Microsoft Office Specialist Diploma Available Now

Microsoft Word Outlines

Learning Objectives Lesson #1

Open Word
Use Template
Learn Interface
Use Tabs
Open Ribbons
Use Tools
Quick Access
Use No Spacing
Change Margins
Enter Text
Move Text
Delete Text
Print Preview
Save File
Close File

Learning Objectives Lesson #2

Open Saved Files
Letter Elements
Letter Rules
Insert Word Art
Use Contextual Tab
Use Nudge
Insert Line Art
Insert Text Boxes
Use Save AS

Learning Objectives Lesson #3

Create Folder
Open Saved File
Delete Objects
Create Letterhead
Use Contextual Tabs
Format Text
Insert Clip Art
Format Clip Art
Insert Line Part
Create Bulleted List
Use Copy & Paste
Use Save As

Lesson #4 Learning Objectives

Create Empty File
Format Text
Use Change Case
Use Drop Caps
Change Line Spacing
Change Margins
Insert Header & footer
Insert Section Break
Insert Columns
Move & Copy Text
Use Borders
Use Find & Replace
Use Word Count
Use Save As

Learning Objectives Lesson #5

Open Word
Enter Text
Create Flyer
Use Styles
Use Format painter
Inset Clip Art
Insert Border Art
Insert Section Break
Remove Borders
Change page Orientation
Insert Columns
Delete Extra Page
Save in Alternate Location

Microsoft Excel Outlines

Lesson #1 Learning Objectives

Open Excel
Excel Interface
Common Screen Elements
Use Tabs
Open Ribbons
Use Tools
Excel Modes
Examine Defaults
Define Pointer
Navigate Excel
Page Break Preview
Enter Data
Make Corrections
Print Preview
Save Spreadsheet

Learning Objectives Lesson #2

Open Existing File
Display Page Break
Change page Orientation
Enter Values
Use Autofit
Format Cells
Format Text
Change Alignment
Use Merge & Center
Type Paragraphs
Use Accounting Number Formats
Use Format Painter
Use Clear Formats
Use Save AS

Learning Objectives Lesson #3

Open Existing File
Display Page Break
Copy Text
Wrap Text
Use Fill Handle
Insert Rows & Columns
Identify A Range
Insert Chart
Edit Chart
Move Chart
Use Borders Tool
Use Save As

Learning Objectives Lesson #4a

Open Excel
Display Page Break
Change Orientation
Rename Worksheet
Use Borders Tool
Create Form
Identify Range
Create Time Card

Learning Objectives Lesson #4b

Define Template
Use Template
Open Template
Replace Text
Keep Structure
Save Template

Learning Objectives Lesson #5

Create Folder
Display Page Break
Change page Orientation

Change Margins
Use Fill Handle
Rename Worksheet
Use Autofit
Use CTRL +S
Rotate Text
Insert Column
Use Drag & Drop
Conditional Formatting
Use AutoSum
Use Sheet Styles
Use Format Painter
Center On Page
Print Preview

 

Microsoft Publisher Outlines

Lesson #1

Quick Publication – Flyer & Banner

Open Publisher

Identify The Templates Window

Navigate the Interface

Identify Common Screen Elements

Use Page Navigation Pane

Design Quick Publications Flyer

Use Publications Page

Replacing placeholder Text

Replacing Placeholder Images

Use Nudge

Keep Image Proportion

Format Shapes

Change Shape Effects

Design Quick Publications Banner

Replace Text Boxes

Format Text Boxes

Change Banner Size

Determine # of Pages in a Banner

Use Print Preview

 

Lesson #2

Quick Publication – Business Card & GIF Image

Open Publisher

Identify The Templates Window

Navigate the Interface

Identify Common Screen Elements

Use Page Navigation Pane

Design Quick Publications Business Card

Change Dimension

Use Nudge

Replacing placeholder Text

Replacing Placeholder Images

Format Shapes

Change Shape Effects

Design Quick Publications Business Cards

Change Image Dimensions

Align Objects

Insert New page

Insert Margin Guide

Draw Text Boxes

Insert Border Line

Use Print Preview

Design GIF Image from scratch

Use Word Art

Fill Text Box

Use RGB & Hex #

Save as GIF File Type

 

Lesson #3

Create ½ Page Flyer from Scratch

Create Blank Publisher file

Change page Layout

Create Ruler Guides

Create Margin Guides

Duplicate Test Box

Format Text Box

Change line Spacing

Group Shapes

Un-Group Shapes

Insert Advertisements

Use Format Painter

Modify Advertisements

Insert Images

Duplicate Page

Insert Shapes

 

Lesson #4

Creating A Quick Publication Greeting Cards – Birthday
Use Greeting Card Template

Use Birthday Thumbnail

Replace Text

Insert Text Bos

Format Text Box

Line Up Text Box

Change color by RGB #

Use Greeting Card Thumbnail

Insert Online Images

Format Images

Preview Greeting Cards

Print Greeting Cards

Creating A Quick Publication – Brochure
Define Brochure
Use Brochure Template
Replace Brochure Content
Preview Brochure
Print Brochure

Microsoft PowerPoint Full Outline

Lesson #1

Define Power Point

Open Power Point

Describe Power Point Interface

Discuss Common Screen Elements

Show Tabs/Ribbons/Group of Tools

Apply to Power Point Interface Only

Creating a slide

Typing In Placeholders

Changing a slide’s layout

Changing Slide’s Position

Using Slide Sorter

Using Slide Pany Thumbnails

Using Slide Views

Presenting Your Presentation

Navigating Your Presentation

Ending your Presentation

Lesson #2

Creating Folders

Opening an existing Publication

Deleting Slides

Inserting Images 

Sizing Images

Displaying in Print Preview

Using Save As

Guidelines for Publications

Enhancing Your Presentation

Using Design View

Changing Themes

Formatting Background

Inserting Picture from your computers

Sizing and Formatting Images

Using Contextual Tabs

Insert Web Pictures

Lesson #3

Creating an Empty File

Inserting Slides

Insert Local Images

Size Images

Typing Text In slides

Change Slide Layout

Select Slides

Change Slide Design

Convert Text to Smart Art

Insert Shapes

Format Shapes

Locking Objects

Insert Video from Your PC

Insert Video from The Web

Lesson #4

Inserting Smart Art

Using Nudge

Creating Charts

Recording Audio

Screen Recording

Using Animation

Animating Smart Art

Animating Images & Text

Using Transition

Presenting presentation

The Actual Presentation

Connecting To a Projector

Microsoft Access Outlines

Learning Objectives

Introduce Access

Dissect Access

Describe Interface

Save Database

Discuss Common Screen Elements

Introduce Access Containers

Describe Tables

Save Table

Create Table Elements

Use Design Views

Use Datasheet View

Describe Field Data Types

Use Field properties

Use Lookup Wizard

Use Input Mask

Enter Records

Insert Fields in Datasheet View

Move Fields

 

Introduce Access

Dissect Access

Describe Interface

Discuss Common Screen Elements

Introduce Forms

Design form

Use Form

Enter Data into Forms

Navigate Forms

Search Forms

Windows Navigation Bar

Delete Records in Forms

Filter Records in Forms

Add Ne Field to Table

Add New Field to Existing Form

 

Introduce Access

Dissect Access

Describe Interface

Discuss Common Screen Elements

Introduce Queries

Create Simple Query

Use Design Query

Creating a Custom Report

Put All Together

Introduce Table

Create Lookup List

Set Input Mask

Save Table

Introduce Forms

Use Form

Change Table Structure

Change Field names

Save Form

Introduce Reports

Design Report

Save Report

Introduce The Query

Choose Fields

Set Search Criteria

Run Query

Save Query

 

Work with Multiple Tables

Introduce Primary Keys

Delete Primary Key Field

Re-create Primary Key field

Move fields

Create Lookup Combo Box

Introduce Relationships

Create Relationships

Introduce Referential Integrity

Enforce Referential Integrity

Introduce one to Many relationship

Create Lookup Query

Create Lookup form