Microsoft Office 2000

Introduction Lesson 1: Office 2000 and the Internet Advanced Microsoft Word Unit Lesson 1: Sorting and Calculating Lesson 2: Customizing Tables and Creating Charts Lesson 3: Merging Form Documents, Mailing Labels, and Envelopes Lesson 4: Formatting Columns and Sections Lesson 5: Formatting Graphics and Text Boxes Lesson 6: Working with Long Documents Lesson 7: Editing in Workgroups Lesson 8: Creating Forms Lesson 9: Customizing Features Lesson 10: Creating Indexes and Tables of Contents Advanced Microsoft Excel Unit Lesson 1: Applying Advanced Formats to Worksheets and Charts Lesson 2: Printing Workbooks Lesson 3: Using Data Lists Lesson 4: Filtering and Extracting Data Lesson 5: Working with Analysis Tools and PivotTables Lesson 6: Creating Macros Lesson 7: Importing, Exporting, and Integrating Data Lesson 8: Using Templates Lesson 9: Working with Multiple Worksheets and Workbooks Lesson 10: Creating Shared Workbooks, Data Maps, and Web Pages Lesson 11: Using Outlines, Subtotals, and Lookup Functions Lesson 12: Working with Graphics and Embedded Elements Advanced Microsoft Access Unit Lesson 1: Modifying Table Design Lesson 2: Relationships in Tables and Queries Lesson 3: Advanced Form Features Lesson 4: Analyzing Data Lesson 5: Advanced Queries Lesson 6: Advanced Report Features Lesson 7: Importing and Exporting Data Lesson 8: Creating Macros and Switchboards Lesson 9: Working with Web Features Lesson 10: Using Advanced Access Tools Advanced Microsoft PowerPoint Unit Lesson 1: Using Advanced Text Features Lesson 2: Creating Tables and Charts Lesson 3: Working with Visual and Sound Objects Lesson 4: Customizing Options Lesson 5: Importing and Exporting Information Lesson 6: Using Advanced Presentation Features Advanced Microsoft Outlook Unit Lesson 1: Customizing and Sharing Outlook Information Lesson 2: Advanced Outlook Features Appendix A: The Microsoft Office User Specialist Program