Important for workers, this is a list of Excel formulas that are often used at work

KONTAN.CO.ID – When working, you will often use various Microsoft (Ms) Excel formulas to make your work easier. Of the many formulas, there are several formulas that you will often use during work.

Because it is often used, it is not surprising that the ability to operate Ms. Excel is one of the most important skills possessed by workers today.

Although there are many different formulas, there are at least eight Excel formulas that are often used at work.

The Ministry of Manpower (Kemnaker) summarizes what Excel formulas are useful in the world of work. The information is shared via Instagram uploads Ministry of Manpower.

For students or workers, you should learn these formulas so that when working later it will be easier. Let’s look at the list of Microsoft Excel formulas that are most often used in the world of work from the Ministry of Manpower:

Also Read: Want to Study at Undip? Undip 2022 SBUB registration is still open, here are the conditions

• Excel summation formula, SUM

This Excel formula is used to sum data or total data.

= SUM (first cell: last cell)

• Average excel formula, AVERAGE

You want to calculate the average value of data that number in the hundreds? You can use AVERAGE whose formula is as follows:

=AVERAGE(first cell:last cell)

By using Microsoft Excel, workers no longer have difficulty in determining the largest data value. The formula used to find the largest value of a data in Excel is MAX.

= MAX (first cell: last cell)

Also Read: Registration for Unpad 2022 Independent Pathway is Open, Check out the Terms and How to Register

What if you want to find the smallest or lowest value in Excel data? You need to use the MIN formula as follows.

= MIN (first cell: last cell)

The most frequently used Excel formula in the world of work is COUNT. This formula is used to count the number of cells in a range, the formula is as follows.

= COUNT (first cell: last cell)

The formula that is widely used when working next is IF. This formula is a logic test evaluation formula.

The function of IF is to display a value if a condition or statement evaluates to “True”, and returns another value if the condition or statement evaluates to “false”.

=IF(value to search, [jika nilai sesuai makan Benar], [jika nilai tidak sesuai makan Salah])

Also Read: Check out how to claim JKP for workers who have been laid off and the benefits they get

You must have often heard about this formula. VLOOKUP is a formula used to display data from a table arranged in a vertical format.

=VLOOKUP(value to search, range of cells to find value or reference table, column number from reference table, True/False).

The next most frequently used Excel formula is HLOOKUP. This formula displays data from a table arranged in a horizontal format.

=HLOOKUP(value to search, range of cells to find value or reference table, column number from reference table, True/False).

VLOOKUP and HLOOKUP in Excel function to read reference tables where two or more tables have data that are connected to each other.

–