OK, so this one is a little specific but as both a Windows and Mac user the one thing that does frustrate me is that Excel on a Mac uses the Insert Function differently to how it works on Windows. If I’m being honest I prefer the way this works on Windows. The result is the same and the functions are the same it is just the way you create them using what should be a useful wizard.

So I have created a little video to help you with this. Just bear in mind that once you know how to use the Insert Function on a Mac then the functions work the same as they do on Windows. If you do look at my other tutorials at www.jargonfreehelp.com about Excel functions such as IF, VLOOKUP, PMT etc all work the same.