{"id":4918,"date":"2024-12-08T13:53:42","date_gmt":"2024-12-08T13:53:42","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/huong-dan-cach-lap-bao-cao-chi-tiet-nxt-kho-bang-advanced-filter-trong-excel\/"},"modified":"2024-12-08T13:53:42","modified_gmt":"2024-12-08T13:53:42","slug":"huong-dan-cach-lap-bao-cao-chi-tiet-nxt-kho-bang-advanced-filter-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/huong-dan-cach-lap-bao-cao-chi-tiet-nxt-kho-bang-advanced-filter-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp b\u00e1o c\u00e1o chi ti\u1ebft NXT kho b\u1eb1ng Advanced Filter trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong c\u00f4ng vi\u1ec7c qu\u1ea3n l\u00fd kho, ch\u00fang ta th\u01b0\u1eddng xuy\u00ean ph\u1ea3i theo d\u00f5i chi ti\u1ebft t\u00ecnh h\u00ecnh nh\u1eadp-xu\u1ea5t-t\u1ed3n (NXT) c\u1ee7a 1 m\u1eb7t h\u00e0ng trong 1 kho\u1ea3ng th\u1eddi gian c\u1ee5 th\u1ec3. Tuy nhi\u00ean vi\u1ec7c n\u00e0y c\u00f3 th\u1ec3 khi\u1ebfn b\u1ea1n g\u1eb7p nhi\u1ec1u kh\u00f3 kh\u0103n khi kh\u00f4ng bi\u1ebft ph\u1ea3i d\u00f9ng c\u00f4ng th\u1ee9c n\u00e0o\u00a0\u0111\u1ec3 b\u00e1o c\u00e1o, b\u00e1o c\u00e1o nh\u01b0 th\u1ebf n\u00e0o cho\u00a0\u0111\u1eb9p. Sau\u00a0\u0111\u00e2y H\u1ecdc\u00a0Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n <strong>c\u00e1ch l\u1eadp b\u00e1o c\u00e1o chi ti\u1ebft\u00a0NXT kho b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Advanced Filter trong\u00a0Excel<\/strong>.<\/p>\n<p>Tr\u01b0\u1edbc ti\u00ean c\u00e1c b\u1ea1n c\u1ea7n n\u1eafm \u0111\u01b0\u1ee3c <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-loc-du-lieu-sang-sheet-khac-bang-advanced-filter-trong-excel.html\">c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u sang sheet kh\u00e1c b\u1eb1ng Advanced Filter trong Excel<\/a>. Ch\u00fang ta s\u1ebd d\u1ef1a tr\u00ean t\u00ednh n\u0103ng\u00a0\u0111\u00f3 c\u1ee7a Advanced Filter\u00a0\u0111\u1ec3 l\u1eadp b\u00e1o c\u00e1o chi ti\u1ebft.<\/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-6755a4e5f354c\" 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\/huong-dan-cach-lap-bao-cao-chi-tiet-nxt-kho-bang-advanced-filter-trong-excel.html#1_Yeu_cau\" title=\"1. Y\u00eau c\u1ea7u\">1. Y\u00eau c\u1ea7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-lap-bao-cao-chi-tiet-nxt-kho-bang-advanced-filter-trong-excel.html#2_Cach_thuc_hien\" title=\"2. C\u00e1ch th\u1ef1c hi\u1ec7n\">2. C\u00e1ch th\u1ef1c hi\u1ec7n<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-lap-bao-cao-chi-tiet-nxt-kho-bang-advanced-filter-trong-excel.html#c_Su_dung_ham_SUMIFS_de_tinh_so_ton\" title=\"c. S\u1eed d\u1ee5ng h\u00e0m SUMIFS\u00a0\u0111\u1ec3 t\u00ednh s\u1ed1 t\u1ed3n\">c. S\u1eed d\u1ee5ng h\u00e0m SUMIFS\u00a0\u0111\u1ec3 t\u00ednh s\u1ed1 t\u1ed3n<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-lap-bao-cao-chi-tiet-nxt-kho-bang-advanced-filter-trong-excel.html#3_Danh_gia_uu_nhuoc_diem\" title=\"3.\u00a0\u0110\u00e1nh gi\u00e1\u00a0\u01b0u nh\u01b0\u1ee3c\u00a0\u0111i\u1ec3m\">3.\u00a0\u0110\u00e1nh gi\u00e1\u00a0\u01b0u nh\u01b0\u1ee3c\u00a0\u0111i\u1ec3m<\/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-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-lap-bao-cao-chi-tiet-nxt-kho-bang-advanced-filter-trong-excel.html#a_Uu_diem\" title=\"a.\u00a0\u01afu\u00a0\u0111i\u1ec3m\">a.\u00a0\u01afu\u00a0\u0111i\u1ec3m<\/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\/huong-dan-cach-lap-bao-cao-chi-tiet-nxt-kho-bang-advanced-filter-trong-excel.html#b_Nhuoc_diem\" title=\"b. Nh\u01b0\u1ee3c\u00a0\u0111i\u1ec3m\">b. Nh\u01b0\u1ee3c\u00a0\u0111i\u1ec3m<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"1_Yeu_cau\"><\/span>1. Y\u00eau c\u1ea7u<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Cho b\u1ea3ng d\u1eef li\u1ec7u\u00a0kho t\u1ea1i Sheet1. Y\u00eau c\u1ea7u l\u1eadp b\u00e1o c\u00e1o chi ti\u1ebft N-X\u00a0kho cho m\u1eb7t h\u00e0ng T\u00e1o\u00a0trong Sheet2 theo th\u1eddi gian t\u00f9y ch\u1ecdn t\u1ea1i\u00a0\u00f4 B3 v\u00e0 B4 trong Sheet2<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17375\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bc_ct_nxt_advanced-filter-01.png\" width=\"855\" height=\"579\" title=\"bc_ct_nxt_advanced-filter-01\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"2_Cach_thuc_hien\"><\/span>2. C\u00e1ch th\u1ef1c hi\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>a. Trong Sheet2 ch\u00fang ta s\u1ebd thi\u1ebft l\u1eadp l\u1ea1i v\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng cho Advanced Filter<\/strong> nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17378\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bc_ct_nxt_advanced-filter-02.png\" width=\"731\" height=\"154\" title=\"bc_ct_nxt_advanced-filter-02\"><\/p>\n<p>Khi thi\u1ebft l\u1eadp\u00a0\u0111i\u1ec1u ki\u1ec7n trong Advanced Filter ch\u00fang ta l\u01b0u\u00a0\u00fd: Ph\u1ea3i bao g\u1ed3m t\u00ean ti\u00eau\u00a0\u0111\u1ec1 c\u1ed9t v\u00e0\u00a0\u0110i\u1ec1u ki\u1ec7n c\u1ea7n l\u1ecdc trong c\u1ed9t\u00a0\u0111\u00f3:<\/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-406.gif\" title=\"ex101_92019-nho-406\"><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-406.gif\" title=\"ex101_92019-nho-406\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>B\u1edfi v\u00ec gi\u00e1 tr\u1ecb th\u1eddi gian n\u1eb1m trong c\u1ed9t Ng\u00e0y, trong\u00a0\u0111\u00f3 <strong>T\u1eeb ng\u00e0y\u00a0\u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 L\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng ng\u00e0y\u00a0\u0111\u00f3<\/strong>, c\u00f2n\u00a0<strong>\u0110\u1ebfn ng\u00e0y\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111i\u1ec1u l\u00e0 Nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng ng\u00e0y\u00a0\u0111\u00f3<\/strong> =&gt; L\u1eadp\u00a0\u0111i\u1ec1u ki\u1ec7n cho 2 gi\u00e1 tr\u1ecb th\u1eddi gian t\u1ea1i 2\u00a0\u00f4 F3 v\u00e0 G3 ri\u00eang<\/li>\n<li>M\u1eb7t h\u00e0ng T\u00e1o n\u1eb1m trong c\u1ed9t T\u00ean h\u00e0ng.<\/li>\n<\/ul>\n<p><strong>b. S\u1eed d\u1ee5ng Advanced Filter<\/strong><\/p>\n<p>Mu\u1ed1n tr\u00edch xu\u1ea5t ra b\u00e1o c\u00e1o chi ti\u1ebft nh\u1eefng n\u1ed9i dung g\u00ec th\u00ec ch\u00fang ta c\u1ea7n x\u00e1c\u00a0\u0111\u1ecbnh r\u00f5 nh\u1eefng tr\u01b0\u1eddng (c\u1ed9t) d\u1eef li\u1ec7u c\u1ea7n l\u1ea5y. C\u1ee5 th\u1ec3\u00a0\u1edf\u00a0\u0111\u00e2y ch\u00fang ta s\u1ebd l\u1ea5y k\u1ebft qu\u1ea3\u00a0\u1edf c\u00e1c c\u1ed9t <strong>Ng\u00e0y, Lo\u1ea1i v\u00e0 S\u1ed1 l\u01b0\u1ee3ng<\/strong>. (kh\u00f4ng c\u1ea7n l\u1ea5y <strong>t\u00ean h\u00e0ng<\/strong> b\u1edfi b\u00e1o c\u00e1o chi ti\u1ebft\u00a0\u0111\u00e3 x\u00e1c\u00a0\u0111\u1ecbnh r\u00f5 t\u00ean h\u00e0ng c\u1ea7n l\u1ea5y l\u00e0 m\u1eb7t h\u00e0ng n\u00e0o)<\/p>\n<p>Do\u00a0\u0111\u00f3 ch\u00fang ta s\u1ebd l\u1ea5y t\u00ean ti\u00eau\u00a0\u0111\u1ec1 t\u01b0\u01a1ng\u00a0\u1ee9ng c\u1ea7n l\u1ea5y trong b\u00e1o c\u00e1o chi ti\u1ebft:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17379\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bc_ct_nxt_advanced-filter-03.png\" width=\"738\" height=\"183\" title=\"bc_ct_nxt_advanced-filter-03\"><\/p>\n<p>Trong Advanced Filter ch\u00fang ta thi\u1ebft l\u1eadp nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17380\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bc_ct_nxt_advanced-filter-04.png\" width=\"316\" height=\"306\" title=\"bc_ct_nxt_advanced-filter-04\"><\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li><strong>List range<\/strong>: V\u00f9ng b\u1ea3ng d\u1eef li\u1ec7u t\u1ea1i sheet1, t\u1eeb A1:D24<\/li>\n<li><strong>Criteria range<\/strong>: V\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n\u00a0\u0111\u1eb7t t\u1ea1i sheet2 (Sheet b\u00e1o c\u00e1o), t\u1eeb E2:G3<\/li>\n<li><strong>Copy to<\/strong>: V\u1ecb tr\u00ed\u00a0\u0111\u1eb7t b\u00e1o c\u00e1o: t\u1ea1i sheet2, t\u1eeb A6:C6 (ch\u00ednh l\u00e0 v\u00f9ng ti\u00eau\u00a0\u0111\u1ec1 c\u1ee7a 3 c\u1ed9t c\u1ea7n l\u1ea5y k\u1ebft qu\u1ea3)<\/li>\n<\/ul>\n<p>B\u1ea5m OK\u00a0\u0111\u1ec3 ho\u00e0n t\u1ea5t thao t\u00e1c.<\/p>\n<p>K\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17381\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bc_ct_nxt_advanced-filter-05.png\" width=\"733\" height=\"288\" title=\"bc_ct_nxt_advanced-filter-05\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"c_Su_dung_ham_SUMIFS_de_tinh_so_ton\"><\/span>c. S\u1eed d\u1ee5ng h\u00e0m SUMIFS\u00a0\u0111\u1ec3 t\u00ednh s\u1ed1 t\u1ed3n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Vi\u1ec7c s\u1eed d\u1ee5ng Advanced Filter ch\u1ec9 gi\u00fap ch\u00fang ta tr\u00edch l\u1ecdc\u00a0\u0111\u01b0\u1ee3c ph\u1ea7n ph\u00e1t sinh c\u1ee7a m\u1eb7t h\u00e0ng ch\u1ee9 kh\u00f4ng x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c s\u1ed1 t\u1ed3n kho (T\u1ed3n\u00a0\u0111\u1ea7u v\u00e0 T\u1ed3n cu\u1ed1i)<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 t\u00ednh\u00a0\u0111\u01b0\u1ee3c s\u1ed1 T\u1ed3n\u00a0\u0111\u1ea7u v\u00e0 T\u1ed3n cu\u1ed1i ch\u00fang ta th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p>T\u1ed3n\u00a0\u0111\u1ea7u = T\u1ed5ng nh\u1eadp t\u1edbi tr\u01b0\u1edbc ng\u00e0y b\u00e1o c\u00e1o \u2013 T\u1ed5ng xu\u1ea5t t\u1edbi tr\u01b0\u1edbc ng\u00e0y b\u00e1o c\u00e1o<\/p>\n<p>T\u1ed3n cu\u1ed1i = T\u1ed3n\u00a0\u0111\u1ea7u + Nh\u1eadp trong k\u1ef3 \u2013 Xu\u1ea5t trong k\u1ef3<\/p>\n<p>T\u1ed5ng nh\u1eadp tr\u01b0\u1edbc ng\u00e0y b\u00e1o c\u00e1o<\/p>\n<p style=\"padding-left: 30px\">=SUMIFS(Sheet1!$D$2:$D$24,Sheet1!$B$2:$B$24,Sheet2!B2,Sheet1!$A$2:$A$24,\u201d&lt;\u201c&amp;Sheet2!B3,Sheet1!$C$2:$C$24,\u201dNh\u1eadp\u201d)<\/p>\n<ul>\n<li>Sheet1!$D$2:$D$24: Ph\u1ea7n n\u1ed9i dung c\u1ee7a c\u1ed9t S\u1ed1 l\u01b0\u1ee3ng<\/li>\n<li>Sheet1!$B$2:$B$24: Ph\u1ea7n n\u1ed9i dung c\u1ee7a c\u1ed9t T\u00ean h\u00e0ng<\/li>\n<li>Sheet2!B2: T\u00ean m\u1eb7t h\u00e0ng c\u1ea7n b\u00e1o c\u00e1o<\/li>\n<li>Sheet1!$A$2:$A$24: Ph\u1ea7n n\u1ed9i dung c\u1ee7a c\u1ed9t\u00a0Ng\u00e0y<\/li>\n<li>\u201c&lt;\u201c&amp;Sheet2!B3: Nh\u1ecf h\u01a1n ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u t\u1ea1i\u00a0\u00f4 B3<\/li>\n<li>Sheet1!$C$2:$C$24:\u00a0Ph\u1ea7n n\u1ed9i dung c\u1ee7a\u00a0c\u1ed9t Lo\u1ea1i<\/li>\n<li>\u201cNh\u1eadp\u201d:\u00a0\u0110i\u1ec1u ki\u1ec7n c\u1ee7a c\u1ed9t Lo\u1ea1i l\u00e0 c\u00e1c ph\u00e1t sinh Nh\u1eadp<\/li>\n<\/ul>\n<p>T\u01b0\u01a1ng t\u1ef1 ta c\u00f3 T\u1ed5ng xu\u1ea5t tr\u01b0\u1edbc ng\u00e0y b\u00e1o c\u00e1o<\/p>\n<p style=\"padding-left: 30px\">=SUMIFS(Sheet1!$D$2:$D$24,Sheet1!$B$2:$B$24,Sheet2!B2,Sheet1!$A$2:$A$24,\u201d&lt;\u201c&amp;Sheet2!B3,Sheet1!$C$2:$C$24,\u201dXu\u1ea5t\u201d)<\/p>\n<p>(Ch\u1ec9 c\u1ea7n thay\u00a0\u0111\u1ed5i\u00a0\u0111i\u1ec1u ki\u1ec7n \u201cNh\u1eadp\u201d th\u00e0nh \u201cXu\u1ea5t\u201d)<\/p>\n<p>K\u1ebft qu\u1ea3 b\u00e1o c\u00e1o ho\u00e0n thi\u1ec7n nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17385\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bc_ct_nxt_advanced-filter-06.png\" width=\"326\" height=\"412\" title=\"bc_ct_nxt_advanced-filter-06\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"3_Danh_gia_uu_nhuoc_diem\"><\/span>3.\u00a0\u0110\u00e1nh gi\u00e1\u00a0\u01b0u nh\u01b0\u1ee3c\u00a0\u0111i\u1ec3m<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"a_Uu_diem\"><\/span>a.\u00a0\u01afu\u00a0\u0111i\u1ec3m<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u1edbi vi\u1ec7c s\u1eed d\u1ee5ng Advanced Filter th\u00ec ch\u00fang ta kh\u00f4ng c\u1ea7n s\u1eed d\u1ee5ng nhi\u1ec1u c\u00f4ng th\u1ee9c, ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng t\u1ed1t Advanced Filter l\u00e0\u00a0\u0111\u01b0\u1ee3c.<\/p>\n<p>V\u1edbi c\u00e1c d\u1ea1ng b\u00e1o c\u00e1o ph\u1ee9c t\u1ea1p th\u00ec ch\u1ec9 c\u1ea7n l\u00e0m\u00a0\u0111\u00fang v\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n l\u00e0 c\u00f3 th\u1ec3 ra\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 b\u00e1o c\u00e1o. Vi\u1ec7c n\u00e0y d\u1ec5 h\u01a1n nhi\u1ec1u so v\u1edbi c\u00e1c ph\u01b0\u01a1ng ph\u00e1p kh\u00e1c<\/p>\n<h3><span class=\"ez-toc-section\" id=\"b_Nhuoc_diem\"><\/span>b. Nh\u01b0\u1ee3c\u00a0\u0111i\u1ec3m<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>M\u1ed7i khi thay\u00a0\u0111\u1ed5i\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng c\u1ea7n b\u00e1o c\u00e1o (t\u00ean h\u00e0ng, th\u1eddi gian b\u00e1o c\u00e1o\u2026) c\u1ea7n th\u1ef1c hi\u1ec7n l\u1ea1i l\u1ec7nh Advanced Filter. Vi\u1ec7c n\u00e0y c\u00f3 th\u1ec3 khi\u1ebfn b\u1ea1n th\u1ea5y b\u1ea5t ti\u1ec7n.<\/p>\n<p>C\u00e1ch kh\u1eafc ph\u1ee5c:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/su-dung-chuc-nang-advance-filter-trong-vba.html\">s\u1eed d\u1ee5ng VBA\u00a0\u0111\u1ec3 t\u1ef1\u00a0\u0111\u1ed9ng h\u00f3a thao t\u00e1c Advanced Filter<\/a><\/p>\n<p>T\u1ea3i v\u1ec1 file m\u1eabu:\u00a0<a href=\"http:\/\/bit.ly\/2IYawWY\">http:\/\/bit.ly\/2IYawWY<\/a><\/p>\n<p>Ngo\u00e0i ra H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n \u201c<strong>Kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m<\/strong>\u201c.\u00a0\u0110\u00e2y l\u00e0 1 kh\u00f3a h\u1ecdc r\u1ea5t\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 ki\u1ebfn th\u1ee9c v\u00e0 b\u1ed5 tr\u1ee3 r\u1ea5t tuy\u1ec7t v\u1eddi cho b\u1ea1n trong vi\u1ec7c l\u00e0m quen v\u1edbi Excel, s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5, c\u00e1c h\u00e0m trong\u00a0Excel\u00a0\u0111\u1ec3\u00a0\u0111\u00e1p\u00a0\u1ee9ng y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c t\u1ed5 ch\u1ee9c, qu\u1ea3n l\u00fd d\u1eef li\u1ec7u v\u00e0 l\u1eadp b\u00e1o c\u00e1o tr\u00ean\u00a0Excel.<\/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-406.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4919,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4918","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\/4918","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=4918"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4918\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4919"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4918"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4918"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4918"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}