4.2  52 reviews on Udemy

Auditing Excel Spreadsheets

Learn how to Audit Excel Spreadsheets using only Microsoft tools
Course from Udemy
 1750 students enrolled
 en
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

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.

Auditing Excel Spreadsheets
$ 94.99
per course
Also check at

FAQs About "Auditing Excel Spreadsheets"

About

Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.
DISCLOSURE: This page may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

SOCIAL NETWORK