- All Tutorials
- Video Tutorials
- Quick Tutorials
222 Search results
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 set the picture outline in WPS Presentation01:48
How to set the picture outline in WPS Presentation
When creating a presentation file, inserting too many pictures can easily lead to messy typesetting. Properly adding outlines to pictures can highlight key pictures and make the layout more logical and the slides more beautiful. Select the picture, click the Picture Tools tab, and then click the Picture Outline drop-down button. Here, we can set the Colors, Weight, and Dashes of the Picture Outline with just one click. If we want to set the Picture Outline further, we can click the Mor....
How to set the text outline in WPS Presentation01:49
How to set the text outline in WPS Presentation
When creating slides with WPS Presentation, adding outlines to the specific text can beautify the text and make the presentation file look more professional. So, how can we add the text outline? Select the text, click the Text Tools tab, and click the Text Outline drop-down button. Here, we can set the Colors, Weight, Dashes of the Text Outline with just one click. If we want to further set the Text Outline, we can click the More Text Outline button. Then, the Object Formatting task pa....
A quick way to calculate sum, average, count, max, and min01:34
A quick way to calculate sum, average, count, max, and min
Here we have received a sheet on the Masks Sales in Single-Day Sheet from a supermarket. How can we quickly calculate the sum, average, maximum, and daily sales volume during the period from August 19th to 31st?We can use the AutoSum feature of the WPS Spreadsheet, rather than calculating all data one by one with a calculator, which would be a waste of time. Follow these step.1. Select the data area, click the AutoSum drop-down button in the Formulas tab.2. Find the Sum button and clic....
How to hide columns in excel
· Hide a single column1. Right-click on the target column for operation.2. Choose Hide from the pop-up list. · Hide a columns within a continuous range range1. Right-click to select a continous column range.2. Choose Hide from the pop-up list. · Hide multiple column selections 1. Long-press Ctrl on the keyboard, while using the mouse to left-click the columns for operation.2. Right click on the last column(s) selected, and choose Hide from the list. To be office excel advanced, you cou....
The COUNTA function in excel
In WPS Spreadsheet, the COUNTA function can help us count the amount of cells left non-empty. · The COUNTA function:=COUNTA(value1, [value2], ...) · Use the COUNTA function for total attendance:In the following example, we use the COUNTA function to calculate total attendance. 1. Enter the formula =COUNTA(C5:C11)2. Press Enter to get the result. As we can see, since 4 cells in total are filled with '√', the result is '4', with the empty cells skipped.Use the COUNTA func....
How to unhide rows in excel
When using WPS Spreadsheet to process data, the Hidden Row function can hide the data temporarily not in need. The double line presents in between two columns means one/several column(s) has/have been hidden. For instance, Column B is hidden in the following screenshot. How can we show the hidden rows again in excel?1. Select Columns A to C.2. Right-click on it, and choose Unhide. To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.
How to hide rows in excel
· Hide a single row1. Right-click on the target row for operation.2. Choose Hide from the pop-up list. · Hide rows within a continuous range range1. Right-click to select a continuous row range.2. Choose Hide from the pop-up list. · Hide multiple row selections 1. Long-press Ctrl on the keyboard, while using the mouse to left-click the rows for operations.2. Right-click on the last row(s) selected, and choose Hide from the list. To be office excel advanced, you could learn how to use....