Discover the Function of PivotTables in Excel 2010


show more Discovering PivotTables provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training show less
please wait ...

Discovering PivotTables

Among Excel's arsenal of data analysis tools is a really great feature called PivotTables. That's what we are going to look at in this chapter and I want to give you an overview of what PivotTables are and where you would find them useful. PivotTables are useful when you have a lot of data to analyze and it's not obvious how they relate to each other. In the example here on the screen, we have orders being placed from different regions of the country over different months. We see we have different sized bottles being sold and in each order we can see how many of these bottles are being sold.

If you have thousands and thousands of rows of data like this, it could be hard to make good decisions unless you have them analyzed properly. So PivotTables summarize your data. They turn raw data into useful knowledge that you can do things with. Now if you were to create a PivotTable based on the data that you just saw, this is whatthe PivotTable might look like. Now I know it looks kind o...

Discovering PivotTables
Video duration: 2m 22s 6h 21m Beginner

Viewers:

Discovering PivotTables provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training

Subjects:
Business Education + Elearning
Software:
Excel
Author:
please wait ...