I have been putting off blogging about this topic because it’s unwieldy to explain and  involves work done many years ago that I would do better now.   I cringe a bit seeing an Offset formula now which I would only …

Save time using Excel Templates to upload to your accounting software – Part A The Cash Book Read More »

Tagged with: , , , , ,

OK imagine this – you have done the right thing as a budding data analyst and created your sales data down the page so that you can take advantage of Pivot Tables which likes dimensions of data going across in …

Transposing Data with INDEX Read More »

Tagged with: , , , , , ,

Somewhere along the line, I realised I was better off using what I call the INDEX / MATCH combo in nearly all lookup situations and not the ever popular VLOOKUP.  The INDEX /MATCH combo can look left and right (unlike …

Why I like INDEX / MATCH combo (and not VLOOKUP) Read More »

Tagged with: , , ,