Conditional Formatting and Data Validation

Conditional Formatting and Data Validation

$69.00 USD for 1 year

Course Overview:

This course covers Conditional Formatting and Data Validation. You will learn how to highlight cells based on their contents, create data validation lists, and how to summarize numerical data based on values.

Key Topics:

  • Learn how to highlight values based on rank (top 5, 10, etc.)
  • Learn how to highlight duplicates, certain text strings, and dates
  • How to create custom formulas to highlight cells based on custom criteria
  • How to create a custom list with data validation
  • How to highlight criteria based on a before or after date
  • Create heat maps, helping you quickly analyze numbers based on colors (green for high, red for low)

Who Will Benefit?

Any professional that uses Microsoft Excel and needs to visualize data or highlight cells based on specific criteria.

Category: