465 results for All
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
465 results for All
How to insert the object in WPS Spreadsheet
01:30How to insert the object in WPS Spreadsheet
Take this table as an example. In order to better supplement the content of the table, we can insert the objects we need in the table. First, select cell F2, click the Insert tab, and the Object button. We can choose Create new or Create from file on the left side in the pop-up dialog. In the Create new interface, we can select different types of blank documents in the Object type area, and we can edit them manually.In the Create from file interface, we can insert local documents, appl....
Four View Modes in WPS Writer
02:26Four View Modes in WPS Writer
No matter you are a student, teacher, or business professionals, you can create and edit documents efficiently by WPS Writer as text editors. We can choose different view modes according to the needs of our daily file reading. Take this document as an example. I will demonstrate four view modes of text. First, click the View tab. 1.Full Screenl If we only want to display the editing area, click Full Screen or use the shortcut Ctrl+Alt+F.l The document will be displayed on full screen,....
How can we format cell values
01:57How can we format cell values
Cell formatting is an important feature of spreadsheets. So today, we will briefly go through how to format cell values. Number formatting can be simply understood as a digital form that can be used for calculations.Take this table as an example: now the data in the cell is in text formatting. If using the SUM function to do calculations, we would find that the data in text format cannot be calculated. At this time, we need to convert the data into a number formatting that can support ....
Create simple and intuitive mini charts
03:10Create simple and intuitive mini charts
The mini chart can help us to compare and analyze data of a row or column. It is very useful when presenting data. So in this video, we are going to show you how to create simple and intuitive mini charts.In Sheet1, we can see Monthly sales of clothing. But we can't visually tell the difference between sales each month. Therefore, we should use the mini chart.1. Click the Insert tab.2. Click the Line buttons.3. Now a Create Sparklines dialog box will pop up.4. Select cells B3:J3 as....
Unique features in Eye Protection Mode
01:37Unique features in Eye Protection Mode
WPS Office Suite is a high-performance and reliable office suite designed to protect data and information for both PC and mobile office software users.Long-time staring at the screen when using office software can cause eye irritation. At this point, we can relieve tired eyes by adjusting the theme or colour of the document. Eye Protection Mode is not available in Microsoft Office yet. But we can adjust the theme colour to relieve eye strain.Click File, then get into the Options inter....
How to insert a text box in Spreadsheet
03:13How to insert a text box in Spreadsheet
The inserted text in a table may be limited by cells. At this time, the text box can become your first choice to beautify your texts. It is rather simple to insert a text box. Click the Insert tab, then select the Text Box drop-down button.You can choose Horizontal Text Box and Vertical Text Box, and the difference lies in the arrangement direction for text. You can benefit from two sides.First, the text box can be dragged at your will. For example, there are multiple paragraphs of tex....
Quickly locate the name of the row and column where the cell is located
01:22Quickly locate the name of the row and column where the cell is located
We often deal with tables with vast amounts of data at work. When we move the page, we can locate the content we are focusing on, but we cannot quickly know the row and column names of the cells. But now, with the Reading Layout of WPS Spreadsheet, users can quickly locate the row and column names of the cells that they are concerned about. Take this table as an example. Click the View tab, and then the Reading Layout drop-down button. In this mode, once a cell is selected, we can fin....
Text to Columns: Sort data quickly
02:03Text to Columns: Sort data quickly
When creating tables, we sometimes need to import data from outside, and this data often requires secondary classification processing. We now want to classify the data in the table into Name, Age and Telephone. So how can we do that?1. We select column A, click the Data tab.2. Click the Text to Columns drop-down button. 3. Then select the Text to Columns option in the drop-down menu.In the popup dialog box, we can see two options.+One is Delimited. Here, we can use symbols as the basis....