Auditing Excel Spreadsheets

Learn how to Audit Excel Spreadsheets using only Microsoft tools
4.8 (9 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,542 students enrolled
$100
Take This Course
  • Lectures 10
  • Contents Video: 1 hour
    Other: 1 min
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2014 English

Course Description

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.

What are the requirements?

  • You should alread have experience working with Excel
  • Any version of Excel to use th GOTO Special and Auditing Tools
  • Excel 2013 Professional Plus Edition for Spreadsheet Inquire
  • You should already be familiar with Auditing theory and techniques

What am I going to get from this course?

  • Identify Spreadsheet Risks in your organization and be able to introduce controls to reduce these risks
  • Identify and understand how the common type of Spreadsheet Fraud are committed
  • Use GOTO Special with confidence when carrying out a spreadsheet audit
  • Use the auditing tools in Excel with ease
  • Use Excels Inquire add in with confidence when auditing spreadsheets
  • Use spreadsheet compare to compare 2 versions of a workbook
  • Understand Microsofts Discovery and Risk assestment server Software
  • Be able to apply spreadsheet protection and also hack certain protection
  • Be confident around the area of Spreadsheet Auditing

What is the target audience?

  • This course is meant for those involved in the Audit of Spreadsheets, and also those with interests in the areas of Excel and Fraud
  • This course is not a traditional functions and formulas based course but instead this course covers theory on Spreadsheet risks and controls along with Theory on Spreadsheet fraud
  • After the theory, we will then jump into Excel and have a look at the tools available to audit spreadsheets
  • This course is suited to those with an interest in Excel, Fraud and Audit and is well suited for Accountants, Auditors, Internal Auditors, Business Analysts, Finance staff, Banking staff, Management and those involved with Compliance and Risk assestment
  • This course is not for you if you are looking to learn advanced Excels formulas

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Auditing Excel Spreadsheets
01:36

A quick breakdown of what will be covered in the course

04:34

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

04:36

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

09:42

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.

12:27

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.

04:05

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

02:55

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.

03:21

Course Summary

3 questions

This multiple choise test will help you reinforce your learning. I hope that you will not skip this session.

Section 2: Bonus Lectures
13:26

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

Bonus
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Paula Guilfoyle, CPA Accountant, Online Educator & Life Long Learner

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.

Ready to start learning?
Take This Course