{"id":1005,"date":"2020-09-11T22:25:20","date_gmt":"2020-09-11T15:25:20","guid":{"rendered":"https:\/\/hoctin.vn\/?p=1005"},"modified":"2020-10-18T13:49:41","modified_gmt":"2020-10-18T06:49:41","slug":"cach-loc-du-lieu-trong-excel","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/cach-loc-du-lieu-trong-excel\/","title":{"rendered":"C\u00e1ch L\u1ecdc D\u1eef Li\u1ec7u Trong Excel D\u1ec5 Hi\u1ec3u V\u00e0 C\u1ef1c K\u1ef3 \u0110\u01a1n Gi\u1ea3n V\u1edbi Filter"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1005\" class=\"elementor elementor-1005\">\n\t\t\t\t\t\t<div class=\"elementor-inner\">\n\t\t\t\t<div class=\"elementor-section-wrap\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-fdc9c6a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fdc9c6a\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-adb0774\" data-id=\"adb0774\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c995c93 elementor-widget elementor-widget-text-editor\" data-id=\"c995c93\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"color: #000000; font-family: Arial; font-size: 16px; white-space: pre-wrap;\">S\u1eafp x\u1ebfp v\u00e0 l\u1ecdc d\u1eef li\u1ec7u trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 gi\u00fap qu\u1ea3n l\u00fd d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3. B\u1ed9 l\u1ecdc gi\u00fap b\u1ea1n t\u00ecm ki\u1ebfm v\u00e0 l\u1ecdc d\u1eef li\u1ec7u, hi\u1ec3n th\u1ecb c\u00e1c d\u1eef li\u1ec7u \u0111\u00e1p \u1ee9ng c\u00e1c ti\u00eau ch\u00ed nh\u1ea5t \u0111\u1ecbnh.<\/span><\/p><p><span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; vertical-align: baseline; white-space: pre-wrap;\">Trong b\u00e0i vi\u1ebft n\u00e0y, hoctin.vn s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel<\/span>\u00a0<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; vertical-align: baseline; white-space: pre-wrap;\">theo s\u1ed1, v\u0103n b\u1ea3n, ng\u00e0y th\u00e1ng, m\u00e0u s\u1eafc, v\u00e0 c\u00e1ch thay \u0111\u1ed5i, x\u00f3a, ch\u1ec9nh s\u1eeda b\u1ed9 l\u1ecdc t\u1ef1 \u0111\u1ed9ng c\u1ee7a Excel m\u1ed9t c\u00e1ch d\u1ec5 hi\u1ec3u v\u00e0 chi ti\u1ebft nh\u1ea5t.<\/span><span style=\"color: #000000; font-family: Arial; font-size: 16px; white-space: pre-wrap;\"><br \/><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-02337d1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"02337d1\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-22cb4a1\" data-id=\"22cb4a1\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1c56fa7 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"1c56fa7\" data-element_type=\"widget\" data-settings=\"{&quot;exclude_headings_by_selector&quot;:[],&quot;marker_view&quot;:&quot;bullets&quot;,&quot;icon&quot;:{&quot;value&quot;:&quot;&quot;,&quot;library&quot;:&quot;&quot;},&quot;headings_by_tags&quot;:[&quot;h2&quot;,&quot;h3&quot;,&quot;h4&quot;,&quot;h5&quot;,&quot;h6&quot;],&quot;minimize_box&quot;:&quot;yes&quot;,&quot;minimized_on&quot;:&quot;tablet&quot;,&quot;hierarchical_view&quot;:&quot;yes&quot;,&quot;min_height&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"table-of-contents.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-toc__header\">\n\t\t\t<h4 class=\"elementor-toc__header-title\">M\u1ee5c L\u1ee5c B\u00e0i Vi\u1ebft<\/h4>\t\t\t\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--expand\"><i class=\"fas fa-chevron-down\"><\/i><\/div>\n\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--collapse\"><i class=\"fas fa-chevron-up\"><\/i><\/div>\n\t\t\t\t\t<\/div>\n\t\t<div class=\"elementor-toc__body\">\n\t\t\t<div class=\"elementor-toc__spinner-container\">\n\t\t\t\t<i class=\"elementor-toc__spinner eicon-loading eicon-animation-spin\" aria-hidden=\"true\"><\/i>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-940c29e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"940c29e\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c06f87f\" data-id=\"c06f87f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b77679c elementor-widget elementor-widget-heading\" data-id=\"b77679c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-435f7c88-7fff-8199-4615-67d837994bb9\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">1, B\u1ed9 L\u1ecdc Trong Excel- Filter L\u00e0 G\u00ec?<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-701a5a0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"701a5a0\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-347831e\" data-id=\"347831e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3818d4f elementor-widget elementor-widget-heading\" data-id=\"3818d4f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-95540f12-7fff-a880-7744-af4435868e09\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">1.1, Filter Trong Excel<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-92945d3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"92945d3\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-48881dc\" data-id=\"48881dc\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f179285 elementor-widget elementor-widget-text-editor\" data-id=\"f179285\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">B\u1ed9 l\u1ecdc l\u00e0 m\u1ed9t c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel nhanh g\u1ecdn \u0111\u1ec3 hi\u1ec3n th\u1ecb c\u00e1c th\u00f4ng tin th\u1ecfa m\u00e3n 1 ho\u1eb7c 1 s\u1ed1 \u0111i\u1ec1u ki\u1ec7n t\u1ea1i m\u1ed9t th\u1eddi \u0111i\u1ec3m nh\u1ea5t \u0111\u1ecbnh v\u00e0 t\u1ea1m \u1ea9n c\u00e1c d\u1eef li\u1ec7u kh\u00f4ng li\u00ean quan kh\u00e1c.<\/span><\/p><p>\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Nh\u1edd c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel b\u1eb1ng Filter, b\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb c\u00e1c h\u00e0ng trong trang t\u00ednh theo gi\u00e1 tr\u1ecb, \u0111\u1ecbnh d\u1ea1ng m\u00e0u s\u1eafc, ch\u1eefa c\u00e1c k\u00fd t\u1ef1 ch\u1ec9 \u0111\u1ecbnh hay b\u1eb1ng \u0111i\u1ec1u ki\u1ec7n ng\u00e0y th\u00e1ng, so s\u00e1nh logic v\u1edbi s\u1ed1.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">B\u1ed9 l\u1ecdc c\u0169ng gi\u00fap b\u1ea1n l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng nhau trong Excel, c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng nhau trong m\u1ed9t c\u1ed9t s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb sau khi s\u1eed d\u1ee5ng b\u1ed9 l\u1ecdc.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">Nh\u1edd ch\u1ee9c n\u0103ng Filter, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 sao ch\u00e9p, t\u00f9y \u00fd s\u1eed d\u1ee5ng ch\u1ec9 nh\u1eefng h\u00e0ng \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb m\u00e0 kh\u00f4ng ph\u1ea3i lo l\u1eafng \u0111\u1ebfn chuy\u1ec7n s\u1eafp x\u1ebfp l\u1ea1i to\u00e0n b\u1ed9 danh s\u00e1ch.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6ccfba5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6ccfba5\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fc1f0de\" data-id=\"fc1f0de\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f76054c elementor-widget elementor-widget-image\" data-id=\"f76054c\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/Cua-so-loc-filter-cach-loc-du-lieu-trong-excel.png\" title=\"Cua-so-loc-filter-cach-loc-du-lieu-trong-excel\" alt=\"C\u00e1ch filter trong excel- c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong excel\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7baa020 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7baa020\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-085c67a\" data-id=\"085c67a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4b4dac7 elementor-widget elementor-widget-heading\" data-id=\"4b4dac7\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">1.2, Sort: C\u00e1ch S\u1eafp X\u1ebfp D\u1eef Li\u1ec7u Trong Excel<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8073e60 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8073e60\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-dc309cf\" data-id=\"dc309cf\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a5c70bf elementor-widget elementor-widget-text-editor\" data-id=\"a5c70bf\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-64ce00c9-7fff-3eb8-9552-f77c30f84ea7\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Sort l\u00e0 m\u1ed9t t\u00ednh n\u0103ng c\u1ee7a b\u1ed9 l\u1ecdc gi\u00fap s\u1eafp x\u1ebfp d\u1eef li\u1ec7u: b\u1ea1n c\u00f3 th\u1ec3 s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n trong Excel, ho\u1eb7c gi\u1ea3m d\u1ea7n, ho\u1eb7c theo tr\u00ecnh t\u1ef1 th\u1eddi gian, theo th\u1ee9 t\u1ef1 b\u1ea3ng ch\u1eef c\u00e1i&#8230;<\/span><\/span><\/p><p><span id=\"docs-internal-guid-b12c85b0-7fff-5b9b-28e3-72d8c8e8f5e9\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">C\u00e1ch Sort trong Excel:<\/span><\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\"><br \/><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-74f0963 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"74f0963\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9047246\" data-id=\"9047246\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5e95177 elementor-widget elementor-widget-image\" data-id=\"5e95177\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/sort-du-lieu-cach-sap-xep-du-lieu-trong-Fitter-excel.png\" title=\"sort-du-lieu-cach-sap-xep-du-lieu-trong-Fitter-excel\" alt=\"C\u00e1ch S\u1eafp X\u1ebfp D\u1eef Li\u1ec7u Trong Excel\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-abdf2dc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"abdf2dc\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9d1d7b8\" data-id=\"9d1d7b8\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-21f1d0a elementor-widget elementor-widget-text-editor\" data-id=\"21f1d0a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">K\u1ebft qu\u1ea3 sau khi s\u1eafp x\u1ebfp doanh thu gi\u1ea3m d\u1ea7n (t\u1eeb cao \u0111\u1ebfn th\u1ea5p):<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7070033 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7070033\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1271874\" data-id=\"1271874\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5200246 elementor-widget elementor-widget-image\" data-id=\"5200246\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/ket-qua-sort-du-lieu-trong-excel.png\" title=\"ket-qua-sort-du-lieu-trong-excel\" alt=\"C\u00e1ch S\u1eafp X\u1ebfp D\u1eef Li\u1ec7u Trong Excel T\u1eeb Cao \u0110\u1ebfn Th\u1ea5p\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-728a86a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"728a86a\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bde4b2e\" data-id=\"bde4b2e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-246fb3d elementor-widget elementor-widget-heading\" data-id=\"246fb3d\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\"><h1 dir=\"ltr\" style=\"line-height:1.38;text-align: justify;margin-top:20pt;margin-bottom:6pt;\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2, C\u00e1ch T\u1ea1o B\u1ed9 L\u1ecdc Trong Excel<\/span><\/h1><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9d98540 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9d98540\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d669c8d\" data-id=\"d669c8d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-10652cb elementor-widget elementor-widget-heading\" data-id=\"10652cb\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-dc8b19f0-7fff-4e2a-08bb-b7e61b488d04\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2.1, C\u00e1ch T\u1ea1o Filter Trong Excel<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c9d41e1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c9d41e1\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3d6901c\" data-id=\"3d6901c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a9f562b elementor-widget elementor-widget-text-editor\" data-id=\"a9f562b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u00e1ch t\u1ea1o b\u1ed9 l\u1ecdc \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u trong Excel:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">&#8211; Ch\u1ecdn h\u00e0ng \u0111\u1ea7u ti\u00ean c\u1ee7a v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n l\u1ecdc:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-86f8182 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"86f8182\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1c8b566\" data-id=\"1c8b566\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d8b17c8 elementor-widget elementor-widget-image\" data-id=\"d8b17c8\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/Chon-hang-dau-tien-cua-bo-du-lieu-can-filter-cach-loc-du-lieu-trong-excel.png\" title=\"Chon-hang-dau-tien-cua-bo-du-lieu-can-filter-cach-loc-du-lieu-trong-excel\" alt=\"Ch\u1ecdn h\u00e0ng \u0111\u1ea7u ti\u00ean c\u1ee7a v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n l\u1ecdc \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u trong Excel\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2646c49 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2646c49\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7ab5c8b\" data-id=\"7ab5c8b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9ba9398 elementor-widget elementor-widget-text-editor\" data-id=\"9ba9398\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p>\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">&#8211; \u0110\u1ec3 s\u1eed d\u1ee5ng l\u1ec7nh filter trong Excel, tr\u00ean thanh Ribbon, ch\u1ecdn <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Data <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">&gt;&gt; <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Filter, <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">ho\u1eb7c s\u1eed d\u1ee5ng ph\u00edm t\u1eaft Filter l\u1ecdc d\u1eef li\u1ec7u: <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Ctrl + Shift + L<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-65bb4f0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"65bb4f0\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9e88d0c\" data-id=\"9e88d0c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e9f7b22 elementor-widget elementor-widget-image\" data-id=\"e9f7b22\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/Insert-Filter-cach-tao-filter-trong-1-o-excel-cach-loc-du-lieu-trong-excel.png\" title=\"Insert-Filter-cach-tao-filter-trong-1-o-excel-cach-loc-du-lieu-trong-excel\" alt=\"C\u00e1ch T\u1ea1o B\u1ed9 L\u1ecdc Trong Excel Insert Filter \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-aa653eb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"aa653eb\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-39e2808\" data-id=\"39e2808\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4f9bc3b elementor-widget elementor-widget-text-editor\" data-id=\"4f9bc3b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">K\u1ebft qu\u1ea3 sau khi t\u1ea1o b\u1ed9 l\u1ecdc trong Excel: m\u1ed7i \u00f4 \u1edf h\u00e0ng \u0111\u1ea7u ti\u00ean xu\u1ea5t hi\u1ec7n c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng m\u0169i t\u00ean x\u1ed5 xu\u1ed1ng <\/span><img loading=\"lazy\" style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap; margin-left: 0px; margin-top: 0px;\" src=\"https:\/\/lh6.googleusercontent.com\/6-GYo11DtYiLYY14QMw0Jn_lsQHwxpfB-eKIaBXgvNL0rkttq2vFtMvLcMaOCM_gKk-fd0LjGjEFze8ERJOfsqhvCDVT0EoImK5LEmjFA1IJkJuU_WsXHhtI9rFlRMcMiA4wWZk-\" width=\"17\" height=\"17\" \/><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1f53bad elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1f53bad\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0b5b92b\" data-id=\"0b5b92b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c51109a elementor-widget elementor-widget-image\" data-id=\"c51109a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/loc-Filter-cach-loc-du-lieu-trong-excel.png\" title=\"loc-Filter-cach-loc-du-lieu-trong-excel\" alt=\"K\u1ebft qu\u1ea3 sau khi t\u1ea1o b\u1ed9 l\u1ecdc trong Excel: m\u1ed7i \u00f4 \u1edf h\u00e0ng \u0111\u1ea7u ti\u00ean xu\u1ea5t hi\u1ec7n c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng m\u0169i t\u00ean x\u1ed5 xu\u1ed1ng\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-26c9daf elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"26c9daf\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-714b08f\" data-id=\"714b08f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2f07e4f elementor-widget elementor-widget-heading\" data-id=\"2f07e4f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-aed3fba4-7fff-300a-3412-cc22af978827\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2.2, C\u00e1ch T\u1ea1o C\u1ed9t L\u1ecdc D\u1eef Li\u1ec7u Trong Excel<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-519c718 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"519c718\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8150920\" data-id=\"8150920\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-61ece16 elementor-widget elementor-widget-text-editor\" data-id=\"61ece16\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">\u0110\u1ec3 t\u1ea1o filter trong 1 \u00f4 Excel, b\u1ea5m chu\u1ed9t ph\u1ea3i t\u1ea1i \u00f4 mu\u1ed1n l\u1ecdc, ch\u1ecdn Filter &gt;&gt; ch\u1ecdn lo\u1ea1i Filter mu\u1ed1n l\u1ecdc (theo gi\u00e1 tr\u1ecb\/ m\u00e0u\/ m\u00e0u ch\u1eef\/ Icon c\u1ee7a \u00f4 hi\u1ec7n t\u1ea1i).<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-bf5484b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bf5484b\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-92cf9c9\" data-id=\"92cf9c9\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9307df7 elementor-widget elementor-widget-image\" data-id=\"9307df7\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/Loc-theo-gia-tri-hoac-dinh-dang-cua-o-duoc-chon-loc-du-lieu-trong-excel.png\" title=\"Loc-theo-gia-tri-hoac-dinh-dang-cua-o-duoc-chon-loc-du-lieu-trong-excel\">&gt; ch\u1ecdn lo\u1ea1i Filter mu\u1ed1n l\u1ecdc\" \/&gt;\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b706024 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b706024\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9bf59a3\" data-id=\"9bf59a3\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d48391f elementor-widget elementor-widget-text-editor\" data-id=\"d48391f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p>\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Tuy nhi\u00ean c\u00e1ch n\u00e0y ch\u1ec9 \u00e1p d\u1ee5ng \u0111\u01b0\u1ee3c khi b\u1ea1n \u0111\u00e3 t\u00ecm th\u1ea5y \u00f4 c\u1ea7n l\u1ecdc trong danh s\u00e1ch v\u00e0 kh\u00f4ng l\u1ecdc \u0111\u01b0\u1ee3c nhi\u1ec1u gi\u00e1 tr\u1ecb c\u00f9ng<\/span> <span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">l\u00fac.<\/span><\/p><p><br \/><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel hay \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u1ea5t <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">l\u00e0: ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng m\u0169i t\u00ean h\u01b0\u1edbng xu\u1ed1ng <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\"><span style=\"border-width: initial; border-style: none; display: inline-block; overflow: hidden; width: 17px; height: 17px;\"><img loading=\"lazy\" style=\"margin-left: 0px; margin-top: 0px;\" src=\"https:\/\/lh6.googleusercontent.com\/6-GYo11DtYiLYY14QMw0Jn_lsQHwxpfB-eKIaBXgvNL0rkttq2vFtMvLcMaOCM_gKk-fd0LjGjEFze8ERJOfsqhvCDVT0EoImK5LEmjFA1IJkJuU_WsXHhtI9rFlRMcMiA4wWZk-\" width=\"17\" height=\"17\" \/><\/span><\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\"> g\u00f3c b\u00ean ph\u1ea3i \u00f4 ti\u00eau \u0111\u1ec1 c\u1ee7a c\u1ed9t, m\u1ed9t h\u1ed9p tho\u1ea1i hi\u1ec7n ra:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6efad04 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6efad04\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-82d0007\" data-id=\"82d0007\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6fcdc70 elementor-widget elementor-widget-image\" data-id=\"6fcdc70\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/Cach-filter-du-lieu-cach-loc-du-lieu-trong-excel.png\" title=\"Cach-filter-du-lieu-cach-loc-du-lieu-trong-excel\" alt=\"C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel hay \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u1ea5t\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d7fa20c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d7fa20c\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d221576\" data-id=\"d221576\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-954d4d2 elementor-widget elementor-widget-text-editor\" data-id=\"954d4d2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">B\u1ecf ch\u1ecdn Select All \u0111\u1ec3 b\u1ecf ch\u1ecdn t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 tick c\u00e1c \u00f4 d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb &gt;&gt; OK.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">B\u1ea1n c\u00f3 th\u1ec3 tick v\u00e0o c\u00e1c \u00f4 \u0111\u1ec3 ch\u1ecdn\/ b\u1ecf ch\u1ecdn d\u1eef li\u1ec7u.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, hoctin.vn ch\u1ecdn hi\u1ec3n th\u1ecb to\u00e0n b\u1ed9 d\u1eef li\u1ec7u tr\u1eeb \u00c1o thun, b\u1eb1ng c\u00e1ch tick v\u00e0o \u00f4 \u00c1o thun \u0111\u1ec3 b\u1ecf ch\u1ecdn. C\u00e1c d\u00f2ng b\u1ecb \u1ea9n do kh\u00f4ng ch\u1ee9a d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c l\u1ecdc:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d7c2c72 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d7c2c72\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-930ea9a\" data-id=\"930ea9a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-beca55f elementor-widget elementor-widget-image\" data-id=\"beca55f\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/ket-qua-sau-khi-loc-du-lieu-trong-excel.png\" title=\"ket-qua-sau-khi-loc-du-lieu-trong-excel\" alt=\"C\u00e1ch T\u1ea1o C\u1ed9t L\u1ecdc D\u1eef Li\u1ec7u Trong Excel B\u1eb1ng Filter\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4cf00c3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4cf00c3\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-15d1504\" data-id=\"15d1504\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-67e9ca7 elementor-widget elementor-widget-heading\" data-id=\"67e9ca7\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-d14138aa-7fff-f625-6e61-1097f766098a\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2.3, C\u00e1ch L\u1ecdc Danh S\u00e1ch Trong Excel Th\u1ecfa M\u00e3n \u0110i\u1ec1u Ki\u1ec7n T\u1ea1i Nhi\u1ec1u C\u1ed9t<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-34cf3c8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"34cf3c8\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-780b465\" data-id=\"780b465\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c8d69b0 elementor-widget elementor-widget-text-editor\" data-id=\"c8d69b0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u0110\u1ec3 ghi nh\u1edb c\u00e1ch l\u1ecdc trong Excel d\u1ec5 d\u00e0ng, ch\u1ec9 c\u1ea7n quan s\u00e1t h\u00e0ng ti\u00eau \u0111\u1ec1, c\u1ed9t n\u00e0o \u0111ang \u0111\u01b0\u1ee3c l\u1ecdc s\u1ebd c\u00f3 bi\u1ec3u t\u01b0\u1ee3ng Filter <\/span><img loading=\"lazy\" style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap; margin-left: 0px; margin-top: 0px;\" src=\"https:\/\/lh4.googleusercontent.com\/RDvdxcgP0CxIP__c2qxVn_8KO7QiGTvZoSG9S7xWghmg1fYcgfRfH__uy2qCiy-ybUCPrwpBRG95rgF8b4eAwPBbXUvgrAp5to0gIyI4Qm1wr-Egx1ewDRO-ENt5ndYtyw_Q84cg\" width=\"17\" height=\"17\" \/>.<\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">N\u1ebfu b\u1ea1n kh\u00f4ng b\u1ecf l\u1ecdc c\u1ed9t \u0111\u00f3 m\u00e0 v\u1eabn ti\u1ebfp t\u1ee5c l\u1ecdc c\u00e1c c\u1ed9t kh\u00e1c, th\u00ec d\u1eef li\u1ec7u hi\u1ec3n th\u1ecb l\u00e0 d\u1eef li\u1ec7u th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n l\u1ecdc t\u1ea1i t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t theo ph\u00e9p to\u00e1n logic AND.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">V\u00ed d\u1ee5: \u0110\u1ec3 l\u1ecdc c\u00e1c d\u00f2ng ch\u1ee9a s\u1ea3n ph\u1ea9m \u00c1o kho\u00e1c v\u00e0 \u00c1o s\u01a1 mi b\u00e1n t\u1ea1i Mi\u1ec1n B\u1eafc, c\u1ea7n filter c\u1ea3 2 c\u1ed9t B v\u00e0 C:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6c3ed09 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6c3ed09\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a0b95b6\" data-id=\"a0b95b6\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-93bfdab elementor-widget elementor-widget-image\" data-id=\"93bfdab\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/Cach-loc-nhieu-cot-cach-loc-du-lieu-trong-excel.png\" title=\"Cach-loc-nhieu-cot-cach-loc-du-lieu-trong-excel\" alt=\"C\u00e1ch L\u1ecdc Danh S\u00e1ch Trong Excel Th\u1ecfa M\u00e3n \u0110i\u1ec1u Ki\u1ec7n T\u1ea1i Nhi\u1ec1u C\u1ed9t\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5381a75 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5381a75\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4608d92\" data-id=\"4608d92\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6221c8e elementor-widget elementor-widget-text-editor\" data-id=\"6221c8e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-b5958822-7fff-c269-9601-a91d2386ee51\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">N\u00fat l\u1ecdc hi\u1ec3n th\u1ecb \u1edf c\u1ea3 2 \u00f4 ti\u00eau \u0111\u1ec1 c\u1ee7a c\u1ed9t B v\u00e0 C. C\u00e1c d\u00f2ng hi\u1ec3n th\u1ecb \u0111\u1ec1u th\u1ecfa m\u00e3n gi\u00e1 tr\u1ecb t\u1ea1i c\u1ed9t B l\u00e0 Mi\u1ec1n B\u1eafc, gi\u00e1 tr\u1ecb t\u1ea1i c\u1ed9t C l\u00e0 \u00c1o kho\u00e1c ho\u1eb7c \u00c1o S\u01a1 Mi. C\u00f3 th\u1ec3 th\u1ea5y b\u1ed9 l\u1ecdc d\u1eef li\u1ec7u trong Excel kh\u00f4ng ph\u00e2n bi\u1ec7t vi\u1ebft hoa vi\u1ebft th\u01b0\u1eddng:<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-797aa6b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"797aa6b\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d980178\" data-id=\"d980178\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-696fef9 elementor-widget elementor-widget-image\" data-id=\"696fef9\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/ket-qua-sau-khi-loc-du-lieu-trong-excel-loc-nhieu-cot.png\" title=\"ket-qua-sau-khi-loc-du-lieu-trong-excel-loc-nhieu-cot\" alt=\"C\u00e1ch L\u1ecdc Danh S\u00e1ch Trong Excel Th\u1ecfa M\u00e3n \u0110i\u1ec1u Ki\u1ec7n T\u1ea1i Nhi\u1ec1u C\u1ed9t L\u1ecdc D\u1eef Li\u1ec7u Trong Excel\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-331f9cf elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"331f9cf\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6faf27c\" data-id=\"6faf27c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c59de42 elementor-widget elementor-widget-text-editor\" data-id=\"c59de42\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-5c2794f5-7fff-8e29-1ad2-cffe8ba18b65\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">L\u01b0u \u00fd: <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Khi c\u1ed9t d\u1eef li\u1ec7u c\u00f3 qu\u00e1 nhi\u1ec1u gi\u00e1 tr\u1ecb khi\u1ebfn h\u1ed9p Filter kh\u00f4ng th\u1ec3 hi\u1ec3n th\u1ecb h\u1ebft d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 k\u00e9o m\u0169i t\u00ean hai chi\u1ec1u \u1edf g\u00f3c c\u1eeda s\u1ed5 b\u1ed9 l\u1ecdc Filter \u0111\u1ec3 thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc.<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-cfcbb8c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cfcbb8c\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-933f6b3\" data-id=\"933f6b3\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a8e4e5e elementor-widget elementor-widget-image\" data-id=\"a8e4e5e\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/Mo-rong-cua-so-loc-cach-loc-du-lieu-trong-excel.png\" title=\"Mo-rong-cua-so-loc-cach-loc-du-lieu-trong-excel\" alt=\"C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong excel: Khi c\u1ed9t d\u1eef li\u1ec7u c\u00f3 qu\u00e1 nhi\u1ec1u gi\u00e1 tr\u1ecb khi\u1ebfn h\u1ed9p Filter kh\u00f4ng th\u1ec3 hi\u1ec3n th\u1ecb h\u1ebft d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 k\u00e9o m\u0169i t\u00ean hai chi\u1ec1u \u1edf g\u00f3c c\u1eeda s\u1ed5 b\u1ed9 l\u1ecdc Filter \u0111\u1ec3 thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8438143 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8438143\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5b76855\" data-id=\"5b76855\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-52ab271 elementor-widget elementor-widget-heading\" data-id=\"52ab271\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-5ffb0dc6-7fff-d7eb-9db9-59bcdf4df50f\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2.4, C\u00e1ch X\u00f3a B\u1ed9 L\u1ecdc\/ Clear Filter Trong Excel<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2102740 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2102740\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-387a243\" data-id=\"387a243\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d262d39 elementor-widget elementor-widget-text-editor\" data-id=\"d262d39\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u00f3 bao gi\u1edd b\u1ea1n th\u1eafc m\u1eafc t\u1ea1i sao d\u00f2ng b\u1ecb \u1ea9n kh\u00f4ng th\u1ec3 unhide \u0111\u01b0\u1ee3c kh\u00f4ng? Nguy\u00ean nh\u00e2n hay g\u1eb7p nh\u1ea5t l\u00e0 do file \u0111\u00e3 \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng Filter, n\u1ebfu b\u1ea1n kh\u00f4ng x\u00f3a b\u1ed9 l\u1ecdc th\u00ec kh\u00f4ng th\u1ec3 hi\u1ec7n c\u00e1c d\u00f2ng \u0111\u00e3 b\u1ecb \u1ea9n trong Excel \u0111\u01b0\u1ee3c.<\/span><\/p><p><br \/><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">\u0110\u1ec3 x\u00f3a b\u1ed9 l\u1ecdc cho 1 c\u1ed9t<\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">, ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng m\u0169i t\u00ean h\u01b0\u1edbng xu\u1ed1ng <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\"><span style=\"border-width: initial; border-style: none; display: inline-block; overflow: hidden; width: 17px; height: 17px;\"><img loading=\"lazy\" style=\"margin-left: 0px; margin-top: 0px;\" src=\"https:\/\/lh6.googleusercontent.com\/6-GYo11DtYiLYY14QMw0Jn_lsQHwxpfB-eKIaBXgvNL0rkttq2vFtMvLcMaOCM_gKk-fd0LjGjEFze8ERJOfsqhvCDVT0EoImK5LEmjFA1IJkJuU_WsXHhtI9rFlRMcMiA4wWZk-\" width=\"17\" height=\"17\" \/><\/span><\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\"> &gt;&gt; <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Clear Filter.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d4b0b87 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d4b0b87\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-cfd8a79\" data-id=\"cfd8a79\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a33fa97 elementor-widget elementor-widget-image\" data-id=\"a33fa97\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/Bo-loc-1-cot-Filter-tra-ve-trang-thai-truoc-khi-filter-cach-loc-du-lieu-trong-excel.png\" title=\"Bo-loc-1-cot-Filter-tra-ve-trang-thai-truoc-khi-filter-cach-loc-du-lieu-trong-excel\" alt=\"Sau khi l\u1ecdc d\u1eef li\u1ec7u trong excel xong, \u0111\u1ec3 x\u00f3a b\u1ed9 l\u1ecdc cho 1 c\u1ed9t, ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng m\u0169i t\u00ean h\u01b0\u1edbng xu\u1ed1ng ch\u1ecdn Clear Filter\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-985e69b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"985e69b\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-26a66ad\" data-id=\"26a66ad\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e37584b elementor-widget elementor-widget-text-editor\" data-id=\"e37584b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">\u0110\u1ec3 x\u00f3a nhanh b\u1ed9 l\u1ecdc cho to\u00e0n b\u1ed9 b\u1ea3ng d\u1eef li\u1ec7u<\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">: ch\u1ecdn <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Data <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">&gt;&gt; <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Clear<\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\"> trong m\u1ee5c Sort &amp; Filter ho\u1eb7c s\u1eed d\u1ee5ng <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">ph\u00edm t\u1eaft Alt + A + C.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-fbe0847 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fbe0847\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5767609\" data-id=\"5767609\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-398a572 elementor-widget elementor-widget-image\" data-id=\"398a572\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/Clear-Bo-loc-Filter-de-ngung-loc-du-lieu-trong-excel.png\" title=\"Clear-Bo-loc-Filter-de-ngung-loc-du-lieu-trong-excel\" alt=\"Sau khi l\u1ecdc d\u1eef li\u1ec7u trong excel, \u0111\u1ec3 x\u00f3a nhanh b\u1ed9 l\u1ecdc cho to\u00e0n b\u1ed9 b\u1ea3ng d\u1eef li\u1ec7u: ch\u1ecdn Data ch\u1ecdn Clear trong m\u1ee5c Sort &amp; Filter ho\u1eb7c s\u1eed d\u1ee5ng ph\u00edm t\u1eaft Alt + A + C\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-89328b5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"89328b5\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ea970fc\" data-id=\"ea970fc\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-71cf3a2 elementor-widget elementor-widget-heading\" data-id=\"71cf3a2\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><br><br><span style=\"font-weight:normal;\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2.5, C\u1eadp Nh\u1eadt B\u1ed9 L\u1ecdc Sau Khi Thay \u0110\u1ed5i D\u1eef Li\u1ec7u B\u1eb1ng Reapply<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4aaf42f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4aaf42f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8f9b3e2\" data-id=\"8f9b3e2\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-542fd72 elementor-widget elementor-widget-text-editor\" data-id=\"542fd72\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">B\u1ed9 l\u1ecdc kh\u00f4ng t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt n\u1ebfu ng\u01b0\u1eddi d\u00f9ng ch\u1ec9nh s\u1eeda\/ x\u00f3a d\u1eef li\u1ec7u. \u0110\u1ec3 c\u1eadp nh\u1eadt data s\u1eed d\u1ee5ng \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u trong Excel, ch\u1ecdn 1 \u00f4 b\u1ea5t k\u1ef3 trong b\u1ea3ng, ch\u1ecdn <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Data <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">&gt;&gt; <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Reapply<\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-93c4629 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"93c4629\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2e772dd\" data-id=\"2e772dd\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6519cdb elementor-widget elementor-widget-image\" data-id=\"6519cdb\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/Reapply-Filter-de-cap-nhat-du-lieu-loc-du-lieu-trong-excel.png\" title=\"Reapply-Filter-de-cap-nhat-du-lieu-loc-du-lieu-trong-excel\" alt=\"c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong excel: C\u1eadp Nh\u1eadt B\u1ed9 L\u1ecdc Filter Sau Khi Thay \u0110\u1ed5i D\u1eef Li\u1ec7u B\u1eb1ng Reapply\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-38d81be elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"38d81be\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-195f836\" data-id=\"195f836\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-79e7ccb elementor-widget elementor-widget-heading\" data-id=\"79e7ccb\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-aafd868c-7fff-98a9-1ab3-c144a3af5473\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2.6, C\u00e1ch Copy Trong Excel B\u1ecf Qua C\u00e1c C\u1ed9t V\u00e0 D\u00f2ng \u1ea8n<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-86cabfc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"86cabfc\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-53c2ad5\" data-id=\"53c2ad5\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5835cd1 elementor-widget elementor-widget-text-editor\" data-id=\"5835cd1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u00e1ch sao ch\u00e9p d\u1eef li\u1ec7u \u0111\u00e3 l\u1ecdc \u0111\u01a1n gi\u1ea3n l\u00e0 ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n copy, s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm Ctrl + C \u0111\u1ec3 sao ch\u00e9p v\u00e0 Ctrl + V \u0111\u1ec3 d\u00e1n d\u1eef li\u1ec7u v\u00e0o v\u00f9ng b\u1ea3ng t\u00ednh m\u1edbi.<\/span><\/p><p><br \/><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">R\u1ea5t \u00edt tr\u01b0\u1eddng h\u1ee3p g\u1eb7p l\u1ed7i Excel sao ch\u00e9p c\u1ea3 c\u00e1c h\u00e0ng b\u1ecb \u1ea9n. \u0110\u1ec3 s\u1eeda l\u1ed7i n\u00e0y, \u1ea5n <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">F5 <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">&gt;&gt; <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Go To Special<\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\"> &gt;&gt; <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Visible Cells only<\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">. Hoctin.vn \u0111\u00e3 c\u00f3 b\u00e0i vi\u1ebft c\u00e1c c\u00e1ch copy trong excel h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1c l\u1ed7i v\u00e0 c\u00e1ch s\u1eeda &#8211; bao g\u1ed3m c\u1ea3 tr\u01b0\u1eddng h\u1ee3p l\u1ed7i copy khi Filter.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-888d630 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"888d630\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-53e0810\" data-id=\"53e0810\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b31d76d elementor-widget elementor-widget-heading\" data-id=\"b31d76d\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-ed55c91a-7fff-4f0c-3b23-0b671c03a4de\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">3, C\u00e1ch Filter V\u1edbi C\u00e1c Lo\u1ea1i D\u1eef Li\u1ec7u Kh\u00e1c Nhau<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ce17b65 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ce17b65\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-29518ea\" data-id=\"29518ea\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-84d16cc elementor-widget elementor-widget-text-editor\" data-id=\"84d16cc\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">C\u1eeda s\u1ed5 Filter ph\u00e2n c\u00e1c khu v\u1ef1c kh\u00e1c nhau cho c\u00e1c lo\u1ea1i d\u1eef li\u1ec7u: S\u1ed1 (Number), V\u0103n b\u1ea3n (Text), M\u00e0u (Color), Ng\u00e0y th\u00e1ng (Date).<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7c7d2da elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7c7d2da\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-55f5ad5\" data-id=\"55f5ad5\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4ac4a2c elementor-widget elementor-widget-heading\" data-id=\"4ac4a2c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-704d7330-7fff-c485-9ba3-f1447ac26c19\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">3.1, C\u00e1ch L\u1ecdc D\u1eef Li\u1ec7u Trong Excel V\u1edbi D\u1eef Li\u1ec7u D\u1ea1ng S\u1ed1<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b7d8375 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b7d8375\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5fc0214\" data-id=\"5fc0214\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-959418f elementor-widget elementor-widget-text-editor\" data-id=\"959418f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u0110\u1ec3 l\u1ecdc d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1, ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng m\u0169i t\u00ean h\u01b0\u1edbng xu\u1ed1ng <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"><span style=\"border: none; display: inline-block; overflow: hidden; width: 17px; height: 17px;\"><img loading=\"lazy\" style=\"margin-left: 0px; margin-top: 0px;\" src=\"https:\/\/lh6.googleusercontent.com\/6-GYo11DtYiLYY14QMw0Jn_lsQHwxpfB-eKIaBXgvNL0rkttq2vFtMvLcMaOCM_gKk-fd0LjGjEFze8ERJOfsqhvCDVT0EoImK5LEmjFA1IJkJuU_WsXHhtI9rFlRMcMiA4wWZk-\" width=\"17\" height=\"17\" \/><\/span><\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> g\u00f3c b\u00ean ph\u1ea3i \u00f4 ti\u00eau \u0111\u1ec1 c\u1ee7a c\u1ed9t, m\u1ed9t h\u1ed9p tho\u1ea1i hi\u1ec7n ra &gt;&gt; ch\u1ecdn Number Filters.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">C\u00e1c t\u00f9y ch\u1ecdn so s\u00e1nh (b\u1eb1ng, kh\u00f4ng b\u1eb1ng, l\u1edbn h\u01a1n, l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng, nh\u1ecf h\u01a1n, nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng, trong kho\u1ea3ng, top 10, tr\u00ean trung b\u00ecnh, d\u01b0\u1edbi trung b\u00ecnh) v\u00e0 c\u1ea3 t\u00f9y ch\u1ecdn l\u1ecdc (Custom Filter) hi\u1ec7n l\u00ean:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-62b6035 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"62b6035\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-31ebcd8\" data-id=\"31ebcd8\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c840b33 elementor-widget elementor-widget-image\" data-id=\"c840b33\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/Number-Filter-cach-loc-du-lieu-trong-excel.png\" title=\"Number-Filter-cach-loc-du-lieu-trong-excel\" alt=\"C\u00e1ch L\u1ecdc D\u1eef Li\u1ec7u Trong Excel V\u1edbi D\u1eef Li\u1ec7u D\u1ea1ng S\u1ed1\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-bf707fa elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bf707fa\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7b00669\" data-id=\"7b00669\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1f44a9b elementor-widget elementor-widget-text-editor\" data-id=\"1f44a9b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">B\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn l\u1ecdc d\u1eef li\u1ec7u trong Excel c\u00f3 \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng Custom Filter ho\u1eb7c b\u1eb1ng b\u1ea5t k\u1ef3 m\u1ed9t ph\u00e9p so s\u00e1nh n\u00e0o theo \u00fd mu\u1ed1n c\u1ee7a m\u00ecnh, h\u1ed9p tho\u1ea1i Custom AutoFilter lu\u00f4n hi\u1ec7n l\u00ean:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e0170b0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e0170b0\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6afcd32\" data-id=\"6afcd32\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8b6dec0 elementor-widget elementor-widget-image\" data-id=\"8b6dec0\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/custom-autofilter-vi-du-loc-cac-so-numbers-loc-du-lieu-trong-excel.png\" title=\"custom-autofilter-vi-du-loc-cac-so-numbers-loc-du-lieu-trong-excel\" alt=\"C\u00e1ch L\u1ecdc D\u1eef Li\u1ec7u Trong Excel V\u1edbi D\u1eef Li\u1ec7u D\u1ea1ng S\u1ed1 B\u1eb1ng Custom Filter\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5a79a18 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5a79a18\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2d0b397\" data-id=\"2d0b397\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-972ab7c elementor-widget elementor-widget-text-editor\" data-id=\"972ab7c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">B\u1eb1ng h\u1ed9p tho\u1ea1i n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam m\u1ed9t \u0111i\u1ec1u ki\u1ec7n kh\u00e1c (n\u1ebfu mu\u1ed1n). B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng th\u00eam \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng c\u00e1ch k\u1ebft h\u1ee3p (AND), ho\u1eb7c ch\u1ecdn 1 trong 2 \u0111i\u1ec1u ki\u1ec7n (OR).\\\\<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">Nh\u01b0 v\u00ed d\u1ee5 tr\u00ean, hoctin.vn \u0111ang \u0111\u1eb7t \u0111i\u1ec1u ki\u1ec7n l\u1ecdc d\u1eef li\u1ec7u l\u00e0 c\u00e1c s\u1ed1 l\u1edbn h\u01a1n 10000 nh\u01b0ng kh\u00f4ng b\u1eb1ng 20000 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng to\u00e1n t\u1eed And n\u1ed1i 2 \u0111i\u1ec1u ki\u1ec7n.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9312ae7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9312ae7\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-58f3796\" data-id=\"58f3796\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c7beae1 elementor-widget elementor-widget-heading\" data-id=\"c7beae1\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-0438cf09-7fff-c92e-5ebe-9a2f5673d8ad\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">3.2, C\u00e1ch L\u1ecdc D\u1eef Li\u1ec7u Trong Excel V\u1edbi D\u1eef Li\u1ec7u D\u1ea1ng V\u0103n B\u1ea3n<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e6b4d8f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e6b4d8f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0714f44\" data-id=\"0714f44\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-51d60b6 elementor-widget elementor-widget-text-editor\" data-id=\"51d60b6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-6e04fcdb-7fff-e893-41cd-756c8b82ea8d\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">T\u01b0\u01a1ng t\u1ef1, \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u d\u1ea1ng v\u0103n b\u1ea3n, ch\u1ecdn Text Filters, c\u00e1c t\u00f9y ch\u1ecdn v\u1edbi d\u1eef li\u1ec7u ki\u1ec3u v\u0103n b\u1ea3n (b\u1eb1ng, kh\u00f4ng b\u1eb1ng, b\u1eaft \u0111\u1ea7u b\u1edfi, c\u00f3 ch\u1ee9a, kh\u00f4ng ch\u1ee9a m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 ch\u1ec9 \u0111\u1ecbnh) v\u00e0 c\u1ea3 t\u00f9y ch\u1ecdn l\u1ecdc (Custom Filter) hi\u1ec7n l\u00ean:<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-32a27fa elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"32a27fa\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5bcb216\" data-id=\"5bcb216\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-66bb081 elementor-widget elementor-widget-image\" data-id=\"66bb081\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/loc-ky-tu-trong-Filter.png\" title=\"loc-ky-tu-trong-Filter\" alt=\"C\u00e1ch L\u1ecdc D\u1eef Li\u1ec7u Trong Excel V\u1edbi D\u1eef Li\u1ec7u D\u1ea1ng V\u0103n B\u1ea3n\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-97b8440 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"97b8440\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-cb9f29f\" data-id=\"cb9f29f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-05f03ab elementor-widget elementor-widget-text-editor\" data-id=\"05f03ab\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-4ceb1b84-7fff-d874-d3a1-2aefa32596fe\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">\u00c1p d\u1ee5ng m\u1ed9t \u0111i\u1ec1u ki\u1ec7n b\u1ea5t k\u1ef3, h\u1ed9p tho\u1ea1i Custom AutoFilter lu\u00f4n hi\u1ec7n l\u00ean. \u1ede v\u00ed d\u1ee5 sau, hoctin.vn s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel \u0111\u1ec3 l\u1ecdc c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n l\u00e0 t\u00ean c\u1ee7a S\u1ea3n ph\u1ea9m c\u00f3 ch\u1ee9a t\u1eeb \u201c\u00e1o\u201d v\u00e0 k\u1ebft th\u00fac b\u1edfi c\u1ee5m \u201cM1\u201d:<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-95a2e63 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"95a2e63\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-817357b\" data-id=\"817357b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-462718a elementor-widget elementor-widget-image\" data-id=\"462718a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/Loc-cot-nhieu-dieu-kien-Filter-trong-excel.png\" title=\"Loc-cot-nhieu-dieu-kien-Filter-trong-excel\" alt=\"C\u00e1ch L\u1ecdc D\u1eef Li\u1ec7u Trong Excel V\u1edbi D\u1eef Li\u1ec7u D\u1ea1ng V\u0103n B\u1ea3n V\u1edbi Custom Filter\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d4d43e8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d4d43e8\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b9dfb9c\" data-id=\"b9dfb9c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-92c7bff elementor-widget elementor-widget-text-editor\" data-id=\"92c7bff\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">K\u1ebft qu\u1ea3 l\u1ecdc d\u1eef li\u1ec7u trong Excel nh\u01b0 sau:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c422860 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c422860\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e42f43a\" data-id=\"e42f43a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-173cc26 elementor-widget elementor-widget-image\" data-id=\"173cc26\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/Ket-qua-custom-autofilter-loc-du-lieu-trong-excel.png\" title=\"Ket-qua-custom-autofilter-loc-du-lieu-trong-excel\" alt=\"K\u1ebft qu\u1ea3 L\u1ecdc D\u1eef Li\u1ec7u Trong Excel V\u1edbi D\u1eef Li\u1ec7u D\u1ea1ng V\u0103n B\u1ea3n\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e45d8d2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e45d8d2\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6986610\" data-id=\"6986610\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0f01a90 elementor-widget elementor-widget-heading\" data-id=\"0f01a90\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-6f4877a8-7fff-5ba4-de6c-f47bb1fe0a9e\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">3.3, C\u00e1ch L\u1ecdc D\u1eef Li\u1ec7u Trong Excel - L\u1ecdc \u00d4 Tr\u1ed1ng (Blank)<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c5a3c14 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c5a3c14\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d35c443\" data-id=\"d35c443\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-17223a0 elementor-widget elementor-widget-text-editor\" data-id=\"17223a0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-f901e8fb-7fff-7af4-1309-3c87283a7b24\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">\u0110\u1ec3 l\u1ecdc \u00f4 tr\u1ed1ng, ch\u1ecdn <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Blanks<\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">.<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a793a4c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a793a4c\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-72a8138\" data-id=\"72a8138\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a7ae02e elementor-widget elementor-widget-image\" data-id=\"a7ae02e\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/loc-o-trong-khong-chua-du-lieu-trong-filter-loc-du-lieu-trong-excel.png\" title=\"loc-o-trong-khong-chua-du-lieu-trong-filter-loc-du-lieu-trong-excel\" alt=\"C\u00e1ch L\u1ecdc D\u1eef Li\u1ec7u Trong Excel - L\u1ecdc \u00d4 Tr\u1ed1ng (Blank) Kh\u00f4ng Ch\u1ee9a D\u1eef Li\u1ec7u\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ceff50b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ceff50b\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1bbf140\" data-id=\"1bbf140\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ec1f807 elementor-widget elementor-widget-text-editor\" data-id=\"ec1f807\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-090fc25b-7fff-3dc0-a11d-08e89917d8c7\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">\u0110\u1ec3 ch\u1ec9 c\u00e1c \u00f4 c\u00f3 d\u1eef li\u1ec7u (b\u1ecf qua c\u00e1c \u00f4 tr\u1ed1ng), <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">ch\u1ecdn Select All<\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\"> (Ch\u1ecdn T\u1ea5t c\u1ea3) &gt;&gt; <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">b\u1ecf ch\u1ecdn Blanks <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">(C\u00e1c \u00f4 tr\u1ed1ng) \u1edf cu\u1ed1i danh s\u00e1ch. \u1ea4n OK, c\u00e1c h\u00e0ng c\u00f3 d\u1eef li\u1ec7u trong c\u1ed9t m\u1edbi hi\u1ec3n th\u1ecb.<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2838976 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2838976\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-efd457a\" data-id=\"efd457a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8cc2269 elementor-widget elementor-widget-heading\" data-id=\"8cc2269\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-f55e1f42-7fff-badc-6bcb-4c6f50e69236\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">3.4, C\u00e1ch L\u1ecdc M\u00e0u Trong Excel<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-06e782c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"06e782c\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3b80856\" data-id=\"3b80856\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-67c9aab elementor-widget elementor-widget-text-editor\" data-id=\"67c9aab\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-1519f303-7fff-db03-ea65-160baeeb6526\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">\u0110\u1ec3 l\u1ecdc theo m\u00e0u \u00f4, ch\u1ecdn Filter by Color:<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a89a99e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a89a99e\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-018cdb9\" data-id=\"018cdb9\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-217ce51 elementor-widget elementor-widget-image\" data-id=\"217ce51\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/Color-Filter-cach-loc-du-lieu-trong-excel.png\" title=\"Color-Filter-cach-loc-du-lieu-trong-excel\" alt=\"C\u00e1ch L\u1ecdc M\u00e0u Trong Excel: \u0110\u1ec3 l\u1ecdc theo m\u00e0u \u00f4, ch\u1ecdn Filter by Color\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b829ef5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b829ef5\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-16b1414\" data-id=\"16b1414\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-701fa7b elementor-widget elementor-widget-text-editor\" data-id=\"701fa7b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">N\u1ebfu c\u1ed9t ch\u1ee9a c\u00e1c ph\u00f4ng m\u00e0u ch\u1eef kh\u00e1c nhau, hay ch\u1ee9a nhi\u1ec1u h\u01a1n 1 bi\u1ec3u t\u01b0\u1ee3ng \u00f4, trong Filter by Color s\u1ebd hi\u1ec3n th\u1ecb c\u00e1c l\u1ef1a ch\u1ecdn \u0111\u1ec3 l\u1ecdc theo m\u00e0u ph\u00f4ng ch\u1eef v\u00e0 bi\u1ec3u t\u01b0\u1ee3ng \u00f4.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-af5bf59 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"af5bf59\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d3a7541\" data-id=\"d3a7541\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-054eccf elementor-widget elementor-widget-heading\" data-id=\"054eccf\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-b8d33244-7fff-e379-d875-a244aa22742d\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">3.5, C\u00e1ch L\u1ecdc D\u1eef Li\u1ec7u \u0110\u1ecbnh D\u1ea1ng Ng\u00e0y Th\u00e1ng Trong Excel<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-71d8b74 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"71d8b74\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4e04ba7\" data-id=\"4e04ba7\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-85004b7 elementor-widget elementor-widget-text-editor\" data-id=\"85004b7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Excel m\u1eb7c \u0111\u1ecbnh hi\u1ec3n th\u1ecb c\u00e1c gi\u00e1 tr\u1ecb l\u00e0 ng\u00e0y th\u00e1ng n\u0103m trong c\u1eeda s\u1ed5 Filter d\u01b0\u1edbi d\u1ea1ng danh s\u00e1ch m\u1edf r\u1ed9ng d\u1ea7n theo th\u1ee9 t\u1ef1 n\u0103m &gt;&gt; th\u00e1ng &gt;&gt; ng\u00e0y.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">\u0110\u1ec3 m\u1edf r\u1ed9ng \/ thu nh\u1ecf gi\u1eefa c\u00e1c c\u1ea5p \u0111\u1ed9 n\u0103m <\/span><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\"><span style=\"border-width: initial; border-style: none; display: inline-block; overflow: hidden; width: 20px; height: 20px;\"><img loading=\"lazy\" style=\"margin-left: 0px; margin-top: 0px;\" src=\"https:\/\/lh5.googleusercontent.com\/5xlIiz5UOmCG6oaPf-AF3GyeRmiK4wZN_fvRMPk5Dry6gzkBtPiFjGegfVp-GODizHb7KlwlATocQSnkXZOeTwITlt-LPJdPy0-iIv_L3dTeNSlwqOF678rLI8G8Snu-0hxUwiSF\" width=\"20\" height=\"20\" \/><\/span><\/span><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\"> th\u00e1ng <\/span><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\"><span style=\"border-width: initial; border-style: none; display: inline-block; overflow: hidden; width: 20px; height: 20px;\"><img loading=\"lazy\" style=\"margin-left: 0px; margin-top: 0px;\" src=\"https:\/\/lh5.googleusercontent.com\/5xlIiz5UOmCG6oaPf-AF3GyeRmiK4wZN_fvRMPk5Dry6gzkBtPiFjGegfVp-GODizHb7KlwlATocQSnkXZOeTwITlt-LPJdPy0-iIv_L3dTeNSlwqOF678rLI8G8Snu-0hxUwiSF\" width=\"20\" height=\"20\" \/><\/span><\/span><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\"> ng\u00e0y b\u1eb1ng c\u00e1ch ch\u1ecdn d\u1ea5u c\u1ed9ng ho\u1eb7c d\u1ea5u tr\u1eeb tr\u01b0\u1edbc m\u1ed7i nh\u00f3m.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-af9e8ca elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"af9e8ca\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-cb1251e\" data-id=\"cb1251e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-369802a elementor-widget elementor-widget-image\" data-id=\"369802a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/filter-loc-ngay-thang-cach-loc-du-lieu-trong-excel.png\" title=\"filter-loc-ngay-thang-cach-loc-du-lieu-trong-excel\">&gt; th\u00e1ng &gt;&gt; ng\u00e0y\" \/&gt;\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-497930c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"497930c\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d1adf7d\" data-id=\"d1adf7d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b98a964 elementor-widget elementor-widget-text-editor\" data-id=\"b98a964\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Date Filters cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng ch\u1ecdn hi\u1ec3n th\u1ecb \/ \u1ea9n d\u1eef li\u1ec7u l\u00e0 ng\u00e0y, tu\u1ea7n, th\u00e1ng, qu\u00fd, n\u0103m ch\u1ec9 \u0111\u1ecbnh ho\u1eb7c l\u1ecdc theo d\u1eef li\u1ec7u so s\u00e1nh v\u1edbi th\u1eddi gian ch\u1ec9 \u0111\u1ecbnh.<\/span><\/p><p>\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">H\u00ecnh \u1ea3nh d\u01b0\u1edbi \u0111\u00e2y hi\u1ec3n th\u1ecb t\u1ea5t c\u1ea3 c\u00e1c b\u1ed9 l\u1ecdc ng\u00e0y th\u00e1ng n\u0103m c\u00f3 s\u1eb5n trong ch\u1ee9c n\u0103ng Filter:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-51a2c87 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"51a2c87\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2019bf9\" data-id=\"2019bf9\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f2ab3d0 elementor-widget elementor-widget-image\" data-id=\"f2ab3d0\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/Date-Filter-cach-loc-du-lieu-trong-excel.png\" title=\"Date-Filter-cach-loc-du-lieu-trong-excel\" alt=\"C\u00e1ch L\u1ecdc D\u1eef Li\u1ec7u \u0110\u1ecbnh D\u1ea1ng Ng\u00e0y Th\u00e1ng Trong Excel V\u1edbi Date Filter\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-dc08e34 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dc08e34\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2e434d3\" data-id=\"2e434d3\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-915e20c elementor-widget elementor-widget-text-editor\" data-id=\"915e20c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Ngo\u00e0i ra, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eafp x\u1ebfp ng\u00e0y th\u00e1ng t\u0103ng d\u1ea7n trong Excel ho\u1eb7c ng\u01b0\u1ee3c l\u1ea1i nh\u1edd Sort Oldest to Newest\/ Sort Newest\u00a0 to Oldest.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c2df02d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c2df02d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-258f36c\" data-id=\"258f36c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-50532b6 elementor-widget elementor-widget-heading\" data-id=\"50532b6\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-48c72db6-7fff-d9db-f83e-3c27bfb76ac1\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">3.6, S\u1eed D\u1ee5ng Search L\u1ecdc T\u00ean Trong Excel<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-497b720 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"497b720\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2d92734\" data-id=\"2d92734\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-94601be elementor-widget elementor-widget-text-editor\" data-id=\"94601be\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">\u0110\u1ec3 t\u00ecm t\u00ean trong Excel v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb c\u00f3 \u0111i\u1ec3m chung, v\u00ed d\u1ee5 \u0111\u1ec3 t\u00ecm c\u00e1c S\u1ea3n ph\u1ea9m c\u00f3 ch\u1ee9a M1 trong t\u00ean, ch\u1ec9 c\u1ea7n g\u00f5 M1 \u1edf \u00f4 Search, c\u1eeda s\u1ed5 Filter s\u1ebd hi\u1ec7n to\u00e0n b\u1ed9 c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n c\u00f3 ch\u1ee9a M1 nh\u01b0 sau:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-bc04da0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bc04da0\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d321f5f\" data-id=\"d321f5f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-44bc3e5 elementor-widget elementor-widget-image\" data-id=\"44bc3e5\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/Cua-so-loc-su-dung-search-cach-loc-du-lieu-trong-excel.png\" title=\"Cua-so-loc-su-dung-search-cach-loc-du-lieu-trong-excel\" alt=\"S\u1eed D\u1ee5ng Search L\u1ecdc T\u00ean Trong Excel Khi L\u1ecdc D\u1eef Li\u1ec7u\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-db1bfd9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"db1bfd9\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-99f90dc\" data-id=\"99f90dc\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-45e90c0 elementor-widget elementor-widget-text-editor\" data-id=\"45e90c0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Ch\u1ecdn <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"><b>Select All Search Results<\/b><\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> \u0111\u1ec3 ch\u1ecdn nhanh to\u00e0n b\u1ed9 c\u00e1c gi\u00e1 tr\u1ecb hi\u1ec7n ra, \u1ea5n OK.<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u0110\u1ec3 \u0111\u1ebfn \u00f4 Search nhanh, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"><b>ph\u00edm t\u1eaft E<\/b><\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">.<\/span><\/p>\n<p><b style=\"font-weight: normal;\">&nbsp;<\/b><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Hi v\u1ecdng b\u00e0i vi\u1ebft c\u1ee7a hoctin.vn \u0111\u00e3 mang l\u1ea1i cho c\u00e1c b\u1ea1n c\u00e1c th\u00f4ng tin h\u1eefu \u00edch v\u1ec1 c\u00e1c c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel.<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Ch\u00fac c\u00e1c b\u1ea1n \u00e1p d\u1ee5ng th\u00e0nh c\u00f4ng trong c\u00f4ng vi\u1ec7c v\u00e0 h\u1ecdc t\u1eadp.<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Trong b\u00e0i h\u01b0\u1edbng d\u1eabn ti\u1ebfp theo, ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u n\u00e2ng cao v\u00e0 s\u1eed d\u1ee5ng b\u1ed9 l\u1ecdc n\u00e2ng cao nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n.<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">&nbsp;<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Ngo\u00e0i ra, \u0111\u1ec3 \u1ee9ng d\u1ee5ng hi\u1ec7u qu\u1ea3 Excel, b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m v\u00e0 c\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c c\u1ee7a Excel. H\u00e3y c\u00f9ng \u0111\u00f3n \u0111\u1ecdc series b\u00e0i vi\u1ebft \u1ee9ng d\u1ee5ng c\u00e1c h\u00e0m Excel:<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"><br><\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/pivot-table-nang-cao\/\" target=\"_blank\">L\u1ecdc D\u1eef Li\u1ec7u V\u1edbi Slicer Trong Pivot Table N\u00e2ng Cao<\/a><br><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/cach-co-dinh-dong-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch C\u1ed1 \u0110\u1ecbnh D\u00f2ng V\u00e0 C\u1ed9t<\/a><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/ham-countif-co-ban\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m COUNTIF<\/a><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/ve-bieu-do-trong-excel-chi-voi-3-buoc\/\" target=\"_blank\" rel=\"noopener\">V\u1ebd Bi\u1ec3u \u0110\u1ed3 Trong Excel<\/a><\/p>\n<div>&nbsp;<\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>S\u1eafp x\u1ebfp v\u00e0 l\u1ecdc d\u1eef li\u1ec7u trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 gi\u00fap qu\u1ea3n l\u00fd d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3. B\u1ed9 l\u1ecdc gi\u00fap b\u1ea1n t\u00ecm ki\u1ebfm v\u00e0 l\u1ecdc d\u1eef li\u1ec7u, hi\u1ec3n th\u1ecb c\u00e1c d\u1eef li\u1ec7u \u0111\u00e1p \u1ee9ng c\u00e1c ti\u00eau ch\u00ed nh\u1ea5t \u0111\u1ecbnh. Trong b\u00e0i vi\u1ebft n\u00e0y, hoctin.vn s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u &#8230; <a title=\"C\u00e1ch L\u1ecdc D\u1eef Li\u1ec7u Trong Excel D\u1ec5 Hi\u1ec3u V\u00e0 C\u1ef1c K\u1ef3 \u0110\u01a1n Gi\u1ea3n V\u1edbi Filter\" class=\"read-more\" href=\"https:\/\/hoctin.vn\/cach-loc-du-lieu-trong-excel\/\">Read more <span class=\"screen-reader-text\">C\u00e1ch L\u1ecdc D\u1eef Li\u1ec7u Trong Excel D\u1ec5 Hi\u1ec3u V\u00e0 C\u1ef1c K\u1ef3 \u0110\u01a1n Gi\u1ea3n V\u1edbi Filter<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":1006,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[30],"tags":[36,16,35,7],"_links":{"self":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/1005"}],"collection":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/comments?post=1005"}],"version-history":[{"count":0,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/1005\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media\/1006"}],"wp:attachment":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media?parent=1005"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/categories?post=1005"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/tags?post=1005"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}