What range names are and why they are useful
Seven of David Carter's self-teach tutorials on Excel pivot tables are about budgets.
When reporting actuals against budget, you often find that your budget categories don’t match the nominal codes in the accounts package.
Data held in row and column format like budgets is difficult to analyse in a pivot table.
We already have an Excel Zone Compendium for Data Entry Basics.
David Carter's first Budgeting tutorial showed you how t
Written by David Carter and Simon Hurst, ExcelZone's series of Five Minute tips aims to develop your skills at using Excel pivot tables.