How do I learn excel from a zero base?

How do I learn excel from a zero base?

Later work will demand your data processing skills (unless you are lazy and miss a good learning opportunity). At the beginning, you'll find that a function can automatically calculate sums (sum), average, and you'll be happy. Next you will find that it is often useful to look for the contents of another table from a table (VLOOKUP), and sometimes a lot of conditions (if function is useful).

In fact, this will solve about 80% of the work problem. Just a few functions won't be difficult, especially if you've found a long time before, and now it's done quickly. As for the future in-depth study depends on whether your work has such a demand.

In addition, a lot of friends will say, I am using a low version of Excel, and then learn the high version will not be difficult? In fact, the core of the Excel version of the changes, not too tense, the change is only more convenient use, such as the previous two steps, now only one step.

To grow, motivation comes from self-motivation, which is actually a little bit of efficiency that Excel brings to you. More professional web sites, such as Office Assistant Network (www.officezhushou.com).

The application of the function is the foundation of Excel, it seems very difficult actually you just have to get down to it, and it's not difficult to analyze it in a step-by-step way. I am generally in the face of multiple layers of nested functions, it's all about taking the innermost layer out, putting it in the new cell, looking at the result, and then adding a layer to the next cell to see the result, and so on until it reaches the exact same level as the multi-layer nesting, so the function is understood. There are friends who are accustomed to analyzing from the outermost layer, vary from person to person and see habits.

Some array formulas can do the same, but the new cells will become an area to place the array, and then gradually look at the results. For some of the more quoted arrays this strategy is rather helpless, only an honest analysis of the function of the array, understanding of the ingenious ideas.

If you're still not interested in Excel, don't even think about it. Learning Excel's fundamental goal is to spend less time dealing with problems, more correctly than others, in other words, a perfect lazy solution.

In order to later can be "lazy", and will never make mistakes, learn Excel bar, this motivation lasting and strong, when you conquer the function, ask for the interest may come.

For excel in the finishing skills, in fact, is your idea of the collation. Let's say the problem with Excel data collation:

Is the de jure form a bad form?

The answer is: not necessarily.

Give an example. The executive Department has a form for recording the purchase and distribution of customer gifts. Many people's thinking is to set up a lot of columns, respectively, record the number of each gift purchased, the recipient, pick up the quantity, the current inventory.

But this idea is unscientific, and even can't write this form. The correct form is to record every event (what you buy today, buy a few, who will take what, take a few), and look like a chronological, but you can always get the data you want to know by using a function or formula in another sheet. Or use a PivotTable report to quickly analyze summaries from different angles.

The following figure is the legendary chronological:

Ii. how to standardize a rotten form

The 0th step is to make a backup first. In order to avoid change in the subsequent changes should not be changed things.

The first step, look at the structure of the table, unreasonable place to move the knife. But the actual work may not be so ideal, because the original data is not collected by you, even if you see the data structure is not appropriate (especially the lack of content), can only do stare, it is necessary at the same time, if possible, call back to rewrite.

The second step is to unify the row height, column width, font, font size, alignment, and make no changes to the content, only to make yourself comfortable in the next steps.

The third step is to review the uniformity of the calculation formula. Is there a calculation error? Is there any reference error? This is critical and sloppy.

The fourth step is to audit the uniformity of the data format. For example, the display is 8, but it's actually 8.2, because the cell format is set to show only the integer part. Again, for example, the text format of 8 and 8 of the number format is different.

Done above, is generally a refreshing form, if necessary, then check the following aspects (including but not limited to):

1, the correctness of the data (validity). For example, the number of people unexpectedly appeared decimal, mobile phone number is not 11 digits, the date of the employee's birth is 1902 ...

2, repeated data, such as a list of books, the same book appeared several times, should be merged.

3, the formula optimization, such as L2=A2+B2+C2+D2+E2+F2+G2+H2+I2+J2+K2, is usually the author of a lattice to click, not ready to click one of the middle one, should be changed to L2=sum (A2:K2). Even the L2=A2+C2+E2+G2+I2+K2, which are added in the middle, can usually be done by the SUMIF function, without having to look like a long string.

Finally, to say that all of these do not need the naked eye to judge, can be through the formula, functions, menu functions to achieve. Spend a period of time to learn a few commonly used functions and menu functions, can be in the back of the application easy to earn time back, input-output ratio is 1:100.

Last but not least, it is also the most important issue for new professionals:

How to reduce errors in Excel?

1, diligent Backup: When you find that you do not change the change, at this time you to restore the previous version of the data flow of sweat, are not back to the original changes in the data when the brain into the water.

2, set the check: In several important nodes or a number of key values there set the checksum, each change will pay attention to check whether the value of 0.

3, Reduce manual entry: In addition to the original data, the other are calculated. Raw data can be copied without manual input.

4, Unification: The data format unification, the computation formula unification.

5, the use of auxiliary columns: A number of complex calculations split into a few steps, easy to check the wrong. Some of the extra columns are hidden when the table is complete, and this is especially useful, don't be afraid of trouble.

6, the use of data validation, duplicate data inspection, with conditional display format, cell annotation and other auxiliary means.