Create a countdown calendar current time and date

WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently. Today, we are going to introduce basic usages of three commonly used date functions. They are namely the TODAY function, NOW function, and DATEDIF function. We can use the date function to insert the current date and time quickly. Also, we can use this function to update it in real-time. We can also make a countdown calendar with it. · ....

How to set the line numbers in WPS Writer

The usage of Line Numbers in long documents can help readers quickly find specific lines. So, how can we add line numbers? Next, I will show you the effects of setting different line number types: 1. Click the Page Layout tab and the Line Numbers drop-down button. We can see that there are different settings in the list. We can choose the Continuous Reading option to add line numbers to the entire document. 2. Choose Restart Each Page to start with number 1 on each page. 3. Choose Res....

How to use the Excel MID function

When using WPS Spreadsheets to process data, sometimes we need to catch part of the data from a series of numbers. We can use the MID formula to realize it, to catch up a certain length of characters from a series of numbers. In this example, there is a list of phone numbers. The MID function can extract the long series of numbers, keeping the last seven numbers when removing the first three characters. Select cell D2 and click the Insert Function to pop up the Search for a function d....

How to convert numbers into percentages

We can directly know the relationships between the part and the whole in our daily work with statistical values shown as percentages. Take this table as an example. We want to calculate the percentage of January sales in annual sales so that we can apply the percentage format here.First, select the cell D2 and enter the formula “=B2/C2”. Then use the fill handle to pull down, and we can get the sales of each employee in January of this year. Then we select the cells D2-D15. Click the N....

How to enter a number starting with 0 in the Spreadsheet

The boss needs us to enter an employee information form, but Alice's work number is never always not displayed correctly. As long as we enter a number starting with “0”, the spreadsheet always hides the preceding “0” by default, so what should we do? In this cases, we just need to convert the cell to text formatting.1. Select a cell, to make a prompt corner mark present. 2. Click the prompt corner mark. Then, the cell will quickly switch to text formatting.Here is another method to....

Quickly fill cells with multiple methods

As for beginners, they usually enter data manually when they first use Spreadsheet. It is time-consuming and also easy to cause mistakes. So today we are going to learn a few tips to help you quickly fill in the data in the worksheet.· Fill contents down into the tableTake this table as an example, select the area that needs to be filled, first click the Home tab, then click the Fill button-and then select Fill down. (Notes: The shortcut key is Ctrl+D.) · Fill contents right into the t....

Remove the picture background with one click

When creating slideshows, we often download a large number of materials from websites, but some of the materials cannot be used directly, such as pictures with backgrounds.Today, I will show you a simple way to quickly remove the picture background. First, we can insert a picture with a pure white background into the slide. And select this picture to get into the Picture Tools tab.Click the Set Transparent Color button, finally click the background color of the picture.Following these....

Use SUMIFS function with multiple criteria

In our work, we often need to filter through multiple criteria for statistics. At this time, we can use the SUMIFS function. The grammatical structure of the SUMIFS function is: “SUMIFS（Sum range, Range1, Criteria 1, Range2, Criteria2...）”Using the data in this table as an example, we want to calculate The total amount of imported fruits from South Korea greater than $50,000. There are two conditions. One is South Korea, and the other is the amount>$50,000.First, after clicking cell E5....