Excel Data & Reporting
Tables, filters, pivot tables, slicers, and Power Query — how to turn a raw export into a report you can refresh instead of rebuild.
What this covers
Pivot tables and how to optimise them, slicers and timelines, Excel Tables, advanced filtering, conditional formatting, and Power Query — including how to keep manual columns when a query refreshes.
Published guides
- How to use slicers in Excel to filter several pivot tables at onceA slicer is the difference between a report someone reads and a report someone uses. Here is how to add one, and how to wire a single slicer to every pivot table on the sheet.
- How to use Excel, from a blank sheet to your first real reportExcel is easy to start and easy to build wrong. This is the path from a blank sheet to a report that updates itself, in the order that stops you having to redo it later.
Prefer an instructor? These topics come out of our Office 365 courses. For a team, corporate training is scoped to your own files and systems.