1 minExcel - Teach me everything!A lot of people had asked me in the past, "How did you learn excel?", or "Did you go to school for this?" -- Well, here we are, I am...
2 minExcel XLOOKUP - Alternative to VLOOKUP (Maybe)XLOOKUP is a function which looks for a match from another table which will return a single result or range by row. This is a very...
1 minExcel HLOOKUP - Find items by rowIf VLOOKUP can find items vertically. Then HLOOKUP can assist with finding things horizontally. I would normally use this function when...
1 minExcel CONCATENATE - Combining Texts TogetherHere I will try to show you different ways of combining texts. On my examples we have used both the concatenate and "&" options. As you...
1 minExcel VLOOKUP - Find items up/downHere's something simple I've put together that I hope you'd be able to follow. Formula: =VLOOKUP(lookup_value,table_array,col_index_num,...