• Executive Assistants
• Office Managers
• Administrative Coordinators
• Administrative Support Staff
• Project Coordinators
• Reporting Specialists
• Customer Service Staff
• Business Users

Microsoft Word – MO-110

Manage documents

• Navigate and search within documents
• Configure document pages and formatting
• Save and share documents electronically
• Inspect accessibility compatibility and privacy

Insert and format text, paragraphs, and sections

• Find and replace document text
• Apply text effects and styles
• Configure paragraph spacing and indentation
• Create sections and document breaks

Manage tables and lists

• Create tables from document text
• Modify table rows and columns
• Merge cells and split tables
• Format lists and manage levels

Create and manage references

• Insert footnotes and endnotes properly
• Modify footnote and endnote properties
• Create automatic tables of contents
• Customize table of contents settings

Insert and format graphic elements

• Insert pictures shapes and icons
• Format images and graphic elements
• Add text to graphic elements
• Position objects and wrap text

Manage document collaboration

• Add and reply to comments
• Resolve and delete document comments
• Track changes within shared documents
• Accept or reject tracked changes

Microsoft Excel – MO-210

Manage worksheets and workbooks

• Import data from multiple sources
• Navigate efficiently within Excel workbooks
• Format worksheets and workbooks professionally
• Prepare workbooks for sharing distribution

Manage data cells and ranges

• Manipulate data within worksheet ranges
• Format cells and data ranges
• Define and use named ranges
• Summarize worksheet data visually

Manage tables and table data

• Create and format Excel tables
• Modify table rows and columns
• Configure appropriate total row calculations
• Filter and sort table data

Perform operations by using formulas and functions

• Insert references within workbook formulas
• Perform calculations using Excel functions
• Sort data and retrieve values
• Format text using Excel functions

Manage charts

• Create charts and chart sheets
• Modify chart data series appropriately
• Add and format chart elements
• Apply chart layouts and styles

Microsoft PowerPoint – MO-310

Manage presentations

• Modify slide masters and layouts
• Change presentation options and properties
• Configure and present slide shows
• Prepare presentations for sharing distribution

Manage slides

• Insert slides from multiple sources
• Modify slide backgrounds and properties
• Organize slides into presentation sections
• Reorder presentation slides and sections

Insert and format text, shapes, and images

• Format presentation text and lists
• Insert hyperlinks and navigation elements
• Insert and format presentation images
• Align group and arrange objects

Insert tables, charts, SmartArt, 3D models, and media

• Create and format presentation tables
• Insert charts and modify elements
• Create and format SmartArt graphics
• Insert media and 3D models

Apply transitions and animations

• Apply and configure slide transitions
• Configure transition timing and effects
• Animate text and graphic elements
• Configure motion paths and sequencing