You have learnt how to create a pivot table in Excel. Step 8: Experiment with the looks and the results until you are happy with the outcome. Depending on what you want to summarize from your table, you drag and drop the contents of the upper part into one of the four drop zones of the lower part. Step 7: The right side of your Excel pane is now split into two types of fields: the upper one shows your sets of data, and the lower one has four drop zones of reporting. This easy-to-follow tutorial takes you through the basics of creating a Pivot Table in Excel and helps you understand how powerful Pivot Tables can be. Step 6: Choose “New Worksheet” if you want the Pivot Table to be placed in a separate worksheet, otherwise choose Existing.

Step 5: Mark “Use an external data source” if your values were processed by a non-excel application, otherwise leave that field empty. Select the entire range of data you want to be included in the reporting of the Pivot table, including headers. From the Insert Tab, the Tables subsection, click on Pivot Table. Position your cursor on where you want your Pivot Table to appear. Make sure you have different columns of data with their names labeled on top of their fields. It is called pivot table because you can easily alter its layout and structure, regardless of the data it feeds from. 3D Maps (ne Power Map) is available in the Office 365 versions of Excel 2013 and all versions of Excel 2016. Zoom in on the neighborhood of each store location. In this tutorial you will learn how to create pivot table in Excel.Ī pivot table is a particular format of table specific to Microsoft Excel, which will allow you to see a bird’s eye view of a table without you having to create formulas for calculations. Display an Excel Pivot Table on a Map using the new Power Map or 3D Maps feature in Windows versions of Excel.

Making pivot tables in excel 2013