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

The usage of Line Numbers in long documents can help readers quickly find specific lines. So, how can we add line numbers? Next, I will show you the effects of setting different line number types: 1. Click the Page Layout tab and the Line Numbers drop-down button. We can see that there are different settings in the list. We can choose the Continuous Reading option to add line numbers to the entire document. 2. Choose Restart Each Page to start with number 1 on each page. 3. Choose Res....

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

Both WPS Writer and Microsoft Word have the function of Converting pictures to text. What are the differences between them? Microsoft Word itself does not support the OCR function. If you want to convert Picture to Text, you need to open another application, "OneNote."1. Copy the picture to OneNote, and right-click it to select Copy Text from Picture.2. Finally, paste the text into PowerPoint or Word as needed. In WPS Writer, it is much more convenient to do the conversion in the docum....

WPS Office Suite is a high-performance and reliable office suite designed to protect data and information for both PC and mobile office software users. WPS Presentation and Microsoft Office both can convert pictures to text. Today we will analyze their differences. Microsoft PowerPoint itself does not support OCR function. If you want to realize Picture to Text, you need to open another app-OneNote.Copy the picture to OneNote, right-click the image to select Copy Text from Picture. Fin....

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

Both WPS Spreadsheets and Microsoft Excel have the function of Converting pictures to text. What are the differences between them? Microsoft Excel itself does not support the OCR function. If you want to convert Picture to Text, you need to open another application, OneNote. 1. Copy the picture and paste it into OneNote.2. Click Copy Text from Picture with the right mouse button3. Paste the text into Excel as needed. In WPS Spreadsheet, the OCR function allows us to convert pictures to....

When making WPS presentation files, are you still troubled by not knowing how to match colors between the elements? This Color Schemes feature will help you. Take this slide as an example. Click the Design tab above and then click the Color Schemes button. Here, WPS Office offers multiple color schemes with a sense of design. All we need to do is choose a color scheme that fits the theme of the presentation. Tips: This feature is only valid for elements that are included with the WPS P....