WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how is information technology affecting education

    77 results for how is information technology affecting education

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

    77 results for how is information technology affecting education

    How to insert a signature in a PDF file

    How to insert a signature in a PDF file

    02:16

    How to insert a signature in a PDF file

    We use powerful PDF in our daily life nearly everyday. WPS pdf converter is easy and free for people to use.Nowadays, electronic information technology is developing rapidly. Many companies have adopted paperless contracts, and we often need to sign a contract or agreement on an electronic device. Now we have received a PDF contract from another company, and we need to sign it. So how can we insert a signature in the PDF file?1. Click the Insert tab, and then click the Sign drop-down m....

    PDF 0.16 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 0.2292 views
    How can we use the data validation feature

    How can we use the data validation feature

    02:46

    How can we use the data validation feature

    We can greatly improve the accuracy of data entry in our work if we use the data validation feature of WPS Spreadsheet. Take this table as an example. This is the information collection form for US citizens joining tour groups for international travel. We need to fill in the information of all the participants. How can we ensure that the passport numbers and phone numbers we entered will not be wrong? 1. First, select the cell area where data needs to be filled.2. Click the Data tab.3.....

    Spreadsheet 0.189 views
    How to use OCR in PDF

    How to use OCR in PDF

    01:16

    How to use OCR in PDF

    Optical character recognition, also called OCR, is practical to extract text information from a picture. It can also maintain the content layout in the source picture. The first example will show you how to extract text from a picture.1. Go to the Tool tab and click OCR.2. In the pop-up dialog, click Screen Capture to take a screenshot of a selected area.3. Choose Extract text only.Then, we can get the text from the dialog on the right-hand side.If you've joined WPS Premium, you ca....

    PDF views
    How to export Presentation as PDF

    How to export Presentation as PDF

    02:21

    How to export Presentation as PDF

    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. PDF is the abbreviation of Portable Document Format with many advantages, such as being compatible with multiple platforms, keeping original file layout, allowing file encryption and so on.So, how do we export the WPS Presentation as a PDF?Take this slide as an example, click the Tools tab above, and then click the Export to PDF button.....

    Presentation views
    INDEX MATCH formulas

    INDEX MATCH formulas

    02:11

    INDEX MATCH formulas

    In the previous videos, we've learned about the usages of INDEX and MATCH formulas, respectively.The INDEX function can return a value in a cell regarding its column and row number in an array. Combining the INDEX MATCH formulas makes it flexible in value lookup. We can break the limitations of VLOOKUP and realize the reverse lookup. Here is a form recording the personal information of staff. How can we look up the 'Number' of a corresponding staff? We can run the INDEX MAT....

    Spreadsheet views
    Display the unit symbol in the formula result

    Display the unit symbol in the formula result

    01:26

    Display the unit symbol in the formula result

    This is a table of information about the department employees. If we need to calculate the average weight of the staff, what should we do?Normally, you only need to enter the formula =AVERAGE(D2:D8) in cell D9 to get the average.However, the formula returns 0, and obviously, the result is incorrect because there are text characters in the cells, which affects the accuracy of the calculation. Do you know how to retain the weight unit and normally perform the calculation at the same time....

    Spreadsheet views
    How can we set header and footer

    How can we set header and footer

    02:17

    How can we set header and footer

    A formal form usually has additional information such as the company’s logo, time, and page number at the top or bottom. This specific area is called header and footer. Do you know how we can set it? Take this table as an example. Get into the Insert tab first, and then click Header/Footer. You can also click the Header and Footer button in the Print Preview tab to set the header and footer area.After the page setting dialog box pops up, we can now see that WPS has already built in som....

    Spreadsheet 0.1492 views
    Prev 123...910 Next
    WPS Academy
    Products
    Partners