How to deal with foreign currencies in your analysis?
When a currency depreciates, it can mask real business performance. Here's how to untangle the forex effect from your numbers.
Writing about finance, data, and other things I find interesting.
Further automating the VLOOKUP function
The column index in VLOOKUP is usually hardcoded — which breaks whenever the source table changes. Here's how to use MATCH to make it dynamic.