The pivot table is the single most powerful tool in all of Excel.


Although Microsoft Excel has many formulas for analyzing Data, using a pivot table is often the fastest and most efficient way to summarize and analyze large datasets.

With a pivot table, you can transform one million rows of transactional data into a summary report in seconds.


In this course, you will learn how to:

  • To analyze and summarize large datasets in a meaningful way to develop reports.
  • To perform time intelligence analysis such as Year over Year(YoY), Month Over Month, Running Totals etc using PivotTables.
  • To visualize data using conditional formatting and Pivot Charts
  • To develop interactive dashboards and reports using Pivot Charts, slicers and timelines.













Course Content



  Excel Tables
Available in days
days after you enroll
  Introduction
Available in days
days after you enroll
  Advanced PivotTable
Available in days
days after you enroll
  Applying Conditional Formatting
Available in days
days after you enroll