Written by David Carter and Simon Hurst, ExcelZone's series of Five Minute tips aims to develop your skills at using Excel pivot tables. If you want to try out each tip for yourself, David takes you through a worked example on a small sample database of sales invoices.
In the worked examples you will analyse the invoices to show sales by product, sales by customer, gross margins, margin percentage etc. The series is therefore relevant to sales and marketing people as well as accountants.
You don't have to work through the series in any particular order. But if you have never used pivot tables before, please do tips 1-3 first as they will get you started.
Tip 1 - First step: remove those subtotals quickly
Tip 2 - How to Group totals by month
Tip 3 - Create...