Microsoft Excel: Pivot Tables to Dashboard- Beginner’s Guide

Learn how to use Microsoft Excel Pivot Tables in simple step-by-step tutorials that will take you from zero to creating

Created by: Sama Sadat
Founder, Excel with Sama

What Will I Learn?

• The course gives you a comprehensive understanding of Excel Pivot Tables, Excel Pivot Charts and interactive Excel Dashboards.
• How to use Pivot Tables to quickly and easily analyze large sets of Data.
• Clear simple step by step tutorials, delivered in a bite sized lectures for easy reference later.
• Create valuable insights for your company through reports and charts.
• Improve your data analytical skills, even if you are starting from a zero level.
• Lifetime access to course material .
• Understand the anatomy of Pivot Tables.
• How to use Slicers and Timelines to create interactive Excel reports.
• Efficiently handling continuous updates to your source Data.
• Customizing your Pivot Tables to reflect your Company's brand.
• How to sort, filter and group Data with Pivot Tables.
• How to visualize your data through Pivot Charts
• How to create calculated fields and calculated Items.
• How to use one of the powerful tools in Microsoft Excel - Conditional formatting.
• How to construct interactive Dashboard that are user friendly.
• A lot of Pivot Tables tips and tricks that you can show off at work.
• Download all the data files used through out the course, so you can practice what you learn on the spot.

Requirements

• Microsoft Excel 2010 and onward. (Windows version, some techniques might not work on Mac).
• NO prior Microsoft Excel knowledge is required.
• Passion to learning is an asset.

Target audience

• Absolute beginners who want a structured step by step Microsoft Excel Pivot Tables course.
• If you work with Microsoft Excel on a regular basis.
• If you want to be more proficient in analyzing your data and creating professional reports.
• New graduates who want to make sure they have the Pivot Tables knowledge to stand out in their next job interview.
• If you want to become more confident in using Microsoft Excel Pivot Tables
• If you want to discover new tools in Microsoft Excel Pivot Tables that will help you to work smarter not harder and do more in less time.
• If you have tried to learn Microsoft Excel Pivot Tables before and have struggled.
• If you have a good knowledge of Microsoft Excel Pivot Tables and you want to fill some gaps.