 Hi, this is Dr. Don and I have part two of the PivotTable overview videos. This is the original data that we used to create the PivotTable that I'm going to show you how to make. When you are trying to use a PivotTable, you need to check your data to make sure it is ranged as a table. And by that I mean the first row in your data set needs to contain labels, titles of each of the columns. And you may recall that we sometimes call these columns as if they contain variables or data fields. And again you need to have that first row only consist of titles. Then there needs to be one row for each item that you are interested in. In this case we have employees and for each employee all of the data that we need for each employee is in that one row. If you had data scattered among rows then the PivotTable couldn't find them properly. So make sure you have one row, one record per item. Then you need to make sure there is no empty rows in your data set. You can make do with an empty cell here and there, Excel can work around that as long as it is not an entire row or an entire column that is empty. So if you have those scan your data, find them and delete those empty rows and delete those empty columns. Finally you need to make sure there is no extraneous information on the edges of your data. For example here in this table I've got a little note that I gave myself. Check on this souring. What you can do is delete it or you can just move it so it's no longer touching so it's longer adjacent and that should be okay. Now down at the bottom I think I recall that I put a total. So I'm going to use a shortcut control shift down arrow to go down to the very bottom of the data table and there you can see yes there's 9,230 records there and I want to get rid of these two cells there that had the total and I'm going to go back up the top control shift up arrow and that puts me up at the top. To create the data, excuse me, the pivot table, all you need to do is click somewhere in your table and then go up to the insert ribbon, click on that, find pivot table and click on that. Now you'll see there's a recommended pivot table there. That can be a shortcut if you know what you're doing. Excel will look at your data and try to suggest how you should create your pivot table but sometimes that can start you off in the wrong direction. So I like folks particularly learning to start with a basic pivot table, click on that and you get this dialog box and it will tell you we've selected this range, all of the cells that are adjacent and it goes from A1 to K92, to K229, which is what I want. I don't want to use an external data source and as I go down, I want to put my pivot table on a new worksheet. Generally that's better if you use a new worksheet than trying to use, put it on your original data. And then finally just for your information note you can use more than one data table, more than one worksheet and create what they call a data model, which is just a pivot table with multiple worksheets. We don't want that, we want just a simple somebody to click OK. Excel inserted this new worksheet here. It's labeled as sheet 14 because I've, excuse me, yeah, sheet 14. I've made a lot of worksheets before I made this video and it's blank except there's some information there. It says here's where you build your report and you do it by pulling fields from the pivot table field list, which is over here on the right side. And here's the list of the fields or the variables we have in our data table. And you build your pivot table by dragging these fields into this area at the bottom and that will be the subject of the next video. So tune in shortly and we'll build that table that we use to create the report.