tutorials

What range names are and why they are useful

6

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.

1

Written by David Carter and Simon Hurst, ExcelZone's series of Five Minute tips aims to develop your skills at using Excel pivot tables.

Pages