From the course: Excel PivotTable Quick Tips
Join today to access over 25,500 courses taught by industry experts.
Create multiple PivotTables - Microsoft Excel Tutorial
From the course: Excel PivotTable Quick Tips
Create multiple PivotTables
- [Instructor] You can have multiple pivot tables on the same sheet. Just like before, we'll place our cursor inside the dataset, change to the Insert tab and click PivotTable. This time, instead of selecting New Worksheet, I'm going to choose Existing Worksheet. I'll change to my sheet that contains the first pivot table and place the cursor where I want the second table to be inserted. I'll click OK. And here's my second pivot table. It contains the same fields and I can adjust these as I see fit. This time, I want to see the amount sold of every order type. At any time, I can delete this second pivot table by right clicking and choosing Delete PivotTable.
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.