Udemy

Interactive Excel Dashboards

Enroll Now
  • 1,856 Students
  • Updated 3/2023
4.8
(244 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
11 Hour(s) 45 Minute(s)
Language
English
Taught by
Simon Sez IT
Rating
4.8
(244 Ratings)

Course Overview

Interactive Excel Dashboards

Create impressive, interactive Dashboards in Excel, from scratch!

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

Course Content

  • 10 section(s)
  • 84 lecture(s)
  • Section 1 Introduction
  • Section 2 Dashboard Setup
  • Section 3 Design Inspiration
  • Section 4 Preparing Data for Analysis
  • Section 5 Useful Excel Formulas
  • Section 6 PivotTables and Pivot Charts
  • Section 7 Advanced Chart Techniques
  • Section 8 Interactive Elements - Form Controls
  • Section 9 Sales Analysis Dashboard
  • Section 10 HR Dashboard

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


Reviews

  • S
    Stuart Kotman
    5.0

    Deb is fantastic. She incorporates the logic and shortcuts seamlessly. I will always give a look to her courses. Mostly, because I learn, yet also, I learn without it seeming tedious. Thanks.

  • H
    Harsh
    4.5

    she is amazing

  • J
    Jim Raley
    5.0

    Ashley is much clearer, slower and thus easier to understand than other courses I've tried. I have difficulty with understanding some foreign accents, speed of their speech, pronunciations, etc. It's very distracting to focusing on the content.

  • R
    Raghu Vikram R E
    5.0

    learnt a lot

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed