Name

Analytics Enabled Audit using Excel

Description

Excel has many useful features for auditors. The ability to put data into a spreadsheet and perform different tests and analysis makes Excel a powerful audit tool. It is simple to use and readily available to most auditors. Excel can perform many types of analytical tests including: Benford’s law, horizontal and vertical analytics, ratio analysis, regression analysis, statistics, stratification and aging. It can also perform many types of data analysis, including: append and merge, cross tabulate and pivot table, detect duplicates, and gaps, extract and filter, join and relate, sample, sort, summarize and subtotal

Download this template with steps for analytic enabled auditing using Microsoft Excel

IT Audit Program

Download

This file is only available to premium subscribers or site license users. Please log in or sign up for a subscription to get this file.

Subscription Level

Type

Procedures

Language