Are you just getting started with Excel? Donโt worry. If you learn these five functions, youโll be able to handle plenty of everyday tasks at work. Here are beginner-friendly explanations and practical examples you can use right away!
โ 1. SUM โ The Basic Way to Add Numbers
This is one of the most frequently used functions. Use it to calculate the total of selected cells.
=SUM(B2:B6)
Tip: To add multiple cells at once, specify the range with a colon (:).
โ 2. AVERAGE โ Calculate an Average
Use this function to calculate the average value in a selected range.
=AVERAGE(C2:C6)
It is useful for calculating grade point averages, test scores, and any other averages.
โ 3. IF โ Return Different Results Based on a Condition
You can create conditional statements in the form of โif this, then that.โ
=IF(D2>=60, "Pass", "Fail")
If cell D2 is 60 or greater, it displays โPassโ; otherwise, it displays โFail.โ
โ 4. COUNTIF โ Count Cells That Meet a Condition
This function is very useful for counting the number of cells that meet a specific condition.
=COUNTIF(E2:E20, "Complete")
You can quickly see how many items have been completed.
โ 5. VLOOKUP โ Find a Value in a Table
This function automatically retrieves the information you need from another worksheet or table.
=VLOOKUP("A001", A2:D10, 3, FALSE)
It finds the value A001 and returns the value from the third column in the same row. It is especially useful for looking up item names, price lists, and codes.
Consider reorganizing your data or using the XLOOKUP function instead.
๐ Summary
- โ SUM: Calculates totals
- ๐ AVERAGE: Calculates averages
- ๐ IF: Returns different results based on a condition
- ๐งฎ COUNTIF: Counts cells that meet a condition
- ๐ VLOOKUP: Finds values in a table
Thereโs no need to be intimidated by Excel. Once you master these five functions, youโre already halfway to handling real-world work tasks! Build your confidence and start practicing right away ๐
๐ Frequently Asked Questions (FAQ)
Q. Where do I enter functions?
A. Enter them in an Excel cell, starting with an equal sign (=), and Excel will recognize them automatically!
Q. Function names are in English. Is there a Korean version?
A. Function names are standardized in English. The menus may be in Korean, but you enter functions in English.
Q. What should I do if VLOOKUP does not work?
A. The lookup value must be on the left, and the value you want to return must be on the right. If it still does not work, consider using XLOOKUP.
Q. Can COUNTIF use numeric criteria too?
A. Yes! For example: =COUNTIF(A2:A10, ">50")
Q. Where should I start if I want to learn Excel for free?
A. You can learn plenty by consistently using the official Microsoft website, YouTube, or this blog.