Escape from Excel Hell: Fixing Problems in Excel 2003, 2002, And 2000

Escape from Excel Hell: Fixing Problems in Excel 2003, 2002, And 2000

by Loren Abdulezer
     
 

  • 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
…  See more details below

Overview

  • 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.

Editorial Reviews

bn.com
The Barnes & Noble Review
Why won’t my formulas calculate correctly? Why isn’t Excel sorting properly? Aren’t there faster ways to navigate large workbooks? Powerful as it is, Excel can drive you nuts. Fortunately, that’s fixable, with Escape from Excel Hell.

Loren Abdulezer organizes this book into fixes you can nail in 30 seconds; fixes that’ll take less than two minutes; and those that’ll take a little longer. From formatting and functions to cleaning up imported data, you’ll be surprised how much fits into the first two categories. Some of Abdulexer’s tips simply make Excel more elegant. Have a spreadsheet requiring a new entry for each date? Here’s how to open it to today’s date -- automatically.

Feeling ambitious? Abdulezer offers valuable tips for handling Excel components, troubleshooting complex data analysis, and managing “giant economy size” spreadsheets. Then, load the CD-ROM for some nifty bonus add-ins. Bill Camarda, from the April 2006 Read Only

Product Details

ISBN-13:
9780471773184
Publisher:
Wiley
Publication date:
03/20/2006
Series:
Mr. Spreadsheet's Bookshelf Series
Edition description:
BK&CD-ROM
Pages:
408
Product dimensions:
7.40(w) x 9.10(h) x 0.96(d)

Meet the Author

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.

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >