Part 1 - Microsoft Office Specialist (MOS) Expert 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
Lesson 2 - Intermediate Microsoft Excel Training
- Common Functions
- Working with Lists
- Visualizing Your Data
- Working with Tables
- Advanced Formatting
Lesson 3 - Advanced Microsoft Excel Training
- Using PivotTables
- Advanced Functions
- Auditing Workbooks
- Data Tools
- Recording and Using Macros
- Working with Others
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
Lesson 5 - Intermediate Microsoft Word Training
- Advanced Formatting
- Working with Tables
- Working with Images
- Page Layout
- Working with Illustrations
- Viewing Your Documents
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
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
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
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
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
Lesson 11 - Introduction to Microsoft Access 365 Training
- Databases and Access Terms
- Quick Overview Access Interface
- Fundamentals
- Tables and Their Views
- Tables
- Queries
- Forms
- Reports
Lesson 12 - Advanced Microsoft Access 365 Training
- Relationships
- Advanced Queries
- Table Functions
- Advanced Forms
- Advanced Reports
- Macros
- Completing the Desktop Application
Part 2 - Certified Administrative Professional
Lesson 1 - Organizational Communication (Part 1)
- Understanding the Workplace Team
- Interacting with Stakeholders
- Communication Essentials
Lesson 2 - Organizational Communication (Part 2)
- Networking
- Motivation, Leadership, And Change Management
- Public Speaking
- International Business
- Organizational Structures And Systems
- Legal And Ethical Issues
Lesson 3 - Business Writing and Document Production
- Business Writing
- Software Applications
- Managing Hardware and Software
Lesson 4 - Technology and Information Distribution
- Information Systems
- Telephone and Electronic Communication
- Copyright Laws and Intellectual Property
- Research and Analysis
- Managing Remote Meetings
- Information Distribution and Storage
Lesson 5 - Office and Records Management
- Filing Standards
- File Security
- Creating Workspaces
- Managing Materials and Supplies
Lesson 6 - Event and Project Management
- Event Scheduling And Management
- Travel Planning
- Meeting Coordination
- Project Management And Negotiations
Lesson 7 - Human Resources
- Human Resources Terminology and Processes
- Employee Handbooks, Training, and Standard Operating Procedures
- Employee Records and Evaluation
- Staffing And Onboarding
- Human Resource Law and Harassment
Lesson 8 - Financial Functions
- Budgeting Basics
- Introduction to Financial Statements
- Introduction to Banking and Statement Reconciliation
Lesson 9 - Workplace Behaviors and Activities (Part 1)
- Goal Setting and Creativity
- Problem Solving and Decision Making
- Time Management and Stress Management
Lesson 10 - Workplace Behaviors and Activities (Part 2)
- Planning And Controlling
- Multitasking
- Generational Distinctions
- Diversity and Inclusion
Lesson 11 - Workplace Behaviors and Activities (Part 3)
- Supply chain management
- Purchasing and logistics
- Scheduling
- Customer service
Lesson 12 - Becoming an Administrative Assistant and Advancing Your Career
- Duties and Traits
- Position Options
- Seeking Employment
- Career Planning
Part 3 - Management Training
Lesson 1 - Introduction to Management Principles
Lesson 2 - The Role and Responsibilities of a Manager
Lesson 3 - Building a Personal Development Plan, Your Leadership Blueprint
Lesson 4 - Corporate Culture in the Management Context
Lesson 5 - Ethics and Social Responsibility
Lesson 6 - Diversity, Equity, and Inclusion (DEIB)
Lesson 7 - Strategic vs. Operational Thinking
Lesson 8 - Goal Setting and Prioritization
Lesson 9 - Planning and Execution
Lesson 10 - Decision-Making
Lesson 11 - Time and Project Management Fundamentals
Lesson 12 - Managing Human Talent
Lesson 13 - Managing Change
Lesson 14 - Customer Relationship Management
Lesson 15 - Leadership
Lesson 16 - Motivating Employees
Lesson 17 - Team Building and Collaboration
Lesson 18 - Managing Communication and Conflict
Lesson 19 - Controlling
Lesson 20 - Career Planning