{"id":4003,"date":"2024-12-04T08:31:38","date_gmt":"2024-12-04T08:31:38","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/power-query-la-gi-tai-sao-can-hoc-power-query\/"},"modified":"2024-12-04T08:31:38","modified_gmt":"2024-12-04T08:31:38","slug":"power-query-la-gi-tai-sao-can-hoc-power-query","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/power-query-la-gi-tai-sao-can-hoc-power-query\/","title":{"rendered":"Power Query l\u00e0 g\u00ec? T\u1ea1i sao c\u1ea7n h\u1ecdc Power Query?"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Tr\u01b0\u1edbc\u00a0\u0111\u00e2y t\u00f4i c\u0169ng gi\u1ed1ng nh\u01b0 b\u1ea1n,\u00a0\u0111\u00f3 l\u00e0 ch\u1eb3ng c\u1ea7n bi\u1ebft Power Query l\u00e0 g\u00ec. T\u00f4i c\u1ee9 s\u1eed d\u1ee5ng\u00a0Excel m\u1ed9t c\u00e1ch t\u1ef1 nhi\u00ean, v\u00f4 th\u1ee9c. C\u00f3 nh\u1eefng l\u00fac c\u00f4ng vi\u1ec7c tr\u1edf n\u00ean r\u1ea5t ph\u1ee9c t\u1ea1p: Khi ph\u1ea3i l\u00e0m s\u1ea1ch 1 b\u1ea3ng d\u1eef li\u1ec7u t\u1eeb ng\u01b0\u1eddi kh\u00e1c g\u1eedi (hay tr\u00edch xu\u1ea5t t\u1eeb ph\u1ea7n m\u1ec1m ra, ho\u1eb7c t\u1ea3i t\u1eeb tr\u00ean m\u1ea1ng v\u1ec1), khi th\u00ec ph\u1ea3i gom d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u file\u00a0Excel v\u00e0o chung 1 file\u2026 Nh\u1eefng vi\u1ec7c\u00a0\u0111\u00f3 khi\u1ebfn t\u00f4i m\u1ea5t nhi\u1ec1u th\u1eddi gian. Mu\u1ed1n t\u1ef1\u00a0\u0111\u1ed9ng nh\u1eefng vi\u1ec7c n\u00e0y, t\u00f4i c\u00f3 t\u00ecm hi\u1ec3u c\u1ea3 VBA. Nh\u01b0ng\u00a0\u0111\u1ec3 d\u00f9ng\u00a0\u0111\u01b0\u1ee3c VBA l\u00e0m nh\u1eefng vi\u1ec7c n\u00e0y th\u00ec c\u0169ng m\u1ea5t kh\u00e1 nhi\u1ec1u th\u1eddi gian. T\u00f4i t\u1ef1 h\u1ecfi: c\u00f3 c\u00e1ch n\u00e0o gi\u00fap l\u00e0m nh\u1eefng vi\u1ec7c n\u00e0y tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n kh\u00f4ng?<\/p>\n<p>H\u00f3a ra gi\u1ea3i ph\u00e1p\u00a0\u0111\u00e3 c\u00f3 s\u1eb5n r\u1ed3i, ch\u1ec9 l\u00e0 t\u00f4i kh\u00f4ng ch\u00fa\u00a0\u00fd t\u1edbi n\u00f3. Gi\u1ea3i ph\u00e1p ch\u00ednh l\u00e0 <strong>Power Query<\/strong>.<\/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-67501369c0284\" 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-la-gi-tai-sao-can-hoc-power-query.html#Power_Query_la_gi\" title=\"Power Query l\u00e0 g\u00ec?\">Power Query l\u00e0 g\u00ec?<\/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\/power-query-la-gi-tai-sao-can-hoc-power-query.html#Tai_sao_can_hoc_Power_Query\" title=\"T\u1ea1i sao c\u1ea7n h\u1ecdc Power Query?\">T\u1ea1i sao c\u1ea7n h\u1ecdc Power Query?<\/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\/power-query-la-gi-tai-sao-can-hoc-power-query.html#Cach_cau_truc_bang_du_lieu_dung\" title=\"C\u00e1ch c\u1ea5u tr\u00fac b\u1ea3ng d\u1eef li\u1ec7u\u00a0\u0111\u00fang\">C\u00e1ch c\u1ea5u tr\u00fac b\u1ea3ng d\u1eef li\u1ec7u\u00a0\u0111\u00fang<\/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-la-gi-tai-sao-can-hoc-power-query.html#Cac_gia_tri_duoc_nhap_vao_la_dung_ve_loai_du_lieu\" title=\"C\u00e1c gi\u00e1 tr\u1ecb\u00a0\u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o l\u00e0\u00a0\u0111\u00fang v\u1ec1 lo\u1ea1i d\u1eef li\u1ec7u\">C\u00e1c gi\u00e1 tr\u1ecb\u00a0\u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o l\u00e0\u00a0\u0111\u00fang v\u1ec1 lo\u1ea1i d\u1eef li\u1ec7u<\/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\/power-query-la-gi-tai-sao-can-hoc-power-query.html#Tap_hop_du_lieu_tu_nhieu_Sheet_nhieu_Workbook_vao_1_bang_chung\" title=\"T\u1eadp h\u1ee3p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u Sheet, nhi\u1ec1u\u00a0Workbook v\u00e0o 1 b\u1ea3ng chung\">T\u1eadp h\u1ee3p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u Sheet, nhi\u1ec1u\u00a0Workbook v\u00e0o 1 b\u1ea3ng chung<\/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-6\" href=\"https:\/\/blog.hocexcel.online\/power-query-la-gi-tai-sao-can-hoc-power-query.html#Power_Query_de_hoc_va_de_su_dung\" title=\"Power Query d\u1ec5 h\u1ecdc\u00a0v\u00e0 d\u1ec5 s\u1eed d\u1ee5ng\">Power Query d\u1ec5 h\u1ecdc\u00a0v\u00e0 d\u1ec5 s\u1eed d\u1ee5ng<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Power_Query_la_gi\"><\/span>Power Query l\u00e0 g\u00ec?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Power Query l\u00e0\u00a0c\u00f4ng c\u1ee5 gi\u00fap t\u1ea1o ra 1 quy tr\u00ecnh t\u1ef1\u00a0\u0111\u1ed9ng cho vi\u1ec7c t\u1ed5 ch\u1ee9c, x\u1eed l\u00fd, t\u00e1i c\u1ea5u tr\u00fac l\u1ea1i b\u1ea3ng d\u1eef li\u1ec7u.<\/p>\n<p>Trong c\u00e1c phi\u00ean b\u1ea3n\u00a0Office 2013 tr\u1edf v\u1ec1 tr\u01b0\u1edbc (2010, 2013), b\u1ea1n ph\u1ea3i c\u00e0i\u00a0\u0111\u1eb7t Power Query d\u01b0\u1edbi d\u1ea1ng 1 Add-in (ti\u1ec7n\u00a0\u00edch m\u1edf r\u1ed9ng).<\/p>\n<p>T\u1eeb phi\u00ean b\u1ea3n\u00a0Office\u00a02016 tr\u1edf v\u1ec1 sau (2016, 2019, 365), Power Query\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c t\u00edch h\u1ee3p s\u1eb5n trong\u00a0Excel: Nh\u00f3m Get &amp; Transform Data trong th\u1ebb Data<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-30446\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/power-query-trong-excel-365.png\" width=\"669\" height=\"161\" title=\"power-query-trong-excel-365\"><\/p>\n<p style=\"text-align: center\"><em>Giao di\u1ec7n Get &amp; Transform Data trong\u00a0th\u1ebb Data<\/em><\/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-318.gif\" title=\"ex101_92019-nho-318\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tai_sao_can_hoc_Power_Query\"><\/span>T\u1ea1i sao c\u1ea7n h\u1ecdc Power Query?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Khi\u00a0\u0111\u01b0\u1ee3c h\u1ecfi \u201c<strong>\u0111i\u1ec1u g\u00ec l\u00e0 quan tr\u1ecdng nh\u1ea5t<\/strong>\u201d khi l\u00e0m vi\u1ec7c tr\u00ean\u00a0Excel, t\u00f4i s\u1ebd n\u00f3i ngay r\u1eb1ng: <strong>C\u1ea7n\u00a0ch\u1eafc ch\u1eafn r\u1eb1ng d\u1eef li\u1ec7u\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c l\u00e0m s\u1ea1ch v\u00e0 th\u1ed1ng nh\u1ea5t<\/strong>.\u00a0\u0110i\u1ec1u n\u00e0y bao g\u1ed3m:<\/p>\n<ul>\n<li>C\u00e1ch c\u1ea5u tr\u00fac b\u1ea3ng d\u1eef li\u1ec7u\u00a0\u0111\u00fang.\u00a0M\u1ed7i khi b\u1ebf t\u1eafc trong vi\u1ec7c t\u00ednh to\u00e1n v\u1edbi d\u1eef li\u1ec7u, t\u00f4i\u00a0\u0111\u1ec1u ngh\u0129 t\u1edbi vi\u1ec7c \u201cc\u1ea5u tr\u00fac l\u1ea1i\u201d. Khi c\u1ea5u tr\u00fac l\u1ea1i th\u00ec h\u00f3a ra vi\u1ec7c t\u00ednh to\u00e1n l\u1ea1i tr\u1edf n\u00ean v\u00f4 c\u00f9ng\u00a0\u0111\u01a1n gi\u1ea3n.<\/li>\n<li>C\u00e1c gi\u00e1 tr\u1ecb\u00a0\u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o l\u00e0\u00a0\u0111\u00fang v\u1ec1 lo\u1ea1i d\u1eef li\u1ec7u, v\u1ec1 n\u1ed9i dung v\u00e0\u00a0\u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt li\u00ean t\u1ee5c<\/li>\n<li>C\u00e1c b\u1ea3ng d\u1eef li\u1ec7u\u00a0c\u00f9ng 1 ch\u1ee9c n\u0103ng c\u1ea7n\u00a0\u0111\u01b0\u1ee3c t\u1eadp h\u1ee3p th\u1ed1ng nh\u1ea5t trong 1 b\u1ea3ng. Vi\u1ec7c n\u00e0y c\u0169ng c\u1ea7n\u00a0\u0111\u01b0\u1ee3c l\u00e0m 1 c\u00e1ch t\u1ef1\u00a0\u0111\u1ed9ng.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Cach_cau_truc_bang_du_lieu_dung\"><\/span>C\u00e1ch c\u1ea5u tr\u00fac b\u1ea3ng d\u1eef li\u1ec7u\u00a0\u0111\u00fang<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Vi\u1ec7c c\u1ea5u tr\u00fac b\u1ea3ng d\u1eef li\u1ec7u\u00a0\u0111\u00fang c\u00e1ch c\u00f3 th\u1ec3 gi\u00fap\u00a0\u00edch r\u1ea5t nhi\u1ec1u:<\/p>\n<ul>\n<li>C\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m SUMIFS, COUNTIFS\u00a0\u0111\u1ec3\u00a0t\u00ednh to\u00e1n, b\u00e1o c\u00e1o theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n\u00a0m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng<\/li>\n<li>C\u00f3 th\u1ec3 tr\u00edch l\u1ecdc d\u1eef li\u1ec7u chi ti\u1ebft b\u1eb1ng Advanced Filter m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng<\/li>\n<li>S\u1eed d\u1ee5ng\u00a0\u0111\u01b0\u1ee3c Pivot Table\u00a0\u0111\u1ec3 l\u00e0m c\u00e1c b\u00e1o c\u00e1o\u00a0\u0111\u1ed9ng, b\u00e1o c\u00e1o\u00a0ph\u00e2n t\u00edch d\u1eef li\u1ec7u\u2026<\/li>\n<\/ul>\n<p>H\u00ecnh d\u01b0\u1edbi\u00a0\u0111\u00e2y s\u1ebd m\u00f4 t\u1ea3 th\u1ebf n\u00e0o l\u00e0 1 b\u1ea3ng d\u1eef li\u1ec7u\u00a0\u0111\u01b0\u1ee3c c\u1ea5u tr\u00fac\u00a0\u0111\u00fang:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-30456\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cc3a1ch-ce1baa5u-trc3bac-be1baa3ng-de1bbaf-lie1bb87u-c491c3bang.png\" width=\"803\" height=\"470\" title=\"cc3a1ch-ce1baa5u-trc3bac-be1baa3ng-de1bbaf-lie1bb87u-c491c3bang\"><\/p>\n<p>Nh\u01b0ng kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o ch\u00fang ta c\u0169ng l\u00e0m vi\u1ec7c ngay v\u1edbi c\u1ea5u tr\u00fac\u00a0\u0111\u00fang. B\u1edfi vi\u1ec7c nh\u1eadp d\u1eef li\u1ec7u trong c\u1ea5u tr\u00fac\u00a0\u0111\u00fang m\u1ea5t r\u1ea5t nhi\u1ec1u th\u1eddi gian. B\u1ea1n ph\u1ea3i nh\u1eadp\u00a0\u0111\u1ee7 n\u1ed9i dung\u00a0tr\u00ean t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t, trong khi v\u1edbi c\u1ea5u tr\u00fac b\u00ean ph\u1ea3i, ch\u1ec9 c\u1ea7n nh\u1eadp m\u1ed7i gi\u00e1 tr\u1ecb t\u1ea1i v\u1ecb tr\u00ed giao\u00a0\u0111i\u1ec3m c\u1ee7a c\u00e1c\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng\u00a0\u0111\u00e3 c\u00f3 s\u1eb5n.\u00a0\u0110\u00f3 l\u00e0 l\u00fd do t\u1ea1i sao ng\u01b0\u1eddi ta l\u1ea1i hay ch\u1ecdn c\u00e1ch nh\u1eadp d\u1eef li\u1ec7u tr\u00ean 1 c\u1ea5u tr\u00fac kh\u00f4ng\u00a0\u0111\u00fang chu\u1ea9n.<\/p>\n<p>\u0110i\u1ec1u n\u00e0y d\u1eabn t\u1edbi 1 kh\u00f3 kh\u0103n l\u00e0: ph\u1ea3i c\u1ea5u tr\u00fac l\u1ea1i th\u00ec m\u1edbi t\u00ednh ra k\u1ebft qu\u1ea3 nh\u01b0\u00a0\u00fd mu\u1ed1n\u00a0\u0111\u01b0\u1ee3c.<\/p>\n<p>Th\u1eed h\u00ecnh dung b\u1ea1n ph\u1ea3i t\u1ed5 ch\u1ee9c l\u1ea1i 1 c\u00e1ch th\u1ee7 c\u00f4ng, copy paste t\u1eebng ph\u1ea7n, r\u1ed3i ph\u1ea3i xoay chuy\u1ec3n c\u00e1ch bi\u1ec3u di\u1ec5n c\u00e1c n\u1ed9i dung\u2026 qu\u1ea3 l\u00e0 1 c\u00f4ng vi\u1ec7c kh\u00f3 kh\u0103n v\u00e0 t\u1ed1n th\u1eddi gian.<\/p>\n<p>Power Query gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng c\u1ea5u tr\u00fac\u00a0l\u1ea1i b\u1ea3ng d\u1eef li\u1ec7u.\u00a0\u0110\u1eb7c bi\u1ec7t h\u01a1n n\u1eefa l\u00e0\u00a0nh\u1eefng g\u00ec b\u1ea1n l\u00e0m trong Power Query\u00a0\u0111\u1ec1u\u00a0\u0111\u01b0\u1ee3c ghi l\u1ea1i, gi\u00fap cho vi\u1ec7c c\u1eadp nh\u1eadt\u00a0th\u00eam th\u00f4ng tin trong b\u1ea3ng d\u1eef li\u1ec7u g\u1ed1c s\u1ebd\u00a0\u0111\u01b0\u1ee3c t\u1ef1\u00a0\u0111\u1ed9ng c\u1eadp nh\u1eadt v\u00e0o b\u1ea3ng k\u1ebft qu\u1ea3\u00a0\u0111\u00e3 t\u00e1i c\u1ea5u tr\u00fac.<\/p>\n<p>Tham kh\u1ea3o:<\/p>\n<p style=\"padding-left: 30px\"><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<h3><span class=\"ez-toc-section\" id=\"Cac_gia_tri_duoc_nhap_vao_la_dung_ve_loai_du_lieu\"><\/span>C\u00e1c gi\u00e1 tr\u1ecb\u00a0\u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o l\u00e0\u00a0\u0111\u00fang v\u1ec1 lo\u1ea1i d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Khi l\u1ea5y d\u1eef li\u1ec7u t\u1eeb c\u00e1c ngu\u1ed3n kh\u00f4ng ph\u1ea3i t\u1eeb\u00a0Excel:\u00a0Web, SQL, c\u00e1c ph\u1ea7n m\u1ec1m kh\u00e1c\u2026 th\u00ec ch\u00fang ta kh\u00f4ng\u00a0\u0111\u1ec3 ch\u1eafc ch\u1eafn\u00a0\u0111\u01b0\u1ee3c v\u1ec1 lo\u1ea1i d\u1eef li\u1ec7u nh\u1eadn\u00a0\u0111\u01b0\u1ee3c. C\u00e1c d\u1eef li\u1ec7u d\u1ea1ng Number, Date th\u01b0\u1eddng b\u1ecb nh\u1ea7m l\u1eabn sang d\u1ea1ng Text, khi\u1ebfn cho vi\u1ec7c t\u00ednh to\u00e1n s\u1ebd kh\u00f4ng ra k\u1ebft qu\u1ea3\u00a0\u0111\u00fang.<\/p>\n<p>Th\u00f4ng th\u01b0\u1eddng b\u1ea1n s\u1ebd ph\u1ea3i s\u1eeda l\u1ea1i d\u1eef li\u1ec7u,\u00a0\u0111\u1ecbnh d\u1ea1ng l\u1ea1i. Nh\u01b0ng m\u1ed7i khi mu\u1ed1n c\u1eadp nh\u1eadt th\u00eam d\u1eef li\u1ec7u, b\u1ea1n s\u1ebd\u00a0ph\u1ea3i th\u1ef1c hi\u1ec7n l\u1ea1i c\u00e1c thao t\u00e1c\u00a0\u0111\u00f3.<\/p>\n<p>Power Query c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n quy\u00a0\u0111\u1ecbnh l\u1ea1i d\u1eef li\u1ec7u c\u00f3 trong t\u1eebng c\u1ed9t v\u1ec1\u00a0\u0111\u00fang lo\u1ea1i d\u1eef li\u1ec7u. B\u1ea1n s\u1ebd kh\u00f4ng c\u00f2n m\u1ea5t th\u1eddi gian lo l\u1eafng cho vi\u1ec7c n\u00e0y n\u1eefa. N\u1ea1p d\u1eef li\u1ec7u th\u00f4 v\u00e0o, ch\u1ec9 c\u1ea7n b\u1ea5m Refresh t\u1ea1i b\u1ea3ng k\u1ebft qu\u1ea3, b\u1ea1n\u00a0\u0111\u00e3 c\u00f3\u00a0\u0111\u01b0\u1ee3c b\u1ea3ng d\u1eef li\u1ec7u ch\u00ednh x\u00e1c\u00a0\u0111\u1ec3 l\u00e0m vi\u1ec7c r\u1ed3i, h\u01a1n n\u1eefa qu\u00e1 tr\u00ecnh n\u00e0y l\u1ea1i\u00a0\u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n 1 c\u00e1ch t\u1ef1\u00a0\u0111\u1ed9ng v\u00e0 r\u1ea5t nhanh.<\/p>\n<p>Tham kh\u1ea3o:<\/p>\n<p style=\"padding-left: 30px\"><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 style=\"padding-left: 30px\"><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<h3><span class=\"ez-toc-section\" id=\"Tap_hop_du_lieu_tu_nhieu_Sheet_nhieu_Workbook_vao_1_bang_chung\"><\/span>T\u1eadp h\u1ee3p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u Sheet, nhi\u1ec1u\u00a0Workbook v\u00e0o 1 b\u1ea3ng chung<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u00f4i\u00a0\u0111\u00e3 g\u1eb7p r\u1ea5t nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p n\u00e0y,\u00a0\u0111\u00f3 l\u00e0 khi b\u1ea1n ph\u1ea3i t\u1eadp h\u1ee3p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u chi nh\u00e1nh, m\u1ed7i chi nh\u00e1nh 1 file\u00a0Excel gi\u1ed1ng nhau, ho\u1eb7c nhi\u1ec1u ng\u01b0\u1eddi l\u00e0m chung tr\u00ean 1 file\u00a0excel, m\u1ed7i ng\u01b0\u1eddi 1 Sheet (hay m\u1ed7i ng\u00e0y 1 Sheet).\u00a0\u0110\u1ec3 b\u00e1o c\u00e1o\u00a0\u0111\u01b0\u1ee3c, b\u1ea1n c\u1ea7n ph\u1ea3i t\u1eadp h\u1ee3p t\u1ea5t c\u1ea3 c\u00e1c d\u1eef li\u1ec7u n\u00e0y tr\u00ean 1 b\u1ea3ng chung. V\u1ea5n\u00a0\u0111\u1ec1 l\u00e0 c\u00e1c Sheet, c\u00e1c\u00a0Workbook s\u1ebd ph\u00e1t sinh th\u00eam th\u01b0\u1eddng xuy\u00ean. T\u1eadp h\u1ee3p l\u1ea1i\u00a0\u0111\u00e3 kh\u00f3,\u00a0\u0111\u1ea3m b\u1ea3o d\u1eef li\u1ec7u m\u1edbi kh\u00f4ng b\u1ecb thi\u1ebfu, s\u00f3t khi t\u1eadp h\u1ee3p c\u00f2n kh\u00f3 h\u01a1n.<\/p>\n<p>N\u1ebfu kh\u00f4ng bi\u1ebft Power Query, b\u1ea1n s\u1ebd c\u1ea7n d\u00f9ng t\u1edbi VBA (g\u1ea7n nh\u01b0 ch\u1eafc ch\u1eafn). Nh\u01b0ng VBA trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y c\u0169ng kh\u00f4ng h\u1ec1\u00a0\u0111\u01a1n gi\u1ea3n.\u00a0Nh\u1eefng code c\u1ea7n s\u1eed d\u1ee5ng trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y th\u01b0\u1eddng l\u00e0 kh\u00f3,\u00a0ph\u1ee9c t\u1ea1p, kh\u00f4ng d\u1ec5\u00a0\u0111\u1ec3 h\u1ecdc v\u00e0 l\u00e0m\u00a0\u0111\u01b0\u1ee3c trong 1 th\u1eddi gian ng\u1eafn.<\/p>\n<p>Khi bi\u1ebft t\u1edbi Power Query, t\u00f4i\u00a0\u0111\u00e3 th\u1ef1c s\u1ef1 ng\u1ea1c nhi\u00ean v\u00ec n\u00f3 c\u00f3 th\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n\u00a0\u0111\u1ec1 n\u00e0y 1 c\u00e1ch tri\u1ec7t\u00a0\u0111\u1ec3. S\u1ebd c\u00f3 1 ch\u00fat c\u00e2u l\u1ec7nh, nh\u01b0ng\u00a0\u0111\u1ec1u r\u1ea5t\u00a0\u0111\u01a1n gi\u1ea3n, d\u1ec5 h\u1ecdc, d\u1ec5 thao t\u00e1c. K\u1ebft qu\u1ea3 l\u1ea1i r\u1ea5t b\u1ea5t ng\u1edd: ch\u1ec9 l\u00e0m 1 l\u1ea7n, sau n\u00e0y khi th\u00eam Sheet, th\u00eam\u00a0Workbook th\u00ec v\u1eabn t\u1ef1\u00a0\u0111\u1ed9ng c\u1eadp nh\u1eadt v\u00e0o b\u1ea3ng chung.\u00a0\u0110i\u1ec1u n\u00e0y th\u1eadt ngo\u00e0i s\u1ee9c t\u01b0\u1edfng t\u01b0\u1ee3ng.<\/p>\n<p>Tham kh\u1ea3o:<\/p>\n<p style=\"padding-left: 30px\"><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<h2><span class=\"ez-toc-section\" id=\"Power_Query_de_hoc_va_de_su_dung\"><\/span>Power Query d\u1ec5 h\u1ecdc\u00a0v\u00e0 d\u1ec5 s\u1eed d\u1ee5ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>N\u1ebfu d\u00e0nh ch\u00fat th\u1eddi gian\u00a0\u0111\u1ecdc nh\u1eefng b\u00e0i tham kh\u1ea3o\u00a0\u0111\u01b0\u1ee3c g\u1ee3i\u00a0\u00fd\u00a0\u1edf tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y Power Query r\u1ea5t d\u1ec5 l\u00e0m. B\u1ea1n s\u1ebd c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng th\u1ef1c hi\u1ec7n theo t\u1eebng b\u01b0\u1edbc. C\u00e1c b\u01b0\u1edbc\u00a0\u0111\u00f3 s\u1ebd\u00a0\u0111\u01b0\u1ee3c ghi l\u1ea1i t\u1ef1\u00a0\u0111\u1ed9ng\u00a0\u0111\u1ec3 b\u1ea1n kh\u00f4ng ph\u1ea3i l\u00e0m l\u1ea1i c\u00e1c thao t\u00e1c\u00a0\u0111\u00f3 n\u1eefa. V\u1eady n\u00ean vi\u1ec7c c\u1ee7a b\u1ea1n ch\u1ec9\u00a0\u0111\u01a1n gi\u1ea3n l\u00e0: <strong>H\u1ecdc thu\u1ed9c l\u00f2ng c\u00e1c thao t\u00e1c\u00a0\u0111\u00f3<\/strong>.<\/p>\n<p>T\u1ea5t nhi\u00ean s\u1ebd c\u00f3 nh\u1eefng tr\u01b0\u1eddng h\u1ee3p kh\u00f3,\u00a0\u0111\u00f2i h\u1ecfi ph\u1ea3i k\u1ef3 c\u00f4ng trong vi\u1ec7c x\u1eed l\u00fd. Nh\u01b0ng tin t\u00f4i\u00a0\u0111i,\u00a0\u0111\u1ed9 kh\u00f3 khi l\u00e0m b\u1eb1ng Power Query\u00a0\u0111\u00e3 gi\u1ea3m\u00a0\u0111i r\u1ea5t nhi\u1ec1u l\u1ea7n so v\u1edbi l\u00e0m b\u1eb1ng VBA.<\/p>\n<p>\u0110\u1ec3 gi\u00fap c\u00e1c b\u1ea1n c\u00f3 c\u00e1i nh\u00ecn r\u00f5 h\u01a1n v\u1ec1 t\u00ednh\u00a0\u1ee9ng d\u1ee5ng c\u1ee7a Power Query trong c\u00f4ng vi\u1ec7c, t\u00f4i s\u1ebd x\u00e2y d\u1ef1ng m\u1ed9t s\u1ed1\u00a0m\u00f4 h\u00ecnh\u00a0ph\u00e2n t\u00edch d\u1eef li\u1ec7u\u00a0\u0111\u1ec3 l\u00e0m r\u00f5 h\u01a1n n\u1ed9i dung n\u00e0y.<\/p>\n<p>\u0110\u00f3n xem b\u00e0i vi\u1ebft: <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<\/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-318.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4004,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4003","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\/4003","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=4003"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4003\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4004"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4003"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4003"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4003"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}