Stories from the front line

News and stories our company’s warriors have dragged back straight from front line of financial training:

 

Hiding columns

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....
Swiss wood piles

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...
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...
Page 1 of 512345