Pinterest Pixel

Recommended Pivot Tables in Excel

Did you know that Excel can automatically generate Pivot Tables for you? You heard that right, there... read more

Download Excel Workbook
Bryan
Posted on

Overview

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!

Recommended Pivot Tables in Excel | MyExcelOnline

Download excel workbookRecommended-Pivot-Tables.xlsx

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

Recommended Pivot Tables 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 Tables 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 Tables in Excel

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

Recommended Pivot Tables in Excel

With just that, your Pivot Table is now ready!

See also  Filter by Text wildcards

Recommended Pivot Tables in Excel

 

How to Use Recommended Pivot Tables in Excel

 

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

Recommended Pivot Tables in Excel | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!