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.

Analyze and design options

Analyze and design options - Microsoft Excel Tutorial

From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Start my 1-month free trial

Analyze and design options

“

- [Instructor] So once you've added a pivot table in Excel, you'll see a new menu header called pivot table tools, and within that, two tabs: analyze and design. These tabs contain all of the tools and options that are specific to pivot tables. So for example, if we drill into the analyze tab, here you'll find any tool and option that will help to supplement our analysis using this pivot table. Got general options, we can expand and collapse fields, group things together, insert slicers and timelines, we can refresh the pivot or change the data source, clear, select, or move the entire table, we can add calculated fields, and even insert things like pivot charts. So we'll be diving in to each of these tools, in depth, in the upcoming sections of the course. I just want to make you aware that this is where these tools live, and that they're organized into these two tabs within the pivot tables header. So the second tab is design, and this is where you can customize the look and feel of…

Contents