{"id":12664,"date":"2025-01-15T12:21:45","date_gmt":"2025-01-15T12:21:45","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/06-sao-chep-cat-dan-du-lieu-trong-excel-phan-1\/"},"modified":"2025-01-15T12:21:45","modified_gmt":"2025-01-15T12:21:45","slug":"06-sao-chep-cat-dan-du-lieu-trong-excel-phan-1","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/06-sao-chep-cat-dan-du-lieu-trong-excel-phan-1\/","title":{"rendered":"#06 Sao ch\u00e9p, c\u1eaft d\u00e1n d\u1eef li\u1ec7u trong Excel ph\u1ea7n 1"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote>\n<p>\u00a0H\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\u1ed16, h\u01b0\u1edbng d\u1eabn \u0111\u1ea7y \u0111\u1ee7 sao ch\u00e9p, c\u1eaft d\u00e1n d\u1eef li\u1ec7u trong Excel.<\/p>\n<p><a href=\"https:\/\/www.youtube.com\/watch?v=wrbwmJ_WLcE&amp;list=PLALCv46JuKEIb30S1S2jPgHLQnUvPpmsz&amp;index=6\">\u0110\u00e2y l\u00e0 b\u00e0i s\u1ed1 #06 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\/wrbwmJ_WLcE?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-678759cc4ef83\" 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\/06-sao-chep-cat-dan-du-lieu-trong-excel-phan-1.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\/06-sao-chep-cat-dan-du-lieu-trong-excel-phan-1.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>B\u1ea1n c\u1ea7n h\u1ecdc Excel \u0111\u1ec3 ki\u1ebfm vi\u1ec7c l\u00e0m ngay b\u00e2y gi\u1edd? H\u00e3y tham kh\u1ea3o nh\u1eefng kho\u00e1 h\u1ecdc c\u1ee7a H\u1ecdc Excel Online:<\/p>\n<figure id=\"attachment_4202\" aria-describedby=\"caption-attachment-4202\" style=\"width: 640px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4202\" title=\"khoa-hoc-excel-online\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%20640%20335'%3E%3C\/svg%3E\" alt=\"khoa-hoc-excel-online\" width=\"640\" height=\"335\" data-lazy-srcset=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/khoa-hoc-excel-online-300x157-2.png 300w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2017\/04\/khoa-hoc-excel-online-600x314.png 600w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2017\/04\/khoa-hoc-excel-online-768x402.png 768w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2017\/04\/khoa-hoc-excel-online-1024x536.png 1024w\" data-lazy-sizes=\"(max-width: 640px) 100vw, 640px\" data-lazy-src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/khoa-hoc-excel-online-300x157-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4202\" title=\"khoa-hoc-excel-online\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/khoa-hoc-excel-online-300x157-2.png\" alt=\"khoa-hoc-excel-online\" width=\"640\" height=\"335\"><\/a><figcaption id=\"caption-attachment-4202\" class=\"wp-caption-text\">khoa-hoc-excel-online<\/figcaption><\/figure>\n<div class=\"related-articles\">\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>\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>\u00a0H\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..<\/p>\n","protected":false},"author":1,"featured_media":12665,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12664","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\/12664","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=12664"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12664\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12665"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12664"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12664"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12664"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}