K2's Array Formulas - Exceptional Power at Your Finger Tips
Earn 2 CPE Credits!
Exam price $89.
OR

All of our materials/exams are NASBA and the AICPA approved the revisions to the Statement on Standards for Continuing Professional Education (CPE) Programs (Standards).

Your Exam purchase includes

  • Course materials (video & PDF version)
  • Unlimited attempts to complete exam
  • Instant grading & certificate of completion
  • One year access to complete your CPE
  • Instructor discussion forum



Overview

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
  • None
  • Fundamental knowledge of computer operations and Microsoft Office Excel
  • Intermediate
  • 103648

No Reviews