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
Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.
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.
Everything you need to know about
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
Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.
Da: World of Books (was SecondSale), Montgomery, IL, U.S.A.
Paperback. Condizione: Very Good. This book covers 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, and 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. The CD-ROM includes trial version of the author's award-winning Power Utility Pak 5, and more than 90 sample workbooks illustrating key formula concepts. Codice articolo 00085343373
Quantità: 1 disponibili
Da: World of Books (was SecondSale), Montgomery, IL, U.S.A.
Paperback. Condizione: Good. This book covers 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, and 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. The CD-ROM includes trial version of the author's award-winning Power Utility Pak 5, and more than 90 sample workbooks illustrating key formula concepts. Codice articolo 00086731329
Quantità: 5 disponibili
Da: Greenworld Books, Arlington, TX, U.S.A.
Condizione: very_good. Fast Free Shipping â" Very Good condition book with a firm cover and clean pages. Shows normal use and some light wear or limited notes markings. A solid, nice copy to enjoy. Codice articolo GWV.0764540734.VG
Quantità: 1 disponibili
Da: BooksRun, Philadelphia, PA, U.S.A.
Paperback. Condizione: Very Good. It's a well-cared-for item that has seen limited use. The item may show minor signs of wear. All the text is legible, with all pages included. It may have slight markings and/or highlighting. Codice articolo 0764540734-8-1
Quantità: 1 disponibili
Da: ThriftBooks-Dallas, Dallas, TX, U.S.A.
Paperback. Condizione: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less. Codice articolo G0764540734I4N00
Quantità: 1 disponibili
Da: Duru Media, Tallahassee, FL, U.S.A.
paperback. Condizione: Very Good. Codice articolo 01KT9MQN2ZCF7AJ
Quantità: 1 disponibili
Da: Book Gurus, Tallahassee, FL, U.S.A.
paperback. Condizione: Good. Codice articolo 01KX3T6HDGQFHD9
Quantità: 1 disponibili
Da: Better World Books: West, Reno, NV, U.S.A.
Condizione: Good. Pap/Cdr. Former library copy. Pages intact with minimal writing/highlighting. The binding may be loose and creased. Dust jackets/supplements are not included. Includes library markings. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good. Codice articolo GRP9909943
Quantità: 1 disponibili
Da: Better World Books, Mishawaka, IN, U.S.A.
Condizione: Good. Pap/Cdr. Pages intact with minimal writing/highlighting. The binding may be loose and creased. Dust jackets/supplements are not included. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good. Codice articolo GRP76407316
Quantità: 1 disponibili
Da: Wonder Book, Frederick, MD, U.S.A.
Condizione: 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. Codice articolo X05H-01779
Quantità: 1 disponibili