ExcelZone's Five Minute Pivot Table Tips - Index


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...

Please Login or Register to read the full article

The full article is available to registered AccountingWEB.co.uk members only. To read the rest of this article you’ll need to login or register. Registration is FREE and allows you to view all content, ask questions, comment and much more.


Please login or register to join the discussion.

There are currently no replies, be the first to post a reply.