When Data Validation or UserForms just won’t cut it in Excel.Filtering Lists Options in ExcelIf you use Data Validation in Excel, you’ll know it improves the data quality
- Home
- |
- Author: Marcus
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
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
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.