Why would I use a PivotTable?

...as someone so nearly said

Over at the Excel Community, the latest article in our Accountants' Guide to Excel series looks at the 'Why?' of using PivotTables. Loved and hated with equal ferocity, PivotTables have been called Excel's equivalent of Marmite (other yeast-based spreads are available). The series will go on to see how PivotTables can take you as far as an interactive dashboard but starts with the simple quesion of why you might want to use a PivotTable at all:

Accountants' Guide to Excel – Why it's OK not to use PivotTables

In an attempt to demonstrate the underlying basics of PivotTables we use a practical example to create a monthly summary of 1,000 bank transactions using 5 mouse clicks:

  • Click on any cell in the Table
  • Choose PivotTable from the Insert Ribbon tab, Tables group
  • Click OK
  • Click Date
  • Click Amount

This blog is brought to you by the Excel Community where you can find additional blogs, extended articles and webinar recordings on a variety of Excel related topics. In addition to live training events, Excel Community members have access to a full suite of online training modules from Excel with Business. There is also an online forum where you can ask questions and share ideas with other community members.