Play the Excel function to learn these four strokes to become a master

Excel is a versatile spreadsheet, it is powerful, easy to operate, in addition to can quickly generate and format a variety of tables, you can also complete a lot of data in the table The function of the database. Moreover, Excel is a widely used data management analysis software, and its powerful built-in functions are almost omnipotent, but because many users do not know the function of the function, they are not familiar with the format used by the function, that is, the use is wrong, and it is not known where the error is. . Excel 2002/2003 has helped us solve many problems in this area. Compared with Excel 2000 and previous versions, the intelligent formula function provided by us will lead us into its function world, making it easy for you to become a master of Excel. It is more convenient and quick to meet the needs of our daily office.
1. Common formulas with buttons
In Excel, we often encounter problems of summation, averaging, and max/min. The earlier version of Excel provided the "automatic summation(∑)" button in the toolbar, which makes it easy to sum the cell areas, but the average and maximum/small values ​​are generally only manual. Enter the formula implementation. In Excel 2002/2003, click on the drop-down button to the right of the “automatic summation" button and we will find that there is more than "average", "count", &"maximum", " ;minimum & rdquo; and other commands, through these commands, we can easily find the average (average), number of cells (count), maximum (max) and minimum (min) of the selected cell area . The data that was originally calculated using the function is now easily implemented by the toolbar button (Figure 1).

Figure 1 "Automatic summation" drop-down menu
2. Insert function to help you search
If we use a function in data analysis, but I do not know what function can be used to achieve This operation can be achieved by using the "search function" function provided in Excel 2002/2003. Suppose we want to understand the function related to “loan”, just click the “Insert” menu in the “Insert” menu to pop up the “Insert Function” dialog box, in the “Search Function” dialog box. Enter the keyword to search for function functions in the box, click the “Go to” button to see the function that Excel recommends for you.
3. The application format is clear.
For some Excel functions that are not commonly used, the user is often prone to format input errors when using it. Excel 2002/2003 will promptly remind you to ensure the correct input of the formula. Sex. In Figure 2, we can also see that when the formula is entered, the system will select the currently referenced cell (or cell range) with a blue box, so that the user can check the input for reference errors. In addition, when applying the function format (such as "parameters"), the system will also mark the current parameters in bold below the function, so that it is clear at a glance.

Figure 2 Check format input error