Office 2000: Intermediate

This online course will lead participants through all of the Microsoft Office Suite programs using easy to understand bite-sized learning modules. This course will cover intermediate topics in Word, Excel, PowerPoint and Outlook. By training in all three Office programs together, participants will gain an insight into how the Office Suite programs operate as an integrated system.

Outlook

Chapter Three: Using the Address Book Introduction to the Address Book Adding New Entries Searching the Address Book and Editing Entries Creating a Distribution List Deleting Contacts and Distribution Lists Chapter Three Review

Chapter Four: Using the Contacts List Adding a Contact Editing and Deleting Contacts Adding an E-mail Sender to the Contacts List Mapping a Contact's Address on the Internet Changing Views Using the Actions Menu Printing the Contact List Chapter Four Review

Chapter Five: Using the Calendar Scheduling an Appointment Viewing the Calendar Editing and Rescheduling Appointments Scheduling an Event Setting Reminders Copying Appointments Configuring Calendar Options Working with Recurring Appointments Printing the Calendar Color-Coding Appointments Changing Calendar Views Assigning Appointments and Events Viewing the TaskPad Viewing Calendars Side by Side Chapter Five Review

Chapter Six: Using the Task List Using the Task List Creating a Recurring and Regenerating Tasks Changing Task Views Chapter Six Review

Word

Chapter Four: Working with Page Layout  Adjusting the Margins Creating Headers and Footers Changing the Paper Orientation and Size Previewing a Document Controlling Where the Page Breaks Working with Section Breaks and Multiple Page Formats Creating and Working with Envelopes Arranging Text in Multiple Columns Chapter Four Review

Chapter Five: Working with Tables Introduction to Tables Creating a Table Working with a Table Adjusting Column Width Adjusting Row Height Inserting and Deleting Rows and Columns Adding Borders to a Table Adding Shading and Patterns Using AutoFormat Totaling Numbers in a Table Sorting Information in a Table Using the Draw Table and Eraser Buttons Creating Table Formulas Merging and Splitting Cells Orienting, Aligning, and Spacing Cell Contents Working with Tables that Span Multiple Pages Resizing, Moving, and Positioning a Table Chapter Five Review

Chapter Six: Working with Templates and Styles Creating and Using a Document Template Creating and Applying Paragraph Styles Creating and Applying a Character Style Modifying a Style Displaying Styles in a Document Attaching a Different Template to a Document Copying Styles Between Documents and Templates Chapter Six Review

Excel

Chapter Three: Formatting a Worksheet Formatting Fonts with the Formatting Toolbar Formatting Values Adjusting Row Height and Column Width Changing Cell Alignment Adding Borders Applying Colors and Patterns Using the Format Painter Using AutoFormat Creating a Custom Number Format Creating, Applying, and Modifying a Style Formatting Cells with Conditional Formatting Merging Cells, Rotating Text, and using AutoFit Chapter Three Review

Chapter Four: Creating and Working with Charts Creating a Chart Moving and Resizing a Chart Formatting and Editing Objects in a Chart Changing a Chart's Source Data Changing a Chart Type and Working with Pie Charts Adding Titles, Gridlines, and a Data Table Formatting a Data Series and Chart Axis Annotating a Chart Working with 3-D Charts Selecting and Saving a Custom Chart Using Fill Effects Mapping Data Modifying a Map Chapter Four Review

Chapter Five: Managing Your Workbooks Switching Between Sheets in a Workbook Inserting and Deleting Worksheets Renaming and Moving Worksheets Working with Several Workbooks and Windows Splitting and Freezing a Window Referencing External Data Creating Headers, Footers, and Page Numbers Specifying a Print Area and Controlling Page Breaks Adjusting Page Margins and Orientation Adding Print Titles and Gridlines Changing the Paper Size and Print Scale Protecting a Worksheet Hiding Columns, Rows and Sheets Viewing a Worksheet and Saving a Custom View Working with Templates Consolidating Worksheets Chapter Five Review

Chapter Six: More Functions and Formulas Formulas with Several Operators and Cell Ranges Using the Formula Palette to Enter and Edit Formulas Creating and Using Range Names Selecting Nonadjacent Ranges and Using AutoCalculate Using the IF Function to Create Conditional Formulas Using the PMT Function Displaying and Printing Formulas Fixing Errors in Your Formulas Mathematical Functions (Reference) Financial Functions (Reference) Date and Time Functions (Reference) Statistical Functions (Reference) Database Functions (Reference) Chapter Six Review