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

        1899 results for wps download and install

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

        1899 results for wps download and install

        Superscript and subscript in WPS Presentation

        Superscript and subscript in WPS Presentation

        01:32

        Superscript and subscript in WPS Presentation

        In WPS free PowerPoint tutorial, learn how to use themes and background styles of preseatations, and do more to create standout presentations. All WPS Presentation tutorials are free for students, teachers, business users and more and can be downloaded free in Windows, PC, Mac, Linux, Android, and iOS devices. Chemical elements and mathematical formulas are sometimes needed in slides during the learning process. These coursewares cannot be separated from the superscript and subscript f....

        Presentation 11.9K views
        Rows and columns tools in WPS Spreadsheet

        Rows and columns tools in WPS Spreadsheet

        02:34

        Rows and columns tools in WPS Spreadsheet

        Today, we are going to show you the usage of the Rows and Columns tool in the WPS Spreadsheet. This tool can help us set the rows and columns of cells and make our work easier with WPS Spreadsheet like Microsoft Excel. Take this table as an example. We need to adjust the row height and column width of the current table.1. Select all tables, click the Home tab, and click Rows and Columns. Select AutoFit Row Height and AutoFit Columns Width. The WPS Spreadsheet will automatically adjust ....

        Spreadsheet 40.1K views
        The AND Function in WPS Spreadsheet

        The AND Function in WPS Spreadsheet

        02:56

        The AND Function in WPS Spreadsheet

        The AND function is one of the commonly-used logical functions. When we need to test multiple conditions, it can quickly return the results. It will return TRUE if all of the arguments evaluate TRUE. Otherwise, it will return FALSE as its result. The syntax is stated as follows: AND(logical1,logical2, ...)Logical 1 is the first condition, while logical 2 is the second condition to evaluate, and up to 255 arguments are allowed in AND Function. Take this table as an example. With the sal....

        Spreadsheet 11.5K views
        How to link WPS Writer and Spreadsheet together

        How to link WPS Writer and Spreadsheet together

        02:26

        How to link WPS Writer and Spreadsheet together

        In today's lesson, we will learn how to use the "Paste link" function in reality.In the workplace, we need to use Word to regularly report our work to the leader.Taking this monthly report as an example, we will generally choose to count the data in Excel and then copy and paste the data table into Word. Suppose you repeat this process every month, which will be a waste of time and sometimes leads to typographical errors. So how can we improve efficiency?The correct operation shoul....

        Writer 8.6K views
        How to insert and find bookmarks in WPS Writer

        How to insert and find bookmarks in WPS Writer

        01:13

        How to insert and find bookmarks in WPS Writer

        No matter you are students, teachers or business workers, can create and edit documents efficiently by WPS Writer as text editors. Easy to use like Microsoft Word.We cannot finish reading a long document all at once, so we can create bookmarks for the document contents to record the location we saw this time. Click the position where the bookmark needs to be Inserted. Then, select the Insert tab and click the Bookmark button to pop up the dialog box. We can enter the name of the Bookma....

        Writer 14.7K views
        How to lock and unlock cells in WPS Spreadsheet

        How to lock and unlock cells in WPS Spreadsheet

        01:35

        How to lock and unlock cells in WPS Spreadsheet

        If you have a worksheet for others to fill in, while you don't want certain important data to be modified, the Protect sheet function in WPS Spreadsheet can help you. To lock the entire sheet, get into the Review tab first. If you see the Lock Cell button grayed out, it means that the entire sheet has been locked by default.Next, click the Protect Sheet button, set the password, and click Confirm the setting. Then the sheet formally enters a locked state, and the sheet cannot be ed....

        Spreadsheet 27.1K views
        Clear and avoid duplicates entries in WPS Spreadsheet

        Clear and avoid duplicates entries in WPS Spreadsheet

        01:56

        Clear and avoid duplicates entries in WPS Spreadsheet

        When using WPS Spreadsheet to process a large number of data, it would be troublesome to find duplicated items manually. Here are some tips to delete duplicates. · Option OneSelect a range of cells. Get into the Data tab, and click the triangle next to Highlight Duplicates. Pick Set from the drop-down list. Duplicated cells within the selected range will be highlighted. To clear the highlight color, we just need to click the Set button. · Option Two Select cell range (A2:C14). Get into....

        Spreadsheet 45.4K views
        Merge and split table cells in WPS Writer

        Merge and split table cells in WPS Writer

        01:09

        Merge and split table cells in WPS Writer

        Today we are going to learn how to merge and split table cells in a document.Take this table as an example.· Merge cellsHere, we can merge cells. Select the cell in the first column and click the Merge Cells button in the Table Tools tab to merge the cells. · Split Cells1. If we want to divide a cell into several cells, we can select the cell that needs to be split. 2. Click the Split Cells button in the Table Tools tab.3. In the pop-up dialog box, we can set the number of columns and ....

        Writer 17.0K views
        Prev 1 2 3 ... 237 238 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