### How to create and edit named ranges in Excel?

You can easily locate the cells or cell ranges and follow your spreadsheets with named ranges. Here are steps to create and edit named ranges.lTo create a named range1. Navigate to the Formulas tab and click on Name Manager, whose shortcut key is Ctrl+F3. In the pop-up box, click New to define a new named range. Then you can enter name for the range, set the scope (Workbook or Sheet), add comments and set the applied range of cells. For instance, enter Nov_Sales at Name and it refers t....

### How to count unique values in Excel

There is no single function can count unique values in WPS Spreadsheet now, so we try to make it in anther way. Here we take a simple table as an example. It is a table of consumption records in a canteen. To make it more clear, some duplicate records are highlighted in different colors. Each ID card number corresponds to only one employees. Employees can enjoy different dishes by multiple payments when having lunch. This table records the number of payments. Now we want to work out....

### The VALUE function: Convert text to number in Excel

In daily work, we often come across text formats that represent numbers. So how can we convert text to number? There are two methods. · Option 11. Click the Formulas tab > Insert Function to pop-up a dialog.2. Input “VALUE” in the text box and then select the desired cell in the new dialog. Then click OK.3. Drag the cell to fill the formula into the rest of the cells.Tips: This method is suitable for situations where multiple data needs to be processed. · Option 2WPS Spreadsheets iden....

### 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 calculate Z-scores in Excel

To describe a value's relationship to the mean of a group of values , sometimes we need to calculate Z-scores. The formula used to calculate a Z-score is Z=(x-µ)/σ, where· x is the value that needs to be standardized· μ is the mean of the given dataset· σ is the standard deviation of the given datasetHere are the steps.1. Here we have a set of data that simulates the sales of coffee. Before calculating the Z-scores, we must calculate the mean and standard deviation of given data by....

### How to insert carriage return in Excel

· Option 1:1. Click the cell within the long sentence.2. Click where we want to insert carriage return, and press the shortcut Alt+Enter.3. Then, the carriage return has been inserted. We push the content to a new line in the same cell. · Option 2:We want to combine the values of several cells into a new cell. And, we need each value to be a new line in the new cell.If we use the shortcut key every time, it can be a very tedious task. In order to save time and improve efficiency, we ca....

### Text to Column 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. For those who want to split the cell text into multiple columns, the function of Text to Column will help you get what you want. WPS Spreadsheet seems superior to table processor for its "Smart Split Columns" function.In today’s case, we want to split text with fixed width and delimited text respectively in a smart way. · Fixed Width Text:Fixed Width me....

### Conditional formatting in Excel—Icon Sets

We can use conditional formatting to highlight specific contents quickly. Here we take a sales table as an example. Open your Spreadsheet, and click the Conditional Formatting drop-down button in the Home tab to get a menu.We are going to talk about Highlight Cells Rules. 1. Select the cell range for which you want to set rules. Click Icon Sets and we have many icons for choice. Here we select the stars icon. We can apply it with one click.2. Then there are stars shown in the cells we ....