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 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 Excelto best support your needs
Table of ContentsPart 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.
Part II: Analyzing Data.
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.
Part III: The Outside World.
Chapter 15: Acquiring Data.
Chapter 16: Sharing Workbooks.
Chapter 17: Using Web Technology.
Part IV: Extending Excel's Reach with VBA.
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.