Drag your mouse over the area that you want to take the data from (here that is our entire table) and then click “OK”. A dialog box will appear and you are going to need to select a range for your pivot table. Click into any cell near to this sheet where you would like your pivot table to appear.Ĭlick on the “Insert” tab in the ribbon at the top and then click the “Pivot Table” icon on the left. As you can see here we have some fictional information about the sales figures for some items in a store. Step # 1 – Finding the Place for the Tableįirst of all you are going to want to have some data already in your sheet. In this tutorial you are going to learn how to create a pivot table in Excel 2013. Pivot tables are one of the most powerful features in Excel and they can make your data easy to use and manage with a minimum of effort.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |