Tips & Tricks #2: How to write long / complex calculations in seconds!
In this video, Derek walks us through how to use string formulas in a spreadsheet to quickly (and with no chance of error) write out long or complex formulas, calculations, or queries. Applicable to BI tools, database languages, and any other programming scenarios where a common syntax occurs throughout a calculation/query.