{"id":4103,"date":"2024-12-04T08:46:09","date_gmt":"2024-12-04T08:46:09","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/lay-du-lieu-tren-trang-facebook-ca-nhan-vao-excel-voi-power-query\/"},"modified":"2024-12-04T08:46:09","modified_gmt":"2024-12-04T08:46:09","slug":"lay-du-lieu-tren-trang-facebook-ca-nhan-vao-excel-voi-power-query","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/lay-du-lieu-tren-trang-facebook-ca-nhan-vao-excel-voi-power-query\/","title":{"rendered":"L\u1ea5y d\u1eef li\u1ec7u tr\u00ean trang Facebook c\u00e1 nh\u00e2n v\u00e0o Excel v\u1edbi Power Query"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-Bh-YYrla#1\">\n<p style=\"text-align: justify\"><em>Trong b\u00e0i vi\u1ebft n\u00e0y, <strong><a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a><\/strong> s\u1ebd h\u01b0\u1edbng d\u1eabn <a href=\"http:\/\/blog.ezworkapp.com\/lay-du-lieu-tren-trang-facebook-ca-nhan-vao-excel-voi-power-query.html\"><strong>c\u00e1ch k\u1ebft n\u1ed1i Power Query v\u1edbi Facebook<\/strong><\/a> \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u t\u1eeb trang c\u00e1 nh\u00e2n c\u1ee7a b\u1ea1n v\u00e0o Excel m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng.<\/em><\/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-675016d11088a\" 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\/lay-du-lieu-tren-trang-facebook-ca-nhan-vao-excel-voi-power-query.html#Ket_noi_voi_trang_Facebook_ca_nhan_cua_ban\" title=\"K\u1ebft n\u1ed1i v\u1edbi trang Facebook c\u00e1 nh\u00e2n c\u1ee7a b\u1ea1n\">K\u1ebft n\u1ed1i v\u1edbi trang Facebook c\u00e1 nh\u00e2n c\u1ee7a b\u1ea1n<\/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\/lay-du-lieu-tren-trang-facebook-ca-nhan-vao-excel-voi-power-query.html#Cach_1\" title=\"C\u00e1ch 1\">C\u00e1ch 1<\/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\/lay-du-lieu-tren-trang-facebook-ca-nhan-vao-excel-voi-power-query.html#Cach_2\" title=\"C\u00e1ch 2\">C\u00e1ch 2<\/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\/lay-du-lieu-tren-trang-facebook-ca-nhan-vao-excel-voi-power-query.html#Lay_du_lieu_tren_tren_trang_ca_nhan_vao_Excel\" title=\"L\u1ea5y d\u1eef li\u1ec7u tr\u00ean tr\u00ean trang c\u00e1 nh\u00e2n v\u00e0o Excel\">L\u1ea5y d\u1eef li\u1ec7u tr\u00ean tr\u00ean trang c\u00e1 nh\u00e2n v\u00e0o Excel<\/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\/lay-du-lieu-tren-trang-facebook-ca-nhan-vao-excel-voi-power-query.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ket_noi_voi_trang_Facebook_ca_nhan_cua_ban\"><\/span>K\u1ebft n\u1ed1i v\u1edbi trang Facebook c\u00e1 nh\u00e2n c\u1ee7a b\u1ea1n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 l\u1ea5y d\u1eef li\u1ec7u t\u1eeb trang c\u00e1 nh\u00e2n Facebook c\u1ee7a b\u1ea1n th\u00ec tr\u01b0\u1edbc ti\u00ean l\u00e0 ph\u1ea3i k\u1ebft n\u1ed1i <a href=\"http:\/\/blog.ezworkapp.com\/power-query-la-gi-tai-sao-can-hoc-power-query.html\"><strong>Power Query<\/strong><\/a> v\u1edbi Facebook \u0111\u00e3 ph\u1ea3i kh\u00f4ng n\u00e0o \ud83d\ude0a<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 k\u1ebft n\u1ed1i\u00a0Power Query v\u1edbi Facebook\u00a0ta c\u00f3 m\u1ed9t s\u1ed1 c\u00e1ch nh\u01b0 sau:<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_1\"><\/span>C\u00e1ch 1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Tr\u00ean Excel, b\u1ea1n v\u00e0o Power Query, trong ph\u1ea7n Get Data b\u1ea1n t\u00ecm t\u1edbi From Online Services, ch\u1ecdn Facebook v\u00e0 \u0111\u0103ng nh\u1eadp.<\/p>\n<h3 style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/10\/1-6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30379 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-6-1.png\" alt=\"lay-du-lieu-tu-facebook-ca-nhan-vao-excel-voi-power-query-1\" width=\"817\" height=\"776\" title=\"1-6-1\"><\/a><\/h3>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_2\"><\/span>C\u00e1ch 2<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Ngo\u00e0i c\u00e1ch tr\u00ean, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 k\u1ebft n\u1ed1i t\u1edbi Facebook trong c\u1eeda s\u1ed5 Power Query Editor.<\/p>\n<p style=\"text-align: justify\">Sau khi m\u1edf\u00a0Power Query Editor, b\u1ea1n chu\u1ed9t ph\u1ea3i v\u00e0o ph\u1ea7n b\u00ean tr\u00e1i c\u1ee7a c\u1eeda s\u1ed5, ch\u1ecdn New Query -&gt; Online Services -&gt; Facebook<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30380 size-thumbnail\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-7-150x150-1.png\" alt=\"lay-du-lieu-tu-facebook-ca-nhan-vao-excel-voi-power-query-2\" width=\"150\" height=\"150\" title=\"2-7-150x150-1\"><\/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-138.gif\" title=\"vba101_92019-nho-138\"><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-327.gif\" title=\"ex101_92019-nho-327\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">Sau \u0111\u00f3 b\u1ea1n th\u1ef1c hi\u1ec7n \u0111\u0103ng nh\u1eadp v\u00e0o trang Facebook c\u00e1 nh\u00e2n c\u1ee7a m\u00ecnh.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/10\/9-3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30399 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/9-3.png\" alt=\"lay-du-lieu-tu-facebook-ca-nhan-vao-excel-voi-power-query-3\" width=\"701\" height=\"256\" title=\"9-3\"><\/a><\/p>\n<p style=\"text-align: justify\">V\u1edbi 2 c\u00e1ch tr\u00ean l\u00e0 b\u1ea1n \u0111\u00e3 k\u1ebft n\u1ed1i \u0111\u01b0\u1ee3c Power Query v\u00e0 Facebook r\u1ed3i nh\u00e9, Ti\u1ebfp theo ta s\u1ebd th\u1ef1c hi\u1ec7n l\u1ea5y d\u1eef li\u1ec7u.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lay_du_lieu_tren_tren_trang_ca_nhan_vao_Excel\"><\/span>L\u1ea5y d\u1eef li\u1ec7u tr\u00ean tr\u00ean trang c\u00e1 nh\u00e2n v\u00e0o Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Sau khi \u0111\u00e3 k\u1ebft n\u1ed1i th\u00e0nh c\u00f4ng t\u1edbi Facebook, ta th\u1ef1c hi\u1ec7n l\u1ea5y d\u1eef li\u1ec7u nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">B\u1ea1n v\u00e0o l\u1ea1i nh\u01b0 b\u01b0\u1edbc \u0111\u0103ng nh\u1eadp v\u00e0o Facebook tr\u00ean \u0111\u1ec3 b\u1eaft \u0111\u1ea7u th\u1ef1c hi\u1ec7n l\u1ea5y d\u1eef li\u1ec7u, v\u00ec \u0111\u00e3 \u0111\u0103ng nh\u1eadp r\u1ed3i n\u00ean l\u1ea7n n\u00e0y Power Query s\u1ebd kh\u00f4ng y\u00eau c\u1ea7u \u0111\u0103ng nh\u1eadp n\u1eefa.<\/p>\n<p style=\"text-align: justify\">C\u00f3 th\u1ec3 s\u1ebd c\u00f3 m\u1ed9t th\u00f4ng b\u00e1o hi\u1ec7n ra nh\u01b0 sau, b\u1ea1n \u1ea5n Continue \u0111\u1ec3 ti\u1ebfp t\u1ee5c<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/10\/7-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30385 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-2-1024x405-1.png\" alt=\"lay-du-lieu-tu-facebook-ca-nhan-vao-excel-voi-power-query-4\" width=\"1024\" height=\"405\" title=\"7-2-1024x405-1\"><\/a><\/p>\n<p style=\"text-align: justify\">M\u1ed9t h\u1ed9p tho\u1ea1i c\u00f3 t\u00ean Fb \u0111\u01b0\u1ee3c hi\u1ec7n ra<\/p>\n<p style=\"text-align: justify\">T\u1ea1i\u00a0m\u1ee5c\u00a0<strong>\u201cMe\u201d, user name or Object ID<\/strong> b\u1ea1n c\u00f3 th\u1ec3 g\u00f5 ch\u1eef me (nh\u01b0 h\u00ecnh) ho\u1eb7c ID trang Facebook c\u00e1 nh\u00e2n c\u1ee7a b\u1ea1n.<\/p>\n<p style=\"text-align: justify\">M\u1ee5c <strong>Connection<\/strong> b\u1ea1n s\u1ebd c\u00f3 c\u00f3 l\u1ef1a ch\u1ecdn danh s\u00e1ch c\u00e1c th\u00f4ng tin m\u00e0 b\u1ea1n mu\u1ed1n l\u1ea5y t\u1eeb trang Facebook c\u00e1 nh\u00e2n c\u1ee7a m\u00ecnh v\u00e0o Excel (\u1ede \u0111\u00e2y m\u00ecnh ch\u1ecdn l\u00e0 Movies l\u00e0m v\u00ed d\u1ee5).<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/10\/3-7.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30381 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-7-1024x626-1.png\" alt=\"lay-du-lieu-tu-facebook-ca-nhan-vao-excel-voi-power-query-5\" width=\"1024\" height=\"626\" title=\"3-7-1024x626-1\"><\/a>Sau khi ch\u1ecdn Movies v\u00e0 \u1ea5n OK, Power Query s\u1ebd \u0111\u01b0a b\u1ea1n t\u1edbi v\u1edbi h\u1ed9p tho\u1ea1i sau, b\u1ea1n c\u00f3 th\u1ec3 \u1ea5n Load hay Load To\u2026 lu\u00f4n v\u00e0o Excel ho\u1eb7c l\u00e0 \u1ea5n v\u00e0o Transform Data \u0111\u1ec3 \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c bi\u1ebfn \u0111\u1ed5i kh\u00e1c (\u1ede \u0111\u00e2y m\u00ecnh ch\u1ecdn\u00a0Transform Data)<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/10\/4-5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30382 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-5-1024x768-1.png\" alt=\"lay-du-lieu-tu-facebook-ca-nhan-vao-excel-voi-power-query-6\" width=\"1024\" height=\"768\" title=\"4-5-1024x768-1\"><\/a><\/p>\n<p style=\"text-align: justify\">C\u1eeda s\u1ed5 Power Query Editor hi\u1ec7n ra, th\u1ef1c hi\u1ec7n c\u00e1c bi\u1ebfn \u0111\u1ed5i cho b\u1ea3ng d\u1eef li\u1ec7u n\u00e0y n\u1ebfu b\u1ea1n mu\u1ed1n (\u1ede \u0111\u00e2y m\u00ecnh ch\u1ec9 th\u1ef1c hi\u1ec7n thay \u0111\u1ed5i Name c\u1ee7a Query n\u00e0y th\u00e0nh <strong>My Movies on Fb<\/strong><\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/10\/5-4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30386 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/5-4-1024x310-1.png\" alt=\"lay-du-lieu-tu-facebook-ca-nhan-vao-excel-voi-power-query-7\" width=\"1024\" height=\"310\" title=\"5-4-1024x310-1\"><\/a><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 v\u1eady l\u00e0 xong r\u1ed3i, b\u00e2y gi\u1edd b\u1ea1n ch\u1ec9 c\u1ea7n Close v\u00e0 Load v\u00e0o Excel th\u00f4i.<\/p>\n<p style=\"text-align: justify\">V\u00e0 m\u00ecnh \u0111\u00e3 c\u00f3 danh s\u00e1ch c\u00e1c Movies tr\u00ean trang Facebook c\u00e1 nh\u00e2n m\u00e0 b\u1ea1n \u0111\u00e3 th\u00edch \u0111\u00e3 theo d\u00f5i.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/10\/6-4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30387 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/6-4-1024x523-1.png\" alt=\"lay-du-lieu-tu-facebook-ca-nhan-vao-excel-voi-power-query-8\" width=\"1024\" height=\"523\" title=\"6-4-1024x523-1\"><\/a><\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 v\u00e0o trang Facebook c\u00e1 nh\u00e2n \u0111\u1ec3 ki\u1ec3m tra xem k\u1ebft qu\u1ea3 c\u1ee7a Power Query tr\u1ea3 v\u1ec1 cho ch\u00fang ta c\u00f3 \u0111\u00fang hay kh\u00f4ng \ud83d\ude0a<\/p>\n<p style=\"text-align: justify\">T\u01b0\u01a1ng t\u1ef1 v\u1edbi c\u00e1c th\u00f4ng b\u1ea1n c\u00f3 th\u1ec3 l\u1ea5y l\u00ean c\u00e1c th\u00f4ng tin kh\u00e1c nh\u01b0 danh s\u00e1ch b\u1ea1n b\u00e8 (Friends), \u00e2m nh\u1ea1c (Music), b\u00e0i \u0111\u0103ng (Posts),\u2026.<\/p>\n<p style=\"text-align: justify\">M \u2013 Code\u00a0c\u1ee7a m\u00ecnh \u0111\u1ec3 l\u1ea5y ra danh s\u00e1ch Movies nh\u01b0 \u1edf tr\u00ean l\u00e0:<\/p>\n<blockquote>\n<p><strong>= Facebook.Graph(\u201chttps:\/\/graph.facebook.com\/v2.8\/me\/movies\u201d)<\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">Tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n xem t\u1ea5t c\u1ea3 c\u00e1c th\u00f4ng tin tr\u00ean th\u00ec \u1edf m\u1ee5c Connection trong h\u1ed9p tho\u1ea1i Facebook b\u1ea1n ch\u1ecdn \u2013none\u2013. Ho\u1eb7c, b\u1ea1n s\u1eeda l\u1ea1i M \u2013 Code trong Source th\u00e0nh nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>= Facebook.Graph(\u201chttps:\/\/graph.facebook.com\/v2.8\/me\u201d)<\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">\u0110\u01a1n gi\u1ea3n l\u00e0 b\u1ea1n ch\u1ec9 c\u1ea7n xo\u00e1 ph\u1ea7n <strong>\/movies\u00a0<\/strong>\u0111i.<\/p>\n<p style=\"text-align: justify\">Th\u1ef1c hi\u1ec7n m\u1ed9t v\u00e0i bi\u1ebfn \u0111\u1ed5i n\u1eefa \u0111\u1ec3 c\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/10\/8-3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30389 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/8-3-1024x576-1.png\" alt=\"lay-du-lieu-tu-facebook-ca-nhan-vao-excel-voi-power-query-9\" width=\"1024\" height=\"576\" title=\"8-3-1024x576-1\"><\/a><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Qua b\u00e0i vi\u1ebft,<strong> H\u1ecdc Excel Online<\/strong> hy v\u1ecdng b\u1ea1n \u0111\u00e3 bi\u1ebft <strong>c\u00e1ch k\u1ebft n\u1ed1i Power Query v\u1edbi trang Facebook<\/strong> c\u00e1 nh\u00e2n c\u1ee7a m\u00ecnh v\u00e0 th\u1ef1c hi\u1ec7n l\u1ea5y c\u00e1c th\u00f4ng\u00a0tin\u00a0li\u00ean quan t\u1edbi b\u1ea1n tr\u00ean Facebook nh\u01b0 danh s\u00e1ch b\u1ea1n b\u00e8 c\u1ee7a b\u1ea1n, c\u00e1c trang Movies, Music,\u2026 m\u00e0 tr\u01b0\u1edbc gi\u1edd b\u1ea1n \u0111\u00e3 th\u00edch, \u0111\u00e3 theo d\u00f5i.<\/p>\n<hr>\n<p style=\"text-align: justify;padding-left: 30px\"><strong><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><\/strong><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><strong><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><\/strong><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><strong><a href=\"http:\/\/blog.ezworkapp.com\/?s=power+bi\">H\u00e0m DAX trong Power BI<\/a><\/strong><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><strong><a href=\"https:\/\/hocexcel.online\/course\/preview\/pbi101-microsoft-power-bi-desktop-business-intelligence-trong-tam-tay\">PBI101 \u2013 Microsoft Power BI Desktop, Business Intelligence trong t\u1ea7m tay<\/a><\/strong><\/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-138.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4104,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4103","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\/4103","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=4103"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4103\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4104"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4103"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4103"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}