ChatGPT Course Section 37 Excel Formula Generation
ChatGPT is a text-based generative AI tool that can do various tasks. In this course, you will learn how to write prompts, generate content, generate codes and utilise its powerful features.
In this video lesson, we will learn about Excel Formula Generation in ChatGPT.
You can access the entire ChatGPT Course in the following playlist:
https://dailymotion.com/rss/playlist/x8jx4a
In this video lesson, we will learn about Excel Formula Generation in ChatGPT.
You can access the entire ChatGPT Course in the following playlist:
https://dailymotion.com/rss/playlist/x8jx4a
Transcript
00:00So what you can also do is utilize ChatGPT in order to generate Excel
00:10formulas as you like. So over here you can see that I got an Excel sheet with a
00:16collection of first name and last names and I want to divide them but I don't
00:20know the formula to do so. In that case I can go around and ask ChatGPT right
00:25here. So I'm going to go around and say in cell A1 I got first name and
00:33last name. Write an Excel formula to divide the first name and last
00:44name right here just like this. So just go around and tell what you want to
00:49do in plain English and it gives you the formula right here for the first name
00:54and the last name as you can see right here. So I'm going to go around and copy
00:58up the code right here and paste this out around over here on cell 1 just
01:02like this and then I'm going to go around over here copy up the code and
01:06paste this out around over here on the last name section as well and this is
01:11what you have as you can see. So apart from this you can go around and select
01:14both of them and click and drag it out right here just like this and then you
01:19can see that the first name and last name now has been divided and that is
01:23how you can go ahead and generate Excel formulas as you like inside of ChatGPT.
01:29So hope you found this video useful. So be sure to comment on what you think
01:33about it. Be sure to hit the like button and don't forget to share this out with
01:37your friends and family and for more contents like these do follow simple
01:42tutorials.