Escape From Excel Hell Fixing Problem In Excel 2003,2002,2000 (With CD)

0.0

Escape from Excel Hell: Fixing Problems in Excel 2003, 2002, 2000 is about fixing the Excel problems that constantly plague Excel users. Most of these problems have easy fixes-once you know the secret. The book organization is oriented around the reader who is working with Excel and encounters problems. The book is meant to be used in the following way. A person is working with a spreadsheet. He or she hits a snag; takes the book off the shelf, thumbs through it; finds the relevant information; fixes the problem, and puts the book back on the shelf. The book is jam packed with numerous facts and tips that make a great read on a rainy day. Key Features Mr. Spreadsheet’s Bookshelf: Escape from Excel Hell: Fixing Problems in Excel 2003, 2002, 2000 (Mr. Spreadsheet’s Bookshelf) is another title in the new series, Mr. Spreadsheet’s Bookshelf, featuring John Walkenbach. As series editor for the book, John will review content, and he will endorse and promote the book on his web site. Wiley is the market leader in the Excel world. Wiley owns 53 percent of the marketshare in the Excel category according to Bookscan. Excel is a part of the Microsoft Office suite. Office continues its dominance in this category with the most popular office productivity suite in this lucrative marketplace. Microsoft Office lays claim to more than 90 percent of the market for Windows-based application suites. Microsoft places the current installed base at 300 million. Microsoft Excel has been a cornerstone of the Office suite from its inception. Excel is the standard among spreadsheet applications and is an indispensable tool in the business community. Focus on problem solving. Problem fixes are divided into three categories. On the spot fixes (30-second escapes) are in Part I. Fixes that require multiple steps (2-minute escapes) are in Part II. Fixes that require planning/strategizing, lots of multiple steps, or significant troubleshooting are in Part III. Expert author. Loren Abdulezer is head of Evolving Technologies Corporation, a New-York based technology consulting firm. He is author of Excel Best Practices for Business. Valuable CD Escape from Excel Hell: Fixing Problems in Excel 2003, 2002, 2000 (Mr. Spreadsheet’s Bookshelf) includes a CD containing spreadsheets of all the examples in the book. There will be approximately 75 to 100 spreadsheets or worksheet tabs. 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 JP Morgan Chase, IBM, Procter & Gamble Pharmaceuticals, and Pfizer. He has consulted on strategic technology and Internet product design, data analysis, mathematical modeling and simulation, MIS/Web reporting, Java and object-oriented programming, Internet security, and business continuity planning. Loren is author of Excel Best Practices for Business. John Walkenbach is series editor for the book, which will be featured on his web site. As Mr. Spreadsheet, John is endorsing the book for the series that bears his name, Mr. Spreadsheet’s Bookshelf. Table Of Contents Preface Acknowledgments Introduction Part I: Escape in Under 30 Seconds Spreadsheet Basics A Few Good Functions Easy Formatting Fixes Part II: Escape in Under Two Minutes Getting Excel to Behave Getting Correct Results with Excel Formulas Charts and Data Visualization Part III: More Elaborate Escapes Common Issues with Excel Components Involved Data Analysis Very Large Spreadsheets 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