Main Profile

At A Glance

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

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

Contact

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

Want more info about Excel Magic Trick 944: How To Create Your Own Original Array Formula From Scratch? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question