The real power of a PivotTable comes out when you want to rearrange your data dynamically. A task that would take several minutes if done by hand takes just a few seconds when you summarize your data in a PivotTable.
- [Instructor] The real power of a pivot table comes out when you want to rearrange your data dynamically. A task that would take several minutes, maybe hours if done by hand, takes just a few seconds when you summarize your data using a pivot table. In this movie I will demonstrate how to pivot a pivot table. On sheet one of this workbook, I have a pivot table, and I have customer state as my row headers, and product category as my column headers. If I want to change the arrangement of the fields within the pivot table, then I can use the tools in the pivot table fields task pane.
If you don't see the task pane, for example if it's been hidden by closing it, then you can click any cell in the pivot table, then on the pivot table analyze contextual tab of the ribbon, click the field list button, and that brings it back. My pivot table summarizes data well, but you can see that there are a lot of blanks. So for example, for Alabama, I only have orders for landscape lighting, light bulbs, and solar panels. If I want to see my data by state and only categories where I had orders, then I can drag product category from the columns area below customer state in the rows area.
And you can see that updates the pivot table. This data is more compact, and for me, much easier to read. If you prefer to emphasize category over state, then you can drag customer state below product category, and you see all the battery sales by state, and if we scroll down, grid tie inverters by state, and so on. If you want to remove a field from a pivot table, then drag it from the pivot table fields task pane to the field list, and when you do, it will be removed from your organization, and your data will be summarized using the fields that are left.
- Creating workbooks
- Manipulating cell data
- Using core functions and formulas
- Formatting worksheet elements
- Creating PivotTables
- Collaborating with others
- Working with charts
- Adding images and shapes
- Saving workbooks
- Printing files
Skill Level Beginner
1. Get Started with Excel
2. Manage Workbooks
3. Work with Worksheets, Cells, and Cell Data
4. Sort, Filter, and Manage Worksheets
5. Summarize Data Using Formulas and Functions
6. Format Worksheet Elements
7. Work with Charts
8. Work with External Data and Objects
9. Explore PivotTables
10. Review and Share Your Spreadsheets
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.