Level 5 – Expand

Working with text (Find)
Index/Match/Match
CaseLinking to .xls
Linking to .ppt
Linking to .word

Sumifs with Index/Match
Advanced report

Hyperlink
Indirect hyperlink
Indirect
Index Sheet

Error checks
Minimizing file size

Scenario
Datatables

Advanced Report Building
Dynamic dropdowns

Waterfall chart tutorial
Setting min/max axis

Consolidating
Budgeting/Forecasting
Vlookup met True

Mix/Price effect
P&L variance driver calculation
ROI/NPV
Gross margin walk

Go back to overview