Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

Microsoft Excel: Data Visualization w/ Excel Charts & Graphs

via Udemy

Overview

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

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

Microsoft Excel isan incrediblypowerful and dynamic data visualizationplatformfor those willing to think beyond rows, columns, and spreadsheets,andI'm here to prove it.


This course gives you a deep, 100%comprehensive understanding of MSExcel's latestdata visualization tools and techniques. I'll show you WHEN, WHY, and HOW to use each Excel chart type, introduce keydata visualization best practices,and guide you throughinteractive, hands-on demos and Excel exercisesevery step of the way.


We'll kick things off by exploring each of the 20+charts &graphsin 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-DSurface & Contour charts

  • Choropleths & Geospatial maps

  • Custom Combo Charts

  • Sparklines


From there we'lldive into a series of advanced Exceldemosguaranteed 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 projectsand dashboards adapted from actual, award-winningworkfeatured 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/COUNTAfunctions

  • 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 quickprimer, trying to diversifyyour Excelskill set, or hopingto step up your Excel data visualizationor business intelligence game ina 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-RATEDExcel 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 advancedExcel visuals and custom charts &graphs. Loved all of it, and hope Ican 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.


Taught by

Maven Analytics and Chris Dutton

Reviews

4.6 rating at Udemy based on 51294 ratings

Start your review of Microsoft Excel: Data Visualization w/ Excel Charts & Graphs

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.