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 insert the object in WPS Spreadsheet

        How to insert the object in WPS Spreadsheet

        01:30

        How to insert the object in WPS Spreadsheet

        Take this table as an example. In order to better supplement the content of the table, we can insert the objects we need in the table. First, select cell F2, click the Insert tab, and the Object button. We can choose Create new or Create from file on the left side in the pop-up dialog. In the Create new interface, we can select different types of blank documents in the Object type area, and we can edit them manually.In the Create from file interface, we can insert local documents, appl....

        Spreadsheet 13.6K views
        Four View Modes in WPS Writer

        Four View Modes in WPS Writer

        02:26

        Four View Modes in WPS Writer

        No matter you are a student, teacher, or business professionals, you can create and edit documents efficiently by WPS Writer as text editors. We can choose different view modes according to the needs of our daily file reading. Take this document as an example. I will demonstrate four view modes of text. First, click the View tab. 1.Full Screenl If we only want to display the editing area, click Full Screen or use the shortcut Ctrl+Alt+F.l The document will be displayed on full screen,....

        Writer 25.1K views
        How can we format cell values

        How can we format cell values

        01:57

        How can we format cell values

        Cell formatting is an important feature of spreadsheets. So today, we will briefly go through how to format cell values. Number formatting can be simply understood as a digital form that can be used for calculations.Take this table as an example: now the data in the cell is in text formatting. If using the SUM function to do calculations, we would find that the data in text format cannot be calculated. At this time, we need to convert the data into a number formatting that can support ....

        Spreadsheet 45.5K views
        Create simple and intuitive mini charts

        Create simple and intuitive mini charts

        03:10

        Create simple and intuitive mini charts

        The mini chart can help us to compare and analyze data of a row or column. It is very useful when presenting data. So in this video, we are going to show you how to create simple and intuitive mini charts.In Sheet1, we can see Monthly sales of clothing. But we can't visually tell the difference between sales each month. Therefore, we should use the mini chart.1. Click the Insert tab.2. Click the Line buttons.3. Now a Create Sparklines dialog box will pop up.4. Select cells B3:J3 as....

        Spreadsheet 12.5K views
        Unique features in Eye Protection Mode

        Unique features in Eye Protection Mode

        01:37

        Unique features in Eye Protection Mode

        WPS Office Suite is a high-performance and reliable office suite designed to protect data and information for both PC and mobile office software users.Long-time staring at the screen when using office software can cause eye irritation. At this point, we can relieve tired eyes by adjusting the theme or colour of the document. Eye Protection Mode is not available in Microsoft Office yet. But we can adjust the theme colour to relieve eye strain.Click File, then get into the Options inter....

        Writer 26.0K views
        How to insert a text box in Spreadsheet

        How to insert a text box in Spreadsheet

        03:13

        How to insert a text box in Spreadsheet

        The inserted text in a table may be limited by cells. At this time, the text box can become your first choice to beautify your texts. It is rather simple to insert a text box. Click the Insert tab, then select the Text Box drop-down button.You can choose Horizontal Text Box and Vertical Text Box, and the difference lies in the arrangement direction for text. You can benefit from two sides.First, the text box can be dragged at your will. For example, there are multiple paragraphs of tex....

        Spreadsheet 22.5K views
        Quickly locate the name of the row and column where the cell is located

        Quickly locate the name of the row and column where the cell is located

        01:22

        Quickly locate the name of the row and column where the cell is located

        We often deal with tables with vast amounts of data at work. When we move the page, we can locate the content we are focusing on, but we cannot quickly know the row and column names of the cells. But now, with the Reading Layout of WPS Spreadsheet, users can quickly locate the row and column names of the cells that they are concerned about. Take this table as an example. Click the View tab, and then the Reading Layout drop-down button. In this mode, once a cell is selected, we can fin....

        Spreadsheet 191.5K views
        Text to Columns: Sort data quickly

        Text to Columns: Sort data quickly

        02:03

        Text to Columns: Sort data quickly

        When creating tables, we sometimes need to import data from outside, and this data often requires secondary classification processing. We now want to classify the data in the table into Name, Age and Telephone. So how can we do that?1. We select column A, click the Data tab.2. Click the Text to Columns drop-down button. 3. Then select the Text to Columns option in the drop-down menu.In the popup dialog box, we can see two options.+One is Delimited. Here, we can use symbols as the basis....

        Spreadsheet 9.3K views
        Prev 1 ... 4 5 ... 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