Askpeople what comes to mind when they think of Excel, and odds are they'll say"spreadsheets".The truthis,Excel isan incrediblypowerful and dynamic data visualizationplatformfor those willing to think beyond rows, columns, and primitive pie charts --andI'm here to prove it.
This course gives you a deep, 100%comprehensive understanding of Excel'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 &graphsintroduced in Excel 2016, including:
Bar & Column charts
Histograms & Pareto charts (Office 365, Excel 2016 or Excel 2019)
Line charts & trend lines
Area charts
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
Chloropleths & Geospatial maps
Custom combo charts & graphs
Sparklines
And more...
From there we'lldive into a series of 12+advanced Exceldemosguaranteed to turn you into an absolute data viz rockstar. These aren't "textbook" demos that you can find on Excel YouTube channels;these are projectsadapted from actual, award-winningworkfeatured by Microsoft, MIT, and the New York Times. I've built my analyticscareer around data visualization, and I can help you do the same.
We'll cover advanced Excel data viz 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 visualizationgame ina major way, this course is for you.
See you there!
-Chris (Founder, Maven Analytics)
__________
Looking for the full business intelligence stack? Search for "Maven Analytics"to browse our full course library, including Excel, Power BI, MySQL, andTableaucourses!
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.
