Look Who it Was Random video

Excel Magic Trick 944: How To Create Your Own Original Array Formula From Scratch

4,817 views · Published 13 July 2012 · 15:06 · Indexed 24 October 2026

Channel: excelisfun · 2012 · Education

Watch on YouTube

Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT944-945.xlsx

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm
Learn how to take a step by step approach to creating your own array formulas:
1) First: Create calculation long hand
2) Second: Notice Pattern of long-hand formulas and concoct a method to simulate long-hand method in a single cell
3) Third: Use ROW and INDIRECT functions to create an array of numbers
4) Fourth: Put it all together in a single cell
5) Fifth: Give Formula Inputs Defined Names using the "Create Names From Selection" feature and keyboard short cut Ctrl + Shift + F3
6) Create single cell Array Formula to calculate Total Interest over the life of a Business Amortization Loan
7) How To Create Your Own Original Array Formula From Scratch

More from this channel