Udemyexperten

Microsoft Excel Dashboards Crash Course for Advanced Users

Excel dashboards crash course: Create interactive visuals in just 2 hours! Learn to build stunning dashboards within Excel. Boost your data presentation skills.

4.6(358)
9,109students
1h 38m
Robin Solonenko
Robin SolonenkoMicrosoft Instructor

Course Content

Microsoft Excel Dashboards Crash Course for Advanced Users is an advanced Udemy course taught by Robin Solonenko. It runs 1h 38m and is taught in English. Learners rate it 4.6 out of 5 from 358 reviews, with 9,109 students enrolled. It is free to enroll, first published November 2022.

Unlock Powerful Dashboards in Excel: A 2-Hour Crash Course

Want to create impressive dashboards like those in Power BI, but prefer to work within Microsoft Excel? This intensive, fast-paced course will show you how to achieve stunning data visualization and interactive dashboards – all without needing to switch to a different program.

Learn to leverage enhanced Excel functions like INDEX, MATCH, IFS, and more to extract key data from your tables using a simple Data List feature and form controls. We'll combine these advanced functions with interactive charts to build compelling dashboards directly within Excel.

In this 2-hour crash course, you'll master:

  • INDEX & MATCH Functions: Efficiently retrieve data based on multiple criteria.
  • IFS Functions: Create complex conditional logic for data extraction.
  • LARGE vs. SMALL: Quickly identify top and bottom values in your datasets.
  • CHOOSE Function: Dynamically select data based on a chosen option.
  • Bar Charts vs. Pie Charts: Understand when to use each chart type for optimal data representation.
  • Dynamic Vertical Group Bars: Create visually engaging and informative charts.
  • Dynamic Line Charts for Date Ranges: Build charts that automatically update based on selected date ranges.
  • Creating Info Graphics: Transform data into easily digestible visual stories.
  • Option Buttons: Enable user interaction and data filtering.
  • List Box: Provide users with a dropdown selection for data filtering.
  • Scroll Bar: Improve usability for large datasets.

By the end of this course, you'll be able to create your very own dashboard masterpiece in Excel.

Important Note: This course is designed for Advanced Excel users who are already comfortable with Excel functions and syntax. While the included manual is eight chapters long, we focus on four key chapters to deliver a comprehensive dashboarding experience in under two hours. Familiarity with the first three chapters of the manual is recommended to maximize your learning. You may have encountered these functions before, but this course reveals how to use them to create truly impactful visuals and dashboards – all within Excel, eliminating the need for Power BI.

$ whoami — the devs behind tutorialsearch.io

Need a web app built? Hire the team behind TutorialSearch.io

We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.

5.0(234)
1h 36m
all
skillshare
skillshare
5.0(122)
3h 38m
all
skillshare
5.0(437)
3h 15m
all
skillshare
5.0
beginner
pluralsight