In Excel you’ll soon discover the power of a well-chosen function. The problem is there are so many it’s hard to know what might be useful. This talk takes 15 favourites of mine and shows you how to use them alone and in combination to simplify formulas and solve some tricky spreadsheet problems.
- Is INDEX a MATCH for VLOOKUP?
- Does COUNT always count?
- What can you FIND with LEN?
- Could that formula be IFfy?
- Will you be CONVERTed?
Speaker: Duncan Young
Download the spreadsheet with examples
23 February 2015