The Northwind Trader tutorials. By David Carter
In his series of four tutorials David Carter used pivot tables and Excel to analyse the sales of Northwind Traders, the sample database that comes with Microsoft Access.
If there was one series of tutorials on AccountingWEB that I would like people to work through, it is this one - Northwind Traders.
Most of the other pivot table tutorials are artificial - the data has been specially prepared so that you can use pivot tables on them straight away. In my terminology, the data is "analysis-ready",
But in real life it isn't like that.