Articles on all things data...

Microsoft Excel Pivot Tables – video guide part 2

 January 24

by Andrew Richards

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

Click to play

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 020 3397 1333. 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.

share this

Related Posts

Using RAG statuses with dates in Microsoft Excel

There is a bug in Excel…

GDPR training video – the Principles

Sign up now to be the first to hear about new articles!