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.
An Excel-based vote tabulation program is at the centre of political controversy in the Phillipines, where early results were delayed because of spreadsheet calculation errors.
As part of its commitment to helping members manage the profitability and performance of their organisations, AccountingWEB has published a series of articles covering management reporting issues a
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.
Sometimes you want to print just a part of your worksheet, not all of it.
The slow way is to highlight the area you want to print, then use the Set Print Area option.
Northwind Traders run all their sales orders and stock control through an ageing accounts package written in Access.
The best approach to defining a new business intelligence solution is to let the users have input into what information they need and what format they need it in, writes the VP of research and d
In his series of four tutorials David Carter used pivot tables and Excel to analyse the sales of Northwind Traders, the sample database that comes with Microsoft Access.
In his first article on Excel 2007 article, David Carter concluded that after some initial shocks, this new version wi
- New Range Name features in Excel 2007. By Simon Hurst 414,977 6
- Want to learn about Excel pivot tables? Start here. By David Carter 108,553 6
- ExcelZone's Five Minute Pivot Table Tips - Index 83,845
- Tutorial:.... Budgeting with Pivot Tables #1 [Excel 5 to 97] 69,052 2
- Exporting data from Sage Line 50 into Excel #1. By David Carter 62,131 10