From the course: Excel: PivotTables for Beginners (2018)

Unlock the full course today

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

Create the value field first

Create the value field first - Microsoft Excel Tutorial

From the course: Excel: PivotTables for Beginners (2018)

Start my 1-month free trial

Create the value field first

“

- [Instructor] Sometimes people put in a blank pivot table like this and they think, "Well, now what?" Well, let me show you the details of how to get going here. The first step you have to do is sort of imagine or envision the pile of information you want to divide up. And if I look at the data here, there's lots of things that could pile up. But the most obvious field I want to pile up is the amount field 'cause it has a bunch of money. So what do we do now? We make a value field out of this amount field. And the way we do that is we go on over here to the Pivot Table Fields list. Now if this fields list isn't open for you yet, then go ahead and right click this area and choose Show Field List. Mine's already open so mine says hide. So you may need to do that if you don't see this fields list open over here. So to make that value field out of the amount field, I'm going to take this amount field and drag it down to values. Great! Here's a little pivot table here and it has one thing…

Contents