To focus on Excel / Google Sheets itself, AI makes it a lot more usable in that you can describe what you want and it can generate formulas for you. I have a running spreadsheet that I had to manually manipulate because I didn't know how to automate some parts and a few minutes with an LLM fixed it for me.