Formula Systems
SUM, XLOOKUP, absolute references, SUMIFS, COUNTIF, IF, ABS, and ratio formulas.
Excel accounting game
Close Sheet
A spreadsheet-style training game built to teach accountants how to work efficiently in Excel by learning repeatable systems, not just memorizing formulas.
fx
=SUM(C4:C10)
ABCD
1CloseReceipts
2DateCustomerReceiptMethod
36/03Apex$4,820ACH
46/05Ridge$3,110Wire
56/07Northstar$7,250ACH
6Control total$26,285
Purpose
Teach the systems behind fast accounting work.
Close Sheet is designed around the way accountants actually use Excel: tying out schedules, building formulas once, filling them down, separating assumptions from outputs, surfacing exceptions, and moving through workbooks without relying on the mouse.
What it teaches
Twelve close-work scenarios.
Accounting Application
Cash receipts, bank recs, A/R aging, variances, accruals, prepaids, depreciation, and margins.
Keyboard Efficiency
AutoSum, Fill Down, Ctrl/Cmd+Enter checks, Tab movement, F2 edit mode, and name-box jumps.
Guided Learning
Each prompt includes why the step matters, the Excel move, and how it applies to real accounting work.
Game loop
Learn by building the workbook.
- Select the target cell in an Excel-like worksheet.
- Read the guided accounting purpose and Excel move.
- Enter the formula or use the shortcut system.
- Fill down where the schedule requires repeatable logic.
- Check the answer and earn efficiency points for better workflow.