> Excel is the best spreadsheet software in my experience when you have to move beyond the basics. I’ve even tried hard to use the open/Libre alternatives.
I agree 100% with this, since I've been trying the same. Although I do think some power-users take it way too far and should be using more robust data analysis tools (Python, DBs) instead of having these monstrous Excel spreadsheets with millions of rows and columns.
I tried showing a finance guy a Python version of a levelized cost of electricity spreadsheet he made. He laughed in my face and continued using Excel to drive executive decisions.
I agree 100% with this, since I've been trying the same. Although I do think some power-users take it way too far and should be using more robust data analysis tools (Python, DBs) instead of having these monstrous Excel spreadsheets with millions of rows and columns.