Microsoft Excel: Data Visualization, Excel Charts & Graphs

Focused View

Maven Analytics,Chris Dutton

4:28:09

32 View

01 - Getting Started

001 Course Structure & Outline.mp4

02:03

002 READ ME Important Notes for New Students.html

003 DOWNLOAD Course Resources.html

003 Data-Viz-Demo-Workbooks.zip

003 Data-Viz-Homework-Workbooks.zip

003 Excel-Data-Visualization.pdf

003 thermometer.zip

003 thumbsup.zip

004 Setting Expectations.mp4

02:02

02 - Data Visualization Best Practices

001 Key Visualization Principles & The 10-Second Rule.mp4

02:45

002 Good, Bad & Ugly Data Viz.mp4

03:44

003 3 Key Questions for Effective Visualization.mp4

01:49

03 - Excel Chart Formatting & Customization

001 Customizing Chart Elements, Layouts & Styles.mp4

06:20

002 Configuring Chart Formats.mp4

05:27

003 Changing Chart Types & Adding a Secondary Axis.mp4

03:03

004 Creating & Applying Custom Chart Templates.mp4

04:06

04 - Mastering Basic Excel Charts & Graphs

001 DEMO Excel Bar & Columns Charts.mp4

08:49

002 HOMEWORK Bar & Column Charts.html

003 DEMO Excel Histograms & Pareto Charts (Office 365Excel 2016+).mp4

05:59

004 HOMEWORK Histograms & Pareto Charts.html

005 DEMO Excel Line Charts & Trendlines.mp4

05:16

006 HOMEWORK Line Charts & Trendlines.html

007 DEMO Excel Area Charts.mp4

04:41

008 HOMEWORK Area Charts.html

009 DEMO Excel Pie Charts, Donuts & Race Tracks.mp4

12:04

010 HOMEWORK Pies, Donuts & Race Tracks.html

011 DEMO Excel Scatter Plots.mp4

07:30

012 DEMO Excel Bubble Charts.mp4

06:36

013 HOMEWORK Scatter Plots & Bubble Charts.html

014 DEMO Excel Box & Whisker Charts (Office 365Excel 2016+).mp4

06:05

015 HOMEWORK Box & Whisker Charts.html

016 DEMO Excel Tree Maps & Sunburst Charts (Office 365Excel 2016+).mp4

06:36

017 HOMEWORK Tree Maps & Sunburst Charts.html

018 DEMO Excel Waterfall Charts (Office 365Excel 2016+).mp4

03:17

019 DEMO Excel Funnel Charts (Office 365Excel 2016+).mp4

03:42

020 HOMEWORK Waterfall & Funnel Charts.html

021 DEMO Excel Radar Charts.mp4

07:56

022 HOMEWORK Radar Charts.html

023 DEMO Excel Stock Charts.mp4

07:18

024 HOMEWORK Stock Charts.html

025 DEMO Excel Heat Maps with Conditional Formatting.mp4

04:41

026 HOMEWORK Heat Maps.html

027 DEMO Excel Surface & 3D Contour Charts.mp4

07:35

028 HOMEWORK Surface & Contour Charts.html

029 DEMO Geo-Spatial Mapping with Excel Power Map.mp4

05:28

030 HOMEWORK Power Map.html

031 DEMO Common Excel Combo Charts.mp4

07:57

032 HOMEWORK Combo Charts.html

033 DEMO Excel Sparklines.mp4

02:07

034 HOMEWORK Sparklines.html

05 - Next-Level Demos

001 Setting Expectations.mp4

01:40

002 DEMO Creating Custom Image Overlay Charts.mp4

06:01

003 DEMO Using Binary Values to Highlight Time Periods.mp4

05:02

004 DEMO Automating Charts with Named Ranges (OFFSET & COUNTA).mp4

07:08

005 DEMO Adding Scroll & Zoom Functionality Using Form Controls.mp4

12:31

006 DEMO Creating Interactive Area Charts to Show Changes Over Time.mp4

14:20

007 DEMO Building a Dynamic Excel Dashboard (Part 1).mp4

16:10

008 DEMO Building a Dynamic Excel Dashboard (Part 2).mp4

12:08

009 DEMO Dynamic Chart Formatting Based on Values.mp4

10:10

010 DEMO Dynamically Highlighting Segments of Data.mp4

10:26

011 DEMO Building a Custom Excel Pacing Chart.mp4

10:23

012 DEMO Designing a Custom Excel Gauge Chart.mp4

09:58

013 DEMO Visualizing Percentages Using Array Functions.mp4

07:16

06 - Wrapping Up

001 BONUS LESSON.html

Description

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

Who is this for?

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

What You Need to Know?

Microsoft Excel, ideally 2016+ or Office 365 for PC (some charts are not available in other versions of Excel)

Mac users are welcome, but note that the user experience will be significantly different across platforms

More details

Description
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Â 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 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, Maven Analytics)

Looking for the full business intelligence stack? Search for "Maven Analytics"Â to browse our full course library, including Excel, Power BI, MySQL, Python *and**Â TableauÂ* 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.*

Who this course is for:
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

User Reviews

Rating

average 0

Total votes0

Focused display

Maven Analytics helps individuals and teams build expert-level analytics & business intelligence skills. We've helped more than 1,000,000 students around the world build job-ready skills, master sought-after tools like Excel, SQL, Power BI, Tableau & Python, and build the foundation for a successful career in data. At Maven Analytics, we empower everyday people to change the world with data.

Chris Dutton

Instructor's Courses

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 world's first purpose-built, all-in-one platform for data professionals to launch or accelerate their careers. Learn in-demand skills, create portfolios to showcase your work, and connect with world-class analysts around the world.At Maven Analytics, our mission is to empower everyday people with life-changing data skills.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.