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 Generating Microsoft Excel Sheets 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 Generating Microsoft Excel Sheets in ChatGPT.
You can access the entire ChatGPT Course in the following playlist:
https://dailymotion.com/rss/playlist/x8jx4a
Category
📚
LearningTranscript
00:00So what you can also do is you can generate Microsoft Excel sheets inside
00:10of ChatGPT. So in order to generate Microsoft Excel sheets, I'm going to go
00:14around and type in this prompt. So I'm going to go around and say
00:21write a visual basic code that I can run in Microsoft Excel to create a list of
00:33fruits with fruits with its nutritional values in a table format with
00:46interesting looking colors and a format right here. Let's say for example, let me
00:55just go around and say format right here. Then I'm going to go around and say the
01:00table should have SN, name of fruit, nutritional values and calories. Let's say
01:16for example right here. So this is what I have written right here. Write a visual
01:22basic code that I can run in Microsoft Excel to create a list of fruits with
01:26nutritional values. So I'm going to say visual basic code that I can run as I can
01:32run as as a module in Microsoft Excel. So this is important. So once you write this
01:40and press send right here, then what happens is that it says there is the
01:44visual basic code right here, just like this. So it created the code as you can
01:49see right here, just like this. And then once it finishes, you can simply go
01:54around and copy it out. So you can see that it went around and then generated
01:59out the code right here with color codes as well. So let me just go around and
02:03copy this out right here. So now I can go around onto Excel right here and then I
02:08can go around onto developer mode right here. If you don't have the developer
02:12mode turned on, then simply right click on the ribbon area and then go around on
02:17to customize the ribbon. Then you can go around, enable the developer mode right
02:21here and press OK. And you'll get this. So now you need to go around on to
02:25visual basic and then go to insert, then module, then paste out the code that you
02:31copied and hit the run button right here. And now if I were to go around and see,
02:36this is what you have. You can see that it is fully color coded and the
02:39nutritional values with filters right here is applied right here, just like
02:44this. And this is what you have, as you can see. So this is the this is what you
02:50can go around and then make a Microsoft Excel sheet with right here, just like
02:57this. And this works in the older 3.10, 3.5 as well. But if you're using 4.0,
03:03you can go around and simply say, give me Microsoft Excel file for this itself
03:12right here. And then what happens is that it'll go around and analyze the
03:18prompt out right here and will generate out the file itself. So you can see that
03:23it is analyzing and it does take a bit of time. It is running everything in the
03:28background and then preparing the file right here. And there you go. You can see
03:32that it says I've created the Excel file with the fruit nutritional values and
03:36format it, formatted it as specified. You can download it using the link right
03:41here, as it says. So now you can see that it is downloading. And if I were to go
03:45around and open this up right here, then you will be able to see it right here.
03:50So this is the opened up file, as you can see right here, and you can enable
03:54editing. And this is the one that is created by Visual Basic right here. And
03:59this is the one that has been downloaded right here, just like this. So that is
04:04how you can go around and then create out a Microsoft Excel sheets by using
04:11chatgpt in different ways. So if you found this video useful, so be sure to
04:16comment on what you think about it. Be sure to hit the like button and don't
04:20forget to share this out with your friends and family. And for more
04:24contents like these, do follow simple tutorials.