41. How to Convert Number and Date to Khmer Number and Date in Excel

41. How to Convert Number and Date to Khmer Number and Date in Excel
(របៀបបំលែងលេខ និង ថ្ងៃខែឆ្នាំទៅជាភាសាខ្មែរ)
In this Excel tutorial in Khmer show you step by step how to convert Number (1,2,3,...) into Khmer Number (១,២,៣, ...) and date like 20/06/2022 into Khmer date (ថ្ងៃចន្ទ ទី២០ ខែមិថុនា ឆ្នាំ២០២២).

Number to Khmer Format: [$-kh-km,1200]0
Date Format in Khmer: [$-kh-km,1200]dddd dd mmmm yyyy

Download Full PDF and Excel Example Files: Click Here
Register My Special Course: វគ្គ ១០១ រូបមន្ត Excel

Download Example Excel File below
Download Souce 1
Download Souce 2

42. How to Prepare Excel File for Printing speak Khmer

42. How to Prepare Excel File for Printing speak Khmer
(រៀបចំឯកសារបោះពុម្ភ Print + PDF)
If you want to print Excel document, here some tips and trick would help you. You may need to do the following:

1. Page Setup:
- Margin: Left, right, top, buttom
- Paper: A4
- Orientation: Lanscape or Portrait
2. Check Printer setting: Paper = A4

Please check the video for more information.

Learn More: How to Print (Word, Excel and PowerPoint)

Download Full PDF and Excel Example Files: Click Here
Register My Special Course: វគ្គ ១០១ រូបមន្ត Excel

Download Example Excel File below
Download Souce 1
Download Souce 2

40. How to Split Date and Convert to Date Format in Excel Khmer

How to Split Date and Convert to Date Format in Excel Khmer
(បំបែកថ្ងៃខែឆ្នាំ និង តភ្ជាប់ជា Date វិញ) - In this Excel tips show how to split date into number as Day, Month and Year in normal value. Then show you how to convert that numbers into date format with help of DATE formula.

DATE Formula: Convert number input into Date format

=DATE(Year, Month, Day)
◾ Year: Required, number of year.
◾ Month: Required, number of month.
◾ Day: Required, number of day.

Download Full PDF and Excel Example Files: Click Here
Register My Special Course: វគ្គ ១០១ រូបមន្ត Excel

Download Example Excel File below
Download Souce 1
Download Souce 2

39. Date Formulas in Excel (Now, Today, Day, Month and Year)

Date Formulas in Excel (Now, Today, Day, Month and Year)
In this Excel tutorial show you the different Now() and Today() formula and also how to get Day, Month, Year from date too.

NOW Formula: return current date and time

=NOW()

TODAY Formula: return current date only

=TODAY()

DAY Formula: return number of day from date

=DAY(serial_number)
◾ serial_number: Required, is your date.

Month Formula: return Month from date

=Month(serial_number)
◾ serial_number: Required, is your date.

Year Formula: return year from date

=Year(serial_number)
◾ serial_number: Required, is your date.

Download Full PDF and Excel Example Files: Click Here
Register My Special Course: វគ្គ ១០១ រូបមន្ត Excel

Download Example Excel File below
Download Souce 1
Download Souce 2

38. How to Create New Line in Excel Khmer

38. How to Create New Line in Excel Khmer
(របៀបចុះបន្ទាត់ និង ទំលាក់ជាពីរជូរ) - In this Excel tutorial in Khmer how to create new line of text in a cell with shorcut key and wrap text.

Download Full PDF and Excel Example Files: Click Here
Register My Special Course: វគ្គ ១០១ រូបមន្ត Excel

Download Example Excel File below
Download Souce 1
Download Souce 2

37. How to create Drop Down List in Excel Khmer

37. How to create Drop Down List in Excel speak Khmer
(របៀបបង្កើត Drop Down List) - In this Excel tutorial show you two ways to create simple drop down list.
Drop down list help you to make your data more accurate. Please check the video for more information.

Download Full PDF and Excel Example Files: Click Here
Register My Special Course: វគ្គ ១០១ រូបមន្ត Excel

Download Example Excel File below
Download Souce 1
Download Souce 2

36. Excel Files Type and Compatibility Mode

Excel Files Type and Compatibility Mode
(ស្គាល់ពីប្រភេទ File ផ្សេងៗ និង Compatibility Mode) - Excel is come with variety of files type. In this video show you the 5 simple files types and how to work with Compatibility mode with trick to fix it.

Download Full PDF and Excel Example Files: Click Here
Register My Special Course: វគ្គ ១០១ រូបមន្ត Excel