Course Information
Arrays: A Powerful Excel Tool
Course Information
| Title: | Arrays: A Powerful Excel Tool |
|---|---|
| Category: | Computer Software |
| Field of Study: | Computer Software and Applications |
| Course Code: | S017-0515 |
| CPE Credits: | 2.0 |
| Price: | 19.95 |
Description
Description:
Course Description 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.
Delivery Method: Online Interactive Self Study
Level: Overview
Prerequisites: None
Advanced Preparation: None
Course Details
Category: Computer Software
Field of Study: Computer Software and Applications
Passing Score: 70%
Publication Date: 04/05/2017
Technical Details: CA, FL: Computer Software and Applications are technical subjects TX: Computer Software and Applications are non-technical subject for TX. NY: Advisory Services includes Computer Software and Application
For More Detail:
If you are unable to view PDF then right click the mouse and click save link as
Objectives
Objectives:
1. Recognize array formulas in mathematical operations 2. Identify the MATCH function and its uses in comparing lists 3. Recognize the use of ISNA and ISERROR to ignore and quantify errors in data 4. Recognize the use of COUNTIF as an array function to identify duplicates in data 5. Identify the SUMPRODUCT function and its uses when multiplying arrays 6. Recognize the combined INDEX and MATCH function as a tool to insert information or match two lists 7. Identify the uses of the AGGREGATE function
For More Objectives:
If you are unable to view PDF then right click the mouse and click save link as
Profession
NASBA: Yes
QAS: Yes
CPA: Suitable for all CPAs
IRS: No IRS credit for Enrolled Agents.
Profession Identifiers: CPA