How to Make a Pivot Table

Next Video:
How to Make a Line Graph in Microsoft Excel....5

To make a pivot table, open up Microsoft Excel, enter data into a spreadsheet, highlight all of the data and select "Pivot Table" from the "Insert" tab at the top of the screen. Create a pivot table, making sure to enter in the range of data and fields, with IT help from a software developer in this free video on computers.

Part of the Video Series: Computers & Laptops
Promoted By Zergnet


Video Transcript

Hi, my name is Dave Andrews. Today I'm going to show you how to make a pivot table. Let's go to the computer and we're going to do this with Excel. Just click on your start button. Go to all programs, Microsoft Office. Let's launch Excel. Now we're going to type in some data here. I'm going to keep track of my employees, their number of sales and their location. Let's say David made 120 sales and he's in the US. Billy made 75 sales and he's in Canada. And Tom made 150 sales from Canada. So what we're going to do is insert a pivot table, which gives you a whole lot of options for filtering and sorting data within Excel. So let's highlight all of our data here. I'm just dragging the mouse to highlight over it. To create our pivot table go to the insert tab at the top. I'm going to select "pivot table." Now it's going to make sure that your data that you've selected is correct. Since I've manually selected the range of data that I'd like to include, I'm just going to click OK here. Now it's going to ask you which fields do you want to include in your pivot table. I want to include all of them. I'm going to put little check marks next to employee sales and location. Now these options down here allow you to select what you want to be able to run the reports on. So let's say that I want to run a report on the location of my employees. I'm just going to grab that and drag it down to the report area. Let me close out of these options. So as you can see here, it's showing my three employees and their total number of sales. The location is missing because that's our report filter. Here is location. Say we only want to see the sales for Canada. I'll just click this little drop-down, select Canada and I'll say OK. Now, only my sales in Canada are showing. And the same would be for the US. Only my sales in the US show. My name is Dave Andrews, and I've just showed you how to create a pivot table.


Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!