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

Skillshare

Excel Data Visualization Part 2: Advanced Demos

via Skillshare

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

This class is Part 2 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.

This segment builds on the skills developed in Microsoft Excel: Data Visualization With Charts & Graphs (Part 1) by introducing a series of advanced demos and case studies that you won't find in ANY other Excel course, including:

  • Custom image-overlay charts
  • Automation with dynamic ranges
  • Scroll & zoom functionality with form controls
  • Dynamic dashboards
  • Advanced formatting techniques
  • Custom-built gauge charts
  • And more!

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?

  • 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 want to master advanced charts, graphs & dashboards
  • Students looking for an engaging, hands-on, and highly interactive approach to training

Syllabus

  • Intro: Setting Expectations
  • Custom Image Overlay Charts
  • Adding Binary Values to Highlight Date Ranges
  • Automation with OFFSET, COUNTA & Named Ranges
  • Adding Scroll & Zoom Functionality with Form Control
  • Animating Changes Over Time
  • Building a Dynamic Dashboard Part 1
  • Building a Dynamic Dashboard Part 2
  • Value Based Dynamic Formatting
  • Dynamically Highlighting a Data Series
  • Building a Custom Pacing Chart
  • Designing a Custom Gauge Chart
  • Visualize a Percentage Using Array Functions
  • Conclusion

Taught by

Chris Dutton

Reviews

Start your review of Excel Data Visualization Part 2: Advanced Demos

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.