How to Make a Pivot Table in Excel

Video Transcript

"Hi, my name is Dave Andrews. Today I'm going to show you how to make a Pivot Table in Excel. Let's open up Excel on the computer by clicking on our start button. Go to all programs. Let's find Microsoft Office and just launch Excel. A Pivot Table is very useful for showing a set of data in multiple ways. I'm going to show you how we can do this by creating just a simple spreadsheet. Let's say we're going to keep track of employees who are in different states and their numbers of sales. Say employee location, number of sales. Let's just put in some data - some data into this, I'm just going to make it up. All right, now we're going to insert our Pivot Table on this data. To do so, just highlight the data in our spreadsheet. Let's go up here to the insert tab, and under tables just click Pivot Table. This brings up the create Pivot Table window that asks you what type of data you'd like to include. We've already got our data selected. Let's click okay, and you now have the Pivot Table field list interface. This lists our fields that we have in our data. We want to include it all. You can see that our Pivot Table as we changed the fields we want to include was automatically updated. But let's say that we want to filter it by the location of the employee. We want to have that capability. Just click on location, hold your mouse down, and drag it into the filter area down here. Now as you can see, the location has disappeared from our data, but we have a filter up here for the location, it's currently displaying all. But say I only want to show sales for Kentucky. I'm just going to click on Kentucky, say okay. Now I'm showing that Tom in Kentucky made twenty sales. A Pivot Table is useful for this for showing your data in multiple ways. My name is Dave Andrews and I've just showed you how to create a Pivot Table in Excel."