Excel Take-Home Assignment: How to Plan, Build and Submit

An Excel take-home assignment is a task you complete on your own time: you get a data file and a brief, and you send back a workbook that answers the questions. To do well, plan before you build, keep the raw data safe, answer with clear formulas, and submit a file that a busy reviewer can understand in a few minutes. This guide walks through each step, from the first read of the brief to the email you send with the file.

What a take-home assignment tests#

A take-home task is different from a timed Excel test. You have more time, but the reviewer sees everything: your answers, your formulas, how you organised the file and how you explain your results. Assignments vary a lot between employers and roles, so treat the brief as the only rulebook.

Most briefs look for some mix of these:

• Correct answers to specific questions, such as totals, counts or averages by group.
• Data handling: spotting and fixing problems like duplicates or blank cells.
• Clear structure: a file that someone else can follow.
• Communication: a short summary, a chart or a recommendation.

If you're also preparing for a live task, the guide to the Excel case study interview covers the in-person version.

Step 1: Read the brief and ask questions early#

Read the whole brief before you open the data. Then make a list of every deliverable: each question, chart, sheet or note they ask for. It's easy to answer four questions well and miss the fifth.

Check for these details and write down anything unclear:

• The deadline and the time zone it's in.
• The format: one workbook, a slide, a written summary, or a mix.
• The expected time. If the brief suggests how long to spend, plan to stay close to it.
• Rules on tools, such as add-ins or AI assistants. If the brief doesn't say, ask.
• Unclear terms, such as whether "monthly revenue" includes refunds.

Send all your questions in one short email, early. If you get no answer in time, make a sensible assumption and write it down. Recording your assumptions is part of a good answer.

Step 2: Plan your time#

Split your time into blocks before you start, and stop polishing when a block ends. A simple plan for any length of task:

These shares are a starting point, not a rule. The point is to keep time for the review at the end. The guide to time management in an Excel test has more ways to avoid running out of time.

Step 3: Set up a workbook someone else can follow#

A reviewer should understand your file without asking you. A clear layout does most of that work:

Never edit the raw data. Copy it to a working sheet and turn it into an Excel table with Ctrl+T (Mac: ⌘T), so formulas and pivots pick up every row. Put any inputs, such as a target or a tax rate, in labelled cells instead of typing them inside formulas.

Step 4: Check and clean the data#

Real assignment data often has problems on purpose. Look before you calculate:

• Count rows and blanks. COUNTA and COUNTBLANK show how complete each column is.
• Look for duplicates in ID columns. Remove them on your working copy only, and note how many you removed.
• Check numbers and dates. Values that sit on the left of the cell are probably text and won't add up.
• Check categories. "North", "north " and "N" may all mean the same region. Clean them so your counts are right.

Write every fix on your Notes sheet: what you changed, how many rows it affected and why.

Step 5: Build the analysis with clear formulas#

Answer each question with a formula the reviewer can click and follow. COUNTIFS and SUMIFS cover a large share of typical questions. Using the hospital data in the exercise on this page (Ward in column B, Stay days in C, Readmitted in D):

=COUNTIFS($B$2:$B$8,F2,$D$2:$D$8,"Yes")

With "Ward A" in F2, this returns 2: patients P03 and P05. A matching total uses SUMIFS:

=SUMIFS($C$2:$C$8,$B$2:$B$8,F2)

That returns 12 days for Ward A (4 + 2 + 6). Put the ward names down column F, lock the ranges with $ and fill down to build a full summary table. The COUNTIFS guide and the SUMIFS guide cover the syntax.

Pivot tables are great for exploring and for quick group summaries. A good habit is to explore with a pivot, then put final answers in formula cells on the Summary sheet, where they sit in fixed places and can be checked against each other.

Avoid typing numbers you worked out elsewhere. A typed value looks the same as a formula result, but a reviewer can't check it.

Step 6: Present your answers#

Put the Summary sheet first and answer every question in the order the brief asks it. For each one, give the number, one sentence on what it means, and a link or note to where it's calculated.

• Use consistent formats: the same number of decimals, currency symbols where needed, dates in one style.
• Add a chart only if it helps answer a question. One clear chart beats five decorative ones.
• Make a recommendation if asked, and base it on your numbers. Note the limits, such as a small sample or missing months.

Step 7: Review and submit#

Keep your last block of time for this checklist:

1. Search for errors. Press F5 (Mac: Control+G), click Special, choose Formulas and tick only Errors to select every error cell.
2. Spot-check two or three answers another way, such as with a filter and the status bar total.
3. Remove clutter: test sheets, stray notes and hidden sheets you don't want seen.
4. Click cell A1 on each sheet and save with the Summary sheet open.
5. Name the file clearly, such as Firstname-Lastname-Excel-Assignment.xlsx, and save as .xlsx unless the brief asks for something else.
6. Close and reopen the file to make sure it opens and nothing is broken.
7. Send it with a short note: what's included, your main assumptions and anything you couldn't finish.

Submit before the deadline, not at the last minute. Be ready to explain any formula in a follow-up call; the Excel scenario interview questions are good practice for that conversation.

Practise it#

The best preparation is working a realistic case against the clock. Practise the hospital admissions case study, which asks for average stays, readmission rates and a by-ward summary, then sharpen your COUNTIFS and SUMIFS skills and build your first pivot table. When you're ready, try the timed Excel case study mock test. Not sure where you stand? Start with the Excel level test, and use the Excel practice tasks to do before a test to fill any gaps.