Excel 2002 Bible
John Walkenbach, Brian Underdahl · John Wiley & Sons, Inc. eBooks · 2001
From the Publisher: If Excel 2002 can do it, you can do it too You, too, can excel! All you need is the expert advice of leading Excel authority John Walkenbach, a.k.a. Mr. Spreadsheet and Brian Underdahl. Whenever you get stuck or want to use a new Excel tool or feature whether it's using the new Smart Tags feature, setting up a simple function, or doing advanced stuff like ToolPak data analysis, putting XML data on the Web, or VBA programming just open this comprehensive reference and discover everything you need to master Excel 2002. Inside, you'll find complete coverage of Excel 2002 *Illustrate data with charts, drawings, maps, and other graphics *Simplify repetitive tasks using new tools that make formulas and functions a snap *Consolidate and juggle multiple worksheets in a single workbook *Analyze data with PivotTables, what-if scenarios, Goal Seeking and Solver, or the Analysis ToolPak *Import data from databases, other Microsoft Office XP applications, and the Web *Automate Excel using templates, VBA macros, and custom worksheet functions *Share documents across a corporate intranet or the Internet *Save worksheets as HTML or XML documents and publish them on your Web page