Dynamic arrays offer many benefits to financial modellers. They add incredible flexibility and make inconsistent formulas impossible. They make model file size smaller and model performance faster. But dynamic arrays cannot perform certain financial calculations, such as the common corkscrew, without help from LAMBDA or 5g functions. Don’t know LAMBDA? No problem. 5g functions require no special skills and are far easier to use than the formulas they replace. 5g stands for fifth generation modelling and is about assembling models from pre-built, pre-tested, industry-specific functions instead of bespoke formulas. 5g functions look and feel just like Excel’s native functions. They can perform simple calculations like creating a timeline, or complex calculations, like revolver credit facilities that normally require VBA or enabling and iterative calculations to solve the circularity they introduce. But with 5g, they don’t. Sound too good to be true? Watch to hear from 5g’s founder and Microsoft MVP, Craig Hatmaker who will explain how these functions work, and how we can use them to solve common financial modelling problems.
★ Find out more about 5G Modelling
★ Follow Craig Hatmaker on LinkedIn
★ Follow Danielle Stein Fairhurst on LinkedIn
★ Register for another Virtual Meetup
