Excel Formulas
Source: Interesting Engineering

Excel, one of the packages of Microsoft Office and one of the most useful software for creating spreadsheets and data entry. The distinguishing feature of a spreadsheet program like Excel is that it allows you to create mathematical formulas and execute functions. Excel is a great tool to use as it offers Excel formulas for data collection and entry.

We all know that Microsoft Excel is extremely powerful and versatile when it comes to calculating numbers or solving math and engineering problems. Microsoft Excel makes all these difficult tasks very easy with the help of the feature “Excel Formula”. The ability to perform extreme calculations is one of the purposes of using a spreadsheet application.

To become a pro in MS-Excel, it is very important for you to know some of the basic formulas and their functions. Also knowing them will only ease your task. Using formulas and functions, you can make your spreadsheet: a dynamic and responsive work.

Let’s know about some of the most useful and popular formulas in Excel:

I) SUM

= SUM (Number1,Number2)

 

This command simply adds your cell content or given volume. If used a colon in place comma, it directly adds all the content of all the cells between the two cells in a column.

  • = sum (A1: A5) – This will add the contents of all cells between A1 and A5 including the contents of A1 and A5.
  • = sum (A1, A5) – This adds the contents of cell A1 and A5 in the given cell.

    Sum
    Source: AbleBits

II) AVERAGE

= AVERAGE (Number1,Number2)

 

This is the same as SUM function, it justs takes the average of the data. The rule for colon and comma is here also the same.

  • = average (A1: A5) – It will take out the average of all the contents from A1 till A5.
  • = average (A1, A5) – This will take the average of just these two cells and print it in the given cell.

    Average
    Source: AbleBits

III) COUNT & COUNTA

= COUNT (Value1,Value2)

 

The COUNT function is very useful in counting the number of entries made in the sheet. The only differences in these two are that the COUNT only counts the entries made in numbers and COUNTA counts all the non-empty entries.

  • = count (A1: A5) – This command will output the number of entries made in “NUMBERS”.
  • = count (A1: A5) – The only difference here is that it counts all types of entry.

    Count
    Source: AbleBits

IV) TRIM

=  TRIM (text)

 

It is used to remove all extra spaces present in the cell.

  • = trim (A1) – It will eliminate all extra spaces in cells but a single space character between words.

    Trim
    Source: AbleBits

V) CONCATENATE

= CONCATENATE (text1, [text2], …)

 

This function allows you to combine the contents of two or more cells into a single cell.

  • = concatenate (A1, A5) – This would combine the contents of cells A1 and A5 and display it in the given cell.
  • = concatenate (A1, ” “, A5)  – This would do the same as above but will add a space between the contents of the two cells.

    Source: AbleBits

Using some of these formulae you can make your work pretty easy and faster…

 

That’s all, for now, buddy, If you like the article then please comment and give your feedback, check more of the author’s articles. Do bookmark Kickgadget for more amazing content!

LEAVE A REPLY

Please enter your comment!
Please enter your name here