Arrays: A Powerful Excel Tool
SKU: 02-053-01-CPE
Credit Hours: 2
Level: Basic
CPE Category: Computer Software and Applications-Non Technical
Requires Prerequisites or Advanced Preparation: No
Delivery Method: PDF
Instructor: Patricia McCarthy, MBA
Course Description:
This course will explain using array formulas allows you to perform tasks that may currently take more than one step and consolidate them into one step, improving efficiency.
At the end of this course, students will 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