Intro · 1:13
Introduction
ChatGPT in Excel.
- Select prompt cells and click a button — the response appears in a new worksheet.
- Works with GPT-3.5 Turbo and GPT-4.
- No coding needed; Windows only.
| Input | Output |
|---|---|
| Prompt cell(s) | New output sheet |
Do this in your own tools, step by step. Ticks are saved on this device.
Output location?
A new worksheet.
OS?
Windows.
0:00 in this video I will show you how to integrate jet gbt into your Excel spreadsheets by the end of this video you will be able to insert buttons like the one on my sheet when you select the cell with your prompt and hit the button a new worksheet will be created for you in that worksheet you will find the response from jbt for example I asked for a 10-day travel plan to Soul South Korea instead of just selecting one cell with your prompt you can also choose multiple ones in the next example I included my prompt in the top left Corner also when I hit the button again you will see the CH gbt response in the new output sheet so now I have some insights into my data I have actually created a very similar video to this one in the past however in that video I used an older model of jet GPT to incorporate
0:48 the GPT 3.5 turbo model and GPT 4 I had to modify the code but don't worry if you want to integrate this functionality into your spreadsheets there is no coding required on your part I have done all the work for you and you free to take my code and use it however you would like the only limitation is that my code will only work on Windows machines okay and with that said let me
Get the other 3 chapters, the exam and your certificate for LinkedIn, plus all 700+ AI courses.