Did you know that Excel can automatically generate Pivot Tables for you? You heard that right, there are Recommended Pivot Tables in Excel that you can actually use!

This is a new feature introduced in Excel 2013.

It is very simple to do so and we will show you how!

DOWNLOAD EXCEL WORKBOOK

STEP 1: Make sure you have selected your data. Go to Insert > Tables > Recommended Pivot Tables

Recommended Pivot Table in Excel

 

STEP 2: You will see the generated Pivot Table recommendations.

Let us select the Count of SALES by PRODUCTS. Click OK.

Recommended Pivot Table in Excel

 

STEP 3: The generated Pivot Table is now in a new sheet. Let us make some changes to it.

Click on COUNT of SALES and select Value Field Settings.

Recommended Pivot Table in Excel

We want it to display the Total sum of Sales per Product instead. Select Sum and click OK.

Recommended Pivot Table in Excel

With just that, your Pivot Table is now ready!

Recommended Pivot Table in Excel

 

How to Use Recommended Pivot Tables in Excel

Helpful Resource:

Excel Pivot Table

 

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Related Excel Tutorials