Three simple, but very useful, Excel functions are illustrated here. Upper, Lower and Proper (making the first letter in a word a capital letter). This is very useful especially when working with lists of people’s names.
This short video shows you what can go wrong with the VLOOKUP formula in Excel. This is a great video as we know that here at ImproveYourExcel the VLOOKUP feature causes users of our site a great deal of problems. Most users give us as they assume the function does not work correctly – where as it is often just one of a few things that go wrong. We hope this video is useful for you – if it is then please like it or share it using the buttons above or leave us a comment below.