Features
- Cover Type: Paperback with 352 pages
- Published by: Microsoft Press January 6, 2001
- Written in: English
- ISBN 10 Number: 0735611610
- ISBN 13 Number: 978-0735611610
-
Book Dimensions:
9.2 x 7.2 x 0.8 inches
- Weighs: 1 pounds
Product Review
The author of
Troubleshooting Microsoft Excel Spreadsheets has organized her work around the negative behaviors that pop up all too often while you're working with Excel 97 and 2000. Rather than explain how the
software is supposed to work by documenting its features and capabilities one by one, this book begins at the apparent dead ends of the world's most widely used computer spreadsheet package. The book states problems ("When I type in the active cell, nothing happens," and "I'm not sure how to get data from my worksheet to appear on a map," are two examples) and presents solutions to them. In other words, it uses statements of users' problems as a means of getting readers to the procedure or set of facts they need. The procedures are a mixture of feature documentation (PivotTables are explained for the uninitiated) and, to a lesser extent, problem workarounds (how to use formatting tricks to solve the perennially vexing "disappearing zero" problem). Problem statements are arranged into flow diagrams that help lead readers to the information they need.
Once you find the spread you're looking for, the book does a fine job of explaining what the problem is and how you can accomplish the job at hand. Fact-rich text lays the groundwork for step-by-step procedures, which usually appear in a couple of versions to address situational differences.
--David Wall Topics covered: - Microsoft Excel 97 and 2000 for everyday users
- Calculations
- Formatting
- Data collection and distribution
- All the Excel extras, such as Microsoft Map and PivotTable analysis
Book Info
A beginner to intermediate level guide to troubleshooting
Microsoft Excel spreadsheets in Excel 97 and 2000. Shows how to diagnose the problem, solve it with step-by-step instructions and screen shots, and avoid future trouble by downloading solutions from the companion Web site. Softcover. DLC:
Microsoft Excel for Windows.
Reader ReviewsI work with spreadsheets in my job everyday. I understand the basics and understand what they are supposed to do but sometime I have trouble making them work right. Since my technical expertise lies in other places I need a helping hand and being on the phone for hours is the answer. Laurie Ann Ulrich has put together a 350 page-troubleshooting guide that takes the mystery out of the spreadsheet world. Ulrich's book covers both the Excel 97 and Excel 2000 applications and Ulrich may have saved me countless hours of frustration. Tackling areas like charts, formatting of data, dates, shapes and lines, exporting and importing of data, filtering text and formatting numbers, formulas, maps, macros, printing and sorting have given the ability to provide better support to the user community. The book includes screenshots and a whole host of ideas in a flow chart style of troubleshooting. Ulrich's compilation of methods are certainly some of the best ways to fix problems and this book is for the beginner to intermediate user, however even the most experienced user may be able to benefit.
Search for books at
