Financial modelling training

Are you unsure about which Excel course might be right for you?

Would you like to talk to one of our tutors who can help clarify your needs?

If you would like to talk to us about choosing the best course, please use our company contact details at the top right of the main navigation.

 

Financial modelling course Sep – 3 days

Financial modelling course
Sep – 3 days

Home > Course > Financial modelling July Find out more about thefinancial modelling course   This modelling training course is designed as a first program for people who would like an opportunity to practise and improve their ability to...
Custom format 000s

Custom format 000s

Imagine you wanted to move the decimal point in your Excel financial model and reduce all the numbers by a factor of one thousand/ 000. There’s a quick trick in custom formats that will help you do that. Essentially all you need to do is add an extra comma (,)...
Jumping and combining columns of Excel data

Jumping and combining columns of Excel data

Imagine you had data in one part of your Excel spreadsheet and needed to amalgamate that same data somewhere else. It’s a common Excel modelling challenge. Maybe the source data is unevenly spaced across your spreadsheet. Then, in the summary, you’d like...
Save a graph to an Excel template

Save a graph to an Excel template

Recently in our blog posts we’ve looked at how to save an Excel template that opens up on your machine as soon as you fire up Excel. That template could contain some simple in-house style rules that help make your models look as professional as possible. Add...
Excel 3D referencing

Excel 3D referencing

The other day we were reviewing a model that had been prepared by a finance director. They had separate tabs for each period (week or maybe month) and had been clever enough to use the exact same structure for each. That made it much easier to create a front summary...
Saving an Excel template

Saving an Excel template

In a couple of recent blog posts we’ve been looking at how easy it is to create professional looking financial models in Excel. The trick is developing a short simple set of formatting rules and applying them consistently. We’ve seen how you can store...
Page 1 of 612345...Last »