or
Sign in to turn on 1-Click ordering.
 
 
Express Checkout with PayPhrase
What's this? | Create PayPhrase
More Buying Choices
26 used & new from $24.85
Have one to sell? Sell yours here
 
   
Spreadsheet Check and Control
 
See larger image 
Share your own customer images
Tell the Publisher!
I’d like to read this book on Kindle

Don’t have a Kindle? Get your Kindle here.
 
  

Spreadsheet Check and Control (Paperback)

~ Patrick R O'Beirne (Author)
4.5 out of 5 stars  See all reviews (6 customer reviews)
List Price: $39.99
Price: $33.19 & this item ships for FREE with Super Saver Shipping. Details
You Save: $6.80 (17%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.

Ordering for Christmas? This item requires additional time to ship. To ensure delivery by December 24, choose FREE Super Saver Shipping at checkout. Read more about holiday shipping.

15 new from $25.66 11 used from $24.85

Frequently Bought Together

Customers buy this book with Excel Best Practices for Business: Covers Excel 2003, 2002, and 2000 by Loren Abdulezer

Spreadsheet Check and Control + Excel Best Practices for Business: Covers Excel 2003, 2002, and 2000
Price For Both: $64.36

One of these items ships sooner than the other. Show details

Customers Who Bought This Item Also Bought

Excel Best Practices for Business: Covers Excel 2003, 2002, and 2000

Excel Best Practices for Business: Covers Excel 2003, 2002, and 2000

by Loren Abdulezer
4.5 out of 5 stars (17)  $31.17
Excel for Auditors: Audit Spreadsheets Using Excel 97 through Excel 2007 (Excel for Professionals series)

Excel for Auditors: Audit Spreadsheets Using Excel 97 through Excel 2007 (Excel for Professionals series)

by Bill Jelen
2.3 out of 5 stars (3)  $18.21
Excel for Accountants: Tips, Tricks & Techniques

Excel for Accountants: Tips, Tricks & Techniques

by Conrad Carlberg
4.2 out of 5 stars (4)  $23.07
Pivot Table Data Crunching

Pivot Table Data Crunching

by Bill Jelen
4.6 out of 5 stars (27)  $26.39
Excel Basics to Blackbelt: An Accelerated Guide to Decision Support Designs

Excel Basics to Blackbelt: An Accelerated Guide to Decision Support Designs

by Elliot Bendoly
5.0 out of 5 stars (2)  $38.47
› Explore similar items

Editorial Reviews

Review

'Probably one of the most important spreadsheet books ever written; probably equivalent to 500 pages in many other books.' -- Simon Murphy, Codematic.net, author of XLAnalyst.

O'Beirne taught me some new tricks and methods that both helped me build better financial models and track down errors. -- Simon Benninga, author of Financial Modeling,and Principles of Finance with Excel

This book provides standards for designing spreadsheets that lend themselves to a logical review by management and internal auditors. -- Jim Kaplan, AuditNet.org

¡¥It is excellent. I think it will become, and it should be, required reading for all young trainee accountants.¡¦ -- Ciaran Walsh, senior finance specialist, Irish Management Institute.

¡¥It's super. I kept saying to myself, ¡§Wow, I didn't know you could do that.¡¨ A great job.¡¦ -- Ray Panko, University of Hawai¡¥i.


Product Description

This spreadsheet book is quite different from every other book on Microsoft Excel. If spreadsheet users had a driving licence, this would be their seat belt, air bag, navigation aid, repair kit, hazard indicators, and the rules of the road.

This new book describes how to produce well-crafted spreadsheets that are easy to understand, maintain, audit, and operate. It shows how to ensure data quality and accuracy and protect against formula and operational errors.

Each of the 47 techniques is explained with examples and has a self-test practical question with answers at the back of the book. The book¡¦s support web site provides sample spreadsheets for these tests.

The material gives spreadsheet users more confidence in their work, and saves time chasing and fixing easily preventable errors. Those whose job is to check the work of others, whether they are software testers or auditors, will learn formula auditing techniques and be able to reveal hidden data and formulas. This book should be adopted by organizations concerned to reduce compliance costs by being able to demonstrate management of material risks and increase controls on spreadsheet based financial reporting.

See all Editorial Reviews

Product Details

  • Paperback: 204 pages
  • Publisher: Systems Publishing (September 1, 2005)
  • Language: English
  • ISBN-10: 190540400X
  • ISBN-13: 978-1905404001
  • Product Dimensions: 9.1 x 7.5 x 0.7 inches
  • Shipping Weight: 12.6 ounces (View shipping rates and policies)
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (6 customer reviews)
  • Amazon.com Sales Rank: #523,134 in Books (See Bestsellers in Books)

    •  Would you like to update product info or give feedback on images?

More About the Author

Patrick O'Beirne
Discover books, learn about writers, read author blogs, and more.

› Visit Amazon's Patrick O'Beirne Page

Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 
(1)
(1)
Agree with these tags?

Your tags: Add your first tag
 
See most popular tags

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more
 

Customer Reviews

6 Reviews
5 star:
 (5)
4 star:    (0)
3 star:    (0)
2 star:
 (1)
1 star:    (0)
 
 
 
 
 
Average Customer Review
4.5 out of 5 stars (6 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
9 of 9 people found the following review helpful:
5.0 out of 5 stars Valuable book, November 24, 2005
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 (http://catless.ncl.ac.uk/Risks) 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.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
6 of 6 people found the following review helpful:
5.0 out of 5 stars Better spreadsheets through simple checks!, October 31, 2005
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..
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
7 of 8 people found the following review helpful:
5.0 out of 5 stars Beginning to End - Better Spreadsheets, November 21, 2005
By Damon Longworth (Missouri, USA) - See all my reviews
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.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews

5.0 out of 5 stars Spreadsheet Check and Control
Entertaining and very useful introduction to spreadsheet errors and how to detect and fix them.

I read it cover to cover and worked all the examples and exercises and... Read more
Published on September 20, 2007 by J. C. Rosenberg

2.0 out of 5 stars very basic
I skimmed the book and it seemed to contain very basic suggestions for building controls into spreadsheets. I was hoping for more and honestly didn't read the book. Read more
Published on May 9, 2007 by S. Stechmann

5.0 out of 5 stars Are your spreadsheets error free? Look again!
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... Read more
Published on August 9, 2006 by Martin Green

Only search this product's reviews


Customer Discussions

This product's forum
Discussion Replies Latest Post
Free sample chapters for download 0 October 2006
Support and Updates 0 August 2006
› See all 2 discussions...  
Start a new discussion
Topic:
First post:
Prompts for sign-in
 


Active discussions in related forums
Search Customer Discussions
   

Product Information from the Amapedia Community

Beta (What's this?)

Spreadsheet Check and Control

This is a: Book Description

I am the author, and am posting this review to start the discussion. I'm not sure whether the Amapedia rules allow posting quotes from other people's reviews so I won't do it yet. ABOUT THIS BOOK If spreadsheet users had a driving licence,

Publisher: Systems Publishing;  Author: Patrick R. O'Beirne;  Number Of Pages: 204; ...

(Report this)
Created on Jul 05, 2008, last edited on Jul 05, 2008.

› Read More and Edit at Amapedia.com opens new browser window


Look for Similar Items by Category

Look for Similar Items by Subject

Search Books by subject:







i.e., each book must be in subject 1 AND subject 2 AND ...
 

Feedback

If you need help or have a question for Customer Service, contact us.
 Would you like to update product info or give feedback on images?
Is there any other feedback you would like to provide?

Your comments can help make our site better for everyone.


Your Recent History

 (What's this?)

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.