\n\t

Why should I check\u00a0my spreadsheet?<\/span><\/span><\/p>\n

It is estimated that 88% of all spreadsheets have errors in them<\/em><\/span><\/a>.\u00a0Studies show that, not only are these mistakes detrimental in terms of loss of time and money, but also damaging in terms of ruined reputation and job losses.<\/span><\/p>\n

What can you do to avoid spreadsheet errors?<\/span><\/span><\/p>\n

Any spreadsheets needs to be checked and double checked. Visual\u00a0review of the spreadsheet and double checking formulas are key to minimising mistakes. The person who developed the spreadsheet\u00a0must do their own checks. But it is also\u00a0of paramount importance that the spreadsheet is peer reviewed before it is accepted.\u00a0<\/span><\/p>\n

The tools available within Excel to check and audit\u00a0spreadsheets are outlined in the following post. Check and Audit excel Spreadsheets<\/a><\/em><\/span>.\u00a0The post also includes introduction to using the XL-Viking check and display functions.<\/span><\/p>\n

The XL-Viking Excel Formula Check, Audit &\u00a0Display Add-in<\/span><\/span><\/p>\n

The XL-Viking add-in contains Excel formula check and\u00a0auditing functions. These functions will display the actual values or variables of the entire formula. This is extremely useful, not only in terms of ensuring accuracy and validity of\u00a0the excel formula, but also in terms of reducing the checking and auditing\u00a0time of\u00a0the calculations. <\/span><\/p>\n

This is how it works;<\/span><\/p>\n