## Arrays: A Powerful Excel Tool

Price: \$29.85

CPE Credits: 3.0

Category: ,

Course Number: CXARRYMC

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. There is an associated Excel exercise file. Table of Contents
Student Comment : “I must tell you that I loved the course!!” C.L., Texas
Delivery Method: Online QAS Self Study.

Level: Overview (Intermediate recommended)

Version: Excel 2007-Excel 2016

Prerequisites: See version comment

Publication: January 2015
Update: November 2016

Format: PDF and Exercise File
Pages: 67

Exam Policies: Exam may be retaken. Course must be completed within one year of purchase.

By the end of the course participants should be able to:• Use array formulas in summary operations

• 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

“This Intermediate course in Excel on Arrays was excellent.” – Warren L. 11/2016

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. There is an associated Excel exercise file. Table of Contents
Student Comment : “I must tell you that I loved the course!!” C.L., Texas
Delivery Method: Online QAS Self Study.

Level: Overview (Intermediate recommended)

Version: Excel 2007-Excel 2016

Prerequisites: See version comment

Publication: January 2015
Update: November 2016

Format: PDF and Exercise File
Pages: 67

Exam Policies: Exam may be retaken. Course must be completed within one year of purchase.

By the end of the course participants should be able to:• Use array formulas in summary operations

• 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

“This Intermediate course in Excel on Arrays was excellent.” – Warren L. 11/2016

• ” I was able to get a head start on my credit losses research through your CPE self study this past weekend.  Excellent quality format – so much better than some of the other resources I’ve been using lately.”  Dec 12, 2018

- Andrea Ll.

• “always love your site and prompt customer service !! ”  Dec. 2017

- Thank you :)

• Thank you Patricia. I really love your courses. I learned so much about excel this weekend!”

- Connie K.