VLOOKUP – explained once and for all
I consider being able to use the Vlookup function, as easily as you were writing your name, to be a
Read MoreTales from my life, learning, teaching and freelancing with MS Excel
I consider being able to use the Vlookup function, as easily as you were writing your name, to be a
Read MoreIf you deal in any kind of exported data, this will probably come in very useful. Text to columns is
Read MoreThis is a function I use most when dealing with mailing lists, it’s invaluable and incredibly simple. There are many times
Read MoreOne of the great markers of a person who knows what they are doing in Excel (and indeed life), is the ease
Read MoreMastering Filtering in excel is one of those watershed skills. I regularly teach it as the point you stop using Excel
Read MoreOk, let’s be fair. This is probably the simplest of all things I will make the effort to post about,
Read More