Introduction to Excel for Beginners (Video in Khmer + Tips)

Hello everyone! Today I share with you full course about Microsoft Excel for beginner. If you never use Excel before, don't worry — I explain everything from zero, step by step, very easy to follow.

This course have 10 video lesson. Each video is short and simple. You can watch one by one, or jump to the topic you want learn. All video is in Khmer language so you can understand easy.

1: What is Excel and Why You Need It

First thing first — what is Excel? Excel is software from Microsoft that help you organize data, calculate number, make report, and many more. Almost every office job need Excel. If you learn it, you have big advantage. Trust me.

2: Understand Cell and Input Data Fast

Now you need know about cell. Cell is the small box in Excel — each one have name like A1, B2, C3. After you understand cell name, I show you trick to input data very fast using AutoFill. You type 1 and 2, then drag down — Excel fill the rest for you automatic.

3: How to Calculate Number in Excel

This one very important. I show you how to do basic math in Excel — add, subtract, multiply, divide. You just type formula like =A1+B1 and Excel do the calculation for you. No need calculator anymore.

4: How to Input Data in Excel

In this video I show you more way to input data — text, number, date, everything. You also learn shortcut key to move between cell fast. If you type data every day, this lesson save you a lot of time.

5: Understand Data Type in Excel

Excel have different data type — number, text, date, time, percentage. If you don't understand data type, your formula might give wrong answer. This video explain everything clear so you don't make mistake.

6: Connect Data in Excel

Sometimes you need link data from one cell to another cell, or from one sheet to another sheet. This video show you how to connect data so when you change one place, the other place update automatic. Very powerful trick.

7: Set Border and Print Preview

Before you print your Excel file, you need set border so the table look clean on paper. I also show you Print Preview so you can check how it look before you waste paper. Very important skill for office work.

8: How to Set Page Number in Excel

When you print many page, you need page number so people don't get confuse which page come first. I show you how to add page number in header or footer. Take only 1 minute to set up.

9: Data Format and Text Alignment

Your data look messy? This video show you how to format number (add comma, decimal, currency), change text alignment (left, center, right), and make your spreadsheet look professional and easy to read.

10: How to use clipboard in Excel

Clipboard is the place where you can store the data that you want to use in your Excel file. It is a very useful tool for copying and pasting data from one cell to another cell, or from one sheet to another sheet.

11: How to Wrap Text and Set New Line in Excel

This video show you how to wrap text and set new line in Excel. It is a very useful tool for copying and pasting data from one cell to another cell, or from one sheet to another sheet.

12: How to Merge & Center in Excel

This video show you how to merge & center in Excel. It is a very useful tool for copying and pasting data from one cell to another cell, or from one sheet to another sheet.

13: Work with Worksheet and Format Painter (Summary)

Last lesson! I show you how to add new sheet, rename sheet, change tab color, and move sheet around. Also I teach you Format Painter — this tool copy the style from one cell and paste to another cell. Double-click Format Painter to apply to many cell at once. Super useful!

💡 Tip: When you learn Excel, don't try memorize everything. Just practice a little bit every day. Open Excel, try type some data, make simple formula. After 2 week you will feel very comfortable. The more you practice, the faster you learn!

📚 Related Tutorials

After you finish this beginner course, you can continue learn more with these post:

• Top 15 Basic Excel Formulas for Beginners — Learn the most useful formula you need every day.
• Excel Keyboard Shortcuts — Make you work faster, save a lot of time.
• How to Highlight Data in Excel — Make your important data stand out with color.
• Calculate Number of Students (Male/Female/Pass/Fail) — Learn COUNTIF formula with real example.