14198492014643

5 Ways to Reduce Mistakes at Work (Excel)

You’ve spent a few days on this spreadsheet you put together. It’s really elaborate. You think you’ve put your best work in it.Then you and your boss go through this work together.

Boss:” Okay.. this number doesn’t look right? You are saying I paid that much? No way that’s right” He is looking at one of the Expense figure in the sheet. There are at least 100 numbers on the screen.

Now you are shaking…because you are not sure..

Then he goes on to check if that number is right. It turns out…it’s not. You know realized there is an linkage error in one of your sheet.

Boss:”It’s fine. Why don’t you fix this and we can look at this again.”

You walked out of the office..feeling guilty.

That guilty feeling would come up again later in the performance review meeting. If you know this feeling, you are not alone. Here are 5 things you can do in Excel to dramatically reduce the chances of errors in Excel.

 

Check and Balance

This would probably be obvious to a lot of people. I was an accountant. So check and balance is my habit. But I used to think it was a waste of time to calculate the same thing twice. However, if you just calculate it once. There is no guarantee that your calculation is right. Whenever you are going to present a really important number, ask yourself, how can you be sure that result is accurate. If you can reach the same result in a different way, you should have the confidence to say that is accurate. So try to reach these output numbers in two different ways to make sure they are correct. Or at least, find another way to get a correct range of your output numbers. So that at least you know your ending results are in the reasonable range, avoiding embarrassing stupid mistakes.

check&balance

Evaluate Formula

Once you find there is some inconsistencies. The next thing is to find the error. Chances are that errors are buried in one of the complicated formulas. Here is a handy function to run the complicated formula step by step: Evaluate Formula function.Evaluate formula

Trace Dependent/Precedent

Using the Evaluate Formula you can know whether the formula is calculating right. If your formula is not that complicated, but you suspect the linkage may be causing the error. This function is the way to check whether cells are linked as you want. For example, I may made a temporary change before on the cell reference, but I forgot to change back. This function can help identify abnormal linkages.

3

 

Split Screen

When I am checking my results. If two results should be equal when the spreadsheet should be correct, but two set of results are far away from each other in the page. You are going to have a hard time scrolling up and down all the time. If you are lazy about it…this will lead to…mistakes…This trick can save you a lot of time since you can then compare them easily.

split

Memorize key figures

This is not an Excel trick.  ..Just something I notice that can separate top performers from others. Also if you are confident that you are sensitive to numbers, you can skip this part. I can’t remember a number unless I try hard to. If you are like me, read along. You know someone knows what he is talking about, if he can tell you the number quickly. We all know well-reasoned arguments. In the business world, a lot of the reason is based on numbers. However, analysts are easily stuck in the doing. Most of the energy is spent on nitty-gritty things, such as formatting, cell linkages, and it’s easy to lose the sight of the big pictures. The solution is to memorize key figures. Try to figure out his or her thinking process first. There must some numbers they remembered based on their experience, then they have some rough ideas about certain numbers in your spreadsheet. That’s why they can find mistakes in your work. These certain numbers are the ones that you need to memorize.     

So these are some tricks you can apply immediately! Nobody want unnecessary mistakes. If you like this article please do subscribe to my email list or visit BestAnalyst.org to see other posts.

26 comments

  1. Still, folks march into drugstores or their physicians’ offices every day asking
    for Dr. Oz-supported treatments—even when these treatments are backed by the barest of signs or none at all.

  2. This is why I decided to examine only the very best (as well as a few not so terrific ones making it reasonable) and also offer you in-depth reviews with information on just what you obtain, ways to take care of your
    vape, what type of choices you’ll have, and also how ideal to use them all.

  3. If you possess your own nutritional supplement shop or you’re looking for an effective
    weight-loss supplement, then the two you should be looking at is ketone and garcinia cambogia.

  4. Areas using the key components in Garcinia Cambogia+ Gummies (frauenmantle, wild olive, cormino seed extract, and horsemint leaf extract) along with calorie-reduced diet lost on average 20.94 and 16.50 pounds in 12- and 8-week studies.

  5. Should you be looking to buy the infusion, remember, it’s wise to choose a product that
    contains 100% pure Garcinia that you reap all the preceding advantages of the natural infusion.

  6. Accurate Locksmithing & Security is a service provider to prominent institutions and is completely compliant with
    both health and safety regulations, along with safety
    and security clearance requirements for workers that should
    work in delicate areas.

  7. Yet a great deal of individuals do not know that professional locksmith professional
    experts Burwood and also locksmith professional experts Strathfield also have knowledge
    in several various other locations.

  8. Accurate records of secrets and also that has
    them can be easily maintained and preserved, eliminating
    the possibility of duplicate secrets being made without authorisation.

  9. Many locksmith professionals also work on any existing door equipment, consisting of door closers, hinges, electrical strikes, and also structure
    repair services, or service digital locks by making secrets
    for transponder-equipped automobiles as well as applying access control systems.

  10. Today is developed to provide the customer the approaches and strategies to get one of the
    most from the lishi picks and also decoders as well as together with our course handouts and also reference/training
    literary works, the expertise to ideal these methods.

  11. I have to thank you for the efforts you have put in writing this site.
    I am hoping to check out the same high-grade blog posts from you
    later on as well. In fact, your creative writing abilities has motivated me to get my very own site now 😉

  12. All our master locksmith and also safety work is guaranteed
    as well as the criteria are validated by the participants organization BS3621 & ISO9002.

  13. Suitable rim locks (Yale kind) as a locksmith professional you will be required to
    fit locks of every kind nevertheless Edge locks are very
    common on wooden doors consequently you will certainly be educated the right
    way to do it and have the ability to fit them to a specialist standard.

  14. With havin so much written content do you
    ever run into any problems of plagorism or copyright infringement?

    My blog has a lot of completely unique content I’ve either written myself or outsourced but it
    looks like a lot of it is popping it up all over the internet without my
    agreement. Do you know any methods to help protect against content from being stolen? I’d truly appreciate it.

  15. It’s genuinely very complicated in this busy life to listen news on Television,
    thus I only use world wide web for that reason, and obtain the most
    recent information.

Leave a Reply

Your email address will not be published. Required fields are marked *