Escape From Excel Hell (eBook)

Fixing Problems in Excel 2003, 2002 and 2000

Loren Abdulezer (Autor)

eBook Download: PDF

2006 | 1. Auflage
408 Seiten
John Wiley & Sons (Verlag)
978-0-470-04311-0 (ISBN)

Infos

* Written especially for advanced beginners and intermediateusers, this book offers quick fixes for anyone bedeviled by faultyformulas, failed formatting, printer purgatory, and otherperplexing Excel problems* Offers three types of fixes: Escape in Under 30 Seconds, Escapein Under Two Minutes, and More Elaborate Escapes-over 400 solutionsin all* Topics covered include formula fixes, formatting fixes, dataand layout fixes for Excel charts, PivotTable fixes, managingcomplexity in very large spreadsheets, fixing broken procedurefunctions, and more* Includes preventive measures and best practices that teachusers how to avoid problems in the futureNote: CD-ROM/DVD and other supplementary materials arenot included as part of eBook file.

Autor

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.

Inhalt

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.

Produkt-Details

• Erscheint lt. Verlag: 16.2.2006
• Mitarbeit: Herausgeber (Serie): John Walkenbach
• Sprache: englisch
• Themenwelt: Informatik ► Office Programme ► Excel
• Schlagworte: Computer-Ratgeber • End-User Computing • Excel • Microsoft Excel
• ISBN-10: 0-470-04311-3 / 0470043113
• ISBN-13: 978-0-470-04311-0 / 9780470043110