Pivot Tables

In this lesson, we will learn Pivot Tables in Excel. We will understand how to create quick summary reports from raw data, how Row, Column, Values, and Filters areas work, and how to calculate sum, count, and average through practical examples. ## Lesson objective In this lesson, we will learn Pivot Tables in Excel. In the previous lesson, we covered Data Cleaning in Excel. We learned how to work with duplicate data, blank cells, extra spaces, numbers stored as text, invalid dates, Find and Replace, Text to Columns, Flash Fill, and Data Validation. Now we move to one of the most powerful tools for Excel data analysis: Pivot Table.