$2,745.00 CAD / 10 DAYS

1) Select Location for Dates in Your City:


Choose Date

  • No available dates.

Notify me Click on date to Register Now or click Notify Me to receive an email notification when course is Guaranteed to Run. once the following courses become Guaranteed to run.

No available dates.

Jump to Shopping Cart Continue shopping

Computer Employment Skills – Level 2 / Med.

 

DAY 1 Microsoft Word Level 2, Part 1

 

WORD LEVEL 1 REVIEW

WORK WITH TEMPLATES

Create a Template

Save a Document as a Template

Accessing User Created Templates

Edit a Template

STYLES

Using Styles

Creating Paragraph Styles

Applying Styles

Modifying Styles

Organizing Styles

 

USE DELINEATION TOOLS

Add and Format Columns

Insert Line, Page, Column and Section Breaks

Change the Page Layout within a Section

Add a Cover Page and a Blank Page

Change the Page Colour

Add a Watermark

Add a Page Border

Change Margins and Indents Using the Ruler

Set tabs

Move Tabs

Remove Tabs

Use the Document Browser

Use the Navigation Pane

Arrange Windows

Compare Documents Side by Side

Split a Document

 

USE HYPERLINKS

Insert a Link

Open, Edit and Remove Links

 

HEADERS AND FOOTERS

Use a Preset Header or Footer

Edit a Header or Footer

Add a Header or Footer to the Gallery

Remove a Header or Footer

Use the Header and Footer Tools Design Tab

Insert, Format and Remove Page Numbers

Link and Unlink Headers and Footers

 

USE TIME SAVING TOOLS

Use the Research Pane

Use the Thesaurus

Use Auto Translate

Translate  a Document

Insert the Date and Time

Insert a Symbol

 

MAIL MERGE

Use the Mail Merge Wizard for Letters

Use the Mail Merge Wizard for Labels

 

Lab session: Word Workbook – pgs 1 – 115

If time, Mavis Beacon – 20 – 40 wpm

 

 

DAY 2 Microsoft Word 2010 Level 2, Part 2

 

WORKING WITH  GRAPHICS

Insert a Picture from a File

Insert Clipart

Add a Screenshot

Resize, Rotate and Move Pictures

Change Text Wrap and Picture Position

Crop a Picture

Format Using the Picture Tools Ribbon

Edit a Picture’s Background

Change, Reset and Export a Picture

 

WORKING WITH ADVANCED GRAPHICS AND OBJECTS

Insert Pre-Defined Text Boxes

Draw a Text Box

Use the Text Box Tools Ribbon

Link and Unlink Text Boxes

Create a Quick Part

Insert Quick Parts

Use the Buildilng Blocks Organizer

 

TABLES

Create and Insert Tables

Draw a Table

Use Quick Tables

Add an Excel Spreadsheet

Selecting in a Table

Insert and Delete Columns and  Rows

Merge and Split Cells

Move, Resize and Split a Table

Apply a Table Style

Align a Table and its Cells

Change Cell Margins and Spacing

Change Text Direction

Use Autofit and Distribute

Manually Format a Table and Borders

Use the Table Properties Dialog

Sort Table Data

Convert Text to Table and Vice Versa

Use Formulas in a Table

 

Lab session: Word Manual, pgs: 116 to End

If time, Mavis Beacon – 20 – 40 wpm

 

 

DAY 3 Microsoft Excel 2010 Level 2, Part 1

 

REVIEW LEVEL 1 EXCEPT FOR FUNCTIONS

CONDITIONAL FORMATTING

Add Conditional Formats

Modify Default Conditional Formatting

Create Conditional Formatting Rules

 

USING CUSTOM AUTOFILL LISTS

Create a Custom Autofill List

Modify a Custom List

Use a Custom List

Delete a Custom List

 

WORKING WITH TABLES

Create a Table

Modify and Format Tables

Use the Total Row

Add Fields by Inserting Columns

Add Records by Inserting Rows

Delete Records or Fields

Remove Duplicate Records

Use Automatic Series Fill in a Table

 

SORTING AND FILTERING DATA

Sort Data in a Table

Used Advanced Sorting Options

Use Autofilters

Create Custom Autofilters

Use an Advanced Filter

Copy Filtered Records

Remove Filters

 

SUBTOTALS

Creating Subtotals

Expand/Collapse Subtotals

Change Subtotal Views

Remove Subtotals

 

Lab session: Excel Workbook pgs 1 – 55

If time, Mavis Beacon – 20 – 40 wpm

DAY 4 Microsoft Excel 2010 Level 2, Part 2


WORKING WITH CHARTS

Create a Chart

Style a Chart with the Design Tab

Format a Chart with Right Click Options

Modify Charts with the Layout Ribbon

Format Chart Elements with the Format Ribbon

Move a Chart

Change the Type of Chart

Change the Source Data

Save a Chart as a Template

 

WORKING WITH SPARKLINES

What is a Sparkline?

Add and Remove Sparklines

Edit Sparkline Data

Format Sparklines

Set Sparkline Options

 

REVIEW LEVEL 1 FORMULAS AND FUNCTIONS

WORK WITH FORMULAS AND FUNCTIONS

Use Relative and Absolute References

Use Multiple Ranges in a Formula

Trace Precedents

Trace Dependents

Remove Trace Arrows

Show Formulas on the Worksheet

Use Error Checking

Use a Watch Window

Add and Delete Cells from the Watch Window

Overview of Function Categories

 

USING THE INSERT FUNCTION WIZARD

Open the Insert Function Wizard

Find a Function

Get Help on Functions

Enter Arguments into the Function Wizard

 

WORKING WITH NAMES AND RANGES

Define and Use Range Names

Delete Named Ranges

Use Named Ranges in a Formula

 

Lab session: Excel Workbook pgs 56 to end

If time, Mavis Beacon – 20 – 40 wpm

 

 

DAY 5 Microsoft Outlook 2010 Intermediate

 

ORGANIZE YOUR EMAIL

Create Folders

Rename, Move and Delete Folders

Move Messages into Folders

Add, Reorder and Remove Folders from the

Favourites List

Use the Search Box

Use the Search Tools Ribbon

Use the Rules and Alerts Wizard

Create an Out of Office Message

Mark a Message for Follow-up

Use Quick Steps

Create Quick Steps

Manage Quick Steps

Set up Categories

Assign Categories

Use Categories in a View

 

ADVANCED EMAIL FEATURES

Create and Use a Signature

Edit a Signature

Set Signature Options

Use and Customize Stationary

Set a Default Theme for Stationary

Customize Default Message Fonts

Request Delivery and Read Receipts

Add Voting Options

Delay Message Delivery

Insert a Calendar

Add a Business Card

 

CALENDAR

Create and Edit Appointments

Schedule an All Day Event

Use the Time Zone Feature

Create a Recurring Appointment

Move and Copy Appointments

Send a Meeting Request

Reply to a Meeting Request

Set Calendar Options

Add Additional Time Zone and Canadian Holidays

Use the Daily Task List

Customize Calendar Views

 

TASK MANAGEMENT

Add, Update and Edit a Task

Create a Recurring Task

Use Task Views

Assign a Task

Send a Status Report

Mark a Task as Private

Change Task Options

 

NOTES AND JOURNAL

Create a Note

Moving a Note

Customize Notes Views

Set Journal Options

Create a New Journal Entry

Edit a Journal Entry

Customize Journal Views

 

Lab session: Outlook Workbook

If time, Mavis Beacon – 20 – 40 wpm

 

 

DAY 6 Microsoft PowerPoint 2010 Comprehensive Day 1

 

GETTING STARTED

Interface Overview

Create a New Presentation

Insert a Slide

Add Notes to a Slide

Apply a Slide Layout

Types of Placeholders

Resize, Move and Delete Placeholders

Change a Slide Layout

Delete a Slide

Reset a Slide

Drag n Drop Slides

Duplicate Slides

Create and View Sections

Move and Delete Sections

Create a Presentation from Templates

Create a Presentation from Themes

Use Sample Files

Save As Options

 

USE VIEWS

Use the Slide Sorter View

Use the Outline View

Use Notes Page and Reading Views

View a Slideshow

Navigate a Slideshow

Use Slideshow Buttons

Change the Theme

Add and Modify Headers and Footers

Change Slide Orientation

Customize Theme Colours, Fonts and Effects

Format and Modify Slide Backgrounds

 

ADD ANIMATION

Add and Modify Slide Transitions

Set Transition Timing and Effect Options

Add a Sound

Add Basic Animation

Set Animation Options

Reorder Animation

Create Advanced Animation

Use Motion Paths

Set an Animation Trigger

Use the Animation Pane

Use the Animation Painter


ADD ART TO A PRESENTATION

Add and Delete an Autoshape

Use the Drawing Tools Ribbon

Resize, Move, Select and Rotate Shapes

Add Text to a Shape

Format Shape Line Weight , Style and Colour

Edit Shapes

Arrange, Group and Ungroup Shapes

Align and Distribute Shapes

Add Text to Shapes

Format Shape Text

Transform Text

Use the Format Shape Dialog Box

Fill a Shape with a Custom Gradient

 

WORDART AND SHAPE TASKS

Add and Format WordArt

Apply WordArt to Pre-Existing Text

Add a Picture Fill to WordArt

Use Grids and guides

Use the Format Shape Dialog

  

Lab session: PowerPoint Workbook pgs 1 – 137

If time, Mavis Beacon – 20 – 40 wpm

 

 

DAY 7 Microsoft PowerPoint 2010 Comprehensive Day 2

 

USE SMARTART

Add SmartArt Diagrams

Add Text and Photos to SmartArt

Move, Resize and Delete SmartArt

Use the SmartArt Tool Design Ribbon

Use the SmartArt Tool Format Ribbon

Reset and Convert SmartArt

Convert a Bulleted List to SmartArt

 

CREATE A PHOTO ALBUM

Create a Photo Album

Reorder the Picture Sequence

Rotate, Flip and Adjust Pictures in the Photo Album

Apply a Layout

Modify the Frame Shape

Apply a Theme

Display in Black and White

Add Captions

Change and Update a Photo Album

 

ADD AUDIO AND VIDEO EFFECTS

Add Movies from the Clip Organizer

Add a Movie from a File

Use the Video Tools Format Tab

Delete a Movie

Insert a Sound Clip from the Organizer or a File

Use Sound Tools

Record a Sound or Narration

Play a CD

Delete a Sound

Hide a Sound Icon

Change the Picture for a Sound Icon

 

USE MASTERS

What is a Slide Master?

Use the Slide Master Ribbon

Use the Notes Master Ribbon

Use the Handouts Master Ribbon

Apply Slide, Notes and Handout Masters

Remove Masters

 

ADVANCED SHOW FEATURES

Hide and Show Slides

Rehearse Timings

Create a Custom Show

Edit, Present and Delete a Custom Show

Package a Presentation for CD

 

DESIGN CONCEPTS

Type and size of fonts

Use of colour

Amount of text and bullets

Consistency, simplicity etc.

Environmental Considerations

Audience Considerations

Storyboard and Timeline

Modify Masters

Create Handouts in MS Word

 

 

Lab session: PowerPoint Workbook pgs 138 – end

If time, Mavis Beacon – 20 – 40 wpm

 

DAY 8 Microsoft Windows 7 Intermediate

 

WORK WITH GADGETS

Add Gadgets

Customize Gadgets

Delete Gadgets

Get Gadgets Online

 

USE WINDOWS 7 APPLICATIONS

Use the Calculator

Use the Snipping Tool

Use Sticky Notes

Use the Picture Library to create a Slideshow

Use Windows Live Photo Gallery

Use Windows Live Movie Maker

 

CUSTOMIZING THE DESKTOP

Customize the Task Bar

Apply a Desktop Background

Create a Custom Desktop Background

Apply a Screen Saver

Change Window Appearance

Change Sound Schemes

View and Arrange Options for the Desktop

 

MAKING WINDOWS WORK FOR YOU

Use the Control Panel

Modify Screen Resolution

Change Mouse Behaviour

View System Information

Set Accessibility Options

 

MAINTAIN AND OPTIMIZE YOUR COMPUTER

Clean Up the Hard Disk

Defragment the Hard Disk

Clear Temporary Internet Files and Cookies

 

TROUBLESHOOT YOUR COMPUTER

Back Up Your Computer

Create a System Repair Disk

Use Easy Transfer

Use System Restore

Use Add/Remove to properly remove programs from

Computer

 

Lab session: Windows7 Intermediate Manual

If time, Mavis Beacon – 20 – 40 wpm

 

 

DAY 9 Review / Project Instruction

Create a presentation using PowerPoint

Email presentation to your instructor

 

Lab session: Project

 

DAY 10 Lab session: Project completion