- All Tutorials
- Video Tutorials
- Quick Tutorials
647 Search results
Use the ROUND function to round decimals quickly01:57
Use the ROUND function to round decimals quickly
In our work and study, we often have to round off decimals. Let me show you how to use the ROUND function to deal with long strings of decimals quickly. Take the decimal in the B3 cell as an example.1. Place the cursor in C3.2. Click Insert Function.3. In Math and Trig, select the ROUND function. The pop-up dialog box has two parameters. Number is the numerical value to be rounded, and Num_digits refers to the digits to be used for rounding. If the Num_digits is greater than 0, then th....
How to add a stamp in a PDF file01:42
How to add a stamp in a PDF file
We use powerful PDF in our daily life nearly every day.In our daily work and study, we can insert a stamp in the PDF file to indicate that the file has already been reviewed.Now we are going to introduce the Stamp WPS Premium feature.Click the Comment tab and then click Stamp. Here, WPS has provided us with a large variety of presets. We can click the needed stamp style and place it in the appropriate area of the page. We can also customize the stamp. Click Click to Add, then the Add S....
How to use the Excel MID function01:54
How to use the Excel MID function
When using WPS Spreadsheets to process data, sometimes we need to catch part of the data from a series of numbers. We can use the MID formula to realize it, to catch up a certain length of characters from a series of numbers. In this example, there is a list of phone numbers. The MID function can extract the long series of numbers, keeping the last seven numbers when removing the first three characters. Select cell D2 and click the Insert Function to pop up the Search for a function d....
How to apply accounting number format in WPS Spreadsheet00:56
How to apply accounting number format in WPS Spreadsheet
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Counting the amount in areas of finance and accounting is quite necessary. Take this Budgetary sheet as an example. The table's currency symbols and decimal points are badly aligned, which is not convenient for us to consult and calculate. How can we improve it? Select the cells D7-D15. Click Number Format in the Home tab, and select More Number For....
How to consolidate data in WPS Spreadsheet01:28
How to consolidate data in WPS Spreadsheet
In daily work, we often need to summarize and calculate some related data. By using the Consolidate feature, we can quickly calculate the data in multiple worksheets. This feature can be also used in Microsoft Office Excel and Openoffice. Now let's learn it together! Take the following table as an example. You can see that there are sales data from different staff. Now we want to count the total sales volume of all employees. 1. Create a summary sheet in Spreadsheet.2. Select cell....
TEXT formula in WPS Spreadsheet03:09
TEXT formula in WPS Spreadsheet
The TEXT formula in Excel is commonly used for the conversion of number-to-text in a certain format, and it could be also used in Microsoft Office Excel and Openoffice. Normally, the TEXT formula is used to customize format cells in terms of actual needs. To realize it, we need to adjust the second parameter of the formula, which stands for format texts to be set. In this example, the number 2.012584, which equips with six decimal places, entered cell A2. How can we convert it into a v....
How to set character spacing in WPS Presentation01:03
How to set character spacing in WPS Presentation
When making slides in WPS Presentation, we often need to adjust the spacing between characters. By this, we can perfect the layout and make our slides easier to view.So how can we adjust the character spacing of the text content in slides? Take these slides as an example. First, click to select the text that needs to be spaced. Click the right mouse button, then click Font. Finally, click the Character Spacing tab. The Spacing is Normal by default. We can set the character spacing as E....
How to insert a background image and print it out in WPS Spreadsheet01:31
How to insert a background image and print it out in WPS Spreadsheet
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Sometimes, background images are nice-to-have if we are to beautify the table. Today, we will learn how to add a background picture and print it out. First, head to the Page Layout tab, click the Background button and select the desired images. Note: The inserted image, either too big or too small, is inappropriate. Here is a smart way for adjusting tho....