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

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

Tagged with: , , , , ,

Transposing Data with INDEX

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

Tagged with: , , , , , ,

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

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

Tagged with: , , ,