198 results for free ms office course with certificate
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
198 results for free ms office course with certificate
Use the Mail Merge function to input tabular data quickly
01:49Use the Mail Merge function to input tabular data quickly
WPS Office contains four major functional modules: Writer, Spreadsheet, Presentation, and PDF Converter. Easily compatible with 51 types, including doc, xls, ppt and other text types. Best free office suite alternative to Microsoft Office Word, Excel, and PowerPoint,applicable to Windows, mac OS, Android and iOS.Do you know how to make badges in batches? Are you still inputting employee information one by one? It's a waste of time. Today, we will learn how to use the Mail Merge fun....
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....
How to use LEFT and RIGHT formulas together in excel
Are you ready to master how to use LEFT and RIGHT formulas together in excel? After learning this WPS free course, you will be advanced from a beginner in WPS Spreadsheet. · What is WPS Spreadsheet? WPS Spreadsheet is compatible with Microsoft Office Excel. As the world's leading developer of office software solutions, WPS Office provides free applications for individuals and businesses to improve productivity. · What is the LEFT and RIGHT function in WPS Spreadsheet? They both all....
How to write meter square in powerpoint
There are many reasons why you may be interested in WPS Presentation and its powerful functions. Today's free course will tell you how to write meter square in WPS Presentation with easy steps. And the trick could be compatible with Microsoft Office PPT. · What’s meter square in WPS PresentationThe square metre (international spelling as used by the International Bureau of Weights and Measures) or square meter (American spelling) is the SI derived unit of area with symbol m2. Simil....
How to crop at an angle in powerpoint
There are many reasons why you may be interested in WPS Presentation and its powerful functions. Today's free course will tell you how to crop at an angle in WPS Presentation with easy steps. And the trick could be compatible with Microsoft Office PPT. · Example of cropping at an angle in WPS PresentationTo crop a picture at an angle in WPS Presentation, you need to insert a picture first. 1. Click the Insert tab, and then click Picture to choose pictures from your album. 2. We can....
How to insert Page Break in WPS Spreadsheet
00:48How to insert Page Break in WPS Spreadsheet
When we want to print a table but do not want to print all the contents on one page, we can Insert a Page Break to break the table into different pages. First, click the Page Layout tab. Click the Page Break Preview button to enter the Page Break Preview mode, where we can see only one page.Select a cell in the page break preview state and click Insert Page Break to generate split lines on the top and left of the selected cell. Now the table is split into four pages. If we select one r....
How to add a motion path animation effect
Today's free course will tell you how to add a motion path animation effect in WPS Presentation with easy steps. And this trick could be compatible with Microsoft Office PPT. · What is motion path in WPS Presentation?As the name suggests, motion path is a trace that can be applied to pictures, shapes and text. This can be set in the Animation tab, where you can find numerous effects to make the objects in your slides more vivid. · Add a motion path to objects in WPS PresentationSel....