Microsoft Excel: Advanced Excel Dashboard Design
- Offered byUDEMY
Microsoft Excel: Advanced Excel Dashboard Design at UDEMY Overview
Duration | 6 hours |
Total fee | ₹399 |
Mode of learning | Online |
Credential | Certificate |
Microsoft Excel: Advanced Excel Dashboard Design at UDEMY Highlights
- 30-Day Money-Back Guarantee
- Certificate of completion
- Full lifetime access
- Learn from 6 downloadable resources and 3 articles
Microsoft Excel: Advanced Excel Dashboard Design at UDEMY Course details
- 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
- 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 MusicCreate a visual showing the evolution of the music industry and the impact of digital formatsMaven CareersBuild a dashboard to explore salary and employment data across key industries in the USMaven ToysDesign a monthly KPI dashboard for sales managers to track regional performance Maven Hotel GroupVisualize hotel booking data to show key cancellation patterns and business insightsBy 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 videoDashboard Design PDF ebookDownloadable Excel project files & solutionsExpert support and Q&A forum30-day money-back guaranteeHappy learning!-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.__________
Microsoft Excel: Advanced Excel Dashboard Design at UDEMY Curriculum
Getting Started
Course Structure & Outline
READ ME: Important Notes for New Students
DOWNLOAD: Course Resources
Setting Expectations
The Course Projects
Data Viz Best Practices
Introduction
Data Viz 101
The 10-Second Rule
The 3 Key Questions
Essential Visuals
Chart Formatting Tips
Storytelling with Data
Common Visualization Mistakes
BEST PRACTICES: Data Visualization
Data Visualization
PROJECT 1: Maven Music
Project Brief
Selecting an Effective Chart Type
Creating the Chart in Excel
Applying Chart Formatting
Telling the Story
Dashboard Design Principles
Introduction
Dashboards 101
Types of Dashboards
Defining a Purpose
Visual Elements
Adding Context
Dashboard Layouts
BEST PRACTICES: Dashboard Design
Dashboard Design
PROJECT 2: Maven Careers
Project Brief
Defining the Purpose & Visuals
Preparing the Filters & Interactivity
Using AVERAGEIFS for Conditional Calculations
Creating a Bar Chart
PRO TIP: Sorting Based on Formulas
Creating a Donut Chart
PRO TIP: Grouping Donut Slices
Creating a Combo Chart
PRO TIP: Splitting Combo Chart Elements
Creating a Filled Map
PRO TIP: Adding New Data with Data Types
PRO TIP: Switching Between Series in a Map
Setting Up the Dashboard Layout
Using Color Strategically
PRO TIP: Dynamically Highlighting Series
PRO TIP: Inserting Form Controls
Creating Custom Color Themes
Protecting the Dashboard
PROJECT 3: Maven Toys
Project Brief
Defining the Purpose & Visuals
Preparing for Scale
PRO TIP: Using Name Manager for Filter Values
Calculating KPIs
Applying Conditional Formatting Rules
PRO TIP: Inserting Linked Pictures
PRO TIP: Using Absolute Structured References
Creating a Line Chart
PRO TIP: Hiding Zero Values in a Line Chart
Creating Complementary Bar Charts
PRO TIP: Dynamically Sorting Data
Creating Top/Bottom Tables
Setting Up the Dashboard Layout
Using Color Strategically
Using the Titles to Tell a Story
Sharing the Dashboard Online
PRO TIP: Formula Based Formatting
PROJECT 4: Maven Hotel Group
Project Brief
Understanding the Story
Defining the Purpose & Visuals
Visualizing Seasonality with a Combo Chart
Contrasting Gains & Losses with a Column Chart
PRO TIP: Conditional Custom Number Formats
PRO TIP: Using Stacked Bars Instead of Pies
PRO TIP: Visualizing Part of a PivotTable
Setting Up the Dashboard Layout
Using Text to Tell a Story
PRO TIP: Saving the Dashboard as an Image
Tips for Success
Tips for Success
Helpful Resources
BONUS LESSON
Microsoft Excel: Advanced Excel Dashboard Design at UDEMY Faculty details
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?