Interactive Excel Dashboards

Interactive Excel Dashboards

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

Create impressive, interactive Dashboards in Excel, from scratch!

Url: View Details

What you will learn

• About Dashboard architecture and inspiration
• How to prepare data for analysis (cleaning data)
• Useful formulas for creating dashboards in Excel

Rating: 4.85294

Level: Intermediate Level

Duration: 12 hours

Instructor: Simon Sez IT