There is only a small amount of data in this table in an effort to keep this as simple as possible, but this same process can easily be expanded to handle much larger amounts of data, and prevent you from needing to write any formulas or macros to get the information that you want. For example, I have created a very simple spreadsheet below that lists sales amounts for three different members of a sales team. The way that I use pivot tables the most often is to quickly total amounts that are associated with different rows.

Among other functions, a pivot table can automatically sort, count, total or average the data stored in one table or spreadsheet, displaying the results in a second table showing the summarized data”. According to Wikipedia, a pivot table is “a data summarization tool found in data visualization programs such as spreadsheets or business intelligence software. If you find yourself asking the question “what is a pivot table,” then know you are not alone. How to Make a Pivot Table in Excel 2013 (Guide with Pictures) Our article continues below with additional information on how to create a pivot table in Microsoft Excel, including pictures for these steps.

Check the box next to each column to include it in the pivot table.

Select the data to include in the pivot table.

This allows you to install your copy of Office on up to five computers, with the ability to remove and add those licenses if you get a new computer, or want to switch a license to a different computer.ĥ Additional Sources How to Make Pivot Tables in Excel 2013 If you are planning to install Office on a second computer, consider getting an Office subscription instead. So read below to learn how to make a pivot table in Excel 2013. Once the data has been reconfigured for the pivot table, you can adjust the way that it is organized and displayed to help you better understand the information that the spreadsheet contains. When you create a pivot table in Excel 2013, you are taking data from your spreadsheet and inserting it into, by default, a new format in another sheet of your Excel workbook. A pivot table in Excel 2013 offers a variety of options for comparing data in columns, and grouping similar data in a way that would otherwise be difficult to do manually. Learning how to make a pivot table in Excel 2013 will give you a new tool in your Excel utility belt that can make sorting and analyzing data much simpler. But if you have heard of or seen a pivot table before, then you might be curious about how to create a pivot table in Microsoft’s spreadsheet application. Microsoft Excel is full of useful tools that can help you get the information that you need from your source data.

How to build pivot tables in excel 2013