Category Archives: Excel

Mask / Anonymize your data with Alteryx

If you handle data, chances are, you have run into this situation where, upon creating a masterpiece visualization, or an innovative report, you need to share it outside your organization for, say: presenting at a conference obtaining vendor technical assistance … Continue reading

Posted in Alteryx, Excel, Qlik, SQL, Tableau | Tagged | 3 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