hotkey.gg / drill library
◆ the drill library

74 drills, zero mouse

The whole curriculum — from arrow-key navigation to full three-statement builds. Every drill has a par time, an optimal key count, a watchable demo, a follow-along walkthrough, and a leaderboard. The chords are the Windows banker set; on a Mac, ⌘ and ⌥ speak the same language.
start training → the shortcut compendium
certificate trackExcel Keyboard Fluency · 16 drills → “Excel Keyboard Fluency”
Navigation, editing and formatting — the full keyboard loop, at speed. Finish every drill in the track with clean recorded runs to earn the certificate.
Foundations · 7 drills
Navigate and select
One long switchback corridor through solid walls: every straightaway is a single shot, eve
Fill down, fill right
A quarterly operating build off the revenue feed — three cost lines across the year, EBITD
Paste Special everything
The full paste-special toolkit — transpose, divide, multiply, formats, values
Assemble and format the summary
COPY what stays, CUT what moves — the feeds run in segment order; dress the table as you g
Rebuild the schedule
Full structural surgery — insert the missing line and the missing quarter, delete the squa
Repair the schedule
A review came back on the schedule — a misspelled team, an FY formula pointing at the wron
Run the model tour
The Foundations capstone — four subtotals blown to #REF! in a live P&L: rebuild the cascad
Formatting · 9 drills
Typeset the memo
Bold the header, unbold the imposter, italicize the memos, flag the discontinued line in r
The decimals pass
Take a comps page to the house decimal standard, and find the cell somebody hand-formatted
Set the alignment
Center, left, right — and a long title centered across the table, never merged
Fix the squeezed columns
A print page nobody can read — fit the labels to their content, hold the quarter block to
Rule off the schedule
Accounting rulings: line under headers, line above every total, outline the headline
The ruling pass
The page says done — the pass disagrees. Exactly 4 ruling breaks hide among the house conv
Clean the paste
Dress a raw pasted comp sheet — weight, alignment, commas, blue ink, wrap and width
Clean it to standard
A full cleanup pass: title, headers, blue inputs (one buried), commas, %, the totals ruled
Make it model-ready
The Formatting capstone — a raw sources & uses taken to book standard: blue inputs, live t
certificate trackSpreadsheet Formulas & Data · 28 drills → “Spreadsheet Formulas & Data Analysis”
Live formulas, lookups, data hygiene and formula auditing — built and checked without the mouse. Finish every drill in the track with clean recorded runs to earn the certificate.
Formulas I · 9 drills
Margins across the page
Three ratio columns on one peer page — the margin, the growth rate and the EV/EBITDA multi
Total it both ways
SUM across and down, tie out the corner
Pin the reference
Cycle the reference locks — one pinned formula prices the whole grid
Common-size both statements
Both blocks ÷ their OWN revenue, $-locked so the fill can’t drift
Compound it, three times
Compound each segment’s own rate, then read which one actually grew fastest
Point-mode formulas
Roll revenue forward off the growth line, then price EBITDA off the margin line
Roll up the segments
SUMIF rollup + live foot + % of total, summary formatted
Sum on two criteria
Roll a booking ledger into a segment × region cross-tab, then prove it back
Convert the page — one anchored rate
One blue, boxed rate drives every converted figure — a locked driver broadcast across the
Data & Lookups · 9 drills
Sort the table
A pipeline log ranked by size, a seventh deal signed late — rank it, land the newcomer, ra
Clean the export
A system export with a duplicate header, a page-break row, and a stale SUBTOTAL — delete a
Work the filtered view
Two screens off one pipeline — narrow the list, read what is left
Unhide the rows
An inherited regional tape with two regions’ detail hidden outright — no ⊞, no trace, and
Look it up
Read a peer table with INDEX/MATCH — three pulls onto one pitch screen
Two-way lookup
INDEX with two MATCHes — row and column at once
Two systems, one truth
COUNTIF for presence, INDEX/MATCH for amounts — drive Δ to zero
Hardcode it
A snapshot still wired into the model — flatten what ships, mark it, archive it, then dele
Serve the year table
A plan page that came back with its frame stripped — rebuild the year header and the line
Formulas II · 10 drills
Review pass — find what’s broken
A divisional review page came back with four breaks in it — a short Total, two typed-over
Error triage — #REF! #DIV/0! #VALUE!
Three live errors and eight red cells — read what each one says, find the causes, rebuild
Wrap it or fix it
Three reads down for three different reasons — wrap the truly missing, repair the merely b
Make it tie — hunt the break
A four-year balance sheet with three breaks in it — the check row pasted over with zeros,
Re-point the stale links
Assumptions moved to v2 — three cells still read the dead block
Scenario switch with CHOOSE
One switch drives the page — a driver block repositions every assumption, and a self-refer
Collapse the suspect leg
Eight legs behind a printed figure and one still reads last quarter — foot the block, coll
Flip the signs back
One plan year came in on the other sign convention — find it, flip it, re-lay EBIT
Replace hardcodes so it rolls forward
Every rate is typed inside a formula — lift them onto the panel so the page rolls forward
Make it balance
Three years of balance sheet with neither side totalled — foot the assets, foot the liabil
certificate trackFinancial Modeling Keyboard Mastery · 30 drills → “Financial Modeling Keyboard Mastery”
DCF, LBO, three-statement builds and debt schedules — full working models, keyboard only. Finish every drill in the track with clean recorded runs to earn the certificate.
Models I · 10 drills
Build the discount rate
Unlever a five-comp beta set, relever at your own structure, weight both sides
Build the unlevered FCF
EBIT → less taxes → NOPAT → plus D&A, less capex and the NWC build: the row every DCF disc
Discount the cash flows
Discount factors × free cash flows build the present-value row; a Gordon terminal value an
Run the comps
Build both enterprise-value multiples across the peer set, read the median, high and low,
Run precedent transactions
A six-deal precedent tape, the median multiple paid, and the implied equity value
Build the football field
Six methodologies on one per-share axis — midpoints, implied premiums, and the reference r
Run the sensitivity table
A two-way DCF sensitivity — five discount rates across, three growth rates down
Attribute the returns
Split the equity gain into growth, multiple and debt paydown — shares of the gain, checked
Run accretion / dilution
Cash, stock or both — pro forma EPS against standalone, drag included
Balance sources and uses
Foot both sides, size the sponsor equity to balance, prove the check at zero, then common-
Models II · 10 drills
Roll it forward
Five years of fixed assets — capex adds, depreciation takes its cut, and every year opens
Run the interest schedule
A term loan that opens where it closed, cash interest on the beginning balance, and the co
Run the LBO math
One entry multiple, three exit years — the equity bridge across all four, then MOIC and IR
Sweep the revolver
Draw, sweep and roll one revolver across four years
Run the paydown waterfall
Foot the cash a credit page has for debt, then cascade it down two tranches by seniority
Run the covenant table
Two leverage tests against a stepping maximum — headroom every quarter, a compliance flag,
Bridge the liquidity — three cases
Cash plus revolver availability walked to ending liquidity across three cases, and the cus
Run the 13-week
The restructuring staple: a weekly cash roll-forward, an anchored liquidity cushion, and t
Run the debt schedule
Roll the term loan year to year — mandatory amortization, a capped cash sweep, interest on
Run the full cascade
The Models II capstone — three facilities, four years, cash applied strictly by seniority:
Full Builds · 10 drills
Build the income statement
Five forecast years off one driver panel — revenue grown year on year, the cost lines as a
Balance the balance sheet
Three years: roll retained earnings, total both sides, land the check at zero
Link the cash flow statement
Point the statement at its schedules, close the cash roll year to year, read cash conversi
Roll working capital
Roll receivables, inventory and payables off three day-count drivers
Tie the three statements
Three statements on one page — net income, cash and retained earnings wired, the check at
Build the operating model
The commercial plan lands as units and a price — build five plan years off a four-cell dri
Build the DCF page
The valuation page a deal book opens on — discount five years of free cash flow, add a ter
Build the paper LBO
Size the deal at close, mark the same page at exit, and read the sponsor return — the equi
Build the debt & interest block
A term loan and a revolver, each priced on its own rate — both roll-forwards, interest on
Build the model cover
Page one of the pack: wire the headline metrics off the model outputs strip for both cases
Excel is a registered trademark of Microsoft Corporation. hotkey.gg is independent and not affiliated with or endorsed by Microsoft. More: the shortcut compendium · all drills · about hotkey.gg.