Advanced Data Validation

Adv DV-2

  • Why data validation?

  • Introduce Different types of DV (How to make DV works)

  • Fine tune the setting of DV

  • Create your own rules with DV (How to make DV work for you)

  • Find, copy and remove DV (How to handle DV embedded in other’s module)

  • Explore formula-driven-DV

  • Get familiar with some key formulas

  • Apply hierarchy structure into DV (selection of 2nd cell is purely based on 1st cell)*

  • Create and maintain database for Dependant DV