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

Abdulezer, Loren

 
9780471773184: Escape from Excel Hell: Fixing Problems in Excel 2003, 2002, and 2000
Brossura
ISBN 10: 0471773182 ISBN 13: 9780471773184
Casa editrice: John Wiley & Sons Inc, 2006

Sinossi

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

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

Informazioni sull?autore

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.

Dalla quarta di copertina

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.

Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.

Editore
John Wiley & Sons Inc
Data di pubblicazione
2006
Lingua
Inglese
ISBN 10 
0471773182
ISBN 13 
9780471773184
Rilegatura
Copertina flessibile
Numero edizione
1
Numero di pagine
408
Contatto del produttore
non disponibile
Persona responsabile
non disponibile