Skip to content
Microsoft Productivity Tools

Excel Data Management: Conditional Formatting and Data Validation


Course
No access code required
Enroll

This course focuses on essentials tools for improving data accuracy, consistency, and visibility in Excel.

Skills you'll gain: applying conditional formatting rules, creating and customizing formatting conditions, setting up data validation rules, creating drop-down lists, and using formulas in data validation to control data input.

Here is the course outline:

1. Conditional Formatting and Data Validation

Covers how to apply and customize conditional formatting using new formatting rules, and how to control data input through data validation, including setting validation criteria, creating drop-down lists, and using formulas to enforce data accuracy and consistency.

Copyright & Disclaimer
Module Reminders
Conditional Formatting and Data Validation Essentials
Knowledge Check!

2. We want to hear from you!

Learning Management System — NPS

We want to hear from you!
Back to top