Artículos relacionados a Excel 2003 Formulas

Excel 2003 Formulas - Tapa blanda

Walkenbach, John

 
9780764540738: Excel 2003 Formulas
Tapa blanda
ISBN 10: 0764540734 ISBN 13: 9780764540738
Editorial: Hungry Minds Inc,U.S., 2003

Sinopsis

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.

"Sinopsis" puede pertenecer a otra edición de este libro.

Acerca del autor

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.

De la contraportada

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

"Sobre este título" puede pertenecer a otra edición de este libro.

Editorial
Hungry Minds Inc,U.S.
Año de publicación
2003
Idioma
Inglés
ISBN 10 
0764540734
ISBN 13 
9780764540738
Encuadernación
Tapa blanda
Número de páginas
864
Contacto del fabricante
no disponible
Persona responsable
no disponible