Fraud Blocker
Announcement bar drops down here to inform users of the latest news and sales!

Business microlearning from Japan’s No1 MBA

Edge

Excel Functions & Formulas: Array Formulas

00h 20m (1 section)

Course Description

Are you frustrated with the complexity of calculations when dealing with large arrays of data?
Array formulas help solve intricate problems with precision and efficiency.

This course covers how to:
• Set up array formulas,
• Count the numbers of errors and unique values in an array of data,
• Use array formulas to count instances/only sum values when “or” criteria hold true,
• Sum every nth row, several largest numbers and a range of data with errors correctly,
• Find the most frequently occurring word,
• And, solve a system of linear equations.

Join us, and explore how array formulas manipulate data dynamically and perform complex calculations!

Share this course:

Start your free trial

Sign up to watch the rest of this course for free - no strings attached!
Continue with a subscription of USD 16.67 / month* after free trial ends
*USD 99.99 billed every 6 months