From the course: Excel 2010 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Discovering PivotTables

Discovering PivotTables - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

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 of…

Contents