Over the past few decades, Microsoft Excel has become the de facto data analytics tool for most business users. When you need the sum of two values, it couldn’t be simpler than clicking the first value you need to add, following it up with a + sign, and adding the next value. Voilà! You have a total of two values. Drag the formula down by clicking the corners. You’ve got a sum of two columns.
Unfortunately, this flexibility comes at a cost. The user gets gradually trapped in the world of quick fixes and patched formulas that ...