Understand functions, such as summation, meaning summary, generalization and induction. Enter =sum () directly when calculating the total next time, and your heart will follow me. For another example, column means column, and this function returns the serial number of the column. For example, column(B4)=4, which is very useful when generating formulas in batches. How to remember? Column, noun, column, column; Cylinder; Column. Just go to Baidu to find out what it means, read it again and remember the word, and you can remember this formula.
Memory function: There are not many common functions. Generally speaking, 90% of the problems can be solved by memorizing several basic functions, such as sum (sum), sumif (conditional sum), vlookup (finding other values in rand return & line), offset (offset function), if (if), count (count), countif, index (. Series three functions, about time, mouth, present and so on. Give each function its own explanation. There are no more than 20 basic functions, which is absolutely enough.
Use function: If the function is not used, it will be forgotten.
If you can't use a function, just help the example directly, or Baidu can look at the case. Is the most direct and effective method. The problem that takes three hours in front can be solved in 10 minutes with this function skill. Do you want to learn? If you have the motivation to learn, take the initiative to learn useful functions. If you use them too much, you will remember them.
Psychological method: To achieve a certain goal in EXCEL, we must learn to solve it with various ideas. If this road is not feasible, it can be solved by other methods. A basic idea is: table-tool-function. For example, to copy data, 1 directly requires the data source to provide non-duplicate data! 2. Copy data using the 2007 toolbar. Or data-filter-choose not to copy records, but paste them. 3. Use function to find and contrast and filter. =IF(COUNTIF(A:A，A 1)，A 1，" ").
Therefore, the highest mental method is from the source to the result, the first step is curved, and more detours can get back on track. Therefore, from the beginning, the data input format is required to be unified and standardized, so as to prepare for the future. Secondly, the application of basic functions. Thirdly, the automation of data processing, setting up functions and checking well in the early stage will save time and effort in the later stage.