Adding Pivot Table columns to enhance data analysis


show more Adding Pivot Table columns to enhance data analysis provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2007: Financial Analysis show less
please wait ...

Adding Pivot Table columns to enhance data analysis

Pivot Tables enable you to analyze your data efficiently, but some questions can only be answered by performing calculations on the data used to create your pivot table. To perform that type of analysis, you can create calculated fields that summarize pivot table data using a formula. Without calculated fields, you would have to copy the data from your pivot table, paste it onto another worksheet and create the formulas there. That's a pain. It's extra work that you absolutely do not have to go through. Now how to create a calculated field in an Excel 2007 pivot table isn't the most intuitively obvious thing.

So I'll just show you where it is on the user interface so you can do it later. To create a calculated field, first you select any cell in the pivot table and then on the Pivot Table Tools Options tab of the ribbon, you go to the Tools group and click Formulas and that's where you find the Calculated Field menu item. So click that and you get the Insert Calcula...

Adding Pivot Table columns to enhance data analysis
Video duration: 3m 5s 2h 18m Intermediate

Viewers:

Adding Pivot Table columns to enhance data analysis provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2007: Financial Analysis

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