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 the Spell Check function in WPS Spreadsheet

        How to use the Spell Check function in WPS Spreadsheet

        02:15

        How to use the Spell Check function in WPS Spreadsheet

        The Spell Check function of WPS Spreadsheet can help us quickly trap misspelled words and provide suggestions for correction, greatly saving the calibration time of the table.In the Review tab, click the Spell Check button and open the Spell Check dialog box, whose shortcut key is F7.In the text box on the left, we can see some words marked in red. These are the words in which WPS Office has detected possible spelling mistakes. Take this table as an example. The cells are checked from ....

        Spreadsheet 18.5K views
        Make a countdown calendar in WPS Spreadsheet

        Make a countdown calendar in WPS Spreadsheet

        01:37

        Make a countdown calendar in WPS Spreadsheet

        It would be helpful to insert a countdown calendar into a project schedule so that we can view the deadline every time we open it. So today we are going to learn how to make a countdown calendar. Take this table as an example. 1. On the right of "Current date," input the formula "=TODAY()" and press the Enter key on the keyboard to return the current day.The Today function can synchronize the date set on the current computer so that the current date will update automatically every time....

        Spreadsheet 12.7K views
        How to merge multiple worksheets into a worksheet

        How to merge multiple worksheets into a worksheet

        01:28

        How to merge multiple worksheets into a worksheet

        By the end of the year, the Indonesian branch needs to make statistical analysis on the sales performance of the whole year. Now, we need to merge all the sales records from January to December into a worksheet, making the PivotTable function possible to use. What can we do? Go to the Data tab, click the Merge Sheet drop-down button, and click the merge multiple worksheets into a worksheet option. Click the Add File button in the pop-up dialog box, select the files from January to Dece....

        Spreadsheet 29.4K views
        How to repair files in WPS Presentation

        How to repair files in WPS Presentation

        02:05

        How to repair files in WPS Presentation

        During our daily study or work, we sometimes find that the file is full of error codes or we cannot even access it. For those who use File Repair for fixing the file, restoring it to its original state won't be a problem at all. Click the Tool tab, then click File Repair.In the pop-up dialog box, click Repair damaged file to add the error file.You can also drag the file directly to the WPS Files Repair interface, which supports multi-format files such as doc, ppt, and xls. Next, WP....

        Presentation 27.3K views
        Use Validation to prevent duplicate values

        Use Validation to prevent duplicate values

        01:23

        Use Validation to prevent duplicate values

        Sometimes we don't want to enter duplicate information from the collected data. We will take the unique telephone number as an example to show how to use the Validation function to prevent duplicate values.Select this column, and click Validation at Data, you can also use the shortcut Alt+D+L. Head to the Setting tab, click the Allow drop-down button and select Custom, and enter countif(D:D,D1)=1.This formula will make the value in cell D1 only appears once in column D; otherwise, ....

        Spreadsheet 11.5K views
        How to insert Check Box

        How to insert Check Box

        02:45

        How to insert Check Box

        When creating tables, we often need to insert check boxes to check the information quickly and check multiple options at once. Today we'll learn how to insert check boxes. Take this Registration of Selected Courses table as an example. 1. Go to the Insert tab, click the Forms drop-down button, and select the Check box. 2. The cursor becomes the shape of a cross, and you can insert a check box by dragging the mouse.3. Input text in the check box, such as "French."Then the check box ....

        Spreadsheet 42.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 67.7K views
        How to set character spacing in documents

        How to set character spacing in documents

        01:32

        How to set character spacing in documents

        When using WPS Writer for typesetting, we often need to adjust the spacing between characters. How can we adjust the character spacing?Take this document as an example. Select the text content, click Home in the upper menu bar, and choose Settings → Font. Then we can see the Font window. We can also press the shortcut key Shift+D to pop up the dialog. Get into the Character Spacing tab, and change the setting of Spacing. Here, we can choose one of the three default character spacing e....

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