Tag Archives: excel

Overcome 10 Excel limitations with Alteryx

Various sources estimate that Excel has between 750 million and 1 billion users worldwide. Odds are that the vast majority of analysts start manipulating data with Excel. Beyond its ubiquity, and from my days of analytics at Microsoft, I have come to appreciate Excel for … Continue reading

Posted in Alteryx, Excel, Performance | Tagged , , | 9 Comments

Wean Off VLOOKUP with the Index-Match Combo

Whether you need to perform a quick & dirty join of two tables in Excel to fetch an attribute, or to build more robust (!) data blending for your data preparation, you might still be limiting yourself to just the … Continue reading

Posted in Excel | Tagged , , , | 1 Comment