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

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

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 (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

Designed For:

All CPAs