Need a MOUS (Microsoft Office User Specialist) test preparation book AND software package?… MOUS Essentials were created specifically to meet the guidelines established by Microsoft for the MOUS Program. The MOUS Essentials for Office 2000 is a revision based on the Essentials series, written by the same authors as the Essentials books and with the same pedagogy. A single text covers both core and expert (where applicable). The MOUS Essentials texts also include computer-based training and assessment with the MOUS PinPoint CD-ROM, included in every text.	MOUS ESSENTIALS: EXCEL 2000 0-13-019104-3 Marianne Fox/ Lawrence C. Metzelaar Brief Overview Project 1: Getting Started With Excel 2000. Project 2: Modifying a Worksheet. Project 3: Improving Worksheet Appearance. Project 4: Entering Formulas. Project 5: Working With Functions. Project 6: Creating and Modifying Charts. Project 7: Developing a Multiple-Sheet Workbook. Project 8: Working With Custom Formats, Auto Formats, Templates and Styles. Project 9: Creating Special Effects in a Worksheet. Project 10. Sorting, Filtering and Editing Lists Project 11. Documenting and Protecting Worksheets and Workbooks Project 12. Guiding Cell Entry With Data Validation. Project 13. Creating PivotTable and PivotChart Reports. Project 14. Creating Consolidated Data, Outlines, Views, and Reports. Project 15. Automating Tasks With Macros. Project 16. Using Goal Seek, Scenarios, Solver and Auditing Tools. Project 17. Using Collaborative Tools and Creating HyperLinks. Project 18. Integrating Applications. SUPPLEMENTS Companion Website Instructor's Resource CD (0-13-019441-7)
KEY FEATURES and BENEFITS Microsoft Certified. All MOUS Essentials are certified by Microsoft as approved courseware for the MOUS Program. This provides students with the software skills necessary to help them compete in today’s job market. A unique Student Test Preparation Guide provides information covering registration, how the tests work, what is covered in the tests and the levels of certification. Exam Notes and Inside Stuff sidebars provide students with extra tips and tricks on preparing for and taking the MOUS exams. Each Project opens with Required Activities for both levels of the exam objectives. These activities are indicated throughout the Projects by icons distinguishing core vs. expert objectives. MOUS PINPOINT SOFTWARE provides a computer-based learning and assessment tool for students to complete the in-text project and practice for the MOUS exams. MOUS PinPoint includes Project Review Tests with "Show Me" Training for each Microsoft MOUS Exam Skill Set covered within the Project. In addition, each MOUS PinPoint has a capstone practice test that mirrors the actual MOUS examination. Instructor’s resources, including supplements and additional exercises, will be available on the Web site.
OTHER TITLES in the MOUS 2000 SERIES MOUS ESSENTIALS 0-13-019106-X WORD 2000 by Keith Mulberry Brief Overview Getting Started with Word 2000. Working with a Document. Working with Text. Editing Documents. Formatting Documents. Formatting Documents with Multiple Sections. Creating and Formatting Tables. Using Additional Table Options. Inserting and Formatting Graphics. Using Additional Graphics Options. Integrating Information. Working with Documents. Working with Columns. Working with Styles and Templates. Automating Your Work. Using Mail Merge. Creating Supplemental Document Components. Managing Files and Customizing Word. Collaborating on Documents. Creating Forms. Creating Web Documents. MOUS ESSENTIALS 0-13-019103-5 ACCESS 2000 By Robert Ferrett, Sally Preston, John Preston Brief Overview Working with Access. Creating a Database. Entering and Editing Data. Querying Your Database. Creating and Using Forms. Creating and Printing Reports. Integrating Access with Other Sources of Data and the Internet. Making Data Entry Easier and More Accurate. Managing Data Using Smaller, Related Tables. Adding Useful Features to Your Forms. Special Purpose Reports and Advanced Report Features. Using Access Macros. Managing Your Databases. Using Access on the Web and Linking to Other Documents. Designing a Complex Database. Making the Input Form More User-Friendly. Managing Changing Data. Using Access Tools. Analyzing and Reporting Data. Filtering Data in a Linked table Using Parameters and Form Filters. Sharing a Database with Others. MOUS ESSENTIALS 0-13-019105-1 POWERPOINT 2000 by Linda Bird Brief Overview Getting Started with PowerPoint. Creating Presentations. Modifying Presentations. Formatting Text and Bullets. Creating Output. Changing a Presentation’s Overall Appearance. Working with Charts. Working with Electronic Slide Shows. Refining Your Presentation. Using Multimedia and Graphics. Using Drawn Objects. Sharing Information with Other Programs. Creating Interactive Slide Shows. Using PowerPoint’s Web and Collaborations Features. Customizing PowerPoint for Your Needs.