Excel & Spreadsheets
Formulas, tables, PivotTables and Power Query: the everyday tools of analysis, before and alongside code.
Beginner
Start here. No background needed beyond school maths.
Excel Easy
Clear step-by-step tutorials with screenshots for every common •••• task, from formulas and functions to charts, data analysis and a first macro.
Sign up to see the source
Excel Functions by Category
The official list of every Excel function grouped by what it does (lookup, text, date, statistical, logical), each linking to a syntax page and examples.
Sign up to see the source
Excel Help and Learning
••••'s own training hub for Excel: short lessons on entering data, formulas, tables, charts and PivotTables, from the first workbook onwards.
Sign up to see the source
Excel Skills for Business (Macquarie University)
A four-course specialisation that takes you from the basics to advanced formulas, data tools, dashboards and macros. Free to audit.
Sign up to see the source
Exceljet: Formulas and Functions
Short, example-led pages for hundreds of functions (XLOOKUP, SUMIFS, FILTER and more), plus guides and shortcuts for working faster.
Sign up to see the source