Contents
Getting Started With AutoFilter. 6
Searching for P.O. Boxes. 7
Text Filters. 8
Checking EIN Numbers. 10
Missing EIN or Telephone
Number. 12
Review Questions. 14
Reviewing Items Below a
Review Threshold. 14
Dates. 18
Rounding. 25
Using Arrays. 26
Comparing Lists Using Arrays. 28
TEXT FUNCTIONS. 30
Range Names. 31
Identifying Duplicates in a
List. 34
Remove Duplicates. 36
Duplicates and Conditional
Formatting. 36
Review Questions. 38
Gaps in Sequence Using If
Statements. 38
Benford’s Law.. 41
Review Questions. 50
CPE Exam- Fraud Audit
Techniques using Excel 51
Glossary. 55
Index. 56
Answers to Review Questions. 57