Excel 2003 Formulas
Select Format
Select Condition 
Book Overview
Everything you need to know about * Mastering operators, error values, naming techniques, and absolute versus relative references * Debugging formulas and using the auditing tools * Importing and exporting XML files and mapping the data to specific cells * Using Excel 2003's rights management feature * Working magic with array formulas * Developing custom formulas to produce the results you need Here's the formula for Excel excellence Formulas are the lifeblood of spreadsheets, and no one can bring a spreadsheet to life like John Walkenbach. In this detailed reference guide, he delves deeply into understanding, creating, and applying formulas in everything from basic workbooks to charts, pivot tables, and more advanced Excel applications. He examines financial formulas, explores the many options made possible with array formulas, teaches you to develop custom worksheet functions with VBA, and much more. Once again, "Mr. Spreadsheet" will astound you with the breadth and depth of Excel's capacity. CD-ROM Includes * Trial version of the author's award-winning Power Utility Pak 5 * More than 90 sample workbooks illustrating key formula concepts
Format:Paperback
Language:English
ISBN:0764540734
ISBN13:9780764540738
Release Date:October 2003
Publisher:Wiley Publishing
Length:826 Pages
Weight:2.85 lbs.
Dimensions:1.9" x 7.4" x 9.2"
Customer Reviews
5 ratings
Excellent book, but there's a better choice
Published by Thriftbooks.com User , 17 years ago
I've found that some reviewers say that this book doesn't give enough theory or examples are trivial or you can find that all in the Help. However, I believe that only advanced Excel users might be dissatiafied with "Excel 2003 Formulas". While that's true that it's not overloaded with the advanced theory (which is what professionals look for), it does give the beginners or intermidiate users all they need to know about formulas, and the tips and tricks offered by Walkenbach really help to discover the world of Excel. However, on the other hand if you're interested not only in formulas, but you're also planning to study the Excel as a whole then I would recommend to get the "Excel 2003 Bible" of this author. The reason is that the "Formulas..." for the most part just copy the "Bible..." which describes usage of the whole Excel and has a lot more information than the "Formulas".
Walkenbach is the best
Published by Thriftbooks.com User , 18 years ago
Just an echo of previous reviewers. This is my third or fourth Walkenback Excel book - and they are all excellent. He provides more not-obvious tips and tricks than any other author - that truly impact the efficiency and usability of your spreadsheets. Great reference.
Excel 2003 Formulas
Published by Thriftbooks.com User , 18 years ago
I have enjoyed Excel 2003 Formulas, as I have been able to incorporate numerous examples into my spreadsheets at work, where I improved the quality of my work and streamlined my processes. It was well worth the investment for the text as it as paid for itself in the first week. The examples are straightforward and easy to understand. The chapters are well-organized.
It's the BOM!
Published by Thriftbooks.com User , 19 years ago
I use Excel non-stop for Bill Of Material (BOM) and pricing/cost analysis for manufacturing. This is by far the best publication available for the number crunching workhorse. I just find it peculiar that John decided to introduce "financial formulas" in Chapter 11. But seriously, it's loaded with boo-koos of real word examples that have made my work much more automated and easier.
Walkenbach and Excel...a great combination!
Published by Thriftbooks.com User , 21 years ago
Excel 2003 Formulas provides some amazing ways to really master Excel. Walkenbach's formulas are the best! He covers operators, naming techniques, debugging, auditing, developing custom VBA functions, array formulas, imported 1-2-3 files, etc. Oh, and the CD that comes with this one is load too!
Copyright © 2025 Thriftbooks.com
Terms of Use | Privacy Policy | Do Not Sell/Share My Personal Information | Cookie Policy | Cookie Preferences | Accessibility Statement
ThriftBooks ® and the ThriftBooks ® logo are registered trademarks of Thrift Books Global, LLC
ThriftBooks ® and the ThriftBooks ® logo are registered trademarks of Thrift Books Global, LLC
