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
- 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
Taught by
Chris Dutton
Related Courses
Intro to StatisticsStanford 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