Play the Excel function to learn these four strokes become master

Excel is a versatile spreadsheet, it is powerful, easy to operate, in addition to can quickly generate and format various forms, but also in the table Data completes the functions of many databases. 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 & ldquo; AutoSum & rdquo; drop-down menu

2. Insert Function help you search

to use a function If we analyze the data, but I don't know what function to use to achieve this operation, we can use 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. See the application format clearly

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 remind you humanizedly. This ensures the correctness of the formula input. 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 the format input error Previous 12 Next Total 2