Part 1 - Microsoft Office Specialist (MOS) Associate Certification Training
Lesson 1 - Introduction to Microsoft Excel Training
- Microsoft Office Basics
- Creating a Microsoft Excel Workbook
- The Ribbon
- The Backstage View (The File Menu)
- The Quick Access Toolbar
- Entering Data in Microsoft Excel Worksheets
- Formatting Microsoft Excel Worksheets
- Editing Worksheets
- Working with Rows and Columns
- Using Formulas in Microsoft Excel
- Finalizing Microsoft Excel Worksheets
- Using Copilot in Microsoft Excel
Introduction to Microsoft Excel Exam
Lesson 2 - Intermediate Microsoft Excel Training
- Common Functions
- Working with Lists
- Visualizing Your Data
- Working with Tables
- Advanced Formatting
Intermediate Microsoft Excel Exam
Lesson 3 - Advanced Microsoft Excel Training
- Using PivotTables
- Advanced Functions
- Auditing Workbooks
- Data Tools
- Recording and Using Macros
- Working with Others
Advanced Microsoft Excel Exam
Final Microsoft Excel Exam
Lesson 4 - Introduction to Microsoft Word Training
- Microsoft Office Basics
- Creating a Microsoft Word Document
- The Ribbon
- The Backstage View (The File Menu)
- The Quick Access Toolbar
- Formatting Microsoft Word Documents
- Editing Documents
- Finalizing Microsoft Word Documents
- Using Copilot in Microsoft Word
Introduction to Microsoft Word Exam
Lesson 5 - Intermediate Microsoft Word Training
- Advanced Formatting
- Working with Tables
- Working with Images
- Page Layout
- Working with Illustrations
- Viewing Your Documents
Intermediate Microsoft Word Exam
Lesson 6 - Advanced Microsoft Word Training
- Working with Long Documents
- Reviewing and Collaborating on Documents
- Comparing and Combining Documents
- Forms
- Managing Mailings
- Protecting Documents
- Macros
Advanced Microsoft Word Exam
Final Microsoft Word Exam
Lesson 7 - Introduction to Microsoft PowerPoint Training
- Microsoft Office Basics
- Creating a Presentation
- The Ribbon
- The Quick Access Toolbar
- The Backstage View (The File Menu)
- Formatting Presentations
- Working with Images
- Working with Tables and Charts
- Preparing and Presenting
- Using Copilot in Microsoft PowerPoint
Introduction to Microsoft PowerPoint Exam
Lesson 8 - Advanced Microsoft PowerPoint Training
- Customizing Presentations
- Presentation Masters
- Working with Special Effects
- Using SmartArt
- Multimedia
- Setting up the Slide Show
- Outlines and Slides
- Managing Multiple Presentations
- Finalizing Presentations
Advanced Microsoft PowerPoint Exam
Final Microsoft PowerPoint Exam
Lesson 9 - Introduction to Microsoft Outlook 365 Training
- The Outlook Interface
- Working with Messages
- Working with the Calendar
- Organizing Contacts
- Working with Groups
- Using Copilot in Microsoft Outlook
Introduction to Microsoft Outlook 365 Exam
Lesson 10 - Advanced Microsoft Outlook 365 Training
- Performing Popular Tasks
- Working with Tasks and Notes
- Using Signature and Themes
- Managing Your Inbox
- Working with Multiple Email Accounts
Advanced Microsoft Outlook 365 Exam
Microsoft Outlook 365 Final Exam
Part 2 - Certified Administrative Professional
Lesson 1 - Certified Administrative Professional
Lesson 2 - Organizational Communication (Part 1)
Lesson 3 - Organizational Communication (Part 2)
Lesson 4 - Business Writing and Document Production
Lesson 5 - Technology and Information Distribution
Lesson 6 - Office and Records Management
Lesson 7 - Event and Project Management
Lesson 8 - Human Resources
Lesson 9 - Financial Functions
Lesson 10 - Workplace Behaviors and Activities (Part 1)
Lesson 11 - Workplace Behaviors and Activities (Part 2)
Lesson 12 - Workplace Behaviors and Activities (Part 3)
Lesson 13 - Becoming an Administrative Assistant and Advancing Your Career