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

        895 results for how does technology help with communication

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

        895 results for how does technology help with communication

        SUBTOTAL function: Calculate the data with the hidden value

        SUBTOTAL function: Calculate the data with the hidden value

        02:33

        SUBTOTAL function: Calculate the data with the hidden value

        Take this table as an example. When using the SUM function to do summations, we may find two rows hidden in the table, but the result of the summation still includes the hidden value. So how can we calculate the data containing hidden values and get a result that does not include the hidden values? This video can help us and it can be also used in Microsoft Office Excel and Openoffice. In this case, we can use the SUBTOTAL function. Next, we are going to show you the usage of the SUBTO....

        Spreadsheet 23.9K views
        How to set the line numbers in WPS Writer

        How to set the line numbers in WPS Writer

        01:56

        How to set the line numbers in WPS Writer

        The usage of Line Numbers in long documents can help readers quickly find specific lines. So, how can we add line numbers? Next, I will show you the effects of setting different line number types: 1. Click the Page Layout tab and the Line Numbers drop-down button. We can see that there are different settings in the list. We can choose the Continuous Reading option to add line numbers to the entire document. 2. Choose Restart Each Page to start with number 1 on each page. 3. Choose Res....

        Writer 15.1K 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
        More features in Picture to Text

        More features in Picture to Text

        01:47

        More features in Picture to Text

        Both WPS Writer and Microsoft Word have the function of Converting pictures to text. What are the differences between them? Microsoft Word itself does not support the OCR function. If you want to convert Picture to Text, you need to open another application, "OneNote."1. Copy the picture to OneNote, and right-click it to select Copy Text from Picture.2. Finally, paste the text into PowerPoint or Word as needed. In WPS Writer, it is much more convenient to do the conversion in the docum....

        Writer 8.5K views
        More features in Picture to Text

        More features in Picture to Text

        01:55

        More features in Picture to Text

        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. WPS Presentation and Microsoft Office both can convert pictures to text. Today we will analyze their differences. Microsoft PowerPoint itself does not support OCR function. If you want to realize Picture to Text, you need to open another app-OneNote.Copy the picture to OneNote, right-click the image to select Copy Text from Picture. Fin....

        Presentation 8.7K 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
        More features in Picture to Text

        More features in Picture to Text

        02:12

        More features in Picture to Text

        Both WPS Spreadsheets and Microsoft Excel have the function of Converting pictures to text. What are the differences between them? Microsoft Excel itself does not support the OCR function. If you want to convert Picture to Text, you need to open another application, OneNote. 1. Copy the picture and paste it into OneNote.2. Click Copy Text from Picture with the right mouse button3. Paste the text into Excel as needed. In WPS Spreadsheet, the OCR function allows us to convert pictures to....

        Spreadsheet 11.2K views
        Color schemes: change the theme color with just one click in WPS Presentation

        Color schemes: change the theme color with just one click in WPS Presentation

        00:52

        Color schemes: change the theme color with just one click in WPS Presentation

        When making WPS presentation files, are you still troubled by not knowing how to match colors between the elements? This Color Schemes feature will help you. Take this slide as an example. Click the Design tab above and then click the Color Schemes button. Here, WPS Office offers multiple color schemes with a sense of design. All we need to do is choose a color scheme that fits the theme of the presentation. Tips: This feature is only valid for elements that are included with the WPS P....

        Presentation 12.7K views
        Prev 1 2 3 ... 111 112 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