There are 8 free training classes of how to use office suite for WPS
How to insert a check box in WPS Spreadsheet
After we use WPS Office to open the spreadsheet, click the Insert tab, then click the Check Box button. Now place the mouse where we want to add a check box and click.This skill could be also used in Microsoft Office Excel and Openoffice.
Top 10 weekly report Excel templates free download
Top 10 Weekly Report Excel Templates Top 10 Weekly Report Excel Templates are Excel Report Sheets that are used for a number of purposes. They are one of the best ways to keep the record of your organization in a systematic order. Not only they present your data in a collected manner but also allow you to compare and contrast. The progress as well as the shortcomings can be seen clear as a day when using Excel Sheet. These templates are free to download sheets with formulas. Top 10 Wee....
How to reorder slices in pie chart in WPS Office Excel
This tutorial from WPS Offical Academy helps you learn about how to reorder slices in the pie chart in WPS Spreadsheet. Simple steps to create a pie table in WPS Office Take this table as an example. The source data illustrates the percentages of various foods based on the recommended diet. And you can easily create a pie chart in WPS Spreadsheet following the steps:1. Select the range of data you'd like to put into the pie chart, and go to the Insert tab, click the Chart button. 2....
How to insert a chart in WPS Spreadsheet
1. Open the spreadsheet and select the data that needs to be used in the chart.2. Then click the Insert tab, and then click the Chart button.3. In the Insert Chart popup box, select the type and style of the chart according to our needs.(For example, we are going to select Column → Clustered Column here.)4. Then double-click the button of Clustered Column.Now we have successfully inserted the chart in WPS Spreadsheet!This skill could be also used in Microsoft Office Excel and Openoffic....
How to change the mouse scroll speed in Windows
1. Click the Start button in the lower left corner of the Home page, then click Settings. 2. In the popup dialog box, select Devices. 3. Now select Mouse in Devices area. Here, we can adjust the mouse scroll speed according to our needs. WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently.
How can we print files in WPS
Print is relatively complicated. So we are only going to introduce some basic features here. If you want to learn more about Print, you can watch our videos on Print in WPS Academy.Take this document in WPS Writer as an example. It is also the same in WPS Presentation and WPS Spreadsheet.After using WPS Writer to open the document, click the Print button in the upper left corner. Or we can also use the shortcut key: Ctrl+P. Then we can see the Print popup window. Now we are going to in....
How to sort numbers in ascending or descending order in Excel?
When presenting and analysing data, you can use the sorting feature to place numbers in numerical order.Now let's explore the techniques together.1. Suppose we have a set of data already. Select the cells in the column you want to sort, and go to the Data tab. Then, click Sort > Ascending/Descending buttons. 2. In the pop-up dialog box, you can select Expand the selection to sort the data next to your selection as well or Continue with the current selection to sort the selected dat....
How to Use Excel Formula IF Cell Contains Text in Excel
How to use excel formula IF cell contains text in Excel- WPS Academy Excel has several formulas that can help you use your data in a convenient way. For example, you can get the output based on whether the cell meets certain specifications. One of Excel's most common tasks is to see if a cell has a value based on a particular condition. This value can be text, date, or any other number. In this article, we are going to show some Excel formulas to return value in another cell if th....