Introduction to the Basics of PivotTables in Excel 2010


show more Introducing PivotTables provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth show less
please wait ...

Introducing PivotTables

Before I get into the details of how to create and manipulate PivotTables, I would like to demonstrate a few of the ways a PivotTable helps you analyze your worksheet data. When you look at your PivotTable, it looks a lot like a regular worksheet with rows and columns of data, labels, subtotals, and grand totals. The difference is that a PivotTable allows you to rearrange your data dynamically within the worksheet. If you click a cell inside of a PivotTable, then you will see that Excel displays the Options and Design tabs on the Ribbon.

These contextual tabs allow you to manipulate your PivotTable either by changing a style, which you can do on the Design tab, or on the Options tab refreshing its data, changing its data source, and so on. What's really exciting about PivotTables is that you can change the structure of your data to emphasize different aspects of that data. PivotTables are divided into several different areas. First, you have the PivotTable Field List which allows yo...

Introducing PivotTables
Video duration: 4m 2s 3h 43m Intermediate

Viewers:

Introducing PivotTables provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...