Download WPS Office for your device

In this lesson we have studied the following key points:1. How to create table borders and insert a diagonal line to the table header.l You can click the "Drow border" button to draw the form lines manually, or you can click the "All borders" button, which provides many border styles.l Select the targeted cell first, press the shortcut key "Ctrl+1", select "Border" >select a diagonal line border. 2. How to merge or unmerge cells.WPS Spreadsheet also provides more ways of merging cells....

Radar chart displays data information on one dimension like a spider web, allowing us to learn the relationships between each piece of data to the whole and compare them quickly.Take this table as an example, which is a table of the competency rating of three employees this year. It's difficult to find out the differences between them only with this data, so we can use a radar chart to make it clear. 1. Select the needed cell range, click the Insert tab and click the Radar drop-dow....

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....

Here are one hundred profiles of new employees, which need to be made into recruitment notices. If you are the HR of this company, how would you do that? The Mail Merge function allows you to handle these 100 notices easily. Take this document as an example. We need to input employees' names, entry time, department, position, and salary.1. Open the table that contains the information of new employees. 2. The information of the five columns will be inserted as Merge Fields. For conv....

Similar to a scatter chart, a bubble chart is mainly composed of bubbles and variables to display information. Unlike scatter charts that can only display variables in the X and Y axis, bubble charts display the skill to the third variable with bubble areas.Bubble charts can be used widely in making maps- a perfect match for displaying data with regional characteristics.This is the survey data of mobile phone sales in a certain area. Let's take it as an example to make a simple bub....

The double-layer doughnut chart can visually display the proportion of multiple data. As shown in the chart, this is the annual sales of a certain sales company. In this chart, we can see the proportion of sales per month and the sales percentage for each quarter. So how do we create the double-layer doughnut chart?First select the quarterly sales data in the cell range B2:B13, click the Insert tab and click the Insert Pie or Doughnut Chart drop-down button, then choose Doughnut in the....

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Today, we will learn how to create a Form in WPS spreadsheet, which allows us to input, search and modify the data. Note: If the table contains merged cells, the Form function will be unavailable. · 1. Data inputFirst, click the Data tab and click the Form button. In the pop-up window, the system will automatically take the title row as the field name. ....

In the last video, we introduced the tips for making dynamic charts quickly. And this video will show you how to create dynamic charts with the help of the VLOOKUP function. Some knowledge points such as drop-down lists, VLOOKUP function, and absolute references are involved in making dynamic charts. If you are not familiar with these knowledge points, you're welcome to enter WPS Academy to search for learning. Take this table as an example. We're going to create a dynamic char....