{"id":5691,"date":"2024-12-19T00:47:22","date_gmt":"2024-12-19T00:47:22","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/19\/huong-dan-cach-tao-danh-sach-chon-tai-khoan-so-cai-trong-excel\/"},"modified":"2024-12-19T00:47:22","modified_gmt":"2024-12-19T00:47:22","slug":"huong-dan-cach-tao-danh-sach-chon-tai-khoan-so-cai-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/19\/huong-dan-cach-tao-danh-sach-chon-tai-khoan-so-cai-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ea1o danh s\u00e1ch ch\u1ecdn t\u00e0i kho\u1ea3n S\u1ed5 c\u00e1i trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i h\u1ecdc tr\u01b0\u1edbc ch\u00fang ta\u00a0\u0111\u00e3 t\u00ecm hi\u1ec3u c\u00e1ch t\u1ea1o m\u1eabu S\u1ed5 C\u00e1i tr\u00ean\u00a0Excel (n\u1ebfu b\u1ea1n ch\u01b0a r\u00f5 c\u00f3 th\u1ec3 xem l\u1ea1i b\u00e0i h\u1ecdc n\u00e0y\u00a0\u1edf\u00a0\u0111\u1ecba ch\u1ec9 b\u00ean d\u01b0\u1edbi)<\/p>\n<blockquote>\n<p>Xemn th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/excel-ke-toan-tao-mau-cai-tren-excel.html\">Excel k\u1ebf to\u00e1n: T\u1ea1o m\u1eabu S\u1ed5 c\u00e1i tr\u00ean\u00a0Excel<\/a><\/p>\n<\/blockquote>\n<p>Trong b\u00e0i h\u1ecdc n\u00e0y, m\u00ecnh s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n t\u1ea1o danh s\u00e1ch ch\u1ecdn t\u00e0i kho\u1ea3n\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 theo d\u00f5i cho b\u1ea5t k\u1ef3 t\u00e0i kho\u1ea3n t\u1ed5ng h\u1ee3p n\u00e0o trong danh m\u1ee5c t\u00e0i kho\u1ea3n.<\/p>\n<p>C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/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-67636d1976a84\" 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\/excel-ke-toan-tao-danh-sach-chon-tai-khoan-trong-cai.html#Buoc_1_Chuan_bi_danh_muc_tai_khoan_so_cai\" title=\"B\u01b0\u1edbc 1: Chu\u1ea9n b\u1ecb danh m\u1ee5c t\u00e0i kho\u1ea3n s\u1ed5 c\u00e1i\">B\u01b0\u1edbc 1: Chu\u1ea9n b\u1ecb danh m\u1ee5c t\u00e0i kho\u1ea3n s\u1ed5 c\u00e1i<\/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\/excel-ke-toan-tao-danh-sach-chon-tai-khoan-trong-cai.html#Buoc_2_Kiem_tra_phien_ban_Microsoft_Excel_de_chon_phuong_phap_phu_hop\" title=\"B\u01b0\u1edbc 2: Ki\u1ec3m tra phi\u00ean b\u1ea3n Microsoft\u00a0Excel\u00a0\u0111\u1ec3 ch\u1ecdn ph\u01b0\u01a1ng ph\u00e1p ph\u00f9 h\u1ee3p\">B\u01b0\u1edbc 2: Ki\u1ec3m tra phi\u00ean b\u1ea3n Microsoft\u00a0Excel\u00a0\u0111\u1ec3 ch\u1ecdn ph\u01b0\u01a1ng ph\u00e1p ph\u00f9 h\u1ee3p<\/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\/excel-ke-toan-tao-danh-sach-chon-tai-khoan-trong-cai.html#Buoc_3_Tao_danh_sach_chon_bang_Data_ValidationList\" title=\"B\u01b0\u1edbc 3: T\u1ea1o danh s\u00e1ch ch\u1ecdn b\u1eb1ng Data Validation\/List\">B\u01b0\u1edbc 3: T\u1ea1o danh s\u00e1ch ch\u1ecdn b\u1eb1ng Data Validation\/List<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_1_Chuan_bi_danh_muc_tai_khoan_so_cai\"><\/span>B\u01b0\u1edbc 1: Chu\u1ea9n b\u1ecb danh m\u1ee5c t\u00e0i kho\u1ea3n s\u1ed5 c\u00e1i<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u k\u1ef9 h\u01a1n\u00a0\u1edf b\u00e0i h\u1ecdc n\u00e0y:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/excel-ke-toan-loc-danh-sach-tai-khoan-tong-hop-trong-danh-muc-tai-khoan-ke-toan.html\">L\u1ecdc danh m\u1ee5c t\u00e0i kho\u1ea3n t\u1ed5ng h\u1ee3p trong danh m\u1ee5c TKKT<\/a><\/p>\n<p>Trong b\u00e0i n\u00e0y m\u00ecnh\u00a0\u0111\u00e3 h\u01b0\u1edbng d\u1eabn r\u1ea5t chi ti\u1ebft v\u1ec1 danh m\u1ee5c t\u00e0i kho\u1ea3n v\u00e0 c\u00e1ch l\u1ecdc c\u00e1c t\u00e0i kho\u1ea3n t\u1ed5ng h\u1ee3p ra kh\u1ecfi danh m\u1ee5c t\u00e0i kho\u1ea3n.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_2_Kiem_tra_phien_ban_Microsoft_Excel_de_chon_phuong_phap_phu_hop\"><\/span>B\u01b0\u1edbc 2: Ki\u1ec3m tra phi\u00ean b\u1ea3n Microsoft\u00a0Excel\u00a0\u0111\u1ec3 ch\u1ecdn ph\u01b0\u01a1ng ph\u00e1p ph\u00f9 h\u1ee3p<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u1edbi phi\u00ean b\u1ea3n Microsoft\u00a0Excel 2007 tr\u1edf v\u1ec1 tr\u01b0\u1edbc\u00a0v\u00e0 c\u00e1c phi\u00ean b\u1ea3n tr\u1edf\u00a0v\u1ec1 sau (t\u1eeb 2010 tr\u1edf\u00a0\u0111i) c\u00f3 s\u1ef1 kh\u00e1c nhau trong ch\u1ee9c n\u0103ng<strong> Data Validation\/List<\/strong>\u00a0\u0111\u00f3 l\u00e0:<\/p>\n<ul>\n<li>Microsoft\u00a0Excel 2007 tr\u1edf v\u1ec1 tr\u01b0\u1edbc: Kh\u00f4ng cho ph\u00e9p ch\u1ecdn danh s\u00e1ch t\u1eeb 1 sheet kh\u00e1c so v\u1edbi sheet\u00a0\u0111\u1eb7t v\u1ecb tr\u00ed t\u1ea1o danh s\u00e1ch ch\u1ecdn.<\/li>\n<li>Microsoft\u00a0Excel 2010 tr\u1edf v\u1ec1\u00a0sau: Cho ph\u00e9p ch\u1ecdn danh s\u00e1ch t\u1eeb 1 sheet kh\u00e1c, ho\u1eb7c t\u1eeb 1 c\u00f4ng th\u1ee9c m\u1ea3ng<\/li>\n<\/ul>\n<p>Do\u00a0\u0111\u00f3 ch\u00fang ta c\u1ea7n h\u1ebft s\u1ee9c l\u01b0u\u00a0\u00fd b\u01b0\u1edbc n\u00e0y\u00a0\u0111\u1ec3 tr\u00e1nh l\u1ed7i v\u00e0 ki\u1ec3m so\u00e1t\u00a0\u0111\u01b0\u1ee3c v\u1ea5n\u00a0\u0111\u1ec1 n\u1ebfu c\u00f3 l\u1ed7i x\u1ea3y ra d\u00f9\u00a0\u0111\u00e3 l\u00e0m\u00a0\u0111\u00fang h\u01b0\u1edbng d\u1eabn<\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-498.gif\" title=\"ex101_92019-nho-498\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-209.gif\" title=\"vba101_92019-nho-209\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-498.gif\" title=\"ex101_92019-nho-498\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_3_Tao_danh_sach_chon_bang_Data_ValidationList\"><\/span>B\u01b0\u1edbc 3: T\u1ea1o danh s\u00e1ch ch\u1ecdn b\u1eb1ng Data Validation\/List<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>Microsoft\u00a0Excel 2007 tr\u1edf v\u1ec1 tr\u01b0\u1edbc: Khi l\u1ecdc t\u00e0i kho\u1ea3n t\u1ed5ng h\u1ee3p t\u1eeb Danh m\u1ee5c t\u00e0i kho\u1ea3n, ch\u00fang ta copy c\u00e1c t\u00e0i kho\u1ea3n\u00a0\u0111\u00e3 l\u1ecdc sang sheet S\u1ed5 c\u00e1i<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12208\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/video-tao-danh-sach-chon-tk.gif\" width=\"1338\" height=\"534\" title=\"video-tao-danh-sach-chon-tk\"><\/p>\n<ul>\n<li>Microsoft\u00a0Excel 2010\u00a0tr\u1edf v\u1ec1\u00a0sau: Ch\u00fang ta c\u00f3 th\u1ec3\u00a0\u0111\u1eb7t danh m\u1ee5c t\u00e0i kho\u1ea3n s\u1ed5 c\u00e1i\u00a0\u0111\u00f3\u00a0\u1edf 1 sheet kh\u00e1c, r\u1ed3i t\u1ea1o Data Validation\/ List c\u00f3 ph\u1ea7n Source t\u00ecm\u00a0\u0111\u1ebfn v\u00f9ng\u00a0\u0111\u00f3 l\u00e0\u00a0\u0111\u01b0\u1ee3c.<\/li>\n<\/ul>\n<p><strong>Nh\u01b0 v\u1eady k\u1ebft qu\u1ea3 sau khi th\u1ef1c hi\u1ec7n b\u01b0\u1edbc 3 c\u1ee7a ch\u00fang ta nh\u01b0 sau:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12209\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/video-tao-danh-sach-chon-tk-kq.gif\" width=\"1320\" height=\"805\" title=\"video-tao-danh-sach-chon-tk-kq\"><\/p>\n<p>\u0110\u00ea\u0309 co\u0301 th\u00ea\u0309 trau d\u00f4\u0300i ki\u00ea\u0301n th\u01b0\u0301c t\u01b0\u0300 c\u01a1 ba\u0309n \u0111\u00ea\u0301n n\u00e2ng cao v\u00ea\u0300 Excel ca\u0301c ba\u0323n ha\u0303y \u0111\u0103ng ki\u0301 tham gia ngay nh\u01b0\u0303ng\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-ke-toan.html\">l\u01a1\u0301p ho\u0323c Excel k\u00ea\u0301 toa\u0301n<\/a>\u00a0v\u01a1\u0301i ca\u0301c chuy\u00ean gia co\u0301 nhi\u00ea\u0300u n\u0103m kinh nghi\u00ea\u0323m v\u00ea\u0300 Excel se\u0303 h\u01b0\u01a1\u0301ng d\u00e2\u0303n ca\u0301c ba\u0323n m\u00f4\u0323t ca\u0301ch t\u00e2\u0323n ti\u0300nh nh\u00e2\u0301t v\u01a1\u0301i gia\u0301 tha\u0300nh c\u01b0\u0323c h\u00e2\u0301p d\u00e2\u0303n.<\/p>\n<p><strong>Mo\u0323i th\u00f4ng tin chi ti\u00ea\u0301t v\u00ea\u0300 ca\u0301c khoa ho\u0323c, xin vui lo\u0300ng li<\/strong><strong>\u00ea<\/strong><strong>n h<\/strong><strong>\u00ea<\/strong><strong>\u0323 v\u01a1<\/strong><strong>\u0301i chu\u0301ng t<\/strong><strong>\u00f4<\/strong><strong>i:<\/strong><\/p>\n<p><strong>\u0110\u1ecb<\/strong><strong>a ch\u1ec9<\/strong>: 102 Th\u00e1i Th\u1ecbnh \u2013 \u0110\u1ed1ng \u0110a, H\u00e0 N\u1ed9i<\/p>\n<p><strong>Email<\/strong>: Listen@hocexcel.online<\/p>\n<p><strong>S\u0110T<\/strong>: 0977.972.223<\/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<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-498.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5692,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5691","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\/5691","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=5691"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5691\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5692"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5691"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5691"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5691"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}