Modelling course

Here you can find out more about our Excel financial modelling course training.

Search our site

Or you can search our site for finance training topics.

 

Pivot tables

In this course lesson we just check to see that you know how to create a pivot table. If you haven’t had much experience with pivot tables before, we’ve got some straight-forward instructions to help get you started. Please don’t be scared of pivot...

Modelling tax

This course lesson is an easy one. We point you to a reference example on tax losses that we think you could find useful at some point in the future. What happens to tax when a business slips into loss? In your modelling you might be tempted to take % tax rate x £...

Max formula

Sometimes people coming on our training have seen Max and Min formulas at work in other people’s models. Really what’s happening is that the model is most likely using those formulas as an alternative to the standard If function, simply because...

Excel macros

We’ve got a whole separate course on Excel macros for you. But, if you haven’t seen macros before, we’re happy to get you started on our financial modelling formulas course. A macro acts like a tape recorder. You start your macro recording while you...

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...
Page 6 of 69« First...45678...203040...Last »