Microsoft Office XP: Advanced Course

Sandra Cable is the author and co-author of numerous books with Course Technology. Her books include both introductory and advanced levels of Microsoft Excel and Access. The author holds a doctorate in Education from Texas A&M University - Commerce. In addition to working full-time for an international corporation in Dallas, TX, she volunteers to teach at seminars and in classrooms promoting simple approaches to using computer applications. Connie Morrison has over 30 years of combined experience in education and educational publishing. She has taught students at all grade levels from elementary through college, and she has trained employees in industry. Connie currently works as an education consultant for Encore Training, Inc., providing staff development and training for educators. Custom Editorial Productions, Inc., located in Cincinatti, Ohio is a full-service writing, editing, and book production agancy that has been partnering with textbook publishers and professional societies since 1982.

Introduction Lesson 1: Microsoft Office XP Basics and the Internet Advanced Microsoft Word Unit Lesson 9: Sorting and Calculating Lesson 10: Customizing Tables and Creating Charts Lesson 11: Merging Form Documents, Mailing Labels, and Envelopes Lesson 12: Formatting Columns and Sections Lesson 13: Formatting Graphics and Text Boxes Lesson 14: Working with Long Documents Lesson 15: Editing in Workgroups Lesson 16: Creating Forms and Working with Web Documents Lesson 17: Customizing Features Lesson 18: Creating Indexes, Tables of Contents, Figures, and Authorities Advanced Microsoft Excel Unit Lesson 9: Applying Advanced Formats to Worksheets and Charts Lesson 10: Printing Workbooks Lesson 11: Using Lists Lesson 12: Filtering and Extracting Data Lesson 13: Working with Analysis Tools and Pivot Tables Lesson 14: Creating Macros and Menus Lesson 15: Importing and Exporting Lesson 16: Using Templates and Protection Lesson 17: Working with Multiple Worksheets and Workbooks Lesson 18: Working with Shared Workbooks Lesson 19: Using Outlines, Subtotals, and Grouping Lesson 20: Using Advanced Excel Tools Advanced Microsoft Access Unit Lesson 7: Modifying Table Design Lesson 8: Relationships in Tables and Queries Lesson 9: Advanced Form Features Lesson 10: Analyzing Data Lesson 11: Advanced Queries and Filters Lesson 12: Advanced Report Features Lesson 13: Importing and Exporting Data Lesson 14: Creating Macros and Switchboards Lesson 15: Working with Web Features Lesson 16: Using Management Tools Lesson 17: Utilizing Advanced Management Tools Advanced Microsoft PowerPoint Unit Lesson 5: Using Advanced Text Features Lesson 6: Creating Tables and Charts Lesson 7: Working with Visual and Sound Objects Lesson 8: Customizing Options Lesson 9: Importing and Exporting Information Lesson 10: Using Advanced Presentation Features Advanced Microsoft Outlook Unit Lesson 4: Customizing and Sharing Outlook Information Lesson 5: Advanced Outlook Features Capstone Simulation: The Alexander Pharmaceutical Company Appendices A: The Microsoft Office User Specialist Program B: Windows Basics C: Computer Concepts D: Using Microsoft Office XP Speech Recognition