Avoid Excel Horror Stories: How to excel at creating reliable, user-friendly spreadsheets
Language: English
Published by Gary Knott, 2021
- Softcover
- Used
Seller: medimops, Berlin, Germanymedimops
AbeBooks seller since May 10, 2010
Condition: Used - Very good
US$ 17.27
Quantity: 1 available
Add to basketItem description from seller
Seller Inventory # M03982322715-V
- Title
- Avoid Excel Horror Stories: How to excel at creating reliable, user-friendly spreadsheets
- Author
- Knott, Gary
- Publisher
- Gary Knott
- Publication year
- 2021
- Condition
- very good
- Binding
- Soft cover
- Language
- English
- ISBN 10
- 3982322715
- ISBN 13
- 9783982322711
Studies show that spreadsheet errors are commonplace. These can cause you huge losses of money, time and reputation. On top of that, spreadsheets are often poorly designed and constructed so that users have a hard time trying to understand and use them. The consequence is, they hinder rather than help you.
Major causes are a lack of best practice training and insufficient error awareness. In this book, we address both these points.
If you develop or use spreadsheets, this book is for you!
You will learn how to excel at creating reliable, user-friendly spreadsheets. You will:
+ learn Golden Ground Rules to make your spreadsheets easier to use and to minimise the risk of error
+ learn how errors can occur – largely based upon real-life horror stories – and how to avoid them
+ fill your tool bag with “how2excel” tips to help you and further improve your spreadsheets
The book is packed with practical examples and screenshots to help you understand. You can also download free bonus material: Excel files containing all the examples in the book as well as a practical checklist to print out and refer to in your work.
In chapter 1 ‘Be prepared’, you will learn what to do before starting to develop a spreadsheet and how best to plan your work.
In chapter 2 ’Follow Gary’s Golden Ground Rules’, you will learn all five of my tried and tested Golden Ground Rules for spreadsheet development. Rules 1 to 3 cover clear spreadsheet structure, calculations and design. Rules 4 and 5 explain how to restrict access and changes to your spreadsheets and make it clear for users how to use them. Follow these to help ensure that your spreadsheets are easy to use and to avoid errors.
In chapter 3 ‘Learn from horror stories’, you will learn about more than 20 real-life spreadsheet errors which had significant, damaging consequences – largely financial but also reputational – for the organisations and the people involved. These horror stories are grouped into categories to get you better acquainted with the kinds of errors that occur. In each case, you will learn how such errors arise and practical techniques to avoid them. These are often illustrated with simple Excel examples to help you better understand them. As a bonus, these examples are all available in Excel files that you can download and review to further improve your understanding.
In chapter 4 ‘Avoid common function errors’, you will understand various errors that can arise when using common functions such as VLOOKUP, NPV and IFERROR and how to avoid them.
At this point in the book, we end the focus on error prevention. Two additional steps are needed to weed out any errors which do manage to slip through, and you will learn these in the next two chapters.
In chapter 5 ’Detect errors’, you will learn how to identify errors, in case prevention fails. You will learn my three-pronged approach to error detection: built-in checks, review and testing by the developer, and independent review and testing.
In chapter 6 ‘Find and correct errors’, you will learn how to find and correct errors, including those that you had not previously detected! This is a vital step that should not be underestimated or omitted if you want to be really sure that your spreadsheets are reliable.
Finally, in chapter 7 ‘How to excel’, you will find advice on how best to apply your new-found knowledge and also a useful checklist of all the major concepts from the book for you to use in your Excel work. As a bonus, you can download and printout a PDF of the checklist for easy reference.
"Synopsis" may belong to another edition of this title.
Shipping rates from Germany to U.S.A.
| Item | 10 to 20 business days | 10 to 20 business days |
|---|---|---|
| First item | US$ 11.59 | US$ 23.18 |
Payment methods
Store description
Seller's business information
momox SE
Schreiberhauer Straße 30
Berlin, Germany 10317
Terms of sale
1. Scope
For all orders via our store on the AbeBooks Marketplace, the following terms and conditions apply. Unless otherwise agreed, the inclusion of any terms and conditions of your own used by you is contradicted.
2. contracting party, conclusion of contract, correction options
The purchase contract is concluded with momox SE.
The subject of the contract is the sale of goods.
If an article is posted by us on AbeBooks, the activation of the offer page on AbeBooks is the binding offer to conclude a contract under the conditions contained in the article page.
The presentation of the products in the online store does not constitute a legally binding offer, but a non-binding online catalog. You have the option to complete the ordering process via the shopping cart system or the buy now function. You can initially place our products in the shopping cart without obligation and correct your entries at any time before submitting your binding order by using the correction tools provided and explained for this purpose in the order process. By clicking the order button you make a binding offer for the goods contained in the shopping cart. By pressing the button "Buy now" an order is automatically created, which will be sent to the delivery address you have provided and for which a payment is made with the specified payment method.
The confirmation of receipt of your order will be sent by e-mail immediately after sending the order. We accept your order within 2 days by us or AbeBooks on our behalf submitting/issuing a declaration of acceptance or shipping confirmation in a separate email or, if applicable, the payment transaction is carried out by the service provider or the selected payment service provider. The time of execution of the payment transaction depends on the respective selected payment method (see under "Payment"). The relevant alternative for you depends on which of the listed events occurs first.
3. contract language, contract text storage
The language(s) available for the conclusion of the contract: German
We store the text of the contract on our systems, which, however, are not accessible to you.
However, you have the possibility to view your last orders via your AbeBooks account. The full text of the contract is not accessible there.
4. delivery conditions
Shipping costs will be added to the indicated product prices. You can find out more about the amount of the shipping costs at the offers.
5. payment
The payment processing is done by AbeBooks. You can pay the invoice amount by credit card.
6. retention of title
The goods remain our property until full payment.
7. transport damage
If goods are delivered with obvious transport damage, please complain about such defects to the deliverer as soon as possible and contact us immediately. Failure to make a complaint or contact us has no consequences for your legal claims and their enforcement, especially your warranty rights. However, they help us to be able to assert our own claims against the carrier or the transport insurance.
8. warranty
The statutory liability for defects shall apply.
Customer service: Phone number: 0049 (0) 30/488288200
9 a.m. to 6 p.m., e-mail: service@momox-shop.uk
9. liability
For claims based on damage caused by us, our legal representatives or vicarious agents, we shall always be liable without limitation - in the event of injury to life, limb or health - in the event of intentional or grossly negligent breach of duty - in the event of warranty promises, insofar as agreed, or - insofar as the scope of application of the Product Liability Act is opened. In the event of a breach of essential contractual obligations, the fulfillment of which is a prerequisite for the proper execution of the contract and the observance of which the contractual partner may regularly rely on (cardinal obligations) due to slight negligence on our part, on the part of our legal representatives or vicarious agents, liability shall be limited to the amount of the damage foreseeable at the time of the conclusion of the contract, the occurrence of which must typically be expected. Otherwise, claims for damages are excluded.
10. dispute resolution
The European Commission provides a platform for online dispute resolution (ODR), which can be found here: https://ec.europa.eu/consumers/odr/. Consumers have the possibility to use this platform for the settlement of their disputes.
To settle disputes arising from a contractual relationship with a consumer or whether such a contractual relationship exists at all, we are obliged to participate in dispute resolution proceedings before a consumer arbitration board. The responsible body is the Universalschlichtungsstelle des Bundes am Zentrum für Schlichtung e.V., Straßburger Straße 8, 77694 Kehl am Rhein, www.verbraucher-schlichter.de. We will participate in a dispute resolution procedure before this body.
11. protection of minors
If your order includes goods whose sale is subject to age restrictions, we ensure that the customer has reached the required minimum age by using a reliable procedure involving a personal identity and age check. The delivery person will hand over the goods only after the age check has been carried out and only to the customer in person.
Delivery to packing stations is not possible in this case.