Your browser version is outdated.
To browse WPS Academy normally, we recommend you to upgrade to the latest version of Internet Explorer or try other browsers.
chrome
Chrome
firefox
Firefox
WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches
      • Home
      • Popular
      • how to sort a pivot table

      667 results for how to sort a pivot table

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

      667 results for how to sort a pivot table

      How to set the calculated field of the pivot table

      How to set the calculated field of the pivot table

      01:49

      How to set the calculated field of the pivot table

      We often need to use a pivot table to calculate sales in the work of commodity sales. So how can we quickly count the sales by setting the calculated fields of the pivot table?Take this pivot table as an example. As is shown in this pivot table, if we want to count the total sales, average sales, maximum sales, and minimum sales of each product, we only need to enter the fields in the pivot table to set it up.First, we need to drag the Total sales field to the VALUES list box three tim....

      Spreadsheet 1,773 views
      How to sort with a custom list

      How to sort with a custom list

      01:36

      How to sort with a custom list

      How can we sort the table with a custom list when designing a report? Today, we will learn how to create a custom list for sorting.For example, we want to sort this table by position. Click Custom Sort in the Data tab to pop up a dialog.By default, the system sorts letters and integers in ascending or descending order on their values.Click the drop-down list at Order and select Custom Lists.Custom lists on the left tell the built-in sorting rules. We can customize the sorting rules at ....

      Spreadsheet 6 views
      How to sort text in WPS Writer

      How to sort text in WPS Writer

      02:37

      How to sort text in WPS Writer

      When editing documents with WPS Writer, here are three options to sort the data. ONE: Sort by paragraphsTake this document as an example. If we want to sort the data in ascending order, how can we realize it?1. Select the text content.2. Go to Home and click Sort. After that, a dialog box will pop up. 3. Go to Sort by, where we can choose to sort by 'paragraph', 'headings', and 'fields'; in this example, we choose 'paragraph'. We can also set the sortin....

      Writer 932 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 1,200 views
      How to add watermarks to a table

      How to add watermarks to a table

      02:19

      How to add watermarks to a table

      Watermarking a document can prevent it from being misused by others; the good news is that watermarks can be added to an excel table.We'll look at two different ways to add watermarks to your table today.The first approach is merely adding a single watermark, which can be utilized for a single-page table.Click Insert, and then click WordArt. Select a style to be inserted, and input the watermark content.The font style can be changed further by clicking Setting in Text Tools. You ca....

      Spreadsheet 4 views
      How to insert a table of contents in word

      How to insert a table of contents in word

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

      Writer 1,483 views
      How to insert a table in WPS Presentation

      How to insert a table in WPS Presentation

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

      Presentation 302 views
      How to create a table with one click

      How to create a table with one click

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

      Spreadsheet 996 views
      Prev 123...8384 Next
      WPS Academy