Managing Data with Excel (TAMC)

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



Price:  $44.99

This course shows you how to take basic rows and columns of data and to manage it and turn it into useful information that can be incorporated into the decision making process. We start with Excel’s simple basic Database features of sorting and filtering data and then take a look at subtotals and nested subtotals. From there, we explore one of Excel’s most exciting features – the pivot table. The course than discusses how to use Database functions and apply conditional formatting to data.

Additional information

Credits

5

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

Field of Study Department

Computer Software & Applications

Course Version

2022-01

CPE Approved

1

Pre-requistes:

Basic file management skills (open/close) are assumed. Basic Excel skills of navigation, using cell references and basic formulas such as =SUM() are assumed.

Knowledge Level:

Overview

Major Topics:

  • Overview of Excel’s data features 
  • Sorting functions
  • Filtering Data 
  • Outlines 
  • Subtotals 
  • Pivot Tables Displaying Data

 

 

Designed For:

All CPAs