Welcome to this video tutorial where we will explore how to integrate ChatGPT into Excel in a simple and easy way. Thanks to AI, you will be able to use Excel more effectively every day. Let’s get started!
Hello and welcome to Easy Click Academy. My name is Frank, and together with our Easy Click team, we are here to ensure that you can use Excel in a quick and easy way, thanks to our digestible video tutorials.
AI, specifically ChatGPT, can make working with Excel so much easier. It already works quite effectively and can be a great help. So, let’s have a quick look at how we can use AI in Excel after integrating ChatGPT.
In the previous two video tutorials, we explored two interesting and useful AI features. The first tutorial showed how we can generate an Excel formula with the help of AI. The second tutorial focused on a situation where we don’t know what an Excel formula in a spreadsheet does, and we simply ask AI in Excel for an explanation. If you haven’t seen these tutorials, we invite you to watch them to gain a complete and detailed overview of how AI can help you work with Excel more effectively. The links to the videos are provided in the description below.
Now, let’s dive into the ChatGPT integration itself. We will discuss how to add and use the AI-aided formula editor in Excel. This tool is exactly what we worked with in the previous sessions, and it uses nothing else but ChatGPT. So, let’s see how we can simply add the AI-aided formula editor in Excel.
First, click on the ‘Insert’ tab and select ‘Get Add-ins’. Then, type ‘AI-aided formula editor’ in the search field and press the search button. You will find it as the first option on the list. It’s important to note that there are several AI tools for Excel, some of which are free and some are paid. In this tutorial, we will focus on the AI-aided formula editor, which is one of the paid options. However, you can try it out for free. Its greatest advantages are simple integration and excellent functionality. You don’t need a separate account for ChatGPT, and there’s no need for API keys or anything else like that. Of course, it might be a good idea to try out other AI tools and pick whichever suits you best. But here, we will solely focus on the AI-aided formula editor.
To add the AI-aided formula editor, click on the ‘Add’ button. Make sure to read through and confirm the terms and conditions, and then press ‘Continue’. Now, you can see the tool’s interface on the right and a new tab at the top that has been added for easier access. A simple registration is sufficient to use this tool. Just fill in your email address, create a password, and that’s it. You’ll receive an email for verification, and after that, you can log in and start using the tool right away. If you already have an account, simply log in and start.
As mentioned before, you can watch a detailed video tutorial on how to use various functions of the tool, including the AI generator and the cell formula part, in separate episodes. The links to these tutorials are provided in the description below. Please note that this tool is paid, and if you click on your account and select ‘Pricing Plans’, you will see various options on how you can use the formula editor. There is a free version available, but it has a maximum of eight AI requests per week. This option is great to get familiar with how AI in Excel works and to try it out. If you like it, you can use it without limitations for $599 USD per month.
To close the formula editor pane, simply click on the ‘X’ button in the upper right-hand corner. To open the editor again, go to the AI-aided formula editor tab and click on the button. If you want to remove the formula editor completely, click on the ‘Insert’ tab, go to ‘My Add-ins’, click on the three dots, and select ‘Remove’. Confirm the removal, and the tool will be gone.
Are you ready to give AI in Excel a try? Share your thoughts and opinions in the comments section below. We would love to hear from you. If you found this tutorial helpful, give us a like and watch another video tutorial by Easy Click Academy. Learn how to use Excel in a quick and easy way.
Thank you for watching, and we’ll see you in the next video!
