Just learned about pyspread[0] from your comment, it's surprisingly powerful. I'm well-versed in Python and in Excel, and I'm already more comfortable in pyspread than in Excel after 10 minutes.

[0] https://pyspread.gitlab.io/index.html