From the course: Excel: PivotTable Tips
Unlock this course with a free trial
Join today to access over 22,600 courses taught by industry experts.
Outline and tabular layouts - Microsoft Excel Tutorial
From the course: Excel: PivotTable Tips
Outline and tabular layouts
- [Instructor] Alright, this next pro tip is an extremely important one for anyone who works with pivot tables in Excel. I'm going to show you how we can display pivots in different types of table layouts or forms, specifically Outline or Tabular Form. Now, most pivot tables, by default, will show in what's called Compact Form, and that groups all of your row labels together, or nests them, into a single column. So, from your pivot table tool tab, the design group specifically, you'll see a Report Layout dropdown showing your different table layouts or form options, and this is what Compact Form typically looks like by default. We've got one value column here, the average of price, and we have two row labels, a country and a province field. Now the problem is that, in Compact Form, these two fields get kind of nested together, and both live within column A, and that means we have one column header accessible for things like sorting and filtering, and we can't apply our own sorting or…
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.
Contents
-
-
-
Customizing the field list4m 7s
-
(Locked)
Autofitting column width4m 21s
-
(Locked)
Outline and tabular layouts7m 46s
-
(Locked)
Counting nonnumerical fields6m 5s
-
(Locked)
Grouping dates8m 3s
-
(Locked)
Enabling multiple filters5m
-
(Locked)
Grouping values6m 50s
-
(Locked)
Adding value calculations9m 1s
-
(Locked)
Showing empty items6m 22s
-
(Locked)
Configuring slicers and timelines10m 23s
-
(Locked)
Conditional formatting8m 23s
-
(Locked)
Removing and reviving source data8m 19s
-
(Locked)
Adding custom sort lists5m 23s
-
(Locked)
Solve order and list formulas6m 16s
-
-