Lesson ProgressPhase 3 of 6
Phase 3Guided Practice
Guided Practice: Build First Automation Layer
Simulator mirroring real workbook logic with immediate feedback
Phase 3: Safe Rehearsal
Simulate the Close Flow
Walk through each step of the automated close before touching the real workbook.
Month-End Close Flow Simulator
This simulator mirrors the exact logic your workbook automation will follow. At each step, identify what the automation needs to do. Get all five steps correct to complete the rehearsal.
Progress: Step 1 of 5
1
Read Input Data
Load the unadjusted trial balance amounts from the input area
Input: Unadjusted TB values
Expected Output: Values loaded into named ranges
→ Calculate Adjusting Entries
Bridge to Phase 4: The Real Workbook
The simulator you just completed mirrors exactly what your workbook automation will do. In Phase 4, you will:
- Download the starter workbook
unit02-lesson05-student.xlsx - Define named ranges for each input area
- Build calculation blocks for adjusting entries
- Add a verification checkpoint (debits = credits)
- Insert a button that runs the full close flow
Key difference: The simulator checked your understanding with text answers. The real workbook will compute actual numbers and prove the automation works with real data.