How to use Pivot Tables to be More Productive in Excel

Welcome to this 5-part mini course presented by Excel Tutes. We recommend that you turn off all notifications and distractions and take notes while watching the videos below. Putting into practice what you learn here will be well worth your time and attention.

1/5 - Creating A Pivot Table

In this video, you'll discover how easy an intuitive it is to analyse huge sets of data using Pivot Tables!

2/5 - Leverage Multiple Fields

To really understand your data, you'll want to view it in a number of ways. In this video we cover the basics of using multiple fields to answer more complex questions about your data.

3/5 - Correctly Formatting Values

Formatting values in your Pivot Tables is slightly different than what you're used to. In this video we learn the correct way to format values in your Pivot Tables.

4/5 - Managing Your Field List

In this video we learn a small but useful skill that a lot of students initially find confusing.

5/5 - Aggregation Methods

This is where Pivot Tables really start to shine. We explore a number of different ways to quickly and easily aggregate your data in this final video.

Want To Learn More

Check out these links to amazing Excel learning resources!

Pivot Table Master Course

The 3 Excel Formulas You Must Know

Badge icon "Erlenmeyer Flask (4519)" provided by Emily van den Heever, from The Noun Project under Creative Commons - Attribution (CC BY 3.0)

Knowing these 3 formulas is your key to saving hours of time!