Microsoft Excel Dashboards Crash Course for Advanced Users

Microsoft Excel Dashboards Crash Course for Advanced Users, available at Free, has an average rating of 4.75, with 20 lectures, 3 quizzes, based on 137 reviews, and has 6216 subscribers.

You will learn about Students will build their dashboard formula toolbox by adding functions they may not have known existed before. Students will learn advanced charting skills and turn them inside out to full interactive responsive charts. Students will experiment with various form controls and learn how they can control the charts they created. Students will build a fully functional and interactive dashboard all within Excel without the need to learn another analytic tool. This course is ideal for individuals who are This course is intended for extreme advanced users of the Microsoft Excel product. Someone who has a job in an analytical role and needs to create stunning visuals and KPIs to their team. They must have serious Excel exposure and know how all basic functions work. It is particularly useful for This course is intended for extreme advanced users of the Microsoft Excel product. Someone who has a job in an analytical role and needs to create stunning visuals and KPIs to their team. They must have serious Excel exposure and know how all basic functions work.

Enroll now: Microsoft Excel Dashboards Crash Course for Advanced Users

Summary

Title: Microsoft Excel Dashboards Crash Course for Advanced Users

Price: Free

Average Rating: 4.75

Number of Lectures: 20

Number of Quizzes: 3

Number of Published Lectures: 20

Number of Published Quizzes: 3

Number of Curriculum Items: 23

Number of Published Curriculum Objects: 23

Original Price: Free

Quality Status: approved

Status: Live

What You Will Learn

Students will build their dashboard formula toolbox by adding functions they may not have known existed before.
Students will learn advanced charting skills and turn them inside out to full interactive responsive charts.
Students will experiment with various form controls and learn how they can control the charts they created.
Students will build a fully functional and interactive dashboard all within Excel without the need to learn another analytic tool.

Who Should Attend

This course is intended for extreme advanced users of the Microsoft Excel product. Someone who has a job in an analytical role and needs to create stunning visuals and KPIs to their team. They must have serious Excel exposure and know how all basic functions work.

Target Audiences

This course is intended for extreme advanced users of the Microsoft Excel product. Someone who has a job in an analytical role and needs to create stunning visuals and KPIs to their team. They must have serious Excel exposure and know how all basic functions work.

If you want those fancy dashboards, you see in Power BI, well guess what you can get them here in Microsoft Excel!

Using enhanced Excel functions such as INDEX, MATCH, IFS and many more, I will guide you use a simple Data List feature and form controls to pull out the important data from your tables using advanced functions and combine it with interactive and modified charts all from within Excel.

In this 2-hour crash course, we will cover:

INDEX & MATCH
IFS Functions
LARGE vs SMALL
CHOOSE
Using Bar Charts as a whole vs Pie Charts
Adding Dynamic Vertical Group Bars to Charts
Making your Line Chart Dynamic to Date Ranges
Creating your very first Info Graphics
Using Option Buttons
Using List Box
Using Scroll Bar
Create your Dashboard masterpiece

This course is intense, it’s fast, but it gets the job done. This course is designed for the Advanced Excel user who knows their way around functions and syntax and Excel in general. Although the manual you get with this course is eight chapters long, we only cover four of them in under 2 hours. So, you must know the first three chapters of the manual as well to be able to keep up with the content.

You may have heard of the functions we mentioned enough but you may not of known how their use can lead to stunning visuals and a dashboard all within Excel with no need to jump into Power BI!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course & Instructor Intro

Lecture 2: Support Notes for Students

Lecture 3: Download Course Resources & PDF Manual

Lecture 4: Contacting the Instructor

Lecture 5: Let's Set Some Expectations

Lecture 6: PDF Manual & Video Correlation

Chapter 2: Dashboard Formula Toolbox

Lecture 1: INDEX & MATCH

Lecture 2: The IFS Sisters

Lecture 3: LARGE & SMALL

Lecture 4: CHOOSE vs IF but not over IFS

Chapter 3: Advanced Charting

Lecture 1: To Pie or Not to Pie

Lecture 2: Dynamic Vertical Group Bars

Lecture 3: Dynamic Chart Ranges

Lecture 4: Info Graphics

Chapter 4: Using Form Controls

Lecture 1: Option Buttons

Lecture 2: List Box

Lecture 3: Scroll Bar

Lecture 4: Combo Box

Chapter 5: Creating Your Dashboard

Lecture 1: Putting It All Together

Lecture 2: Instructor Thank You

Instructors

Robin Solonenko
Microsoft Instructor

Rating Distribution

1 stars: 0 votes
2 stars: 2 votes
3 stars: 16 votes
4 stars: 44 votes
5 stars: 75 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu