From the course: Excel Essential Training (Microsoft 365)
Join today to access over 24,400 courses taught by industry experts.
Creating PivotTables - Microsoft Excel Tutorial
From the course: Excel Essential Training (Microsoft 365)
Creating PivotTables
- [Instructor] One of Excel's most powerful analytical tools is a feature called a pivot table. And it's not really a data management tool. It's not found on the data tab in the ribbon. You'll find it over on the insert tab, probably based on the idea that we are creating or about to create something new in the same sense that when we create a chart, we're creating something new. I've got a list over in columns A through G. It's about 900 rows. For the moment, it's not in any particular order, but we'd like to make some sense out of it. And one way we could be doing this is to use some of Excel's functions. So off to the right, you'll see one way to do this, not by way of a pivot table, but to point out the idea that when we're trying to analyze information, certainly one of the things we want to do is summarize perhaps by salesperson and maybe break down this information by region. And you can imagine other combinations here too, as you look at those field names, maybe in a different…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
