32 results for full ms office course
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
32 results for full ms office course
How can we check word count in WPS Writer
01:22How 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....
How to repair files in WPS Presentation
02:05How 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....
Data Format-Scientific Notation
02:03Data 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....
Why error message #DIV0! occurs and how to solve it
02:27Why 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....
Elementary arithmetic functions in WPS Spreadsheet
02:50Elementary 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....
How to insert and set pictures in WPS Spreadsheet
02:19How 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....
How to insert pictures in WPS Presentation
02:12How 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....
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.