A search engine of every*online CPE course.

Arrays: A Powerful Excel Tool - 2016

Provided by:

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.

Learning Objectives

Course Learning objectives Upon completion of this course, you should be able to: Use array formulas in mathematical operations Create and use defined range names Describe the MATCH function and its uses in comparing lists Define the use of ISNA and ISERROR to ignore and quantify errors in data Recognize the use of COUNTIF as an array function to identify duplicates in data Describe the SUMPRODUCT function and its uses when multiplying arrays Recognize the combined INDEX and MATCH function as a tool to insert information or match two lists Identify the uses of the AGGREGATE function

Ratings and Reviews

To review this course, please login.

Please Review This Course

Overall Quality

Instructor

Usefulness

150 Characters Minimum

Submit
Course Information

Overall Quality

(0)

Instructor

(0)

Usefulness

(0)
Add to Transcript Write Review

Learning Format 3 Hours
Self-Study / On-Demand

Credit Type(s)
Specialized Knowledge

Knowledge Level
Overview