image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

Description

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 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 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 Learning
courses!
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

What you'll 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

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Getting Started
5
1.1-Course Structure & Outline
1.2-READ ME: Important Notes for New Students
1.3-DOWNLOAD: Course Resources
1.4-Setting Expectations
1.5-The Course Projects
2-Data Viz Best Practices
10
2.1-Introduction
2.2-Data Viz 101
2.3-The 10-Second Rule
2.4-The 3 Key Questions
2.5-Essential Visuals
2.6-Chart Formatting Tips
2.7-Storytelling with Data
2.8-Common Visualization Mistakes
2.9-BEST PRACTICES: Data Visualization
2.10-Data Visualization
3-PROJECT 1: Maven Music
5
3.1-Project Brief
3.2-Selecting an Effective Chart Type
3.3-Creating the Chart in Excel
3.4-Applying Chart Formatting
3.5-Telling the Story
4-Dashboard Design Principles
9
4.1-Introduction
4.2-Dashboards 101
4.3-Types of Dashboards
4.4-Defining a Purpose
4.5-Visual Elements
4.6-Adding Context
4.7-Dashboard Layouts
4.8-BEST PRACTICES: Dashboard Design
4.9-Dashboard Design
5-PROJECT 2: Maven Careers
19
5.1-Project Brief
5.2-Defining the Purpose & Visuals
5.3-Preparing the Filters & Interactivity
5.4-Using AVERAGEIFS for Conditional Calculations
5.5-Creating a Bar Chart
5.6-PRO TIP: Sorting Based on Formulas
5.7-Creating a Donut Chart
5.8-PRO TIP: Grouping Donut Slices
5.9-Creating a Combo Chart
5.10-PRO TIP: Splitting Combo Chart Elements
5.11-Creating a Filled Map
5.12-PRO TIP: Adding New Data with Data Types
5.13-PRO TIP: Switching Between Series in a Map
5.14-Setting Up the Dashboard Layout
5.15-Using Color Strategically
5.16-PRO TIP: Dynamically Highlighting Series
5.17-PRO TIP: Inserting Form Controls
5.18-Creating Custom Color Themes
5.19-Protecting the Dashboard
6-PROJECT 3: Maven Toys
18
6.1-Project Brief
6.2-Defining the Purpose & Visuals
6.3-Preparing for Scale
6.4-PRO TIP: Using Name Manager for Filter Values
6.5-Calculating KPIs
6.6-Applying Conditional Formatting Rules
6.7-PRO TIP: Inserting Linked Pictures
6.8-PRO TIP: Using Absolute Structured References
6.9-Creating a Line Chart
6.10-PRO TIP: Hiding Zero Values in a Line Chart
6.11-Creating Complementary Bar Charts
6.12-PRO TIP: Dynamically Sorting Data
6.13-Creating Top/Bottom Tables
6.14-Setting Up the Dashboard Layout
6.15-Using Color Strategically
6.16-Using the Titles to Tell a Story
6.17-Sharing the Dashboard Online
6.18-PRO TIP: Formula Based Formatting
7-PROJECT 4: Maven Hotel Group
11
7.1-Project Brief
7.2-Understanding the Story
7.3-Defining the Purpose & Visuals
7.4-Visualizing Seasonality with a Combo Chart
7.5-Contrasting Gains & Losses with a Column Chart
7.6-PRO TIP: Conditional Custom Number Formats
7.7-PRO TIP: Using Stacked Bars Instead of Pies
7.8-PRO TIP: Visualizing Part of a PivotTable
7.9-Setting Up the Dashboard Layout
7.10-Using Text to Tell a Story
7.11-PRO TIP: Saving the Dashboard as an Image
8-Tips for Success
3
8.1-Tips for Success
8.2-Helpful Resources
8.3-BONUS LESSON