Book Description
* The most comprehensive guidebook available on the most popular spreadsheet program, fully updated to include all-new "X" features
* Written by the leading Excel guru known as "Mr. Spreadsheet," John Walkenbach, who has written more than thirty books and 300 articles on related topics and maintains the popular Spreadsheet Page at www.j-walk.com/ss
* The definitive reference book for beginning to advanced users, featuring expert advice and hundreds of examples, tips, techniques, shortcuts, work-arounds, and more
* Covers expanded use of XML and Web services to facilitate data reporting, analysis, importing, and exporting information
* Explores Excel programming for those who want advanced information
* CD-ROM includes all templates and worksheets used in the book, as well as sample chapters from all Wiley Office "X" related Bibles and useful third party software, including John Walkenbach's Power Utility Pak


From the Back Cover
If Excel 2003 can do it, you can do it too... Whether you’re just discovering Excel or are already a power user, there’s no better instructor than "Mr. Spreadsheet," John Walkenbach. From basic formulas, functions, and chart creation to data analysis, custom number formats, data validation, and Excel programming with VBA, this is the comprehensive resource for Excel 2003. No matter what your level of expertise, you’ll benefit from hundreds of examples, exercises, tips, techniques, and workarounds, all served with a generous helping of the master’s expert advice. Inside, you’ll find complete coverage of Excel 2003 Learn your way around cells, rows, columns, worksheets, workbooks, and ranges Discover how to create charts and diagrams, organize lists, and simplify complex tasks using Excel Develop formulas that manipulate text, look up values, and perform financial applications Analyze data using external database files and pivot tables Perform "what if" analysis, use Goal Seek and Solver, and gain proficiency with the Analysis ToolPak Use XML to facilitate data reporting, analysis, importing, and exporting Explore conditional formatting, link and consolidate worksheets, and use Excel in a workgroup Understand how Excel uses HTML in Internet applications Program Excel using VBA, develop UserForms, and create custom add-ins Bonus CD-ROM and companion Web site! Exclusive Office 2003 Super Bible eBook, with more than 500 pages of information about how Microsoft Office components work together Bonus shareware, freeware, trial, demo, and evaluation programs that work with or enhance Microsoft Office Searchable eBook version of Excel 2003 Bible An easy-to-use interface that allows you to browse and install everything on the CD


About the Author
John Walkenbach is the author of approximately three dozen spreadsheet books. Visit his Web site at http://.j-walk.com.

FROM OUR EDITORS

The Barnes & Noble Review
Whatever your level of Excel experience, John Walkenbach￯﾿ﾽs Excel 2003 Bible will make you far more productive. It￯﾿ﾽs a complete course in Excel that￯﾿ﾽll serve your needs well, whether you have upgraded to Excel 2003 or are still working with Excel 2002 or 2000.

Walkenbach may be the industry￯﾿ﾽs leading spreadsheet maven. He￯﾿ﾽs written more than 30 spreadsheet books and spent years as a consultant specializing in Excel application development, creating custom functions, debugging macros, and optimizing complex workbooks.

He also created the widely praised Power Utility Pak add-in. (Judge it for yourself. The software￯﾿ﾽs on this book￯﾿ﾽs accompanying CD-ROM, along with loads of bonus resources -- including 500 pages of additional Office 2003 content.)

Excel 2003 Bible begins with a soup-to-nuts introduction to Excel fundamentals: editing and formatting worksheet data, and so forth. Next, Walkenbach takes a far deeper look at formulas and functions. His coverage includes advanced naming techniques, manipulating text strings, counting cells, displaying using date/time serial numbers, creating frequency distributions, building conditional sums using multiple criteria, and much more. He also presents example-rich explanations of financial formulas such as PMT, RATE, NPER, and PV.

You￯﾿ﾽll find in-depth coverage of charting and graphics; and Excel data analysis -- including database connectivity, PivotTables, What-if Analysis, Goal Seeking, Solver, and the Analysis Toolpak. Next, Walkenbach turns to advanced features such as conditional formatting, data validation, linking and consolidation, and Web queries. There￯﾿ﾽs a full chapter on collaboration: everything from file reservations and sharing to mailing and routing workbooks.

Don￯﾿ﾽt miss Walkenbach￯﾿ﾽs chapter on eliminating spreadsheet errors. (According to recent research, substantive mistakes are found in at least 86 percent of spreadsheets.) Here, Walkenbach covers both obvious errors -- #DIV/0!, #N/A, et cetera -- and the fundamentals of spreadsheet auditing.

VBA programming is the most powerful way to customize Excel for your own needs or those of others. Many Excel books satisfy themselves with a chapter on recording automated macros. Not this one. It covers everything from code entry to custom functions, UserForms to controls, events to building your own add-ins. There￯﾿ﾽs a full chapter of sample code: working with ranges, efficient loops, automatically generating charts, and much more.

Excel 2003 isn￯﾿ﾽt a massive update, but some of Microsoft￯﾿ﾽs improvements are significant. For example, Excel 2003 offers far deeper support for XML. New XML toolbars and taskpanes make it easy to import, export, and refresh XML content.

Excel 2003 Bible covers all that, starting with a practical introduction to XML and its business uses. You￯﾿ﾽll learn two ways to import XML data: by using a map, and by importing to a list. You￯﾿ﾽll learn how to export XML data to a wide range of locations, as well as the issues associated with saving files to XML format.

Simply put, if it can be done with Excel 2003, this book will show you how. Bill Camarda

Bill Camarda is a consultant, writer, and web/multimedia content developer. His 15 books include Special Edition Using Word 2000 and Upgrading & Fixing Networks for Dummies, Second Edition.

FROM THE PUBLISHER

If Excel 2003 can do it, you can do it too...

Whether you’re just discovering Excel or are already a power user, there’s no better instructor than "Mr. Spreadsheet," John Walkenbach. From basic formulas, functions, and chart creation to data analysis, custom number formats, data validation, and Excel programming with VBA, this is the comprehensive resource for Excel 2003. No matter what your level of expertise, you’ll benefit from hundreds of examples, exercises, tips, techniques, and workarounds, all served with a generous helping of the master’s expert advice.

Inside, you’ll find complete coverage of Excel 2003 Learn your way around cells, rows, columns, worksheets, workbooks, and ranges Discover how to create charts and diagrams, organize lists, and simplify complex tasks using Excel Develop formulas that manipulate text, look up values, and perform financial applications Analyze data using external database files and pivot tables Perform "what if" analysis, use Goal Seek and Solver, and gain proficiency with the Analysis ToolPak Use XML to facilitate data reporting, analysis, importing, and exporting Explore conditional formatting, link and consolidate worksheets, and use Excel in a workgroup Understand how Excel uses HTML in Internet applications Program Excel using VBA, develop UserForms, and create custom add-ins

Bonus CD-ROM and companion Web site! Exclusive Office 2003 Super Bible eBook, with more than 500 pages of information about how Microsoft Office components work together Bonus shareware, freeware, trial, demo, and evaluation programs that work with or enhance Microsoft Office Searchable eBook version of Excel 2003 Bible An easy-to-use interface that allows you to browse and install everything on the CD