From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Pro tip: Tabular layouts

Pro tip: Tabular layouts - Microsoft Excel Tutorial

From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Start my 1-month free trial

Pro tip: Tabular layouts

“

- [Instructor] So one pro tip relating to table layouts is using the tabular layout to create new source data and I'll let you know what I mean by that. So let's say in this case we've got our IMDB movie database. It's a ton of rows of data, it's at the title level with all these different categorical fields and metrics and let's say using the pivot, we just want to aggregate that data up to a slightly less granular level. So instead by title, maybe I just want table of data that shows revenues by country by genre and that's the deepest I want it to go. In that case, I can exclude anything from the pivot that I'm not interested in. In this case, let's pull color and black and white back into filters and now I've got the data that I really care about, revenue, by genre, by country. The problem is, if I copy this and paste it somewhere else, it's not in a very useful format so I can't just take this and load it into a SQL table or an Access database and even if I move it to a new…

Contents