Beschreibung:
* 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.
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.