Budgeting with Pivot Tools Tutorial – AccountingWEB

The U.K.-based AccountingWEB site has provided this detailed tutorial, from software consultant David Carter, to assist in converting raw accounting data into an interactive budget management workbook using Excel's pivot table function. "For the management accountant," says Carter, "Excel pivot tables represent the most important development in IT since the original invention of the spreadsheet." He provides a downloadable set of raw data and a step-by-step guide that walks the user through basic processes of design and manipulation. The tutorial also includes links to a second tutorial on sales analysis and other guides and related information.