Array formulas, which work on arrays of data rather than individual cells or ranges, allow users to make calculations that would otherwise be impossible with ordinary formulas. They can perform multiple discrete calculations in a single cell or return results to multiple cells. For example, an array formula can be used to round off totals or subtotals, a feat that is impossible to accomplish with an ordinary formula. Don't miss this opportunity to harness the power of array formulas to improve your analytical abilities in Excel.
- Explain array formulas and how they differ from ordinary formulas
- List the types of arrays that exist in Excel
- Identify an array formula from the Formula Bar
- Compose array formulas from the keyboard
- Describe common accounting situations where array formulas would be useful
- Fundamental knowledge of computer operations and Microsoft Office Excel