Curriculum
- 12 Sections
- 14 Lessons
- 15 Weeks
Expand all sectionsCollapse all sections
- Gripping the basics1
- How to access portal1
- Conditional Calculations (And, Or, If, If And, If Or, Count if, Sumif, Sumifs)2
- Sumifs practice, Date functions, Filters1
- Duplicates, Auto Filter, Group, Subtotal, Name Manager, Drop down, Conditional Formatting, Copy Paste Special1
- Flash Fill, Text to Column, Concatenate, Left, Right, Fill in (Series), Match, Vlookup1
- Index Match1
- Pivot Tables2
- Sum if not, Goal seek, Data Tables, Solver1
- Offset1
- Excel charts and graphs1
- Final assessment1