The filter function is often used in data processing, but only when the data is vertically arranged. Today we will filter data horizontally using two ways.· 1. Transpose dataTake this table as an example. To filter the sales of all categories, we need to select and copy the entire table with Ctrl+C and then right-click Transpose at Paste Special. By doing so, the table is transformed into a vertically-oriented table. Go to the Home tab, and click AutoFilter to get the sales of all cat....

When processing a table, we may find that some information contains parentheses, but it'd be troublesome to delete them one by one. Today, we're going to learn the skill to delete these parentheses and the content inside quickly. Take this table as an example. There are parentheses following the actors' names, and we want to delete these parentheses and the nationality inside. 1. Select the cell range which contains the parentheses and press Ctrl+H to pop up the Replace di....

Making conference table cards is a necessary skill for civilian staff. Today we will learn about how to make double-sides conference tables. Step 1. Create a single table.First of all, click the Page layout tab, and set the page layout to Landscape.To make the table more exquisite, we have inserted a two-column, one-row table and a background image into the document in advance.Now, we can choose the desired WordArt effect and add it to the appropriate position in the cells on both side....

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

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Today, we will learn how to create a Form in WPS spreadsheet, which allows us to input, search and modify the data. Note: If the table contains merged cells, the Form function will be unavailable. · 1. Data inputFirst, click the Data tab and click the Form button. In the pop-up window, the system will automatically take the title row as the field name. ....

The boss needs us to enter an employee information form, but Alice's work number is never always not displayed correctly. As long as we enter a number starting with “0”, the spreadsheet always hides the preceding “0” by default, so what should we do? In this cases, we just need to convert the cell to text formatting.1. Select a cell, to make a prompt corner mark present. 2. Click the prompt corner mark. Then, the cell will quickly switch to text formatting.Here is another method to....

The TEXT formula in Excel is commonly used for the conversion of number-to-text in a certain format, and it could be also used in Microsoft Office Excel and Openoffice. Normally, the TEXT formula is used to customize format cells in terms of actual needs. To realize it, we need to adjust the second parameter of the formula, which stands for format texts to be set. In this example, the number 2.012584, which equips with six decimal places, entered cell A2. How can we convert it into a v....

The line chart is mainly used to show the trends in data and is also one of the most commonly used chart styles at work. This table shows the number of newly hired employees and the number of employees who resigned from the company from 2000 to 2021. So how can we quickly generate a line chart on this? 1. Select all the data in column B. 2. Click the Chart button in the Insert tab, and choose the Line option. In this way, we can get a simple line chart.If we modify the data in the data....