← All courses
🧮Intermediate
Excel Intermediate
Level up from basic sheets to real spreadsheet skill — smart references, the functions that do the work, lookups, clean data tools, and pivot tables that summarise anything.
4 modules · 19 lessons · 19 lessons
Share
₦2,50050% OFF
₦5,000 save ₦2,500
Offer ends in …
What you'll learn
- Formulas & references
- Key functions
- Lookups
- Pivot tables
Curriculum
5 modules · 19 lessonsModule 1Formula foundations4 lessons
Absolute vs relative referencesPreviewNamed ranges
IF, nested IF and IFS
Logical functions: AND, OR, NOT
Module 2Functions that do the work4 lessons
SUMIFS, COUNTIFS, AVERAGEIFS
Text functions
Date and time functions
Rounding and math helpers
Module 3Lookups4 lessons
VLOOKUP
INDEX/MATCH
XLOOKUP (the modern way)
Handling errors with IFERROR
Module 4Clean, validate, summarise3 lessons
Sorting, filtering and tables
Conditional formatting
Data validation (dropdowns)
Module 5Pivot tables & charts4 lessons
Your first pivot table
Grouping, filtering and slicers
Charts that communicate
Where to go next
Reviews
No reviews yet.
