How to Add and Use AI to Microsoft 365 Excel
Here’s how to add AI to Microsoft Excel. First, open Microsoft Excel and create a Blank Workbook. Go to the Developer tab. If the Developer tab is missing, go to File, open Options, and then Customize Ribbon. Enable the Developer option and click OK. The Developer tab will now appear. Go back to the Developer tab, click Add-ins, open the Store, and search for an AI add-in. For example, you can install Claude or GPT for Microsoft Excel. Select the preferred add-in, click Continue, and the AI add-in will be available in Excel. Some add-ins may also include a tutorial video. Open the Settings to choose the AI model. The free trial provides up to 100 AI calls, and you can also view the available plans from there.
To use the add-in, use the AI.ASK function. Enter some sample data into the worksheet, then type ‘=AI.ASK’. This function is used to send prompts to the AI. Enter the prompt you want, such as asking the AI to find the highest value in a selected range, and then select the data range. The AI will return the result based on the prompt you provided. This is just one example of how the function can be used. You can also change AI models or view additional settings from the add-in settings whenever required. And that’s how AI can be added to Microsoft Excel.
Thank you very much.


