The dynamic array revolution! Part 1

Dynamic arrays are revolutionizing how we create models in Excel. This video provides a glimpse into how this approach solves real world problems in seconds, easily, and accurately. Dynamic arrays are incredible, especially when combined with 5g functions. 5g is a standard (not a product) for converting native Excel formulas into Excel functions using only 100% native Excel. No VBA. No Office Script. No add ins. 5g functions look and feel just like native Excel functions so anyone who can use SUM() can use 5g functions. 5g functions make using dynamic arrays easy. This video shows one such example. It demonstrates a function named Depreciateλ. Depreciateλ creates an entire depreciation schedule for a financial model. This one function, in one cell replaces what would otherwise require hundreds of formulas in hundreds of cells. That is not just tremendous time savings. It is also a quantum leap in error reduction. Want to know more about 5g? Go to 5gModeling.com. That site explains how to create your own 5g functions at no cost and provides links to existing 5g functions we can import into our Excel models and start using now. Some are free. The model in this video, and all the 5g functions used to create the model, plus much more, can be purchase at: https://www.eloquens.com/tool/jNDNHywy/craig-hatmaker/financial-starter-pack More information about the Depreciateλ function shown in this video can be found here: https://sites.google.com/d/1yLa0b0KlrfSDyVKDPsOBmKlY4KcfZPsy/p/1eddbEKIokEIWzb_1zjH86EjctfiylrmE/edit