management reports
Tutorial 4: Add cost prices and margins
In this fourth and last Northwind tutorial, David Cartershows how to insert the missing product cost prices and produce a margin percentage report.
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.
Tutorial 2: Creating the Daybook
In the second tutorial, David Carter, shows how to create a single daybook for management reports. It uses the Northwind's data map from the last article improving sales reporting in Excel.
Tutorial 1: How to data map and boost sales and forecasting with Excel
In the first tutorial David Carter shows how to download the Northwind database and make a data map. It is the first step in improving sales reports and forecasts between Access and Excel.
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