Wiley, 2006. — 408 p. — ISBN: 978-0-470-04311-0.
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.
Escape in Under 30 Seconds.Spreadsheet Basics.
A Few Good Functions.
Easy Formatting Fixes.
Escape in Under Two Minutes.Getting Excel to Behave.
Getting Correct Results with Excel Formulas.
Charts and Data Visualization.
More Elaborate Escapes.Common Issues with Excel Components.
Involved Data Analysis.
Very Large Spreadsheets.
Other Challenging Topics.
AppendicesMiscellaneous Solved Problems.
Installing the Escape Excel Hell Utility Pak.
Escape From Excel Hell Techniques and Hip Pocket Tips.
About the CD.