Today I will tell you the differences in the web search function between Microsoft Word and WPS Writer. When we use Microsoft Word to edit a document, we usually copy the content and open a browser to search for it if we encounter content that we do not understand. And when you use WPS Writer, you can skip this step. WPS Office has a built-in Google search engine in WPS Writer, so you only need to select the text you want to query and then click the Search button in the lower right cor....

When you want to split the content based on the specific categories in the sheet, are you still disassembling and reorganizing the content one by one? The Split Sheet feature can help you. Take this sheet as an example. If we want to split this sheet into three sheets based on class 1, class 2 and class 3, what should we do? We just need to click the Home tab and click Worksheet, then click the Split Sheet option, finally choose Split Sheets By Content. In the Split area box, we can ch....

Switching back and forth between different workbooks is inconvenient for checking data. Today we will tell you how the View side by side function can help.For example, suppose we want to check whether the data in March is identical in the Quarterly Sales and Monthly Sales sheets. Click the View side by side in the View tab. The interface will then be divided into two sections, one on the left and one on the right. The quarterly sales sheet is on the left while the monthly sales sheet 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....

Do you know how to edit a PDF? What if we need to correct something wrong in a PDF?Go to WPS Premium, and you will be able to use the editing feature. For example, if you want to edit the title, get into the "Edit" tab, and click the "Edit Content" drop-down menu. By checking the "Show Text Boundary" option, you will see the text contents in the PDF presenting in text boxes.Click the text box, then you can edit the text content in the PDF. Right-click to copy, paste, cut, or delete the....

Are you still checking table data one by one? Here are two practical methods that can help us find data difference items quickly. Take this table as an example. How can we do it, if we want to quickly find out the data difference items in the rows from Database1 to Database4? First, we select the cell range, then click the Home tab, and click the Find and Replace drop-down button. Select the Go To option under the drop-down menu, or we can also use the shortcut key Ctrl+G to open the d....