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 we communicate with each other

      447 results for how we communicate with each other

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

      447 results for how we communicate with each other

      Set Allow Users to Edit Ranges in a protected sheet

      Set Allow Users to Edit Ranges in a protected sheet

      02:04

      Set Allow Users to Edit Ranges in a protected sheet

      As we all know, we can protect the sheet by setting a password. So, can we divide this table into several ranges and set up separate passwords for each range? The answer is yes. Take this table as an example. This is a student grade table, and we need to set different passwords for each of the three ranges in the table so that the three ranges do not affect each other. Next, I will show you how to do that.Click the Review tab and the Allow Users to Edit Ranges button, and click New. In....

      Spreadsheet 62 views
      Learn PivotTable from scratch

      Learn PivotTable from scratch

      04:21

      Learn PivotTable from scratch

      PivotTable enables us to create various tables by changing its fields on each area as a kind of interactive table. With PivotTable, we can analyze and process complex data tables quickly. Take this raw data sheet as an example, which displays the sales of each branch of a brand. Now we can start to analyze its data. For example, we can analyze the total sales of each branch, the total sales of each item sold in each branch, the total sales of each item sold in each branch in each sales....

      Spreadsheet 1,901 views
      How to set the header row across pages

      How to set the header row across pages

      00:50

      How to set the header row across pages

      When using WPS Writer to create a table, except for the first page, the table on other pages does not display the header row, so we don't know what the data represents in each column. Take this document as an example. Only the first page has the header row. For beginners, they will choose to add a header row above each table manually. It's too much trouble. Today I will teach you a method to quickly set the header row across pages. At this point, we can select the header row, c....

      Writer 148 views
      How to quickly set the slide layout

      How to quickly set the slide layout

      01:13

      How to quickly set the slide layout

      When making presentation slides, how can we quickly set the layout of slides?Take these slides as an example. The overall layout is not aesthetically pleasing. Also, the placement of text and pictures is relatively random. Click the Home tab, and then click Layout. Here, WPS Office has provided us with a large variety of layout styles.Just click Tow Content, then the layout of the slideshow will immediately become neat and beautiful. Next, we can adjust the size and position of each co....

      Presentation 829 views
      How to set the line numbers in WPS Writer

      How to set the line numbers in WPS Writer

      01:56

      How to set the line numbers in WPS Writer

      The usage of Line Numbers in long documents can help readers quickly find specific lines. So, how can we add line numbers? Next, I will show you the effects of setting different line number types: 1. Click the Page Layout tab and the Line Numbers drop-down button. We can see that there are different settings in the list. We can choose the Continuous Reading option to add line numbers to the entire document. 2. Choose Restart Each Page to start with number 1 on each page. 3. Choose Res....

      Writer 782 views
      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 1,041 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
      How to set up paging or cross-page printing in WPS Writer

      How to set up paging or cross-page printing in WPS Writer

      01:47

      How to set up paging or cross-page printing in WPS Writer

      The system prints all the pages by default when printing a document. But what if we only want to print part of the pages in the document? Today we're going to share with you two solutions.l Method 1. Select the print range.Take this document as an example. If we only need to print pages 1, 4, 5, and 9, we can click the Print button in the upper left corner or press CTRL+ P to pop up the dialog box. At Page ranges, enter 1, 4, 5, 9, and insert commas to separate them from each other....

      Writer 11 views
      Prev 123...5556 Next
      WPS Academy