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

        How to align shapes in WPS Presentation

        How to align shapes in WPS Presentation

        03:26

        How to align shapes in WPS Presentation

        You will be the amazing reporter with WPS Presentation, which could alternative to Microsoft powerpoint.Learning to align the shapes in WPS Presentation can make the layout easier. So how to use the function of Align?Select the shapes to be aligned, click the Drawing Tool tab, and then click the Align button. In the Align drop-down menu, you can set the alignment as needed.Note: same alignment settings show different effects with different reference objects. Here are three different wa....

        Presentation 10.1K views
        How to insert objects in WPS Presentation

        How to insert objects in WPS Presentation

        01:17

        How to insert objects in WPS Presentation

        You will be the amazing reporter with WPS Presentation, which could be an alternative to Microsoft PowerPoint. Take this presentation as an example. In order to better explain the contents, I will insert a table into this slide. Click Object in the Insert tab. A dialogue box will pop up, where we could select Create new or Create from file.In the Create new interface, we can select different types of blank documents at the Object type, but we need to edit them manually. In the Create ....

        Presentation 10.1K views
        How to find the specified text content in WPS Presentation

        How to find the specified text content in WPS Presentation

        01:06

        How to find the specified text content in WPS Presentation

        When using WPS Presentation, how can we quickly find the text in the slide? Take this presentation as an example. If we want to find the WPS in this file quickly, we simply click the Home tab and then click Find. Its shortcut key is Ctrl+F. In the pop-up dialog box, enter WPS in the edit box. We can also check the replacement conditions as needed, such as Match case and Find whole words only.Once we set it up, click Find next to quickly find the specified text content in the presentati....

        Presentation 10.1K views
        Pie Charts and Sparklines

        Pie Charts and Sparklines

        10:02

        Pie Charts and Sparklines

        You have learned two types of charts in today's lesson: pie charts and sparkline charts.1.Pie charts are suitable for showing data proportions, and data labels play an important part. The right-hand menu allows us to format data labels. 2.The combo of pie charts and doughnut charts can display complex data. A chart with too many colors should be avoided. We can choose the tone on tone color and adjust the saturation to improve the color matching. 3.Sparkline is a handy chart type. ....

        Spreadsheet 10.0K views
        Set Allow Users to Edit Ranges in a protected sheet

        Set Allow Users to Edit Ranges in a protected sheet

        02:04

        Set Allow Users to Edit Ranges in a protected sheet

        As we all know, we can protect the sheet by setting a password. So, can we divide this table into several ranges and set up separate passwords for each range? The answer is yes. Take this table as an example. This is a student grade table, and we need to set different passwords for each of the three ranges in the table so that the three ranges do not affect each other. Next, I will show you how to do that.Click the Review tab and the Allow Users to Edit Ranges button, and click New. In....

        Spreadsheet 10.0K views
        Line Charts and Area Charts

        Line Charts and Area Charts

        09:37

        Line Charts and Area Charts

        In this lesson, we learned about the basic use of line and area charts.1.A line chart and an area chart are essentially identical. Both may effectively display data trends over a specific time period, but an area chart is better for displaying the stacked effect.2.The combo of a line chart and an area chart can diversify the data. The right color scheme can make the chart more advanced.3.In the same chart, a combo of line and column charts can display two sets of data with different di....

        Spreadsheet 9.9K views
        How to extract and replace the page content of a PDF file

        How to extract and replace the page content of a PDF file

        01:23

        How to extract and replace the page content of a PDF file

        When we are editing a PDF file, what should we do if we want to extract and replace several pages of the content?We can use the Extract Page and Replace pages functions of WPS Premium. If we want to extract the third page of this file and save it separately as a PDF file, click the Page tab, click Extract Page. In the Extract Mode box, select Extract selected page to PDF. In Page range, enter 3.We can add a watermark to the file, and we can also name the newly output file and set the s....

        PDF 9.9K views
        How to use the MID function in WPS Spreadsheet

        How to use the MID function in WPS Spreadsheet

        01:54

        How to use the MID function in WPS Spreadsheet

        When using WPS Spreadsheets to process data, sometimes we need to catch part of the data from a series of numbers. We can use the MID formula to realize it, to catch up a certain length of characters from a series of numbers. In this example, there is a list of phone numbers. The MID function can extract the long series of numbers, keeping the last seven numbers when removing the first three characters. Select cell D2 and click the Insert Function to pop up the Search for a function d....

        Spreadsheet 9.8K views
        Prev 1 ... 41 42 ... 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