Excel Dashboard - Basic to Advanced Tutorial

Learn to create 4 types of dashboards from scratch with 100+ techniques

  Enroll in Course

4.5 (982 ratings) 1,136 students enrolled

Excel Dashboards are a powerful tool to communicate and summarize complex Excel data. As a professional, you may have access to tons of data. But, the important aspect of decision making is drawing actionable and relevant conclusions.

If you give your boss an Excel file with customer call data 10,000 rows and 300 columns, your boss won't be able to take a decision from this raw data.You will still need to summarize this with key variables as levers so the dashboard operator can quickly draw patterns and derive conclusions.

I don’t want to make you shine for your Boss. I want you to become the BOSS. This MS Office Training will give you career-building skills that you can use to become better in making chart reports and more efficient at your job.

What’s covered in the Excel Dashboard course?

  • Dashboard fundamentals (Optional): Design tips, Data formats, Formatting, Data cleaning, Sparklines, Spider, waterfall and bubble charts, List- controlled graphs, pivot tables and dynamic functions. Skip this section if you’re already an intermedia user
  • Learn to create 4 types of dashboards from scratch with 100+ techniques
    • ✓ Single sheet tracker controlled by list field across multiple sheets
    • ✓ Pivot table dashboard using interlinked pivots, slicers and button-controlled charts
    • ✓ Map chart dashboard using Advanced Excel functions
    • ✓ Dynamic Dashboards using Excel Macros

You will learn the following techniques:

  1. Naming the dynamic data and the using it in function
  2. Create Chart for comparison from the Pivot table
  3. Create Trend line from the Pivot table
  4. Creating Pie Chart from Slab Report from Pivot table
  5. Inserting Slicer using Chart & Customize Slicer Setting
  6. Creating Waterfall Chart
  7. Creating Bubble Charts
  8. Extract data from multiple sheet using OFFSET, INDIRECT and CELL
  9. Form controls for interactive dashboard.
  10. Creating Thermometer chart
  11. Importing Data from the Internet
  12. Converting Line Item into a Currency Table
  13. Calculation of Currency using INDEX and MATCH
  14. AverageIF for calculating Country Wise Salary
  15. Dynamic Dropdown
  16. Button-controlled charts and spark lines
  17. List longitude and latitude with plotting data on dashboard
  18. Using REPT Function based on the percentage calculation
  19. Advanced INDEX and MATCH with multiple references
  20. Insert World Map into the chart
  21. Plotting Data on Map Chart and Controlling Map Preview from drop-down
  22. Preparing the base by removing duplicate for Dashboard
  23. Implementation of OFFSET for dynamic data
  24. Using macro to update pivot table based on the Job Type
  25. Preparing data for Spiderweb chart and change the graph setting
  26. Use of Array functions like MAXIF and MINIF with single and multiple parameters
  27. Creating Name Range using shortcut and many more

Here are some of the benefits my Outlook tutorial has for you…

Verifiable outlook tutorial completion certificate

Verifiable course completion certificate

6 hours of high-quality video tutorials with 4 hours of lab work for Outlook Tutorials

49+ high-quality video tutorials

Hassle-free 30 day money back guarantee for Outlook Tutorials in case you are not satisfied

Hassle-free 30-day money back guarantee in case you are not satisfied

 Life Time Support for Outlook Tutorials

Life Time Support for Outlook Tutorials

Important information before you join:

  • Once enrolled, you have unlimited, lifetime access to the course!
  • You will have instant and free access to any updates I'll add to the course.
  • I will give you my full support regarding any issues or suggestions related to the course.
  • Guided practice - over worksheets included for immediate practice
  • Access to all videos 24 x 7 - learn online from anywhere
  • A 30-day money back guarantee (we want you to be 100% satisfied)

If you have read this far, next action is JOINING this course. Invest 3.5 hrs for a benefit of lifetime Ninja status on creating Excel Dashboard

“I would like to tell you that I am very impressed with your courses so far – I particularly like the short videos that allow me to get to a topic quickly and then move on (your competitors mostly offer 20-30 min videos which is a bit much to keep one’s attention span). The other gem in your training are the shortcuts, I found no other course with the same insights.”
Peter Klugsberger
Good useful shortcuts told in a precise manner.
Roop Saini
“This is an awesome course in such a short time-frame to become a data analyst using python
Norman Handy

Course Curriculum

  Section 2: Dashboard fundamentals
Available in days
days after you enroll
  Section 4: Map chart dashboard using Advanced Excel functions
Available in days
days after you enroll
  Download Working files for Section 3, 4 & 5
Available in days
days after you enroll

Money Back Guarantee for Outlook Tutorials

If you're not completely satisfied, let us know within 30 days for a full refund. We want you to be 100% satisfied.

Get started now!

Don't have a Credit Card? Click here


Doesn't it frustrate you that you end up spending a lot of time on Presentation-related activity because you don't know better and faster way to complete the same?

I've been there.

There's nothing more frustrating than
- Spending time on creating appealing presentation slides while you could be working on perfecting your speech or delivery.

And to make matters even worse, you think what you know is enough and what I don’t know is implicitly considered irrelevant and useless from my point of view.

The fact you're watching this video, means you know what it's like to feel because nothing seems to work out the way you planned.

- An accelerated, Practical approached Advanced Excel Dashboard Tutorials to teach you Skill needed to compete in competitive work environment. (Total 3.5 hours)
- All Advanced tutorials case studies related to videos.
- Access to all video tutorials 24 x 7 - learn excel online from anywhere.
- A 30-day money-back guarantee (we want you to be 100% satisfied with our Excel Dashboard tutorials)
- You will also get support for doubt and assistance to implement your learning in real-life challenges.

You can enroll for this course online by just a click on Enroll Now button Payments can be made using any of the following options and receipts of the same will be issued to the candidate automatically via email.
- Visa/Master Card credit and debit card
- PayPal
- Other payment option, Click here

This is a self-paced, lean Training program with videos from basics to advanced tutorials. Watch the preview of videos tutorials to get a flavor the program's uniqueness and relevance. Online courses may not be your first preference. But I promise this – After watching 3 videos, this courses will give a tough fight to your usual classroom training.

Office Training library access comes with Unconditional 30 days money back guarantee.

This means you can try courses for yourself and if you don't agree that it adds value to your knowledge, then just send us an email to [email protected] and we'll cancel your subscription immediately.

No Questions asked, no hoops to jump through and no hard feelings...

So go ahead and click on the Enroll in Course button.

To know more please read our Refund Policy. If you just want to get to know the flavor of the course, you click on any one of the tutorials

- We are covered by YourStory | Inc42
- Recommended by MBAExcel.com | Excel Made Easy | WmfExcel | Excel Champs | Engineers Excel | Get Digital Help | AJP Excel | Deskbright
- Our Client list includes: Big Four (KPMG, PwC, EY), Tata Group (Our Corporate Training Company)
- We are among Top 35 Excel Resource Websites in the world

Simple – Our feedback form from each corporate clients give us a rating between 4.8 to 5 (5 being the highest). We will empower you with tips and tricks based on real issues faced by 1000s of students we teach. We created these advanced tutorials after so many years of research and hundreds of hours of training.

Still have more questions?
US: +1-2033499909 or India: +91-8080042523

[email protected]

Still have more questions? +91-8080042523 or [email protected]

Excel Dashboard - Basic to Advanced

Learn Interactive Excel Dashboard as well as Single Sheet Project Tracker (Advanced Level)