Excel 2003 Bible [Paperback]

John Walkenbach (Author)

Book Description

Series: Bible | Publication Date: September 19, 2003

• 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.

Editorial Reviews

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.

Product Details

• Paperback: 936 pages
• Publisher: Wiley (September 19, 2003)
• Language: English
• ISBN-10: 0764539671
• ISBN-13: 978-0764539671
• Product Dimensions: 9.4 x 7.2 x 2 inches
• Shipping Weight: 3 pounds (View shipping rates and policies)
• Average Customer Review: 4.3 out of 5 stars  See all reviews (55 customer reviews)
• Amazon Best Sellers Rank: #49,309 in Books (See Top 100 in Books)

More About the Author

John Walkenbach, a.k.a. Mr. Spreadsheet, is arguably the foremost authority on Excel. His fifty-plus books include Excel 2010 Power Programming with VBA, Excel 2010 Formulas, and the bestselling Excel 2010 Bible, all published by Wiley. He has also written hundreds of articles and created the award-winning Power Utility Pak.

Customer Reviews

Most Helpful Customer Reviews

165 of 174 people found the following review helpful:

5.0 out of 5 stars Exceptional Guide for Advanced and Simple Applications, April 10, 2004

By 

Donald Mitchell "Jesus Loves You!" (Thanks for Providing My Reviews over 109,000 Helpful Votes Globally) - See all my reviews
(VINE VOICE)    (HALL OF FAME REVIEWER)    (TOP 100 REVIEWER)   

This review is from: Excel 2003 Bible (Paperback)

I usually avoid books about Microsoft software because I can usually muddle through and figure out what I want to do. If in doubt, I seek out a twelve-year-old who knows the answers. But this week I had a desire to create a unique chart for a client, and decided to see if Excel would help me make the chart. I had the good fortune to run across Excel 2003 Bible at the library, and took it home to skim. Within 45 minutes I had all the answers to my questions, and found a way to create a better chart than I had originally planned to make. That was well worth my time. I'm sure that I would never have found the alternatives on my own that the book pointed me to.

Intrigued by the help I got, I went back and read the simple sections as well. I was impressed by how thorough all of the material is. You are given many different ways to accomplish the same task, along with the pros and cons of why to go one way versus another. I also appreciated the many graphics in the book to show what the screens look like.

The book is also backed up with a CD to run simulations and a web site where you can get more help.

If you think you may ever want to do advanced applications of Excel, I strongly encourage you to read this book. I particularly liked the charting and analysis sections.

As I finished this book, I realized that I usually employ Excel to get tasks done faster . . . and hadn't given much thought to how to complete them better. I suspect that much data could be made more usable and valuable for me and others if I think about how to employ all of Excel's tools in advance.

129 of 137 people found the following review helpful:

2.0 out of 5 stars Not up to date, March 18, 2005

By 

JoshInMillValley "Josh" (Mill Valley, California) - See all my reviews

Amazon Verified Purchase

This review is from: Excel 2003 Bible (Paperback)

John is a great writer. I have a number of his books in my library.

Unfortunately, he's not keeping up with the product. The primary changes in Excel 2003 (xml, SharePoint integration, InfoPath, etc) are essentially missing from his Book.

Its like he took the Excel 2000 version of his Bible pretty much just changed the cover.

I returned my copy.

27 of 27 people found the following review helpful:

5.0 out of 5 stars Top Quality Material, November 24, 2003

By 

Jeremy Conkling (Anchorage, AK United States) - See all my reviews

This review is from: Excel 2003 Bible (Paperback)

Purchased the Excel 2003 Bible to brush up on my spreadsheet skills. It covers everything from the basics to advanced in an easy to read format which is easy to understand. Also comes with an eBook on CD that I have used more than the paperback. Quick information at the click of the mouse. Superb.