{"id":3536,"date":"2024-12-03T02:52:28","date_gmt":"2024-12-03T02:52:28","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-ky-thuat-loai-bo-gia-tri-trung-lap-trong-danh-sach-excel\/"},"modified":"2024-12-03T02:52:28","modified_gmt":"2024-12-03T02:52:28","slug":"huong-dan-ky-thuat-loai-bo-gia-tri-trung-lap-trong-danh-sach-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-ky-thuat-loai-bo-gia-tri-trung-lap-trong-danh-sach-excel\/","title":{"rendered":"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"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id=\"b\u1ecf-loc-trung-trong-excel\" cite=\"https:\/\/blog.hocexcel.online\/huong-dan-ky-thuat-loai-bo-gia-tri-trung-lap-trong-danh-sach-excel.html?bo-loc-trung-trong-excel\">\n<p>Nh\u1eb1m gi\u00fap c\u00e1c b\u1ea1n h\u00ecnh th\u00e0nh t\u01b0 duy t\u1ed1t trong vi\u1ec7c t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u v\u00e0 l\u1eadp b\u00e1o c\u00e1o tr\u00ean\u00a0Excel,<a href=\"http:\/\/blog.ezworkapp.com\/\"><strong> Blog H\u1ecdc Excel Online<\/strong><\/a> xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n seri b\u00e0i vi\u1ebft v\u1ec1 \u201cK\u1ef9 n\u0103ng t\u1ed5 ch\u1ee9c, qu\u1ea3n l\u00fd d\u1eef li\u1ec7u v\u00e0 l\u1eadp b\u00e1o c\u00e1o tr\u00ean\u00a0Excel\u201d. B\u00e0i vi\u1ebft c\u1ee7a t\u00e1c gi\u1ea3 D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n \u2013 Gi\u1ea3ng vi\u00ean c\u1ee7a H\u1ecdc\u00a0Excel Online, d\u1ef1a tr\u00ean nh\u1eefng kinh nghi\u1ec7m gi\u1ea3ng d\u1ea1y trong th\u1ef1c t\u1ebf c\u1ee7a th\u1ea7y li\u00ean quan t\u1edbi n\u1ed9i dung n\u00e0y. M\u1eddi c\u00e1c b\u1ea1n c\u00f9ng t\u00ecm hi\u1ec3u 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-674e726b5fa82\" 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-ky-thuat-loai-bo-gia-tri-trung-lap-trong-danh-sach-excel.html#Bai_6_Huong_dan_ky_thuat_loai_bo_gia_tri_trung_lap_trong_danh_sach\" title=\"B\u00e0i 6: 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\">B\u00e0i 6: 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<\/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-ky-thuat-loai-bo-gia-tri-trung-lap-trong-danh-sach-excel.html#1_Su_dung_cong_cu_Remove_Duplicate\" title=\"1. S\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Remove Duplicate\">1. S\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Remove Duplicate<\/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-ky-thuat-loai-bo-gia-tri-trung-lap-trong-danh-sach-excel.html#2_Su_dung_danh_sach_khong_trung_vao_bao_cao\" title=\"2. S\u1eed d\u1ee5ng danh s\u00e1ch kh\u00f4ng tr\u00f9ng v\u00e0o b\u00e1o c\u00e1o\">2. S\u1eed d\u1ee5ng danh s\u00e1ch kh\u00f4ng tr\u00f9ng v\u00e0o b\u00e1o c\u00e1o<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Bai_6_Huong_dan_ky_thuat_loai_bo_gia_tri_trung_lap_trong_danh_sach\"><\/span>B\u00e0i 6: 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<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u00e2y l\u00e0 k\u1ef9 thu\u1eadt th\u01b0\u1eddng s\u1eed d\u1ee5ng\u00a0\u0111\u1ec3 gi\u00fap ch\u00fang ta x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c danh s\u00e1ch c\u00e1c\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng c\u1ea7n b\u00e1o c\u00e1o d\u1ef1a tr\u00ean 1 b\u1ea3ng d\u1eef li\u1ec7u g\u1ed1c.\u00a0\u0110i\u1ec1u n\u00e0y d\u1ef1a tr\u00ean nguy\u00ean t\u1eafc:<\/p>\n<ul>\n<li><strong>\u0110\u1ed1i v\u1edbi B\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p:<\/strong> M\u1ed7i\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng c\u1ea7n b\u00e1o c\u00e1o s\u1ebd xu\u1ea5t hi\u1ec7n 1 l\u1ea7n tr\u00ean m\u1ed7i\u00a01 d\u00f2ng (b\u00e1o c\u00e1o 1 chi\u1ec1u) ho\u1eb7c 1 l\u1ea7n tr\u00ean m\u1ed7i 1 c\u1ed9t (b\u00e1o c\u00e1o 2 chi\u1ec1u) ho\u1eb7c theo 1 danh s\u00e1ch\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng (b\u00e1o c\u00e1o 3 chi\u1ec1u)<\/li>\n<li><strong>\u0110\u1ed1i v\u1edbi B\u00e1o c\u00e1o chi ti\u1ebft:<\/strong> X\u00e1c\u00a0\u0111\u1ecbnh danh s\u00e1ch ch\u1ecdn\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng c\u1ea7n chi ti\u1ebft. Trong danh s\u00e1ch n\u00e0y c\u00e1c\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng ch\u1ec9 xu\u1ea5t hi\u1ec7n 1 l\u1ea7n v\u00e0 kh\u00f4ng\u00a0\u0111\u01b0\u1ee3c tr\u00f9ng l\u1eb7p (gi\u1ed1ng v\u1edbi chi\u1ec1u th\u1ee9 3 trong b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p)<\/li>\n<\/ul>\n<p><strong>V\u00ed d\u1ee5:<\/strong><\/p>\n<p>D\u1ef1a v\u00e0o b\u1ea3ng qu\u1ea3n l\u00fd d\u1eef li\u1ec7u kh\u00e1ch h\u00e0ng d\u01b0\u1edbi\u00a0\u0111\u00e2y h\u00e3y l\u1eadp b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p s\u1ed1 ti\u1ec1n R\u00fat, G\u1eedi theo t\u1eebng khu v\u1ef1c<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17237\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-remove-duplicate-01.png\" width=\"531\" height=\"519\" title=\"heo-remove-duplicate-01\"><\/p>\n<p>D\u1ec5 nh\u1eadn th\u1ea5y l\u00e0\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 l\u1eadp\u00a0\u0111\u01b0\u1ee3c b\u00e1o c\u00e1o tr\u00ean, ch\u00fang ta c\u1ea7n ph\u1ea3i l\u1ecdc ra\u00a0\u0111\u01b0\u1ee3c t\u1ea1i c\u1ed9t Khu v\u1ef1c 1 danh s\u00e1ch c\u00e1c khu v\u1ef1c m\u00e0 ch\u1ec9 xu\u1ea5t hi\u1ec7n 1 l\u1ea7n.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"1_Su_dung_cong_cu_Remove_Duplicate\"><\/span>1. S\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Remove Duplicate<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u00e2y l\u00e0 c\u00f4ng c\u1ee5\u00a0\u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 s\u1eed d\u1ee5ng nh\u1ea5t\u00a0\u0111\u1ec3 l\u00e0m vi\u1ec7c n\u00e0y, tuy nhi\u00ean ch\u1ec9 c\u00f3 t\u1eeb phi\u00ean b\u1ea3n\u00a0Office 2007 tr\u1edf v\u1ec1 sau.<\/p>\n<p>C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n 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\/2024\/12\/ex101_92019-nho-273.gif\" title=\"ex101_92019-nho-273\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li><strong>B\u01b0\u1edbc 1<\/strong>: Copy d\u1eef li\u1ec7u c\u1ea7n lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng sang 1 v\u1ecb tr\u00ed b\u00ean ngo\u00e0i b\u1ea3ng t\u00ednh ban\u00a0\u0111\u1ea7u<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17241\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-remove-duplicate-02.png\" width=\"556\" height=\"412\" title=\"heo-remove-duplicate-02\"><\/p>\n<ul>\n<li><strong>B\u01b0\u1edbc 2<\/strong>: Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u v\u1eeba copy, tr\u00ean thanh c\u00f4ng c\u1ee5 ch\u1ecdn tab <strong>Data<\/strong> &gt; Ch\u1ecdn <strong>Remove Duplicates<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17209\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-data-remove-dupplicate.png\" width=\"710\" height=\"152\" title=\"heo-data-remove-dupplicate\"><\/p>\n<ul>\n<li><strong>B\u01b0\u1edbc 3<\/strong>: Trong c\u1eeda s\u1ed5 Remove Duplicates: M\u1ee5c 1 l\u00e0 v\u1ecb tr\u00ed c\u1ed9t\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn\u00a0\u0111\u1ec3 lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng. M\u1ee5c 2 l\u00e0 trong c\u1ed9t\u00a0\u0111\u00f3 c\u00f3 ch\u1ee9a d\u00f2ng ti\u00eau\u00a0\u0111\u1ec1 hay kh\u00f4ng, n\u1ebfu c\u00f3 th\u00ec\u00a0\u0111\u00e1nh d\u1ea5u ch\u1ecdn. Sau khi ho\u00e0n t\u1ea5t vi\u1ec7c x\u00e1c\u00a0\u0111\u1ecbnh th\u00f4ng tin c\u1ee7a c\u1ed9t l\u1ecdc tr\u00f9ng, b\u1ea5m ok.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17242\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-remove-duplicate-03.png\" width=\"430\" height=\"347\" title=\"heo-remove-duplicate-03\"><\/p>\n<ul>\n<li><strong>B\u01b0\u1edbc 4<\/strong>:\u00a0K\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c khi l\u1ecdc gi\u00e1 tr\u1ecb tr\u00f9ng nh\u01b0 sau:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17244\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-remove-duplicate-04.png\" width=\"634\" height=\"469\" title=\"heo-remove-duplicate-04\"><\/p>\n<p style=\"padding-left: 30px\">Excel\u00a0\u0111\u00e3 lo\u1ea1i b\u1ecf 13 gi\u00e1 tr\u1ecb tr\u00f9ng, ch\u1ec9 gi\u1eef l\u1ea1i 7 gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng.<\/p>\n<p>Nh\u01b0 v\u1eady ch\u1ec9 v\u1edbi 1 v\u00e0i thao t\u00e1c\u00a0\u0111\u01a1n gi\u1ea3n ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 lo\u1ea1i b\u1ecf\u00a0\u0111\u01b0\u1ee3c nh\u1eefng d\u1eef li\u1ec7u b\u1ecb tr\u00f9ng l\u1eb7p\u00a0trong 1 danh s\u00e1ch.<\/p>\n<p><em>(Ngo\u00e0i ra ch\u00fang ta c\u00f2n c\u00f3 th\u00eam 1 s\u1ed1 c\u00e1ch kh\u00e1c n\u1eefa\u00a0\u0111\u1ec3 lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng trong danh s\u00e1ch, m\u1eddi c\u00e1c b\u1ea1n xem th\u00eam t\u1ea1i b\u00e0i vi\u1ebft:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tong-hop-cac-phuong-phap-loai-bo-du-lieu-lap.html\">T\u1ed5ng h\u1ee3p c\u00e1c ph\u01b0\u01a1ng ph\u00e1p lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p<\/a> c\u1ee7a th\u1ea7y Nguy\u1ec5n\u00a0\u0110\u1ee9c Thanh)<\/em><\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Su_dung_danh_sach_khong_trung_vao_bao_cao\"><\/span>2. S\u1eed d\u1ee5ng danh s\u00e1ch kh\u00f4ng tr\u00f9ng v\u00e0o b\u00e1o c\u00e1o<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Sau khi\u00a0\u0111\u00e3 l\u1ea5y\u00a0\u0111\u01b0\u1ee3c danh s\u00e1ch kh\u00f4ng tr\u00f9ng, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng danh s\u00e1ch\u00a0\u0111\u00f3\u00a0\u0111\u1ec3 ph\u1ee5c v\u1ee5 cho vi\u1ec7c l\u1eadp b\u00e1o c\u00e1o. C\u00e1c d\u1ea1ng b\u00e1o c\u00e1o nh\u01b0 sau:<\/p>\n<ul>\n<li><strong>B\u00e1o c\u00e1o 1 chi\u1ec1u<\/strong>: B\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p theo khu v\u1ef1c (s\u1eed d\u1ee5ng\u00a0tr\u1ef1c ti\u1ebfp)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17249\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-remove-duplicate-05.png\" width=\"282\" height=\"174\" title=\"heo-remove-duplicate-05\"><\/p>\n<ul>\n<li><strong>B\u00e1o c\u00e1o 2 chi\u1ec1u<\/strong>: B\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p s\u1ed1 ti\u1ec1n g\u1eedi theo t\u1eebng ng\u00e0y, t\u1eebng khu v\u1ef1c (Transpose danh s\u00e1ch theo h\u00e0ng ngang + L\u1ea5y danh s\u00e1ch ng\u00e0y kh\u00f4ng tr\u00f9ng theo c\u1ed9t Ng\u00e0y)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17250\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-remove-duplicate-06.png\" width=\"789\" height=\"365\" title=\"heo-remove-duplicate-06\"><\/p>\n<ul>\n<li><strong>B\u00e1o c\u00e1o 3 chi\u1ec1u<\/strong>: B\u00e1o c\u00e1o chi ti\u1ebft theo khu v\u1ef1c\u2026 s\u1ed1 ti\u1ec1n g\u1eedi v\u00e0 r\u00fat theo t\u1eebng ng\u00e0y (S\u1eed d\u1ee5ng Data Validation \/ List\u00a0\u0111\u1ec3\u00a0\u0111\u01b0a danh s\u00e1ch kh\u00f4ng tr\u00f9ng v\u00e0o danh s\u00e1ch ch\u1ecdn\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng c\u1ee7a b\u00e1o c\u00e1o)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17251\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-remove-duplicate-07.png\" width=\"697\" height=\"367\" title=\"heo-remove-duplicate-07\"><\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 n\u1eafm\u00a0\u0111\u01b0\u1ee3c m\u1ee5c\u00a0\u0111\u00edch c\u1ee7a vi\u1ec7c lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng trong 1 danh s\u00e1ch, k\u1ef9 thu\u1eadt l\u1ecdc b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng v\u00e0\u00a0\u1ee9ng d\u1ee5ng c\u1ee7a danh s\u00e1ch kh\u00f4ng tr\u00f9ng trong vi\u1ec7c l\u1eadp b\u00e1o c\u00e1o.<\/p>\n<p>Xem th\u00eam:<strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-loc-gia-tri-trung-nhau-tren-excel-2010.html\"> C\u00e1ch l\u1ecdc t\u00ean tr\u00f9ng trong excel<\/a> <\/strong>\u2013 d\u1ec5 l\u00e0m nh\u1ea5t<\/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<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-273.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3537,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3536","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\/3536","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=3536"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3536\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3537"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3536"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3536"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3536"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}