File / Organization Basics

•   File Formats (.doc, .txt, .rtf, .pdf) - Benefits of Different Types

Formatting

Images

•   WordArt

•   Types of Image Formats (jpg, tif, gif…)

•   Modifying Images – Stretch/Skew & Flip/Rotate – MS Paint

•   Create WordArt, modify existing images and insert them into practice documents

Tables

•   Creating

•   Selecting Cells, Rows, Columns

•   Formatting Cells

•   Merging Cells

•   Formatting Tables

•   Wrapping Text Around Tables

•   Borders and Shading Cells/Tables

•   Create practice tables

Advanced Basics

•   Formatting & Suppressing Page Numbers

•   Finding and Replacing Formatting

•   Using and Creating Templates

•   Practice creating report style templates, finding and replacing text, and changing page number format.

Formatting

Images

•   Text Wrapping Around Images – Edit Wrap Points

Tables

•   Convert text to table

•   Convert tables to text

Group Editing / Collaboration Tools

•   Compare and Merge Documents

•   Track Changes

•   Inserting and Modifying Comments

•   Reviewing Toolbar Functions

Inserting Images, Sound, Video, Hyperlinks

•   WordArt

•   Saved Images

•   Charts, Tables

•   Sounds, Sound (music)

•   Video

•   Hyperlinks

Linking and Embedding Objects and Files

•   Embedding Word Tables/Excel Charts

•   Linking Tables and Charts

•   Breaking Links to Tables and Charts

•   Hyperlinks (Action Buttons)

Group Editing / Collaboration Tools

•   Compare and Merge Documents

•   Track Changes

•   Inserting and Modifying Comments

•   Reviewing Toolbar Functions

Presenter Tips

•   Headers and Footers

•   Speaker Notes

•   Creating Handouts of the Slide Presentation

•   Using an LCD Projector

Email

•   Flagging

•   Saving as a File

•   Assigning Permissions for Someone Else to Handle Your Mail

•   Security Zones

•   Mail Merge – Sending Form Letters to Many People

•   Archiving

•   Organizing Messages

•   Templates – using, creating

Calendar

•   Color Coding Events on the Calendar

•   Task Requests

•   Scheduling Meetings and Meeting Resources

•   Meeting Requests

•   Tracking Receipts for requests

Contacts

•   Address books other than “Contacts”

•   Sending a Letter to Multiple Contacts

•   Creating a Data Source for Mail Merge

•   Importing and Exporting Information

Configuring and Customizing Outlook

•   Forms

•   Creating New Forms – Customizing for Your Company (advanced) (184)

•   Backup Files

•   Customizing “Outlook Today”

Functions

•  3-D References (Linking Data in Separate Sheets / Books)

•  VLookup, HLookup

•  Sorting Data

•  Filtering Data

•  Date and Time Functions

•  If

•  SumIf

•  CountIf

•  Round, Roundup, Rounddown

Hide/show formulas/values

Images and Drawing Objects

•  Inserting Images / Clipart / WordArt

•  Formatting Images

•  Images in Headers

Group Editing / Collaboration Tools

•  Sharing Workbooks / Planning a Worksheet

•  Track Changes

•  Inserting and Modifying Comments

•  Reviewing Toolbar Functions

Charts & Tables

•  Line Graphs (numerical vs. numerical)

•  Pie Charts for Parts of a Column Total (1 categorical vs. 1 numerical)

•  Series and Labels for 2 Categorical vs. Numerical data bar graphs

•  Pivot Tables