51
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
M0.L5 Final Outcomes
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 # 1: 15 Oct 2025
M3.L1 Absolute & Relative Cell References
M3.L2 Basic Math Operators: Sum, +, -, /, *
M3.L3 Basic Statistical Formulas
M3.L4 Use IF Statements
M3.L5 Create Percentages
M3.L6 Summarise Using COUNT
Assignment #2
M3.L1 Sorting & 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 # 1: 22 Oct 2025
M4.L1 Import/Open a large dataset in Excel
M4.L2 Create Summary Tables for Visualising
M4.L3 Pie Charts
M4.L4 Bar Charts
M4.L5 Line Charts
Assignment #3
M5.L1 Data Validation
M5.L2 Create Summary Tables for Visualising
M5.L3 Protecting You Workbook
M5.L4 VLOOKUP
M5.L5 Intro to Pivot Table
Assignment #4
Coaching Call # 1: 29 Oct 2025
M6.L1 Combine (2 or more) Datasets
M6.L2 Summarise with Pivot Table
M6.L3 Calculate with Formulas
M6.L4 Visualise with Charts
M6.L5 Layout a Basic Report
Assignment #5
M7.L1 The Maple Syrup Principle: S.A.P.
M7.L2 Tables, tabs and links
M7.L3 Templates
M7.L4 You're Done! Next Steps...
M7.L5 Final Feedback Survey
