In the first part of our video tutorial, we looked at the basics of what PivotTables are, how they work, and how to create them.

In this second part, we’re going to take a look at some ways in which you can extend your PivotTables, to include:

  • Grouping dates, so that they can be summarised by month and year, for example
  • Adding more than one value field to display different calculations
  • Creating drill-down effects to display your data in a more compact form
  • Adding formatting to display your data effectively

Can we help you further?

We hope that this video guide (and its prequel – part 1) will help you in your quest to understand PivotTables. But if you have questions, please do fill in a comment below. Or, contact us – either via the contact form on this site, or on 01483 277172. We run custom training courses for clients large and small, and we’d be delighted to help you and your colleagues to get more from Excel – just let us know what we can do for you.