Microsoft Excel Intermediate - Creating a Dashboard

If you use Microsoft Excel in your professional life, or even personal life, then this class will be perfect for you.

This class is a project based class in which we will work together from beginning to end to create a dashboard in Microsoft Excel. It is designed as if we were in the workplace and have been assigned a new task.

You do not need any knowledge of Microsoft Excel to follow along with this course as we will start together from the beginning and work our way up to creating an amazing looking dashboard.

To start with, I will explain to you the fundamentals of a Pivot Table and how we can use them effectively for Dashboards. I will then show you how to create all of the charts that are needed for the dashboard. I will also show you how slicers work and how to make them look much better! You will also learn how to make the dashboard automatically refresh when new data is added to the data set. Finally, we will put it altogether and design an amazing looking dashboard.

After taking this class, you should feel confident in your ability to create a dashboard and transform a large data set into a insightful visual dashboard.