subject: Good use of the screening and sorting function Excel2007 - office software, office supplies - office supplies industry [print this page] Good use of the screening and sorting function Excel2007 - office software, office supplies - office supplies industry
Many people spend Excel After 2007, may be amazed at the Excel2007 powerful features for general users, Excel2007 is the most powerful data analysis capabilities. If you just use the simple form to record the data, then use Word2007 table function can be completed, there is no need to please Excel2007 master to lobby the data analysis. But data analysis is an easily said than done something here to learn about how to use filtering and sorting capabilities, data analysis from the most basic start.
Screening! To the data "through a sieve"
Stock market has finally jumped the matter, the long-depressed stock investors finally see the light of the! Among the many to be "stuck" in stocks, funds, which will be the first to profit? More than 30% of profit over what? What is today's price ranking? If you use Excel2007 for performance statistics, income and expenditure account, then, these problems can be easily resolved. Here for a virtual stock list, for example, we first look up profit 30% higher than the what.
Step 1: First select the "higher proportion" cell, and then click "Start" label "Edit" group "sort and filter" drop-down arrow to open the menu, select the "Filter" command.
Tip: Related operations on the data analysis, generally in the "Data" tab can find items related to operations, so here you can also switch to the data tab, then click "Sort and Filter" group "Filter" button to achieve the same effect and the order.
Step 2: implementation of the "filter" command, "increase the proportion of" where the continuous cell lines have suffered a drop-down arrow, click the "up scale" drop-down arrow to the cell where, in the open menu, select "Digital filter greater than" in the open "Custom AutoFilter way" dialog box, in the "greater than" the right box, "0.3", then click "OK" button to complete the screening conditions set. Then Excel2007 automatically help us to filter out the records meet the criteria will be Mouse Move the pointer where the filter criteria selection button on the cell, but also see the specific filter conditions.
Tip: Click the "Data" tab of the "sort and filter" group of "Clear" button to cancel the last screening results, but still maintain the state of the selected cell screening (ie screening button still exists), single again Click "Filter" button to close the selection state (selection button on the cell also no).
Sort Helping you find the position
Just found out through the filter higher ratio greater than 30%, now to find out the price of the top ten stocks, and preferably the first discharged to from the tenth, so the position is even more convenient. To how to do? Using the above said, plus the screening can be easily sorted.
Step 1: First select the "today's price" cell, and then click "Filter" button, then click "Today's price" cell drop-down arrow and select "Digital Filter 10 largest value ", in the open dialog box, click" OK "button.
Step 2: Click the "Sort and Filter" group "Descending" button, then Excel2007 will automatically "Today's price" column ranked according to figures from big to small.
Lined sequence found today after the price of the same, then the same as today's price row to how it? In fact, multiple sort Excel2007 sort can be implemented. Also to cases where, for example, if you want to price the same as today people use "mathematics" as the keyword row about sequence, or "math" scores high in the ranking of the top row, according to the following methods can be.
Click the "Sort and Filter" group "sort" button, open the "Sort" dialog box, click the "Add condition" button, and then according to their need to set "secondary keywords" Finally click "OK" button.
Use Word processing forms, the case of less data can be, slightly larger amount of data, or may request Excel2007 the form of experts in negotiations. In many cases, the amount of data, how to quickly find the desired data also become a problem, selection + sort, definitely is looking for skilled data.
