207 results for coursera ms office course
- All Tutorials
- Video Tutorials
- Quick Tutorials
207 results for coursera ms office course
Data Format-Scientific Notation02: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....
Elementary arithmetic functions in WPS Spreadsheet02: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....
How to use OCR in PDF02:12
How to use OCR in PDF
Optical character recognition, also called OCR, is practical to extract text information from a picture. It can also maintain the content layout in the source picture. The first example will show you how to extract text from a picture.1. Go to the Tool tab and click OCR.2. In the pop-up dialog, click Screen Capture to take a screenshot of a selected area.3. Choose Extract text only.Then, we can get the text from the dialog on the right-hand side.If you've joined WPS Premium, you ca....
Why error message #DIV0! occurs and how to solve it02: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....
10 best examples of VBA in Excel
10 Best Examples of VBA in Excel 10 Best Examples of VBA in Excel is VBA is the abbreviation of Visual Basic for Applications. It is the programming language of MS excel along with other MS office programs like MS Word, PowerPoint etc. Basically, all actions or tasks in MS excel are interpreted in VBA language by the program to perform the desired tasks. These templates are free to download sheets with formulas and better experience. 10 Best Examples of VBA in Excel is beneficial, as t....
How to delete ms word pages in word 2021
HOW TO DELETE MS WORD PAGES - WPS, WPS Office,writer,Spreadsheet,Presentation To delete uncessary content from your word document, it is necessary to delete word pages. If you are wondering how to delete ms word pages? You are at the right place. Here you’ll learn step by step how to delete ms word pages. The steps mentioned also works either you are using Mac or Windows operating system. At the beginning page of document Open the word document which have more than one page. This examp....
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 edit resumes in pdf format in WPS Office
In WPS Office, we can edit resumes directly in pdf format by joining WPS premium. Are you ready to master how to edit resumes in pdf format in WPS Office? After learning this WPS free course of how to edit resumes in pdf format in WPS Office, you will be advanced from a beginner in WPS Writer.l An introduction to the features of editing resume in pdf format in WPS Office:Ø Add text to your resume1. Click the Add Text button, click on the position where the text needs to be inserted, an....