Excel Skills for Internships: What to Know Before Day One

Excel for internships is less about advanced tricks and more about doing everyday tasks quickly and without mistakes. In most internships, the spreadsheet work is cleaning a list, looking up values, totalling by category and turning the result into a chart. This guide lists the skills to know before day one, shows a typical first-week task, and gives you a short plan to get ready.

What Excel tasks do interns usually get?#

Intern tasks tend to be small, practical and repeated. You might be asked to:

• Tidy a list someone exported from another system: remove duplicates, fix spaces, sort it.
• Fill in missing details, such as prices, managers or regions, by looking them up in another table.
• Total or count by category: sales by region, tickets by status, hours by project.
• Summarise a large table for a manager, often with a pivot table.
• Make a simple chart for a slide or a weekly email.
• Update a tracker every week without breaking its formulas.

None of these need macros or complex models. They need the right handful of functions and careful habits. The exact mix depends on the team: finance interns see more percentages and rounding, marketing interns more lists and charts, operations interns more trackers.

The Excel skills to know before day one#

Learn these in order. Each one builds on the one before.

XLOOKUP needs Excel 2021 or Microsoft 365. Many shared files still use VLOOKUP, so learn to read both. For a fuller list by level, see the Excel skills checklist, and for the graduate version of this list, Excel skills every fresh graduate should have.

A typical first-week task, solved#

Here is the kind of request an intern might get: "Add prices to these orders and tell me the total for each region." The orders are in A1:D7 and a price list is in G1:H6:

The price list has P-101 at 4.50, P-102 at 12.00, P-103 at 7.25, P-104 at 19.99 and P-105 at 3.00.

1. Look up each price. In E2, type this and fill it down to E7:

=VLOOKUP(C2,$G$2:$H$6,2,FALSE)

VLOOKUP finds the product ID in the first column of the price list and returns the value from column 2. FALSE means exact match, and the $ signs keep the price list in place as you fill down. The VLOOKUP function guide explains each argument.

2. Work out each line total. In F2, type =D2*E2 and fill down. Order 1001 is 4 × 12.00 = 48.00.

3. Total by region. In a small summary table, use SUMIF:

=SUMIF($B$2:$B$7,"North",$F$2:$F$7)

North comes to 103.99 (48.00 + 19.99 + 36.00). South is 81.00 and East 43.50. To count orders instead, =COUNTIF($B$2:$B$7,"North") returns 3. See the SUMIF function guide and the COUNTIF function guide.

4. Check it with a pivot table. Select the data, choose Insert > PivotTable, drag Region to Rows and the line total to Values. The pivot should show the same three totals. If the pivot and your formulas agree, you can send the numbers with confidence.

How to prepare in one or two weeks#

Short daily practice beats one long session. A simple plan:

1. Days 1–2: cells, ranges, basic formulas, filling down and absolute references.
2. Days 3–4: IF, COUNTIF and SUMIF on a small sales or ticket list.
3. Days 5–6: VLOOKUP and XLOOKUP, including what #N/A means and how to fix it.
4. Day 7: sorting, filtering, a first pivot table and a chart from it.
5. Days 8–10 (if you have them): timed practice tests and the tasks you found hardest.

Do the tasks with your own hands on real data. Reading a formula is not the same as typing it under time pressure. The guide on learning Excel fast for a job has more ideas for a short timeline. Not sure where you stand? The Excel level test takes 12 questions and tells you which skills to work on first.

Good habits on day one#

How you work with a shared file matters as much as which functions you know. These habits keep you out of trouble:

• Keep the raw data. Copy the original sheet before you change anything, or work on a copy of the file.
• Don't type over formulas. If a cell shows a total, click it and look at the formula bar before you edit.
• Use cell references, not typed numbers. =B2*$F$1 updates when the rate changes; =B2*0.08 doesn't.
• Check your totals two ways, for example with SUMIF and a pivot table, or by looking at the status bar sum.
• Label everything: headers, units (USD, hours) and the date the data was pulled.
• Ask early. A two-minute question about which column to use saves an afternoon of redoing work.

Will there be an Excel test for the internship?#

Some employers test Excel during hiring, especially for finance, consulting, operations and data internships. Tests usually check basic formulas, lookups, sorting and filtering, and sometimes a pivot table, often under a time limit. The guide to the Excel test for a job interview explains common formats, and the Excel interview questions for freshers lists questions with answers. To rehearse under time pressure, try the basic Excel test.

Practise it#

The fastest way to be ready is to do the tasks above yourself. Practise VLOOKUP in a live spreadsheet: you type the formula and it checks it instantly. Then build your first summary in the pivot tables lesson, and finish with the basics skill check, where you fix, calculate and format an order on your own with no hints.