Financial modelling

You can search our site for finance training topics.

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


Password protect an Excel spreadsheet

To password protect parts of a spreadsheet, first you need to ‘tell’ Excel which parts of the spreadsheet should be locked. Locking parts of a spreadsheet – step 1: apply locking format to cells Locking gets applied as a cell format. Select the whole...

Excel hyperlinks

Cell hyperlinks are really quick and easy to create in Excel. Creating cell hyperlinks To create a cell hyperlink, find the “Insert” tab in Excel. Under “Links” select “Hyperlink”. A box will pop up – see the picture below...

Excel array formulas

Previously we’ve looked at Excel’s Sumif, Sumifs and Sumproduct functions, which essentially combine two formulas in one. If you like the idea of regularly doing two things at the same time, it might be worth taking a look at Excel’s array formulas....
Page 3 of 4212345...102030...Last »