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