Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise