From the course: Excel: PivotTables for Beginners
Join today to access over 24,200 courses taught by industry experts.
Create a PivotTable with AI - Microsoft Excel Tutorial
From the course: Excel: PivotTables for Beginners
Create a PivotTable with AI
- [Instructor] Everybody loves a good shortcut, so let's learn one for creating PivotTables. I've got the 02_07 exercise file open, and I've got a lot of data here, but I want it summarized and I need it done quickly, so I'm going to do this. On the home tab, I'm going to go over here and click analyze data. And here, the analyze data pane opened up, and Excel used AI to generate some PivotTables here. This one here shows me sales by product and year, and that's pretty helpful. Here's one that shows rating by year in category. We've got another line chart here, but this is an interesting one. Let's say this is a bike shop that I'm running here. It turns out accessories are a bigger category of sales than bikes themselves. That's kind of interesting. You might be asking why I showed you the longer method in the previous videos when I could have just shown you this shortcut. Well, you still have to know how to work with…
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.