{"id":12658,"date":"2025-01-15T12:16:42","date_gmt":"2025-01-15T12:16:42","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/09-dia-chi-tuyet-doi-va-dia-chi-tuong-doi-trong-excel\/"},"modified":"2025-01-15T12:16:42","modified_gmt":"2025-01-15T12:16:42","slug":"09-dia-chi-tuyet-doi-va-dia-chi-tuong-doi-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/09-dia-chi-tuyet-doi-va-dia-chi-tuong-doi-trong-excel\/","title":{"rendered":"#09 \u0110\u1ecba ch\u1ec9 tuy\u1ec7t \u0111\u1ed1i v\u00e0 \u0111\u1ecba ch\u1ec9 t\u01b0\u01a1ng \u0111\u1ed1i trong excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<hr>\n<p>H\u1ecdc v\u00e0 th\u1ef1c h\u00e0nh d\u1ec5 hi\u1ec3u v\u1ec1 Excel c\u01a1 b\u1ea3n v\u1edbi c\u00e1c video h\u01b0\u1edbng d\u1eabn sau \u0111\u00e2y. Video s\u1ed1 9, t\u00ecm hi\u1ec3u v\u1ec1 \u0111\u1ecba ch\u1ec9 tuy\u1ec7t \u0111\u1ed1i v\u00e0 \u0111\u1ecba ch\u1ec9 t\u01b0\u01a1ng \u0111\u1ed1i trong Excel.<\/p>\n<blockquote>\n<p>\u00a0<\/p>\n<p><a href=\"https:\/\/www.youtube.com\/watch?v=QyuWapIKFp8&amp;index=9&amp;list=PLALCv46JuKEIb30S1S2jPgHLQnUvPpmsz\">\u0110\u00e2y l\u00e0 b\u00e0i s\u1ed1 #09 trong lo\u1ea1t videos<\/a> <a href=\"https:\/\/www.youtube.com\/playlist?list=PLALCv46JuKEIb30S1S2jPgHLQnUvPpmsz\"><strong>H\u01b0\u1edbng d\u1eabn Excel t\u1eeb \u0111\u01a1n gi\u1ea3n \u0111\u1ebfn ph\u1ee9c t\u1ea1p<\/strong><\/a><\/p>\n<\/blockquote>\n<hr>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/QyuWapIKFp8?list=PLALCv46JuKEIb30S1S2jPgHLQnUvPpmsz&amp;wmode=transparent\" width=\"560\" height=\"315\" frameborder allowfullscreen=\"allowfullscreen\"><\/iframe>\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-6787a728cb46d\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/09-dia-chi-tuyet-doi-va-dia-chi-tuong-doi-trong-excel.html#Cac_kien_thuc_lien_quan\" title=\"C\u00e1c ki\u1ebfn th\u1ee9c li\u00ean quan:\">C\u00e1c ki\u1ebfn th\u1ee9c li\u00ean quan:<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/09-dia-chi-tuyet-doi-va-dia-chi-tuong-doi-trong-excel.html#Co_the_ban_se_quan_tam_den_nhung_bai_viet_sau\" title=\"C\u00f3 th\u1ec3 b\u1ea1n s\u1ebd quan t\u00e2m \u0111\u1ebfn nh\u1eefng b\u00e0i vi\u1ebft sau\">C\u00f3 th\u1ec3 b\u1ea1n s\u1ebd quan t\u00e2m \u0111\u1ebfn nh\u1eefng b\u00e0i vi\u1ebft sau<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3 id=\"cc-kin-thc-lin-quan\"><span class=\"ez-toc-section\" id=\"Cac_kien_thuc_lien_quan\"><\/span>C\u00e1c ki\u1ebfn th\u1ee9c li\u00ean quan:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u2022 <a href=\"https:\/\/www.youtube.com\/playlist?list=PLALCv46JuKEIb30S1S2jPgHLQnUvPpmsz\">Excel c\u01a1 b\u1ea3n<\/a><\/p>\n<hr>\n<p>\u27a4 Subscribe: <a href=\"http:\/\/youtube.com\/user\/ductnguy?subscribe_confirmation=1\">http:\/\/youtube.com\/user\/ductnguy?subscribe_confirmation=1<\/a><\/p>\n<p>\u27a4 Facebook group: <a href=\"https:\/\/www.facebook.com\/groups\/569100319856001\/\">https:\/\/www.facebook.com\/groups\/569100319856001\/<\/a><\/p>\n<p>\u27a4 Facebook page: <a href=\"https:\/\/www.facebook.com\/www.hocexcel.online\">https:\/\/www.facebook.com\/www.hocexcel.online<\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Co_the_ban_se_quan_tam_den_nhung_bai_viet_sau\"><\/span>C\u00f3 th\u1ec3 b\u1ea1n s\u1ebd quan t\u00e2m \u0111\u1ebfn nh\u1eefng b\u00e0i vi\u1ebft sau<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li><a title=\"Bi\u1ec3u \u0111\u1ed3 \u0111\u1ed9ng trong Excel, c\u00e1ch thi\u1ebft l\u1eadp d\u1eef li\u1ec7u\" href=\"https:\/\/blog.hocexcel.online\/2016\/06\/02\/bieu-do-dong-trong-excel.html\">Bi\u1ec3u \u0111\u1ed3 \u0111\u1ed9ng trong Excel, c\u00e1ch thi\u1ebft l\u1eadp d\u1eef li\u1ec7u<\/a><\/li>\n<li><a title=\"\u0110\u0129a DVD Excel C\u01a1 b\u1ea3n \u0111\u1ebfn ph\u1ee9c t\u1ea1p\" href=\"https:\/\/blog.hocexcel.online\/2016\/05\/31\/tai-lieu-excel-dvd-excel.html\">\u0110\u0129a DVD Excel C\u01a1 b\u1ea3n \u0111\u1ebfn ph\u1ee9c t\u1ea1p<\/a><\/li>\n<li><a title=\"\u0110i\u1ec1u khi\u1ec3n Word t\u1eeb Excel - thay cho Mail Merge\" href=\"https:\/\/blog.hocexcel.online\/2016\/05\/27\/dieu-khien-word-tu-excel.html\">\u0110i\u1ec1u khi\u1ec3n Word t\u1eeb Excel \u2013 thay cho Mail Merge<\/a><\/li>\n<li><a title=\"#89 S\u1eed d\u1ee5ng SUMIF v\u1edbi d\u1ea5u * v\u00e0 ? \u0111\u1ec3 \u0111\u1ebfm theo \u0111i\u1ec1u ki\u1ec7n \" href=\"https:\/\/blog.hocexcel.online\/2016\/05\/23\/su-dung-sumif-voi-dieu-kien.html\">#89 S\u1eed d\u1ee5ng SUMIF v\u1edbi d\u1ea5u * v\u00e0 ? \u0111\u1ec3 \u0111\u1ebfm theo \u0111i\u1ec1u ki\u1ec7n<\/a><\/li>\n<li><a title=\"S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Goal Seek trong Excel\" href=\"https:\/\/blog.hocexcel.online\/2016\/05\/23\/su-dung-goal-seek.html\">S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Goal Seek trong Excel<\/a><\/li>\n<\/ul>\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=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2019\/09\/EX101_92019-nho.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12659,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12658","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12658","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=12658"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12658\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12659"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12658"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12658"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12658"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}