It would be helpful to insert a countdown calendar into a project schedule so that we can view the deadline every time we open it. So today we are going to learn how to make a countdown calendar. Take this table as an example. 1. On the right of "Current date," input the formula "=TODAY()" and press the Enter key on the keyboard to return the current day.The Today function can synchronize the date set on the current computer so that the current date will update automatically every time....

We may sometimes need to convert the format of the date in the table when using WPS Spreadsheet like Microsoft Excel. At this point, by using the Date function, we can quickly generate a specific date symbol. Take this table as an example. This table contains the information on the date of birth of some students in class. We can see that the information of year, month, and day are separated in this table. So how can we convert the format quickly to know the birthdays of the students? 1....

We often download some special fonts when beautifying documents.However, if the same font is not installed on other computers, it may not display correctly.So how can we solve this problem? Here are the steps to insert fonts into documents.Click Menu and then Options in the upper-left corner. On the left of the pop-up dialog, select General and Save and select Embed True Type on the Save interface, and click OK to save again. In this way, after we save the document locally and transfe....

1. The basic rules of inputting data.2. Commonly-used fill functions (Fill handle, Series, and Flash Fill).3. Create simple drop-down lists for higher efficiency.4. Use the OCR function for quick input.

Comparing and analyzing similar data is something we have to do. Today, we will look at how to customize the formats to show data changes.Take this table as an example. Subtract the data of 2018 from that of 2019 to get the difference. Positive numbers show progress, while negative numbers indicate underperformance and entail attention.To better illustrate, we want to display the increase in green and highlight the decrease in red with a * symbol. Right-click the data area and choose F....

When editing WPS presentation files, we will inevitably need to enter some symbols that cannot be directly entered through the keyboard. So, how can we insert the special symbols as needed? Take the slides as an example. To facilitate statistics, we want to tick the box after the tourist attractions we have already visited. Click where we want to insert the symbol, click the Insert tab and the Symbol drop-down button. Here, we can see Recently Used Symbols and Custom Symbols. These are....