5.00
(1 Rating)

Microsoft Excel: Advanced Excel Dashboard Design

Categories: MS Excel

About Course

This is a hands-onproject-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.

Show More

What Will You 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

Course Content

Getting Started

Data Viz Best Practices

PROJECT 1: Maven Music

Dashboard Design Principles

PROJECT 2: Maven Careers

PROJECT 3: Maven Toys

PROJECT 4: Maven Hotel Group

Tips for Success

Certification of Completion

Student Ratings & Reviews

5.0
Total 1 Rating
5
1 Rating
4
0 Rating
3
0 Rating
2
0 Rating
1
0 Rating
MA
8 months ago
I wish I can give this course more than 5 stars. This course really exceeds my expectations. Thank you so much.