tag:blogger.com,1999:blog-1742350258271097522024-03-13T07:47:48.645+07:00Tos.Rean.MeTos Rean (Rean Computer 101) is Khmer online video resources for learners. Main contents are Microsoft Excel Khmer, Windows 10/11 in Khmer, How to Video and Tech Tips and TricksHannhttp://www.blogger.com/profile/13176110046706075521noreply@blogger.comBlogger65125tag:blogger.com,1999:blog-174235025827109752.post-25702123020440833552022-06-21T15:27:00.009+07:002022-09-30T16:26:58.043+07:0041. How to Convert Number and Date to Khmer Number and Date in Excel<iframe allowfullscreen="" frameborder="0" height="315" id="bigframe" src="https://www.youtube.com/embed/nRSEp9IOc7g" width="100%"></iframe>
<b>41. How to Convert Number and Date to Khmer Number and Date in Excel</b><br>
(របៀបបំលែងលេខ និង ថ្ងៃខែឆ្នាំទៅជាភាសាខ្មែរ)<br>
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 (ថ្ងៃចន្ទ ទី២០ ខែមិថុនា ឆ្នាំ២០២២).<br><br>
<pre>
Number to Khmer Format: [$-kh-km,1200]0
Date Format in Khmer: [$-kh-km,1200]dddd dd mmmm yyyy
</pre>
<br>
<b>Download Full PDF and Excel Example Files: <a href="https://bit.ly/3b6SBxf" target="_blank">Click Here</a>
<br>
Register My Special Course: <a href="https://bit.ly/101ExcelFormulasKH" target="_blank">វគ្គ ១០១ រូបមន្ត Excel</a></b>
<br>
<br>
<b> Download Example Excel File below</b><br />
<a href="https://app.box.com/s/dnqlhjvzkaefz05axbngxnlfhqjdgkqq" target="_blank">Download Souce 1</a><br>
<a href="https://mega.nz/file/D8dHmCJL#IAwaQFtakGhOEitt13t2M7EjkSdBzvXdMLxYBwQ5-sk" target="_blank">Download Souce 2</a>
<br><br>
<button class="btn"><a href="https://bit.ly/3mODVp4" target="_blank">Start </a><i class="fa fa-home"></i></button>
<button class="btn"><a href="https://bit.ly/3OaX7JG" target="_blank">Previous Video </a><i class="fa fa-arrow-circle-left"></i></button>
<button class="btn"><i class="fa fa-arrow-circle-right"></i>
<a href="https://bit.ly/3N9pdn2" target="_blank">Next Video</a></button>Hannhttp://www.blogger.com/profile/13176110046706075521noreply@blogger.com0tag:blogger.com,1999:blog-174235025827109752.post-64370141400744028452022-06-21T15:21:00.006+07:002022-09-30T16:29:29.159+07:0042. How to Prepare Excel File for Printing speak Khmer<iframe allowfullscreen="" frameborder="0" height="315" id="bigframe" src="https://www.youtube.com/embed/uvP-9v9rp_U" width="100%"></iframe>
<b>42. How to Prepare Excel File for Printing speak Khmer</b><br>
(រៀបចំឯកសារបោះពុម្ភ Print + PDF)<br>
If you want to print Excel document, here some tips and trick would help you. You may need to do the following:<br><br>
1. Page Setup:<br>
- Margin: Left, right, top, buttom<br>
- Paper: A4<br>
- Orientation: Lanscape or Portrait<br>
2. Check Printer setting: Paper = A4<br><br>
Please check the video for more information.<br><br>
<b>Learn More: <a href="https://bit.ly/38idx3a" target="_blank">How to Print (Word, Excel and PowerPoint)</a><b>
<br>
<br>
<b>Download Full PDF and Excel Example Files: <a href="https://bit.ly/3b6SBxf" target="_blank">Click Here</a>
<br>
Register My Special Course: <a href="https://bit.ly/101ExcelFormulasKH" target="_blank">វគ្គ ១០១ រូបមន្ត Excel</a></b>
<br>
<br>
<b> Download Example Excel File below</b><br />
<a href="https://mega.nz/file/n80jWSQC#Tt_MD_oHqjVw-0UssZxUpjxj9dotRFSnl7JVWIyCkXM" target="_blank">Download Souce 1</a><br>
<a href="https://app.box.com/s/stvcmhgvrrnsy68tbubkf9wli1ghlsgo" target="_blank">Download Souce 2</a>
<br><br>
<button class="btn"><a href="https://bit.ly/3mODVp4" target="_blank">Start </a><i class="fa fa-home"></i></button>
<button class="btn"><a href="https://bit.ly/3zS0tg8" target="_blank">Previous Video </a><i class="fa fa-arrow-circle-left"></i></button>
<button class="btn"><i class="fa fa-arrow-circle-right"></i>
<a href="https://bit.ly/3mODVp4" target="_blank">THANK Youuuuuu</a></button>
Hannhttp://www.blogger.com/profile/13176110046706075521noreply@blogger.com0tag:blogger.com,1999:blog-174235025827109752.post-31775745552899456992022-06-21T15:16:00.006+07:002022-09-30T16:30:09.325+07:0040. How to Split Date and Convert to Date Format in Excel Khmer<iframe allowfullscreen="" frameborder="0" height="315" id="bigframe" src="https://www.youtube.com/embed/UYWtmjYSiOQ" width="100%"></iframe>
<b>How to Split Date and Convert to Date Format in Excel Khmer</b><br>
(បំបែកថ្ងៃខែឆ្នាំ និង តភ្ជាប់ជា 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 <b>DATE</b> formula.<br>
<div class="separator" style="clear: both;"><img alt="" border="0" data-original-height="233" data-original-width="730" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5wVOTm1zHqmnccvfsfJEK9iUsgDAHIDq_U6Q3ek2mFB1iR-NvfIu0dGqyq9ktDr6UgJsM1sR2KcoJlpXdXLZxtvTtMRedhUsUT3CyGPSznSiIn3c7ePWoDPRfBk1gbAxf_9e0HqqkA_csQ1ecj5mV4-H5GQsSvW0HNr1RqDwJYyWT-OxcwCISVMsoSw/s1600/Date%20formula%20in%20Excel%20khmer.PNG"/></div>
<b>DATE Formula: Convert number input into Date format</b>
<div class="formula"> =DATE(Year, Month, Day)<br>
◾ Year: Required, number of year.<br>
◾ Month: Required, number of month.<br>
◾ Day: Required, number of day.<br>
</div>
<br>
<b>Download Full PDF and Excel Example Files: <a href="https://bit.ly/3b6SBxf" target="_blank">Click Here</a>
<br>
Register My Special Course: <a href="https://bit.ly/101ExcelFormulasKH" target="_blank">វគ្គ ១០១ រូបមន្ត Excel</a></b>
<br>
<br>
<b> Download Example Excel File below</b><br />
<a href="https://app.box.com/s/a8mpny2n69xhy8jbhbfswr9poror9dau" target="_blank">Download Souce 1</a><br>
<a href="https://mega.nz/file/S0ciAACA#LexFbhF0ODgO33SGK3pErmsIALKr3fvo3pDbzLvzl-w" target="_blank">Download Souce 2</a>
<br><br>
<button class="btn"><a href="https://bit.ly/3mODVp4" target="_blank">Start </a><i class="fa fa-home"></i></button>
<button class="btn"><a href="https://bit.ly/3y68pZT" target="_blank">Previous Video </a><i class="fa fa-arrow-circle-left"></i></button>
<button class="btn"><i class="fa fa-arrow-circle-right"></i>
<a href="https://bit.ly/3zS0tg8" target="_blank">Next Video</a></button>
Hannhttp://www.blogger.com/profile/13176110046706075521noreply@blogger.com0tag:blogger.com,1999:blog-174235025827109752.post-72085958882159517822022-06-21T15:00:00.005+07:002022-09-30T16:30:46.569+07:0039. Date Formulas in Excel (Now, Today, Day, Month and Year)<iframe allowfullscreen="" frameborder="0" height="315" id="bigframe" src="https://www.youtube.com/embed/yZUGHwJ8uSM" width="100%"></iframe>
<b>Date Formulas in Excel (Now, Today, Day, Month and Year)</b><br>
In this Excel tutorial show you the different Now() and Today() formula and also how to get Day, Month, Year from date too. <br>
<div class="separator" style="clear: both;"><img alt="" border="0" data-original-height="388" data-original-width="889" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhH9SG9yb-ScvLar_p-GwtoewA3Ddt2QmCS5yw5HGyJrbgFEhQMDf18vXfpN28y6ZYDZC0sAcb-vNZgT8skVP0vjXdvadvU_3z6GWEeZvePrcHbmjD9DUmo8YVORvGGJlHI2bmbfgfp4RTn1Upp94CfW7Ufecm9Ul1jgYD8R-KE7hHkr2CH0G8t3ecAsQ/s1600/Now%20Today%20Day%20Month%20and%20year%20Formula%20in%20Excel%20Khmer%20%281%29.png"/></div>
<br>
<b>NOW Formula: return current date and time</b>
<div class="formula"> =NOW()</div><br>
<b>TODAY Formula: return current date only</b>
<div class="formula"> =TODAY()</div><br>
<b>DAY Formula: return number of day from date</b>
<div class="formula"> =DAY(serial_number)<br>
◾ serial_number: Required, is your date.
</div><br>
<b>Month Formula: return Month from date</b>
<div class="formula"> =Month(serial_number)<br>
◾ serial_number: Required, is your date.
</div><br>
<b>Year Formula: return year from date</b>
<div class="formula"> =Year(serial_number)<br>
◾ serial_number: Required, is your date.
</div>
<br>
<b>Download Full PDF and Excel Example Files: <a href="https://bit.ly/3b6SBxf" target="_blank">Click Here</a>
<br>
Register My Special Course: <a href="https://bit.ly/101ExcelFormulasKH" target="_blank">វគ្គ ១០១ រូបមន្ត Excel</a></b>
<br>
<br>
<b> Download Example Excel File below</b><br />
<a href="https://mega.nz/file/z5ci2YgI#2m5_NRAtS1xaxt1BfkIB3gdK408cae3Xm1kloQWNPws" target="_blank">Download Souce 1</a><br>
<a href="https://app.box.com/s/n5u0qlnesg7h03j9yekuiq252fumhv7l" target="_blank">Download Souce 2</a>
<br><br>
<button class="btn"><a href="https://bit.ly/3mODVp4" target="_blank">Start </a><i class="fa fa-home"></i></button>
<button class="btn"><a href="https://bit.ly/3zN0Bh7" target="_blank">Previous Video </a><i class="fa fa-arrow-circle-left"></i></button>
<button class="btn"><i class="fa fa-arrow-circle-right"></i>
<a href="https://bit.ly/3OaX7JG" target="_blank">Next Video</a></button>
Hannhttp://www.blogger.com/profile/13176110046706075521noreply@blogger.com0tag:blogger.com,1999:blog-174235025827109752.post-69160155652904734582022-06-21T13:54:00.002+07:002022-09-30T16:31:25.092+07:0038. How to Create New Line in Excel Khmer <iframe allowfullscreen="" frameborder="0" height="315" id="bigframe" src="https://www.youtube.com/embed/MWr0TpbCB7M" width="100%"></iframe>
<b>38. How to Create New Line in Excel Khmer </b><br>
(របៀបចុះបន្ទាត់ និង ទំលាក់ជាពីរជូរ) - In this Excel tutorial in Khmer how to create new line of text in a cell with shorcut key and wrap text.<br>
<div class="separator" style="clear: both;"><img alt="" border="0" data-original-height="245" data-original-width="795" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEga1h5mrzYU8ylyL-pj87K4ranfkJ4G9jj3iRrxlgfyzR25YHvQL-JdcJq8istyRyfdGGbOUc7L4bwqILGTkdKuiObiD9t_NlPSCbT6LgRPDPj-Gzc1SJE-76jubsGK1XoXSxvbJha8vZKYI4-LoRKzYRmtoogCLJ_9uiggyiZH54fOP9q7haiGc1wwUw/s1600/new%20line.PNG"/></div>
<br>
<b>Download Full PDF and Excel Example Files: <a href="https://bit.ly/3b6SBxf" target="_blank">Click Here</a>
<br>
Register My Special Course: <a href="https://bit.ly/101ExcelFormulasKH" target="_blank">វគ្គ ១០១ រូបមន្ត Excel</a></b>
<br>
<br>
<b> Download Example Excel File below</b><br />
<a href="https://app.box.com/s/76t8rxlt5fjom12laubloaijeadc5bn4" target="_blank">Download Souce 1</a><br>
<a href="https://mega.nz/file/qw1SSDzJ#GiDfiXQt2LR4HqdtJ7ivqo99TmkWiF5XQFgG24Hrd2s" target="_blank">Download Souce 2</a>
<br><br>
<button class="btn"><a href="https://bit.ly/3mODVp4" target="_blank">Start </a><i class="fa fa-home"></i></button>
<button class="btn"><a href="https://bit.ly/3zRQJCL" target="_blank">Previous Video </a><i class="fa fa-arrow-circle-left"></i></button>
<button class="btn"><i class="fa fa-arrow-circle-right"></i>
<a href="https://bit.ly/3y68pZT" target="_blank">Next Video</a></button>Hannhttp://www.blogger.com/profile/13176110046706075521noreply@blogger.com0tag:blogger.com,1999:blog-174235025827109752.post-50321691934509601402022-06-21T13:43:00.005+07:002022-09-30T16:35:21.325+07:0037. How to create Drop Down List in Excel Khmer<iframe allowfullscreen="" frameborder="0" height="315" id="bigframe" src="https://www.youtube.com/embed/Jne9YHtmDPQ" width="100%"></iframe>
<b>37. How to create Drop Down List in Excel speak Khmer</b><br>
(របៀបបង្កើត Drop Down List) - In this Excel tutorial show you two ways to create simple drop down list. <br><b>Drop down list</b> help you to make your data more accurate. Please check the video for more information.<br>
<div class="separator" style="clear: both;"><img alt="" border="0" data-original-height="390" data-original-width="519" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjLkRnxzmUg1b986kBNGVoF0Qgn8mZ4HFC8d0mMCpgwuonjG6RJbMg_1I7ePJWUPt2FexjgcPy85uhfqo0E5W1Zh71AxX-Y3SM5SwIOySkPscdOlmO-MjeWZ2_2Jbfr8eLwIZ5XXORLIPFSORv2BT23K3nqCRrST2fSQ3T5GqvcQGA8HYd2w7tjwu_okw/s1600/dropdown%20list%20in%20Excel%20speak%20Khmer%20%281%29.png"/></div>
<br>
<b>Download Full PDF and Excel Example Files: <a href="https://bit.ly/3b6SBxf" target="_blank">Click Here</a>
<br>
Register My Special Course: <a href="https://bit.ly/101ExcelFormulasKH" target="_blank">វគ្គ ១០១ រូបមន្ត Excel</a></b>
<br>
<br>
<b> Download Example Excel File below</b><br />
<a href="https://app.box.com/s/xj2ihnvpueg79oofxzrlto4u32z4xli0" target="_blank">Download Souce 1</a><br>
<a href="https://mega.nz/file/X0EBwaqJ#l0eP_fBUduNuAn4nisct5TsDFyPQizRku2xh5-kUM_A" target="_blank">Download Souce 2</a>
<br><br>
<button class="btn"><a href="https://bit.ly/3mODVp4" target="_blank">Start </a><i class="fa fa-home"></i></button>
<button class="btn"><a href="https://bit.ly/3N3oaVL" target="_blank">Previous Video </a><i class="fa fa-arrow-circle-left"></i></button>
<button class="btn"><i class="fa fa-arrow-circle-right"></i>
<a href="https://bit.ly/3zN0Bh7" target="_blank">Next Video</a></button>Hannhttp://www.blogger.com/profile/13176110046706075521noreply@blogger.com0tag:blogger.com,1999:blog-174235025827109752.post-79471663219317184932022-06-21T13:32:00.006+07:002022-09-30T16:35:56.637+07:0036. Excel Files Type and Compatibility Mode <iframe allowfullscreen="" frameborder="0" height="315" id="bigframe" src="https://www.youtube.com/embed/vxyRB469FY0" width="100%"></iframe>
<b> Excel Files Type and Compatibility Mode </b><br>
(ស្គាល់ពីប្រភេទ 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. <br>
<br>
<b>Download Full PDF and Excel Example Files: <a href="https://bit.ly/3b6SBxf" target="_blank">Click Here</a>
<br>
Register My Special Course: <a href="https://bit.ly/101ExcelFormulasKH" target="_blank">វគ្គ ១០១ រូបមន្ត Excel</a></b>
<br>
<br>
<button class="btn"><a href="https://bit.ly/3mODVp4" target="_blank">Start </a><i class="fa fa-home"></i></button>
<button class="btn"><a href="https://bit.ly/3Ob66KG" target="_blank">Previous Video </a><i class="fa fa-arrow-circle-left"></i></button>
<button class="btn"><i class="fa fa-arrow-circle-right"></i>
<a href="https://bit.ly/3zRQJCL" target="_blank">Next Video</a></button>Hannhttp://www.blogger.com/profile/13176110046706075521noreply@blogger.com0tag:blogger.com,1999:blog-174235025827109752.post-70711083149535264742022-06-21T12:59:00.004+07:002022-09-30T16:36:08.318+07:0035. How to set Password in Excel File speak Khmer<iframe allowfullscreen="" frameborder="0" height="315" id="bigframe" src="https://www.youtube.com/embed/nb4rhPsvXRw" width="100%"></iframe>
<b>35. How to set Password in Excel File speak Khmer</b><br>
(របៀបដាក់ Password លើឯកសារ)<br>
If you important Excel file and don't other to see by just open then you can set password before they can open it. Set password to your Excel file help to secure your data and privacy but you need to remember it or noted it. Please check the video for more information.<br>
<div class="separator" style="clear: both;"><img alt="" border="0" data-original-height="233" data-original-width="434" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFnkc9rCLuILa3ofCDD9DWpuW41kFjlk6v9q3b4ct85BGo6WH45Mz5tdlmpb2PxOcH5CJhJFbIqTrZxN3Q0Otstn6piVHycjD5TdrRyM7Qnb1l_vKxTKafBeE4pdzX7KqD8UsnpQaRcUkP3RvIzoJDaAjjPPWbGYY9C-pXhvak1UYizlkrYvApdA9NpA/s1600/password.PNG"/></div>
<br>
<b>Download Full PDF and Excel Example Files: <a href="https://bit.ly/3b6SBxf" target="_blank">Click Here</a>
<br>
Register My Special Course: <a href="https://bit.ly/101ExcelFormulasKH" target="_blank">វគ្គ ១០១ រូបមន្ត Excel</a></b>
<br>
<br>
<button class="btn"><a href="https://bit.ly/3mODVp4" target="_blank">Start </a><i class="fa fa-home"></i></button>
<button class="btn"><a href="https://bit.ly/3HF4zKC" target="_blank">Previous Video </a><i class="fa fa-arrow-circle-left"></i></button>
<button class="btn"><i class="fa fa-arrow-circle-right"></i>
<a href="https://bit.ly/3N3oaVL" target="_blank">Next Video</a></button>
Hannhttp://www.blogger.com/profile/13176110046706075521noreply@blogger.com0tag:blogger.com,1999:blog-174235025827109752.post-55334713073784420412022-06-21T12:49:00.002+07:002022-09-30T16:36:22.317+07:0034. How to Check File Information in Excel speak Khmer<iframe allowfullscreen="" frameborder="0" height="315" id="bigframe" src="https://www.youtube.com/embed/GNkANiYsotg" width="100%"></iframe>
<b>34. How to Check File Information in Excel speak Khmer</b><br>
(របៀបមើលព័ត៌មានក្នុងឯកសារ) <br>
In this Excel tutorial in Khmer show you how to check information on your Excel file like file size, created date, last modified date and even more about the author or change other information if you got wrong one.<br>
<div class="separator" style="clear: both;"><img alt="" border="0" data-original-height="662" data-original-width="1003" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIKYdimk_rxSQSDM07m0oUCRsHXTgX7O4uTc8gpSVyp650sckeemVM6U3fsj62FJ4Nf93XNsJrC-QMRP2GaPHHHlBeEPm8ZKtB2tu3gavo8jNX4R_4hYf7_Q2nv0Tpy-MlzbLHh2D8IuhJBEM2W_EdoFtXYHdsA-Ql5LcWGKN-KtwraNMZd8lG1E2rMA/s1600/document%20info%20%281%29.png"/></div>
<br>
<b>Download Full PDF and Excel Example Files: <a href="https://bit.ly/3b6SBxf" target="_blank">Click Here</a>
<br>
Register My Special Course: <a href="https://bit.ly/101ExcelFormulasKH" target="_blank">វគ្គ ១០១ រូបមន្ត Excel</a></b>
<br>
<br>
<button class="btn"><a href="https://bit.ly/3mODVp4" target="_blank">Start </a><i class="fa fa-home"></i></button>
<button class="btn"><a href="https://bit.ly/3zRtLf1" target="_blank">Previous Video </a><i class="fa fa-arrow-circle-left"></i></button>
<button class="btn"><i class="fa fa-arrow-circle-right"></i>
<a href="https://bit.ly/3Ob66KG" target="_blank">Next Video</a></button>
Hannhttp://www.blogger.com/profile/13176110046706075521noreply@blogger.com0tag:blogger.com,1999:blog-174235025827109752.post-46301447322396618252022-06-21T09:10:00.003+07:002022-09-30T16:37:09.314+07:0033. Ten Excel Keyboard Shortcut You Should Know<iframe allowfullscreen="" frameborder="0" height="315" id="bigframe" src="https://www.youtube.com/embed/ohYVlxJpW8U" width="100%"></iframe>
<b>10 Excel Keyboard Shortcuts You Should Know</b><br>
(10 Excel Shortcut Keys ដែលអ្នកត្រូវដឹង) - These 10 keyboard shortcuts are helpful and time saving when working with Excel or other Microsoft application software like Word. <br> Below are the collection of all Excel Keyboard shortcuts.<br>
<div class="separator" style="clear: both;"><img alt="" border="0" data-original-height="2134" data-original-width="3793" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtFZ-2nPEC8TMsY8ZU7X8Z4EgrqniDym35K6gfN_IsQWpMhI71TeicR6v0GneWwlqMiWyzWICvIqr4BxcXEimpoX6BA0ENFssnzyZ5_jOweQWtFIIb_BKmc8qZQSU9xaf7K1mJ4nW6TdyCpdjFxX3tasKIq17UciFmmuStD9UNnOaq_XoJz5vuCE3OYw/s1600/%E1%9E%9A%E1%9F%80%E1%9E%93%20Excel%20101_Page_34.jpg"/></div>
<div class="separator" style="clear: both;"><img alt="" border="0" data-original-height="2134" data-original-width="3793" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiKV1mxndRRsGBzESDXMdBgPNGGK3SB-v0kKIkMJNprOzVqtKN3V_5uvbth_cs5_mZ2w6IWuQdURdwoTLBhh2xRRicHmW_hAbpk2zdhPqX20PVQRjxLF-zp2JI6VEQDpUuKEXziuAKpGYu3WyyUn565j_iCjEWunx50UW-Y0F83ZkVeI6bJE8qF-jaEvA/s1600/%E1%9E%9A%E1%9F%80%E1%9E%93%20Excel%20101_Page_35.jpg"/></div>
<div class="separator" style="clear: both;"><img alt="" border="0" data-original-height="2134" data-original-width="3793" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjmbuXjsBgDk3S9p6odPIM_Byz5NFybBuVsLFu5xuZfufRYqyZLXi_qlaJnabhDOQeCkashaFR57Vdaq77W6HDpmAaeTgP8xA6ly6VI4iKiW1HYn9A19U5pdUVGhcSz1bdXn6zx0iXGknTCY50s7_SUzdi9tRCeV_k7vGfAOOy4sLTYUVHGqe4ir524Iw/s1600/%E1%9E%9A%E1%9F%80%E1%9E%93%20Excel%20101_Page_36.jpg"/></div>
<div class="separator" style="clear: both;"><img alt="" border="0" data-original-height="2134" data-original-width="3793" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqNCkptx0mdI_2fQw6ksq_qFYN7s79Qhk0WkVI_-g3p9zSslQQXLOTrC-T0sz5QyIBdPwGZwsQ4cAnqA6GqhBmcMeJdfdSdlYnbCcMvj8vBV81nb4CnQsLVvmIueDDCUWJeyrsBNT4jZUTzU9zzA8ukESmZPGUTsUDo2fwsHj8enR7dh_GHx1q7i9mPg/s1600/%E1%9E%9A%E1%9F%80%E1%9E%93%20Excel%20101_Page_37.jpg"/></div>
<div class="separator" style="clear: both;"><img alt="" border="0" data-original-height="2134" data-original-width="3793" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzeuQhyP16Wc6g4XfLtYzwD_aA2evT2dpJqFUlaxVW62pULY9OsCGlB7x5LskTuViuux7nDCNfY0nWtJKVOr_k-_1EH0KBZOCrMOD44CbuEVIKBUtZJKsaKsaasX-sDyQSC0qSmeQULonD5cqnO4JYUby-H7hcobTYUbu3ZGkgoHPuTnMgYnrsM-zxoA/s1600/%E1%9E%9A%E1%9F%80%E1%9E%93%20Excel%20101_Page_38.jpg"/></div>
<br>
<b>Download Full PDF and Excel Example Files: <a href="https://bit.ly/3b6SBxf" target="_blank">Click Here</a>
<br>
Register My Special Course: <a href="https://bit.ly/101ExcelFormulasKH" target="_blank">វគ្គ ១០១ រូបមន្ត Excel</a></b>
<br>
<br>
<b> Download Example Excel File below</b><br />
<a href="https://app.box.com/s/kfedzc50g5ima7jlwjs3b66885n94uf9" target="_blank">Download Souce 1</a><br>
<a href="https://mega.nz/file/vpsmnRCC#BW9V218oq1UhpRL8si0QVB7PYvK6gccdUIKoUm93msY" target="_blank">Download Souce 2</a>
<br><br>
<button class="btn"><a href="https://bit.ly/3mODVp4" target="_blank">Start </a><i class="fa fa-home"></i></button>
<button class="btn"><a href="https://bit.ly/3mXTJpD" target="_blank">Previous Video </a><i class="fa fa-arrow-circle-left"></i></button>
<button class="btn"><i class="fa fa-arrow-circle-right"></i>
<a href="https://bit.ly/3HF4zKC" target="_blank">Next Video</a></button>
Hannhttp://www.blogger.com/profile/13176110046706075521noreply@blogger.com0tag:blogger.com,1999:blog-174235025827109752.post-61098750409844830652022-06-20T14:40:00.004+07:002022-09-30T16:37:51.698+07:0032. Working with data from Sheet to Sheet in Excel Khmer<iframe allowfullscreen="" frameborder="0" height="315" id="bigframe" src="https://www.youtube.com/embed/2lPvRTUkdeA" width="100%"></iframe>
<b>32. Working with data from Sheet to Sheet in Excel speak Khmer</b><br>
(គណនាទិន្នន័យឆ្លង sheet) In this Excel tutorial in Khmer show you how to get value from one sheet to another sheet. You can also calculate across sheet too.<br>
<br>
<b>Download Full PDF and Excel Example Files: <a href="https://bit.ly/3b6SBxf" target="_blank">Click Here</a>
<br>
Register My Special Course: <a href="https://bit.ly/101ExcelFormulasKH" target="_blank">វគ្គ ១០១ រូបមន្ត Excel</a></b>
<br>
<br>
<b> Download Example Excel File below</b><br />
<a href="https://mega.nz/file/u0lT3SyI#zMJpYOpgZ8PlAkhkf0NQS3GtAse0eVgVjwNmMvNBeKs" target="_blank">Download Souce 1</a><br>
<a href="https://app.box.com/s/uilje4jg4q2aicjfp58pmnj4a8mowzhi" target="_blank">Download Souce 2</a>
<br><br>
<button class="btn"><a href="https://bit.ly/3mODVp4" target="_blank">Start </a><i class="fa fa-home"></i></button>
<button class="btn"><a href="https://bit.ly/3xIfZsB" target="_blank">Previous Video </a><i class="fa fa-arrow-circle-left"></i></button>
<button class="btn"><i class="fa fa-arrow-circle-right"></i>
<a href="https://bit.ly/3zRtLf1" target="_blank">Next Video</a></button>
Hannhttp://www.blogger.com/profile/13176110046706075521noreply@blogger.com0tag:blogger.com,1999:blog-174235025827109752.post-63398110725738388522022-06-20T14:25:00.004+07:002022-09-30T16:38:27.315+07:0031. How to remove DUPLICATE Data in Excel Khmer<iframe allowfullscreen="" frameborder="0" height="315" id="bigframe" src="https://www.youtube.com/embed/yIo6tcfGXV8" width="100%"></iframe>
<b>31. How to remove DUPLICATE Data in Excel speak Khmer</b><br>
(របៀបលុបទិន្នន័យដែលស្ទួន) If you have lot of data may contain duplicate value, so Excel help you to do that with no time to wait. <br>
Just select you data then go to Data Menu >> Remove Duplicate. <br>
<br>
<b>Download Full PDF and Excel Example Files: <a href="https://bit.ly/3b6SBxf" target="_blank">Click Here</a>
<br>
Register My Special Course: <a href="https://bit.ly/101ExcelFormulasKH" target="_blank">វគ្គ ១០១ រូបមន្ត Excel</a></b>
<br>
<br>
<button class="btn"><a href="https://bit.ly/3mODVp4" target="_blank">Start </a><i class="fa fa-home"></i></button>
<button class="btn"><a href="https://bit.ly/3b0Urzt" target="_blank">Previous Video </a><i class="fa fa-arrow-circle-left"></i></button>
<button class="btn"><i class="fa fa-arrow-circle-right"></i>
<a href="https://bit.ly/3mXTJpD" target="_blank">Next Video</a></button>
Hannhttp://www.blogger.com/profile/13176110046706075521noreply@blogger.com0tag:blogger.com,1999:blog-174235025827109752.post-58510188846767547172022-06-20T14:19:00.008+07:002022-09-30T16:39:32.078+07:0030. How to Sort Data base on Character and Number in Excel Khmer<iframe allowfullscreen="" frameborder="0" height="315" id="bigframe" src="https://www.youtube.com/embed/SO5nUWkFadg" width="100%"></iframe>
<b>30. How to Sort Data base on Character and Number in Excel Khmer</b><br>
(របៀបតម្រៀបទិនន្នយតាមអក្សរ និងលេខ) If you have lot of data in Excel, <b>SORT</b> can help you find data quickly by name or number order. In this Excel tutorial show you step by step with SORT.<br>
<br>
<b>Download Full PDF and Excel Example Files: <a href="https://bit.ly/3b6SBxf" target="_blank">Click Here</a>
<br>
Register My Special Course: <a href="https://bit.ly/101ExcelFormulasKH" target="_blank">វគ្គ ១០១ រូបមន្ត Excel</a></b>
<br>
<br>
<b> Download Example Excel File below</b><br />
<a href="https://app.box.com/s/ajbg7w50b96yqv5f8w0hetepwod1ruvp" target="_blank">Download Souce 1</a><br>
<a href="https://mega.nz/file/u1kiTCRT#V-iMzHgEWt55c7TW6S8joOxs6qhET12M1USmH_usvcY" target="_blank">Download Souce 2</a>
<br><br>
<button class="btn"><a href="https://bit.ly/3mODVp4" target="_blank">Start </a><i class="fa fa-home"></i></button>
<button class="btn"><a href="https://bit.ly/3b7dhFf" target="_blank">Previous Video </a><i class="fa fa-arrow-circle-left"></i></button>
<button class="btn"><i class="fa fa-arrow-circle-right"></i>
<a href="https://bit.ly/3xIfZsB" target="_blank">Next Video</a></button>
Hannhttp://www.blogger.com/profile/13176110046706075521noreply@blogger.com0tag:blogger.com,1999:blog-174235025827109752.post-78198379129595852712022-06-20T14:03:00.009+07:002022-06-20T14:20:32.568+07:0029. How to use SUMIF formula in Excel speak Khmer<iframe allowfullscreen="" frameborder="0" height="315" id="bigframe" src="https://www.youtube.com/embed/imhoHNEMdR0" width="100%"></iframe>
<b>29. How to use SUMIF formula in Excel speak Khmer</b><br>
If you want find total value base on certain condition, you can use SUMIF. SUMIF help you to calculate sum of value with criteria like "Male", Date, any value.<br><br>
<b>SUMIF Formula</b>
<div class="formula"> =SUMIF(Range, Criteria, [sum_range])<br></div>
◾ Range: Required, set of value or cells<br />
◾ Criteria: Required, sum base on condition<br />
◾ [sum_range]: optional, range to sum<br />
<div class="separator" style="clear: both;"><img alt="" border="0" data-original-height="2134" data-original-width="3793" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEZgrXLxQTDt3DRQ-Rg5GQihP2aph0vDTrZwBoYsT1D9MQM8PvTzzl83heR7PdfEA-1yVpt_ob-aIXLGvHEFSmUrGkbv5mr6OfyXcXpil41fUfs_DoYgbF1_vrejEaPljojusSa1KXWk4G8wjf2eCUKLHx0EZ-6aa-8iJh11rR10fas_OpV88QYleKHA/s1600/%E1%9E%9A%E1%9F%80%E1%9E%93%20Excel%20Khmer%20-%20SUMIF%20formula%20in%20Excel%20speak%20Khmer.jpg"/></div>
<br>
<b>Download Full PDF and Excel Example Files: <a href="https://bit.ly/3b6SBxf" target="_blank">Click Here</a>
<br>
Register My Special Course: <a href="https://bit.ly/101ExcelFormulasKH" target="_blank">វគ្គ ១០១ រូបមន្ត Excel</a></b>
<br>
<br>
<button class="btn"><a href="https://bit.ly/3mODVp4" target="_blank">Start </a><i class="fa fa-home"></i></button>
<button class="btn"><a href="https://bit.ly/3N2ct1D" target="_blank">Previous Video </a><i class="fa fa-arrow-circle-left"></i></button>
<button class="btn"><i class="fa fa-arrow-circle-right"></i>
<a href="https://bit.ly/3b0Urzt" target="_blank">Next Video</a></button>Hannhttp://www.blogger.com/profile/13176110046706075521noreply@blogger.com0tag:blogger.com,1999:blog-174235025827109752.post-42826280805573909932022-06-20T13:51:00.003+07:002022-06-20T14:04:53.887+07:0028. How to Calculate Grade (A, B, C,..) in Excel speak Khmer<iframe allowfullscreen="" frameborder="0" height="315" id="bigframe" src="https://www.youtube.com/embed/5MwsrDOMhq4" width="100%"></iframe>
<b>28. Calculate Grade (A, B, C,..) in Excel speak Khmer</b><br>
(រូបមន្ត IF ក្នុង IF គណនាចំណាត់ថ្នាក់ A, B, C,...) If you want to calculate grade in Excel, you can use IF formula to do that but it is a long sentence. This is nested IF (IF in IF).
<div class="separator" style="clear: both;"><img alt="" border="0" data-original-height="2134" data-original-width="3793" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWJHyyAaZCWnZDphu6sTyDiy2_nC4MAS9lKQqwkYPaVtdYjiYYzCYydHjltliRv6-F966fYvZoggCLvNtHztrgkTZxEMwTO_UvgrzhFdczm1fMHv1U98RaggqsVRhfQqayi6b2gEhHzXLjXdTHB3w-fTCP3Q8UVKqUz40MOJR5suPtEcnZZcNUY1pCDA/s1600/%E1%9E%9A%E1%9F%80%E1%9E%93%20Excel%20Khmer%20-%20IF%20in%20IF%20formula%20in%20Excel%20speak%20Khmer.jpg"/></div>
<br>
<b>Download Full PDF and Excel Example Files: <a href="https://bit.ly/3b6SBxf" target="_blank">Click Here</a>
<br>
Register My Special Course: <a href="https://bit.ly/101ExcelFormulasKH" target="_blank">វគ្គ ១០១ រូបមន្ត Excel</a></b>
<br>
<br>
<button class="btn"><a href="https://bit.ly/3mODVp4" target="_blank">Start </a><i class="fa fa-home"></i></button>
<button class="btn"><a href="https://bit.ly/3QynzOL" target="_blank">Previous Video </a><i class="fa fa-arrow-circle-left"></i></button>
<button class="btn"><i class="fa fa-arrow-circle-right"></i>
<a href="https://bit.ly/3b7dhFf" target="_blank">Next Video</a></button>
Hannhttp://www.blogger.com/profile/13176110046706075521noreply@blogger.com0tag:blogger.com,1999:blog-174235025827109752.post-23161381050908670892022-06-20T09:55:00.004+07:002022-06-20T13:51:59.524+07:0027. How to use RANK formula in Excel speak Khmer<iframe allowfullscreen="" frameborder="0" height="315" id="bigframe" src="https://www.youtube.com/embed/iXYGlyZ7krI" width="100%"></iframe>
<b>27. How to use RANK formula in Excel speak Khmer</b><br>
If you want to find number 1,2,3,... then Rank could help you but it comes with some tricks if you don't understand the concept. Please refer to the video for more information.
<b>RANK Formula</b>
<div class="formula"> =RANK(Number,Ref,[order])<br>
=Average(start_cell:end_cell)</div>
◾ Number: Required, total or average value to find rank<br />
◾ Ref: Required,set of range or cells to compare with number.<br />
◾ [order]: optional<br />
<div class="separator" style="clear: both;"><img alt="" border="0" data-original-height="2134" data-original-width="3793" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgL4U-HmsxnmDRHlBVacPfa0s4Ii0GXnc1C3x-7lKNocv1dnsT1JzbtokehoAxb01NEYBIklPHEvxXaT9Vsd9o0xitwXWnXkWEaKCe_8QZVBrMHbHO8a98RIvX6i02PufvLKvWp2KDl90xoT4Cjr42vzS0J-Yyo7R_tdcQeA01CCJXCUTIBOjhH_cFYww/s1600/%E1%9E%9A%E1%9F%80%E1%9E%93%20Excel%20Khmer%20-%20Rank%20formula%20in%20Excel%20speak%20Khmer.jpg"/></div>
<br>
<b>Download Full PDF and Excel Example Files: <a href="https://bit.ly/3b6SBxf" target="_blank">Click Here</a>
<br>
Register My Special Course: <a href="https://bit.ly/101ExcelFormulasKH" target="_blank">វគ្គ ១០១ រូបមន្ត Excel</a></b>
<br>
<br>
<button class="btn"><a href="https://bit.ly/3mODVp4" target="_blank">Start </a><i class="fa fa-home"></i></button>
<button class="btn"><a href="https://bit.ly/3xDmuwK" target="_blank">Previous Video </a><i class="fa fa-arrow-circle-left"></i></button>
<button class="btn"><i class="fa fa-arrow-circle-right"></i>
<a href="https://bit.ly/3N2ct1D" target="_blank">Next Video</a></button>
Hannhttp://www.blogger.com/profile/13176110046706075521noreply@blogger.com0tag:blogger.com,1999:blog-174235025827109752.post-22332779660471710112022-06-20T08:59:00.004+07:002022-06-20T09:56:39.610+07:0026. How to use COUNTIF formula in Excel Khmer<iframe allowfullscreen="" frameborder="0" height="315" id="bigframe" src="https://www.youtube.com/embed/wOKfjOGgCFE" width="100%"></iframe>
<b>26. How to use COUNTIF formula in Excel Khmer</b><br>
(រូបមន្ត CountIF) If you want to count someting with condition like "Male" or "Female", CountIF could help you to do that. <b>COUNTIF</b> take on condition and count base on Condition that match.
<b>COUNTIT Formula</b>
<div class="formula"> =COUNTIT(Range, Condition)<br></div>
◾ Range: Required, set of cells or values <br />
◾ Condition: Required, count value that match with condition<br />
<div class="separator" style="clear: both;"><img alt="" border="0" data-original-height="2134" data-original-width="3793" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghOQ1Ax6q6r1o-4vCdEBfo3DGt-L5qWjqVrkCi0ZUMDPrWmr1cSghdg37FMA8_dxiqhQZqqvmAJAey-5CuZkejK4HvXvggCpkrODZrD6w680YJiQsIeM3FJTER-fqDwOuBiqEK5QLqnRGWqH58T0XbnEXMSkbSyVQX14uGQ9t-92XiU0e0aHOIFgevXw/s1600/%E1%9E%9A%E1%9F%80%E1%9E%93%20Excel%20Khmer%20-%20CountIF%20formula%20in%20Excel%20speak%20Khmer.jpg"/></div>
<br>
<b>Download Full PDF and Excel Example Files: <a href="https://bit.ly/3b6SBxf" target="_blank">Click Here</a>
<br>
Register My Special Course: <a href="https://bit.ly/101ExcelFormulasKH" target="_blank">វគ្គ ១០១ រូបមន្ត Excel</a></b>
<br>
<br>
<button class="btn"><a href="https://bit.ly/3mODVp4" target="_blank">Start </a><i class="fa fa-home"></i></button>
<button class="btn"><a href="https://bit.ly/3tHsHXh" target="_blank">Previous Video </a><i class="fa fa-arrow-circle-left"></i></button>
<button class="btn"><i class="fa fa-arrow-circle-right"></i>
<a href="https://bit.ly/3QynzOL" target="_blank">Next Video</a></button>Hannhttp://www.blogger.com/profile/13176110046706075521noreply@blogger.com0tag:blogger.com,1999:blog-174235025827109752.post-69296958719324550272022-06-20T08:44:00.001+07:002022-06-20T09:00:16.679+07:0025. How to use IF formula in Excel speak Khmer<iframe allowfullscreen="" frameborder="0" height="315" id="bigframe" src="https://www.youtube.com/embed/hWhbZEg03mo" width="100%"></iframe>
<b>25. How to use IF formula in Excel speak Khmer</b><br>
If formula is working base on condition, If the condition is True, then do something (True Part), if not do something else instead (Fail Part).
<b>IF Formula: </b>
<div class="formula"> =IF(Something is True, then do something, otherwise do something else)<br>
</div>
<div class="separator" style="clear: both;"><img alt="" border="0" data-original-height="2134" data-original-width="3793" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjej67M7oPI0GqDdSaRki1wgqroqYM3su4bQ08j4rCe4qN4MRsqacIyAUnsrlYkNLE3oSRXnev495XYe7Mklb3hmRpt_fNVjs5pM5jYLtrDRtcKK5XYCDSmiVtYlyFsdD1jAMkbk-UNDhyDbJykTkxNSpN0mbRYzARwc36kvYEiHa0abchk2AgJP7dz5A/s1600/%E1%9E%9A%E1%9F%80%E1%9E%93%20Excel%20Khmer%20-%20IF%20formula%20in%20Excel%20speak%20Khmer.jpg"/></div>
<b>How to use Comparision Condition in Excel</b>
<div class="separator" style="clear: both;"><img alt="" border="0" data-original-height="2134" data-original-width="3793" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg175Snl0iq3jxrH9JRKBCk9iskTzqLdlNZTC0lLOfARxqk-2tW7erEY01Y7m1dD2gkJLSlvmItBn8wpYxWOVj_47vbDYXU3cOITbcabi5PrywP5wKA-M6tdpQnAvoawFEA6N8LUWuzngeKhBm21NvU9s3x9qVU4zJ5GR_c5OOsCe21dGnZNP9OG5yBpA/s1600/%E1%9E%9A%E1%9F%80%E1%9E%93%20Excel%20Khmer%20-%20IF%20condition%20in%20Excel%20speak%20Khmer.jpg"/></div>
<br>
<b>Download Full PDF and Excel Example Files: <a href="https://bit.ly/3b6SBxf" target="_blank">Click Here</a>
<br>
Register My Special Course: <a href="https://bit.ly/101ExcelFormulasKH" target="_blank">វគ្គ ១០១ រូបមន្ត Excel</a></b>
<br>
<br>
<button class="btn"><a href="https://bit.ly/3mODVp4" target="_blank">Start </a><i class="fa fa-home"></i></button>
<button class="btn"><a href="https://bit.ly/39BiQeN" target="_blank">Previous Video </a><i class="fa fa-arrow-circle-left"></i></button>
<button class="btn"><i class="fa fa-arrow-circle-right"></i>
<a href="https://bit.ly/3xDmuwK" target="_blank">Next Video</a></button>
Hannhttp://www.blogger.com/profile/13176110046706075521noreply@blogger.com0tag:blogger.com,1999:blog-174235025827109752.post-85947104336215824472022-06-20T08:31:00.002+07:002022-06-20T08:45:04.700+07:0024. How to Keep the Row on the Top in Excel speak Khmer<iframe allowfullscreen="" frameborder="0" height="315" id="bigframe" src="https://www.youtube.com/embed/jhZcnJ3pGrg" width="100%"></iframe>
<b>24. How to Keep the Row on the Top in Excel speak Khmer</b><br>
(របៀបកំណត់ឲ្យជួរទីមួយនៅលើរហូត) If you have lot of rows and columns of data in Excel, then when you scroll down the top row will disappear or scroll to the right but don't see the name or id of the data. Luckily Freezing Panes can help you to keep row header on the top or some column stay still when scrolling.
<div class="separator" style="clear: both;"><img alt="" border="0" data-original-height="431" data-original-width="1009" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgR8ZFdiAl9EPtT4-FpghIexuus1rYK8EoYQYzDx4J2TkJv8gML6L3tERtB6bkrOvPQXCGGozmzIeUokCa1swoyH4kAAU2x-QR0Z1Fswd7m0wk29Jrv47U7tt3OWmnTxN9IbFTc8CB1DcZvrmpGwgMjq23m14wiXu9RuCRJv5BWLDHHI6HDgKxAXzmCDQ/s1600/freezing%20pan%20in%20excel.png"/></div>
<br>
<b>Download Full PDF and Excel Example Files: <a href="https://bit.ly/3b6SBxf" target="_blank">Click Here</a>
<br>
Register My Special Course: <a href="https://bit.ly/101ExcelFormulasKH" target="_blank">វគ្គ ១០១ រូបមន្ត Excel</a></b>
<br>
<br>
<button class="btn"><a href="https://bit.ly/3mODVp4" target="_blank">Start </a><i class="fa fa-home"></i></button>
<button class="btn"><a href="https://bit.ly/3QAZbwi" target="_blank">Previous Video </a><i class="fa fa-arrow-circle-left"></i></button>
<button class="btn"><i class="fa fa-arrow-circle-right"></i>
<a href="https://bit.ly/3tHsHXh" target="_blank">Next Video</a></button>Hannhttp://www.blogger.com/profile/13176110046706075521noreply@blogger.com0tag:blogger.com,1999:blog-174235025827109752.post-2792863169664897382022-06-19T18:23:00.003+07:002022-06-20T08:31:38.723+07:0023. How to Connect Value together in Excel speak Khmer<iframe allowfullscreen="" frameborder="0" height="315" id="bigframe" src="https://www.youtube.com/embed/HDp1OS_LZmA" width="100%"></iframe>
<b>23. How to Connect Value together in Excel speak Khmer</b><br>
(រូបមន្ត Concatenate និង របៀបតភ្ជាប់ទិន្នន័យតាមឈ្នាប់ &)<br><br>
This Excel tutorial in Khmer show three method to connect text together. <b>Concatenate (old version) or Concat (Excel 2019 UP)</b> are use to connect text or value together but you can try other method just using <b>ampersand</b> (&) sign.<br>
<b>Concatenate Formula</b>
<div class="formula"> =Concatenate(Text1,[Text2],...)<br>
=Concat(Text1,[Text2],...)</div>
◾ Text1: Required, value to calculate, (Text1,...,Text255)<br />
<div class="separator" style="clear: both;"><img alt="" border="0" data-original-height="2134" data-original-width="3793" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgN9cJz0POxtuAznxgL9rRfaoGGj-8BR-NKxiYHEeO4GJLAbUNbU_9cfkOdcszFNsUf5NwivHyaS2neFCHMO3QaFkLHkrRZoi-q_1c0XWZ1dIr3O0VdoRs_zpi0dHGAxQ6KyiMNl1jqEyrQ7kP-ukX8Jl18OeejIJUuPK5u5bgH-5xb75wqM-oIKgWV1Q/s1600/%E1%9E%9A%E1%9F%80%E1%9E%93%20Excel%20Khmer%20-%20Concat%20formula%20in%20Excel%20speak%20Khmer%20%282%29.jpg"/></div>
<div class="separator" style="clear: both;"><img alt="" border="0" data-original-height="2134" data-original-width="3793" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfeR47QekESJnTY-ru5PfDlN0xax2iYr1ib_Snw8X9cXjdFvSSMM712VpaKnvZCi2IFyucOPPuCJTWt5cOxu1AmRiZtc5h34EJwr0zHLLYeQICrKUrfkotNrNUi1JiBxhEdXnV01ezuc7yK-gT5WggSZtxTqkL8lv8rCri5rNbCpWP-PYUK4lOkHPsrA/s1600/%E1%9E%9A%E1%9F%80%E1%9E%93%20Excel%20Khmer%20-%20Concat%20formula%20in%20Excel%20speak%20Khmer%20%281%29.jpg"/></div>
<br>
<b>Download Full PDF and Excel Example Files: <a href="https://bit.ly/3b6SBxf" target="_blank">Click Here</a>
<br>
Register My Special Course: <a href="https://bit.ly/101ExcelFormulasKH" target="_blank">វគ្គ ១០១ រូបមន្ត Excel</a></b>
<br>
<br>
<button class="btn"><a href="https://bit.ly/3mODVp4" target="_blank">Start </a><i class="fa fa-home"></i></button>
<button class="btn"><a href="https://bit.ly/3tNejN3" target="_blank">Previous Video </a><i class="fa fa-arrow-circle-left"></i></button>
<button class="btn"><i class="fa fa-arrow-circle-right"></i>
<a href="https://bit.ly/39BiQeN" target="_blank">Next Video</a></button>Hannhttp://www.blogger.com/profile/13176110046706075521noreply@blogger.com0tag:blogger.com,1999:blog-174235025827109752.post-57177928166129493472022-06-19T18:05:00.009+07:002022-06-19T18:25:30.955+07:0022. How to use CountA in Excel speak Khmer<iframe allowfullscreen="" frameborder="0" height="315" id="bigframe" src="https://www.youtube.com/embed/O16RZ9zo1Ow" width="100%"></iframe>
<b>22. How to use CountA in Excel speak Khmer</b><br>
If You want to count both text, number or even date, count is used. Basicially, CountA can count any input value include "Space" value.<br>
<b>CountA Formula: Count all value of selected cells</b>
<div class="formula"> =CountA(Number1,[Number2],...)<br>
=CountA(start_cell:end_cell)</div>
◾ Number1: Required, value to count, (number1,...,number255)<br />
◾ start_cell: Required, start value to count.<br />
◾ end_cell: Required, end value to count.<br />
<div class="separator" style="clear: both;"><img alt="" border="0" data-original-height="2134" data-original-width="3793" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqiLVZUMC0FwqsQeY3285KuAZq1ocCGK2GMo33k7T2JXT0lovwq3Xr45a3Rl-cKUPd14Qf3uinTNo0NTySABLQnC1lihcawUe5CnQbCmSlQsVA5OKwbXOahHg0dZCUMPmsjmLHX2o0hjO-BmUGgtww9Dl_1v61VqeGrHUUS0WLtrXTYbzkjstkfoQW5w/s1600/%E1%9E%9A%E1%9F%80%E1%9E%93%20Excel%20Khmer%20-%20CountA%20formula%20in%20Excel%20speak%20Khmer.jpg"/></div>
<br>
<b>Download Full PDF and Excel Example Files: <a href="https://bit.ly/3b6SBxf" target="_blank">Click Here</a>
<br>
Register My Special Course: <a href="https://bit.ly/101ExcelFormulasKH" target="_blank">វគ្គ ១០១ រូបមន្ត Excel</a></b>
<br>
<br>
<button class="btn"><a href="https://bit.ly/3mODVp4" target="_blank">Start </a><i class="fa fa-home"></i></button>
<button class="btn"><a href="https://bit.ly/3xDdpEb" target="_blank">Previous Video </a><i class="fa fa-arrow-circle-left"></i></button>
<button class="btn"><i class="fa fa-arrow-circle-right"></i>
<a href="https://bit.ly/3QAZbwi" target="_blank">Next Video</a></button>
Hannhttp://www.blogger.com/profile/13176110046706075521noreply@blogger.com0tag:blogger.com,1999:blog-174235025827109752.post-24114880410444105332022-06-19T17:47:00.004+07:002022-06-19T18:10:53.461+07:0021. How to use Count Formula in Excel speak Khmer<iframe allowfullscreen="" frameborder="0" height="315" id="bigframe" src="https://www.youtube.com/embed/YxzWmM_I7bU" width="100%"></iframe>
<b>21. How to use Count Formula in Excel speak Khmer</b><br>
This Excel tutorial in Khmer show how to use Count Formula to count only value from range of cells. <i><b>Note: Text or other value not count, count only number value</b>.
</i>
<b>Count Formula: Count only number as value of selected cells</b>
<div class="formula"> =Count(Number1,[Number2],...)<br>
=Count(start_cell:end_cell)</div>
◾ Number1: Required, value to count, (number1,...,number255)<br />
◾ start_cell: Required, start value to count.<br />
◾ end_cell: Required, end value to count.<br />
<div class="separator" style="clear: both;"><img alt="" border="0" data-original-height="2134" data-original-width="3793" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh9wlD8w-EAKCDzld4E3On0TsE5jgnlOB4obrBNQyY0J8mwSzTFM41_trIkrO7vPN4BiYtSOKw3KOzmceMUv1mLumebUaB2Fy4GoDnmn_aOL3z8AwUbeMflgNBwBkbe2HCMroimv7A_cY49lxbbOGUJGXX8FQ2B6RAipFC5H0gYmLz2I5hmsl8MywKCVw/s1600/%E1%9E%9A%E1%9F%80%E1%9E%93%20Excel%20Khmer%20-%20Count%20formula%20in%20Excel%20speak%20Khmer.jpg"/></div>
<br><br>
<b>Download Full PDF and Excel Example Files: <a href="https://bit.ly/3b6SBxf" target="_blank">Click Here</a></b>
<br><br>
<b> Register My Special Course:<a href="https://bit.ly/101ExcelFormulasKH" target="_blank">វគ្គ ១០១ រូបមន្ត Excel</a><br>
<br>
<button class="btn"><a href="https://bit.ly/3mODVp4" target="_blank">Start </a><i class="fa fa-home"></i></button>
<button class="btn"><a href="https://bit.ly/3zNPWCY" target="_blank">Previous Video </a><i class="fa fa-arrow-circle-left"></i></button>
<button class="btn"><i class="fa fa-arrow-circle-right"></i>
<a href="https://bit.ly/3tNejN3" target="_blank">Next Video</a></button>
Hannhttp://www.blogger.com/profile/13176110046706075521noreply@blogger.com0tag:blogger.com,1999:blog-174235025827109752.post-38735097005977194072022-06-18T17:53:00.004+07:002022-06-19T18:02:08.185+07:0020. How to use Worksheet in Excel speak Khmer<iframe allowfullscreen="" frameborder="0" height="315" id="bigframe" src="https://www.youtube.com/embed/P6AleZKLfFk" width="100%"></iframe>
<b>20. How to use Worksheet in Excel speak Khmer</b><br>
<b>Worksheet</b> known as <b>Sheet</b> in Microsoft Excel. In Excel contains many sheets as you may need to hold your input data like <b>text, number, date and time</b>. <b>Sheet</b> helps to separate your data base on categories or type of data.
<br>
<div class="separator" style="clear: both;"><img alt="" border="0" data-original-height="549" data-original-width="1176" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggDTgIGVJHdygELUV2KJgRmg2E0DvOC4AlZS_BniHHWymdkuJ_e5o2a1HjoUOYeijUBzkETXr6FmBklpDJdxSCCusqTxY4eHNYkdDrpjgUgqR73yuBz0jTsi5akIHNO8vuRtz64tsZLiUPStUN8ySIKtZD1CCgKB3kMiX0HUNmdiOesTWxxpM-tZaVAA/s1600/worksheet%20in%20excel%20khmer.png"/></div>
<br>
<b>Download Full PDF and Excel Example Files: <a href="https://bit.ly/3b6SBxf" target="_blank">Click Here</a></b>
<br><br>
<b> Register My Special Course:<a href="https://bit.ly/101ExcelFormulasKH" target="_blank">វគ្គ ១០១ រូបមន្ត Excel</a><br>
<br>
<button class="btn"><a href="https://bit.ly/3mODVp4" target="_blank">Start </a><i class="fa fa-home"></i></button>
<button class="btn"><a href="https://bit.ly/39BYwde" target="_blank">Previous Video </a><i class="fa fa-arrow-circle-left"></i></button>
<button class="btn"><i class="fa fa-arrow-circle-right"></i>
<a href="https://bit.ly/3xDdpEb" target="_blank">Next Video</a></button>
Hannhttp://www.blogger.com/profile/13176110046706075521noreply@blogger.com0tag:blogger.com,1999:blog-174235025827109752.post-48916474616135419492022-06-18T17:42:00.006+07:002022-06-19T18:02:22.470+07:0019. Working with TEXT and other format in Excel speak Khmer<iframe allowfullscreen="" frameborder="0" height="315" id="bigframe" src="https://www.youtube.com/embed/YlYcZZGQ_lo" width="100%"></iframe>
<b>19. Working with TEXT and other format in Excel speak Khmer</b><br>
(ស្គាល់ពីប្រភេទទិន្នន័យ Text and Other Format)<br>
In this Excel tutorial in Khmer explained step by step how to working with Text format and other format in Microsoft Excel. Knowing how to format your Excel data is really important to make your data look better and easy to understand.
<br>
<div class="separator" style="clear: both;"><img alt="" border="0" data-original-height="452" data-original-width="845" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEioJKMWvBK6h-cQVSq5lLyB9wtgPa73fmp8i1t9CtXzzz3ym9mLJS3nwh-Q2JpirNLlzP30eSORtBlzL8gEORrYG-JN_9aeeuYNi3fglWStspMxVONA5yAC0O6cLKspgXVGj9VzfxDx7MAZPY5hVT1zZTkmfUfF8C3mRj4viiVeEFvmRiJG3-zUYJ2VUA/s1600/text%20and%20other%20format%20in%20excel%20khmer.png"/></div>
<br>
<b>Download Full PDF and Excel Example Files: <a href="https://bit.ly/3b6SBxf" target="_blank">Click Here</a></b>
<br><br>
<b> Register My Special Course:<a href="https://bit.ly/101ExcelFormulasKH" target="_blank">វគ្គ ១០១ រូបមន្ត Excel</a><br>
<br>
<button class="btn"><a href="https://bit.ly/3mODVp4" target="_blank">Start </a><i class="fa fa-home"></i></button>
<button class="btn"><a href="https://bit.ly/3zMYGcu" target="_blank">Previous Video </a><i class="fa fa-arrow-circle-left"></i></button>
<button class="btn"><i class="fa fa-arrow-circle-right"></i>
<a href="https://bit.ly/3zNPWCY" target="_blank">Next Video</a></button>Hannhttp://www.blogger.com/profile/13176110046706075521noreply@blogger.com0tag:blogger.com,1999:blog-174235025827109752.post-67425179817632965022022-06-18T17:25:00.006+07:002022-06-19T18:02:28.969+07:0018. Working with DATE and TIME in Excel speak Khmer<iframe allowfullscreen="" frameborder="0" height="315" id="bigframe" src="https://www.youtube.com/embed/p6Sh82UhsQ0" width="100%"></iframe>
<b>18. Working with DATE and TIME in Excel speak Khmer</b><br>
(ស្គាល់ពីប្រភេទទិន្នន័យ និង របៀបវាយបញ្ចូល Date and Time)<br>
Date and Time in Excel is very important to salary and age calculation. Knowing how to input date and time format is the KEY for data accuracy.
<pre>
- Date input format: MM/DD/YY or MM-DD-YY and you can change the display as you want in custom format.
- Time input format: HH:MM:SS AM/PM you can change the display in custom format.
</pre>
<div class="separator" style="clear: both;"><img alt="" border="0" data-original-height="512" data-original-width="557" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEicIbJagrcCPYiggjmUHRa64iKejfPYbfoTJcooSEkC6K383VCzYLfO3A68AJ2TF705FdsLIQSetHhx5bgHCxqJOoXlcr1YkZ0uRyuO2lj1c3SktPP4zTv5mm_HdMUWLZ1U_EUtbnwIjr1OgCSDCxW6HhiCMugD16GiKQEh41MdPif9XWJCyuGvAbpR8Q/s1600/date%20time%20formula%20in%20excel%20khmer.png"/></div>
<br>
<b>Download Full PDF and Excel Example Files: <a href="https://bit.ly/3b6SBxf" target="_blank">Click Here</a></b>
<br><br>
<b> Register My Special Course:<a href="https://bit.ly/101ExcelFormulasKH" target="_blank">វគ្គ ១០១ រូបមន្ត Excel</a><br>
<br>
<button class="btn"><a href="https://bit.ly/3mODVp4" target="_blank">Start </a><i class="fa fa-home"></i></button>
<button class="btn"><a href="https://bit.ly/3tKIXXl" target="_blank">Previous Video </a><i class="fa fa-arrow-circle-left"></i></button>
<button class="btn"><i class="fa fa-arrow-circle-right"></i>
<a href="https://bit.ly/39BYwde" target="_blank">Next Video</a></button>
Hannhttp://www.blogger.com/profile/13176110046706075521noreply@blogger.com0