Based on the MOUS exam itself (and certified by Microsoft), the streamlined PH MOUS Test Preparation Guide for Excel 2000 book/software package coaches users through successful completion of the MOUS certification exam--from Core to Expert skill levels. Dynamically interactive--enhanced by the unparalleled MOUS PinPoint 2000 software--it takes users step-by-step to guaranteed success.
Each chapter focuses on specific learning objectives (based on the Core and Expert MOUS objectives), discusses specific skills necessary to complete the MOUS certification exam, and walks readers through condensed step-by-step mini-tutorials for a specific skill set.
Readers then use the interactive program on the MOUS PinPoint interactive CD-ROM (included in every copy of the book) to see the material demonstrated, to complete in-text projects, and to practice for the MOUS exams. Getting Started with Excel. Edit Worksheet Contents. Modify Worksheet Structure.
Use Complex Formulas. Manage Pages and Printing. Format Worksheets. Use Functions. Use Financial Functions. Create Charts. Use Excel with the Web. Handle Multiple Worksheets. Import and Export. Manage Data and Lists. Use Analysis Tools. Work with Templates. Create Macros and Customize Excel. Collaborate with Workgroups. For those preparing for the MOUS certification exam for Excel 2000.