While proficiency in Microsoft Office is essential in most professional settings, earning a Microsoft Office Associate certification signifies that you have a deep level of skills needed to use the Office suite.
The Microsoft Office Specialist (MOS) Associate Certification Training course will teach you how to use the Microsoft Office suite at an advanced level. You will build your expertise through hands-on exercises, in-depth course material, and supplemental video demonstrations. You will also prepare for the certification exams for Word, Excel, PowerPoint, and Outlook. As you prepare for each exam, you will test your skills at regular intervals with quizzes and exams.
By course completion, you will be fully prepared to take the MO-200 and MO-201 (Excel), MO-100 and MO-101 (Word), MO-300 and MO-310 (PowerPoint), and MO-400 (Outlook) exams. To earn the Microsoft Office Specialist (MOS) Associate Certification, you must successfully complete 3 Associate level exams of your choosing.
This course offers enrollment with or without vouchers. The vouchers are prepaid access to sit for the certifying exams upon eligibility. Proctor fees may apply, which are not included.
Instructor(s):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.
Requirements:
Hardware Requirements:
- This course must be taken on a PC. Macs and Chromebooks are not compatible.
Software Requirements:
- PC: Windows 10 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
- Microsoft Office 365, 2021, or 2019 (not included in enrollment). While you can use an older version of Microsoft Office, if you do, there will be some differences between your version and what you see in the course.
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
- Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and available online.
Hide Syllabus
Lesson 1
- Microsoft Word 2019/365
- Introduction to Microsoft Word
- Creating a Microsoft Word Document
- The Ribbon
- The File Tab
- The Quick Access Toolbar
- Formatting Microsoft Word Documents
- Editing Documents
- Finalizing Microsoft Word Documents
- Introduction to Microsoft Word 2019/365 Exam
- Intermediate Microsoft Word
- Advanced Formatting
- Working with Tables
- Working with Images
- Page Layout
- Working with Illustrations
- Viewing Your Document(s)
- Intermediate Microsoft Word 2019/365 Exam
- Advanced Microsoft Word
- Working with Long Documents
- Reviewing and Collaborating on Documents
- Comparing and Combining Documents
- Managing Mailings
- Protecting Documents
- Random Useful Items
- Advanced Microsoft Word 2019/365 Exam
- Microsoft Word Final Exam
- Microsoft Excel 2019/365
- Introduction to Microsoft Excel
- Creating a Microsoft Excel Workbook
- The Ribbon
- The Backstage View (The File Menu)
- Entering Data in Microsoft Excel Worksheets
- Formatting Microsoft Excel Worksheets
- Using Formulas in Microsoft Excel
- Working with Rows and Columns
- Editing Worksheets
- Finalizing Microsoft Excel Worksheets
- Introduction to Microsoft Excel 2019/365 Exam
- Intermediate Microsoft Excel
- Advanced Formulas
- Working with Lists
- Working with Illustrations
- Visualizing Your Data
- Working with Tables
- Advanced Formatting
- Intermediate Microsoft Excel 2019/365 Exam
- Advanced Microsoft Excel
- Using Pivot Tables
- Auditing Worksheets
- Data Tools
- Working with Others
- Recording and Using Macros
- Random Useful Items
- Advanced Microsoft Excel 2019/365 Exam
- Microsoft Excel 2019/365 Final Exam
- Microsoft PowerPoint 2019/365
- Introduction to Microsoft PowerPoint
- Creating a PowerPoint Presentation
- The Ribbon
- The Quick Access Toolbar
- The Backstage View (The File Menu)
- Formatting Microsoft PowerPoint Presentations
- Working with Images
- Working with Tables and Charts
- Finalizing Microsoft PowerPoint Presentations
- Introduction to Microsoft PowerPoint 2019/365 Final Exam
- Advanced Microsoft PowerPoint
- Customizing Presentations
- Presentation Masters
- Working with Special Effects
- Using SmartArt
- Multimedia
- Setting Up the Slide Show
- Outlines and Slides
- Managing Multiple Presentations
- Sharing and Securing a Presentation
- Advanced Microsoft PowerPoint 2019/365 Final Exam
- Microsoft PowerPoint 2019/365 Final Exam
- Microsoft Outlook 2019/365
- Introduction to Microsoft Outlook
- The Outlook 2019/365 Interface
- Performing Popular Tasks in Outlook
- Working with Messages
- Working with the Calendar
- Organizing Contacts
- Introduction to Microsoft Outlook 2019/365 Exam
- Advanced Microsoft Outlook
- Working with Tasks and Notes
- Using Signature and Themes
- Managing Your Inbox
- Working with Multiple Email Accounts
- Advanced Microsoft Outlook 2019/365 Exam
- Advanced Microsoft PowerPoint 2019/365 Final Exam
- Microsoft Outlook Final Exam
Hide Syllabus