An office worker looking at a spreadsheet on a monitor

Office software skills employers list

Job Quro resources3 min readOffice and administration

This helps you read the software line in an office posting and decide what to practice. Employers describe skills by type of program, and each type has a few tasks that come up again and again at work.

The skills that appear most often

Word processing means writing, formatting and editing documents such as letters, memos and reports. Office postings that list it usually expect you to set margins and headings, insert tables, track changes and save files in shared formats. Many also mention mail merge, which fills one letter template with names and addresses from a list.

Spreadsheet skills cover entering and sorting data, writing simple formulas for totals and averages, filtering rows and building basic charts. Postings that ask for intermediate or advanced spreadsheet skills often mean lookup formulas and pivot tables, which summarize a large list by category.

Postings that ask for intermediate or advanced spreadsheet skills often mean lookup formulas and pivot tables, which summarize a large list by category.

Email, calendars and shared files

Almost every office role involves an email program with a shared calendar. Assistants are often asked to book meetings across several people's calendars, reserve rooms and send invitations for video meetings. Many offices also keep documents in shared online folders, so you may need to set who can view or edit each file.

Some fields use their own systems on top of these. Medical offices run scheduling and billing software, accounting offices use bookkeeping programs, and sales teams keep customer records in a database. Employers usually train new hires on these systems, and a posting will say when prior experience is required.

Ways to practice for free

Many public libraries offer free computer classes and online courses in office programs with a library card. American Job Centers often run workshops on basic computer and office skills, and community colleges offer short noncredit courses. Free versions of word processing and spreadsheet programs are available online for practice at home.

A useful exercise is to rebuild a real task: format a one-page letter, sort a list of a hundred names, or total a column of expenses by month. Doing the task once on your own makes it easier to describe the skill plainly when an employer asks.

What to do this week

  • Mark each software skill named in an office posting
  • Ask your library about free computer classes
  • Build a practice spreadsheet with a sort and a total
  • Format a one-page letter with a table

Who to ask

The hiring contact, or the staff at your local American Job Center or library

Remember: Office postings describe software by type, and a few common tasks in each type cover most of what employers mean.

Tags:
  • Office
  • Article