! Method Half my life in the study to learn Excel functions, taught you today _ net _ Chinese accounting perspective needed to accountants - CPA | Certified Tax | Accounting titles | Senior Accountant | Accounting practitioners

Many people see the function is afraid to die, wait for them to hide aside, but escape can never solve the problem. Once Luzi is also afraid of the function, because even the English do not understand, how to remember the function? Let alone advanced function nest, it is simply to my little life! My first half of the study are learning Excel function method, today teach you! Although the first half of life a little exaggeration, but at least there are ten years, it is still some weight. Function is rather special, learning function is to continue to practice, just look at me to teach Far school is not good! This is my Excel100 days group of readers said a word, why do you say? Luzi said two real things. I have a set of WeChat before the issue, intact to the group of readers to practice, as long as all right, you can reward signature books, the results are only 2-3 readers all right, many other are 80-90 Minute. That is, even if the WeChat has the answer, you read, all the right people also accounted for less than 1%. Group of a reader to my book and WeChat public number article read more than 2 times, remember the keywords to see! Looks very bad, there should be no problem, right? The results of a few days before the written test dumbfounded, and many problems will not do. Luzi looked inside the title, not difficult, and are selected from the public number or books out of the case, but for a scene. To understand with the real understanding of more than one hundred thousand eight thousand miles. After these two things, Luzi immediately took a new teaching method, title sea tactics. To Excel100 days group of people made a lot of practice questions. There are a lot of problems will be able to learn, you are too underestimated people lazy! Many people do not even stay for seven days, for this lure with the temptation to learn. As long as you can insist on 21 days to reward signature book with a small bonus, but also to find the group of readers to check the daily practice. Why is it here for 21 days? A good habit of about 21 days will be able to develop, as long as you can insist on 21 days after the basic can stick to it. Above 2, but the foreplay, the most critical is to learn to use in their own work, can be used in the work you can remember prison. But some people work on the contact case is very small, then how to do it? Excel does not work overtime every day hundreds of thousands of questions, you have to try to answer them, in helping others when you have raised yourself. Group problems may be your work later encountered a scene, but here is prepared for you in advance, to the real work encountered, in order to be handy. According to other public numbers routines, the next should be advertising time. But Lu's routine is , There is no advertising, some just fine! Finally, the reader questioned: you are so selfless to know what they have no reservations Out, but the individual but with these re-build group, do micro-signal? Luzi had learned to learn from someone, and later learned to a certain extent, want to re-teach these knowledge to those who want to learn. In a very long period of time, Luzi's signature is: I am helping everyone, everyone help me! Meaning I hope to help you now, when I need one day you need help, you can also reach out to help me. As for the individual to learn or get my information after going to do, this is not my concern, go with him, do not do bad things like! Today put a little more, Q & A series simply said three like. Screen out the date of the weekend This can create an auxiliary column, with WEEKDAY function to solve. In the B2 input formula, drop down the padding. = WEEKDAY (A2,2)> 5 WEEKDAY returns the corresponding day of each date, such as Monday is 1, because the weekend is 6 with 7, that is greater than 5. And then TRUE can be filtered out. Find the maximum number of rows corresponding to the first line of the first line of the number, such as the first line 57 corresponds to -2. In the L2 input formula, drop down the padding. = LOOKUP (1,0 / (B2: K2 = MAX (B2: K2)), $ B $ 1: $ K $ 1) LOOKUP function classic pattern syntax: = LOOKUP (1,0 / (lookup area) = Find value), return area) Find the value because it is the maximum value of each row, so use the MAX function. Formula is no problem, but it is time to show the sum value. This is because there are spaces or empty text exists. The formula for each month is this: = IFERROR (VLOOKUP ($ A2, Sheet4! $ A: $ D, COLUMN (), 0), "") This is no longer used, IFERROR function fault tolerance, there is no corresponding value is displayed blank, this direct operation on the wrong. If the search out of the late number is to statistics, it is best to "" into 0, so you can directly sum. = IFERROR (VLOOKUP ($ A2, Sheet4! $ A: $ D, COLUMN (), 0), 0) Author: Lu child, Best-selling author, "Excel efficiency manual done early, no overtime" series series founder, personal public number: Excel does not work overtime (ID: Excelbujiaban)