Are You Still Using VLOOKUP the Old Way?

There *is* a smarter way to write Excel VLOOKUP formulas for financial analysis.The title of this post really should have been “are you still using VLOOKUP?”, but I

Read More

What version of Excel are you really using (and why it matters)

Knowing the precise version of Excel can save you hours (or days) of frustration.Why Version MattersGrowing up in the South-Eastern suburbs of Melbourne, getting your driver’s licence was

Read More

Extracting Data from PowerPoint Tables

Extracting data from PowerPoint tables into Excel with VBA (and a little help from ChatGPT).Extracting PowerPoint Table Data into ExcelThere’s a wealth of data in your PowerPoint presentations.

Read More