Top Microsoft Office Skills Needed by Job Seekers

Job hunting has never been an easy process. In today’s dynamic technology-laden society, how can we know what are must have skills? We may think we are up-to-date just to see a new version released or an application that we were considered an expert in be removed from the desired programs in most job descriptions.

Many job descriptions contain at least one Microsoft Office program. From my search through many jobs and from talking to students in my classes. The two software programs I hear about most are Excel and Word. Aside from those two, the most frequently referred to programs are Outlook, PowerPoint, and Access. From my experience and research (LinkedIn, Indeed, etc.), here are the most desired skills for each of the Microsoft Office applications.


Analyze Tables

Charts & Sparklines

Create Spreadsheets

Create Tables

Conditional Formatting

Convert Text to Columns

Data Analysis

Data Validation


Functions (Logical, Financial, Statistical, Date and Time)

Goal Seek, Scenario Manager, Solver

Group Data


PivotTables & PivotCharts


Compare and Merge documents

Create and Manage Comments

Create Forms using fields and advanced form tools

Create Labels

Create and Use Templates

Formatting Documents

Formatting Tables

Grammar Check

Mail Merge & using Outlook for recipient list


Page Setup


Sharing & Protecting Documents

Spell Check

Text Formatting

Track Changes


Auto Reply

Calendars (Share and Configure)

Cc: and Bcc:

Configure Email Settings

Create an Electronic Business Card

Create and Send Email Messages


Email Filters

Emailing Documents

Manage Junk Mail

Manage Folders

Plan Meetings


Set Message Rules

Sending Attachments

Set Up Email Signatures

Tasks (Create, Schedule, and Delegate)


Broadcast and Share a Slideshow

Create Presentations

Create and Format Templates

Create Interactive Slideshows (use transitions, animation and buttons)

Insert, Embed and Link data and media from other applications

Insert Hyperlinks

Insert and Format Media (Sound, Video, Across slides)

Link and Embed Video

Work with Slide Masters

Use the Advanced Timeline


Create & Design Databases

Create Advanced Queries

Calculated Controls

Data Sorting and Filtering

Establish Relationships and Join lines between tables

Use VBA and SQL within Access

Use other Office applications with Access

Angela Nino - Versitas Editor

One response to “Top Microsoft Office Skills Needed by Job Seekers”

  1. Sirron says:

    Thank you very much

Leave a Reply

Your email address will not be published. Required fields are marked *