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