Word

Exploring Word

• Working in the World Environment
• Opening, Moving around, and Closing a Document
• Displaying different views of a Document
• Creating and Saving a Document
• Previewing and Printing a Document

Editing and Proofreading Documents

• Making changes to a Document
• Inserting Saved text
• Reorganizing a Document  Outline
• Finding and Replacing Text
• Correcting Spelling and Grammar Errors
• Finalizing a Document

Changing the Look of Text

• Formatting Text and Paragraphs
• Manually Changing the Look of Characters
• Manually Changing the Look of Paragraphs
• Creating and Modifying Lists

Presenting Information in Columns and Tables

• Presenting information in Columns
• Creating a Tabular List
• Presenting Information in a Table
• Formatting Table Information
• Performing Calculations in a Table
• Using a Table to Control Page Layout
• Add borders and shading to tables
• Revise tables (insert and delete rows and columns and change cell formats)
• Modify table structure (merge cells, change height, and width)

Excel

Setting Up a Worksheet

• Creating Workbooks
• Modifying Workbooks
• Modifying worksheets
• Copying Worksheets within the same Workbook
• Naming Worksheets within the Workbook

Working with Data and Data Tables

• Entering and Revising Data
• Moving Data within a Workbook
• Finding and Replacing Data
• Insert and delete selected cells
• Cut, copy, paste,  and move selected cells
• Formatting Cells
• Clear cell formats
• Work with series (AutoFill)

Performing Calculation on Data

• Naming Group of Data
• Creating Formulas and Calculation
• Summarizing Data

Formatting Worksheets

• Apply font styles (typeface, size, color, and styles)
• Apply number formats (currency, percent, dates, and commas)
• Modify row and column size
• Modify alignment of cell content
• Adjust decimal places
• Apply cell borders and shading
• Merge cells

Page Setup and Printing

• Preview and print worksheets and workbooks
• Print a selection
• Change page orientation and scaling
• Set page margins and centering
• Set print, and clear a print area
• Set up headers and footers
• Set print titles and options (gridlines, print quality, and headings for rows and columns)

PowerPoint

Creating a Presentation

• Delete slides
• Create a specified type of slide
• Create a presentation from a template or a wizard
• Navigate among different views (slide, outline, sorter, and tri-pane)
• Create a new presentation from existing slides
• Copy a slide from one presentation into another
• Insert headers and footers
• Create a blank presentation
• Create a presentation using the AutoContent Wizard
• Send a presentation via e-mail

Modifying a Presentation

• Change the order of slides using Slide Sorter view
• Find and replace text
• Change the layout for one or more slides
• Modify the Slide Master
• Modify slide sequence in the outline pane
• Apply a design template

Working with Text

• Check spelling
• Change and replace text fonts (individual slide and entire presentation)
• Enter text in tri-pane view
• Import text from Microsoft Word
• Change the text alignment
• Create a text box for entering text
• Use the Wrap text in TextBox feature
• Use the Office Clipboard
• Use the Format Painter
• Promote and Demote text in slide and outline panes

Working with Visual Elements

• Add a picture from the Clip Art Gallery
• Add and group shapes using WordArt or the Drawing Toolbar
• Apply formatting
• Add text to a graphic object using a text box
• Scale and size an object including clip art
• Create tables within PowerPoint
• Rotate and fill an object

Customizing a Presentation

• Add AutoNumber bullets
• Add speaker notes
• Add graphical bullets
• Add slide transitions
• Animate text and objects

Creating Output

• Preview presentation in black and white
• Print slides in a variety of formats
• Print audience handouts
• Print speaker notes in a specified format

Delivering a Presentation

• Start a slide show on any slide
• Use on screen navigation tools
• Print a slide as an overhead transparency
• Use the pen during a presentation

Managing Files

• Save changes to a presentation
• Save as a new presentation
• Publish a presentation to the Web
• Use the Microsoft Office Assistant
• Insert hyperlink

Access

Planning and Designing Databases

• Determine appropriate data inputs/outputs for your database
• Create table structure
• Establish table relationships

Working with Access

• Use the Microsoft Office Assistant
• Select an object using the Objects Bar
• Print database objects (tables, forms, reports, and queries)
• Navigate through records in a table, query, or form
• Create a database (using a wizard or in-design view)

Building and Modifying Tables

• Create tables by using the Table Wizard
• Set primary keys
• Modify field properties
• Use multiple data types
• Modify tables using Design View
• Use the Lookup Wizard
• Use the Input Mask Wizard

Building and Modifying Forms

• Create a form with the Form Wizard
• Use the Control Toolbox to add controls
• Modify Format Properties (font, style, font size, color, caption, etc.) of controls
• Use form sections (headers, footers, and detail)
• Use a Calculated Control on a form

Viewing and Organizing Information

• Use the Office Clipboard
• Switch between object views
• Enter records using a datasheet
• Enter records using a form
• Delete records from a table
• Find a record
• Sort records
• Apply and remove filters (filter by form and filter by selection)
• Specify criteria in a query
• Display related records in a subdatasheet
• Create a calculated field
• Create and modify a multitable select query

Defining Relationships

• Establish relationships
• Enforce referential integrity

Producing Reports

• Create a report with the Report Wizard
• Preview and print a report
• Move and resize a control
• Modify Format Properties (font, style, font size, color, caption, etc.)
• Use the Control Toolbox to add controls
• Use report sections (headers, footers, and detail)
• Use a Calculated Control in a report

Integrating with Other Applications

• Import data to a new table
• Save a table, query, or form as a Web page
• Add Hyperlinks

Using Access Tools

• Print database relationships
• Back-up and restore a database
• Compact and repair a database

Outlook

Using Outlook to Communicate

• Read mail
• Send mail
• Compose mail by entering text
• Print mail
• Address mail by entering text
• Use mail features (forward, reply, and recall)
• Use address book to address mail
• Flag mail messages
• Navigate within mail
• Find messages
• Configure basic mail print options
• Work with attachments
• Add a signature to mail
• Customize the look of mail
• Use mail templates (themes) to compose mail
• Integrate and use mail with other Outlook components
• Customize menu and task bars

Using Outlook to Manage Messages

• Create folders
• Sort mail
• Set viewing options
• Archive mail messages
• Filter a view

Using the Outlook Calendar

• Navigate within the calendar
• Schedule appointments and events
• Set reminders
• Print in calendar
• Schedule multiday events
• Configure calendar print options
• Customize the calendar view
• Schedule recurring appointments
• Customize menu and task bars
• Add and remove meeting attendees
• Plan meetings involving others
• Save a personal or team calendar as a Web page
• Book office resources directly (for example, conference rooms)
• Integrate calendar with other Outlook components

Navigating and Using Outlook Effectively

• Use Outlook Help and the Microsoft Office Assistant.
• Move items between folders
• Navigate between Outlook components
• Modify the Outlook Master Categories List
• Assign items to a category
• Sort information using categories
• Use the Office Clipboard

Using Contacts

• Create, edit, and delete contacts
• Send contact information via e-mail
• Organize contacts by category
• Manually record an activity in a journal
• Link activities to a Contact
• Sort contacts using fields

Using Tasks

• Create and update one-time tasks
• Accept and decline tasks
• Organize tasks using categories
• Assign tasks to others
• Create tasks from other Outlook components
• Change the view for tasks