-
Welcome
-
Lesson 1 - Freeze Panes
-
Lesson 2 - Removing Duplicates
-
Lesson 3 - Match
-
Lesson 4 - Logical Functions
-
Lesson 5 - Count
-
Lesson 6 - Lookups
-
Lesson 7 - Tables
-
Lesson 8 - Slicers
-
Lesson 9 - Sparklines
-
Lesson 10 - SheetVeryHidden
-
Lesson 11 - Pivot tables
-
Lesson 12 - Macro's
-
Tip 1 - Join the content of two or more cells
-
Tip 2 - IFERROR function
-
Tip 3 - Enable data entry only when the previous cell is filled
-
Tip 4 - Random numbers
-
Tip 5 - Conditional validation or dependent drop down list
-
Tip 6 - Flash fill
-
Tip 7 - Most frequently occurring value
-
Assessment
-
Participant Feedback
-
My Certificate