One good choice is FormulaGenerator. This AI-powered tool lets you create Excel formulas, VBA automations and SQL queries based on text prompts. It also can find and fix formula errors, create VBA code and answer spreadsheet-related questions with its AnswersBot feature. It's available as a web app and a Google Sheets extension, and offers a free version and a paid subscription for heavier-duty automation.
Another good option is Sheeter, which uses AI to create complex formulas for both Excel and Google Sheets. You type a query into a search box, and the tool creates powerful formulas you can copy and paste into your spreadsheet. It supports a broad range of formulas, and you can customize plans to suit your needs, so it's a good choice for automating your spreadsheet work.
For a more complete service, Ajelix combines Excel formula generation with AI tools and business intelligence abilities. Among its features are a VBA and Google Apps code creator, an Excel template builder and a self-service BI tool for faster data visualization. It's designed to be easy to use, even for small business owners and non-technical team members, and offers several pricing plans to accommodate different needs.