Course Content
Formulas
Data Formatting
Conditional Formatting Part 1
Conditional Formatting Part 2
Conditional Formatting Part 3
Conditional Formatting Part 4
Conditional Formatting Part 5
Sort and Filter
Error Handling
Bar Chart
Line Chart
Pie Chart
Combo Chart
Text to Column
Cell Referencing
Table to Range
IF and NESTED IF
IF with Other Functions
Error Functions
VLOOKUP
INDEX and MATCH
Debugging
Name Manager and INDIRECT
SUMPRODUCT
Date and Time Functions
Text Functions Part 1
Text Functions Part 2
Logical Functions
Bullet Chart
Bubble Chart
Waterfall Chart
Thermometer Chart
Normalization of Indices
PV, FV and CAGR
PMT and Loan Amortization
Depreciation
NPV, IRR and XIRR
Forecast
Descriptive Statistics
Rank and Percentile
Smoothening and Cyclicality
ANOVA
Histogram and Moving Average
Regression
Pivot Tables
Pivot Charts
Pivot Slicers
Goal Seek
Solver
Data Table
Dashboard Part 1
Dashboard Part 2
Dashboard Part 3
Financial Statement Linkages
Application Modelling Part 1
Application Modelling Part 2
Application Part 1
Application Part 2
Application Part 3
Application Part 4
Application Part 5
Application Part 6
Part 1
Part 2
Part 3
Part 4
Part 5
Part 6
Part 7
Part 1
Part 2
Part 3