{"id":2135,"date":"2024-12-02T07:02:56","date_gmt":"2024-12-02T07:02:56","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/power-query-lam-moi-du-lieu\/"},"modified":"2024-12-02T07:02:56","modified_gmt":"2024-12-02T07:02:56","slug":"power-query-lam-moi-du-lieu","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/power-query-lam-moi-du-lieu\/","title":{"rendered":"POWER QUERY \u2013 L\u00c0M M\u1edaI D\u1eee LI\u1ec6U"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em><span style=\"font-weight: 400\">Trong lo\u1ea1t b\u00e0i tr\u01b0\u1edbc v\u1ec1 Power Query ch\u00fang ta \u0111\u00e3 t\u00ecm hi\u1ec3u <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dua-du-lieu-ve-dang-chuan-voi-power-query-trong-excel.html\">c\u00e1ch \u0111\u01b0a d\u1eef li\u1ec7u v\u1ec1 d\u1ea1ng chu\u1ea9n<\/a> t\u1eeb c\u00e1c \u0111\u1ecbnh d\u1ea1ng t\u1ec7p kh\u00e1c nhau v\u00e0 t\u1ea3i n\u00f3 v\u00e0o Excel. Trong b\u00e0i vi\u1ebft n\u00e0y <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch l\u00e0m m\u1edbi d\u1eef li\u1ec7u, v\u00e0 nh\u1eefng h\u01b0\u1edbng d\u1eabn sau \u0111\u00e2y c\u00f3 th\u1ec3 cho ph\u00e9p b\u1ea1n truy v\u1ea5n m\u1ed9t l\u1ea7n ho\u1eb7c s\u1eed d\u1ee5ng nhi\u1ec1u l\u1ea7n.<\/span><\/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-674d5b9f09b3a\" 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\/power-query-lam-moi-du-lieu.html#Lam_moi_tat_ca_du_lieu\" title=\"L\u00e0m m\u1edbi t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u\">L\u00e0m m\u1edbi t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u<\/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\/power-query-lam-moi-du-lieu.html#Tao_mot_truy_van_co_ban\" title=\"T\u1ea1o m\u1ed9t truy v\u1ea5n c\u01a1 b\u1ea3n\">T\u1ea1o m\u1ed9t truy v\u1ea5n c\u01a1 b\u1ea3n<\/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\/power-query-lam-moi-du-lieu.html#Cap_nhat_du_lieu_nguon\" title=\"C\u1eadp nh\u1eadt d\u1eef li\u1ec7u ngu\u1ed3n\">C\u1eadp nh\u1eadt d\u1eef li\u1ec7u ngu\u1ed3n<\/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\/power-query-lam-moi-du-lieu.html#Lam_moi_du_lieu\" title=\"L\u00e0m m\u1edbi d\u1eef li\u1ec7u\">L\u00e0m m\u1edbi d\u1eef li\u1ec7u<\/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-5\" href=\"https:\/\/blog.hocexcel.online\/power-query-lam-moi-du-lieu.html#Lam_moi_cac_truy_van_cu_the\" title=\"L\u00e0m m\u1edbi c\u00e1c truy v\u1ea5n c\u1ee5 th\u1ec3\">L\u00e0m m\u1edbi c\u00e1c truy v\u1ea5n c\u1ee5 th\u1ec3<\/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-6\" href=\"https:\/\/blog.hocexcel.online\/power-query-lam-moi-du-lieu.html#Nut_Refresh\" title=\"N\u00fat Refresh\">N\u00fat Refresh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/power-query-lam-moi-du-lieu.html#Menu_Query_and_Connections_truy_van_va_ket_noi\" title=\"Menu Query and Connections (truy v\u1ea5n v\u00e0 k\u1ebft n\u1ed1i)\">Menu Query and Connections (truy v\u1ea5n v\u00e0 k\u1ebft n\u1ed1i)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/power-query-lam-moi-du-lieu.html#Lam_moi_VBA\" title=\"L\u00e0m m\u1edbi VBA\">L\u00e0m m\u1edbi VBA<\/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-9\" href=\"https:\/\/blog.hocexcel.online\/power-query-lam-moi-du-lieu.html#Tuy_chon_lam_moi_nang_cao\" title=\"T\u00f9y ch\u1ecdn l\u00e0m m\u1edbi n\u00e2ng cao\">T\u00f9y ch\u1ecdn l\u00e0m m\u1edbi n\u00e2ng cao<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/power-query-lam-moi-du-lieu.html#Nhung_luu_y_khi_ban_lam_moi_du_lieu\" title=\"Nh\u1eefng l\u01b0u \u00fd khi b\u1ea1n l\u00e0m m\u1edbi d\u1eef li\u1ec7u\">Nh\u1eefng l\u01b0u \u00fd khi b\u1ea1n l\u00e0m m\u1edbi d\u1eef li\u1ec7u<\/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-11\" href=\"https:\/\/blog.hocexcel.online\/power-query-lam-moi-du-lieu.html#Dong_va_mo_tep\" title=\"\u0110\u00f3ng v\u00e0 m\u1edf t\u1ec7p\">\u0110\u00f3ng v\u00e0 m\u1edf t\u1ec7p<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/power-query-lam-moi-du-lieu.html#Truy_van_dua_tren_cac_truy_van_khac\" title=\"Truy v\u1ea5n d\u1ef1a tr\u00ean c\u00e1c truy v\u1ea5n kh\u00e1c\">Truy v\u1ea5n d\u1ef1a tr\u00ean c\u00e1c truy v\u1ea5n kh\u00e1c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/power-query-lam-moi-du-lieu.html#Background_refresh\" title=\"Background refresh\u00a0\">Background refresh\u00a0<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Lam_moi_tat_ca_du_lieu\"><\/span><b>L\u00e0m m\u1edbi t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">C\u00e1c c\u00f4ng c\u1ee5 t\u00ednh to\u00e1n c\u00f3 trong Excel theo m\u1eb7c \u0111\u1ecbnh s\u1ebd t\u00ednh to\u00e1n l\u1ea1i v\u1edbi m\u1ecdi s\u1ef1 thay \u0111\u1ed5i. Tuy nhi\u00ean <a href=\"http:\/\/blog.ezworkapp.com\/power-query-la-gi-tai-sao-can-hoc-power-query.html\"><strong>Power Query<\/strong> <\/a>kh\u00f4ng gi\u1ed1ng v\u1eady, n\u00f3 s\u1ebd ch\u1ec9 t\u00ednh to\u00e1n l\u1ea1i khi c\u00f3 l\u1ec7nh c\u1ee5 th\u1ec3.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">Qu\u00e1 tr\u00ecnh l\u00e0m m\u1edbi kh\u00e1 \u0111\u01a1n gi\u1ea3n, nh\u1ea5p v\u00e0o <\/span><b>Data \u2192 Refresh all.<\/b><\/p>\n<p><span style=\"font-weight: 400\">Ph\u1ea7n sau s\u1ebd s\u1eed d\u1ee5ng<\/span><i><span style=\"font-weight: 400\"> Example 6 \u2013 Data Refresh 1.csv<\/span><\/i><span style=\"font-weight: 400\"> v\u00e0 Example 6 \u2013 <\/span><i><span style=\"font-weight: 400\">Data Refresh 2.csv<\/span><\/i><span style=\"font-weight: 400\"> t\u1eeb c\u00e1c b\u1ea3n t\u1ea3i xu\u1ed1ng \u0111\u1ec3 l\u00e0m v\u00ed d\u1ee5\u00a0 hi\u1ec3u r\u00f5 h\u01a1n.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tao_mot_truy_van_co_ban\"><\/span><b>T\u1ea1o m\u1ed9t truy v\u1ea5n c\u01a1 b\u1ea3n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">M\u1edf c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c v\u00e0 t\u1ea1o m\u1ed9t truy v\u1ea5n m\u1edbi b\u1eb1ng t\u1ec7p CSV: tr\u00ean thanh l\u00e0m vi\u1ec7c ch\u1ecdn <\/span><b>Data\u2013&gt; Get Data\u2013&gt; From File \u2013&gt; From text\/CSV.<\/b><\/p>\n<p><span style=\"font-weight: 400\">C\u1eeda s\u1ed5 <\/span><b>Import data<\/b><span style=\"font-weight: 400\"> hi\u1ec3n th\u1ecb. L\u1ef1a ch\u1ecdn <\/span><i><span style=\"font-weight: 400\">Example \u2013 Data Refresh 1.csv<\/span><\/i><span style=\"font-weight: 400\"> v\u00e0 nh\u1eadp v\u00e0o<\/span><b> Import.<\/b><\/p>\n<p><span style=\"font-weight: 400\">Power Query s\u1ebd m\u1edf m\u1ed9t c\u1eeda s\u1ed5 m\u1edbi v\u00e0 hi\u1ec3n th\u1ecb m\u1ed9t m\u1eabu d\u1eef li\u1ec7u, nh\u1ea5p v\u00e0o <\/span><b>Transform Data.<\/b><\/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-162.gif\" title=\"ex101_92019-nho-162\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><span style=\"font-weight: 400\">Ti\u1ebfp theo th\u1ef1c hi\u1ec7n m\u1ed9t s\u1ed1 chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u c\u01a1 b\u1ea3n \u0111\u1ec3 \u0111\u1ecbnh h\u00ecnh CSV th\u00e0nh th\u00f4ng tin h\u1eefu \u00edch h\u01a1n. \u0110\u00e2y l\u00e0 b\u00e0i \u0111\u1ea7u ti\u00ean h\u01b0\u1edbng d\u1eabn m\u1ed9t s\u1ed1 ph\u00e9p bi\u1ebfn \u0111\u1ed5i, \u0111i\u1ec1u n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c h\u01b0\u1edbng d\u1eabn r\u00f5 h\u01a1n trong c\u00e1c ph\u1ea7n sau.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o c\u1ed9t Date. Tr\u00ean thanh l\u00e0m vi\u1ec7c v\u00e0o<\/span><b> Transform \u2013&gt; Date\u2013&gt;Month \u2013&gt;End of month <\/b><span style=\"font-weight: 400\">(thao t\u00e1c n\u00e0y s\u1ebd thay \u0111\u1ed5i c\u1ed9t Date th\u00e0nh ng\u00e0y cu\u1ed1i c\u00f9ng trong th\u00e1ng theo l\u1ecbch).<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o ti\u00eau \u0111\u1ec1 c\u1ed9t Product, sau \u0111\u00f3 gi\u1eef ph\u00edm Shift v\u00e0 nh\u1ea5p v\u00e0o ti\u00eau \u0111\u1ec1 c\u1ed9t Sold By. Sau khi c\u1ea3 2 c\u1ed9t \u0111\u01b0\u1ee3c ch\u1ecdn, nh\u1ea5n tab <\/span><b>Home \u2013&gt; Remove Columns<\/b><span style=\"font-weight: 400\">. (thao t\u00e1c n\u00e0y x\u00f3a c\u00e1c c\u1ed9t \u0111\u00e3 ch\u1ecdn).<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u00e2y gi\u1edd ch\u00fang ta chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u tr\u00ean c\u1ed9t Date. Ch\u1ecdn ti\u00eau \u0111\u1ec1 c\u1ed9t Date sau \u0111\u00f3 nh\u1ea5n <\/span><b>Transform \u2013&gt; Pivot Column<\/b><span style=\"font-weight: 400\"> tr\u00ean thanh l\u00e0m vi\u1ec7c.<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u1eeda s\u1ed5 Pivot Column s\u1ebd m\u1edf ra. Thay \u0111\u1ed5i c\u1ed9t <\/span><b>Values Column<\/b><span style=\"font-weight: 400\"> th\u00e0nh <\/span><i><span style=\"font-weight: 400\">Value<\/span><\/i><span style=\"font-weight: 400\">. Nh\u1ea5p v\u00e0o t\u00f9y ch\u1ecdn n\u00e2ng cao v\u00e0 \u0111\u1eb7t <\/span><b>Aggregate Value Function<\/b><span style=\"font-weight: 400\"> th\u00e0nh <\/span><i><span style=\"font-weight: 400\">Sum<\/span><\/i><span style=\"font-weight: 400\">, Sau \u0111\u00f3 nh\u1ea5p v\u00e0o <\/span><b>OK<\/b><span style=\"font-weight: 400\">.<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u00e2y gi\u1edd nh\u1ea5p v\u00e0o tab<\/span><b> Home\u2013&gt; Close&amp;Load. <\/b><span style=\"font-weight: 400\">Excel s\u1ebd t\u1ea1o m\u1ed9t trang t\u00ednh m\u1edbi v\u1edbi m\u1ed9t b\u1ea3ng v\u00e0 b\u1ea3ng n\u00e0y ch\u1ee9a d\u1eef li\u1ec7u t\u1eeb CSV \u0111\u00e3 \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ed5i. Gi\u1ed1ng nh\u01b0 \u1ea3nh ch\u1ee5p b\u00ean d\u01b0\u1edbi:<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cap_nhat_du_lieu_nguon\"><\/span><b>C\u1eadp nh\u1eadt d\u1eef li\u1ec7u ngu\u1ed3n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 th\u1ef1c hi\u1ec7n qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c m\u1edbi, ch\u00fang ta m\u00f4 ph\u1ecfng n\u01a1i ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c t\u1ec7p m\u1edbi h\u00e0ng ng\u00e0y, h\u00e0ng tu\u1ea7n ho\u1eb7c h\u00e0ng th\u00e1ng. \u0110\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y ch\u00fang ta \u0111\u1ed5i t\u00ean c\u1ea3 hai s\u1ed5 l\u00e0m vi\u1ec7c m\u1eabu.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><i><span style=\"font-weight: 400\">Example -Data Refresh 1.csv <\/span><\/i><span style=\"font-weight: 400\">c\u00f3 th\u1ec3 \u0111\u1ed5i t\u00ean th\u00e0nh b\u1ea5t k\u1ef3 th\u1ee9 g\u00ec.<\/span><\/li>\n<li style=\"font-weight: 400\"><i><span style=\"font-weight: 400\">Example 6 \u2013 Data Refresh 2.csv <\/span><\/i><span style=\"font-weight: 400\">\u0111\u01b0\u1ee3c \u0111\u1ed5i t\u00ean th\u00e0nh <\/span><i><span style=\"font-weight: 400\">Example 6 \u2013 Data Refresh 1.csv<\/span><\/i><span style=\"font-weight: 400\">\u00a0.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">Power Query v\u1eabn \u0111ang tr\u1ecf \u0111\u1ebfn m\u1ed9t t\u1ec7p c\u00f3 t\u00ean l\u00e0\u00a0<\/span><i><span style=\"font-weight: 400\">Example 6 \u2013 Data Refresh 1.csv\u00a0 <\/span><\/i><span style=\"font-weight: 400\">c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u m\u1edbi.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Lam_moi_du_lieu\"><\/span><b>L\u00e0m m\u1edbi d\u1eef li\u1ec7u<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o <\/span><b>Data \u2013&gt;Refresh all.<\/b><\/p>\n<p><span style=\"font-weight: 400\">Excel s\u1ebd nh\u1eadp d\u1eef li\u1ec7u t\u1eeb t\u1ec7p Power Query \u00e1p d\u1ee5ng c\u00e1c ph\u00e9p bi\u1ebfn \u0111\u1ed5i t\u01b0\u01a1ng t\u1ef1 v\u00e0 t\u1ea3i d\u1eef li\u1ec7u v\u00e0o trang t\u00ednh. D\u1eef li\u1ec7u m\u1edbi s\u1ebd t\u1ef1 \u0111\u1ed9ng xu\u1ea5t hi\u1ec7n tr\u00ean trang t\u00ednh.<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00f3 th\u1ec3 nh\u00ecn th\u1ea5y d\u1eef li\u1ec7u th\u00e1ng 3 xu\u1ea5t hi\u1ec7n ch\u1ec9 v\u1edbi m\u1ed9t c\u00fa nh\u1ea5p chu\u1ed9t.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Khi xu\u1ea5t hi\u1ec7n s\u1ef1 thay \u0111\u1ed5i v\u1edbi c\u00e1c c\u00e1c d\u1eef li\u1ec7u hi\u1ec7n t\u1ea1i ho\u1eb7c n\u01a1i nh\u1eadn t\u1ec7p m\u1edbi b\u1ea1n ch\u1ec9 c\u1ea7n l\u01b0u t\u1ec7p v\u1edbi c\u00f9ng \u0111\u01b0\u1eddng d\u1eabn t\u1ec7p ch\u1ec9 b\u1eb1ng m\u1ed9t c\u00fa nh\u1ea5p chu\u1ed9t,<\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong ph\u1ea7n sau ch\u00fang ta s\u1ebd xem x\u00e9t vi\u1ec7c li\u00ean k\u1ebft \u0111\u01b0\u1eddng d\u1eabn t\u1ec7p v\u1edbi m\u1ed9t \u00f4. B\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp m\u00e0 kh\u00f4ng c\u1ea7n ghi \u0111\u00e8 l\u00ean c\u00e1c t\u1ec7p tr\u01b0\u1edbc \u0111\u00f3.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Lam_moi_cac_truy_van_cu_the\"><\/span><b>L\u00e0m m\u1edbi c\u00e1c truy v\u1ea5n c\u1ee5 th\u1ec3<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Ch\u00fang ta c\u00f3 th\u1ec3 m\u1ea5t m\u1ed9t kho\u1ea3ng th\u1eddi gian \u0111\u1ec3 l\u00e0m m\u1edbi t\u1ea5t c\u1ea3 khi c\u00f3 nhi\u1ec1u truy v\u1ea5n trong c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c. Trong nh\u1eefng tr\u01b0\u1eddng h\u1ee3p \u0111\u00f3 l\u00e0m c\u00e1ch n\u00e0o ch\u1ec9 th\u1ef1c hi\u1ec7n nh\u1eefng truy v\u1ea5n m\u00e0 ch\u00fang ta c\u1ea7n. C\u00f3 m\u1ed9t s\u1ed1 c\u00e1ch th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Nut_Refresh\"><\/span><b>N\u00fat Refresh<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">B\u1ea1n nh\u1eadp v\u00e0o m\u1ed9t truy v\u1ea5n trong b\u1ea3ng, tr\u00ean thanh l\u00e0m vi\u1ec7c nh\u1ea5p Data\u2013&gt; menu th\u1ea3 xu\u1ed1ng v\u1edbi m\u1ed9t s\u1ed1 Refresh v\u1edbi t\u00f9y ch\u1ecdn.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o Refresh \u0111\u1ec3 l\u00e0m m\u1edbi truy v\u1ea5n b\u1ea1n \u0111\u00e3 ch\u1ecdn.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Menu_Query_and_Connections_truy_van_va_ket_noi\"><\/span><b>Menu Query and Connections (truy v\u1ea5n v\u00e0 k\u1ebft n\u1ed1i)<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Khi t\u1ea3i d\u1eef li\u1ec7u t\u1eeb Power Query v\u00e0o Excel, menu <\/span><b>Queries and Connections<\/b><span style=\"font-weight: 400\"> s\u1ebd m\u1edf ra. C\u1eeda s\u1ed5 n\u00e0y hi\u1ec3n th\u1ecb t\u1ea5t c\u1ea3 c\u00e1c truy v\u1ea5n \u0111\u01b0\u1ee3c t\u1ea1o trong trang l\u00e0m vi\u1ec7c.<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu menu \u0111\u00f3 kh\u00f4ng m\u1edf, h\u00e3y nh\u1ea5p v\u00e0o <\/span><b>Data -&gt; Queries and Connections.<\/b><\/p>\n<p><span style=\"font-weight: 400\">M\u1ed7i truy v\u1ea5n trong menu <\/span><b>Queries and Connections<\/b><span style=\"font-weight: 400\"> c\u00f3 m\u1ed9t bi\u1ec3u t\u01b0\u1ee3ng l\u00e0m m\u1edbi.\u00a0Ch\u1ec9 c\u1ea7n nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng \u0111\u1ec3 l\u00e0m m\u1edbi d\u1eef li\u1ec7u.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ngo\u00e0i ra, ch\u00fang ta c\u00f3 th\u1ec3 nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o truy v\u1ea5n v\u00e0 ch\u1ecdn <\/span><b>Refresh<\/b><span style=\"font-weight: 400\"> t\u1eeb menu.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Lam_moi_VBA\"><\/span><b>L\u00e0m m\u1edbi VBA<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">M\u1ee5c n\u00e0y s\u1ebd kh\u00f4ng tr\u00ecnh b\u00e0y trong lo\u1ea1t b\u00e0i n\u00e0y, nh\u01b0ng b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng VBA \u0111\u1ec3 l\u00e0m m\u1edbi c\u00e1c truy v\u1ea5n ri\u00eang l\u1ebb.\u00a0\u0110\u00e2y c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t t\u00f9y ch\u1ecdn h\u1eefu \u00edch khi:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">B\u1ea1n mu\u1ed1n cung c\u1ea5p m\u1ed9t giao di\u1ec7n d\u1ec5 s\u1eed d\u1ee5ng cho ng\u01b0\u1eddi d\u00f9ng<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">B\u1ea1n mu\u1ed1n ki\u1ec3m so\u00e1t th\u1ee9 t\u1ef1 l\u00e0m m\u1edbi c\u00e1c truy v\u1ea5n.<\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Tuy_chon_lam_moi_nang_cao\"><\/span><b>T\u00f9y ch\u1ecdn l\u00e0m m\u1edbi n\u00e2ng cao<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Vi\u1ec7c l\u00e0m m\u1edbi c\u00e1c truy v\u1ea5n ri\u00eang l\u1ebb c\u00f3 th\u1ec3 tr\u1edf n\u00ean t\u1ed1n th\u1eddi gian ho\u1eb7c qu\u00e1 ch\u1eadm khi nhi\u1ec1u truy v\u1ea5n \u0111\u01b0\u1ee3c th\u00eam v\u00e0o c\u00e1c trang l\u00e0m vi\u1ec7c. Tuy nhi\u00ean, Excel \u0111\u00e3 th\u00eam m\u1ed9t s\u1ed1 c\u00e1c t\u00f9y ch\u1ecdn \u0111\u1ec3 cho ph\u00e9p d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c l\u00e0m m\u1edbi t\u1ef1 \u0111\u1ed9ng.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ch\u1ecdn m\u1ed9t \u00f4 trong m\u1ed9t B\u1ea3ng truy v\u1ea5n, sau \u0111\u00f3 nh\u1ea5p v\u00e0o<\/span> <b>Data -&gt;\u00a0 Refresh All (Drop Down) -&gt; Connection Properties.<\/b><\/p>\n<p><span style=\"font-weight: 400\">C\u00e1c <\/span><b>Query Properties <\/b><span style=\"font-weight: 400\">s\u1ebd \u0111\u01b0\u1ee3c m\u1edf ra:<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00e1c t\u00f9y ch\u1ecdn l\u00e0m m\u1edbi c\u00f3 s\u1eb5n trong c\u1eeda s\u1ed5 n\u00e0y l\u00e0:<\/span><\/p>\n<p><b><i>Background refresh: <\/i><\/b><span style=\"font-weight: 400\">cho ph\u00e9p b\u1ea1n\u00a0 ti\u1ebfp t\u1ee5c l\u00e0m vi\u1ec7c trong khi d\u1eef li\u1ec7u l\u00e0m m\u1edbi di\u1ec5n ra \u1edf background.\u00a0N\u00f3 \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb theo m\u1eb7c \u0111\u1ecbnh.\u00a0N\u1ebfu ch\u00fang ta x\u00f3a t\u00f9y ch\u1ecdn n\u00e0y th\u00ec s\u1ebd kh\u00f4ng th\u1ec3 l\u00e0m vi\u1ec7c cho \u0111\u1ebfn khi qu\u00e1 tr\u00ecnh l\u00e0m m\u1edbi ho\u00e0n t\u1ea5t.\u00a0V\u1edbi t\u00ednh n\u0103ng n\u00e0y \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng, qu\u00e1 tr\u00ecnh l\u00e0m m\u1edbi s\u1ebd m\u1ea5t nhi\u1ec1u th\u1eddi gian h\u01a1n, tuy nhi\u00ean b\u1ea1n v\u1eabn c\u00f3 th\u1ec3 ti\u1ebfp t\u1ee5c l\u00e0m vi\u1ec7c.<\/span><\/p>\n<p><b><i>Refresh every x minutes:<\/i><\/b> <span style=\"font-weight: 400\">C\u00e1c trang l\u00e0m vi\u1ec7c ph\u1ea3i \u0111\u01b0\u1ee3c m\u1edf \u0111\u1ec3 t\u00f9y ch\u1ecdn <\/span><b>Refresh every x minutes\u00a0<\/b><span style=\"font-weight: 400\"> ho\u1ea1t \u0111\u1ed9ng.\u00a0T\u00ednh n\u0103ng n\u00e0y h\u1eefu \u00edch khi d\u1eef li\u1ec7u ngu\u1ed3n th\u01b0\u1eddng xuy\u00ean thay \u0111\u1ed5i.\u00a0B\u1ea1n ch\u1ec9 n\u00ean s\u1eed d\u1ee5ng t\u00f9y ch\u1ecdn n\u00e0y khi b\u1eadt t\u00ednh n\u0103ng <\/span><b>Background refresh<\/b><span style=\"font-weight: 400\">, n\u1ebfu kh\u00f4ng n\u00f3 c\u00f3 th\u1ec3 ph\u00e1t sinh nh\u1eefng v\u1ea5n \u0111\u1ec1 cho ng\u01b0\u1eddi d\u00f9ng.<\/span><\/p>\n<p><b><i>Refresh when opening the file: <\/i><\/b><span style=\"font-weight: 400\">T\u1ef1 \u0111\u1ed9ng l\u00e0m m\u1edbi d\u1eef li\u1ec7u khi m\u1edf t\u1ec7p l\u00e0 m\u1ed9t t\u00ednh n\u0103ng h\u1eefu \u00edch v\u00ec d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt b\u1ea5t c\u1ee9 khi n\u00e0o b\u1ea1n m\u1edf t\u1ec7p.<\/span><\/p>\n<p><b><i>Refresh this connection on Refresh All:<\/i><\/b> <span style=\"font-weight: 400\">n\u01a1i truy v\u1ea5n ch\u1ee9a d\u1eef li\u1ec7u c\u1ed1 \u0111\u1ecbnh, b\u1ea1n kh\u00f4ng c\u1ea7n l\u00e0m m\u1edbi n\u00f3 nhi\u1ec1u l\u1ea7n. B\u1ea1n ch\u1ec9 c\u1ea7n x\u00f3a d\u1ea5u t\u00edch b\u00ean c\u1ea1nh h\u1ed9p <\/span><i><span style=\"font-weight: 400\">Refresh this connection on Refresh All<\/span><\/i><span style=\"font-weight: 400\"> th\u00ec n\u00f3 s\u1ebd x\u00f3a c\u00e1c truy v\u1ea5n kh\u1ecfi quy tr\u00ecnh.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Nhung_luu_y_khi_ban_lam_moi_du_lieu\"><\/span><b>Nh\u1eefng l\u01b0u \u00fd khi b\u1ea1n l\u00e0m m\u1edbi d\u1eef li\u1ec7u<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">D\u01b0\u1edbi \u0111\u00e2y s\u1ebd l\u00e0 m\u1ed9t s\u1ed1 kh\u00f3 kh\u0103n m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 g\u1eb7p ph\u1ea3i<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dong_va_mo_tep\"><\/span><b>\u0110\u00f3ng v\u00e0 m\u1edf t\u1ec7p<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">V\u1ecb tr\u00ed l\u01b0u tr\u1eef d\u1eef li\u1ec7u ngu\u1ed3n r\u1ea5t quan tr\u1ecdng \u0111\u1ed1i v\u1edbi vi\u1ec7c l\u00e0m m\u1edbi d\u1eef li\u1ec7u.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Khi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef trong t\u1ec7p b\u00ean ngo\u00e0i nh\u01b0 CSV, v\u0103n b\u1ea3n ho\u1eb7c l\u00e0 c\u00e1c workbook c\u1ee7a Excel th\u00ec n\u00f3 l\u00e0 phi\u00ean b\u1ea3n \u0111\u01b0\u1ee3c l\u01b0u cu\u1ed1i c\u00f9ng c\u1ee7a t\u1ec7p \u0111\u01b0\u1ee3c t\u1ea3i v\u00e0o Power Query. N\u1ebfu t\u1ec7p b\u00ean ngo\u00e0i \u0111ang m\u1edf, c\u00e1c thay \u0111\u1ed5i s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c bao g\u1ed3m trong qu\u00e1 tr\u00ecnh l\u00e0m m\u1edbi cho \u0111\u1ebfn khi ch\u00fang \u0111\u01b0\u1ee3c l\u01b0u.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">Khi d\u1eef li\u1ec7u v\u00e0 truy v\u1ea5n n\u1eb1m trong c\u00f9ng m\u1ed9t s\u1ed5 l\u00e0m vi\u1ec7c, t\u1ea5t c\u1ea3 c\u00e1c thay \u0111\u1ed5i \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p ngay c\u1ea3 khi t\u1ec7p ch\u01b0a \u0111\u01b0\u1ee3c l\u01b0u.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Truy_van_dua_tren_cac_truy_van_khac\"><\/span><b>Truy v\u1ea5n d\u1ef1a tr\u00ean c\u00e1c truy v\u1ea5n kh\u00e1c<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Trong c\u00e1c b\u00e0i \u0111\u0103ng ti\u1ebfp theo s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n xem x\u00e9t s\u1eed d\u1ee5ng truy v\u1ea5n d\u1ef1a tr\u00ean m\u1ed9t truy v\u1ea5n kh\u00e1c. Nh\u01b0ng ch\u00fang ta ph\u1ea3i c\u1ea7n l\u01b0u \u00fd v\u1ec1 k\u1ebft qu\u1ea3 n\u1ebfu ch\u00fang ta ch\u1ec9 l\u00e0m m\u1edbi m\u1ed9t truy v\u1ea5n duy nh\u1ea5t v\u00ec m\u1ecdi truy v\u1ea5n ti\u1ebfp theo trong chu\u1ed7i s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c l\u00e0m m\u1edbi.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Background_refresh\"><\/span><b>Background refresh\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">\u0110\u00e2y l\u00e0 m\u1ed9t t\u00ednh n\u0103ng h\u1eefu \u00edch v\u00ec ch\u00fang ta c\u00f3 th\u1ec3 ti\u1ebfp t\u1ee5c l\u00e0m vi\u1ec7c trong Excel.\u00a0Tuy nhi\u00ean, b\u1ea5t k\u1ef3 PivotTables ho\u1eb7c c\u00f4ng th\u1ee9c n\u00e0o \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt ho\u1eb7c t\u00ednh to\u00e1n tr\u01b0\u1edbc khi qu\u00e1 tr\u00ecnh background refresh ho\u00e0n t\u1ea5t th\u00ec ch\u00fang ta kh\u00f4ng nh\u1ea5t thi\u1ebft ph\u1ea3i c\u00f3 d\u1eef li\u1ec7u ch\u00ednh x\u00e1c.\u00a0Do \u0111\u00f3, trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n c\u00f3 th\u1ec3 kh\u00f4ng c\u1ea7n \u0111\u1ebfn background refresh.<\/span><\/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-162.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2136,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2135","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\/2135","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=2135"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2135\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2136"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2135"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2135"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2135"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}