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.


