Log in Start learning

Module 3

Excel and Google Sheets

The analyst's everyday tool: clean structure, robust formulas, PivotTables and Power Query.

Difficulty:All beginner intermediate advanced expert

Spreadsheet Fundamentals

Data organisation, tables, references and validation.

Structuring data well

✓Spreadsheet foundations — structure, tables, references and validationBuild spreadsheets that stay correct as they grow — tidy layout, Excel Tables, relative vs absolute references, sorting, filtering and data validation.Beginner45 min

Formulas for Analysis

Conditional logic, conditional aggregation and lookups.

Logical and conditional functions

✓Conditional functions and lookups — IF, SUMIFS, COUNTIFS, XLOOKUP and INDEX/MATCHThe formulas analysts use every day to classify, summarise by condition, combine tables and clean dates and text.Beginner60 min

Analysis and Reporting

PivotTables, cleaning, reconciliation and variance.

PivotTables and PivotCharts

✓PivotTables, cleaning, reconciliation and variance analysisSummarise data interactively, clean it systematically, reconcile two sources and present plan-vs-actual variance correctly.Intermediate60 min

Power Query and Collaboration

Repeatable data preparation and shared workbooks.

Power Query

✓Power Query and Google Sheets collaborationReplace manual copy-paste with repeatable data preparation in Power Query, and collaborate safely in Google Sheets.Intermediate50 min