{"id":9512,"date":"2025-01-02T08:38:54","date_gmt":"2025-01-02T08:38:54","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-nhung-cach-danh-so-thu-tu-trong-excel-don-gian\/"},"modified":"2025-01-02T08:38:54","modified_gmt":"2025-01-02T08:38:54","slug":"huong-dan-nhung-cach-danh-so-thu-tu-trong-excel-don-gian","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-nhung-cach-danh-so-thu-tu-trong-excel-don-gian\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn nh\u1eefng c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel \u0111\u01a1n gi\u1ea3n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n m\u1ed9t s\u1ed1 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel.<\/p>\n<p>\u00a0<\/p>\n<p><em>\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1\u2026 \u0111\u01a1n gi\u1ea3n m\u00e0?\u00a0<\/em>\u2013 C\u00e1c b\u1ea1n \u0111ang ngh\u0129 nh\u01b0 v\u1eady ph\u1ea3i kh\u00f4ng? C\u0169ng \u0111\u00fang, vi\u1ec7c \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1\u00a0 hi\u1ec3u \u0111\u01a1n gi\u1ea3n l\u00e0 g\u00e1n m\u1ed9t d\u00e3y s\u1ed1 cho m\u1ed9t chu\u1ed7i d\u1eef li\u1ec7u kh\u00e1c t\u01b0\u01a1ng \u0111\u1ed3ng th\u00f4i. Tuy v\u1eady, h\u00e3y c\u00f9ng ngh\u00eda qua m\u1ed9t s\u1ed1 ki\u1ec3u \u0111\u00e1nh th\u1ee9 t\u1ef1 trong Excel \u0111\u00e3 ch\u1ee9 nh\u1ec9.<\/p>\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-6776509dd49d3\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-danh-so-thu-tu-trong-excel-don-gian.html#Danh_so_thu_tu_co_ban_bang_thao_tac_nhap_so_va_Fill\" title=\"\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 c\u01a1 b\u1ea3n b\u1eb1ng thao t\u00e1c nh\u1eadp s\u1ed1 v\u00e0 Fill\">\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 c\u01a1 b\u1ea3n b\u1eb1ng thao t\u00e1c nh\u1eadp s\u1ed1 v\u00e0 Fill<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-danh-so-thu-tu-trong-excel-don-gian.html#Tao_danh_sach_so_thu_tu_theo_y_thich_bang_Custom_Lists\" title=\"T\u1ea1o danh s\u00e1ch s\u1ed1 th\u1ee9 t\u1ef1 theo \u00fd th\u00edch b\u1eb1ng Custom Lists\">T\u1ea1o danh s\u00e1ch s\u1ed1 th\u1ee9 t\u1ef1 theo \u00fd th\u00edch b\u1eb1ng Custom Lists<\/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\/cach-danh-so-thu-tu-trong-excel-don-gian.html#Danh_so_thu_tu_trong_Excel_su_dung_ham_dem\" title=\"\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm\">\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Danh_so_thu_tu_co_ban_bang_thao_tac_nhap_so_va_Fill\"><\/span>\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 c\u01a1 b\u1ea3n b\u1eb1ng thao t\u00e1c nh\u1eadp s\u1ed1 v\u00e0 Fill<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Cho m\u1ed9t d\u00e3y danh s\u00e1ch t\u00ean nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24170\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/danh-so-thu-tu-1.png\" width=\"231\" height=\"186\" title=\"danh-so-thu-tu-1\"><\/p>\n<p>\u0110\u1ec3 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 cho c\u1ed9t B, t\u1ea1i c\u1ed9t A ta l\u00e0m nh\u01b0 sau:<br \/>\n<strong>B\u01b0\u1edbc 1:\u00a0<\/strong>T\u1ea1i \u00f4 A2, g\u00f5 s\u1ed1 th\u1ee9 t\u1ef1 \u0111\u1ea7u ti\u00ean. VD: 1<\/p>\n<p><strong>B\u01b0\u1edbc 2:\u00a0<\/strong>Di chu\u1ed9t t\u1edbi l\u1ec1 b\u00ean ph\u1ea3i, ph\u00eda d\u01b0\u1edbi \u00f4 A2 cho t\u1edbi khi con chu\u1ed9t chuy\u1ec3n th\u00e0nh h\u00ecnh ch\u1eef th\u1eadp \u0111en.<\/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\/2025\/01\/ex101_92019-nho-62.gif\" title=\"ex101_92019-nho-62\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><strong>B\u01b0\u1edbc 3:\u00a0<\/strong>Click \u0111\u00fap ho\u1eb7c k\u00e9o t\u1edbi \u00f4 cu\u1ed1i c\u00f9ng r\u1ed3i th\u1ea3 chu\u1ed9t.<\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> Trong n\u00fat t\u00f9y ch\u1ecdn Fill, ch\u1ecdn\u00a0<strong>Fill Series.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24171\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/danh-so-thu-tu-2.png\" width=\"277\" height=\"334\" title=\"danh-so-thu-tu-2\"><\/p>\n<p>K\u1ebft qu\u1ea3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24172\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/danh-so-thu-tu-3.png\" width=\"240\" height=\"213\" title=\"danh-so-thu-tu-3\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tao_danh_sach_so_thu_tu_theo_y_thich_bang_Custom_Lists\"><\/span>T\u1ea1o danh s\u00e1ch s\u1ed1 th\u1ee9 t\u1ef1 theo \u00fd th\u00edch b\u1eb1ng Custom Lists<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<figure id=\"attachment_24173\" aria-describedby=\"caption-attachment-24173\" style=\"width: 233px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24173\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/danh-so-thu-tu-4.png\" width=\"233\" height=\"191\" title=\"danh-so-thu-tu-4\"><figcaption id=\"caption-attachment-24173\" class=\"wp-caption-text\">\u201cPh\u00e1 c\u00e1ch\u201d nh\u01b0 n\u00e0y ki\u1ec3u g\u00ec nh\u1ec9?<\/figcaption><\/figure>\n<p>\u0110\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c s\u1ed1 th\u1ee9 t\u1ef1 nh\u01b0 trong h\u00ecnh, ngo\u00e0i ch\u1ee9c n\u0103ng ch\u00ednh l\u00e0\u00a0<strong>Custom Lists\u00a0<\/strong>ra, ta s\u1ebd c\u1ea7n m\u1ed9t ch\u00fat chu\u1ea9n b\u1ecb.<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: Chu\u1ea9n b\u1ecb s\u1eb5n danh s\u00e1ch mu\u1ed1n th\u00eam<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24174\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/danh-so-thu-tu-5.png\" width=\"91\" height=\"165\" title=\"danh-so-thu-tu-5\"><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> V\u00e0o th\u1ebb\u00a0<strong>File,\u00a0<\/strong>ch\u1ecdn\u00a0<strong>Options<\/strong> -&gt;\u00a0<strong>Advanced<\/strong>. K\u00e9o chu\u1ed9t xu\u1ed1ng m\u1ee5c\u00a0<strong>General<\/strong> ch\u1ecdn\u00a0<strong>Edit Custom Lists.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24175\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/danh-so-thu-tu-6.png\" width=\"830\" height=\"677\" title=\"danh-so-thu-tu-6\"><\/p>\n<p><strong>B\u01b0\u1edbc 3:\u00a0<\/strong>Th\u00eam danh s\u00e1ch b\u1eb1ng n\u00fat\u00a0<strong>Import<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24176\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/danh-so-thu-tu-7.png\" width=\"500\" height=\"376\" title=\"danh-so-thu-tu-7\"><\/p>\n<p>\u0110\u00e3 xong. V\u1eady l\u00e0 khi nh\u1eadp b\u1ea5t k\u00ec m\u1ed9t gi\u00e1 tr\u1ecb n\u00e0o trong danh s\u00e1ch c\u00f3 s\u1eb5n v\u00e0 s\u1eed d\u1ee5ng fill, danh s\u00e1ch s\u1ebd \u0111\u01b0\u1ee3c t\u1ef1 \u0111\u1ed9ng g\u1ee3i \u00fd!<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Danh_so_thu_tu_trong_Excel_su_dung_ham_dem\"><\/span>\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>M\u1ed9t c\u00e1ch \u0111\u00e1nh s\u1ed1 b\u1eb1ng h\u00e0m COUNT \u1edf \u0111\u00e2y H\u1ecdc Excel Online mu\u1ed1n gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n \u0111\u00f3 l\u00e0 \u0111\u00e1nh s\u1ed1 b\u1eb1ng\u00a0<strong>COUNTA (\u0111\u1ebfm nh\u1eefng \u00f4 kh\u00f4ng tr\u1ed1ng).\u00a0<\/strong>C\u1ee5 th\u1ec3 c\u00e1ch \u0111\u1ebfm nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1:\u00a0<\/strong>T\u1ea1i \u00f4\u00a0<strong>G2\u00a0<\/strong>nh\u1eadp<\/p>\n<p><em>=COUNTA(H2:H2)<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 2:\u00a0<\/strong>C\u1ed1 \u0111\u1ecbnh \u0111\u1ea7u:<\/p>\n<p><em>=COUNTA($H$2:H2)<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 3:\u00a0<\/strong>S\u1eed d\u1ee5ng Fill<\/p>\n<p>K\u1ebft qu\u1ea3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24177\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/danh-so-thu-tu-9.png\" width=\"397\" height=\"299\" title=\"danh-so-thu-tu-9\"><\/p>\n<p>B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam b\u00e0i vi\u1ebft v\u1ec1 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 sau: <a href=\"http:\/\/blog.ezworkapp.com\/ham-countif-thiet-lap-so-thu-tu-thanh-phan-bang-phan-loai.html\">S\u1eed d\u1ee5ng COUNTIF \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 theo \u0111i\u1ec1u ki\u1ec7n<\/a><\/p>\n<p>Ngo\u00e0i ra c\u00f2n r\u1ea5t nhi\u1ec1u ki\u1ec3u \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 n\u1eefa \u0111\u01b0\u1ee3c bi\u1ebfn h\u00f3a t\u1eeb nh\u1eefng c\u00e1ch c\u01a1 b\u1ea3n ra \u0111ang ch\u1edd c\u00e1c b\u1ea1n t\u00ecm hi\u1ec3u \u0111\u00f3.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t!<\/p>\n<p>\u00a0<\/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\/2025\/01\/ex101_92019-nho-62.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9513,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9512","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9512","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=9512"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9512\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9513"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9512"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9512"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9512"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}