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

20 minutes (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:

Related Courses

Learn practical ways to apply AI to save time, spark creativity, and make smarter decisions.
4 videos
27 min
Learn simple desk-friendly habits to reduce strain, improve posture, and stay comfortable during long hours at your workstation.
1 videos
2 min
Learn what stress really is, why it matters, and how to manage it through practical strategies that boost resilience and support sustainable performance.
4 videos
9 min
DEI unlocks innovation & fairness at work. Learn how to build a culture where everyone thrives ethically and profitably.
1 videos
2 min
Learn how stakeholder buy-in turns ideas into action through trust, alignment, and strategies that build lasting support.
3 videos
8 min

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