Download WPS Office for your device

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

WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently.We often see unique watermarks printed on the back of some files. Adding a watermark can not only prevent others from embezzling but also can help us to indicate the source of the article. So how can we add a watermark to a document?To show the source, we need to add the watermark of WPS Academy to the following documents now.1. After cl....

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. WPS Spreadsheet and Microsoft Excel both have the function of inserting pictures. Compared with Microsoft Excel, WPS spreadsheet has an added advantage-Embed to cell. In Microsoft Excel, we usually need to manually adjust the size of the pictures after inserting them. If the position of the table changes, the inserted pictures will not fit in the new ce....

WPS Writer is easy to use as Microsoft Word. Both WPS Presentation and Microsoft PowerPoint have the Screenshot function. What is the difference between them? In Microsoft PowerPoint, two methods are available. One is Available Windows, which means taking screenshots through the opened windows on our desktop; the other is Screen Clipping, requiring us to manually capture the size of screenshots. In WPS Presentation, we can enter the Insert tab and click the Screenshot drop-down button.....

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy. Changing the orientation of printing paper is mostly necessary for our daily work. How can we set them in landscape or portrait orientation? In this table, we want to set the paper orientation and print it out. First, head to the Quick Access Toolbar in the upper left corner of the interface, then click Print Preview. If we want to print the table horizontally, click the Landscape butt....

We learned how to share and edit files with our co-workers.There are two methods to share files. One is the traditional method that can be set in the Review tab and shared the file through the local area network. Thus, multiple people can work on the file at the same time. You can trace the revision in the records. Another method is to co-edit online. All you have to do is share the link. The receivers do not need to download WPS Office to participate in the cooperation. The editing re....

WPS PDF could help edit PDF files and freely convert between PDF and Word, Excel, PowerPoint, and JPG files online. When editing PDF files, we often need to merge multiple PDF files or split a PDF file. So how can we do that?· Merge PagesTake this file as an example. When we need to merge multiple PDF files into one, click the Page tab, then click Merge Page. Now the WPS PDF to Word Converter dialog box will pop up. Click the Add files button in the upper right corner and select other ....

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy. Take this table as an example. This is a sales performance table. Now we want to add a red flag to employees whose sales are greater than or equal to $950 while giving warnings to under-performers with sales less than $700. So how can we do that? We can use conditional formatting.1. We can select the D2:D26 cell, then click the Conditional Formatting in the Home tab before choosing the....