Microsoft Office Training

It’s About Productivity

Microsoft Office Training Page Word MOS Icon
Word
Microsoft Office Training For Document Creation, Collaboration and Effective Communication
Price: $249
Length: 8-12 Learning Hours, Online
Core

Successful candidates in XCERIO’s Microsoft Office Training Course will have a fundamental understanding of the Word environment and the ability to complete tasks independently. They will demonstrate the correct application of the principle features of Word by creating and editing 2- to 3-page documents for a variety of purposes and situations. Document examples include professional-looking reports, multi-column newsletters, résumés, and business correspondence.

Expert

Expert-level candidates for XCERIO’s Microsoft Office Training Course will proficiently use the advanced features of Word for document and content management, and advanced formatting. Candidates will create and manage professional documents of four pages or more for a variety of specialized purposes and situations. They will customize their 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. Candidate roles may include editors, project managers, business information workers, educators and others.

Expert Instructor-Led Videos

Official Microsoft Office Specialist Certification

Comprehensive Skill Profile

Hands-On with Live Application Learning

Microsoft Office Training Study Guide and Course Materials

Exclusive eBook Including Projects

Acclaim + LinkedIn Digital Badges

Create and Manage Documents
  • Create a Document
    1. Creating a blank document
    2. Create a blank document using a template
    3. Open a PDF is Word for Editing
    4. Insert text from a file or external source
Read All
Format Text, Paragraphs, and Sections
  • Insert Text and Paragraphs
    1. Find and replace test
    2. Cut, copy and paste text
    3. Replace text by using AutoCorrect
    4. Insert special characters
Read All
Create Tables and Lists
  • Create a Table
    1. Convert text to tables
    2. Convert tables to text
    3. Create a table by specifying rows and columns
    4. Apply table styles
Read All
Insert and Format Graphic Elements
  • Insert Graphic Elements
    1. Insert shapes
    2. Insert pictures
    3. Insert a screen shot or screen clipping
    4. Insert text boxes
Read All
Manage Document Options and Settings
  • Manage Documents and Templates
    1. Modify existing templates
    2. Copy custom styles, macros, and building blocks to other documents or templates
    3. Manage document versions
    4. Compare and combine multiple documents
    5. Link to external document content
    6. Enable macros in a document
    7. Display hidden ribbon tabs
    8. Change the application default font
Read All
Design Advanced Documents
  • Perform Advanced Editing and Formatting
    1. Find and replace text by using wildcards and special characters
    2. Find and replace formatting and styles
    3. Set advanced page setup layout options
    4. Link text boxes
    5. Set paragraph pagination options
    6. Resolve style conflicts by using Paste Options
Read All
Create Advanced References
  • Create and Manage Indexes
    1. Mark index entries
    2. Create indexes
    3. Update indexes
Read All
Create Custom Word Elements
  • Create and Modify Building Blocks, Macros and Controls
    1. Create QuickParts
    2. Manage building blocks
    3. Create and modify simple macros
    4. Insert and configure content controls
Read All

Based off Average Salaries and Skill Requirements from Payscale.com

85501
Project Manager
48041
Marketing Coordinator
47593
Communications Coordinator
49975
Administrative Office Manager
50825
Executive Secretary
41103
General Receptionist

Don’t settle for anything but the Official Microsoft Office Specialist Certification

Microsoft Office Specialist (MOS) Certification Example Comparative image of a certificate of participation
Microsoft Office Training Page Excel MOS Icon
Excel
Microsoft Office Training For Data Analysis, Manipulation, Presentation and Interpreting Data for Insights
Price: $249
Length: 8-12 Learning Hours, Online
Core

Successful candidates in XCERIO’s Microsoft Office Training Course will have a fundamental understanding of the Excel environment and the ability to complete tasks independently. They will know and demonstrate the correct application of the principle features of Excel. Candidates will create and edit a workbook with multiple sheets, and use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.

Expert

Expert-level candidates in XCERIO’s Microsoft Office Training Course will have an advanced understanding of the Excel environment, and the ability to guide others to the proper use of the program’s features. They will create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations. They will customize their Excel environments to meet project needs and to enhance productivity. Expert workbook examples include custom business templates, multiple-axis financial charts, amortization tables, and inventory schedules. Candidate roles may include accountants, financial analysts, data analysts, commercial bankers, and others.

Expert Instructor-Led Videos

Official Microsoft Office Specialist Certification

Comprehensive Skill Profile

Hands-On with Live Application Learning

Microsoft Office Training Study Guide and Course Materials

Exclusive eBook Including Projects

Acclaim + LinkedIn Digital Badges

Create and Manage Worksheets and Workbooks
  • Create Worksheets and Workbooks
    1. Create a workbook
    2. Import data from a delimited text file
    3. Add a worksheet to an existing workbook
    4. Copy and move a worksheet
Read All
Manage Data Cells and Ranges
  • Insert Data in Cells and Ranges
    1. Replace data
    2. Cut, copy, or paste data
    3. Paste data by using special paste options
    4. Fill cells by using Auto Fill
    5. Insert and delete cells
Read All
Create Charts and Objects
  • Create Charts
    1. Create a new chart
    2. Add additional data series
    3. Switch between rows and columns in source data
    4. Analyze data by using Quick Analysis
Read All
Create Tables
  • Create and Manage Tables
  1. Create an Excel table from a cell range
  2. Convert a table to a cell range
  3. Add or remove table rows and columns
Read All
Perform Operations with Formulas and Functions
  • Summarize Data by using Functions
    1. Insert references
    2. Perform calculations by using the SUM function
    3. Perform calculations by using MIN and MAX functions
    4. Perform calculations by using the COUNT function
    5. Perform calculations by using the AVERAGE function
Read All
Manage Workbook Options and Settings
  • Manage Workbooks
    1. Save a workbook as a template
    2. Copy macros between workbooks
    3. Reference data in another workbook
    4. Reference data by using structured references
    5. Enable macros in a workbook
    6. Display hidden ribbon tabs
Read All
Apply Custom Data Formats and Layouts
  • Apply Custom Data Formats and Validation
    1. Create custom number formats
    2. Populate cells by using advanced Fill Series options
    3. Configure data validation
Read All
Create Advanced Formulas
  • Apply Functions in Formulas
    1. Perform logical operations by using AND, OR, and NOT functions
    2. Perform logical operations by using nested functions
    3. Perform statistical operations by using SUMIFS, AVERAGEIFS, and COUNTIFS functions
Read All
Create Advanced Charts and Tables
  • Create Advanced Charts
    1. Add trendlines to charts
    2. Create dual-axis charts
    3. Save a chart as a template
Read All

Based off Average Salaries and Skill Requirements from Payscale.com

73073
Production Manager
79096
Business Analyst
52225
Accountant
66426
Business Development
58982
Financial Analyst
68731
Business Process Consultant

Don’t settle for anything but the Official Microsoft Office Specialist Certification

Microsoft Office Specialist (MOS) Certification Example Comparative image of a certificate of participation
Microsoft Office Training Page PowerPoint MOS Icon
PowerPoint
Microsoft Office Training For Presentation Design and Delivery Skills
Price: $249
Length: 8-12 Learning Hours, Online

Successful candidates in XCERIO’s Microsoft Office Training Course will have a fundamental understanding of the PowerPoint environment and demonstrate the correct application of PowerPoint. Candidates create, edit, and enhance presentations and slideshows. Presentation examples include professional-grade sales presentations, employee training, instructional materials, and kiosk slideshows.

Expert Instructor-Led Videos

Official Microsoft Office Specialist Certification

Comprehensive Skill Profile

Hands-On with Live Application Learning

 Microsoft Office Training Study Guide and Course Materials

Exclusive eBook Including Projects

Acclaim + LinkedIn Digital Badges

Create and Manage Presentations
  • Create a Presentation
  1. Create a new presentation
  2. Create a presentation based on a template
  3. Import Word document outlines
Read All
Insert and Format Text, Shapes and Images
  • Insert and Format Text
  1. Insert text on a slide
  2. Apply formatting and styles to text
  3. Apply WordArt styles to text
  4. Format text in multiple columns
  5. Create bulleted and numbered lists
  6. Insert hyperlinks
Read All
Apply Transitions and Animations
  • Apply Slide Transitions
  1. Insert slide transitions
  2. Set transition effect options
Read All
Insert Tables, Charts, SmartArt and Madia
  • Insert and Format Tables
  1. Create a table
  2. Insert and delete table rows and columns
  3. Apply table styles
  4. Import a table
Read All
Manage Multiple Presentations
  • Merge Content from Multiple Presentations
    1. Inset slides from another presentation
    2. Compare two presentations
    3. Insert comments
    4. Review comments
Read All

Based off Average Salaries and Skill Requirements from Payscale.com

55391
Marketing Executive
48041
Marketing Coordinator
58500
Sales Specialist
72732
Quality Assurance Manager

Don’t settle for anything but the Official Microsoft Office Specialist Certification

Microsoft Office Specialist (MOS) Certification Example Comparative image of a certificate of participation
Microsoft Office Training Page Access MOS Icon
Access
Microsoft Office Training For Database Management, Manipulation, and Query Skills
Price: $249
Length: 8-12 Learning Hours, Online

Successful candidates in XCERIO’s Microsoft Office Training Course will have a fundamental understanding of the application’s environment. They understand basic database design principles and are able to complete tasks independently. They know and demonstrate the correct application of the principle features of Access, and will demonstrate the ability to create and maintain basic Access database objects including tables, relationships, data entry forms, multi-level reports, and multi-table queries.

Expert Instructor-Led Videos

Official Microsoft Office Specialist Certification

Comprehensive Skill Profile

Hands-On with Live Application Learning

Microsoft Office Training Study Guide and Course Materials

Exclusive eBook Including Projects

Acclaim + LinkedIn Digital Badges

Create and Manage a Database
  • Create and Modify Databases
  1. Create a blank desktop database
  2. Create a database from a template
  3. Create a database by using Import objects or data from other sources
  4. Delete database objects
Read All
Build Tables
  • Create Tables
    1. Create a table
    2. Import data into tables
    3. Create linked tables from external sources
    4. Import tables from other databases
    5. Create a table from a template with application parts
Read All
Create Forms
  • Create a Form
    1. Create a form
    2. Create a form from a template with application parts
    3. Save a form
Read All
Create Queries
  • Create a Query
    1. Run a query
    2. Create a crosstab query
    3. Create a parameter query
    4. Create an action query
    5. Create a multi-table query
    6. Save a query
Read All
Create Reports
  • Create a Report
    1. Create a report based on the query or table
    2. Create a report in Design view
    3. Create a report by using a wizard
Read All

Based off Average Salaries and Skill Requirements from Payscale.com

75000
Traffic Planner
51105
Marketing Insights Analyst
67407
Business Analyst
57920
Systems Administrator

Don’t settle for anything but the Official Microsoft Office Specialist Certification

Microsoft Office Specialist (MOS) Certification Example Comparative image of a certificate of participation
Microsoft Office Training Page Outlook MOS Icon
Outlook
Microsoft Office Training For Time Management, Communication, Collaboration and Email Skills
Price: $249
Length: 8-12 Learning Hours, Online

Successful candidates in XCERIO’s Microsoft Office Training Course will create and edit professional-looking email messages, maintain calendars across time zones, and schedule tasks for a variety of purposes and situations. Candidates will use Outlook to enhance professional correspondence, create calendars, and schedule appointments. Application examples include coordinating building resources, sending messages for marketing campaigns, planning staff meetings, and assigning meeting action items.

Expert Instructor-Led Videos

Official Microsoft Office Specialist Certification

Comprehensive Skill Profile

Hands-On with Live Application Learning

Microsoft Office Training Study Guide and Course Materials

Exclusive eBook Including Projects

Acclaim + LinkedIn Digital Badges

Manage the Outlook Environment for Productivity
  • Customize Settings
  1. Customize reply messages
  2. Change text Formats for all outgoing messages
  3. Customize the Navigation Pane
  4. Configure reviews
  5. Manage multiple accounts
  6. Add an account
Read All
Manage Messages
  • Configure Mail Settings
    1. Set fonts for new messages and responses
    2. Create, assign, and modify signatures
    3. Create and manage rules
    4. Create automatic replies
    5. Create messages by using Quick Parts
    6. Configure junk e-mail and clutter settings
Read All
Manage Schedules
  • Create and Manage Calendars
    1. Create and add calendars
    2. Adjust viewing details for calendars
    3. Modify calendar time zones
    4. Delete calendars
    5. Set calendar work times
    6. Manage multiple calendars
    7. Manage calendar groups
    8. Display multiple calendars
    9. Share calendars
Read All
Manage Contacts and Groups
  • Create and Manage Contacts
    1. Create a new contact
    2. Delete contacts
    3. Import contacts from external sources
    4. Edit contact information
    5. Attach an image to a contact
    6. Add tags to contacts
    7. Share contacts
    8. Create and manage address books
Read All

Based off Average Salaries and Skill Requirements from Payscale.com

73073
Production Manager
79096
Business Analyst
52225
Accountant
58500
Sales Specialist
72732
Quality Assurance Manager
68731
Business Process Consultant

Don’t settle for anything but the Official Microsoft Office Specialist Certification

Microsoft Office Specialist (MOS) Certification Example Comparative image of a certificate of participation
Microsoft Single
One Time Payment
$249
Starter Pack
Basic pack for those looking at touching up on that one important application in their lives
1x Microsoft Office Exam
Simulation Practice Testing
Instructor-Led Video Tutorials
Microsoft Office Specialist Certification
Microsoft Office Master Certification
Personal Learning Advisor
Exam Retakes
Learn Now
Microsoft Master
One Time Payment
$799
The Executive Suite
Set the golden standard with premium full access and unlock your potential
4x Microsoft Office Exams
Simulation Practice Testing
Instructor-Led Video Tutorials
Microsoft Office Specialist Certifications
Microsoft Office Master Certification
Personal Learning Advisor
2x Exam Retakes
Learn Now
BUILD YOUR OWN MICROSOFT OFFICE TRAINING