Viewing Word Documents in Excel

Dynamically viewing Word Documents in Excel with a UserForm to expand the functionality of your Excel solutions. Embedding Applications in Applications Years ago I developed an Access database

Read More

Dynamically Filter a List in a Worksheet

When Data Validation or UserForms just won’t cut it in Excel. Filtering Lists Options in Excel If you use Data Validation in Excel, you’ll know it improves the

Read More

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

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 Matters Growing up in the South-Eastern suburbs of Melbourne, getting your driver’s

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 Excel There’s a wealth of data in your PowerPoint

Read More