{"id":12409,"date":"2022-11-25T19:11:05","date_gmt":"2022-11-25T12:11:05","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=12409"},"modified":"2022-12-08T12:00:38","modified_gmt":"2022-12-08T05:00:38","slug":"kiem-tra-trung-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-trong-excel\/","title":{"rendered":"Ki\u1ec3m tra tr\u00f9ng trong excel nh\u01b0 th\u1ebf n\u00e0o b\u1ea1n bi\u1ebft ch\u01b0a?"},"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;12409&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;Ki\u1ec3m tra tr\u00f9ng trong excel nh\u01b0 th\u1ebf n\u00e0o b\u1ea1n bi\u1ebft ch\u01b0a?&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;\"><span style=\"font-weight: 400;\">Tr\u00ean m\u1ed9t kh\u1ed1i c\u00f4ng vi\u1ec7c l\u1edbn th\u01b0\u1eddng \u0111\u00f2i h\u1ecfi con ng\u01b0\u1eddi ph\u1ea3i nh\u1eadp m\u1ed9t l\u01b0\u1ee3ng d\u1eef li\u1ec7u, h\u00e0ng h\u00f3a l\u1edbn; \u0111\u1ec3 l\u1eadp ra c\u00e1c b\u1ea3n b\u00e1o c\u00e1o, th\u1ed1ng k\u00ea v\u1ec1 kh\u00e1ch h\u00e0ng, h\u00e0ng h\u00f3a,&#8230; Ch\u00ednh v\u00ec v\u1eady m\u00e0 \u0111\u00f4i l\u00fac vi\u1ec7c b\u1ecb nh\u1eadp tr\u00f9ng\u00a0 m\u1ed9t ho\u1eb7c nhi\u1ec1u s\u1ed1 li\u1ec7u l\u00e0 vi\u1ec7c kh\u00f4ng th\u1ec3 tr\u00e1nh kh\u1ecfi. Tuy nhi\u00ean n\u00f3 s\u1ebd l\u00e0m \u1ea3nh h\u01b0\u1edfng c\u00f4ng ty c\u0169ng nh\u01b0 ti\u1ebfn tr\u00ecnh c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n. <\/span><span style=\"font-weight: 400;\">\u0110\u1ec3 tr\u00e1nh kh\u1ecfi nh\u1eefng sai l\u1ea7m th\u00ec sau khi nh\u1eadp \u0111\u1ee7 d\u1eef li\u1ec7u; ch\u00fang ta n\u00ean s\u1eed d\u1ee5ng ph\u01b0\u01a1ng th\u1ee9c <\/span><b>ki\u1ec3m tra tr\u00f9ng trong Excel<\/b><span style=\"font-weight: 400;\"> \u0111\u01a1n gi\u1ea3n m\u00e0 mang l\u1ea1i hi\u1ec7u qu\u1ea3 cao trong c\u00f4ng vi\u1ec7c. <\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y; m\u00ecnh s\u1ebd h\u01b0\u1edbng d\u1eabn t\u1ea5t c\u1ea3 c\u00e1c b\u1ea1n c\u00e1ch \u0111\u1ec3 ki\u1ec3m tra gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p trong b\u1ea3ng excel; c\u0169ng nh\u01b0 c\u00e1c phi\u00ean b\u1ea3n Excel 2019, 2016, 2013, 2010.\u00a0<\/span><\/p>\n<figure id=\"attachment_12426\" aria-describedby=\"caption-attachment-12426\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12426 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/kiem-tra-trung-trong-excel-1.jpg\" alt=\"Ki\u1ec3m tra tr\u00f9ng trong excel nh\u01b0 th\u1ebf n\u00e0o\" width=\"600\" height=\"693\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/kiem-tra-trung-trong-excel-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/kiem-tra-trung-trong-excel-1-346x400.jpg 346w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12426\" class=\"wp-caption-text\">Ki\u1ec3m tra tr\u00f9ng trong excel nh\u01b0 th\u1ebf n\u00e0o<\/figcaption><\/figure>\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\/kiem-tra-trung-trong-excel\/#Gioi_thieu_cach_kiem_tra_bang_Conditional_Formatting\" >Gi\u1edbi thi\u1ec7u c\u00e1ch ki\u1ec3m tra b\u1eb1ng Conditional Formatting<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-trong-excel\/#Cac_buoc_kiem_tra_trung_trong_Excel\" >C\u00e1c b\u01b0\u1edbc ki\u1ec3m tra tr\u00f9ng trong Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-trong-excel\/#Buoc_1_Lua_chon_cot_thong_so_can_kiem_tra_cac_gia_tri_bi_trung_lap\" >B\u01b0\u1edbc 1: L\u1ef1a ch\u1ecdn c\u1ed9t th\u00f4ng s\u1ed1 c\u1ea7n ki\u1ec3m tra c\u00e1c gi\u00e1 tr\u1ecb b\u1ecb tr\u00f9ng l\u1eb7p<\/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\/kiem-tra-trung-trong-excel\/#Buoc_2_Cach_xac_dinh_gia_tri_bi_trung_lap\" >B\u01b0\u1edbc 2: C\u00e1ch x\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb b\u1ecb tr\u00f9ng l\u1eb7p<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-trong-excel\/#Kiem_tra_trung_ten\" >Ki\u1ec3m tra tr\u00f9ng t\u00ean<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-trong-excel\/#Luu_y\" >L\u01b0u \u00fd<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-trong-excel\/#Buoc_3_Ket_qua_kiem_tra_trung_trong_excel\" >B\u01b0\u1edbc 3: K\u1ebft qu\u1ea3 ki\u1ec3m tra tr\u00f9ng trong excel<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Gioi_thieu_cach_kiem_tra_bang_Conditional_Formatting\"><\/span><b>Gi\u1edbi thi\u1ec7u c\u00e1ch ki\u1ec3m tra b\u1eb1ng Conditional Formatting<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch th\u1ee9c \u0111\u1ec3 d\u1ec5 d\u00e0ng <\/span><b>ki\u1ec3m tra tr\u00f9ng trong Excel; <\/b><span style=\"font-weight: 400;\">\u0111\u1ea7u ti\u00ean ch\u00fang t\u00f4i mu\u1ed1n gi\u1edbi thi\u1ec7u l\u00e0 ki\u1ec3m tra b\u1eb1ng c\u00f4ng c\u1ee5 Conditional Formatting. \u0110\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00f4ng c\u1ee5 n\u00e0y; ch\u00fang ta c\u00f9ng \u0111i kh\u00e1m ph\u00e1 t\u1ea7m quan tr\u1ecdng hay l\u00e0 c\u00e1c t\u00ednh n\u0103ng n\u1ed5i b\u1eadt; v\u00e0 vai tr\u00f2 c\u1ee7a n\u00f3 t\u1ea1i trang t\u00ednh Excel nh\u00e9.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Conditional Formatting, \u0111\u01b0\u1ee3c coi l\u00e0 m\u1ed9t l\u00e0 \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n; ch\u01b0a h\u1ebft c\u00f4ng c\u1ee5 n\u00e0y c\u00f2n gi\u00fap ng\u01b0\u1eddi d\u00f9ng \u0111\u1ecbnh d\u1ea1ng trang t\u00ednh; nh\u1edd v\u00e0o c\u00e1c thao t\u00e1c s\u1eafp x\u1ebfp ph\u00e2n lo\u1ea1i d\u1eef li\u1ec7u. T\u1ea1i th\u01b0 m\u1ee5c c\u1ee7a Conditional Formatting c\u00f3 th\u1ec3 \u0111\u1ed5i m\u00e0u, th\u00eam \u1ea3nh, highlight\u2026; \u0111\u1ec3 cho b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 \u0111\u1ed9 ph\u00e2n chia r\u00f5 r\u00e0ng.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u1edd v\u00e0o vi\u1ec7c \u1ee9ng d\u1ee5ng Excel th\u01b0\u1eddng xuy\u00ean \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt c\u00e1c t\u00ednh n\u0103ng linh ho\u1ea1t; c\u00f4ng c\u1ee5 Conditional Formatting \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng trong r\u1ea5t nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p; c\u00f3 th\u1ec3 l\u00e0 \u0111\u00e1nh d\u1ea5u d\u1eef li\u1ec7u, x\u00f3a ho\u1eb7c th\u00eam d\u1eef li\u1ec7u. \u0110\u1eb7c bi\u1ec7t l\u00e0 ch\u1ee9c n\u0103ng <\/span><b>ki\u1ec3m tra tr\u00f9ng l\u1eb7p <\/b><span style=\"font-weight: 400;\">th\u00ec Conditional Formatting.<\/span><\/p>\n<figure id=\"attachment_12430\" aria-describedby=\"caption-attachment-12430\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12430 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/kiem-tra-trung-trong-excel-5.jpg\" alt=\"Gi\u1edbi thi\u1ec7u c\u00e1ch ki\u1ec3m tra b\u1eb1ng Conditional Formatting\" width=\"600\" height=\"667\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/kiem-tra-trung-trong-excel-5.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/kiem-tra-trung-trong-excel-5-360x400.jpg 360w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12430\" class=\"wp-caption-text\">Gi\u1edbi thi\u1ec7u c\u00e1ch ki\u1ec3m tra b\u1eb1ng Conditional Formatting<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<p>Xem th\u00eam:<\/p>\n<p><a href=\"https:\/\/teky.edu.vn\/blog\/ham-countif-trong-excel\/\">H\u00e0m countif trong excel c\u00f3 nh\u1eefng t\u00e1c d\u1ee5ng g\u00ec trong to\u00e1n h\u1ecdc?<\/a><\/p>\n<p><a href=\"https:\/\/teky.edu.vn\/blog\/doi-duoi-excel-sang-pdf\/\">\u0110\u1ed5i \u0111u\u00f4i excel sang PDF m\u1ed9t c\u00e1ch nhanh nh\u1ea5t, b\u1ea1n \u0111\u00e3 bi\u1ebft ch\u01b0a?<\/a><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cac_buoc_kiem_tra_trung_trong_Excel\"><\/span><b>C\u00e1c b\u01b0\u1edbc ki\u1ec3m tra tr\u00f9ng trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1ed7i khi nh\u1eadp xong d\u1eef li\u1ec7u c\u00e1c b\u1ea1n n\u00ean c\u00f3 thao t\u00e1c<\/span> <span style=\"font-weight: 400;\">ki\u1ec3m tra tr\u00f9ng; \u0111i\u1ec1u n\u00e0y s\u1ebd gi\u00fap gi\u1ea3m thi\u1ec3u nh\u1eefng r\u1eafc r\u1ed1i trong s\u1ed1 li\u1ec7u. V\u1eady th\u00ec c\u00e1c b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch<\/span><b> ki\u1ec3m tra tr\u00f9ng l\u1eb7p trong Excel<\/b><span style=\"font-weight: 400;\"> ch\u01b0a; n\u1ebfu ch\u01b0a h\u00e3y c\u00f9ng m\u00ecnh \u0111i qua m\u1ed9t v\u00e0i b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n v\u1edbi c\u00f4ng c\u1ee5 Conditional Formatting. H\u00e3y c\u00f9ng nhau th\u1ef1c h\u00e0nh theo 3 b\u01b0\u1edbc c\u1ef1c d\u1ec5 d\u01b0\u1edbi \u0111\u00e2y nh\u00e9.<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"T\u00ecm d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p trong b\u1ea3ng Excel v\u00e0 t\u00f4 m\u00e0u\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/vaHiEKurv3Q?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<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 gi\u00fap c\u00e1c b\u1ea1n d\u1ec5 h\u00ecnh dung ra c\u00e1ch l\u00e0m; c\u0169ng nh\u01b0 n\u1eafm b\u1eaft \u0111\u01b0\u1ee3c ngay ki\u1ebfn th\u1ee9c trong l\u1ea7n luy\u1ec7n t\u1eadp \u0111\u1ea7u ti\u00ean; th\u00ec ch\u00fang m\u00ecnh s\u1ebd \u00e1p d\u1ee5ng l\u00fd thuy\u1ebft v\u00e0o m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 ki\u1ec3m tra tr\u00f9ng l\u1eb7p cho c\u00e1c b\u1ea1n ti\u1ec7n theo d\u00f5i.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Buoc_1_Lua_chon_cot_thong_so_can_kiem_tra_cac_gia_tri_bi_trung_lap\"><\/span><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: L\u1ef1a ch\u1ecdn c\u1ed9t th\u00f4ng s\u1ed1 c\u1ea7n ki\u1ec3m tra c\u00e1c gi\u00e1 tr\u1ecb b\u1ecb tr\u00f9ng l\u1eb7p<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<figure id=\"attachment_12431\" aria-describedby=\"caption-attachment-12431\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12431 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/kiem-tra-trung-trong-excel-6.jpg\" alt=\"L\u1ef1a ch\u1ecdn c\u1ed9t th\u00f4ng s\u1ed1 c\u1ea7n ki\u1ec3m tra\" width=\"600\" height=\"685\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/kiem-tra-trung-trong-excel-6.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/kiem-tra-trung-trong-excel-6-350x400.jpg 350w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12431\" class=\"wp-caption-text\">L\u1ef1a ch\u1ecdn c\u1ed9t th\u00f4ng s\u1ed1 c\u1ea7n ki\u1ec3m tra<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ta l\u1ea5y v\u00ed d\u1ee5 trong b\u1ea3ng Danh s\u00e1ch \u0111i\u1ec3m thi gi\u1eefa h\u1ecdc k\u00ec c\u1ee7a c\u00e1c b\u1ea1n sinh vi\u00ean tr\u01b0\u1eddng \u0110\u1ea1i h\u1ecdc Kinh t\u1ebf Qu\u1ed1c D\u00e2n. Ta s\u1ebd l\u1ef1a ch\u1ecdn ra c\u1ed9t \u0111\u1ea7u ti\u00ean l\u00e0 c\u1ed9t H\u1ecd t\u00ean; \u0111\u1ec3 x\u00e1c nh\u1eadn l\u1ea1i c\u00e1c gi\u00e1 tr\u1ecb ch\u1ec9 \u0111\u01b0\u1ee3c xu\u1ea5t hi\u1ec7n m\u1ed9t l\u1ea7n duy nh\u1ea5t. V\u00e0o tr\u01b0\u1eddng h\u1ee3p \u0111\u1eb7c bi\u1ec7t n\u1ebfu t\u00ean sinh vi\u00ean tr\u00f9ng nhau th\u00ec ta l\u1ea7n l\u01b0\u1ee3t x\u00e9t \u0111\u1ebfn ng\u00e0y sinh, s\u1ed1 \u0111i\u1ec7n tho\u1ea1i\u2026<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tuy nhi\u00ean th\u00ec c\u1ed9t gi\u1edbi t\u00ednh v\u00e0 qu\u00ea qu\u00e1n s\u1ebd \u00edt \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng h\u01a1n; b\u1edfi c\u00f3 nhi\u1ec1u ng\u01b0\u1eddi s\u1ebd b\u1ecb tr\u00f9ng nhau n\u00ean d\u1eabn \u0111\u1ebfn k\u1ebft qu\u1ea3 s\u1ebd kh\u00f4ng ch\u00ednh x\u00e1c. Do \u0111\u00f3, c\u00e1c b\u1ea1n c\u1ea7n l\u1ef1a ch\u1ecdn \u0111\u00fang c\u1ed9t d\u1eef li\u1ec7u v\u00e0 th\u1ef1c hi\u1ec7n \u0111\u00fang thao t\u00e1c <\/span><b>ki\u1ec3m tra tr\u00f9ng trong Excel<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Buoc_2_Cach_xac_dinh_gia_tri_bi_trung_lap\"><\/span><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: C\u00e1ch x\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb b\u1ecb tr\u00f9ng l\u1eb7p<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<figure id=\"attachment_12429\" aria-describedby=\"caption-attachment-12429\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12429 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/kiem-tra-trung-trong-excel-4.jpg\" alt=\"C\u00e1ch x\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb b\u1ecb tr\u00f9ng l\u1eb7p\" width=\"600\" height=\"645\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/kiem-tra-trung-trong-excel-4.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/kiem-tra-trung-trong-excel-4-372x400.jpg 372w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12429\" class=\"wp-caption-text\">C\u00e1ch x\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb b\u1ecb tr\u00f9ng l\u1eb7p<\/figcaption><\/figure>\n<h4><span class=\"ez-toc-section\" id=\"Kiem_tra_trung_ten\"><\/span>Ki\u1ec3m tra tr\u00f9ng t\u00ean<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi \u0111\u00e3 l\u1ef1a ch\u1ecdn \u0111\u01b0\u1ee3c c\u1ed9t d\u1eef li\u1ec7u c\u1ea7n ki\u1ec3m tra tr\u00f9ng l\u1eb7p trong Excel; th\u00ec ta c\u1ea7n b\u00f4i \u0111en to\u00e0n b\u1ed9 c\u1ed9t \u0111\u00f3 l\u1ea1i.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ti\u1ebfp t\u1ee5c \u1edf v\u00ed d\u1ee5 tr\u00ean, ta s\u1ebd l\u00e0m \u0111en c\u1ed9t<\/span> <span style=\"font-weight: 400;\">H\u1ecd v\u00e0 t\u00ean. <\/span><span style=\"font-weight: 400;\">Sau \u0111\u00f3 nh\u1ea5p chu\u1ed9t v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng <\/span><i><span style=\"font-weight: 400;\">Home<\/span><\/i><span style=\"font-weight: 400;\"> tr\u00ean thanh c\u00f4ng c\u1ee5 &gt; di chuy\u1ec3n sang nh\u00f3m <\/span><i><span style=\"font-weight: 400;\">Style<\/span><\/i><span style=\"font-weight: 400;\"> &gt;nh\u1ea5n ch\u1ecdn th\u01b0 m\u1ee5c <\/span><i><span style=\"font-weight: 400;\">Conditional Formatting <\/span><\/i><span style=\"font-weight: 400;\">&gt; sau \u0111\u00f3 ch\u1ecdn ti\u1ebfp\u00a0 <\/span><i><span style=\"font-weight: 400;\">Highlight Cells Rules &gt;\u00a0 <\/span><\/i><span style=\"font-weight: 400;\">cu\u1ed1i c\u00f9ng l\u00e0 <\/span><i><span style=\"font-weight: 400;\">Duplicate Values.<\/span><\/i><\/p>\n<figure id=\"attachment_12427\" aria-describedby=\"caption-attachment-12427\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12427 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/kiem-tra-trung-trong-excel-2.jpg\" alt=\"Ki\u1ec3m tra tr\u00f9ng t\u00ean\" width=\"600\" height=\"309\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/kiem-tra-trung-trong-excel-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/kiem-tra-trung-trong-excel-2-400x206.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12427\" class=\"wp-caption-text\">Ki\u1ec3m tra tr\u00f9ng t\u00ean<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi ho\u00e0n t\u1ea5t c\u00e1c m\u1ee5c \u0111\u1ebfn\u00a0 <\/span><i><span style=\"font-weight: 400;\">Duplicate Values<\/span><\/i><span style=\"font-weight: 400;\">, m\u00e0n h\u00ecnh m\u00e1y t\u00ednh s\u1ebd xu\u1ea5t hi\u1ec7n m\u1ed9t h\u1ed9i tho\u1ea1i t\u00f9y ch\u1ecdn nh\u1ecf. T\u1ea1i \u0111\u00e2y, b\u1ea1n c\u1ea7n ph\u1ea3i l\u1ef1a ch\u1ecdn m\u00e0u s\u1eafc kh\u00e1c v\u1edbi d\u1eef li\u1ec7u c\u00f3 s\u1eb5n \u0111\u1ec3 sau khi \u00e1p d\u1ee5ng <\/span><b>c\u00e1ch ki\u1ec3m tra tr\u00f9ng t\u00ean trong Excel<\/b><span style=\"font-weight: 400;\"> \u0111\u1ec3 nh\u1eefng gi\u00e1 tr\u1ecb n\u00e0o b\u1ecb tr\u00f9ng l\u1eb7p s\u1ebd ngay l\u1eadp t\u1ee9c t\u1ef1 \u0111\u1ed9ng b\u1ecb \u0111\u1ed5i m\u00e0u.<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Luu_y\"><\/span>L\u01b0u \u00fd<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tuy nhi\u00ean \u1edf h\u1ed9p tho\u1ea1i t\u00f9y ch\u1ecdn \u0111\u00f3 c\u00f3 2 c\u00e1ch \u0111\u1ed5i m\u00e0u, n\u1ebfu b\u1ea1n nh\u1ea5p chu\u1ed9t v\u00e0o t\u00f9y ch\u1ecdn th\u1ee9 1 nh\u1ea5n d\u00f2ng ch\u1eef <\/span><i><span style=\"font-weight: 400;\">Duplicate <\/span><\/i><span style=\"font-weight: 400;\">th\u00ec b\u1ed9 \u0111i\u1ec1u khi\u1ec3n m\u00e1y t\u00ednh s\u1ebd ki\u1ec3m tra tr\u00f9ng trong Excel v\u00e0 in m\u00e0u v\u00e0o c\u00e1c \u00f4 d\u1eef li\u1ec7u b\u1ecb tr\u00f9ng.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ng\u01b0\u1ee3c l\u1ea1i n\u1ebfu b\u1ea1n nh\u1ea5p chu\u1ed9t v\u00e0o t\u00f9y ch\u1ecdn th\u1ee9 nh\u1ea5t nh\u01b0ng nh\u1ea5n d\u00f2ng <\/span><i><span style=\"font-weight: 400;\">Unique<\/span><\/i><span style=\"font-weight: 400;\">, h\u1ec7 th\u1ed1ng Excel s\u1ebd bi\u1ec3u th\u1ecb m\u00e0u cho t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb l\u00e0 duy nh\u1ea5t. \u0110i\u1ec1u n\u00e0y \u0111\u1ed3ng ngh\u0129a v\u1edbi vi\u1ec7c nh\u1eefng \u00f4 kh\u00f4ng chuy\u1ec3n m\u00e0u s\u1ebd \u0111\u1ea1i di\u1ec7n cho gi\u00e1 tr\u1ecb b\u1ecb tr\u00f9ng v\u00e0 ta c\u1ea7n lo\u1ea1i b\u1ecf ch\u00fang.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u1ea1i v\u1ecb tr\u00ed \u00f4 t\u00f9y ch\u1ecdn 2, khi ki\u1ec3m tra tr\u00f9ng trong excel s\u1ebd kh\u00f4ng t\u1ef1 hi\u1ec7n m\u00e0u. N\u1ebfu b\u1ea1n mu\u1ed1n nh\u00ecn r\u00f5 h\u01a1n th\u00ec c\u00f3 th\u1ec3 t\u1ef1 ch\u1ecdn m\u00e0u s\u1eafc sau khi gi\u00e1 tr\u1ecb l\u1eb7p hi\u1ec3n th\u1ecb. Ngo\u00e0i ra, b\u1ea1n c\u00f2n c\u00f3 th\u1ec3 b\u00f4i m\u00e0u c\u1ea3 \u00f4 l\u1eabn ch\u1eef.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 b\u1ea1n ch\u1ecdn <\/span><i><span style=\"font-weight: 400;\">Light Red Fill with Dark Red Text <\/span><\/i><span style=\"font-weight: 400;\">&#8211; \u0111\u00e2y l\u00e0 t\u00f9y ch\u1ecdn b\u00f4i \u0111\u1ecf c\u1ea3 \u00f4 v\u00e0 ch\u1eef; n\u00f3 tr\u1edf n\u00ean n\u1ed5i b\u1eadt h\u01a1n gi\u00fap b\u1ea1n d\u1ec5 nh\u1eadn di\u1ec7n v\u1ecb tr\u00ed b\u1ecb tr\u00f9ng l\u1eb7p.<\/span><\/p>\n<figure id=\"attachment_12428\" aria-describedby=\"caption-attachment-12428\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12428 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/kiem-tra-trung-trong-excel-3.jpg\" alt=\"L\u01b0u \u00fd khi ki\u1ec3m tra tr\u00f9ng l\u1eb7p trong excel\" width=\"600\" height=\"496\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/kiem-tra-trung-trong-excel-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/kiem-tra-trung-trong-excel-3-400x331.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12428\" class=\"wp-caption-text\">L\u01b0u \u00fd khi ki\u1ec3m tra tr\u00f9ng l\u1eb7p trong excel<\/figcaption><\/figure>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Buoc_3_Ket_qua_kiem_tra_trung_trong_excel\"><\/span><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: K\u1ebft qu\u1ea3 ki\u1ec3m tra tr\u00f9ng trong excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Sau ho\u00e0n thi\u1ec7n c\u00e1c thao t\u00e1c \u1edf Conditional Formatting \u0111\u1ec3 <\/span><b>ki\u1ec3m tra d\u1eef li\u1ec7u tr\u00f9ng trong Excel<\/b><span style=\"font-weight: 400;\">; b\u1ea1n c\u1ea7n nh\u1ea5p <\/span><i><span style=\"font-weight: 400;\">OK<\/span><\/i><span style=\"font-weight: 400;\"> v\u00e0 \u0111\u00f3ng h\u1ed9p tho\u1ea1i ho\u1eb7c c\u00f3 th\u1ec3 d\u00f9ng l\u1ec7nh Enter. Khi \u0111\u00f3 Excel s\u1ebd hi\u1ec3n th\u1ecb nh\u1eefng gi\u00e1 tr\u1ecb c\u1ea7n lo\u1ea1i b\u1ecf s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb kh\u00e1c bi\u1ec7t so v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ngo\u00e0i ra, v\u1eabn c\u00f2n r\u1ea5t nhi\u1ec1u c\u00e1ch kh\u00e1c \u0111\u1ec3 <\/span>ki\u1ec3m tra trong excel;<span style=\"font-weight: 400;\"> nh\u01b0 l\u00e0 nh\u1eadp l\u1ec7nh Ctrl+F ho\u1eb7c l\u1ecdc Tool. Tuy nhi\u00ean 2 c\u00e1ch n\u00e0y c\u00f2n nhi\u1ec1u h\u1ea1n ch\u1ebf b\u1edfi c\u00e1ch n\u00e0y ta ph\u1ea3i \u0111i l\u1ecdc t\u1eebng d\u1eef li\u1ec7u m\u1ed9t; s\u1ebd l\u00e0m m\u1ea5t kh\u00e1 nhi\u1ec1u th\u1eddi gian.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c tr\u00ean b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 t\u1ef1 <\/span><b>ki\u1ec3m tra tr\u00f9ng trong Excel<\/b><span style=\"font-weight: 400;\"> b\u1eb1ng Conditional Formatting; m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng. V\u1eady th\u00ec b\u1ea1n c\u00f2n ng\u1ea7n ng\u1ea1i g\u00ec m\u00e0 kh\u00f4ng t\u00edch l\u0169y th\u00eam cho b\u1ea3n th\u00e2n m\u1ed9t th\u1ee7 thu\u1eadt c\u1ee7a tin h\u1ecdc <a href=\"https:\/\/vi.wikipedia.org\/wiki\/V%C4%83n_ph%C3%B2ng\">v\u0103n ph\u00f2ng<\/a> nh\u1ec9?\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\">Ch\u00fang t\u00f4i r\u1ea5t vui khi cung c\u1ea5p c\u00e1c th\u00f4ng tin h\u1eefu \u00edch cho c\u00e1c b\u1ea1n. M\u1ecdi th\u00f4ng tin chi ti\u1ebft xin li\u00ean h\u1ec7 v\u1edbi Teky.edu.vn \u0111\u1ec3 \u0111\u01b0\u1ee3c t\u01b0 v\u1ea5n v\u00e0 h\u01b0\u1edbng d\u1eabn.<\/p>\n<p>Xem th\u00eam:<\/p>\n<ul>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-doi-cot-trong-excel\/\" target=\"_blank\" rel=\"noopener\">Kh\u00e1m ph\u00e1 ngay 3 c\u00e1ch \u0111\u1ed5i c\u1ed9t trong Excel \u0111\u01a1n gi\u1ea3n<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-khoa-cot-trong-excel\/\" target=\"_blank\" rel=\"noopener\">B\u1eadt m\u00ed c\u00e1ch kh\u00f3a c\u1ed9t trong Excel ch\u1ec9 trong m\u1ed9t n\u1ed1t nh\u1ea1c<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Tr\u00ean m\u1ed9t kh\u1ed1i c\u00f4ng vi\u1ec7c l\u1edbn th\u01b0\u1eddng \u0111\u00f2i h\u1ecfi con ng\u01b0\u1eddi ph\u1ea3i nh\u1eadp m\u1ed9t l\u01b0\u1ee3ng d\u1eef li\u1ec7u, h\u00e0ng h\u00f3a l\u1edbn; \u0111\u1ec3 l\u1eadp ra c\u00e1c b\u1ea3n b\u00e1o c\u00e1o, th\u1ed1ng k\u00ea v\u1ec1 kh\u00e1ch h\u00e0ng, h\u00e0ng h\u00f3a,&#8230; Ch\u00ednh v\u00ec v\u1eady m\u00e0 \u0111\u00f4i l\u00fac vi\u1ec7c b\u1ecb nh\u1eadp tr\u00f9ng\u00a0 m\u1ed9t ho\u1eb7c nhi\u1ec1u s\u1ed1 li\u1ec7u l\u00e0 vi\u1ec7c kh\u00f4ng th\u1ec3 tr\u00e1nh kh\u1ecfi. &hellip;<\/p>\n","protected":false},"author":3,"featured_media":12425,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-12409","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"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>Ki\u1ec3m tra tr\u00f9ng trong excel nh\u01b0 th\u1ebf n\u00e0o b\u1ea1n bi\u1ebft ch\u01b0a?<\/title>\n<meta name=\"description\" content=\"C\u00e1c b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch ki\u1ec3m tra tr\u00f9ng l\u1eb7p trong Excel ch\u01b0a, n\u1ebfu ch\u01b0a h\u00e3y c\u00f9ng m\u00ecnh \u0111i qua m\u1ed9t v\u00e0i b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n v\u1edbi c\u00e1c c\u00e1ch sau\" \/>\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\/kiem-tra-trung-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Ki\u1ec3m tra tr\u00f9ng trong excel nh\u01b0 th\u1ebf n\u00e0o b\u1ea1n bi\u1ebft ch\u01b0a?\" \/>\n<meta property=\"og:description\" content=\"C\u00e1c b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch ki\u1ec3m tra tr\u00f9ng l\u1eb7p trong Excel ch\u01b0a, n\u1ebfu ch\u01b0a h\u00e3y c\u00f9ng m\u00ecnh \u0111i qua m\u1ed9t v\u00e0i b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n v\u1edbi c\u00e1c c\u00e1ch sau\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-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-25T12:11:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-08T05:00:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/kiem-tra-trung-trong-excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"338\" \/>\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\/kiem-tra-trung-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"Ki\u1ec3m tra tr\u00f9ng trong excel nh\u01b0 th\u1ebf n\u00e0o b\u1ea1n bi\u1ebft ch\u01b0a?\",\"datePublished\":\"2022-11-25T12:11:05+00:00\",\"dateModified\":\"2022-12-08T05:00:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-trong-excel\/\"},\"wordCount\":1937,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/kiem-tra-trung-trong-excel.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-trong-excel\/\",\"name\":\"Ki\u1ec3m tra tr\u00f9ng trong excel nh\u01b0 th\u1ebf n\u00e0o b\u1ea1n bi\u1ebft ch\u01b0a?\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/kiem-tra-trung-trong-excel.jpg\",\"datePublished\":\"2022-11-25T12:11:05+00:00\",\"dateModified\":\"2022-12-08T05:00:38+00:00\",\"description\":\"C\u00e1c b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch ki\u1ec3m tra tr\u00f9ng l\u1eb7p trong Excel ch\u01b0a, n\u1ebfu ch\u01b0a h\u00e3y c\u00f9ng m\u00ecnh \u0111i qua m\u1ed9t v\u00e0i b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n v\u1edbi c\u00e1c c\u00e1ch sau\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/kiem-tra-trung-trong-excel.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/kiem-tra-trung-trong-excel.jpg\",\"width\":600,\"height\":338,\"caption\":\"Ki\u1ec3m tra tr\u00f9ng trong excel nh\u01b0 th\u1ebf n\u00e0o b\u1ea1n bi\u1ebft ch\u01b0a?\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-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\":\"Ki\u1ec3m tra tr\u00f9ng trong excel nh\u01b0 th\u1ebf n\u00e0o b\u1ea1n bi\u1ebft ch\u01b0a?\"}]},{\"@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":"Ki\u1ec3m tra tr\u00f9ng trong excel nh\u01b0 th\u1ebf n\u00e0o b\u1ea1n bi\u1ebft ch\u01b0a?","description":"C\u00e1c b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch ki\u1ec3m tra tr\u00f9ng l\u1eb7p trong Excel ch\u01b0a, n\u1ebfu ch\u01b0a h\u00e3y c\u00f9ng m\u00ecnh \u0111i qua m\u1ed9t v\u00e0i b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n v\u1edbi c\u00e1c c\u00e1ch sau","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\/kiem-tra-trung-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"Ki\u1ec3m tra tr\u00f9ng trong excel nh\u01b0 th\u1ebf n\u00e0o b\u1ea1n bi\u1ebft ch\u01b0a?","og_description":"C\u00e1c b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch ki\u1ec3m tra tr\u00f9ng l\u1eb7p trong Excel ch\u01b0a, n\u1ebfu ch\u01b0a h\u00e3y c\u00f9ng m\u00ecnh \u0111i qua m\u1ed9t v\u00e0i b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n v\u1edbi c\u00e1c c\u00e1ch sau","og_url":"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-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-25T12:11:05+00:00","article_modified_time":"2022-12-08T05:00:38+00:00","og_image":[{"width":600,"height":338,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/kiem-tra-trung-trong-excel.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\/kiem-tra-trung-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"Ki\u1ec3m tra tr\u00f9ng trong excel nh\u01b0 th\u1ebf n\u00e0o b\u1ea1n bi\u1ebft ch\u01b0a?","datePublished":"2022-11-25T12:11:05+00:00","dateModified":"2022-12-08T05:00:38+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-trong-excel\/"},"wordCount":1937,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/kiem-tra-trung-trong-excel.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-trong-excel\/","name":"Ki\u1ec3m tra tr\u00f9ng trong excel nh\u01b0 th\u1ebf n\u00e0o b\u1ea1n bi\u1ebft ch\u01b0a?","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/kiem-tra-trung-trong-excel.jpg","datePublished":"2022-11-25T12:11:05+00:00","dateModified":"2022-12-08T05:00:38+00:00","description":"C\u00e1c b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch ki\u1ec3m tra tr\u00f9ng l\u1eb7p trong Excel ch\u01b0a, n\u1ebfu ch\u01b0a h\u00e3y c\u00f9ng m\u00ecnh \u0111i qua m\u1ed9t v\u00e0i b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n v\u1edbi c\u00e1c c\u00e1ch sau","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/kiem-tra-trung-trong-excel.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/kiem-tra-trung-trong-excel.jpg","width":600,"height":338,"caption":"Ki\u1ec3m tra tr\u00f9ng trong excel nh\u01b0 th\u1ebf n\u00e0o b\u1ea1n bi\u1ebft ch\u01b0a?"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/kiem-tra-trung-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":"Ki\u1ec3m tra tr\u00f9ng trong excel nh\u01b0 th\u1ebf n\u00e0o b\u1ea1n bi\u1ebft ch\u01b0a?"}]},{"@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\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12409","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=12409"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12409\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/12425"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=12409"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=12409"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=12409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}