In this example, we have checked “Order ID” and “Quantity” for our report.ħ. Check the boxes under “PivotTable Fields” of the categories you would like to add to the report. Here we have selected cell blocks A1 to F16 from Sheet1.Ħ. Select the range of data for the pivot table within the “Create PivotTable” pop-up box. Choose “PivotTable” within the drop-down window.ĥ. Click on “Insert” tab at the top of the window.Ĥ. Select the cell where you would like to create the Pivot Table. Here, we will take the data from Sheet1 and create a pivot table on a new sheet (Sheet2):ġ. LEARNING PIVOT TABLES IN EXCEL 2013 HOW TOThis is a very useful tool for someone to group certain categories together to obtain specific information in a relatively fast manner.įollow these 10 Quick Steps on how to create a Pivot Table in Excel 2013. One way to organize your data within your Excel spreadsheet is with Pivot Tables.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |