Lesson · Excel for accountants
PivotTables: sales by customer and month
Summarise Baobab's sales by customer and month.
11 minutes Standard as at 2 November 2026
What you will be able to do
- Summarise Baobab's sales by customer and month
- Refresh a PivotTable when new data arrives
This is a preview of a member lesson. The full lesson is in the Excel for accountants library, open to everyone who enrols.
Free · one email a week
IFRS and SAM, one requirement at a time
Each week you get the Institute's new articles: one requirement of IFRS 17, IFRS 9, IFRS 15, IFRS 18 or SAM, worked on a South African case. You start with the free IFRS 18 readiness checklist, ten areas to work through before IFRS 18 takes effect, each with its paragraph reference.