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

        161 results for how has communication technology changed over time

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

        161 results for how has communication technology changed over time

        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 annotations to PDF files

        How to add annotations to PDF files

        02:08

        How to add annotations to PDF files

        When we read the information of certain PDF documents, sometimes we need to mark some important paragraphs or add corresponding comments to some content. Today I would like to introduce how to add annotations to PDF documents quickly. Take this PDF document as an example. Click the Comment tab, and click the Note Mode button. At this time, a blank page appears on the right side of the document body. We select the text that needs to be annotated, click the Highlight drop-down menu, and ....

        PDF 10.9K views
        How to set header and footer in odd and even pages respectively

        How to set header and footer in odd and even pages respectively

        03:08

        How to set header and footer in odd and even pages respectively

        What can we do if we want to set the header and footer in odd and even pages respectively? Take this article as an example. Double-click the header of the home page, and click the Header and Footer Options in the Header/Footer tab, then you will see a pop-up dialog box. l Page different settings 1.Check Different first page in the Page different settings to set the header and footer of the first page separately. 2.Check Different odd and even pages to set the header and footer of odd....

        Writer 10.8K 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
        Relative reference, absolute reference, and mixed reference

        Relative reference, absolute reference, and mixed reference

        03:46

        Relative reference, absolute reference, and mixed reference

        When copying formulas to other cells, we might encounter three reference modes, namely relative reference, absolute reference, and mixed reference. We need to choose the proper reference method according to the specific calculation requirements and the formula. · 1. Relative ReferenceWhen copying formulas to other cells, the formula will change according to the position of the referenced cell.Take this table as an example. Enter =B2*C2 in cell D2, and then pull down the fill handle to ....

        Spreadsheet 8.7K views
        How to use Slide Master in WPS Presentation

        How to use Slide Master in WPS Presentation

        03:29

        How to use Slide Master in WPS Presentation

        WPS Office Suite is a high-performance and reliable office suite designed to protect data and information for both PC and mobile office software users.Slide Master can be the perfect fit for improving work productivity to uniform the fonts, background, and company logos when creating new slides. Without using Slide Master, every click with New Slide means creating a new blank slide with non-uniform formats. With the Slide Master function, we only need to set the background and font of ....

        Presentation 13.4K 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 55.9K views

        How to split and wrap text into different columns in excel

        How To Split And Wrap Text Into Different Columns In Excel – WPS Academy Excel is a spreadsheet application developed by Microsoft Office. It allows users to create, edit and share spreadsheets using charts and large data sets. Excel has been around for decades and has evolved dramatically over the years. Today, it is one of the most popular data analysis software available. Few people doubt that Microsoft Excel is at the top regarding office software. At the same time, if you are new ....

        xls Spreadsheet 4.6K views
        Prev 1 2 3 ... 20 21 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