Live 5g Instruction
5g makes the dream of dynamic models a reality

Live 5g Instruction

The only live 5g training session starts July 30th. Register here:

https://maven.com/full-stack-modeller/financial-modelling-with-modern-excel

Financial Modelling Bootcamp

5g makes financial modelling with dynamic arrays easy, even easier than traditional modelling. And dynamic arrays with 5g lower model error potential dramatically.

This 'bootcamp' features sessions spread over three weeks. Giles Male (co-founder of Full Stack Modeller) will start the sessions covering the fundamentals of three statement modelling. Diarmuid Early (two time FMWC champion, Microsoft MVP, and co-founder of The Golden Company) will then take us into the realm of modern Excel guiding us through the fundamentals of Dynamic Arrays and LAMBDA. These three areas—Financial Modelling, Dynamic Arrays, and LAMBDA—are the foundation of 5g.

The future of financial modelling is dynamic arrays. Dynamic arrays are extremely easy to use and dramatically reduce model error potential. Dynamic array models perform faster and have smaller file sizes. They can replace 70% of a financial model's calculations with less effort than traditional formulas. Ten percent of a financial model's calculations require minor knowledge of dynamic array functions like SEQUENCE() and CHOOSEROWS(). The remaining 20% require LAMBDA.

Diarmuid Early will demystify LAMBDA. LAMBDAs can be simple and straightforward while adding names to formulas to help us understand their purpose. However, not everyone will want to learn LAMBDA. For those, 5g provides that functionality without any special skills.

5g will close this bootcamp with hands-on live instruction. We will explore some 5g functions, see a traditional model converted to a 100% dynamic array model with support from 5g, learn how to import and use 5g functions in our own models, and try our hand at creating a 5g function.

Sign up today for 12 hours of interactive training for less than the cost of an hour of consulting. Sign up here:

https://maven.com/full-stack-modeller/financial-modelling-with-modern-excel

Steven Wijaya

Administrative Assistant at Excel Daily Hack

8 个月

Can't wait!

Paul Smith, CFA, CFM

Financial Modelling | Power BI | FMWC Multi-Award Winner |

8 个月

What a great line-up and the more people know about 5g the better.

要查看或添加评论,请登录

Craig Hatmaker的更多文章

  • Emulating Solver with LAMBDA

    Emulating Solver with LAMBDA

    Introduction Excel’s Solver is a powerful optimization tool, but some companies impose restrictions on its use. A…

    3 条评论
  • Rollingλ(): 5g Function for Rolling Calculations

    Rollingλ(): 5g Function for Rolling Calculations

    Introduction Excel's LAMBDA functions have opened up incredible possibilities. 5g functions are LAMBDA functions…

    10 条评论
  • TRIMRANGE() and Trim Refs

    TRIMRANGE() and Trim Refs

    I cringed when I first saw TRIMRANGE(). "Oh great," I thought, "another reason for people to avoid learning tables.

    6 条评论
  • Intro to LAMBDA - Lesson 16 - Simple Corkscrew

    Intro to LAMBDA - Lesson 16 - Simple Corkscrew

    I could use your help. I am preparing a virtual work session for FMI on "Intro to LAMBDA.

    13 条评论
  • Programming with LAMBDA - Prime Numbers

    Programming with LAMBDA - Prime Numbers

    LAMBDA makes Excel "Turing Complete." Virtually all programming languages are Turing complete.

    2 条评论
  • Timing LAMBDAs with LAMBDA

    Timing LAMBDAs with LAMBDA

    I recently created a 5g function. It worked great but two friends suggested faster ways to accomplish the same thing.

    2 条评论
  • Create a 5g Function: RunTotRowsλ()

    Create a 5g Function: RunTotRowsλ()

    NOTE! This article was written with assistance from Google's Gemini AI. Introduction In the world of Excel, complex…

    7 条评论
  • From Formulas to LAMBDAs

    From Formulas to LAMBDAs

    I have just completed creating a small class on converting a group of formulas into a single LAMBDA function. It is…

    1 条评论
  • Stairway to ... LAMBDA?

    Stairway to ... LAMBDA?

    I use Excel for everything. I need some stairs from my yard to the forest floor below.

    19 条评论
  • Corkscrew LAMBDA Template

    Corkscrew LAMBDA Template

    Create complex corkscrew calculations easily with this template. What is the difference between complex Corkscrews and…

    3 条评论

社区洞察

其他会员也浏览了