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?
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
But how do we get it there in the first place? There are a couple of options - choosing the best one for your case will very much depend on the volume of data you need to analyse and the data infrastructure that your company provides. So far I've used: 1. Import from text (a.k.a. … Continue reading Let’s crunch this data in Excel
My dataset is too big for Excel to handle efficiently As I've mentioned before, Excel is not a storage place! If you're having problems processing the sheer volume of your data with it, you might need to look into consolidating monthly compilations into a centralized place. Assuming you have no DB access and no ETL … Continue reading 5 super handy things to remember if you’re an MS Access newbie