Level 4 – Create

Text & Date formulas – Basic 
Working with text – 2
Working with date & time , TEXT function
Find

TRIM
CLEAN
SUBSTITUTE
Text manipulation advanced

Match
Index/Match
Invoice automation 2

Sumifs met multiple criteria & ><=
Index/Match
Sumifs met multiple criteria & ><=
Rank
Ranking report

Top 10
Frequency
Grouping time
Grouping categories
Slicers

Pivot table continued
IFERROR / IFNA
Bad debt report
Advanced pivot table dashboard
Sales Funnel
Goal seek

Go back to overview