Excel financial modelling course training

You can search our site for finance training topics.

Or you can find out more about our Excel financial modelling course training:

 

The watch window

Here’s a simple idea. Create a ‘locked’ area in your spreadsheet for key results. Go e.g. into cell C4 and go “View”, “Window”, “Freeze Panes”. Now cells A1:B3 always stay in view as you scroll down or and across...

3D referencing

3D referencing is a cool trick in Excel. Imagine you had a number of subsidiaries you wanted to consolidate up. Imagine you had thought ahead and had placed each subsidiary’s numbers on a separate tab using exactly the same struture for each. Now it’s time...

Escalation factors

In this course lesson we look at escalation factors in modelling. Imagine you were working on a big project model perhaps with expenses escalating at inflation and revenues increasing by a contracted annual % growth rate. It would make sense to try and centralise...

Date formulas

We often centralise dates and put them across the tops of our models. Then sometimes we want those dates to update as time rolls forward. In this course lesson we take a quick look at Excel’s date formulas. The formula that we’re big fans of here is...

Data tables

Investment bankers seem to love their data tables, and we understand why. Imagine you wanted to look at the impact of a key model input (e.g. weighted average cost of capital) on a key output (e.g. valuation). Then you also wanted to look at another input (e.g....
Page 4 of 40« First...23456...102030...Last »