Select Page

If you have 3-4 staff who are interested in a course, in-company training will prove cost-effective for your firm.

The outlines that you see here on our site are just a sample of what we train and we will happily craft a bespoke course just for you.

Please use this form if a small group of your firm’s employees might like one of our financial training courses.

7 + 10 =

## Hundreds of happy customers

Did you know that virtually
everyone likes our courses?

# Stories from the front line

Here you can read about topics that have popped out of our financial modelling course training.

It’s right here that you can sit round the camp fire and listen to stories from Excel warriors at the front line of financial modelling.

## Hiding columns

Here's a trick that will help you navigate more quickly around a big spreadsheet. Hide the columns out to the right. Hide the spare rows beyond the bottom. That means you will be able to use "Ctrl" and your arrows to jump quickly around your model. Hiding the spare...

## Swiss wood piles

If you're ever lucky enough to go walking in the Swiss mountains something may strike you about the tidiness of the woodpiles outside the pretty log cabins. They're all very neat. They're (probably) the most beautifully-stacked woodpiles in the world. What's a tidy...

## Marwa Hammam, Executive Director at Cambridge University’s Judge Business School

We questioned Marwa Hammam, Executive Director of the Master of Finance programme at Cambridge University’s Judge Business School: “What are your students using as alternatives to Excel?”. It turns out that “Not much” is the answer. Some students on some programmes...

## 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 (,) on the...

## 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 to make use...

## 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 some...

## 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

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 those rules in a...

## Jumping around in Excel

Did you know there are some great Excel shortcuts that help you jump around a spreadsheet? "Ctrl" then left square bracket "[" (all at the same time) If you've got a link in a spreadsheet it's really easy to see the cell reference in the formula bar (as per the...

## 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 1 of 3123