Excel for Administrative Assistants: Skills Employers Test
Excel skills admin roles ask for: lists and trackers, sorting and filtering, totals and date formulas, mail-merge-ready data and basic lookups.
By Ayoub Farid · · 1 min read
Admin roles use Excel for lists, schedules, trackers and simple reports. Tests are usually basic to intermediate, and they reward tidy, accurate work more than clever formulas.
Skills to have
Lists and trackers
Contact lists, inventory, room bookings, expense logs. Convert ranges to tables (Ctrl+T), freeze the header row (View > Freeze Panes), and use data validation for drop-downs.
Sorting and filtering
Sort by date, then name. Filter to show one department or overdue items.
Everyday formulas
- Totals and averages: SUM, AVERAGE
- Counts by status: COUNTIF
- Days until a deadline:
=C2-TODAY(). See TODAY - Overdue flag:
=IF(C2<TODAY(),"Overdue","") - Working days: NETWORKDAYS
Clean, mail-merge-ready data
Mail merge (Word letters and labels from Excel) needs one header row, one record per row, no merged cells, clean names: TRIM, PROPER and combine first and last names.
A simple lookup
Pulling a phone number or department from another list with XLOOKUP or VLOOKUP.
Printing
Set print area, fit to one page wide, repeat header rows on every page (Page Layout > Print Titles).
Typical test tasks
- Format a contact list consistently
- Sort and filter a schedule
- Total expenses by category
- Count tasks by status
- Flag overdue items
Try the basic Excel test questions.
Frequently asked questions
What Excel skills does an administrative assistant need?
Organised lists, sorting and filtering, SUM/COUNTIF/date formulas, clean data for mail merge and basic lookups.
Is there an Excel test for admin jobs?
Often, usually at a basic or intermediate level.
Do admin assistants need pivot tables?
Not always, but knowing how to make a simple one is a plus.
How do I track deadlines in Excel?
Use =C2-TODAY() for days left and conditional formatting to highlight overdue items.