{"id":9833,"date":"2025-01-03T14:52:14","date_gmt":"2025-01-03T14:52:14","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/03\/huong-dan-cach-lap-bao-cao-chi-tiet-tu-dong-trong-excel-moi-nhat-2019\/"},"modified":"2025-01-03T14:52:14","modified_gmt":"2025-01-03T14:52:14","slug":"huong-dan-cach-lap-bao-cao-chi-tiet-tu-dong-trong-excel-moi-nhat-2019","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/03\/huong-dan-cach-lap-bao-cao-chi-tiet-tu-dong-trong-excel-moi-nhat-2019\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp b\u00e1o c\u00e1o chi ti\u1ebft t\u1ef1 \u0111\u1ed9ng trong Excel m\u1edbi nh\u1ea5t 2019"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>L\u1ecdc c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng (hay l\u1ecdc danh s\u00e1ch kh\u00f4ng tr\u00f9ng) l\u00e0 m\u1ed9t trong nh\u1eefng k\u1ef9 thu\u1eadt th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng trong\u00a0Excel. M\u1ee5c\u00a0\u0111\u00edch c\u1ee7a vi\u1ec7c n\u00e0y l\u00e0 gi\u00fap ch\u00fang ta t\u1ea1o\u00a0\u0111\u01b0\u1ee3c\u00a0danh s\u00e1ch ch\u1ecdn\u00a0m\u1ed9t trong c\u00e1c gi\u00e1 tr\u1ecb\u00a0\u0111\u1ec3 l\u1eadp b\u00e1o c\u00e1o. M\u1ed9t v\u00ed d\u1ee5 th\u01b0\u1eddng th\u1ea5y\u00a0nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23205\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/muc-dich-loc-danh-sach-khong-trung.png\" width=\"968\" height=\"292\" title=\"muc-dich-loc-danh-sach-khong-trung\"><\/p>\n<p>T\u1eeb b\u1ea3ng k\u00ea b\u00e1n h\u00e0ng, ch\u00fang ta l\u1ecdc ra danh s\u00e1ch t\u00ean c\u00e1c m\u1eb7t h\u00e0ng kh\u00f4ng tr\u00f9ng. Sau\u00a0\u0111\u00f3 s\u1eed d\u1ee5ng danh s\u00e1ch n\u00e0y v\u00e0o trong Data Validation \/ List\u00a0\u0111\u1ec3 t\u1ea1o\u00a0\u0111\u01b0\u1ee3c danh s\u00e1ch ch\u1ecdn c\u00e1c m\u1eb7t h\u00e0ng ph\u1ee5c v\u1ee5 cho b\u00e1o c\u00e1o chi ti\u1ebft. Khi ch\u1ecdn 1 m\u1eb7t h\u00e0ng b\u1ea5t k\u1ef3 th\u00ec b\u00e1o c\u00e1o chi ti\u1ebft s\u1ebd t\u1ef1\u00a0\u0111\u1ed9ng th\u1ec3 hi\u1ec7n c\u00e1c k\u1ebft qu\u1ea3 chi ti\u1ebft t\u01b0\u01a1ng\u00a0\u1ee9ng theo m\u1eb7t h\u00e0ng\u00a0\u0111\u00f3.<\/p>\n<p>Tr\u01b0\u1edbc\u00a0\u0111\u00e2y ch\u00fang ta\u00a0\u0111\u00e3 bi\u1ebft t\u1edbi 1 v\u00e0i c\u00e1ch l\u00e0m\u00a0\u0111i\u1ec1u n\u00e0y r\u1ed3i, nh\u01b0ng trong b\u00e0i vi\u1ebft n\u00e0y H\u1ecdc\u00a0Excel Online\u00a0s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n 1 c\u00e1ch l\u00e0m ho\u00e0n to\u00e0n m\u1edbi r\u1ea5t\u00a0d\u1ec5 d\u00e0ng, nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u n\u00e0o.<\/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-6777f99e21c1b\" 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-tu-dong-trong-excel-moi-nhat-2019.html#Tu_dong_loc_danh_sach_khong_trung_bang_ham_UNIQUE\" title=\"T\u1ef1\u00a0\u0111\u1ed9ng l\u1ecdc danh s\u00e1ch kh\u00f4ng tr\u00f9ng b\u1eb1ng h\u00e0m UNIQUE\">T\u1ef1\u00a0\u0111\u1ed9ng l\u1ecdc danh s\u00e1ch kh\u00f4ng tr\u00f9ng b\u1eb1ng h\u00e0m UNIQUE<\/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-tu-dong-trong-excel-moi-nhat-2019.html#Tao_danh_sach_chon_ten_hang_voi_Data_Validation_%E2%80%93_List\" title=\"T\u1ea1o danh s\u00e1ch ch\u1ecdn t\u00ean h\u00e0ng v\u1edbi Data Validation \u2013 List\">T\u1ea1o danh s\u00e1ch ch\u1ecdn t\u00ean h\u00e0ng v\u1edbi Data Validation \u2013 List<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-lap-bao-cao-chi-tiet-tu-dong-trong-excel-moi-nhat-2019.html#Tu_dong_cap_nhat_ket_qua_bao_cao_chi_tiet_voi_ham_FILTER\" title=\"T\u1ef1\u00a0\u0111\u1ed9ng c\u1eadp nh\u1eadt k\u1ebft qu\u1ea3 b\u00e1o c\u00e1o chi ti\u1ebft v\u1edbi h\u00e0m FILTER\">T\u1ef1\u00a0\u0111\u1ed9ng c\u1eadp nh\u1eadt k\u1ebft qu\u1ea3 b\u00e1o c\u00e1o chi ti\u1ebft v\u1edbi h\u00e0m FILTER<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tu_dong_loc_danh_sach_khong_trung_bang_ham_UNIQUE\"><\/span>T\u1ef1\u00a0\u0111\u1ed9ng l\u1ecdc danh s\u00e1ch kh\u00f4ng tr\u00f9ng b\u1eb1ng h\u00e0m UNIQUE<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m UNIQUE l\u00e0 m\u1ed9t h\u00e0m m\u1edbi trong\u00a0Excel c\u1ee7a phi\u00ean b\u1ea3n\u00a0Office 365 (b\u1ea3n quy\u1ec1n c\u00f3 thu ph\u00ed t\u1eeb Microsoft). H\u00e0m n\u00e0y c\u00f3 t\u00e1c d\u1ee5ng l\u1ecdc ra danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng (xu\u1ea5t hi\u1ec7n l\u1ea7n\u00a0\u0111\u1ea7u ti\u00ean). C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m UNIQUE c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 xem th\u00eam t\u1ea1i b\u00e0i vi\u1ebft:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-unique-tu-dong-loc-danh-sach-khong-trung-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m UNIQUE t\u1ef1 \u0111\u1ed9ng l\u1ecdc danh s\u00e1ch kh\u00f4ng tr\u00f9ng trong Excel<\/a><\/p>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean, ch\u00fang ta s\u1ebd vi\u1ebft c\u00f4ng th\u1ee9c t\u1ea1i\u00a0\u00f4 F3 nh\u01b0 sau:<\/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-99.gif\" title=\"ex101_92019-nho-99\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>=UNIQUE(A3:A11)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23206\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vd-loc-danh-sach-khong-trung-unique.png\" width=\"633\" height=\"333\" title=\"vd-loc-danh-sach-khong-trung-unique\"><\/p>\n<p>K\u1ebft qu\u1ea3\u00a0Excel s\u1ebd t\u1ef1\u00a0\u0111\u1ed9ng cho ra c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng: T\u00e1o \/ L\u00ea \/ Cam m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i l\u00e0m th\u00eam b\u1ea5t c\u1ee9 thao t\u00e1c n\u00e0o.<\/p>\n<p>Th\u1eadt\u00a0\u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o? Vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m UNIQUE ti\u1ebft ki\u1ec7m r\u1ea5t nhi\u1ec1u th\u1eddi gian v\u00e0 thao t\u00e1c so v\u1edbi c\u00e1c ph\u01b0\u01a1ng ph\u00e1p c\u0169 tr\u01b0\u1edbc\u00a0\u0111\u00e2y.<\/p>\n<p>Tham kh\u1ea3o:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-ky-thuat-loai-bo-gia-tri-trung-lap-trong-danh-sach-excel.html\">H\u01b0\u1edbng d\u1eabn k\u1ef9 thu\u1eadt lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p trong danh s\u00e1ch Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/loc-danh-sach-khong-trung-bang-vba.html\">L\u1ecdc danh s\u00e1ch kh\u00f4ng tr\u00f9ng b\u1eb1ng VBA<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/tu-dong-loc-danh-sach-khong-trung-voi-advanced-filter-vba-cuc-ky-don-gian.html\">T\u1ef1 \u0111\u1ed9ng l\u1ecdc danh s\u00e1ch kh\u00f4ng tr\u00f9ng v\u1edbi Advanced Filter VBA c\u1ef1c k\u1ef3 \u0111\u01a1n gi\u1ea3n<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tao_danh_sach_chon_ten_hang_voi_Data_Validation_%E2%80%93_List\"><\/span>T\u1ea1o danh s\u00e1ch ch\u1ecdn t\u00ean h\u00e0ng v\u1edbi Data Validation \u2013 List<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Data Validation l\u00e0 ch\u1ee9c n\u0103ng gi\u00fap thi\u1ebft l\u1eadp\u00a0\u0111i\u1ec1u ki\u1ec7n nh\u1eadp d\u1eef li\u1ec7u trong 1\u00a0\u00f4. Trong ch\u1ee9c n\u0103ng n\u00e0y ch\u00fang ta c\u00f3 th\u1ec3 t\u1ea1o List, t\u1ee9c l\u00e0\u00a0ch\u1ecdn m\u1ed9t gi\u00e1 tr\u1ecb trong 1 danh s\u00e1ch cho s\u1eb5n. C\u1ee5 th\u1ec3 trong v\u00ed d\u1ee5 tr\u00ean, ch\u00fang ta c\u1ea7n t\u1ea1o danh s\u00e1ch ch\u1ecdn c\u00e1c m\u1eb7t h\u00e0ng\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c l\u1ecdc ra\u00a0\u1edf c\u1ed9t F.<\/p>\n<p>T\u1ea1i\u00a0\u00f4 I4 ch\u00fang ta l\u00e0m nh\u01b0 sau:<\/p>\n<ul>\n<li><strong>B\u01b0\u1edbc 1<\/strong>: Ch\u1ecdn th\u1ebb Data &gt; Ch\u1ecdn Data Validation<\/li>\n<li><strong>B\u01b0\u1edbc 2<\/strong>: Trong c\u1eeda s\u1ed5 Data Validation, m\u1ee5c Allow ch\u1ecdn List<\/li>\n<li><strong>B\u01b0\u1edbc 3<\/strong>: Trong Source (ngu\u1ed3n)\u00a0c\u1ee7a danh s\u00e1ch, ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m\u00a0OFFSET nh\u01b0 sau:<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\">=OFFSET($F$3,0,0,COUNTA($F$3:$F$11))<\/p>\n<p>\u00dd ngh\u0129a: L\u1ea5y danh s\u00e1ch theo v\u00f9ng t\u1eeb F3:F11, b\u1ecf qua c\u00e1c d\u00f2ng tr\u1ed1ng.<\/p>\n<p>K\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c ch\u00ednh l\u00e0 danh s\u00e1ch t\u1eeb F3:F5<\/p>\n<p>Khi d\u1eef li\u1ec7u g\u1ed1c c\u00f3 s\u1ef1 thay\u00a0\u0111\u1ed5i:\u00a0d\u00f2ng 8 thay\u00a0\u0111\u1ed5i th\u00e0nh m\u1eb7t h\u00e0ng\u00a0\u1ed4i<\/p>\n<ul>\n<li>H\u00e0m UNIQUE(A3:A11) s\u1ebd cho ra 4 k\u1ebft qu\u1ea3 t\u01b0\u01a1ng\u00a0\u1ee9ng t\u1ea1i F3:F6<\/li>\n<li>Data Validation\/List s\u1ebd t\u1ef1\u00a0\u0111\u1ed9ng thay\u00a0\u0111\u1ed5i c\u00f3 th\u00eam h\u00e0ng\u00a0\u1ed4i m\u00e0 kh\u00f4ng c\u1ea7n thay\u00a0\u0111\u1ed5i c\u00f4ng th\u1ee9c<\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23208\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/data-validation-tu-dong-cap-nhat-01.png\" width=\"890\" height=\"290\" title=\"data-validation-tu-dong-cap-nhat-01\"><\/p>\n<p>Tham kh\u1ea3o:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-data-validation-de-nhap-nhanh-du-lieu-tu-select-box.html\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Data Validation \u0111\u1ec3 nh\u1eadp nhanh d\u1eef li\u1ec7u t\u1eeb select box<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/tao-data-validation-voi-name-dong-trong-excel-voi-ham-offset-va-counta.html\">T\u1ea1o data validation v\u1edbi name \u0111\u1ed9ng trong Excel v\u1edbi h\u00e0m Offset v\u00e0 counta<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-tao-danh-sach-phu-thuoc-nhau-trong-excel-bang-vba.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ea1o danh s\u00e1ch ph\u1ee5 thu\u1ed9c nhau trong Excel b\u1eb1ng VBA<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tu_dong_cap_nhat_ket_qua_bao_cao_chi_tiet_voi_ham_FILTER\"><\/span>T\u1ef1\u00a0\u0111\u1ed9ng c\u1eadp nh\u1eadt k\u1ebft qu\u1ea3 b\u00e1o c\u00e1o chi ti\u1ebft v\u1edbi h\u00e0m FILTER<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean, b\u00e1o c\u00e1o chi ti\u1ebft g\u1ed3m 3\u00a0\u0111i\u1ec1u ki\u1ec7n:<\/p>\n<ul>\n<li>Ch\u1ec9 x\u00e9t nh\u1eefng d\u1eef li\u1ec7u ph\u00e1t sinh t\u1eeb ng\u00e0y 01\/08\/2018<\/li>\n<li>Ch\u1ec9 x\u00e9t nh\u1eefng d\u1eef li\u1ec7u ph\u00e1t sinh\u00a0\u0111\u1ebfn ng\u00e0y 31\/08\/2018<\/li>\n<li>Ch\u1ec9 x\u00e9t nh\u1eefng d\u1eef li\u1ec7u ph\u00e1t sinh v\u1edbi t\u00ean h\u00e0ng\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn (v\u00ed d\u1ee5 ch\u1ecdn m\u1eb7t h\u00e0ng Cam)<\/li>\n<\/ul>\n<p>Ba\u00a0\u0111i\u1ec1u ki\u1ec7n tr\u00ean x\u1ea3y ra\u00a0\u0111\u1ed3ng th\u1eddi. Do\u00a0\u0111\u00f3 ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m FILTER\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p>T\u1ea1i\u00a0\u00f4 H7 nh\u1eadp c\u00f4ng th\u1ee9c:<\/p>\n<p style=\"padding-left: 30px\">=FILTER(B3:D11,($B$3:$B$11&gt;=$I$2)*($B$3:$B$11&lt;=$I$3)*($A$3:$A$11=$I$4),\u201d\u201d)<\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>B3:D11 l\u00e0 v\u00f9ng b\u1ea3ng d\u1eef li\u1ec7u chi ti\u1ebft<\/li>\n<li>($B$3:$B$11&gt;=$I$2)*($B$3:$B$11&lt;=$I$3)*($A$3:$A$11=$I$4): x\u00e9t 3\u00a0\u0111i\u1ec1u ki\u1ec7n t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi 3 v\u00f9ng d\u1eef li\u1ec7u trong b\u1ea3ng d\u1eef li\u1ec7u, c\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n x\u1ea3y ra\u00a0\u0111\u1ed3ng th\u1eddi n\u00ean d\u00f9ng d\u1ea5u *\u00a0\u0111\u1ec3 nh\u00e2n c\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n v\u1edbi nhau.<\/li>\n<li>\u201c\u201d l\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb r\u1ed7ng khi kh\u00f4ng c\u00f3 n\u1ed9i dung th\u1ecfa m\u00e3n\u00a0\u0111i\u1ec1u ki\u1ec7n (kh\u00f4ng c\u00f3 k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23210\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ket-qua-bcct-bang-ham-filter.png\" width=\"1049\" height=\"335\" title=\"ket-qua-bcct-bang-ham-filter\"><\/p>\n<p>Nh\u01b0 v\u1eady ch\u1ec9 v\u1edbi 2 h\u00e0m UNIQUE v\u00e0 FILTER, ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 l\u00e0m b\u00e1o c\u00e1o chi ti\u1ebft t\u1ef1\u00a0\u0111\u1ed9ng trong\u00a0Excel\u00a0\u0111\u01b0\u1ee3c r\u1ed3i. V\u1edbi ph\u01b0\u01a1ng ph\u00e1p n\u00e0y, m\u1ecdi th\u1ee9 tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n r\u1ea5t nhi\u1ec1u ph\u1ea3i kh\u00f4ng n\u00e0o.<\/p>\n<p>Tham kh\u1ea3o:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-filter-trong-excel-office-365.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FILTER trong Excel Office 365<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-lap-bao-cao-chi-tiet-tu-dong-voi-ham-filter-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp b\u00e1o c\u00e1o chi ti\u1ebft t\u1ef1 \u0111\u1ed9ng v\u1edbi h\u00e0m Filter trong Excel<\/a><\/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-99.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9834,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9833","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\/9833","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=9833"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9833\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9834"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9833"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9833"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9833"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}