SPECIALISTS IN FINANCIAL MODELLING

Virtual Meetup I Are Excel’s Power Technologies suitable for Financial Modelling?

When people think about financial modelling or forecasting in Excel, what comes to mind is worksheets loaded with formulae, built in a report-focussed layout. Watch as Ken Puls showcases examples of using Excel’s Power Technologies to build Financial Models and Forecasts for clients. From data shaping with Power Query to DAX in Power Pivot, these tools play an essential role in modern financial modelling solutions.

(more…)

Virtual Debate: Google Sheets versus Microsoft Excel

Google Sheets is gaining popularity but how does it stack up against its rival Microsoft Excel? Many of the recent Excel enhancements were inspired by Google Sheets – or is it the other way around? Join us for another virtual debate to hear from two Microsoft MVPs Alan Murray and David Benaim as we compare the two and debate which tool provides the best modelling features.
(more…)

Thinking about entering the Financial Modeling World Cup? Here’s some advice.

If you’re going to compete this year, now’s the time to get in at the beginning of the season. Still undecided? Not sure if your skills are good enough? I’m gonna level with you. They’re probably not. You’ll most likely fail spectacularly. The competition is brutal and heart breaking but the experience is invaluable. You’ll dread the next round but won’t be able to wait. Just do it – your career will thank you.

(more…)

Financial Modeling in Excel for Dummies 2nd edition

Dummies Book coverThe second edition of Financial Modeling in Excel for Dummies is now available! The first edition made it into the bestsellers list (for books on spreadsheets that is 😊) and here’s what it says on the back cover:

Turn heads with stunning financial models

It’s not the kind of modeling where you get to strike a pose, but it can still be fun, we promise. Financial Modeling in Excel For Dummies is your no-hassle guide to using the Microsoft Excel application to build beautiful financial models of all shapes and sizes. Project finance, pricing, valuation, reporting—it’s all in here, as we show you how to generate answers using Excel’s powerful functions and features. Together, we’ll make sure those numbers add up. We’ll even help you present the output so that your boss will understand it.

(more…)

Dummies Cheat Sheet

The cheat sheet for “Financial Modeling in Excel for Dummies” is also now available!  All Dummies books include cheat sheets which summarise important themes or content from the book into a single place. The cheat sheet is publicly available on the Dummies site, and you can access it without purchasing the book. Here’s what’s covered in the cheat sheet:

Essential Excel Functions for Building Financial Models

Financial modelling is ALL about the functions! Basically, the whole point of building a financial model is so that when the inputs change, the outputs change as well – so a good financial modeller will know lots of lots of functions.  Check out my list of favourite Excel functions. (more…)

Reducing Errors with Financial Modelling Best Practice

Much of what we call “best practice” in financial modelling is really just common sense and will make your life a lot easier as well as reduce the possibility of error when building your models. Hear from financial modelling specialist, Danielle Stein Fairhurst as she covers important do’s, don’t, tips and tricks of of financial modelling best practice.

(more…)

Skills Needed for Financial Modelling (and how to get them)

Skills Needed for Financial Modelling There’s no doubt that having good Financial modelling skills is fantastic for your career but there’s a lot more to it than being good at Excel! Finance & accounting, design, logic and numeracy to name a few. And should you put “financial modelling” your resume? Hear from financial modelling specialist, Danielle Stein Fairhurst explore some of the other skills you need, and how to get them.

(more…)