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

        Easily drag videos into your presentation

        Easily drag videos into your presentation

        00:48

        Easily drag videos into your presentation

        Hi there, friends. How did you insert audio or videos into slides?You may be familiar with the following procedures: Click Movie in the Insert tab. Click Local video to switch back and forth between different files. If there are multiple videos, you have to pick each one individually before clicking Open.Let's count how many steps are involved? Good news! It takes only one step in WPS Office's latest version. Select the files to insert, and drag them into your slides. Whoosh! T....

        Presentation 11.5K views
        How to insert equations in WPS Presentation

        How to insert equations in WPS Presentation

        01:54

        How to insert equations in WPS Presentation

        You will be the amazing reporter with WPS Presentation, which could be an alternative to Microsoft PowerPoint. Mathematical equations contain a variety of number formats like symbols, scores, root numbers, and so on. It is difficult for us to enter these equations with the input method. However, with the Equation function in WPS Presentation, inserting mathematical equations will no longer be a problem. Click the Insert tab at the top of the screen, then click the Equation button. Here....

        Presentation 11.5K views
        Make a ranking bar chart

        Make a ranking bar chart

        01:58

        Make a ranking bar chart

        The bar charts use bars with the same width to indicate the amount of data. Therefore, we can compare data intuitively. By using a bar chart, it will be convenient for us to compare the differences between data.Take this table as an example. This is the data of cumulative confirmed COVID-19 cases on April 9, 2020. If we want to see the difference in confirmed cases between countries more intuitively, we can use a bar chart.1. Click any cell in the data area.2. Click the Insert tab.3. T....

        Spreadsheet 11.4K views
        How to set Shape Effect in WPS Presentation

        How to set Shape Effect in WPS Presentation

        02:36

        How to set Shape Effect in WPS Presentation

        Have you ever felt that simply inserting WPS Office's own shape is slightly monotonous? Inserting poorly designed graphics deters us from standing out in work. Learning to use the Shape effect of WPS demonstration can make your slides more professional. Take this slide as an example, select the inserted graphic, click the Drawing Tools tab at the top, then click Shape Effects before clicking More Shape Effects. Next, I will demonstrate different effects one by one. 1. ShadowAdding ....

        Presentation 11.4K views
        How can we add and set borders for cells

        How can we add and set borders for cells

        01:54

        How can we add and set borders for cells

        When we use WPS Spreadsheet to organize the data form, we may sometimes need to add borders to the cells in the table. For example, we may use the upper and lower borders to make alphabets, employee information tables, music staff, and so on. Different data forms require different cell borders, so how can we to set the table border style? Take the employee information table as an example. 1. Select the cell area.2. Click the Home tab in the upper feature area and then the Other Borders....

        Spreadsheet 11.4K views
        How to merge sheets with the same name

        How to merge sheets with the same name

        01:43

        How to merge sheets with the same name

        In WPS Spreadsheet, there are many ways to merge worksheets. Do you know how to merge worksheets of the same name correctly?Take this workbook as an example, and you can find three worksheets that record students' scores in mathematics, physics, and chemistry respectively.Teachers need to extract the scores of mathematics, physics, and chemistry from these three classes and then put the scores of each subject in different workbooks. What can we do? First, click the Data tab, click ....

        Spreadsheet 11.4K views
        Recalculate the table formulas in the Manual Recalculation mode

        Recalculate the table formulas in the Manual Recalculation mode

        01:20

        Recalculate the table formulas in the Manual Recalculation mode

        Today, let me introduce you to a lesser-used function, Manual Recalculation. Take this document as an example. Now, the cells have formulas. When we modify the source data, the values in the table will also change automatically. That is because the table turns on the automatic calculation by default. When we need to process a particularly large amount of data in the worksheet, if we still choose automatic calculation, then every time we change the source data, the table data processing....

        Spreadsheet 11.3K views
        More features in Picture to Text

        More features in Picture to Text

        02:12

        More features in Picture to Text

        Both WPS Spreadsheets and Microsoft Excel have the function of Converting pictures to text. What are the differences between them? Microsoft Excel itself does not support the OCR function. If you want to convert Picture to Text, you need to open another application, OneNote. 1. Copy the picture and paste it into OneNote.2. Click Copy Text from Picture with the right mouse button3. Paste the text into Excel as needed. In WPS Spreadsheet, the OCR function allows us to convert pictures to....

        Spreadsheet 11.2K views
        Prev 1 ... 36 37 ... 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