Financial modelling courses

You can search our site for finance training topics.

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

 

Excel date functions

Excel’s date functions can be helpful in financial modelling.  If you have a monthly or quarterly financial model, you will want to roll months or quarters (= three months) forward.  Of course Excel stores dates as numbers, which the next day one integer longer...

Excel data tables

Excel data tables can be used to output results of financial modelling, plotting one key variable against another, showing the impact on the main result. A common example might be plotting the impact of two key inputs (e.g discount rate and long term growth rate) on a...

Excel modelling course: naming cells

Cell names can help users navigate quickly around an Excel model. Excel modelling with named cells: an example at work Sometimes it helps to see an example at work.  Please download the Excel names spreadsheet for an illustration of how cell names can be used in...

Excel’s Iferror and Iserror formulas

Iserror is an Excel function that regularly gets comments on our financial modelling courses. It’s a simple function to employ. If you’ve got multiple checks in a large spreadsheet, Iserror will tell you whether you’ve got any problems anywhere in...

Sumif and Sumproduct formulas

Excel’s Sumif and Sumproduct functions do two things at once in a financial model. Sumif totals numbers that meet a particular criterion, although if you’ve got multiple criteria you’ll want to take a closer look at its cousin Sumifs. Sumproduct...
Page 20 of 42« First...10...1819202122...3040...Last »