{"id":10022,"date":"2025-01-07T06:01:12","date_gmt":"2025-01-07T06:01:12","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/07\/huong-dan-su-dung-filter-loc-du-lieu-trong-bai-thi-mos-excel\/"},"modified":"2025-01-07T06:01:12","modified_gmt":"2025-01-07T06:01:12","slug":"huong-dan-su-dung-filter-loc-du-lieu-trong-bai-thi-mos-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/07\/huong-dan-su-dung-filter-loc-du-lieu-trong-bai-thi-mos-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Filter l\u1ecdc d\u1eef li\u1ec7u trong b\u00e0i thi MOS Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>S\u1eed d\u1ee5ng Filter gi\u00fap b\u1ea1n \u0111\u1ecbnh v\u1ecb v\u00e0 hi\u1ec3n th\u1ecb nh\u1eefng gi\u00e1 tr\u1ecb d\u1eef li\u1ec7u c\u1ee5 th\u1ec3. \u0110\u1ed3ng th\u1eddi \u0111\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng k\u0129 n\u0103ng quan tr\u1ecdng trong Excel. H\u00e3y c\u00f9ng H\u1ecdc Excel Online t\u00ecm hi\u1ec3u qua b\u00e0i vi\u1ebft b\u00ean d\u01b0\u1edbi:<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-677cc3274cb6b\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/su-dung-filter-loc-du-lieu-mos-excel.html#Tao_va_bo_tao_Filter_cho_vung_du_lieu\" title=\"T\u1ea1o v\u00e0 b\u1ecf t\u1ea1o Filter cho v\u00f9ng d\u1eef li\u1ec7u\">T\u1ea1o v\u00e0 b\u1ecf t\u1ea1o Filter cho v\u00f9ng d\u1eef li\u1ec7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/su-dung-filter-loc-du-lieu-mos-excel.html#Ap_dung_huy_ap_dung_Filter\" title=\"\u00c1p d\u1ee5ng, h\u1ee7y \u00e1p d\u1ee5ng Filter.\">\u00c1p d\u1ee5ng, h\u1ee7y \u00e1p d\u1ee5ng Filter.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/su-dung-filter-loc-du-lieu-mos-excel.html#Custom_Filter\" title=\"Custom Filter\">Custom Filter<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/su-dung-filter-loc-du-lieu-mos-excel.html#Su_dung_Filter_dua_theo_mau_sac\" title=\"S\u1eed d\u1ee5ng Filter d\u1ef1a theo m\u00e0u s\u1eafc\">S\u1eed d\u1ee5ng Filter d\u1ef1a theo m\u00e0u s\u1eafc<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Tao_va_bo_tao_Filter_cho_vung_du_lieu\"><\/span><strong>T\u1ea1o v\u00e0 b\u1ecf t\u1ea1o Filter<\/strong> <strong>cho v\u00f9ng d\u1eef li\u1ec7u<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol>\n<li>Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u.<\/li>\n<li>T\u1ea1i th\u1ebb <strong>Home<\/strong>, nh\u00f3m <strong>Editing<\/strong>, \u1ea5n v\u00e0o <strong>Sort &amp; Filter <\/strong>v\u00e0 click Ho\u1eb7c t\u1ea1i th\u1ebb <strong>Data<\/strong>, trong nh\u00f3m <strong>Sort &amp; Filter<\/strong>, click v\u00e0o <strong>Filter.<\/strong><\/li>\n<li>\u1ea4n v\u00e0o <strong>Filter <\/strong>m\u1ed9t l\u1ea7n n\u1eefa \u0111\u1ec3 h\u1ee7y ch\u1ee9c n\u0103ng.<\/li>\n<\/ol>\n<h3><span class=\"ez-toc-section\" id=\"Ap_dung_huy_ap_dung_Filter\"><\/span><strong>\u00c1p d\u1ee5ng, h\u1ee7y \u00e1p d\u1ee5ng Filter.<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Sau khi \u0111\u1eb7t Filter cho v\u00f9ng d\u1eef li\u1ec7u, \u1ea5n v\u00e0o m\u0169i t\u00ean t\u1ea1i c\u1ed9t b\u1ea1n mu\u1ed1n l\u1ecdc.<\/p>\n<ul>\n<li>Ch\u1ecdn \u0111i\u1ec1u ki\u1ec7n l\u1ecdc: Bao g\u1ed3m c\u00e1c \u0111i\u1ec1u ki\u1ec7n c\u01a1 b\u1ea3n nh\u01b0: L\u1edbn h\u01a1n, Nh\u1ecf h\u01a1n, B\u1eb1ng, Top 10, \u1edf gi\u1eefa\u2026 \u0110\u1ed1i v\u1edbi c\u00e1c \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u kh\u00e1c nhau s\u1ebd c\u00f3 th\u00eam c\u00e1c \u0111i\u1ec1u ki\u1ec7n l\u1ecdc kh\u00e1c nhau.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21399\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-dieu-kien-filter.png\" width=\"440\" height=\"552\" title=\"mos-excel-2010-dieu-kien-filter\"><\/p>\n<ul>\n<li>Ch\u1ecdn \u0111\u1ed1i t\u01b0\u1ee3ng l\u1ecdc: Hi\u1ec3n th\u1ecb danh s\u00e1ch c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng c\u1ee5 th\u1ec3 trong b\u1ea3ng d\u1eef li\u1ec7u.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21400\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-doi-tuong-loc.png\" width=\"272\" height=\"440\" title=\"mos-excel-2010-doi-tuong-loc\"><\/p>\n<p>\u0110\u1ec3 h\u1ee7y \u00e1p d\u1ee5ng filter, trong nh\u00f3m <strong>Sort &amp; Filter<\/strong>, click v\u00e0o n\u00fat <strong>Clear.<\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Custom_Filter\"><\/span><strong>Custom Filter<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong \u0111i\u1ec1u ki\u1ec7n l\u1ecdc, Excel cho ph\u00e9p ng\u01b0\u1eddi s\u1eed d\u1ee5ng \u0111\u1eb7t \u0111i\u1ec1u ki\u1ec7n t\u00f9y ch\u1ecdn b\u1eb1ng thao t\u00e1c v\u1edbi <strong>Custom Filter. <\/strong>Click v\u00e0o ch\u1ee9c n\u0103ng Custom Filter\u2026, thi\u1ebft l\u1eadp \u0111i\u1ec1u ki\u1ec7n v\u00e0 \u1ea5n <strong>OK <\/strong>\u0111\u1ec3 \u00e1p d\u1ee5ng.<\/p>\n<figure id=\"attachment_21401\" aria-describedby=\"caption-attachment-21401\" style=\"width: 382px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-21401\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-custom-filter.png\" width=\"382\" height=\"235\" title=\"mos-excel-2010-custom-filter\"><figcaption id=\"caption-attachment-21401\" class=\"wp-caption-text\">H\u1ed9p tho\u1ea1i Custom Filter n\u1eb1m trong m\u1ee5c \u0111i\u1ec1u ki\u1ec7n l\u1ecdc<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_Filter_dua_theo_mau_sac\"><\/span><strong>S\u1eed d\u1ee5ng Filter d\u1ef1a theo m\u00e0u s\u1eafc<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Sau khi th\u00eam m\u00e0u s\u1eafc cho c\u00e1c \u00f4 ho\u1eb7c s\u1eed d\u1ee5ng Conditional Formatting, b\u1ea1n c\u00f3 th\u1ec3 l\u1ecdc d\u1eef li\u1ec7u theo m\u00e0u \u0111\u00f3 b\u1eb1ng c\u00e1ch \u1ea5n v\u00e0o m\u0169i t\u00ean t\u1ea1i c\u1ed9t mu\u1ed1n l\u1ecdc, sau \u0111\u00f3 ch\u1ecdn <strong>Filter by Color<\/strong> v\u00e0 ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng m\u00e0u theo \u00fd mu\u1ed1n.<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-124.gif\" title=\"ex101_92019-nho-124\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<figure id=\"attachment_21402\" aria-describedby=\"caption-attachment-21402\" style=\"width: 430px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-21402\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-filter-by-color.png\" width=\"430\" height=\"440\" title=\"mos-excel-2010-filter-by-color\"><figcaption id=\"caption-attachment-21402\" class=\"wp-caption-text\">Filter by color: L\u1ecdc theo m\u00e0u cell ho\u1eb7c theo m\u00e0u ch\u1eef<\/figcaption><\/figure>\n<p>Ngo\u00e0i ra c\u00f2n c\u00f3 r\u1ea5t nhi\u1ec1u c\u00e1ch k\u1ebft h\u1ee3p c\u00e1c \u0111i\u1ec1u ki\u1ec7n v\u1edbi filter \u0111ang ch\u1edd b\u1ea1n t\u00ecm hi\u1ec3u \u0111\u1ea5y.<\/p>\n<p>\u00a0<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\"><strong>H\u1ecdc Excel Online<\/strong><\/a>. V\u00e0 \u0111\u1eebng qu\u00ean r\u1eb1ng b\u00ean c\u1ea1nh Filter c\u00f2n c\u00f3 ch\u1ee9c n\u0103ng quan tr\u1ecdng kh\u00f4ng k\u00e9m: <strong>ch\u1ee9c n\u0103ng Sort<\/strong> s\u1ebd \u0111\u01b0\u1ee3c gi\u1edbi thi\u1ec7u trong b\u00e0i vi\u1ebft ti\u1ebfp theo.<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-124.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10023,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10022","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10022","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=10022"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10022\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10023"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10022"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10022"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10022"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}