11 basic Excel formulas so you don't get lost if you start using Microsoft's spreadsheet



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.





Sum




Capture 2019 03 23 At 15 36 32



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)



Subtraction




Capture 2019 03 23 At 15 37 38



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.



Multiplication




Capture 2019 03 23 At 15 38 26



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







I have seen excel sheets that you would never believe





Division




Capture 2019 03 23 At 15 39 15



The same as above, but now to divide We will use the symbol "http://feeds.weblogssl.com/" between the boxes whose values ​​we want to use. This could be an example: = A2 / C2.



Average, mean, or arithmetic mean




Capture 2019 03 23 At 15 40 00



We go a little further and come to the average formula. The function of this formula is return the arithmetic average value of the values ​​stored in cells selected. The formula could be such that.= AVERAGE (A2: B2).



Maximum and minimum values




Capture 2019 03 23 At 15 40 55



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).




Capture 2019 03 23 At 15 41 39



Will count




Capture 2019 03 23 At 15 45 25



Contara is one of the formulas for counting values. A formula that allows you to count values ​​even if they are not numbers and just 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)



Count Yes




Capture 2019 03 23 At 15 44 06



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")



Condition




Capture 2019 03 23 At 15 34 44



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




Capture 2019 03 23 At 15 26 52



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.



Search for H




Search H



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.