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.

 

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....

Excel’s XNPV function

XNPV works a little bit like XIRR. The formula requires you to assign dates to cash flows. It’s easy to use. The benefit of Excel’s XNPV function Excel’s XNPV function is immediately attractive. Unlike the NPV function, XNPV will not discount the...
Page 32 of 69« First...1020...3031323334...405060...Last »