**Includes exercises and two, follow-along Dashboard Projects**
Have you ever looked at an interactive dashboard in Excel and thought “I wish I could create something like that!”. Well, now you can. We’ve drawn on our years of expertise as a Microsoft Excel training provider and have put together the ultimate Excel dashboards course.
We’ll teach you how to create dashboards that look amazing, that are fully interactive so you (or anyone else!) can change the data they are seeing, and that can be updated with new data in a couple of clicks.
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 advanced Excel course, we look at how to create stunning, interactive dashboards in Excel.
Once we’ve taught you all the techniques you need to create your dashboards we end the course with two, super projects:
Creating a fully interactive Sales Dashboard from scratch
Creating a fully interactive HR Dashboard from scratch
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
This course includes:
9+ hours of video tutorials
70+ individual video lectures
Exercise files to practice what you learned
Certificate of completion
This course was recorded using Excel 365. It's also relevant to those using other, recent versions of Microsoft Excel including Excel 2019, 2016, and 2013.