Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Interactive Excel Dashboards
Rating: 4.7 out of 5(266 ratings)
1,943 students
Created bySimon Sez IT
Last updated 3/2023
English

What you'll 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 content

12 sections84 lectures11h 45m total length
  • Introduction to Excel Dashboards2:22
  • WATCH ME: Essential Information for a Successful Training Experience2:11
  • Course Exercise Files1:29
  • DOWNLOAD ME: Course Exercise Files0:23
  • DOWNLOAD ME: Course Demo Files0:23
  • Section Quiz

Requirements

  • Microsoft Excel for Windows. The course was created using Excel 2019/365 for Windows. All of the code used in this course except for one property is compatible for Excel 2007, Excel 2010, Excel 2013, Excel 2016 and Excel 2019.
  • Intermediate knowledge of Microsoft Excel.

Description

**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:

  1. Creating a fully interactive Sales Dashboard from scratch

  2. 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:

  1. 9+ hours of video tutorials

  2. 70+ individual video lectures

  3. Exercise files to practice what you learned

  4. 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.


Here’s what our students are saying…


"The instructor has a nice way of teaching - I really need this skill for my job. I am pretty sure I can learn it! Very happy with the instruction style so far."

- Irma

"I liked her teaching, once trained skipped over simple items and didn't waste our time with repeating it. Dashboard courses I have taken two already and I always pick up new things - here spark lines. Thank You"

- Duane

"Clear, concise, easy to follow. It is 'early days' for the rating, but I have no doubt I'll enjoy the remainder of the course. Best of all, I'm learning things that I can use at work tomorrow, and it will save me LOTS of time."

- Robert

Who this course is for:

  • Those wanting to create visually appealing dashboards in Excel
  • Users with basic knowledge of Excel 2019/365 and those upgrading from previous software versions
  • Users who have a foundation of Microsoft Excel and seeking to advance their Excel 2019/365 knowledge.