How to audit your Excel files to identify errors or mistakes

About this course

Are your spreadsheets important? If yes, then this course is MUST for you. It describes good practices that all spreadsheet users should follow.Use this course to learn how to avoid the most common errors and to make future development easier. If you are a software tester or a manager of end user-computing, it gives you techniques in checking spreadsheets for accuracy and soundness. If you are an auditor looking for evidence of fraud, such as deliberately concealed data or functionality, you will also benefit from knowing the many ways in which data can be hidden or calculation methods subverted.   This course was created in response to experssions of concerns by managers or auditors about risk to the business from a pervasive dependence on spreadsheets. This course can be considered as a guide to developing high quality spreadsheets, steps to perform for auditing or reviewing spreadsheets created by someone else to ensure accuracy. This course is of interest to anyone who relies on data analysis performed in spreadsheets or models built in it for decision making. The techniques described include areas such as ensuring that the objectives of the models are clear, defining the calculations, good design practice, testing and understanding and presenting the results from spreadsheet. From this course your will learn how to:Increase efficiency by avoiding reworkDiscover Powerful formula auditing techniquesFoil attempts to conceal data and formulas from youReduce worry about costly and embarrassing mistakesCreate spreadsheets faster by avoiding wasted time from lack of specificationPresent results with more confidence knowing that you have checked for errors.In this course we will first understand various frequently used keyboard shortcuts. I have provided a cheat of all keyboard shortcut combination available i

Course objectives

• develop high-quality spreadsheets
• ensure accuracy in data analysis
• reduce costly mistakes
• enhance spreadsheet presentation skills