Microsoft Excel Pivot Tables
A Business Software Tip by J. Carlton Collins, CPA
Accountants have long known the value of PivotTables. But they’re a great data analysis tool for management, too. PivotTables allow you to create multidimensional data views by dragging and dropping column headings to move data around. J. Carlton Collins, CPA, president of ASA Research, LLC, is an accounting systems and spreadsheet expert. In this article, he’ll walk you through both the basic and complex issues involved.
PivotTable Primer
To rearrange the worksheet, simply drag and drop column headings to a new location on the worksheet, and Microsoft Excel crunches the data accordingly. The diagram below depicts a typical PivotTable and highlights its moveable elements.
Leave a Comment
If you would like to make a comment, please fill out the form below.
You must be logged in to post a comment.
