Newsletter   Secure Checkout   View Cart (0 items)  
Search:    Welcome Guest! Save up to 30-40% on most items with our awesome everyday discounts!

Spreadsheet Check and Control [Paperback]

Our Price $ 27.99  
Retail Value $ 39.99  
You Save $ 12.00  (30%)  
Item Number 268424  
Buy New $27.99
Available on the Internet only.

Item description for Spreadsheet Check and Control by Patrick R. O'Beirne...

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 books 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.

Promise Angels is dedicated to bringing you great books at great prices. Whether you read for entertainment, to learn, or for literacy - you will find what you want at!

Item Specifications...

Pages   204
Est. Packaging Dimensions:   Length: 9.13" Width: 7.48" Height: 0.71"
Weight:   0.79 lbs.
Binding  Softcover
Publisher   Systems Publishing
ISBN  190540400X  
ISBN13  9781905404001  

Availability  121 units.
Availability accurate as of Apr 27, 2017 04:42.
Usually ships within one to two business days from La Vergne, TN.
Orders shipping to an address other than a confirmed Credit Card / Paypal Billing address may incur and additional processing delay.

More About Patrick R. O'Beirne

Register your artisan biography and upload your photo! Are You The Artisan or Author behind this product?
Improve our customers experience by registering for an Artisan Biography Center Homepage.

Product Categories

1Books > Subjects > Computers & Internet > Microsoft > Applications > Microsoft Excel
2Books > Subjects > Nonfiction > Education > General

Reviews - What do customers think about Spreadsheet Check and Control?

Spreadsheet Check and Control  Sep 21, 2007
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 am a much better modeler for the efforts.
very basic  May 9, 2007
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. Would be suitable and very helpful for an Excel novice.
Are your spreadsheets error free? Look again!  Aug 9, 2006
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.
Valuable book  Nov 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 ( 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.
Beginning to End - Better Spreadsheets  Nov 22, 2005
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.

Write your own review about Spreadsheet Check and Control

Ask A Question or Provide Feedback regarding Spreadsheet Check and Control

Item Feedback and Product Questions
For immediate assistance call 888.395.0572 during the hours of 10am thru 8pm EST Monday thru Friday and a customer care representative will be happy to help you!

Help us continuously improve our service by reporting your feedback or questions below:

I have a question regarding this product
The information above is incorrect or conflicting
The page has misspellings or incorrect grammar
The page did not load correctly in my browser or created an error.

Email Address:
Anti Spam Question. To combat spammers we require that you answer a simple question.
What color is the sky?
Leave This Blank :
Do Not Change This Text :

Add This Product Widget To Your Website

Looking to add this information to your own website? Then use our Product Widget to allow you to display product information in a frame that is 120 pixels wide by 240 pixels high.

    Copy and paste the following HTML into your website and enjoy!

Order toll-free weekdays 10am thru 10pm EST by phone: 1-888-395-0572 (Lines are closed on holidays & weekends.)
Customer Service | My Account | Track My Orders | Return Policy | Request Free Catalog | Email Newsletter

Gift Certificates
RSS Feeds
About Us
Contact Us
Terms Of Use
Privacy Policy