Microsoft Excel - Data Visualization, Excel Charts & Graphs
4.7 /5- Offered byUDEMY
Microsoft Excel - Data Visualization, Excel Charts & Graphs at UDEMY Overview
Duration | 5 hours |
Total fee | ₹11,200 |
Mode of learning | Online |
Difficulty level | Intermediate |
Official Website | Go to Website  |
Credential | Certificate |
Microsoft Excel - Data Visualization, Excel Charts & Graphs at UDEMY Highlights
- Compatible on Mobile and TV
- Earn a Cerificate on successful completion
- Get Full Lifetime Access
- Course Instructor: Maven Analytics
Microsoft Excel - Data Visualization, Excel Charts & Graphs at UDEMY Course details
- Anyone looking to create beautiful and effective data visualizations in Excel
- 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 or business intelligence
- 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
- 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. __________ FULL COURSE DESCRIPTION: Ask people what comes to mind when they think of Excel, and odds are they'll say " spreadsheets". The truth is, Excel is an incredibly powerful and dynamic data visualization platform for those willing to think beyond rows, columns, and primitive pie charts -- and I'm here to prove it. This course gives you a deep, 100% comprehensive understanding of 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 introduced 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-D Surface & contour charts Chloropleths & Geospatial maps Custom combo charts & graphs Sparklines And more... __________ From there we'll dive into a series of 12+ advanced Excel demos guaranteed to turn you into an absolute data viz rockstar. These aren't "textbook" demos that you can find on Excel YouTube channels; these are projects adapted from actual, award-winning work featured by Microsoft, MIT, and the New York Times . I've built my analytics career 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/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 game in a major way, this course is for you. See you there! -Chris ( Founder, Excel Maven & Maven Analytics ) __________ NOTE: Full course includes downloadable resources and Excel project files , homework and course quizzes , lifetime access and a 30-day money-back guarantee . __________ P. S. Looking to master the full Excel + Power BI stack? Complete the path below and emerge an analytics ROCKSTAR: Excel Pro Tips for Power Users Advanced Excel Formulas & Functions Data Visualization with Excel Charts & Graphs Data Analysis with Excel PivotTables Excel Power Query, Power Pivot & DAX Up & Running with Power BI Desktop Publishing to Power BI Service Looking for the Spanish version of this Excel course? Search for Microsoft Excel - Visualizacin de Datos y Gr?�???�???�???�??°ficos by Chris Dutton and Enrique Ruiz Tapia, with fully translated videos, slides, and Excel datasets!
Microsoft Excel - Data Visualization, Excel Charts & Graphs at UDEMY Curriculum
Getting Started
Course Structure & Outline
READ ME: Important Notes for New Students
DOWNLOAD: Course Resources
Setting Expectations
Data Visualization Best Practices
Key Visualization Principles & The 10-Second Rule
Good, Bad & Ugly Data Viz
3 Key Questions for Effective Visualization
Excel Chart Formatting & Customization
Customizing Chart Elements, Layouts & Styles
Configuring Chart Formats
Changing Chart Types & Adding a Secondary Axis
Creating & Applying Custom Chart Templates
Mastering Basic Excel Charts & Graphs
DEMO: Excel Bar & Columns Charts
HOMEWORK: Bar & Column Charts
DEMO: Excel Histograms & Pareto Charts (Office 365/Excel 2016+)
PRO TIP: "Hacking" a Histogram using FREQUENCY
HOMEWORK: Histograms & Pareto Charts
DEMO: Excel Line Charts & Trendlines
HOMEWORK: Line Charts & Trendlines
DEMO: Excel Area Charts
HOMEWORK: Area Charts
DEMO: Excel Pie Charts, Donuts & Race Tracks
HOMEWORK: Pies, Donuts & Race Tracks
DEMO: Excel Scatter Plots
DEMO: Excel Bubble Charts
HOMEWORK: Scatter Plots & Bubble Charts
DEMO: Excel Box & Whisker Charts (Office 365/Excel 2016+)
HOMEWORK: Box & Whisker Charts
DEMO: Excel Tree Maps & Sunburst Charts (Office 365/Excel 2016+)
HOMEWORK: Tree Maps & Sunburst Charts
DEMO: Excel Waterfall Charts (Office 365/Excel 2016+)
DEMO: Excel Funnel Charts (Office 365/Excel 2016+)
HOMEWORK: Waterfall & Funnel Charts
DEMO: Excel Radar Charts
HOMEWORK: Radar Charts
DEMO: Excel Stock Charts
HOMEWORK: Stock Charts
DEMO: Excel Heat Maps with Conditional Formatting
HOMEWORK: Heat Maps
DEMO: Excel Surface & 3D Contour Charts
HOMEWORK: Surface & Contour Charts
DEMO: Geo-Spatial Mapping with Excel Power Map
HOMEWORK: Power Map
DEMO: Common Excel Combo Charts
HOMEWORK: Combo Charts
DEMO: Excel Sparklines
HOMEWORK: Sparklines
Next-Level Demos
Setting Expectations
DEMO: Creating Custom Image Overlay Charts
DEMO: Using Binary Values to Highlight Time Periods
DEMO: Automating Charts with Named Ranges (OFFSET & COUNTA)
DEMO: Adding Scroll & Zoom Functionality Using Form Controls
DEMO: Creating Interactive Area Charts to Show Changes Over Time
DEMO: Building a Dynamic Excel Dashboard (Part 1)
DEMO: Building a Dynamic Excel Dashboard (Part 2)
DEMO: Dynamic Chart Formatting Based on Values
DEMO: Dynamically Highlighting Segments of Data
DEMO: Building a Custom Excel Pacing Chart
DEMO: Designing a Custom Excel Gauge Chart
DEMO: Visualizing Percentages Using Array Functions
Wrapping Up
Resources & Next Steps
More from Maven Analytics
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?