Lesson ProgressPhase 3 of 6
Phase 3Guided Practice
Guided Practice: Polish Wizard Interface: Validation, Controls, and Auditability
Simulator mirroring real workbook validation logic with immediate feedback
Phase 3: Safe Rehearsal
Validation Logic Simulator
Practice identifying what each validation rule should do before adding them to the real workbook.
Validation Rule Trainer
Each rule below is one validation check you will add to your workbook in Phase 4. Identify what the automation should do when the rule is triggered.
Progress: Rule 1 of 5
1
Supplies Amount Check
Must be between 0 and the unadjusted Supplies balance
Input: Supplies used amount
Expected Behavior: Flag negative amounts or amounts greater than the total
→ Period Date Check
Bridge to Phase 4: The Real Workbook
The validation rules you just practiced will be added to your Lesson 5 workbook. In Phase 4, you will:
- Open your Lesson 5 workbook (or download the starter)
- Add validation rules for each input field
- Build user-facing controls (dropdown or toggle cell)
- Create an audit panel showing inputs, outputs, and verification
- Update the button flow to check validation before running
Key difference: The simulator asked you to identify correct behaviors. The real workbook will enforce those behaviors with actual formulas and conditional formatting.