How many EXCEL function formulas have you mastered? Learning anything will become perfect. Don't rush for success. First of all, you should understand the characteristics, concepts, expressions, relative addresses and absolute addresses of functions. When you understand this, it will be easy to learn. Explain the function in an easy-to-understand way, and anyone without any foundation can learn it. First, you must know something. If you study Excel blindly, even if you persist in studying and practicing for 24 hours, you will still draw water with a sieve. You must have a strong interest and good mathematical thinking. If you are not interested, you will not learn well. People with poor mathematical thinking generally can't learn excel software well, because you can't find the optimal algorithm, even if it is a simple summation, you may not be able to get started. I remember when I was training FoxPro database, I met a China learner. If X is right.

For example, SUM itself means sum, and AVERAGE itself means average and average. In addition, there must be a certain programming foundation, otherwise even some simple functions (such as if, Sumif and Countif functions) will not be used, let alone "macro" or VBA. Average function; Maximum and minimum functions; Rank function; The last function of Countifs is to have perseverance and practice more on the computer. I really want to learn excel well. There are various versions of video tutorials online, which can be studied online. Genius comes from diligence, and in time you will become a master among masters. Keep studying, and it will be effective. There are not many commonly used functions: string processing functions: left, len, right, mid；; Numerical processing function: int, max, min, average, count, round, sum search function: vlookup, match, index, conditional function: if; Array function: sumif；; Functions and formulas are technical. I think the most important thing is to know how to design tables and turn business requirements into data that Excel can achieve.