Live Excel Training

Pankaj Kumawat

profile
Live Excel Training
profile
5,79912,300
60 mins

How 1:1 Live Training on Excel is more beneficial than buying a course?


In this live training, we will start from the very basics of excel & move towards advanced excel.


Benefits from this :

  • It will be at your convienient time.
  • Only you will be the participant in this training with me.
  • All doubts will be solved in a live session.
  • You will get assignments after every session.
  • We will go through the assignment & It's solution in the first 10 mins of the next session.
  • 1- Month free consultation & support for any Excel problem.


We can discuss this in more detail in 15 mins call which can help to build trust & to know the process of training.


Excel Basic to Advanced Topics:

  1. Excel Introduction And Use
  2. Navigation and Basic Formulas
  3. Formatting and Cell Styles
  4. Sorting and Filtering Data
  5. Pivot Tables and Charts
  6. Conditional Formatting
  7. Data Validation
  8. VLOOKUP and HLOOKUP
  9. IF and Nested IF Statements
  10. SUMIF and COUNTIF
  11. Macros and VBA Programming
  12. Advanced Charting and Graphs
  13. Working with External Data Sources
  14. Data Consolidation and Grouping
  15. Advanced Formulas and Functions (e.g. INDEX, MATCH, OFFSET)
  16. Advanced Pivot Tables and Dashboards
  17. Error Handling and Debugging
  18. Collaboration and Sharing
  19. Customizing Excel Settings and Options
  20. Importing and Exporting Data
  21. Advanced Printing and Page Layout.
  22. How to get Jobs After learning Excel & salary.


Course Duration : One Month

Live Training : 1 Hour Per Day

Practice Project File and Real Business Case Study