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.

 

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...
Speed up formatting with Excel cell styles

Speed up formatting with Excel cell styles

In our last article we looked at how to create an Excel template and apply formatting, making your financial model look as professional as possible. In that article we showed how easy it is to copy and paste a simple set of formats across your model. Excel cell styles...
Page 2 of 712345...Last »