មេរៀនទី១៖ ការស្វែងយល់ដំបូងពី Microsoft Excel - Introduction to Excel for Beginners (Video in Khmer)

Hello everyone! In today's video tutorial, you will learn the complete basics of Microsoft Excel step-by-step.

If you are a complete beginner opening Microsoft Excel for the first time, this guide will help you understand the interface, work with cells, enter data, and write your first formula!

🛠️ Step-by-Step Guide for Absolute Beginners

Step 1: Understand the Excel Interface

• Workbook vs. Worksheet: A workbook is your entire Excel file (.xlsx), while a worksheet (tab at the bottom) is an individual grid page inside the workbook.
• Columns & Rows: Columns run vertically and are labeled with letters (A, B, C). Rows run horizontally and are labeled with numbers (1, 2, 3).
• Cell Address: The intersection of a column and a row forms a Cell (e.g. Column B + Row 5 = Cell B5).

Step 2: Entering Data & Formatting

1. Click any cell to select it.
2. Type text, numbers, or dates, then press Enter (to move down) or Tab (to move right).
3. Use the Home ribbon tab to change font style, font size, cell background colors, and borders.

Step 3: Write Your First Excel Formula

Every Excel formula MUST begin with an equals sign (=):

• Addition: =A1 + B1
• Subtraction: =A1 - B1
• Multiplication: =A1 * B1
• Division: =A1 / B1
• AutoSum Function: =SUM(A1:A10)

💡 Pro Tips for Beginners

1. AutoSum Shortcut (Alt + =): Click below a column of numbers and press Alt + = to insert a =SUM() formula automatically!
2. Jump to Top-Left Cell (Ctrl + Home): Press Ctrl + Home anywhere in your worksheet to jump straight back to cell A1.
3. Undo Typing (Ctrl + Z): Made a mistake? Press Ctrl + Z to undo your last action instantly!