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
