{"id":8007,"date":"2024-12-21T19:23:25","date_gmt":"2024-12-21T19:23:25","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-lay-du-lieu-tu-1-file-excel-dang-dong\/"},"modified":"2024-12-21T19:23:25","modified_gmt":"2024-12-21T19:23:25","slug":"huong-dan-cach-lay-du-lieu-tu-1-file-excel-dang-dong","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-lay-du-lieu-tu-1-file-excel-dang-dong\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1ea5y d\u1eef li\u1ec7u t\u1eeb 1 File Excel \u0111ang \u0111\u00f3ng"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Khi l\u00e0m vi\u1ec7c v\u1edbi Excel ch\u00fang ta th\u01b0\u1eddng s\u1eed d\u1ee5ng c\u00e1c h\u00e0m \u0111\u1ec3 l\u1ea5y hay tham chi\u1ebfu d\u1eef li\u1ec7u trong 1 Sheet, gi\u1eefa c\u00e1c Sheets trong 1 File,\u2026.Th\u1ebf c\u00f2n khi b\u1ea1n mu\u1ed1n <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-lay-du-lieu-tu-1-file-excel-dang-dong.html\"><strong>l\u1ea5y d\u1eef li\u1ec7u t\u1eeb 1 file Excel kh\u00e1c<\/strong><\/a> m\u00e0 file \u0111\u00f3 l\u1ea1i \u0111ang \u0111\u00f3ng th\u00ec b\u1ea1n s\u1ebd l\u00e0m nh\u01b0 n\u00e0o?. B\u00e0i vi\u1ebft n\u00e0y c\u1ee7a <strong><a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online <\/a><\/strong>s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u1ec3 c\u00f3 th\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u \u0111\u00f3. <strong>Let go!<\/strong><\/em><\/p>\n<p>\u0110\u1ec3 l\u1ea5y hay tham chi\u1ebfu t\u1edbi 1 gi\u00e1 tr\u1ecb hay 1 v\u00f9ng gi\u00e1 tr\u1ecb nao \u0111\u00f3 trong 1 file Excel \u0111ang \u0111\u00f3ng b\u1ea1n th\u1ef1c hi\u1ec7n\u00a0c\u00e1c\u00a0b\u01b0\u1edbc nh\u01b0 sau:<\/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-676715ac97e88\" 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-lay-du-lieu-tu-1-file-excel-dang-dong.html#Buoc_1_Xac_dinh_duong_dan_Path\" title=\"B\u01b0\u1edbc 1: X\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1eddng d\u1eabn (Path)\">B\u01b0\u1edbc 1: X\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1eddng d\u1eabn (Path)<\/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-lay-du-lieu-tu-1-file-excel-dang-dong.html#Buoc_2_Thuc_hien_viec_lay_tham_chieu_du_lieu\" title=\"B\u01b0\u1edbc 2: Th\u1ef1c hi\u1ec7n vi\u1ec7c l\u1ea5y, tham chi\u1ebfu d\u1eef li\u1ec7u\">B\u01b0\u1edbc 2: Th\u1ef1c hi\u1ec7n vi\u1ec7c l\u1ea5y, tham chi\u1ebfu d\u1eef li\u1ec7u<\/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-lay-du-lieu-tu-1-file-excel-dang-dong.html#Mot_so_luu_y_khi_ap_dung\" title=\"M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi \u00e1p d\u1ee5ng\">M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi \u00e1p d\u1ee5ng<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Buoc_1_Xac_dinh_duong_dan_Path\"><\/span>B\u01b0\u1edbc 1: X\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1eddng d\u1eabn (Path)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tr\u01b0\u1edbc ti\u00ean, b\u1ea1n c\u1ea7n x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c \u0111\u01b0\u1eddng d\u1eabn \u0111\u1ea7y \u0111\u1ee7 c\u1ee7a File Excel m\u00e0 b\u1ea1n mu\u1ed1n l\u1ea5y d\u1eef li\u1ec7u. B\u1ea1n c\u00f3 th\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u \u0111\u00f3 b\u1eb1ng nhi\u1ec1u c\u00e1ch kh\u00e1c nhau.<\/p>\n<p>Ho\u1eb7c l\u00e0 b\u1ea1n m\u1edf file \u0111\u00f3 l\u00ean r\u1ed3i d\u00f9ng c\u00e1c h\u00e0m tra c\u1ee9u th\u00f4ng tin m\u00e0 Excel h\u1ed7 tr\u1ee3 nh\u01b0 h\u00e0m CELL, h\u00e0m INFO \u0111\u1ec3 l\u00e0m \u0111i\u1ec1u \u0111\u00f3.<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/mot-so-cach-tim-duong-dan-toi-file-va-toi-thu-muc-chu-file-dang-mo.html\"><em><strong>C\u00e1ch t\u00ecm \u0111\u01b0\u1eddng d\u1eabn t\u1edbi file excel, th\u01b0 m\u1ee5c ch\u1ee9a file \u0111ang m\u1edf<\/strong><\/em><\/a><\/p>\n<p>Ho\u1eb7c c\u00f3 1 c\u00e1ch \u0111\u01a1n gi\u1ea3n h\u01a1n v\u00e0 c\u0169ng nhanh h\u01a1n, kh\u00f4ng c\u1ea7n ph\u1ea3i m\u1edf file nh\u01b0 tr\u00ean \u0111\u00f3 l\u00e0 b\u1ea1n t\u00ecm t\u1edbi th\u01b0 m\u1ee5c ch\u01b0a File \u0111\u00f3 gi\u1eef ph\u00edm <strong>Shift<\/strong> v\u00e0 \u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0o file \u0111\u00f3 sau \u0111\u00f3 ch\u1ecdn <strong>Copy as path<\/strong> \u0111\u1ec3 Copy \u0111\u01b0\u1eddng d\u1eabn \u0111\u1ea7y \u0111\u1ee7 c\u1ee7a file \u0111\u00f3.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/09\/1-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-29859 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-2-566x1024-1.png\" alt=\"huong-dan-cach-lay-du-lieu-tu-mot-file-excel-dang-dong-1\" width=\"566\" height=\"1024\" title=\"1-2-566x1024-1\"><\/a><\/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-331.gif\" title=\"vba101_92019-nho-331\"><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-720.gif\" title=\"ex101_92019-nho-720\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Nh\u01b0 v\u1eady l\u00e0 b\u1ea1n \u0111\u00e3 c\u00f3 \u0111\u01b0\u1ee3c \u0111\u01b0\u1ee3c d\u1eabn \u0111\u1ea7y \u0111\u1ee7 t\u1edbi File Excel b\u1ea1n mu\u1ed1n l\u1ea5y d\u1eef li\u1ec7u. Sau khi \u0111\u00e3 c\u00f3 \u0111\u01b0\u1eddng d\u1eabn \u0111\u1ea7y \u0111\u1ee7 c\u1ee7a File Excel c\u1ea7n l\u1ea5y d\u1eef li\u1ec7u b\u1ea1n m\u1edf 1 file Excel kh\u00e1c l\u00ean v\u00e0 Paste v\u00e0o 1 Cell n\u00e0o \u0111\u00f3 \u0111\u01b0\u1eddng d\u1eabn v\u1eeba Copy \u0111\u01b0\u1ee3c \u0111\u1ec3 b\u01b0\u1edbc 2 ta s\u1ebd th\u1ef1c hi\u1ec7n l\u1ea5y d\u1eef li\u1ec7u.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Buoc_2_Thuc_hien_viec_lay_tham_chieu_du_lieu\"><\/span>B\u01b0\u1edbc 2: Th\u1ef1c hi\u1ec7n vi\u1ec7c l\u1ea5y, tham chi\u1ebfu d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u1edbi \u0111\u01b0\u1eddng d\u1eabn n\u00e0y ta c\u1ea7n ch\u1ec9nh s\u1eeda l\u1ea1i m\u1ed9t s\u1ed1 \u0111i\u1ec3m n\u1eefa, c\u1ee5 th\u1ec3 m\u00ecnh c\u00f3 v\u00ed d\u1ee5 sau:<\/p>\n<p>Sau khi th\u1ef1c hi\u1ec7n b\u01b0\u1edbc 1 m\u00ecnh c\u00f3 \u0111\u01b0\u1eddng d\u1eabn sau:<\/p>\n<blockquote>\n<p><strong>C:UsersIBMDesktopFile.xlsm<\/strong><\/p>\n<\/blockquote>\n<p>Ti\u1ebfp theo, ta c\u1ea7n x\u00e1c \u0111\u1ecbnh Sheet c\u1ea7n l\u1ea5y d\u1eef li\u1ec7u trong File Excel \u0111\u00f3.<\/p>\n<p>\u1ede \u0111\u00e2y, File Excel c\u1ee7a m\u00ecnh c\u00f3 2 Sheets, v\u00e0 m\u00ecnh c\u1ea7n l\u1ea5y d\u1eef li\u1ec7u \u1edf Sheet <strong>DATA<\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/09\/2-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-29868 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-2-931x1024-1.png\" alt=\"huong-dan-cach-lay-du-lieu-tu-mot-file-excel-dang-dong-2\" width=\"931\" height=\"1024\" title=\"2-2-931x1024-1\"><\/a><\/p>\n<p>B\u1ea1n ch\u1ec9nh l\u1ea1i \u0111\u01b0\u1eddng d\u1eabn tr\u00ean th\u00e0nh nh\u01b0 sau <em>(ch\u00fa \u00fd v\u1ecb tr\u00ed c\u00e1 d\u1ea5u nh\u00e1y \u0111\u01a1n, ngo\u1eb7c vu\u00f4ng nha b\u1ea1n)<\/em><\/p>\n<blockquote>\n<p><strong>\u2018C:UsersIBMDesktop[File.xlsm]DATA\u2019<\/strong><\/p>\n<\/blockquote>\n<p>V\u1edbi \u0111\u01b0\u1eddng d\u1eabn tr\u00ean b\u1ea1n \u0111\u00e3 x\u00e1c \u0111\u1ecbnh vi\u1ec7c l\u1ea5y d\u1eef li\u1ec7u trong Sheet DATA. C\u00e2u h\u1ecfi ti\u1ebfp theo l\u00e0 trong Sheet n\u00e0y b\u1ea1n c\u1ea7n l\u1ea5y d\u1eef li\u1ec7u \u1edf \u00f4 n\u00e0o, v\u00f9ng n\u00e0o?<\/p>\n<p>Gi\u1ea3 s\u1eed m\u00ecnh c\u1ea7n l\u1ea5y d\u1eef li\u1ec7u t\u1ea1i \u00f4 B2 ch\u1eb3ng h\u1ea1n th\u00ec c\u00f4ng th\u1ee9c s\u1ebd l\u00e0 nh\u01b0 sau <em>(\u0111\u1eebng qu\u00ean d\u1ea5u ch\u1ea5m than nha b\u1ea1n)<\/em><\/p>\n<blockquote>\n<p><strong>=\u2019C:UsersIBMDesktop[File.xlsm]DATA\u2019!B2<\/strong><\/p>\n<\/blockquote>\n<p>B\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3u c\u00f4ng th\u1ee9c \u0111\u00f3 nh\u01b0 sau:<\/p>\n<ul>\n<li><strong>C:UsersIBMDesktop:<\/strong> \u0110\u00e2y l\u00e0 \u0111\u01b0\u1eddng d\u1eabn t\u1edbi th\u01b0 m\u1ee5c ch\u1ee9a File Excel b\u1ea1n c\u1ea7n l\u1ea5y d\u1eef li\u1ec7u<\/li>\n<li><strong>[File.xlsm]:<\/strong> \u0110\u00e2y l\u00e0 t\u00ean v\u00e0 ph\u1ea7n m\u1edf r\u1ed9ng c\u1ee7a File b\u1ea1n c\u1ea7n l\u1ea5y d\u1eef li\u1ec7u<\/li>\n<li><strong>DATA:<\/strong> \u0110\u00e2y l\u00e0 Sheet trong File m\u00e0 b\u1ea1n c\u1ea7n l\u1ea5y d\u1eef li\u1ec7u<\/li>\n<li><strong>B2:<\/strong> \u0110\u00e2y ch\u00ednh l\u00e0 v\u00f9ng b\u1ea1n c\u1ea7n l\u1ea5y d\u1eef li\u1ec7u trong Sheet DATA<\/li>\n<\/ul>\n<p style=\"text-align: center\"><em><strong>\u0110\u1eebng qu\u00ean v\u1ecb tr\u00ed c\u1ee7a c\u00e1c d\u1ea5u ngo\u1eb7c vu\u00f4ng, d\u1ea5u nh\u00e1y \u0111\u01a1n v\u00e0 d\u1ea5u ch\u1ea5m than<\/strong><\/em><\/p>\n<p>\u1ea4n Enter v\u00e0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 cho b\u1ea1n nh\u01b0 sau: (ch\u00ednh x\u00e1c ph\u1ea3i ko n\u00e0o \ud83d\ude0a)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-29869 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-2-1024x252-1.png\" alt=\"huong-dan-cach-lay-du-lieu-tu-mot-file-excel-dang-dong-3\" width=\"1024\" height=\"252\" title=\"3-2-1024x252-1\"><\/p>\n<p>Nh\u01b0 v\u1eady ta \u0111\u00e3 l\u1ea5y l\u00ean \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb. Ch\u00fang ta c\u0169ng ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Excel, c\u1ee5 th\u1ec3 m\u00ecnh d\u00f9ng h\u00e0m <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dung-ham-index-va-match-qua-bai-tap-co-loi-giai.html\">INDEX + MATCH<\/a> nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dung-ham-index-va-match-qua-bai-tap-co-loi-giai.html\"><em><strong>H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m index v\u00e0 match qua b\u00e0i t\u1eadp c\u00f3 l\u1eddi gi\u1ea3i<\/strong><\/em><\/a><\/p>\n<p>B\u1ea1n nh\u00ecn c\u00f4ng th\u1ee9c n\u00f3 r\u1ea5t d\u00e0i, nh\u01b0ng th\u1ef1c ra kh\u00f4ng ph\u1ea3i v\u00ec n\u00f3 ph\u1ee9c t\u1ea1p m\u00e0 do ta c\u1ea7n c\u00f3 th\u00eam \u0111\u01b0\u1eddng d\u1eabn \u0111\u1ec3 tham chi\u1ebfu t\u1edbi file \u0111ang \u0111\u00f3ng.<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/09\/4-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-29875 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-2-1024x851-1.png\" alt=\"huong-dan-cach-lay-du-lieu-tu-mot-file-excel-dang-dong-4\" width=\"1024\" height=\"851\" title=\"4-2-1024x851-1\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Mot_so_luu_y_khi_ap_dung\"><\/span>M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi \u00e1p d\u1ee5ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Qua b\u00e0i vi\u1ebft n\u00e0y c\u1ee7a <strong>H\u1ecdc Excel Online<\/strong>, ta th\u1ea5y\u00a0 l\u00e0 ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 l\u1ea5y c\u0169ng nh\u01b0 tham chi\u1ebfu \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u t\u1eeb 1 File Excel \u0111ang \u0111\u00f3ng. Tuy nhi\u00ean khi \u00e1p d\u1ee5ng b\u1ea1n c\u1ea7n l\u01b0u \u00fd m\u1ed9t s\u1ed1 \u0111i\u1ec3m nh\u01b0 sau:<\/p>\n<p>\u2013 V\u1ecb tr\u00ed c\u00e1c d\u1ea5u nh\u00e1y \u0111\u01a1n, ngo\u1eb7c vu\u00f4ng v\u00e0 d\u1ea5u ch\u1ea5m than trong \u0111\u01b0\u1eddng d\u1eabn t\u1edbi \u0111\u1ecba ch\u1ec9 \u00f4 (v\u00f9ng) trong 1 Sheet c\u1ee7a File m\u00e0 b\u1ea1n mu\u1ed1n l\u1ea5y, tham chi\u1ebfu d\u1eef li\u1ec7u<\/p>\n<p>\u2013 Trong th\u1ef1c t\u1ebf th\u00ec vi\u1ec7c \u00e1p d\u1ee5ng c\u00e1ch n\u00e0y <strong>KH\u00d4NG<\/strong> ph\u1ed5 bi\u1ebfn v\u00e0 b\u1ea1n c\u0169ng <strong>KH\u00d4NG<\/strong> n\u00ean qu\u00e1 l\u1ea1m d\u1ee5ng c\u00e1ch n\u00e0y v\u00ec vi\u1ec7c ki\u1ec3m so\u00e1t d\u1eef li\u1ec7u c\u0169ng nh\u01b0 x\u00e1c \u0111\u1ecbnh v\u00f9ng s\u1ebd g\u1eb7p kh\u00f3 kh\u0103n v\u00e0 r\u1ea5t d\u1ec5 d\u1eabn t\u1edbi sai s\u00f3t khi b\u1ea1n tham chi\u1ebfu sai.<\/p>\n<hr>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/mot-so-cach-tim-duong-dan-toi-file-va-toi-thu-muc-chu-file-dang-mo.html\">C\u00e1ch t\u00ecm \u0111\u01b0\u1eddng d\u1eabn t\u1edbi file excel, th\u01b0 m\u1ee5c ch\u1ee9a file \u0111ang m\u1edf<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/lay-thong-tin-trong-so-tinh-ham-info.html\">H\u01b0\u1edbng d\u1eabn l\u1ea5y th\u00f4ng tin v\u1edbi h\u00e0m info trong excel<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-ham-cell-thong-tin-o.html\">H\u01b0\u1edbng d\u1eabn h\u00e0m cell tra c\u1ee9u th\u00f4ng tin \u00f4 trong excel<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/gioi-thieu-ham-address-trong-excel.html\">Gi\u1edbi thi\u1ec7u h\u00e0m address trong excel<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/chuyen-ten-cot-thanh-so.html\">C\u00e1ch chuy\u1ec3n t\u00ean c\u1ed9t th\u00e0nh s\u1ed1 trong excel<\/a><\/strong><\/em><\/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-331.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8008,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8007","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\/8007","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=8007"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8007\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8008"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8007"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8007"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8007"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}