Tutorial: Analyse Sales and Margins with pivot tables [Excel 2000 & 2003]

This article updates IT Zone consultant editor David Carter's hugely popular pivot table tutorial, which applies Excel's powerful multidimensional analysis tool to one of the most common business reporting activities - sales analysis.

In this tutorial you will learn how to use pivot tables to analyse your company's sales. You will also use Excel's 'Import Wizard' to load into Excel a data file that was exported from a third party accounts package.

Continued...