Home / the Internet / Software / 5 useful functions in Microsoft Excel

5 useful functions in Microsoft Excel

/
43 Views

5 useful functions in Microsoft Excel</a>

Microsoft Excel is one of the most popular and successful office programs.

However, not every manager uses all the functionality of this program.

So if you want to succeed in your business and hit your bosses - learn new features in Excel.

Instructions

1

The VLOOKUP function.
Finds the desired value in the table.
Example of use.
To know Katya's score, write = VPR ("Katya", A1: E1,2,0)
Where "Katya" is the name of the student, A1: E1 - the range of cells of the search, 2 - the number of the column, 0 means that we do not need to find an exact match to the value.
Features of use.
Unfortunately, the function is able to search only from left to right. Among other things, the function can search for long enough for large tables.

2

Function INDEX.
Finds the value at the intersection of the desired row and column.
Example of use.
To find out who became the first in the race, type: = INDEX (A1: A11, 1)
Where A1: A11 is the range of search cells, and 1 means that we need the one who came first.

3

The MATCHING function.
Finds a value in a range of cells and reflects the position of this value.
Example of use.
To find the name of the head of the company "Starateli", enter = SEARCH ("Starateli", B3: B13,0)
Where "Earners" is the name of the company, B3: B13 is the range of search cells, and 0 means that we are not looking for the exact value.

4

The function $.
Allows you to cancel automatic correction of the formula when copying it to a new cell.
Example of use.
If you write "$ A $ 1" - the value of the copied data cell will be the same in any direction.

5

The & amp;
Helps to collect all values โ€‹โ€‹of cells into one.
Analogues.
It operates in the same way as the CLUTCH function.

5 useful functions in Microsoft Excel Was last modified: June 21st, 2017 By Pauwiucd
It is main inner container footer text