- All Tutorials
- Video Tutorials
- Quick Tutorials
438 Search results
How to use the Excel MID function01:54
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 add and set the numbering in WPS Presentation00:55
How to add and set the numbering in WPS Presentation
WPS Office is a comprehensive office suite that includes writer, spreadsheet, presentation and PDF editor all within one single software.When using WPS presentation, we may want to add numbering to make our slides look more organized. So, how can we add numbering?Select the text content that needs to be added with numbering, click the Home tab above, and then click the Numbering button. Here, we can see a variety of preset numbering provided by WPS. Click to select a style to add. If w....
How to add a stamp in a PDF file01:42
How to add a stamp in a PDF file
We use powerful PDF in our daily life nearly every day.In our daily work and study, we can insert a stamp in the PDF file to indicate that the file has already been reviewed.Now we are going to introduce the Stamp WPS Premium feature.Click the Comment tab and then click Stamp. Here, WPS has provided us with a large variety of presets. We can click the needed stamp style and place it in the appropriate area of the page. We can also customize the stamp. Click Click to Add, then the Add S....
How to add gridlines and guides in WPS Presentation01:31
How to add gridlines and guides in WPS Presentation
When we make a slideshow, in order to achieve a good typographic effect, we generally add guides and gridlines to the page. Take this slide as an example. It is difficult for us to center the title without smart assisted alignment. At this point, we only need to click the View tab above, then click the Grid and Guides button, finally check Display smart guides on screen. With the help of smart guides, centering the title becomes simple. Learn to use guides, and we can achieve more type....
How to add a watermark02:14
How to add a watermark
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....
Look up data quickly with LOOKUP function04:23
Look up data quickly with LOOKUP function
Today I would like to introduce you to the LOOKUP function, which has many relevant knowledge points. Beginners will have some difficulty in learning the LOOKUP function, and the video will introduce the common use of this function and the notes in the process of using it. Take this spreadsheet as an example. If we want to find out who is the purchaser based on the lump sum in cell J9, we can use the LOOKUP function. The general statement structure of the LOOKUP function is LOOKUP (Loo....
Add speaker notes in WPS Presentation01:29
Add speaker notes in WPS Presentation
Have you ever experienced the situation of forgetting the scripts during a presentation? Speaker notes function in WPS Academy might help you to solve it. You will be the amazing reporter with WPS Presentation, which could alternative to Microsoft powerpoint. When using WPS Presentation for a presentation, we can add speaker notes in the PowerPoint to provide tips during the slides show. The speaker notes will be present on the speaker's screen, while audiences can only watch the s....
Use the ROW function in WPS Spreadsheets for row numbering03:03
Use the ROW function in WPS Spreadsheets for row numbering
When using WPS Spreadsheets to process data, how can we deal with the worksheets without numbering or those with disordered numbers? Are there any convenient ways to number the rows while the numbers are not supposed to get disordered when certain rows are removed? The ROW function can realize it. The complete ROW formula is =ROW([Reference]). Here Reference can refer to a single cell, a cell range, or nothing. Here is the introduction to the two options of using the ROW function. · O....