Technology, Skills related Lance Rubin Technology, Skills related Lance Rubin

Building a Financial Modelling Strategy for a Business

Building a business strategy that works is one thing, but building a financial modelling strategy to help businesses make better decisions is an entirely different (but related challenge). It is way more than building a bunch of Excel spreadsheets. At times it is also about dealing with larger data, and people's willingness to learn and adapt. In this article co-authored by Mark Vigors we explore how to build a financial modelling strategy with practical steps that you can take.

Read More

LAMBDA – the new Excel Paradigm for Modeling

In the latest article, co-authored by Craig Hatmaker and me, we delve into the game-changing potential of LAMBDA in Excel modeling. With LAMBDA, Dynamic Arrays (DA) become more accessible, transforming financial modeling with increased efficiency and scalability. Join me in exploring this paradigm shift in Excel, where we empower users to build faster, less error-prone, and more scalable models. Let's embark on this journey together and embrace the evolution of financial modeling with LAMBDA.

Read More
Technology, Skills related Lance Rubin Technology, Skills related Lance Rubin

Accounting and Finance Trends for 2024 - Why it's a Breakout Year for Finance Professionals and Data Enthusiasts.

I’ve never been more excited to start a new year than this year coming in 2024 and there are several reasons for that, which we are going to cover in this article. But rather than just rely on my thoughts, I thought I’d call upon my helpful co-pilot Bing Chat to assist and challenge me and visa versa on the topic.   For transparency, I have put in italics and have referenced Bing sources. Enjoy, strap in and enjoy the 2024 ride!

Read More

Automation in modelling


It's finally out! 😁

Thanks, Benjamin Stoter, CA(SA) for collaborating on this latest article on automation in financial modelling. 🙏

This couldn't have come at a better time with all the hype around Chat GPT, AI and other similar related topics.

Some interesting things to consider in this article and also to look out for. 👀 "Bottom line, the person next to you who learns how to embrace and apply these tools is more of a threat to your job than the bot inside the machine.”

The Knowledge App has also been updated with this latest article. This year we aim to complete the remaining articles in the series. Link in the comments below 👇

Read More
Technology, Skills related Lance Rubin Technology, Skills related Lance Rubin

Finance Tech Stack Part 2: Nine Criteria every Finance professional should know about Tech

Our follow-up article on the Finance Tech Stack part 2 is now out.🙌

Too often I have asked a few of these questions to teams that have already implemented the latest finance tech solutions sold to them and already there are signs of problems a few of these key principles were not considered. 😱

Before you and your team consider any finance technology solution, I highly recommend taking a quick read of this.🧐

You will save yourself a lot of pain (and money) down the track.🤑

Stay safe everyone!😷

Read More