From the course: Excel 2019 Essential Training

Unlock the full course today

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

Creating PivotTables

Creating PivotTables

From the course: Excel 2019 Essential Training

Start my 1-month free trial

Creating PivotTables

- [Instructor] A PivotTable is Excel's most powerful analytical tool, and it gives you a quick capability to create summary totals based on list-like data without any formulas whatsoever. We've got a list on this worksheet called PivotTable data in the workbook 10 data management features. It's about 900 rows or so, it's not in any particular order. We'd like to come up with some totals, for example, like we see over in column I. I'll make column H narrower here. A list like this, how long would it take you to create a list like this? I'm gonna double-click one of the cells here. Are you familiar with that function? It's not the most complex of functions, but, to create a list like this it's gonna take some time. And if you were making a presentation of this data or just analyzing it yourself, could you easily switch and say okay, let's do this with the products that we see, they're coming out of column B they're five different products. How long would it take you to restructure all…

Contents