Excel 2002: Programmer's Reference: Complete Reference

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 expertExtend Excel's capabilities by automating repetitive tasks, creating macros, writing subroutines and functions, and working with variablesCollaborate with others over an intranet or the InternetMaster new features like multi-use task panes, improved PivotTables, enhanced crash recovery means, and moreReport and analyze numbers using multiple financial functions Design and format professional presentations with visual treatments like charts, clip art, 3-D shapes, and text enhancementCreate and publish HTML worksheets, write UDFs, and utilize Visual BasicCustomize Excel to best support your needs