• Author:
  • Abdulezer, Loren
  • Walkenbach, John
• Subject:
  Business Applications
• Published by:
  John Wiley & Sons Inc (US)
• Published:
  06/03/2006
• Price:
  $52.99
• <  Buy this book  >

• Written especially for advanced beginners and intermediate users, this book offers quick fixes for anyone bedeviled by faulty formulas, failed formatting, printer purgatory, and other perplexing Excel problems
• Offers three types of fixes: Escape in Under 30 Seconds, Escape in Under Two Minutes, and More Elaborate Escapes-over 400 solutions in all
• Topics covered include formula fixes, formatting fixes, data and layout fixes for Excel charts, PivotTable fixes, managing complexity in very large spreadsheets, fixing broken procedure functions, and more
• Includes preventive measures and best practices that teach users how to avoid problems in the future

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Loren Abdulezer is CEO and President of Evolving Technologies Corporation, a New York–based technology consulting firm. He is an experienced IT professional serving major Fortune 500 companies, including Citigroup, JP Morgan Chase, IBM, Procter & Gamble Pharmaceuticals, and Pfizer. He has consulted on strategic technology and Internet product design, data analysis, mathematical modeling, visual modeling, and simulation, MIS/Web reporting, Java and object-oriented programming, Internet security, and business continuity planning.
Loren is a world acknowledged expert on spreadsheets, visual modeling, and dashboard technology. He is the author of Excel Best Practices for Business (www.ExcelBestPractices.com), also published by Wiley, and is a Crystal Xcelsius Consulting Partner for Business Objects S.A. (www.XcelsiusBestPractices.com). You can find out more information about Loren and the book Escape From Excel Hell at www.EscapeFromExcelHell.com.

Preface.

Acknowledgments.

Introduction.

Part I: Escape in Under 30 Seconds.

Chapter 1: Spreadsheet Basics.

Chapter 2: A Few Good Functions.

Chapter 3: Easy Formatting Fixes.

Part II: Escape in Under Two Minutes.

Chapter 4: Getting Excel to Behave.

Chapter 5: Getting Correct Results with Excel Formulas.

Chapter 6: Charts and Data Visualization.

Part III: More Elaborate Escapes.

Chapter 7: Common Issues with Excel Components.

Chapter 8: Involved Data Analysis.

Chapter 9: Very Large Spreadsheets.

Chapter 10: Other Challenging Topics.

Appendix A: Miscellaneous Solved Problems.

Appendix B: Installing the Escape Excel Hell Utility Pak.

Appendix C: Escape From Excel Hell Techniques and Hip Pocket Tips.

Appendix D: About the CD.

Index.

End-User License Agreement.