Prentice Hall Test Prep Series: Microsoft Excel 2002 MOUS Expert Level

by Fox, Marianne; Metzelaar, Lawrence C.

• ISBN13: 9780130497802
• ISBN10: 0130497800
• Edition: 1st
• Format: Paperback
• Copyright: 2002-01-01
• Publisher: Pearson College Div

Summary

This book focuses on preparing the user to pass the associated Microsoft Office User Specialist (MOUS) certification exam. Its step-by-step tutorials show how to complete the required procedures in a clear, concise, and direct manner. The tutorials are organized to match the order of the skill sets and skills being measured as published on Microsoft's MOUS website. Skill sets include working with cells and cell data, formatting and printing worksheets, modifying workbooks, creating and revising formulas, creating and modifying graphics, importing and exporting data, managing workbooks, formatting numbers, working with ranges, customizing excel, auditing worksheets, summarizing data, analyzing data, and workgroup collaboration. For MOUS certification.

Table of Contents

Introduction	xxiii
About Excel 2002	1	(12)
Core Skill Set 1 Working with Cells and Cell Data	13	(56)
Core Skill Set 2 Managing Workbooks	69	(24)
Core Skill Set 3 Formatting and Printing Worksheets	93	(44)
Core Skill Set 4 Modifying Workbooks	137	(18)
Core Skill Set 5 Creating and Revising Formulas	155	(44)
Core Skill Set 6 Creating and Modifying Graphics	199	(54)
Core Skill Set 7 Workgroup Collaboration	253	(20)
Expert Skill Set 1 Importing and Exporting Data	273	(28)
Expert Skill Set 2 Managing Workbooks	301	(18)
Expert Skill Set 3 Formatting Numbers	319	(14)
Expert Skill Set 4 Working with Ranges	333	(22)
Expert Skill Set 5 Customizing Excel	355	(34)
Expert Skill Set 6 Auditing Worksheets	389	(20)
Expert Skill Set 7 Summarizing Data	409	(56)
Expert Skill Set 8 Analyzing Data	465	(34)
Expert Skill Set 9 Workgroup Collaboration	499	(34)
Glossary	533	(6)
Index	539