# Data analyst Excel test: practice the skills that get checked

> Data analyst screens lean on summarizing and reshaping data: multi-condition counts, lookups, splitting text, and modern dynamic-array functions that return whole tables from one formula.

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

## What employers usually test

| Skill | Functions | Practice |
|---|---|---|
| Multi-condition summaries | COUNTIFS, SUMIFS | [Lesson 8: COUNTIFS, SUMIFS & AVERAGEIFS](https://spreadsheetpractice.com/learn/countifs-sumifs-averageifs) (free) |
| Lookups | XLOOKUP, INDEX/MATCH | [Lesson 13: XLOOKUP](https://spreadsheetpractice.com/learn/xlookup) (Pro) |
| Filtering and sorting | FILTER, SORT, UNIQUE | [Lesson 27: FILTER](https://spreadsheetpractice.com/learn/filter-function) (Pro) |
| Splitting text | TEXTBEFORE, TEXTAFTER | [Lesson 21: TEXTBEFORE, TEXTAFTER & FIND](https://spreadsheetpractice.com/learn/textbefore-textafter-find) (Pro) |
| Readable formulas | LET | [Lesson 28: LET](https://spreadsheetpractice.com/learn/let-function) (Pro) |
| Ranking | RANK, LARGE | [Lesson 34: RANK, LARGE & SMALL](https://spreadsheetpractice.com/learn/rank-large-small) (Pro) |

## A sample task

**Two conditions.** In F5, return rows where the region matches G2 and the amount is greater than G3. If nothing matches, show None.

From [FILTER](https://spreadsheetpractice.com/learn/filter-function). Solve it, graded instantly, at [the data analyst test page](https://spreadsheetpractice.com/excel-test/data-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 | [AND, OR & IFS](https://spreadsheetpractice.com/learn/and-or-ifs) | Free |
| 3 | [COUNTIFS, SUMIFS & AVERAGEIFS](https://spreadsheetpractice.com/learn/countifs-sumifs-averageifs) | Free |
| 4 | [XLOOKUP](https://spreadsheetpractice.com/learn/xlookup) | Pro |
| 5 | [INDEX & MATCH](https://spreadsheetpractice.com/learn/index-match) | Pro |
| 6 | [LEFT, RIGHT, MID & LEN](https://spreadsheetpractice.com/learn/left-right-mid-len) | Pro |
| 7 | [TEXTBEFORE, TEXTAFTER & FIND](https://spreadsheetpractice.com/learn/textbefore-textafter-find) | Pro |
| 8 | [UNIQUE & SORT](https://spreadsheetpractice.com/learn/unique-sort) | Pro |
| 9 | [FILTER](https://spreadsheetpractice.com/learn/filter-function) | Pro |
| 10 | [LET](https://spreadsheetpractice.com/learn/let-function) | Pro |
| 11 | [RANK, LARGE & SMALL](https://spreadsheetpractice.com/learn/rank-large-small) | Pro |
| 12 | [SUMPRODUCT](https://spreadsheetpractice.com/learn/sumproduct) | 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 Excel still tested if the job uses SQL or Python?

Often, yes. Excel is a quick way for interviewers to see how you summarize and check data.

### Should I learn dynamic arrays?

Yes. FILTER, SORT and UNIQUE replace many manual steps and signal that you know current Excel.

### How long should I prepare?

Two weeks at 30 to 45 minutes a day, finishing with the timed capstone.

## Prep for other roles

- [Financial analyst](https://spreadsheetpractice.com/excel-test/financial-analyst)
- [Accountant](https://spreadsheetpractice.com/excel-test/accountant)
- [Administrative assistant](https://spreadsheetpractice.com/excel-test/administrative-assistant)
- [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.
