Page 139 - Lean six sigma demystified
P. 139
118 Lean Six Sigma DemystifieD
FIGURE 4-12 • Data validation menu.
In the case of the travel group, it was time to mistake-proof the data entry form.
To clean up the dates, Excel’s Data Validation can require specific formats,
in this case a date after January 1, 2010. Just select column A, Data Validation,
and specify the criteria (Fig. 4-13).
FIGURE 4-13 • Validate using Format.
