Basic to Advanced Level Excellent
Excel Advanced
Formula Based Approach 2025 to 2026
Financial Modeling with Formulas & Functions
BRIEF CONTENTS
1. Introduction to MS Excel & Key Features
2. Excel Superb Formulas
3. VBA Macros
4. Conditional Formatting
5. Filter
6. Sorting
7. Pivot Table
8. Data Analyzing with Charts & Visualization
9. Logical Function
10. Lookup Functions
11. Text Functions
12. Information & IS Functions
13. Date & Time Functions
14. Statistical Functions
15. Financial Functions & Modeling
16. Very Essential
17. Array Formulas
18. Introduction to Power BI
19. TESTS
20. Keyboard Shortcuts & Interview Questions/Answers