Class 1

Class 2

Class 3 – How to write a formula, Cell References, If and Nested If

Class 4 – Practice of IF & SumIf

Class 5 – Pivot Tables (Basic to Advanced with Slicers and Timelines)

Class 6 – Filter, Advanced Filter, Auto Filter & Removing duplicates

Copy paste tricks

Basic Excel Shortcuts – Excel File

Class 7 – Text to column, flash fill and Date functions

Class 8 – Match and Vlookup

Class 9 – Index Match & Find and Replace

Assessment (Part 1) – Nested If for City Names

Assessment (Part 2) – SumIf for Sales

Class 10 – Left, Right & Middle (Simple to Complex)

Class 11 – Middle (Last case), Randbetween, Custom Formatting

Class 12 – Part 1 (Fill in series & Index Match Example)

Class 12 – Part 2 (Index Match Example)

Class 13 – Consolidate, Grouping, Subtotal & Offset

Class 14 – Infinite index match

Class 15 – Conditional formatting, SumIf with Not, Precedent, Quick Analysis, Charts and Graphs

Final Assessment

How to register and access course