Take this sales performance table as an example. We want to generate a new column, "sales commission" based on this PivotTable. (Tips: Sales commission is equal to sales amount multiplied by 0.08.) So, how do we do that? First, we click the Options tab, and the Fields, Items drop-down button, select Calculated Fields, then the Insert Calculated Field dialog will pop up.In the Name edit box, input "Sales commission". In the Fields area, choose Sales amount. In the Formula edit box, inpu....

Optical character recognition, also called OCR, is practical to extract text information from a picture. It can also maintain the content layout in the source picture. The first example will show you how to extract text from a picture.1. Go to the Tool tab and click OCR.2. In the pop-up dialog, click Screen Capture to take a screenshot of a selected area.3. Choose Extract text only.Then, we can get the text from the dialog on the right-hand side.If you've joined WPS Premium, you ca....

When editing a document, we sometimes insert a lot of pictures. We usually back up images in case they get lost.Then, do you know how to download an package of images at a time? For example, in this document, many pictures are inserted into the document, and it is a waste of time to save them one by one. Here I'm going to introduce you a very simple skill. Click the Menu button in the upper left corner, and click the Save as the button to pop up the dialog box.In File Type, select ....

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Today, we will learn how to create a Form in WPS spreadsheet, which allows us to input, search and modify the data. Note: If the table contains merged cells, the Form function will be unavailable. · 1. Data inputFirst, click the Data tab and click the Form button. In the pop-up window, the system will automatically take the title row as the field name. ....

When we are using WPS Document, we often encounter situations where we need to insert pictures into the document. So, how can we insert pictures and set images in the Document? Take this speech draft as an example.1. Click the Insert button on the tab of the upper side of the screen.2. Then select the drop-down button of Picture.3. Click From File in the popup window.4. Select the image you want to insert, and click Open. We can now see that the picture is inserted into the document su....

When editing documents with WPS Writer, here are three options to sort the data. ONE: Sort by paragraphsTake this document as an example. If we want to sort the data in ascending order, how can we realize it?1. Select the text content.2. Go to Home and click Sort. After that, a dialog box will pop up. 3. Go to Sort by, where we can choose to sort by 'paragraph', 'headings', and 'fields'; in this example, we choose 'paragraph'. We can also set the sortin....

PDF is a highly compatible format that occupies little space and is easy to transfer. Converting a table into a PDF file is often needed in daily study and work. Here are the steps. Take this table as an example. Click the Tools tab, then click the Export to PDF button. A dialog box Export to PDF will pop up, where you can select the small icon to the right of the file name to rename it. We can choose Active sheet for multi-page tables to set the export range.When we want multiple tabl....

When editing slides, to explain the content more specifically, we sometimes need to add related attachments to the slides. We can use the Insert Attachments feature to directly open the attached files in the slides to avoid switching pages frequently during a presentation. So how can we do that? Take this work report as an example. To better enumerate the work completed in August, we can insert the WPS Spreadsheet attachment in the slide.1. Click the Insert tab, then click the File Obj....