With the new Daybook worksheet set up via MS Query, David Carter now uses Excel pivot tables to create reports on sales by customer, by area, and by product group.
Continuing his quest to improve to sales reporting at Northwinds Traders, David Carter reviews the data we downloaded last time into Excel and from it defines a "data map" of Northwind.
Northwind Traders run all their sales orders and stock control through an ageing accounts package written in Access.
In the corporate world Excel add-in reporting tools such as XLCubed and Intelligent Apps have been enormously successful.
Seven of David Carter's self-teach tutorials on Excel pivot tables are about budgets.
Continuing his series of tutorials on using pivot tables with budgets, David Carter now produces the monthly reports comparing actual to budget, Month and Year to Date.
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.
“Bank reconciliation? What is a bank reconciliation?”
“What are these cheques that you have in England?”
It’s now time to get serious.
- Want to learn about Excel pivot tables? Start here. By David Carter 113,634 6
- ExcelZone's Five Minute Pivot Table Tips - Index 88,534
- Tutorial:.... Budgeting with Pivot Tables #1 [Excel 5 to 97] 71,436 2
- Tutorial. MS Query and Sage #1 - how to setup Import External Data. By David Carter 49,269 2
- Improve your reporting skills with self-teach tutorials. 36,284