Microsoft excel pivot table tutorial for beginners. Interested in learning more. 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. You can use the following link to enroll in my course. Here is the sample file.