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 - Microsoft Excel Tutorial
From the course: Excel 2010 Essential Training
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.