Getting started with PivotTables
In this exercise, you will create your first PivotTable to help you explore the data.
To follow along with all exercises on your local computer, you can find all the course material here.
PivotTables are a great way to start exploratory data analysis. They can easily summarize and manipulate data, which makes them a powerful tool. It's also important to make sure everything we do is concise and accurate, so we'll use best practices in naming our fields and formatting the data correctly.
Let's create a PivotTable of Bananas Sales.xlsx
to get a better understanding of the data as a whole.
This exercise is part of the course
Data Analysis in Excel
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
