JAKARTA – Here are seven Excel formulas that administrators need to master. This formula must be mastered and is basic knowledge of Microsoft Excel.
Microsoft Excel is one of the important software in today’s life. The reason is that Excel is a useful software for analyzing and documenting data that is usually used by administrators.
So, what are the formulas an administrator needs to master? Here is the review
AVERAGE
The AVERAGE Excel formula is an easy way to eliminate the need to do calculations yourself. So if you want to find the average of two or more cells, just use “=AVERAGE(X1,X2)” or if you want to find the average over a range, use “=AVERAGE(X1:X22)”.
SUM
For example, if you have a column of cells that list the sales of each unit and you want to know the total of all sales, you can use the SUM function. Select the cell at the bottom of the column where you want to write the total. Then use “=SUM(X1:X22)”, where X1 is the first cell in the range and X22 is the last.
SUMIF
SUMIF has a function to add numbers from certain cells, but with the addition of specific criteria. In the SUMIF formula application example below, “Surabaya” is an example of the location criteria.
SUMIF formula
=SUMIF(range,criteria,[sum_range])
Implementation of SUMIF
=SUMIF(B3:B16,”Surabaya”,D3:D16)
TO COUNT
This formula is used to calculate cells with numeric data. This formula ignores cells that contain anything other than numbers and is useful for tracking numeric data for a variety of reasons. For example, if you want to know the final number of orders listed on your Excel sheet, you can use the COUNT formula, without having to calculate each cell yourself.
The formula is “=COUNT(X1:X22)”
Follow Okezone news on Google News
The following content is presented by the advertiser. Okezone.com journalists are not involved in this content material.
Quoted From Many Source
