Search 6,000+ CA Community College Courses

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Skillshare

Excel Data Visualization Part 1: Charts & Graphs

via Skillshare

Go to class Write review

Overview

This class is Part 1 of a two part Excel data visualization series, designed to give you a deep, 100% comprehensive understanding of Excel's latest data visualization tools and techniques.

In this section of the course I'll introduce key data visualization tips and best practices, guide you through interactive, hands-on demos and exercises, and show you when, why, and how to use each of the 20+ chart types that Excel 2016 has to offer, including: 

  • Bar & Column charts
  • Histograms & Pareto charts
  • Line charts & trend lines 
  • Area charts
  • Pies & Donuts
  • Scatter plots & Bubble charts
  • Box & Whisker charts
  • Tree Maps & Sunbursts
  • Waterfall & Funnel charts
  • Radar & Stock charts
  • Heat maps, 3-D Surface & contour charts
  • Chloropleths & Geospatial maps
  • Custom combo charts & graphs
  • Sparklines

Once you've mastered the basics, Part 2 is all about putting your skills to the test, with advanced demos and case studies that you won't find in ANY other course, guaranteed.

Whether you're looking for a quick primer, trying to diversify your Excel skill set, or hoping to step up your data viz game in a major way, this series is for you.

What are the requirements?

  • Microsoft Excel, ideally 2016 for PC (some charts are not available in earlier versions of Excel)
  • Mac users are welcome, but note that the user experience will be significantly different across platforms

What am I going to get from this course?

  • A step-by-step, 100% comprehensive guide to visualizing data using charts & 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 that you won't find in ANY other course

Who is the target audience?

  • Anyone looking to create beautiful, custom 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

Syllabus

  • Course Structure and Outline
  • Key Data Viz Principles & The 10-Second Rule
  • The Good, The Bad, and The Ugly
  • The 3 Key Questions
  • Customizing Charts in Excel: Setting Expectations
  • Chart Elements, Layouts, Colors, and Styles
  • Chart Formatting Options
  • Changing Chart Types & Adding a Secondary Axis
  • Creating, Modifying & Applying Custom Templates
  • Bar & Column Charts
  • Histograms & Pareto Charts
  • Line Charts & Trendlines
  • Area Charts
  • Pies, Donuts, and Race Tracks
  • Scatter Plots
  • Bubble Charts
  • Box & Whisker Charts
  • Tree Maps & Sunburst Charts
  • Waterfall Charts
  • Funnel Charts
  • Radar Charts
  • Stock Charts
  • Heat Maps
  • Surface & Contour Charts
  • Geo-Spatial Maps with Power Map
  • Basic Combo Charts
  • Sparklines
  • Conclusion

Taught by

Chris Dutton

Reviews

Start your review of Excel Data Visualization Part 1: Charts & Graphs

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.