Advanced Excel Dashboard Design

Learn expert-level data visualization & dashboard design skills, and build 3 full-scale Excel dashboards from scratch!

Last updated 2022-01-10 | 4.7

- Build stunning
- professional-quality dashboards in Excel (from scratch!)
- Review key data visualization best practices and dashboard design principles
- Apply powerful techniques for transforming raw data into beautiful
- interactive visuals

What you'll learn

Build stunning
professional-quality dashboards in Excel (from scratch!)
Review key data visualization best practices and dashboard design principles
Apply powerful techniques for transforming raw data into beautiful
interactive visuals
Learn the same tools used by professional business intelligence analysts and data scientists
Work through 4 unique
hands-on course projects

* Requirements

* Microsoft Excel
* ideally Office 365 for PC
* Mac users are welcome to join
* but may have difficulty following along

Description

This is a hands-on, project-based course designed to teach you key visualization and design principles, along with powerful techniques for creating dynamic, interactive Excel reports and dashboards.


We'll start by reviewing data visualization best practices, including tips for selecting the right visuals, eliminating clutter, focusing attention, and telling data-driven stories. From there we'll introduce dashboard design principles, and share frameworks for defining clear objectives, identifying effective metrics and visual elements, and leveraging concepts like reading patterns and Gestalt principles to optimize layout and flow.


Throughout the course you'll practice applying these techniques to unique, real-world projects and scenarios:


  • Maven Music

    • Create a visual showing the evolution of the music industry and the impact of digital formats


  • Maven Careers

    • Build a dashboard to explore salary and employment data across key industries in the US


  • Maven Toys

    • Design a monthly KPI dashboard for sales managers to track regional performance


  • Maven Hotel Group

    • Visualize hotel booking data to show key cancellation patterns and business insights


By the end of the course, not only will you have unique, professional-quality Excel dashboards to add to your portfolio, but you'll have gained the knowledge and confidence to apply these same concepts to your own work.


If you're ready to build the exact skills you need to create stunning, professional-quality dashboards in Excel, this is the course for you!


Join today and get immediate, lifetime access to the following:

  • 6+ hours of high-quality video

  • Dashboard Design PDF ebook

  • Downloadable Excel project files & solutions

  • Expert support and Q&A forum

  • 30-day money-back guarantee


Happy learning!

-Enrique (Certified Excel Expert & Instructor, Maven Analytics)


__________

See why our Excel courses are some of the TOP-RATED on Udemy:

"At the first part I just said to myself, 'Wow, Excel is capable of that? It's amazing!' Then at the second part I told myself 'This guy is doing magic!', and now I feel like I'm capable of doing the same. I can't wait to dive into the other courses!"

- Judit B.

"Excellent from start to finish. I picked up a bunch of techniques that will be useful in the workplace, from new chart templates to some very cool advanced visualizations. I loved all of it!"

- Robert C.

"Excellent material that I apply to my daily use of Excel. I consider myself an Excel professional, yet I picked up dozens of new tips and techniques. Wonderful course, well-presented and well-explained."

- Jeffrey P.

__________

Who this course is for:

  • Excel users looking to bring their data to life with dynamic, interactive reports and dashboards
  • Analysts, Data Scientists, or BI professionals who want to develop expert-level data visualization and design skills
  • Anyone who wants to learn how to tell clear and compelling stories with data
  • Students looking to learn powerful, practical skills with hands-on projects and demos

Course content

8 sections • 80 lectures

Course Structure & Outline Preview 01:52

READ ME: Important Notes for New Students Preview 02:13

DOWNLOAD: Course Resources Preview 00:07

Setting Expectations Preview 02:45

The Course Projects Preview 02:33

Introduction Preview 01:39

Data Viz 101 Preview 01:43

The 10-Second Rule Preview 02:23

The 3 Key Questions Preview 02:45

Essential Visuals Preview 05:49

Chart Formatting Tips Preview 04:26

Storytelling with Data Preview 01:35

Common Visualization Mistakes Preview 05:15

BEST PRACTICES: Data Visualization Preview 01:06

Data Visualization

Project Brief Preview 01:46

Selecting an Effective Chart Type

Creating the Chart in Excel Preview 04:00

Applying Chart Formatting Preview 08:58

Telling the Story Preview 09:53

Introduction Preview 01:40

Dashboards 101 Preview 01:03

Types of Dashboards Preview 01:57

Defining a Purpose Preview 02:14

Visual Elements Preview 02:35

Adding Context Preview 02:28

Dashboard Layouts Preview 02:35

BEST PRACTICES: Dashboard Design Preview 01:12

Dashboard Design

Project Brief Preview 02:12

Defining the Purpose & Visuals

Preparing the Filters & Interactivity Preview 05:55

Using AVERAGEIFS for Conditional Calculations Preview 06:09

Creating a Bar Chart Preview 03:20

PRO TIP: Sorting Based on Formulas Preview 02:51

Creating a Donut Chart Preview 04:52

PRO TIP: Grouping Donut Slices Preview 05:01

Creating a Combo Chart Preview 08:51

PRO TIP: Splitting Combo Chart Elements Preview 11:19

Creating a Filled Map Preview 04:10

PRO TIP: Adding New Data with Data Types Preview 05:46

PRO TIP: Switching Between Series in a Map Preview 10:18

Setting Up the Dashboard Layout Preview 16:28

Using Color Strategically Preview 06:06

PRO TIP: Dynamically Highlighting Series Preview 06:16

PRO TIP: Inserting Form Controls Preview 13:09

Creating Custom Color Themes Preview 03:17

Protecting the Dashboard Preview 05:10

Project Brief Preview 02:23

Defining the Purpose & Visuals

Preparing for Scale Preview 09:38

PRO TIP: Using Name Manager for Filter Values Preview 02:24

Calculating KPIs Preview 06:42

Applying Conditional Formatting Rules Preview 03:25

PRO TIP: Inserting Linked Pictures Preview 01:47

PRO TIP: Using Absolute Structured References Preview 05:58

Creating a Line Chart Preview 05:37

PRO TIP: Hiding Zero Values in a Line Chart Preview 02:32

Creating Complementary Bar Charts Preview 08:35

PRO TIP: Dynamically Sorting Data Preview 10:34

Creating Top/Bottom Tables Preview 08:37

Setting Up the Dashboard Layout Preview 21:07

Using Color Strategically Preview 14:08

Using the Titles to Tell a Story Preview 07:16

Sharing the Dashboard Online Preview 04:21

PRO TIP: Formula Based Formatting Preview 07:40

Project Brief Preview 02:30

Understanding the Story Preview 04:02

Defining the Purpose & Visuals

Visualizing Seasonality with a Combo Chart Preview 09:38

Contrasting Gains & Losses with a Column Chart Preview 06:02

PRO TIP: Conditional Custom Number Formats Preview 02:14

PRO TIP: Using Stacked Bars Instead of Pies Preview 02:43

PRO TIP: Visualizing Part of a PivotTable Preview 04:17

Setting Up the Dashboard Layout Preview 12:23

Using Text to Tell a Story Preview 10:53

PRO TIP: Saving the Dashboard as an Image Preview 02:19