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.

Navigating the Field List

Navigating the Field List - Microsoft Excel Tutorial

From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Start my 1-month free trial

Navigating the Field List

“

- [Instructor] The first step towards mastering pivot tables is understanding exactly how the field list works. Think of the field list as your cockpit or your command center where you can drag and drop your fields to customize exactly how the data in your pivot table will be displayed. Now there are five key sections of the field list to pay attention to. The first section on top lays out all of the columns available in your source data with check marks for any fields that are currently included somewhere in the pivot. In this case, we're looking at a simple data set containing only four fields: state, year, total population and student population. Beneath that you have four boxes: filters, columns, rows, and values. And these four boxes determine what data you're looking at and how it's filtered and organized in your pivot table. So I actually like to start in the lower right box and drag in any quantitative or numerical fields that I care about analyzing. In other words, these are…

Contents