Escape From Excel Hell (eBook)

Loren Abdulezer is CEO and President of EvolvingTechnologies Corporation, a New York-based technologyconsulting firm. He is an experienced IT professional serving majorFortune 500 companies, including Citigroup, JP Morgan Chase, IBM,Procter & Gamble Pharmaceuticals, and Pfizer. He has consultedon strategic technology and Internet product design, data analysis,mathematical modeling, visual modeling, and simulation, MIS/Webreporting, Java and object-oriented programming, Internet security,and business continuity planning.Loren is a world acknowledged expert on spreadsheets, visualmodeling, and dashboard technology. He is the author of ExcelBest Practices for Business (www.ExcelBestPractices.com), alsopublished by Wiley, and is a Crystal Xcelsius Consulting Partnerfor Business Objects S.A. (www.XcelsiusBestPractices.com). You canfind out more information about Loren and the book Escape FromExcel 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 PocketTips.Appendix D: About the CD.Index.End-User License Agreement.