From the course: Excel: Creating a Basic Dashboard

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Manage PivotTables and PivotCharts

Manage PivotTables and PivotCharts - Microsoft Excel Tutorial

From the course: Excel: Creating a Basic Dashboard

Start my 1-month free trial Buy for my team

Manage PivotTables and PivotCharts

“

- [Instructor] Excel tables let you store and summarize your data in a flexible and efficient manner. You can greatly extend the capability of Excel tables by creating PivotTables and PivotCharts, which let you rearrange and summarize your data quickly. In this movie, I will show you how to create and work with PivotTables and also PivotCharts. My samples file is "01_02_CreatePivot," and you can find it in the chapter one folder of the exercise files collection. In this workbook, I have an Excel table that contains monthly sales data for three different categories, and I'd like to create both a PivotTable and a PivotChart. You can create both at the same time, but for this example, I will show you how to create a PivotTable and then create a PivotChart from that. To begin, click any cell in your Excel table, and then on the Insert tab of the ribbon, click the PivotTable down arrow, and click From Table/Range. So I…

Contents