What are PivotTable reports and PivotChart reports?


show more What are PivotTable reports and PivotChart reports? provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

What are PivotTable reports and PivotChart reports?

This series of movies on Pivot Tables is just going to introduce you to the very lowest level of power that you can work with when you are using Pivot Tables. But I wanted to introduce this concept to you because it is a very powerful way of using the Excel 2007 work sheets, to analyze the information that you have in your worksheets. What we're looking at here in this particular screen and if you've opened up the Pivot Table worksheet in your Exercise Files, you can follow along. And you'll see that we've started off with the end result, this is where we want to learn how to get to.

If you click on the Data tab, you'll see that the information that we have is the same inventory list that we've been working with throughout most of our exercises to date. But what I've done is I've created a Pivot Table and if you click on the Pivot Table tab, you'll see that the Pivot Table is really the sum of all your inventory items. We've done this in various ways...

What are PivotTable reports and PivotChart reports?
Video duration: 2m 31s 5h 13m Beginner

Viewers:

What are PivotTable reports and PivotChart reports? provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

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