I can click on it, and there's one that says 'Remove Field'.Actually I want to find out actually- from my 'Sales People', there he is there under 'Rows'. Let's say I want to get rid of the 'Products'. I've pulled out the 'Products', and how much was spent on them. You can see here now, I've pulled from my raw data.
So I want to know to know the 'Products', and I want to know how much was 'Order'ed, the values. So we're cleaning up our data from that nice, big raw data set, and kind of just pulling the bits we want. You can see here, it's listed them down here. So you click, hold and drag them into rows. I'm going to put in, say, my 'Products' into here. So the ups and downs, the Y-axis, the vertical. We'll use columns a bit more, and filters even less but rows and values. The most important ones are rows and values, you'll use these the most. We're going to use these fields down the bottom here. This is the most interesting, or important thing when you're building a pivot table. What we need to do is, we're going to use these pivot fields here. And 'Sheet2' is going to be my 'Pivot Table', just so we know. Let's just name it, let's double click 'Sheet1' and call this one 'Raw Data'. 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.
0 kommentar(er)
