Master Top 10 Basic Excel Formulas for Beginners (Khmer Video + Free Practice File)

Hello everyone! Today I want to teach you the 10 most useful basic Excel formulas for daily work. These formulas will help you calculate numbers, clean text, and count data very easily.

I will explain briefly each function with formula and you can watch the video for more detail how to use each formula along with file download.

Watch video tutorial below in Khmer with full explanation:

1. SUM Formula

SUM formula add all numbers together inside cell range.

=SUM(number1, [number2], ...)

• Example: =SUM(A1:A10) → add all total number from cell A1 to A10.

2. AVERAGE Formula

AVERAGE formula calculate average value from your list of numbers.

=AVERAGE(number1, [number2], ...)

• Example: =AVERAGE(B2:B20) → get average score or average sales amount.

3. MAX Formula

MAX formula find the biggest number inside your data range.

=MAX(number1, [number2], ...)

• Example: =MAX(C1:C50) → find highest salary or max price.

4. MIN Formula

MIN formula find the smallest or lowest number in range.

=MIN(number1, [number2], ...)

• Example: =MIN(C1:C50) → find lowest price item.

5. TODAY Formula

TODAY formula auto get current date today from your computer clock. Update auto every day when open file.

=TODAY()

• Note: No arguments inside bracket!

6. UPPER Formula

UPPER formula convert all text characters into ALL CAPITAL LETTERS.

=UPPER(text)

• Example: =UPPER("hello excel") → return "HELLO EXCEL".

7. LOWER Formula

LOWER formula convert all text characters into all small letters.

=LOWER(text)

• Example: =LOWER("JOHN SMITH") → return "john smith".

8. COUNTIF Formula

COUNTIF formula count how many cells match your condition.

=COUNTIF(range, criteria)

• Example: =COUNTIF(D2:D50, "Pass") → count how many student pass exam.

9. COUNTA Formula

COUNTA formula count all non-empty cells (numbers, text, symbols, anything).

=COUNTA(value1, [value2], ...)

• Example: =COUNTA(A2:A100) → count how many total rows have data.

10. ABS Formula

ABS formula turn negative number into positive number.

=ABS(number)

• Example: =ABS(-150) → return 150.

Download practice file here: Download Practice File

💡 Pro Tips for Beginners

1. AutoSum Shortcut: Click target empty cell under number column and press Alt + = on keyboard for instant SUM formula!
2. Combine Formula: You can use TODAY() inside calculations like =YEAR(TODAY()) to get current year automatically.
3. Difference COUNTA vs COUNT: COUNT() count only numbers, but COUNTA() count everything (text + numbers).