Microsoft Excel - Data Visualization, Excel Charts & Graphs

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

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

__________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

*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

Expected Outcomes

  1. 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 Curated for the Udemy Business collection Requirements 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 Description 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, Maven Analytics ) __________ Looking for the full business intelligence stack? Search for " Maven Analytics " to browse our full course library, including Excel, Power BI, MySQL , and Tableau courses! *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 Show more Show less Featured review Maria Inmaculada de la Torre Ruiz 78 courses 31 reviews Rating: 5.0 out of 5 6 months ago Great course to get you started working with Charts from a beginner point of view and take you to more advanced techniques that will get started producing Dashboards. Easy to follow and plenty of exercises to practice at all levels. Show more Show less Course content 6 sections • 59 lectures • 4h 37m total length Expand all sections Getting Started 4 lectures • 6min Course Structure & Outline Preview 02:03 READ ME: Important Notes for New Students 01:54 DOWNLOAD: Course Resources 00:27 Setting Expectations Preview 02:02 Data Visualization Best Practices 3 lectures • 8min Key Visualization Principles & The 10-Second Rule Preview 02:45 Good, Bad & Ugly Data Viz 03:44 3 Key Questions for Effective Visualization 01:49 Excel Chart Formatting & Customization 4 lectures • 19min Customizing Chart Elements, Layouts & Styles 06:20 Configuring Chart Formats 05:27 Changing Chart Types & Adding a Secondary Axis 03:03 Creating & Applying Custom Chart Templates Preview 04:06 Excel Chart Customization 5 questions Mastering Basic Excel Charts & Graphs 34 lectures • 2hr DEMO: Excel Bar & Columns Charts 08:49 HOMEWORK: Bar & Column Charts 00:21 DEMO: Excel Histograms & Pareto Charts (Office 365/Excel 2016+) 05:58 HOMEWORK: Histograms & Pareto Charts 00:16 DEMO: Excel Line Charts & Trendlines 05:16 HOMEWORK: Line Charts & Trendlines 00:24 DEMO: Excel Area Charts 04:41 HOMEWORK: Area Charts 00:24 DEMO: Excel Pie Charts, Donuts & Race Tracks 12:04 HOMEWORK: Pies, Donuts & Race Tracks 00:26 DEMO: Excel Scatter Plots 07:30 DEMO: Excel Bubble Charts 06:36 HOMEWORK: Scatter Plots & Bubble Charts 00:35 DEMO: Excel Box & Whisker Charts (Office 365/Excel 2016+) 06:05 HOMEWORK: Box & Whisker Charts 00:24 DEMO: Excel Tree Maps & Sunburst Charts (Office 365/Excel 2016+) Preview 06:36 HOMEWORK: Tree Maps & Sunburst Charts 00:20 DEMO: Excel Waterfall Charts (Office 365/Excel 2016+) 03:17 DEMO: Excel Funnel Charts (Office 365/Excel 2016+) 03:42 HOMEWORK: Waterfall & Funnel Charts 00:31 DEMO: Excel Radar Charts Preview 07:56 HOMEWORK: Radar Charts 00:22 DEMO: Excel Stock Charts 07:18 HOMEWORK: Stock Charts 00:16 DEMO: Excel Heat Maps with Conditional Formatting 04:41 HOMEWORK: Heat Maps 00:25 DEMO: Excel Surface & 3D Contour Charts 07:35 HOMEWORK: Surface & Contour Charts 00:20 DEMO: Geo-Spatial Mapping with Excel Power Map 05:28 HOMEWORK: Power Map 00:15 DEMO: Common Excel Combo Charts 07:57 HOMEWORK: Combo Charts 00:23 DEMO: Excel Sparklines 02:07 HOMEWORK: Sparklines 00:18 Basic Excel Chart Types 10 questions Next-Level Demos 13 lectures • 2hr 3min Setting Expectations 01:40 DEMO: Creating Custom Image Overlay Charts 06:01 DEMO: Using Binary Values to Highlight Time Periods 05:02 DEMO: Automating Charts with Named Ranges (OFFSET & COUNTA) Preview 07:08 DEMO: Adding Scroll & Zoom Functionality Using Form Controls 12:30 DEMO: Creating Interactive Area Charts to Show Changes Over Time 14:20 DEMO: Building a Dynamic Excel Dashboard (Part 1) 16:10 DEMO: Building a Dynamic Excel Dashboard (Part 2) Preview 12:08 DEMO: Dynamic Chart Formatting Based on Values 10:09 DEMO: Dynamically Highlighting Segments of Data 10:26 DEMO: Building a Custom Excel Pacing Chart 10:22 DEMO: Designing a Custom Excel Gauge Chart Preview 09:58 DEMO: Visualizing Percentages Using Array Functions 07:16 Advanced Excel Data Visualization Techniques 4 questions Wrapping Up 1 lecture • 1min BONUS LECTURE: More from Maven Analytics 00:55 Instructors Maven Analytics Award-Winning Analytics & Business Intelligence Training 4.6 Instructor Rating 178,414 Reviews 529,779 Students 23 Courses Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training. Learning new skills shouldn’t be complicated. Think of Maven as your personal team of instructors, experts, mentors and guides, helping you navigate the learning process and develop the skills you need, on-demand. Show more Show less Chris Dutton Founder, Maven Analytics 4.6 Instructor Rating 161,148 Reviews 529,779 Students 6 Courses Chris Dutton is a certified Excel MOS Expert , edtech entrepreneur , and best-selling analytics instructor . As founder and COO of Maven Analytics, Chris' work has been featured by Microsoft , HuffPost , Entrepreneur , and the New York Times , reaching more than 500,000 students around the world. A leader in analytics education, Maven Analytics empowers everyday people to change the world with data. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6780f5d13d59075e',m:'51d8ebb92e552426fbec859462e60e73ac83a8bc-1627840766-1800-AfVeuB4mL5mpiOikklYeCLFH701Wg22kx0AI0JrbbLo5ZgJF5FVxFFdOs8KFZg8C1AO6ohKz54RGW+xhhyrVR0dMoZjYeyNEYNH0aNa0jFRY7NLe3OTgM78+BvJdMoYwe2TRA7HUyS5btvJ7moohTLiwvL5gUEf8Nj1LNNbqe2Se',s:[0xb477555144,0x3d346e1f41],}})();
  2. 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 Curated for the Udemy Business collection Requirements 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 Description 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, Maven Analytics ) __________ Looking for the full business intelligence stack? Search for " Maven Analytics " to browse our full course library, including Excel, Power BI, MySQL , and Tableau courses! *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 Show more Show less Featured review Maria Inmaculada de la Torre Ruiz 78 courses 31 reviews Rating: 5.0 out of 5 6 months ago Great course to get you started working with Charts from a beginner point of view and take you to more advanced techniques that will get started producing Dashboards. Easy to follow and plenty of exercises to practice at all levels. Show more Show less Course content 6 sections • 59 lectures • 4h 37m total length Expand all sections Getting Started 4 lectures • 6min Course Structure & Outline Preview 02:03 READ ME: Important Notes for New Students 01:54 DOWNLOAD: Course Resources 00:27 Setting Expectations Preview 02:02 Data Visualization Best Practices 3 lectures • 8min Key Visualization Principles & The 10-Second Rule Preview 02:45 Good, Bad & Ugly Data Viz 03:44 3 Key Questions for Effective Visualization 01:49 Excel Chart Formatting & Customization 4 lectures • 19min Customizing Chart Elements, Layouts & Styles 06:20 Configuring Chart Formats 05:27 Changing Chart Types & Adding a Secondary Axis 03:03 Creating & Applying Custom Chart Templates Preview 04:06 Excel Chart Customization 5 questions Mastering Basic Excel Charts & Graphs 34 lectures • 2hr DEMO: Excel Bar & Columns Charts 08:49 HOMEWORK: Bar & Column Charts 00:21 DEMO: Excel Histograms & Pareto Charts (Office 365/Excel 2016+) 05:58 HOMEWORK: Histograms & Pareto Charts 00:16 DEMO: Excel Line Charts & Trendlines 05:16 HOMEWORK: Line Charts & Trendlines 00:24 DEMO: Excel Area Charts 04:41 HOMEWORK: Area Charts 00:24 DEMO: Excel Pie Charts, Donuts & Race Tracks 12:04 HOMEWORK: Pies, Donuts & Race Tracks 00:26 DEMO: Excel Scatter Plots 07:30 DEMO: Excel Bubble Charts 06:36 HOMEWORK: Scatter Plots & Bubble Charts 00:35 DEMO: Excel Box & Whisker Charts (Office 365/Excel 2016+) 06:05 HOMEWORK: Box & Whisker Charts 00:24 DEMO: Excel Tree Maps & Sunburst Charts (Office 365/Excel 2016+) Preview 06:36 HOMEWORK: Tree Maps & Sunburst Charts 00:20 DEMO: Excel Waterfall Charts (Office 365/Excel 2016+) 03:17 DEMO: Excel Funnel Charts (Office 365/Excel 2016+) 03:42 HOMEWORK: Waterfall & Funnel Charts 00:31 DEMO: Excel Radar Charts Preview 07:56 HOMEWORK: Radar Charts 00:22 DEMO: Excel Stock Charts 07:18 HOMEWORK: Stock Charts 00:16 DEMO: Excel Heat Maps with Conditional Formatting 04:41 HOMEWORK: Heat Maps 00:25 DEMO: Excel Surface & 3D Contour Charts 07:35 HOMEWORK: Surface & Contour Charts 00:20 DEMO: Geo-Spatial Mapping with Excel Power Map 05:28 HOMEWORK: Power Map 00:15 DEMO: Common Excel Combo Charts 07:57 HOMEWORK: Combo Charts 00:23 DEMO: Excel Sparklines 02:07 HOMEWORK: Sparklines 00:18 Basic Excel Chart Types 10 questions Next-Level Demos 13 lectures • 2hr 3min Setting Expectations 01:40 DEMO: Creating Custom Image Overlay Charts 06:01 DEMO: Using Binary Values to Highlight Time Periods 05:02 DEMO: Automating Charts with Named Ranges (OFFSET & COUNTA) Preview 07:08 DEMO: Adding Scroll & Zoom Functionality Using Form Controls 12:30 DEMO: Creating Interactive Area Charts to Show Changes Over Time 14:20 DEMO: Building a Dynamic Excel Dashboard (Part 1) 16:10 DEMO: Building a Dynamic Excel Dashboard (Part 2) Preview 12:08 DEMO: Dynamic Chart Formatting Based on Values 10:09 DEMO: Dynamically Highlighting Segments of Data 10:26 DEMO: Building a Custom Excel Pacing Chart 10:22 DEMO: Designing a Custom Excel Gauge Chart Preview 09:58 DEMO: Visualizing Percentages Using Array Functions 07:16 Advanced Excel Data Visualization Techniques 4 questions Wrapping Up 1 lecture • 1min BONUS LECTURE: More from Maven Analytics 00:55 Instructors Maven Analytics Award-Winning Analytics & Business Intelligence Training 4.6 Instructor Rating 178,414 Reviews 529,779 Students 23 Courses Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training. Learning new skills shouldn’t be complicated. Think of Maven as your personal team of instructors, experts, mentors and guides, helping you navigate the learning process and develop the skills you need, on-demand. Show more Show less Chris Dutton Founder, Maven Analytics 4.6 Instructor Rating 161,148 Reviews 529,779 Students 6 Courses Chris Dutton is a certified Excel MOS Expert , edtech entrepreneur , and best-selling analytics instructor . As founder and COO of Maven Analytics, Chris' work has been featured by Microsoft , HuffPost , Entrepreneur , and the New York Times , reaching more than 500,000 students around the world. A leader in analytics education, Maven Analytics empowers everyday people to change the world with data. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6780f5d13d59075e',m:'51d8ebb92e552426fbec859462e60e73ac83a8bc-1627840766-1800-AfVeuB4mL5mpiOikklYeCLFH701Wg22kx0AI0JrbbLo5ZgJF5FVxFFdOs8KFZg8C1AO6ohKz54RGW+xhhyrVR0dMoZjYeyNEYNH0aNa0jFRY7NLe3OTgM78+BvJdMoYwe2TRA7HUyS5btvJ7moohTLiwvL5gUEf8Nj1LNNbqe2Se',s:[0xb477555144,0x3d346e1f41],}})();
  3. 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 Curated for the Udemy Business collection Requirements 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 Description 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, Maven Analytics ) __________ Looking for the full business intelligence stack? Search for " Maven Analytics " to browse our full course library, including Excel, Power BI, MySQL , and Tableau courses! *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 Show more Show less Featured review Maria Inmaculada de la Torre Ruiz 78 courses 31 reviews Rating: 5.0 out of 5 6 months ago Great course to get you started working with Charts from a beginner point of view and take you to more advanced techniques that will get started producing Dashboards. Easy to follow and plenty of exercises to practice at all levels. Show more Show less Course content 6 sections • 59 lectures • 4h 37m total length Expand all sections Getting Started 4 lectures • 6min Course Structure & Outline Preview 02:03 READ ME: Important Notes for New Students 01:54 DOWNLOAD: Course Resources 00:27 Setting Expectations Preview 02:02 Data Visualization Best Practices 3 lectures • 8min Key Visualization Principles & The 10-Second Rule Preview 02:45 Good, Bad & Ugly Data Viz 03:44 3 Key Questions for Effective Visualization 01:49 Excel Chart Formatting & Customization 4 lectures • 19min Customizing Chart Elements, Layouts & Styles 06:20 Configuring Chart Formats 05:27 Changing Chart Types & Adding a Secondary Axis 03:03 Creating & Applying Custom Chart Templates Preview 04:06 Excel Chart Customization 5 questions Mastering Basic Excel Charts & Graphs 34 lectures • 2hr DEMO: Excel Bar & Columns Charts 08:49 HOMEWORK: Bar & Column Charts 00:21 DEMO: Excel Histograms & Pareto Charts (Office 365/Excel 2016+) 05:58 HOMEWORK: Histograms & Pareto Charts 00:16 DEMO: Excel Line Charts & Trendlines 05:16 HOMEWORK: Line Charts & Trendlines 00:24 DEMO: Excel Area Charts 04:41 HOMEWORK: Area Charts 00:24 DEMO: Excel Pie Charts, Donuts & Race Tracks 12:04 HOMEWORK: Pies, Donuts & Race Tracks 00:26 DEMO: Excel Scatter Plots 07:30 DEMO: Excel Bubble Charts 06:36 HOMEWORK: Scatter Plots & Bubble Charts 00:35 DEMO: Excel Box & Whisker Charts (Office 365/Excel 2016+) 06:05 HOMEWORK: Box & Whisker Charts 00:24 DEMO: Excel Tree Maps & Sunburst Charts (Office 365/Excel 2016+) Preview 06:36 HOMEWORK: Tree Maps & Sunburst Charts 00:20 DEMO: Excel Waterfall Charts (Office 365/Excel 2016+) 03:17 DEMO: Excel Funnel Charts (Office 365/Excel 2016+) 03:42 HOMEWORK: Waterfall & Funnel Charts 00:31 DEMO: Excel Radar Charts Preview 07:56 HOMEWORK: Radar Charts 00:22 DEMO: Excel Stock Charts 07:18 HOMEWORK: Stock Charts 00:16 DEMO: Excel Heat Maps with Conditional Formatting 04:41 HOMEWORK: Heat Maps 00:25 DEMO: Excel Surface & 3D Contour Charts 07:35 HOMEWORK: Surface & Contour Charts 00:20 DEMO: Geo-Spatial Mapping with Excel Power Map 05:28 HOMEWORK: Power Map 00:15 DEMO: Common Excel Combo Charts 07:57 HOMEWORK: Combo Charts 00:23 DEMO: Excel Sparklines 02:07 HOMEWORK: Sparklines 00:18 Basic Excel Chart Types 10 questions Next-Level Demos 13 lectures • 2hr 3min Setting Expectations 01:40 DEMO: Creating Custom Image Overlay Charts 06:01 DEMO: Using Binary Values to Highlight Time Periods 05:02 DEMO: Automating Charts with Named Ranges (OFFSET & COUNTA) Preview 07:08 DEMO: Adding Scroll & Zoom Functionality Using Form Controls 12:30 DEMO: Creating Interactive Area Charts to Show Changes Over Time 14:20 DEMO: Building a Dynamic Excel Dashboard (Part 1) 16:10 DEMO: Building a Dynamic Excel Dashboard (Part 2) Preview 12:08 DEMO: Dynamic Chart Formatting Based on Values 10:09 DEMO: Dynamically Highlighting Segments of Data 10:26 DEMO: Building a Custom Excel Pacing Chart 10:22 DEMO: Designing a Custom Excel Gauge Chart Preview 09:58 DEMO: Visualizing Percentages Using Array Functions 07:16 Advanced Excel Data Visualization Techniques 4 questions Wrapping Up 1 lecture • 1min BONUS LECTURE: More from Maven Analytics 00:55 Instructors Maven Analytics Award-Winning Analytics & Business Intelligence Training 4.6 Instructor Rating 178,414 Reviews 529,779 Students 23 Courses Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training. Learning new skills shouldn’t be complicated. Think of Maven as your personal team of instructors, experts, mentors and guides, helping you navigate the learning process and develop the skills you need, on-demand. Show more Show less Chris Dutton Founder, Maven Analytics 4.6 Instructor Rating 161,148 Reviews 529,779 Students 6 Courses Chris Dutton is a certified Excel MOS Expert , edtech entrepreneur , and best-selling analytics instructor . As founder and COO of Maven Analytics, Chris' work has been featured by Microsoft , HuffPost , Entrepreneur , and the New York Times , reaching more than 500,000 students around the world. A leader in analytics education, Maven Analytics empowers everyday people to change the world with data. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6780f5d13d59075e',m:'51d8ebb92e552426fbec859462e60e73ac83a8bc-1627840766-1800-AfVeuB4mL5mpiOikklYeCLFH701Wg22kx0AI0JrbbLo5ZgJF5FVxFFdOs8KFZg8C1AO6ohKz54RGW+xhhyrVR0dMoZjYeyNEYNH0aNa0jFRY7NLe3OTgM78+BvJdMoYwe2TRA7HUyS5btvJ7moohTLiwvL5gUEf8Nj1LNNbqe2Se',s:[0xb477555144,0x3d346e1f41],}})();
  4. 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 Curated for the Udemy Business collection Requirements 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 Description 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, Maven Analytics ) __________ Looking for the full business intelligence stack? Search for " Maven Analytics " to browse our full course library, including Excel, Power BI, MySQL , and Tableau courses! *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 Show more Show less Featured review Maria Inmaculada de la Torre Ruiz 78 courses 31 reviews Rating: 5.0 out of 5 6 months ago Great course to get you started working with Charts from a beginner point of view and take you to more advanced techniques that will get started producing Dashboards. Easy to follow and plenty of exercises to practice at all levels. Show more Show less Course content 6 sections • 59 lectures • 4h 37m total length Expand all sections Getting Started 4 lectures • 6min Course Structure & Outline Preview 02:03 READ ME: Important Notes for New Students 01:54 DOWNLOAD: Course Resources 00:27 Setting Expectations Preview 02:02 Data Visualization Best Practices 3 lectures • 8min Key Visualization Principles & The 10-Second Rule Preview 02:45 Good, Bad & Ugly Data Viz 03:44 3 Key Questions for Effective Visualization 01:49 Excel Chart Formatting & Customization 4 lectures • 19min Customizing Chart Elements, Layouts & Styles 06:20 Configuring Chart Formats 05:27 Changing Chart Types & Adding a Secondary Axis 03:03 Creating & Applying Custom Chart Templates Preview 04:06 Excel Chart Customization 5 questions Mastering Basic Excel Charts & Graphs 34 lectures • 2hr DEMO: Excel Bar & Columns Charts 08:49 HOMEWORK: Bar & Column Charts 00:21 DEMO: Excel Histograms & Pareto Charts (Office 365/Excel 2016+) 05:58 HOMEWORK: Histograms & Pareto Charts 00:16 DEMO: Excel Line Charts & Trendlines 05:16 HOMEWORK: Line Charts & Trendlines 00:24 DEMO: Excel Area Charts 04:41 HOMEWORK: Area Charts 00:24 DEMO: Excel Pie Charts, Donuts & Race Tracks 12:04 HOMEWORK: Pies, Donuts & Race Tracks 00:26 DEMO: Excel Scatter Plots 07:30 DEMO: Excel Bubble Charts 06:36 HOMEWORK: Scatter Plots & Bubble Charts 00:35 DEMO: Excel Box & Whisker Charts (Office 365/Excel 2016+) 06:05 HOMEWORK: Box & Whisker Charts 00:24 DEMO: Excel Tree Maps & Sunburst Charts (Office 365/Excel 2016+) Preview 06:36 HOMEWORK: Tree Maps & Sunburst Charts 00:20 DEMO: Excel Waterfall Charts (Office 365/Excel 2016+) 03:17 DEMO: Excel Funnel Charts (Office 365/Excel 2016+) 03:42 HOMEWORK: Waterfall & Funnel Charts 00:31 DEMO: Excel Radar Charts Preview 07:56 HOMEWORK: Radar Charts 00:22 DEMO: Excel Stock Charts 07:18 HOMEWORK: Stock Charts 00:16 DEMO: Excel Heat Maps with Conditional Formatting 04:41 HOMEWORK: Heat Maps 00:25 DEMO: Excel Surface & 3D Contour Charts 07:35 HOMEWORK: Surface & Contour Charts 00:20 DEMO: Geo-Spatial Mapping with Excel Power Map 05:28 HOMEWORK: Power Map 00:15 DEMO: Common Excel Combo Charts 07:57 HOMEWORK: Combo Charts 00:23 DEMO: Excel Sparklines 02:07 HOMEWORK: Sparklines 00:18 Basic Excel Chart Types 10 questions Next-Level Demos 13 lectures • 2hr 3min Setting Expectations 01:40 DEMO: Creating Custom Image Overlay Charts 06:01 DEMO: Using Binary Values to Highlight Time Periods 05:02 DEMO: Automating Charts with Named Ranges (OFFSET & COUNTA) Preview 07:08 DEMO: Adding Scroll & Zoom Functionality Using Form Controls 12:30 DEMO: Creating Interactive Area Charts to Show Changes Over Time 14:20 DEMO: Building a Dynamic Excel Dashboard (Part 1) 16:10 DEMO: Building a Dynamic Excel Dashboard (Part 2) Preview 12:08 DEMO: Dynamic Chart Formatting Based on Values 10:09 DEMO: Dynamically Highlighting Segments of Data 10:26 DEMO: Building a Custom Excel Pacing Chart 10:22 DEMO: Designing a Custom Excel Gauge Chart Preview 09:58 DEMO: Visualizing Percentages Using Array Functions 07:16 Advanced Excel Data Visualization Techniques 4 questions Wrapping Up 1 lecture • 1min BONUS LECTURE: More from Maven Analytics 00:55 Instructors Maven Analytics Award-Winning Analytics & Business Intelligence Training 4.6 Instructor Rating 178,414 Reviews 529,779 Students 23 Courses Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training. Learning new skills shouldn’t be complicated. Think of Maven as your personal team of instructors, experts, mentors and guides, helping you navigate the learning process and develop the skills you need, on-demand. Show more Show less Chris Dutton Founder, Maven Analytics 4.6 Instructor Rating 161,148 Reviews 529,779 Students 6 Courses Chris Dutton is a certified Excel MOS Expert , edtech entrepreneur , and best-selling analytics instructor . As founder and COO of Maven Analytics, Chris' work has been featured by Microsoft , HuffPost , Entrepreneur , and the New York Times , reaching more than 500,000 students around the world. A leader in analytics education, Maven Analytics empowers everyday people to change the world with data. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6780f5d13d59075e',m:'51d8ebb92e552426fbec859462e60e73ac83a8bc-1627840766-1800-AfVeuB4mL5mpiOikklYeCLFH701Wg22kx0AI0JrbbLo5ZgJF5FVxFFdOs8KFZg8C1AO6ohKz54RGW+xhhyrVR0dMoZjYeyNEYNH0aNa0jFRY7NLe3OTgM78+BvJdMoYwe2TRA7HUyS5btvJ7moohTLiwvL5gUEf8Nj1LNNbqe2Se',s:[0xb477555144,0x3d346e1f41],}})();
  5. 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 Curated for the Udemy Business collection Requirements 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 Description 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, Maven Analytics ) __________ Looking for the full business intelligence stack? Search for " Maven Analytics " to browse our full course library, including Excel, Power BI, MySQL , and Tableau courses! *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 Show more Show less Featured review Maria Inmaculada de la Torre Ruiz 78 courses 31 reviews Rating: 5.0 out of 5 6 months ago Great course to get you started working with Charts from a beginner point of view and take you to more advanced techniques that will get started producing Dashboards. Easy to follow and plenty of exercises to practice at all levels. Show more Show less Course content 6 sections • 59 lectures • 4h 37m total length Expand all sections Getting Started 4 lectures • 6min Course Structure & Outline Preview 02:03 READ ME: Important Notes for New Students 01:54 DOWNLOAD: Course Resources 00:27 Setting Expectations Preview 02:02 Data Visualization Best Practices 3 lectures • 8min Key Visualization Principles & The 10-Second Rule Preview 02:45 Good, Bad & Ugly Data Viz 03:44 3 Key Questions for Effective Visualization 01:49 Excel Chart Formatting & Customization 4 lectures • 19min Customizing Chart Elements, Layouts & Styles 06:20 Configuring Chart Formats 05:27 Changing Chart Types & Adding a Secondary Axis 03:03 Creating & Applying Custom Chart Templates Preview 04:06 Excel Chart Customization 5 questions Mastering Basic Excel Charts & Graphs 34 lectures • 2hr DEMO: Excel Bar & Columns Charts 08:49 HOMEWORK: Bar & Column Charts 00:21 DEMO: Excel Histograms & Pareto Charts (Office 365/Excel 2016+) 05:58 HOMEWORK: Histograms & Pareto Charts 00:16 DEMO: Excel Line Charts & Trendlines 05:16 HOMEWORK: Line Charts & Trendlines 00:24 DEMO: Excel Area Charts 04:41 HOMEWORK: Area Charts 00:24 DEMO: Excel Pie Charts, Donuts & Race Tracks 12:04 HOMEWORK: Pies, Donuts & Race Tracks 00:26 DEMO: Excel Scatter Plots 07:30 DEMO: Excel Bubble Charts 06:36 HOMEWORK: Scatter Plots & Bubble Charts 00:35 DEMO: Excel Box & Whisker Charts (Office 365/Excel 2016+) 06:05 HOMEWORK: Box & Whisker Charts 00:24 DEMO: Excel Tree Maps & Sunburst Charts (Office 365/Excel 2016+) Preview 06:36 HOMEWORK: Tree Maps & Sunburst Charts 00:20 DEMO: Excel Waterfall Charts (Office 365/Excel 2016+) 03:17 DEMO: Excel Funnel Charts (Office 365/Excel 2016+) 03:42 HOMEWORK: Waterfall & Funnel Charts 00:31 DEMO: Excel Radar Charts Preview 07:56 HOMEWORK: Radar Charts 00:22 DEMO: Excel Stock Charts 07:18 HOMEWORK: Stock Charts 00:16 DEMO: Excel Heat Maps with Conditional Formatting 04:41 HOMEWORK: Heat Maps 00:25 DEMO: Excel Surface & 3D Contour Charts 07:35 HOMEWORK: Surface & Contour Charts 00:20 DEMO: Geo-Spatial Mapping with Excel Power Map 05:28 HOMEWORK: Power Map 00:15 DEMO: Common Excel Combo Charts 07:57 HOMEWORK: Combo Charts 00:23 DEMO: Excel Sparklines 02:07 HOMEWORK: Sparklines 00:18 Basic Excel Chart Types 10 questions Next-Level Demos 13 lectures • 2hr 3min Setting Expectations 01:40 DEMO: Creating Custom Image Overlay Charts 06:01 DEMO: Using Binary Values to Highlight Time Periods 05:02 DEMO: Automating Charts with Named Ranges (OFFSET & COUNTA) Preview 07:08 DEMO: Adding Scroll & Zoom Functionality Using Form Controls 12:30 DEMO: Creating Interactive Area Charts to Show Changes Over Time 14:20 DEMO: Building a Dynamic Excel Dashboard (Part 1) 16:10 DEMO: Building a Dynamic Excel Dashboard (Part 2) Preview 12:08 DEMO: Dynamic Chart Formatting Based on Values 10:09 DEMO: Dynamically Highlighting Segments of Data 10:26 DEMO: Building a Custom Excel Pacing Chart 10:22 DEMO: Designing a Custom Excel Gauge Chart Preview 09:58 DEMO: Visualizing Percentages Using Array Functions 07:16 Advanced Excel Data Visualization Techniques 4 questions Wrapping Up 1 lecture • 1min BONUS LECTURE: More from Maven Analytics 00:55 Instructors Maven Analytics Award-Winning Analytics & Business Intelligence Training 4.6 Instructor Rating 178,414 Reviews 529,779 Students 23 Courses Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training. Learning new skills shouldn’t be complicated. Think of Maven as your personal team of instructors, experts, mentors and guides, helping you navigate the learning process and develop the skills you need, on-demand. Show more Show less Chris Dutton Founder, Maven Analytics 4.6 Instructor Rating 161,148 Reviews 529,779 Students 6 Courses Chris Dutton is a certified Excel MOS Expert , edtech entrepreneur , and best-selling analytics instructor . As founder and COO of Maven Analytics, Chris' work has been featured by Microsoft , HuffPost , Entrepreneur , and the New York Times , reaching more than 500,000 students around the world. A leader in analytics education, Maven Analytics empowers everyday people to change the world with data. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6780f5d13d59075e',m:'51d8ebb92e552426fbec859462e60e73ac83a8bc-1627840766-1800-AfVeuB4mL5mpiOikklYeCLFH701Wg22kx0AI0JrbbLo5ZgJF5FVxFFdOs8KFZg8C1AO6ohKz54RGW+xhhyrVR0dMoZjYeyNEYNH0aNa0jFRY7NLe3OTgM78+BvJdMoYwe2TRA7HUyS5btvJ7moohTLiwvL5gUEf8Nj1LNNbqe2Se',s:[0xb477555144,0x3d346e1f41],}})();
  6. Build 10+ Excel projects designed to take your data visualization skills to the next level Curated for the Udemy Business collection Requirements 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 Description 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, Maven Analytics ) __________ Looking for the full business intelligence stack? Search for " Maven Analytics " to browse our full course library, including Excel, Power BI, MySQL , and Tableau courses! *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 Show more Show less Featured review Maria Inmaculada de la Torre Ruiz 78 courses 31 reviews Rating: 5.0 out of 5 6 months ago Great course to get you started working with Charts from a beginner point of view and take you to more advanced techniques that will get started producing Dashboards. Easy to follow and plenty of exercises to practice at all levels. Show more Show less Course content 6 sections • 59 lectures • 4h 37m total length Expand all sections Getting Started 4 lectures • 6min Course Structure & Outline Preview 02:03 READ ME: Important Notes for New Students 01:54 DOWNLOAD: Course Resources 00:27 Setting Expectations Preview 02:02 Data Visualization Best Practices 3 lectures • 8min Key Visualization Principles & The 10-Second Rule Preview 02:45 Good, Bad & Ugly Data Viz 03:44 3 Key Questions for Effective Visualization 01:49 Excel Chart Formatting & Customization 4 lectures • 19min Customizing Chart Elements, Layouts & Styles 06:20 Configuring Chart Formats 05:27 Changing Chart Types & Adding a Secondary Axis 03:03 Creating & Applying Custom Chart Templates Preview 04:06 Excel Chart Customization 5 questions Mastering Basic Excel Charts & Graphs 34 lectures • 2hr DEMO: Excel Bar & Columns Charts 08:49 HOMEWORK: Bar & Column Charts 00:21 DEMO: Excel Histograms & Pareto Charts (Office 365/Excel 2016+) 05:58 HOMEWORK: Histograms & Pareto Charts 00:16 DEMO: Excel Line Charts & Trendlines 05:16 HOMEWORK: Line Charts & Trendlines 00:24 DEMO: Excel Area Charts 04:41 HOMEWORK: Area Charts 00:24 DEMO: Excel Pie Charts, Donuts & Race Tracks 12:04 HOMEWORK: Pies, Donuts & Race Tracks 00:26 DEMO: Excel Scatter Plots 07:30 DEMO: Excel Bubble Charts 06:36 HOMEWORK: Scatter Plots & Bubble Charts 00:35 DEMO: Excel Box & Whisker Charts (Office 365/Excel 2016+) 06:05 HOMEWORK: Box & Whisker Charts 00:24 DEMO: Excel Tree Maps & Sunburst Charts (Office 365/Excel 2016+) Preview 06:36 HOMEWORK: Tree Maps & Sunburst Charts 00:20 DEMO: Excel Waterfall Charts (Office 365/Excel 2016+) 03:17 DEMO: Excel Funnel Charts (Office 365/Excel 2016+) 03:42 HOMEWORK: Waterfall & Funnel Charts 00:31 DEMO: Excel Radar Charts Preview 07:56 HOMEWORK: Radar Charts 00:22 DEMO: Excel Stock Charts 07:18 HOMEWORK: Stock Charts 00:16 DEMO: Excel Heat Maps with Conditional Formatting 04:41 HOMEWORK: Heat Maps 00:25 DEMO: Excel Surface & 3D Contour Charts 07:35 HOMEWORK: Surface & Contour Charts 00:20 DEMO: Geo-Spatial Mapping with Excel Power Map 05:28 HOMEWORK: Power Map 00:15 DEMO: Common Excel Combo Charts 07:57 HOMEWORK: Combo Charts 00:23 DEMO: Excel Sparklines 02:07 HOMEWORK: Sparklines 00:18 Basic Excel Chart Types 10 questions Next-Level Demos 13 lectures • 2hr 3min Setting Expectations 01:40 DEMO: Creating Custom Image Overlay Charts 06:01 DEMO: Using Binary Values to Highlight Time Periods 05:02 DEMO: Automating Charts with Named Ranges (OFFSET & COUNTA) Preview 07:08 DEMO: Adding Scroll & Zoom Functionality Using Form Controls 12:30 DEMO: Creating Interactive Area Charts to Show Changes Over Time 14:20 DEMO: Building a Dynamic Excel Dashboard (Part 1) 16:10 DEMO: Building a Dynamic Excel Dashboard (Part 2) Preview 12:08 DEMO: Dynamic Chart Formatting Based on Values 10:09 DEMO: Dynamically Highlighting Segments of Data 10:26 DEMO: Building a Custom Excel Pacing Chart 10:22 DEMO: Designing a Custom Excel Gauge Chart Preview 09:58 DEMO: Visualizing Percentages Using Array Functions 07:16 Advanced Excel Data Visualization Techniques 4 questions Wrapping Up 1 lecture • 1min BONUS LECTURE: More from Maven Analytics 00:55 Instructors Maven Analytics Award-Winning Analytics & Business Intelligence Training 4.6 Instructor Rating 178,414 Reviews 529,779 Students 23 Courses Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training. Learning new skills shouldn’t be complicated. Think of Maven as your personal team of instructors, experts, mentors and guides, helping you navigate the learning process and develop the skills you need, on-demand. Show more Show less Chris Dutton Founder, Maven Analytics 4.6 Instructor Rating 161,148 Reviews 529,779 Students 6 Courses Chris Dutton is a certified Excel MOS Expert , edtech entrepreneur , and best-selling analytics instructor . As founder and COO of Maven Analytics, Chris' work has been featured by Microsoft , HuffPost , Entrepreneur , and the New York Times , reaching more than 500,000 students around the world. A leader in analytics education, Maven Analytics empowers everyday people to change the world with data. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.h