Microsoft Excel: Data Visualization w/ Excel Charts & Graphs

Master Excel data visualization with 20+ charts and dashboards. Enhance your skills with advanced techniques and hands-on demos from an expert instructor.

  • Overview
  • Curriculum
  • Instructor
  • Review

Brief Summary

This course will transform your Excel skills by teaching you over 20 types of charts and advanced visual techniques. You'll dive into interactive demos and practical applications that make data visualization fun and effective.

Key Points

  • Master 20+ Excel chart types including bar, line, and pie charts.
  • Create advanced, custom dashboards and visuals.
  • Learn the best practices for data visualization.
  • Hands-on demos and exercises for practical learning.
  • Advanced topics like animated charts and grid visuals.

Learning Outcomes

  • Understand when and how to use various Excel charts.
  • Create dynamic and customized dashboards.
  • Utilize advanced Excel tools and techniques for better data analysis.
  • Apply best practices in data visualization to your projects.
  • Gain confidence in presenting data visually with unique tips.

About This Course

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

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.


  • 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

Course Curriculum

1 Lectures

Instructors

Profile photo of Chris Dutton
Chris Dutton

Chris Dutton is an EdTech entrepreneur and best-selling Data Analytics instructor.As Founder and Chief Product Officer at Maven Analytics, his work has been featured by USA Today, Business Insider, Entrepreneur and the New York Times, reaching more than 1,000,000 students around the world. Maven Analytics was named one of the top 10 education companies revolutionizing the industry, and is the...

Instructors

Profile photo of Maven Analytics
Maven Analytics

Maven Analytics empowers everyday people with life-changing data & AI skills.Named one of the top education companies revolutionizing the industry, our unique Guided Learning model helps individuals and teams build new skills, showcase their work, and connect with peers and experts around the world.We've helped 1,000,000+ students build job-ready skills, master tools like Excel, SQL, Power BI, Tableau and Python,...

Review
4.9 course rating
4K ratings
ui-avatar of Arvind Kumar
Arvind K.
5.0
7 months ago

Hello team. It is an amazing platform where everyone can hone their skills. thanks team

  • Helpful
  • Not helpful
ui-avatar of Andrew Pettitt
Andrew P.
4.0
7 months ago

Good. but was expecting some information on error bars.

  • Helpful
  • Not helpful
ui-avatar of Lia Fischer
Lia F.
4.5
7 months ago

so far easy to follow

  • Helpful
  • Not helpful
ui-avatar of Jennifer Toleafoa
Jennifer T.
5.0
7 months ago

This training has very informative information that applies to my employment role.

  • Helpful
  • Not helpful
ui-avatar of Zhang yan
Zhang Y.
5.0
7 months ago

Amazing ,easy to understand and good tool to use.

  • Helpful
  • Not helpful
ui-avatar of Darlene Galit
Darlene G.
5.0
7 months ago

I have learned a lot in this course

  • Helpful
  • Not helpful
ui-avatar of Mapulane Majoro
Mapulane M.
4.5
7 months ago

It is a good match for me as i work with graphs and have to analyze data and present the MI to stakeholders

  • Helpful
  • Not helpful
ui-avatar of Pam Jahnke
Pam J.
5.0
7 months ago

Great course! Really broke things down and made it easy and fun to create charts and graphs. I'm excited to apply the things I learned into my reports for work. The instructor was easy to understand and provided just the right amount of information to make it interesting without being too simple or too advanced. I'm going to take more courses from him.

  • Helpful
  • Not helpful
ui-avatar of Mark A. Johnson
Mark A. J.
5.0
7 months ago

I learned the basics about the design of the chart and then the formatting of the elements of the chart along with the quick layout - this falls under chart design.

  • Helpful
  • Not helpful
ui-avatar of Maksym Tretiakov
Maksym T.
5.0
7 months ago

I have done all excel courses with Chris , and now it is time for the data VIZ.
As usual nice and clear, enjoying another course with great instructor.

  • Helpful
  • Not helpful
Leave A Reply

Your email address will not be published. Required fields are marked *

Ratings

Courses You May Like

Lorem ipsum dolor sit amet elit
Show More Courses