Microsoft Office Specialist (MOS) 2019 & 365 Course Bundle

The following topics are covered:

• Introduction
• The Excel Application
• Managing Worksheets & Workbooks
• Navigating Worksheets & Workbooks
• Formatting Worksheets & Workbooks
• Customisation Option & Views
• Configuring Content For Collaboration
• Lesson Review & Quiz
• Assignment 1 - Worksheet & Workbook Exercises

The following topics are covered:

• Introduction
• Manipulating Data in Worksheets
• Formatting Cells & Ranges
• Summarising Data Visually
• Applying Formulas
• Lesson Review & Quiz
• Assignment 2 - Data Cell & Range Exercises

The following topics are covered:

• Introduction
• Creating & Formatting Tables
• Modifying Tables
• Filtering & Sorting Table Data
• Introducing Pivot Tables & Charts
• Lesson Review & Quiz
• Assignment 3 - Table Exercises

The following topics are covered:

• Introduction
• Inserting References
• Calculating & Transforming Data
• Using Conditional Logic In Functions
• Formatting & Modifying Text With Functions
• Introducing Maths Functions
• Introducing Date & Time Functions
• Lesson Review & Quiz
• Assignment 4 – Function Exercises

The following topics are covered:

• Introduction
• Creating & Modifying Charts
• Formatting Charts
• Working With Objects
• Lesson Review & Quiz
• Assignment 5 - Charts & Object Exercises
• The MOS Examination Explained

The following topics are covered:

• Introduction
• Managing Workbooks
• Preparing Workbooks for Collaboration
• Using and Configuring Language Options
• Lesson Review & Quiz
• Assignment 1 - Workbook Options & Settings Exercises

The following topics are covered:

• Introduction
• Fill Cells Based on Existing Data
• Formatting & Validating Data
• Advanced Conditional Formatting & Filtering
• Lesson Review & Quiz
• Assignment 2 - Custom Data Formatting Exercises

The following topics are covered:

• Introduction
• Performing Logical Operations in Formulas
• Lookup Data Using Functions
• Using Advanced Date & Time Functions
• Performing Data Analysis
• Troubleshooting Formulas
• Creating & Modifying Macros
• Lesson Review & Quiz
• Assignment 3 - Advanced Formula Exercises

The following topics are covered:

• Introduction
• Creating & Modifying Advanced Charts
• Creating & Modifying Pivot Tables
• Managing Pivot Tables
• Create & Modifying Pivot Charts
• Lesson Review & Quiz
• Assignment 4 - Advanced Table & Chart Exercises
• The MOS Examination

The following topics are covered:

• Introduction
• Word Basics
• Creating Documents
• Navigating Within Documents
• Formatting Documents
• Saving, Customising, & Sharing Documents
• Inspecting Documents For Issues
• Lesson Review & Quiz
• Assignment 1 - Word Document Exercises

The following topics are covered:

• Introduction
• Inserting Text & Paragraphs
• Formatting Text & Paragraphs
• Creating & Configuring Document Sections
• Lesson Review & Quiz
• Assignment 2 - Formatting Exercises

The following topics are covered:

• Introduction
• Creating a Table
• Modifying A Table
• Creating & Modifying Lists
• Lesson Review & Quiz
• Assignment 3 - Table & List Exercises

The following topics are covered:

• Introduction
• Creating & Managing Reference Elements
• Making Citations
• Creating Captions
• Creating & Managing Reference Tables
• Lesson Review & Quiz
• Assignment 4 - Reference Exercises

The following topics are covered:

• Introduction
• Inserting Illustrations & Text Boxes
• Formatting Illustrations & Text Boxes
• Adding Text to Graphic Elements
• Modifying Graphical Elements
• Lesson Review & Quiz
• Assignment 5 - Course Project
• The MOS Examination Explained

The following topics are covered:

• Introduction
• Adding & Managing Comments
• Manging Change Tracking.

The following topics are covered:

• Introduction
• Managing Documents & Templates
• Preparing Documents for Collaboration
• Managing Document Changes
• Using & Configuring Language Options
• Lesson Review & Quiz
• Assignment 1 - Document Options & Settings Exercises

The following topics are covered:

• Introduction
• Creating & Modifying Building Blocks
• Creating Custom Design Elements
• Creating & Managing Indexes
• Creating & Managing Tables of Figures
• Lesson Review & Quiz
• Assignment 3 – Advanced Document Element Exercises

The following topics are covered:

• Introduction
• Managing Forms, Fields, & Controls
• Creating & Modifying Macros
• Mail Merge Recipient Lists
• Mail Merge Operations Lesson Review & Quiz
• Assignment 4 – Advanced Word Feature Exercises
• The MOS Examination.

The following topics are covered:

• Getting started
• The PowerPoint application
• Creating presentations
• Inserting and formatting slides
• Modifying slide masters, handouts, and notes
• Changing presentation options and views
• Configuring a presentation for printing
• Configuring and presenting a slide show
• Preparing presentations for collaboration
• Lesson review & quiz
• Assignment 1 - Creating an AGM presentation

The following topics are covered:

• Introduction
• Inserting slides
• Modifying slides
• Ordering & grouping slides
• Lesson review & quiz
• Assignment 2 - Adding to the AGM presentation

The following topics are covered:

• Introduction
• Formatting text
• Inserting links
• Inserting and formatting images
• Inserting and formatting graphic elements
• Ordering and grouping objects
• Lesson review & quiz
• Assignment 3 - Updating the AGM presentation with text boxes, shapes, & images

The following topics are covered:

• Introduction
• Inserting and formatting tables
• Inserting and modifying charts
• Inserting and formatting SmartArt graphics
• Inserting and modifying 3D models
• Inserting and managing media
• Lesson review & quiz
• Assignment 4 - Updating the AGM presentation with tables, charts, SmartArt, & media.

The following topics are covered:

• Introduction
• Applying and configuring slide transitions
• Animating slide content
• Set timing for transitions and animations
• Lesson review & quiz
• Assignment 5 - Adding transitions and animations to the AGM presentation
• The MOS Examination

The following topics are covered:

• Getting started
• Customising Outlook settings
• Configuring mail settings
• Performing search operations
• Printing & saving information
• Lesson review & quiz
• Assignment 1 - Outlook settings and processes exercises

The following topics are covered:

• Introduction
• Creating Messages
• Message options
• Inserting message content
• Organising messages
• Managing messages
• Lesson review & quiz
• Assignment 2 - Managing messages exercises

The following topics are covered:

• Introduction
• Configuring mail settings
• Formatting messages
• Managing conversations
• Quick Steps, archiving, and delegating access
• Lesson review & quiz
• Assignment 3 - Mail settings and formatting exercises

The following topics are covered:

• Introduction
• Creating & managing calendars
• Creating appointments, meetings, & events
• Organising & managing appointments, meetings, & events
• Lesson review & quiz
• Assignment 4 - Scheduling exercises

The following topics are covered:

• Introduction
• Creating & managing contacts
• Managing address books
• Creating & managing contact groups
• Creating & managing notes & tasks
• Lesson Review & Quiz
• Assignment 5 - Contacts & tasks exercises
• The MOS examination

The following topics are covered:

• Introduction
• Modifying Database Structure
• Managing Table Relationships & Keys
• Printing & Exporting Data
• Lesson Review & Quiz
• Assignment 1 - Creating & Modifying Databases Exercises

The following topics are covered:

• Introduction
• Creating Tables
• Managing Tables
• Managing Records In Tables
• Creating & Modifying Fields
• Lesson Review & Quiz
• Assignment 2 - Database Table Exercises

The following topics are covered:

• Introduction
• Creating & Running Queries (1)
• Creating & Running Queries (2)
• Modifying Queries
• Creating Calculated Fields & Grouping
• Lesson Review & Quiz
• Assignment 3 - Query Exercises

The following topics are covered:

• Introduction
• Configuring Form Controls (1)
• Configuring Form Controls (2)
• Formatting Forms (1)
• Formatting Forms (2)
• Lesson Review & Quiz
• Assignment 4 - Forms Exercises

The following topics are covered:

• Introduction
• Configuring Report Controls
• Formatting Reports
• Lesson Review & Quiz
• Assignment 5 – Report Exercises
• The MOS Examination