Analyzing Data with Microsoft Excel Pivot Tables
A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data. The data is arranged in rows and columns with distinct headers. Use Pivot Tables to group time data by Month, Quarter and Year. OCL Learning @ExcelMaestro explains in the video below.