Excel Skills Every DU Student Should Practise Before an Internship

Team DUverse

8/8/20252 min read

white concrete building during daytime
white concrete building during daytime

Excel may not be the most exciting item on your internship checklist, but being comfortable with it can make everyday tasks much easier. You might need to organise survey responses, check expenses, summarise research or prepare a quick report. You don’t have to become an advanced analyst before your first day. A handful of practical skills can help you work faster and make fewer mistakes.

Here’s a straightforward guide from Team DUverse to what’s worth practising—and how to get started for free.

Get comfortable with formulas and lookups

Start with formulas you’re likely to use in ordinary work. SUM adds values, AVERAGE calculates a mean, and COUNT or COUNTA helps you count numbers or non-empty cells. Learn IF to return different results depending on a condition, such as marking a score as “Pass” or “Review.” SUMIF and COUNTIF are useful when you need totals or counts that meet a particular condition.

Next, practise lookups. XLOOKUP can find a value in one column and return related information from another, such as matching a student ID to a department. If your version of Excel doesn’t include it, learn VLOOKUP as well. Pay attention to exact matches and check that your lookup range includes the columns you need. A small test table is a good place to practise before applying a formula to a larger sheet.

Turn raw data into useful summaries

Pivot tables let you group and summarise a long list without manually adding everything up. For example, you could total expenses by category, count responses by year, or compare sales across months. Keep your source data tidy: use a single header row, avoid merged cells, and make sure each row represents one record. Select the data, insert a pivot table, then experiment with placing fields in rows, columns, values and filters.

Conditional formatting makes patterns easier to spot. Use it to highlight duplicate entries, overdue dates, unusually high values or scores below a threshold. Choose rules that explain themselves, and don’t rely on colour alone if the sheet will be shared or printed.

Simple charts can communicate a finding quickly. Use a bar or column chart to compare categories, a line chart to show change over time, and a pie chart only when you have a few parts of one whole. Add a clear title, label axes where needed, and remove decorative clutter.

Save time with shortcuts

A few keyboard shortcuts can make routine work feel much smoother. Try Ctrl+C and Ctrl+V to copy and paste, Ctrl+Z to undo, Ctrl+F to find text, and Ctrl+Arrow to jump to the edge of a data region. Ctrl+Shift+L toggles filters in many Excel versions; Ctrl+T turns a range into a table. On a Mac, many shortcuts use Command instead of Ctrl. Practise them as you work rather than trying to memorise a long list at once.

Practise with real datasets for free

Use public datasets from sources such as government open-data portals, Kaggle’s free datasets, or World Bank Data. Pick a topic you care about, download a small CSV file and explore it in Excel. Clean up headings, check for blanks, calculate a few summary figures, build a pivot table and create one chart. Save a copy of the original so you can compare your changes.

For a simple routine, spend 20 minutes on one dataset and write down what each formula or chart tells you. The goal isn’t to make a perfect dashboard; it’s to practise turning untidy information into a clear answer. That confidence will serve you well when your first internship task lands.

Subscribe for exciting updates: