Course Content
1. Excel Fundamentals (2 hours)
0/3
Excel interface and navigation
Data entry, formatting, and best practices
Basic formulas and functions
2. Advanced Formulas and Functions (4 hours)
0/4
Logical functions: IF, AND, OR
Lookup functions: VLOOKUP, HLOOKUP, XLOOKUP, INDEX/MATCH
Date and text functions
Error handling and dynamic named ranges
3. Data Tools and Validation (2.5 hours)
0/3
Data validation and drop-down lists
Removing duplicates, Flash Fill
Text to columns, consolidate, What-If analysis
4. Charts and Data Visualization (2 hours)
0/3
Creating dynamic charts
Conditional formatting for insights
Sparklines and formatting best practices
5. PivotTables and PivotCharts (3 hours)
0/3
Building PivotTables from scratch
Grouping, filtering, and calculated fields
Slicers and timeline tools
6. Financial Modeling Essentials (4 hours)
0/4
Best practices for model structure
Dynamic assumptions and inputs
Building a simple 3-statement model
Scenario and sensitivity analysis
7. Excel Automation (2.5 hours)
0/3
Introduction to Macros and VBA
Recording and modifying simple macros
Automating repetitive tasks
Microsoft Excel for Finance & Business
Previous
Next