Lesson ProgressPhase 3 of 6
Phase 3Guided Practice
Guided Practice: Build Self-Auditing Formulas and Error Flags
Rehearse formula logic before building in real workbook
Phase 3: Safe Rehearsal — Practice Formula Logic
Test SUMIF and Balance Check Logic Before Building in Excel
This simulator mirrors the formulas you'll build in Excel. Practice entering transactions and checking that your ledger balances before you work in the real workbook.
1
Enter Debits
2
Enter Credits
3
Check Balance
Step 1: Enter Debit Amounts
Enter the debit amount for each transaction. Think about what accounts Sarah is debiting in each case.
Client payment received
Account: Cash
Invoice sent to client
Account: Accounts Receivable
Supplies purchased
Account: Office Supplies
Bridge to Phase 4: Build Real Formulas in Excel
You just practiced the logic that SUMIF formulas and trial balance checks use. In Phase 4, you'll:
- Open your Lesson 04 workbook (the table you built)
- Write
=SUMIF()formulas using table column references - Create trial balance checks with
=IF()formulas - Add conditional formatting to create red flags for errors
The Excel formulas will work exactly like this simulator—totaling amounts and checking if your ledger balances.