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

        2922 results for All

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

        2922 results for All

        AVERAGE function quickly average data

        AVERAGE function quickly average data

        00:57

        AVERAGE function quickly average data

        In WPS Spreadsheet, we can use the AVERAGE function to quickly find the average value of a set of data quickly. It is often used to calculate average wages, average sales, and so on. Take this table as an example. We now need to find the average sales of the bakery this week. After we click cell D4, click Insert Function, and enter AVERAGE in the Search for Function of the dialog box. Click the OK button, and then the Function Arguments dialog box will pop up. The data we filled in Num....

        Spreadsheet 33.1K views
        Set the text wrapping type in WPS Writer

        Set the text wrapping type in WPS Writer

        01:40

        Set the text wrapping type in WPS Writer

        After inserting the picture in the document, how can we set the text wrapping style? Take the word document as an example. This video could be also used in Microsoft Office Word and Openoffice. After clicking the picture, click the Wrap Text button in the floating toolbar to the right of the picture. We can choose a variety of text wrapping styles here. Click View more, and the Layout dialog box will pop up, which allows us to set the wrapping style more accurately.In the Text Wrapping....

        Writer 32.8K views
        How we can use the settings of borders and shading

        How we can use the settings of borders and shading

        01:43

        How we can use the settings of borders and shading

        When we are using WPS Document to edit text, we sometimes need to put a border around the text, or we may also want to add a special shading color to the text in order to highlight the keywords. So now the problem is, how can we do that? Take this resume as an example. If we want to highlight the border, we should select all the content first, and click the Home tab, and then lick the Outside Borders drop-down button. Here, we can see different styles of border lines. Click Borders and....

        Writer 32.5K views
        How to convert PDF files into documents

        How to convert PDF files into documents

        01:58

        How to convert PDF files into documents

        We use powerful PDF in our daily life nearly every day.In our daily work, we often need to edit the file twice. If it involves large-scale changes, we can try the PDF to Word feature of WPS Premium. By using this, we can convert the text and pictures quickly in the PDF file into an editable document file.Take this PDF file as an example. Click the Home tab, and select PDF to Word in the PDF to Office drop-down menu. We can also click Tools. Then click the PDF to Word button to enter th....

        PDF 32.2K views
        How to convert Excel to PDF

        How to convert Excel to PDF

        02:50

        How to convert Excel to PDF

        PDF is a highly compatible format that occupies little space and is easy to transfer. Converting a table into a PDF file is often needed in daily study and work. Here are the steps. Take this table as an example. Click the Tools tab, then click the Export to PDF button. A dialog box Export to PDF will pop up, where you can select the small icon to the right of the file name to rename it. We can choose Active sheet for multi-page tables to set the export range.When we want multiple tabl....

        Spreadsheet 30.2K views
        How to quickly set the font style

        How to quickly set the font style

        01:50

        How to quickly set the font style

        In the process of making WPS Presentation, we can set the font of slides to standardize the style. Take this file as an example. Select the content you need to set the font, click the right mouse button, and then click Font in the shortcut menu. In the pop-up dialog box, we can set the Font, Size, Effects and so on. We can set the font types in the Asian text font box and Latin text font box. In the Font style box, we can set the style of the selected content, such as Regular, Bold, It....

        Presentation 30.2K views
        How to add text superscript and subscript

        How to add text superscript and subscript

        01:11

        How to add text superscript and subscript

        When editing chemistry and mathematics data, we often use superscript or subscript to represent special symbols. Take this document as an example, m2 represents the square in the unit area. How can we set the number 2 as a superscript? Select the number 2. In the Home tab, click the Superscript button. Or we can use the shortcut key Ctrl+Shift+= to set the number as a superscript.Numbers in some chemical symbols need to be set as subscripts, such as O2, N2. Select the number 2 in O2. I....

        Writer 30.2K views
        How to set the table properties in WPS Writer

        How to set the table properties in WPS Writer

        02:19

        How to set the table properties in WPS Writer

        After we insert the table in the document, we may want to set the table. So how are we going to do that? Take the table in this document as an example. The width of the table is too long. If we need to adjust it, just click the cross cursor in the upper left corner of the table. Select the entire table, click the Table Tools tab, and click the Table Properties button. Now we can see a dialogue box has popped up. In the Table tab, we can enter an appropriate value in Size to adjust the....

        Writer 30.2K views
        Prev 1 ... 9 10 ... 365 366 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