2. Excel primary school level: Knowing that Excel is a component in Office, it can do simple reports and the most commonly used functions, such as simple formatting and printing. (novice level)
3, Excel junior high school level: know the most commonly used formulas, functions and simple charts, and can design tables by themselves with simple calculation functions; (elementary)
4、
Excel high school level: for example, Huashan Raul, master more than 30 common functions, be familiar with formulas, such as multiple IF judgments, familiar with common charts, use names, custom and conditional formats, effectiveness, grouping and hierarchical display, advanced screening, custom sorting, merging, sorting, * * * sharing, snapshots, ordinary pivot tables, design tables with ordinary automatic calculation functions, and record macros with safe concepts and simple applications. (intermediate)
5、
Excel university level: such as extermination teacher, very skilled in data analysis,
Familiar with engineering, finance, statistics and other functions that are not commonly used, skilled in the use of dynamic charts, the general application of array formulas, and the comprehensive application of various charts, controls, tables and effectiveness. Proficient in using univariate and programming analysis tools.
, simulation operation table, XML, preliminary understanding of vba and simple programming.
Do your own custom functions and design your own solutions, which can handle more than 90% Excel problems, and the company you work for is already a first-class level. You often do training, and it is easy to find a job. (master)
6.Excel master: For example, Ashes of Time focuses on the interaction between vba and Excel and other components of office, which can solve all problems in Excel, develop a large number of practical add-in templates, and often do very advanced training. Excel is his job and it is easy to be poached. (top master)
7. Doctor-level Excel: If you fail alone, it is beyond the scope of Excel. Focus on the cooperation between Excel and other software systems, such as SQL, VB, PB, etc. The company's key protected objects are easily poached by companies such as Microsoft. (super first-class master)
8.Excel martyr level: Dong Fangbubai, for example, is a super-class master of evil school, who specializes in exploring the potential functions and loopholes of Excel. Excel is all he has, he likes to compile worms with macros, and he often does some extremely advanced abnormal applications (hardcore players).