Audit and Analytical Uses for Filters and Tables in Excel

Course Description:

This course provides a brief introduction to some the Excel filter and table features that can assist you in auditing and analyzing large volumes of data. It is an overview level course.

The course provides step by step instruction and Excel practice exercises.

Learning Objectives:

Upon successful completion of this course, participants will be able to:

• Recognize how to use auto filter and apply filters
• Recognize the steps needed to create a table
• Recognize the steps needed to remove duplicates from a table
• Identify and use a pivot table