Excel Tutorial For Pivot Tables

You can use the following link to enroll in my course.

Excel tutorial for pivot tables. Here is the sample file. To do so highlight your entire data set including the column headers click insert on the ribbon and then click the pivot table button. In this tutorial you will learn these pivottable features in detail along with examples. By the time you complete this tutorial you will have sufficient knowledge on pivottable features that can get you started with exploring analyzing and reporting data based on the requirements.

Jump to chapters below this pivot table excel tutorial shows you how to use and create pivot tables in excel 2010 2013 2016 2019 and office 365. A pivot table is a summary of a large dataset that usually includes the total figures average minimum maximum etc. A pivot table allows you to extract the significance from a large detailed data set. 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.

Now excel creates a dummy pivot table in a new worksheet and displays the fields task pane on the right hand side of the window. Our data set consists of 213 records and 6 fields. Pivot tables are one of excel s most powerful features. Order id product category amount date and country.

Select insert pivottable. Pivot tables allow us to analyse summarize and show only relevant data in our reports. Once youve entered data into your excel worksheet and sorted it to your liking highlight the cells youd like to summarize in a pivot table. In tablerange verify the cell range.

Under choose the data that you want to analyze select select a table or range. Pivot table fields task pane top section is the fields sections which lists down the available fields for pivot table. Click insert along the top navigation and select the pivottable icon.