Learn Excel - Basic to Advanced - Join Evening Live Classes

• How to Create, Save, Duplicate new Excel Sheets and Workbooks
• How to use Simple Excel Formulas
• Using Drag and Drop in Excel to save time
• How to Create Folders and Download Excel files zip and mail them
• How to Download and Save Excel files into Folders

• Using Flash Fill to combine, segregate and customize data
• Data Entry Shortcuts - to use Paste Special, to transpose data from rows to columns and vice versa
• Inserting and Deleting Shortcuts to select Rows, Columns, Tables and Sheets
• Selection Shortcuts to use Excel without using the mouse
• Calculation Shortcuts to fasten calculation in Excel

• Basic Formatting in Excel for Proper Presentation
• Formatting as a table
• Autofit Rows and Columns
• Wrap Text and Freeze Panes
• Inserting and Removing Blank Rows
• Proper, Lower and Upper Command to make data look pretty
• Making Proper Print Layout for Printing Data from Excel

We will learn how to use functions like Vlookup, Hlookup, Xlookup, Index and Match

These commands are required for

• Comparing Data in Excel
• Compiling Data in Excel
• Fetching data in Excel from Database

We will learn different cases like Exact Mach, Apprximate Match, Match by using Wild Card Characters

In this case,we will learn how to get value from a data in case of different conditions

We will cover formulas like

• If Command → To Calculate Value in case of 1 Condition
• Nested If → To Calculate Values in case of Multiple conditions
• Countif Countifs → Counting in case of conditions
• Sumif and Sumifs → Calculating Totals in case of conditions
• Use of Filters and Subtotal → Alternative of Countif and Countifs
• And Condition → When both conditions will be true
• Or Condition → When one of two conditions will be true

Here, we will learn how to make form in excel where certain values will be selected.

On data entry,it will show input message

If some wrong value entered,it will show error message

Example

• Restricting Text length
• Only Values between 1 to 50
• Allow only Dates in a cell
• Allow decimals upto 2 places
• Select from a dropdown list

Here, we will learn how to use Pivot table features in excel to to calculate, summarize and analyse data in following situations

• Changing Rows into Columns and Vice Versa
• Have a summary of a value appearing repeatedly
• Comparing 2 Data having multiple repeated values
• Making Graphical Presentation of Data using Pivot charts
• Expanding and Collapsing levels of Data
• Preparing Concise Reports as required by management

Sometimes ,we are have to do back calculation

like we used to calculate value of x in School

Here, we use Advanced Excel Tools like

• Goal Seek
• Scenario Manager
• Data Tables

Sometimes,we have to do repeated tsks and doing them again and again becomes boring and time consuming

So we can take help of >Macros and VBA to automate/repeat a task

We will learn

• SHow to Record/Create/View a Macro
• How to Create simple Shortcuts/Buttons to automate a task
• How to Make User Forms to Fill Database Automatically
• Practical Examples of How to Use Macros in Real life Situations
• How to Work in Visual Basic Editor
• Understand Difference between macros and VBA

We will be sharing assignments on

• Real life Excel Usage in different situations
• Applying Multiple Excel Formulas in one sheet
• Mixed Assignments where you have to think which formula to apply where
• Interview Sheets and Excel Test as asked in Various Job interviews
• Changing Rows into Columns and Vice Versa

Also if you are stuck in any real excel work of your company and need support and guidance, you can mail data with us

Our trainers will help you apply different formulas to make work easier