- All Tutorials
- Video Tutorials
- Quick Tutorials
443 Search results
Create a countdown calendar current time and date02:14
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. · ....
Use text tools to format paragraphs layout quickly01:37
Use text tools to format paragraphs layout quickly
When you use WPS Document, have you ever encountered the situation that you need to reformat after copying text into a document? The Text Tools in WPS Document can help us to format paragraph layout more efficiently. Now we are going to show you how we can use text tools to quickly format paragraphs. Take this press release as an example. We can see that the layout of the text is really messy. So how can we use Text Tools to quickly format the paragraphs? When encountering this kind of....
How can we create a drop-down list01:33
How can we create a drop-down list
How can users quickly enter information in the table according to standard content? Drop-down list can help us to do that. Take this table as an example. Now we need to perfect the data in the “Gender” column. We can easily do that by using the drop-down list. 1. First, select the C2: C16 cell range.2. Then click the Insert Drop-Down List button in the Data tab. 3. We can select the Add choices drop down manually button in the popup dialog box and enter Male in the text box below. 4. T....
Clear and avoid duplicates entries in WPS Spreadsheet01:56
Clear and avoid duplicates entries in WPS Spreadsheet
When using WPS Spreadsheet to process a large number of data, it would be troublesome to find duplicated items manually. Here are some tips to delete duplicates. · Option OneSelect a range of cells. Get into the Data tab, and click the triangle next to Highlight Duplicates. Pick Set from the drop-down list. Duplicated cells within the selected range will be highlighted. To clear the highlight color, we just need to click the Set button. · Option Two Select cell range (A2:C14). Get into....
How to import external data in WPS Spreadsheet
1. Use WPS Office to open the spreadsheet, and click the drop-down button of Menu in the upper left corner.2. Choose Data → Import External Data → Import Data, and click OK in the popup window.3. In the Step 1: Select data source interface, click Open data file directly, and Select Data Source..., then we can choose the file as needed. 4. In the File Conversion interface, we can select the encoding that makes our document readable. There are two options of Text encoding, one is Windows....
How to use the Smart Split Columns feature02:34
How to use the Smart Split Columns feature
The Smart Split Columns feature of the WPS Spreadsheet can divide the table content into columns according to the table content in four ways.· Delimiter:Take this table as an example. If we look through the table carefully, we can find that although the cells contain a lot of data, the data are all separated by space. 1. Now click Text to Columns in the Data tab, and click Smart Split Columns.2. After a dialog box pops up, we can view the result of Smart Split Columns in the preview wi....
How to convert PDF files into documents01:58
How to convert PDF files into documents
We use powerful PDF in our daily life nearly every day.In our daily work, we often need to edit the file twice. If it involves large-scale changes, we can try the PDF to Word feature of WPS Premium. By using this, we can convert the text and pictures quickly in the PDF file into an editable document file.Take this PDF file as an example. Click the Home tab, and select PDF to Word in the PDF to Office drop-down menu. We can also click Tools. Then click the PDF to Word button to enter th....
How to set up a slideshow in WPS Presentation01:47
How to set up a slideshow in WPS Presentation
Before we preview or make a presentation with slides, we should set up the slideshow in advance. So, how are we going to set it? Take these slides as an example. We first need to click the Slide Show tab at the top and then click the Set Up Show drop-down button. Here, we can set the slideshow as Manual or Auto.If we want to customize the slideshow settings, click the Set Up Show button. In the popup Set Up Show dialog box, we can also set the show type, multiple monitors, etc... In Sh....