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.

Excel

Analyze Tables

Charts & Sparklines

Create Spreadsheets

Create Tables

Conditional Formatting

Convert Text to Columns

Data Analysis

Data Validation

Formulas

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

Goal Seek, Scenario Manager, Solver

Group Data

Macros

PivotTables & PivotCharts

Word

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

Macros

Page Setup

Printing

Sharing & Protecting Documents

Spell Check

Text Formatting

Track Changes

Outlook

Auto Reply

Calendars (Share and Configure)

Cc: and Bcc:

Configure Email Settings

Create an Electronic Business Card

Create and Send Email Messages

Email

Email Filters

Emailing Documents

Manage Junk Mail

Manage Folders

Plan Meetings

Scheduling

Set Message Rules

Sending Attachments

Set Up Email Signatures

Tasks (Create, Schedule, and Delegate)

PowerPoint

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

Access

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

Leave a Reply