• List Price: CDN$ 51.86
  • You Save: CDN$ 4.26 (8%)
Only 1 left in stock (more on the way).
Ships from and sold by Amazon.ca. Gift-wrap available.
Spreadsheet Check and Con... has been added to your Cart
+ CDN$ 6.49 shipping
Used: Good | Details
Sold by Nearfine
Condition: Used: Good
Comment: A good reading copy. May contain markings or be a withdrawn library copy. Expect delivery in 20 days.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Spreadsheet Check and Control Paperback – Sep 1 2005

See all formats and editions Hide other formats and editions
Amazon Price
New from Used from
"Please retry"
CDN$ 47.60
CDN$ 32.12 CDN$ 29.06

Harry Potter and the Cursed Child
click to open popover

Special Offers and Product Promotions

  • You'll save an extra 5% on Books purchased from Amazon.ca, now through July 29th. No code necessary, discount applied at checkout. Here's how (restrictions apply)

No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

Product Details

  • Paperback: 200 pages
  • Publisher: Systems Publishing (Sept. 1 2005)
  • Language: English
  • ISBN-10: 190540400X
  • ISBN-13: 978-1905404001
  • Product Dimensions: 19.1 x 1.1 x 23.5 cm
  • Shipping Weight: 358 g
  • Average Customer Review: Be the first to review this item
  • Amazon Bestsellers Rank: #706,336 in Books (See Top 100 in Books)
  •  Would you like to update product info, give feedback on images, or tell us about a lower price?

Customer Reviews

There are no customer reviews yet on Amazon.ca
5 star
4 star
3 star
2 star
1 star

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: HASH(0xa09ef054) out of 5 stars 9 reviews
10 of 10 people found the following review helpful
HASH(0xa06945a0) out of 5 stars Valuable book Nov. 24 2005
By Dr. G. Hinson - Published on Amazon.com
Format: Paperback
Spreadsheet Check and Control addresses a woefully underrepresented aspect of information security, namely integrity. Whether in the hands of ordinary untrained computer users or professional software developers, spreadsheets are deceptively easy to program and all too easy to program incorrectly. The author provides a compelling and clearly-written set of tips and techniques for finding and resolving programming errors that, unchecked, could cause serious consequences. The `47 key practices' noted in the subtitle are collected under headings such as fundamentals (3 key practices), error identification (4 practices) and error correction (11 practices), all within chapter 3 on calculation. Previous chapters cover specification and inputs, the remainder cover outputs and review.

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.
8 of 8 people found the following review helpful
HASH(0xa0694018) out of 5 stars Better spreadsheets through simple checks! Oct. 31 2005
By Colm Toolan - Published on Amazon.com
Format: Paperback
Although this book was written with the syllabus of The European Computer Driving Licence (ECDL) in mind, its quality and depth far surpass any expectations that may be implied by that fact. Patrick O'Beirne's wide experience of spreadsheet pitfalls and risk is apparent at every turn, resulting in a serious discussion of how best to avoid business disasters based on inaccurate and erroneous Excel models.

Microsoft Excel - and other spreadsheet programmes - allows the creation of models of infinite complexity. The main advantage of Excel - an easy-to-use, almost intuitive, "programming" interface - is potentially its main disadvantage. Spreadsheets get started quickly and may or may not be properly maintained. Complex calculations can be resolved in a cell-by-cell iterative manner, making error location difficult. Solutions tend to be extended over time - often by different people - which compounds the problem. A myriad of pre-packaged functions is available, but the choice of the appropriate - or inappropriate - function is entirely at the developer's discretion.

Spreadsheet Check and Control addresses all of these issues by providing succinct, down-to-earth tips on the basics of spreadsheet working:
* Specification - define what you're trying to do, record sources of information
* Security - avoid breaking a working version, making sure everyone is using the correct version, the use of passwords and their limitation
* Style - managing constants, units of measurement etc for consistency, handling unwieldy formulae

The discussion on Calculation addresses the fundamentals, such as the precedence of mathematical operators, circular references, and the particular quirks of arrays in Excel. Valuable hints on finding and identifying errors are provided followed by detailed descriptions of various error types and explicit tips for their correction. Obviously, if the developer understands the generic cause of an error type, then finding the offending formula or data for a specific instance is a much more efficient process. Given that the nature of the Excel beast results in error displays that are often "separated in time and space" from the original cause, the guidance provided here will significantly reduce error tracking effort.

The section on Output includes the mandatory hints on charting, but the pitfalls associated with cell formats provide answers to some fascinating questions: When is a number not a number? Are invisible cells seen by some? When is 100% not 100%? When did John Smith change his name? When is a database not a database?

Although it was common enough in the early days of programming, no one today would claim that a software programme was completed without some degree of formal testing. Yet spreadsheets are constantly being modified and altered - not just before that important meeting, but actually in the meeting! - without much awareness of the need to test the quality of the changed model. Patrick's work as Chairman of the European Spreadsheet Risk Interest Group (EuSpRIG) provides him with numerous examples and anecdotes of just how horribly wrong things can go as a result. The Review section of the book addresses the key areas of data integrity and functional correctness and is quite simply a "must read".

The Appendices provide useful information, but my favourite is the list of websites and software tools, which provide all the links the user needs to pursue the topic of Spreadsheet Check and Control further.

If you need useful, practical advice on building better spreadsheets, then this book is for you.

If you need to have confidence in the models that your colleagues and employees build, then this is the ideal present for them.

My only gripe has nothing to do with the book, but with the fact the Microsoft do a relatively good job of translating function names and arguments. As a result, it does require some additional brainpower to get the best of Patrick's tips if you're using a foreign language version of Excel.

Colm Toolan, Business Architect..
8 of 9 people found the following review helpful
HASH(0xa0866840) out of 5 stars Beginning to End - Better Spreadsheets Nov. 21 2005
By dlngwth - Published on Amazon.com
Format: Paperback
Whether your a beginner or a seasoned pro, I would recommend this book. It is not collecting dust on my bookshelf. This is one of the first books I have read that took me from pre-design to maintaining the finished product. The book gave me proven design principles that will prevent many of the common pitfalls of my spreadsheet models.

One of the first things I noticed was how the book took me from the preparation before design - to getting the data in - to error checking, with an in-depth look at calculations and functions - to the finished presentation of the data. The book was an easy read, not filled with lengthy technical jargon.

Spreadsheet Check and Control will be a great addition to your collection, as it is to mine.
4 of 4 people found the following review helpful
HASH(0xa091f258) out of 5 stars Are your spreadsheets error free? Look again! Aug. 9 2006
By Martin Green - Published on Amazon.com
Format: Paperback
I hate proofreading my work. I know what's supposed to be there so that's what I see. But if a typo slips through the net there's no real harm done and someone else usually spots it and lets me know. But auditing a spreadsheet is a different matter. A simple error could easily go unnoticed and its consequences might cascade through the workbook without ever being discovered. So this book is a Godsend! It explains, clearly and with illustrated examples, how to design and build reliable, error-free spreadsheets and how to use the tools that Excel provides for auditing and error-checking. Each section concludes with a self-test and there is a support website. I though I knew my way around Excel pretty well, but reading this book I found myself saying "I didn't know you could do that!". If you build spreadsheets you should read this book.
1 of 1 people found the following review helpful
HASH(0xa0976c54) out of 5 stars Great Book to Add to Excel Materials June 27 2013
By Grolsch - Published on Amazon.com
Format: Paperback
So many books on the market telling you how to make pie charts and formula syntax. This book was a welcome change.

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.