{"id":12339,"date":"2024-06-15T09:27:46","date_gmt":"2024-06-15T02:27:46","guid":{"rendered":"https:\/\/arito.vn\/?p=12339"},"modified":"2025-06-16T16:53:50","modified_gmt":"2025-06-16T09:53:50","slug":"huong-dan-tao-bang-cham-cong-tren-excel-day-du-va-chi-tiet-nhat","status":"publish","type":"post","link":"https:\/\/arito.vn\/en\/huong-dan-tao-bang-cham-cong-tren-excel-day-du-va-chi-tiet-nhat\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn t\u1ea1o b\u1ea3ng ch\u1ea5m c\u00f4ng tr\u00ean excel \u0111\u1ea7y \u0111\u1ee7 v\u00e0 chi ti\u1ebft nh\u1ea5t"},"content":{"rendered":"<p style=\"text-align: center;\"><span style=\"font-size: 28px;\"><strong>T\u1ea3i ng\u00e0y 17+ <a href=\"https:\/\/arito.vn\/en\/mau-bang-cham-cong-de-su-dung-va-hieu-qua\/\">m\u1eabu b\u1ea3ng ch\u1ea5m c\u00f4ng<\/a> tr\u00ean excel\/ word ti\u1ec7n l\u1ee3i<\/strong><\/span><\/p>\n<p><span style=\"font-weight: 400;\">Kh\u00f4ng th\u1ec3 ph\u1ee7 nh\u1eadn r\u1eb1ng b\u1ea3ng ch\u1ea5m c\u00f4ng Excel l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 kh\u00f4ng th\u1ec3 thi\u1ebfu c\u1ee7a m\u1ed7i doanh nghi\u1ec7p, gi\u00fap ch\u00fang ta t\u1ef1 tin h\u01a1n trong vi\u1ec7c qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1. H\u00e3y c\u00f9ng <strong><a href=\"https:\/\/arito.vn\/en\/\">Arito Solutions<\/a><\/strong> kh\u00e1m ph\u00e1 c\u00e1ch <strong><a href=\"https:\/\/arito.vn\/en\/huong-dan-tao-bang-cham-cong-tren-excel-day-du-va-chi-tiet-nhat\/\">t\u1ea1o b\u1ea3ng ch\u1ea5m c\u00f4ng tr\u00ean Excel<\/a><\/strong> \u0111\u1ec3 n\u00e2ng cao hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n.<\/span><\/p>\n<h2><b>1. X\u00e1c \u0111\u1ecbnh m\u00f4 h\u00ecnh b\u1ea3ng ch\u1ea5m c\u00f4ng tr\u00ean excel<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 t\u1ea1o b\u1ea3ng ch\u1ea5m c\u00f4ng tr\u00ean Excel m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3, ng\u01b0\u1eddi l\u1eadp c\u1ea7n c\u00f3 m\u1ed9t k\u1ebf ho\u1ea1ch c\u1ee5 th\u1ec3 v\u1ec1 c\u1ea5u tr\u00fac c\u1ee7a b\u1ea3ng ch\u1ea5m c\u00f4ng. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 nh\u1eefng g\u1ee3i \u00fd \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 h\u00ecnh dung \u0111\u01b0\u1ee3c m\u00f4 h\u00ecnh b\u1ea3ng ch\u1ea5m c\u00f4ng:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u1ed1 l\u01b0\u1ee3ng Sheet: M\u1ed9t b\u1ea3ng ch\u1ea5m c\u00f4ng ho\u00e0n ch\u1ec9nh s\u1ebd bao g\u1ed3m 13 sheet, trong \u0111\u00f3 1 sheet s\u1ebd d\u00e0nh cho vi\u1ec7c li\u1ec7t k\u00ea danh s\u00e1ch to\u00e0n b\u1ed9 nh\u00e2n vi\u00ean trong c\u00f4ng ty, v\u00e0 12 sheet c\u00f2n l\u1ea1i s\u1ebd t\u01b0\u01a1ng \u1ee9ng v\u1edbi 12 th\u00e1ng trong n\u0103m.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u1ed1 l\u01b0\u1ee3ng nh\u00e2n vi\u00ean tr\u00ean m\u1ed7i sheet: T\u00f9y thu\u1ed9c v\u00e0o t\u1ed5ng s\u1ed1 nh\u00e2n vi\u00ean trong c\u00f4ng ty, s\u1ed1 l\u01b0\u1ee3ng nh\u00e2n vi\u00ean tr\u00ean m\u1ed7i sheet c\u00f3 th\u1ec3 dao \u0111\u1ed9ng t\u1eeb kho\u1ea3ng 20 nh\u00e2n vi\u00ean tr\u1edf l\u00ean.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">K\u00fd hi\u1ec7u ch\u1ea5m c\u00f4ng: M\u1ed7i nh\u00e2n vi\u00ean s\u1ebd c\u00f3 m\u1ed9t k\u00fd hi\u1ec7u ch\u1ea5m c\u00f4ng ri\u00eang, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng xuy\u00ean su\u1ed1t trong 12 th\u00e1ng. \u0110i\u1ec1u n\u00e0y gi\u00fap ph\u00e2n bi\u1ec7t v\u00e0 nh\u1eadn di\u1ec7n d\u1ec5 d\u00e0ng.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">C\u1ea5u tr\u00fac c\u1ed9t: B\u1ea3ng ch\u1ea5m c\u00f4ng c\u1ea7n ph\u1ea3i c\u00f3 \u0111\u1ea7y \u0111\u1ee7 c\u00e1c c\u1ed9t cho th\u00e1ng, ng\u00e0y, v\u00e0 th\u1ee9. \u0110\u1ec3 ph\u00e2n bi\u1ec7t c\u00e1c ng\u00e0y cu\u1ed1i tu\u1ea7n, c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u00e0u s\u1eafc kh\u00e1c nhau cho th\u1ee9 7 v\u00e0 Ch\u1ee7 nh\u1eadt.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ch\u1ea5m c\u00f4ng: C\u00f4ng c\u1ee7a nh\u00e2n vi\u00ean s\u1ebd \u0111\u01b0\u1ee3c ghi v\u00e0o c\u1ed9t t\u01b0\u01a1ng \u1ee9ng v\u1edbi ng\u00e0y, v\u00e0 t\u1ed5ng k\u1ebft v\u00e0o ng\u00e0y cu\u1ed1i c\u00f9ng c\u1ee7a m\u1ed7i th\u00e1ng.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Li\u00ean k\u1ebft gi\u1eefa c\u00e1c sheet: C\u00f3 th\u1ec3 th\u00eam li\u00ean k\u1ebft gi\u1eefa c\u00e1c th\u00e1ng v\u1edbi nhau \u0111\u1ec3 d\u1ec5 d\u00e0ng chuy\u1ec3n \u0111\u1ed5i v\u00e0 thao t\u00e1c tr\u00ean c\u00e1c b\u1ea3ng ch\u1ea5m c\u00f4ng.<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">Nh\u1eefng g\u1ee3i \u00fd tr\u00ean s\u1ebd gi\u00fap b\u1ea1n c\u00f3 c\u00e1i nh\u00ecn r\u00f5 r\u00e0ng h\u01a1n v\u1ec1 c\u00e1ch t\u1ed5 ch\u1ee9c v\u00e0 thi\u1ebft k\u1ebf b\u1ea3ng ch\u1ea5m c\u00f4ng tr\u00ean Excel, t\u1eeb \u0111\u00f3 gi\u00fap b\u1ea1n \u0111\u1ea1t \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 mong mu\u1ed1n m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i ch\u1ec9nh s\u1eeda nhi\u1ec1u l\u1ea7n.<\/span><\/p>\n<h2><b>2. H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u00e0m b\u1ea3ng ch\u1ea5m c\u00f4ng tr\u00ean Excel<\/b><\/h2>\n<h3><b>B\u01b0\u1edbc 1: Thi\u1ebft l\u1eadp b\u1ed1 c\u1ee5c c\u00e1c sheet:<\/b><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u0110\u1ea7u ti\u00ean, b\u1ea1n c\u1ea7n t\u1ea1o hai sheet: m\u1ed9t cho <strong><a href=\"https:\/\/arito.vn\/en\/mau-danh-sach-nhan-vien-nhan-su-chi-tiet\/\">danh s\u00e1ch nh\u00e2n vi\u00ean<\/a><\/strong> (DSNV) v\u00e0 m\u1ed9t cho th\u00e1ng m\u1eabu (v\u00ed d\u1ee5: Th\u00e1ng 1). \u0110i\u1ec1u n\u00e0y gi\u00fap t\u1ed5 ch\u1ee9c v\u00e0 qu\u1ea3n l\u00fd d\u1eef li\u1ec7u d\u1ec5 d\u00e0ng h\u01a1n.<\/span><\/li>\n<\/ul>\n<h3><b>B\u01b0\u1edbc 2: T\u1ea1o sheet Danh s\u00e1ch nh\u00e2n vi\u00ean:<\/b><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">T\u1ea1o c\u00e1c c\u1ed9t &#8220;T\u00ean&#8221; v\u00e0 &#8220;M\u00e3 nh\u00e2n vi\u00ean&#8221;, c\u0169ng nh\u01b0 c\u00e1c th\u00f4ng tin kh\u00e1c v\u1ec1 nh\u00e2n vi\u00ean nh\u01b0 qu\u00ea qu\u00e1n, ng\u00e0y sinh, s\u1ed1 CCCD\/CMND, ng\u00e0y b\u1eaft \u0111\u1ea7u l\u00e0m vi\u1ec7c. \u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea1n c\u00f3 m\u1ed9t c\u01a1 s\u1edf d\u1eef li\u1ec7u nh\u00e2n vi\u00ean \u0111\u1ea7y \u0111\u1ee7 v\u00e0 r\u00f5 r\u00e0ng.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u0110\u1ecbnh d\u1ea1ng c\u00e1c c\u1ed9t li\u00ean quan \u0111\u1ebfn ng\u00e0y th\u00e1ng \u0111\u1ec3 hi\u1ec3n th\u1ecb \u0111\u1ed3ng b\u1ed9 v\u00e0 d\u1ec5 \u0111\u1ecdc.<\/span><\/li>\n<\/ul>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-12340\" src=\"https:\/\/arito.vn\/wp-content\/uploads\/2024\/06\/bang-cham-cong-excel-1-danh-sach-nhan-vien.jpg\" alt=\"t\u1ea1o b\u1ea3ng ch\u1ea5m c\u00f4ng\" width=\"1280\" height=\"983\" \/><\/p>\n<h3><b>B\u01b0\u1edbc 3: T\u1ea1o sheet cho c\u00e1c th\u00e1ng:<\/b><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">T\u1ea1o khung cho b\u1ea3ng ch\u1ea5m c\u00f4ng v\u1edbi c\u00e1c th\u00f4ng tin c\u1ea7n thi\u1ebft nh\u01b0 ti\u00eau \u0111\u1ec1, th\u00e1ng, b\u1ed9 ph\u1eadn ch\u1ea5m c\u00f4ng, \u0111\u1ecbnh m\u1ee9c ng\u00e0y c\u00f4ng trong th\u00e1ng. \u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea1n t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch logic v\u00e0 c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng t\u00ecm ki\u1ebfm.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">T\u1ea1o c\u00e1c c\u1ed9t bao g\u1ed3m m\u00e3 nh\u00e2n vi\u00ean, t\u00ean nh\u00e2n vi\u00ean, ng\u00e0y trong th\u00e1ng (31 c\u1ed9t t\u01b0\u01a1ng \u1ee9ng v\u1edbi 31 ng\u00e0y), c\u1ed9t quy ra c\u00f4ng, v\u00e0 c\u1ed9t ghi ch\u00fa. \u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea1n ghi nh\u1eadn th\u00f4ng tin ch\u1ea5m c\u00f4ng m\u1ed9t c\u00e1ch chi ti\u1ebft.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">C\u0103n \u0111\u1ed9 r\u1ed9ng c\u1ee7a c\u00e1c c\u1ed9t sao cho g\u1ecdn g\u00e0ng v\u00e0 d\u1ec5 nh\u00ecn, gi\u00fap vi\u1ec7c nh\u1eadp li\u1ec7u v\u00e0 \u0111\u1ecdc d\u1eef li\u1ec7u tr\u1edf n\u00ean thu\u1eadn ti\u1ec7n h\u01a1n.<\/span><\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-12341\" src=\"https:\/\/arito.vn\/wp-content\/uploads\/2024\/06\/bang-cham-cong-excel-3-sheet-thang-1.jpg\" alt=\"H\u01b0\u1edbng d\u1eabn t\u1ea1o b\u1ea3ng ch\u1ea5m c\u00f4ng tr\u00ean excel \u0111\u1ea7y \u0111\u1ee7 v\u00e0 chi ti\u1ebft nh\u1ea5t\" width=\"1280\" height=\"984\" \/><\/p>\n<h3><b>B\u01b0\u1edbc 4: T\u1ea1o ng\u00e0y th\u00e1ng trong b\u1ea3ng ch\u1ea5m c\u00f4ng:<\/b><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">X\u00e1c \u0111\u1ecbnh n\u0103m s\u1eed d\u1ee5ng v\u00e0 nh\u1eadp v\u00e0o \u00f4 t\u01b0\u01a1ng \u1ee9ng \u0111\u1ec3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng cho vi\u1ec7c t\u00ednh to\u00e1n sau n\u00e0y.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">T\u1ea1o ng\u00e0y \u0111\u1ea7u ti\u00ean c\u1ee7a th\u00e1ng v\u00e0 c\u00e1c ng\u00e0y ti\u1ebfp theo trong th\u00e1ng. \u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea1n t\u1ef1 \u0111\u1ed9ng t\u1ea1o ra l\u1ecbch l\u00e0m vi\u1ec7c cho m\u1ed7i th\u00e1ng m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u0110\u1ed5i m\u00e0u cho c\u00e1c ng\u00e0y cu\u1ed1i tu\u1ea7n \u0111\u1ec3 ph\u00e2n bi\u1ec7t d\u1ec5 d\u00e0ng gi\u1eefa c\u00e1c ng\u00e0y l\u00e0m vi\u1ec7c v\u00e0 ng\u00e0y ngh\u1ec9.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u0110i\u1ec1u ch\u1ec9nh c\u00e1c \u00f4 ng\u00e0y tr\u1ed1ng (nh\u01b0 ng\u00e0y 29, 30, 31 c\u1ee7a c\u00e1c th\u00e1ng kh\u00f4ng \u0111\u1ec1u \u0111\u1eb7n) \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng b\u00f4i x\u00e1m v\u00e0 kh\u00f4ng hi\u1ec3n th\u1ecb ng\u00e0y kh\u00f4ng t\u1ed3n t\u1ea1i.<\/span><\/li>\n<\/ul>\n<h3><b>B\u01b0\u1edbc 5: \u0110\u1eb7t k\u00fd hi\u1ec7u ch\u1ea5m c\u00f4ng t\u01b0\u01a1ng \u1ee9ng:<\/b><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u0110\u1eb7t c\u00e1c k\u00fd hi\u1ec7u ch\u1ea5m c\u00f4ng ph\u00f9 h\u1ee3p cho t\u1eebng lo\u1ea1i c\u00f4ng vi\u1ec7c (v\u00ed d\u1ee5: ng\u00e0y c\u00f4ng, n\u1eeda ng\u00e0y c\u00f4ng, ngh\u1ec9 h\u01b0\u1edfng l\u01b0\u01a1ng, ngh\u1ec9 kh\u00f4ng l\u01b0\u01a1ng, ngh\u1ec9 \u1ed1m \u0111au). \u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea1n ghi nh\u1eadn v\u00e0 ph\u00e2n lo\u1ea1i c\u00f4ng vi\u1ec7c c\u1ee7a nh\u00e2n vi\u00ean m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng v\u00e0 ch\u00ednh x\u00e1c.<\/span><\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-12342\" src=\"https:\/\/arito.vn\/wp-content\/uploads\/2024\/06\/bang-cham-cong-excel-19-dat-ky-hieu.jpg\" alt=\"\u0110\u1eb7t k\u00fd hi\u1ec7u ch\u1ea5m c\u00f4ng t\u01b0\u01a1ng \u1ee9ng tr\u00ean b\u1ea3ng ch\u1ea5m c\u00f4ng\" width=\"1280\" height=\"983\" \/><\/p>\n<h3><b>B\u01b0\u1edbc 6: T\u1ea1o c\u00f4ng th\u1ee9c v\u00e0 h\u00e0m:<\/b><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">T\u1ea1o c\u00e1c c\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00ednh s\u1ed1 ng\u00e0y c\u00f4ng th\u1ef1c t\u1ebf, n\u1eeda ng\u00e0y c\u00f4ng, ngh\u1ec9 h\u01b0\u1edfng l\u01b0\u01a1ng, ngh\u1ec9 kh\u00f4ng l\u01b0\u01a1ng, ngh\u1ec9 \u1ed1m \u0111au cho m\u1ed7i nh\u00e2n vi\u00ean. \u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea1n t\u1ef1 \u0111\u1ed9ng t\u00ednh to\u00e1n v\u00e0 ghi nh\u1eadn d\u1eef li\u1ec7u ch\u1ea5m c\u00f4ng m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 c\u00f4ng th\u1ee9c v\u00e0 h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong qu\u00e1 tr\u00ecnh t\u1ea1o b\u1ea3ng ch\u1ea5m c\u00f4ng tr\u00ean Excel:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>\u0110\u1ebfm s\u1ed1 ng\u00e0y c\u00f4ng th\u1ef1c t\u1ebf:<\/b>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng h\u00e0m COUNTIF \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a k\u00fd hi\u1ec7u ch\u1ea5m c\u00f4ng c\u1ee7a ng\u00e0y c\u00f4ng th\u1ef1c t\u1ebf trong m\u1ed9t d\u00e3y c\u1ee5 th\u1ec3.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: <\/span><span style=\"font-weight: 400;\">=COUNTIF($E11:$AI11;$G$34)<\/span><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>\u0110\u1ebfm s\u1ed1 ng\u00e0y n\u1eeda c\u00f4ng:<\/b>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">T\u01b0\u01a1ng t\u1ef1, s\u1eed d\u1ee5ng h\u00e0m COUNTIF \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a k\u00fd hi\u1ec7u ch\u1ea5m c\u00f4ng c\u1ee7a ng\u00e0y n\u1eeda c\u00f4ng trong m\u1ed9t d\u00e3y c\u1ee5 th\u1ec3.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: <\/span><span style=\"font-weight: 400;\">=COUNTIF($E11:$AI11;$G$35)<\/span><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>\u0110\u1ebfm s\u1ed1 ng\u00e0y ngh\u1ec9 h\u01b0\u1edfng l\u01b0\u01a1ng:<\/b>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng h\u00e0m COUNTIF \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a k\u00fd hi\u1ec7u ch\u1ea5m c\u00f4ng c\u1ee7a ng\u00e0y ngh\u1ec9 h\u01b0\u1edfng l\u01b0\u01a1ng trong m\u1ed9t d\u00e3y c\u1ee5 th\u1ec3.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: <\/span><span style=\"font-weight: 400;\">=COUNTIF($E11:$AI11;$G$36)<\/span><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>\u0110\u1ebfm s\u1ed1 ng\u00e0y ngh\u1ec9 kh\u00f4ng l\u01b0\u01a1ng:<\/b>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng h\u00e0m COUNTIF \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a k\u00fd hi\u1ec7u ch\u1ea5m c\u00f4ng c\u1ee7a ng\u00e0y ngh\u1ec9 kh\u00f4ng l\u01b0\u01a1ng trong m\u1ed9t d\u00e3y c\u1ee5 th\u1ec3.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: <\/span><span style=\"font-weight: 400;\">=COUNTIF($E11:$AI11;$G$37)<\/span><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>\u0110\u1ebfm s\u1ed1 ng\u00e0y ngh\u1ec9 \u1ed1m \u0111au, thai s\u1ea3n:<\/b>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng h\u00e0m COUNTIF \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a k\u00fd hi\u1ec7u ch\u1ea5m c\u00f4ng c\u1ee7a ng\u00e0y ngh\u1ec9 \u1ed1m \u0111au, thai s\u1ea3n trong m\u1ed9t d\u00e3y c\u1ee5 th\u1ec3.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: <\/span><span style=\"font-weight: 400;\">=COUNTIF($E11:$AI11;$G$38)<\/span><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Sao ch\u00e9p c\u00e1c c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng cho c\u00e1c nh\u00e2n vi\u00ean kh\u00e1c. \u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 \u0111\u1ea3m b\u1ea3o t\u00ednh nh\u1ea5t qu\u00e1n trong d\u1eef li\u1ec7u ch\u1ea5m c\u00f4ng.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">T\u1ed5ng h\u1ee3p l\u1ea1i, vi\u1ec7c th\u1ef1c hi\u1ec7n t\u1eebng b\u01b0\u1edbc m\u1ed9t theo tr\u00ecnh t\u1ef1 n\u00e0y s\u1ebd gi\u00fap b\u1ea1n t\u1ea1o b\u1ea3ng ch\u1ea5m c\u00f4ng tr\u00ean Excel m\u1ed9t c\u00e1ch chi ti\u1ebft, \u0111\u00fang c\u00e1ch v\u00e0 hi\u1ec7u qu\u1ea3.<\/span><\/p>\n<h2><b>3. Nh\u1eefng l\u01b0u \u00fd trong l\u00e0m b\u1ea3ng ch\u1ea5m c\u00f4ng excel<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 t\u1ea1o b\u1ea3ng ch\u1ea5m c\u00f4ng ch\u00ednh x\u00e1c v\u00e0 hi\u1ec7u qu\u1ea3 tr\u00ean Excel, b\u1ea1n c\u1ea7n l\u01b0u \u00fd nh\u1eefng \u0111i\u1ec3m quan tr\u1ecdng sau:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>\u0110\u1ed3ng b\u1ed9 quy \u0111\u1ecbnh v\u00e0 h\u00ecnh th\u1ee9c b\u1ea3ng ch\u1ea5m c\u00f4ng:<\/b>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">X\u00e1c \u0111\u1ecbnh r\u00f5 r\u00e0ng c\u00e1c quy \u0111\u1ecbnh v\u1ec1 th\u1eddi gian l\u00e0m vi\u1ec7c, t\u00ednh c\u00f4ng, t\u00ednh l\u01b0\u01a1ng, ngh\u1ec9 ph\u00e9p, l\u00e0m th\u00eam gi\u1edd, l\u00e0m b\u00f9, v\u00e0 c\u00e1c ch\u1ebf \u0111\u1ed9 kh\u00e1c.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Thi\u1ebft k\u1ebf b\u1ea3ng ch\u1ea5m c\u00f4ng sao cho ph\u1ea3n \u00e1nh ch\u00ednh x\u00e1c th\u1eddi gian l\u00e0m vi\u1ec7c v\u00e0 ngh\u1ec9 c\u1ee7a nh\u00e2n vi\u00ean theo t\u1eebng ng\u00e0y, tu\u1ea7n ho\u1eb7c th\u00e1ng.<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Thi\u1ebft k\u1ebf ti\u00eau ch\u00ed ch\u00ednh:<\/b>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">X\u00e1c \u0111\u1ecbnh nh\u1eefng ti\u00eau ch\u00ed quan tr\u1ecdng nh\u01b0 t\u00ean nh\u00e2n vi\u00ean, m\u00e3 nh\u00e2n vi\u00ean, th\u1eddi gian l\u00e0m vi\u1ec7c, ng\u00e0y ngh\u1ec9, lo\u1ea1i c\u00f4ng, s\u1ed1 gi\u1edd l\u00e0m th\u00eam, v\u00e0 c\u00e1c th\u00f4ng tin kh\u00e1c c\u1ea7n thi\u1ebft.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Ph\u00e2n chia b\u1ea3ng ch\u1ea5m c\u00f4ng th\u00e0nh c\u00e1c m\u1ee5c nh\u1ecf \u0111\u1ec3 d\u1ec5 qu\u1ea3n l\u00fd v\u00e0 t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u sau n\u00e0y. Tr\u00e1nh thi\u1ebft k\u1ebf qu\u00e1 ph\u1ee9c t\u1ea1p \u0111\u1ec3 gi\u1eef cho b\u1ea3ng ch\u1ea5m c\u00f4ng d\u1ec5 hi\u1ec3u v\u00e0 s\u1eed d\u1ee5ng.<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Ghi r\u00f5 th\u1eddi gian ho\u00e0n th\u00e0nh:<\/b>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Ghi l\u1ea1i th\u1eddi gian khi ho\u00e0n th\u00e0nh d\u1eef li\u1ec7u ch\u1ea5m c\u00f4ng th\u00f4 \u0111\u1ec3 c\u00f3 th\u1ec3 theo d\u00f5i v\u00e0 ki\u1ec3m tra l\u1ea1i khi c\u1ea7n thi\u1ebft.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">\u0110\u1ea3m b\u1ea3o r\u1eb1ng m\u1ecdi ng\u01b0\u1eddi s\u1eed d\u1ee5ng b\u1ea3ng ch\u1ea5m c\u00f4ng \u0111\u1ec1u bi\u1ebft v\u00e0 tu\u00e2n th\u1ee7 theo quy tr\u00ecnh quy \u0111\u1ecbnh.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">Nh\u1eefng l\u01b0u \u00fd n\u00e0y gi\u00fap b\u1ea1n t\u1ea1o ra b\u1ea3ng ch\u1ea5m c\u00f4ng ch\u00ednh x\u00e1c, tr\u00e1nh sai s\u00f3t v\u00e0 \u0111\u1ea3m b\u1ea3o quy\u1ec1n l\u1ee3i c\u1ee7a nh\u00e2n s\u1ef1 trong qu\u00e1 tr\u00ecnh t\u00ednh l\u01b0\u01a1ng v\u00e0 qu\u1ea3n l\u00fd th\u1eddi gian l\u00e0m vi\u1ec7c.<\/span><\/p>\n<h2><b>4. H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u00e0m b\u1ea3ng ch\u1ea5m c\u00f4ng v\u1edbi ph\u1ea7n m\u1ec1m Arito Solutions<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng Excel \u0111\u1ec3 t\u1ea1o b\u1ea3ng ch\u1ea5m c\u00f4ng l\u00e0 m\u1ed9t gi\u1ea3i ph\u00e1p ph\u1ed5 bi\u1ebfn \u0111\u01b0\u1ee3c nhi\u1ec1u doanh nghi\u1ec7p nh\u1ecf l\u1ef1a ch\u1ecdn t\u1ea1m th\u1eddi. Tuy nhi\u00ean, vi\u1ec7c ch\u1ea5m c\u00f4ng th\u1ee7 c\u00f4ng b\u1eb1ng Excel c\u00f3 th\u1ec3 t\u1ed1n th\u1eddi gian c\u1ee7a nh\u00e2n s\u1ef1 v\u00e0 g\u1eb7p kh\u00f3 kh\u0103n trong vi\u1ec7c t\u1ed5ng h\u1ee3p, qu\u1ea3n l\u00fd ch\u1ea5m c\u00f4ng. \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 d\u1eabn \u0111\u1ebfn l\u00e3ng ph\u00ed ngu\u1ed3n nh\u00e2n l\u1ef1c, th\u1eddi gian, c\u00f4ng s\u1ee9c c\u0169ng nh\u01b0 h\u1ea1n ch\u1ebf n\u0103ng su\u1ea5t l\u00e0m vi\u1ec7c c\u1ee7a to\u00e0n ph\u00f2ng HR trong th\u1eddi \u0111\u1ea1i chuy\u1ec3n \u0111\u1ed5i s\u1ed1 m\u1ea1nh m\u1ebd nh\u01b0 hi\u1ec7n nay.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ch\u00ednh v\u00ec v\u1eady, vi\u1ec7c s\u1eed d\u1ee5ng ph\u1ea7n m\u1ec1m c\u00f4ng ngh\u1ec7 thay th\u1ebf Excel \u0111ang \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u doanh nghi\u1ec7p \u01b0u ti\u00ean v\u00e0 s\u1eed d\u1ee5ng. Trong \u0111\u00f3, Arito l\u00e0 m\u1ed9t trong nh\u1eefng gi\u1ea3i ph\u00e1p t\u1ed1t nh\u1ea5t, nh\u1eadn \u0111\u01b0\u1ee3c \u0111\u00e1nh gi\u00e1 t\u00edch c\u1ef1c t\u1eeb nh\u00e2n s\u1ef1 C&amp;B v\u00e0 nh\u00e0 qu\u1ea3n l\u00fd.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12343\" src=\"https:\/\/arito.vn\/wp-content\/uploads\/2024\/06\/Screenshot-2024-06-15-at-09.25.33.png\" alt=\"arito hrm\" width=\"1780\" height=\"838\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Arito l\u00e0 m\u1ed9t s\u1ea3n ph\u1ea9m n\u1eb1m trong b\u1ed9 gi\u1ea3i ph\u00e1p qu\u1ea3n tr\u1ecb nh\u00e2n s\u1ef1 t\u1ed5ng th\u1ec3 <strong><a href=\"https:\/\/arito.vn\/en\/quan-ly-nhan-su-hrm\/\">Arito HRM<\/a><\/strong> \u2013 ph\u1ea7n m\u1ec1m \u0111\u01b0\u1ee3c h\u00e0ng ngh\u00ecn doanh nghi\u1ec7p t\u1ea1i Vi\u1ec7t Nam tin d\u00f9ng, gi\u00fap gi\u1ea3m 50% s\u1ee9c lao \u0111\u1ed9ng, t\u0103ng 30% hi\u1ec7u qu\u1ea3 l\u00e0m vi\u1ec7c.<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><b>Tr\u01b0\u1edbc khi s\u1eed d\u1ee5ng Arito<\/b><\/td>\n<td><b>Sau khi d\u00f9ng Arito<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">C\u00f4ng ty c\u00f3 nhi\u1ec1u chi nh\u00e1nh, kh\u00f3 kh\u0103n trong vi\u1ec7c c\u1eadp nh\u1eadt d\u1eef li\u1ec7u c\u00f4ng.<\/span><\/td>\n<td><span style=\"font-weight: 400;\">T\u1ef1 \u0111\u1ed9ng thi\u1ebft l\u1eadp th\u1eddi gian l\u00e0m vi\u1ec7c cho nh\u00e2n vi\u00ean, to\u00e0n b\u1ed9 d\u1eef li\u1ec7u c\u00f4ng \u0111\u01b0\u1ee3c \u0111\u1ed3ng b\u1ed9.<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Xin ngh\u1ec9 ph\u00e9p, \u0111i mu\u1ed9n ph\u1ea3i l\u00e0m \u0111\u01a1n, xin ch\u1eef k\u00fd qu\u1ea3n l\u00fd, l\u00e0m email t\u1ed1n th\u1eddi gian.<\/span><\/td>\n<td><span style=\"font-weight: 400;\">T\u1ef1 l\u00e0m \u0111\u01a1n, qu\u1ea3n l\u00fd duy\u1ec7t \u0111\u01a1n ngay tr\u00ean ph\u1ea7n m\u1ec1m, kh\u00f4ng c\u1ea7n gi\u1ea5y t\u1edd th\u1ee7 c\u00f4ng.<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Ch\u1ea5m c\u00f4ng th\u1ee7 c\u00f4ng b\u1eb1ng Excel t\u1ed1n r\u1ea5t nhi\u1ec1u th\u1eddi gian, c\u00f4ng s\u1ee9c, \u0111\u1ed9 ch\u00ednh x\u00e1c ch\u01b0a cao.<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Ch\u1ea5m c\u00f4ng \u0111a d\u1ea1ng h\u00ecnh th\u1ee9c v\u1edbi khu\u00f4n m\u1eb7t, v\u00e2n tay, GPS, d\u1ec5 d\u00e0ng theo d\u00f5i th\u1eddi gian l\u00e0m vi\u1ec7c c\u1ee7a nh\u00e2n vi\u00ean.<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Kh\u00f4ng c\u00f3 c\u00e1i nh\u00ecn t\u1ed5ng qu\u00e1t v\u1ec1 t\u00ecnh h\u00ecnh ch\u1ea5m c\u00f4ng, l\u00e0m b\u00e1o c\u00e1o m\u1ea5t nhi\u1ec1u th\u1eddi gian.<\/span><\/td>\n<td><span style=\"font-weight: 400;\">T\u1ef1 \u0111\u1ed9ng t\u1ea1o b\u00e1o c\u00e1o theo nhi\u1ec1u d\u1ea1ng kh\u00e1c nhau, l\u00e3nh \u0111\u1ea1o, qu\u1ea3n l\u00fd d\u1ec5 d\u00e0ng theo d\u00f5i t\u00ecnh h\u00ecnh nh\u00e2n vi\u00ean \u0111i l\u00e0m.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<blockquote><p><strong>&gt;&gt;&gt; 10 <a href=\"https:\/\/arito.vn\/en\/phan-mem-hrm-hieu-qua-va-duoc-tin-dung-nhat-hien-nay\/\">Ph\u1ea7n m\u1ec1m HRM<\/a> v\u1edbi nhi\u1ec1u t\u00ednh n\u0103ng h\u1ed7 tr\u1ee3 HR h\u1eefu \u00edch nh\u1ea5t<\/strong><\/p><\/blockquote>","protected":false},"excerpt":{"rendered":"<p>T\u1ea3i ng\u00e0y 17+ m\u1eabu b\u1ea3ng ch\u1ea5m c\u00f4ng tr\u00ean excel\/ word ti\u1ec7n l\u1ee3i Kh\u00f4ng th\u1ec3 ph\u1ee7 nh\u1eadn r\u1eb1ng b\u1ea3ng ch\u1ea5m c\u00f4ng Excel l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 kh\u00f4ng th\u1ec3 thi\u1ebfu c\u1ee7a m\u1ed7i doanh nghi\u1ec7p, gi\u00fap ch\u00fang ta t\u1ef1 tin h\u01a1n trong vi\u1ec7c qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1. H\u00e3y c\u00f9ng Arito Solutions kh\u00e1m ph\u00e1 c\u00e1ch t\u1ea1o b\u1ea3ng ch\u1ea5m c\u00f4ng tr\u00ean Excel \u0111\u1ec3 n\u00e2ng cao hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n. 1. X\u00e1c \u0111\u1ecbnh m\u00f4 h\u00ecnh b\u1ea3ng ch\u1ea5m c\u00f4ng tr\u00ean excel \u0110\u1ec3 t\u1ea1o b\u1ea3ng ch\u1ea5m c\u00f4ng tr\u00ean Excel m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3, ng\u01b0\u1eddi l\u1eadp c\u1ea7n c\u00f3 m\u1ed9t k\u1ebf ho\u1ea1ch c\u1ee5 th\u1ec3 v\u1ec1 c\u1ea5u\u2026<\/p>","protected":false},"author":9,"featured_media":12344,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,308],"tags":[],"class_list":["post-12339","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tin-trong-nganh","category-quan-tri-nguon-nhan-luc"],"blocksy_meta":"","_links":{"self":[{"href":"https:\/\/arito.vn\/en\/wp-json\/wp\/v2\/posts\/12339","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/arito.vn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/arito.vn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/arito.vn\/en\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/arito.vn\/en\/wp-json\/wp\/v2\/comments?post=12339"}],"version-history":[{"count":5,"href":"https:\/\/arito.vn\/en\/wp-json\/wp\/v2\/posts\/12339\/revisions"}],"predecessor-version":[{"id":12515,"href":"https:\/\/arito.vn\/en\/wp-json\/wp\/v2\/posts\/12339\/revisions\/12515"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/arito.vn\/en\/wp-json\/wp\/v2\/media\/12344"}],"wp:attachment":[{"href":"https:\/\/arito.vn\/en\/wp-json\/wp\/v2\/media?parent=12339"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/arito.vn\/en\/wp-json\/wp\/v2\/categories?post=12339"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/arito.vn\/en\/wp-json\/wp\/v2\/tags?post=12339"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}