Course Description
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
