How can I learn excel quickly?

Start with the basics. Using Office 2010 and above, WPS has used the latest version, here I used Office Excel 2016 for the demo. If you are not familiar with the operation, don't blindly memorize what shortcut keys, use the mouse in the early stage to understand what operation has and what it does.

I think it should be interest, people who are interested, will always study and practice tirelessly, and can persist for a long time, which is better than most.

Usually practice more, don't understand the place, at any time, if there is no special need, there is no need to learn systematically, and there are only a few functions that are used in ordinary work.

First of all, you need to familiarize yourself with your computer's operating system, choose between WindOS 10 or Windows 7. Two system operation shortcuts Windows + D to quickly return to the desktop Windows + E to open Explorer (File Manager), the Windows key is the space bar or the icon key next to the Ctrl key. Familiarity with use can do more with less. ‍‍

The first is the use of shortcut keys, which can make daily work twice as effective with half the effort.

For example, Ctrl+Ctrl+V, Ctrl+E, etc.

Secondly, in the face of tedious work, there must be one"Laziness"I need to constantly wonder if there is an easier way to do it, search more and learn more. For example, the use of various functions, the familiarity of the ribbon, etc.

Finally, if you want to really learn Excel well, you must learn the programming language and conquer VB, at this time, you can really get started with Excel's advanced learning.

Learning functions, this step is very important, 90% of our work can be solved by using functions, but the functions are diverse, complex, the best is to learn while practicing, I recommend it again, I want to learn the basic tutorial of functions on the Internet, it is really good.

At first, you can first observe the templates made by others, understand the source and destination of the data, understand the writing of formulas, how to make icons, etc., too complex formulas do not need to be memorized, you need to be able to spend your mother.

There are dozens of commonly used skills in excel, and when it comes to the masters, it is a sharp weapon. However, the excel in Xiaobai's hand is always a burden.

Learning VB, this is a relatively advanced learning. Basically everything we do quickly and easily at hand.

Office office software three suites word excel ppt, for each useful, ppt is good at doing display reports, word a lot of word processing work, excel is good at data statistics, analysis and display.

I think it's the skills and methods, you should find a good teacher to learn excel, good teaching materials, follow the requirements of others' specifications, and follow the cases little by little, then you have also learned the methods and skills of learning. The thinking of predecessors, as their own ladder, can be learned quickly.

Excel skills are the same skills, the master is handy to use, but Xiaobai only wants to apply it! This is the difference between a master and a novice.

Books, the Internet, etc. are fine.

1. Be sure to have a few books or tutorials on hand for reference.

Books are not for learning, they are for reference. When you encounter a problem, you can flip through the book based on your impressions, first, to find the answer, and second, to learn new knowledge.

2. Be good at making use of network resources.

3. Excel learning can't be rushed.

Many students want to learn excel quickly through a certain way and learn a lot of excel knowledge. This is unrealistic, learning includes "learning" and "learning". The best way to practice is to consolidate the Excel knowledge points learned by solving problems at work.

4. What excel knowledge points should you learn first?

Familiarize yourself with some of the commands on the toolbar, most of which you can understand at a glance.

Master some excel operation skills, and learn the skills by following the tutorials released by the platform every day. Slowly accumulate skill points.

Functions and functions, starting from their own actual work, what needs to be learned in the work first. For example, if you want to check it, you need to learn vlookup, countif functions, and if you summarize it, you need to learn pivot tables, classification and sumifs, sumifs, and other summary functions. Filtering data often requires learning filtering and advanced filtering functions.

5. When to study VBA? Suitable for beginners?

If you need to deal with more complex data analysis or the largest amount of data. You don't need to be very familiar with Excel functions or functions, you can learn VBA programming directly.

Find an excel tutorial and follow it.

Learn the basics first:

Learn the hard ones again.

1 Find some good ones to be served by others, and imitate them yourself.

2 Try to do some by yourself, and you won't ask on the Internet again.

Diligence + study + inquisitive + high-finger pointing.

To learn how to use Excel functions and formulas, you can start from the following aspects:

1. Understand the basic concepts of rabbit functions and formulas. Functions are pre-built functional modules of Excel programs that can process data in a specific way, and each function has its own specific syntax structure and parameter content. A formula is a combination of symbols that the user inputs himself/herself, including functions and other operators, and can perform specific data operations, starting with the symbol "=".

Excel functions are a special kind of formula in their own right.

2. Through several simple functions such as sum, len, mod, and, etc., master the input methods of formulas and functions, the concept of function grammatical structure, the concept of function parameters, what is a constant, what is a logical value, what is an error value, what is a cell reference and other important concepts.

3. Cell reference is an important part of function parameters, which is divided into three types: relative reference, absolute reference and mixed reference. The flexible and correct use of cell reference types can reduce the effort of function and formula input, while also making the calculated data more accurate and efficient. This requires a serious exploration of knowledge rabbits in practice.

4. There are many built-in functions in excel, some of which are in specific professional fields, and not all of them can be used in actual work, so there is no need to master the syntax structure and parameter content of each function. However, the above basic concepts of functions and formulas must be deeply understood and carefully mastered, which is the core key to learning functions and formulas.

5. In practical application, it is often necessary to nest multiple functions in a formula, that is, the calculation results of one function are used as parameters of another function. When using nested functions, it is necessary to have a clear concept of parameters, especially when multiple nesting, it is necessary to distinguish which function is which level of parameters.

6. Practice more, think more, understand more, combine with your own work practice, work some very commonly used important functions, remember their syntax structure and parameter content, and be able to use flexibly and input proficiently.

Excel is actually quite simple, if you just learn for the convenience of simple use in life, then you just need to buy an excel book to learn by yourself, if you are a professional office worker, and want to learn quickly, it is recommended that you can choose a school to study. It is recommended that you study at Shanxi Xinhua Computer School.