|
Excel 2002 Expert MOUS
This book is made up of five parts, each dealing with a specific topic: managing data (named ranges, import/export, data lists, publishing Web pages, using XML with Excel etc), tools for analysing data (including auditing tools, pivot tables and charts), templates, working in a team, the configuration of the environment and basic principles for working
with macros. Each chapter is independent of the others, so that you can choose what to study, and in what order. At the end of the book, you will find the official list of topics tested in the MOUS Excel 2002 Expert exam. The number of the corresponding lesson and exercise is given next to each topic in the list.
CONTENTS:
INTRODUCTION
MANAGING DATA
Named ranges
Importing/Exporting
Formatting
Outlines
Lists of data
ANALYSIS TOOLS
Auditing
Solver
Pivot table
Pivot chart
TEMPLATES, WORKBOOKS AND WORKGROUPS
Templates
Workbooks
Tracking changes
Comments
Protection
PRINTING AND CONFIGURATION
Printing
Toolbars
MACROS
Macros
SUMMARY EXERCISES
TABLE OF OBJECTIVES
INDEX
|
