Description

In this course, explore advanced techniques for creating custom data visualizations in Excel. Learn how to build dynamic dashboards, apply value-based formatting, and use dynamic series selection to showcase data effectively.

What will you learn?

1. Explain how to define the elements in a thermometer chart.
2. Review the purpose of OFFSET and COUNTA functions.
3. Relate why a guardrail is used when creating scroll bars and zoom bars.
4. Examine the reason for using value-based dynamic formatting.
5. Determine what a gauge-and-needle chart is and how to create one.