Excel practice by role
Nobody sets out to learn SUMIFS. They set out to get through a financial analyst interview, or to stop dreading the monthly report. Pick the job you are in — or the one you are interviewing for — and practice what it actually asks of you.
Finance
Finance runs on spreadsheets that other people rely on without checking. That raises the bar: a formula that is merely usually right is a liability, because nobody downstream will catch it.
17 exercises
Accounting
Accounting Excel is reconciliation work: two lists that should agree, and the job of finding out where they do not.
8 exercises
Sales
Sales spreadsheets answer one question in many forms: who is ahead, who is behind, and what does that mean for their commission.
13 exercises
Marketing
Marketing analysis is mostly combining exports that were never designed to be combined, then working out cost per outcome.
2 exercises
Human Resources
HR data is small, sensitive and full of dates — which makes date arithmetic and careful conditional logic the core skills.
3 exercises
Operations
Operations spreadsheets are early-warning systems: they exist to flag the thing that is about to go wrong.
10 exercises
Data Analyst
The job description says analysis. The calendar says cleaning, joining and reshaping, and Excel is where most of that still happens.
9 exercises
Business Analyst
A business analyst turns a vague question into a number someone will act on, and has to be able to defend how they got there.
8 exercises
Product Manager
Product managers use Excel to answer their own questions quickly rather than waiting a week for someone else's queue.
3 exercises
Consultant
Consultants build models fast, on someone else's messy data, and then have to defend the numbers in front of the client.
5 exercises
Student
Excel is the skill most often screened for before an interview and most often overstated on a résumé. Closing that gap is worth more than another line on the CV.
13 exercises