Replace confusing cell references with global constants, local variables, and reusable custom functions.

Global variables are divisive: an invaluable shortcut or a dangerous example of sloppy code? Let's talk about what they do, what they’re good for, and why you should be extra careful using them. A ...