Tutorial: Budgeting with Pivot Tables #1 [Excel 2000 & 2003]
This article updates IT Zone consultant editor David Carter's hugely popular 1999 pivot table tutorial, which applies Excel's powerful multidimensional analysis tool to a common business activity - the annual budget.
Introduction
For the management accountant, Excel pivot tables represent the most important development in IT since the original invention of the spreadsheet.
If you are regularly required to analyse data, or to prepare and present management reports, they are an indispensable tool.
Continued...
The full article is available to registered AccountingWEB members only. To read the rest of this article you’ll need to login or register.
Registration is FREE and allows you to view all content, ask questions, comment and much more.
Or if you are already registered, login here
It´s ok, but...
I have made many budgets with Excel. The problem with pivot tables approach is that it can not handel complex number relations.
For example: how can I budget advertising expenses as 3% of sales for january to june and then 1% of sales till december ?
As you can see, pivot tables are best tool to group data, but not to make more interconexted budgets (it is very common to make budgets as % of sales)...
Keep in mind that !
Very Helpful
I have found this to be very easy to follow and to help me understand what Pivot Tables are all about and I am using 2007 as well so some of the menu options were slightly different to mentioned. Thank you
Tutorial: Budgeting with Pivot Tables (Excel 2000/2003)
A powerful and timesaving way of preparing budgets.
Many thanks to the whole Team for this presentation.
Romano