K2's Harness the Power of Array Formulas

  • Tuesday, December 12, 2017

    10:00am – 12:00pm
  • 2
    Computer Software and Applications

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.


Upon completing this course, you should be able to:

  • Explain array formulas and how they differ from ordinary formulas
  • Identify an array formula from the Formula Bar
  • Compose array formulas from the keyboard
  • Describe common accounting situations where array formulas would be useful


  • Basic syntax of array formulas and how to enter them from the keyboard
  • Creating array formulas useful to accountants and other financial professionals
  • Using SUMPRODUCT as an alternative to array formulas in some situations
  • Additional Information

    Designed For

    Accountants and business professionals who want to better understand array formulas and put their power to use in common accounting and business scenarios


    K2 Enterprises

    Advanced Preparation



    Good working knowledge of Excel with a fundamental understanding of Excel formula building

    Field of Study

    Computer Software and Applications

    Course Number


    Level of Knowledge


    Add to Cart

    View All Courses