Replace confusing cell references with global constants, local variables, and reusable custom functions.
Python has made using Microsoft Excel much easier than it has ever been, and it isn't very hard to start using it yourself.