Which Excel skills does a banking job need on day one?

You need five things comfortable on day one: VLOOKUP/INDEX-MATCH, pivot tables, a handful of formulas (SUM, SUMIF, COUNTIF, nested IF), basic data cleaning, and enough keyboard shortcuts that you're not hunting through menus while your reporting manager waits.

The core five

VLOOKUP and INDEX-MATCH. Banking work runs on cross-referencing — matching a customer ID against a KYC sheet, pulling a branch code against a transaction log, checking a loan account against a disbursement list. If you can't do a lookup without asking a colleague, every small task takes three times as long.

Pivot Tables. Most of what a new banking employee produces in the first month is some version of "summarize this transaction data by branch/product/date." Pivot tables are how that gets done in minutes instead of hours of manual sorting.

SUM, SUMIF, COUNTIF, and nested IF. These four cover a surprising amount of ground — daily cash reconciliation, flagging accounts above a threshold, counting how many transactions fall into a category. You don't need to be a formula wizard, but these four should be automatic.

Data cleaning. Real bank data is messy — extra spaces, inconsistent date formats, duplicate entries from system exports. TRIM, Text to Columns, Remove Duplicates, and conditional formatting to flag outliers will save you from reporting wrong numbers on day one, which is the fastest way to lose a manager's trust.

Keyboard shortcuts. Ctrl+Arrow to jump across a sheet, Ctrl+Shift+L to toggle filters, Ctrl+Shift+End to select to the last cell with data. Banking teams work fast and watch how fast you work — someone clicking through ribbons for ten minutes stands out, and not in a good way.

What you can skip for now

Macros, VBA, Power Query, complex array formulas — genuinely useful later, but nobody expects a new joiner to know them. If you show up with the five basics solid and accurate, you're already ahead of most freshers.

How to actually get there before day one

Don't just watch tutorials — build one small "project" that mimics real work: take a dummy dataset of 500-1000 transactions, build a pivot table summary by category, and do a VLOOKUP-based reconciliation against a second sheet. Doing it once with your own hands teaches you more than an hour of watching someone else click through it.

One more thing worth knowing: accuracy matters more than speed at first. A slow correct pivot table beats a fast wrong one — nobody remembers how quickly you finished, everyone remembers if the numbers were off.

If you're preparing for your first banking role and want structured, hands-on practice with these exact tools — alongside the actual banking processes they're used for — AKROS Solution's retail banking program builds Excel fluency into the classroom training itself, not as an afterthought.