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
- login or register to post comments
- Add to a social bookmarking site
The Bottom Line:If Mr Cable has his way...
"If Mr Cable had his way, all the big banks would be broken up and bonuses would be virtually eliminated - a sure-fire way in my view of guaranteeing an end to the UK’s ability to compete as an international financial centre. Let’s not forget that this is a man who is on record as saying that everyone who works in a bank has an ‘aristocratic lifestyle’ clearly demonstrating his lack of understanding of the sector." A tough line on bankers’ bonuses could make a brain drain of financial talent a distinct possibility, warns Paul Marsden. Read more