Synopses & Reviews
With a completion time of 75+ hours, this text has lessons which contain objectives, step-by-step instructions, screen illustrations, tips, notes, Internet coverage, chapter summaries, end-of-chapter exercises, projects, and SCANS correlations. Integration of each software application is covered throughout the book. With the use of both the Introductory Course and this text, Expert certification for Microsoft Office is achieved.
Synopsis
This comprehensive 75+ hour text is designed for an advanced course on the four main Microsoft Office 2000 applications plus Outlook. The coverage of Word and Excel provide Proficient level certification for the Microsoft Office User Specialist (MOUS) certification program. This text offers a complete MOUS solution for Microsoft Office 2000 certification when used in conjunction with our introductory Office 2000 text.
About the Author
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.
Table of Contents
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