WPS Academy
Free Download
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how to alphabetize a column in excel

    3066 results for how to alphabetize a column in excel

    • All Tutorials
    • Video Tutorials
    • Quick Tutorials
    • All
    • Spreadsheet
    • Presentation
    • Writer
    • PDF

    3066 results for how to alphabetize a column in excel

    How to draw a column chart in WPS Spreadsheet

    How to draw a column chart in WPS Spreadsheet

    01:46

    How to draw a column chart in WPS Spreadsheet

    A Column chart can help us to visually compare data differences and is also one of the chart styles often used in work.Take this table as an example, how can we quickly compare the differences in sales of each country each country's sales? 1. Click Insert, click Chart, and click Column.2. Click the column with the mouse, and then the editing window will pop up on the right. Then, we can modify the color of the column in FILL&LINE. 3. Click SERIES. We can adjust the gap between the....

    Spreadsheet 5.8K views
    How to set a worksheet in WPS Spreadsheet

    How to set a worksheet in WPS Spreadsheet

    03:53

    How to set a worksheet in WPS Spreadsheet

    The Worksheet feature of the WPS Spreadsheet can perform several basic operations on the table. So now I'm going to show you the usage of Worksheet feature that it could be also used in Microsoft Office Excel and Openoffice. · Insert SheetClick the Home tab, select Worksheet, then select Insert Sheet. Now we can set the number and position of the insert in the popup dialog box. Or we can also click the plus sign in the bottom column of the table to add directly.· Delete SheetClick....

    Spreadsheet 5.5K views
    How to group data in a spreadsheet

    How to group data in a spreadsheet

    02:01

    How to group data in a spreadsheet

    When using WPS Spreadsheets to process data reports, grouping data in proper ways can present data more clearly and boost our productivity. The spreadsheet in this example presents a company's sales performance during the first half of a year. To make it more convenient for data viewing, we can group the data belonging to the same category. 1. Select cells of Column B and Column K. 2. Get into the Data tab, and click the Group button. (Tips: You can also press the shortcut keys Shi....

    Spreadsheet 4.2K views
    How to insert shapes in a worksheet

    How to insert shapes in a worksheet

    01:20

    How to insert shapes in a worksheet

    We can insert shapes into a worksheet with WPS Spreadsheet. For example, we can insert shapes as background into the four cells. This operation will emphasize the content in the corresponding cells. How can we realize it? Get into the Insert tab, and click the Shapes dropdown button. Then choose a shape that you want in the dropdown menu. In this example. we choose the Rounded Rectangle button. As you can see, the cursor turns into a cross + symbol. We can use it to draw a shape where....

    Spreadsheet 3.3K views
    How to create a Form in spreadsheet

    How to create a Form in spreadsheet

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

    Spreadsheet 5.0K views
    How to add a stamp in a PDF file

    How to add a stamp in a PDF file

    01:42

    How to add a stamp in a PDF file

    We use powerful PDF in our daily life nearly every day.In our daily work and study, we can insert a stamp in the PDF file to indicate that the file has already been reviewed.Now we are going to introduce the Stamp WPS Premium feature.Click the Comment tab and then click Stamp. Here, WPS has provided us with a large variety of presets. We can click the needed stamp style and place it in the appropriate area of the page. We can also customize the stamp. Click Click to Add, then the Add S....

    PDF 3.2K views
    How to crop the picture in a table

    How to crop the picture in a table

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

    Spreadsheet 22.3K views
    How to create a scatter chart in WPS Spreadsheet

    How to create a scatter chart in WPS Spreadsheet

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

    Spreadsheet 3.7K views
    Prev 1 2 3 ... 383 384 Next
    WPS Academy
    Products
    Partners

    Follow us

    WPS Office Official Twitter

    WPS Office Official Facebook

    WPS Office Official YouTube