Microsoft Office Specialist

Introduction to computer system beginner course

What is a computer

Identifying the different parts of the computer

Setting up a computer system for operation

The use of computer keyboard

The use of computer mouse

The desktop environment and how to launch apps

File management operations

Common computer problems and solutions

Text selection techniques

Cut, copy and paste text

Undo and redo document changes

Fonts and formats overview

Apply text font types and sizes

Text Font formats

Text alignment options

Document line and paragraph spacing

Formatting Business Letters

Resume and Cover Letter Writing

Creating a list

Sorting a list

Renumber a list

Customizing a list

Creating a table

Converting a Text to Table

Manipulating Table structures

Exploring page layout options

Adjusting margins

Adjusting paper sizes

Formatting Page columns

Inserting page breaks and sections

Contextual Menus

Inserting and manipulating pictures

Inserting and manipulating shapes

Inserting screenshots

Inserting Signature line in documents

Working with Equations and symbols

Adding cross-references

Adding Bookmarks

Adding Hyperlinks to document

Insert Document Footnotes and Endnotes

Inserting and formatting page numbers

Adding Citations and Table of References

Adding and replying comments

Tracking Document Changes

Reviewing Tracked Changes

Share a document

Merge changes to Documents

Creating Mailing List and Address

Understanding mail merges

Finding or creating recipient data source

Formatting and setting data source

Merging data

Completing mail merge

Preparing Documents for printing

Using the Print Preview

Print Documents

Printing Envelopes and Labels

Exporting Documents to PDF and other formats

Sharing and collaborating

Launching Excel application

Excel Interface

Using the Excel backstage view

Preparing Documents for printing

Using the Print Preview

Print Documents

Printing Envelopes and Labels

Exporting Documents to PDF and other formats

Understanding and displaying formulas

Understanding order of operations

Using cell references in formulas

Cross-sheet referencing

Cross-workbook referencing

Using cell ranges in formulas

Naming a range

Using the SUM function

Using the COUNT, COUNTA, COUNTBLANK functions

Using statistical functions

Excel conditional functions

Inserting and deleting cells and ranges

Manually formatting cells and cell contents

Wrapping text within cells

Merge cells and splitting merged cells

Placing borders around cells

Copying cell formats using the format painter

Formatting cells with styles

Inserting or deleting rows and columns

Hiding and unhiding rows and columns

Transposing rows and columns

Using themes in workbooks

Viewing and printing worksheet guidelines

Inserting and manipulating headers and footers

Adding and moving page breaks

Setting worksheet orientation

Copying and renaming Worksheets

Hiding and unhiding worksheets

Deleting worksheets

Freezing worksheet Panes

Finding and replacing worksheet data

Sorting data on a single criterion

Sorting data with multiple criteria

Sorting data using cell attributes

Filtering data

Filtering data using cell attributes

Chart types and description

Selecting data to include in charts

Moving a chart

Using recommended charts

Formatting a chart with a quick style or layout

Adding and removing chart elements

Adding an additional data series

Choosing a different chart type

Inserting a picture from a file

Inserting picture from online sources

Adding and formatting shapes

Adding text to shapes

Resizing shapes

Stacking overlapping graphics

Creating SmartArt graphic

Printing with the backstage view

Setting the print area

Printing selected worksheets

Printing an entire workbook

Applying printing options

Scaling a worksheet to fit on a printed page

Page layout view

Page break view

Normal view

Custom views

Understanding the PowerPoint interface

PowerPoint Navigation and Ribbon

PowerPoint backstage options

Adding and deleting slides

Changing slide layouts

Selecting Text

Cut, Copy and Paste Text

Text Formatting skills

Inserting Textboxes

Working with shapes

Inserting SmartArt shapes

Inserting and manipulating Pictures on slides

Inserting and manipulating Videos on slides

Inserting and manipulating Audio on slides

Working with Excel Charts

Creating tables

Add and Distribute columns and rows

Slide Transitions

Transition options

Animation Effects

Animation options

Animation timings

Reordering animations

Using the slide master to edit slide contents

Using the Notes master

Preparing presentation Handouts with Handout master

Presenting a slideshow

Slideshow tools

Presenter view

Convert presentations to video (.mp4)

Presenting online

Start Microsoft Access 365

Open an existing database

Using the Navigation Pane

Using the ribbon

Using the backstage view Database fields

Modifying data types for fields

Use a template to create a database

Create a blank database

Create a Table from Another Table

Save a Table

Navigating through records

Enter, Edit and Delete records

Defining primary key

Define and Modify a Multi-field Primary Key

Sort Data within a Table

Filtering Data within a Table

Remove a Filter

Freeze/Unfreeze and Hide/Unhide Fields

Define Table Relationships

Modify Table Relationships

Print Table Relationships

Modify Table properties

Rename a Table

Delete a Table

Set a Field Property in Datasheet View and Design View

Define Input Masks for Fields

Allow Zero Length

Set Data Validation Rules

Enter Captions

Create Fields

Delete a Field

Create a Multivalued Lookup Field

Creating a simple form and delete a form

Create a form in design view

Creating a form in layout view

Use the form wizard

Apply a theme

Sort Data within a form

Filter Data with Common Filters

Use filter by form

Create and delete a report

Use the report wizard

Create a report in design view

Apply a theme

Group and Sort Data within a report

Filter Data within a report

Find data within a report

Create a simple query

Create a find duplicates query

Create a query from multiple tables

Find unmatched records

Add a table to a query

Add criteria to a query

Sort data within a Query

Filter Data within a Query

Importing Data from a specific source

Run import specifications

Export from Table to Excel and other formats

Microsoft Outlook Ribbon

Personalizing Outlook

Using the backstage view

Creating Message

Sending a Message

Reading and responding to message

Formatting messages

Personalizing Message

Working with Quick Parts

Inserting and Formatting Graphic Message Content

Working with Attachments

Managing Automatic Message Handling

Automating Message Format

Using message options

Working with security

Sorting Email messages

Filtering Email Messages

Printing Multiple Messages

Creating and modifying contacts

Sending and receiving contacts

Viewing and deleting contacts

Creating and manipulating contact groups

Creating appointments

Sending appointment options

Creating an event

Printing appointment details

Setting calendar options

Sharing your calendar

Managing a calendar

Creating a meeting request

Responding to a meeting request

Managing a meeting

Updating a meeting request

Managing a recurring meeting

Sharing meeting notes

Creating new Tasks

Working with Task options

Managing and completing a task

Working with assigned tasks