Excel Dashboards
- Description
- Course Resources
Excel Dashboards
- DURATION: 9.40 hours
- VIDEOS: 77
- LEVEL: Intermediate
In this advanced Excel Dashboards course, we look at how to create stunning, interactive dashboards in Excel.
A dashboard is a great way to visualize your data. An interactive dashboard allows you to change what results you see at the click of a button. In this in-depth course, we look at how to prepare your data for analysis, some essential formulas you’ll need to help you create dashboards in Excel, Pivot Tables, Pivot Charts, Form Controls and so much more.
Finally, we take you through how to combine all those skills to create a Sales Dashboard and an HR Dashboard in two, end of course projects.
If you need to analyze and present data in Excel, then this course will show you step-by-step how to create jaw-dropping Excel dashboards that leave people wondering how you became that good in Excel!
In this course you will learn:
- About Dashboard architecture and inspiration
- How to prepare data for analysis (cleaning data)
- Useful formulas for creating dashboards in Excel
- How to create and edit Pivot Tables in Excel
- How to create Pivot Charts from Pivot Tables
- Advanced chart techniques in Excel
- How to add interactive elements (form controls) into your dashboards
- How to create a Sales Dashboard from scratch
- How to create an HR Dashboard from scratch
Course Format
This is a video-led training course. You can preview some videos in the pane above. This course is suitable for Windows users.
Excel Dashboards
This course includes course support files and exercise files in the form of .ZIP files. You will need to download the .zip files to your PC or Mac (the file are not compatible with a mobile device) and unzip the file. Once unzipped, all of the exercise/example files will reside in one folder.
What people are saying
Trusted by
Start Your Membership
Simon Sez: “Let’s make you a software superstar!”
From Excel to photo editing, experience quality courses that ensure easy learning.
START YOUR MEMBERSHIPLearn More