From the course: Excel Essential Training (Microsoft 365)

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Creating PivotTables

Creating PivotTables

From the course: Excel Essential Training (Microsoft 365)

Start my 1-month free trial Buy for my team

Creating PivotTables

“

- [Instructor] One of Excel's best analytical tools is what we call a pivot table. It's based on analyzing a list. On this worksheet, we've got a list in columns A through G. It's over 900 rows, and we'd like to come up with some summary information. It's part of that idea of give me the big picture. I don't need to see the detail all the time. Now, Excel has a number of data management tools, and you might have seen this in the previous movies. On the Data tab, we've got sorting and filtering and a lot of different data tools here. One of these tools off to the right, Subtotal, which we're not going to be using actually, does allow us to introduce new lines into our list for summary information. But suppose we wanted to come up with a concise view of how well these salespersons are doing by region. Any of the salespersons, by the way, can sell any of the products to any of the customers and no one salesperson is responsible…

Contents