Microsoft Excel: Data Validation & Conditional Formatting

Wishlist Share

About Course

Make spreadsheets reliable and readable—drop-down lists, input rules, error alerts, conditional formatting rules, colour scales, icon sets and formula-based highlights.

Tutwoo is an independent learning provider. This course is not affiliated with or endorsed by any software company named. Product features and menus change over time—check the official help pages for the latest details.

What Will You Learn?

  • Create drop-down lists and input rules Use input messages and error alerts Apply conditional formatting rules Highlight with formulas

Course Content

Course Lessons

  • Data validation
  • Conditional formatting
  • Good practice

Sources & Further Reading
The official guidance this course is based on.

Final Assessment

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?

✕