Troubleshooting Excel Spreadsheets - Softcover

Ulrich-Fuller, Laurie

Softcover

ISBN 10: 0735611610 ISBN 13: 9780735611610

Publisher: Microsoft Press,U.S., 2001

Synopsis

Trouble with your Microsoft Excel spreadsheet? Confounded by error messages? With this handy Troubleshooting guide, it's easy to pinpoint -- and solve -- your own software problems. Fast! Each section opens with a troubleshooting chart to help quickly diagnose the source of the problem. It offers clear, step-by-step solutions to try right away, plus a full chapter of things to do to stay out of trouble or learn a new trick. Continuous support via the Troubleshooting Latest Solutions Web site provides monthly updates on additional problem solving information. Books in the Troubleshooting series are colorful, superbly organized, and easy to read, giving even novice users the confidence to fix it themselves -- without calling tech support or wasting time on futile trial and error. Covering both Excel 97 and Excel 2000, this book shows how to troubleshoot worksheets, analyze data.

About this title

Review:

The author of Troubleshooting Microsoft Excel Spreadsheets has organised her work around the negative behaviour that pops up all too often while you're working with Excel 97 and 2000. Rather than explaining how the software is supposed to work by (one-by-one) documenting its features and capabilities, 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. To put it another way, the book 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

Synopsis:

Explains how to diagnose and correct common problems in Microsoft Excel 97 and Excell 2000.

About this edition

• Publisher: Microsoft Press,U.S.
• Publication date: 2001
• ISBN 10: 0735611610
• ISBN 13: 9780735611610
• Binding: Paperback
• Edition number: 1
• Number of pages: 352