Clean and organise data
Use Excel tables, sorting, filters, formatting and cleanup tools to turn a raw extract into a usable worksheet.
Weekend morning classes
Learn Microsoft Excel 365 in small weekend classes. Clean business data, use formulas and lookups, and build reports with PivotTables and charts.
Use Excel tables, sorting, filters, formatting and cleanup tools to turn a raw extract into a usable worksheet.
Build totals and checks with SUMIFS and IF. Match records with XLOOKUP and handle missing values.
Summarise data with PivotTables and charts, and build reusable lists with FILTER, UNIQUE and dynamic arrays.