Arrays: A Powerful Excel Tool (Currently Unavailable)

Author: Patricia McCarthy, Joseph P. Helstrom

CPE Credit:  2 hours for CPAs

Arrays are a powerful Excel tool that few people know about. It allows you to take multiple steps and consolidate them into one. If you are doing an IF statement in a separate column and then copying it down and then summing or averaging the results - an array will let you do it all in one step.

Do you sit there and delete error values in a column so that you can sum them? This will show you a more efficient way. Do you need to compare 2 lists and see what is different on one from the other? Yes an array simplifies the process.

Note: This course uses Excel 2003/2007

Publication Date: June 2012

Number of Pages: 41

Designed For
Practitioners at all levels who are interested in furthering their knowledge of Excel functions to increase their proficiency and productivity in the workplace.

Topics Covered

  • What is an Array
  • Summary Operation
  • Applying Constants
  • Using Defined Names
  • Sum and IF in Arrays
  • Array with a Nested IF
  • Sum and IF with more than 2 Criteria
  • Comparing Lists
  • Other Uses of ISERROR
  • Other Uses of Arrays

Learning Objectives

  • Gain an understanding of how arrays work
  • Understand how to utilize arrays in the workplace

Level
Intermediate

Instructional Method
Self-Study

NASBA Field of Study
Computer Science (2 hours)

Program Prerequisites
A working knowledge of Excel functions

Advance Preparation
None

">
 Chat — Books Support