SPECIALISTS IN FINANCIAL MODELLING

Meetup Presentation: Turning up the Heat with Excel Dashboards

Heat maps have evolved considerably in recent versions of Excel from a matrix of colours to become a powerful graphical representation of data displayed in a dashboard. Excel has the capacity to add conditional colour to images based on an agreed set of parameters or...

Webinar: Building Error Checks in Financial Models

We know that a well-designed financial model contains in-built, automatically calculating error checks and a good financial modeller is always looking for opportunities to build error checks into their model. Join financial modeller, Danielle Stein Fairhurst for this...

Financial Modeling for Dummies

I am very excited to announce that I’ve just signed with my existing publisher, Wiley to start work on a new book Financial Modeling in Excel For Dummies. Yes, that’s not how I normally spell “modelling” I know, but they tell me a large part of...

Winter Webinars – Infographics & Dashboards in Excel

This month our subscriber numbers have just hit 10,000, (wow!) and in this edition, it’s all about webinars!  We’ve got several great webinars you can register for, and learn with, all from the comfort of your home or office.  (And don’t forget you...

Webinar: Infographics in Excel

Nothing conveys complex information more quickly and effectively than a well-built and visually appealing infographic.  They are designed to entertain as well as inform, and the popularity of the infographic in social media has made them an effective way to distill...

Use your Budget Surplus

One of my favourite scenes from The Office is when Michael’s accountant tries to explain to him the concept of the budget surplus and why they needed to spend it before the end of the day. If you’re in a similar situation, don’t run around trying to...

Three Ways to Split Data without Using Power Query

I was only kidding. One of them IS Power Query. Seeing as Power Query is one of the best things to happen to Excel data analysis since the invention of the …. PivotTable, how could I possibly write about splitting data without mentioning Power Query? Note that Power...

Demand for Financial Modelling Skills Reaches new Heights

Guest post by Lance Rubin Have you noticed lately how many finance roles have “financial modelling” listed as a core skill? Financial modelling is now one of the most sought after skills in today’s corporate world and demand for financial modelling experience...