Originally published: 02/08/2019 14:14
Last version published: 17/08/2020 10:56
Publication number: ELQ-22243-6
View all versions & Certificate
Last version published: 17/08/2020 10:56
Publication number: ELQ-22243-6
View all versions & Certificate

Advanced Dashboard Design Course
The complete advanced Dashboard Design Course for Excel. Learn how to create 5 types of corporate dashboards.
Description
This course has 5 main parts that will teach you how to create from scratch 4 different styles of dashboards:
1/ Operations Dashboard
2/ Whole of Organisation Dashboard
3/ HR & Sales Dashboard
4/ Global Dashboard
5/ Financial Dashboard Design
Total: 38 videos + 4 Excel Dashboards
Total Time: 856 minutes (15 hours & 51 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 15minutes)
- 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
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
Can be downloaded separately here: https://www.eloquens.com/tool/Qk31sGqz/startups/kpi-dashboards/whole-of-organisation-excel-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
4/ Global 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
5/ Financial Dashboard Design ((4 Videos 95 mins)
- Build a custom VBA function to help the model spin.
- Create a slicer to change the focus of the dashboard.
- Generate all the charts, bullet charts, bar/column charts, doughnut charts.
- Conditional formatting and sparklines tutorial.
Enjoy your course!
- Marcus Small
If you have any questions on this course, you're welcome to reach out to me via Private Message here: https://www.eloquens.com/channel/marcus-small-thesmallman
This course has 5 main parts that will teach you how to create from scratch 4 different styles of dashboards:
1/ Operations Dashboard
2/ Whole of Organisation Dashboard
3/ HR & Sales Dashboard
4/ Global Dashboard
5/ Financial Dashboard Design
Total: 38 videos + 4 Excel Dashboards
Total Time: 856 minutes (15 hours & 51 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 15minutes)
- 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
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
Can be downloaded separately here: https://www.eloquens.com/tool/Qk31sGqz/startups/kpi-dashboards/whole-of-organisation-excel-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
4/ Global 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
5/ Financial Dashboard Design ((4 Videos 95 mins)
- Build a custom VBA function to help the model spin.
- Create a slicer to change the focus of the dashboard.
- Generate all the charts, bullet charts, bar/column charts, doughnut charts.
- Conditional formatting and sparklines tutorial.
Enjoy your course!
- Marcus Small
If you have any questions on this course, you're welcome to reach out to me via Private Message here: https://www.eloquens.com/channel/marcus-small-thesmallman
This Best Practice includes
38videos + 5 Excel Models