Module B – Formulas, Functions & Core Skills

• Understanding formulas and cell references
• Basic calculations (SUM, AVERAGE, MIN, MAX)
• Using AutoFill and relative vs absolute references
• Working with simple IF statements
• Sorting and filtering data effectively
• Creating a basic chart to visualise information

Outcome: Build spreadsheets that calculate automatically and analyse data with confidence.

Learning Path

New to Excel? Start with Module A first.