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
  • Home
  • Video Tutorials
    WPS Spreadsheet Data Entry and Editing Data Analysis Data Visualization Page Layout Review and Security More Functions and Formulas
    WPS Writer Text Writing Insert and Edit Page Layout Review and Security References More
    WPS Presentation View Insert and Edit Animation and Slide Show More Review and Security
    WPS PDF Multiple Editing Tools Insert More Add Comments Page Management File Format Conversion Print
  • Graphic Tutorials
    WPS Spreadsheet Data Entry and Editing Data Analysis Functions and Formulas Page Layout Review and Security More
    WPS Writer Text Writing Insert and Edit References Page Layout Review and Comments Security More
    WPS Presentation Insert and Edit Animation and Slide Show Premium Benefits More
    PDF Edit View Review and Comments Security Premium Benefits More
    WPS Basics Home Page Settings and Account Premium Benefits More
    Beginner Tutorial Preferences Settings Get Started Common Uses
  • Download
    WPS Office for Windows
    WPS Office for Mac
    WPS Office for Android
    WPS Office for iOS
    WPS Office for Linux
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches

      • Home
      • Video Tutorials
      • Graphic Tutorials
      • Home
      • Popular
      • pivot table show value as text

      189 results for pivot table show value as text

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

      189 results for pivot table show value as text

      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
      Learn pivot table from the beginning

      Learn pivot table from the beginning

      04:27

      Learn pivot table from the beginning

      A PivotTable has a flexible operation interface. We can change the layout of various types of reports only with mouse operation. It can help us better search for information and make decisions.Take this table as an example. This is the sales data of a certain company over a period of time. If we want to count the total sales of products sold by each branch, we can use the pivot table to count it quickly. This is the completed pivot table. 1. First, select any cell with data in this tab....

      Spreadsheet 4,978 views
      Formatting time in WPS Spreadsheet

      Formatting time in WPS Spreadsheet

      01:08

      Formatting time in WPS 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 format the time. Before setting, we need to be aware of the correct way to record time.A complete-time duration consists of hours, minutes and seconds, and each value is separated by colons.For example: 12:25:25. Take this table as an example, select the cells A4-A14. Click the Number Format drop-down button in the Home tab, ....

      Spreadsheet 99 views
      How to adjust the overall width and font position of the table in WPS Writer

      How to adjust the overall width and font position of the table in WPS Writer

      01:33

      How to adjust the overall width and font position of the table in WPS Writer

      After we create the table in a document, we can adjust the size of the cells and the position of the text in the table.Take this table as an example. We move the mouse cursor to where the table is located and click the cross button in the upper left corner to select all cells. Click the Table Tools tab and the Table Properties button, then a dialog box will pop up.In the Cell tab, find Size and check Preferred width. We can also adjust the width of all cells after entering the value ac....

      Writer 499 views
      SUBTOTAL function: Calculate the data with the hidden value

      SUBTOTAL function: Calculate the data with the hidden value

      02:33

      SUBTOTAL function: Calculate the data with the hidden value

      Take this table as an example. When using the SUM function to do summations, we may find two rows hidden in the table, but the result of the summation still includes the hidden value. So how can we calculate the data containing hidden values and get a result that does not include the hidden values? This video can help us and it can be also used in Microsoft Office Excel and Openoffice. In this case, we can use the SUBTOTAL function. Next, we are going to show you the usage of the SUBTO....

      Spreadsheet 1,546 views
      Why error message #DIV0! occurs and how to solve it

      Why error message #DIV0! occurs and how to solve it

      02:27

      Why error message #DIV0! occurs and how to solve it

      When calculating data with WPS Spreadsheet, the error message #DIV/0! will come to us from time to time.What caused the mistake? And how can we remove it? Take this table as an example. For example, when we want to calculate the unit price of pencils, we can enter =C3/D3 in cell E3, and the calculation result will show the error value #DIV/0! This is because, in this division operation, the denominator is 0, which leads to the calculation error. When we drop down and fill in the calcul....

      Spreadsheet 3 views
      Why error message NA occurs and how to solve it

      Why error message NA occurs and how to solve it

      02:56

      Why error message NA occurs and how to solve it

      When using the VLOOKUP function to locate data, a #N/A error sometimes will appear.Two common causes are listed as followed. The first reason: the searched value is not in the searching range. Take this table as an example. To get the sales of erasers, black pens, pencils, and blue pens, we need to insert the following formula: =VLOOKUP(F3,A2:D9,4,0) F3 is Lookup_value, Eraser is the value to look for. A2:D9 is Table_array, the entire table is the range containing the data to look for.....

      Spreadsheet 10 views
      Get to know the cell widget

      Get to know the cell widget

      02:38

      Get to know the cell widget

      Today we are going to show you how to use the cell widget in WPS Spreadsheet. The functions of it are very practical useful. Let's learn this feature together! · Convert Text to Number In WPS Spreadsheet, the text formatting is quite special. 1. It cannot be directly converted to other formats. 2. The text formatting is aligned to the left, and other formattings are aligned to the right. Take this table as an example. We now need to change the date in the table to another type. By ....

      Spreadsheet 535 views
      Prev 123...2324 Next
      WPS Academy
      Products
      WPS Office for Windows
      WPS Office for Mac
      WPS Office for Android
      WPS Office for iOS
      WPS Office for Linux
      Affiliate Program
      Links
      OEM Partners
      Strategic partners
      Enterprise Sales
      Popular Searches
      Partners
      WPS Office for Windows
      WPS Office for Mac
      WPS Office for Android
      WPS Office for iOS
      WPS Office for Linux
      Affiliate Program
      Links
      OEM Partners
      Strategic partners
      Enterprise Sales
      Popular Searches