{"id":4950,"date":"2024-12-08T15:41:12","date_gmt":"2024-12-08T15:41:12","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/huong-dan-cach-xu-ly-loi-du-lieu-ngay-thang-trong-excel\/"},"modified":"2024-12-08T15:41:12","modified_gmt":"2024-12-08T15:41:12","slug":"huong-dan-cach-xu-ly-loi-du-lieu-ngay-thang-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/huong-dan-cach-xu-ly-loi-du-lieu-ngay-thang-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch x\u1eed l\u00fd l\u1ed7i d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>M\u1ee5c\u00a0\u0111\u00edch c\u1ee7a ch\u00fang ta khi h\u1ecdc\u00a0Excel\u00a0\u0111\u00f3 l\u00e0 c\u00f3 th\u1ec3 t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u t\u1ed1t, t\u1eeb\u00a0\u0111\u00f3 l\u1eadp\u00a0\u0111\u01b0\u1ee3c c\u00e1c b\u00e1o c\u00e1o theo y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c. Th\u1ebf nh\u01b0ng ch\u00fang ta c\u0169ng g\u1eb7p ph\u1ea3i v\u00f4 v\u00e0n nh\u1eefng th\u1eafc m\u1eafc nh\u01b0:<\/p>\n<ul>\n<li>T\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u nh\u01b0 th\u1ebf n\u00e0o l\u00e0 t\u1ed1t?<\/li>\n<li>L\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 ki\u1ec3m tra d\u1eef li\u1ec7u tr\u00ean\u00a0Excel\u00a0\u0111\u1ec3\u00a0\u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c c\u1ee7a d\u1eef li\u1ec7u?<\/li>\n<li>L\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 l\u1eadp\u00a0\u0111\u01b0\u1ee3c c\u00e1c b\u00e1o c\u00e1o tr\u00ean\u00a0Excel?<\/li>\n<li>B\u00e1o c\u00e1o th\u1ebf n\u00e0o l\u00e0\u00a0\u0111\u1eb9p, khoa h\u1ecdc?<\/li>\n<li>\u2026<\/li>\n<\/ul>\n<p>Nh\u1eb1m gi\u00fap c\u00e1c b\u1ea1n h\u00ecnh th\u00e0nh t\u01b0 duy t\u1ed1t trong vi\u1ec7c t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u v\u00e0 l\u1eadp b\u00e1o c\u00e1o tr\u00ean Excel, H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n seri b\u00e0i vi\u1ebft v\u1ec1 \u201cK\u1ef9 n\u0103ng t\u1ed5 ch\u1ee9c, qu\u1ea3n l\u00fd d\u1eef li\u1ec7u v\u00e0 l\u1eadp b\u00e1o c\u00e1o tr\u00ean Excel\u201d. B\u00e0i vi\u1ebft c\u1ee7a t\u00e1c gi\u1ea3 Nguy\u1ec5n \u0110\u1ee9c Thanh \u2013 Gi\u1ea3ng vi\u00ean c\u1ee7a H\u1ecdc Excel Online, d\u1ef1a tr\u00ean nh\u1eefng kinh nghi\u1ec7m gi\u1ea3ng d\u1ea1y trong th\u1ef1c t\u1ebf c\u1ee7a th\u1ea7y li\u00ean quan t\u1edbi n\u1ed9i dung n\u00e0y. M\u1eddi c\u00e1c b\u1ea1n c\u00f9ng t\u00ecm hi\u1ec3u nh\u00e9.<\/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-6755be1729d89\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-xu-ly-loi-du-lieu-ngay-thang-trong-excel.html#Bai_3_Huong_dan_cach_xu_ly_loi_du_lieu_ngay_thang_trong_Excel\" title=\"B\u00e0i 3:\u00a0H\u01b0\u1edbng d\u1eabn\u00a0c\u00e1ch x\u1eed l\u00fd l\u1ed7i d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng trong\u00a0Excel\">B\u00e0i 3:\u00a0H\u01b0\u1edbng d\u1eabn\u00a0c\u00e1ch x\u1eed l\u00fd l\u1ed7i d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng trong\u00a0Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-xu-ly-loi-du-lieu-ngay-thang-trong-excel.html#1_Phat_hien_loi_du_lieu_thoi_gian_voi_bo_loc_tu_dong_trong_Excel_cong_cu_AutoFilter\" title=\"1. Ph\u00e1t hi\u1ec7n l\u1ed7i d\u1eef li\u1ec7u th\u1eddi gian v\u1edbi b\u1ed9 l\u1ecdc t\u1ef1 \u0111\u1ed9ng trong Excel (c\u00f4ng c\u1ee5\u00a0AutoFilter)\">1. Ph\u00e1t hi\u1ec7n l\u1ed7i d\u1eef li\u1ec7u th\u1eddi gian v\u1edbi b\u1ed9 l\u1ecdc t\u1ef1 \u0111\u1ed9ng trong Excel (c\u00f4ng c\u1ee5\u00a0AutoFilter)<\/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\/huong-dan-cach-xu-ly-loi-du-lieu-ngay-thang-trong-excel.html#2_Nguyen_tac_sap_xep_du_lieu_trong_AutoFilter\" title=\"2. Nguy\u00ean t\u1eafc s\u1eafp x\u1ebfp d\u1eef li\u1ec7u trong AutoFilter\">2. Nguy\u00ean t\u1eafc s\u1eafp x\u1ebfp d\u1eef li\u1ec7u trong AutoFilter<\/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\/huong-dan-cach-xu-ly-loi-du-lieu-ngay-thang-trong-excel.html#3_Cach_xu_ly_sua_loi_du_lieu\" title=\"3. C\u00e1ch x\u1eed l\u00fd, s\u1eeda l\u1ed7i d\u1eef li\u1ec7u\">3. C\u00e1ch x\u1eed l\u00fd, s\u1eeda l\u1ed7i d\u1eef li\u1ec7u<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Bai_3_Huong_dan_cach_xu_ly_loi_du_lieu_ngay_thang_trong_Excel\"><\/span>B\u00e0i 3:\u00a0H\u01b0\u1edbng d\u1eabn\u00a0c\u00e1ch x\u1eed l\u00fd l\u1ed7i d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng trong\u00a0Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-thay-doi-va-tao-dinh-dang-ngay-thang-mac-dinh-tren-excel.html\">D\u1eef li\u1ec7u d\u1ea1ng ng\u00e0y th\u00e1ng trong\u00a0Excel<\/a><\/strong> r\u1ea5t d\u1ec5 b\u1ecb nh\u1eadp sai. M\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u1edbi d\u1eef li\u1ec7u d\u1ea1ng ng\u00e0y th\u00e1ng b\u1ecb sai nh\u01b0 sau:<\/p>\n<ul>\n<li>Kh\u00f4ng quy\u00a0\u01b0\u1edbc v\u1ec1 c\u00e1ch hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u th\u1eddi gian, d\u1eabn t\u1edbi vi\u1ec7c kh\u00f4ng ph\u00e2n bi\u1ec7t\u00a0\u0111\u01b0\u1ee3c l\u00e0 nh\u1eadp Ng\u00e0y tr\u01b0\u1edbc hay Th\u00e1ng tr\u01b0\u1edbc.<\/li>\n<li>Nh\u1eadp sai s\u1ed1 th\u00e1ng (l\u1edbn h\u01a1n 12) d\u1eabn t\u1edbi\u00a0Excel kh\u00f4ng x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb th\u1eddi gian n\u00e0y.<\/li>\n<li>Nh\u1eadp d\u1eef li\u1ec7u th\u1eddi gian d\u01b0\u1edbi d\u1ea1ng Text d\u1eabn t\u1edbi\u00a0Excel hi\u1ec3u l\u00e0 d\u1eef li\u1ec7u Text ch\u1ee9 kh\u00f4ng ph\u1ea3i 1 gi\u00e1 tr\u1ecb th\u1eddi gian.<\/li>\n<\/ul>\n<p>V\u1eady l\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 nh\u1eadn bi\u1ebft c\u00e1c l\u1ed7i n\u00e0y v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c nh\u01b0 th\u1ebf n\u00e0o? Ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u ti\u1ebfp nh\u00e9.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"1_Phat_hien_loi_du_lieu_thoi_gian_voi_bo_loc_tu_dong_trong_Excel_cong_cu_AutoFilter\"><\/span>1. Ph\u00e1t hi\u1ec7n l\u1ed7i d\u1eef li\u1ec7u th\u1eddi gian v\u1edbi b\u1ed9 l\u1ecdc t\u1ef1 \u0111\u1ed9ng trong Excel (c\u00f4ng c\u1ee5\u00a0AutoFilter)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>AutoFilter l\u00e0 b\u1ed9 l\u1ecdc t\u1ef1\u00a0\u0111\u1ed9ng trong\u00a0Excel. Ngo\u00e0i ch\u1ee9c n\u0103ng gi\u00fap ch\u00fang ta l\u1ecdc t\u00ecm 1 n\u1ed9i dung trong b\u1ea3ng d\u1eef li\u1ec7u, n\u00f3 c\u00f2n gi\u00fap cho ch\u00fang ta ph\u00e1t hi\u1ec7n c\u00e1c l\u1ed7i v\u1ec1 d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh. C\u1ee5 th\u1ec3\u00a0\u1edf\u00a0\u0111\u00e2y ch\u00fang ta s\u1ebd xem AutoFilter ph\u00e1t hi\u1ec7n l\u1ed7i d\u1eef li\u1ec7u th\u1eddi gian nh\u01b0 th\u1ebf n\u00e0o.<\/p>\n<p><strong>B\u01b0\u1edbc 1: M\u1edf c\u00f4ng c\u1ee5 AutoFilter<\/strong><\/p>\n<p>Ch\u1ecdn <strong>to\u00e0n b\u1ed9\u00a0b\u1ea3ng d\u1eef li\u1ec7u<\/strong> &gt; Trong tab <strong>Data<\/strong> &gt; Ch\u1ecdn <strong>Filter<\/strong><\/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\/2024\/12\/ex101_92019-nho-410.gif\" title=\"ex101_92019-nho-410\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-16984\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/mo-auto-filter.png\" width=\"804\" height=\"480\" title=\"mo-auto-filter\"><\/p>\n<p><strong>B\u01b0\u1edbc 2: B\u1ea5m ch\u1ecdn n\u00fat l\u1ecdc trong c\u1ed9t li\u00ean quan t\u1edbi th\u1eddi gian, c\u1ee5 th\u1ec3\u00a0\u1edf\u00a0\u0111\u00e2y l\u00e0 c\u1ed9t Ng\u00e0y m\u1edf (c\u1ed9t C)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-16986\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/auto-filter-thoi-gian.png\" width=\"606\" height=\"535\" title=\"auto-filter-thoi-gian\"><\/p>\n<p>\u1ede\u00a0\u0111\u00e2y ch\u00fang ta th\u1ea5y d\u1eef li\u1ec7u th\u1eddi gian\u00a0\u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp t\u1ef1\u00a0\u0111\u1ed9ng theo c\u00e1c n\u0103m. Tuy nhi\u00ean c\u00f3 m\u1ed9t s\u1ed1 d\u1eef li\u1ec7u kh\u00f4ng\u00a0\u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo n\u0103m m\u00e0 ghi c\u1ee5 th\u1ec3 n\u1ed9i dung th\u1eddi gian.<\/p>\n<p>=&gt; Nh\u1eefng d\u1eef li\u1ec7u kh\u00f4ng\u00a0\u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp t\u1ef1\u00a0\u0111\u1ed9ng theo n\u0103m l\u00e0 d\u1eef li\u1ec7u l\u1ed7i v\u1ec1 th\u1eddi gian.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Nguyen_tac_sap_xep_du_lieu_trong_AutoFilter\"><\/span>2. Nguy\u00ean t\u1eafc s\u1eafp x\u1ebfp d\u1eef li\u1ec7u trong AutoFilter<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u1edbi d\u1eef li\u1ec7u th\u1eddi gian (d\u1ea1ng ng\u00e0y\/th\u00e1ng\/n\u0103m ho\u1eb7c d\u1ea1ng gi\u1edd\/ph\u00fat) s\u1ebd\u00a0\u0111\u01b0\u1ee3c t\u1ef1\u00a0\u0111\u1ed9ng s\u1eafp x\u1ebfp trong c\u1eeda s\u1ed5 d\u1eef li\u1ec7u l\u1ecdc c\u1ee7a AutoFilter theo quy t\u1eafc:<\/p>\n<ul>\n<li>Th\u1ee9 t\u1ef1: gi\u1ea3m d\u1ea7n v\u1ec1 th\u1eddi gian<\/li>\n<li>G\u1ed9p nh\u00f3m theo N\u0103m &gt; Th\u00e1ng &gt; Ng\u00e0y &gt; Gi\u1edd\u2026<\/li>\n<\/ul>\n<p>Ch\u1ec9 nh\u1eefng d\u1eef li\u1ec7u chu\u1ea9n\u00a0\u0111\u1ecbnh d\u1ea1ng th\u1eddi gian m\u1edbi\u00a0\u0111\u01b0\u1ee3c t\u1ef1\u00a0\u0111\u1ed9ng s\u1eafp x\u1ebfp. Nh\u1eefng d\u1eef li\u1ec7u kh\u00f4ng\u00a0\u0111\u00fang chu\u1ea9n s\u1ebd kh\u00f4ng\u00a0\u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_Cach_xu_ly_sua_loi_du_lieu\"><\/span>3. C\u00e1ch x\u1eed l\u00fd, s\u1eeda l\u1ed7i d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>B\u01b0\u1edbc 1: Th\u1ed1ng nh\u1ea5t v\u1ec1 quy t\u1eafc hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u th\u1eddi gian trong m\u00e1y t\u00ednh<\/strong><\/p>\n<p>\u0110\u00e2y l\u00e0 y\u00eau c\u1ea7u b\u1eaft bu\u1ed9c m\u1ed7i khi ch\u00fang ta s\u1eed d\u1ee5ng\u00a0excel tr\u00ean 1 m\u00e1y t\u00ednh m\u1edbi, b\u1edfi\u00a0th\u00f4ng th\u01b0\u1eddng m\u00e1y t\u00ednh hi\u1ec3n th\u1ecb theo quy\u00a0\u01b0\u1edbc Th\u00e1ng tr\u01b0\u1edbc-Ng\u00e0y sau. Quy \u01b0\u1edbc\u00a0n\u00e0y ng\u01b0\u1ee3c v\u1edbi quy\u00a0\u01b0\u1edbc th\u00f4ng th\u01b0\u1eddng m\u00e0 ch\u00fang ta hay s\u1eed d\u1ee5ng l\u00e0 Ng\u00e0y tr\u01b0\u1edbc-Th\u00e1ng sau.<\/p>\n<p>\u0110\u1ec3 thi\u1ebft l\u1eadp n\u1ed9i dung n\u00e0y, ch\u00fang ta th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<ul>\n<li>M\u1ecf c\u1eeda s\u1ed5\u00a0<strong>Control Pannel<\/strong> &gt; Ch\u1ecdn m\u1ee5c <strong>Region<\/strong> (Region and Language)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-16987 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/region-01.png\" width=\"554\" height=\"710\" title=\"region-01\"><\/p>\n<ul>\n<li>B\u1ea5m ch\u1ecdn m\u1ee5c Additional Settings\u2026<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-16988\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/region-02.png\" width=\"528\" height=\"755\" title=\"region-02\"><\/p>\n<ul>\n<li>Trong m\u1ee5c n\u00e0y ch\u1ecdn Date<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-16989\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/region-03.png\" width=\"528\" height=\"755\" title=\"region-03\"><\/p>\n<ul>\n<li>M\u1ee5c Short Date ch\u1ecdn quy\u00a0\u01b0\u1edbc l\u00e0\u00a0dd\/mm\/yyyy<\/li>\n<\/ul>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li><strong>dd<\/strong> l\u00e0\u00a0\u0111\u1ea1i di\u1ec7n cho Ng\u00e0y. N\u1ebfu ng\u00e0y &lt;10 th\u00ec s\u1ebd c\u00f3 s\u1ed1 0\u00a0\u1edf tr\u01b0\u1edbc<\/li>\n<li><strong>mm<\/strong> l\u00e0\u00a0\u0111\u1ea1i di\u1ec7n cho Th\u00e1ng. N\u1ebfu th\u00e1ng &lt;10 th\u00ec s\u1ebd c\u00f3 s\u1ed1 0\u00a0\u1edf tr\u01b0\u1edbc<\/li>\n<li><strong>yyyy<\/strong> l\u00e0\u00a0\u0111\u1ea1i di\u1ec7n cho N\u0103m.\u00a0\u1ede\u00a0\u0111\u00e2y ch\u00fang ta n\u00ean d\u00f9ng 4 ch\u1eef y\u00a0\u0111\u1ec3 th\u1ec3 hi\u1ec7n\u00a0\u0111\u1ee7 4 s\u1ed1 c\u1ee7a N\u0103m<\/li>\n<\/ul>\n<p>D\u1ea5u ng\u0103n c\u00e1ch th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 d\u1ea5u \/ ho\u1eb7c d\u1ea5u \u2013<\/p>\n<p><strong>B\u01b0\u1edbc 2:\u00a0\u0110\u1ecbnh d\u1ea1ng cho to\u00e0n b\u1ed9 tr\u01b0\u1eddng d\u1eef li\u1ec7u th\u1eddi gian<\/strong><\/p>\n<p>Sau khi\u00a0\u0111\u00e3 thi\u1ebft l\u1eadp quy\u00a0\u01b0\u1edbc hi\u1ec3n th\u1ecb th\u1eddi gian, ch\u00fang ta s\u1ebd ti\u1ebfn h\u00e0nh\u00a0\u0111\u1ecbnh d\u1ea1ng cho to\u00e0n b\u1ed9 tr\u01b0\u1eddng d\u1eef li\u1ec7u th\u1eddi gian trong b\u1ea3ng.<\/p>\n<p>C\u1ee5 th\u1ec3\u00a0\u1edf\u00a0\u0111\u00e2y l\u00e0 c\u1ed9t C.<\/p>\n<ul>\n<li>Ch\u1ecdn to\u00e0n b\u1ed9 c\u1ed9t C<\/li>\n<li>Format Cells cho c\u1ed9t C d\u1ea1ng Date ho\u1eb7c trong m\u1ee5c Custome ch\u1ecdn\u00a0dd\/mm\/yyyy<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-16990\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/formatcells-date.png\" width=\"890\" height=\"509\" title=\"formatcells-date\"><\/p>\n<p><strong>B\u01b0\u1edbc 3: L\u1ecdc v\u00e0 s\u1eeda nh\u1eefng d\u1eef li\u1ec7u sai, l\u1ed7i<\/strong><\/p>\n<p>B\u1ecf ch\u1ecdn\u00a0\u1edf m\u1ee5c Select All, sau\u00a0\u0111\u00f3 ch\u1ec9 ch\u1ecdn nh\u1eefng gi\u00e1 tr\u1ecb l\u1ed7i v\u1ec1 th\u1eddi gian\u00a0\u0111\u1ec3 t\u00ecm ra v\u1ecb tr\u00ed c\u1ee7a nh\u1eefng d\u00f2ng b\u1ecb l\u1ed7i.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-16991\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/auto-filter-loc-gia-tri-loi.png\" width=\"640\" height=\"562\" title=\"auto-filter-loc-gia-tri-loi\"><\/p>\n<p>S\u1eeda nh\u1eefng gi\u00e1 tr\u1ecb n\u00e0y cho\u00a0\u0111\u00fang.\u00a0C\u00e1ch t\u1ed1t nh\u1ea5t l\u00e0 n\u00ean nh\u1eadp l\u1ea1i theo\u00a0\u0111\u00fang chu\u1ea9n th\u1eddi gian.<\/p>\n<p><strong>B\u01b0\u1edbc 4: Ki\u1ec3m tra l\u1ea1i n\u1ed9i dung xem nh\u1eefng d\u1eef li\u1ec7u l\u1ed7i\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c s\u1eeda ch\u01b0a.<\/strong><\/p>\n<p>Nh\u01b0 v\u1eady l\u00e0 ch\u00fang ta\u00a0\u0111\u00e3 ho\u00e0n th\u00e0nh k\u1ef9 thu\u1eadt ph\u00e1t hi\u1ec7n l\u1ed7i d\u1eef li\u1ec7u v\u1ec1 th\u1eddi gian trong\u00a0Excel b\u1eb1ng c\u00f4ng c\u1ee5 AutoFilter v\u00e0 c\u00e1ch s\u1eeda l\u1ed7i d\u1eef li\u1ec7u th\u1eddi gian. C\u00e1c b\u1ea1n l\u01b0u\u00a0\u00fd th\u1ef1c hi\u1ec7n\u00a0\u0111\u00fang tr\u00ecnh t\u1ef1 x\u1eed l\u00fd\u00a0\u0111\u1ec3\u00a0\u0111\u1ea3m b\u1ea3o th\u1ed1ng nh\u1ea5t\u00a0\u0111\u01b0\u1ee3c v\u1ec1 quy\u00a0\u01b0\u1edbc thi\u1ebft l\u1eadp gi\u00e1 tr\u1ecb th\u1eddi gian m\u1eb7c \u0111\u1ecbnh trong m\u00e1y t\u00ednh, c\u00e1ch hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u th\u1eddi gian trong\u00a0Excel. Khi\u00a0\u0111\u00f3 vi\u1ec7c s\u1eeda l\u1ed7i s\u1ebd d\u1ec5 h\u01a1n v\u00e0\u00a0\u0111\u1ea3m b\u1ea3o ch\u00ednh x\u00e1c.<\/p>\n<p>B\u00e0i ti\u1ebfp theo:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-xu-ly-loi-du-lieu-dang-so-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch x\u1eed l\u00fd l\u1ed7i d\u1eef li\u1ec7u\u00a0d\u1ea1ng s\u1ed1\u00a0(Number) trong Excel<\/a><\/p>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/cach-thiet-lap-chi-nhap-du-lieu-dang-ngay-thang-trong-o-tren-excel.html\">Thi\u1ebft l\u1eadp ch\u1ec9 nh\u1eadp lo\u1ea1i d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng trong c\u1ed9t Ng\u00e0y<\/a><\/p>\n<p>Ngo\u00e0i ra H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n \u201c<strong>Kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m<\/strong>\u201c.\u00a0\u0110\u00e2y l\u00e0 1 kh\u00f3a h\u1ecdc r\u1ea5t\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 ki\u1ebfn th\u1ee9c v\u00e0 b\u1ed5 tr\u1ee3 r\u1ea5t tuy\u1ec7t v\u1eddi cho b\u1ea1n trong vi\u1ec7c l\u00e0m quen v\u1edbi Excel, s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5, c\u00e1c h\u00e0m trong\u00a0Excel\u00a0\u0111\u1ec3\u00a0\u0111\u00e1p\u00a0\u1ee9ng y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c t\u1ed5 ch\u1ee9c, qu\u1ea3n l\u00fd d\u1eef li\u1ec7u v\u00e0 l\u1eadp b\u00e1o c\u00e1o tr\u00ean\u00a0Excel.<\/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\/2024\/12\/ex101_92019-nho-410.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4951,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4950","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4950","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=4950"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4950\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4951"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4950"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4950"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4950"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}