Home >Technology peripherals >AI >Use ChatGPT to generate quotes from your favorite movies

Use ChatGPT to generate quotes from your favorite movies

WBOY
WBOYforward
2023-05-08 16:19:081872browse

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

Use ChatGPT to generate quotes from your favorite movies

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

Use ChatGPT to generate quotes from your favorite movies

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

Use ChatGPT to generate quotes from your favorite movies

△ 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:

Use ChatGPT to generate quotes from your favorite movies

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.

Use ChatGPT to generate quotes from your favorite movies

Netizens once again "wailed":

The sword of unemployment above their heads has become sharper.

Use ChatGPT to generate quotes from your favorite movies

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.

Use ChatGPT to generate quotes from your favorite movies

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

Use ChatGPT to generate quotes from your favorite movies

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.

Use ChatGPT to generate quotes from your favorite movies

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

Use ChatGPT to generate quotes from your favorite movies

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.

Use ChatGPT to generate quotes from your favorite movies

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

Use ChatGPT to generate quotes from your favorite movies


Use ChatGPT to generate quotes from your favorite movies

Furthermore, ChatGPT can also help write VBA code.

Even novices in programming can now automate Excel tasks.

Use ChatGPT to generate quotes from your favorite movies

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

Use ChatGPT to generate quotes from your favorite movies

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

Use ChatGPT to generate quotes from your favorite movies

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.

Use ChatGPT to generate quotes from your favorite movies

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.

Use ChatGPT to generate quotes from your favorite movies

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

Use ChatGPT to generate quotes from your favorite movies

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

Use ChatGPT to generate quotes from your favorite movies

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:

Use ChatGPT to generate quotes from your favorite movies


Use ChatGPT to generate quotes from your favorite movies

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

Use ChatGPT to generate quotes from your favorite movies

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

Use ChatGPT to generate quotes from your favorite movies

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.

Use ChatGPT to generate quotes from your favorite movies

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.

Use ChatGPT to generate quotes from your favorite movies

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!

Statement:
This article is reproduced at:51cto.com. If there is any infringement, please contact admin@php.cn delete