All programs
Digital SkillsProductivityMEIL1 100% HRDF claimable
Microsoft Excel Intermediate – Level I
Designed for users who already have fundamental Excel skills and are ready to advance into more powerful functions and formula-based analysis. Work with cell references, named ranges, logical and lookup functions, and date/time formulas to build dynamic spreadsheets.
1 DayPEOPLElogy
What you'll learn
- Identify the components and structure of Excel functions and formulas
- Differentiate between cell reference types and apply them appropriately
- Construct formulas using aggregation, logical, date/time, and lookup functions
- Create and use named ranges to simplify formula accuracy
- Evaluate when to use approximate vs exact match lookups
Course modules (7)
01Fundamentals of functions and formulas
02Aggregation functions (SUM, AVERAGE, COUNT, MAX, MIN)
03Cell reference types (relative, absolute, mixed)
04Named ranges
05Logical functions (IF, nested IF)
06Date and time functions
07Lookup functions (VLOOKUP, HLOOKUP)