The tutorial of finding excel is both simple and easy to learn and easy to use. I know how to do it

When learning excel, we should first understand what functions it contains, and then learn what to learn first and then what to learn, plan step by step, and promote learning according to the knowledge rabbit plan;

First: common basic functions.

1. Add, name, delete, hide and modify colors of worksheets;

2. Drawing**: Click Start - Select Font (Bold or Not) - Font Size - Font Color - Border - Font Alignment - Merge Cells - Wrap Lines, etc.

3. Make a slash header: Press Ctrl+1 to format the cells - click the border - Style - select the slash.

4. Window freezing: The frozen window is divided into the first line, the first line, etc., we select the first line, select the first line and click on the view, and freeze the first line.

Second, about the deletion and insertion of rows and columns.

1. The deletion, insertion, and setting of the line width, hiding, etc., only need to click the right button of the mouse, and all of them will be displayed. This feature is very useful. You can adjust the line width according to the amount of text, hide the information you don't want to show, and even insert and delete the hidden number in time.

It can be said that the usage rate of this feature is very high. Knowledge Rabbit.

Third: the practical issuance and function of shortcut keys.

The function of Ctrl+C is to copy.

The function of Ctrl+X is to cut, Ctrl+V is to paste, Ctrl+Z is to undo the previous operation, Ctrl+S is to save the file, and Ctrl+A is to select all.

Ctrl+1 to format cells, Ctrl+Y, Restore the previous operation, Ctrl+F, find Ctrl+G, locate Ctrl+H, and replace.

Ctrl+N to create a new workbook alt+tab to switch the browsing window alt+enter to force a line break alt+= quick sum ctrl+p print settings.

As a daily work, in fact, these functions are basically enough for office workers to use, of course, for some specific positions or need to use excel to make various data, then you need to know more. For example, the use of formulas, statistical functions, logical functions, date functions, text functions, conditional formatting, data processing, icon use, protection, etc. After these are all done, there will be basically no problem in the future.

The bookstore has professional introductory books, and reading books is a pleasure.

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

1. Understand the basic concepts of functions and formulas. Functions are pre-built functional modules of the excel program that can process data in a specially defined method, 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 trapped 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 needs to be carefully explored 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 nests, it is necessary to distinguish which function is the parameter of which level.

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.

I suggest that you only learn what is commonly used in your work, and if you don't use it often, it makes no sense for you to learn, and sooner or later you will forget. As for the basic operation, this one doesn't require any books (of course, it's not impossible to buy a book), just follow the excel help document to see what each function is, how to operate different problems, and then try it yourself, basically not difficult.

Then you will find that the formulas and macros are very flexible, so you can see how to use each formula with your own help and instructions; If the macro is recorded, you have used 20% of all the features so far. Never mind. This level is enough for a perfect score several times.

If you're satisfied, you can stop. Learning excel requires direction, you need to know how to learn step by step, know what class they are in, in order to be better and stable, you can't go to any training class to listen, you spend money and time is really not satisfied; You can't blindly and casually find textbooks to learn first, otherwise you will be like the author, piecing together and learning like a wild road, and taking a lot of detours.

The best way to learn excel is to learn theoretical knowledge directly through practical cases, avoiding simply learning knowledge points without practical application. Secondly, it is necessary to review the same case and knowledge points repeatedly and practice often, otherwise it is easy to forget that "review" is more important than "learning" in the world of excel. In the field of electronics, the only competitor of excel software is itself.

Based on this absolute advantage, excel has become a de facto industry standard. As a result, we don't have to spend time focusing on other watch software.

Even if it is necessary, it will be very expensive to learn the skills of other similar software. The advantages of Excel are very obvious. If you want to be a lecturer or secretary in the future, PPT it is one of the software you deal with the most, through the perfect PPT production can let your students or bosses listen to your explanations and analysis, make your work smoother, and make you more confident in your work.

Excel marks cells or ranges by highlighting them out of the display cells or ranges. These protruding displays do not appear in the printout. If you want to display cells with highlights in a print worksheet, you can use the formatting feature to apply cell shading.

I think you can see some learning excel on the top**, and at the same time, you can also ask a tutor for yourself to teach from scratch, and now there are many excel training courses on the market, you can also participate, and if you encounter no problems, you should consult more people around you.

If your excel skills are zero, you can continue to strengthen them in your work, and you can also learn simple ** operations through some courses, which will help you work.