Use ChatGPT to generate quotes from your favorite movies

Thanks to ChatGPT, my dream of letting Excel collect data by itself has now come true.

△ Picture source: Douyin@Qinyuan International Logistics

Just enter the requirements and data, and ChatGPT can create a table from scratch.

If you want to add rows and columns and perform calculations in the table, it is not a problem. The generated table can also be copied and pasted into Excel with one click.

# If you are a bit lazy, you can use voice-to-text, and making requests is really just a matter of opening your mouth.

△ Picture source: Douyin @成兴

If you don’t know how to write formulas yourself, you can still ask it for advice, and it even comes with operating tips:

This smooth and smooth Excel operation has once again made people look stupid.

The popularity of posts about "ChatGPT making forms" on social platforms has been soaring.

Netizens once again "wailed":

The sword of unemployment above their heads has become sharper.

What is the effect? We gave it a try~

Humans only need to move their mouths and copy and paste

ChatGPT’s Excel skills can be roughly divided into three levels.

• Beginner level is for making ordinary tables;
• Intermediate level is for writing formulas;
• Advanced level is for writing VBA code.

Let’s start with the simplest function and try making a watch.

It is necessary to give the contents of the table and clearly explain the one-to-one correspondence.

Of course, it can be further improved, such as calculating in the table, adding units, and changing the representation method.

You can also only give the header content and let it use its content freely.

After writing, it will also strictly note that the above information is false.

#These generated tables can be copied and pasted directly into Excel (just adjust the format yourself).

At the second level, let ChatGPT help you think of formulas?

For example, if you want to calculate the salary in a table, ChatGPT can give you the correct formula based on the prompts.

There are also some functions that I can’t remember, such as vertical search for “VLOOKUP”, which can also tell ChatGPT what you want to do through language description.

There are also complex operations such as extracting data. The formula often requires a long paragraph. With ChatGPT, you can be lazy.

Furthermore, ChatGPT can also help write VBA code.

Even novices in programming can now automate Excel tasks.

For example, to delete all pictures in the table, the code given by ChatGPT is:

Just copy this code, paste it into Excel’s Visual Basic editor, and then run it~

In short, with the assistance of ChatGPT, many operations on Excel tables will be simplified to "copy and paste", and the accuracy is good.

Some bloggers said that this can increase work efficiency by 10 times.

There are still people who can't wait for Microsoft's action. They have already connected ChatGPT to Excel and got an on-page AI assistant, which is also the first to experience it.

AI AI, you really don’t need to use your brain

As for the effectiveness of ChatGPT in helping to do Excel, some people said that this depends to a certain extent on the quality of the questions. .

#If the question is too brief, it may not understand what you are trying to express.

And some report analysis work can only be done by people.

However, this does not affect the shock that ChatGPT has brought to the public in the past few days.

Many people have started to use it to help them complete their work:

More people are joking that their jobs will not be replaced, right? It’s not too late to change careers now.

Some netizens even said that their company had a wave of layoffs because it purchased AI tools.

What he is talking about is that ChatGPT is paired with a video editing tool, AI AI, to take over all the short video production work.

There is also ChatBCG, an AI tool for making PPT. The front-end time is also very popular:

In recent days, technology giants such as Microsoft and Google have also There is a lot of competition to release ChatGPT related products.

As netizens said, all this is just the beginning of a qualitative change, and the good show may have just begun.

Now that Microsoft has merged ChatGPT into Bing, is it still far away from the Office family bucket?

Reference link:

[1]https://weibo.com/2275284204/MrD7v3ytQ#comment???

[2]https://artificialcorner.com /10x-your-productivity-in-excel-with-chatgpt-6f9536e46d7e???

[3]https://www.youtube.com/watch?v=kQPUWryXwag???

[4]https://appsource.microsoft.com/zh-cn/product/office/WA200004894?src=office&corrid=0198d65b-fe2d-0887-9f14-4e9af7f690b8&omexannotallow=&referralurl=??

The above is the detailed content of Use ChatGPT to generate quotes from your favorite movies. For more information, please follow other related articles on the PHP Chinese website!