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

        1647 results for download wps office 12 3 4

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

        1647 results for download wps office 12 3 4

        Formatting time in WPS Spreadsheet

        Formatting time in WPS Spreadsheet

        01:08

        Formatting time in WPS 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 format the time. Before setting, we need to be aware of the correct way to record time.A complete-time duration consists of hours, minutes and seconds, and each value is separated by colons.For example: 12:25:25. Take this table as an example, select the cells A4-A14. Click the Number Format drop-down button in the Home tab, ....

        Spreadsheet 16.3K views
        Get to know WPS Spreadsheet

        Get to know WPS Spreadsheet

        10:26

        Get to know WPS Spreadsheet

        1. Learned the basic operation interface of WPS Spreadsheet.2. What is the difference between a workbook and a worksheet?3. know the table rows and columns, how to correctly adjust the row height column width?4. What is a cell, what is the cell area, how do we quickly locate the specified cell or cell area?

        Spreadsheet 53.6K views
        Multiple ways to use hyperlinks in WPS Presentation

        Multiple ways to use hyperlinks in WPS Presentation

        02:07

        Multiple ways to use hyperlinks in WPS Presentation

        When using WPS Presentation to make slides, we often need to add a hyperlink in the text to jump to a web page or jump to other parts of the slideshow. So how can we add a hyperlink in slides? · Add a hyperlink to jump to other slidesTake these slides as an example. 1. Select the text box where Introduction is located.2. Click the Insert tab, and then click the Hyperlink button.3. Click Place in this Document in the pop-up Edit Hyperlink dialog box.4. Then click Slide 4. Now a hyperlin....

        Presentation 13.1K views
        Hyperlink in WPS Office Spreadsheet

        Hyperlink in WPS Office Spreadsheet

        02:22

        Hyperlink in WPS Office Spreadsheet

        When we work, we often need to add hyperlinks in spreadsheets to jump to other tables or add hyperlinks to jump to web pages. So, how can we add hyperlinks to WPS Office Spreadsheet? Take this spreadsheet as an example.1. ClickStatistics and click the right mouse button. 2. In the pop-up shortcut menu, select the Hyperlink option. You can also use the Ctrl + K shortcut key to open the Hyperlink dialog box. 3. In the pop-up dialog box, click Place in this Document. 4. Under the Cell Ref....

        Spreadsheet 89.0K views
        Quickly filter classified data

        Quickly filter classified data

        01:41

        Quickly filter classified data

        How to quickly extract data of a certain category from a large amount of data? The filtering feature of WPS Office can help us to do it quickly. Take this table as an example. How are we going to filter out the data of New York? 1. Select any cell in the list.2. Click the Home tab.3. Click the AutoFilter drop-down button or use the shortcut key CTRL+Shift+L to set. Then the data list will enter the filtering state. 4. Click the gray inverted triangle arrow in the header cell of Branch,....

        Spreadsheet 37.9K views
        How to customize draw borders for tables

        How to customize draw borders for tables

        01:19

        How to customize draw borders for tables

        When using WPS Spreadsheet to create tables, we may want some of the cells in the table to have borders and some without borders. To do this, we can use the Draw Border functions to customize the drawing of cell borders, which could be also used in Microsoft Office Excel and Openoffice. Take this table as an example. 1. Click the Home tab. 2. Click the Draw Border drop-down button. 3. Select the Draw Border option in the drop-down menu. The mouse cursor will turn into a brush style. 4.....

        Spreadsheet 51.4K views
        How to fill cells with pure colors, gradient colors, and patterns

        How to fill cells with pure colors, gradient colors, and patterns

        01:57

        How to fill cells with pure colors, gradient colors, and patterns

        When using WPS Spreadsheet to write a statistical data report, we may want to emphasize the cell data. To do this, we can fill the cell with background color and pattern.Take this table as an example. 1. If we want to fill the B3:G3 cell with color, select this area first.2. Click the Home tab above.3. Then click Settings.4. And finally click Cells. Or we can use the shortcut key Ctrl+1 to open the Formats Cells dialog box. · Pure colorClick Patterns, then we can choose a pure color to....

        Spreadsheet 23.4K views
        How to trim media in WPS Presentation

        How to trim media in WPS Presentation

        00:55

        How to trim media in WPS Presentation

        To give a fluent presentation, we can insert a video into a slide as supplementary material to avoid switching back and forth. In addition to inserting videos, WPS Presentation also supports trimming media. Take this presentation as an example. 1. Select the video. 2. Then WPS Presentation jumps to Video Tools automatically.3. Here we can click Volume to set its volume. For example, we choose Low. 4. If we need to trim the beginning and end of the video, click Trim Media.5. In the Trim....

        Presentation 6.1K views
        Prev 1 2 3 ... 205 206 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