Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
This series of movies on Pivot Tables is just going to introduce you to the very lowest level of power that you can work with when you are using Pivot Tables. But I wanted to introduce this concept to you because it is a very powerful way of using the Excel 2007 work sheets, to analyze the information that you have in your worksheets. What we're looking at here in this particular screen and if you've opened up the Pivot Table worksheet in your Exercise Files, you can follow along. And you'll see that we've started off with the end result, this is where we want to learn how to get to.
If you click on the Data tab, you'll see that the information that we have is the same inventory list that we've been working with throughout most of our exercises to date. But what I've done is I've created a Pivot Table and if you click on the Pivot Table tab, you'll see that the Pivot Table is really the sum of all your inventory items. We've done this in various ways in different movies, but with this Pivot Table, I can easily see how many inventory items I have; of Flour, of Icing, of Mix, of Sprinkles, of toppings for a Grand Total of how many items I have in my total inventory, as well as I can look at all of the inventory for each individual item.
And I can do that very simply by selecting or deselecting any of the items I wish to review. Over here in my Pivot Table field list. If instead of looking at inventory, I wanted to look at final cost, it's just two clicks of my Mouse button in order to pull that same information from my datasheet, and present it to me, so that I can analyze it here. Similarly, I can be creating from this table and from this area, different charting options, by going up to my Options tab here, and selecting the ability to do Pivot Charting directly from here.
And you'll see that the Insert Chart options that we just reviewed in our charting movies are made available. So this is going to be quite an interesting set of movies for you. We're not going to delve too deeply in it because we want to introduce the concept only here of Pivot Tables, and hopefully you're going to find it very enjoyable and want your appetite to learn more.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 86768 Viewers
80 Video lessons · 136033 Viewers
59 Video lessons · 54758 Viewers
52 Video lessons · 68651 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.