- Taschenbuch: 200 Seiten
- Verlag: Systems Pub (1. September 2005)
- Sprache: Englisch
- ISBN-10: 190540400X
- ISBN-13: 978-1905404001
- Größe und/oder Gewicht: 19,1 x 1,1 x 23,5 cm
- Durchschnittliche Kundenbewertung: 1 Kundenrezension
- Amazon Bestseller-Rang: Nr. 527.194 in Fremdsprachige Bücher (Siehe Top 100 in Fremdsprachige Bücher)
Andere Verkäufer auf Amazon
+ kostenlose Lieferung
+ kostenlose Lieferung
Spreadsheet Check and Control: 47 Key Practices to Detect and Prevent Errors (Englisch) Taschenbuch – 1. September 2005
Es wird kein Kindle Gerät benötigt. Laden Sie eine der kostenlosen Kindle Apps herunter und beginnen Sie, Kindle-Bücher auf Ihrem Smartphone, Tablet und Computer zu lesen.
Geben Sie Ihre Mobiltelefonnummer ein, um die kostenfreie App zu beziehen.
Wenn Sie dieses Produkt verkaufen, möchten Sie über Seller Support Updates vorschlagen?
Learn how to: increase efficiency by avoiding rework; discover powerful formula auditing techniques; foil attempts to conceal data and formulas from you; reduce worry about costly and embarrassing mistakes; create spreadsheets faster by avoiding wasted time from lack of specification; present results with more confidence knowing that you have checked for errors; benefits to your organisation; ensure data quality and accuracy; protect against formula and operational errors; be able to demonstrate management of material risks; increase controls over spreadsheet based financial reporting; and reduce compliance costs for businesses in regulated sectors.
Derzeit tritt ein Problem beim Filtern der Rezensionen auf. Bitte versuchen Sie es später noch einmal.
Spreadsheet Check and Control hilft dabei, die grundsätzlichsten und am häufigsten auftretenden Fehler zu vermeiden. Und das geschieht vor allem mit praxis bezogenen Beispielen und Leitfäden. Dabei tauchen auch die typischen, fast schon existenziellen, Fragen auf: Wann ist eine Zahl keine Zahl? Warum sind unsichtbare Zellen sichtbar - und vor allem: für wen? Wieso sind 100% nicht immer 100%? etc.
Patrick O'Beirnes Spreadsheet Check and Control ist für alle geeignet, die komplexe Modelle von Anfang an vernünftig strukturieren möchten.
Die hilfreichsten Kundenrezensionen auf Amazon.com
I have the following issues with the book -
1. There is not enough information on good layout design or designing spreadsheets to minimize errors or mistakes.
2. It doesn't discuss why people are making particular errors or in what context errors are being made. Sure I can look out for issue x, y, or z, but in what situations would those issues come up in the first place?
3. There are some points that are very obvious and other points that people will never use.
Again, I did not learn much if anything from reading this book. It may be good for the beginner, but not for the advanced user.
1. Useful for advanced users: I did get a number of ideas I plan to use in the usual fall Excel marathon. I have learned much of what is in this book by making the mistakes myself. But if it prevents even one mistake going forward, it's well worth the price.
2. Best for intermediate users: However, I plan to use to help train analysts going forward. I have trained a LOT of analysts and see the same pitfalls repeatedly. In addition, now there are fewer people doing more work than ever -- so anything than can speed up the learning process is a good thing. There just isn't as much time for mistakes and learning and I find people's spreadsheets getting worse every year. It's nice to have a concise instruction of what to do/not to do at the ready.
3. If there is a next version: I do wish the author had spent more time at a higher level strategy and design instead of padding with a lot of more basic step-by-step (anyone who is interested in this book is probably not a basic user anymore). For example, anyone who is truly interested in charting would likely already have a copy of Show Me the Numbers: Designing Tables and Graphs to Enlighten. Otherwise, Excel for Dummies has better basic information. He needs to be clear who is audience is.
Also, taking out the step-by-step would allow the book to "age" better as Excel versions are updated. However, while this book uses Excel 2003, it's still worthwhile as the ideas are what are important -- where to click in the ribbon is of much less concern.
The author thanks www. eusprig. org where you can find a lot of additional ideas and white papers for further reading.
The reader is given just enough explanatory information to understand the issue at hand, followed by advice on how to avoid or fix the problem. There are numerous examples throughout the text, illustrated with Microsoft Excel screenshots (the reader can download the same example spreadsheets from the author's website to try out the techniques described). There are review questions at the end of each of the key practices with answers provided at the end of the book, and a good selection of annotated hyperlinks to further information sources.
Many of the practices are accompanied by relevant case studies - real world security incidents drawn from sources such as the RISKS list managed by Peter Neumann ([...]) and a number of public audit reports which identified spreadsheet errors. It focuses the mind to realize that a simple spreadsheet mistake can lead to errors amounting to millions of dollars.
This is definitely a practitioner's book, not a theoretical or academic tome. With minimal preamble, each section gets quickly down to the nitty-gritty tools and techniques of finding and eliminating errors. The writing style is clear and easy to read.
Save red faces all round by buying, absorbing and passing-on this book, especially if you personally develop spreadsheets or if your organization is subject to Sarbanes Oxley and related regulations. Avoiding even a trivial spreadsheet mistake may well pay for the book. Avoiding a large one may save your career.