Excel Data Visualization: Designing Custom Visualizations

Offered By: LinkedIn Learning

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