Written by David Carter and Simon Hurst, ExcelZone's series of Five Minute tips aims to develop your skills at using Excel pivot tables.
Reader Ray Yaukip has been experimenting with pivot tables to summarise stock movements in and out. They give him most of what he wants but has come up against a problem.
Reader Ray Yaukip needed a pivot table that gave the total of stock movements or of stock value between two dates.
I have several pivot tables linked to my data in the same spreadsheet.
The Multiple Consolidation Ranges feature allows you to pile a lot of similar worksheets on top of each other and summarise the results in a pivot table.
For anyone who is serious about analysing data and creating pivot table reports, knowing how to use Excel's VLOOKUP function is a must. David Carter explains how.
This tutorial is in response to a question posed by reader Mr Tom Trainer, who asked on 1st August: "Can pivot tables be used to manipulate 3-D spreadsheets, (i.e.
All accountants use spreadsheets for financial modelling and 'What if?' analysis.
- Want to learn about Excel pivot tables? Start here. By David Carter 108,538 6
- ExcelZone's Five Minute Pivot Table Tips - Index 83,819
- Tutorial: Consolidating multiple worksheets in a Pivot Table 54,533 1
- The ExcelZone Compendium Archive 1999-2007 45,493 3
- Tutorial: ...Analyse Sales and Margins with pivot tables [Excel 5, 95 & 97] 42,516 1