Arrays: A Powerful Excel Tool
SKU: CPE-07-053
Credit Hours: 3
Level: Basic
Field of Study: Computer Software and Applications-Non Technical
Requires Prerequisites or Advanced Preparation: No
Delivery Method: Online PDF
Instructor: Patricia McCarthy, MBA
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