Learn Excel - Basic to Advanced
by CA Maninder Singh
The only way to learn excel is by Practice Practice and more Practice
To solve this purpose,we have launched Live Classes for Excels where you will be doing different assignments in excel with us and learn new skill every day
This will not be a theoretical class
It will be a practical workshop where we will be sharing different excel data of Companies and make you do different work along with us
If you are stuck, you can ask us out live
Recorded video access will also be provided for your convenience which you can access anytime.
Classes wil be undertaken in Evening after office timings
50% discount in Course Fees. Fees for Course is now at Rs 5000 Rs 2500 and duration is 1 to 2 months depending upon speed
Course @
What will This Training Course Include?
Basic and Advanced Excel
Practical Assignments in Application of Advanced Excel formulas in different situations
• Basic Excel and Excel Shortcuts
• V-lookup and H-lookup
• Pivot tables, Goal Seek and Macros
• If Command, Nested if,
• Count if, Sum if etc.
• Index and Match
• Concatenate and Data Validation formulas
Course @
What will you learn?
Unit 1: Basic Excel
- 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
Unit 2: Excel Shortcuts
- 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
Unit 3: Excel Formatting
- 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
Unit 4: Lookup Functions
- Comparing Data in Excel
- Fetching data in Excel from Database
Unit 5: Conditional Formulas
- 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
Unit 6: Data Validation
- 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
Unit 7: Pivot Tables and charts
- 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
Unit 8: Reverse Calculation in Excel
- Goal Seek
- Scenario Manager
- Data Tables
Unit 9: Macros and VBA
- 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
Unit 10: Bonus
- 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
