{"id":8484,"date":"2024-12-22T14:42:41","date_gmt":"2024-12-22T14:42:41","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/chen-va-su-dung-ky-tu-dac-biet-trong-excel\/"},"modified":"2024-12-22T14:42:41","modified_gmt":"2024-12-22T14:42:41","slug":"chen-va-su-dung-ky-tu-dac-biet-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/chen-va-su-dung-ky-tu-dac-biet-trong-excel\/","title":{"rendered":"Ch\u00e8n v\u00e0 s\u1eed d\u1ee5ng k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6768255fe9928\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/chen-va-su-dung-ky-tu-dac-biet-trong-excel.html#%E2%99%A5_Chen_ky_tu_dac_biet_trong_Excel_%E2%99%A5\" title=\"\u2665 Ch\u00e8n k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t trong Excel \u2665\">\u2665 Ch\u00e8n k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t trong Excel \u2665<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/chen-va-su-dung-ky-tu-dac-biet-trong-excel.html#I_Dung_hop_thoai_Symbol\" title=\"I. D\u00f9ng h\u1ed9p tho\u1ea1i Symbol.\">I. D\u00f9ng h\u1ed9p tho\u1ea1i Symbol.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/chen-va-su-dung-ky-tu-dac-biet-trong-excel.html#II_Dung_Character_Map_cua_Win\" title=\"II. D\u00f9ng Character Map c\u1ee7a Win.\">II. D\u00f9ng Character Map c\u1ee7a Win.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/chen-va-su-dung-ky-tu-dac-biet-trong-excel.html#III_AltCode\" title=\"III. Alt+Code.\">III. Alt+Code.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/chen-va-su-dung-ky-tu-dac-biet-trong-excel.html#IV_Copy_and_Paste\" title=\"IV. Copy and Paste.\">IV. Copy and Paste.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/chen-va-su-dung-ky-tu-dac-biet-trong-excel.html#V_Su_dung_ky_tu_dac_biet\" title=\"V. S\u1eed d\u1ee5ng k\u00fd t\u1ef1 \u0111\u1eb7c bi\u00eat.\">V. S\u1eed d\u1ee5ng k\u00fd t\u1ef1 \u0111\u1eb7c bi\u00eat.<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"%E2%99%A5_Chen_ky_tu_dac_biet_trong_Excel_%E2%99%A5\"><\/span><strong>\u2665 Ch\u00e8n k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t trong Excel \u2665<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: left\">B\u1ea1n mu\u1ed1n file c\u1ee7a m\u00ecnh \u0111\u1eb7c bi\u1ec7t? C\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t l\u00e0 ch\u00e8n v\u00e0i k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t, file c\u1ee7a b\u1ea1n s\u1ebd \u0111\u1eb7c bi\u1ec7t ngay. Tuy v\u1eady kh\u00f4ng \u00edt l\u1ea7n b\u1ea1n m\u1ecfi m\u1eaft \u0111\u1ec3 t\u00ecm k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t, hay nh\u1eefng l\u1ea7n \u0111\u1ecbnh d\u1ea1ng l\u1ea1i text, th\u00ec c\u00e1c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t m\u1ea5t ti\u00eau. \u0110\u00f3 l\u00e0 do b\u1ea1n ch\u01b0a c\u00f3 ph\u01b0\u01a1ng ph\u00e1p.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-801 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/10_10_2016_07_25_18_0.png\" alt=\"10_10_2016_07_25_18_0\" width=\"983\" height=\"324\" title=\"10_10_2016_07_25_18_0\"><\/p>\n<p>V\u1ec1 c\u01a1 b\u1ea3n, m\u1ed9t k\u00fd t\u1ef1 hi\u1ec3n th\u1ecb tr\u00ean m\u00e0n h\u00ecnh, hay tr\u00ean gi\u1ea5y ph\u1ee5 thu\u1ed9c c\u01a1 b\u1ea3n v\u00e0o hai th\u1ee9:<br \/>\n<strong>M\u00e3 k\u00fd t\u1ef1 ( code):<\/strong><\/p>\n<ul>\n<li>K\u00fd t\u1ef1 a c\u00f3 m\u00e3 ( code) l\u00e0 97.<\/li>\n<li>K\u00fd t\u1ef1 A c\u00f3 m\u00e3 ( code) l\u00e0 64.<\/li>\n<li>K\u00fd t\u1ef1 b c\u00f3 m\u00e3 l\u00e0 98.<\/li>\n<\/ul>\n<p>Tr\u00ean m\u00e0n h\u00ecnh, a, A, b nh\u00ecn kh\u00e1c nhau h\u1eb3n.<\/p>\n<p><strong>Font g\u00e1n cho k\u00fd t\u1ef1<\/strong><\/p>\n<ul>\n<li>Ch\u1eef A khi g\u00e1n font l\u00e0 Time New Roman: A.<\/li>\n<li>Ch\u1eef A khi g\u00e1n font l\u00e0 Arial back: <strong>A<\/strong>.<\/li>\n<li>C\u00f9ng m\u1ed9t k\u00fd t\u1ef1, nh\u01b0ng tr\u00f4ng l\u1ea1i kh\u00e1c nhau.<\/li>\n<\/ul>\n<p>Ch\u00ednh v\u1eady m\u00e0 vi\u1ec7c ch\u00e8n k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t c\u0169ng ph\u1ea3i quan t\u00e2m \u0111\u1ebfn code v\u00e0 font. Kinh nghi\u1ec7m cho th\u1ea5y n\u00ean ch\u1ecdn font tr\u00f9ng v\u1edbi font b\u1ea1n \u0111ang d\u00f9ng tr\u1eeb tr\u01b0\u1eddng h\u1ee3p \u0111\u1eb7c bi\u1ec7t. C\u00f3 4 c\u00e1ch \u0111\u1ec3 ch\u00e8n k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t:<\/p>\n<ul>\n<li>D\u00f9ng h\u1ed9p tho\u1ea1i Symbol.<\/li>\n<li>D\u00f9ng Character Map c\u1ee7a Win.<\/li>\n<li>Alt+Code.<\/li>\n<li>Copy and Paste<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"I_Dung_hop_thoai_Symbol\"><\/span>I. D\u00f9ng h\u1ed9p tho\u1ea1i Symbol.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00e1ch l\u00e0m:<br \/>\n+ B\u1ecf chu\u1ed9t v\u00e0o v\u1ecb tr\u00ed mu\u1ed1n ch\u00e8n.<br \/>\n+ Insert-&gt;Text-&gt;Symbol.<br \/>\n+ Ch\u1ecdn font tr\u00f9ng v\u1edbi font \u0111ang d\u00f9ng. <strong>(1)<\/strong><br \/>\n+ D\u00f9ng chu\u1ed9t t\u00ecm k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t <strong>(2)<\/strong> ho\u1eb7c nh\u1eadp code n\u1ebfu bi\u1ebft <strong>(3)<\/strong>, k\u00fd t\u1ef1 \u2640.<br \/>\n+ Double click v\u00e0o k\u00fd t\u1ef1 ho\u1eb7c click Insert \u0111\u1ec3 ch\u00e8n.<strong>(4)<\/strong><br \/>\nK\u1ebft qu\u1ea3:<br \/>\n+ Excel ch\u00e8n k\u00fd t\u1ef1 v\u1edbi code \u0111\u00e3 ch\u1ecdn. \u2640, code:<strong> 2640<\/strong>hex -&gt;<strong>9792<\/strong> dec.<br \/>\n+ \u0110\u1ecbnh d\u1ea1ng k\u00fd t\u1ef1 \u1ea5y theo font \u0111\u00e3 ch\u1ecdn.<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-780.gif\" title=\"ex101_92019-nho-780\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-784 size-large aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/nhapkytudacbiet-time-0_01_4522____-1024x576-1.png\" alt=\"nhapkytudacbiet-time-0_01_4522____\" width=\"1024\" height=\"576\" title=\"nhapkytudacbiet-time-0_01_4522____-1024x576-1\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"II_Dung_Character_Map_cua_Win\"><\/span>II. D\u00f9ng Character Map c\u1ee7a Win.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00e1ch l\u00e0m:<br \/>\n+ Ch\u1ea1y Character Map: %SystemRoot%system32charmap.exe<br \/>\n+ Ch\u1ecdn font ch\u1eef. ( Time new Roman).<strong>(1)<\/strong><br \/>\n+ T\u00ecm k\u00fd t\u1ef1 trong danh s\u00e1ch.<strong>(2)<\/strong><br \/>\n+ Double click \u0111\u1ec3 ch\u1ecdn k\u00fd t\u1ef1, c\u00f3 th\u1ec3 double click nhi\u1ec1u l\u1ea7n \u0111\u1ec3 ch\u1ecdn nhi\u1ec1u k\u00fd t\u1ef1.<br \/>\n+ Click copy \u0111\u1ec3 copy c\u00e1c k\u00fd t\u1ef1 v\u1eeba ch\u1ecdn v\u00e0o Clipboard.<strong>(4)<\/strong><br \/>\n+ Paste v\u00e0o c\u00e1c \u1ee9ng d\u1ee5ng kh\u00e1c.<br \/>\nK\u1ebft qu\u1ea3:<br \/>\n+ K\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t n\u1eb1m trong Clipboard.<br \/>\n+ Paste c\u00e1c k\u00fd t\u1ef1 n\u00e0y v\u00e0o v\u1ecb tr\u00ed b\u1ea1n mu\u1ed1n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-785 size-large aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/nhapkytudacbiet-time-0_02_3211__-1024x576-1.png\" alt=\"nhapkytudacbiet-time-0_02_3211__\" width=\"1024\" height=\"576\" title=\"nhapkytudacbiet-time-0_02_3211__-1024x576-1\"><\/p>\n<blockquote>\n<p>Xem th\u00eam:\u00a0kh\u00f3a h\u1ecdc excel n\u00e2ng cao h\u00e0 n\u1ed9i<\/p>\n<\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"III_AltCode\"><\/span>III. Alt+Code.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>L\u00e0m theo hai c\u00e1ch tr\u00ean, b\u1ea1n \u0111\u00e3 c\u00f3 code c\u1ee7a k\u00fd t\u1ef1, thay v\u00ec ph\u1ea3i b\u1eadt h\u1ed9p tho\u1ea1i Sysbol l\u1ea1i c\u00f3 th\u1ec3 l\u00e0m nh\u01b0 sau:<br \/>\n+ \u0110\u1eb7t chu\u1ed9t v\u00e0o v\u1ecb tr\u00ed mu\u1ed1n ch\u00e8n k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t.<br \/>\n+ Nh\u1ea5n ph\u00edm ALT.<br \/>\n+ G\u00f5 code c\u1ee7a k\u00fd t\u1ef1 tr\u00ean b\u00e0n ph\u00edm s\u1ed1.<br \/>\n+ Nh\u1ea3 ph\u00edm ALT.<br \/>\n+ K\u00fd t\u1ef1 s\u1ebd xu\u1ea5t hi\u1ec7n t\u1ea1i con tr\u1ecf.<br \/>\nL\u01b0a \u00fd:<br \/>\n+ Code \u1edf \u0111\u00e2y l\u00e0 d\u1ea1ng dec. Code l\u1ea5y \u0111\u01b0\u1ee3c trong h\u1ed9p tho\u1ea1i Sysbol v\u00e0 Character Map c\u00f3 th\u1ec3 l\u00e0 d\u1ea1ng hex.<br \/>\n+ Trong Excel, n\u1ebfu bi\u1ebft code hex th\u00ec c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m HEX2DEC \u0111\u1ec3 t\u00ednh code dec.<br \/>\n+ Kh\u00f4ng ph\u1ea3i t\u1ea5t c\u1ea3 c\u00e1c \u1ee9ng d\u1ee5ng \u0111\u1ec1u h\u1ed7 tr\u1ee3 ki\u1ec3u n\u00e0y, Word h\u1ed7 tr\u1ee3 r\u1ea5t t\u1ed1t, Excel th\u00ec ph\u1eadt ph\u1ed3ng l\u1eafm. N\u00ean alt+code trong word r\u1ed3i copy sang excel.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-802 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/10_10_2016_07_28_49_0-1024x202-1.png\" alt=\"10_10_2016_07_28_49_0\" width=\"1024\" height=\"202\" title=\"10_10_2016_07_28_49_0-1024x202-1\"><\/p>\n<p>D\u00f9ng h\u00e0m Hex2Dec \u0111\u1ec3 chuy\u1ec3n code hex sang code dec.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-786 size-large aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/nhapkytudacbiet-time-0_03_1210__-1024x576-1.png\" alt=\"nhapkytudacbiet-time-0_03_1210__\" width=\"1024\" height=\"576\" title=\"nhapkytudacbiet-time-0_03_1210__-1024x576-1\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"IV_Copy_and_Paste\"><\/span>IV. Copy and Paste.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Theo 3 c\u00e1ch tr\u00ean b\u1ea1n \u0111\u00e3 c\u00f3 trong tay v\u00e0i k\u00fd t\u1ef1 \u0111\u1eb9p m\u1eaft, k\u1ebft h\u1ee3p google th\u00ec s\u1ebd c\u00f3 h\u00e0ng t\u00e1 nh\u01b0ng k\u00fd t\u1ef1 \u0111\u1ed9c v\u00e0 l\u1ea1. Nhi\u1ec7m v\u1ee5 c\u00f2n l\u1ea1i l\u00e0 copy and paste. N\u00f3i l\u00e0 m\u1ed9t chuy\u1ec7n, t\u00ecm ki\u1ebfm ra ch\u00fang c\u0169ng m\u1ec7t ph\u1ebft. Thay v\u00e0o \u0111\u00f3 b\u1ea1n t\u1ea3i file <a href=\"https:\/\/drive.google.com\/open?id=0B87wpzexmU0URGE2bjJCd21rYlE\">T\u1ea1i \u0111\u00e2y v\u00e0\u00a0 <\/a>,\u00a0 \u0110\u00e2y n\u1eefan\u00f3 \u0111\u00e3 t\u1ed5ng h\u1ee3p kh\u00e1 \u0111\u1ea7y \u0111\u1ee7, ch\u1ec9 vi\u1ec7c copy and paste.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-787 size-large aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/nhapkytudacbiet-time-0_04_5614__-1024x576-1.png\" alt=\"nhapkytudacbiet-time-0_04_5614__\" width=\"1024\" height=\"576\" title=\"nhapkytudacbiet-time-0_04_5614__-1024x576-1\"><\/p>\n<p><strong>L\u1ea5y k\u00fd t\u1ef1:<\/strong><br \/>\n+ M\u1edf file \u0111\u00e3 t\u1ea3i, chuy\u1ec3n qua sheet Unicode.<br \/>\n+ Ch\u1ecdn tr\u00f2n b\u1ed9 d\u1eef li\u1ec7u v\u00e0 \u0111\u1ecbnh d\u1ea1ng v\u1ec1 font \u0111ang mu\u1ed1n d\u00f9ng ( m\u1eb7c \u0111\u1ecbnh l\u00e0 Time New Roman)<br \/>\n+ D\u00f9ng chu\u1ed9t di chuy\u1ec3n \u0111\u1ec3 t\u00ecm k\u00fd t\u1ef1 mong mu\u1ed1n, m\u1ed7i m\u1ed9t \u00f4 ch\u1ee9a m\u1ed9t k\u00fd t\u1ef1.<br \/>\n+ Khi t\u00ecm th\u1ea5y th\u00ec chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4, ch\u1ecdn copy v\u00e0 paste v\u00e0o v\u1ecb tr\u00ed mu\u1ed1n ch\u00e8n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-788 size-large aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/nhapkytudacbiet-time-0_04_5826__-1024x576-1.png\" alt=\"nhapkytudacbiet-time-0_04_5826__\" width=\"1024\" height=\"576\" title=\"nhapkytudacbiet-time-0_04_5826__-1024x576-1\"><\/p>\n<blockquote>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">H\u01b0\u1edbng d\u1eabn h\u1ecdc excel c\u01a1 b\u1ea3n<\/a><\/p>\n<\/blockquote>\n<p><strong>L\u1ea5y m\u00e3 code c\u1ee7a k\u00fd t\u1ef1 ( code dec):<\/strong><br \/>\n+ Double click v\u00e0o \u00f4 ch\u1ee9 k\u00fd t\u1ef1 mu\u1ed1n l\u1ea5y code.<br \/>\n+ Tr\u00ean thanh c\u00f4ng th\u1ee9c, b\u00f4i \u0111en to\u00e0n b\u1ed9 \u0111\u1ed1i s\u1ed1 c\u1ee7a h\u00e0m NumberToStr.<br \/>\n+ Nh\u1ea5n F9, code dec c\u1ee7a k\u00fd t\u1ef1 s\u1ebd xu\u1ea5t hi\u1ec7n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-789 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/nhapkytudacbiet-time-0_05_2805__-1024x576-1.png\" alt=\"nhapkytudacbiet-time-0_05_2805__\" width=\"1024\" height=\"576\" title=\"nhapkytudacbiet-time-0_05_2805__-1024x576-1\"><\/p>\n<p><strong>L\u01b0u c\u00e1c k\u00fd t\u1ef1 y\u00eau th\u00edch:<\/strong><br \/>\n+ L\u1ea5y code dec c\u1ee7a k\u00fd t\u1ef1 ( ph\u1ea7n tr\u01b0\u1edbc).<br \/>\n+ Chuy\u1ec3n qua sheet \u201cMau\u201d.<br \/>\n+ Paste code dec c\u1ee7a k\u00fd t\u1ef1 v\u00e0o c\u1ed9t Code.<br \/>\n+ L\u1ea7n sau ch\u1ec9 vi\u1ec7c v\u00e0o \u0111\u00e2y l\u1ea5y ra \u0111\u1ec3 d\u00f9ng.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-790 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/nhapkytudacbiet-time-0_05_3922__-1024x576-1.png\" alt=\"nhapkytudacbiet-time-0_05_3922__\" width=\"1024\" height=\"576\" title=\"nhapkytudacbiet-time-0_05_3922__-1024x576-1\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"V_Su_dung_ky_tu_dac_biet\"><\/span>V. S\u1eed d\u1ee5ng k\u00fd t\u1ef1 \u0111\u1eb7c bi\u00eat.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>K\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t c\u0169ng gi\u1ed1ng k\u00fd t\u1ef1 th\u00f4ng th\u01b0\u1eddng, b\u1ea1n c\u00f3 th\u1ec3 ch\u00e8n n\u00f3 v\u00e0o trong m\u1ed9t c\u00f4ng th\u1ee9c, tuy v\u1eady b\u1ea1n ch\u1ec9 c\u00f3 th\u1ec3 ch\u00e8n v\u00e0o c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1ch d\u00f9ng alt+code v\u00e0 copy and paste.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-791 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/nhapkytudacbiet-time-0_08_0511__-1024x576-1.png\" alt=\"nhapkytudacbiet-time-0_08_0511__\" width=\"1024\" height=\"576\" title=\"nhapkytudacbiet-time-0_08_0511__-1024x576-1\"><\/p>\n<p>Th\u1eadm ch\u00ed b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng n\u00f3 cho m\u1ee5c \u0111\u00edch \u0111\u1ecbnh d\u1ea1ng, \u0111\u1ecbnh dang theo \u0111i\u1ec1u ki\u1ec7n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-792 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/nhapkytudacbiet-time-0_10_1109__-1024x576-1.png\" alt=\"nhapkytudacbiet-time-0_10_1109__\" width=\"1024\" height=\"576\" title=\"nhapkytudacbiet-time-0_10_1109__-1024x576-1\"><\/p>\n<p>L\u01b0u \u00fd: tr\u00ean h\u00ecnh tr\u00ean k\u00fd t\u1ef1 m\u00e9t vu\u00f4ng, tr\u00f4ng l\u00e0 2 k\u00fd t\u1ef1, nh\u01b0ng th\u1ef1c ch\u1ea5t n\u00f3 l\u00e0 m\u1ed9t k\u00fd t\u1ef1 nh\u00e9<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-793 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/nhapkytudacbiet-time-0_09_4522__-1024x576-1.png\" alt=\"nhapkytudacbiet-time-0_09_4522__\" width=\"1024\" height=\"576\" title=\"nhapkytudacbiet-time-0_09_4522__-1024x576-1\"><\/p>\n<p><strong>Video h\u01b0\u1edbng d\u1eabn chi ti\u1ebft:<\/strong><\/p>\n<iframe loading=\"lazy\" title=\"Ch\u00e8n k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ebft, s\u1eed d\u1ee5ng k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t trong Excel.\u263a\u263b\u2665\u2666\u2663\u2660\u2022\u25d8\u25cb\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/Rg-o75Qafs4?feature=oembed\" frameborder allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n<p style=\"text-align: left\"><strong>Video s\u1eed d\u1ee5ng k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t cho \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n:<\/strong><\/p>\n<iframe loading=\"lazy\" title=\"SP: D\u00f9ng k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t thay th\u1ebf Formating Conditional  IconSet.\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/GZqAGJUTt-E?feature=oembed\" frameborder allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 bi\u1ebft th\u00eam nhi\u1ec1u h\u00e0m n\u00e2ng cao trong Excel c\u0169ng nh\u01b0 s\u1eed d\u1ee5ng t\u1ed1t h\u01a1n c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel, c\u00e1c b\u1ea1n h\u00e3y tham gia ngay kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2o7MhcP\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc chi ti\u1ebft v\u00e0 \u0111\u1ea7y \u0111\u1ee7 nh\u1ea5t, gi\u00fap b\u1ea1n ph\u00e1t tri\u1ec3n ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, c\u00f3 h\u1ec7 th\u1ed1ng. \u0110\u1eb7c bi\u1ec7t kh\u00f3a h\u1ecdc n\u00e0y kh\u00f4ng gi\u1edbi h\u1ea1n th\u1eddi gian h\u1ecdc t\u1eadp, n\u00ean b\u1ea1n c\u00f3 th\u1ec3 h\u1ecdc tho\u1ea3i m\u00e1i v\u00e0 xem l\u1ea1i b\u1ea5t c\u1ee9 khi n\u00e0o.<\/p>\n<p>T\u00e1c gi\u1ea3: Nguy\u1ec5n Ng\u1ecdc Thu Hi\u1ec1n<\/p>\n<p>Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. Chi ti\u1ebft xem t\u1ea1i:<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-780.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8485,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8484","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8484","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=8484"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8484\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8485"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8484"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8484"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8484"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}