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.
Comments