Course Content
MOS – Microsoft® Office Specialist
    About Lesson

    Microsoft Office 2021
    Word 2021

    • Core:

      • Document Creation: Basic tools for creating and editing text documents.
      • Text Formatting: Options for font style, color, and size.
      • Spell Check: Tools for checking spelling and grammar errors.
      • Templates: A selection of ready-made templates to help get started.
      • Basic Editing: Tools for text modification, such as copy, paste, and find.
    • Advanced:

      • Advanced Formatting: More sophisticated options for formatting text and tables.
      • Mail Merge: Capability to send personalized messages to multiple recipients.
      • References: Tools for adding citations, bibliographies, and indexes.
      • Collaboration: Features for sharing documents and real-time collaboration.
      • Inserting Graphics: Professional tools for adding charts, images, and graphics.

    Excel 2021

    • Core:

      • Data Entry: User-friendly interface for inputting data into cells.
      • Basic Formulas: Using fundamental functions like SUM and AVERAGE.
      • Charting: Creating simple charts to visualize data.
      • Conditional Formatting: Options for formatting cells based on values.
    • Advanced:

      • Advanced Functions: Utilizing complex functions like VLOOKUP and IF.
      • Pivot Tables: Creating tables for analyzing large datasets.
      • Data Analysis Tools: Advanced options for graphing and analyzing data.
      • Add-ins: Ability to use add-ins for enhanced functionality.

    PowerPoint 2021

    • Comprehensive:
      • Presentation Creation: Tools for making engaging and visually appealing slides.
      • Animations: Options for adding motion effects to text and images.
      • Transitions: Effects between slides to enhance presentation flow.
      • Media Insertion: Capability to add videos and audio files.
      • Collaboration and Sharing: Features for teamwork and feedback.

    Outlook 2021

    • Email Management: Tools for sending and receiving emails efficiently.
    • Calendar: Scheduling meetings and appointments with reminders.
    • Tasks: Managing tasks and tracking progress.
    • Advanced Search: Tools for quickly finding messages and appointments.
    • Security Features: Improvements in email security and information protection.