Free Download PDF - 50 Popular Excel Formulas Cheatsheet (Khmer Language)
Free download PDF cheatsheet learn 50 popular Excel formulas in Khmer language for beginner.
Advertisement
Hello everyone! Today I share free PDF eBook 50 Popular Excel Formulas (prepared by Mr. Meng Hann). This book include basic calculation, text format, date & time, logical condition, and lookup function for beginner to practice at home easily.
📚 What Inside This PDF Book?
This book contain 5 main group of Excel formulas:
- Basic Calculation Formulas: SUM, AVERAGE, COUNT, COUNTA, MAX, MIN, ROUND, etc.
- Basic Text Formulas: CONCAT, LEFT, RIGHT, MID, LEN, TRIM, UPPER, LOWER, PROPER, etc.
- Basic Date & Time Formulas: TODAY, NOW, DATE, YEAR, MONTH, DAY, TIME, DAYS, etc.
- Basic Logical & Conditional Formulas: IF, AND, OR, NOT, IFERROR, COUNTIF, SUMIF.
- Basic Information & Lookup Formulas: ISNUMBER, ISTEXT, ISBLANK, MATCH.
💡 Related Tutorials & Resources
If you want learn more Excel formulas, check these free guide:
- 📊 Basic Excel Functions Guide — SUM, AVERAGE, COUNT, MIN, MAX
- ⚡ Advanced Excel Functions Guide — VLOOKUP, XLOOKUP, INDEX & MATCH
- ⌨️ Excel Keyboard Shortcuts Reference — 65+ shortcuts to work faster
- 🎥 Watch Khmer Excel Video Tutorials — Step by step video lessons
📋 50 Excel Formulas Cheatsheet Summary Table
Advertisement
Below is quick preview table of 50 formulas inside the PDF file:
1. Basic Calculation Formulas
| # | Formula | Description | Example |
|---|---|---|---|
| 1 | =SUM(range) | Sum all numbers in range | =SUM(A1:A5) |
| 2 | =AVERAGE(range) | Get average value | =AVERAGE(B1:B4) |
| 3 | =COUNT(range) | Count cells with numbers | =COUNT(A1:C5) |
| 4 | =COUNTA(range) | Count all non-empty cells | =COUNTA(A1:A10) |
| 5 | =COUNTBLANK(range) | Count blank cells | =COUNTBLANK(B1:B10) |
| 6 | =MAX(range) | Find highest value | =MAX(C1:C10) |
| 7 | =MIN(range) | Find lowest value | =MIN(C1:C10) |
| 8 | =PRODUCT(range) | Multiply numbers in range | =PRODUCT(A1:A3) |
| 9 | =MOD(number, divisor) | Get remainder of division | =MOD(10, 3) |
| 10 | =ROUND(number, num_digits) | Round number to decimal digits | =ROUND(15.678, 2) |
| 11 | =ABS(number) | Get absolute value | =ABS(-25) |
| 12 | =INT(number) | Get integer part only | =INT(8.95) |
| 13 | =SQRT(number) | Get square root | =SQRT(16) |
| 14 | =POWER(number, power) | Calculate power of number | =POWER(5, 2) |
2. Basic Text Formulas
| # | Formula | Description | Example | Result |
|---|---|---|---|---|
| 15 | =CONCAT(text1, text2, ...) | Join text from multiple cells | =CONCAT("Sok ", "Chea") | Sok Chea |
| 16 | =LEFT(text, [num_chars]) | Cut characters from left | =LEFT("Excel", 2) | Ex |
| 17 | =RIGHT(text, [num_chars]) | Cut characters from right | =RIGHT("Excel", 3) | cel |
| 18 | =MID(text, start, num) | Cut characters from middle | =MID("Microsoft", 6, 4) | soft |
| 19 | =LEN(text) | Count length of characters | =LEN("Khmer") | 5 |
| 20 | =TRIM(text) | Remove extra spaces | =TRIM(" Hello ") | Hello |
| 21 | =UPPER(text) | Convert text to UPPERCASE | =UPPER("apple") | APPLE |
| 22 | =LOWER(text) | Convert text to lowercase | =LOWER("WORK") | work |
| 23 | =PROPER(text) | Convert first letter to uppercase | =PROPER("john doe") | John Doe |
| 24 | =REPLACE(old, start, num, new) | Replace text by position | =REPLACE("2024", 3, 2, "26") | 2026 |
| 25 | =SUBSTITUTE(text, old, new) | Replace old word with new word | =SUBSTITUTE("I like A", "A", "B") | I like B |
| 26 | =REPT(text, number_times) | Repeat text multiple times | =REPT("*", 5) | ***** |
| 27 | =EXACT(text1, text2) | Compare two text exact match | =EXACT("A", "a") | False |
3. Basic Date & Time Formulas
| # | Formula | Description | Example | Result |
|---|---|---|---|---|
| 28 | =TODAY() | Get current date | =TODAY() | 30/05/2026 |
| 29 | =NOW() | Get current date & time | =NOW() | 30/05/2026 15:20 |
| 30 | =DATE(year, month, day) | Create date serial | =DATE(2026, 5, 30) | 30/05/2026 |
| 31 | =YEAR(serial_number) | Extract year number | =YEAR("30/05/2026") | 2026 |
| 32 | =MONTH(serial_number) | Extract month number | =MONTH("30/05/2026") | 5 |
| 33 | =DAY(serial_number) | Extract day number | =DAY("30/05/2026") | 30 |
| 34 | =TIME(hour, minute, second) | Create time serial | =TIME(14, 30, 0) | 2:30 PM |
| 35 | =HOUR(serial_number) | Extract hour number | =HOUR("14:30:00") | 14 |
| 36 | =MINUTE(serial_number) | Extract minute number | =MINUTE("14:30:00") | 30 |
| 37 | =SECOND(serial_number) | Extract second number | =SECOND("14:30:05") | 5 |
| 38 | =WEEKDAY(serial_number) | Get day of week (1=Sun, 7=Sat) | =WEEKDAY("30/05/2026") | 7 |
| 39 | =DAYS(end_date, start_date) | Calculate total days between dates | =DAYS("10/05/2026", "01/05/2026") | 9 |
4. Basic Logical & Conditional Formulas
| # | Formula | Description | Example | Result |
|---|---|---|---|---|
| 40 | =IF(test, true, false) | Check condition TRUE/FALSE | =IF(A1>=50, "Pass", "Fail") | Pass |
| 41 | =AND(logical1, logical2) | Check all conditions TRUE | =AND(A1>10, B1<50) | True |
| 42 | =OR(logical1, logical2) | Check any condition TRUE | =OR(A1>10, B1>100) | True |
| 43 | =NOT(logical) | Reverse logical result | =NOT(A1>10) | False |
| 44 | =IFERROR(value, val_if_error) | Catch calculation error | =IFERROR(A1/B1, "Error") | Error |
| 45 | =COUNTIF(range, criteria) | Count cells with 1 condition | =COUNTIF(A1:A10, "Male") | 6 |
| 46 | =SUMIF(range, crit, [sum_range]) | Sum cells with 1 condition | =SUMIF(A1:A10, ">100") | 500 |
5. Basic Information & Lookup Formulas
| # | Formula | Description | Example | Result |
|---|---|---|---|---|
| 47 | =ISNUMBER(value) | Check if cell is number | =ISNUMBER(50) | True |
| 48 | =ISTEXT(value) | Check if cell is text | =ISTEXT("Sok") | True |
| 49 | =ISBLANK(value) | Check if cell is empty | =ISBLANK(A1) | False |
| 50 | =MATCH(val, array, [type]) | Find relative position in range | =MATCH("Apple", A1:A5, 0) | 3 |
📥 Download PDF Cheatsheet Below
👉 Click link below to open and download PDF:
📥 Download 50 Excel Formulas PDF (Free)
📚 Useful Resources
- Essential Excel Keyboard Shortcuts Every User Should Know (Download Free)
- Top 15 Basic Excel Formulas for Beginners
- Top Microsoft Excel Tips and Tricks Every Spreadsheet User Should Know (Download Free)
- Free Download PDF - Advance Excel VBA Book (Khmer Language)
- Free Download PDF - Learn Computer, Word, Excel, & PowerPoint (Khmer Language)
Found this tutorial helpful? Share it with colleagues:
📚
Related Tutorials
Opens in new tab ↗DownloadsBeginner
Free Cambodia Public Holiday List for Download as Excel File
Free download Excel file for Cambodia Public Holiday list for 2024, 2025, and 2026 to work with NETWORKDAYS and WORKDAY in Excel.
2026-09-07Read more→
DownloadsBeginner
Free Download PDF - Advance Excel with VBA (Khmer Language)
Free download PDF book learn how to use Excel VBA from beginner to advance in Khmer language for beginner.
2026-09-05Read more→
DownloadsBeginner
Free Download PDF - How to use Computer, Word, Excel and PowerPoint (Khmer Language)
Free download PDF book learn computer basic, Microsoft Word, Excel and PowerPoint in Khmer language for beginner.
2026-09-02Read more→
Advertisement