AI is revolutionizing the way you work with spreadsheets. This add-in integrates AI features powered by GPT-4 in modern Formula Editors and brings the power of AI to your fingertips to help you better create, understand and edit Excel formulas.

AI formula generation:

When you don't know how to write a formula, you can describe it in natural languages, then ask the AI to generate the Excel formula.

Formula Editor will help you validate the correctness of the formula. You can preview the result of the formula before adopting it.

AI formula explanation:

Whenever you cannot understand a formula or a part of it, you can select it and ask AI to explain it.

Formula Editor will provide its evaluation value. AI explanation can be easily triggered by the button, hovering, or shortcuts (Ctrl+K Ctrl+I), and seamlessly assist you in working with formulas.

Other features of Formula Editor:

Formula formatting: automatically pretty-print a long and complex formula in several lines with appropriate with whitespace indentation and proper nesting.

Error messages: point out on the fly the errors in a formula if they exist, explains the reason and proposes correction.

Formula optimization: automatically identify in your formula the part that can be improved in terms of correctness, readability, or efficiency.

Plans:

Default Basic Plan: Users need to sign in to utilize the Default Basic Plan. This plan provides access to all non-AI features, and limited access to AI features.

Pro Plan: In the add-in, users have the option to upgrade to the paid Pro Plan. This plan offers unlimited use of all AI features, along with other benefits.

Excel version requirement:

The add-in is built with Excel JavaScript API 1.2 and web libraries that have certain requirements on the version of Excel and operating system; some functionalities can be disabled or a blank page can be displayed if the embedded browser of your Excel is Internet Explorer; in this case, you can always use the add-in in Excel Online in a non-IE browser.

More details can be found in www.10studio.tech. Give the add-in a try, and enjoy the power of AI x Formula Editor!

AI-aided Formula Editor

by Matrix Lead