58
Coaching Call # 1: 8 Oct 2025
M0.L1 Introduction to the course
M0.L2 Where does data come from?
M0.L3 'I'm not a Numbers Person'
M0.L4 Download Course Resources
M1.L1 A Tour of Excel
M1.L2 Entering Data
M1.L3 Formatting Data
M1.L4 Formatting a Table
M1.L5 Dataset Layout vs Summarised Table Layout
Assignment #1
Coaching Call #2: 15 Oct 2025
Cell References (part 1)
Cell References (part 2)
Cell References (part 3)
Basic Math Operators: Sum, +, -, /, * (Part 1)
Basic Math Operators: Sum, +, -, /, * (Part 2)
Basic Math Operators: Sum, +, -, /, * (Part 3)
Basic Statistical Formulas
Conditional Formulas (IF)
Conditional Formulas (Aggregate)
Dot Notation
Dot Notation (BYCOL)
Assignment #2
M3.L1 Sorting and Filtering Data
M3.L2 Freezing Rows & Columns
M3.L3 Paste Special & Format Painter
M3.L4 Conditional Formatting
M3.L5 Page Layouts & Printing
Assignment #3
Coaching Call # 3: 22 Oct 2025
M4.L1 Visualisation Tips
M4.L2 Bar & Column Charts with 2 Series
M4.L3 Telling a Story
M4.L4 Bar & Column Charts with 2 Series
M4.L5 Line Charts with 2 Series
M4.L6 Circle Charts
M4.L7 Combo Charts
Assignment #3
M5.L1 Data Validation
M5.L2 Create Summary Tables for Visualising
M5.L3 Protect Your Workbook
M5.L4 VLookup and XLookup
M5.L5 Intro to Pivot Tables
Assignment #4
Coaching Call # 4: 29 Oct 2025
M6.L1 Overview
M6.L2 Intro to your Capstone Project
M6.L3 Principles
M6.L4 Tables Tabs and Links
M6.L5 Explore, Summarise and Analyse your Data
M6.L6 Presenting & reporting your data
Assignment #5
M7.L1 Bringing it all together
M7.L2 Templates
M7.L3 You're Done! Next Steps....
Excel Essentials Capstone Project
Coaching Call # 5: 4 Oct 2025
