Your browser version is outdated.
To browse WPS Academy normally, we recommend you to upgrade to the latest version of Internet Explorer or try other browsers.
chrome
Chrome
firefox
Firefox
WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches
      • Home
      • Popular
      • show today's date

      186 results for show today's date

      • All Tutorials
      • Video Tutorials
      • Quick Tutorials
      • All
      • Spreadsheet
      • Presentation
      • Writer
      • PDF

      186 results for show today's date

      Use Date function to convert date format

      Use Date function to convert date format

      01:50

      Use Date function to convert date format

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

      Spreadsheet 3,086 views
      Set the date format cells

      Set the date format cells

      01:40

      Set the date format cells

      In practical work, we often need to enter the date in the spreadsheet. There are many data format types, so how do we set the date formats as we need? Take this spreadsheet as an example. Select the spreadsheet area, right-click the mouse, and select Format Cells from the shortcut menu. The shortcut key is Ctrl+1. In the pop-up Format Cells dialog box, select Date. There are many date formats in Type. We can choose the Wednesday date format, its abbreviated format, or the date format o....

      Spreadsheet 3,930 views
      Insert date and time in the header or footer

      Insert date and time in the header or footer

      00:55

      Insert date and time in the header or footer

      WPS Writer allows users to add various styles of header and footer, including text, pictures, and date and time. So how can we realize inserting date and time? A footer has been added to this document. So here we take the header as an example to show how to insert date and time. Get into the Header/Footer tab and click Date and Time to pop up the dialog. On the left-hand side of the dialog, we can choose from different formats to present the date and time. Check the Update automaticall....

      Writer 523 views
      Use Validation to restrict date entries

      Use Validation to restrict date entries

      01:10

      Use Validation to restrict date entries

      When editing a spreadsheet, we may want to restrict the contents to ensure effectiveness, such as requiring the dates cannot exceed today. Today we will tell you how to restrict the input dates using Validation.First, select the cell range that contains the dates. Click Validation in the Data tab or use the shortcuts Alt+D+L.The Data Validation dialog will pop up, where you can select Date at Allow. Then, click the Data drop-down button to restrict the date range. Here, we select less ....

      Spreadsheet 23 views
      Show or hide editing marks

      Show or hide editing marks

      02:27

      Show or hide editing marks

      All users may need to show or hide editing marks to preview the editing effects or make the document look neater. Today we are going to learn about how to show or hide editing marks. · Show/Hide paragraph marksTake this document as an example. Every time we press the Enter key, a black Paragraph Mark appears, which is also called Hard Return. In general, it appears at the end of a paragraph, and its code is "^p" in a Word document.It doesn't affect printing but sometimes has a nega....

      Writer 4 views
      Create a countdown calendar & Insert current time and date

      Create a countdown calendar & Insert current time and date

      02:14

      Create a countdown calendar & Insert 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. · ....

      Spreadsheet 284 views
      Customize the formats to show data changes

      Customize the formats to show data changes

      01:28

      Customize the formats to show data changes

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

      Spreadsheet 2 views
      The Rehearse Timings feature of Slide Show

      The Rehearse Timings feature of Slide Show

      01:21

      The Rehearse Timings feature of Slide Show

      It is very important to limit the length of your speech in some speech contests or formal speech occasions. WPS Presentation provides the Rehearse Timings feature for us to rehearse the speech. Take this slide as an example. 1. Head to the Slide Show tab, and click the Rehearse Timings button to enter the rehearse mode. In the upper left corner, there is a timer that can be moved freely. 2. Click the inverted triangle icon on the left or click to jump to the next slide, and then the sl....

      Presentation 16 views
      Prev 123...2324 Next
      WPS Academy