Microsoft Excel: Data Visualization w/ Excel Charts & Graphs
All LevelsOffice ProductivityExcel

Microsoft Excel: Data Visualization w/ Excel Charts & Graphs

Master 20+ Excel charts & graphs, build custom dashboards, and create advanced spreadsheet visuals w/ a top instructor!

Created by Maven Analytics • 1,500,000 Learners, Chris Dutton
4.5 hours
Video Content
59
Lectures
196,075
Students
4.6
Rating
4.6
(196,075 students enrolled)

What you'll learn

Understand WHEN, WHY, and HOW to use 20+ chart types in Microsoft Excel
Learn advanced Excel tools like automated dashboards, scrolling charts, dynamic formats, and more
Master unique tips, tools and case studies that you won't find in ANY other Excel course, guaranteed
Explore fun, interactive, and highly effective lessons from a best-selling Excel instructor
Get LIFETIME access to project files, quizzes, homework exercises, and 1-on-1 expert support
Build 10+ Excel projects designed to take your data visualization skills to the next level

Course Content

6 sections • 59 lectures • 04:38:04 total length

Getting Started

4 lectures • 06:00

Course Structure & Outline01:18
READ ME: Important Notes for New Students02:13
DOWNLOAD: Course Resources00:27
Setting Expectations02:02

Data Visualization Best Practices

3 lectures • 08:18

Key Visualization Principles & The 10-Second Rule02:45
Good, Bad & Ugly Data Viz03:44
3 Key Questions for Effective Visualization01:49

Excel Chart Formatting & Customization

4 lectures • 18:56

Customizing Chart Elements, Layouts & Styles06:20
Configuring Chart Formats05:27
Changing Chart Types & Adding a Secondary Axis03:03
Creating & Applying Custom Chart Templates04:06
Excel Chart Customization5 questions

Mastering Basic Excel Charts & Graphs

34 lectures • 01:59:42

DEMO: Excel Bar & Columns Charts08:49
HOMEWORK: Bar & Column Charts00:21
DEMO: Excel Histograms & Pareto Charts (Office 365/Excel 2016+)05:58
HOMEWORK: Histograms & Pareto Charts00:16
DEMO: Excel Line Charts & Trendlines05:16
+30 more lectures

Next-Level Demos

13 lectures • 02:03:10

Setting Expectations01:40
DEMO: Creating Custom Image Overlay Charts06:01
DEMO: Using Binary Values to Highlight Time Periods05:02
DEMO: Automating Charts with Named Ranges (OFFSET & COUNTA)07:08
DEMO: Adding Scroll & Zoom Functionality Using Form Controls12:30
+9 more lectures

Wrapping Up

1 lectures • 01:55

BONUS LESSON01:55

Description

Microsoft Excel is an incredibly powerful and dynamic data visualization platform for those willing to think beyond rows, columns, and spreadsheets, and I'm here to prove it.


This course gives you a deep, 100% comprehensive understanding of MS Excel's latest data visualization tools and techniques. I'll show you WHEN, WHY, and HOW to use each Excel chart type, introduce key data visualization best practices, and guide you through interactive, hands-on demos and Excel exercises every step of the way.


We'll kick things off by exploring each of the 20+ charts & graphs in Excel, including: 


  • Bar & Column charts

  • Histograms & Pareto charts (Office 365, Excel 2016 or Excel 2019)

  • Line charts, Area charts & trend lines

  • Pies & Donuts

  • Scatter plots & Bubble charts

  • Box & Whisker charts (Office 365, Excel 2016 or Excel 2019)

  • Tree Maps & Sunbursts (Office 365, Excel 2016 or Excel 2019)

  • Waterfall & Funnel charts (Office 365, Excel 2016 or Excel 2019)

  • Radar & Stock charts

  • Heat maps, 3-D Surface & Contour charts

  • Choropleths & Geospatial maps

  • Custom Combo Charts

  • Sparklines


From there we'll dive into a series of advanced Excel demos guaranteed to turn you into an absolute data visualization and analytics rockstar. These aren't "textbook" demos that you can find on Excel YouTube channels; these are projects and dashboards adapted from actual, award-winning work featured by Microsoft, MIT, and the New York Times.


We'll cover advanced Excel data visualization topics that you won't find anywhere else, including:


  • Custom image overlay charts

  • Automation with named ranges and OFFSET/COUNTA functions

  • Scroll & Zoom functionality with Excel form controls

  • Animated charts to visualize changes over time

  • Dynamic, custom Excel dashboards

  • Value-based chart formatting

  • Custom gauge charts & pacing charts

  • Grid visuals using Excel array formulas


Whether you're looking for a quick primer, trying to diversify your Excel skill set, or hoping to step up your Excel data visualization or business intelligence game in a major way, this course is for you.


See you there!

-Chris (Founder, 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!


Hear why this is one of the TOP-RATED Excel courses on Udemy, and the #1 Excel Data Visualization course:

"Absolutely great stuff. I really enjoyed it! Chris is truly a Excel guru. I strongly recommend this course to all users looking to improve their skills with Excel charts & graphs."

Nirav M.


"Excellent from start to finish! I picked up a bunch of Excel data visualization tips that will be useful in the workplace, including some very cool advanced Excel visuals and custom charts & graphs. Loved all of it, and hope I can learn more from this wonderful individual!"

Robert C.


"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'm definitely buying his other Excel and data visualization courses!"

Judit B.


NOTE: Full course includes downloadable resources and Excel project files, homework and course quizzes, lifetime access and a 30-day money-back guarantee. Most lectures compatible with Excel 2016, Excel 2019 or Office 365.


Who this course is for:

  • Anyone looking to create beautiful and effective data visualizations in Excel
  • MS Excel users who have basic skills but want to master advanced charts, graphs & dashboards
  • Students looking for an engaging, hands-on, and highly interactive approach to training
  • Anyone looking to pursue a career in data analysis, analytics or business intelligence

This course includes:

  • 4.5 hours on-demand video
  • 19 articles
  • 5 downloadable resources
  • Access on mobile and TV
  • Full lifetime access
  • Certificate of completion

Instructors

Maven Analytics • 1,500,000 Learners

Chris Dutton

Students also download

Explore related courses to expand your learning journey.