YoVDO

Excel Data Visualization: Designing Custom Visualizations

Offered By: LinkedIn Learning

Tags

Data Visualization Courses Dynamic Charts Courses

Course Description

Overview

Go beyond the built-in chart and graph tools in Excel. Learn how to create custom data visualizations, including how to build dynamic dashboards and gauge charts.

Syllabus

Introduction
  • Part 2: Introduction
1. Next-Level Data Visualization Demos
  • Setting expectations
  • Image overlay chart
  • Binary ranges
  • Automation with OFFSET and COUNTA
  • Interactivity with form controls
  • Animating changes over time
  • Building a dynamic dashboard, part 1
  • Building a dynamic dashboard, part 2
  • Value-based formatting
  • Dynamic series selection
  • Custom pacing chart
  • Custom gauge chart
  • Visualizing percentages with arrays
Wrapping Up
  • Wrapping up

Taught by

Chris Dutton

Related Courses

Intro to Statistics
Stanford University via Udacity
Introduction to Data Science
University of Washington via Coursera
Passion Driven Statistics
Wesleyan University via Coursera
Information Visualization
Indiana University via Independent
DCO042 - Python For Informatics
University of Michigan via Independent