Learning VBA is not difficult. Loading your spreadsheet full of convoluted functions might work, but VBA makes those tasks much more concise and easier to modify.

I do agree that trending away from Excel altogether is a good idea - eventually. However, once you know VBA, you can pickup another language MUCH easier. And when you're ready to move away from Excel, most of your work can be ported over rather than essentially starting over from scratch.