From the course: Excel Power User Challenge

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Deliveries and PivotTables

Deliveries and PivotTables - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

Deliveries and PivotTables

“

Pause the video, come back and I'll show you a solution. Let's do this, because we know we have data to add later, I'm going to to immediately put this data into a table, format as table. I am going to grab, how about this green here? Table has headers, okay? Get rid of these filter buttons. Now, create the pivot table, cursor in the dataset, insert, pivot table. I'm going to put it on a new worksheet, click Ok. Let's grab the objectives. Go over here. Cut and paste. Now, we can see what we need to do. Click inside that pivot table. I'm going to pull this field list out. We want the driver in rows. I'm going to put the addresses in the values and then the result in columns. This out of the way, let's bring this up so we can all see. We only want drivers that have at least 10 deliveries. So, Jake, Lou, Lourdes, Benson, they all need to go away. So, I'm going to go to this arrow, click here. Value filters, greater than or equal to 10, okay. I want to get rid of these grid lines, view…

Contents