It takes some figuring out but it's been amazing for spreadsheets, I'll explain what I'm trying to do as if I were explaining it to a person and it'll give me a huge script that does exactly what I want, with annotations and everything. It has enabled me to do things that I don't have the knowledge to do and saved me a ton of time. For example, I had a really complicated formula, vlookup, hlookup, arrays, it was a monster of a formula that took me seriously like 12 hours to get working. With GPT, a few years and one pandemic later, I'd forgotten how I did it, so I tested gpt with it. 2 hours. It was frustrating, there were a lot of "nope"s and "got this error"s but it did it so much faster than I could have iterated on it, and that was only 3.5. GPT 4 is way better at that, I can do other stuff just as complex as that with the 25 reply tokens I have.
That's just one thing it's good for, now that plugins are a thing it can use Wolfram Alpha and actually do math (don't even try without that plugin). As a cook I might have a recipe that calls for a liter of soy sauce, but I only have 3/8l, I can just take a picture of the recipe on my phone, pull the text out with ocr, then I have a saved chat where I give it recipes with "adjust this for only 3/8l soy sauce" and it just gives me an updated recipe. I could pull up a note in my phone, multi-window a calculator, and do the math myself, but like why? It's actually a pretty useful tool, at least for what I use it for.