Arrays: A Powerful Excel Tool
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.

Course Publication Date: February 06, 2017

This course is available with NO ADDITIONAL FEE if you have an active self study membership or all access membership or can be purchased for $15.00!

Author:Mill Creek Publishing
Recommended CPE:1.50
Delivery Method:QAS Self Study
Level of Knowledge:Overview
Advanced Preparation:None
Recommended Field of Study:Computer Software and Applications
Learning Objectives
  • 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.

CPE Depot Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website:

Sponsor Number: 109423


Search Courses

Group Plan

Group plans are convenient and cost effective!

Authors Wanted

We are looking for authors!