Udemy - Microsoft Excel - Data Visualization, Excel Charts & Graphs
| Category | : | Others |
| Language | : | ENGLISH |
| Total Size | : | 2 GB |
| Uploaded By | : | GetPaidCourseFree |
| Date uploaded: | : | 02 Mar 2024 |
| Last Update | : | 02 Mar 2024 |
| Total View | : | 43 |
Overview
Master 20+ Excel charts, build advanced Excel visuals & learn data analysis with a best-selling Excel instructor!
What you'll learn:
- Understand WHEN, WHY, and HOW to use 20+ chart types in Excel 2016+
- 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
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 &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 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
