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

Recommended Pivot Tables in Excel | MyExcelOnline Recommended Pivot Tables in Excel | MyExcelOnline

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!

Recommended Pivot Tables in Excel

 

How to Use Recommended Pivot Tables in Excel

 

If you like this Excel tip, please share it
Recommended Pivot Tables in Excel | MyExcelOnline Recommended Pivot Tables in Excel | MyExcelOnline
Recommended Pivot Tables in Excel | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  Rank Largest to Smallest With Excel Pivot Tables

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!

Share to...