Design and Create Custom Dashboards in Excel

Excel dashboards can be created to effectively present data

Dashboards can be used by all levels of an organisation to deliver value, track progress, KPIs and uncover insights. Organizations work with more data each day, so Excel skills are highly sought after.

This six-week course by The Excel Club will teach you how to create dashboards from scratch. After that, you'll be able to put this knowledge into action and create three interactive Excel Dashboards.

Start designing your dashboard

This course will walk you through Excel dashboard design from start to finish.

We'll start by talking about the three types and then move on to the basics of creating them. Learn the best tips and tricks for creating dashboards, as well as the mistakes you should avoid in order to make your dashboards function effectively.

How to automate your interactive dashboard

This course will guide you through the steps of creating dashboards.

Once you have mastered the steps, you will be able to automate charts using named ranges. You'll also learn how to link the data, use the offset function and then link charts to names. The INDEX function will be used on subsets.

To easily modify your charts, use VLookup or form controls

This course will show you how to modify charts with different tools before you start creating your dashboards. This course will cover how to set up data validation, change the charts using VLookup, and how to add form controls to modify charts.

The final week of the course will see you create three dashboards with your own data and goals.