September 13-16, 2020 I Wherever You Are

Excel: Tell a Compelling Data Story with Conditional Formatting

September 15, 2020
1:30 pm - 2:30 pm

Excel: Tell a Compelling Data Story with Conditional Formatting

Excel’s conditional formatting capability is a powerful tool that allows users to highlight a specific cell or group of cells, depending on the value. The power of color and highlights helps the presenter tell an impactful visual story immediately and explore and analyze the most relevant data for the audience. During this in-depth session, we will begin with a foundational demonstration of how to use this quick and easy tool to showcase data and ramp up to the fullest potential of conditional formatting.  See how to use this tool effectively to emphasize the most valuable data for users. We’ll cover:

  • Apply highlight rules to your data set
  • Formatting based on formulas
  • Make a rule dependent on the content of another cell
  • Highlight rows based on drop-down list
  • Use multiple conditions for a Rule with logical operators (AND/OR)
© Diversified Communications. All rights reserved.