Excel Pivot Tables

Excel Pivot Tables are probably the single most powerful feature in Excel, and if you need help creating a Pivot Table, we can help.  (If you are looking for Excel training instead of our Excel consulting, visit our training pages.)

Excel Pivot Tables enable you to analyze and aggregate thousands or tens of thousands of records.  While the basic Pivot Table is pretty easy to set up, there are many advanced features that can be leveraged to automate recurring processes.  Examples are creating Pivot Table reports directly on external data sources, calculated fields, calculated items, and various data extraction techniques.

If you'd like some assistance creating Excel Pivot Tables, or would like to explore ways to have Excel automate your recurring processes, please contact us.  If you are looking to learn more about Pivot Tables, feel free to check out an article we wrote that was published in the Journal of Accountancy called Drilling for Information.

Excel Pivot Tables