{"id":10961,"date":"2022-11-07T10:07:55","date_gmt":"2022-11-07T03:07:55","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=10961"},"modified":"2022-12-06T14:05:43","modified_gmt":"2022-12-06T07:05:43","slug":"cach-danh-so-thu-tu-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/","title":{"rendered":"C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel nhanh v\u00e0 ch\u00ednh x\u00e1c nh\u1ea5t"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;10961&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;5&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (5 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel nhanh v\u00e0 ch\u00ednh x\u00e1c nh\u1ea5t&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (5 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p style=\"text-align: justify;\"><b><i>C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel <\/i><\/b><i><span style=\"font-weight: 400;\">t\u1ef1 \u0111\u1ed9ng l\u00e0 k\u1ef9 n\u0103ng \u0111\u01a1n gi\u1ea3n m\u00e0 h\u1ea7u nh\u01b0 ai c\u0169ng c\u1ea7n ph\u1ea3i bi\u1ebft khi s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 n\u00e0y. Nh\u1eb1m gi\u00fap cho thao t\u00e1c \u0111\u00e1nh m\u00e1y c\u1ee7a b\u1ea1n tr\u1edf n\u00ean nhanh ch\u00f3ng v\u00e0 chuy\u00ean nghi\u1ec7p h\u01a1n nhi\u1ec1u. Song kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft v\u00e0 s\u1eed d\u1ee5ng ch\u00ednh x\u00e1c. Ti\u1ebfp t\u1ee5c theo d\u00f5i nh\u1eefng th\u00f4ng tin sau \u0111\u00e2y v\u00e0 ch\u00fang t\u00f4i s\u1ebd mang \u0111\u1ebfn cho b\u1ea1n c\u00e2u tr\u1ea3 l\u1eddi d\u1ec5 hi\u1ec3u v\u00e0 c\u1ee5 th\u1ec3 nh\u1ea5t!<\/span><\/i><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">N\u1ed9i dung <\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/#Nhung_cach_danh_so_thu_tu_trong_excel_de_hieu_ban_doc_tham_khao\" >Nh\u1eefng c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel d\u1ec5 hi\u1ec3u b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/#Cach_danh_so_thu_tu_excel_bang_keo_chuot\" >C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 excel b\u1eb1ng k\u00e9o chu\u1ed9t\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/#Cach_danh_so_thu_tu_excel_bang_ham\" >C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 excel b\u1eb1ng h\u00e0m<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/#Cach_danh_so_thu_tu_trong_excel_co_dieu_kien\" >C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/#Ket_luan_chung\" >K\u1ebft lu\u1eadn chung\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/#Tham_khao_them_ve_cach_danh_so_thu_tu_trong_excel\" >Tham kh\u1ea3o th\u00eam v\u1ec1 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Nhung_cach_danh_so_thu_tu_trong_excel_de_hieu_ban_doc_tham_khao\"><\/span><b>Nh\u1eefng c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel d\u1ec5 hi\u1ec3u b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u1ea1n c\u1ea3m th\u1ea5y t\u1ed1n th\u1eddi gian khi c\u1ee9 ph\u1ea3i g\u00f5 t\u1eebng s\u1ed1 th\u1ee9 t\u1ef1 m\u1ed9t trong file excel d\u00e0i v\u1edbi h\u00e0ng tr\u0103m s\u1ed1 li\u1ec7u? B\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm ph\u01b0\u01a1ng ph\u00e1p x\u1eed l\u00fd s\u1ed1 th\u1ee9 t\u1ef1 m\u1ed9t c\u00e1ch ho\u00e0n to\u00e0n t\u1ef1 \u0111\u1ed9ng? Ch\u1ec9 trong v\u00f2ng 30 gi\u00e2y cho \u0111\u1ebfn 1 ph\u00fat?\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u1eady th\u00ec b\u00e0i vi\u1ebft n\u00e0y ch\u00ednh l\u00e0 d\u00e0nh cho b\u1ea1n v\u1edbi c\u00e1ch \u0111\u00e1nh s\u1ed1 excel t\u1ef1 \u0111\u1ed9ng nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3. Ch\u00fang v\u1eeba gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian m\u1ed9t c\u00e1ch t\u1ed1i \u01b0u. L\u1ea1i v\u1eeba h\u1ea1n ch\u1ebf nh\u1eefng sai s\u00f3t s\u1ed1 li\u1ec7u trong qu\u00e1 tr\u00ecnh \u0111\u00e1nh m\u00e1y. D\u01b0\u1edbi \u0111\u00e2y s\u1ebd l\u00e0 3 <\/span><b>c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel <\/b><span style=\"font-weight: 400;\">\u0111\u01b0\u1ee3c \u01b0a chu\u1ed9ng nh\u1ea5t hi\u1ec7n nay. H\u1ea7u nh\u01b0 n\u00f3 \u00e1p d\u1ee5ng \u0111\u01b0\u1ee3c cho m\u1ecdi phi\u00ean b\u1ea3n excel (2007, 2010, 2013, 2016,&#8230;).<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"T\u1ef1 H\u1ecdc Excel | B\u00e0i 2: C\u00e1c C\u00e1ch \u0110\u00e1nh S\u1ed1 Th\u1ee9 T\u1ef1 Trong Excel\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/xLWmFyKG9GQ?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<ul style=\"text-align: justify;\">\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Cach_danh_so_thu_tu_excel_bang_keo_chuot\"><\/span><b><i>C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 excel b\u1eb1ng k\u00e9o chu\u1ed9t\u00a0<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ea7u ti\u00ean l\u00e0 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 th\u00f4ng d\u1ee5ng v\u00e0 d\u1ec5 d\u00e0ng nh\u1ea5t &#8211; \u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng b\u1eb1ng c\u00e1ch k\u00e9o chu\u1ed9t. \u1ede c\u00e1ch n\u00e0y, thao t\u00e1c r\u1ea5t nhanh v\u00e0 \u0111\u01a1n gi\u1ea3n. Tr\u01b0\u1edbc h\u1ebft, b\u1ea1n s\u1ebd ch\u1ecdn \u00f4 v\u00e0 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 \u0111\u1ea7u ti\u00ean v\u00e0o \u00f4 \u0111\u00f3.\u00a0<\/span><\/p>\n<figure id=\"attachment_10962\" aria-describedby=\"caption-attachment-10962\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-10962\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-thu-tu-trong-excel-1-400x200.jpg\" alt=\"cach-danh-so-thu-tu-trong-excel-1\" width=\"400\" height=\"200\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-thu-tu-trong-excel-1-400x200.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-thu-tu-trong-excel-1.jpg 600w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-10962\" class=\"wp-caption-text\">\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ti\u1ebfp t\u1ee5c, b\u1ea1n v\u1eeba gi\u1eef ph\u00edm Ctrl v\u00e0 s\u1eed d\u1ee5ng con chu\u1ed9t di chuy\u1ec3n \u0111\u1ebfn g\u00f3c ph\u1ea3i c\u1ee7a \u00f4 \u0111\u1ea7u ti\u00ean cho \u0111\u1ebfn khi xu\u1ea5t hi\u1ec7n d\u1ea5u +. Ti\u1ebfn h\u00e0nh k\u00e9o r\u00ea \u00f4 \u0111\u00f3 cho \u0111\u1ebfn \u00f4 c\u1ea7n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 cu\u1ed1i c\u00f9ng. Sau \u0111\u00f3 th\u1ea3 chu\u1ed9t v\u00e0 ph\u00edm Ctrl l\u00e0 b\u1ea1n \u0111\u00e3 c\u00f3 m\u1ed9t danh s\u00e1ch s\u1ed1 th\u1ee9 t\u1ef1 ho\u00e0n ch\u1ec9nh, ai c\u0169ng c\u00f3 th\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c.<\/span><\/p>\n<figure id=\"attachment_10963\" aria-describedby=\"caption-attachment-10963\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-10963\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-thu-tu-trong-excel-2-400x200.jpg\" alt=\"cach-danh-so-thu-tu-trong-excel-2\" width=\"400\" height=\"200\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-thu-tu-trong-excel-2-400x200.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-thu-tu-trong-excel-2.jpg 600w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-10963\" class=\"wp-caption-text\">File excel ho\u00e0n ch\u1ec9nh sau khi k\u00e9o r\u00ea chu\u1ed9t \u0111\u00e1nh STT<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00e0 n\u1ebfu v\u1edbi m\u1ed9t danh s\u00e1ch d\u00e0i nh\u01b0 b\u1ea3ng s\u1ed1 li\u1ec7u th\u00f4ng tin kh\u00e1ch h\u00e0ng d\u00e0i \u0111\u1ebfn h\u00e0ng tr\u0103m ng\u01b0\u1eddi th\u00ec b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 l\u1ea7n l\u01b0\u1ee3t l\u00e0: 1,2. Sau \u0111\u00f3 k\u00e9o tr\u1ecf chu\u1ed9t v\u00e0o 2 \u00f4 \u0111\u00f3 v\u00e0 r\u00ea \u0111\u1ebfn v\u1ecb tr\u00ed g\u00f3c ph\u00eda b\u00ean ph\u1ea3i c\u1ee7a \u00f4 th\u1ee9 2. Cu\u1ed1i c\u00f9ng b\u1ea1n nh\u00e1y \u0111\u00fap chu\u1ed9t \u0111\u1ec3 excel t\u1ef1 \u0111\u1ed9ng \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 cho b\u1ea1n.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u01afu \u0111i\u1ec3m:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Thao t\u00e1c nhanh ch\u00f3ng, ti\u1ec7n d\u1ee5ng, d\u1ec5 th\u1ef1c hi\u1ec7n\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Kh\u00f4ng c\u1ea7n ph\u1ea3i nh\u1edb h\u00e0m, nh\u1edb l\u1ec7nh s\u1eed d\u1ee5ng<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c cho danh s\u00e1ch ng\u1eafn l\u1eabn d\u00e0i\u00a0<\/span><\/li>\n<\/ul>\n<ul style=\"text-align: justify;\">\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Cach_danh_so_thu_tu_excel_bang_ham\"><\/span><b><i>C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 excel b\u1eb1ng h\u00e0m<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><i><span style=\"font-weight: 400;\">C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel b\u1eb1ng h\u00e0m<\/span><\/i><span style=\"font-weight: 400;\"> c\u0169ng \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi quan t\u00e2m hi\u1ec7n nay. C\u00f3 nhi\u1ec1u h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u01b0ng \u1edf \u0111\u00e2y, ch\u00fang t\u00f4i s\u1ebd ph\u00e2n t\u00edch <\/span><b>c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 excel<\/b><span style=\"font-weight: 400;\"> v\u1edbi h\u00e0m ROW. H\u00e0m ROW l\u00e0 m\u1ed9t h\u00e0m s\u1eed d\u1ee5ng kh\u00e1 nhanh ch\u00f3ng, ti\u1ec7n l\u1ee3i trong vi\u1ec7c \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1. N\u00f3 cung c\u1ea5p s\u1ed1 h\u00e0ng hi\u1ec7n t\u1ea1i c\u1ee7a m\u00ecnh v\u00e0 kh\u00f4ng tham chi\u1ebfu d\u1ef1a tr\u00ean c\u00e1c \u00f4 th\u1ee9 t\u1ef1 kh\u00e1c.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u1ee5 th\u1ec3, b\u1ea1n ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c: = ROW() &#8211; 1. B\u1ea1n ph\u1ea3i tr\u1eeb \u0111i 1 n\u1eefa b\u1edfi v\u00ec th\u01b0\u1eddng h\u00e0ng \u0111\u1ea7u ti\u00ean l\u00e0 STT, H\u1ecd t\u00ean,&#8230; T\u1eeb h\u00e0ng th\u1ee9 2 tr\u1edf \u0111i m\u1edbi b\u1eaft \u0111\u1ea7u n\u1ed9i dung b\u1ea3ng d\u1eef li\u1ec7u, m\u1edbi b\u1eaft \u0111\u1ea7u \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1. Vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m ROW tr\u1eeb \u0111i 1 s\u1ebd gi\u00fap k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c.\u00a0<\/span><\/p>\n<figure id=\"attachment_10964\" aria-describedby=\"caption-attachment-10964\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-10964\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-thu-tu-trong-excel-3-400x200.jpg\" alt=\"cach-danh-so-thu-tu-trong-excel-3\" width=\"400\" height=\"200\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-thu-tu-trong-excel-3-400x200.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-thu-tu-trong-excel-3.jpg 600w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-10964\" class=\"wp-caption-text\">\u0110\u00e1nh h\u00e0m ROW v\u00e0o \u00f4 c\u1ea7n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 . Sau \u0111\u00f3 k\u00e9o r\u00ea chu\u1ed9t \u0111\u1ec3 \u0111\u01b0\u1ee3c danh s\u00e1ch ho\u00e0n ch\u1ec9nh<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u01afu \u0111i\u1ec3m:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 th\u1ef1c hi\u1ec7n trong nhi\u1ec1u t\u00ecnh hu\u1ed1ng kh\u00e1c nhau<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">D\u1ec5 nh\u1edb, d\u00f9 s\u1eed d\u1ee5ng h\u00e0m nh\u01b0ng kh\u00f4ng h\u1ec1 ph\u1ee9c t\u1ea1p, ai c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u00f3 th\u1ec3 c\u1eaft d\u00e1n t\u00f9y \u00fd kh\u00f4ng c\u1ea7n \u0111i\u1ec1u ch\u1ec9nh l\u1ea1i s\u1ed1 th\u1ee9 t\u1ef1. B\u1edfi v\u00ec h\u00e0m ROW s\u1ebd t\u1ef1 \u0111i\u1ec1u ch\u1ec9nh cho ch\u00ednh x\u00e1c.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c trong nhi\u1ec1u t\u00ecnh hu\u1ed1ng kh\u00e1c nhau<\/span><\/li>\n<\/ul>\n<ul style=\"text-align: justify;\">\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Cach_danh_so_thu_tu_trong_excel_co_dieu_kien\"><\/span><b><i>C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u1edbi h\u00e0m excel c\u00f3 \u0111i\u1ec1u ki\u1ec7n (v\u00ed d\u1ee5 nh\u01b0 b\u1ecf tr\u1ed1ng \u00f4) th\u00ec b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m counta \u0111\u1ec3 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1. C\u1ee5 th\u1ec3, v\u00ed d\u1ee5 nh\u01b0 ta c\u00f3 b\u1ea3ng excel nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u00fac n\u00e0y, b\u1ea1n s\u1ebd nh\u1eadp h\u00e0m nh\u01b0 sau v\u00e0o \u00f4 s\u1ed1 th\u1ee9 t\u1ef1 \u0111\u1ea7u ti\u00ean v\u00e0 k\u00e9o r\u00ea n\u00f3 (r\u00ea chu\u1ed9t \u0111\u1ebfn g\u00f3c ph\u1ea3i c\u1ee7a \u00f4, click v\u00e0 k\u00e9o) cho \u0111\u1ebfn \u00f4 cu\u1ed1i c\u00f9ng:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">A2= If(C2= \u201c\u201d,0, COUNTA($C$2:C2))<\/span><\/p>\n<figure id=\"attachment_10965\" aria-describedby=\"caption-attachment-10965\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-10965\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-thu-tu-trong-excel-4-400x200.jpg\" alt=\"cach-danh-so-thu-tu-trong-excel-4\" width=\"400\" height=\"200\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-thu-tu-trong-excel-4-400x200.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-thu-tu-trong-excel-4.jpg 600w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-10965\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng h\u00e0m If v\u00e0 COUNTA cho b\u1ea3ng excel b\u1ecb khuy\u1ebft<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u1ede \u0111\u00e2y, b\u1ea1n k\u1ebft h\u1ee3p h\u00e0m If v\u00e0 COUNTA \u0111\u1ec3 s\u1eed d\u1ee5ng cho b\u1ea3ng excel c\u00f3 \u0111i\u1ec1u ki\u1ec7n. L\u00fac n\u00e0y, h\u00e0m tr\u00ean c\u00f3 th\u1ec3 gi\u1ea3i ngh\u0129a nh\u01b0 sau: N\u1ebfu nh\u01b0 C2 l\u00e0 m\u1ed9t \u00f4 tr\u1ed1ng th\u00ec \u00f4 s\u1ed1 th\u1ee9 t\u1ef1 t\u01b0\u01a1ng \u1ee9ng A2 s\u1ebd l\u00e0 0. C\u00f2n n\u1ebfu C2 kh\u00f4ng tr\u1ed1ng th\u00ec \u00f4 th\u1ee9 t\u1ef1 A2 t\u01b0\u01a1ng \u1ee9ng s\u1ebd \u0111\u01b0\u1ee3c t\u00ednh d\u1eef li\u1ec7u t\u1eeb kho\u1ea3ng C2 cho \u0111\u1ebfn C2. Sau khi \u00e1p d\u1ee5ng cho nh\u1eefng \u00f4 ph\u00eda d\u01b0\u1edbi, kho\u1ea3ng t\u00ednh d\u1eef li\u1ec7u l\u1ea7n l\u01b0\u1ee3t s\u1ebd tr\u1edf th\u00e0nh C2 \u0111\u1ebfn C3, C2 \u0111\u1ebfn C4,&#8230;\u00a0<\/span><\/p>\n<figure id=\"attachment_10966\" aria-describedby=\"caption-attachment-10966\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-10966\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-thu-tu-trong-excel-5-400x200.jpg\" alt=\"cach-danh-so-thu-tu-trong-excel-5\" width=\"400\" height=\"200\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-thu-tu-trong-excel-5-400x200.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-thu-tu-trong-excel-5.jpg 600w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-10966\" class=\"wp-caption-text\">B\u1ea3ng excel ho\u00e0n ch\u1ec9nh STT sau khi d\u00f9ng If v\u00e0 COUNTA<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u01afu \u0111i\u1ec3m:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c cho b\u1ea3ng excel b\u1ecb khuy\u1ebft m\u1ed9t s\u1ed1 \u00f4 (kh\u00f4ng \u0111\u1ea7y \u0111\u1ee7 th\u00f4ng tin). T\u1ea1o s\u1ef1 ti\u1ec7n l\u1ee3i t\u1ed1i \u01b0u cho ng\u01b0\u1eddi s\u1eed d\u1ee5ng.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Nhanh ch\u00f3ng v\u00e0 ho\u00e0n to\u00e0n t\u1ef1 \u0111\u1ed9ng.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u1ed9 ch\u00ednh x\u00e1c cao, mang \u0111\u1ebfn \u0111\u00e1p \u00e1n ch\u00ednh x\u00e1c v\u00e0 \u00edt khi b\u1ecb sai l\u1ec7ch.<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ket_luan_chung\"><\/span><b>K\u1ebft lu\u1eadn chung<\/b><span style=\"font-weight: 400;\">\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong s\u1ed1 3 <\/span><i><span style=\"font-weight: 400;\">c\u00e1ch t\u1ef1 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel <\/span><\/i><span style=\"font-weight: 400;\">tr\u00ean th\u00ec c\u00e1ch n\u00e0o c\u0169ng hi\u1ec7u qu\u1ea3 \u0111\u1ed1i v\u1edbi t\u1eebng \u0111\u1ed1i t\u01b0\u1ee3ng ri\u00eang. N\u1ebfu c\u00e1ch th\u1ee9 3 ph\u00f9 h\u1ee3p s\u1eed d\u1ee5ng cho b\u1ea3ng s\u1ed1 li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n. Th\u00ec c\u00e1ch th\u1ee9 1, th\u1ee9 2 ph\u00f9 h\u1ee3p s\u1eed d\u1ee5ng cho b\u1ea3ng s\u1ed1 li\u1ec7u th\u00f4ng th\u01b0\u1eddng, kh\u00f4ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00e0 n\u1ebfu so s\u00e1nh c\u00e1ch 1, c\u00e1ch 2 th\u00ec c\u00f3 v\u1ebb c\u00e1ch 2 s\u1ebd hi\u1ec7u qu\u1ea3 h\u01a1n. B\u1edfi n\u00f3 \u0111\u00fang trong m\u1ecdi t\u00ecnh hu\u1ed1ng, k\u1ec3 c\u1ea3 khi b\u1ea1n c\u1eaft d\u00e1n b\u1edbt \u00f4 hay th\u00eam \u00f4. H\u00e3y t\u00f9y v\u00e0o t\u1eebng t\u00ecnh hu\u1ed1ng c\u1ee5 th\u1ec3 m\u00e0 s\u1eed d\u1ee5ng <\/span><b>c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel <\/b><span style=\"font-weight: 400;\">ph\u00f9 h\u1ee3p nh\u00e9!<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tham_khao_them_ve_cach_danh_so_thu_tu_trong_excel\"><\/span><b>Tham kh\u1ea3o th\u00eam v\u1ec1 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ngo\u00e0i vi\u1ec7c s\u1eed d\u1ee5ng m\u00e1y t\u00ednh l\u00e0m file excel th\u00ec b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111i\u1ec7n tho\u1ea1i. V\u1eady <\/span><i><span style=\"font-weight: 400;\">c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel tr\u00ean \u0111i\u1ec7n tho\u1ea1i <\/span><\/i><span style=\"font-weight: 400;\">nh\u01b0 th\u1ebf n\u00e0o? C\u1ee5 th\u1ec3 b\u1ea1n t\u1ea3i v\u1ec1 \u1ee9ng d\u1ee5ng microsoft excel v\u00e0 nh\u1eadp s\u1ed1 li\u1ec7u nh\u01b0 th\u00f4ng th\u01b0\u1eddng. Song thay v\u00ec k\u00e9o r\u00ea chu\u1ed9t nh\u01b0 \u1edf m\u00e1y t\u00ednh th\u00ec b\u1ea1n s\u1ebd fill handle \u0111\u1ed1i v\u1edbi \u0111i\u1ec7n tho\u1ea1i.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f2n \u0111\u1ed1i v\u1edbi <\/span><i><span style=\"font-weight: 400;\">c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trang trong excel <\/span><\/i><span style=\"font-weight: 400;\">b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o ngay sau \u0111\u00e2y: Ch\u1ecdn th\u1ebb view \u2192 Ch\u1ecdn Add Header ho\u1eb7c Add Footer (\u0111\u1ec3 \u0111\u00e1nh s\u1ed1 \u0111\u1ea7u ho\u1eb7c cu\u1ed1i trang) \u2192 Ch\u1ecdn Design, Page Number \u0111\u1ec3 \u0111\u00e1nh s\u1ed1 trang \u2192 Tr\u1ecf chu\u1ed9t v\u00e0o v\u1ecb tr\u00ed tr\u00ean trang gi\u1ea5y \u0111\u1ec3 c\u00f3 th\u1ec3 ch\u1ecdn v\u1ecb tr\u00ed hi\u1ec3n th\u1ecb s\u1ed1 th\u1ee9 t\u1ef1 \u0111\u00e1nh d\u1ea5u.<\/span><\/p>\n<p style=\"text-align: justify;\"><i><span style=\"font-weight: 400;\">Nh\u01b0 v\u1eady, tr\u00ean \u0111\u00e2y ch\u00ednh l\u00e0 nh\u1eefng th\u00f4ng tin li\u00ean quan \u0111\u1ebfn <\/span><\/i><b><i>c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel. <\/i><\/b><i><span style=\"font-weight: 400;\">Mong r\u1eb1ng nh\u1eefng th\u00f4ng tin tr\u00ean s\u1ebd gi\u00fap \u00edch cho b\u1ea1n trong vi\u1ec7c s\u1eed d\u1ee5ng excel th\u00e0nh th\u1ea1o h\u01a1n. Vui l\u00f2ng tham kh\u1ea3o th\u00eam c\u00e1c th\u00f4ng tin chi ti\u1ebft v\u1ec1 t\u00ednh to\u00e1n trong excel t\u1ea1i <a href=\"https:\/\/teky.edu.vn\/\">Teky.<\/a><\/span><\/i><\/p>\n<p style=\"text-align: justify;\">Xem th\u00eam:<\/p>\n<ul>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/danh-so-trang-trong-excel\/\" target=\"_blank\" rel=\"noopener\">\u0110\u00e1nh s\u1ed1 trang trong excel v\u00e0 c\u00e1ch th\u1ef1c hi\u1ec7n nhanh ch\u00f3ng d\u1ec5 hi\u1ec3u<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch \u0111\u00e1nh s\u1ed1 0 trong Excel r\u1ea5t \u0111\u01a1n gi\u1ea3n d\u00e0nh cho b\u1ea1n<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-xoa-so-trang-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch x\u00f3a s\u1ed1 trang trong excel sao cho \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/di-chuyen-cot-trong-excel\/\" target=\"_blank\" rel=\"noopener\">B\u1ecf t\u00fai ngay 2 c\u00e1ch \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 di chuy\u1ec3n c\u1ed9t trong excel<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel t\u1ef1 \u0111\u1ed9ng l\u00e0 k\u1ef9 n\u0103ng \u0111\u01a1n gi\u1ea3n m\u00e0 h\u1ea7u nh\u01b0 ai c\u0169ng c\u1ea7n ph\u1ea3i bi\u1ebft khi s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 n\u00e0y. Nh\u1eb1m gi\u00fap cho thao t\u00e1c \u0111\u00e1nh m\u00e1y c\u1ee7a b\u1ea1n tr\u1edf n\u00ean nhanh ch\u00f3ng v\u00e0 chuy\u00ean nghi\u1ec7p h\u01a1n nhi\u1ec1u. Song kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft v\u00e0 s\u1eed d\u1ee5ng &hellip;<\/p>\n","protected":false},"author":3,"featured_media":10966,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"show_on_app":false,"footnotes":""},"categories":[173],"tags":[],"class_list":["post-10961","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"acf":{"show_on_app":false},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Tham kh\u1ea3o c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel nhanh v\u00e0 ch\u00ednh x\u00e1c nh\u1ea5t<\/title>\n<meta name=\"description\" content=\"C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel t\u1ef1 \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o? \u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 nh\u01b0 th\u1ebf n\u00e0o l\u00e0 ch\u00ednh x\u00e1c v\u00e0 nhanh ch\u00f3ng? Tham kh\u1ea3o ngay \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tham kh\u1ea3o c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel nhanh v\u00e0 ch\u00ednh x\u00e1c nh\u1ea5t\" \/>\n<meta property=\"og:description\" content=\"C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel t\u1ef1 \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o? \u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 nh\u01b0 th\u1ebf n\u00e0o l\u00e0 ch\u00ednh x\u00e1c v\u00e0 nhanh ch\u00f3ng? Tham kh\u1ea3o ngay \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-07T03:07:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-06T07:05:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-thu-tu-trong-excel-5.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Huy \u0110\u00e0m\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Huy \u0110\u00e0m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\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\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel nhanh v\u00e0 ch\u00ednh x\u00e1c nh\u1ea5t\",\"datePublished\":\"2022-11-07T03:07:55+00:00\",\"dateModified\":\"2022-12-06T07:05:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/\"},\"wordCount\":1913,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-thu-tu-trong-excel-5.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/\",\"name\":\"Tham kh\u1ea3o c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel nhanh v\u00e0 ch\u00ednh x\u00e1c nh\u1ea5t\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-thu-tu-trong-excel-5.jpg\",\"datePublished\":\"2022-11-07T03:07:55+00:00\",\"dateModified\":\"2022-12-06T07:05:43+00:00\",\"description\":\"C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel t\u1ef1 \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o? \u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 nh\u01b0 th\u1ebf n\u00e0o l\u00e0 ch\u00ednh x\u00e1c v\u00e0 nhanh ch\u00f3ng? Tham kh\u1ea3o ngay \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-thu-tu-trong-excel-5.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-thu-tu-trong-excel-5.jpg\",\"width\":600,\"height\":300,\"caption\":\"B\u1ea3ng excel ho\u00e0n ch\u1ec9nh STT sau khi d\u00f9ng If v\u00e0 COUNTA\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel nhanh v\u00e0 ch\u00ednh x\u00e1c nh\u1ea5t\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\",\"name\":\"Huy \u0110\u00e0m\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"caption\":\"Huy \u0110\u00e0m\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Tham kh\u1ea3o c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel nhanh v\u00e0 ch\u00ednh x\u00e1c nh\u1ea5t","description":"C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel t\u1ef1 \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o? \u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 nh\u01b0 th\u1ebf n\u00e0o l\u00e0 ch\u00ednh x\u00e1c v\u00e0 nhanh ch\u00f3ng? Tham kh\u1ea3o ngay \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n","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:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"Tham kh\u1ea3o c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel nhanh v\u00e0 ch\u00ednh x\u00e1c nh\u1ea5t","og_description":"C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel t\u1ef1 \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o? \u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 nh\u01b0 th\u1ebf n\u00e0o l\u00e0 ch\u00ednh x\u00e1c v\u00e0 nhanh ch\u00f3ng? Tham kh\u1ea3o ngay \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n","og_url":"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2022-11-07T03:07:55+00:00","article_modified_time":"2022-12-06T07:05:43+00:00","og_image":[{"width":600,"height":300,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-thu-tu-trong-excel-5.jpg","type":"image\/jpeg"}],"author":"Huy \u0110\u00e0m","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Huy \u0110\u00e0m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"7 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel nhanh v\u00e0 ch\u00ednh x\u00e1c nh\u1ea5t","datePublished":"2022-11-07T03:07:55+00:00","dateModified":"2022-12-06T07:05:43+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/"},"wordCount":1913,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-thu-tu-trong-excel-5.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/","name":"Tham kh\u1ea3o c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel nhanh v\u00e0 ch\u00ednh x\u00e1c nh\u1ea5t","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-thu-tu-trong-excel-5.jpg","datePublished":"2022-11-07T03:07:55+00:00","dateModified":"2022-12-06T07:05:43+00:00","description":"C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel t\u1ef1 \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o? \u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 nh\u01b0 th\u1ebf n\u00e0o l\u00e0 ch\u00ednh x\u00e1c v\u00e0 nhanh ch\u00f3ng? Tham kh\u1ea3o ngay \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-thu-tu-trong-excel-5.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-thu-tu-trong-excel-5.jpg","width":600,"height":300,"caption":"B\u1ea3ng excel ho\u00e0n ch\u1ec9nh STT sau khi d\u00f9ng If v\u00e0 COUNTA"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/cach-danh-so-thu-tu-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel nhanh v\u00e0 ch\u00ednh x\u00e1c nh\u1ea5t"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c","name":"Huy \u0110\u00e0m","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","caption":"Huy \u0110\u00e0m"},"url":"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/"}]}},"thumbnail":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-thu-tu-trong-excel-5-400x200.jpg","_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/10961","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=10961"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/10961\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/10966"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=10961"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=10961"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=10961"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}