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.
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.
Excel With Wayne is an online Microsoft Excel Training Course taught by Dr. Wayne Winston. Dr. Winston is the world's foremost Microsoft Excel Expert that teaches at some of the world's largest organizations including Microsoft and government organizations such as the Navy and Army.