4 results for excel certification course online free
- All Tutorials
- Video Tutorials
- Quick Tutorials
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 export a document to PDF?
1. Option 1: Click Export to PDF icon at the top left as below. Option 2: Click Menu → Export to PDF. 2. After setting as you need, click Export to PDF. 3. When the output is complete, you can use WPS Office to open the PDF file. Tips: PDF to Word/Excel/PPT: free of chargePDF to Word/Excel/PPT: only for membership For all, easy your work with WPS office suite. Free download WPS Office for PC, Mobile, Windows, Mac, Android, iOS online.
Insert an elegant table quickly in Excel
Sometime we may need to insert a table in Excel. Here are the steps.1. Open an Excel document, click the Insert > Table.2. In the pop-up dialog, you can select the cell range where you want to create a table. You can also check My table has headers according to individual needs. 3. You can also change its style in the toolbar. For all, easy your work with WPS office suite. Free download WPS Office for PC, Mobile, Windows, Mac, Android, iOS online.
How to compare two excel sheets and highlight differences
In this article, you will know how to quickly compare two excel sheets and highlight differences with only 6 simple steps as follows. How to quickly compare two excel sheets for differences in values? You can use the View Side-by-Side comparison function if your boss requires you to immediately find out the differences between the two Excel sheets.For example, this is book1 and this is book2, click on View Side-by-Side and you can manually find out the differences in their values row b....