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 (Reference No. 1). Writer Bio
