Using Excel Pivot Tables

Video Transcript

"Microsoft Excel is a registered trademark of Microsoft Office Products, and I am in no way, shape or form affiliated with Microsoft Office or Microsoft. Next up we want to work on pivot tables. Basically what you want to do is go to Data, select Pivot Table and Pivot Chart Report. It'll pop up Wizard. It'll say "Where's the data that you want to get analyzed?" And you say, "From the Excel List or Data Base." And what kind of report do you want to create? Do you want to create a pivot table or you want to create a chart report. In this instance we want to create a pivot table. So you'd go ahead and click Next. And now you gotta figure out, "Well, what data do I want to use?" And then you would select your data, your data range, and then you can either put it on a new worksheet or put it on the existing worksheet. So we'll go ahead and put it on the existing worksheet. And we're going to select a range of cells to put it in. Come click Finish. Now, what you want to do is select on each one, and we're going to add to it. And in row area we selected Quantity, and put in quantity, and then we're going to add another row or column of Received, and then another column for Percentage. Okay? Or, you can change it around to be the column area, and you can add it columnwise. As you can see, your table can get very large and elaborate very quickly. For each individual tab you can actually either show all, or you can only show a part of them. And you can do that by selecting them, or deselecting them...however you want to do it. Notice how it always changes, also. If you want to add rows instead of columns, again, you'd have to go back and add them. And it would be set up in rows. And you can show All. Or again, you can just show Partial. Really, how you want to form out the sheet is up to you, and what data you want to use is up to you."