Blogs

Returns text from a cell that occurs before a given delimiter

Returns text from a cell that occurs after a given delimiter

Compares values against a given expression and returns the corresponding result value

Concatenates values together from cells or ranges of cells

Returns one value for a TRUE result, and another for a FALSE result for multiple conditions

Find out more about how we support students sitting the Financial Modeling Institute exams.

I was preparing for some face to face training for a client recently and I was struck by two things when looking through their spreadsheets:

Here are the top 10 reasons why joining Full Stack Modeller is the right decision for you. 1 You will have the opportunity to become an accredited Full Stack Modeller with certificates to show off on your LinkedIn profile. 2 You will be supported by a global community of finance professionals who regularly share the best and worst formulas (and pie charts) they have ever seen. You will also be supported by us, of course - a team of awesome, humble mentors. 3 We host live events with industry experts almost every week, which you can join live or watch on demand. 4 You will have free access to our masterclass series so that you can tell everyone about how many hours of CPD training you have completed. 5 You can practice your new skills with regular case studies and monthly community-wide challenges. 6 You can stay up to date with the latest tools and software for financial modellers to keep your productivity levels high. 7 You can access everything on any device, anytime, anywhere. 24/7 spreadsheet chat at your fingertips! 8 You can network with hundreds of finance professionals who regularly share their stories, experiences, and beautiful financial models. "Having a set of experts and like-minded people you can consult is hugely reassuring. And one learns so much too from other people's questions and the brainstorming and responses that follow." - Wikus, South Africa 9 We often offer discounts for your first year of membership. Head over to a pricing page to see if we have any on offer now! We also offer discounts for team bookings. 10 You'll get lots of additional benefits, including a free ticket to the Financial Modelling Summit each year, and extended trials with many of the software companies we showcase. If you're unsure if you need training in the first place, take our FREE skills assessment to see how many gaps you may have in your knowledge and skill set.

Find out more about the Master Financial Modeler (MFM) qualification from the Financial Modeling Institute (FMI).