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
- Home
- |
- Archives: Uncategorized
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
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
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
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