Many companies around the globe rely on Spreadsheets to help produce financial information, forecasts, pricing, and costings, and to aid in the decisions made by management. Simply put, spreadsheets are used everywhere. But at what risk to the company or organization?
LEARN HOW TO MINIMISE SPREADSHEET RISK AND MASTER TECHNIQUES USED TO AUDIT SPREADSHEETS IN THIS COURSE
Auditing Excel Spreadsheets is not for everyone, but for those with a keen interest in Excel, Fraud, Auditing or Compliance then then course is for you.
CONTENTS AND OVERVIEW
We will first cover some theory on Spreadsheets Risks and discuss some controls that you can introduce to reduce these risks. Following this will be more theory, this time covering a detailed overview of the types of Spreadsheet Fraud. With the theory finished, we will jump into Excel and look at the following tools and techniques: GOTO Special, Auditing Tools and Excel’s Inquire function. GOTO Special Function has been around for a long time in Excel and quickly allows you select cells in a worksheet based on set criteria. You will have a workbook to download so that you can practice and master this technique yourself. We will also quickly look at the Auditing Tools, which have also been available in Excel for some time. Introduced in MS Excel 2013, Excel Inquire is new. It enables you quickly identify and select areas of risk or interest in a workbook, map workbook relationships and compare two versions of a workbook. Using the workbook provided you can learn to quickly master this tool. Finally, we will have a quick look at Microsoft Discovery and Risk Assessment Server which allows you search for all Excel files on your server, and rank them according to risk. Risk levels are based on Materiality and complexity criteria that you set.
A quick breakdown of what will be covered in the course
In this session we are going to look at the 5 most common Spreadsheets risks and we are also going to look at some ways we can control or minimise these risks
Knowing what to look out for when auditing a spreadsheet will help you as an auditor uncover and identify potential risks in spreadsheets, so we are going to look at the common types of spreadsheet fraud in this session
The GOTO Special and auditing tools have been available in Excel for some time now. The GOTO special tool allows you quickly select and identify chosen aspects of a worksheet and enhance your spreadsheet auditing skills. Download the files Spreadsheet Inq 1 so you can work along with this tutorial. You will also use this workbook in the next tutorial.
Spreadsheet Inquire was introduced with Microsoft Office Professional Plus 2013 & Office 365 Professional Plus editions. In this session we are going to look at this tool in detail, so dont forget to download the file so you can work along too.
One of the problems organisations have is that they do not know where all the workbooks are located, and they don’t know the risk or materiality of these workbooks, so where would they start with an audit. This MS server level control is a good place to start and this session will cover the basics of the Discover and Risk assessment server
Workbooks have life cycles, and each phase has audit implications. Here are some fairly random off-the-top-of-my-head notes that may inspire you.
This multiple choise test will help you reinforce your learning. I hope that you will not skip this session.
In this lecture we will look at how to set up protection in Excel workbooks and worksheets, and we will also see how this can be easily hacked in certain versions of Excel
Paula is a Qualified CPA with over 15 years' experience in the fields of Accountancy, Business Management,Process improvement, Internal Audit, Group accountant, Operations management and Training. All across a broad range of industries and sectors. Paula has been Key Speaker at many Accounting Events where her talks on Excel are received very positively. Taken from her experiences in Accounting and business fields, Paula also has Udemy courses for those wishing to up skill, especially in the area of Spreadsheets, Bookkeeping and Accounting.
Now an E-learning Educator 5+ years, Paula also has a focus on E-learning and online teaching. Drawn from her online teaching experience,Paula has a number of courses available to online teachers to help bridge the skills gap for those that teach or wish to teach online.