To give a fluent presentation, we can insert a video into a slide as supplementary material to avoid switching back and forth. In addition to inserting videos, WPS Presentation also supports trimming media. Take this presentation as an example. 1. Select the video. 2. Then WPS Presentation jumps to Video Tools automatically.3. Here we can click Volume to set its volume. For example, we choose Low. 4. If we need to trim the beginning and end of the video, click Trim Media.5. In the Trim....

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

In the last video, we just talked about the worksheet and workbook in the WPS Spreadsheet. So in this video, we will learn about the Spreadsheet interface elements: rows, columns, cells, and those tools in the lower status bar.On the left is the row, and the marked numbers 1, 2, and 3 are called the row number. Above is the column, and the marked numbers A, B, and C are called the column number. The grids in the middle are called cells.When expressing the position of a cell, we use col....

In the previous video, we learned how to set the table page and the header and footer of the table. And this video will teach us how to print out tables. In our daily work, we often need to use the print function. In the quick access toolbar, we can click Print Preview and then click the Settings button to pop up the Print dialog. Before printing, we need to make sure that the computer is connected to the printer. If we need to print two copies of the spreadsheet document, we can chec....

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

Presentation Tools is a feature for WPS Office that can quickly modify the font and size of slide texts, and insert pictures to multiple slides in batches. We can see four options here: Replace Fonts, Batch Font Settings, Customize Text Formats and Insert Picture to Multiple Slides. Microsoft PowerPoint has similar functions as well, such as Replace Font, New Photo Album and Edit Master Slide. However, their entry points are scattered which means the users may need to switch back and f....

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

What should we do when we print a spreadsheet if we want to print a certain area of it? This video could help to solve the problem and could be also used in Microsoft Office Excel and Openoffice. Take this spreadsheet as an example. If we want to print the student ID, and their Chinese and mathematics scores, select this cell area, click the Page Layout tab and the Print Area drop-down button, and select Set Print Area to set the selected area as a printable area. Click Print Preview i....