Excel Tip: Consolidate your Spreadsheets Pivot Tables | AccountingWEB

Excel Tip: Consolidate your Spreadsheets Pivot Tables

Manipulating multiple worksheets is made easy with our latest pivot table tutorial from pivot king David Carter.

His latest guide - Consolidating multiple worksheets in a Pivot Table - 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 of Carter's pivot table tips - a must for anyone who regularly uses Microsoft's Excel spreadsheet program.

View more helpful tips!

Wait, there's more!
There's always more at AccountingWEB. We're an active community of financial professionals and journalists who strive to bring you valuable content every day. If you'd like, let us know your interests and we'll send you a few articles every week either in taxation, practice excellence, or just our most popular stories from that week. It's free to sign up and to be a part of our community.
Premium content is currently locked

Editor's Choice

WHAT KIND OF FIRM ARE YOU?
As part of our continued effort to provide valuable resources and insight to our subscribers, we're conducting this brief survey to learn more about your personal experiences in the accounting profession. We will be giving away five $50 Amazon gift cards, and a $250 Amazon gift card to one lucky participant.
This is strictly for internal use and data will not be sold
or shared with any third parties.