Use Excel 2007 's filtering and sorting capabilities

Many people can marvel at the strength of Excel 2007 when they use Excel 2007, and for ordinary users, Excel 2007 is the most powerful data analysis capability. If you just use a table to record some simple data, you can do it with the table feature in Word 2007, and there is no need to ask Excel 2007, the Master of data analysis. But data analysis is also an easy thing to do, and here we will learn how to use the filtering and sorting function to start from the most basic data analysis work.

Screening!

"Pass the Sieve" to the data

The stock market finally rose, the depressed investors have finally seen the dawn! Among the many stocks and funds that are "stuck", which would be the first to profit? What are the profits more than 30%? What is the ranking of today's prices? If you use Excel 2007 for performance statistics and income accounting, these problems can be easily solved. Here, for example, take a virtual stock list, and check out what the profit is above 30%.

Step 1th: First select the up scale cell, and then click the Sort and filter Drop-down arrow in the Start tab edit Group to select the Filter command from the Open menu.

Small tip:

For data analysis-related operations, you can generally find related action items in the Data tab, so you can switch to data labels here, and then click the Filter button in the Sort and filter group to achieve the same effect as the previous command.

2nd step: After you perform the filter command, a drop-down arrow appears in the contiguous cell of the row that has the rise ratio. Click the drop-down arrow in the cell that has the increase ratio to select number filter → greater than in the open menu, and in the Custom AutoFilter dialog box that opens, in the "Greater than" Enter "0.3" in the box on the right, and click OK to complete the settings for the filter criteria. Excel 2007 automatically filters the records that match the criteria, moves the mouse pointer over the filter button in the cell that contains the filter criteria, and sees the specific filter criteria.

Small tip:

Click the Clear button in the sort and filter group of the Data tab to cancel the last filter result. However, the filter state of the selected cells remains (that is, the filter button still exists), and clicking the Filter button again closes the filter state (the filter button on the cell is not available).

Sort

Help you rank quickly

Just through the screening to find the rise ratio of more than 30%, now want to find the top 10 of the price of stocks, and preferably from the first place to tenth place, so the ranking is more convenient. What do we do? This can be easily achieved by using the filter mentioned above and adding a sort.

Step 1th: First select the "Today Price" cell, and then click the Filter button, next click the Drop-down arrow in the Today Price cell, select number filter → 10 maximum values, and then click OK in the Open dialog box.

Step 2nd: Click the Descending button in the sort and filter group, when Excel 2007 automatically arranges the "Today Price" column by number from large to small.

After a good order and found that the same today's price, then the same as today's price how to row it? In fact, Excel 2007 can be sorted with multiple sorts. Also take the case here, for example, if you want to today's price of the same person again with "math" for the key word order, that is, "math" high scores in the top of the ranking, according to the following methods.

Click the Sort button in the sort and filter group, and in the Sort dialog box that opens, click the Add Condition button, and then set the secondary key as you want, and then click OK.

Use Word to work with a table, with less data, and a little more data, or you'll have to ask Excel 2007, the form expert. In the case of a lot of data, how to quickly find the data they want to become a problem, screening + sorting, is definitely a good looking for data experts.