If you're having trouble crafting complicated formulas in Excel, there are several AI-powered tools to help you along. FormulaGenerator is a great example, using fine-tuned GPT models to generate Excel formulas, VBA automations and SQL queries based on text prompts. It also can correct formula errors and explain how formulas work, making it a good all-purpose tool for spreadsheet tasks. It's got a free tier and a premium subscription that costs $4.99 per month, so you can use it as much or little as you want.
Another option is AI Excel Bot, which uses GPT-3 to generate complicated Excel formulas based on English prompts. It can also explain complicated formulas and generate VBA code. It's available as a Chrome add-on so you can run it directly in Google Sheets or Excel. It offers a free tier and a Pro tier costing $5.99 per month, so it's good for light or heavy use.
ManyExcel has a collection of AI tools to help you with your Excel and Google Sheets work. There's an AI Formula Generator, Regex Generator and Script Generator that can craft complicated formulas, regex patterns and VBA scripts. The tool also has a data analysis tool that can extract information and create interactive charts. It's got a free tier and a Pro tier costing $5 per month, so it's a good option if you're using it a lot.
Last is Sheeter, an AI-powered excel formula generator that can speed up your productivity by automating the creation of complicated formulas. It works with both Excel and Google Sheets and has lots of options for customizing its output. It's got a variety of pricing tiers, including a Basic Plan and a Diamond Plan, so it's got options for people with different needs, too, and can be a good option for generating and managing formulas.