{"id":35199,"date":"2022-04-12T15:06:36","date_gmt":"2022-04-12T08:06:36","guid":{"rendered":"https:\/\/divineshop.vn\/tin-tuc\/?p=35199"},"modified":"2022-04-12T15:06:36","modified_gmt":"2022-04-12T08:06:36","slug":"mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian","status":"publish","type":"post","link":"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian\/","title":{"rendered":"M\u00e1ch b\u1ea1n 5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n"},"content":{"rendered":"<div class=\"content-inner\">\n<p><strong>Khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u v\u00e0 c\u00e1c con s\u1ed1 trong Excel, vi\u1ec7c \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 gi\u00fap m\u1ecdi th\u1ee9 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp r\u00f5 r\u00e0ng h\u01a1n r\u1ea5t nhi\u1ec1u. Trong b\u00e0i vi\u1ebft n\u00e0y, Divine Shop s\u1ebd m\u00e1ch nh\u1ecf cho b\u1ea1n 5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel c\u1ef1c k\u1ef3 \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 th\u1ef1c hi\u1ec7n.<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-526107\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian_6239a5c0507f9.jpeg\" alt=\"\" width=\"1600\" height=\"900\" \/><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_17 counter-hierarchy counter-decimal ez-toc-grey\">\n<h2><span class=\"ez-toc-section\" id=\"5_cach_danh_so_thu_tu_trong_Excel\"><\/span><span id=\"5_cach_danh_so_thu_tu_trong_Excel\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt\">5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Dien_mot_day_cac_so_vao_mot_cot\"><\/span><span id=\"Dien_mot_day_cac_so_vao_mot_cot\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 14pt\">\u0110i\u1ec1n m\u1ed9t d\u00e3y c\u00e1c s\u1ed1 v\u00e0o m\u1ed9t c\u1ed9t<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Thao t\u00e1c r\u1ea5t \u0111\u01a1n gi\u1ea3n, b\u1ea1n ch\u1ec9 c\u1ea7n th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: Nh\u1eadp 2 s\u1ed1 th\u1ee9 t\u1ef1 v\u00e0o 2 \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t c\u1ea7n \u0111\u00e1nh th\u1ee9 t\u1ef1.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-525948\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian_6239a5c3deeda.png\" alt=\"\" width=\"1000\" height=\"441\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: B\u00f4i \u0111en 2 \u00f4 n\u00e0y, di chu\u1ed9t v\u00e0o \u00f4 vu\u00f4ng nh\u1ecf \u1edf g\u00f3c ph\u1ea3i b\u00ean d\u01b0\u1edbi \u00f4 th\u1ee9 2 <em>(khi \u0111\u00f3 con tr\u1ecf chu\u1ed9t s\u1ebd bi\u1ebfn th\u00e0nh bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u + m\u00e0u \u0111en)<\/em>.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-525949\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian_6239a5c57546e.png\" alt=\"\" width=\"1004\" height=\"463\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3<\/strong>: B\u1ea1n h\u00e3y \u1ea5n gi\u1eef chu\u1ed9t v\u00e0 k\u00e9o th\u1ea3 xu\u1ed1ng \u0111\u1ebfn \u00f4 cu\u1ed1i c\u00f9ng c\u1ea7n \u0111\u00e1nh s\u1ed1.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-525952\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian_6239a5c78bbc2.png\" alt=\"\" width=\"1004\" height=\"398\" \/><\/p>\n<p>V\u00e0 \u0111\u00e2y l\u00e0 k\u1ebft qu\u1ea3.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-525953\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian_6239a5c847877.png\" alt=\"\" width=\"1002\" height=\"391\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Danh_so_thu_tu_qua_tinh_nang_Fill\"><\/span><span id=\"Danh_so_thu_tu_qua_tinh_nang_Fill\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 14pt\">\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 qua t\u00ednh n\u0103ng Fill<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: Nh\u1eadp s\u1ed1 v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean c\u1ea7n \u0111\u00e1nh th\u1ee9 t\u1ef1.<\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: Tr\u00ean thanh Menu, ch\u1ecdn <strong>Home<\/strong> &gt; <strong>Editing<\/strong> &gt; <strong>Fill<\/strong> &gt;<strong>Fill Series<\/strong>.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-525998\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian_6239a5c8f0674.jpeg\" alt=\"\" width=\"1002\" height=\"539\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3<\/strong>: T\u1ea1i m\u1ee5c <strong>Series in<\/strong>, tick v\u00e0o \u00f4 <strong>Columns<\/strong> (\u0111\u00e1nh s\u1ed1 theo c\u1ed9t) ho\u1eb7c <strong>Rows<\/strong> (\u0111\u00e1nh s\u1ed1 theo h\u00e0ng) &gt; nh\u1eadp <strong>s\u1ed1 b\u1eaft \u0111\u1ea7u<\/strong> v\u00e0o \u00f4 <strong>Step value<\/strong> v\u00e0<strong> s\u1ed1 k\u1ebft th\u00fac<\/strong> v\u00e0o \u00f4 <strong>Stop value<\/strong> &gt; nh\u1ea5n <strong>OK<\/strong>.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-525999\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian_6239a5c9b2241.jpeg\" alt=\"\" width=\"1034\" height=\"516\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tao_day_so_lien_tiep_bang_cong_thuc_don_gian\"><\/span><span id=\"Tao_day_so_lien_tiep_bang_cong_thuc_don_gian\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 14pt\">T\u1ea1o d\u00e3y s\u1ed1 li\u00ean ti\u1ebfp b\u1eb1ng c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: Nh\u1eadp s\u1ed1 v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean c\u1ea7n \u0111\u00e1nh s\u1ed1. <em>V\u00ed d\u1ee5: nh\u1eadp s\u1ed1 1 v\u00e0o \u00f4 C4.<\/em><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-526018\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian_6239a5ca8271d.png\" alt=\"\" width=\"1001\" height=\"429\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: T\u1ea1i \u00f4 k\u1ebf ti\u1ebfp, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c nh\u01b0 sau: =C4+1 <em>(v\u1edbi C4 l\u00e0 \u00f4 \u0111\u1ea7u ti\u00ean c\u1ea7n \u0111\u00e1nh s\u1ed1 \u1edf B\u01b0\u1edbc 1).<\/em><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-526013\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian_6239a5cc4f491.png\" alt=\"\" width=\"985\" height=\"407\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3<\/strong>: \u1ea4n chu\u1ed9t v\u00e0o \u00f4 vu\u00f4ng nh\u1ecf \u1edf g\u00f3c ph\u1ea3i b\u00ean d\u01b0\u1edbi c\u1ee7a \u00f4 v\u1eeba nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0 k\u00e9o th\u1ea3 \u0111\u1ebfn \u00f4 cu\u1ed1i c\u00f9ng c\u1ea7n \u0111\u00e1nh s\u1ed1.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-526014\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian_6239a5ce318ec.png\" alt=\"\" width=\"1000\" height=\"420\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_ROW_de_danh_so_thu_tu\"><\/span><span id=\"Su_dung_ham_ROW_de_danh_so_thu_tu\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 14pt\">S\u1eed d\u1ee5ng h\u00e0m ROW \u0111\u1ec3 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u01afu \u0111i\u1ec3m khi s\u1eed d\u1ee5ng h\u00e0m ROW \u0111\u1ec3 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 l\u00e0 n\u1ebfu b\u1ea1n th\u00eam ho\u1eb7c x\u00f3a h\u00e0ng, s\u1ed1 th\u1ee9 t\u1ef1 s\u1ebd \u0111\u01b0\u1ee3c t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1u ch\u1ec9nh, b\u1ea1n kh\u00f4ng c\u1ea7n ph\u1ea3i ch\u1ec9nh th\u1ee7 c\u00f4ng t\u1eebng h\u00e0ng m\u1ed9t.<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: T\u1ea1i \u00f4 \u0111\u1ea7u ti\u00ean c\u1ea7n \u0111\u00e1nh s\u1ed1, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c <strong>=ROW()-x<\/strong>. <em>V\u00ed d\u1ee5: t\u1ea1i \u00f4 C4, ta nh\u1eadp c\u00f4ng th\u1ee9c =ROW()-3<\/em><\/p>\n<p>Trong \u0111\u00f3, h\u00e0m ROW hi\u1ec3n th\u1ecb s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a h\u00e0ng hi\u1ec7n t\u1ea1i, nh\u01b0 trong v\u00ed d\u1ee5 \u00f4 C4 \u0111ang n\u1eb1m \u1edf h\u00e0ng 4. V\u00ec th\u1ebf, \u0111\u1ec3 b\u1eaft \u0111\u1ea7u \u0111\u1ebfm t\u1eeb s\u1ed1 1, b\u1ea1n c\u1ea7n tr\u1eeb \u0111i 3 <em>(3 t\u01b0\u01a1ng \u1ee9ng v\u1edbi x trong c\u00f4ng th\u1ee9c t\u1ed5ng qu\u00e1t)<\/em>.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-526048\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian_6239a5cf2dd1a.jpeg\" alt=\"\" width=\"1002\" height=\"504\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: Sau \u0111\u00f3, b\u1ea1n th\u1ef1c hi\u1ec7n thao t\u00e1c k\u00e9o th\u1ea3 \u0111\u1ebfn \u00f4 cu\u1ed1i c\u00f9ng c\u1ea7n \u0111\u00e1nh th\u1ee9 t\u1ef1 l\u00e0 xong.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-526047\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian_6239a5cfbc384.png\" alt=\"\" width=\"1001\" height=\"434\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Danh_so_du_lieu_bang_ham_COUNTA\"><\/span><span id=\"Danh_so_du_lieu_bang_ham_COUNTA\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 14pt\">\u0110\u00e1nh s\u1ed1 d\u1eef li\u1ec7u b\u1eb1ng h\u00e0m COUNTA<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><em>*L\u01b0u \u00fd: B\u1ea1n ch\u1ec9 c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m COUNTA \u0111\u1ec3 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 c\u00e1c h\u00e0ng, c\u1ed9t c\u00f3 d\u1eef li\u1ec7u.<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: T\u1ea1i \u00f4 \u0111\u1ea7u ti\u00ean c\u1ea7n \u0111\u00e1nh s\u1ed1 (v\u00ed d\u1ee5 l\u00e0 \u00f4 C4), nh\u1eadp c\u00f4ng th\u1ee9c =<strong>IF(ISBLANK(D4),\u201d\u201d,COUNTA($D$4:D4))<\/strong><\/p>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li><em><strong>IF(ISBLANK(D4),\u201d\u201d<\/strong><\/em>: Ki\u1ec3m tra \u00f4 li\u1ec1n k\u1ec1 c\u1ee7a \u00f4 C4 trong c\u1ed9t D c\u00f3 d\u1eef li\u1ec7u hay kh\u00f4ng. N\u1ebfu tr\u1ed1ng, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 m\u1ed9t kho\u1ea3ng tr\u1ed1ng.<\/li>\n<li><strong><em>COUNTA($D$4:D4)<\/em><\/strong>: \u0110\u1ebfm c\u00e1c \u00f4 ch\u1ee9a d\u1eef li\u1ec7u, trong \u0111\u00f3 $D$4:D4 l\u00e0 ph\u1ea1m vi m\u00e0 h\u00e0m COUNTA c\u1ea7n \u0111\u1ebfm <em>(gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean lu\u00f4n kh\u00f3a, n\u1ebfu kh\u00f4ng th\u00ec h\u00e0m s\u1ebd b\u1ecb l\u1ed7i khi \u00e1p d\u1ee5ng v\u1edbi c\u00e1c \u00f4 b\u00ean d\u01b0\u1edbi).<\/em><\/li>\n<\/ul>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-526091\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian_6239a5d1184fd.png\" alt=\"\" width=\"1000\" height=\"455\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: Ti\u1ebfp \u0111\u1ebfn, h\u00e3y k\u00e9o th\u1ea3 \u0111\u1ebfn v\u1ecb tr\u00ed \u00f4 cu\u1ed1i c\u00f9ng c\u1ea7n \u0111\u00e1nh th\u1ee9 t\u1ef1.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-526092\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian_6239a5d1dd7f4.png\" alt=\"\" width=\"1000\" height=\"449\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tam_ket\"><\/span><span id=\"Tam_ket\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt\">T\u1ea1m k\u1ebft<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Hi v\u1ecdng qua b\u00e0i vi\u1ebft n\u00e0y, b\u1ea1n \u0111\u00e3 bi\u1ebft th\u00eam \u0111\u01b0\u1ee3c nhi\u1ec1u c\u00e1ch th\u1eadt h\u1eefu \u00edch \u0111\u1ec3 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel nh\u00e9. Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng.<\/p>\n<p><em><strong>\u00a0<\/strong><\/em><\/p>\n<\/div>\n<\/div>\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/divineshop.vn\/search?q=h%E1%BB%8Dc+t%E1%BA%ADp\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" width=\"728\" height=\"240\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/12\/Hoc-tap.png\" alt=\"\" class=\"wp-image-285219\" srcset=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/12\/Hoc-tap.png 728w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/12\/Hoc-tap-300x99.png 300w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/12\/Hoc-tap-150x49.png 150w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/12\/Hoc-tap-696x229.png 696w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><\/figure>\n\n\n\n<!--nextpage-->\n\n\n\n<div class=\"wp-container-69e56b5a1f235 wp-block-group\"><div class=\"wp-block-group__inner-container\"><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u v\u00e0 c\u00e1c con s\u1ed1 trong Excel, vi\u1ec7c \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 gi\u00fap m\u1ecdi th\u1ee9 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp r\u00f5 r\u00e0ng h\u01a1n r\u1ea5t nhi\u1ec1u. Trong b\u00e0i vi\u1ebft n\u00e0y, Divine Shop s\u1ebd m\u00e1ch nh\u1ecf cho b\u1ea1n 5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel c\u1ef1c k\u1ef3 \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 th\u1ef1c hi\u1ec7n. [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":35201,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[148],"tags":[255],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v18.1 (Yoast SEO v18.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<meta name=\"description\" content=\"Khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u v\u00e0 c\u00e1c con s\u1ed1 trong Excel, vi\u1ec7c \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 gi\u00fap m\u1ecdi th\u1ee9 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp r\u00f5 r\u00e0ng h\u01a1n r\u1ea5t nhi\u1ec1u. Trong b\u00e0i vi\u1ebft n\u00e0y, Divine Shop\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"M\u00e1ch b\u1ea1n 5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n\" \/>\n<meta property=\"og:description\" content=\"Khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u v\u00e0 c\u00e1c con s\u1ed1 trong Excel, vi\u1ec7c \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 gi\u00fap m\u1ecdi th\u1ee9 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp r\u00f5 r\u00e0ng h\u01a1n r\u1ea5t nhi\u1ec1u. Trong b\u00e0i vi\u1ebft n\u00e0y, Divine Shop\" \/>\n<meta property=\"og:url\" content=\"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian\/\" \/>\n<meta property=\"og:site_name\" content=\"Divine News\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/divineshop.vn\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-12T08:06:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian_6239a5c0507f9.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1600\" \/>\n\t<meta property=\"og:image:height\" content=\"900\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"CTV\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\",\"name\":\"Divine News\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/divineshop.vn\",\"https:\/\/www.instagram.com\/divineshop.game\/\",\"https:\/\/www.youtube.com\/DivineTVN\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#logo\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg\",\"contentUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg\",\"width\":960,\"height\":960,\"caption\":\"Divine News\"},\"image\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#website\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/\",\"name\":\"Divine News\",\"description\":\"Tin hay m\u1ed7i ng\u00e0y\",\"publisher\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/divineshop.vn\/tin-tuc\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"vi\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian\/#primaryimage\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian_6239a5c0507f9.jpeg\",\"contentUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian_6239a5c0507f9.jpeg\",\"width\":1600,\"height\":900},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian\/#webpage\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian\/\",\"name\":\"M\u00e1ch b\u1ea1n 5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n - Divine News\",\"isPartOf\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian\/#primaryimage\"},\"datePublished\":\"2022-04-12T08:06:36+00:00\",\"dateModified\":\"2022-04-12T08:06:36+00:00\",\"description\":\"Khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u v\u00e0 c\u00e1c con s\u1ed1 trong Excel, vi\u1ec7c \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 gi\u00fap m\u1ecdi th\u1ee9 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp r\u00f5 r\u00e0ng h\u01a1n r\u1ea5t nhi\u1ec1u. Trong b\u00e0i vi\u1ebft n\u00e0y, Divine Shop\",\"breadcrumb\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/divineshop.vn\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"M\u00e1ch b\u1ea1n 5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian\/#webpage\"},\"author\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a\"},\"headline\":\"M\u00e1ch b\u1ea1n 5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n\",\"datePublished\":\"2022-04-12T08:06:36+00:00\",\"dateModified\":\"2022-04-12T08:06:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian\/#webpage\"},\"wordCount\":849,\"publisher\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian_6239a5c0507f9.jpeg\",\"keywords\":[\"Th\u1ee7 thu\u1eadt Excel\"],\"articleSection\":[\"M\u1eb8O HAY\"],\"inLanguage\":\"vi\",\"copyrightYear\":\"2022\",\"copyrightHolder\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a\",\"name\":\"CTV\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#personlogo\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g\",\"caption\":\"CTV\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"description":"Khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u v\u00e0 c\u00e1c con s\u1ed1 trong Excel, vi\u1ec7c \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 gi\u00fap m\u1ecdi th\u1ee9 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp r\u00f5 r\u00e0ng h\u01a1n r\u1ea5t nhi\u1ec1u. Trong b\u00e0i vi\u1ebft n\u00e0y, Divine Shop","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian\/","og_locale":"vi_VN","og_type":"article","og_title":"M\u00e1ch b\u1ea1n 5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n","og_description":"Khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u v\u00e0 c\u00e1c con s\u1ed1 trong Excel, vi\u1ec7c \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 gi\u00fap m\u1ecdi th\u1ee9 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp r\u00f5 r\u00e0ng h\u01a1n r\u1ea5t nhi\u1ec1u. Trong b\u00e0i vi\u1ebft n\u00e0y, Divine Shop","og_url":"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian\/","og_site_name":"Divine News","article_publisher":"https:\/\/www.facebook.com\/divineshop.vn","article_published_time":"2022-04-12T08:06:36+00:00","og_image":[{"width":1600,"height":900,"url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian_6239a5c0507f9.jpeg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"CTV","Est. reading time":"7 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization","name":"Divine News","url":"https:\/\/divineshop.vn\/tin-tuc\/","sameAs":["https:\/\/www.facebook.com\/divineshop.vn","https:\/\/www.instagram.com\/divineshop.game\/","https:\/\/www.youtube.com\/DivineTVN"],"logo":{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/#logo","inLanguage":"vi","url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg","contentUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg","width":960,"height":960,"caption":"Divine News"},"image":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#logo"}},{"@type":"WebSite","@id":"https:\/\/divineshop.vn\/tin-tuc\/#website","url":"https:\/\/divineshop.vn\/tin-tuc\/","name":"Divine News","description":"Tin hay m\u1ed7i ng\u00e0y","publisher":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/divineshop.vn\/tin-tuc\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"vi"},{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian\/#primaryimage","inLanguage":"vi","url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian_6239a5c0507f9.jpeg","contentUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian_6239a5c0507f9.jpeg","width":1600,"height":900},{"@type":"WebPage","@id":"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian\/#webpage","url":"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian\/","name":"M\u00e1ch b\u1ea1n 5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n - Divine News","isPartOf":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian\/#primaryimage"},"datePublished":"2022-04-12T08:06:36+00:00","dateModified":"2022-04-12T08:06:36+00:00","description":"Khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u v\u00e0 c\u00e1c con s\u1ed1 trong Excel, vi\u1ec7c \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 gi\u00fap m\u1ecdi th\u1ee9 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp r\u00f5 r\u00e0ng h\u01a1n r\u1ea5t nhi\u1ec1u. Trong b\u00e0i vi\u1ebft n\u00e0y, Divine Shop","breadcrumb":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/divineshop.vn\/tin-tuc\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/divineshop.vn\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"M\u00e1ch b\u1ea1n 5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n"}]},{"@type":"Article","@id":"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian\/#article","isPartOf":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian\/#webpage"},"author":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a"},"headline":"M\u00e1ch b\u1ea1n 5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n","datePublished":"2022-04-12T08:06:36+00:00","dateModified":"2022-04-12T08:06:36+00:00","mainEntityOfPage":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian\/#webpage"},"wordCount":849,"publisher":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian\/#primaryimage"},"thumbnailUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/mach-ban-5-cach-danh-so-thu-tu-trong-excel-sieu-don-gian_6239a5c0507f9.jpeg","keywords":["Th\u1ee7 thu\u1eadt Excel"],"articleSection":["M\u1eb8O HAY"],"inLanguage":"vi","copyrightYear":"2022","copyrightHolder":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"}},{"@type":"Person","@id":"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a","name":"CTV","image":{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/#personlogo","inLanguage":"vi","url":"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g","caption":"CTV"}}]}},"_links":{"self":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/35199"}],"collection":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=35199"}],"version-history":[{"count":2,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/35199\/revisions"}],"predecessor-version":[{"id":73425,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/35199\/revisions\/73425"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/35201"}],"wp:attachment":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=35199"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=35199"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=35199"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}