Structured references use table columns instead of cell coordinates, making formulas easier to read, update, and trust.
Python has made using Microsoft Excel much easier than it has ever been, and it isn't very hard to start using it yourself.