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.
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...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...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....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... Unrated Poor Adequate Good ExcellentCourse typeFinancial modellingDelegate's nameK. R.Delegate's occupationPrivate equity executiveDelegate's company nameQED EquityDelegate's countryIrelandCourse date11/03/2014Did the trainer encourage participation and check...