ABSTRACT
This chapter examines the use of Excel as a powerful data analysis tool. Properly used, data may be sorted, filtered, extracted to pivot tables, or utilized in what-if analyses in order to determine the probable effectiveness of the implementation of audit recommendations. This may be coupled with financial, statistical, and engineering data analysis, facilitating analysis using advanced techniques, such as analysis of variances (ANOVA), exponential smoothing, correlation, and regression analyses.
