Excel 2019 in 30 Minutes (Basics – 7 of 10): Conditional Formatting

Course Description:

When you master Excel, you have one of the most practical and valuable skillsets in modern business. Our “Excel in 30 Minutes” series can help you get started. By the end of this course, you will be able to use Conditional Formatting and Comparative Analysis Formatting to easily read and analyze data, as well as access and create templates for predefined formatting.

Course Duration: 28 minutes

Key Points:

• Use Conditional Formatting to make it easy to read and analyze your data
• Apply Conditional Formatting to Text, Numbers, and Dates to easily identify certain values or duplicates
• Apply Comparative Analysis Formatting to add Data Bars, Color Scales, and Icon Sets to your worksheets
• Access built-in Templates and create your own Custom Templates to use predefined formatting