Learning Objectives

Intellectual Point
Document and Content Management

Covers creating, managing, and formatting documents, spreadsheets, and presentations, including tasks like managing documents, inserting and formatting text, and managing document collaboration.

Intellectual Point
Data Management and Analysis

Focuses on managing data cells and ranges, creating tables, applying formulas and functions, and managing charts, primarily within Excel.

Intellectual Point
Presentation Design and Delivery

Involves creating and managing presentations, inserting and formatting shapes and slides, applying transitions and animations, and managing multiple presentations in PowerPoint.

Intellectual Point
Database Management

Addresses creating and modifying databases, tables, queries, forms, and reports in Access, including managing database objects and relationships.

Intellectual Point
Communication and Collaboration

Encompasses managing Outlook settings and processes, handling messages, schedules, contacts, and tasks, facilitating effective communication and collaboration.

  • The Microsoft Office Specialist (MOS) Training Course at Intellectual Point is meticulously designed to provide participants with in-depth knowledge and practical expertise in Microsoft Office applications such as Word, Excel, and PowerPoint. This course is structured to guide you through the essential functions and advanced features of these productivity tools, preparing you for the MOS certification exam. With hands-on training and real-world scenarios, you'll master document formatting, data manipulation, and presentation design to enhance office efficiency and productivity.
  • Throughout this comprehensive course, you'll gain the skills necessary to perform a wide range of tasks, from creating detailed documents to building complex spreadsheets and engaging presentations. By the end of the training, you will confidently apply your skills in workplace settings, enhance your productivity, and be prepared to attain the MOS certification. By the end of this course, participants will:
  • 1) Create and format professional documents using advanced Word features.
  • 2) Analyze and organize data proficiently using Excel advanced functions.
  • 3) Design compelling and informative presentations with PowerPoint.
  • 4) Utilize Microsoft Office tools to optimize workflow and productivity.
  • 5) Achieve mastery over Microsoft Office applications to successfully pass the MOS exam.

Module by Module Learning Outline

Program Materials

Microsoft Word Mastery

Learning Objectives

  • Develop advanced skills in document creation and formatting using Microsoft Word.
  • Prepare professional documents to meet workplace standards and certification requirements.

Topics Covered

  • Document Creation and Management: Navigating and customizing the Word interface. Creating and managing documents with ease.
  • Advanced Formatting Techniques: Utilizing styles and themes for consistency. Implementing advanced page layout features.

Excel for Data Analysis

Learning Objectives

  • Master data manipulation and analysis using advanced Excel functionalities.
  • Enhance decision-making processes through effective data visualization.

Topics Covered

  • Advanced Spreadsheet Functions: Understanding complex formulas and functions. Utilization of pivot tables and charts for analytical insights.
  • Data Visualization and Management: Designing interactive dashboards for data presentation. Techniques for efficient data sorting and filtering.

PowerPoint Presentation Design

Learning Objectives

  • Create engaging and informative presentations using PowerPoint.
  • Apply design principles to enhance presentation effectiveness.

Topics Covered

  • Designing Compelling Presentations: Integrating multimedia elements into slides. Using master slides and design templates for cohesive presentations.
  • Effective Presentation Techniques: Storyboarding and structuring presentations. Tips for delivering impactful presentations.

Integrating Microsoft Office Applications

Learning Objectives

  • Utilize synergies between Word, Excel, and PowerPoint to streamline workflow.
  • Prepare documents and presentations for collaborative projects.

Topics Covered

  • Cross-application Techniques: Linking data between Excel and Word. Embedding Excel charts into PowerPoint presentations.
  • Workflow Optimization: Automating repetitive tasks using macros. Collaborating with others using Microsoft Office features.

Certification Exam Preparation

Learning Objectives

  • Develop effective exam strategies to tackle the MOS certification successfully.
  • Review and practice certification-type questions and tasks.

Topics Covered

  • Understanding the Exam Format: Overview of the different MOS certification exams. Key areas and objectives of the exam.
  • Practice and Review Sessions: Timed practice exercises simulating exam conditions. Techniques for managing exam time and stress.

Tuition & Hours

Tuition is charged by course. The cost of the certification exam is not included in the tuition and is a separate cost based on the current rates as set by the vendor.

Course Total Hours Tuition
IT-102: Microsoft Office Specialist (MOS) 72 $4,499.00

Books & Supplies

There are no additional charges for books or supplies.

Indirect Costs

Should a student wish to obtain the Microsoft Office Specialist (MOS) certification exam, the cost is an additional fee not covered in tuition. While encouraged, the exam is not a required expense to be paid at the time of enrollment. To obtain a voucher for the certification exam, you will need to purchase it separately.

Course Exam Exam Fee
IT-102: Microsoft Office Specialist (MOS) Microsoft Office Specialist (MOS) $400

Program Award

Upon successful completion of the course, the student will receive a Certificate of Completion for Microsoft Office Specialist (MOS) Training.

* Exam fees are quoted based on time of publication. Voucher prices may change based on vendor rates and are updated accordingly. Please contact Intellectual Point to verify exam fee charges.

Register For Class

No courses available at this time

Download Course PDF

NOT SURE WHERE TO START?

Private Team Training

Enrolling at least 3 people in this course? Consider bringing this (or any course that can be custom designed) to your preferred location as a private team training

For details, call 703-554-3827

Presentation to full room

Come Learn With Intellectual Point

Price Match Guarantee!

We will match Competitor’s Price Quote.
Call for more details 703-554-3827

A Microsoft Office 2016 Specialist Certification Course at Intellectual Point Includes:
  • A thorough review of all Microsoft Office topics by industry experts
  • 24 x 7 access to the real labs in classrooms and remotely
  • 100% latest material & and realistic practice questions
  • Confidence building hands-on training
  • Free mobile applications to study on your own time
  • Study materials, notes, videos, flashcards, and practice questions included in the course price

happy clients

What Our Customers Say - Based on over 600+ Reviews!

Our Top Customers
Training and Testing Partners