284 results for best excel course
- 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....
Use the Mail Merge function to input tabular data quickly01:49
Use 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....
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....
Split the screen for data comparison01:21
Split the screen for data comparison
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. When we meet a situation where a large amount of data in the table can not be completely displayed in the window, we still want to see the contents from different positions at the same time. To solve this, using the Split window is probably the best idea. If you want to connect the total sales with Branch in a spreadsheet with massive data, dragging the....
MATCH 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 INDEX function can look up a value regarding its row and column numbers, which can be used in two forms: array form and reference form. · Syntax1(Array form): INDEX (Array, Row_num, [Column_num].) · Arguments:Array: Specified array or range of cells.Row_num: The row number of the specified arrayCol_num: [Optional] The column number of....
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....
HLOOKUP Function in Excel
To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy. · Description:The HLOOKUP function can look up a value in the top row of values and returns a value in the same column from a row that you specify. · Syntax: HLOOKUP(lookup_value, table_array, row_num, range_lookup) · Arguments:Lookup_valueThe value to be found in the first row of the table. (can be a value, a reference, or a text string).Table_arrayThe table of text, numbers, or logic....
Subtraction in Excel
There are two methods for you. Here we take this sales table as an example. How can we work out the net margins of each kind of fruit quickly? · Option 1Input the formula “=C2-B2” and press Enter on the keyboard. Then drag the mouse to fill the following cells. · Option 21. Click Formulas, and click Insert Function to pop up a dialog. 2. Input “IMSUB” in the dialog and input “C2” in Plural 1 and “B2” in Plural 2. Then click OK and drag the mouse to fill the following cells. WPS office....