Why Become a Microsoft Office Specialist?

Microsoft Office is the world's most popular suite of business productivity tools. Its Word, Excel and PowerPoint products set the standard for word processing, spreadsheet and data use and business presentations, respectively.

01Higher Earning Power

Studies indicate that MOS certification can lead to productivity enhancements for employees, contractors and freelance experts. Higher levels of productivity are highly correlated to confidence and job satisfaction. Research suggests that MOS certification can lead to salary levels up to $16,000 higher than uncertified peers.

02Better Job Prospects

Many jobs require certification in one or all of the Microsoft Office products. MOS certification may lead directly to job opportunities in training or computer support, for example. Design or data-related positions may require certification in PowerPoint or Access.

03Stronger Professional Profile

The process and knowledge involved with the MOS certification provide advanced knowledge in the operations and functions of the Office Suite products. MOS certificate holders are expected to understand and operate Microsoft Office products at a level of detail that exceeds that of an uncertified peer.

What You'll Learn

This course will prepare to take and pass the MO-100 (Word), MO-200 (Excel), MO-300 (PowerPoint), MO-400 (Outlook), and MO-500 (Access) exams.

Prepare to take and the Microsoft Office Specialist Certification exams for Word, Excel, PowerPoint, Outlook, and Access
Learn essential skills required of the Microsoft Office suite including Word, Excel, PowerPoint, Access, and Outlook
Send messages, manage calendars, and collaborate with coworkers using Outlook
Present information in a compelling way via Excel or PowerPoint
Manage databases and improve efficiency using Access
Know how to create and edit a Word document

Career Outlook:
Microsoft Office Specialists


Business operations and office support positions are among the fastest-growing career areas in the current economy. From administrative assistants to specialists in business presentations, data analysis and document publishing, many of today's most promising career areas involve expertise in Microsoft Office products.

Potential Earnings

According to PayScale.com, holders of the MOS certification earn an average of $54,000 per year. With skills in a specific domain such as legal or financial, the pay can increase to $67,000 or higher.

Among the Office and Administrative Support Occupations listed by the US Bureau of Labor Statistics (BLS), those that require MOS skills offer the highest levels of pay and future opportunities. For example, desktop publishers earn on average $45,390 per year. Computer support specialists earn an average of $54,760 per year in a category that is growing faster than the average for all jobs.

Course Outline

You will have six months of course access to train for the Microsoft Office Specialist Certification exams Word, Excel, PowerPoint, Outlook and Access.

  • Lesson 1: INTRODUCTION
    Learn about best communication practices, expectations and how to make yourself a viable asset to any team.
  • Lesson 2: EXCEL
    Understand how to work within Microsoft Excel. Enter data and create worksheets, cover advanced topics like using formulas, visualizing data and how to collaborate with other Excel users.
  • Lesson 3: WORD
    Create and edit Word documents. Learn to use tables, images, illustrations, and change page layout. Additionally, you'll cover how to review and collaborate on documents, manage mailings and protect documents.
  • Lesson 4: POWERPOINT
    Develop PowerPoint presentations from start to finish. Understand how to format your presentations, and include advanced elements like effects, illustrations and tables.
  • Lesson 5: OUTLOOK
    Master Microsoft Outlook by learning to work with messages, organize contacts, manage an inbox and work across multiple email accounts.
  • Lesson 6: ACCESS
    Complete the course by developing an understanding of Access. Receive an overview of the user interface before moving on to covering tables, queries, forms, reports and macros.
UTSA Microsoft Office Certification Training
100% Online

You will have six months of course access to train for the Microsoft Office Specialist Certification exams Word, Excel, PowerPoint, Outlook and Access.

Meet the Instructor
Tracy Berry

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

Building Community

This training program is delivered to the San Antonio community through a partnership with Ed2Go.

UTSA Professional and Continuing Education