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.
David Carter's series of Five Minute Tips aims to develop your skill at using Excel pivot tables.
For anyone who is serious about analysing data and creating pivot table reports, knowing how to use Excel's VLOOKUP function is a must. David Carter explains how.
In his previous articles David Carter showed how to export data out
In two previous articles in this series, David Carter showed how to analyse sales into different product groups, and then how to calculate gross margins.
I have reporting information coming from 3 different regions , in 3 different formats in Excel spreadsheets and I want all of this information to appear in a template P&L in excel.