We show how to easily and quickly generate a formula for Excel or other spreadsheets using the AI-powered service Formularizer, explore its features, and test it in action.
Formulas are an essential tool when working with Microsoft Excel. Previously, we compiled a selection of AI tools for spreadsheets, which you can check out here: neuro.pizza/articles/neuroseti-dlya-tablic. In this article, we will demonstrate everything with a real example.
We will test Formularizer AI, available at formularizer.com/home. Keep in mind that the free version allows generating up to 50 different formulas per month. The service supports not only Excel but also Google Sheets.
Enter in the input field what the formula should do. You can write in plain language. As an example, we will ask the AI to create a simple formula that calculates the sum of columns based on a given condition.
In just a few seconds, we get not only the formula itself but also a detailed explanation of how it works. This can be useful if you want to create something more complex with multiple conditions.
The service offers more than just formula generation; it also includes other useful tools for working with spreadsheets, such as creating regular expressions (regex) and SQL queries.
The same fast generation with equally detailed explanations. Of course, such functionality is mainly useful for advanced users in specific tasks, but who wouldn't want to simplify and speed up their workflow?