Excel tutorial on pivot tables. In this tutorial you will learn these pivottable features in detail along with examples. You can use the following link to enroll in my course. To do so highlight your entire data set including the column headers click insert on the ribbon and then click the pivot table button. Choose where to place your pivot table after clicking that pivot table button youll be met with a popup that asks where youd like to place your pivot table.
Pivot tables allow us to analyse summarize and show only relevant data in our reports. Click any single cell inside the data set. To insert a pivot table execute the following steps. Its a lot harder to explain a pivot table than to show you how one works so lets take a look.
Under choose the data that you want to analyze select select a table or range. Here is the sample file. Pdf version quick guide resources job search discussion. Pivottable is an extremely powerful tool that you can use to slice and dice data.
In tablerange verify the cell range. Click insert along the top navigation and select the pivottable icon. Excel pivot tables tutorial. Here we have a worksheet that contains a large set of sales data for a business that sells speciality chocolate to retailers.
By the time you complete this tutorial you will have sufficient knowledge on pivottable. Highlight your cells to create your pivot table. 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. 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.