WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • full ms office course

    32 results for full ms office course

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

    32 results for full ms office course

    How can we check word count in WPS Writer

    How can we check word count in WPS Writer

    01:22

    How can we check word count in WPS Writer

    When we are editing a document, we want to check how many characters we have entered in total. Or if we want to check the number of words in the selected paragraph, we can use the word count function. It can quickly help us count the pages, words, etc. in the document. For all, easy your work with WPS office suite. Taking this document as an example, in the status information area on the status bar at the bottom of the interface, we can get general information about the word count, the....

    Writer 0.417 views
    How to repair files in WPS Presentation

    How to repair files in WPS Presentation

    02:05

    How to repair files in WPS Presentation

    During our daily study or work, we sometimes find that the file is full of error codes or we cannot even access it. For those who use File Repair for fixing the file, restoring it to its original state won't be a problem at all. Click the Tool tab, then click File Repair.In the pop-up dialog box, click Repair damaged file to add the error file.You can also drag the file directly to the WPS Files Repair interface, which supports multi-format files such as doc, ppt, and xls. Next, WP....

    Presentation 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 views
    Why error message #DIV0! occurs and how to solve it

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

    02:27

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

    When calculating data with WPS Spreadsheet, the error message #DIV/0! will come to us from time to time.What caused the mistake? And how can we remove it? Take this table as an example. For example, when we want to calculate the unit price of pencils, we can enter =C3/D3 in cell E3, and the calculation result will show the error value #DIV/0! This is because, in this division operation, the denominator is 0, which leads to the calculation error. When we drop down and fill in the calcul....

    Spreadsheet views
    Elementary arithmetic functions in WPS Spreadsheet

    Elementary arithmetic functions in WPS Spreadsheet

    02:50

    Elementary arithmetic functions in WPS Spreadsheet

    Today I will introduce you to introductory calculation of functions, namely addition, subtraction, multiplication and division. In the table, there are three ways to enter the function, respectively, input in the formula bar input in the cell and click Insert Function. So how can we do elementary arithmetic in the table? We can enter the corresponding symbol for the operation in the formula bar or cells. Take this table as an example, we enter "= A2 + B2" in cell C2, press the Enter ke....

    Spreadsheet views
    How to insert and set pictures in WPS Spreadsheet

    How to insert and set pictures in WPS Spreadsheet

    02:19

    How to insert and set pictures in WPS Spreadsheet

    When using WPS Spreadsheet, we often need to add pictures for a more visual presentation. So how can we insert a picture into the table? Select the cell where you want to insert a picture, click the Insert tab, and then click Picture. Here we can choose Floating Picture or Embed to Cell. Floating Picture allows pictures to float above cells, then we can move and resize the picture at will. Embed to Cell is to pin the picture within a cell. We can't move the picture but only control....

    Spreadsheet views
    How to insert pictures in WPS Presentation

    How to insert pictures in WPS Presentation

    02:12

    How to insert pictures in WPS Presentation

    When using WPS Presentation, we can insert pictures to make the slides more beautiful and help others better understand the text content. So how can we insert and set pictures in slides? Take this slide as an example.1. Click the Insert tab, and then click Picture.2. In the popup window, click From File.3. Select the picture we want to insert and click Open. As we can see, the picture is inserted into the slides now. After inserting the picture, we can see that there are eight small do....

    Presentation 0.118 views

    How to exit the full screen mode in WPS Writer

    1. Find the small floating window in the upper right corner of the full screen interface.2. Click the Quit button to exit the full screen mode. 3. We can also press Esc key to exit the full screen mode. This skill could also be used in Microsoft Office Word and OpenOffice.

    Writer 0.1845 views
    Prev 1234 Next
    WPS Academy
    Products
    Partners