Analytics

Excel for Analytics — Spreadsheets & Analysis

Analyse data and build reports with spreadsheets — formulas, functions, pivot tables and charts. No coding needed.

29 lessons8 chaptersStart: What is Excel? →

1Excel Basics

What is Excel?20 min Cells, Ranges & References30 min Your First Formulas25 min SUM, AVERAGE, MIN & MAX30 min Making Decisions with IF35 min Counting with COUNT, COUNTIF & SUMIF35 min

2Clean & Look Up

Handy Text & Date Functions35 min Lookups: VLOOKUP & XLOOKUP40 min Sorting & Filtering30 min Finding & Removing Duplicates25 min Conditional Formatting30 min

3Analyse & Visualise

Summarising with Pivot Tables45 min Charts & Graphs35 min A Simple Dashboard40 min Interactive Pivots: Slicers, Grouping & Calculated Fields45 min

4Going Deeper with Formulas

INDEX + MATCH: The Flexible Lookup40 min Multi-Criteria: SUMIFS, COUNTIFS & AVERAGEIFS35 min Dynamic Arrays: FILTER, SORT & UNIQUE40 min

5Professional Workflow

Named Ranges & Mixed References35 min Excel Tables & Structured References35 min Data Validation & Drop-Down Lists30 min Error Handling & Formula Auditing35 min Custom & Conditional Number Formatting35 min

6Advanced Analytics

Power Query: Get & Transform Data45 min What-If Analysis: Goal Seek & Scenarios40 min The Data Model & Intro to DAX50 min Statistics & the Analysis ToolPak45 min

7Automation

Automate Repetitive Work: Macros & VBA45 min

8Project

Project: Analyse a Dataset & Build a One-Page Summary120 min