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 have smartphones changed the way we communicate

      245 results for how have smartphones changed the way we communicate

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

      245 results for how have smartphones changed the way we communicate

      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
      Use Validation to restrict data change

      Use Validation to restrict data change

      02:24

      Use Validation to restrict data change

      We want to lock the cells after checking the table data and prevent it from being further changed. What can we do?In today's tutorial, you will learn how to use the Validation function to restrict data change.Step one, select the E column, and then add a drop-down list named checked.Click Validation at Data, and you can also use the shortcut Alt+D+L.In the Setting tab, select List at Allow, and enter checked at Source. Finally, click OK.By doing so, we can select checked in the dro....

      Spreadsheet 4 views
      How to align fonts in WPS Presentation

      How to align fonts in WPS Presentation

      01:09

      How to align fonts in WPS Presentation

      Within the same text box, we can align different texts in different ways. Today, we will learn how to set them. Take this text as an example. When we decrease the font size of part of the text, we will find that the typesetting between these fonts with different sizes has changed. This is because they are set differently in Align Font.Select the text box, get into the Text Tools tab, and click the Align Font drop-down button.Select Roman, and both texts will be aligned according to th....

      Presentation 15 views
      How to insert a background image and print it out in WPS Spreadsheet

      How to insert a background image and print it out in WPS Spreadsheet

      01:31

      How to insert a background image and print it out 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. Sometimes, background images are nice-to-have if we are to beautify the table. Today, we will learn how to add a background picture and print it out. First, head to the Page Layout tab, click the Background button and select the desired images. Note: The inserted image, either too big or too small, is inappropriate. Here is a smart way for adjusting tho....

      Spreadsheet 2,489 views
      How to set the text direction in WPS Writer

      How to set the text direction in WPS Writer

      01:47

      How to set the text direction in WPS Writer

      Usually, when editing a document, the text is input horizontally from left to right by default. In the following video, we will teach you how to change the direction of the text. First, select the text that needs to be changed, and click the Text Direction drop-down button in the Page Layout tab. Here, we can see six styles in the list. 1.Horizontal Text Box: This is the default text direction in WPS Writer. 2.Vertical from right to left: At this time, the text is vertical and aligned ....

      Writer 416 views
      How can we insert symbols in WPS Writer

      How can we insert symbols in WPS Writer

      01:50

      How can we insert symbols in WPS Writer

      When we edit a document, we will inevitably need to enter some symbols that are not directly entered by the keyboard input method. So, how do we insert the special symbols that we need? Take this document as an example. We want to tick the tourist attractions we have visited to facilitate statistics. Click the position where we want to insert the symbol and click the Insert tab and the Symbol drop-down button. We can see Recently Used Symbols and Custom Symbols here. These are the ....

      Writer 5,494 views
      Use COUNTIF function for conditional statistics

      Use COUNTIF function for conditional statistics

      01:32

      Use COUNTIF function for conditional statistics

      COUNTIF is a statistical function. It is often used to count the number of cells that meet the criteria. This function can not only count numbers and text but also can count expressions. So how can we use this function? The grammatical structure of the COUNTIF function is: COUNTIF(Range, Criteria)Range is the cell range that meets the criteria.Criteria are the conditions that need to be counted.Now we have a table that records everyone's afternoon tea order information. Column B co....

      Spreadsheet 2,292 views
      Use format painter to adjust the styles in batches

      Use format painter to adjust the styles in batches

      01:28

      Use format painter to adjust the styles in batches

      Are you still formatting the cells one by one? Use the format painter to quickly apply the cell format, which greatly improves your efficiency. Take this table as an example. We want to copy and paste the format of the first-row cell range elsewhere. Select the cell range in the first row, click the Home tab, then click the Format Painter button, and select the cell range you want to apply; click once. In this way, we can apply the cell formats of the first row to other cells. Then how....

      Spreadsheet 40 views
      Prev 123...3031 Next
      WPS Academy