And you'll see down here, here's 'Sheet1' still, with all my data, but I've got this new sheet too which is going to have my pivot table on it. So it's going to create a new one of these. And you can have multiple ones in here, it's just like pages in a document. Within this workbook, we can have worksheets. So we've got our workbook which is the Excel file. In my case, it's just one big chunk, so I'm going to have it anywhere in here, and I'm going to go to insert, and this first one here called 'Pivot Table'.Įverything is fine, this one here, ‘New Worksheet' is just interesting. You might have to select it if you've got lots of different groups of data you're working with. Open that up, and what we need to do is, have our cursor anywhere inside this data set.

To create a pivot table, open up the exercise files, there's one there called 'Pivot Table Data 1'. So let's go off and build our pivot table.

And we have to kind of re-jig it to prove a point to extract data, to see it in a different way. So it's a way of taking this data and feeding it into a sheet. I can break it down even further, and I want to say, the ‘Products’ that were sold by just 'Daniel Scott', the sales person, or maybe, 'Ben Samuels'.

So, on this other sheet down the bottom here, I've broken down the data to show me the ‘Products’ by the ‘Years’, and how much they were sold. I've created one, I just wanted to show you a bit of a demo. What is a pivot table? It is a way to take longer data like this, where there's lots going on, and break it down to usable chunks. All right, it's the one everybody's been waiting for, it's Pivot Table time.

Excel 2016 pivot chart tutorial