Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Escape From Excel Hell: Fixing Problems in Excel 2003, 2002 and 2000 (Mr. Spreadsheet's Bookshelf)

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


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

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.

(HTML tags aren't allowed.)

Intelligent Computer Techniques in Applied Electromagnetics (Studies in Computational Intelligence)
Intelligent Computer Techniques in Applied Electromagnetics (Studies in Computational Intelligence)
This book contains papers presented at the International Symposium on Electromagnetic Fields in Mechatronics, Electrical and Electronic Engineering ISEF’07 which was held in Prague, the Czech Republic, from September 13 to 15, 2007. ISEF conferences have been organized since 1985 and from the very beginning it was a common initiative of...
Dinosaurs: A Concise Natural History
Dinosaurs: A Concise Natural History

From the authors of The Evolution and Extinction of the Dinosaurs comes an introduction to the study of dinosaurs for non-specialists designed to excite readers about science by using dinosaurs to illustrate and discuss geology, natural history and evolution. While focusing on dinosaurs it also uses them to convey other aspects of the...

Design and Analysis of Distributed Algorithms (Wiley Series on Parallel and Distributed Computing)
Design and Analysis of Distributed Algorithms (Wiley Series on Parallel and Distributed Computing)
This text is based on a simple and fully reactive computational model that allows for intuitive comprehension and logical designs. The principles and techniques presented can be applied to any distributed computing environment (e.g., distributed systems, communication networks, data networks, grid networks, internet, etc.). The text provides a...

Delphi Graphics and Game Programming Exposed
Delphi Graphics and Game Programming Exposed
The majority of the book is dedicated to the mechanics of creating a game in Delphi, and will therefore be concerned mainly with exactly how to do something, such as fast flicker-free animation. Some parts address more theoretical issues, such as game design, and are very light in their coverage. Other parts are at a more intermediate level,...
Transact-SQL Cookbook (O'Reilly Windows)
Transact-SQL Cookbook (O'Reilly Windows)
This cookbook contains a wealth of solutions to problems that SQL programmers face all the time. Recipes inside range from how to perform simple tasks, like importing external data, to ways of handling issues that are more complicated, like set algebra. Each recipe includes a discussion that explains the logic and concepts underlying the...
Severe Injuries to the Limbs: Staged Treatment
Severe Injuries to the Limbs: Staged Treatment

This book details the protocol of staged external fixation developed by the authors: primary temporary unilateral tubular stabilization followed by definitive circular Ilizarov (hybrid) fixation. Coverage explains and fully illustrates the rationale and advantages of a logical progression of surgical steps. The book draws from an archive of...

©2020 LearnIT (support@pdfchm.net) - Privacy Policy