Excel Skills Every Virtual Assistant Needs

The Excel skills for virtual assistant work are practical ones: cleaning messy client lists, filtering and sorting, joining names and emails, counting and totalling, and keeping simple trackers. You rarely need advanced modelling. You do need to work fast and hand back sheets the client can trust. This guide is for new and working virtual assistants who want to know which skills to learn first, with a small example for each.

What virtual assistants use Excel for#

A virtual assistant (VA) uses Excel mostly to organise information for a client. The work is varied, but it falls into a few repeating jobs:

The work overlaps heavily with office roles, so the guide to Excel skills for admin jobs is useful too. If you support online shops, see the Excel skills for ecommerce, which adds product and order data.

Cleaning messy lists with TRIM and PROPER#

Cleaning text is the skill VAs use most, because client lists arrive full of extra spaces and odd capitals. TRIM removes spaces at the start and end of a cell and turns double spaces between words into single ones.

In B2, =TRIM(A2) returns Ben Cole. The raw cell has 12 characters and the cleaned one has 8, so =LEN(A2) and =LEN(B2) show the difference. In B3, =PROPER(TRIM(A3)) returns Aisha Khan, with a capital at the start of each word.

Why does it matter? "Ben Cole " with a trailing space is a different value to Excel than "Ben Cole". It won't match in a lookup, it sorts in the wrong place, and COUNTIF misses it. The TRIM function guide covers the details, and Practise cleaning text in a live spreadsheet to build the habit.

After you clean a column with formulas, replace the originals: copy the results, then paste them as values (Windows: Ctrl+Alt+V, then V, then Enter; Mac: ⌃⌘V, then choose Values). Then delete the helper column.

Filtering and sorting client data quickly#

Filtering hides the rows you don't need so you can work with the ones you do. Click any cell in the list and press Ctrl+Shift+L (Mac: ⌘⇧F) to add filter arrows to the header row. Then pick values, such as only the "Pending" invoices or only the leads from one city.

Three habits make filtering reliable:

• One header row with a unique name in each column.
• No blank rows in the middle of the data, because Excel stops the list at the first fully blank row.
• Clean values. "London" and "London " show as two separate items in the filter list.

For a list that updates itself, the FILTER function returns matching rows with a formula, for example =FILTER(A2:C7,C2:C7="Yes"). It needs Excel 2021 or Microsoft 365. Practise filtering a table to get quick at both methods.

Joining names and emails with TEXTJOIN#

Joining text means combining several cells into one, such as a full name or a list of emails. For two or three cells, the & operator is enough: =A2&" "&B2 joins a first and last name with a space.

For a whole column, TEXTJOIN is faster. It takes a separator, a TRUE or FALSE for skipping empty cells, and the cells to join:

=TEXTJOIN("; ",TRUE,B2:B7)

This returns every email in B2:B7 as one line, separated by a semicolon and a space, ready to paste into the To box of an email. To join only some of them, such as the people who replied Yes, put FILTER inside:

=TEXTJOIN("; ",TRUE,FILTER(B2:B7,C2:C7="Yes"))

On the sample data in the exercise below, the result is lena@example.com; aisha@example.com; ben@example.com; omar@example.com. TEXTJOIN needs Excel 2019 or later. The TEXTJOIN function guide has more examples, and you can practise joining text in a live spreadsheet.

Counting and totalling with COUNTIF and SUMIF#

Clients ask simple questions: how many leads are new, how much is still unpaid. COUNTIF counts cells that match a condition, and SUMIF adds the numbers next to them.

In the last formula, F1 holds Friday's date. The & joins the operator to the cell value. These are the same skills tested in most admin and support roles, as the guide to Excel skills for customer service shows.

Building simple trackers clients can trust#

A tracker is a list with one row per item: a task, an invoice, an appointment. Good trackers follow a few rules:

1. Put one header row at the top, with clear names such as Task, Owner, Due, Status.
2. Keep one record per row and one type of data per column. Dates in the date column, numbers in the number column.
3. Don't merge cells inside the data. Merged cells break sorting and filtering.
4. Turn the list into an Excel table with Ctrl+T (Mac: ⌘T). New rows then pick up formulas and formatting.
5. Use a drop-down list for the Status column so everyone types the same words.

A status column with fixed words makes counting easy: =COUNTIF(D2:D50,"Done"). A due date column lets you highlight overdue items with conditional formatting.

How to show your Excel skills to clients#

Clients and agencies often check Excel with a short practical test: clean a list, filter it, count something, look up a value. Speed matters, because a task that takes you an hour by hand might take two minutes with a formula. The guide to the Excel data entry test explains what those tests usually check.

On your profile or resume, name the tasks, not just the program. "Cleaned and merged 2,000-row contact lists" says more than "Good at Excel" (only claim what you have actually done). The guide on how to list Excel skills on a resume has more wording ideas. Not sure where you stand? The Excel level test gives you a quick starting point, and the basic Excel test is a good timed rehearsal.

Practise it#

The fastest way to get these skills is to use them on real-looking lists. Practise cleaning text in a live spreadsheet, then practise joining names and emails and filtering a table: you type each formula and ExcelReady checks it instantly. Start with the email-list exercise on this page.