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

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



Price:  $ 9.99

This course is Free however you do need to register so that you can receive a certificate for the course.
This course provides a brief introduction to some the Excel features that can assist you in auditing and analyzing large volumes of data. It is an 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.

Additional information

year

2019

version

01

Credits

1

Company Code

Self Study

Format

On Demand

Yellow Book Approved

0

CFP Approved

0

IRS Approved

0

CTEC Approved

0

Field of Study Credits

Computer Software & Applications (1)

Field of Study Department

Computer Software & Applications

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