8/24/2023 0 Comments Excel 2016 pivot table cheat sheet![]() 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |