Excel Dashboard Course will teach you everything you need to know to create world class dashboards and reports. It's an online self-paced course that will start benefiting you right away. It is full of practical examples and has already helped 350+ students.
I just wanted to let you know that I think your dashboard course is excellent. I have been able to produce some excellent reports in my job using what I have learned. Thank You.
I am Sumit Bansal, your Excel Dashboard instructor for this course. I have been training people in advanced Excel and dashboards for more than 10 years.
I have also been honored with the Microsoft Excel MVP status for my expertise in Excel.
Creating an Excel Dashboard is like juggling many balls at the same time. You need to know how to get all the nuts & bolts together to create that perfect dashboard.
While every dashboard/report is different, there are some common magic rules to follow when creating these.
Drawing from my experience, in this course, I have made sure you get to learn everything about Excel Dashboards in a structured way.
When you're done with the course, I guarantee you'll be able to create robust world-class Excel Dashboard that will benefit you (and others) a lot.
Sumit, I always thought of myself as an intermediate user of Excel but I really like your teaching style. It does not assume any preconceived knowledge or skills. It just leads us through in a logical and easy-to-follow style. So, thanks!
Excel Dashboard course is a 100% online self-paced video course where you get access to all the lessons and download files as soon as you register. The lessons are full of practical examples that will help you save time and be productive from Day 1 itself.
The course is packed into 6 modules that will cover all the Excel dashboard concepts and then show you how to create real-life fully functional dashboards from scratch.
Module 1: Excel Dashboard Essentials
In this module, you get introduced to the concept of Excel Dashboards and learn about some inbuilt Excel features that are useful while creating a dashboard.
Module 2: Dashboard Nuts & Bolts
Once you have a good understanding of the Excel dashboard essentials, this module will teach you about the building blocks you need to create an Excel Dashboard.
Module 3: Excel Charting for Dashboards
This module is all about Excel charting. It will show you how to create amazing interactive charts that will take your dashboards to a whole new level.
Module 4: VBA Toolkit for Excel Dashboards
With VBA, you can unleash the hidden powers in Excel. You can do a lot of amazing things with VBA, which are otherwise not possible with Excel inbuilt features.
Module 5: Creating Dashboards From Scratch (5 Examples)
In this module, you get five full-length tutorials on how to create dashboards from scratch. Each video will show you how to take the raw data and create beautiful and dynamic dashboard using it
Call Centre Performance Dashboard
Learn how to analyze daily call center type dataset with this amazing dashboard. In this dashboard video, you will learn how to work with sparklines, interactive controls, charts, and advanced Excel formulas.
Sales Pipeline Management Dashboard
In this dashboard, you will learn how to analyze sales pipeline data. You will learn the smart technique of using interactive controls (drop down list, radio button, checkboxes) to make the dashboard user friendly and allow the user to analyze data with a single click.
HR Training Performance Dashboard
In this interactive dashboard, you will learn how to use advanced Excel formulas to analyze data and get relevant insights from it. It also uses conditional formatting to add visual analysis to your dashboard.
Sales Dashboard (Powered by Pivot Table and Pivot Charts)
In this dashboard, you will learn how to quickly create an amazing interactive dashboard in less than 15 minutes. It uses slicers to create interactive buttons that instantly updates the dashboard on selection.
Game of Thrones Visualization Dashboard (with VBA)
This dashboard lesson is packed with a lot of powerful techniques. You will learn how to lookup and update images based on selections. You will also learn how to use radio buttons to sort data, use checkboxes to show selective data, and use conditional formatting to add visual appeal to your dashboards.
[BONUS] Module 6: Dashboard Extras
In this bonus module, you'll learn about some additional features that will add more power to your Excel dashboards.
Assignments + Solutions
A course wouldn't be complete without some assignments.
There are two video assignments in this course in two different modules. Each assignment is based on the concepts that are covered in that module.
Once you have attempted the assignment, you can go through the solution video where you'll learn exactly how to solve a given problem.
Access to 14+ Hours of Excel VBA Tutorials
As soon as you join the course, you get access to the entire Dashboard course (14+ hours of video tutorials)
Downloadable Example Files
The video tutorials are accompanied with downloadable examples files used during the recording of the videos
Downloadable Videos (HD Quality)
You can download all the dashboard course videos (HD quality) and watch at your own pace from any device
You made it all look so simple.
I can't wait to try it for myself and make myself look like an Excel Goddess at work.
This is a 100% online go-at-your-own-pace video course that allows you to learn at your own comfort.
Since you get a lifetime access to this course, you don't have to worry about losing access or having limited time to complete this course.
Each lesson is packed with actionable steps and you also get the example files so you can follow along and practice at the same time. You can watch these videos any number of times from anywhere and on any device.
So no matter where you're, your learning would never stop.
Get started by choosing one of the membership levels
Simple as pie. When you enroll for the course, you get a link to the registration page (the link is also emailed to you instantly). Visit the registration link to create a Login Id and Password and get instant access to the full video course.
A: This is a self-paced course where you can learn at your own speed. This means there is no rush and you can start the course whenever you want (and can take your time in completing it). You get access to the entire course as soon as you sign up.
This course covers 2007, 2010, 2013, and 2016. The concepts and techniques covered in this course would work in all the versions of Excel. Any minor differences in the versions are highlighted upfront and details on all the versions are covered.
Yes. As soon as you complete the course, shoot me an email and I will send you the certificate within 5 business days.
Yes. When you make the payment, you immediately get the invoice via email.
Have more Questions? Ask me at sumitb[email protected]
© Copyright TrumpExcel.com - Online Excel Tips & Tutorials (2018)