{"id":4051,"date":"2024-12-04T08:38:41","date_gmt":"2024-12-04T08:38:41","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/huong-dan-su-dung-name-dong-voi-power-query-trong-excel\/"},"modified":"2024-12-04T08:38:41","modified_gmt":"2024-12-04T08:38:41","slug":"huong-dan-su-dung-name-dong-voi-power-query-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/huong-dan-su-dung-name-dong-voi-power-query-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Name \u0111\u1ed9ng v\u1edbi Power Query trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-Bh-YYrla#1\">\n<p style=\"text-align: justify\"><em>Ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c Name \u0111\u1ed9ng trong Excel, v\u1eady c\u00f2n trong <a href=\"http:\/\/blog.ezworkapp.com\/power-bi-la-gi.html\"><strong>Power Query<\/strong><\/a> th\u00ec sao? 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 c\u00e1ch \u0111\u1ec3 <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-name-dong-voi-power-query.html\"><strong>s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c Name \u0111\u1ed9ng trong Power Query.<\/strong><\/a><\/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-67501510a610d\" 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-su-dung-name-dong-voi-power-query.html#Tao_Name_dong\" title=\"T\u1ea1o Name \u0111\u1ed9ng\">T\u1ea1o Name \u0111\u1ed9ng<\/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-su-dung-name-dong-voi-power-query.html#Su_dung_Name_dong_trong_Power_Query\" title=\"S\u1eed d\u1ee5ng Name \u0111\u1ed9ng trong Power Query\">S\u1eed d\u1ee5ng Name \u0111\u1ed9ng trong Power Query<\/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-su-dung-name-dong-voi-power-query.html#Mot_vai_luu_y\" title=\"M\u1ed9t v\u00e0i l\u01b0u \u00fd\">M\u1ed9t v\u00e0i l\u01b0u \u00fd<\/a><\/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\/huong-dan-su-dung-name-dong-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=\"Tao_Name_dong\"><\/span>T\u1ea1o Name \u0111\u1ed9ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea1o Name \u0111\u1ed9ng trong Excel ta c\u00f3 m\u1ed9t s\u1ed1 h\u00e0m th\u01b0\u1eddng d\u00f9ng nh\u01b0 OFFSET, n\u1ebfu b\u1ea1n \u0111ang d\u00f9ng c\u00e1c phi\u00ean b\u1ea3n Excel m\u1edbi h\u01a1n nh\u01b0 Excel 2019, 365 th\u00ec s\u1ebd c\u00f3 kh\u00e1 nhi\u1ec1u c\u00e1ch n\u1eefa \u0111\u1ec3 t\u1ea1o \u0111\u01b0\u1ee3c Name \u0111\u1ed9ng.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 cho c\u00e1c phi\u00ean b\u1ea3n Excel kh\u00e1c \u0111\u1ec1u c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n th\u00ec trong b\u00e0i vi\u1ebft n\u00e0y m\u00ecnh s\u1ebd s\u1eed d\u1ee5ng h\u00e0m OFFSET \u0111\u1ec3 t\u1ea1o name \u0111\u1ed9ng.<\/p>\n<p style=\"text-align: justify\">C\u1ee5 th\u1ec3, m\u00ecnh c\u00f3 1 b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 sau, ta s\u1ebd d\u00f9ng h\u00e0m OFFSET \u0111\u1ec3 t\u1ea1o 1 Name \u0111\u1ed9ng v\u00e0 Name n\u00e0y ch\u00ednh l\u00e0 to\u00e0n b\u1ed9\u00a0d\u1eef li\u1ec7u c\u1ee7a ch\u00fang ta<\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-offset-va-cac-ket-hop-ham-cua-no-trong-excel-cong-thuc-vi-du.html\"><em><strong>H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ea1o danh s\u00e1ch \u0111\u1ed9ng trong excel v\u1edbi h\u00e0m OFFSET<\/strong><\/em><\/a><\/p>\n<p style=\"text-align: justify\">B\u1ea1n v\u00e0o Define Name, t\u1ea1i h\u1ed9p tho\u1ea1i New Name b\u1ea1n l\u00e0m nh\u01b0 sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>\u1ede \u0111\u00e2y <strong>Name<\/strong> m\u00ecnh \u0111\u1eb7t l\u00e0 DATA (b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1eb7t theo \u00fd b\u1ea1n nh\u00e9, t\u00ean n\u00e0y kh\u00f4ng c\u00f3 d\u1ea5u c\u0169ng nh\u01b0 kh\u00f4ng ch\u1ee9a c\u00e1c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t)<\/li>\n<li><strong>Refers to:<\/strong> B\u1ea1n g\u00f5 v\u00e0o c\u00f4ng th\u1ee9c t\u1ea1o Name \u0111\u1ed9ng v\u1edbi <strong>h\u00e0m OFFSET<\/strong> nh\u01b0 sau:<\/li>\n<\/ul>\n<blockquote>\n<p><strong>=OFFSET($A$3,0,0,COUNTA($A:$A),3)<\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/10\/1-5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30368 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-5-3.png\" alt=\"huong-dan-su-dung-name-dong-voi-power-bi-trong-excel-1\" width=\"951\" height=\"509\" title=\"1-5-3\"><\/a><\/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-323.gif\" title=\"ex101_92019-nho-323\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_Name_dong_trong_Power_Query\"><\/span>S\u1eed d\u1ee5ng Name \u0111\u1ed9ng trong Power Query<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Sau khi \u0111\u00e3 t\u1ea1o \u0111\u01b0\u1ee3c Name \u0111\u1ed9ng v\u1edbi <strong>h\u00e0m OFFSET<\/strong> nh\u01b0 tr\u00ean, b\u1ea1n v\u00e0o Power Query, trong Get Data b\u1ea1n ch\u1ecdn Launch Power Query Editor\u2026. L\u00fac n\u00e0y c\u1eeda s\u1ed5 t\u1ea1o Power Query Editor s\u1ebd hi\u1ec7n ra.<\/p>\n<p style=\"text-align: justify\">B\u1ea1n t\u1ea1o 1 Blank Query , b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m \u0111i\u1ec1u \u0111i\u1ec1u n\u00e0y trong Tab Home, nh\u00f3m New Query ho\u1eb7c b\u1ea1n chu\u1ed9t ph\u1ea3i v\u00e0o ph\u1ea7n b\u00ean tr\u00e1i c\u1ee7a c\u1eeda s\u1ed5 Query Editor, c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/10\/3-4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30371 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-4-2.png\" alt=\"huong-dan-su-dung-name-dong-voi-power-bi-trong-excel-2\" width=\"727\" height=\"430\" title=\"3-4-2\"><\/a><\/p>\n<p style=\"text-align: justify\">Ti\u1ebfp theo, tr\u00ean thanh c\u00f4ng th\u1ee9c (M \u2013 Code) b\u1ea1n g\u00f5 v\u00e0o nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>= Excel.CurrentWorkbook(){[Name=\u201dDATA\u201d]}[Content]<\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">N\u1ebfu nh\u01b0 ch\u01b0a hi\u1ec3u v\u1ec1 M \u2013 Code th\u00ec b\u1ea1n ch\u1ec9 c\u1ea7n quan t\u00e2m t\u1edbi ph\u1ea7n <strong>{[Name= \u201cDATA\u201d]}<\/strong><\/p>\n<p style=\"text-align: justify\">B\u1ea1n g\u00f5 t\u00ean Name \u0111\u1ed9ng c\u1ee7a b\u1ea1n v\u00e0o ph\u1ea7n n\u00e0y sau \u0111\u00f3 \u1ea5n Enter b\u1ea1n s\u1ebd 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\/3-6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30373 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-6-1024x329-1.png\" alt=\"huong-dan-su-dung-name-dong-voi-power-bi-trong-excel-3\" width=\"1024\" height=\"329\" title=\"3-6-1024x329-1\"><\/a><\/p>\n<p style=\"text-align: justify\">2 b\u01b0\u1edbc <strong>Promoted Headers<\/strong> v\u00e0 <strong>Changed type<\/strong> l\u00e0 Power Query Editor t\u1ef1 hi\u1ec3u v\u00e0 th\u1ef1c hi\u1ec7n cho m\u00ecnh (B\u1ea1n th\u1ea5y n\u00f3 th\u00f4ng minh ch\u01b0a \ud83d\ude0a). Tuy nhi\u00ean, trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, khi l\u00e0m vi\u1ec7c v\u1edbi Power Query th\u00ec b\u1ea1n c\u0169ng n\u00ean \u0111\u1ec3 \u00fd h\u01a1n t\u1edbi t\u00ednh n\u0103ng t\u1ef1 nh\u1eadn d\u1ea1ng n\u00e0y.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Mot_vai_luu_y\"><\/span>M\u1ed9t v\u00e0i l\u01b0u \u00fd<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y ch\u00fang ta ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c Name \u0111\u1ed9ng trong Power Query. Tuy nhi\u00ean. H\u1ecdc Excel Online ngh\u0129 b\u1ea1n kh\u00f4ng n\u00ean qu\u00e1 l\u1ea1m d\u1ee5ng vi\u1ec7c n\u00e0y trong tr\u01b0\u1eddng h\u1ee3p kh\u00f4ng c\u1ea7n thi\u1ebft, thay v\u00e0o \u0111\u00f3 b\u1ea1n\u00a0n\u00ean t\u1ea1o Table cho d\u1eef li\u1ec7u \u0111\u1ec3 s\u1eed d\u1ee5ng Power Query. \u0110\u1ecbnh d\u1ea1ng Table \u0111\u01b0\u1ee3c khuy\u1ebfn kh\u00edch s\u1eed d\u1ee5ng v\u00e0 cho hi\u1ec7u su\u1ea5t t\u1ed1t nh\u1ea5t so v\u1edbi Name Range th\u00f4ng th\u01b0\u1eddng v\u00e0 Name \u0111\u1ed9ng n\u00e0y.<\/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\">Hy v\u1ecdng qua b\u00e0i vi\u1ebft n\u00e0y c\u1ee7a<strong> H\u1ecdc Excel Online<\/strong> b\u1ea1n \u0111\u00e3 n\u1eafm \u0111\u01b0\u1ee3c c\u00e1ch \u0111\u1ec3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c Name \u0111\u1ed9ng trong Power Query.<\/p>\n<p style=\"text-align: justify\"><strong>Power Query<\/strong> l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 r\u1ea5t m\u1ea1nh \u0111\u01b0\u1ee3c Microsoft h\u1ed7 tr\u1ee3 cho kh\u00e1 nhi\u1ec1u phi\u00ean b\u1ea3n Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn hi\u1ec7n nay, vi\u1ec7c n\u1eafm \u0111\u01b0\u1ee3c<strong> Power Query trong Excel<\/strong> n\u00f3 s\u1ebd l\u00e0 c\u1ea7u n\u1ed1i gi\u00fap cho b\u1ea1n ti\u1ebfn t\u1edbi 1 c\u00f4ng c\u1ee5 r\u1ea5t m\u1ea1nh trong vi\u1ec7c l\u00e0m c\u00e1c b\u00e1o c\u00e1o ph\u00e2n t\u00edch \u2013 Power BI<\/p>\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\/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-323.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4052,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4051","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\/4051","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=4051"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4051\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4052"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4051"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4051"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4051"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}