How much do you really know about Excel? Everyone rushes to highlight their extensive knowledge on their CVs, but when it comes to entering formulas and developing more complex spreadsheets, they actually remember little or nothing. Fortunately, there are very powerful tools on the Web that come to the rescue of the lost user (including yours truly), and one of them is Excel Formula Bot, to which we can explain what we want and receive the exact formula as an answer.
I can configure entire computers from memory and recall serial numbers of programs I haven't used in years, but if someone asks me for help with Excel, I go straight to Google. Excel is one of those programs that lives by “flight hours”: the more time you invest in creating spreadsheets and models, the more fluent your mastery becomes... but none of that will happen without assimilating the correct formulas.
On the Web you'll find a huge number of portals and tutorials that publish endless lists of formulas, however, there is another option: Explain exactly what you want. That's how the Excel Formula Bot portal works, equipped with a free artificial intelligence, optimized for semantic searches.
Excel Formula Bot: Artificial Intelligence for Getting Excel Formulas
Honestly, there is no instruction in Excel Formula Bot beyond explain the problem you want to solve. The only challenge is... that it works in English. Both the description and the formulas obey that language, and the final result requires a pinch of conversion.
For example, in one of my tests I indicated the sum of cells B2, C2, D2 and E2, to present the result in G2. Excel Formula Bot responded correctly with =SUM(B2:E2), which can be injected into any cell... but SUM only works for Excel in English. When we work in Spanish, the exact formula is =SUMA(B2:E2). Of course, Excel has a “Traductor de Funciones”, but it must be installed and configured following the official documentation.
Beyond this initial inconvenience, I think Excel Formula Bot is very useful, and can get users of all levels out of a jam, offering formulas for any need. Obviously, the ideal would be for the bot to extend its support to other languages, applying automatic conversions. We'll be waiting.
Official site: Click here
