Excel Data Visualization: Designing Custom Visualizations
2h 4mIntermediate2022-03-23
Authors
Chris Dutton
Certified Microsoft Excel Expert, Analytics Consultant
Course details
Interested in using more than the built-in chart and graph tools to showcase your data in Excel? In this course—the second and final installment in the Excel Data Visualization series—instructor Chris Dutton steps through how to create unique, custom data visualizations in Excel. Since Chris covered the core data visualization capabilities of Excel in the previous installment of the series, he dives into some more sophisticated techniques here. As he moves through a series of hands-on demos, Chris covers everything from building dynamic dashboards to advanced maneuvers like value-based formatting and dynamic series selection.
Learning objectives
Explain how to define the elements in a thermometer chart.
Review the purpose of OFFSET and COUNTA functions.
Relate why a guardrail is used when creating scroll bars and zoom bars.
Examine the reason for using value-based dynamic formatting.
Determine what a gauge-and-needle chart is and how to create one.
Learning objectives
Explain how to define the elements in a thermometer chart.
Review the purpose of OFFSET and COUNTA functions.
Relate why a guardrail is used when creating scroll bars and zoom bars.
Examine the reason for using value-based dynamic formatting.
Determine what a gauge-and-needle chart is and how to create one.
Skills covered
SpreadsheetsMicrosoft ExcelBusiness Software and ToolsMicrosoftOne-Off
Concepts
Introduction
- Part 2 - Introduction
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