Home
0
Home
Cart Empty | Login/Register  Login/Register
Search Courses List  >  Course Details
Use Landscape to see Search/Filter
Item Types:
Field of Study:
Authors:
CPE Hours:
Keyword:
Course Details

Audit and Analytical Uses for Filters and Tables in Excel (Course Id 2855)

New / QAS / Registry
  Add to Cart 

Author:

 Joseph P Helstrom, CPA

Course Length:

 Pages: 27 ||| Word Count: 4351 ||| Review Questions: 4 ||| Final Exam Questions: 5

CPE Credits:

 1.0

IRS Credits:

 0

Price:

 $12.95

Passing Score:

 70%

Course Type:

 Text
Audit and Analytical Uses for Filters and Tables in Excel - CPE course for CPAs

Technical Designation:

 NonTechnical

Field Of Study:

 Computer Software & Applications

Approved Audience:

 NASBA QAS - NASBA Registry

Key Takeaways:

This overview level course introduces Excel AutoFilter features, tables, duplicate removal tools, and pivot tables for auditing and analyzing large volumes of data.

  • Provides step by step instruction on using Excel AutoFilter features to organize and analyze large datasets.
  • Covers Excel tables and duplicate removal tools for cleaning up data before analysis.
  • Includes Excel practice exercises and answer files alongside the step by step instruction.
  • Worth 1.0 CPE credit in Computer Software and Applications as a self study course, requiring a 5 question final exam preceded by 4 review questions (optional) and a 70% passing score.

Frequently Asked Questions:

The Audit and Analytical Uses for Filters and Tables in Excel course starts with AutoFilter, showing how to apply and work with multiple filters at once.

This course teaches the steps needed to remove duplicates from a table, in addition to creating tables and adding total rows.

This course introduces pivot tables as a tool for identifying and summarizing large volumes of audit data.

This course is a NonTechnical, self study text course worth 1.0 CPE credit in Computer Software and Applications. It requires a 70% score on a 5 question final exam after 4 review questions (optional). CPEthink is approved by NASBA as a CPE sponsor and lists this course on the NASBA site as a courtesy for CPAs to search https://nasba.org.

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 as well as answer files.

Usage Rank:

 10000

Release:

 2026

Version:

 1.0

Prerequisites:

 None.

Experience Level:

 Overview

Additional Contents:

 Complete, no additional material needed.

Additional Links:
Internal: Excel PivotTable Basics CPE Course
Internal: Organize and Analyze Data with Pivot Tables Excel CPE
External: Create a PivotTable to analyze worksheet data
External: Microsoft Excel

Advance Preparation:

 None.

Delivery Method:

 QAS Self Study

Intended Participants:

 Anyone needing Continuing Professional Education (CPE).

Revision Date:

 15-May-2026

NASBA Course Declaration:

 Participants must complete the final examination within one year of purchase and with a minimum passing grade of 70% or better to receive CPE credit unless otherwise noted on the Course History page (i.e. California Ethics must score 90% or better). After logging in click on the Course History links on your My Courses page for the Begin date and Expire date for the Final Exam.

Keywords:

 Audit and Analytical Uses for Filters and Tables in Excel - CPE course for CPAs

Learning Objectives:

Course Learning Objectives

Upon completion of this course, you should be able to:

  1. Recognize how to use auto filter and apply filters
  2. Recognize the steps needed to create a table 
  3. Recognize the steps needed to remove duplicates from a table
  4. Identify and use a pivot table

Course Contents:

Chapter 1 - Audit and Analytical Uses for Filters and Tables in Excel

Course Learning Objectives

Getting Started With AutoFilter

Working With Multiple Filters

Other Cool AutoFilter Options

Getting Started With Tables

Adding a Total Row

Other Total Functions

Adding a Column

Format Styles

Remove Duplicates

Pivot Tables

Review Questions

Glossary
Click to go to: Excel Courses for Accountants | Excel CPE Courses for CPAs
Thank you for taking one of our free courses. We would like to be able to let you know when we add free courses or have special offers and will never spam you or share your address with anyone. If you are Ok with that please reply with "Ok" or if not please reply "No Thanks". Either way enjoy your free CPE course.
  
Exam completed on .

Do you want to add the course again?
  
     
Our IRS Approved Continuing Education Provider number is 1SXC8 NASBA QAS Self-Study sponsor Id is 108299 Customer Reviews 5 Star Excellence award from Shopper Approved for collecting at least 100 5 star reviews Click to verify BBB accreditation and to see a BBB report. View TrustedSite Certification
Trustpilot
Tin-Tin C. from bought 2 courses 1 hour ago.  |||  Want A Discount? - Click Here ||| Brandon R. from bought 1 subscription 3 hours ago.  |||  Want A Discount? - Click Here ||| Laneita L. from AL bought 1 course 4 hours ago.  |||  Want A Discount? - Click Here ||| Reba K. from MD bought 1 course 5 hours ago.  |||  Want A Discount? - Click Here ||| Gary G. from CA bought 1 subscription 7 hours ago.  |||  Want A Discount? - Click Here ||| Guy H. from CA bought 1 course 8 hours ago.  |||  Want A Discount? - Click Here ||| Shane S. from KY bought 1 subscription 10 hours ago.  |||  Want A Discount? - Click Here ||| Jonathan S. from AL bought 1 course 11 hours ago.  |||  Want A Discount? - Click Here ||| Shanedra H. from GA bought 1 course 1 day ago.  |||  Want A Discount? - Click Here ||| Elizabeth C. from NC bought 1 subscription 1 day ago.  |||  Want A Discount? - Click Here ||| 
Remove Marquee
Copyright © 2026 Cpethink.com

Privacy | Refunds | Terms | Blog | Site Map | Contact Us | FAQs | Login | NASBA Id 108299 | IRS Id 1SXC8 | Cage Code 874S4