Chat with us, powered by LiveChat

Excel: Audit & Analytical Uses for Filters & Tables (AUMC)

Customer Rating
Field of Study
Computer Software & Applications
Level
Overview
Credits
1
Qualifies For
CPE



Price:  $0

Attention: this course is FREE for new customers who wish to try CPA Self-Study. However, you do need to register so that you can receive a CPE certificate for the course.

This course provides a brief introduction to some of the Excel features that can assist you in auditing and analyzing large volumes of data. It is a 1-credit overview-level course. The screen shots shown are in most cases Excel 2016 unless there are significant differences in versions.

This course provides step-by-step instruction and Excel practice exercises, as well as answer files.

Looking for more topics? Check out our full range of excel CPE courses.

Additional information

Credits

1

Format

Self-Study Download

Company Code

Self Study

Yellow Book Approved

0

CFP Approved

0

IRS Approved

0

CTEC Approved

0

Field of Study Credits

Computer Software & Applications (Non-Technical) (1)

Field of Study Department

Computer Software & Applications (Non-Technical)

Course Version

2019-01

CPE Approved

1

Pre-requistes:

Excel 2007 or higher is required

Knowledge Level:

Overview

Major Topics:

  • Getting Started With AutoFilter
  • Adding Subtotals to Only the Visible Data
  • 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

Learning Objectives:

  • 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

Designed For:

All CPAs
Follow by Email
Facebook
Twitter
LinkedIn