295 results for course excel certification
- All Tutorials
- Video Tutorials
- Quick Tutorials
How to convert Excel to PDF02:50
How to convert Excel to PDF
PDF is a highly compatible format that occupies little space and is easy to transfer. Converting a table into a PDF file is often needed in daily study and work. Here are the steps. Take this table as an example. Click the Tools tab, then click the Export to PDF button. A dialog box Export to PDF will pop up, where you can select the small icon to the right of the file name to rename it. We can choose Active sheet for multi-page tables to set the export range.When we want multiple tabl....
More features in Document Encryption02:14
More features in Document Encryption
Both WPS Spreadsheets and Microsoft Excel have the function of document encryption. For users' actual needs, WPS Spreadsheets additionally provide two practical features: Encryption at different levels and Password hints. In Microsoft, two methods are available for document encryption.Method 1Click the "Protect Workbook" drop-down button in the "Info" interface and select "Encrypt with Password." We can only set a password for the excel document in the pop-up dialog but not make it....
LOOKUP Function in Excel
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more.· Description:The LOOKUP function can search a value in a column or row and returns a particular value from the same place in another column or row. It has two Syntax. · Syntax1 :LOOKUP(value, array) · Arguments:Value: The value to search for in an array, which must be in ascending order.Array: An array of values.(contains both the values to search for a....
Compare two excel files for differences in WPS Office Excel
Welcome to WPS Official Academy to check the contents of compare two excel files for differences in WPS Office Excel. We often need to compare the data from two different excel files, but it would be troublesome to compare each item one by one with naked eyes. So how can we compare two excel files for differences in a quick and easy way? Let’s have a try step by step. Here we take two tables of employees performance appraisal for example. We can find the two tables are inconsistent wit....
How to unprotect an Excel sheet
If we have set up password protection:1. Click the Review tab.2. Click the Unprotect Sheet button.3. In the pop-up Unprotect Sheet dialog box, enter the password we set before, and then click OK. · Note:If there is no password protection:1. Click the Review tab.2. Click the Unprotect Sheet button. Then we can remove protection from Excel. To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.
How to insert checkbox in Excel
1. Click the cell where we want to insert the check box.2. Click the Insert tab → the Forms drop-down button → the Check Box option.3. When the cursor appears as a cross, click the left mouse button and drag the cursor to insert a checkbox. Or we can click the cell directly,then we can insert a checkbox.4. After inserting the checkbox, we can edit the text of it.5. Click another cell, then we can check the box. To be office excel advanced, you could learn how to use WPS Office Spreadsh....
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.
Conditional formatting in Excel—Data Bars
We can use conditional formatting to mark specific contents quickly. Here we take a sales table as an example. Open your Excel document, and click the Conditional Formatting drop-down button in the Home tab to get a menu. We are going to talk about Data Bars. 1. Select the cell range for which you want to set rules. Click Data Bars and select one of them according to your needs. Then the cells are marked with bars of different lengths, from which we can easily know the rank of sales. ....