Chat with us, powered by LiveChat

Arrays: A Powerful Excel Tool (RYMC)

Customer Rating
Field of Study
Computer Software & Applications
Level
Intermediate
Credits
3.0
Qualifies For
CPE



Price:  $49.0
Arrays in Microsoft Excel are a very powerful, yet generally unknown tool. Using array formulas allows you to perform tasks that may currently take more than one step, and consolidate them into one step, improving efficiency. Array formulas make it easier to perform tasks such as comparing and evaluating lists, mathematical operations, quantifying errors and identifying duplicates in data. Excel also has built in functions that may be used to work with arrays. These functions include SUMPRODUCT, the combination of the INDEX and MATCH functions and the AGGREGATE function. These functions will also be discussed. There is an associated Excel exercise file.

Additional information

Credits

3.0

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

Field of Study Department

Computer Software & Applications (Non-Technical)

Course Version

2019-01-01

CPE Approved

1

Pre-requistes:

None

Knowledge Level:

Intermediate

Major Topics:

  • Overview of Array
  • Various uses for Arrays

Learning Objectives:

  • Use array formulas in mathematical operations
  • Create and use defined range names
  • Describe the MA

Designed For:

All CPAs
Follow by Email
Facebook
Twitter
LinkedIn