When making slides, we can make the presentation look more professional by inserting video adequately in slides. So how can we insert videos?Take these slides as an example. Click the Insert tab above, and then click Movie. Here, we can choose Local Video or Link Localvideo. The main difference between them is the way of saving the video files.Please note that: if we choose Link Localvideo to insert a video, once we send the slides to other devices, WPS Presentation may not be able to ....

When using WPS Presentation, we often need to edit text content in the text box. So how can we insert a text box? First, click the Insert tab above and click the Text Box drop-down button. Here, we can choose to insert a Horizontal Text Box or a Vertical Text Box. This video of How to insert and set a text box will only take the horizontal text box as an example, which could be compatible with Microsoft Office powerpoint. Click Horizontal Text Box and then long-press the left mouse but....

Take this table as an example. When using the SUM function to do summations, we may find two rows hidden in the table, but the result of the summation still includes the hidden value. So how can we calculate the data containing hidden values and get a result that does not include the hidden values? This video can help us and it can be also used in Microsoft Office Excel and Openoffice. In this case, we can use the SUBTOTAL function. Next, we are going to show you the usage of the SUBTO....

When using WPS Spreadsheets to process data, it is convenient to use the SUMPRODUCT function to multiply data and then sum the results that we get. The spreadsheet for demonstration records sales amounts and prices of clothes in different cities. What can we do for a quick calculation of the total sales in all cities? The SUMPRODUCT function can realize it. This video could be also used in Microsoft Office Excel and Openoffice. Place the cursor in cell F5. Then, click Insert Formula i....

In the last video, we introduced the tips for making dynamic charts quickly. And this video will show you how to create dynamic charts with the help of the VLOOKUP function. Some knowledge points such as drop-down lists, VLOOKUP function, and absolute references are involved in making dynamic charts. If you are not familiar with these knowledge points, you're welcome to enter WPS Academy to search for learning. Take this table as an example. We're going to create a dynamic char....

When using WPS Spreadsheet to process data, we can customize cell format with codes. In this video, you will learn about several practical codes for custom cell format. Take the worksheet here as an example. Select Column E, right-click on it and choose Format Cells in the menu. You can also use the shortcut key Ctrl+1 to pop up the dialog. Get into the tab of "Custom". Then we can see "m/d/yyyy" in the input box. Here "m", "d", and "yyyy"are respectively placeholders for month, day, a....

When doing a presentation, how can we hide certain slides during the slide show while keeping them in the document? This video will show you the Hide Slide function in WPS Presentation. Suppose that we need to hide the second slide, select the preview of it, get into the Slide Show tab, and click Hide Slide. Then we can see the corresponding slide preview greyed out, with a Hide slide icon presenting on the upper-left corner of it. In this way, when we click From Current Slide to start....