{"id":9562,"date":"2025-01-02T09:58:18","date_gmt":"2025-01-02T09:58:18","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-sua-loi-ngay-thang-cua-du-lieu-duoc-trich-xuat-tu-phan-mem-ra-excel\/"},"modified":"2025-01-02T09:58:18","modified_gmt":"2025-01-02T09:58:18","slug":"huong-dan-cach-sua-loi-ngay-thang-cua-du-lieu-duoc-trich-xuat-tu-phan-mem-ra-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-sua-loi-ngay-thang-cua-du-lieu-duoc-trich-xuat-tu-phan-mem-ra-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eeda l\u1ed7i ng\u00e0y th\u00e1ng c\u1ee7a d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c tr\u00edch xu\u1ea5t t\u1eeb ph\u1ea7n m\u1ec1m ra excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Khi tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb c\u00e1c ph\u1ea7n m\u1ec1m kh\u00e1c (v\u00ed d\u1ee5 nh\u01b0 ph\u1ea7n m\u1ec1m ch\u1ea5m c\u00f4ng) ra\u00a0excel, ch\u00fang ta th\u01b0\u1eddng g\u1eb7p ph\u1ea3i 1 v\u1ea5n\u00a0\u0111\u1ec1\u00a0\u0111\u00f3 l\u00e0 d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng, th\u1eddi gian th\u01b0\u1eddng\u00a0b\u1ecb l\u1ed7i, kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng\u00a0\u0111\u1ec3 t\u00ednh to\u00e1n ngay. Trong b\u00e0i vi\u1ebft n\u00e0y H\u1ecdc\u00a0Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch\u00a0s\u1eeda l\u1ed7i ng\u00e0y th\u00e1ng c\u1ee7a d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c tr\u00edch xu\u1ea5t t\u1eeb ph\u1ea7n m\u1ec1m ra excel.<\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i file m\u1eabu v\u00ed d\u1ee5 t\u1ea1i\u00a0\u0111\u00e2y:\u00a0<a href=\"http:\/\/bit.ly\/2PVCpDv\">http:\/\/bit.ly\/2PVCpDv<\/a><\/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-6776633968437\" 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-sua-loi-ngay-thang-cua-du-lieu-duoc-trich-xuat-tu-phan-mem-ra-excel.html#Dac_diem_du_lieu_thoi_gian_trich_xuat_tu_phan_mem\" title=\"\u0110\u1eb7c\u00a0\u0111i\u1ec3m d\u1eef li\u1ec7u th\u1eddi gian tr\u00edch xu\u1ea5t t\u1eeb ph\u1ea7n m\u1ec1m\">\u0110\u1eb7c\u00a0\u0111i\u1ec3m d\u1eef li\u1ec7u th\u1eddi gian tr\u00edch xu\u1ea5t t\u1eeb ph\u1ea7n m\u1ec1m<\/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-sua-loi-ngay-thang-cua-du-lieu-duoc-trich-xuat-tu-phan-mem-ra-excel.html#Cach_sua_loi_dinh_dang_thoi_gian\" title=\"C\u00e1ch s\u1eeda l\u1ed7i\u00a0\u0111\u1ecbnh d\u1ea1ng th\u1eddi gian\">C\u00e1ch s\u1eeda l\u1ed7i\u00a0\u0111\u1ecbnh d\u1ea1ng th\u1eddi gian<\/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-sua-loi-ngay-thang-cua-du-lieu-duoc-trich-xuat-tu-phan-mem-ra-excel.html#Cach_1_Dung_ham_VALUE\" title=\"C\u00e1ch 1: D\u00f9ng h\u00e0m VALUE\">C\u00e1ch 1: D\u00f9ng h\u00e0m VALUE<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-sua-loi-ngay-thang-cua-du-lieu-duoc-trich-xuat-tu-phan-mem-ra-excel.html#Cach_2_Dung_cong_cu_TextToColumn\" title=\"C\u00e1ch 2: D\u00f9ng c\u00f4ng c\u1ee5 TextToColumn\">C\u00e1ch 2: D\u00f9ng c\u00f4ng c\u1ee5 TextToColumn<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-sua-loi-ngay-thang-cua-du-lieu-duoc-trich-xuat-tu-phan-mem-ra-excel.html#Chu_y\" title=\"Ch\u00fa\u00a0\u00fd\">Ch\u00fa\u00a0\u00fd<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Dac_diem_du_lieu_thoi_gian_trich_xuat_tu_phan_mem\"><\/span>\u0110\u1eb7c\u00a0\u0111i\u1ec3m d\u1eef li\u1ec7u th\u1eddi gian tr\u00edch xu\u1ea5t t\u1eeb ph\u1ea7n m\u1ec1m<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong file v\u00ed d\u1ee5 ch\u00fang ta c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c tr\u00edch xu\u1ea5t t\u1eeb ph\u1ea7n m\u1ec1m ch\u1ea5m c\u00f4ng nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23978\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/data-trich-xuat-tu-pm-ra-excel.png\" width=\"620\" height=\"330\" title=\"data-trich-xuat-tu-pm-ra-excel\"><\/p>\n<p>Trong\u00a0\u0111\u00f3 c\u00e1c c\u1ed9t <strong>Date<\/strong> v\u00e0 <strong>InTime<\/strong> l\u00e0 d\u1eef li\u1ec7u d\u1ea1ng <strong>Ng\u00e0y<\/strong> v\u00e0 <strong>Gi\u1edd<\/strong>. Tuy nhi\u00ean nh\u1eefng d\u1eef li\u1ec7u n\u00e0y l\u1ea1i kh\u00f4ng d\u00f9ng\u00a0\u0111\u1ec3 t\u00ednh to\u00e1n ngay\u00a0\u0111\u01b0\u1ee3c v\u00ec n\u00f3 kh\u00f4ng ph\u1ea3i d\u1eef li\u1ec7u\u00a0\u0111\u00fang chu\u1ea9n d\u1ea1ng th\u1eddi gian m\u00e0\u00a0Excel quy\u00a0\u0111\u1ecbnh.<\/p>\n<p>Ch\u00fang ta c\u00f3 th\u1ec3 ki\u1ec3m tra b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m\u00a0IsNumber cho c\u1ed9t\u00a0B v\u00e0\u00a0C nh\u01b0 sau:<\/p>\n<p>T\u1ea1i \u00f4 E2 nh\u1eadp c\u00f4ng th\u1ee9c =ISNUMBER(B2) =&gt; K\u1ebft qu\u1ea3 l\u00e0 FALSE<\/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-66.gif\" title=\"ex101_92019-nho-66\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Nh\u01b0 v\u1eady v\u1ec1 b\u1ea3n ch\u1ea5t d\u1eef li\u1ec7u trong\u00a0\u00f4 B2 l\u00e0 Text ch\u1ee9 kh\u00f4ng ph\u1ea3i Number. Do\u00a0\u0111\u00f3 kh\u00f4ng d\u00f9ng trong t\u00ednh to\u00e1n\u00a0\u0111\u01b0\u1ee3c.<\/p>\n<p>=&gt;\u00a0<strong>\u0110\u1eb7c\u00a0\u0111i\u1ec3m c\u1ee7a d\u1eef li\u1ec7u th\u1eddi gian tr\u00edch xu\u1ea5t t\u1eeb ph\u1ea7n m\u1ec1m kh\u00e1c ra\u00a0Excel th\u01b0\u1eddng\u00a0\u1edf d\u1ea1ng TEXT<\/strong>.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_sua_loi_dinh_dang_thoi_gian\"><\/span>C\u00e1ch s\u1eeda l\u1ed7i\u00a0\u0111\u1ecbnh d\u1ea1ng th\u1eddi gian<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Cach_1_Dung_ham_VALUE\"><\/span><strong>C\u00e1ch 1: D\u00f9ng h\u00e0m VALUE<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/su-dung-ham-value-va-cac-tuy-chon-khac-de-chuyen-doi-dinh-dang-cua-tu-text-sang-number.html\">H\u00e0m VALUE<\/a> gi\u00fap chuy\u1ec3n d\u1eef li\u1ec7u t\u1eeb d\u1ea1ng Text v\u1ec1 d\u1ea1ng Number. V\u1ec1 b\u1ea3n ch\u1ea5t, d\u1eef li\u1ec7u th\u1eddi gian trong\u00a0Excel l\u00e0 d\u1ea1ng Number.<\/p>\n<p>C\u00e1ch l\u00e0m nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: T\u1ea1i c\u1ed9t E (c\u1ed9t ph\u1ee5), ch\u00fang ta d\u00f9ng h\u00e0m VALUE,\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng c\u1ee7a h\u00e0m VALUE l\u00e0 gi\u00e1 tr\u1ecb trong c\u1ed9t B<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23979\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-value-chuyen-du-lieu-dang-number.png\" width=\"549\" height=\"330\" title=\"ham-value-chuyen-du-lieu-dang-number\"><\/p>\n<p>V\u00ed d\u1ee5: E2=VALUE(B2)<\/p>\n<p>K\u1ebft qu\u1ea3 c\u1ee7a\u00a0\u0111o\u1ea1n text 1\/Jun\/2018 khi chuy\u1ec3n sang Number c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 43252<\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: Copy k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m Value, d\u00e1n tr\u1edf l\u1ea1i v\u00e0o c\u1ed9t B<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23980\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/copy-paste-ket-qua-ham-value.png\" width=\"549\" height=\"374\" title=\"copy-paste-ket-qua-ham-value\"><\/p>\n<p><strong>B\u01b0\u1edbc 3<\/strong>:\u00a0\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u b\u1eb1ng Format cells<\/p>\n<p>Ch\u00fang ta s\u1ebd\u00a0\u0111\u1ecbnh d\u1ea1ng l\u1ea1i d\u1eef li\u1ec7u trong c\u1ed9t B\u00a0\u0111\u1ec3\u00a0\u0111\u01b0a v\u1ec1\u00a0\u0111\u00fang\u00a0\u0111\u1ecbnh d\u1ea1ng\u00a0dd\/mm\/yyyy b\u1eb1ng c\u00e1ch:<\/p>\n<ul>\n<li>Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u trong c\u1ed9t B<\/li>\n<li>M\u1edf Format Cells (ph\u00edm t\u1eaft Ctrl + 1)<\/li>\n<li>Trong th\u1ebb Number ch\u1ecdn Custome, trong m\u1ee5c Type nh\u1eadp\u00a0dd\/mm\/yyyy<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23981\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/dinh-dang-du-lieu-ve-dang-date.png\" width=\"926\" height=\"405\" title=\"dinh-dang-du-lieu-ve-dang-date\"><\/p>\n<p>Nh\u01b0 v\u1eady k\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c s\u1ebd l\u00e0 d\u1eef li\u1ec7u d\u1ea1ng th\u1eddi gian c\u00f3 d\u1ea1ng ng\u00e0y\/th\u00e1ng\/n\u0103m\u00a0\u0111\u00fang ti\u00eau chu\u1ea9n c\u1ee7a\u00a0Excel.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_2_Dung_cong_cu_TextToColumn\"><\/span>C\u00e1ch 2: D\u00f9ng c\u00f4ng c\u1ee5 TextToColumn<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>TextToColumn l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 kh\u00e1 h\u1eefu\u00a0\u00edch trong\u00a0Excel. Ngo\u00e0i vi\u1ec7c t\u00e1ch d\u1eef li\u1ec7u ra nhi\u1ec1u c\u1ed9t th\u00ec n\u00f3 c\u00f2n c\u00f3 t\u00e1c d\u1ee5ng chuy\u1ec3n\u00a0\u0111\u1ed5i d\u1eef li\u1ec7u v\u1ec1\u00a0\u0111\u00fang\u00a0\u0111\u1ecbnh d\u1ea1ng ti\u00eau chu\u1ea9n trong Excel. C\u00e1ch th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: Ch\u1ecdn b\u1ea3ng d\u1eef li\u1ec7u c\u1ea7n chuy\u1ec3n\u00a0\u0111\u1ed5i, trong th\u1ebb Data ch\u1ecdn TextToColumn<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23982\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/text-to-column-buoc-1.png\" width=\"1130\" height=\"700\" title=\"text-to-column-buoc-1\"><\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: Trong c\u1eeda s\u1ed5 TextToColumn (step 1\u00a0of 3)\u00a0b\u1ea5m Next\u00a0\u0111\u1ec3 sang Step 2\u00a0of 3<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23983\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/text-to-column-buoc-2.png\" width=\"753\" height=\"538\" title=\"text-to-column-buoc-2\"><\/p>\n<p><strong>B\u01b0\u1edbc 3<\/strong>: B\u1ea5m Next m\u1ed9t l\u1ea7n n\u1eefa\u00a0\u0111\u1ec3 sang Step\u00a03 of 3<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23984\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/text-to-column-buoc-3.png\" width=\"755\" height=\"538\" title=\"text-to-column-buoc-3\"><\/p>\n<p>T\u1ea1i b\u01b0\u1edbc n\u00e0y, ch\u00fang ta b\u1ea5m ch\u1ecdn m\u1ee5c Date v\u00e0 ch\u1ecdn t\u01b0\u01a1ng\u00a0\u1ee9ng c\u00e1ch hi\u1ec3n th\u1ecb th\u1eddi gian theo d\u1ea1ng DMY (D l\u00e0 ng\u00e0y, M l\u00e0 th\u00e1ng, Y l\u00e0 n\u0103m)<\/p>\n<p>Sau\u00a0\u0111\u00f3 b\u1ea5m Finish\u00a0\u0111\u1ec3 ho\u00e0n th\u00e0nh.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Chu_y\"><\/span>Ch\u00fa\u00a0\u00fd<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>C\u1ea3 2 c\u00e1ch\u00a0\u0111\u1ec1u\u00a0\u00e1p d\u1ee5ng\u00a0\u0111\u01b0\u1ee3c cho d\u1eef li\u1ec7u Ng\u00e0y, Gi\u1edd<\/li>\n<li>C\u00e1ch d\u00f9ng h\u00e0m VALUE s\u1ebd tu\u00e2n th\u1ee7 theo thi\u1ebft l\u1eadp ng\u00e0y th\u00e1ng m\u1eb7c\u00a0\u0111\u1ecbnh trong Region c\u1ee7a m\u00e1y t\u00ednh (Control pannel\/ Region\/ Date-Time)<\/li>\n<li>C\u00e1ch d\u00f9ng TextToColumn cho ph\u00e9p t\u1ef1 do l\u1ef1a ch\u1ecdn c\u00e1ch hi\u1ec3n th\u1ecb Th\u00e1ng tr\u01b0\u1edbc Ng\u00e0y sau hay Ng\u00e0y tr\u01b0\u1edbc th\u00e1ng sau m\u1ed9t c\u00e1ch linh ho\u1ea1t h\u01a1n. K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 ngay t\u1ea1i v\u1ecb tr\u00ed ban\u00a0\u0111\u1ea7u, kh\u00f4ng c\u1ea7n copy\/paste nh\u01b0 c\u00e1ch d\u00f9ng h\u00e0m VALUE<\/li>\n<\/ul>\n<p>T\u00ecm hi\u1ec3u th\u00eam c\u00e1c n\u1ed9i dung t\u01b0\u01a1ng t\u1ef1:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-chuyen-so-thanh-chu-trong-excel.html\">H\u01b0\u1edbng d\u1eabn chuy\u1ec3n ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u t\u1eeb s\u1ed1 (Number) sang ch\u1eef (Text) trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/chuyen-tu-ngay-thang-date-ve-dinh-dang-number-hoac-chu-text.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng (Date) v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 (Number) ho\u1eb7c ch\u1eef (Text) trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/su-dung-ham-value-va-cac-tuy-chon-khac-de-chuyen-doi-dinh-dang-cua-tu-text-sang-number.html\">S\u1eed d\u1ee5ng h\u00e0m VALUE v\u00e0 c\u00e1c t\u00f9y ch\u1ecdn kh\u00e1c \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng c\u1ee7a s\u1ed1 t\u1eeb text sang number<\/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-66.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9563,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9562","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\/9562","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=9562"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9562\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9563"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9562"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9562"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9562"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}