Microsoft Office 2003 Solutions Workshop

Microsoft Office 2003

Solutions Workshop

Day 1 – Microsoft Word

$ Creating and Formatting Documents

$ Bullets and Numbering

$ Tabs and Indentions

$ Creating, Modifying, and Formatting Tables

$ Inserting and Modifying Graphics

$ Creating Headers and Footers

$ Creating and Using Templates

$ Sorting and Managing Lists

$ Creating and Modifying Styles

$ Applying Borders and Shading

$ Creating Section Breaks, Page Breaks, and Columns

$ Using Mail Merge Letters and Labels

$ Sharing Documents and Tracking Changes

$ Comparing and Merging Documents

$ Creating Bookmarks and Document Mapping

$ Creating Table of Contents, Index, etc.

$ Using Footnotes, Endnotes, and Captions

$ Creating Master Documents and Sub-Documents

Day 2 – Microsoft Excel

$ Creating a worksheet

$ Selecting Cells and Modifying Cell Contents

$ Selecting Cell Ranges

$ Using AutoFill

$ Creating Basic Formulas and Using Basic Functions

$ Cut, Copy, and Paste Data

$ Formatting Cells and Creating Custom Cell Formats

$ Formatting Worksheets

$ Naming, Moving, Copying, and Color-coding Worksheets

$ Using Freeze Panes and Split Screen

$ Creating Headers, Footers and Page Breaks

$ Creating and Using Templates

$ Protecting Worksheets and Workbooks

$ Creating and Modifying Charts

$ Using Logical, Financial, and Look-Up and Reference Functions

$ Creating Named Ranges and Using Named Ranges in Calculations

$ Filtering, Sorting, Outlining, and Sub-totaling

$ Import and Export Data

$ Data Validation and Auditing Tools

$ Pivot Tables and Pivot Charts

$ Creating Scenarios, Using Solver and Goal Seek

$ Using Random Sampling

Day 3 – Access

$ Understand Relational Databases

$ Create Tables, Queries, Forms, and Reports

$ Establish Field Properties

$ Establish Relationships with Referential Integrity

$ Filter and Sort Data

$ Import and Export Data

$ Create Parameter and Action Queries

$ Add Groupings and Graphics to Forms

$ Add Calculated Fields to Reports

$ Create Action Buttons and Macros

$ Create Pivot Tables and Pivot Charts

$ Create Sub forms and Sub reports

$ Create Switchboards

Day 4 – PowerPoint

$ Create Presentation using the AutoContent Wizard

$ Create Presentation using Designs

$ Create Presentations from Blank

$ Create Presentations from Word Outline

$ Change Slide Layouts

$ Insert and Modify Text

$ Add Graphics, Tables, and Charts

$ Using Drawing Tools and AutoShapes

$ Use Slide Masters

$ Add Transitions and Animation

$ Rehearse Timings

$ Create Custom Shows

$ Create Web Page

$ Create a Flow Chart

$ Insert Videos, Sounds, and Narration

Day 5 – Microsoft Outlook

$ Sending, Receiving, Retrieving, and Storing E-mail

$ Creating Signatures and Using Letterheads

$ Sending and Receiving Attachments

$ Creating Folders

$ Creating Appointments and Events

$ Creating Recurring Appointments and Events

$ Scheduling Meetings and Track Responses

$ Granting Permissions and Sharing Calendars

$ Granting Permissions and Sharing Folders

$ Creating and Managing Contacts

$ Creating and Managing Groups

$ Creating and Managing Tasks

$ Assigning Tasks to Others and Tracking

$ Creating and Managing Journal Entries

$ Creating and Posting Notes

$ Creating and Using Rules

On-Site Training Solutions

The Power Behind Productivity