Skillfully use Conditional Formatting to highlight performance

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy. Take this table as an example. This is a sales performance table. Now we want to add a red flag to employees whose sales are greater than or equal to $950 while giving warnings to under-performers with sales less than $700. So how can we do that? We can use conditional formatting.1. We can select the D2:D26 cell, then click the Conditional Formatting in the Home tab before choosing the....

Ctrl+E smart filling

After getting in touch with WPS, we know that Ctrl+C copy and Ctrl+V paste are two shortcuts, which can easily improve office efficiency. Few people know about Ctrl+E smart filling, which can intelligently identify the pattern by comparing the characters’ relationship and quickly fill cells. Next, I will introduce the usage of the smart filling shortcut key Ctrl+E. · 1. Extract charactersIn this table, we want to extract all the names in the sentences. First, enter the name that appear....

How to set custom symbols and symbols shortcut key in WPS Spreadsheet

When using tables to enter data, if we often need to enter symbols, we can set shortcut keys for commonly used symbols, which can improve our work efficiency. Take this size chart as an example. We need to enter the length unit cm multiple times, so how can we get a quick input? Click the Home tab, and the Symbol drop-down button, then click More Symbol to pop up a dialog box. Click the Custom Symbols tab, and then we can see that there are many system-defined symbols, including the cm....

Use slash header to show the title name

Take this table as an example. When creating a table, we often need to use the Slash Header to display the title name, so how can we make a Slash Header?1. Select cell A1, right-click.2. Then select Format Cells in the popup shortcut menu. We can also use the shortcut key Ctrl+1.3. Then select Border in the Format Cells dialog box.4. Now select the slash shape icon in the border preview area, and click OK. 5. Now enter Subject in cell A1.6. Press Alt+Enter to insert a line break, and t....

The AVERAGE, MAXIMUM, MINIMUM functions

When we analyze the sales performance of staff, the AVERAGE, MAXIMUM, and MINIMUM functions can help a lot. The worksheet on the screen lists the personal sales performance for each staff.If we want to get the average sales, we can use the AVERAGE function. Click cell C22, and enter the formula "=AVERAGE()". Then, input "E3-G21" within the parentheses, and press Enter to get the result.If we want to know the highest sales, we can use the MAX function. Click cell E22, and enter the form....

How can we use the data validation feature

We can greatly improve the accuracy of data entry in our work if we use the data validation feature of WPS Spreadsheet. Take this table as an example. This is the information collection form for US citizens joining tour groups for international travel. We need to fill in the information of all the participants. How can we ensure that the passport numbers and phone numbers we entered will not be wrong? 1. First, select the cell area where data needs to be filled.2. Click the Data tab.3.....

Different usages of the break feature

In the process of document typesetting, using the break feature correctly can help us effectively improve the readability and aesthetics of the document. We can use different types of Break in different situations. Here, we can use this paper to demonstrate the various usages of the break feature.· 1. Page BreakIf we want to place the content of the level 2 heading on a new page, we can insert a page break. Click the beginning of the level 2 heading, click the Breaks drop-down button i....

How to insert attachments in WPS Writer

When editing a document, we sometimes need to add related attachments to explain more detail. At this time, we can use the Insert Attachment function to open the attachment in the original file directly. It can greatly improve our work efficiency. So how can we do that? Take this document on introduction to Monet's as an example. We can insert his work as an attachment at the end of the document. It can make it easier for people who read this document to understand Monet.1. Click t....