- All Tutorials
- Video Tutorials
- Quick Tutorials
648 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 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....
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 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....
How to insert and set pictures in WPS Spreadsheet02:19
How to insert and set pictures in WPS Spreadsheet
When using WPS Spreadsheet, we often need to add pictures for a more visual presentation. So how can we insert a picture into the table? Select the cell where you want to insert a picture, click the Insert tab, and then click Picture. Here we can choose Floating Picture or Embed to Cell. Floating Picture allows pictures to float above cells, then we can move and resize the picture at will. Embed to Cell is to pin the picture within a cell. We can't move the picture but only control....
How to crop pictures in WPS Presentation01:19
How to crop pictures in WPS Presentation
After inserting a picture in WPS Presentation, we can use the Crop tool to modify the shape and the scale of the picture and make it look better. Select the picture in the presentation to get into the Picture Tools tab, and click the Crop drop-down button.There are two different crop modes to choose from, Crop by Shape and Crop by Scale. · 1. Crop by ShapeHere, WPS Office provides us with a variety of shapes.If we want to crop the picture to a rounded rectangle, click Rectangle and sel....
How to insert attachments in WPS presentation01:06
How to insert attachments in WPS presentation
When editing slides, to explain the content more specifically, we sometimes need to add related attachments to the slides. We can use the Insert Attachments feature to directly open the attached files in the slides to avoid switching pages frequently during a presentation. So how can we do that? Take this work report as an example. To better enumerate the work completed in August, we can insert the WPS Spreadsheet attachment in the slide.1. Click the Insert tab, then click the File Obj....
How to use WPSArt in WPS Presentation01:51
How to use WPSArt in WPS Presentation
Are you still struggling to create a hierarchy like this one when you use WPS Presentation to make the company's annual report? Next, let's learn how to quickly create a hierarchy. Click the Insert tab and the WPSArt button to pop up the Insert WPSArt Dialog pane. Here, we can see the different types of Hierarchy. Click the graphic, and the corresponding application scenario description will be displayed on the right side.Click Hierarchy, and select one of the styles, finally c....