{"id":783,"date":"2023-08-25T16:15:18","date_gmt":"2023-08-25T09:15:18","guid":{"rendered":"https:\/\/trannghiait.com\/?p=783"},"modified":"2023-08-25T22:35:14","modified_gmt":"2023-08-25T15:35:14","slug":"783","status":"publish","type":"post","link":"https:\/\/trannghiait.com\/index.php\/2023\/08\/25\/783\/","title":{"rendered":"C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel v\u1eadn d\u1ee5ng t\u1ed1t nh\u1ea5t trong l\u00e0m vi\u1ec7c \u1edf c\u01a1 quan\/c\u00f4ng s\u1edf:"},"content":{"rendered":"\n<p>\u0110\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn chi ti\u1ebft v\u00e0 nhi\u1ec1u h\u00ecnh \u1ea3nh v\u00ed d\u1ee5 minh h\u1ecda v\u1ec1 c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Ch\u1ecdn ph\u1ea1m vi d\u1eef li\u1ec7u c\u1ea7n l\u1ecdc.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"882\" height=\"367\" src=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-57.png\" alt=\"\" class=\"wp-image-785\" srcset=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-57.png 882w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-57-300x125.png 300w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-57-768x320.png 768w\" sizes=\"(max-width: 882px) 100vw, 882px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li>Tr\u00ean thanh menu, ch\u1ecdn tab &#8220;Data&#8221; v\u00e0 ch\u1ecdn &#8220;Filter&#8221; trong nh\u00f3m &#8220;Sort &amp; Filter&#8221;.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"990\" height=\"367\" src=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-58.png\" alt=\"\" class=\"wp-image-786\" srcset=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-58.png 990w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-58-300x111.png 300w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-58-768x285.png 768w\" sizes=\"(max-width: 990px) 100vw, 990px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\">\n<li>C\u00e1c n\u00fat l\u1ecdc s\u1ebd xu\u1ea5t hi\u1ec7n \u1edf ti\u00eau \u0111\u1ec1 c\u1ee7a c\u00e1c c\u1ed9t trong b\u1ea3ng t\u00ednh.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"943\" height=\"368\" src=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-59.png\" alt=\"\" class=\"wp-image-787\" srcset=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-59.png 943w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-59-300x117.png 300w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-59-768x300.png 768w\" sizes=\"(max-width: 943px) 100vw, 943px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"4\">\n<li>Nh\u1ea5p v\u00e0o n\u00fat l\u1ecdc \u1edf c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n l\u1ecdc d\u1eef li\u1ec7u.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"941\" height=\"363\" src=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-60.png\" alt=\"\" class=\"wp-image-788\" srcset=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-60.png 941w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-60-300x116.png 300w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-60-768x296.png 768w\" sizes=\"(max-width: 941px) 100vw, 941px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"5\">\n<li>M\u1ed9t h\u1ed9p tho\u1ea1i s\u1ebd hi\u1ec3n th\u1ecb cho ph\u00e9p b\u1ea1n ch\u1ecdn c\u00e1c \u0111i\u1ec1u ki\u1ec7n l\u1ecdc.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"282\" height=\"417\" src=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-61.png\" alt=\"\" class=\"wp-image-789\" srcset=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-61.png 282w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-61-203x300.png 203w\" sizes=\"(max-width: 282px) 100vw, 282px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"6\">\n<li>Ch\u1ecdn \u0111i\u1ec1u ki\u1ec7n l\u1ecdc ph\u00f9 h\u1ee3p v\u00e0 nh\u1ea5n OK.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"266\" height=\"404\" src=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-62.png\" alt=\"\" class=\"wp-image-790\" srcset=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-62.png 266w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-62-198x300.png 198w\" sizes=\"(max-width: 266px) 100vw, 266px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"7\">\n<li>C\u00e1c d\u00f2ng d\u1eef li\u1ec7u kh\u00f4ng th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n l\u1ecdc s\u1ebd b\u1ecb \u1ea9n \u0111i.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"936\" height=\"351\" src=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-63.png\" alt=\"\" class=\"wp-image-791\" srcset=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-63.png 936w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-63-300x113.png 300w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-63-768x288.png 768w\" sizes=\"(max-width: 936px) 100vw, 936px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"8\">\n<li>\u0110\u1ec3 hi\u1ec3n th\u1ecb l\u1ea1i t\u1ea5t c\u1ea3 c\u00e1c d\u00f2ng d\u1eef li\u1ec7u, h\u00e3y nh\u1ea5p v\u00e0o n\u00fat &#8220;Clear Filter&#8221; trong c\u1ed9t \u0111\u00f3.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"859\" height=\"668\" src=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-64.png\" alt=\"\" class=\"wp-image-792\" srcset=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-64.png 859w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-64-300x233.png 300w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-64-768x597.png 768w\" sizes=\"(max-width: 859px) 100vw, 859px\" \/><\/figure>\n\n\n\n<p>Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng &#8220;Advanced Filter&#8221; \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau ho\u1eb7c t\u1ea1o b\u1ed9 l\u1ecdc t\u00f9y ch\u1ec9nh. \u0110\u1ec3 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng n\u00e0y, h\u00e3y ch\u1ecdn &#8220;Advanced&#8221; trong h\u1ed9p tho\u1ea1i l\u1ecdc v\u00e0 l\u00e0m theo c\u00e1c h\u01b0\u1edbng d\u1eabn tr\u00ean m\u00e0n h\u00ecnh.<\/p>\n\n\n\n<p>Hy v\u1ecdng h\u01b0\u1edbng d\u1eabn tr\u00ean s\u1ebd gi\u00fap b\u1ea1n l\u1ecdc d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng v\u00e0 nhanh ch\u00f3ng trong Excel.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>\u0110\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn chi ti\u1ebft v\u00e0 nhi\u1ec1u h\u00ecnh \u1ea3nh v\u00ed d\u1ee5 minh h\u1ecda v\u1ec1 c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel: Ngo\u00e0i ra, b\u1ea1n c\u00f3 <a class=\"mh-excerpt-more\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/25\/783\/\" title=\"C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel v\u1eadn d\u1ee5ng t\u1ed1t nh\u1ea5t trong l\u00e0m vi\u1ec7c \u1edf c\u01a1 quan\/c\u00f4ng s\u1edf:\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":776,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-783","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kien-thuc-excel"],"_links":{"self":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/783","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/comments?post=783"}],"version-history":[{"count":2,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/783\/revisions"}],"predecessor-version":[{"id":805,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/783\/revisions\/805"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/media\/776"}],"wp:attachment":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/media?parent=783"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/categories?post=783"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/tags?post=783"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}