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

        1955 results for about wps office

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

        1955 results for about wps office

        How much do you know about data format

        How much do you know about data format

        08:41

        How much do you know about data format

        1. How to set the data format.2. How to enter the correct date and time formats.3. How to make number format and text format convert to each other.4. How to flexibly utilize the custom format.

        Spreadsheet 9.8K views
        Do you really know about the Logical functions?

        Do you really know about the Logical functions?

        11:52

        Do you really know about the Logical functions?

        1.We only need to set the logical value in advance, we can use the IF function to quickly determine whether the data meet the conditions.2. When we want to meet more than one condition at the same time, we can use the AND function; when we want to meet only one of the conditions in the case of multiple conditions, we can use the OR function.3. share how to use the function combination of IF+AND+OR in practical work.

        Spreadsheet 8.4K views
        How much do you know about data format 2

        How much do you know about data format 2

        10:25

        How much do you know about data format 2

        In this lesson we have studied the following key points:1. How to make number format and text format convert to each other?In WPS Spreadsheets, when the number entered exceeds 11 digits, it will be automatically converted into text.Text format has the following 3 features: it is aligned to the left by default; it is unable to participate in calculation; a green corner prompt will appear in the upper left corner of the cell will. The way to convert text format into number format is as ....

        Spreadsheet 28.6K 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
        Set the page printing area in WPS Office Spreadsheet

        Set the page printing area in WPS Office Spreadsheet

        00:47

        Set the page printing area in WPS Office Spreadsheet

        What should we do when we print a spreadsheet if we want to print a certain area of it? This video could help to solve the problem and could be also used in Microsoft Office Excel and Openoffice. Take this spreadsheet as an example. If we want to print the student ID, and their Chinese and mathematics scores, select this cell area, click the Page Layout tab and the Print Area drop-down button, and select Set Print Area to set the selected area as a printable area. Click Print Preview i....

        Spreadsheet 27.3K views
        Get to know the WPS Spreadsheet

        Get to know the WPS Spreadsheet

        02:04

        Get to know the WPS Spreadsheet

        WPS is an Office Software developed by Kingsoft. This video is going to introduce WPS to you. Before you start watching, remember to download the latest WPS Office Suite from our official website. After we download, open WPS. Then we will come to the workbench interface. Click the + icon in the upper left corner. We can choose to create a new document, table, slides, or PDF in the menu bar. Here, we want to create a spreadsheet, so we select Spreadsheet. Then we can see a Blank button ....

        Spreadsheet 8.3K views
        Explanation on WPS Presentation printing interface

        Explanation on WPS Presentation printing interface

        03:30

        Explanation on WPS Presentation printing interface

        When using WPS Office to print various files, we often encounter different small problems. This video will briefly explain the function of each small feature of the printing interface, and it could be compatible with Microsoft Office powerpoint. If you want to learn more printing skills, you can search printing in our WPS Academy to enjoy more related videos. Take this slide as an example. First, we need to determine that the printer hardware can work properly and is now running. We al....

        Presentation 90.5K 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
        Prev 1 2 3 ... 244 245 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