{"id":2004,"date":"2024-12-02T06:42:56","date_gmt":"2024-12-02T06:42:56","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/tim-hieu-ky-nang-phan-tich-du-lieu-truoc-khi-lap-bao-cao-tren-excel\/"},"modified":"2024-12-02T06:42:56","modified_gmt":"2024-12-02T06:42:56","slug":"tim-hieu-ky-nang-phan-tich-du-lieu-truoc-khi-lap-bao-cao-tren-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/tim-hieu-ky-nang-phan-tich-du-lieu-truoc-khi-lap-bao-cao-tren-excel\/","title":{"rendered":"T\u00ecm hi\u1ec3u k\u1ef9 n\u0103ng ph\u00e2n t\u00edch d\u1eef li\u1ec7u tr\u01b0\u1edbc khi l\u1eadp b\u00e1o c\u00e1o tr\u00ean Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Ph\u00e2n t\u00edch d\u1eef li\u1ec7u l\u00e0 m\u1ed9t c\u00f4ng vi\u1ec7c r\u1ea5t quan tr\u1ecdng gi\u00fap ch\u00fang ta c\u00f3 th\u1ec3 <strong>l\u1eadp b\u00e1o c\u00e1o<\/strong> t\u1ed1t h\u01a1n, tr\u00e1nh \u0111\u01b0\u1ee3c nh\u1eefng sai s\u00f3t, \u0111\u1ea3m b\u1ea3o \u0111\u01b0\u1ee3c t\u00ednh ch\u00ednh x\u00e1c c\u1ee7a b\u00e1o c\u00e1o. V\u1eady ph\u00e2n t\u00edch d\u1eef li\u1ec7u l\u00e0 ph\u1ea3i l\u00e0m nh\u1eefng c\u00f4ng vi\u1ec7c g\u00ec? Sau \u0111\u00e2y <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd t\u00ecm hi\u1ec3u v\u1ec1 k\u1ef9 n\u0103ng ph\u00e2n t\u00edch d\u1eef li\u1ec7u tr\u01b0\u1edbc khi l\u1eadp b\u00e1o c\u00e1o tr\u00ean Excel th\u00f4ng qua 1 b\u00e0i t\u1eadp sau:<\/em><\/p>\n<p>Gi\u1ea3 s\u1eed r\u1eb1ng b\u1ea1n l\u00e0m \u1edf v\u1ecb tr\u00ed tr\u01b0\u1edfng b\u1ed9 ph\u1eadn b\u00e1n h\u00e0ng. Tr\u01b0\u1edbc khi l\u1eadp \u0111\u01b0\u1ee3c<strong>\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/lap-bao-cao-tong-hop-tu-dong-voi-excel-va-vba.html\">b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p<\/a><\/strong> hay b\u1ea3ng b\u00e1o c\u00f3 chi ti\u1ebft th\u00ec b\u1ea1n ph\u1ea3i ph\u00e2n t\u00edch d\u1eef li\u1ec7u. Cu\u1ed1i th\u00e1ng b\u1ea1n nh\u1eadn \u0111\u01b0\u1ee3c 1 b\u1ea3ng d\u1eef li\u1ec7u v\u1ec1 b\u00e1n h\u00e0ng trong th\u00e1ng c\u1ee7a c\u1eeda h\u00e0ng m\u00ecnh nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18365\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ky-nang-phan-tich-du-lieu-bang-data.png\" width=\"622\" height=\"570\" title=\"ky-nang-phan-tich-du-lieu-bang-data\"><\/p>\n<p>B\u1ea1n ph\u1ea3i b\u00e1o c\u00e1o t\u1eeb nh\u1eefng\u00a0d\u1eef li\u1ec7u n\u00e0y. Nh\u01b0ng khoan\u00a0\u0111\u00e3 n\u00e0o, b\u1ea1n c\u00f3 ch\u1eafc ch\u1eafn v\u1ec1 nh\u1eefng d\u1eef li\u1ec7u n\u00e0y\u00a0ch\u01b0a? Li\u1ec7u c\u00f3 sai s\u00f3t g\u00ec v\u1ec1 tr\u00ecnh b\u00e0y, l\u1ed7i ch\u00ednh t\u1ea3, l\u1ed7i\u00a0\u0111\u1ecbnh d\u1ea1ng\u2026 khi\u1ebfn cho vi\u1ec7c b\u00e1o c\u00e1o c\u1ee7a b\u1ea1n c\u00f3 th\u1ec3 b\u1ecb sai kh\u00f4ng? Vi\u1ec7c c\u1ea7n l\u00e0m l\u00fac n\u00e0y ch\u00ednh l\u00e0 b\u1ea1n c\u1ea7n ph\u00e2n t\u00edch b\u1ea3ng d\u1eef li\u1ec7u\u00a0\u0111\u1ec3\u00a0\u0111\u1ea3m b\u1ea3o d\u1eef li\u1ec7u ph\u1ee5c v\u1ee5 cho vi\u1ec7c b\u00e1o c\u00e1o l\u00e0 lu\u00f4n ch\u00ednh x\u00e1c.<\/p>\n<p>Xem th\u00eam:\u00a0<strong>H\u01b0\u1edbng d\u1eabn c\u00e1ch <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-xay-dung-bang-du-lieu-chuan-de-lap-bao-cao-tren-excel.html\">x\u00e2y d\u1ef1ng b\u1ea3ng d\u1eef li\u1ec7u<\/a> chu\u1ea9n \u0111\u1ec3 l\u1eadp b\u00e1o c\u00e1o tr\u00ean Excel<\/strong><\/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-674d56ef83eb3\" 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\/tim-hieu-ky-nang-phan-tich-du-lieu-truoc-khi-lap-bao-cao-tren-excel.html#1_Dac_diem_ve_loai_du_lieu_trong_Excel\" title=\"1. \u0110\u1eb7c \u0111i\u1ec3m v\u1ec1\u00a0lo\u1ea1i d\u1eef li\u1ec7u trong\u00a0Excel\">1. \u0110\u1eb7c \u0111i\u1ec3m v\u1ec1\u00a0lo\u1ea1i d\u1eef li\u1ec7u trong\u00a0Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/tim-hieu-ky-nang-phan-tich-du-lieu-truoc-khi-lap-bao-cao-tren-excel.html#2_Ky_thuat_phan_tich_du_lieu\" title=\"2. K\u1ef9 thu\u1eadt ph\u00e2n t\u00edch d\u1eef li\u1ec7u\">2. K\u1ef9 thu\u1eadt ph\u00e2n t\u00edch d\u1eef li\u1ec7u<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/tim-hieu-ky-nang-phan-tich-du-lieu-truoc-khi-lap-bao-cao-tren-excel.html#a_Du_lieu_Ngay\" title=\"a. D\u1eef li\u1ec7u Ng\u00e0y\">a. D\u1eef li\u1ec7u Ng\u00e0y<\/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\/tim-hieu-ky-nang-phan-tich-du-lieu-truoc-khi-lap-bao-cao-tren-excel.html#b_Du_lieu_dang_Text\" title=\"b. D\u1eef li\u1ec7u d\u1ea1ng Text\">b. D\u1eef li\u1ec7u d\u1ea1ng Text<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/tim-hieu-ky-nang-phan-tich-du-lieu-truoc-khi-lap-bao-cao-tren-excel.html#c_Du_lieu_dang_So\" title=\"c. D\u1eef li\u1ec7u d\u1ea1ng S\u1ed1\">c. D\u1eef li\u1ec7u d\u1ea1ng S\u1ed1<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/tim-hieu-ky-nang-phan-tich-du-lieu-truoc-khi-lap-bao-cao-tren-excel.html#3_Luyen_tap_ky_nang_phan_tich_du_lieu\" title=\"3. Luy\u1ec7n t\u1eadp k\u1ef9 n\u0103ng ph\u00e2n t\u00edch\u00a0d\u1eef li\u1ec7u\">3. Luy\u1ec7n t\u1eadp k\u1ef9 n\u0103ng ph\u00e2n t\u00edch\u00a0d\u1eef li\u1ec7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/tim-hieu-ky-nang-phan-tich-du-lieu-truoc-khi-lap-bao-cao-tren-excel.html#4_Tong_ket\" title=\"4. T\u1ed5ng k\u1ebft\">4. T\u1ed5ng k\u1ebft<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"1_Dac_diem_ve_loai_du_lieu_trong_Excel\"><\/span>1. \u0110\u1eb7c \u0111i\u1ec3m v\u1ec1\u00a0lo\u1ea1i d\u1eef li\u1ec7u trong\u00a0Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>D\u1eef li\u1ec7u trong\u00a0Excel g\u1ed3m 3 lo\u1ea1i ch\u00ednh:<\/p>\n<ul>\n<li>Lo\u1ea1i Text: l\u00e0 d\u1ea1ng k\u00fd t\u1ef1 ch\u1eef, chu\u1ed7i k\u00fd t\u1ef1, kh\u00f4ng ph\u1ea3i l\u00e0 d\u1ea1ng s\u1ed1<\/li>\n<li>Lo\u1ea1i Number: l\u00e0 d\u1ea1ng s\u1ed1, g\u1ed3m c\u00e1c lo\u1ea1i Number, Accounting, Currency, Percentage\u2026<\/li>\n<li>Lo\u1ea1i Date: l\u00e0 d\u1ea1ng ng\u00e0y th\u00e1ng. V\u1ec1 b\u1ea3n ch\u1ea5t lo\u1ea1i Date v\u1eabn l\u00e0 lo\u1ea1i Number nh\u01b0ng\u00a0\u0111\u01b0\u1ee3c chuy\u1ec3n sang 1 nh\u00f3m ri\u00eang<\/li>\n<\/ul>\n<p>Do\u00a0\u0111\u00f3 trong m\u1ed7i tr\u01b0\u1eddng d\u1eef li\u1ec7u (c\u1ed9t d\u1eef li\u1ec7u) ph\u1ea3i th\u1ed1ng nh\u1ea5t c\u00f9ng chung 1 lo\u1ea1i d\u1eef li\u1ec7u\u00a0\u0111\u1ec3\u00a0\u0111\u1ea3m b\u1ea3o t\u00ednh th\u1ed1ng nh\u1ea5t v\u1ec1 d\u1eef li\u1ec7u.<\/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-149.gif\" title=\"ex101_92019-nho-149\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>D\u1ef1a v\u00e0o b\u1ea3ng d\u1eef li\u1ec7u tr\u00ean ch\u00fang ta th\u1ea5y:<\/p>\n<ul>\n<li>D\u1eef li\u1ec7u lo\u1ea1i Date l\u00e0 c\u1ed9t Ng\u00e0y (c\u1ed9t A)<\/li>\n<li>D\u1eef li\u1ec7u lo\u1ea1i Text l\u00e0 c\u1ed9t Nh\u00e2n vi\u00ean b\u00e1n h\u00e0ng (c\u1ed9t B)\u00a0v\u00e0 T\u00ean m\u1eb7t h\u00e0ng (c\u1ed9t C)<\/li>\n<li>D\u1eef li\u1ec7u lo\u1ea1i Number l\u00e0 c\u1ed9t S\u1ed1 l\u01b0\u1ee3ng (c\u1ed9t D),\u00a0\u0110\u01a1n gi\u00e1 (c\u1ed9t E), Th\u00e0nh ti\u1ec1n (c\u1ed9t F)<\/li>\n<\/ul>\n<p>Y\u00eau c\u1ea7u ph\u1ea3i l\u00e0m:<\/p>\n<ul>\n<li>C\u1ed9t d\u1eef li\u1ec7u Ng\u00e0y:\u00a0\u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u v\u1ec1 d\u1ea1ng Ng\u00e0y th\u00e1ng thay v\u00ec hi\u1ec3n th\u1ecb d\u01b0\u1edbi d\u1ea1ng s\u1ed1 nh\u01b0 ban\u00a0\u0111\u1ea7u. Ki\u1ec3m tra d\u1eef li\u1ec7u trong c\u1ed9t Ng\u00e0y c\u00f3 n\u1ed9i dung n\u00e0o kh\u00f4ng\u00a0\u0111\u00fang\u00a0\u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng kh\u00f4ng, c\u00f3 l\u1ed7i v\u1ec1 d\u1eef li\u1ec7u d\u1ea1ng ng\u00e0y th\u00e1ng kh\u00f4ng<\/li>\n<li>C\u1ed9t d\u1eef li\u1ec7u Text: c\u00f3 n\u1ed9i dung n\u00e0o b\u1ecb th\u1eeba d\u1ea5u c\u00e1ch kh\u00f4ng, c\u00e1c\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng tr\u00ean\u00a0\u0111\u01b0\u1ee3c nh\u1eadp theo danh s\u00e1ch c\u00f3 n\u1ed9i dung n\u00e0o n\u1eb1m ngo\u00e0i danh s\u00e1ch kh\u00f4ng, c\u00f3 n\u1ed9i dung n\u00e0o sai l\u1ed7i ch\u00ednh t\u1ea3 kh\u00f4ng\u2026<\/li>\n<li>C\u1ed9t d\u1eef li\u1ec7u Number: \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u v\u1ec1 d\u1ea1ng S\u1ed1 c\u00f3 d\u1ea5u ng\u0103n c\u00e1ch h\u00e0ng ngh\u00ecn. Ki\u1ec3m tra d\u1eef li\u1ec7u xem c\u00f3 n\u1ed9i dung n\u00e0o kh\u00f4ng ph\u1ea3i l\u00e0 d\u1ea1ng s\u1ed1 kh\u00f4ng<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"2_Ky_thuat_phan_tich_du_lieu\"><\/span>2. K\u1ef9 thu\u1eadt ph\u00e2n t\u00edch d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"a_Du_lieu_Ngay\"><\/span>a. D\u1eef li\u1ec7u Ng\u00e0y<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>\u0110\u1ec3\u00a0\u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u ng\u00e0y<\/strong>, ch\u00fang ta s\u1ebd l\u00e0m c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<ul>\n<li>Ch\u1ecdn to\u00e0n b\u1ed9 c\u1ed9t d\u1eef li\u1ec7u<\/li>\n<li>B\u1ea5m chu\u1ed9t ph\u1ea3i ch\u1ecdn <strong>Format Cells<\/strong> cho c\u1ed9t\u00a0\u0111\u00f3<\/li>\n<li>Trong Format cells ch\u1ecdn d\u1ea1ng Date ho\u1eb7c Custom\/ M\u1ee5c type nh\u1eadp\u00a0dd\/mm\/yyyy<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18367\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/date-data-format-cells.png\" width=\"653\" height=\"446\" title=\"date-data-format-cells\"><\/p>\n<p><strong>K\u1ef9 thu\u1eadt s\u1eeda l\u1ed7i d\u1eef li\u1ec7u d\u1ea1ng ng\u00e0y th\u00e1ng<\/strong>: Xem t\u1ea1i b\u00e0i vi\u1ebft:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-xu-ly-loi-du-lieu-ngay-thang-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch x\u1eed l\u00fd l\u1ed7i d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><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<h3><span class=\"ez-toc-section\" id=\"b_Du_lieu_dang_Text\"><\/span>b. D\u1eef li\u1ec7u d\u1ea1ng Text<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1eb7c tr\u01b0ng c\u1ee7a d\u1eef li\u1ec7u d\u1ea1ng Text l\u00e0:<\/p>\n<ul>\n<li>D\u1ec5 c\u00f3 l\u1ed7i sai do b\u1ea5t c\u1ea9n khi nh\u1eadp, khi\u00a0\u0111\u00e1nh m\u00e1y<\/li>\n<li>Kh\u00f3 s\u1eeda l\u1ed7i do c\u00e1c l\u1ed7i kh\u00f4ng c\u00f3 t\u00ednh quy lu\u1eadt, d\u1eef li\u1ec7u d\u1ea1ng Text kh\u00f3 x\u1eed l\u00fd h\u01a1n c\u00e1c d\u1ea1ng kh\u00e1c<\/li>\n<li>Kh\u00f4ng c\u00f3 quy\u00a0\u0111\u1ecbnh hay nguy\u00ean t\u1eafc v\u1ec1 Format.<\/li>\n<\/ul>\n<p>Do\u00a0\u0111\u00f3\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ea1ng text c\u1ea7n ch\u00fa\u00a0\u00fd c\u00e1c k\u1ef9 thu\u1eadt sau:<\/p>\n<ul>\n<li>L\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng, l\u1ecdc d\u1eef li\u1ec7u kh\u00f4ng tr\u00f9ng: s\u1eed d\u1ee5ng <strong>Advanced Filter<\/strong> ho\u1eb7c\u00a0<strong>Remove duplicates<\/strong><\/li>\n<li>Ph\u00e1t hi\u1ec7n d\u1eef li\u1ec7u sai, kh\u00f4ng c\u00f3 trong danh s\u00e1ch b\u1eb1ng <strong>Conditional formatting<\/strong><\/li>\n<li>S\u1eed d\u1ee5ng\u00a0<strong>Text to column<\/strong>\u00a0\u0111\u1ec3 ph\u00e2n t\u00e1ch d\u1eef li\u1ec7u ra nhi\u1ec1u c\u1ed9t<\/li>\n<\/ul>\n<p><strong>K\u1ef9 thu\u1eadt s\u1eeda l\u1ed7i d\u1eef li\u1ec7u d\u1ea1ng Text<\/strong>: Xem t\u1ea1i b\u00e0i vi\u1ebft<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-xu-ly-loi-du-lieu-dang-text-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch x\u1eed l\u00fd l\u1ed7i d\u1eef li\u1ec7u d\u1ea1ng Text trong Excel<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"c_Du_lieu_dang_So\"><\/span>c. D\u1eef li\u1ec7u d\u1ea1ng S\u1ed1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>\u0110\u1ec3\u00a0\u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u S\u1ed1<\/strong>, ch\u00fang ta s\u1ebd l\u00e0m c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<ul>\n<li>Ch\u1ecdn to\u00e0n b\u1ed9 c\u1ed9t d\u1eef li\u1ec7u<\/li>\n<li>B\u1ea5m chu\u1ed9t ph\u1ea3i ch\u1ecdn\u00a0<strong>Format Cells<\/strong>\u00a0cho c\u1ed9t\u00a0\u0111\u00f3<\/li>\n<li>Trong <strong>Format Cells<\/strong> ch\u1ecdn <strong>Number<\/strong>. <strong>Decimal places<\/strong> (s\u1ed1 sau d\u1ea5u ph\u1ea9y) ch\u1ecdn l\u00e0 0 v\u00ec kh\u00f4ng c\u00f3 s\u1ed1\u00a0sau d\u1ea5u ph\u1ea9y, ch\u1ecdn d\u1ea5u ng\u0103n c\u00e1ch ph\u1ea7n ngh\u00ecn\u00a0\u0111\u00e1nh d\u1ea5u t\u00edch v\u00e0o\u00a0\u00f4\u00a0<strong>Use 1000 separator<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18371\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/number-data-format-cells.png\" width=\"1010\" height=\"492\" title=\"number-data-format-cells\"><\/p>\n<p><strong>K\u1ef9 thu\u1eadt s\u1eeda l\u1ed7i d\u1eef li\u1ec7u d\u1ea1ng Number<\/strong>: Xem t\u1ea1i b\u00e0i vi\u1ebft<\/p>\n<p style=\"padding-left: 30px\"><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 d\u1ea1ng\u00a0S\u1ed1\u00a0trong Excel<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"3_Luyen_tap_ky_nang_phan_tich_du_lieu\"><\/span>3. Luy\u1ec7n t\u1eadp k\u1ef9 n\u0103ng ph\u00e2n t\u00edch\u00a0d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00e1c b\u1ea1n t\u1ea3i v\u1ec1 b\u1ea3ng d\u1eef li\u1ec7u m\u1eabu\u00a0t\u1ea1i: <a href=\"http:\/\/bit.ly\/2M1NHR6\">http:\/\/bit.ly\/2M1NHR6<\/a><\/p>\n<p>Trong b\u00e0i t\u1eadp n\u00e0y ch\u00fang ta s\u1ebd l\u00e0m th\u1eed v\u1edbi vi\u1ec7c ph\u00e2n t\u00edch c\u00e1c d\u1eef li\u1ec7u d\u1ea1ng Text xem c\u00f3 l\u1ed7i g\u00ec kh\u00f4ng nh\u00e9.<\/p>\n<p><strong>C\u1ed9t Nh\u00e2n vi\u00ean b\u00e1n h\u00e0ng<\/strong><\/p>\n<p>\u0110\u1ec3 ki\u1ec3m tra d\u1eef li\u1ec7u nh\u1eadp t\u1ea1i c\u1ed9t n\u00e0y c\u00f3 ch\u00ednh x\u00e1c v\u1edbi c\u1ed9t Danh s\u00e1ch nh\u00e2n vi\u00ean hay kh\u00f4ng, ch\u00fang ta d\u00f9ng Conditional formatting\u00a0\u0111\u1ec3 ki\u1ec3m tra nh\u01b0 sau:<\/p>\n<p>\u0110\u1ebfm t\u1eebng n\u1ed9i dung \u1edf c\u1ed9t B, b\u1eaft \u0111\u1ea7u t\u1eeb \u00f4 B2 trong danh s\u00e1ch H2:H6. N\u1ebfu k\u1ebft qu\u1ea3 h\u00e0m\u00a0\u0111\u1ebfm ra = 0 t\u1ee9c l\u00e0 gi\u00e1 tr\u1ecb\u00a0\u0111\u00f3 kh\u00f4ng c\u00f3 trong danh s\u00e1ch, t\u1ee9c l\u00e0 nh\u1eadp sai.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18378\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/text-data-cf-check-error.png\" width=\"1033\" height=\"483\" title=\"text-data-cf-check-error\"><\/p>\n<p>K\u1ebft qu\u1ea3\u00a0\u00f4 B4 cho ch\u00fang ta bi\u1ebft\u00a0\u00f4 n\u00e0y nh\u1eadp sai. D\u00f9 hi\u1ec3n th\u1ecb b\u1eb1ng m\u1eaft th\u01b0\u1eddng kh\u00f4ng th\u1ea5y sai nh\u01b0ng v\u1ec1 b\u1ea3n ch\u1ea5t d\u1eef li\u1ec7u l\u00e0 sai, c\u00f3 l\u1ed7i.<\/p>\n<p>Do\u00a0\u0111\u00f3 ch\u00fang ta s\u1ebd s\u1eeda l\u1ea1i n\u1ed9i dung t\u1ea1i\u00a0\u00f4 n\u00e0y cho\u00a0\u0111\u00fang.<\/p>\n<p>C\u00e1c n\u1ed9i dung kh\u00e1c c\u00e1c b\u1ea1n h\u00e3y luy\u1ec7n t\u1eadp l\u00e0m v\u00e0 ph\u00e1t hi\u1ec7n c\u00e1c l\u1ed7i nh\u00e9.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"4_Tong_ket\"><\/span>4. T\u1ed5ng k\u1ebft<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>B\u1ea1n l\u00e0m t\u1ed1t c\u00e1c b\u00e0i t\u1eadp, nh\u01b0ng b\u1ea1n l\u1ea1i kh\u00f4ng t\u1ef1 tay l\u00e0m\u00a0\u0111\u01b0\u1ee3c c\u00e1c b\u00e1o c\u00e1o trong c\u00f4ng vi\u1ec7c, nguy\u00ean nh\u00e2n ch\u00ednh l\u00e0 vi\u1ec7c b\u1ea1n kh\u00f4ng bi\u1ebft c\u00e1ch ph\u00e2n t\u00edch d\u1eef li\u1ec7u. B\u1edfi th\u00f4ng th\u01b0\u1eddng c\u00e1c b\u00e0i t\u1eadp cho s\u1eb5n th\u01b0\u1eddng b\u1ecf qua b\u01b0\u1edbc ph\u00e2n t\u00edch d\u1eef li\u1ec7u, gi\u1ea3\u00a0\u0111\u1ecbnh r\u1eb1ng d\u1eef li\u1ec7u lu\u00f4n\u00a0\u0111\u00fang. Trong khi\u00a0\u0111\u00f3 th\u1ef1c t\u1ebf l\u1ea1i cho th\u1ea5y ng\u01b0\u1eddi nh\u1eadp d\u1eef li\u1ec7u v\u00e0o\u00a0excel ho\u1eb7c khi tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb ph\u1ea7n m\u1ec1m kh\u00e1c ra\u00a0Excel l\u1ea1i g\u00e2y ra r\u1ea5t nhi\u1ec1u l\u1ed7i d\u1eef li\u1ec7u. N\u1ebfu kh\u00f4ng c\u00f3 k\u1ef9 n\u0103ng ph\u00e2n t\u00edch d\u1eef li\u1ec7u th\u00ec kh\u00f4ng th\u1ec3 ra\u00a0\u0111\u01b0\u1ee3c b\u00e1o c\u00e1o\u00a0\u0111\u00fang.<\/p>\n<p>Ph\u00e2n t\u00edch d\u1eef li\u1ec7u l\u00e0 1 \u201c<strong>k\u1ef9 n\u0103ng<\/strong>\u201c, n\u00f3 ph\u1ee5 thu\u1ed9c v\u00e0o kinh nghi\u1ec7m v\u00e0 s\u1ef1 luy\u1ec7n t\u1eadp nhi\u1ec1u. B\u1ea1n c\u00e0ng luy\u1ec7n t\u1eadp nhi\u1ec1u th\u00ec c\u00e0ng gi\u1ecfi trong vi\u1ec7c ph\u00e2n t\u00edch d\u1eef li\u1ec7u. C\u00f4ng c\u1ee5\u00a0\u0111\u1ec3 ph\u00e2n t\u00edch th\u00ec r\u1ea5t\u00a0\u0111a d\u1ea1ng, kh\u00f3 c\u00f3 th\u1ec3 nh\u1edb h\u1ebft\u00a0\u0111\u01b0\u1ee3c. Tuy nhi\u00ean ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t v\u00e0i c\u00f4ng c\u1ee5\u00a0\u0111\u1eb7c tr\u01b0ng, hay s\u1eed d\u1ee5ng nh\u1ea5t\u00a0\u0111\u1ec3 luy\u1ec7n t\u1eadp ph\u00e1t tri\u1ec3n k\u1ef9 n\u0103ng n\u00e0y.<\/p>\n<p>Ngo\u00e0i ra H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n \u201c<a href=\"http:\/\/bit.ly\/2kPC4QS\"><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><\/a>\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. Chi ti\u1ebft kh\u00f3a h\u1ecdc xem t\u1ea1i:<\/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-149.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2005,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2004","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\/2004","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=2004"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2004\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2005"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2004"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2004"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2004"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}