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 ....

Conditional formatting in Excel—Highlight

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. We have several more specific rules here, and we take Greater Than as an example.We can use this rule to highlight the cells that satisfy the condition we set. 1. Select the cell range for which you want to set rules....

How to add strikethrough line in excel

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Strikethrough line can show a completed task, a marked error, or introduce WPS’ tutorials with Microsoft’s heading, as you can see, it can express the author's opinion in an annoying funny way.1. Open your table with WPS Spreadsheet.2. Select the cells or texts you want to add the strikethrough line on. Head to the Home tab > Settings > Cells. You ....

How to insert a Word document into Excel

1. Open the table in Excel and select the cell where we want to insert the Word document.2. Click the Insert tab and the Object button. Then the Insert Object dialog will pop up.3. In the dialog, choose Create from file.4. Click the Browse button, select the Word document we want to insert, and click Open. 5. Check Link to file and Display as icon, and click OK. Then, we can see that the Word document has been inserted.6. We can double-click the icon to open the Word document.(Note: Ch....