Demon efficiency of Excel!Formulas should be automatically generated with “GPTExcel”[Today’s work hack]| Lifehacker Japan

We all know AI is changing the way we work (and everything else), even though it’s still in its infancy.

right nowVarious spreadsheet appsAI is about to be introduced into

Microsoft is currently testing Copilot, an AI assistant across all Microsoft 365 apps.

Over the next few months, Google will begin integrating AI tools into Sheets, starting with Workspace accounts.

However, neither is ready for use yet, so if you want to work with AI right now,third party toolsI have to rely on.

[Today’s work hack is recommended for such people! ]

People who want to work more efficiently with Excel and Google Spreadsheets
People who don’t know how to use formulas

Work Hack of the Day: Hack Formulas with AI Spreadsheet Tool ‘GPTExcel’

Image: GPT Excel

One of the AI tools for spreadsheets that you can use right now is “GPTExcel”. Excel, generates formulas for spreadsheets.

Generation procedure

First, enter the formula you want to create in text.

Then as the destinationSelect Excel or SpreadsheetTo do. This is because they may have different commands. When you click “Generate”, AI will tell you the formula.

Generated formula

this time,“I want letters in odd numbered cells to be capitalized”the following formula was suggested:

Excel: =IF(MOD(ROW(),2)=1,UPPER(A1),A1)
Spreadsheet: =ARRAYFORMULA(IF(MOD(ROW(A1:A),2)=1,UPPER(A1:A),A1:A))

Please explain the formula

Moreover, this AI does not end with just a proposal.

If you ask me, I will give you a proper explanation. Paste the formula in the “explain” tab,Clicking on “Explain formula” will explain how the formula works.

For the formula above, we have the following explanation:

This expression uses the MOD function to determine if the line number is even or odd. If the row number is odd, use the UPPER function to capitalize the letters in cell A1. If the row number is even, the character in cell A1 is returned as is.
The IF function is used to do this check and return the appropriate result.

As with any AI, always double-check before using a robot for important tasks.

After I sent the spreadsheet to my boss, I found out that the formula was destroying all the data.

Read more Work Hacks of the Day articles

In the series “Today’s Work Hack”, you can work quickly and efficiently! We will deliver tools, apps, and OS shortcuts, how to use them, and ideas.