Create a Pivot Table in Excel 2013

Create a Pivot Table in Excel 2013

There is a new feature in Excel 2013, that makes it even easier to get started with pivot tables.

Just select a cell in your source data table, and on the Ribbon’s Insert tab, click Recommended PivotTables.

click Recommended PivotTables
click Recommended PivotTables

A window opens, and you can see a list of suggested pivot table layouts, based on your data.

list of suggested pivot table layouts
list of suggested pivot table layouts

Click on any layout, to see a larger view of it, and when you select one that you want to use, click the OK button.

Your pivot table is created on a new worksheet, and you can leave it as is, or make changes to it.

pivot table is created on a new worksheet
pivot table is created on a new worksheet

Watch the Video

To see the steps for creating a pivot table in Excel 2013, please watch this short video tutorial.

Download the Sample File

To download the sample file for this video, please visit my Contextures website: Create a Pivot Table

__________________

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.