Create and modify tables to organize data and enhance appearance

Use styles to create consistently formatted documents and to facilitate changing paragraph and character formatting

Use existing templates to provide consistent document editing and formatting, and create custom templates

Perform Mail Merge tasks (creating form letters, envelopes, and mailing labels) using Word 2000

Open and move around in an Excel workbook to learn navigation skills necessary for creating and using Excel spreadsheets

Organize columns and rows to accommodate information and edit the contents of cells to organize the information on your worksheet

Calculate values by entering formulas into cells and specify an exact address of a cell by creating an absolute cell reference, create formulas by typing functions or building more complex formulas using the Insert Function dialog box

Format cells and worksheet elements to make the worksheet consistent and readable

Change the page setup and preview the workbook to define how the printed worksheet appears

Organize, protect, and display data, using various tools

Create linking formulas and use the IF function

Set up multiple worksheets, use information from other sources through consolidation, and copy and paste links to combine information into one worksheet

Create and modify charts to present data effectively, customize charts to enhance their appearance

Create and apply styles to format worksheets consistently and quickly, use conditional formatting, comments, and text boxes to highlight and explain data

Create, modify, save, and print a one page document using a publication design.

Create a multi-page document, starting with a blank page, adding pages and page elements.

Format text by adding tabs, indents, special characters, and automated formatting.

Insert and modify graphic elements on a page.

Add and modify rows, columns, text, and formatting in a table to display data on a page.

Create documents that use special paper.

Understand the concepts of good presentation skills (with or without a PowerPoint presentation)

Identify PowerPoint screen elements and terms to use the program efficiently

Use outlines to organize the text of your presentations

Display a consistent look throughout presentations by using colour schemes and the Slide Master

Enhance your presentations by using PowerPoint 2003 design templates and formatting tools

Modify your presentations for a more organized display of information

Polish presentations by adding WordArt and objects and inserting pictures

Produce an on-screen slide show

Import and share data from between programs to create a presentation quickly

Use charts and tables to present data graphically

Use graphics to enhance a presentation, use animation to increase the impact of text and graphics in a presentation

Use the Style Checker to ensure that a presentation is free of errors, use PowerPoint features to rehearse a slide show, and prepare it for presentation

Understand the concepts of the web page and HTML

Create a simple Web Page using HTML

Enhance a basic Web Page by changing colours and backgrounds, and adding images and tables

Add hyperlinks to a Web Page document

Explore the FrontPage 2003 Environment

Create Web-based HTML documents to develop a Web site

Format a page to make it visually appealing

Create hyperlinks to link to other files on the Internet or on a network

Place pictures in a page to increase the information conveyed to visitors

Use tables to arrange text and objects on a page

Add multimedia to your pages by inserting movies, sounds, and animations

Manage and publish your site with FrontPage tools

Import files from different locations to collect all of the necessary files in one place, define the formatting for headings and other HTML elements

Use the Navigation view to create a structure for navigation bars, enable visitors to your site to see multiple pages at once with frames

Create a form to gather information from visitors to your Web site, use advanced form options to save information in a database and create discussion groups

Use Substitution and Include components to automatically include and update information, use FrontPage to work in a group

Identify the components of a database, and work with those components

Open a table, find information stored there, and enter data

Create a table design from a template, and customize it

Enter data into tables, and ensure its accuracy by using input masks and input validation formulas

Create relationships between tables to ensure data accuracy and to deploy referential integrity

Create forms for entering data into tables, and change the design elements that have been placed on those forms

Import and export data to and from various sources, including Word and Excel

Preview and print database objects, and change the page setup options