{"id":12460,"date":"2022-11-26T10:49:34","date_gmt":"2022-11-26T03:49:34","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=12460"},"modified":"2022-12-13T16:58:03","modified_gmt":"2022-12-13T09:58:03","slug":"huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel H\u01b0\u1edbng d\u1eabn chi ti\u1ebft 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;12460&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;4&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 - (4 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel H\u01b0\u1edbng d\u1eabn chi ti\u1ebft 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 - (4 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><em>Khi s\u1eed d\u1ee5ng Excel ch\u1eafc ch\u1eafn m\u1ecdi ng\u01b0\u1eddi s\u1ebd \u00edt l\u1ea7n c\u1ea7n l\u1ecdc d\u1eef li\u1ec7u. Ch\u00ednh v\u00ec th\u1ebf h\u00e0m l\u1ecdc d\u1eef li\u1ec7u hay c\u00f2n c\u00f3 t\u00ean g\u1ecdi kh\u00e1c l\u00e0m h\u00e0m Filter \u0111\u00f3ng vai tr\u00f2 quan tr\u1ecdng. \u0110\u00e2y s\u1ebd l\u00e0 h\u00e0m gi\u00fap b\u1ea1n l\u1ecdc v\u00e0 tr\u1ea3 l\u1eddi c\u00e1c d\u1eef li\u1ec7u t\u1ee9c th\u00ec theo c\u00e1c \u0111i\u1ec1u ki\u1ec7n ti\u00eau ch\u00ed m\u00e0 b\u1ea1n c\u1ea7n l\u1ecdc. C\u00f9ng teky.edu.vn theo d\u00f5i c\u00e1c th\u00f4ng tin d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 bi\u1ebft <strong>c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel<\/strong> nh\u00e9.<\/em> <\/span><\/p>\n<p style=\"text-align: justify;\"><!--more--><\/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\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/#_Ham_loc_trong_Excel_la_gi_ham_nay_dung_de_lam_gi\" >\u00a0H\u00e0m l\u1ecdc trong Excel l\u00e0 g\u00ec? h\u00e0m n\u00e0y d\u00f9ng \u0111\u1ec3 l\u00e0m g\u00ec?\u00a0<\/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\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/#Vi_du_co_ban_ve_ham_loc_du_lieu_trong_Excel\" >V\u00ed d\u1ee5 c\u01a1 b\u1ea3n v\u1ec1 h\u00e0m l\u1ecdc d\u1eef li\u1ec7u trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/#Cac_vi_du_cung_mot_so_loi_co_ban_khac_khi_su_dung_ham_loc_trong_Excel\" >C\u00e1c v\u00ed d\u1ee5 c\u00f9ng m\u1ed9t s\u1ed1 l\u1ed7i c\u01a1 b\u1ea3n kh\u00e1c khi s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc 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-4\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/#Mot_so_vi_du_khac\" >M\u1ed9t s\u1ed1 v\u00ed d\u1ee5 kh\u00e1c<\/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\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/#Vi_du_1\" >V\u00ed d\u1ee5 1<\/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\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/#Vi_du_so_2\" >V\u00ed d\u1ee5 s\u1ed1 2<\/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\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/#Mot_so_loi_thuong_gap_khi_su_dung_ham_loc_trong_Excel\" >M\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"_Ham_loc_trong_Excel_la_gi_ham_nay_dung_de_lam_gi\"><\/span><b>\u00a0H\u00e0m l\u1ecdc trong Excel l\u00e0 g\u00ec? h\u00e0m n\u00e0y d\u00f9ng \u0111\u1ec3 l\u00e0m g\u00ec?\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m l\u1ecdc hay c\u00f2n c\u00f3 t\u00ean g\u1ecdi kh\u00e1c l\u00e0 h\u00e0m Filter l\u00e0 h\u00e0m quen thu\u1ed9c v\u00e0 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u. H\u00e0m n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 l\u1ecdc c\u00e1c d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong b\u1ea3n t\u00ednh. H\u00e0m n\u00e0y s\u1ebd c\u00f3 c\u00fa ph\u00e1p c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><strong>=FILTER(array,include,if_empty)<\/strong><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3 c\u1ee5 th\u1ec3 c\u00e1c th\u00e0nh ph\u1ea7n trong c\u00fa ph\u00e1p n\u00e0y l\u00e0:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\"><strong>Array:<\/strong> Ch\u00ednh l\u00e0 v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n \u0111\u1ec3 l\u1ecdc.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\"><strong>Include:<\/strong> \u0110i\u1ec1u ki\u1ec7n \u0111\u1ec3 l\u1ecdc v\u00e0 c\u1ed9t d\u1eef li\u1ec7u c\u1ea7n l\u1ecdc.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\"><strong>If_empty:<\/strong> K\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 trong tr\u01b0\u1eddng h\u1ee3p kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n.<\/span><\/li>\n<\/ul>\n<p><iframe loading=\"lazy\" title=\"L\u1ecdc d\u1eef li\u1ec7u v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n v\u1edbi h\u00e0m Filter trong Excel\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/Woe-5bJ4uXE?start=165&#038;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;\">M\u1ed9t l\u01b0u \u00fd cho c\u00fa ph\u00e1p h\u00e0m l\u1ecdc n\u00e0y l\u00e0 c\u00fa ph\u00e1p n\u00e0y ch\u1ec9 hi\u1ec3n th\u1ecb tr\u00ean trang t\u00ednh c\u1ee7a phi\u00ean b\u1ea3n m\u00e1y t\u00ednh khi s\u1eed d\u1ee5ng Microsoft Excel 2019 v\u00e0 Excel 365. V\u1edbi c\u00e1c phi\u00ean b\u1ea3n Excel c\u0169 th\u00ec s\u1ebd kh\u00f4ng th\u1ec3 hi\u1ec7n \u0111\u01b0\u1ee3c h\u00e0m l\u1ecdc n\u00e0y.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m l\u1ecdc trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ea5t nhi\u1ec1u, m\u1ed9t s\u1ed1 \u1ee9ng d\u1ee5ng c\u00f3 th\u1ec3 k\u1ec3 \u0111\u1ebfn nh\u01b0:\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ecm ki\u1ebfm c\u00e1c d\u1eef li\u1ec7u gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">L\u1ecdc c\u00e1c d\u1eef li\u1ec7u v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n k\u1ebft h\u1ee3p v\u1edbi nhau.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng h\u00e0m l\u1ecdc \u0111\u1ec3 tr\u1ea3 v\u1ec1 \u0111\u1ea7y \u0111\u1ee7 d\u1eef li\u1ec7u nh\u01b0 d\u1eef li\u1ec7u g\u1ed1c.<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Vi_du_co_ban_ve_ham_loc_du_lieu_trong_Excel\"><\/span><b>V\u00ed d\u1ee5 c\u01a1 b\u1ea3n v\u1ec1 h\u00e0m l\u1ecdc d\u1eef li\u1ec7u trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 h\u00e0m n\u00e0y, sau \u0111\u00e2y Teky.edu.vn s\u1ebd \u0111\u01b0a ra m\u1ed9t v\u00ed d\u1ee5 c\u01a1 b\u1ea3n gi\u00fap b\u1ea1n \u0111\u1ecdc hi\u1ec3u h\u01a1n v\u1ec1 h\u00e0m n\u00e0y nh\u00e9. C\u00f9ng theo d\u00f5i v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 bi\u1ebft c\u00e1ch d\u00f9ng nh\u00e9.<\/span><\/p>\n<p style=\"text-align: justify;\"><b>V\u00ed d\u1ee5:<\/b><span style=\"font-weight: 400;\"> \u1ede \u0111\u00e2y Teky.edu.vn s\u1ebd l\u1ea5y v\u00ed d\u1ee5 g\u1ed3m m\u1ed9t danh s\u00e1ch c\u00f3 \u0111i\u1ec3m c\u00f9ng x\u1ebfp lo\u1ea1i c\u1ee7a c\u00e1c b\u1ea1n h\u1ecdc sinh trong l\u1edbp 9C. \u1ede \u0111\u00e2y s\u1ebd s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc \u0111\u1ec3 t\u00ecm t\u00ean c\u1ee7a c\u00e1c b\u1ea1n x\u1ebfp lo\u1ea1i gi\u1ecfi. C\u00e1ch th\u1ee9c th\u1ef1c hi\u1ec7n s\u1ebd c\u00f3 c\u00e1c b\u01b0\u1edbc c\u1ee5 th\u1ec3 nh\u01b0 sau:\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc \u0111\u1ea7u ti\u00ean:<\/b><span style=\"font-weight: 400;\"> B\u1ea1n s\u1ebd ti\u1ebfn h\u00e0nh ch\u1ecdn \u00f4 trong b\u1ea3ng d\u1eef li\u1ec7u sau \u0111\u00f3 s\u1ebd nh\u1eadp c\u00fa ph\u00e1p =FILTER(A1:D16,D1:D16=&#8221;gi\u1ecfi&#8221;). C\u1ee5 th\u1ec3 trong c\u00fa ph\u00e1p n\u00e0y l\u00e0:\u00a0<\/span><\/p>\n<figure id=\"attachment_12461\" aria-describedby=\"caption-attachment-12461\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12461 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/21.png\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t\" width=\"600\" height=\"357\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/21.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/21-400x238.png 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12461\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t<\/figcaption><\/figure>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">[A1:D16]: L\u00e0 v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n l\u1ecdc<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">[D1:D16= &#8220;gi\u1ecfi&#8221;]: L\u00e0 c\u1ed9t d\u1eef li\u1ec7u ch\u1ee9a \u0111i\u1ec1u ki\u1ec7n &#8220;gi\u1ecfi&#8221; c\u1ea7n l\u1ecdc.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc th\u1ee9 2:<\/b><span style=\"font-weight: 400;\"> Sau khi \u0111\u00e3 nh\u1eadp xong c\u00fa ph\u00e1p nh\u01b0 \u1edf b\u01b0\u1edbc 1 th\u00ec b\u1ea1n s\u1ebd nh\u1ea5n Enter v\u00e0 nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m Filter trong Excel. V\u00e0 k\u1ebft qu\u1ea3 sau khi b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi.<\/span><\/p>\n<figure id=\"attachment_12462\" aria-describedby=\"caption-attachment-12462\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12462 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-11.png\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-11.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-11-400x200.png 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12462\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cac_vi_du_cung_mot_so_loi_co_ban_khac_khi_su_dung_ham_loc_trong_Excel\"><\/span><b>C\u00e1c v\u00ed d\u1ee5 c\u00f9ng m\u1ed9t s\u1ed1 l\u1ed7i c\u01a1 b\u1ea3n kh\u00e1c khi s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Mot_so_vi_du_khac\"><\/span><b>M\u1ed9t s\u1ed1 v\u00ed d\u1ee5 kh\u00e1c<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u1ede m\u1ee5c 2, Teky.edu.vn \u0111\u00e3 n\u00eau ra m\u1ed9t v\u00ed d\u1ee5 \u0111\u1ec3 s\u1eed d\u1ee5ng <a href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-tao-lua-chon-trong-excel-don-gian-nhat\/\">h\u00e0m l\u1ecdc<\/a>. \u0110\u1ec3 m\u1ecdi ng\u01b0\u1eddi hi\u1ec3u th\u00eam th\u00ec sau \u0111\u00e2y Teky.edu.vn s\u1ebd \u0111\u01b0a th\u00eam 3 v\u00ed d\u1ee5 \u0111\u1ec3 m\u1ecdi ng\u01b0\u1eddi hi\u1ec3u h\u01a1n.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1ed9t l\u01b0u \u00fd l\u00e0 c\u00e1c v\u00ed d\u1ee5 n\u00e0y, Teky.edu.vn \u0111\u00e3 th\u1ef1c hi\u1ec7n trong phi\u00ean b\u1ea3n Microsoft Excel <a href=\"https:\/\/www.microsoft.com\/vi-vn\/microsoft-365\/excel\" rel=\"nofollow noreferrer\">365<\/a>.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Gi\u1ea3 s\u1eed b\u1ea1n l\u00e0 gi\u00e1o vi\u00ean ch\u1ee7 nhi\u1ec7m c\u1ee7a l\u1edbp 9C. B\u1ea1n c\u1ea7n l\u1ecdc d\u1eef li\u1ec7u c\u00e1c th\u00f4ng tin v\u00e0 \u0111i\u1ec3m, x\u1ebfp lo\u1ea1i c\u1ee7a t\u1eebng h\u1ecdc sinh trong l\u1edbp. B\u1ea3ng d\u1eef li\u1ec7u v\u1ec1 l\u1edbp s\u1ebd nh\u01b0 sau: <\/span><\/p>\n<figure id=\"attachment_12463\" aria-describedby=\"caption-attachment-12463\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12463 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-10.png\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc chi ti\u1ebft nh\u1ea5t\" width=\"600\" height=\"332\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-10.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-10-400x221.png 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12463\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc chi ti\u1ebft nh\u1ea5t<\/figcaption><\/figure>\n<h4 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Vi_du_1\"><\/span><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 1<\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"> B\u1ea1n c\u1ea7n l\u1ecdc c\u00e1c h\u1ecdc sinh N\u1eef trong l\u1edbp. B\u1ea1n s\u1ebd th\u1ef1c hi\u1ec7n c\u1ee5 th\u1ec3 nh\u01b0 sau:\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc \u0111\u1ea7u ti\u00ean:<\/b><span style=\"font-weight: 400;\"> B\u1ea1n s\u1ebd ch\u1ecdn m\u1ed9t \u00f4 b\u1ea5t k\u1ef3. Sau \u0111\u00f3 s\u1ebd nh\u1eadp c\u00fa ph\u00e1p =FILTER(A1:D16,B1:B16=&#8221;N\u1eef&#8221;) <\/span><\/p>\n<figure id=\"attachment_12464\" aria-describedby=\"caption-attachment-12464\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12464 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-8.png\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc chi ti\u1ebft nh\u1ea5t\" width=\"600\" height=\"318\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-8.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-8-400x212.png 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12464\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc chi ti\u1ebft nh\u1ea5t<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc th\u1ee9 2: <\/b><span style=\"font-weight: 400;\">Sau khi \u0111\u00e3 nh\u1eadp xong c\u00fa ph\u00e1p nh\u01b0 tr\u00ean th\u00ec b\u1ea1n nh\u1ea5n Enter. K\u1ebft qu\u1ea3 sau khi s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc tr\u00f9ng trong Excel s\u1ebd nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi. <\/span><\/p>\n<figure id=\"attachment_12465\" aria-describedby=\"caption-attachment-12465\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12465 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-8.png\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t\" width=\"600\" height=\"353\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-8.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-8-400x235.png 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12465\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t<\/figcaption><\/figure>\n<h4 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Vi_du_so_2\"><\/span><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 s\u1ed1 2<\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u00ean c\u1ea1nh vi\u1ec7c l\u1ecdc c\u00e1c b\u1ea1n N\u1eef, b\u1ea1n c\u00f3 th\u1ec3 c\u00f3 nhu c\u1ea7u l\u1ecdc ra c\u00e1c b\u1ea1n h\u1ecdc sinh c\u00f3 \u0111i\u1ec3m l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 9 \u0111i\u1ec3m. C\u00e1ch th\u1ee9c th\u1ef1c hi\u1ec7n s\u1ebd nh\u01b0 c\u00e1c b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y: <\/span><\/p>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc \u0111\u1ea7u ti\u00ean:<\/b><span style=\"font-weight: 400;\"> B\u1ea1n s\u1ebd ch\u1ecdn m\u1ed9t \u00f4 b\u1ea5t k\u1ef3 trong <a href=\"https:\/\/teky.edu.vn\/blog\/12049-2\/\">b\u1ea3ng t\u00ednh<\/a>. Sau \u0111\u00f3 b\u1ea1n s\u1ebd nh\u1eadp c\u00fa ph\u00e1p nh\u01b0 sau: =FILTER(A1:D16,C1:C16&gt;=9) <\/span><\/p>\n<figure id=\"attachment_12466\" aria-describedby=\"caption-attachment-12466\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12466 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-8.png\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t\" width=\"600\" height=\"373\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-8.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-8-400x249.png 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12466\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc th\u1ee9 2:<\/b><span style=\"font-weight: 400;\"> sau khi \u0111\u00e3 nh\u1eadp xong th\u00ec b\u1ea1n nh\u1ea5n Enter \u0111\u1ec3 hi\u1ec7n ra k\u1ebft qu\u1ea3.<\/span><\/p>\n<figure id=\"attachment_12467\" aria-describedby=\"caption-attachment-12467\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12467 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-4.png\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t\" width=\"600\" height=\"317\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-4.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-4-400x211.png 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12467\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 s\u1ed1 3: B\u1ea1n c\u1ea7n l\u1ecdc c\u00e1c h\u1ecdc sinh N\u1eef x\u1ebfp lo\u1ea1i h\u1ecdc l\u1ef1c gi\u1ecfi. C\u00e1ch th\u1ee9c th\u1ef1c hi\u1ec7n s\u1ebd nh\u01b0 sau: <\/span><\/p>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc \u0111\u1ea7u ti\u00ean: <\/b><span style=\"font-weight: 400;\">B\u1ea1n s\u1ebd ch\u1ecdn v\u00e0o \u00f4 b\u1ea5t k\u1ef3. Sau \u0111\u00f3 s\u1ebd nh\u1eadp c\u00fa ph\u00e1p =FILTER(A1:D16,(B1:B16=&#8221;N\u1eef&#8221;)*(D1:D16=&#8221;Gi\u1ecfi&#8221;)) nh\u01b0 h\u00ecnh. <\/span><\/p>\n<figure id=\"attachment_12468\" aria-describedby=\"caption-attachment-12468\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12468 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-2.png\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t\" width=\"600\" height=\"318\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-2.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-2-400x212.png 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12468\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc th\u1ee9 2:<\/b><span style=\"font-weight: 400;\"> Sau khi \u0111\u00e3 nh\u1eadp xong th\u00ec nh\u1ea5n Enter \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 \u0111\u00e3 l\u1ecdc. <\/span><\/p>\n<figure id=\"attachment_12469\" aria-describedby=\"caption-attachment-12469\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12469 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-2.png\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t\" width=\"600\" height=\"328\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-2.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-2-400x219.png 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12469\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t<\/figcaption><\/figure>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Mot_so_loi_thuong_gap_khi_su_dung_ham_loc_trong_Excel\"><\/span><b>M\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><b>L\u1ed7i #CALC!:<\/b><span style=\"font-weight: 400;\"> \u0110\u00e2y l\u00e0 l\u1ed7i ph\u1ed5 bi\u1ebfn. L\u1ed7i n\u00e0y s\u1ebd xu\u1ea5t hi\u1ec7n khi kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb n\u00e0o \u0111\u1ec3 th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n l\u1ecdc. C\u00e1ch kh\u1eafc ph\u1ee5c l\u00e0 b\u1ea1n c\u00f3 th\u1ec3 \u0111i\u1ec1n th\u00eam tham s\u1ed1 [If_empty]. <\/span><\/p>\n<figure id=\"attachment_12470\" aria-describedby=\"caption-attachment-12470\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12470 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/10-1.png\" alt=\"M\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel\" width=\"600\" height=\"359\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/10-1.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/10-1-400x239.png 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12470\" class=\"wp-caption-text\">M\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><b>L\u1ed7i #NA!, #VALUE!,&#8230; :<\/b><span style=\"font-weight: 400;\"> L\u1ed7i n\u00e0y s\u1ebd xu\u1ea5t hi\u1ec7n khi tham s\u1ed1 [Include] c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb l\u1ed7i ho\u1eb7c \u0111i\u1ec1u ki\u1ec7n kh\u00f4ng h\u1ee3p l\u00fd.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><b>L\u1ed7i #SPILL!<\/b><span style=\"font-weight: 400;\">: L\u1ed7i n\u00e0y s\u1ebd xu\u1ea5t hi\u1ec7n khi v\u00f9ng xu\u1ea5t k\u1ebft qu\u1ea3 c\u00f3 ch\u1ee9a l\u1eabn c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c. Khi \u0111\u00f3, b\u1ea1n s\u1ebd kh\u1eafc ph\u1ee5c b\u1eb1ng c\u00e1ch \u0111\u1ea3m b\u1ea3o kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb n\u00e0o kh\u00e1c n\u1eb1m l\u1eabn trong v\u00f9ng n\u00e0y.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y l\u00e0 nh\u1eefng chia s\u1ebb c\u1ee7a teky.edu.vn v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel. V\u1edbi nh\u1eefng chia s\u1ebb n\u00e0y \u0111\u00e3 gi\u00fap m\u1ecdi ng\u01b0\u1eddi s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng. V\u00e0 \u0111\u1ec3 bi\u1ebft th\u00eam c\u00e1c m\u1eb9o, th\u1ee7 thu\u1eadt c\u1ee7a tin h\u1ecdc. H\u00e3y truy c\u1eadp v\u00e0o website \u0111\u1ec3 bi\u1ebft c\u00e1ch th\u00f4ng tin b\u1ed5 \u00edch kh\u00e1c nh\u00e9.<\/span><\/p>\n<p><strong>Xem th\u00eam:<\/strong><\/p>\n<ul>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch l\u1ecdc trong excel \u0111\u1ed1i v\u1edbi c\u00e1c d\u1eef li\u1ec7u nhanh ch\u00f3ng v\u00e0 \u0111\u01a1n gi\u1ea3n<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel nhanh ch\u00f3ng m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/chuyen-anh-thanh-tranh-ve\/\" target=\"_blank\" rel=\"noopener\">Chuy\u1ec3n \u1ea3nh th\u00e0nh tranh v\u1ebd top \u1ee9ng d\u1ee5ng si\u00eau hot<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Khi s\u1eed d\u1ee5ng Excel ch\u1eafc ch\u1eafn m\u1ecdi ng\u01b0\u1eddi s\u1ebd \u00edt l\u1ea7n c\u1ea7n l\u1ecdc d\u1eef li\u1ec7u. Ch\u00ednh v\u00ec th\u1ebf h\u00e0m l\u1ecdc d\u1eef li\u1ec7u hay c\u00f2n c\u00f3 t\u00ean g\u1ecdi kh\u00e1c l\u00e0m h\u00e0m Filter \u0111\u00f3ng vai tr\u00f2 quan tr\u1ecdng. \u0110\u00e2y s\u1ebd l\u00e0 h\u00e0m gi\u00fap b\u1ea1n l\u1ecdc v\u00e0 tr\u1ea3 l\u1eddi c\u00e1c d\u1eef li\u1ec7u t\u1ee9c th\u00ec theo c\u00e1c \u0111i\u1ec1u ki\u1ec7n &hellip;<\/p>\n","protected":false},"author":3,"featured_media":12473,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-12460","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>H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t<\/title>\n<meta name=\"description\" content=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t, \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng. \u00c1p d\u1ee5ng cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n r\u1ea5t hi\u1ec7u qu\u1ea3.\" \/>\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\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t\" \/>\n<meta property=\"og:description\" content=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t, \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng. \u00c1p d\u1ee5ng cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n r\u1ea5t hi\u1ec7u qu\u1ea3.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/\" \/>\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-26T03:49:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-13T09:58:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-su-dung-ham-loc-trong-Excel-chi-tiet-nhat.png\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"8 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\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel H\u01b0\u1edbng d\u1eabn chi ti\u1ebft nh\u1ea5t\",\"datePublished\":\"2022-11-26T03:49:34+00:00\",\"dateModified\":\"2022-12-13T09:58:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/\"},\"wordCount\":1833,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-su-dung-ham-loc-trong-Excel-chi-tiet-nhat.png\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/\",\"name\":\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-su-dung-ham-loc-trong-Excel-chi-tiet-nhat.png\",\"datePublished\":\"2022-11-26T03:49:34+00:00\",\"dateModified\":\"2022-12-13T09:58:03+00:00\",\"description\":\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t, \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng. \u00c1p d\u1ee5ng cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n r\u1ea5t hi\u1ec7u qu\u1ea3.\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-su-dung-ham-loc-trong-Excel-chi-tiet-nhat.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-su-dung-ham-loc-trong-Excel-chi-tiet-nhat.png\",\"width\":600,\"height\":400,\"caption\":\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/#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 s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel H\u01b0\u1edbng d\u1eabn chi ti\u1ebft 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":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t","description":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t, \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng. \u00c1p d\u1ee5ng cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n r\u1ea5t hi\u1ec7u qu\u1ea3.","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\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t","og_description":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t, \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng. \u00c1p d\u1ee5ng cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n r\u1ea5t hi\u1ec7u qu\u1ea3.","og_url":"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/","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-26T03:49:34+00:00","article_modified_time":"2022-12-13T09:58:03+00:00","og_image":[{"width":600,"height":400,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-su-dung-ham-loc-trong-Excel-chi-tiet-nhat.png","type":"image\/png"}],"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":"8 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel H\u01b0\u1edbng d\u1eabn chi ti\u1ebft nh\u1ea5t","datePublished":"2022-11-26T03:49:34+00:00","dateModified":"2022-12-13T09:58:03+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/"},"wordCount":1833,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-su-dung-ham-loc-trong-Excel-chi-tiet-nhat.png","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/","url":"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/","name":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-su-dung-ham-loc-trong-Excel-chi-tiet-nhat.png","datePublished":"2022-11-26T03:49:34+00:00","dateModified":"2022-12-13T09:58:03+00:00","description":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t, \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng. \u00c1p d\u1ee5ng cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n r\u1ea5t hi\u1ec7u qu\u1ea3.","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-su-dung-ham-loc-trong-Excel-chi-tiet-nhat.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-su-dung-ham-loc-trong-Excel-chi-tiet-nhat.png","width":600,"height":400,"caption":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/#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 s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel H\u01b0\u1edbng d\u1eabn chi ti\u1ebft 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\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12460","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=12460"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12460\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/12473"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=12460"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=12460"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=12460"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}