From the course: Excel: PivotTables for Beginners
Join today to access over 24,200 courses taught by industry experts.
Start building a PivotTable - Microsoft Excel Tutorial
From the course: Excel: PivotTables for Beginners
Start building a PivotTable
- [Instructor] When you're ready to make sense out of seemingly random data like these transactions here, then it's time to start building a PivotTable. Let's walk through the process. First, click inside the data, and then on the insert tab, click PivotTable, and then from table range. For this first box here, we actually don't have to do anything because it picked up on the table we made earlier, and you can see that with this selection here, and that's great. We'll just move forward. So for this option, Excel defaulted to the new worksheet, but I'm going to choose existing worksheet because I want it right up here, and I'm going to then select the cell where I want the PivotTable to land, and that's F4. And again, it just picked up that selection here, put that address there for me. All I'm going to do now is I'm just going to click okay. I've got an empty PivotTable here. I've got the PivotTable fields list here,…
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.