This is the Ms. Excel Formula Often Used in the World of Work

One of the requirements to be accepted for work is that you must be able to use a computer. Usually in addition to being able to use a computer, you also need to be able to use Microsoft Office, one of which is Microsoft Excel. ‘

In using Ms. Excel itself, you don’t just create data with tables, but you must be able to process existing data using formulas in Ms. Excel. In this article, Yiptechid will share Ms. Excel formulas that are often used in the world of work.

Ms. Excel Formulas Often Used in the World of Work

1. SUM

The first most used Excel formula is SUM. This Excel SUM formula has the main function of finding the addition or adding up numbers. Generally, you can use the plus operator (+) or the plus symbol (manual). However, you can use the following two formulas, namely by adding up numbers in Excel cells or ranges. For example, you will add up the numbers in cells C2 to C7, then you can use the excel formula as follows:

=C2+C3+C4+C5+C6+C7
SUM(C2:C7)

Then what if you want to use the formula for subtraction, multiplication and division? you can use operators like the following

Subtraction: =number1-number2
Multiplication: =number1*number2
Division: =number1/number2

2. AVERAGE

The second most used Excel formula is Average. This Average formula has a main function, which is to find the average value of a variable. Using Excel formulas, of course, will make a job easier and faster.

Average formula: =AVERAGE(number1:number2)
Example: =AVERAGE(L3:L6)

3. MIN

Do you want to find which is the lowest number value, among the amount of data? Well, the MIN formula is the next most frequently used Excel formula. So, if you are looking for the lowest value in a row of numbers, you can use the MIN formula.

Min formula: =MIN(number1:number2)
Example: =MIN(L3:L6)

4. MAX

Contrary to MIN, the MAX formula is Excel’s most frequently used formula, which works to find the highest value in a row of numbers. The formula used is also not much different from the MIN formula

MAX Formula: =MAX(number1:number2)
Example: =MAX(L3:L6)

5. IF

This IF formula is also one of the most frequently used Excel formulas in the world of work for all fields of work. As for this Excel IF formula function, it can help you return a value, if the checked condition is TRUE / FALSE, and returns another value, if the checked condition is FALSE / FALSE. However, in essence, you can put multiple IFs depending on your needs.

IF formula: =IF(logical_test,[value_if_true],[_if_false]
Example: =IF(2<3,”Benar”,”Salah”)> “Benar” =IF(2>3,”Benar”,”Salah”)> “Salah”

6. COUNT

The most frequently used Excel formula, and almost the same as SUM, is COUNT. This formula serves to count the number of cells that contain numbers.

COUNT Formula: =COUNT(value1,[value2],..]
Example: =COUNT(a1:a10)

7. COUNTIF

Almost the same as the COUNT formula, CountIF functions to calculate the number of cells in a range that has one specific criterion.

COUNTIF Formula: =COUNTIF(range,criteria)
Example: =COUNTIF(a1:a10,”A”)

8. CONCATENATE

The next most frequently used Excel formula is CONCATENATE. As for this formula can be helpful when you want to combine several values, in cells with some word modifications.

Concatenate Formula: =CONCATENATE(text1;text2;…)
Example: = CONCATENATE( Pembaca ;K6; Jumlahnya ;L6)

9. LEFT

There is a formula that is equally important, and is often used, namely LEFT. What does it do? The LEFT formula can be used if you need to extract multiple characters, in a word or number, from the left.

Left formula: =LEFT(cell yang mau diambil;jumlah karakter yang ingin ditampilkan)
Example: =LEFT(B25;5)

10. RIGHT

Its use is almost the same as the LEFT formula, it’s just that the RIGHT formula takes the characters from the right.

Right Formula: =RIGHT(cell yang mau diambil;jumlah karakter yang ingin ditampilkan)
Example: =RIGHT(B25;5)

11. MID

In fact, the MID formula has the same purpose as the Left and Right formula, only the MID formula, takes a character from the middle.

Mid formula: =MID(cell yang mau diambil;jumlah karakter yang ingin ditampilkan)
Example: =MID(B25;5)

12. REPT

Now, for this most frequently used Excel formula, it is usually used when you want to count, how many votes were there when the student council president was elected, or other elections. For example, in a voice you denote Turus (|), so you can count how many Turus there are in the table.

Rept formula: =REPT( | ;berapa banyak pengulangan)
Example: =REPT( | ;(B25/$B$30)*100)

13. Date

The most frequently used Excel formula, especially in everyday activities, is the DATE formula. This formula can be used, when you want to add dates to your Excel file.

Date Formula: =DATE(year;month;day)
Example: =DATE(2019;2;1)

14. Year

Now, for the Year formula, it is commonly used, when you want to retrieve data for the year, in a date formatted cell.

Year formula: =YEAR(cell yang ingin diambil datanya)
Example: =YEAR(B3)

15. Month

The next Excel formula that is also the most frequently used is the Month formula. This formula is usually used when you want to retrieve month’s data in a cell with date format.

Month Formula: =MONTH(cell yang ingin diambil datanya)
Example: =MONTH(B3)

16. Day

The most frequently used Excel formula and the last formula to be discussed is the Day formula. This formula is commonly used, if you want to retrieve day data in a date formatted cell.

Day Formula: =DAY(cell yang ingin diambil datanya)
Example: =DAY(B3)

Those are some information regarding the most frequently used Excel formula series, especially in the world of work. So, before you apply for a job that uses Microsoft Excel in it, make sure you have mastered the Excel formulas above.

Leave a Reply

Your email address will not be published. Required fields are marked *