291 results for ms office online classes
- All Tutorials
- Video Tutorials
- Quick Tutorials
How to change the page orientation00:48
How to change the page orientation
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....
Skillfully use Conditional Formatting to highlight performance01:21
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....
Use color scales to make the temperature chart00:43
Use color scales to make the temperature chart
The table shows the minimum temperature data of each month in a specific area. We can visually display the temperature changes through the color scale feature of the conditional formatting. We select the cell range B2:M2 and get into the Home tab. Click the Conditional Formatting drop-down button, and choose the Color Scales option. In the pop-up menu, we can select Red-White-Bule Color Scale.At this time, the selected table area will be marked with color. The higher the temperature, t....
How to set the header row across pages00:50
How to set the header row across pages
When using WPS Writer to create a table, except for the first page, the table on other pages does not display the header row, so we don't know what the data represents in each column. Take this document as an example. Only the first page has the header row. For beginners, they will choose to add a header row above each table manually. It's too much trouble. Today I will teach you a method to quickly set the header row across pages. At this point, we can select the header row, c....
How to convert numbers into percentages01:08
How to convert numbers into percentages
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....
How to insert calculated fields in PivotTable01:06
How to insert calculated fields in PivotTable
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....
Use the shortcut Alt+= to quickly sum01:02
Use the shortcut Alt+= to quickly sum
In tables, we often have to perform summation operations. Using the function to sum and then filling the cells with the fill handle is too troublesome. However, the sum shortcut Alt+= can help us quickly sum. Take this table as an example. We need to sum the column data of the table, just select the sum range B16:F16, then press the shortcut Alt+= to quickly complete the summation.Similarly, if we want to sum the row data, we can simply select the range G2:G15 that needs to be summed a....
How to compress pictures in WPS Writer01:06
How to compress pictures in WPS Writer
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. ....