Webcast: K2's Harness the Power of Array Formulas (XKHPA117)
Tell a Friend About This EventTell a Friend
 

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 y

8/8/2017
When: 08/08/2017
9:00 AM until 11:00 AM
Where: Webcast
K2 Enterprises
United States
Presenter: Mac McClelland


Online registration is closed.
« Go to Upcoming Event List  

Acronym XKHPA117
CPE 2 hours
Vendor K2 Enterprises
Category
Management
Level Intermediate
Prerequisite Good working knowledge of Excel with a fundamental understanding of Excel formula building
Adv Prep None
Yellow Book? No
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
Registration
Member $79
CPA Non-Member $104

The Member rate applies to LCPA members, other state society members, and non-CPA staff of LCPA members. To register online, use the ‘Register’ button above. To register by phone, call the LCPA Member Service Center at 800.288.5272 or 504.464.1040, Monday through Friday, 8am to 5pm.

Course Description

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.

Objectives

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

Topics

  • 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