Knockout Narratives Sale
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Original Essays | January 5, 2015

    Frances E. Jensen: IMG What You Don't Know about the Teenage Brain



    Things were changing in our household: the teen years had intruded into our otherwise harmonious, do-as-mom-tells-you relatively orderly world. As... Continue »

    spacer

This item may be
out of stock.

Click on the button below to search for this title in other formats.


Check for Availability
Add to Wishlist

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

by

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

 

Synopses & Reviews

Publisher Comments:

When Excel talks back to you, here's what to do

You try to open a spreadsheet and Excel won't let you, because there's a macro involved. You cannot convince the software that the macro is safe. You hurl something across the room.

Grab this book instead! You'll find more than 200 fixes for things that drive Excel users crazy, organized and identified for easy access. More than 100 problems can be solved in anywhere from 30 seconds to two minutes. If you're a more advanced user, turn to Part III, where you'll find the more elaborate escapes.

When all you want is to make your spreadsheet work so you can finish your project, here's all you need. Oh, and the macro problem? Check Chapter 1.

Loren Abdulezer's Top Escapes

  • Escape # 1 Fix tricky worksheet headers and footers
  • Escape # 2 Sort tabs by alphabetical order or date
  • Escape # 3 Build conditional charts
  • Escape # 4 Escape messy data with formulas
  • Escape # 5 Don't pay a penalty for giant spreadsheets

CD-ROM INCLUDES:

  • Excel spreadsheet examples and take-aways from the book
  • A searchable version of the book plus the Adobe Acrobat Reader
  • Crystal Xcelsius Professional trial software and sample files

See the CD appendix for details and complete system requirements.

Book News Annotation:

Technology consultant Abdulezer troubleshoots some 200 problems commonly encountered when working with spreadsheets. The problems are arranged into three basic categories: those that can be solved in less than 30 seconds, those requiring a few minutes more, and those that will likely take more than ten minutes to fix. A searchable version of the text is found on the accompanying CD-ROM, along with Excel spreadsheet examples, and Crystal Xcelsius Professional software. Annotation ©2007 Book News, Inc., Portland, OR (booknews.com)

Synopsis:

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

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

Table of Contents

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 Pocket Tips.

Appendix D: About the CD.

Index.

End-User License Agreement.

Product Details

ISBN:
9780471773184
Subtitle:
Fixing Problems in Excel 2003, 2002 and 2000
Publisher:
Wiley
Author:
Abdulezer, Loren
Author:
Walkenbach, John
Subject:
Business
Subject:
Spreadsheets - Excel
Subject:
Electronic spreadsheets
Subject:
Spreadsheets - General
Subject:
Personal Computers-Applications
Subject:
Microsoft Excel
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Copyright:
Edition Description:
CD-ROM + On-line
Series:
Mr. Spreadsheet's Bookshelf
Publication Date:
20060606
Binding:
Electronic book text in proprietary or open standard format
Grade Level:
General/trade
Language:
English
Illustrations:
Y
Pages:
408
Dimensions:
9.14x7.36x1.02 in. 1.38 lbs.

Related Subjects


Business » Investing
Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Operating Systems » Microsoft Windows » Windows 95 » General
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets

Escape from Excel Hell: Fixing Problems in Excel 2003, 2002, 2000
0 stars - 0 reviews
$ In Stock
Product details 408 pages John Wiley & Sons - English 9780471773184 Reviews:
"Synopsis" by ,
  • 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.

spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.