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.
In this video, you'll discover how easy an intuitive it is to analyse huge sets of data using Pivot Tables!
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.
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.
In this video we learn a small but useful skill that a lot of students initially find confusing.
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.