Most pivot table tutorials use a sales dataset: regions, products, units sold. That is fine for learning the buttons and useless for learning what a pivot table can do in an accounting file. Accountants work with general ledger detail, open invoices, vendor payments, bank exports and payroll registers, and the questions they ask of that data are specific: does it tie, what changed, what is old, who crossed a threshold.
This post works through six pivot table examples drawn from that ...