Microsoft Excel: Advanced Excel Dashboard Design

Microsoft Excel: Advanced Excel Dashboard Design

English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 74 lectures (6h 24m) | 2.81 GB

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

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!

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
Table of Contents

Getting Started
1 Course Structure & Outline
2 READ ME Important Notes for New Students
3 DOWNLOAD Course Resources
4 Setting Expectations
5 The Course Projects

Data Viz Best Practices
6 Introduction
7 Data Viz 101
8 The 10-Second Rule
9 The 3 Key Questions
10 Essential Visuals
11 Chart Formatting Tips
12 Storytelling with Data
13 Common Visualization Mistakes
14 BEST PRACTICES Data Visualization

PROJECT 1 Maven Music
15 Project Brief
16 Creating the Chart in Excel
17 Applying Chart Formatting
18 Telling the Story

Dashboard Design Principles
19 Introduction
20 Dashboards 101
21 Types of Dashboards
22 Defining a Purpose
23 Visual Elements
24 Adding Context
25 Dashboard Layouts
26 BEST PRACTICES Dashboard Design

PROJECT 2 Maven Careers
27 Project Brief
28 Preparing the Filters & Interactivity
29 Using AVERAGEIFS for Conditional Calculations
30 Creating a Bar Chart
31 PRO TIP Sorting Based on Formulas
32 Creating a Donut Chart
33 PRO TIP Grouping Donut Slices
34 Creating a Combo Chart
35 PRO TIP Splitting Combo Chart Elements
36 Creating a Filled Map
37 PRO TIP Adding New Data with Data Types
38 PRO TIP Switching Between Series in a Map
39 Setting Up the Dashboard Layout
40 Using Color Strategically
41 PRO TIP Dynamically Highlighting Series
42 PRO TIP Inserting Form Controls
43 Creating Custom Color Themes
44 Protecting the Dashboard

PROJECT 3 Maven Toys
45 Project Brief
46 Preparing for Scale
47 PRO TIP Using Name Manager for Filter Values
48 Calculating KPIs
49 Applying Conditional Formatting Rules
50 PRO TIP Inserting Linked Pictures
51 PRO TIP Using Absolute Structured References
52 Creating a Line Chart
53 PRO TIP Hiding Zero Values in a Line Chart
54 Creating Complementary Bar Charts
55 PRO TIP Dynamically Sorting Data
56 Creating TopBottom Tables
57 Setting Up the Dashboard Layout
58 Using Color Strategically
59 Using the Titles to Tell a Story
60 Sharing the Dashboard Online
61 PRO TIP Formula Based Formatting

PROJECT 4 Maven Hotel Group
62 Project Brief
63 Understanding the Story
64 Visualizing Seasonality with a Combo Chart
65 Contrasting Gains & Losses with a Column Chart
66 PRO TIP Conditional Custom Number Formats
67 PRO TIP Using Stacked Bars Instead of Pies
68 PRO TIP Visualizing Part of a PivotTable
69 Setting Up the Dashboard Layout
70 Using Text to Tell a Story
71 PRO TIP Saving the Dashboard as an Image

Tips for Success
72 Tips for Success
73 Helpful Resources