Excel Tip: Consolidate your Spreadsheets Pivot Tables
His latest guide - Consolidating multiple worksheets in a Pivot Table [1] - to this invaluable Excel tool should take only 15 minutes, and shows you how to take a number of worksheets and turn them into one comprehensive spreadsheet.
Carter's new tutorial comes in response to a question from AccountingWEB reader Tom Trainer, who wanted to know if pivot tables could be used to manipulate 3-D spreadsheets - the answer is yes, says Carter, as he shows how to use pivot tables to produce a variety of views of the data.
This top pivot table tip is an adapted version of a tutorial first published by John Lacher, an American CPA.
* New to pivot tables? David Carter's series of award-winning pivot table tutorials on AccountingWEB have become an Internet legend. Visit our overview [2] of Carter's pivot table tips - a must for anyone who regularly uses Microsoft's Excel spreadsheet program.