How to Use the Pivot Table Wizard in Excel

Video Transcript

"Hi, my name is Dave Andrews. Today I'm going to show you how to use the pivot table wizard in Excel. Let's open up Excel by clicking on our start button. Let's go to all programs. Let's find Microsoft Office. We're just going to open up Excel. Now what I'm going to do is pretend that I'm a sales manager and I'm going to type in some employees and their number of sales as well as thee location that that employee is selling from. Let's put some data in here. And for location, let's kind of spread it out a little bit. So as you can see, I have four employees that are located in Tennessee, New York, and Alabama. What we want to do is insert a pivot table that allows me to run some information on these employees as well as information on the location. So, let's highlight all of our data, go to insert and let's select pivot table. It's asking me what ranges I want to include in my pivot table. I'm just going to leave it as what I have selected and say okay. Now this pulls up the pivot table wizard on the side here. I can choose what data I want to include in the pivot table by simply clicking on the check mark next to that. As you can see, in the pivot table, it's giving me the sum of the sales by Dave. Some by Megan and some by Steve. What I'd like to do is just sort it by location simply by right-clicking on location and saying add to column labels. As you can see, Alabama, New York and Tennessee, are showing up now as columns and all of my sales from New York have been summed together. All of my sales in Alabama are summed together and all of my sales in Tennessee are summed together. My name is Dave Andrews and I've just showed you how to use the pivot table wizard in Excel."