Download Excel Workbook
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!
STEP 1: Make sure you have selected your data. Go to Insert > Tables > Recommended Pivot Tables
STEP 2: You will see the generated Pivot Table recommendations.
Let us select the Count of SALES by PRODUCTS. Click OK.
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.
We want it to display the Total sum of Sales per Product instead. Select Sum and click OK.
With just that, your Pivot Table is now ready!
How to Use Recommended Pivot Tables in Excel
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.
