Excel 2002

The Most Authoritative Volume Available on Excel 2002 Take the world's most popular spreadsheet program to new heights with this comprehensive resource. From tips on using basic features to easy-to-understand explanations of advanced functions, this book provides everything you need to become an Excel expert. Input or import data, then make analyses for financial, statistical, engineering, or other professional functions. In addition to in-depth coverage of the fully revised and updated application, Excel 2002: The Complete Reference also serves as a study guide for the MOUS certification exam. Let this great resource help you get the most from Excel 2002.

• Structure and format worksheets like an expert
• Extend Excel's capabilities by automating repetitive tasks, creating macros, writing subroutines and functions, and working with variables
• Collaborate with others over an intranet or on the Internet
• Master new features like multi-use task panes, improved PivotTables, enhanced crash recovery means, and more
• Report and analyze numbers using multiple financial functions
• Design and format professional presentations with visual treatments like charts, clip art, 3-D shapes, and text enhancement
• Create and publish HTML worksheets, write UDFs, and utilize Visual Basic
• Customize Excel to best support your needs.

Part I: Getting Started.

• Chapter 1: Excel Basics.
• Chapter 2: Entering Information.
• Chapter 3: Working with Files.
• Chapter 4: Manipulating Data.
• Chapter 5: Structuring Worksheets.
• Chapter 6: Printing.

• Chapter 7: Managing Data.
• Chapter 8: Using Formulas.
• Chapter 9: Worksheet Functions.
• Chapter 10: Advanced Work with Formulas.
• Chapter 11: Charting Data.
• Chapter 12: Drawing Objects.
• Chapter 13: Pivot Tables.
• Chapter 14: Global Seek and Solver: Reaching Solutions with Brute Force.

• Chapter 15: Acquiring Data.
• Chapter 16: Sharing Workbooks.
• Chapter 17: Using Web Technology.

• Chapter 18: Repeating Tasks Automatically.
• Chapter 19: The Visual Basic Editor and the Excel Object Model.
• Chapter 20: Writing Subroutines.
• Chapter 21: Writing Functions.
• Chapter 22: Controlling Input with User Forms.
• Chapter 23: Techniques for Handling VBA Arrays.
• Chapter 24: Using Data Access Objects.