{"id":2490,"date":"2024-12-02T07:57:13","date_gmt":"2024-12-02T07:57:13","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-loc-du-lieu-sang-sheet-khac-bang-advanced-filter-trong-excel\/"},"modified":"2024-12-02T07:57:13","modified_gmt":"2024-12-02T07:57:13","slug":"huong-dan-cach-loc-du-lieu-sang-sheet-khac-bang-advanced-filter-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-loc-du-lieu-sang-sheet-khac-bang-advanced-filter-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u sang sheet kh\u00e1c b\u1eb1ng Advanced Filter trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id=\"c\u00e1ch-l\u1ecdc-d\u1eef-li\u1ec7u-t\u1eeb-sheet-n\u00e0y-qua-sheet-kh\u00e1c-theo-\u0111i\u1ec1u-ki\u1ec7n\" cite=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-loc-du-lieu-sang-sheet-khac-bang-advanced-filter-trong-excel.html?cach-loc-du-lieu-tu-sheet-nay-qua-sheet-khac-theod-dieu-kien\">\n<p>Vi\u1ec7c l\u1ecdc d\u1eef li\u1ec7u t\u1eeb sheet n\u00e0y sang sheet kh\u00e1c l\u00e0 m\u1ed9t vi\u1ec7c th\u01b0\u1eddng\u00a0g\u1eb7p ph\u1ea3i trong c\u00f4ng vi\u1ec7c. Vi\u1ec7c n\u00e0y ch\u00ednh l\u00e0 vi\u1ec7c l\u1eadp b\u00e1o c\u00e1o chi ti\u1ebft d\u1ef1a v\u00e0o m\u1ed9t s\u1ed1\u00a0\u0111i\u1ec1u ki\u1ec7n l\u1eadp b\u00e1o c\u00e1o. M\u1ee5c\u00a0\u0111\u00edch l\u00e0 l\u1ea5y nh\u1eefng n\u1ed9i dung th\u1ecfa m\u00e3n\u00a0\u0111i\u1ec1u ki\u1ec7n trong b\u1ea3ng d\u1eef li\u1ec7u (n\u1eb1m tr\u00ean 1 sheet ri\u00eang)\u00a0\u0111\u01b0a sang b\u00e1o c\u00e1o chi ti\u1ebft (n\u1eb1m tr\u00ean 1 sheet ri\u00eang). Trong\u00a0Excel vi\u1ec7c n\u00e0y\u00a0\u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n m\u1ed9t c\u00e1ch kh\u00e1\u00a0\u0111\u01a1n gi\u1ea3n v\u1edbi c\u00f4ng c\u1ee5 Advanced Filter (b\u1ed9 l\u1ecdc n\u00e2ng cao). Sau\u00a0\u0111\u00e2y ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u <strong>c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u sang sheet kh\u00e1c b\u1eb1ng Advanced Filter trong\u00a0Excel<\/strong> nh\u00e9:<\/p>\n<\/blockquote>\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-674d68591409b\" 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-loc-du-lieu-sang-sheet-khac-bang-advanced-filter-trong-excel.html#1_Gioi_thieu_ve_cong_cu_Advanced_Filter\" title=\"1. Gi\u1edbi thi\u1ec7u v\u1ec1 c\u00f4ng c\u1ee5 Advanced Filter\">1. Gi\u1edbi thi\u1ec7u v\u1ec1 c\u00f4ng c\u1ee5 Advanced Filter<\/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\/huong-dan-cach-loc-du-lieu-sang-sheet-khac-bang-advanced-filter-trong-excel.html#a_Mo_cong_cu_Advenced_Filter\" title=\"a.\u00a0M\u1edf c\u00f4ng c\u1ee5 Advenced Filter\">a.\u00a0M\u1edf c\u00f4ng c\u1ee5 Advenced Filter<\/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\/huong-dan-cach-loc-du-lieu-sang-sheet-khac-bang-advanced-filter-trong-excel.html#b_Chu_y\" title=\"b. Ch\u00fa\u00a0\u00fd\">b. Ch\u00fa\u00a0\u00fd<\/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-loc-du-lieu-sang-sheet-khac-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><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-loc-du-lieu-sang-sheet-khac-bang-advanced-filter-trong-excel.html#3_Cach_thiet_lap_dieu_kien_trong_Advanced_Filter\" title=\"3. C\u00e1ch thi\u1ebft l\u1eadp\u00a0\u0111i\u1ec1u ki\u1ec7n trong Advanced Filter\">3. C\u00e1ch thi\u1ebft l\u1eadp\u00a0\u0111i\u1ec1u ki\u1ec7n trong Advanced Filter<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"1_Gioi_thieu_ve_cong_cu_Advanced_Filter\"><\/span>1. Gi\u1edbi thi\u1ec7u v\u1ec1 c\u00f4ng c\u1ee5 Advanced Filter<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"a_Mo_cong_cu_Advenced_Filter\"><\/span>a.\u00a0M\u1edf c\u00f4ng c\u1ee5 Advenced Filter<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong th\u1ebb <strong>Data<\/strong> &gt; Ch\u1ecdn <strong>Advanced Filter<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17315\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-advancedfilter-02.png\" width=\"500\" height=\"157\" title=\"heo-advancedfilter-02\"><\/p>\n<p>H\u1ed9p tho\u1ea1i Advanced Filter nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17316\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-advancedfilter-01.png\" width=\"315\" height=\"306\" title=\"heo-advancedfilter-01\"><\/p>\n<p>Trong\u00a0\u0111\u00f3<\/p>\n<ul>\n<li>Action\/ <strong>Filter the list, in-place<\/strong>: L\u1ecdc t\u1ea1i ch\u00ednh danh s\u00e1ch g\u1ed1c<\/li>\n<li>Action\/\u00a0<strong>Copy to another location<\/strong>: Sao ch\u00e9p k\u1ebft qu\u1ea3 l\u1ecdc\u00a0\u0111\u01b0\u1ee3c sang v\u1ecb tr\u00ed kh\u00e1c<\/li>\n<li><strong>List range<\/strong>: V\u00f9ng d\u1eef li\u1ec7u c\u1ea7n l\u1ecdc<\/li>\n<li><strong>Criteria range<\/strong>: V\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n l\u1ecdc<\/li>\n<li><strong>Copy to<\/strong>: N\u01a1i\u00a0\u0111\u1eb7t k\u1ebft qu\u1ea3 l\u1ecdc (khi ch\u1ecdn sao ch\u00e9p k\u1ebft qu\u1ea3 sang v\u1ecb tr\u00ed kh\u00e1c)<\/li>\n<li><strong>Unique records only<\/strong>: Ch\u1ec9 l\u1ea5y c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng nhau (xu\u1ea5t hi\u1ec7n 1 l\u1ea7n)<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"b_Chu_y\"><\/span>b. Ch\u00fa\u00a0\u00fd<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>Nh\u01b0 v\u1eady mu\u1ed1n l\u1ecdc d\u1eef li\u1ec7u t\u1eeb sheet n\u00e0y sang sheet kh\u00e1c ch\u00fang ta <strong>b\u1eaft bu\u1ed9c ph\u1ea3i ch\u1ecdn Copy to another location<\/strong> khi th\u1ef1c hi\u1ec7n Advanced Filter.<\/li>\n<li><strong>N\u01a1i\u00a0\u0111\u1eb7t k\u1ebft qu\u1ea3 l\u1ecdc (copy to) ph\u1ea3i t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi sheet ch\u1ee9a v\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n (criteria range), t\u1ee9c l\u00e0 trong c\u00f9ng 1 sheet.<\/strong><\/li>\n<\/ul>\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>X\u00e9t v\u00ed d\u1ee5 sau:<\/p>\n<p>Cho b\u1ea3ng d\u1eef li\u1ec7u t\u1ea1i sheet Data g\u1ed3m:<\/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-193.gif\" title=\"ex101_92019-nho-193\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17317\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-advancedfilter-data.png\" width=\"504\" height=\"366\" title=\"heo-advancedfilter-data\"><\/p>\n<p>Y\u00eau c\u1ea7u: L\u1ecdc d\u1eef li\u1ec7u b\u00e1n h\u00e0ng c\u1ee7a nh\u00e2n vi\u00ean Trang sang Sheet m\u1edbi<\/p>\n<ul>\n<li><strong>B\u01b0\u1edbc 1<\/strong>: T\u1ea1o m\u1edbi 1 sheet, l\u1ea5y t\u00ean l\u00e0 \u201cReport01\u201d<\/li>\n<li><strong>B\u01b0\u1edbc 2<\/strong>: Thi\u1ebft l\u1eadp\u00a0\u0111i\u1ec1u ki\u1ec7n nh\u01b0 sau<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17318\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-advancedfilter-criteria01.png\" width=\"150\" height=\"80\" title=\"heo-advancedfilter-criteria01\"><\/p>\n<ul>\n<li><strong>B\u01b0\u1edbc 3<\/strong>: Th\u1ef1c hi\u1ec7n l\u1ecdc b\u1eb1ng c\u00f4ng c\u1ee5 Advanced Filter nh\u01b0 sau<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17319\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-advancedfilter-creat.png\" width=\"462\" height=\"334\" title=\"heo-advancedfilter-creat\"><\/p>\n<p style=\"padding-left: 60px\"><strong>List range: <\/strong>T\u1ea1i sheet Data, v\u00f9ng A1:D11 (Xem\u00a0\u1edf\u00a0\u0111\u1ec1 b\u00e0i)<\/p>\n<p style=\"padding-left: 60px\"><strong>Criteria range<\/strong>: T\u1ea1i sheet Report01, v\u00f9ng A1:A2<\/p>\n<p style=\"padding-left: 60px\"><strong>Copy to<\/strong>: V\u1ecb tr\u00ed\u00a0\u0111\u1eb7t k\u1ebft qu\u1ea3 t\u1ea1i Sheet Report01,\u00a0\u00f4 A4<\/p>\n<p>K\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c t\u1ea1i Report01<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17320\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-advancedfilter-ket-qua.png\" width=\"416\" height=\"220\" title=\"heo-advancedfilter-ket-qua\"><\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 l\u1ea5y\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u1ecdc d\u1eef li\u1ec7u t\u1eeb sheet Data\u00a0\u0111\u1ec3\u00a0\u0111\u01b0a sang sheet Report b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng Advanced Filter.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"3_Cach_thiet_lap_dieu_kien_trong_Advanced_Filter\"><\/span>3. C\u00e1ch thi\u1ebft l\u1eadp\u00a0\u0111i\u1ec1u ki\u1ec7n trong Advanced Filter<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n trong Advanced Filter b\u1eaft bu\u1ed9c ph\u1ea3i tu\u00e2n theo nguy\u00ean t\u1eafc sau:<\/p>\n<ul>\n<li>Bao g\u1ed3m t\u00ean ti\u00eau\u00a0\u0111\u1ec1 c\u1ee7a tr\u01b0\u1eddng d\u1eef li\u1ec7u c\u00f3 li\u00ean quan + n\u1ed9i dung\u00a0\u0111i\u1ec1u ki\u1ec7n trong tr\u01b0\u1eddng\u00a0\u0111\u00f3<\/li>\n<li>M\u1ed1i quan h\u1ec7 gi\u1eefa c\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n\u00a0\u0111\u01b0\u1ee3c vi\u1ebft nh\u01b0 sau:<\/li>\n<\/ul>\n<p><strong>M\u1ed1i quan h\u1ec7 ph\u1ee5 thu\u1ed9c \/\u00a0\u0110i\u1ec1u ki\u1ec7n d\u1ea1ng V\u00e0<\/strong>: T\u1ea5t c\u1ea3 c\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n\u00a0\u0111\u1ec1u th\u1ecfa m\u00e3n<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17321\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-advancedfilter-dieukien-and.png\" width=\"484\" height=\"71\" title=\"heo-advancedfilter-dieukien-and\"><\/p>\n<ul>\n<li>M\u1ed7i\u00a0\u0111i\u1ec1u ki\u1ec7n s\u1ebd k\u00e8m theo 1 ti\u00eau\u00a0\u0111\u1ec1. N\u1ebfu trong c\u00f9ng 1 c\u1ed9t ti\u00eau\u00a0\u0111\u1ec1 th\u00ec l\u1eb7p l\u1ea1i c\u1ed9t ti\u00eau\u00a0\u0111\u1ec1\u00a0\u0111\u00f3.<\/li>\n<li>C\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u1eb7t tr\u00ean c\u00f9ng 1 h\u00e0ng<\/li>\n<\/ul>\n<p><strong>M\u1ed1i quan h\u1ec7 b\u1ed5 sung \/\u00a0\u0110i\u1ec1u ki\u1ec7n d\u1ea1ng Ho\u1eb7c<\/strong>: Ch\u1ec9 c\u1ea7n 1 trong nh\u1eefng\u00a0\u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c th\u1ecfa m\u00e3n<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17322\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-advancedfilter-dieukien-or.png\" width=\"483\" height=\"138\" title=\"heo-advancedfilter-dieukien-or\"><\/p>\n<ul>\n<li>M\u1ed7i\u00a0\u0111i\u1ec1u ki\u1ec7n s\u1ebd k\u00e9m theo 1 ti\u00eau\u00a0\u0111\u1ec1. N\u1ebfu trong c\u00f9ng 1 c\u1ed9t ti\u00eau\u00a0\u0111\u1ec1 th\u00ec\u00a0\u0111\u1eb7t\u00a0\u1edf d\u00f2ng ph\u00eda d\u01b0\u1edbi tr\u00ean c\u00f9ng c\u1ed9t ti\u00eau\u00a0\u0111\u1ec1\u00a0\u0111\u00f3<\/li>\n<li>C\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u1eb7t so le nhau, kh\u00f4ng n\u1eb1m c\u00f9ng 1 h\u00e0ng.<\/li>\n<\/ul>\n<p>Tr\u00ean\u00a0\u0111\u00e2y l\u00e0 nh\u1eefng n\u1ed9i dung ch\u00ednh v\u1ec1 vi\u1ec7c s\u1eed d\u1ee5ng Advanced Filter trong\u00a0Excel\u00a0\u0111\u1ec3 l\u1ecdc \/ tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb sheet n\u00e0y sang sheet kh\u00e1c. Vi\u1ec7c s\u1eed d\u1ee5ng Advanced Filter kh\u00e1\u00a0\u0111\u01a1n gi\u1ea3n, ch\u1ec9 c\u1ea7n ch\u00fa\u00a0\u00fd v\u1ec1 c\u00e1ch x\u00e2y d\u1ef1ng v\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n v\u00e0 v\u1ecb tr\u00ed\u00a0\u0111\u1eb7t v\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n.<\/p>\n<p>Ngo\u00e0i ra H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><strong>Kh\u00f3a h\u1ecdc Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi \u0111i l\u00e0m [\u0110\u0103ng k\u00fd]<\/strong><\/a>.\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<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-193.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2491,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2490","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\/2490","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=2490"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2490\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2491"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2490"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2490"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2490"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}