City of St. Catharines Learning & Development

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