Using Pivot Tables in Microsoft Excel
A pivot table in Microsoft Excel allows the user to organize data in a way that can create filters, categories and groupings. Choose data for inclusion in a pivot table in Microsoft Excel with help from a software developer in this free video on Microsoft Excel.
Promoted By Zergnet
Hi, my name is Dave Andrews. Today I'm going to show you how to use Pivot Tables in Microsoft Excel. Let's go to our computer and open Excel. Click on the "Start" button, let's go to "All Programs", let's find "Microsoft Office", and then click on "Excel". A pivot table allows you to organize data in a fashion that you'd want to see it. You can create filters and categories and groupings in a pivot table. So I'm just going to type a basic spreadsheet of employees, of their location, and their number of sales. Let's fill in some of this information. So there is my spreadsheet, but I want to make a pivot table. Let's just highlight the spreadsheet, go to "Insert" and then click on "Pivot Table". It asks me what range of data I'd like to use and I've already got it selected so let's hit "OK". We now have our pivot table screen that allows us to create the pivot table. First you want to choose what data you want to include in the pivot table. I want to see all of it. As you can see, it's already categorizing but it's categorizing by the name of the employee. Let's say I would like to categorize by their location. I'll just grab "Location" and I'll pull it down into the "Column" field. As you can see, too, I'm now categorizing by location. I can also hide the employee's name and only see the number of sales by location. As you can see a pivot table gives you a lot of options for what you want to see in your table and what you want to group by. You can also filter it just by location. I can now choose to only see Columbia, and there is my answer. My name is Dave Andrews, and I've just shown you how to use pivot tables in Microsoft Excel.