WPS Academy
Free Download
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches
        Related: wps downloadwps for windowswps for macwps linux download

        465 results for All

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

        465 results for All

        How to use OCR in PDF

        How to use OCR in PDF

        02:12

        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 29.5K views
        How to set the text effect of slides

        How to set the text effect of slides

        02:53

        How to set the text effect of slides

        When we use WPS presentation to make slides, text effects can be added to make the document more aesthetic and better-designed. So how can we set text effect?Take this slide as an example, select the text content, click the Text Tools tab at the top, then click Text Effects and select More Text Effects. Next, I will demonstrate different effects one by one. · 1. ShadowAdding a shadow effect to the text can make it more stereoscopic.Select the text and click SHADOW, where you can choose....

        Presentation 13.6K 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 14.8K views
        Conditional Formatting for data virtualization

        Conditional Formatting for data virtualization

        01:23

        Conditional Formatting for data virtualization

        Do you know how to virtualize data with the Conditional Formatting function? The worksheet presents the data of 'Likes to views ratios'. Today's tutorial will take this sheet as an example for data virtualising. Select the cell range B2:B10. Go to Home and click Conditional Formatting. Next, choose Data Bars and then the red Gradient Fill option. After that, we can see the data virtualized with red bars.Although the data in cell B13 is 66.42%, as we can see, the data bar fi....

        Spreadsheet 10.0K views
        Arrange tools in WPS Presentation

        Arrange tools in WPS Presentation

        01:32

        Arrange tools in WPS Presentation

        Arrange tools in WPS Presentation allow users to adjust the object layout, group objects, and rotate objects. The Arrange tools make it easier to manipulate images, shapes, and other elements. Usually, the latest created object is placed at the front of a slide.If we want to change the object layouts, here are the steps.1. Choose an object.2. Go to Home and click Arrange. 3. Choose Bring to Front in the drop-down menu. Another option to realize it is shown below.1. Select the object.2.....

        Presentation 14.5K views
        Get to Know the PDF Print Interface

        Get to Know the PDF Print Interface

        02:56

        Get to Know the PDF Print Interface

        We often need to print PDF files at work, so let's get to know the PDF Print Interface.Take this PDF file as an example. Click Menu and then click Print to get a dialog.The interface is divided into five sections: Basic Setting, Page Range, Print Handling, Page Setup and Content Settings. · Basic Setting In the Basic Setting area, we can select a printer, enter copies and check Print in Grayscale.Print in Grayscale refers to the technical process of printing color contents into dif....

        PDF 57.2K views
        How to set the picture outline in WPS Presentation

        How to set the picture outline in WPS Presentation

        01:48

        How to set the picture outline in WPS Presentation

        When creating a presentation file, inserting too many pictures can easily lead to messy typesetting. Properly adding outlines to pictures can highlight key pictures and make the layout more logical and the slides more beautiful. Select the picture, click the Picture Tools tab, and then click the Picture Outline drop-down button. Here, we can set the Colors, Weight, and Dashes of the Picture Outline with just one click. If we want to set the Picture Outline further, we can click the Mor....

        Presentation 15.9K views
        How to create a Form in spreadsheet

        How to create a Form in spreadsheet

        01:26

        How to create a Form in spreadsheet

        WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Today, we will learn how to create a Form in WPS spreadsheet, which allows us to input, search and modify the data. Note: If the table contains merged cells, the Form function will be unavailable. · 1. Data inputFirst, click the Data tab and click the Form button. In the pop-up window, the system will automatically take the title row as the field name. ....

        Spreadsheet 18.3K views
        Prev 1 ... 14 15 ... 58 59 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