• 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
    Add to Cart

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

Policies: Click here

Course Details

Author: Joseph Helstrom

Category: Computer Software

Field of Study: Computer Software and Applications

Passing Score: 70%

Publication Date: 04/05/2017

For More Detail: Click here

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: Click here

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.

Start Saving on Your CPE Today!

Join MasterCPE