My focus is to keep it extremely simple as it makes more sense. Provide hands-on expertise to real corporate world examples. I have various types of course structures for different people depending on their grasping speed. My style of teaching is based on practical questions as excel is something we can learn from books until we practice them.
Become a master of excel which is a necessity in the corporate world.
Topics Covered (short brief):-
1. Introduction to Excel
2. Mathematical Functions - Countifs, Sumifs, Sumproduct, Averageifs, round, COS, Subtotal, etc.
3. Text Functions and Data Validation- Conditional Formatting, Substitute, Concatenate, Filters, etc
4. Logical Functions - IF, AND, OR, Nested IF, etc
5. Lookup and Reference Functions - Index, Vlook - up, Hlook - up, Match, Offset, XLookup, Indirect, etc
6. Pivot- MIS, Data Analytics & Dashboards, Graphs, etc
7. Macros - Buttons, Strings, Recording, FORM Controls, ActiveX,
8. Loop in , WhatIF - Analysis, Creating Forms through VBA
9. Automating work with help of MACROS
Thank you