Excel 2000 Advanced

NEW FEATURES IN EXCEL 2000:
Comprehensive coverage of Advanced Excel 2000 Topics
Basedupon feedback from instructors like you, the Select Advanced Excel 2000 module covers a variety of topics beyond those required for MOUS certification. As you review the Table of Contents, you will be pleased with the comprehensive coverage of Excel 2000 in this book.

Useful Appendices:
The Select Advanced Excel 2000 module includes two useful appendices:
Appendix A covers basic concepts in Excel 2000, providing a brief review of navigating Excel worksheets and workbooks, entering text, numbers, and formulas in Excel, using functions in formulas, and getting help with the Office Assistant.
Appendix B covers Excel's financial functions, and is perfect for students who want to learn how to use the power of Excel for calculating the loan payment for any loan scenario.

Contents

• Introduction
• Designing complex workbooks
  Creating a three-Dimensional workspace
  Completing a three-Dimensional workspace using logical and lookup functions
  Sorting, grouping, and filtering sales data
  Formatting, displaying, printing, and publishing workbooks
• Analysing data with excel
  Creating interactive PivotTable reports
  Using the analysis toolpak to analyse sales transactions
  Forecasting values with what-if analysis : Using data tables, scenarios, goal seek, and solver
• Integrating data, collaborating with others, and customizing Excel 2000
  Using excel's auditing and collaboration features
  Using visual basic for applications (VBA) to customize and automate Excel
  Sharing Excel 2000 data with other Microsoft Office 2000 applications
• Appendices
• Excel 2000 reference guide
• Glossary
• Index