Using Excel as an Audit Software

This content was specifically designed for use and free distribution by



A community of professionals helping you to maximize the benefits of audit software






Using Excel as an Audit Software

By Richard B. Lanza, CPA/CITP, CFE, PMP
www.auditsoftware.net

 TABLE OF CONTENTS

COPYRIGHT PAGE 3
DOCUMENT PURPOSE / CALL FOR FEEDBACK 4
LIMITATIONS OF EXCEL AS AN AUDIT SOFTWARE5
AUDIT SOFTWARE TESTS6
1. Analytical Tests
1.1 Horizontal Analysis
1.2 Vertical Analysis7
1.3 Ratios7
1.4 Trend analysis8
1.5 Performance Measures8
1.6 Statistics8
1.7 Stratifications10
1.8 Aging11
1.9 Benford’s Law11
1.10 Regression 12
1.11 Monte Carlo simulation13
2. Data Management/Analysis Reports 14
2.1 Append/Merge15
2.2 Calculated Fields/Functions16
2.3 Cross Tabulate 17
2.4 Duplicates20
2.5 Extract/Filter21
2.6 Export23
2.7 Gaps23
2.8 Index / Sort23
2.9 Join / Relate24
2.11 Summarize28
ABOUT THE AUTHOR 29
Using Excel as an Audit Software 2
© 2006 - Richard B. Lanza Copyright Page

© 2006 - Richard B. Lanza
No part of this publication may be reproduced in any form without permission in writing from Richard B.
Lanza.


Limitation of Liability / Disclaimer of Warranty
The author, Richard B. Lanza, has used his best efforts in preparing this publication and is not responsible
for any errors or omissions. He makes no representations or warranties with respect to the accuracy or
completeness of the contents of this document and specifically ...