Your browser version is outdated.
To browse WPS Academy normally, we recommend you to upgrade to the latest version of Internet Explorer or try other browsers.
chrome
Chrome
firefox
Firefox
WPS Academy

WPS Academy Free office suite tutorials

  • Home
  • Video Tutorials
    WPS Spreadsheet Data Entry and Editing Data Analysis Data Visualization Page Layout Review and Security More Functions and Formulas
    WPS Writer Text Writing Insert and Edit Page Layout Review and Security References More
    WPS Presentation View Insert and Edit Animation and Slide Show More Review and Security
    PDF Multiple Editing Tools Insert More Add Comments Page Management File Format Conversion Print
  • Graphic Tutorials
    WPS Spreadsheet Data Entry and Editing Data Analysis Functions and Formulas Page Layout Review and Security More
    WPS Writer Text Writing Insert and Edit References Page Layout Review and Comments Security More
    WPS Presentation Insert and Edit Animation and Slide Show Premium Benefits More
    PDF Edit View Review and Comments Security Premium Benefits More
    WPS Basics Home Page Settings and Account Premium Benefits More
    Beginner Tutorial Preferences Settings Get Started Common Uses
  • Download
    WPS Office for Windows
    WPS Office for Mac
    WPS Office for Android
    WPS Office for iOS
    WPS Office for Linux
Top Searches
    Login/Sign up
    • Home
    • Popular
    • define removal power

    9 results for define removal power

    • All Tutorials
    • Video Tutorials
    • Quick Tutorials
    • All
    • Spreadsheet
    • Presentation
    • Writer
    • PDF
    Why error message #NUM! occurs and how to solve it

    Why error message #NUM! occurs and how to solve it

    02:55

    Why error message #NUM! occurs and how to solve it

    We may encounter some errors when calculating in tables. One of these errors is "#NUM!." There are mainly three causes: 1. The calculated value is too large or too small. 2. Invalid values are referenced in the formula. 3. The iterative function fails to calculate the result. · 1. The calculated value is too large or too small.Take this table as an example. To calculate eight hundred to the power of nine hundred, input "=B3^C3," which means B3 to the power of C3. Then it returns "#NUM....

    Spreadsheet 1 view

    How to apply or power down sound effects?

    1. Open the page where you want to power down sound effects.2. Click the Slide Transition icon in the mini toolbar on the right to get a pane. Click the Sound drop-down button and select a desired sound. 3. If you need to power down the sound, Click the Sound drop-down button and select [No Sound]. For all, easy your work with WPS office suite. Free download WPS Office for PC, Mobile, Windows, Mac, Android, iOS online.

    Presentation 490 views
    How to set up custom slide shows in WPS Presentation

    How to set up custom slide shows in WPS Presentation

    01:40

    How to set up custom slide shows in WPS Presentation

    When using WPS Presentation, how can we adjust the content and order of the slide show without deleting the original slides or even changing the page order of the original slides? The Custom Slide Shows feature can help us. Click the Slide Show tab at the top of the screen, and click the Custom Slide Shows button. In the popup dialog, click the New button to customize the settings for the slide show.In the popup Define Custom Show dialog, we can enter the name of the custom show in the....

    Presentation 222 views
    Data Format-Scientific Notation

    Data Format-Scientific Notation

    02:03

    Data Format-Scientific Notation

    In WPS Spreadsheet, scientific notation is normally applied to data so as to compute more digits yet save more spaces. Today we will introduce how to apply scientific notation format to data in cells.You can use the following methods:When entering large numbers, we can manually adjust the column width of the cells . By doing so, the number will display in scientific notation format automatically. In scientific notation, the power of 10 is generally expressed by E. For example, the numb....

    Spreadsheet 2 views
    How to use the paste special function

    How to use the paste special function

    02:11

    How to use the paste special function

    Copy-paste has always been one of the most frequently-used functions in excel. However, few people are aware of its true power. Today we will learn how to utilize Paste Special in excel.The first method is to paste special contents in your table.Take this table as an example. This table is set with styles. In many cases, we merely want to paste the values but don't want the original styles. What should we do? Press Ctrl+C to copy the contents, click the Paste drop-down menu in the ....

    Spreadsheet 76 views
    More features in Split and Merge

    More features in Split and Merge

    04:37

    More features in Split and Merge

    In our daily work, we often need to split or merge worksheets.Most people use an easy way of copying and pasting, but it is a waste of time. In Microsoft Excel, we may need plug-ins, VBA or Power Query, etc., to split or merge workbooks.For convenience, WPS Spreadsheets provides the function of splitting and merging workbooks. First, let's learn about the splitting function. WPS Office provides three ways of splitting.· Split Sheets By ContentTake this workbook as an example, which....

    Spreadsheet 244 views
    How to adjust the picture position

    How to adjust the picture position

    02:06

    How to adjust the picture position

    After inserting a picture in the document, to perfect the layout, we will adjust the position of the picture in the process of typesetting. Take this document as an example. If we want to move the picture to the lower right corner of the page margin, click the picture first. Then click the Layout Options button in the upper right corner of the picture. And then click View More, now the Layout dialog box will pop up. WPS has provided us a large variety of alignment methods in the Positi....

    Writer 1,654 views
    Learn pivot table from the beginning

    Learn pivot table from the beginning

    04:27

    Learn pivot table from the beginning

    A PivotTable has a flexible operation interface. We can change the layout of various types of reports only with mouse operation. It can help us better search for information and make decisions.Take this table as an example. This is the sales data of a certain company over a period of time. If we want to count the total sales of products sold by each branch, we can use the pivot table to count it quickly. This is the completed pivot table. 1. First, select any cell with data in this tab....

    Spreadsheet 4,978 views
    Prev 12 Next
    WPS Academy
    Products
    WPS Office for Windows
    WPS Office for Mac
    WPS Office for Android
    WPS Office for iOS
    WPS Office for Linux
    Affiliate Program
    Links
    OEM Partners
    Strategic partners
    Enterprise Sales
    Popular Searches
    Partners
    WPS Office for Windows
    WPS Office for Mac
    WPS Office for Android
    WPS Office for iOS
    WPS Office for Linux
    Affiliate Program
    Links
    OEM Partners
    Strategic partners
    Enterprise Sales
    Popular Searches