Here is what nobody tells incoming interns: your Excel is visible from across the room. Within the first days, whoever sits near you knows whether you touch the mouse, whether your formatting follows the conventions, whether the basics are fluent and that impression feeds directly into what you get staffed on, which feeds everything the conversion article describes. Nobody expects you to model on day one. Everyone notices keyboard fluency by day two. The good news: the gap is closable in 15-20 focused hours. Here is where to spend them.
Excel: the checklist
The Excel standard · what is visible by day two
NO MOUSE · The single standard that signals training. Navigate, select, jump between sheets and edit cells from the keyboard until the mouse feels slow.
THE EDITING CORE · Fluent cell editing, anchoring references without thinking, repeating and undoing actions, pasting values and formats deliberately rather than by default.
THE FUNCTION SET · Conditional sums and counts, modern lookups, error handling around them and the basic date arithmetic every model leans on. Ten functions used fluently beat fifty half-known.
THE COLOUR CONVENTION · Blue for hardcoded inputs, black for formulas, green for links to other sheets. It is the market's shared language for what can be safely changed.
STRUCTURE HABITS · One formula per row, written once and filled across. No numbers buried inside formulas. A checks row that sums to zero, because models that verify themselves are the house style everywhere.
PRINT AND PRESENT · Clean page setup and a tab order a stranger can follow. Analysts print more than students believe.
PowerPoint: the junior's real job
Students prepare for PowerPoint as if the task were design. It is not; banks run on templates and the intern's job is precision inside one. The skills that matter: aligning and distributing objects properly rather than by eye, keeping text hierarchies consistent, formatting a table so the numbers sit where a reader's eye expects them and the discipline layer that seniors actually check, footnotes present, sources cited, page numbers right, every figure agreeing with the model it came from. A junior whose pages never need format fixes is materially more valuable than one with opinions about layout and the reputation forms exactly that fast.
What not to waste hours on
Three honest deprioritisations. Macros and VBA: genuinely useful one year in, invisible on day one and most desks would rather you did not automate what you cannot yet do manually. Programming: a real asset in the medium term, not a substitute for Excel fluency now and no staffer has ever assigned an intern for their Python. And advanced charting artistry, because the bank's chart formats are already decided. The pattern is the same as certificate collecting on the CV: depth in the core beats breadth in the impressive. If a modelling test sits between you and the seat, that is its own preparation, covered in the modelling tests article; this checklist is about the different exam that starts the morning you arrive.
The 15-20 hour plan
One week of no-mouse Excel, forcing it on everything you do, is worth more than any course. Then rebuild one simple three-statement model from a blank sheet, twice, the second time against a clock, applying the colour and structure conventions throughout. Then two hours in PowerPoint recreating a clean public deck page, to standard, with alignment tools only. That is the whole programme and it puts you ahead of most of your intern class, because most of them will have spent the same weeks on none of it. What the desk actually looks like when you land and how the first impressions get made, is the territory of the first-90-days article on this site and the day-in-the-life piece. If you want your readiness checked against what staffers actually notice, that is a natural fit for the IBD Recruiting Review.
FAQ
What Excel skills do I need before a banking internship?
Keyboard-only navigation, fluent editing and anchoring, a core set of ten functions used well, the blue-black-green colour convention and models that check themselves.
Do I need VBA or Python before an internship?
No. Macros are invisible on day one and programming is not a substitute for Excel fluency. Depth in the core beats breadth in the impressive.
How long does it take to prepare Excel for banking?
15-20 focused hours: a week of mouse-free Excel, one simple three-statement model rebuilt twice and two hours recreating a clean deck page to standard.
Former Executive Director in TMT Investment Banking at Nomura and M&A banker at BNP Paribas. Top-rated mentor with 300+ sessions. About
