371 results for telephone directory in excel
- All Tutorials
- Video Tutorials
- Quick Tutorials
Text to Columns: Sort data quickly02:03
Text to Columns: Sort data quickly
When creating tables, we sometimes need to import data from outside, and this data often requires secondary classification processing. We now want to classify the data in the table into Name, Age and Telephone. So how can we do that?1. We select column A, click the Data tab.2. Click the Text to Columns drop-down button. 3. Then select the Text to Columns option in the drop-down menu.In the popup dialog box, we can see two options.+One is Delimited. Here, we can use symbols as the basis....
Use Validation to prevent duplicate values01:23
Use Validation to prevent duplicate values
Sometimes we don't want to enter duplicate information from the collected data. We will take the unique telephone number as an example to show how to use the Validation function to prevent duplicate values.Select this column, and click Validation at Data, you can also use the shortcut Alt+D+L. Head to the Setting tab, click the Allow drop-down button and select Custom, and enter countif(D:D,D1)=1.This formula will make the value in cell D1 only appears once in column D; otherwise, ....
How to display the side directory tree in WPS Writer
1. Click the Section tab in the upper menu bar.2. Click Section Navigation Pane → Content. Perfect your work with WPS Writer like Microsoft word.
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....
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....
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....
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....