Excel Pivot Tables for Accountants

Overview

Filtering, sorting, drilling-down data in the reports without writing one formula or macro

One of the most powerful features of Excel is a Pivot Table but very few accountants use it on their day-to-day tasks. Pivot Tables are viewed by some as complicated and intimidating while to majority of accountants, it is a foreign and unknown concept. Pivot Table, in simplest definition, refers to data summarization tool that can automatically sort, count total or average of data stored in one table or spreadsheet.