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

        2922 results for All

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

        2922 results for All

        Add blank rows in an individual table

        Add blank rows in an individual table

        01:02

        Add blank rows in an individual table

        Sometimes there are several tables in one worksheet, and we want to add blank rows in one of the tables. How can we solve it? Take this worksheet as an example. Suppose we need to add a blank row in the left table. At this time, if we use the frequently used method, which is to select the desired range and right-click to insert a blank row, we can find that a blank row is also inserted in another table. Thus, we need to use another method to insert the blank row.Firstly, select the loc....

        Spreadsheet 6.9K views
        Beautify The Table

        Beautify The Table

        10:38

        Beautify The Table

        You can start from three aspects: 1.select the correct color scheme. We can download color schemes from color matching websites.2.we can choose suitable icons to fill in the data series and make it interesting and vivid.3. we can achieve special effects by adjusting "Series Overlap" and create needle tube charts and mountain charts. We can click "Smoothed Line" to smooth the lines and adjust "LINE" and "MARKER" to enrich a line chart. After you've beautified a chart, right-click i....

        Spreadsheet 6.9K views
        More features in Screenshot

        More features in Screenshot

        02:02

        More features in Screenshot

        Both WPS Writer and Microsoft Word have the function of the screenshot. What are the differences between them? In Microsoft Word, two methods are available. One is Available Windows, which means to capture the opened windows on our desktop; the other is Screen Clipping. We need to capture the screen by manually adjusting its size in this mode, and only the area outside the Excel document is available. In WPS Writer, we can enter the Insert tab and click the Screenshot drop-down button.....

        Writer 6.9K views
        More features in Encryption

        More features in Encryption

        02:05

        More features in Encryption

        No matter you are a student, teacher, or business professionals, you can create and edit documents efficiently by WPS Writer as text editors. When we want to protect a document, we usually want to encrypt it and prevent editing. Today, we will compare the WPS Writer with Microsoft Word regarding the Encryption function. First, let's start with Microsoft Word. There are two ways to encrypt documents in Word.For the first method, we need to head to the Info interface, click Protect D....

        Writer 6.9K views
        Different ways to utilize column charts

        Different ways to utilize column charts

        11:05

        Different ways to utilize column charts

        Clustered columns are one of the most frequently used charts. Data discrepancies are reflected in the height of columns.1.We can highlight data by setting data labels, trendlines, the starting point of the Y-axis, and other methods. 2.We can set column size and gaps at "Series Overlap" and "Gap Width." 3.Stacked columns and 100% stacked columns can better display data percentage. They can clearly show the containment relationship for categories.

        Spreadsheet 6.8K views
        Display the unit symbol in the formula result

        Display the unit symbol in the formula result

        01:26

        Display the unit symbol in the formula result

        This is a table of information about the department employees. If we need to calculate the average weight of the staff, what should we do?Normally, you only need to enter the formula =AVERAGE(D2:D8) in cell D9 to get the average.However, the formula returns 0, and obviously, the result is incorrect because there are text characters in the cells, which affects the accuracy of the calculation. Do you know how to retain the weight unit and normally perform the calculation at the same time....

        Spreadsheet 6.8K views
        Unique features in Student Tools

        Unique features in Student Tools

        02:23

        Unique features in Student Tools

        No matter you are a student, teacher, or business professionals, you can create and edit documents efficiently by WPS Writer as text editors. Student Tools is a collection of functions launched by WPS for students users. Some frequently-used functions are selected. This built-in function cannot be found in other office software at present. In the interface of this function, WPS Office selects Reading View mode from the View tab, frequently used features such as Highlight and Text Color....

        Writer 6.8K views
        Print out tables

        Print out tables

        02:43

        Print out tables

        In the previous video, we learned how to set the table page and the header and footer of the table. And this video will teach us how to print out tables. In our daily work, we often need to use the print function. In the quick access toolbar, we can click Print Preview and then click the Settings button to pop up the Print dialog. Before printing, we need to make sure that the computer is connected to the printer. If we need to print two copies of the spreadsheet document, we can chec....

        Spreadsheet 6.8K views
        Prev 1 ... 55 56 ... 365 366 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