Overview
- 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
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Synopsis
- 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
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Editorials
From Barnes & Noble
The Barnes & Noble ReviewWhatever 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.