To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy. Changing the orientation of printing paper is mostly necessary for our daily work. How can we set them in landscape or portrait orientation? In this table, we want to set the paper orientation and print it out. First, head to the Quick Access Toolbar in the upper left corner of the interface, then click Print Preview. If we want to print the table horizontally, click the Landscape butt....

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

Today I will introduce you to introductory calculation of functions, namely addition, subtraction, multiplication and division. In the table, there are three ways to enter the function, respectively, input in the formula bar input in the cell and click Insert Function. So how can we do elementary arithmetic in the table? We can enter the corresponding symbol for the operation in the formula bar or cells. Take this table as an example, we enter "= A2 + B2" in cell C2, press the Enter ke....

We can directly know the relationships between the part and the whole in our daily work with statistical values shown as percentages. Take this table as an example. We want to calculate the percentage of January sales in annual sales so that we can apply the percentage format here.First, select the cell D2 and enter the formula “=B2/C2”. Then use the fill handle to pull down, and we can get the sales of each employee in January of this year. Then we select the cells D2-D15. Click the N....

If we have a large number of pictures in our document, this will make the file too large for us to transfer. At this point, we can adequately compress the picture in order to reduce the file size and save the file space. First, click the picture to get into the Picture Tools tab, and click the Compress Pictures button to pop up the dialog. In the Apply to interface, we can select the range of compressing pictures.In the Change resolution interface, we can select two fixed resolutions. ....

We want to print the table on one page, but the table is too large. It is divided into several pages when printed. Then, how can we do? The print scaling feature of WPS Presentation can help you solve this problem quickly. Take this document as an example. We can see that without scaling, the table will be divided into four pages for printing. Just click the Page Layout tab above, then Page Zoom, and finally click Fit Sheet on One Page. In this way, the table will automatically adapt ....

In practical work, we often need to enter the date in the spreadsheet. There are many data format types, so how do we set the date formats as we need? Take this spreadsheet as an example. Select the spreadsheet area, right-click the mouse, and select Format Cells from the shortcut menu. The shortcut key is Ctrl+1. In the pop-up Format Cells dialog box, select Date. There are many date formats in Type. We can choose the Wednesday date format, its abbreviated format, or the date format o....

Now we have already set up a custom numbering style. Where can we find and modify it? Take this document as an example. We have already added the multilevel numbering to the file. At this time, we want to quickly switch to the customized numbering style. Click the Numbering drop-down button in the Home tab, and then click More Numbering to pop up a dialog box.In the Custom List tab, we can see all the custom numbering styles we set on the left. If you want to delete a custom numbering ....