Few skills are more important to master than the ability to create an Excel Pivot Table. If you know how to create an Excel Pivot Table, you can quickly summarize and analyze large datasets. You can also create dynamic tables and charts in order to quickly see different views of your data. Luckily, creating an Excel Pivot Table is pretty simple and can be accomplished in just two steps, allowing even the newest of Excel users to start creating complex data analysis.
Step 1: Select the Data You Want to Pivot
The first step is to simply define the data you want to include in your Excel Pivot Table. So, just highlight the data you want to include in the pivot, as in the example below:
Step 2: Create Your Excel Pivot Table!
Then simply go up into the Insert Tab and select PivotTable, as in the example below:
Just click “Ok” on the next screen, and you should get something that looks like this:
You have successfully created a Pivot Table! Now, you are ready to add fields and filters and begin analyzing your data! What you have created is the skeleton for a basic Pivot Table. Once you have a better understanding of how to arrange fields and filters in the table, you can create advanced (and dynamic) data analysis projects. With further training, you can also learn how to incorporate Pivot Charts into your Pivot Table reports. Pivot Charts and Pivot Tables function similarly and are extremely valuable if you need to model your data graphically. Excel Pivot Tables are extremely powerful data analysis tools if you know how to use them. The best way to start learning more about them is to simply find a reliable resource on the internet and sign up for some training classes.
To get started, start by signing up for our Desktop Secrets Newsletter, where you’ll receive Excel tips and tricks directly in your inbox in addition to exclusive discounts on our upcoming training classes.