Pivot table excel tutorial for beginners. Here is the sample file. 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. A pivot table is a summary of a large dataset that usually includes the total figures average minimum maximum etc. 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.