{"id":3944,"date":"2024-12-04T08:26:21","date_gmt":"2024-12-04T08:26:21","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/tach-ngay-thang-tinh-thu-bang-power-query\/"},"modified":"2024-12-04T08:26:21","modified_gmt":"2024-12-04T08:26:21","slug":"tach-ngay-thang-tinh-thu-bang-power-query","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/tach-ngay-thang-tinh-thu-bang-power-query\/","title":{"rendered":"T\u00e1ch ng\u00e0y th\u00e1ng t\u00ednh th\u1ee9 b\u1eb1ng Power Query"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>\u0110ang \u0111ang v\u1ea5t v\u1ea3 khi ph\u1ea3i t\u00e1ch m\u1ed9t ng\u00e0y th\u00e1ng trong m\u1ed9t chu\u1ed7i t\u00ednh ra s\u1ed1 tu\u1ea7n th\u1ee9 m\u1ea5y trong th\u00e1ng, n\u00f3 l\u00e0 th\u1ee9 m\u1ea5y? b\u1ea1n m\u1ea5t qu\u00e1 nhi\u1ec1u th\u1eddi gian \u0111\u1ec3 l\u00e0m vi\u1ec7c \u0111\u00f3 v\u1edbi ph\u01b0\u01a1ng ph\u00e1p th\u00f4ng th\u01b0\u1eddng, h\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft n\u00e0y c\u1ee7a HocExcelOnline b\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch t\u00e1ch d\u1eef li\u1ec7u t\u1eeb m\u1ed9t chu\u1ed7i ra ng\u00e0y th\u00e1ng n\u0103m, t\u00ednh l\u00e0 tu\u1ea7n bao nhi\u00eau thu\u1ed9c th\u1ee9 n\u00e0o h\u00e3y \u0111\u1ebfn v\u1edbi Power Query.<\/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-6750122c57336\" 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-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/tach-ngay-thang-tinh-thu-bang-power-query.html#Mau_ban_du_lieu_can_phai_tach\" title=\"M\u1eabu b\u1ea3n d\u1eef li\u1ec7u c\u1ea7n ph\u1ea3i t\u00e1ch.\">M\u1eabu b\u1ea3n d\u1eef li\u1ec7u c\u1ea7n ph\u1ea3i t\u00e1ch.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/tach-ngay-thang-tinh-thu-bang-power-query.html#Phan_tich_du_lieu_dau_vao_va_cac_buoc_thuc_hien\" title=\"Ph\u00e2n t\u00edch d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o v\u00e0 c\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n\">Ph\u00e2n t\u00edch d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o v\u00e0 c\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/tach-ngay-thang-tinh-thu-bang-power-query.html#Cach_thuc_thuc_hien\" title=\"C\u00e1ch th\u1ee9c th\u1ef1c hi\u1ec7n\">C\u00e1ch th\u1ee9c th\u1ef1c hi\u1ec7n<\/a>\n<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/tach-ngay-thang-tinh-thu-bang-power-query.html#Buoc_1_Tao_bang\" title=\"B\u01b0\u1edbc 1: T\u1ea1o b\u1ea3ng\">B\u01b0\u1edbc 1: T\u1ea1o b\u1ea3ng<\/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\/tach-ngay-thang-tinh-thu-bang-power-query.html#Buoc_2_Vao_Power_Query\" title=\"B\u01b0\u1edbc 2: V\u00e0o Power Query\">B\u01b0\u1edbc 2: V\u00e0o Power Query<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/tach-ngay-thang-tinh-thu-bang-power-query.html#Buoc_3_Tach_so_ra_khoi_chuoi\" title=\"B\u01b0\u1edbc 3:\u00a0T\u00e1ch s\u1ed1 ra kh\u1ecfi chu\u1ed7i\">B\u01b0\u1edbc 3:\u00a0T\u00e1ch s\u1ed1 ra kh\u1ecfi chu\u1ed7i<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/tach-ngay-thang-tinh-thu-bang-power-query.html#Buoc_4_Chuyen_ve_dinh_dang_ngay_thang\" title=\"B\u01b0\u1edbc 4: Chuy\u1ec3n v\u1ec1 \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng.\">B\u01b0\u1edbc 4: Chuy\u1ec3n v\u1ec1 \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/tach-ngay-thang-tinh-thu-bang-power-query.html#Buoc_5_Tao_cot_va_thuc_hien_tinh_toan\" title=\"B\u01b0\u1edbc 5 . T\u1ea1o c\u1ed9t v\u00e0 th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n.\">B\u01b0\u1edbc 5 . T\u1ea1o c\u1ed9t v\u00e0 th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n.<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/tach-ngay-thang-tinh-thu-bang-power-query.html#Video_truc_quan\" title=\"Video tr\u1ef1c quan.\">Video tr\u1ef1c quan.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/tach-ngay-thang-tinh-thu-bang-power-query.html#Ket_thuc\" title=\"K\u1ebft th\u00fac\">K\u1ebft th\u00fac<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1><span class=\"ez-toc-section\" id=\"Mau_ban_du_lieu_can_phai_tach\"><\/span>M\u1eabu b\u1ea3n d\u1eef li\u1ec7u c\u1ea7n ph\u1ea3i t\u00e1ch.<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30596\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dulieu1.png\" width=\"596\" height=\"990\" title=\"dulieu1\"><\/p>\n<p>Ta c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 h\u00ecnh \u1edf tr\u00ean gi\u1edd ph\u1ea3i t\u00e1ch ra th\u1ebf n\u00e0o nh\u1ec9.<\/p>\n<h1><span class=\"ez-toc-section\" id=\"Phan_tich_du_lieu_dau_vao_va_cac_buoc_thuc_hien\"><\/span>Ph\u00e2n t\u00edch d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o v\u00e0 c\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<blockquote>\n<ul>\n<li>T\u00e1ch s\u1ed1 ra kh\u1ecfi chu\u1ed7i<\/li>\n<li>Chuy\u1ec3n v\u1ec1 \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng<\/li>\n<li>T\u00e1ch ng\u00e0y, th\u00e1ng, t\u00ednh th\u1ee9.<\/li>\n<\/ul>\n<\/blockquote>\n<h1><span class=\"ez-toc-section\" id=\"Cach_thuc_thuc_hien\"><\/span>C\u00e1ch th\u1ee9c th\u1ef1c hi\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<h2><span class=\"ez-toc-section\" id=\"Buoc_1_Tao_bang\"><\/span>B\u01b0\u1edbc 1: T\u1ea1o b\u1ea3ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<blockquote>\n<p>B\u00f4i \u0111en v\u00f9ng c\u1ea7n t\u00e1ch d\u1eef li\u1ec7u \u1ea5n t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft \u201cCtrl +T\u201d tr\u00ean b\u00e0n ph\u00edm ho\u1eb7c v\u00e0o\u00a0 Insert &gt; Table.<\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Buoc_2_Vao_Power_Query\"><\/span>B\u01b0\u1edbc 2: V\u00e0o Power Query<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<blockquote>\n<p>\u1ea4n t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft tr\u00ean b\u00e0n ph\u00edm \u201cAlt+A+PT\u201d ho\u1eb7c v\u00e0o Menu Data &gt; From table\/range<\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Buoc_3_Tach_so_ra_khoi_chuoi\"><\/span>B\u01b0\u1edbc 3:\u00a0T\u00e1ch s\u1ed1 ra kh\u1ecfi chu\u1ed7i<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<blockquote>\n<p>T\u00e1ch s\u1ed1 ra kh\u1ecfi chu\u1ed7i s\u1eed d\u1ee5ng ph\u00edm t\u1eaft \u201cALT+H+SP\u201d Ch\u1ecdn By Number of Characters.<\/p>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30600\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dulieu2.png\" width=\"968\" height=\"420\" title=\"dulieu2\"><\/p>\n<p>Do s\u1ed1 trong n\u00e0y c\u00f3 6 s\u1ed1 v\u00e0 n\u1eb1m \u1edf cu\u1ed1i l\u00ean ta s\u1ebd l\u00e0 nh\u01b0 sau.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30601\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dulieu3.png\" width=\"1023\" height=\"468\" title=\"dulieu3\"><\/p>\n<p>v\u1eady l\u00e0 ta \u0111\u00e3 t\u00e1ch xong s\u1ed1 ra kh\u1ecfi chu\u1ed7i th\u1eadt \u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o.<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-134.gif\" title=\"vba101_92019-nho-134\"><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-314.gif\" title=\"ex101_92019-nho-314\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Buoc_4_Chuyen_ve_dinh_dang_ngay_thang\"><\/span>B\u01b0\u1edbc 4: Chuy\u1ec3n v\u1ec1 \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Click v\u00e0o c\u1ed9t ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n chuy\u1ec3n ch\u1ecdn nh\u01b0 h\u00ecnh.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30602\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dulieu4.png\" width=\"850\" height=\"396\" title=\"dulieu4\"><\/p>\n<p>Ok v\u1eady l\u00e0 ta \u0111\u00e3 c\u00f3 d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng \u0111\u01b0\u1ee3c t\u00e1ch ra gi\u1edd v\u1edbi b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n ta c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m trong Power Query t\u00ednh to\u00e1n.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Buoc_5_Tao_cot_va_thuc_hien_tinh_toan\"><\/span>B\u01b0\u1edbc 5 . T\u1ea1o c\u1ed9t v\u00e0 th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<blockquote>\n<p>Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft \u201cALT+A+CC\u201d ho\u1eb7c v\u00e0o nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi.<\/p>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30603\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dulieu5.png\" width=\"1449\" height=\"683\" title=\"dulieu5\"><\/p>\n<p>Gi\u1edd vi\u1ebft c\u00f4ng th\u1ee9c t\u00e1ch ng\u00e0y, th\u00e1ng, n\u0103m nh\u01b0 h\u00ecnh.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30604\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dulieu6.png\" width=\"1038\" height=\"645\" title=\"dulieu6\"><\/p>\n<blockquote>\n<p>T\u00e1ch ng\u00e0y:= Date.Day([Column1.2])<\/p>\n<p>T\u00e1ch th\u00e1ng: =Date.Month([Column1.2])<\/p>\n<p>T\u00e1ch n\u0103m : =Date.Year([Column1.2])<\/p>\n<p>Tu\u1ea7n th\u1ee9 m\u1ea5y : =Date.WeekOfMonth([Column1.2])<\/p>\n<p>Th\u1ee9 :if Date.DayOfWeek([Column1.2]) = 1 then \u201cCh\u1ee7 Nh\u1eadt\u201d\u00a0 \u00a0else if Date.DayOfWeek([Column1.2]) = 2 then \u201cTh\u1ee9 Hai\u201d\u00a0 else if Date.DayOfWeek([Column1.2]) = 3 then \u201cTh\u1ee9 Ba\u201d\u00a0 else if Date.DayOfWeek([Column1.2]) = 4 then \u201d Th\u1ee9 T\u01b0\u201d\u00a0 else if Date.DayOfWeek([Column1].2) = 5 then \u201cTh\u1ee9 N\u0103m\u201d\u00a0 else if Date.DayOfWeek([Column1.2]) = 6 then \u201cTh\u1ee9 6\u201d else \u201cTh\u1ee9 B\u1ea3y\u201d<\/p>\n<\/blockquote>\n<h1><span class=\"ez-toc-section\" id=\"Video_truc_quan\"><\/span>Video tr\u1ef1c quan.<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div style=\"width: 1920px\" class=\"wp-video\"><!--[if lt IE 9]&gt;document.createElement('video');&lt;![endif]--><br \/>\n<video class=\"wp-video-shortcode\" id=\"video-30590-1\" width=\"1920\" height=\"1080\" preload=\"metadata\" controls=\"controls\"><source type=\"video\/mp4\" src=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2019\/10\/t%C3%A1ch-th%E1%BB%A9-ng%C3%A0y-th%C3%A1ng.mp4?_=1\" \/><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/10\/t%C3%A1ch-th%E1%BB%A9-ng%C3%A0y-th%C3%A1ng.mp4\">https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2019\/10\/t\u00e1ch-th\u1ee9-ng\u00e0y-th\u00e1ng.mp4<\/a><\/video><\/div>\n<h1><span class=\"ez-toc-section\" id=\"Ket_thuc\"><\/span>K\u1ebft th\u00fac<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>Qua b\u00e0i vi\u1ebft v\u1eeba r\u1ed3i HocExcelOnline hi v\u1ecdng s\u1ebd gi\u00fap c\u00e1c b\u1ea1n l\u00e0m nh\u1eefng b\u00e1o c\u00e1o v\u00e0 x\u1eed l\u00fd v\u1eabn \u0111\u1ec1 ng\u00e0y th\u00e1ng nhanh nh\u1ea5t khi s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Power Query.<\/p>\n<p>N\u1ebfu th\u1ea5y hay h\u00e3y gh\u00e9 tham HocExcelOnline v\u00e0 chia s\u1ebb cho m\u1ecdi ng\u01b0\u1eddi bi\u1ebft nh\u00e9.<\/p>\n<hr>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dua-du-lieu-ve-dang-chuan-voi-power-query-trong-excel.html\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Power Query \u0111\u1ec3 chu\u1ea9n ho\u00e1 d\u1eef li\u1ec7u<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/lay-du-lieu-tai-chinh-tu-dong-vao-bang-tinh-excel.html\">L\u1ea5y d\u1eef li\u1ec7u t\u00e0i ch\u00ednh t\u1ef1\u00a0\u0111\u1ed9ng t\u1eeb\u00a0Web v\u00e0o\u00a0Excel b\u1eb1ng Power Query<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/lay-du-lieu-tren-trang-facebook-ca-nhan-vao-excel-voi-power-query.html\">L\u1ea5y d\u1eef li\u1ec7u tr\u00ean trang Facebook c\u00e1 nh\u00e2n v\u00e0o\u00a0Excel b\u1eb1ng Power Query<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cach-gop-du-lieu-tu-nhieu-bang-vao-1-bang-su-dung-power-query.html\">C\u00e1ch g\u1ed9p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u b\u1ea3ng v\u00e0o 1 b\u1ea3ng s\u1eed d\u1ee5ng Power Query<\/a><\/p>\n<p>\u0110\u00f3n xem b\u00e0i vi\u1ebft:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ung-dung-power-query-xay-dung-mo-hinh-du-lieu-phan-tich-nang-suat-lao-dong-phan-1.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch\u00a0x\u00e2y d\u1ef1ng b\u1ea3ng d\u1eef li\u1ec7u ph\u00e2n t\u00edch hi\u1ec7u su\u1ea5t lao\u00a0\u0111\u1ed9ng b\u1eb1ng Power Query<\/a><\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-134.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3945,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3944","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\/3944","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=3944"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3944\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3945"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3944"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3944"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3944"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}