WPS Academy
Free Download
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches

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

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

        191 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 8.9K 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 9.4K 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 13.0K 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 46.9K 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 6.2K views
        How to add a watermark

        How to add a watermark

        02:14

        How to add a watermark

        WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently.We often see unique watermarks printed on the back of some files. Adding a watermark can not only prevent others from embezzling but also can help us to indicate the source of the article. So how can we add a watermark to a document?To show the source, we need to add the watermark of WPS Academy to the following documents now.1. After cl....

        Writer 15.6K 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 35.5K views
        Why error message #NAME? occurs and how to solve it

        Why error message #NAME? occurs and how to solve it

        03:29

        Why error message #NAME? occurs and how to solve it

        When processing data in a table, the #NAME error might occur. There are four possible causes: first, the formula name was misspelled. Second, the double quotation marks were omitted for text values. Third, the colon was omitted in a range reference. Fourth, the formula refers to a name that has not been defined. First, the formula name was misspelled Take this table as an example. When we use the formula =SUN(C3:C12) to calculate the total sales of all products, the calculation result ....

        Spreadsheet 7.9K views
        Prev 1 2 3 ... 23 24 Next
        WPS Academy
        Products
        WPS Office for Windows
        WPS Office for Mac
        WPS Office for Android
        WPS Office for iOS
        WPS Office for Linux
        Partners
        Links
        OEM Partners
        Strategic partners

        Follow us

        WPS Office Official Twitter

        WPS Office Official Facebook

        WPS Office Official YouTube