miércoles, 27 de febrero de 2008

Formulas and Functions with Microsoft Office Excel 2007

Most Microsoft Excel users learn only a small percentage of the program's features. They know they could get more out of Excel if they could just get a leg up on building formulas and using functions. Unfortunately, this side of Excel appears complex and intimidating to the uninitiated -- shrouded in the mysteries of mathematics, finance, and impenetrable spreadsheet jargon.

Sound familiar? If you're a businessperson who needs to use Excel as an everyday part of your job, then you've come to the right book. Formulas and Functions with Microsoft Office Excel 2007 demystifies worksheet formulas and presents the most useful Excel functions in an accessible, jargon-free way. This book not only takes you through Excel's intermediate and advanced formula-building features, it also tells you why these features are useful to you and shows you how to use them in everyday situations. Throughout the book you'll find no-nonsense, step-by-step tutorials and lots of practical examples aimed directly at business users.

Edición: Que (2007)
Idioma: Inglés
Formato: PDF

Contenido:

  1. Getting the Most Out of Ranges
  2. Using Range Names
  3. Building Basic Formulas
  4. Creating Advanced Formulas
  5. Troubleshooting Formulas
  6. Understanding Functions
  7. Working with Text Functions
  8. Working with Logical and Information Functions
  9. Working with Lookup Functions
  10. Working with Date and Time Functions
  11. Working with Math Functions
  12. Working with Statistical Functions
  13. Analyzing Data with Tables
  14. Analyzing Data with PivotTables
  15. Using Excel’s Business-Modeling Tools
  16. Using Regression to Track Trends and Make Forecasts
  17. Solving Complex Problems with Solver
  18. Building Loan Formulas
  19. Building Investment Formulas
  20. Building Discount Formulas

Descarga/Download

No hay comentarios: