Is there an explanation of all the excel functions?

Excel help has all the answers you want.

In Excel, the most commonly used functions vlookup basic usage, function formula introductory skills!

All functions of Excel official and their usages and examples. This is sorted by function name, and there are also categories displayed on the official website, and those who need it can pick it up.

Excel function (in alphabetical order).

First of all, it is impossible to list all the places with 10,000 words. The explanation of the function itself basically has to be explained, not to mention the usage you still have to use.

Secondly, no one in this world knows the usage of all excel functions. There is no one who can list all the functions. Depending on the nature of your job, what you need to learn is enough.

Finally, press F1 in Excel to open Help, which is the best teacher for beginners. Don't think about being fat in one bite.

This is more complicated, and it depends on what kind of function you need, there are built-in functions, and there are functions written by yourself, which cannot be explained in a word.

{} is used in excel to define arrays. For example, if the content in a1 is abc=mid(a1,,1), this function means that the content of abc is taken out in three parts.

The first time you take the 1 in curly braces, you take the first one. Then take the second and third. If this function is written as =mid(a1,,1), then only two numbers will be taken.

It's the first and the second. In other words, the formula will take the value from {} and calculate it in turn. If you don't use this {}, the formula can only take one value at a time.

The functions are of course in English. There are no functions in Chinese. But you just mean to see help.

Then after you enter the function, select the function, and then press F1, which will automatically pop up the Chinese description of the function that Microsoft comes with. And all the functions are described. There are also examples in it.

More detailed than anyone else has ever said.

Make a move, press.

Come to F1 and do it.

It's all there.

There is no need to engage in so many dus in the number of beginner letters, one by one. Use which dao to learn which.

Click on the fx above and there it is.

If you want a more detailed explanation or how to do it, then click on the help about this function, which has a more detailed introduction.

Good luck

Press F1 to see how much help you know?

Do you know the law of twenty-eight? Why do you need to learn so much? Generally speaking, the functions you use most often are not even 20% of excel, why do you learn so many formulas?

Isn't it good to learn what you use? I've been using excel for at least 10 years, and I use the formulas to solve most of the problems, but I don't even know a tenth of the formulas, so if you're going to be a teacher, then finish it. A good suggestion for you:

When you want to use a formula, use the help of excel to look it up, and it will be clear, there are examples, and the explanation is also very clear. For example, if you want to find the formula for finding the average score, you can search for "average" in the help and then look at the help. When you want to use a formula, use the formula wizard to find out the formula you need for classification, and then infer whether it is needed according to the English meaning, and then look at the help, you can solve it.

I advise you not to spend time reading all the formulas in vain, even if you read them all, you may not be able to use them, or use them! Good luck.

Check it out at your mailbox. You'll be able to study for a few years.

Replace with lookup, find=, replace with =round(

Let's start with a simple example.

Suppose you want to add round (original formula, 2) to all the formulas in column A in four steps:

In the first step, select column A, CTRL+H, enter "=" in the "Find" box, and replace "in" with "box input".'=", the dots are all replaced, that is, the formula in column A is converted to text.

In the second step, enter the formula in an empty column:

Pull down, that is, in the third step of the original text of column A becomes round (original formula, 2), copy the column of the second step, copy the Paste Special value, save only the value of the column and remove the formula (you can paste it into another empty column).

The fourth step is to replace the method with the first step, just in reverse, enter " in the "Find" box'=", replace "=" with "" box, that is, convert the text of the third step back to the formula.

If you have a large amount of data, you may need to create a new worksheet to process it.

1. Change the formula.

if(b2="c1","a")

2. The if function beyond 7 layers is written like this.

if(……if(……

1. Add auxiliary columns, use the countif function to count (suitable for single columns) 2. Add colors to conditional formatting (multiple columns are also acceptable).

3. Pivot table count (suitable for single column).

4. Add auxiliary columns, and distinguish the Interact function after sorting (suitable for single columns).

- Find - Find content box to enter your content - click to find all - press Ctrl+A to select all cells of the content, I don't know if this is useful to you.

There is no function, but it is positioned. After selecting this area, press Ctrl+G and click "Targeting Criteria", which can be selected from a variety of options such as formulas, constants, and null values. You need to select cells with the same value or the same content, you can consider replacing them with null values and then replacing them back.

The detailed situation is best analyzed on a case-by-case basis.

Assuming the data is in column A, select all column A - menu - format - conditional formatting - formula - enter on the right: =countif(a:a,a1)>1 - format - pattern - red - OK - OK.

As long as there is the same content, the cell will be automatically filled with red.

There is a "Search" in the "", just enter the search content.

Rounding to the nearest whole number: =int(a1) or =rounddown(a1,0).

Advance up to the integer: =roundup(a1,0).

Formatting Cells, Numbers, Numbers, and Decimal Places to 0 can be achieved.

I don't know, but I know there's a way to do the same thing, and that's to set the number of decimal places in the data.