- Shopping Bag ( 0 items )
From Barnes & NobleThe 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.