# Marketing analyst Excel test: skills, sample task and prep plan

> Marketing screens ask you to turn campaign exports into answers: growth between periods, conversion by channel, spend against results, and a ranked list of what worked. Expect clean-ups, lookups between tables and conditional averages.

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

## What employers usually test

| Skill | Functions | Practice |
|---|---|---|
| Growth and rates | % change | [Lesson 4: Percentages & growth](https://spreadsheetpractice.com/learn/percentages-and-growth) (free) |
| Results by channel | SUMIFS, AVERAGEIFS | [Lesson 8: COUNTIFS, SUMIFS & AVERAGEIFS](https://spreadsheetpractice.com/learn/countifs-sumifs-averageifs) (free) |
| Joining tables | XLOOKUP | [Lesson 13: XLOOKUP](https://spreadsheetpractice.com/learn/xlookup) (Pro) |
| Share of total | running totals, $ | [Lesson 36: Running totals & share of total](https://spreadsheetpractice.com/learn/running-totals-share-of-total) (Pro) |
| Ranking campaigns | RANK, LARGE | [Lesson 34: RANK, LARGE & SMALL](https://spreadsheetpractice.com/learn/rank-large-small) (Pro) |
| Cleaning exports | TRIM, TEXTBEFORE | [Lesson 20: Cleaning messy data](https://spreadsheetpractice.com/learn/cleaning-messy-data) (Pro) |

## A sample task

**Conditional average.** In G7, average the revenue for the product in G3.

From [COUNTIFS, SUMIFS & AVERAGEIFS](https://spreadsheetpractice.com/learn/countifs-sumifs-averageifs). Solve it, graded instantly, at [the marketing analyst test page](https://spreadsheetpractice.com/excel-test/marketing-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 | [COUNTIF & SUMIF](https://spreadsheetpractice.com/learn/countif-sumif) | Free |
| 4 | [COUNTIFS, SUMIFS & AVERAGEIFS](https://spreadsheetpractice.com/learn/countifs-sumifs-averageifs) | Free |
| 5 | [XLOOKUP](https://spreadsheetpractice.com/learn/xlookup) | Pro |
| 6 | [Cleaning messy data](https://spreadsheetpractice.com/learn/cleaning-messy-data) | 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 | [RANK, LARGE & SMALL](https://spreadsheetpractice.com/learn/rank-large-small) | Pro |
| 11 | [Running totals & share of total](https://spreadsheetpractice.com/learn/running-totals-share-of-total) | Pro |
| 12 | [Median, quartiles & outliers](https://spreadsheetpractice.com/learn/median-quartiles-outliers) | 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

### Which skills matter most for a marketing analyst test?

Conditional totals and averages by channel, percentage change, and lookups that join an ad export to a budget table.

### Will I need PivotTables or charts?

Often, yes. The free Data tools track covers both, and the formulas here help you check the pivot.

### How long should I prepare?

Two weeks at about 30 minutes a day is enough for most screens.

## 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)
- [Data analyst](https://spreadsheetpractice.com/excel-test/data-analyst)
- [Operations analyst](https://spreadsheetpractice.com/excel-test/operations-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.
