ChatGPT Course Section 8 Generating Microsoft Excel Sheets

SimpleTutorials

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

Transcript

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.

Category

Transcript

Recommended