Processing has always been one of the most frustrating jobs for migrant workers, especially when it comes to some complex data calculations and often requires finding specific formulas.
But now, with the blessing of WPS AI, this process can be simplified infinitely, let's take a look!
Generate formulas quicklyAfter having WPS, you need to perform complex calculations, no need to check tutorials, find formulas, and get results in just one sentence.
For example, to sum and average in ** below, you only need to enter :
Find the sum of the products in column C;
Find the average number of dragon fruit products in column C;
*The formula will be automatically generated and the result will be calculated.
There are also more complex calculations, such as the calculation of age and date, which can also be solved in one sentence.
For example, if you want to extract the date of birth and calculate the age from the ID card information, you only need the following two commands:
Fill in the date of birth through the ID card information in column D;
The age of the subject is calculated by listing the date of birth by d;
After generating the formula, pull down in the lower right corner, and all the data in a column has been calculated, which is not too convenient.
When it comes to calculations such as data evaluation, we only need to give the data range and evaluation level, and we can also let AI do the calculations.
For example:Judge the data in column B, greater than 5000 and less than 10000, b; More than 10000 less than 30000, a; More than 30000,s.
It can be seen that with the help of AI, in terms of ** calculation, almost all calculations can be easily solved in one sentence, and there is no need to find tutorials and formulas, which is not only more convenient, but also greatly saves time.
AI WritingIn addition to using AI to assist in calculations, we can also use AI to help us with some writing tasks. There are quite a few tools that can be used for AI writing, such as the one belowAI creator.
Find the AI writing function on the homepage of the software and you can get started.
Select the type of work you want to write about, and then enter the appropriate writing requirements.
For example, if we need ad copy for a specific product, we can enter the name of the product and the features of the product that need to be highlighted in the copy.
In addition to advertising copywriting, the content of ** weekly report, annual summary, ** and other content at work can be generated with one click, and you don't have to spend your brain writing anymore!
The flexible use of AI can make us more convenient in the office, and it can provide great help in all aspects of work, so let's learn actively!