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, Excel expert David Carter takes you through a worked example on a small sample database of sales invoices.
In the worked examples you will analyze 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.
Next step - pivot table self-teach tutorials The sample database contains just 27 records and each of these tips should only take you 5 minutes to work through. If you want to learn more about pivot tables, there is a set of full-scale tutorials which show you how to use pivot tables for particular applications (budgeting, sales analysis, cost analysis, etc). These use much larger data sets and will take you an hour or so to work through. See Want to learn about Excel pivot tables? Start here