Word Associate certification demonstrates competency in the correct application of the principle features of Word by creating and editing documents for a variety of purposes and situations. The exam covers the ability to create and maintain professional-looking reports, multicolumn newsletters, résumés, and business correspondence.

Demonstrates foundational skills in creating, formatting, and managing professional documents - ideal for administrative, academic, and business roles.

​

For this test, please expect  33-37 task-based questions to complete within 50 minutes

 

General Exam Objectives:

1. Manage Documents

   1. Navigate within documents

   2. Format documents

   3. Save and share documents

   4. Inspectd documents for issues

2. Insert and Format Text, Paragraphs and Sections

   1. Insert text

   2. Format text and paragraphs

   3. Create and configure document sections

3. Manage Tables and Lists

   1. Create, modify tables and lists

4. Create and Manage References

   1. Create and manage footnotes, endnotes, and table of contents

5. Insert and Format Graphic Elements

   1. Insert and format illustrations and textboxes

   2. Add text to graphic elements

   3. Modify graphic elements

6. Manage Document Collaboration

   1. Add and manage comments

   2. Manage change tracking

​​

See specific objectives at: Certiport - Marketing Resource Library

Word Expert Certification demonstrates competency in creating and managing professional documents for a variety of specialized purposes and situations. The exam covers the ability to customize Word environments to meet project needs, and to enhance productivity. Examples of expert-level documents include a business plan, a research paper, a book, a specialized brochure, and a mass mailing.

​

Validates advanced skills in managing long and complex documents, including references, custom styles, forms, macros, and collaboration tools to create professional-grade reports, proposals, and publications.

​

23-27  task-based questions to complete within 50 minutes

​

General Exam Objectives:

1. Manage Document Options and Settings

   1. Manage documents and templates

   2. Prepare documents for collaboration

   3. Use and configure language options

2. Use Advanced Editing and Formatting Features

   1. Find, replace, and paste document content

   2. Configure paragraph layout options

   3. Create and manage paragraph, character, and table styles

3. Create Custom Document Elements

   1. Create and modify building blocks

   2. Create custom design elements

   3. Create and manage indexes

   4. Create and manage table of figures

   5. Create and manage bibliographies

4. Use Advanced Word Features

   1. Manage forms, fields and controls

   2. Create and modify macros

   3. Perform mail merges

​​

See specific objectives at: Certiport - Marketing Resource Library

Challenging this exam will build and validate your skills, including creating and formatting spreadsheets, using basic formulas and functions, and visualizing data with charts.

​

For this exam, please expect  33-37 task-based questions to complete within 50 minutes

​

General Exam Objectives:

1. Manage Worksheets and Workbooks

   1. Import data into workbooks

   2. Navigate within workbooks

   3. Format worksheets and workbooks

   4. Customize options and views

   5. Prepare workbooks for collaboration and distribution

2. Manage Data Cells and Ranges

   1. Manipulate data in worksheets

   2. Format cells and ranges

   3. Define and reference named ranges

   4. Summarize data visually

3. Manage Tables and Table Data

   1. Create and format tables

   2. Modify tables

   3. Filter and sort table data

4. Perform operations by using Formulas and Functions

   1. Insert references

   2. Calculate and transform data

   3. Format and modify text

5. Manage Charts

   1. Create, modify and format charts

​​

See specific objectives Certiport - Marketing Resource Library

Showcase advanced Excel proficiency, including complex formulas, pivot tables, data analysis tools, and automation with macros. The exam covers how to customize Excel environments to meet project needs and enhance productivity. Within the exam are custom business templates, multiple-axis financial charts, amortization tables and inventory schedules.

 

23-27 task-based questions to complete within 50 minutes

 

General Exam Objectives:

1.  Manage Workbook Options and Settings

   1. Manage workbooks

   2. Prepare workbooks for collaboration

2. Manage and Format Data

   1. Fill cells based on existing data

   2. Format and validate data

   3. Apply advanced conditional formatting and filtering

3. Create Advanced Formulas and Macros

   1. Perform Logical operations in formulas

   2. Look up data byusing functions

   3. Ude advanced date and time functions

   4. Perform data analysis

   5. Troubleshoot formulas

   6. Create and modify simple macros

4. Manage Advanced Charts and Tables

   1. Create and modify advanced charts

   2. Create and modify PivotTables

   3. Create and modify PivotCharts

​

See specific objectives Certiport - Marketing Resource Library

Based on Generally Accepted Accounting Principles (GAAP)*, this certification validates the ability to use Microsoft Excel to manage financial data, perform calculations, and generate reports—ideal for individuals pursuing roles in bookkeeping, auditing, and entry-level accounting. The Microsoft Office Specialist: Excel for Accounting Associate certification demonstrates competency in the fundamentals of preparing accounting data for analysis, preparing a trial balance, preparing and analyzing financial statements, and performing routine accounting activities. Workbook examples include trial balances, financial statements, payroll data, bank reconciliations, and amortization schedules.

​

23-27 task-based questions to complete within 50 minutes

 

General Exam Objectives:

1. Perform Accounting Data for Analysis

   1. Import and export accounting data

   2. Clean accounting data

   3. Verify accounting data integrity

   4. Transform accounting data

2. Prepare a Trial Balance

   1. Organize accounting transactions

   2. Organize financial data using formulas

3. Prepare and Analyze Financial Statements

   1. Prepare financial statements

   2. Analyze financial statements

   3. Correct financial statement errors

   4. Present financial information visually

4. Perform Routine Accounting Activities

   1. Prepare amortization schedules

   2. Prepare bank reconciliations

   3. Manage accounts receivable and accounts payable

   4. Perform payroll activities

   5. Create depreciation schedules

​

See specific objectives Certiport - Marketing Resource Library

This certification validates the ability to use Microsoft Excel to manage and forecast financial data, perform calculations, and generate reports for financial analysis – ideal for individuals pursuing careers as financial analysts or in other finance-related positions.

The Microsoft Office Specialist: Excel for Business Finance Associate certification demonstrates competency in the fundamentals of preparing financial data for analysis, performing financial analysis, performing loan and investment analysis, and creating financial forecasts. Workbook examples include financial statements and amortization schedules.

​

23-27 task-based questions to complete within 50 minutes

​

General Exam Objectives:

1. Perform Financial Analysis

   1. Import and export financial data

   2. Clean financial data

   3. Verify financial data integrity

   4. Transform financial data

2. Perform Financial Analysis

   1. Analyze financial statements to calculate variances

   2. Analyze financial statements using formulas

   3. Identify and correct errors in financial formulas

3. Perform Loan and Investment Analysis

   1. Analyze loans

   2. Analyze investments

4. Create Financial Forecasts

   1. Predict future performance

   2. Prepare financial projections

   3. Present financial information visually

​

See specific objectives at Certiport - Marketing Resource Library

This exam proves the ability to create, edit, and enhance presentations, including the ability to use slide layouts, transitions, animations, multimedia, and collaboration tools to deliver engaging and visually effective presentations.

 

PowerPoint Associate certification demonstrates competency to create, edit, and enhance presentations and slideshows. The exam covers the ability to create and manage presentations, insert and format shapes and slides, create slide content, apply transitions and animations and manage multiple presentations. Presentation examples include professional-grade sales presentations, employee training, instructional materials, and kiosk slideshows.

​

For this test, please expect  33-37 task-based questions to complete within 50 minutes

​

General Exam Objectives:

1. Manage Presentations

   1. Modify slide masters, handout masters, and note masters

   2. Change presentation options and views

   3. Configure print settings for presentations

   4. Configure and present slideshows

   5. Prepare presentations for collaboration and distribution

2. Manage Slides

   1. Insert and modify slides

   2. Order and group slides

3. Insert Format Text, Shapes and Images

   1. Format text

   2. Insert links

   3. Insert and format images and graphic elements

   4. Order, align and group slide content

4. Insert Tables, Charts, SmartArt, and Media

   1. Insert and format tables

   2. Insert and modify charts

   3. Insert and modify 3D models and SmartArt

   4. Isert and manage media

5. Apply Transitions and Animations

   1. Apply and configure slide transitions

   2. Animate slide content

 

See specific objectives at: Certiport - Marketing Resource Library

Demonstrates proficiency in managing email communications, calendars, contacts, and tasks, including the ability to organize messages, schedule meetings, automate processes, and maintain productivity using Outlook’s core features.

​

Certification earners have an understanding of the Outlook environment and demonstrate the correct applications for the principle features. Earners create professional-grade emails, maintain calendars across time zones and schedule tasks. Proficiencies include coordinating resources, sending marketing campaigns, staff meetings, and assigning action items. 

​

Exam registration will be available in 2026

Maximize your Microsoft Office proficiency with MOS Associate or Expert certifications, showcasing advanced skills through stacked credentials.

​

To earn a Microsoft Office Specialist: Associate (Microsoft 365 Apps) certification, pass any three of the following exams*:

• Microsoft Word (Microsoft 365 Apps)

• Microsoft Excel (Microsoft 365 Apps)

• Microsoft PowerPoint (Microsoft 365 Apps)

• Microsoft Outlook (Microsoft 365 Apps) - To be released

 

To earn a Microsoft Office Specialist: Expert (Microsoft 365 Apps) certification, pass the following two exams: 

• Microsoft Word Expert (Microsoft 365 Apps)

• Microsoft Excel Expert (Microsoft 365 Apps)