Data Analysis with Pivot Tables

This course teaches you how to use Microsoft Excel's Pivot Tables to calculate, summarize, and analyze data quickly. Pivot Tables allow you to see comparisons, patterns, and trends in your data in seconds and without having to do calculations manually.

On top of that, you will also learn how to create dynamic charts with Pivot Charts. Pivot Charts are interactive and they respond to the changes made to your Pivot Tables.

Throughout this course, there will be little snippets of Excel tips and shortcuts to help you become more efficient in Excel too.

With your new-found knowledge in Pivot Tables, you can take it further and learn how to create your own Personal Expenses Dashboard! These lessons include how to use the TEXT and IF excel formulas to create dynamic chart titles.

We have also included additional materials with this course on how to use Power Query to transform and restructure your source data so that it will be in the best form for Pivot Tables.