PrepJetPrepare your data for analysis in five steps using ExcelMost data sets require preparation before analysis. Garbage in, garbage out — your analysis will only yield meaningful results if your data…Aug 10, 2016Aug 10, 2016
PrepJetHow to discover the “black sheep” in your dataAn introduction to outlier detectionAug 10, 2016Aug 10, 2016
PrepJetLet’s trick Excel VLOOKUP: How to lookup lists with multiple criteria using INDEX and MATCHDownload our example file here.Jun 24, 2016Jun 24, 2016
PrepJetHow to match tables without unique identifier: An introduction to fuzzy matchingYou have two tables, let’s say a customer list from your CRM system, and a list of leads to be targeted by your sales department. Of…Jan 14, 2016Jan 14, 2016