Download WPS Office for your device

We often need to use a pivot table to calculate sales in the work of commodity sales. So how can we quickly count the sales by setting the calculated fields of the pivot table?Take this pivot table as an example. As is shown in this pivot table, if we want to count the total sales, average sales, maximum sales, and minimum sales of each product, we only need to enter the fields in the pivot table to set it up.First, we need to drag the Total sales field to the VALUES list box three tim....

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

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc. Today, we will learn Editing settings in WPS Spreadsheet. A personalized editing style will make the table easier to edit and read. First, click Menu in the upper left corner of the table, select Options, and click Edit in the pop-up dialog box to get into the Edit Settings interface. Here I will elaborate on how the functions of Edit Settings can be put int....

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

When editing a PDF file, do you know what to do if you want to make a secondary modification to the picture on the page?Go to WPS Premium, and you will be able to use the editing feature. Take this document as an example. Click the picture you want to modify, then a small icon will appear in the upper right corner of the picture. Click it to enter the picture editing mode.At this point we use the mouse to drag the picture to move its position. As we move the picture, auxiliary lines wi....

When we organize the data of the document, we usually insert a chart for a supplementary explanation.Take this document as an example. The table in the document represents the annual sales volume of different regions. Now, let's look at the data comparison more intuitively by inserting a bar chart. Go to the Insert tab and click the Chart button. In the pop-up dialog, we can choose a variety of chart types. Click Bar and Stacked Bar, then a default style stacked bar is inserted int....

As we all know, we can protect the sheet by setting a password. So, can we divide this table into several ranges and set up separate passwords for each range? The answer is yes. Take this table as an example. This is a student grade table, and we need to set different passwords for each of the three ranges in the table so that the three ranges do not affect each other. Next, I will show you how to do that.Click the Review tab and the Allow Users to Edit Ranges button, and click New. In....

How can we select and edit multiple pictures, texts, and other objects in excel? Today, we will learn some tricks about the Selection Pane.Take this table as an example. You may open the Selection Pane using the methods listed below.The first method is to select Selection Pane from the Find and Replace drop-down menu in the Home tab. The second approach is to go to the Page Layout tab and look for Selection Pane. Or, you can go to the right-hand navigation bar and look for Selection Pa....