{"id":8071,"date":"2024-12-21T19:50:31","date_gmt":"2024-12-21T19:50:31","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/ky-thuat-name-dong-dynamic-name-range-trong-excel\/"},"modified":"2024-12-21T19:50:31","modified_gmt":"2024-12-21T19:50:31","slug":"ky-thuat-name-dong-dynamic-name-range-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/ky-thuat-name-dong-dynamic-name-range-trong-excel\/","title":{"rendered":"K\u1ef9 thu\u1eadt name \u0111\u1ed9ng \u2013 dynamic name range trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>K\u1ef9 thu\u1eadt s\u1eed d\u1ee5ng name \u0111\u1ed9ng r\u1ea5t h\u1eefu d\u1ee5ng khi c\u00e1c b\u1ea1n t\u1ea1o nh\u1eefng b\u00e1o c\u00e1o v\u00e0 Dashboard b\u1edfi t\u00ednh ch\u1ea5t kh\u00f4ng c\u1ea7n thay \u0111\u1ed5i tham chi\u1ebfu khi d\u1eef li\u1ec7u t\u0103ng l\u00ean hay gi\u1ea3m \u0111i. V\u00ed d\u1ee5, trong c\u1ed9t A b\u1ea1n c\u00f3 d\u1eef li\u1ec7u c\u1ea7n t\u00ednh to\u00e1n, m\u1ed7i khi th\u00eam d\u1eef li\u1ec7u v\u00e0o, b\u1ea1n c\u1ea7n thay \u0111\u1ed5i v\u00f9ng tham chi\u1ebfu \u0111\u1ec3 c\u00f4ng th\u1ee9c ph\u1ea3n \u00e1nh \u0111\u00fang d\u1eef li\u1ec7u c\u1ea7n t\u00ednh to\u00e1n, x\u1eed l\u00fd. V\u1edbi k\u1ef9 thu\u1eadt t\u1ea1o name \u0111\u1ed9ng trong Excel, b\u1ea1n kh\u00f4ng c\u1ea7n ph\u1ea3i thay \u0111\u1ed5i tham chi\u1ebfu m\u1ed7i khi d\u1eef li\u1ec7u thay \u0111\u1ed5i n\u1eefa, h\u00e3y theo d\u00f5i video \u0111\u1ec3 bi\u1ebft c\u00e1ch vi\u1ebft ra 1 name \u0111\u1ed9ng v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng name \u0111\u1ed9ng trong Excel:<\/p>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/9LDw2Bmn5Gk\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe>\n<p>\u00a0<\/p>\n<p><a href=\"https:\/\/www.hocexcel.online\/ex101\">https:\/\/www.hocexcel.online\/ex101<\/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":"<p>K\u1ef9 thu\u1eadt s\u1eed d\u1ee5ng name \u0111\u1ed9ng r\u1ea5t h\u1eefu d\u1ee5ng khi c\u00e1c b\u1ea1n t\u1ea1o nh\u1eefng b\u00e1o..<\/p>\n","protected":false},"author":1,"featured_media":8072,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8071","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\/8071","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=8071"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8071\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8072"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8071"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8071"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8071"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}