Skillshareintermediateen

Excel Data Visualization Part 1: Charts & Graphs

Master Excel data visualization! Part 1 covers the latest features for clear, impactful charts and graphs. Learn to analyze and present data effectively.

4.6(162)
4,474students
2h 26m
Certificate
Chris Dutton
Chris DuttonFounder, Excel Maven

Course Content

Excel Data Visualization Part 1: Charts & Graphs is an intermediate-level Skillshare course taught by Chris Dutton. It runs 2h 26m, is taught in English, and includes a certificate of completion. Learners rate it 4.6 out of 5 from 162 reviews, with 4,474 students enrolled. It is a paid course, first published February 2017.

Unlock the Power of Data Visualization in Excel: Part 1

Dive into a comprehensive exploration of Excel data visualization with this in-depth, two-part series. Part 1 provides a complete understanding of Excel's data visualization tools and techniques, empowering you to transform raw data into compelling visuals.

This course offers a hands-on approach, guiding you through interactive demos and exercises. You'll learn data visualization tips and best practices and discover when, why, and how to effectively utilize over 20 chart types available in Excel 2016.

Master these essential chart types:

  • Bar & Column Charts: Effectively compare data across categories.
  • Histograms & Pareto Charts: Analyze data distribution and identify key factors.
  • Line Charts & Trend Lines: Visualize data trends over time.
  • Area Charts: Highlight the magnitude of change over time.
  • Pie & Donut Charts: Display parts of a whole.
  • Scatter Plots & Bubble Charts: Explore relationships between variables.
  • Box & Whisker Charts: Understand data distribution and outliers.
  • Tree Maps & Sunbursts: Visualize hierarchical data.
  • Waterfall & Funnel Charts: Track progress and identify bottlenecks.
  • Radar & Stock Charts: Compare multiple variables across different categories.
  • Heat Maps: Visualize data density and correlations.
  • 3-D Surface & Contour Charts: Analyze three-dimensional data.
  • Chloropleths & Geospatial Maps: Visualize data on maps.
  • Custom Combo Charts & Graphs: Combine different chart types for enhanced insights.
  • Sparklines: Display mini-charts within cells for quick data summaries.

This first part lays the foundation for advanced techniques in Part 2, featuring exclusive demos and case studies.

Who is this course for?

  • Anyone seeking to create beautiful data visualizations in Excel.
  • Excel users with basic skills who want to master advanced charts, graphs & dashboards.
  • Students looking for an engaging, hands-on, and interactive learning experience.
  • Professionals aiming to diversify their Excel skill set and elevate their data visualization game.

Requirements:

  • Microsoft Excel, ideally Excel 2016 for PC. (Note: Some charts are not available in earlier versions.)
  • Mac users are welcome, but be aware of potential user experience differences.

What you'll gain:

  • A step-by-step, 100% comprehensive guide to data visualization using charts and graphs in Excel.
  • A deep understanding of when, why, and how to use 20+ chart types in Excel 2016.
  • Exclusive data visualization tips, tricks, and best practices from an award-winning analytics expert.
  • Unique, custom content not found in other courses.
$ whoami — the devs behind tutorialsearch.io

Need a web app built? Hire the team behind TutorialSearch.io

We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.

5.0
53m
beginner
pluralsight
5.0(413)
3h 45m
beginner
skillshare
5.0
1h 29m
beginner
pluralsight