Home / Course catalog / Excel level 3 – 2 Reducing err... (Bus_Excel_03-02)

Business tools

Excel level 3 – 2 Reducing errors at source with data validation (Bus_Excel_03-02)


Description

This module helps learners prevent errors at source in shared operational files. It directly responds to the need to enforce dropdowns, allowed values, and input constraints, so only valid data is entered and colleagues are guided when they risk creating inconsistencies or wrong entries.

Content
  • What is data validation
  • How to create drop-down list
  • Optional : How to insert a checkbox
  • Optional : How to insert a check mark symbol
Completion rules
  • All units must be completed