To take this course, you must have a solid understanding of most topics covered in Excel Course 1A. Beneficial if you have knowledge of Course 1B topics.

Conditional Formatting and Data Validation aren’t just nice-to-haves—they're must-know tools in Excel.

This course helps you use them to spot patterns, highlight key info, and keep your data clean, accurate, and easy to manage.

Required Prior Knowledge: Solid understanding of most Excel Course 1A topics needed.

Helpful if you have some knowledge of Excel Course 1B topics.

Includes:

Conditional Formatting

Highlight Cell Rules
Top/Bottom Rules
Data Bars, Color Scales, Icon sets
Using Manage Rules
Clearing Rules
Using Formulas for a Rule
Absolute References in Rules
Conditional Formatting with Checkboxes

Data Validation

Restrict Entries in Cells
Customized Error Messages
Suppress Error Messages
Add Input Messages
Simple Drop-Down Lists
Create Drop-Down Lists from Data
Circumvent Validation Settings
Modify Validation Settings
Clear Validation

1161 - Excel Course 2A: Format & Validation Rules