Microsoft Office Excel 2013 Pivot Table Tutorial

Or maybe you tried using one and had difficulty.

Microsoft office excel 2013 pivot table tutorial. Pivot tables are one of excel s most powerful features. Click the pivotchart command button in the tools group on the analyze tab under the pivottable tools contextual. Pivot tables allow us to analyse summarize and show only relevant data in our reports. Lets say you have a sales data for different regions with a pivot table you can summarize the data by region and find the average sales per region the maximum and minimum sale per region etc.

A create pivottable window should appear. Follow the steps below to take your pivot table to the next step. Each version of excel can look and feel completely different from another. Select the range of data for the pivot table and click on the ok button.

Under choose where you want the pivottable report to be placed select new worksheet to place the pivottable in a new worksheet or existing worksheet and then select the location you want the pivottable to appear. In tablerange verify the cell range. Create a pivotchart select a cell in your table. Excel 2013 is a version of excel developed by microsoft that runs on the windows platform.

In this tutorial well show you the ropes. Select insert pivotchart. In the tables group click on the tables button and select pivottable from the popup menu. You might have heard the word pivottable before and wondered what it was.

A pivot table allows you to extract the significance from a large detailed data set. Finally when youre done youll see that anyone can make a pivottable. If however you want the pivot table to appear on the same worksheet click the existing worksheet button and then indicate the location of the first cell of the new table in the location text box. By default excel builds the new pivot table on a new worksheet it adds to the workbook.

Under choose the data that you want to analyze select select a table or range. Pivot tables tutorial complete congratulations you have completed the excel 2013 tutorial that explains pivot tables in excel 2013. Then youll get an idea of the basic parts of a pivottable. In this example weve chosen cells a1 to f16 in sheet1.

A pivot table is a summary of a large dataset that usually includes the total figures average minimum maximum etc. After creating a pivot table in excel 2013 you can create a pivot chart to display its summary values graphically in two simple steps.