Microsoft Excel: Advanced Excel Dashboard Design
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
- Microsoft Excel, ideally Office 365 for PC
- Mac users are welcome to join, but may have difficulty following along
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:
Create a visual showing the evolution of the music industry and the impact of digital formats
Build a dashboard to explore salary and employment data across key industries in the US
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
-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
Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience.
Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.
Learning new skills shouldn’t be complicated. Think of Maven as your personal team of instructors, experts, mentors and guides, helping you navigate the learning process and develop the skills you need, on-demand.
Enrique is a certified Microsoft Excel Expert and top-rated instructor with a background in business intelligence, data analysis, and visualization.
He has been producing advanced Excel and test prep courses at Maven Analytics since 2016, along with adaptations tailored to Spanish-speaking learners.
A leader in analytics education, Maven Analytics empowers everyday people to change the world with data.