Microsoft Excel: Excel Data Visualization & Dashboard Design
Microsoft Excel: Excel Data Visualization & Dashboard Design, available at $94.99, has an average rating of 4.63, with 74 lectures, 6 quizzes, based on 2249 reviews, and has 13599 subscribers.
You will learn about Build stunning, professional-quality dashboards in MS 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 data analysts, data scientists and business intelligence professionals Work through 4 unique, hands-on course projects in Excel This course is ideal for individuals who are Excel users looking to bring their data to life with dynamic, interactive reports and dashboards or Analysts, Data Scientists, or BI professionals who want to develop expert-level data visualization and design skills or Anyone who wants to learn how to tell clear and compelling stories with data or Students looking to learn powerful, practical skills with hands-on projects and demos It is particularly useful for Excel users looking to bring their data to life with dynamic, interactive reports and dashboards or Analysts, Data Scientists, or BI professionals who want to develop expert-level data visualization and design skills or Anyone who wants to learn how to tell clear and compelling stories with data or Students looking to learn powerful, practical skills with hands-on projects and demos.
Enroll now: Microsoft Excel: Excel Data Visualization & Dashboard Design
Summary
Title: Microsoft Excel: Excel Data Visualization & Dashboard Design
Price: $94.99
Average Rating: 4.63
Number of Lectures: 74
Number of Quizzes: 6
Number of Published Lectures: 74
Number of Published Quizzes: 6
Number of Curriculum Items: 80
Number of Published Curriculum Objects: 80
Original Price: $129.99
Quality Status: approved
Status: Live
What You Will Learn
- Build stunning, professional-quality dashboards in MS 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 data analysts, data scientists and business intelligence professionals
- Work through 4 unique, hands-on course projects in Excel
Who Should Attend
- 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
Target Audiences
- 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
This is a hands-on, project-based course designed to teach you advanced data analytics, data visualization and storytelling principles, along with powerful techniques for creating dynamic, interactive Microsoft 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 data analysis and visualization techniques to a series of unique, real-world projectsand 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 MS Excel dashboards to add to your portfolio, but you’ll have gained the knowledge and confidence to apply these same concepts to your own spreadsheets.
If you’re ready to build the exact skills you need to create stunning, high-quality spreadsheets and 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)
__________
Looking for our full course library? Search “Maven Analytics” to browse our full collection of Excel, Power BI, SQL, Tableau, Python, Alteryx & Machine Learningcourses!
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.
__________
Course Curriculum
Chapter 1: Getting Started
Lecture 1: Course Structure & Outline
Lecture 2: READ ME: Important Notes for New Students
Lecture 3: DOWNLOAD: Course Resources
Lecture 4: Setting Expectations
Lecture 5: The Course Projects
Chapter 2: Data Viz Best Practices
Lecture 1: Introduction
Lecture 2: Data Viz 101
Lecture 3: The 10-Second Rule
Lecture 4: The 3 Key Questions
Lecture 5: Essential Visuals
Lecture 6: Chart Formatting Tips
Lecture 7: Storytelling with Data
Lecture 8: Common Visualization Mistakes
Lecture 9: BEST PRACTICES: Data Visualization
Chapter 3: PROJECT 1: Maven Music
Lecture 1: Project Brief
Lecture 2: Creating the Chart in Excel
Lecture 3: Applying Chart Formatting
Lecture 4: Telling the Story
Chapter 4: Dashboard Design Principles
Lecture 1: Introduction
Lecture 2: Dashboards 101
Lecture 3: Types of Dashboards
Lecture 4: Defining a Purpose
Lecture 5: Visual Elements
Lecture 6: Adding Context
Lecture 7: Dashboard Layouts
Lecture 8: BEST PRACTICES: Dashboard Design
Chapter 5: PROJECT 2: Maven Careers
Lecture 1: Project Brief
Lecture 2: Preparing the Filters & Interactivity
Lecture 3: Using AVERAGEIFS for Conditional Calculations
Lecture 4: Creating a Bar Chart
Lecture 5: PRO TIP: Sorting Based on Formulas
Lecture 6: Creating a Donut Chart
Lecture 7: PRO TIP: Grouping Donut Slices
Lecture 8: Creating a Combo Chart
Lecture 9: PRO TIP: Splitting Combo Chart Elements
Lecture 10: Creating a Filled Map
Lecture 11: PRO TIP: Adding New Data with Data Types
Lecture 12: PRO TIP: Switching Between Series in a Map
Lecture 13: Setting Up the Dashboard Layout
Lecture 14: Using Color Strategically
Lecture 15: PRO TIP: Dynamically Highlighting Series
Lecture 16: PRO TIP: Inserting Form Controls
Lecture 17: Creating Custom Color Themes
Lecture 18: Protecting the Dashboard
Chapter 6: PROJECT 3: Maven Toys
Lecture 1: Project Brief
Lecture 2: Preparing for Scale
Lecture 3: PRO TIP: Using Name Manager for Filter Values
Lecture 4: Calculating KPIs
Lecture 5: Applying Conditional Formatting Rules
Lecture 6: PRO TIP: Inserting Linked Pictures
Lecture 7: PRO TIP: Using Absolute Structured References
Lecture 8: Creating a Line Chart
Lecture 9: PRO TIP: Hiding Zero Values in a Line Chart
Lecture 10: Creating Complementary Bar Charts
Lecture 11: PRO TIP: Dynamically Sorting Data
Lecture 12: Creating Top/Bottom Tables
Lecture 13: Setting Up the Dashboard Layout
Lecture 14: Using Color Strategically
Lecture 15: Using the Titles to Tell a Story
Lecture 16: Sharing the Dashboard Online
Lecture 17: PRO TIP: Formula Based Formatting
Chapter 7: PROJECT 4: Maven Hotel Group
Lecture 1: Project Brief
Lecture 2: Understanding the Story
Lecture 3: Visualizing Seasonality with a Combo Chart
Lecture 4: Contrasting Gains & Losses with a Column Chart
Lecture 5: PRO TIP: Conditional Custom Number Formats
Lecture 6: PRO TIP: Using Stacked Bars Instead of Pies
Lecture 7: PRO TIP: Visualizing Part of a PivotTable
Lecture 8: Setting Up the Dashboard Layout
Lecture 9: Using Text to Tell a Story
Lecture 10: PRO TIP: Saving the Dashboard as an Image
Chapter 8: Tips for Success
Lecture 1: Tips for Success
Lecture 2: Helpful Resources
Lecture 3: BONUS LESSON
Instructors
-
Maven Analytics
Empowering everyday people with life-changing data skills -
Enrique Ruiz
Certified Microsoft Excel Expert
Rating Distribution
- 1 stars: 11 votes
- 2 stars: 14 votes
- 3 stars: 115 votes
- 4 stars: 654 votes
- 5 stars: 1455 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024