# Financial analyst Excel test: what's on it and how to prepare

> Finance interviews often include a timed Excel task: pull numbers from a table, summarize by segment, and build a small model that still works when the inputs change. Here is what to practice, a sample task, and a 14-day plan.

Source: https://spreadsheetpractice.com/excel-test/financial-analyst · Updated October 29, 2026

## What employers usually test

| Skill | Functions | Practice |
|---|---|---|
| Lookups across tables | XLOOKUP, INDEX/MATCH | [Lesson 13: XLOOKUP](https://spreadsheetpractice.com/learn/xlookup) (Pro) |
| Totals by segment | SUMIFS | [Lesson 8: COUNTIFS, SUMIFS & AVERAGEIFS](https://spreadsheetpractice.com/learn/countifs-sumifs-averageifs) (free) |
| Locked references in models | $ signs | [Lesson 3: Relative vs absolute references](https://spreadsheetpractice.com/learn/relative-absolute-references) (free) |
| Growth and margins | % change | [Lesson 4: Percentages & growth](https://spreadsheetpractice.com/learn/percentages-and-growth) (free) |
| Weighted averages | SUMPRODUCT | [Lesson 35: SUMPRODUCT](https://spreadsheetpractice.com/learn/sumproduct) (Pro) |
| Time value of money | PMT, NPV, IRR | [Lesson 41: NPV & IRR](https://spreadsheetpractice.com/learn/npv-irr) (Pro) |
| Clean outputs | ROUND | [Lesson 33: ROUND, ROUNDUP & ROUNDDOWN](https://spreadsheetpractice.com/learn/round-roundup-rounddown) (Pro) |

## A sample task

**Net present value.** In E4, calculate the project's NPV at the discount rate in E2. Year 0 is an upfront investment.

From [NPV & IRR](https://spreadsheetpractice.com/learn/npv-irr). Solve it, graded instantly, at [the financial analyst test page](https://spreadsheetpractice.com/excel-test/financial-analyst).

## A 14-day prep plan

About 30 minutes a day.

| Day | Focus | Access |
|---|---|---|
| 1 | [Relative vs absolute references](https://spreadsheetpractice.com/learn/relative-absolute-references) | Free |
| 2 | [Percentages & growth](https://spreadsheetpractice.com/learn/percentages-and-growth) | Free |
| 3 | [AND, OR & IFS](https://spreadsheetpractice.com/learn/and-or-ifs) | Free |
| 4 | [COUNTIFS, SUMIFS & AVERAGEIFS](https://spreadsheetpractice.com/learn/countifs-sumifs-averageifs) | Free |
| 5 | [XLOOKUP](https://spreadsheetpractice.com/learn/xlookup) | Pro |
| 6 | [INDEX & MATCH](https://spreadsheetpractice.com/learn/index-match) | Pro |
| 7 | [Tiered lookups & IFERROR](https://spreadsheetpractice.com/learn/tiered-lookups-iferror) | Pro |
| 8 | [ROUND, ROUNDUP & ROUNDDOWN](https://spreadsheetpractice.com/learn/round-roundup-rounddown) | Pro |
| 9 | [SUMPRODUCT](https://spreadsheetpractice.com/learn/sumproduct) | Pro |
| 10 | [Loan payments with PMT](https://spreadsheetpractice.com/learn/pmt-loan-payments) | Pro |
| 11 | [Future & present value](https://spreadsheetpractice.com/learn/future-and-present-value) | Pro |
| 12 | [NPV & IRR](https://spreadsheetpractice.com/learn/npv-irr) | Pro |
| 13 | [Timed run: the analyst interview capstone](https://spreadsheetpractice.com/learn/capstone-analyst-interview) | Pro |
| 14 | [Retake the skills test and compare](https://spreadsheetpractice.com/excel-skills-test) | Free |

## Questions

### Is the test done in Excel or in a browser?

It varies by employer. Some send a workbook to complete; others use an online simulator. Practice both: build formulas from scratch, and read formulas someone else wrote.

### What do graders look at besides the answer?

How you got there: one formula filled down instead of typed numbers, locked references, and inputs kept in their own cells so the model can be changed.

### How long should I prepare?

About 30 minutes a day for two weeks covers the plan below, including two timed practice runs.

## Prep for other roles

- [Accountant](https://spreadsheetpractice.com/excel-test/accountant)
- [Administrative assistant](https://spreadsheetpractice.com/excel-test/administrative-assistant)
- [Data analyst](https://spreadsheetpractice.com/excel-test/data-analyst)
- [Operations analyst](https://spreadsheetpractice.com/excel-test/operations-analyst)
- [Marketing analyst](https://spreadsheetpractice.com/excel-test/marketing-analyst)
- [HR analyst](https://spreadsheetpractice.com/excel-test/hr-analyst)
- [Sales analyst](https://spreadsheetpractice.com/excel-test/sales-analyst)
- [Project manager](https://spreadsheetpractice.com/excel-test/project-manager)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
