15 Microsoft Office Skills to Put on a Resume

By Devin ColeUpdated Oct 19, 202612 min read

From PivotTables and mail merge to Outlook calendar management — which Office skills to name, where each one belongs, and how to prove it in a bullet.

Table of contents

How to use this list
The list at a glance
Each skill, with an example bullet
How to show them on your resume
FAQ

Featured image for "15 Microsoft Office Skills to Put on a Resume"

The fifteen Microsoft Office skills below cover Excel, Word, PowerPoint, Outlook and the wider Microsoft 365 apps, with a note on who each one suits and an example resume bullet for each. Pick the five or six that appear in the job ad you are answering, list them in a skills section, and prove the most important two or three inside your experience bullets.

Which apps matter varies by employer: some offices run on Excel and Outlook all day, others have moved most collaboration to Teams and SharePoint, and some use Google Workspace and only want Office as a secondary skill. Read the ad before you copy anything from this list.

How to use this list

Start with the job ad, not the list. Mark every app and feature it names — "advanced Excel," "mail merge," "calendar management," "PivotTables" — and keep those words in the form the employer used them. Office support roles often ask for exactly this: creating spreadsheets, managing databases, and preparing presentations, reports and documents (U.S. Bureau of Labor Statistics, 2025).

Then split your picks in two. Tool names and features go in a short skills section, which CareerOneStop describes as optional, best placed after your headline or summary when the skills are central to the job, titled "Skills" or "Technical Skills," and usually listed in columns (CareerOneStop, U.S. Department of Labor). Anything you have actually used at work goes into an experience bullet with a number attached. CareerOneStop also advises spreading skills across the summary, skills section, accomplishments and continuing education rather than parking them in one place.

The list at a glance

#	Skill	Hard or soft	Roles it suits best
1	Excel formulas and functions	Hard	Admin assistants, bookkeepers, analysts, office managers
2	PivotTables and PivotCharts	Hard	Analysts, sales support, operations, finance clerks
3	Data cleaning and Power Query	Hard	Data entry, operations, marketing ops, research assistants
4	Excel charts and dashboards	Hard	Reporting roles, project coordinators, team leads
5	Macros and basic VBA	Hard	Finance, operations, anyone with repeating weekly reports
6	Word styles and long-document formatting	Hard	Legal and medical admin, proposal writers, editors
7	Mail merge	Hard	Membership, fundraising, HR, front-office admin
8	Track Changes and co-authoring	Soft, run through a tool	Legal admin, contracts, communications, policy teams
9	PowerPoint slide master and templates	Hard	Marketing, internal comms, executive assistants
10	Turning data into a presentation	Soft	Analysts, project managers, anyone presenting to leadership
11	Outlook inbox, calendar and scheduling	Hard	Executive assistants, receptionists, schedulers, recruiters
12	Microsoft Teams collaboration	Soft, run through a tool	Remote and hybrid roles, coordinators, support desks
13	SharePoint and OneDrive file management	Hard	Office managers, records staff, project coordinators
14	Access queries, forms and reports	Hard	Membership admin, inventory, small-office database owners
15	Microsoft Forms and Power Automate	Hard	Operations, HR admin, facilities, anyone chasing approvals

Availability differs: Access ships with some Microsoft 365 plans and not others, Power Automate depends on the licence your employer bought, and a few offices still run older desktop versions. Check what the ad names before you claim it.

Each skill, with an example bullet

1. Excel formulas and functions

Employers mean you can build a working formula from scratch — SUM, IF, SUMIFS, XLOOKUP or VLOOKUP, INDEX/MATCH, date and text functions, and absolute references — rather than editing someone else's template and hoping.

Resume bullet
Rebuilt a 14-tab department budget tracker using XLOOKUP and SUMIFS, cutting monthly data entry from 6 hours to 45 minutes.

2. PivotTables and PivotCharts

This is the single most-requested "advanced Excel" item in office ads. It means you can take a flat export and turn it into a summary by region, month or category without manual sorting.

Resume bullet
Summarized 18,000 order lines per quarter in PivotTables, producing a 4-page regional sales report for 9 branch managers.

3. Data cleaning and Power Query

Removing duplicates, splitting columns, fixing date formats, applying data validation, and merging recurring exports so the same clean-up does not have to happen by hand every month.

Resume bullet
Merged 6 monthly CSV exports in Power Query and removed roughly 1,200 duplicate contact records before each mailing.

4. Excel charts and dashboards

Picking a chart that answers the question, labelling it so it reads without explanation, and linking slicers or filters so one sheet serves several readers.

Resume bullet
Built a one-page Excel dashboard with 5 linked charts and 3 slicers, replacing a weekly 12-slide status deck.

5. Macros and basic VBA

Recording and editing macros to repeat formatting, printing or export steps. Microsoft states that the MO-211 Excel Expert exam covers creating advanced formulas and macros alongside managing workbook settings, data formatting and advanced charts and tables (Microsoft, 2025).

Resume bullet
Recorded 4 Excel macros to format and print weekly inventory reports, saving the team about 3 hours each week.

6. Word styles and long-document formatting

Using heading styles, automatic numbering, section breaks, headers and footers, cross-references and a generated table of contents — the difference between a 100-page document you can update and one you have to rebuild.

Resume bullet
Reformatted a 120-page policy manual with heading styles and a linked table of contents, reducing update time to under 30 minutes per revision.

7. Mail merge

Driving letters, labels, envelopes or bulk email from a spreadsheet or contact list, including filtering recipients and checking the merge before it prints.

Resume bullet
Produced monthly mail merges of 450 renewal letters and matching envelopes from an Excel recipient list.

8. Track Changes and co-authoring

A collaboration habit as much as a feature: accepting and rejecting edits cleanly, using comments instead of rewriting, and returning one agreed version instead of four conflicting files.

Resume bullet
Coordinated Track Changes review of 30+ contracts a month across 4 reviewers, returning a single consolidated version within 2 business days.

9. PowerPoint slide master and templates

Building or maintaining a branded template so colleagues stop hand-positioning text boxes — slide master, layouts, theme colours, and consistent fonts and spacing.

Resume bullet
Rebuilt the company slide master into a 12-layout branded template adopted by 40 staff across 3 departments.

10. Turning data into a presentation

The judgement part: choosing what to cut, giving each slide one point, and being able to speak to the numbers. Employers often write this as "preparing presentations for leadership."

Resume bullet
Condensed a 22-page quarterly report into a 10-slide board deck and presented it to 8 directors.

11. Outlook inbox, calendar and scheduling

Rules and folders, flagging and follow-up, delegate access, shared calendars, room and resource booking, and scheduling across time zones without double-booking anyone.

Resume bullet
Managed 2 executive calendars and an inbox averaging 200 emails a day, scheduling 25–30 meetings a week across 4 time zones.

12. Microsoft Teams collaboration

Running and recording meetings, organising channels and files, keeping threads readable, and showing new starters where things live.

Resume bullet
Hosted 3 recurring Teams meetings a week for up to 25 attendees and posted agendas and recordings to the channel within 24 hours.

13. SharePoint and OneDrive file management

Site and library structure, permissions, version history, naming conventions, and moving a shared drive somewhere people can actually find things.

Resume bullet
Migrated 1,800 shared-drive files to SharePoint, set permissions for 6 teams, and wrote a 2-page naming convention adopted office-wide.

14. Access queries, forms and reports

Still used in offices that outgrew a spreadsheet but never bought a system. Means building or maintaining tables, queries, data-entry forms and printed reports.

Resume bullet
Maintained an Access database of 5,400 member records, building 8 queries and 3 report templates used for monthly renewals.

15. Microsoft Forms and Power Automate

Replacing email ping-pong with a form and an automated routing or approval flow. Worth listing only where the employer's licence includes it — check the ad.

Resume bullet
Built a Microsoft Forms request form and Power Automate flow routing 60+ facilities requests a month to 3 approvers.

How to show them on your resume

Mine the ad for the exact words. Print or paste the posting and underline every app, feature and phrase: "advanced Excel," "PivotTables," "mail merge," "Outlook calendar management," "SharePoint." Use the employer's wording, not a synonym. If the ad says "Microsoft 365" and you write "MS Office," you have made the reader do work.

Build a short skills section. CareerOneStop describes this section as optional, sitting after your headline or summary when the skills are essential to the job (or after education when they are less central), titled "Skills" or "Technical Skills," and listed in columns as software names or short phrases (CareerOneStop, U.S. Department of Labor). Six to ten entries is plenty. Group them — Excel (PivotTables, XLOOKUP, Power Query) | Word (mail merge, styles, Track Changes) | Outlook | Teams and SharePoint — so a 10-second scan picks up the clusters.

Prove the top three inside experience bullets. A skills list is a claim; a bullet is evidence. Pick the three skills the ad leans on hardest and write each into a bullet with action verb, task and a number in the units of the job — rows, files, letters, meetings, hours saved.

Weak vs strong
Weak: Responsible for Excel reporting. Strong: Built 4 weekly PivotTable reports from a 20,000-row export, cutting report prep from 5 hours to 90 minutes.

Name one or two in the summary. CareerOneStop advises highlighting skills throughout the resume — in the summary statement, the skills section, your accomplishments, and continuing education — rather than in one block. Two lines is enough: the role you are applying for, your years in it, and the one or two Office skills the job turns on.

Put training and certification under education. List the certification name, the issuing body and the date. Microsoft Office Specialist exams are delivered through Certiport, whose Microsoft 365 Apps track lists Word Associate, Excel Associate, PowerPoint Associate, Outlook Associate, Word Expert and Excel Expert (Certiport, a Pearson VUE business). In-progress study can be listed as in progress, with the exam code.

Re-tailor for each application and keep a master copy. Hold a longer master file with every skill and bullet you have, then cut it down for each ad. Swap the skills section order, change the summary line, and promote whichever bullet matches. The whole edit is usually 10 minutes, and it stops you sending a spreadsheet-heavy resume to a role that is really about calendars and documents.

Frequently asked questions

How many Microsoft Office skills should I actually list?

Six to ten in the skills section, and no more than three or four proved inside your experience bullets. A list of fifteen apps tells the reader nothing about what you are good at, and it is obvious when someone has pasted a menu. Prioritise by the ad: if the posting mentions Excel five times and Outlook once, your skills section should read that way too. If an app is genuinely secondary, it can go at the end of the line without a feature list behind it.

Does it matter whether a skill is hard or soft?

It matters for where you put it. Hard skills — PivotTables, mail merge, Power Query, slide masters — can sit in a skills section as short phrases and still mean something. Soft skills like coordinating a review cycle or presenting data to leadership mean nothing as a bare phrase; they only land as a bullet with a situation and a number attached. So list the hard ones, demonstrate the soft ones, and never let a soft skill appear only as an adjective about yourself.

Can I list a skill I have only used a little, or learned outside a job?

Yes, if you are honest about it and can do it in front of someone. Coursework, volunteering, a committee treasurer spreadsheet and a family business all count — write the bullet with real numbers from that context. What you should not do is claim "advanced Excel" when you mean you can sort a column, because a practical test or a first-week task will find it out. If you want outside proof, the Microsoft Office Specialist program is the standard route: Microsoft requires three exams for the Associate (Office 2019) certification — MO-100 Word, MO-200 Excel and MO-300 PowerPoint — while the Microsoft 365 Apps version requires three exams in different programs, at least one of them a Microsoft 365 Apps exam, chosen from MO-110, MO-210 and MO-310 or the Office 2019 codes (Microsoft). The Expert certification requires the Associate first, then two Expert exams in different programs from MO-111, MO-211, MO-101 and MO-201, and Microsoft calls it the highest certification in the program (Microsoft, 2025). Exam availability, delivery options and fees vary by country and test centre, so check Certiport and Microsoft for the current list before you book.

Do I need a degree for office roles that want these skills?

For most entry-level secretary and administrative assistant work, no. The U.S. Bureau of Labor Statistics gives the typical entry-level education as a high school diploma or equivalent (2025), and says high school graduates who are comfortable with word processing and spreadsheet programs usually qualify for entry-level positions (2025). BLS also notes that workers typically learn the duties over several weeks of on-the-job training, with extra training for legal and medical specialties and several years of experience expected for executive-level roles (2025). O*NET lists this occupation under code 43-6014.00, with reported job titles including Administrative Assistant, Administrative Clerk, Administrative Secretary and Administrative Specialist (O*NET OnLine, 2026) — so search several of those titles, because employers label the same job differently.

Will adding Office skills or a certification raise my pay?

No one can promise that, and it depends on the employer, the role and where you work. BLS notes that earnings vary by experience, responsibility, performance, tenure and geographic area, and that its Pay tab describes typical earnings and how workers are compensated — annual salaries, hourly wages, commissions, tips or bonuses (2025). Check the current BLS Occupational Outlook Handbook figures for your occupation and state, and look at what local postings list, rather than relying on a national average. What the skills reliably do is widen the set of jobs you can apply to and give you something concrete to put in a bullet.

Sources

U.S. Bureau of Labor StatisticsSecretaries and Administrative Assistants : Occupational Outlook Handbook2025
O*NET OnLine (National Center for O*NET Development)Secretaries and Administrative Assistants, Except Legal, Medical, and Executive - 43-6014.002026