517 results for create a pivot table in excel
- All Tutorials
- Video Tutorials
- Quick Tutorials
517 results for create a pivot table in excel
How to create a table with one click01:35
How to create a table with one click
Did you know that, when you are using WPS Spreadsheet, you can directly create a table in the original datasheet? The generated table comes with functions such as sorting, filtering, and setting styles, which can save us a lot of time for subsequent operations. For all, easy our work with WPS Spreadsheet like Microsoft Excel. Here are the steps to create a table. Take the sales table in this article as an example. 1. Click the Table button in the Insert tab. (Notes: You can also use th....
How to create a Form in spreadsheet01:26
How to create a Form in spreadsheet
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. ....
Insert a symbol in the table02:36
Insert a symbol in the table
When using WPS Spreadsheet, we often need to insert some special characters in the text content. Sometimes when we need to insert special symbols such as m2, ℃, etc., it is not quite convenient to use the keyboard to input them. At this time, we can use the Symbol feature of WPS Spreadsheet to meet our needs. Take this table as an example. This is the Weekly Attendance Sheet of employees. We now need to add an area unit m2 after 1000 in the third row. Click the Insert tab, and then cli....
How to insert a table of contents in word02:00
How to insert a table of contents in word
A table of contents, also called TOC, is a significant part of an article. It can help readers to get the outline quickly and locate the target part. In WPS, we can insert a table of contents in a convenient way. Click the blank page inserted at the beginning of the article. Get into the Reference tab, and click Table of Contents. In the dropdown menu, we can choose from three styles of the table of contents, which presents in different layouts. Since we have "Heading 1", "Heading 2", ....
How to insert a table in WPS Presentation01:47
How to insert a table in WPS Presentation
When creating a presentation in WPS Office, sometimes we need to insert a table for data demonstration. How can we realize it? Take this PowerPoint as an example. Get into the Insert tab and click the Table dropdown menu. Then drag the cursor to decide the table size. This method allows us to create a table with 10 columns and 10 rows at maximum. If we want to insert a bigger table, choose Insert Table. In the Insert Table dialog, we can decide the numbers of columns and rows. Enter t....
How to crop the picture in a table01:30
How to crop the picture in a table
Sometimes we need to crop the picture into the shape we want after inserting it. So how can we do that? Take this table as an example. We have inserted a picture of the clothes on the table, but the picture is a little large. We need to crop it into the right shape and size. Click on the picture to jump to the Picture Tools tab. Click the Crop drop-down button, and we can see two options. Here we select Crop by Scale to adjust its scale. We select the 1:1 scale to crop the picture. No....
How to create a scatter chart in WPS Spreadsheet02:53
How to create a scatter chart in WPS Spreadsheet
A scatter chart in WPS Spreadsheet is normally called an X-Y graph. It presents all the data as points on rectangular coordinates, showing the relationships between variables. The scatter plot is a great graphical tool that we often use for statistical modelling. Take this table as an example. This is a set of height and weight data of boys and girls. If we want to observe the relationship between the two variables: height and weight, with the help of a scatter chart, how can we do tha....
How to create a flowchart in Word03:14
How to create a flowchart in Word
We often need to paint various Flowcharts in the office routine. In WPS Writer, we can make flowcharts easily with the Insert Shapes function.There are many kinds of flowcharts. Today, we will give an example to illustrate better. Step one, insert a drawing canvas.Click Insert, then click Shapes and select New Drawing Canvas to add one.A great benefit is that we can drag the canvas directly to move the flowchart.You can drag the position of the canvas only if the canvas is set to a te....