Advanced Excel Dashboard Design

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 the dashboard design process, 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. You'll design a custom visual for a music magazine, build a dashboard to help students research career paths, create a monthly report for regional managers at a toy company, and help a hotel chain bring their data and insights to life.

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.

COURSE CURRICULUM:

WHO SHOULD TAKE THIS COURSE?

• 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

WHAT ARE THE COURSE REQUIREMENTS?

• Microsoft Excel, ideally 2016+ or Office 365 for PC

• Mac users are welcome to join, but may have difficulty following along