Use the Today function to quickly calculate days between dates

In the application of WPS Office Spreadsheet, we usually calculate days between dates. So, how can we do a quick calculation? First, I will teach you how to use Today function to calculate days between the current date and the future date. If you are the HR of a company, you can use the Today function to calculate the remaining time of each employee's contract period when you manage the contract period of your employees. It can clearly show you the employees whose contracts are abo....

The SUMPRODUCT function for quick calculation of total sales

When using WPS Spreadsheets to process data, it is convenient to use the SUMPRODUCT function to multiply data and then sum the results that we get. The spreadsheet for demonstration records sales amounts and prices of clothes in different cities. What can we do for a quick calculation of the total sales in all cities? The SUMPRODUCT function can realize it. This video could be also used in Microsoft Office Excel and Openoffice. Place the cursor in cell F5. Then, click Insert Formula i....

How to edit a picture in a PDF file

When editing a PDF file, do you know what to do if you want to make a secondary modification to the picture on the page?Go to WPS Premium, and you will be able to use the editing feature. Take this document as an example. Click the picture you want to modify, then a small icon will appear in the upper right corner of the picture. Click it to enter the picture editing mode.At this point we use the mouse to drag the picture to move its position. As we move the picture, auxiliary lines wi....

How to create a scatter chart in WPS Spreadsheet

A scatter chart in WPS Spreadsheet is normally called an X-Y graph. It presents all the data as points on rectangular coordinates, showing the relationships between variables. The scatter plot is a great graphical tool that we often use for statistical modelling. Take this table as an example. This is a set of height and weight data of boys and girls. If we want to observe the relationship between the two variables: height and weight, with the help of a scatter chart, how can we do tha....

Customize the TOC level

To facilitate reading, we will set the table of contents for the headings of contents in the long document. Do you know how to set the TOC level correctly? Take this document as an example. If we want to generate the table of contents, click Reference and then click Table of Contents. A blank table of contents is inserted, which is not what we want.GIf We need to set the table of contents for headings in the article. First, select the first bold heading in the article, click the Refere....

How to set the print scaling

We want to print the table on one page, but the table is too large. It is divided into several pages when printed. Then, how can we do? The print scaling feature of WPS Presentation can help you solve this problem quickly. Take this document as an example. We can see that without scaling, the table will be divided into four pages for printing. Just click the Page Layout tab above, then Page Zoom, and finally click Fit Sheet on One Page. In this way, the table will automatically adapt ....

More features in Picture to Text

Both WPS Writer and Microsoft Word have the function of Converting pictures to text. What are the differences between them? Microsoft Word itself does not support the OCR function. If you want to convert Picture to Text, you need to open another application, "OneNote."1. Copy the picture to OneNote, and right-click it to select Copy Text from Picture.2. Finally, paste the text into PowerPoint or Word as needed. In WPS Writer, it is much more convenient to do the conversion in the docum....

Edit text contents in PDF

Do you know how to edit a PDF? What if we need to correct something wrong in a PDF?Go to WPS Premium, and you will be able to use the editing feature. For example, if you want to edit the title, get into the "Edit" tab, and click the "Edit Content" drop-down menu. By checking the "Show Text Boundary" option, you will see the text contents in the PDF presenting in text boxes.Click the text box, then you can edit the text content in the PDF. Right-click to copy, paste, cut, or delete the....