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 has communication changed in the last 50 years

      23 results for how has communication changed in the last 50 years

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

      23 results for how has communication changed in the last 50 years

      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 use the OR Function

      How to use the OR Function

      01:40

      How to use the OR Function

      WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. This is a promotion application form submitted by employees. The company sets two conditions for it.1. Length of service should be more than 3 years; 2: Personal KPI should be rated as A.The Applicant has the qualification to register when any one of the requirements is met. If you are the HR of the company, how can you quickly select qualified employee....

      Spreadsheet 38 views
      Set the date format cells

      Set the date format cells

      01:40

      Set the date format cells

      In practical work, we often need to enter the date in the spreadsheet. There are many data format types, so how do we set the date formats as we need? Take this spreadsheet as an example. Select the spreadsheet area, right-click the mouse, and select Format Cells from the shortcut menu. The shortcut key is Ctrl+1. In the pop-up Format Cells dialog box, select Date. There are many date formats in Type. We can choose the Wednesday date format, its abbreviated format, or the date format o....

      Spreadsheet 3,930 views
      How to start auto numbering from 1

      How to start auto numbering from 1

      01:45

      How to start auto numbering from 1

      Sometimes the paragraphs must be automatically numbered to make the text more logically acceptable.For example, we are typesetting the paper. And according to the typesetting requirements, the heading doesn't need to be numbered, while the body part does, and each numbering starts from 1. How can we operate?1. Let's number the body part first. Hold down the Ctrl key, and press the left mouse button to select discontinuous body parts. Then click Home and Numbering. We can see th....

      Writer 14 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
      Use VLOOKUP function to create dynamic charts

      Use VLOOKUP function to create dynamic charts

      03:44

      Use VLOOKUP function to create dynamic charts

      In the last video, we introduced the tips for making dynamic charts quickly. And this video will show you how to create dynamic charts with the help of the VLOOKUP function. Some knowledge points such as drop-down lists, VLOOKUP function, and absolute references are involved in making dynamic charts. If you are not familiar with these knowledge points, you're welcome to enter WPS Academy to search for learning. Take this table as an example. We're going to create a dynamic char....

      Spreadsheet 144 views
      How to set the slide size in WPS Presentation

      How to set the slide size in WPS Presentation

      01:28

      How to set the slide size in WPS Presentation

      When using WPS Presentation to make slides, we need to set the slide size first. So how can we set the slide size? First, click the Design tab above, and then click the Slide Size button. Here, we can quickly adjust the slide size, such as the commonly used Standard Screen 4:3 or Wide Screen size 16:9.If we need to set other sizes, we can click Custom Size to open the Page Setup dialog box for more detailed slide settings. By clicking the Page Setup button in the Design tab, we can als....

      Presentation 2,183 views
      Fill handle: Use Ctrl+D to fill

      Fill handle: Use Ctrl+D to fill

      01:07

      Fill handle: Use Ctrl+D to fill

      We sometimes need to deal with tables containing various content. Then we may find it troublesome even to use the fill handle to pull down and fill. Here, we will introduce two convenient methods to you. The first method is to double-click the fill handle. After filling the first data in column A, double-click the fill handle, then the data will be automatically filled in sequence order. Now we can see the data has been filled automatically in the row range of column B. In the digital ....

      Spreadsheet 65 views
      Prev 123 Next
      WPS Academy