Advanced Dashboard Design

The complete advanced Dashboard Design Course for Excel. Learn how to create 4 types of corporate dashboards.

This course has 4 main parts that will teach you how to create from scratch 4 different styles of dashboards:

Total: 34 videos + 4 Excel Dashboards
Total Time: 856 minutes (14 hours & 16 minutes)

Each main part is subdivided into a series of videos with a go-along Excel Model.

1 Operations Dashboard

(7 videos, 195 minutes - 3 hours 15 minutes)

- Brief Overview of the Dashboard Structure
- What Formula will be covered
- Formula creation on the Calculations page and the set-up of the model.
- Putting the Dashboard Page together, calcs, text boxes, option buttons, charts

Operations Dashboard.PNG

2 Whole of Organisation Dashboard

(9 videos, 229 minutes - 3 hours 49 minutes)

- Brief Overview of the Workbook Structure
- Formula creation on the Calculations page and the set-up of the model
- Putting the Dashboard page together through the tables and charts on the Dashboard Page
- Finally we will make the Dashboard spin through pivot tables, slicers, check boxes, combo boxes

Whole of Organisation Dashboard

3 HR & Sales Dashboard

(8 videos, 213 minutes - 3 hours 33 minutes)

- Brief Overview of the Workbook Structure
- Formula creation on the Calculations page and the set-up of the model
- Putting the Dashboard Page together, calcs, text boxes, pivot tables, slicers, combobox, charts

Hr Dashboard

4 Global Sales Dashboard

(10 videos, 219 minutes - 3 hours 39 minutes)

- Brief Overview of the Workbook Structure
- Formula creation on the Calculations page and the set-up of the model
- Putting the Dashboard Page together, calcs, text boxes, charts
- Adding the bells & whistles, the options buttons, active X buttons and VBA

Sales Dashoard

The following is a link to the course: