Tutorial 3: Create sales reports with pivot tables
In this third Northwind tutorial, David Carter uses Excel pivot tables with the new worksheet Daybook to create detailed customer reports.
Excel pivot tables can be now used with the new Daybook worksheet set up via MS Query. These will create reports on sales by customer, by area, and by product group and when the administrative staff enter new sales orders onto the company's Access system, the sales reports in Excel will be automatically updated.
To read the rest of the article you'll need to log in below
If you've forgotten your details click here for a reminder.
If you haven't got an account, it's free and it only takes a minute to set one up,
click here to register