Excel is one of the basic applications in office automation (and now a programming language. A powerful spreadsheet that is part of Microsoft Office widely used in office and accounting tasks. Many are those who have a certain fear of Office, an application that requires learning based on formulas that, we cannot deny, takes time.
The problem is the ignorance of the necessary formulas and that is what we are going to try to see here. Some of the basic Excel formulas to practice without fear and become familiar with the spreadsheets.
It is the ABC and Excel. The basic formula everyone should know when faced with the Microsoft spreadsheet. A formula that allows us to add the values of a group of cells, or even whole rows and columns. It offers the advantage of supporting both separate cells and gaps. A formula whose example could be = SUM (A1: A30)
The same as before. Another basic but now used to subtract the values two-cell. This could be the example to use, in which the value of one box is subtracted from another: = A2 – A3.
It is the formula used for multiply the values of two or more cells. The cells whose values we want to use are marked and an asterisk between them as a multiplication symbol. This could be an example: = A1 * A3 * A5
The same as above, but now to divide We will use the symbol “http://www.genbeta.com/” between the boxes whose values we want to use. This could be an example: = A2 / C2.
Average, mean, or arithmetic mean
We go a little further and come to the average formula. The function of this formula is return arithmetic average value of values stored in cells selected. The formula could be such that.= AVERAGE (A2: B2).
Maximum and minimum values
It is the formula used to know the maximum and minimum values contained in a set of cells. To calculate them we will use the terms MAX and MIN together with the cells to be analyzed. This is an example for maximums = MIN (A2, B4, C3,29) and another for minimum = MIN (A2, B4, C3,29).
Contara is one of the formulas for counting values. A formula that allows you to count values even if they are not numbers and only ignores empty cells. It is usually used to know how many entries a table has, if we do not care that they are alpha numeric values. If we only want to take into account the numbers, the COUNT formula is used. An example could be = COUNTA (B2: B13)
This formula allows count items that meet a certain criteria. Criteria that can be based on the correspondence with a number, in which a certain text appears. Excel will count the cells that offer a condition that we have marked. An example could be counting cells with the value 455 = COUNTIF (B2: B13; “455”)
To a certain extent similar to the previous one. It is a formula based on the fulfillment of a condition. A value is returned if the condition we marked is met. The classic example used is that of the grades, where approved is if there is a value equal to or greater than 5 and fail is where that value is less than 5. The example could be: = YES (B2 = “500”, “Approved”; “Fail”)
Search for V
Searches for a value within a row and returns the value that has been found or an error if it was not found. An example could be = VLOOKUP (“Genbeta”, B1: D6, 3, FALSE) if we want to know the number of articles published by Genbeta in the month of February.
The use of “FALSE” is because it is the necessary value to indicate that we want an exact search, that is, we only want the value for the entry with the Genbeta index.
Similar to the previous one, this formula pursues the search for a certain data in the first column of a table or matrix and once the row in which said data is located, return the value that the column that we specify has in that same row. This example = VLOOKUP (“May”; A1: D13; 2; FALSE) it would be useful to know how many articles Genbeta published in a month.