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
"synopsis" may belong to another edition of this title.
John Walkenbach, principal of JWalk and Associates Inc., is a leading authority on spreadsheet software and creator of the award-winning Power Utility Pak. He has written more than 30 spreadsheet books and over 300 articles and reviews for publications including PC World, InfoWorld, and Windows, and maintains the popular Spreadsheet Page at www.j-walk.com/ss.
"About this title" may belong to another edition of this title.
Shipping:
FREE
Within U.S.A.
Seller: SecondSale, Montgomery, IL, U.S.A.
Condition: Very Good. Item in very good condition! Textbooks may not include supplemental items i.e. CDs, access codes etc. Seller Inventory # 00078378156
Quantity: 3 available
Seller: SecondSale, Montgomery, IL, U.S.A.
Condition: Good. Item in good condition. Textbooks may not include supplemental items i.e. CDs, access codes etc. Seller Inventory # 00082356887
Quantity: 2 available
Seller: Wonder Book, Frederick, MD, U.S.A.
Condition: Good. Good condition. With CD! 2003 edition. A copy that has been read but remains intact. May contain markings such as bookplates, stamps, limited notes and highlighting, or a few light stains. Seller Inventory # X05H-01779
Quantity: 1 available
Seller: Better World Books, Mishawaka, IN, U.S.A.
Condition: Good. Pap/Cdr. Former library book; may include library markings. Used book that is in clean, average condition without any missing pages. Seller Inventory # GRP9909943
Quantity: 1 available
Seller: Better World Books, Mishawaka, IN, U.S.A.
Condition: Good. Pap/Cdr. Used book that is in clean, average condition without any missing pages. Seller Inventory # GRP76407316
Quantity: 2 available
Seller: ThriftBooks-Dallas, Dallas, TX, U.S.A.
Paperback. Condition: As New. No Jacket. Pages are clean and are not marred by notes or folds of any kind. ~ ThriftBooks: Read More, Spend Less 2.85. Seller Inventory # G0764540734I2N00
Quantity: 1 available
Seller: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.
Paperback. Condition: As New. No Jacket. Pages are clean and are not marred by notes or folds of any kind. ~ ThriftBooks: Read More, Spend Less 2.85. Seller Inventory # G0764540734I2N00
Quantity: 1 available
Seller: WorldofBooks, Goring-By-Sea, WS, United Kingdom
Paperback. Condition: Good. The book has been read but remains in clean condition. All pages are intact and the cover is intact. Some minor wear to the spine. Seller Inventory # GOR001521290
Quantity: 1 available
Seller: WorldofBooks, Goring-By-Sea, WS, United Kingdom
Paperback. Condition: Very Good. The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged. Seller Inventory # GOR001638652
Quantity: 2 available
Seller: Better World Books Ltd, Dunfermline, United Kingdom
Condition: Good. Pap/Cdr. Ships from the UK. Former library book; may include library markings. Used book that is in clean, average condition without any missing pages. Seller Inventory # GRP9909943
Quantity: 1 available