How do I quickly re-map values with VBA?

Do you remember the 7 most common data integrity problems? 4 of them needed business expertise and 3 of them were immediately solvable. If you only have Excel in your toolkit, here's a quick way in which you can address them in a relatively painless way: (2) same person, different spellings (e.g. TENEVA ANGELINA in … Continue reading How do I quickly re-map values with VBA?

1 super handy feature of Power Query

What is your favourite feature of Power Query? Mine, by all means, is the option to import data from a folder. Located under Power Query --> From File in Excel 2013 Data tab --> New Query --> From File in Excel 2016 the option is a handy way of keeping track of all your documents … Continue reading 1 super handy feature of Power Query