{"id":12224,"date":"2026-05-02T11:29:34","date_gmt":"2026-05-02T04:29:34","guid":{"rendered":"https:\/\/arito.vn\/?p=12224"},"modified":"2026-09-12T23:56:48","modified_gmt":"2026-09-12T16:56:48","slug":"mau-danh-sach-nhan-vien-nhan-su-chi-tiet","status":"publish","type":"post","link":"https:\/\/arito.vn\/en\/mau-danh-sach-nhan-vien-nhan-su-chi-tiet\/","title":{"rendered":"9 M\u1eabu danh s\u00e1ch nh\u00e2n vi\u00ean c\u00f4ng ty Excel v\u00e0 Word k\u00e8m quy \u0111\u1ecbnh b\u1eaft bu\u1ed9c"},"content":{"rendered":"

Ph\u00e1p lu\u1eadt kh\u00f4ng b\u1eaft bu\u1ed9c doanh nghi\u1ec7p d\u00f9ng m\u1ed9t m\u1eabu danh s\u00e1ch nh\u00e2n vi\u00ean c\u1ed1 \u0111\u1ecbnh. Nh\u01b0ng c\u00f3 m\u1ed9t lo\u1ea1i danh s\u00e1ch nh\u00e2n s\u1ef1 b\u1eaft bu\u1ed9c ph\u1ea3i l\u1eadp, v\u00e0 kh\u00f4ng l\u1eadp th\u00ec b\u1ecb ph\u1ea1t \u0111\u1ebfn 20 tri\u1ec7u \u0111\u1ed3ng.<\/p>\n

B\u00e0i vi\u1ebft cung c\u1ea5p 9 m\u1eabu danh s\u00e1ch nh\u00e2n vi\u00ean b\u1eb1ng Excel v\u00e0 Word, trong \u0111\u00f3 c\u00f3 m\u1eabu s\u1ed5 qu\u1ea3n l\u00fd lao \u0111\u1ed9ng theo \u0111\u00fang quy \u0111\u1ecbnh, k\u00e8m nh\u1eefng l\u01b0u \u00fd ph\u00e1p l\u00fd m\u1edbi \u00e1p d\u1ee5ng t\u1eeb n\u0103m 2026.<\/p>\n

Danh s\u00e1ch nh\u00e2n vi\u00ean l\u00e0 g\u00ec?<\/h2>\n

Danh s\u00e1ch nh\u00e2n vi\u00ean l\u00e0 b\u1ea3ng t\u1ed5ng h\u1ee3p th\u00f4ng tin c\u1ee7a to\u00e0n b\u1ed9 ng\u01b0\u1eddi lao \u0111\u1ed9ng \u0111ang l\u00e0m vi\u1ec7c t\u1ea1i doanh nghi\u1ec7p, d\u00f9ng \u0111\u1ec3 tra c\u1ee9u, qu\u1ea3n l\u00fd v\u00e0 l\u00e0m c\u0103n c\u1ee9 cho c\u00e1c nghi\u1ec7p v\u1ee5 nh\u00e2n s\u1ef1 nh\u01b0 ch\u1ea5m c\u00f4ng, t\u00ednh l\u01b0\u01a1ng, \u0111\u00f3ng b\u1ea3o hi\u1ec3m v\u00e0 qu\u1ea3n l\u00fd h\u1ee3p \u0111\u1ed3ng.<\/p>\n

C\u1ea7n ph\u00e2n bi\u1ec7t hai lo\u1ea1i, v\u00ec ch\u00fang ch\u1ecbu hai ch\u1ebf \u0111\u1ed9 ph\u00e1p l\u00fd kh\u00e1c nhau:<\/p>\n\n\n\n\n\n\n\n\n\n
<\/td>\n\n

Danh s\u00e1ch nh\u00e2n vi\u00ean n\u1ed9i b\u1ed9<\/p>\n<\/td>\n

\n

S\u1ed5 qu\u1ea3n l\u00fd lao \u0111\u1ed9ng<\/p>\n<\/td>\n<\/tr>\n

\n

B\u1eaft bu\u1ed9c l\u1eadp<\/p>\n<\/td>\n

\n

Kh\u00f4ng<\/p>\n<\/td>\n

\n

C\u00f3<\/p>\n<\/td>\n<\/tr>\n

\n

C\u0103n c\u1ee9 ph\u00e1p l\u00fd<\/p>\n<\/td>\n

\n

Kh\u00f4ng c\u00f3<\/p>\n<\/td>\n

\n

\u0110i\u1ec1u 12 B\u1ed9 lu\u1eadt Lao \u0111\u1ed9ng 2019, \u0110i\u1ec1u 3 Ngh\u1ecb \u0111\u1ecbnh 145\/2020<\/p>\n<\/td>\n<\/tr>\n

\n

N\u1ed9i dung<\/p>\n<\/td>\n

\n

Doanh nghi\u1ec7p t\u1ef1 quy\u1ebft<\/p>\n<\/td>\n

\n

Ph\u1ea3i c\u00f3 \u0111\u1ee7 c\u00e1c n\u1ed9i dung c\u01a1 b\u1ea3n theo quy \u0111\u1ecbnh<\/p>\n<\/td>\n<\/tr>\n

\n

H\u00ecnh th\u1ee9c<\/p>\n<\/td>\n

\n

T\u1ef1 do<\/p>\n<\/td>\n

\n

B\u1ea3n gi\u1ea5y ho\u1eb7c b\u1ea3n \u0111i\u1ec7n t\u1eed<\/p>\n<\/td>\n<\/tr>\n

\n

Ph\u1ea3i xu\u1ea5t tr\u00ecnh khi thanh tra<\/p>\n<\/td>\n

\n

Kh\u00f4ng b\u1eaft bu\u1ed9c<\/p>\n<\/td>\n

\n

C\u00f3<\/p>\n<\/td>\n<\/tr>\n

\n

Ch\u1ebf t\u00e0i n\u1ebfu thi\u1ebfu<\/p>\n<\/td>\n

\n

Kh\u00f4ng<\/p>\n<\/td>\n

\n

Ph\u1ea1t ti\u1ec1n<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Ph\u1ea7n l\u1edbn doanh nghi\u1ec7p l\u1eadp danh s\u00e1ch n\u1ed9i b\u1ed9 r\u1ea5t chi ti\u1ebft nh\u01b0ng l\u1ea1i kh\u00f4ng c\u00f3 s\u1ed5 qu\u1ea3n l\u00fd lao \u0111\u1ed9ng \u0111\u00fang quy \u0111\u1ecbnh, v\u00ec kh\u00f4ng bi\u1ebft ngh\u0129a v\u1ee5 n\u00e0y t\u1ed3n t\u1ea1i.<\/p>\n

\"Danh<\/p>\n

S\u1ed5 qu\u1ea3n l\u00fd lao \u0111\u1ed9ng: danh s\u00e1ch b\u1eaft bu\u1ed9c theo lu\u1eadt<\/h2>\n

\u0110\u00e2y l\u00e0 ph\u1ea7n c\u1ea7n \u0111\u1ecdc tr\u01b0\u1edbc khi t\u1ea3i b\u1ea5t k\u1ef3 m\u1eabu n\u00e0o.<\/p>\n

Quy \u0111\u1ecbnh<\/h3>\n

Ai ph\u1ea3i l\u1eadp:<\/b> m\u1ecdi ng\u01b0\u1eddi s\u1eed d\u1ee5ng lao \u0111\u1ed9ng.<\/p>\n

Th\u1eddi h\u1ea1n:<\/b> trong v\u00f2ng 30 ng\u00e0y<\/b> k\u1ec3 t\u1eeb ng\u00e0y b\u1eaft \u0111\u1ea7u ho\u1ea1t \u0111\u1ed9ng, theo kho\u1ea3n 1 \u0110i\u1ec1u 3 Ngh\u1ecb \u0111\u1ecbnh 145\/2020\/N\u0110-CP.<\/p>\n

L\u1eadp \u1edf \u0111\u00e2u:<\/b> t\u1ea1i n\u01a1i \u0111\u1eb7t tr\u1ee5 s\u1edf ch\u00ednh, v\u00e0 t\u1ea1i t\u1eebng chi nh\u00e1nh, v\u0103n ph\u00f2ng \u0111\u1ea1i di\u1ec7n.<\/p>\n

H\u00ecnh th\u1ee9c:<\/b> b\u1ea3n gi\u1ea5y ho\u1eb7c b\u1ea3n \u0111i\u1ec7n t\u1eed, theo kho\u1ea3n 2 \u0110i\u1ec1u 3 Ngh\u1ecb \u0111\u1ecbnh 145\/2020. Doanh nghi\u1ec7p d\u00f9ng file Excel ho\u1eb7c ph\u1ea7n m\u1ec1m nh\u00e2n s\u1ef1 \u0111\u1ec1u h\u1ee3p l\u1ec7, mi\u1ec5n l\u00e0 c\u00f3 \u0111\u1ee7 n\u1ed9i dung v\u00e0 xu\u1ea5t tr\u00ecnh \u0111\u01b0\u1ee3c khi c\u1ea7n.<\/p>\n

Ngh\u0129a v\u1ee5 c\u1eadp nh\u1eadt:<\/b> th\u00f4ng tin ng\u01b0\u1eddi lao \u0111\u1ed9ng ph\u1ea3i \u0111\u01b0\u1ee3c ghi v\u00e0o s\u1ed5 k\u1ec3 t\u1eeb ng\u00e0y ng\u01b0\u1eddi \u0111\u00f3 b\u1eaft \u0111\u1ea7u l\u00e0m vi\u1ec7c, kh\u00f4ng ph\u1ea3i ghi d\u1ed3n cu\u1ed1i th\u00e1ng hay cu\u1ed1i qu\u00fd.<\/p>\n

Ngh\u0129a v\u1ee5 xu\u1ea5t tr\u00ecnh:<\/b> ph\u1ea3i xu\u1ea5t tr\u00ecnh khi c\u01a1 quan qu\u1ea3n l\u00fd nh\u00e0 n\u01b0\u1edbc v\u1ec1 lao \u0111\u1ed9ng y\u00eau c\u1ea7u, theo kho\u1ea3n 3 \u0110i\u1ec1u 3 Ngh\u1ecb \u0111\u1ecbnh 145\/2020.<\/p>\n

M\u1ee9c ph\u1ea1t<\/h3>\n

Theo \u0110i\u1ec1u 8 Ngh\u1ecb \u0111\u1ecbnh 12\/2022\/N\u0110-CP:<\/p>\n\n\n\n\n\n
\n

H\u00e0nh vi<\/p>\n<\/td>\n

\n

M\u1ee9c ph\u1ea1t v\u1edbi c\u00e1 nh\u00e2n<\/p>\n<\/td>\n

\n

M\u1ee9c ph\u1ea1t v\u1edbi t\u1ed5 ch\u1ee9c<\/p>\n<\/td>\n<\/tr>\n

\n

Kh\u00f4ng l\u1eadp s\u1ed5 qu\u1ea3n l\u00fd lao \u0111\u1ed9ng, l\u1eadp kh\u00f4ng \u0111\u00fang th\u1eddi h\u1ea1n, ho\u1eb7c kh\u00f4ng \u0111\u1ea3m b\u1ea3o c\u00e1c n\u1ed9i dung c\u01a1 b\u1ea3n<\/p>\n<\/td>\n

\n

5 \u0111\u1ebfn 10 tri\u1ec7u \u0111\u1ed3ng<\/p>\n<\/td>\n

\n

10 \u0111\u1ebfn 20 tri\u1ec7u \u0111\u1ed3ng<\/b><\/b><\/p>\n<\/td>\n<\/tr>\n

\n

Kh\u00f4ng ghi \u0111\u1ea7y \u0111\u1ee7 th\u00f4ng tin ng\u01b0\u1eddi lao \u0111\u1ed9ng v\u00e0o s\u1ed5 k\u1ec3 t\u1eeb ng\u00e0y b\u1eaft \u0111\u1ea7u l\u00e0m vi\u1ec7c, ho\u1eb7c kh\u00f4ng xu\u1ea5t tr\u00ecnh khi c\u01a1 quan c\u00f3 th\u1ea9m quy\u1ec1n y\u00eau c\u1ea7u<\/p>\n<\/td>\n

\n

1 \u0111\u1ebfn 3 tri\u1ec7u \u0111\u1ed3ng<\/p>\n<\/td>\n

\n

2 \u0111\u1ebfn 6 tri\u1ec7u \u0111\u1ed3ng<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

M\u1ee9c ph\u1ea1t quy \u0111\u1ecbnh t\u1ea1i Ngh\u1ecb \u0111\u1ecbnh 12\/2022 \u00e1p d\u1ee5ng cho c\u00e1 nh\u00e2n, t\u1ed5 ch\u1ee9c vi ph\u1ea1m c\u00f9ng h\u00e0nh vi th\u00ec m\u1ee9c ph\u1ea1t g\u1ea5p \u0111\u00f4i.<\/p>\n

\u0110i\u1ec3m \u0111\u00e1ng ch\u00fa \u00fd:<\/b> h\u00e0nh vi b\u1ecb ph\u1ea1t n\u1eb7ng nh\u1ea5t kh\u00f4ng ch\u1ec9 l\u00e0 \u201ckh\u00f4ng l\u1eadp\u201d m\u00e0 c\u00f2n g\u1ed3m \u201cl\u1eadp kh\u00f4ng \u0111\u1ea3m b\u1ea3o c\u00e1c n\u1ed9i dung c\u01a1 b\u1ea3n\u201d. Doanh nghi\u1ec7p c\u00f3 file danh s\u00e1ch nh\u00e2n vi\u00ean nh\u01b0ng thi\u1ebfu c\u00e1c tr\u01b0\u1eddng b\u1eaft bu\u1ed9c v\u1eabn thu\u1ed9c di\u1ec7n n\u00e0y.<\/p>\n

M\u1eabu s\u1ed5 qu\u1ea3n l\u00fd lao \u0111\u1ed9ng<\/h3>\n

C\u00e1c n\u1ed9i dung c\u01a1 b\u1ea3n c\u1ea7n c\u00f3:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n

#<\/p>\n<\/td>\n

\n

Tr\u01b0\u1eddng th\u00f4ng tin<\/p>\n<\/td>\n

\n

Ghi ch\u00fa<\/p>\n<\/td>\n<\/tr>\n

\n

1<\/p>\n<\/td>\n

\n

H\u1ecd v\u00e0 t\u00ean<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

2<\/p>\n<\/td>\n

\n

Gi\u1edbi t\u00ednh<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

3<\/p>\n<\/td>\n

\n

Ng\u00e0y th\u00e1ng n\u0103m sinh<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

4<\/p>\n<\/td>\n

\n

Qu\u1ed1c t\u1ecbch<\/p>\n<\/td>\n

\n

Quan tr\u1ecdng v\u1edbi doanh nghi\u1ec7p c\u00f3 lao \u0111\u1ed9ng n\u01b0\u1edbc ngo\u00e0i<\/p>\n<\/td>\n<\/tr>\n

\n

5<\/p>\n<\/td>\n

\n

N\u01a1i c\u01b0 tr\u00fa<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

6<\/p>\n<\/td>\n

\n

S\u1ed1 th\u1ebb c\u0103n c\u01b0\u1edbc, ho\u1eb7c s\u1ed1 h\u1ed9 chi\u1ebfu v\u1edbi ng\u01b0\u1eddi n\u01b0\u1edbc ngo\u00e0i<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

7<\/p>\n<\/td>\n

\n

Tr\u00ecnh \u0111\u1ed9 chuy\u00ean m\u00f4n k\u1ef9 thu\u1eadt<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

8<\/p>\n<\/td>\n

\n

B\u1eadc tr\u00ecnh \u0111\u1ed9 k\u1ef9 n\u0103ng ngh\u1ec1<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

9<\/p>\n<\/td>\n

\n

V\u1ecb tr\u00ed vi\u1ec7c l\u00e0m<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

10<\/p>\n<\/td>\n

\n

Lo\u1ea1i h\u1ee3p \u0111\u1ed3ng lao \u0111\u1ed9ng<\/p>\n<\/td>\n

\n

X\u00e1c \u0111\u1ecbnh th\u1eddi h\u1ea1n ho\u1eb7c kh\u00f4ng x\u00e1c \u0111\u1ecbnh th\u1eddi h\u1ea1n<\/p>\n<\/td>\n<\/tr>\n

\n

11<\/p>\n<\/td>\n

\n

Th\u1eddi \u0111i\u1ec3m b\u1eaft \u0111\u1ea7u l\u00e0m vi\u1ec7c<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

12<\/p>\n<\/td>\n

\n

Tham gia b\u1ea3o hi\u1ec3m x\u00e3 h\u1ed9i<\/p>\n<\/td>\n

\n

C\u00f3 ho\u1eb7c kh\u00f4ng, k\u00e8m s\u1ed1 s\u1ed5 n\u1ebfu c\u00f3<\/p>\n<\/td>\n<\/tr>\n

\n

13<\/p>\n<\/td>\n

\n

Ti\u1ec1n l\u01b0\u01a1ng<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

14<\/p>\n<\/td>\n

\n

N\u00e2ng b\u1eadc, n\u00e2ng l\u01b0\u01a1ng<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

15<\/p>\n<\/td>\n

\n

S\u1ed1 ng\u00e0y ngh\u1ec9 trong n\u0103m<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

16<\/p>\n<\/td>\n

\n

S\u1ed1 gi\u1edd l\u00e0m th\u00eam<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

17<\/p>\n<\/td>\n

\n

H\u1ecdc ngh\u1ec1, \u0111\u00e0o t\u1ea1o, b\u1ed3i d\u01b0\u1ee1ng n\u00e2ng cao tr\u00ecnh \u0111\u1ed9<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

18<\/p>\n<\/td>\n

\n

K\u1ef7 lu\u1eadt lao \u0111\u1ed9ng, tr\u00e1ch nhi\u1ec7m v\u1eadt ch\u1ea5t<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

19<\/p>\n<\/td>\n

\n

Tai n\u1ea1n lao \u0111\u1ed9ng, b\u1ec7nh ngh\u1ec1 nghi\u1ec7p<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

20<\/p>\n<\/td>\n

\n

Th\u1eddi \u0111i\u1ec3m ch\u1ea5m d\u1ee9t h\u1ee3p \u0111\u1ed3ng lao \u0111\u1ed9ng v\u00e0 l\u00fd do<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Ba \u0111i\u1ec3m hay b\u1ecb b\u1ecf s\u00f3t khi doanh nghi\u1ec7p t\u1ef1 l\u1eadp s\u1ed5:<\/b><\/b><\/p>\n

C\u00e1c tr\u01b0\u1eddng t\u1eeb s\u1ed1 14 \u0111\u1ebfn 19 th\u01b0\u1eddng kh\u00f4ng c\u00f3 trong file danh s\u00e1ch nh\u00e2n vi\u00ean th\u00f4ng th\u01b0\u1eddng. \u0110\u00e2y ch\u00ednh l\u00e0 ph\u1ea7n khi\u1ebfn s\u1ed5 b\u1ecb coi l\u00e0 \u201ckh\u00f4ng \u0111\u1ea3m b\u1ea3o n\u1ed9i dung c\u01a1 b\u1ea3n\u201d.<\/p>\n

Tr\u01b0\u1eddng s\u1ed1 8 v\u1ec1 b\u1eadc tr\u00ecnh \u0111\u1ed9 k\u1ef9 n\u0103ng ngh\u1ec1 hay b\u1ecb \u0111\u1ec3 tr\u1ed1ng. N\u1ebfu ng\u01b0\u1eddi lao \u0111\u1ed9ng ch\u01b0a c\u00f3 b\u1eadc k\u1ef9 n\u0103ng ngh\u1ec1 th\u00ec ghi r\u00f5 l\u00e0 ch\u01b0a c\u00f3, \u0111\u1eebng b\u1ecf tr\u1ed1ng \u00f4.<\/p>\n

Tr\u01b0\u1eddng s\u1ed1 20 c\u1ea7n gi\u1eef l\u1ea1i c\u1ea3 ng\u01b0\u1eddi \u0111\u00e3 ngh\u1ec9 vi\u1ec7c. Nhi\u1ec1u doanh nghi\u1ec7p x\u00f3a d\u00f2ng c\u1ee7a ng\u01b0\u1eddi ngh\u1ec9 vi\u1ec7c kh\u1ecfi file, l\u00e0m m\u1ea5t d\u1eef li\u1ec7u m\u00e0 thanh tra c\u00f3 th\u1ec3 h\u1ecfi t\u1edbi.<\/p>\n

V\u1ec1 c\u00e1ch t\u1ed5 ch\u1ee9c file:<\/b> kh\u00f4ng n\u00ean nh\u1ed3i c\u1ea3 20 tr\u01b0\u1eddng v\u00e0o m\u1ed9t sheet duy nh\u1ea5t v\u00ec s\u1ebd r\u1ea5t kh\u00f3 d\u00f9ng h\u1eb1ng ng\u00e0y. C\u00e1ch th\u1ef1c t\u1ebf l\u00e0 t\u00e1ch th\u00e0nh sheet ch\u00ednh ch\u1ee9a c\u00e1c tr\u01b0\u1eddng tra c\u1ee9u th\u01b0\u1eddng xuy\u00ean, v\u00e0 c\u00e1c sheet ph\u1ee5 ghi bi\u1ebfn \u0111\u1ed9ng l\u01b0\u01a1ng, ngh\u1ec9 ph\u00e9p, l\u00e0m th\u00eam gi\u1edd, k\u1ef7 lu\u1eadt. T\u1ea5t c\u1ea3 n\u1eb1m trong c\u00f9ng m\u1ed9t file th\u00ec v\u1eabn \u0111\u01b0\u1ee3c coi l\u00e0 m\u1ed9t s\u1ed5.<\/p>\n

\"M\u1eabu<\/p>\n

B\u00e1o c\u00e1o t\u00ecnh h\u00ecnh s\u1eed d\u1ee5ng lao \u0111\u1ed9ng<\/h2>\n

Ngh\u0129a v\u1ee5 th\u1ee9 hai g\u1eafn tr\u1ef1c ti\u1ebfp v\u1edbi danh s\u00e1ch nh\u00e2n s\u1ef1.<\/p>\n\n\n\n\n\n\n\n\n\n
\n

N\u1ed9i dung<\/p>\n<\/td>\n

\n

Quy \u0111\u1ecbnh<\/p>\n<\/td>\n<\/tr>\n

\n

M\u1eabu b\u00e1o c\u00e1o<\/p>\n<\/td>\n

\n

M\u1eabu s\u1ed1 01\/PLI Ph\u1ee5 l\u1ee5c I ban h\u00e0nh k\u00e8m Ngh\u1ecb \u0111\u1ecbnh 145\/2020\/N\u0110-CP<\/p>\n<\/td>\n<\/tr>\n

\n

K\u1ef3 b\u00e1o c\u00e1o 6 th\u00e1ng<\/p>\n<\/td>\n

\n

Tr\u01b0\u1edbc ng\u00e0y 05 th\u00e1ng 6<\/b><\/b><\/p>\n<\/td>\n<\/tr>\n

\n

K\u1ef3 b\u00e1o c\u00e1o h\u1eb1ng n\u0103m<\/p>\n<\/td>\n

\n

Tr\u01b0\u1edbc ng\u00e0y 05 th\u00e1ng 12<\/b><\/b><\/p>\n<\/td>\n<\/tr>\n

\n

N\u01a1i n\u1ed9p<\/p>\n<\/td>\n

\n

S\u1edf N\u1ed9i v\u1ee5<\/b>, qua N\u1ec1n t\u1ea3ng h\u1ee3p \u0111\u1ed3ng lao \u0111\u1ed9ng \u0111i\u1ec7n t\u1eed<\/p>\n<\/td>\n<\/tr>\n

\n

Tr\u01b0\u1eddng h\u1ee3p kh\u00f4ng n\u1ed9p \u0111\u01b0\u1ee3c qua n\u1ec1n t\u1ea3ng<\/p>\n<\/td>\n

\n

G\u1eedi tr\u1ef1c ti\u1ebfp \u0111\u1ebfn S\u1edf N\u1ed9i v\u1ee5<\/p>\n<\/td>\n<\/tr>\n

\n

\u0110\u1ed3ng th\u1eddi<\/p>\n<\/td>\n

\n

Th\u00f4ng b\u00e1o \u0111\u1ebfn c\u01a1 quan b\u1ea3o hi\u1ec3m x\u00e3 h\u1ed9i n\u01a1i \u0111\u1eb7t tr\u1ee5 s\u1edf, chi nh\u00e1nh, v\u0103n ph\u00f2ng \u0111\u1ea1i di\u1ec7n<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

L\u01b0u \u00fd v\u1ec1 c\u01a1 quan ti\u1ebfp nh\u1eadn:<\/b> sau \u0111\u1ee3t s\u1eafp x\u1ebfp b\u1ed9 m\u00e1y, ch\u1ee9c n\u0103ng qu\u1ea3n l\u00fd nh\u00e0 n\u01b0\u1edbc v\u1ec1 lao \u0111\u1ed9ng chuy\u1ec3n v\u1ec1 S\u1edf N\u1ed9i v\u1ee5. Ph\u1ea7n l\u1edbn b\u00e0i h\u01b0\u1edbng d\u1eabn \u0111ang l\u01b0u h\u00e0nh tr\u00ean m\u1ea1ng v\u1eabn ghi S\u1edf Lao \u0111\u1ed9ng Th\u01b0\u01a1ng binh v\u00e0 X\u00e3 h\u1ed9i. Doanh nghi\u1ec7p n\u00ean ki\u1ec3m tra l\u1ea1i h\u01b0\u1edbng d\u1eabn c\u1ee7a c\u01a1 quan t\u1ea1i \u0111\u1ecba ph\u01b0\u01a1ng m\u00ecnh tr\u01b0\u1edbc m\u1ed7i k\u1ef3 n\u1ed9p, v\u00ec c\u00e1ch th\u1ee9c ti\u1ebfp nh\u1eadn gi\u1eefa c\u00e1c t\u1ec9nh c\u00f3 th\u1ec3 kh\u00e1c nhau trong giai \u0111o\u1ea1n chuy\u1ec3n ti\u1ebfp.<\/p>\n

M\u1eb9o th\u1ef1c t\u1ebf:<\/b> n\u1ebfu file danh s\u00e1ch nh\u00e2n vi\u00ean \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u00fang ngay t\u1eeb \u0111\u1ea7u, s\u1ed1 li\u1ec7u cho M\u1eabu 01\/PLI c\u00f3 th\u1ec3 l\u1ea5y t\u1ef1 \u0111\u1ed9ng b\u1eb1ng h\u00e0m \u0111\u1ebfm thay v\u00ec ng\u1ed3i \u0111\u1ebfm tay. C\u00e1c tr\u01b0\u1eddng c\u1ea7n c\u00f3 s\u1eb5n \u0111\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c vi\u1ec7c n\u00e0y: gi\u1edbi t\u00ednh, lo\u1ea1i h\u1ee3p \u0111\u1ed3ng, tr\u00ecnh \u0111\u1ed9 chuy\u00ean m\u00f4n, v\u1ecb tr\u00ed vi\u1ec7c l\u00e0m, t\u00ecnh tr\u1ea1ng tham gia b\u1ea3o hi\u1ec3m x\u00e3 h\u1ed9i, v\u00e0 ng\u00e0y b\u1eaft \u0111\u1ea7u, ng\u00e0y k\u1ebft th\u00fac l\u00e0m vi\u1ec7c.<\/p>\n

Danh s\u00e1ch nh\u00e2n vi\u00ean v\u00e0 Lu\u1eadt B\u1ea3o v\u1ec7 d\u1eef li\u1ec7u c\u00e1 nh\u00e2n<\/h2>\n

\u0110\u00e2y l\u00e0 ph\u1ea7n ho\u00e0n to\u00e0n m\u1edbi t\u1eeb n\u0103m 2026 v\u00e0 ch\u01b0a b\u00e0i vi\u1ebft n\u00e0o v\u1ec1 ch\u1ee7 \u0111\u1ec1 n\u00e0y \u0111\u1ec1 c\u1eadp.<\/p>\n

Lu\u1eadt B\u1ea3o v\u1ec7 d\u1eef li\u1ec7u c\u00e1 nh\u00e2n s\u1ed1 91\/2025\/QH15<\/b>, Qu\u1ed1c h\u1ed9i th\u00f4ng qua ng\u00e0y 26\/6\/2025, c\u00f3 hi\u1ec7u l\u1ef1c t\u1eeb 01\/01\/2026<\/b>. Ngh\u1ecb \u0111\u1ecbnh 356\/2025\/N\u0110-CP<\/b> h\u01b0\u1edbng d\u1eabn thi h\u00e0nh c\u0169ng c\u00f3 hi\u1ec7u l\u1ef1c c\u00f9ng ng\u00e0y.<\/p>\n

V\u00ec sao li\u00ean quan \u0111\u1ebfn danh s\u00e1ch nh\u00e2n vi\u00ean:<\/b> m\u1ed9t file danh s\u00e1ch nh\u00e2n vi\u00ean \u0111i\u1ec3n h\u00ecnh ch\u1ee9a h\u1ecd t\u00ean, ng\u00e0y sinh, s\u1ed1 c\u0103n c\u01b0\u1edbc, n\u01a1i c\u01b0 tr\u00fa, s\u1ed1 \u0111i\u1ec7n tho\u1ea1i, s\u1ed1 t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng, s\u1ed1 s\u1ed5 b\u1ea3o hi\u1ec3m x\u00e3 h\u1ed9i, m\u1ee9c l\u01b0\u01a1ng. \u0110\u00e2y l\u00e0 ho\u1ea1t \u0111\u1ed9ng thu th\u1eadp v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u c\u00e1 nh\u00e2n, v\u00e0 m\u1ed9t ph\u1ea7n trong \u0111\u00f3 thu\u1ed9c nh\u00f3m d\u1eef li\u1ec7u c\u00e1 nh\u00e2n nh\u1ea1y c\u1ea3m.<\/p>\n

Ngh\u1ecb \u0111\u1ecbnh 356\/2025 \u0111\u00e3 b\u1ed5 sung v\u00e0o nh\u00f3m d\u1eef li\u1ec7u nh\u1ea1y c\u1ea3m m\u1ed9t s\u1ed1 lo\u1ea1i \u0111\u00e1ng ch\u00fa \u00fd v\u1edbi doanh nghi\u1ec7p, trong \u0111\u00f3 c\u00f3 \u1ea3nh ch\u1ee5p th\u1ebb c\u0103n c\u01b0\u1edbc, th\u00f4ng tin \u0111\u1ecbnh danh \u0111i\u1ec7n t\u1eed v\u00e0 l\u1ecbch s\u1eed giao d\u1ecbch.<\/p>\n

B\u1ed1n vi\u1ec7c doanh nghi\u1ec7p n\u00ean r\u00e0 l\u1ea1i v\u1edbi file danh s\u00e1ch nh\u00e2n vi\u00ean:<\/b><\/b><\/p>\n\n\n\n\n\n\n\n
\n

Vi\u1ec7c<\/p>\n<\/td>\n

\n

C\u00e1ch l\u00e0m<\/p>\n<\/td>\n<\/tr>\n

\n

Ch\u1ec9 thu th\u1eadp th\u00f4ng tin th\u1ef1c s\u1ef1 c\u1ea7n<\/p>\n<\/td>\n

\n

B\u1ecf c\u00e1c tr\u01b0\u1eddng kh\u00f4ng ph\u1ee5c v\u1ee5 m\u1ee5c \u0111\u00edch c\u1ee5 th\u1ec3 n\u00e0o. Nhi\u1ec1u m\u1eabu l\u01b0u h\u00e0nh tr\u00ean m\u1ea1ng c\u00f3 c\u1ea3 tr\u01b0\u1eddng t\u00f4n gi\u00e1o, d\u00e2n t\u1ed9c, t\u00ecnh tr\u1ea1ng h\u00f4n nh\u00e2n m\u00e0 doanh nghi\u1ec7p kh\u00f4ng d\u00f9ng \u0111\u1ebfn<\/p>\n<\/td>\n<\/tr>\n

\n

Ki\u1ec3m so\u00e1t ng\u01b0\u1eddi \u0111\u01b0\u1ee3c xem file<\/p>\n<\/td>\n

\n

File nh\u00e2n s\u1ef1 \u0111\u1ea7y \u0111\u1ee7 kh\u00f4ng n\u00ean \u0111\u1ec3 \u1edf th\u01b0 m\u1ee5c chung ai c\u0169ng v\u00e0o \u0111\u01b0\u1ee3c. B\u1ea3n g\u1eedi cho b\u1ed9 ph\u1eadn kh\u00e1c n\u00ean c\u1eaft b\u1edbt c\u1ed9t nh\u1ea1y c\u1ea3m<\/p>\n<\/td>\n<\/tr>\n

\n

H\u1ea1n ch\u1ebf g\u1eedi file qua k\u00eanh kh\u00f4ng ki\u1ec3m so\u00e1t<\/p>\n<\/td>\n

\n

G\u1eedi file danh s\u00e1ch \u0111\u1ea7y \u0111\u1ee7 qua Zalo hay email c\u00e1 nh\u00e2n l\u00e0 r\u1ee7i ro. N\u1ebfu bu\u1ed9c ph\u1ea3i g\u1eedi, n\u00ean \u0111\u1eb7t m\u1eadt kh\u1ea9u file v\u00e0 g\u1eedi m\u1eadt kh\u1ea9u qua k\u00eanh kh\u00e1c<\/p>\n<\/td>\n<\/tr>\n

\n

C\u00f3 c\u01a1 s\u1edf ph\u00e1p l\u00fd cho vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u<\/p>\n<\/td>\n

\n

R\u00e0 l\u1ea1i h\u1ee3p \u0111\u1ed3ng lao \u0111\u1ed9ng v\u00e0 n\u1ed9i quy xem \u0111\u00e3 c\u00f3 n\u1ed9i dung v\u1ec1 vi\u1ec7c thu th\u1eadp, s\u1eed d\u1ee5ng d\u1eef li\u1ec7u c\u00e1 nh\u00e2n c\u1ee7a ng\u01b0\u1eddi lao \u0111\u1ed9ng hay ch\u01b0a<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

M\u1ed9t c\u00f4ng th\u1ee9c Excel h\u1eefu \u00edch cho vi\u1ec7c n\u00e0y<\/b> l\u00e0 che b\u1edbt s\u1ed1 c\u0103n c\u01b0\u1edbc \u1edf c\u00e1c b\u1ea3n d\u00f9ng chung, ch\u1ec9 gi\u1eef 4 s\u1ed1 cu\u1ed1i:<\/p>\n

=IF(LEN(B2)<4,””,REPT(“*”,LEN(B2)-4)&RIGHT(B2,4))<\/p>\n

D\u00f9ng c\u00f4ng th\u1ee9c n\u00e0y t\u1ea1o m\u1ed9t c\u1ed9t m\u1edbi, r\u1ed3i khi c\u1ea7n g\u1eedi danh s\u00e1ch cho b\u1ed9 ph\u1eadn kh\u00e1c th\u00ec g\u1eedi c\u1ed9t \u0111\u00e3 che thay v\u00ec c\u1ed9t g\u1ed1c.<\/p>\n

N\u1ed9i dung ph\u1ea7n n\u00e0y mang t\u00ednh \u0111\u1ecbnh h\u01b0\u1edbng. Doanh nghi\u1ec7p c\u00f3 quy m\u00f4 l\u1edbn ho\u1eb7c x\u1eed l\u00fd nhi\u1ec1u d\u1eef li\u1ec7u nh\u1ea1y c\u1ea3m n\u00ean tham v\u1ea5n \u00fd ki\u1ebfn ph\u00e1p l\u00fd v\u1ec1 ngh\u0129a v\u1ee5 c\u1ee5 th\u1ec3 c\u1ee7a m\u00ecnh theo Lu\u1eadt B\u1ea3o v\u1ec7 d\u1eef li\u1ec7u c\u00e1 nh\u00e2n v\u00e0 Ngh\u1ecb \u0111\u1ecbnh 356\/2025.<\/p>\n

N\u00ean d\u00f9ng Excel hay Word?<\/h2>\n

C\u1ea3 b\u1ed1n t\u1eeb kh\u00f3a ng\u01b0\u1eddi d\u00f9ng t\u00ecm \u0111\u1ec1u c\u00f3, nh\u01b0ng hai \u0111\u1ecbnh d\u1ea1ng ph\u1ee5c v\u1ee5 hai m\u1ee5c \u0111\u00edch kh\u00e1c nhau.<\/p>\n\n\n\n\n\n\n\n\n\n\n
\n

Ti\u00eau ch\u00ed<\/p>\n<\/td>\n

\n

Excel<\/p>\n<\/td>\n

\n

Word<\/p>\n<\/td>\n<\/tr>\n

\n

L\u01b0u tr\u1eef v\u00e0 tra c\u1ee9u nhi\u1ec1u ng\u01b0\u1eddi<\/p>\n<\/td>\n

\n

T\u1ed1t<\/p>\n<\/td>\n

\n

K\u00e9m<\/p>\n<\/td>\n<\/tr>\n

\n

L\u1ecdc, s\u1eafp x\u1ebfp, th\u1ed1ng k\u00ea<\/p>\n<\/td>\n

\n

T\u1ed1t<\/p>\n<\/td>\n

\n

Kh\u00f4ng l\u00e0m \u0111\u01b0\u1ee3c<\/p>\n<\/td>\n<\/tr>\n

\n

T\u00ednh to\u00e1n t\u1ef1 \u0111\u1ed9ng<\/p>\n<\/td>\n

\n

T\u1ed1t<\/p>\n<\/td>\n

\n

Kh\u00f4ng<\/p>\n<\/td>\n<\/tr>\n

\n

In ra k\u00fd v\u00e0 \u0111\u00f3ng d\u1ea5u<\/p>\n<\/td>\n

\n

K\u00e9m, hay v\u1ee1 trang<\/p>\n<\/td>\n

\n

T\u1ed1t<\/p>\n<\/td>\n<\/tr>\n

\n

G\u1eedi k\u00e8m h\u1ed3 s\u01a1, c\u00f4ng v\u0103n<\/p>\n<\/td>\n

\n

K\u00e9m<\/p>\n<\/td>\n

\n

T\u1ed1t<\/p>\n<\/td>\n<\/tr>\n

\n

Tr\u00ecnh b\u00e0y \u0111\u1eb9p, c\u00f3 ti\u00eau \u0111\u1ec1 qu\u1ed1c hi\u1ec7u<\/p>\n<\/td>\n

\n

K\u00e9m<\/p>\n<\/td>\n

\n

T\u1ed1t<\/p>\n<\/td>\n<\/tr>\n

\n

S\u1ed1 l\u01b0\u1ee3ng ng\u01b0\u1eddi ph\u00f9 h\u1ee3p<\/p>\n<\/td>\n

\n

T\u1eeb v\u00e0i ch\u1ee5c tr\u1edf l\u00ean<\/p>\n<\/td>\n

\n

D\u01b0\u1edbi v\u00e0i ch\u1ee5c, ho\u1eb7c d\u00f9ng cho m\u1ed9t l\u1ea7n<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

K\u1ebft lu\u1eadn th\u1ef1c t\u1ebf:<\/b> d\u00f9ng Excel \u0111\u1ec3 qu\u1ea3n l\u00fd, d\u00f9ng Word \u0111\u1ec3 xu\u1ea5t b\u1ea3n gi\u1ea5y c\u1ea7n k\u00fd.<\/p>\n

Ba tr\u01b0\u1eddng h\u1ee3p c\u1ee5 th\u1ec3 n\u00ean d\u00f9ng Word:<\/b><\/b><\/p>\n

Danh s\u00e1ch nh\u00e2n vi\u00ean g\u1eedi k\u00e8m h\u1ed3 s\u01a1 th\u1ea7u, h\u1ed3 s\u01a1 n\u0103ng l\u1ef1c. B\u00ean nh\u1eadn mu\u1ed1n m\u1ed9t v\u0103n b\u1ea3n g\u1ecdn, c\u00f3 ti\u00eau \u0111\u1ec1 v\u00e0 ch\u1eef k\u00fd, kh\u00f4ng mu\u1ed1n file d\u1eef li\u1ec7u th\u00f4.<\/p>\n

Danh s\u00e1ch \u0111\u1ec1 ngh\u1ecb c\u1ea5p th\u1ebb ra v\u00e0o, danh s\u00e1ch nh\u00e2n s\u1ef1 v\u00e0o c\u00f4ng tr\u01b0\u1eddng. C\u1ea7n in ra, k\u00fd v\u00e0 \u0111\u00f3ng d\u1ea5u.<\/p>\n

Danh s\u00e1ch k\u00e8m quy\u1ebft \u0111\u1ecbnh, th\u00f4ng b\u00e1o n\u1ed9i b\u1ed9. V\u00ed d\u1ee5 danh s\u00e1ch nh\u00e2n s\u1ef1 \u0111\u01b0\u1ee3c n\u00e2ng l\u01b0\u01a1ng k\u00e8m quy\u1ebft \u0111\u1ecbnh, ho\u1eb7c danh s\u00e1ch tham gia \u0111\u00e0o t\u1ea1o k\u00e8m th\u00f4ng b\u00e1o.<\/p>\n

C\u00e1ch l\u00e0m hi\u1ec7u qu\u1ea3 nh\u1ea5t:<\/b> gi\u1eef d\u1eef li\u1ec7u g\u1ed1c trong Excel, khi c\u1ea7n b\u1ea3n Word th\u00ec d\u00f9ng ch\u1ee9c n\u0103ng tr\u1ed9n th\u01b0 trong Word \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u t\u1eeb file Excel sang. C\u00e1ch n\u00e0y tr\u00e1nh ph\u1ea3i g\u00f5 l\u1ea1i v\u00e0 tr\u00e1nh sai l\u1ec7ch gi\u1eefa hai b\u1ea3n.<\/p>\n

\"N\u00ean<\/p>\n

\u2b07 T\u1ea3i b\u1ed9 m\u1eabu danh s\u00e1ch nh\u00e2n s\u1ef1 T\u1ea0I \u0110\u00c2Y<\/a><\/p>\n

9 m\u1eabu danh s\u00e1ch nh\u00e2n vi\u00ean<\/h2>\n

M\u1eabu 1: S\u1ed5 qu\u1ea3n l\u00fd lao \u0111\u1ed9ng (Excel)<\/h3>\n

D\u00f9ng \u0111\u1ec3:<\/b> \u0111\u00e1p \u1ee9ng ngh\u0129a v\u1ee5 b\u1eaft bu\u1ed9c theo Ngh\u1ecb \u0111\u1ecbnh 145\/2020.<\/p>\n

C\u1ea5u tr\u00fac \u0111\u1ec1 xu\u1ea5t:<\/b> m\u1ed9t file g\u1ed3m nhi\u1ec1u sheet.<\/p>\n\n\n\n\n\n\n\n\n\n
\n

Sheet<\/p>\n<\/td>\n

\n

N\u1ed9i dung<\/p>\n<\/td>\n<\/tr>\n

\n

Th\u00f4ng tin chung<\/p>\n<\/td>\n

\n

13 tr\u01b0\u1eddng \u0111\u1ea7u trong b\u1ea3ng \u1edf ph\u1ea7n tr\u00ean, m\u1ed7i ng\u01b0\u1eddi m\u1ed9t d\u00f2ng<\/p>\n<\/td>\n<\/tr>\n

\n

Bi\u1ebfn \u0111\u1ed9ng l\u01b0\u01a1ng<\/p>\n<\/td>\n

\n

Ng\u00e0y hi\u1ec7u l\u1ef1c, m\u1ee9c c\u0169, m\u1ee9c m\u1edbi, l\u00fd do<\/p>\n<\/td>\n<\/tr>\n

\n

Ngh\u1ec9 ph\u00e9p v\u00e0 l\u00e0m th\u00eam<\/p>\n<\/td>\n

\n

S\u1ed1 ng\u00e0y ngh\u1ec9 trong n\u0103m, s\u1ed1 gi\u1edd l\u00e0m th\u00eam theo th\u00e1ng<\/p>\n<\/td>\n<\/tr>\n

\n

\u0110\u00e0o t\u1ea1o<\/p>\n<\/td>\n

\n

Kh\u00f3a h\u1ecdc, th\u1eddi gian, k\u1ebft qu\u1ea3<\/p>\n<\/td>\n<\/tr>\n

\n

K\u1ef7 lu\u1eadt v\u00e0 tai n\u1ea1n<\/p>\n<\/td>\n

\n

Ng\u00e0y, n\u1ed9i dung, h\u00ecnh th\u1ee9c x\u1eed l\u00fd<\/p>\n<\/td>\n<\/tr>\n

\n

Ch\u1ea5m d\u1ee9t h\u1ee3p \u0111\u1ed3ng<\/p>\n<\/td>\n

\n

Ng\u00e0y ch\u1ea5m d\u1ee9t, l\u00fd do<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

L\u01b0u \u00fd:<\/b> gi\u1eef l\u1ea1i d\u00f2ng c\u1ee7a ng\u01b0\u1eddi \u0111\u00e3 ngh\u1ec9 vi\u1ec7c, \u0111\u00e1nh d\u1ea5u tr\u1ea1ng th\u00e1i thay v\u00ec x\u00f3a.<\/p>\n

\u0110\u00e2y l\u00e0 m\u1eabu quan tr\u1ecdng nh\u1ea5t trong b\u00e0i v\u00e0 c\u0169ng l\u00e0 m\u1eabu duy nh\u1ea5t c\u00f3 y\u00eau c\u1ea7u b\u1eaft bu\u1ed9c v\u1ec1 n\u1ed9i dung.<\/p>\n

M\u1eabu 2: Danh s\u00e1ch nh\u00e2n vi\u00ean t\u1ed5ng h\u1ee3p (Excel)<\/h3>\n

D\u00f9ng \u0111\u1ec3:<\/b> tra c\u1ee9u h\u1eb1ng ng\u00e0y, l\u00e0 b\u1ea3ng g\u1ed1c cho c\u00e1c b\u00e1o c\u00e1o kh\u00e1c.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n

C\u1ed9t<\/p>\n<\/td>\n

\n

Ghi ch\u00fa<\/p>\n<\/td>\n<\/tr>\n

\n

M\u00e3 nh\u00e2n vi\u00ean<\/p>\n<\/td>\n

\n

\u0110\u1eb7t theo quy t\u1eafc c\u1ed1 \u0111\u1ecbnh, kh\u00f4ng tr\u00f9ng<\/p>\n<\/td>\n<\/tr>\n

\n

H\u1ecd v\u00e0 t\u00ean<\/p>\n<\/td>\n

\n

N\u00ean t\u00e1ch c\u1ed9t H\u1ecd \u0111\u1ec7m v\u00e0 c\u1ed9t T\u00ean \u0111\u1ec3 s\u1eafp x\u1ebfp \u0111\u00fang theo t\u00ean<\/p>\n<\/td>\n<\/tr>\n

\n

Ng\u00e0y sinh<\/p>\n<\/td>\n

\n

\u0110\u1ecbnh d\u1ea1ng ng\u00e0y, kh\u00f4ng nh\u1eadp d\u1ea1ng ch\u1eef<\/p>\n<\/td>\n<\/tr>\n

\n

Gi\u1edbi t\u00ednh<\/p>\n<\/td>\n

\n

D\u00f9ng danh s\u00e1ch ch\u1ecdn, kh\u00f4ng g\u00f5 tay<\/p>\n<\/td>\n<\/tr>\n

\n

S\u1ed1 c\u0103n c\u01b0\u1edbc<\/p>\n<\/td>\n

\n

\u0110\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n \u0111\u1ec3 kh\u00f4ng m\u1ea5t s\u1ed1 0 \u0111\u1ea7u<\/p>\n<\/td>\n<\/tr>\n

\n

S\u1ed1 \u0111i\u1ec7n tho\u1ea1i<\/p>\n<\/td>\n

\n

\u0110\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n<\/p>\n<\/td>\n<\/tr>\n

\n

Email<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

N\u01a1i c\u01b0 tr\u00fa<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

Ph\u00f2ng ban<\/p>\n<\/td>\n

\n

D\u00f9ng danh s\u00e1ch ch\u1ecdn<\/p>\n<\/td>\n<\/tr>\n

\n

Ch\u1ee9c danh<\/p>\n<\/td>\n

\n

D\u00f9ng danh s\u00e1ch ch\u1ecdn<\/p>\n<\/td>\n<\/tr>\n

\n

Ng\u00e0y v\u00e0o l\u00e0m<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

Lo\u1ea1i h\u1ee3p \u0111\u1ed3ng<\/p>\n<\/td>\n

\n

D\u00f9ng danh s\u00e1ch ch\u1ecdn<\/p>\n<\/td>\n<\/tr>\n

\n

Ng\u00e0y h\u1ebft h\u1ea1n h\u1ee3p \u0111\u1ed3ng<\/p>\n<\/td>\n

\n

\u0110\u1ec3 tr\u1ed1ng v\u1edbi h\u1ee3p \u0111\u1ed3ng kh\u00f4ng x\u00e1c \u0111\u1ecbnh th\u1eddi h\u1ea1n<\/p>\n<\/td>\n<\/tr>\n

\n

L\u01b0\u01a1ng c\u01a1 b\u1ea3n<\/p>\n<\/td>\n

\n

\u0110\u1ecbnh d\u1ea1ng s\u1ed1<\/p>\n<\/td>\n<\/tr>\n

\n

S\u1ed1 t\u00e0i kho\u1ea3n v\u00e0 ng\u00e2n h\u00e0ng<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

M\u00e3 s\u1ed1 thu\u1ebf c\u00e1 nh\u00e2n<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

S\u1ed1 s\u1ed5 b\u1ea3o hi\u1ec3m x\u00e3 h\u1ed9i<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

Ng\u01b0\u1eddi li\u00ean h\u1ec7 kh\u1ea9n c\u1ea5p v\u00e0 s\u1ed1 \u0111i\u1ec7n tho\u1ea1i<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

Tr\u1ea1ng th\u00e1i<\/p>\n<\/td>\n

\n

\u0110ang l\u00e0m vi\u1ec7c, ngh\u1ec9 thai s\u1ea3n, \u0111\u00e3 ngh\u1ec9 vi\u1ec7c<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

V\u1ec1 c\u1ed9t Tr\u1ea1ng th\u00e1i:<\/b> \u0111\u00e2y l\u00e0 c\u1ed9t quan tr\u1ecdng nh\u1ea5t \u0111\u1ec3 file d\u00f9ng \u0111\u01b0\u1ee3c l\u00e2u d\u00e0i. C\u00f3 c\u1ed9t n\u00e0y th\u00ec kh\u00f4ng c\u1ea7n x\u00f3a d\u00f2ng ng\u01b0\u1eddi ngh\u1ec9 vi\u1ec7c, v\u00e0 m\u1ecdi c\u00f4ng th\u1ee9c \u0111\u1ebfm \u0111\u1ec1u l\u1ecdc theo tr\u1ea1ng th\u00e1i.<\/p>\n

M\u1eabu 3: Danh s\u00e1ch nh\u00e2n vi\u00ean theo ph\u00f2ng ban (Excel)<\/h3>\n

D\u00f9ng \u0111\u1ec3:<\/b> xem c\u01a1 c\u1ea5u nh\u00e2n s\u1ef1 t\u1eebng b\u1ed9 ph\u1eadn, ph\u1ee5c v\u1ee5 h\u1ecdp giao ban v\u00e0 l\u1eadp k\u1ebf ho\u1ea1ch tuy\u1ec3n d\u1ee5ng.<\/p>\n

Kh\u00f4ng n\u00ean t\u1ea1o file ri\u00eang cho t\u1eebng ph\u00f2ng. C\u00e1ch \u0111\u00fang l\u00e0 l\u1ea5y t\u1eeb m\u1eabu 2, d\u00f9ng b\u1ed9 l\u1ecdc ho\u1eb7c b\u1ea3ng t\u1ed5ng h\u1ee3p theo c\u1ed9t ph\u00f2ng ban. T\u1ea1o file ri\u00eang cho t\u1eebng ph\u00f2ng d\u1eabn \u0111\u1ebfn nhi\u1ec1u b\u1ea3n kh\u00f4ng \u0111\u1ed3ng b\u1ed9.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n
\n

C\u1ed9t<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

Ph\u00f2ng ban<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

M\u00e3 nh\u00e2n vi\u00ean<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

H\u1ecd v\u00e0 t\u00ean<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

Ch\u1ee9c danh<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

C\u1ea5p b\u1eadc<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

Ng\u00e0y v\u00e0o l\u00e0m<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

Th\u00e2m ni\u00ean<\/p>\n<\/td>\n

\n

T\u00ednh b\u1eb1ng c\u00f4ng th\u1ee9c<\/p>\n<\/td>\n<\/tr>\n

\n

Tr\u1ea1ng th\u00e1i<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

N\u00ean c\u00f3 th\u00eam m\u1ed9t sheet t\u1ed5ng h\u1ee3p \u0111\u1ebfm s\u1ed1 ng\u01b0\u1eddi theo t\u1eebng ph\u00f2ng v\u00e0 t\u1eebng c\u1ea5p b\u1eadc.<\/p>\n

M\u1eabu 4: Theo d\u00f5i h\u1ee3p \u0111\u1ed3ng lao \u0111\u1ed9ng (Excel)<\/h3>\n

D\u00f9ng \u0111\u1ec3:<\/b> c\u1ea3nh b\u00e1o h\u1ee3p \u0111\u1ed3ng s\u1eafp h\u1ebft h\u1ea1n. \u0110\u00e2y l\u00e0 m\u1eabu c\u00f3 gi\u00e1 tr\u1ecb ph\u00f2ng ng\u1eeba r\u1ee7i ro cao nh\u1ea5t.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n

C\u1ed9t<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

M\u00e3 nh\u00e2n vi\u00ean, H\u1ecd t\u00ean, Ph\u00f2ng ban<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

S\u1ed1 h\u1ee3p \u0111\u1ed3ng<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

Lo\u1ea1i h\u1ee3p \u0111\u1ed3ng<\/p>\n<\/td>\n

\n

X\u00e1c \u0111\u1ecbnh th\u1eddi h\u1ea1n, kh\u00f4ng x\u00e1c \u0111\u1ecbnh th\u1eddi h\u1ea1n, th\u1eed vi\u1ec7c<\/p>\n<\/td>\n<\/tr>\n

\n

Ng\u00e0y k\u00fd<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

Ng\u00e0y b\u1eaft \u0111\u1ea7u hi\u1ec7u l\u1ef1c<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

Ng\u00e0y h\u1ebft h\u1ea1n<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

S\u1ed1 ng\u00e0y c\u00f2n l\u1ea1i<\/p>\n<\/td>\n

\n

C\u00f4ng th\u1ee9c<\/p>\n<\/td>\n<\/tr>\n

\n

C\u1ea3nh b\u00e1o<\/p>\n<\/td>\n

\n

C\u00f4ng th\u1ee9c<\/p>\n<\/td>\n<\/tr>\n

\n

L\u1ea7n k\u00fd th\u1ee9 m\u1ea5y<\/p>\n<\/td>\n

\n

Quan tr\u1ecdng, xem l\u01b0u \u00fd b\u00ean d\u01b0\u1edbi<\/p>\n<\/td>\n<\/tr>\n

\n

Ph\u01b0\u01a1ng \u00e1n<\/p>\n<\/td>\n

\n

T\u00e1i k\u00fd, chuy\u1ec3n kh\u00f4ng x\u00e1c \u0111\u1ecbnh th\u1eddi h\u1ea1n, kh\u00f4ng t\u00e1i k\u00fd<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

L\u01b0u \u00fd ph\u00e1p l\u00fd quan tr\u1ecdng v\u1ec1 c\u1ed9t \u201cL\u1ea7n k\u00fd th\u1ee9 m\u1ea5y\u201d:<\/b> theo B\u1ed9 lu\u1eadt Lao \u0111\u1ed9ng 2019, h\u1ee3p \u0111\u1ed3ng lao \u0111\u1ed9ng x\u00e1c \u0111\u1ecbnh th\u1eddi h\u1ea1n ch\u1ec9 \u0111\u01b0\u1ee3c k\u00fd th\u00eam m\u1ed9t l\u1ea7n, sau \u0111\u00f3 n\u1ebfu ng\u01b0\u1eddi lao \u0111\u1ed9ng ti\u1ebfp t\u1ee5c l\u00e0m vi\u1ec7c th\u00ec ph\u1ea3i k\u00fd h\u1ee3p \u0111\u1ed3ng kh\u00f4ng x\u00e1c \u0111\u1ecbnh th\u1eddi h\u1ea1n. Doanh nghi\u1ec7p kh\u00f4ng theo d\u00f5i c\u1ed9t n\u00e0y d\u1ec5 k\u00fd sai lo\u1ea1i h\u1ee3p \u0111\u1ed3ng \u1edf l\u1ea7n th\u1ee9 ba.<\/p>\n

Ngo\u00e0i ra, khi h\u1ee3p \u0111\u1ed3ng h\u1ebft h\u1ea1n m\u00e0 ng\u01b0\u1eddi lao \u0111\u1ed9ng v\u1eabn ti\u1ebfp t\u1ee5c l\u00e0m vi\u1ec7c, c\u1ea7n x\u1eed l\u00fd trong th\u1eddi h\u1ea1n lu\u1eadt \u0111\u1ecbnh, n\u1ebfu kh\u00f4ng h\u1ee3p \u0111\u1ed3ng s\u1ebd t\u1ef1 chuy\u1ec3n th\u00e0nh h\u1ee3p \u0111\u1ed3ng kh\u00f4ng x\u00e1c \u0111\u1ecbnh th\u1eddi h\u1ea1n.<\/p>\n

M\u1eabu 5: Theo d\u00f5i nh\u00e2n s\u1ef1 m\u1edbi (Excel)<\/h3>\n

D\u00f9ng \u0111\u1ec3:<\/b> qu\u1ea3n l\u00fd qu\u00e1 tr\u00ecnh ti\u1ebfp nh\u1eadn ng\u01b0\u1eddi m\u1edbi, \u0111\u1ea3m b\u1ea3o kh\u00f4ng s\u00f3t th\u1ee7 t\u1ee5c.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n

C\u1ed9t<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

H\u1ecd t\u00ean, Ng\u00e0y b\u1eaft \u0111\u1ea7u, Ph\u00f2ng ban, Ch\u1ee9c danh<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

Ng\u01b0\u1eddi qu\u1ea3n l\u00fd tr\u1ef1c ti\u1ebfp<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

\u0110\u00e3 k\u00fd h\u1ee3p \u0111\u1ed3ng th\u1eed vi\u1ec7c<\/p>\n<\/td>\n

\n

\u0110\u00e1nh d\u1ea5u<\/p>\n<\/td>\n<\/tr>\n

\n

\u0110\u00e3 n\u1ed9p \u0111\u1ee7 h\u1ed3 s\u01a1<\/p>\n<\/td>\n

\n

\u0110\u00e1nh d\u1ea5u<\/p>\n<\/td>\n<\/tr>\n

\n

\u0110\u00e3 c\u1ea5p email v\u00e0 t\u00e0i kho\u1ea3n<\/p>\n<\/td>\n

\n

\u0110\u00e1nh d\u1ea5u<\/p>\n<\/td>\n<\/tr>\n

\n

\u0110\u00e3 c\u1ea5p thi\u1ebft b\u1ecb<\/p>\n<\/td>\n

\n

\u0110\u00e1nh d\u1ea5u<\/p>\n<\/td>\n<\/tr>\n

\n

\u0110\u00e3 \u0111\u00e0o t\u1ea1o h\u1ed9i nh\u1eadp<\/p>\n<\/td>\n

\n

\u0110\u00e1nh d\u1ea5u<\/p>\n<\/td>\n<\/tr>\n

\n

\u0110\u00e3 \u0111\u0103ng k\u00fd b\u1ea3o hi\u1ec3m x\u00e3 h\u1ed9i<\/p>\n<\/td>\n

\n

\u0110\u00e1nh d\u1ea5u<\/p>\n<\/td>\n<\/tr>\n

\n

\u0110\u00e3 \u0111\u0103ng k\u00fd ng\u01b0\u1eddi ph\u1ee5 thu\u1ed9c<\/p>\n<\/td>\n

\n

\u0110\u00e1nh d\u1ea5u<\/p>\n<\/td>\n<\/tr>\n

\n

Ng\u00e0y h\u1ebft th\u1eed vi\u1ec7c<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

K\u1ebft qu\u1ea3 \u0111\u00e1nh gi\u00e1 th\u1eed vi\u1ec7c<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Hai c\u1ed9t v\u1ec1 b\u1ea3o hi\u1ec3m x\u00e3 h\u1ed9i v\u00e0 ng\u01b0\u1eddi ph\u1ee5 thu\u1ed9c hay b\u1ecb b\u1ecf s\u00f3t, v\u00e0 c\u1ea3 hai \u0111\u1ec1u \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn quy\u1ec1n l\u1ee3i c\u1ee7a ng\u01b0\u1eddi lao \u0111\u1ed9ng l\u1eabn ngh\u0129a v\u1ee5 c\u1ee7a doanh nghi\u1ec7p.<\/p>\n

M\u1eabu 6: Theo d\u00f5i nh\u00e2n s\u1ef1 ngh\u1ec9 vi\u1ec7c (Excel)<\/h3>\n

D\u00f9ng \u0111\u1ec3:<\/b> qu\u1ea3n l\u00fd th\u1ee7 t\u1ee5c ngh\u1ec9 vi\u1ec7c v\u00e0 ph\u00e2n t\u00edch nguy\u00ean nh\u00e2n ngh\u1ec9.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n
\n

C\u1ed9t<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

H\u1ecd t\u00ean, Ph\u00f2ng ban, Ch\u1ee9c danh<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

Ng\u00e0y v\u00e0o l\u00e0m, Ng\u00e0y ngh\u1ec9 vi\u1ec7c, Th\u00e2m ni\u00ean<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

H\u00ecnh th\u1ee9c ch\u1ea5m d\u1ee9t<\/p>\n<\/td>\n

\n

\u0110\u01a1n ph\u01b0\u01a1ng, th\u1ecfa thu\u1eadn, h\u1ebft h\u1ea1n h\u1ee3p \u0111\u1ed3ng, k\u1ef7 lu\u1eadt<\/p>\n<\/td>\n<\/tr>\n

\n

L\u00fd do ngh\u1ec9<\/p>\n<\/td>\n

\n

D\u00f9ng danh s\u00e1ch ch\u1ecdn \u0111\u1ec3 th\u1ed1ng k\u00ea \u0111\u01b0\u1ee3c<\/p>\n<\/td>\n<\/tr>\n

\n

\u0110\u00e3 b\u00e0n giao c\u00f4ng vi\u1ec7c<\/p>\n<\/td>\n

\n

\u0110\u00e1nh d\u1ea5u<\/p>\n<\/td>\n<\/tr>\n

\n

\u0110\u00e3 thu h\u1ed3i t\u00e0i s\u1ea3n<\/p>\n<\/td>\n

\n

\u0110\u00e1nh d\u1ea5u<\/p>\n<\/td>\n<\/tr>\n

\n

\u0110\u00e3 ch\u1ed1t s\u1ed5 b\u1ea3o hi\u1ec3m x\u00e3 h\u1ed9i<\/p>\n<\/td>\n

\n

\u0110\u00e1nh d\u1ea5u<\/p>\n<\/td>\n<\/tr>\n

\n

\u0110\u00e3 thanh to\u00e1n l\u01b0\u01a1ng v\u00e0 ph\u00e9p c\u00f2n l\u1ea1i<\/p>\n<\/td>\n

\n

\u0110\u00e1nh d\u1ea5u<\/p>\n<\/td>\n<\/tr>\n

\n

\u0110\u00e3 ra quy\u1ebft \u0111\u1ecbnh ngh\u1ec9 vi\u1ec7c<\/p>\n<\/td>\n

\n

\u0110\u00e1nh d\u1ea5u<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

V\u1ec1 bi\u1ec3u m\u1eabu li\u00ean quan, xem b\u00e0i m\u1eabu quy\u1ebft \u0111\u1ecbnh ngh\u1ec9 vi\u1ec7c<\/span><\/a>.<\/p>\n

V\u1ec1 c\u1ed9t L\u00fd do ngh\u1ec9:<\/b> n\u00ean d\u00f9ng danh s\u00e1ch ch\u1ecdn c\u1ed1 \u0111\u1ecbnh kho\u1ea3ng 8 \u0111\u1ebfn 10 nh\u00f3m l\u00fd do. G\u00f5 t\u1ef1 do th\u00ec cu\u1ed1i n\u0103m kh\u00f4ng th\u1ed1ng k\u00ea \u0111\u01b0\u1ee3c, v\u00e0 doanh nghi\u1ec7p m\u1ea5t \u0111i d\u1eef li\u1ec7u h\u1eefu \u00edch nh\u1ea5t v\u1ec1 v\u1ea5n \u0111\u1ec1 nh\u00e2n s\u1ef1 c\u1ee7a m\u00ecnh.<\/p>\n

M\u1eabu 7: Theo d\u00f5i bi\u1ebfn \u0111\u1ed9ng l\u01b0\u01a1ng (Excel)<\/h3>\n

D\u00f9ng \u0111\u1ec3:<\/b> l\u01b0u l\u1ecbch s\u1eed thay \u0111\u1ed5i l\u01b0\u01a1ng, ph\u1ee5c v\u1ee5 tr\u01b0\u1eddng 14 c\u1ee7a s\u1ed5 qu\u1ea3n l\u00fd lao \u0111\u1ed9ng.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n
\n

C\u1ed9t<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

M\u00e3 nh\u00e2n vi\u00ean, H\u1ecd t\u00ean, Ph\u00f2ng ban<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

Lo\u1ea1i bi\u1ebfn \u0111\u1ed9ng<\/p>\n<\/td>\n

\n

N\u00e2ng l\u01b0\u01a1ng \u0111\u1ecbnh k\u1ef3, th\u0103ng ch\u1ee9c, \u0111i\u1ec1u chuy\u1ec3n, \u0111i\u1ec1u ch\u1ec9nh<\/p>\n<\/td>\n<\/tr>\n

\n

Ng\u00e0y hi\u1ec7u l\u1ef1c<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

Ch\u1ee9c danh c\u0169, Ch\u1ee9c danh m\u1edbi<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

M\u1ee9c l\u01b0\u01a1ng c\u0169, M\u1ee9c l\u01b0\u01a1ng m\u1edbi<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

T\u1ef7 l\u1ec7 t\u0103ng<\/p>\n<\/td>\n

\n

C\u00f4ng th\u1ee9c<\/p>\n<\/td>\n<\/tr>\n

\n

M\u1ee9c \u0111\u00f3ng b\u1ea3o hi\u1ec3m c\u0169, m\u1edbi<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

S\u1ed1 quy\u1ebft \u0111\u1ecbnh<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Quan tr\u1ecdng: m\u1ed7i l\u1ea7n thay \u0111\u1ed5i l\u00e0 m\u1ed9t d\u00f2ng m\u1edbi, kh\u00f4ng ghi \u0111\u00e8 l\u00ean d\u00f2ng c\u0169. Ghi \u0111\u00e8 l\u00e0 m\u1ea5t l\u1ecbch s\u1eed.<\/p>\n

M\u1eabu 8: Danh s\u00e1ch nh\u00e2n vi\u00ean thi c\u00f4ng (Excel)<\/h3>\n

D\u00f9ng \u0111\u1ec3:<\/b> qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 ra v\u00e0o c\u00f4ng tr\u01b0\u1eddng, th\u01b0\u1eddng ph\u1ea3i n\u1ed9p cho ch\u1ee7 \u0111\u1ea7u t\u01b0 ho\u1eb7c ban qu\u1ea3n l\u00fd d\u1ef1 \u00e1n.<\/p>\n\n\n\n\n\n\n\n\n\n\n
\n

C\u1ed9t<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

S\u1ed1 th\u1ee9 t\u1ef1, S\u1ed1 th\u1ebb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

H\u1ecd v\u00e0 t\u00ean, N\u0103m sinh<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

S\u1ed1 c\u0103n c\u01b0\u1edbc, Ng\u00e0y c\u1ea5p, N\u01a1i c\u1ea5p<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

Ch\u1ee9c danh, T\u1ed5 \u0111\u1ed9i<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

Ch\u1ee9ng ch\u1ec9 an to\u00e0n lao \u0111\u1ed9ng<\/p>\n<\/td>\n

\n

S\u1ed1 v\u00e0 ng\u00e0y h\u1ebft h\u1ea1n<\/p>\n<\/td>\n<\/tr>\n

\n

\u0110\u00e3 kh\u00e1m s\u1ee9c kh\u1ecfe<\/p>\n<\/td>\n

\n

Ng\u00e0y kh\u00e1m<\/p>\n<\/td>\n<\/tr>\n

\n

Th\u1eddi gian ra v\u00e0o<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Hai c\u1ed9t v\u1ec1 ch\u1ee9ng ch\u1ec9 an to\u00e0n v\u00e0 kh\u00e1m s\u1ee9c kh\u1ecfe l\u00e0 y\u00eau c\u1ea7u th\u01b0\u1eddng g\u1eb7p c\u1ee7a ch\u1ee7 \u0111\u1ea7u t\u01b0 nh\u01b0ng hay b\u1ecb thi\u1ebfu trong c\u00e1c m\u1eabu l\u01b0u h\u00e0nh tr\u00ean m\u1ea1ng.<\/p>\n

M\u1eabu 9: Danh s\u00e1ch nh\u00e2n vi\u00ean b\u1ea3n Word<\/h3>\n

D\u00f9ng \u0111\u1ec3:<\/b> in ra k\u00fd, \u0111\u00f3ng d\u1ea5u, g\u1eedi k\u00e8m c\u00f4ng v\u0103n ho\u1eb7c h\u1ed3 s\u01a1.<\/p>\n

C\u1ea5u tr\u00fac:<\/b><\/b><\/p>\n

T\u00caN C\u00d4NG TY\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>C\u1ed8NG H\u00d2A X\u00c3 H\u1ed8I CH\u1ee6 NGH\u0128A VI\u1ec6T NAM
\n<\/span>S\u1ed1: …\/DS-…\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>\u0110\u1ed9c l\u1eadp – T\u1ef1 do – H\u1ea1nh ph\u00fac<\/p>\n

<\/span>\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>…, ng\u00e0y … th\u00e1ng … n\u0103m …<\/p>\n

<\/span>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>DANH S\u00c1CH NH\u00c2N VI\u00caN
\n<\/span>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>(V\/v …………………)<\/p>\n

<\/span>[B\u1ea3ng: STT | H\u1ecd v\u00e0 t\u00ean | N\u0103m sinh | Gi\u1edbi t\u00ednh | S\u1ed1 c\u0103n c\u01b0\u1edbc |
\n<\/span> Ch\u1ee9c danh | Ph\u00f2ng ban | Ghi ch\u00fa]<\/p>\n

<\/span>T\u1ed5ng s\u1ed1: ….. ng\u01b0\u1eddi, trong \u0111\u00f3 n\u1eef: ….. ng\u01b0\u1eddi.<\/p>\n

<\/span>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>\u0110\u1ea0I DI\u1ec6N C\u00d4NG TY
\n<\/span>\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>(K\u00fd, ghi r\u00f5 h\u1ecd t\u00ean, \u0111\u00f3ng d\u1ea5u)<\/p>\n

Hai l\u01b0u \u00fd khi l\u00e0m b\u1ea3n Word:<\/b><\/b><\/p>\n

H\u1ea1n ch\u1ebf s\u1ed1 c\u1ed9t. B\u1ea3n in kh\u1ed5 A4 d\u1ecdc ch\u1ec9 ch\u1ee9a \u0111\u01b0\u1ee3c kho\u1ea3ng 7 \u0111\u1ebfn 8 c\u1ed9t l\u00e0 \u0111\u1ecdc tho\u1ea3i m\u00e1i. C\u1ea7n nhi\u1ec1u c\u1ed9t h\u01a1n th\u00ec chuy\u1ec3n kh\u1ed5 ngang.<\/p>\n

C\u00e2n nh\u1eafc c\u00f3 n\u00ean \u0111\u01b0a s\u1ed1 c\u0103n c\u01b0\u1edbc v\u00e0o b\u1ea3n g\u1eedi ra ngo\u00e0i hay kh\u00f4ng. N\u1ebfu b\u00ean nh\u1eadn kh\u00f4ng th\u1ef1c s\u1ef1 c\u1ea7n, n\u00ean b\u1ecf c\u1ed9t n\u00e0y ho\u1eb7c ch\u1ec9 ghi 4 s\u1ed1 cu\u1ed1i, theo tinh th\u1ea7n ch\u1ec9 cung c\u1ea5p d\u1eef li\u1ec7u c\u00e1 nh\u00e2n \u1edf m\u1ee9c c\u1ea7n thi\u1ebft.<\/p>\n

B\u1ea3ng ch\u1ecdn m\u1eabu theo t\u00ecnh hu\u1ed1ng<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n

T\u00ecnh hu\u1ed1ng<\/p>\n<\/td>\n

\n

M\u1eabu n\u00ean d\u00f9ng<\/p>\n<\/td>\n

\n

\u0110\u1ecbnh d\u1ea1ng<\/p>\n<\/td>\n<\/tr>\n

\n

Doanh nghi\u1ec7p m\u1edbi th\u00e0nh l\u1eadp, c\u1ea7n \u0111\u00e1p \u1ee9ng quy \u0111\u1ecbnh<\/p>\n<\/td>\n

\n

M\u1eabu 1<\/p>\n<\/td>\n

\n

Excel<\/p>\n<\/td>\n<\/tr>\n

\n

Qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 h\u1eb1ng ng\u00e0y<\/p>\n<\/td>\n

\n

M\u1eabu 2<\/p>\n<\/td>\n

\n

Excel<\/p>\n<\/td>\n<\/tr>\n

\n

B\u00e1o c\u00e1o c\u01a1 c\u1ea5u nh\u00e2n s\u1ef1 cho ban gi\u00e1m \u0111\u1ed1c<\/p>\n<\/td>\n

\n

M\u1eabu 3<\/p>\n<\/td>\n

\n

Excel<\/p>\n<\/td>\n<\/tr>\n

\n

Tr\u00e1nh qu\u00ean t\u00e1i k\u00fd h\u1ee3p \u0111\u1ed3ng<\/p>\n<\/td>\n

\n

M\u1eabu 4<\/p>\n<\/td>\n

\n

Excel<\/p>\n<\/td>\n<\/tr>\n

\n

Ti\u1ebfp nh\u1eadn ng\u01b0\u1eddi m\u1edbi<\/p>\n<\/td>\n

\n

M\u1eabu 5<\/p>\n<\/td>\n

\n

Excel<\/p>\n<\/td>\n<\/tr>\n

\n

X\u1eed l\u00fd th\u1ee7 t\u1ee5c ngh\u1ec9 vi\u1ec7c<\/p>\n<\/td>\n

\n

M\u1eabu 6<\/p>\n<\/td>\n

\n

Excel<\/p>\n<\/td>\n<\/tr>\n

\n

Chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u cho b\u00e1o c\u00e1o 01\/PLI<\/p>\n<\/td>\n

\n

M\u1eabu 1 v\u00e0 2<\/p>\n<\/td>\n

\n

Excel<\/p>\n<\/td>\n<\/tr>\n

\n

G\u1eedi k\u00e8m h\u1ed3 s\u01a1 th\u1ea7u, h\u1ed3 s\u01a1 n\u0103ng l\u1ef1c<\/p>\n<\/td>\n

\n

M\u1eabu 9<\/p>\n<\/td>\n

\n

Word<\/p>\n<\/td>\n<\/tr>\n

\n

N\u1ed9p danh s\u00e1ch nh\u00e2n s\u1ef1 v\u00e0o c\u00f4ng tr\u01b0\u1eddng<\/p>\n<\/td>\n

\n

M\u1eabu 8 ho\u1eb7c 9<\/p>\n<\/td>\n

\n

Excel ho\u1eb7c Word<\/p>\n<\/td>\n<\/tr>\n

\n

Danh s\u00e1ch k\u00e8m quy\u1ebft \u0111\u1ecbnh n\u1ed9i b\u1ed9<\/p>\n<\/td>\n

\n

M\u1eabu 9<\/p>\n<\/td>\n

\n

Word<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

C\u00f4ng th\u1ee9c Excel d\u00f9ng \u0111\u01b0\u1ee3c ngay<\/h2>\n

C\u00e1c c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y gi\u1ea3 \u0111\u1ecbnh b\u1ed1 c\u1ee5c theo m\u1eabu 2. \u0110i\u1ec1u ch\u1ec9nh \u0111\u1ecba ch\u1ec9 \u00f4 theo file c\u1ee7a b\u1ea1n.<\/p>\n

C\u1ea3nh b\u00e1o h\u1ee3p \u0111\u1ed3ng s\u1eafp h\u1ebft h\u1ea1n<\/b> (M2 l\u00e0 ng\u00e0y h\u1ebft h\u1ea1n h\u1ee3p \u0111\u1ed3ng):<\/p>\n

=IF(M2=””,”Kh\u00f4ng x\u00e1c \u0111\u1ecbnh th\u1eddi h\u1ea1n”,
\n<\/span> IF(M2-TODAY()<0,”\u0110\u00e3 h\u1ebft h\u1ea1n”,
\n<\/span> IF(M2-TODAY()<=30,”S\u1eafp h\u1ebft h\u1ea1n”,”C\u00f2n hi\u1ec7u l\u1ef1c”)))<\/p>\n

S\u1ed1 ng\u00e0y c\u00f2n l\u1ea1i \u0111\u1ebfn khi h\u1ebft h\u1ea1n:<\/b><\/b><\/p>\n

=IF(M2=””,””,M2-TODAY())<\/p>\n

T\u00ednh tu\u1ed5i<\/b> (C2 l\u00e0 ng\u00e0y sinh):<\/p>\n

=IF(C2=””,””,DATEDIF(C2,TODAY(),”Y”))<\/p>\n

T\u00ednh th\u00e2m ni\u00ean theo n\u0103m v\u00e0 th\u00e1ng<\/b> (K2 l\u00e0 ng\u00e0y v\u00e0o l\u00e0m):<\/p>\n

=IF(K2=””,””,DATEDIF(K2,TODAY(),”Y”)&” n\u0103m “&DATEDIF(K2,TODAY(),”YM”)&” th\u00e1ng”)<\/p>\n

\u0110\u1ebfm s\u1ed1 ng\u01b0\u1eddi \u0111ang l\u00e0m vi\u1ec7c theo t\u1eebng ph\u00f2ng ban<\/b> (I l\u00e0 c\u1ed9t ph\u00f2ng ban, S l\u00e0 c\u1ed9t tr\u1ea1ng th\u00e1i, U2 l\u00e0 t\u00ean ph\u00f2ng c\u1ea7n \u0111\u1ebfm):<\/p>\n

=COUNTIFS($I$2:$I$1000,U2,$S$2:$S$1000,”\u0110ang l\u00e0m vi\u1ec7c”)<\/p>\n

\u0110\u1ebfm s\u1ed1 lao \u0111\u1ed9ng n\u1eef \u0111ang l\u00e0m vi\u1ec7c,<\/b> ph\u1ee5c v\u1ee5 b\u00e1o c\u00e1o 01\/PLI (D l\u00e0 c\u1ed9t gi\u1edbi t\u00ednh):<\/p>\n

=COUNTIFS($D$2:$D$1000,”N\u1eef”,$S$2:$S$1000,”\u0110ang l\u00e0m vi\u1ec7c”)<\/p>\n

T\u00ednh t\u1ed5ng qu\u1ef9 l\u01b0\u01a1ng theo ph\u00f2ng ban<\/b> (N l\u00e0 c\u1ed9t l\u01b0\u01a1ng c\u01a1 b\u1ea3n):<\/p>\n

=SUMIFS($N$2:$N$1000,$I$2:$I$1000,U2,$S$2:$S$1000,”\u0110ang l\u00e0m vi\u1ec7c”)<\/p>\n

Che b\u1edbt s\u1ed1 c\u0103n c\u01b0\u1edbc, gi\u1eef 4 s\u1ed1 cu\u1ed1i<\/b> (E2 l\u00e0 s\u1ed1 c\u0103n c\u01b0\u1edbc):<\/p>\n

=IF(LEN(E2)<4,””,REPT(“*”,LEN(E2)-4)&RIGHT(E2,4))<\/p>\n

Tra c\u1ee9u th\u00f4ng tin theo m\u00e3 nh\u00e2n vi\u00ean,<\/b> d\u00f9ng cho c\u00e1c sheet ph\u1ee5:<\/p>\n

=IFERROR(VLOOKUP($A2,DanhSach!$A:$S,3,0),”Kh\u00f4ng t\u00ecm th\u1ea5y”)<\/p>\n

B\u1ea3n Excel t\u1eeb phi\u00ean b\u1ea3n 2021 tr\u1edf l\u00ean c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m kh\u00e1c g\u1ecdn h\u01a1n:<\/p>\n

=XLOOKUP($A2,DanhSach!$A:$A,DanhSach!$C:$C,”Kh\u00f4ng t\u00ecm th\u1ea5y”)<\/p>\n

Ba thi\u1ebft l\u1eadp n\u00ean l\u00e0m cho file<\/h2>\n

Ch\u1eb7n tr\u00f9ng m\u00e3 nh\u00e2n vi\u00ean.<\/b> Ch\u1ecdn c\u1ed9t m\u00e3 nh\u00e2n vi\u00ean, v\u00e0o Data r\u1ed3i Data Validation, ch\u1ecdn Custom v\u00e0 nh\u1eadp:<\/p>\n

=COUNTIF($A$2:$A$1000,A2)=1<\/p>\n

D\u00f9ng danh s\u00e1ch ch\u1ecdn cho c\u00e1c c\u1ed9t ph\u00e2n lo\u1ea1i.<\/b> T\u1ea1o m\u1ed9t sheet ri\u00eang ch\u1ee9a danh m\u1ee5c ph\u00f2ng ban, ch\u1ee9c danh, lo\u1ea1i h\u1ee3p \u0111\u1ed3ng, tr\u1ea1ng th\u00e1i, l\u00fd do ngh\u1ec9. R\u1ed3i \u0111\u1eb7t Data Validation ki\u1ec3u List tr\u1ecf v\u00e0o danh m\u1ee5c \u0111\u00f3. Vi\u1ec7c n\u00e0y ng\u0103n t\u00ecnh tr\u1ea1ng c\u00f9ng m\u1ed9t ph\u00f2ng ban \u0111\u01b0\u1ee3c g\u00f5 theo ba c\u00e1ch kh\u00e1c nhau, l\u00e0m h\u1ecfng m\u1ecdi c\u00f4ng th\u1ee9c \u0111\u1ebfm.<\/p>\n

T\u00f4 m\u00e0u t\u1ef1 \u0111\u1ed9ng d\u00f2ng c\u00f3 h\u1ee3p \u0111\u1ed3ng s\u1eafp h\u1ebft h\u1ea1n.<\/b> Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u, v\u00e0o Conditional Formatting, ch\u1ecdn New Rule ki\u1ec3u c\u00f4ng th\u1ee9c v\u00e0 nh\u1eadp:<\/p>\n

=AND($M2<>””,$M2-TODAY()<=30,$M2-TODAY()>=0)<\/p>\n

Ch\u1ecdn m\u00e0u n\u1ec1n c\u1ea3nh b\u00e1o. T\u1eeb \u0111\u00f3 m\u1ed7i l\u1ea7n m\u1edf file l\u00e0 th\u1ea5y ngay h\u1ee3p \u0111\u1ed3ng n\u00e0o c\u1ea7n x\u1eed l\u00fd.<\/p>\n

Khi n\u00e0o Excel kh\u00f4ng c\u00f2n \u0111\u1ee7<\/h2>\n

Excel ph\u00f9 h\u1ee3p \u0111\u1ebfn m\u1ed9t quy m\u00f4 nh\u1ea5t \u0111\u1ecbnh. B\u1ed1n d\u1ea5u hi\u1ec7u cho th\u1ea5y \u0111\u00e3 \u0111\u1ebfn l\u00fac c\u1ea7n c\u00f4ng c\u1ee5 kh\u00e1c:<\/p>\n\n\n\n\n\n\n\n
\n

D\u1ea5u hi\u1ec7u<\/p>\n<\/td>\n

\n

V\u1ea5n \u0111\u1ec1 b\u00ean d\u01b0\u1edbi<\/p>\n<\/td>\n<\/tr>\n

\n

Nhi\u1ec1u b\u1ea3n file tr\u00f4i n\u1ed5i, kh\u00f4ng bi\u1ebft b\u1ea3n n\u00e0o m\u1edbi nh\u1ea5t<\/p>\n<\/td>\n

\n

Kh\u00f4ng c\u00f3 ngu\u1ed3n d\u1eef li\u1ec7u duy nh\u1ea5t<\/p>\n<\/td>\n<\/tr>\n

\n

Ph\u1ea3i nh\u1eadp l\u1ea1i th\u00f4ng tin nh\u00e2n s\u1ef1 sang file ch\u1ea5m c\u00f4ng v\u00e0 file l\u01b0\u01a1ng<\/p>\n<\/td>\n

\n

D\u1eef li\u1ec7u kh\u00f4ng li\u00ean th\u00f4ng, sai s\u00f3t t\u00edch t\u1ee5<\/p>\n<\/td>\n<\/tr>\n

\n

Ai m\u1edf file c\u0169ng xem \u0111\u01b0\u1ee3c l\u01b0\u01a1ng c\u1ee7a m\u1ecdi ng\u01b0\u1eddi<\/p>\n<\/td>\n

\n

Kh\u00f4ng ph\u00e2n quy\u1ec1n theo c\u1ed9t v\u00e0 theo d\u00f2ng<\/p>\n<\/td>\n<\/tr>\n

\n

Kh\u00f4ng bi\u1ebft ai s\u1eeda g\u00ec, s\u1eeda khi n\u00e0o<\/p>\n<\/td>\n

\n

Kh\u00f4ng c\u00f3 l\u01b0u v\u1ebft, r\u1ee7i ro khi c\u00f3 tranh ch\u1ea5p<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

D\u1ea5u hi\u1ec7u th\u1ee9 ba \u0111\u00e1ng ch\u00fa \u00fd nh\u1ea5t t\u1eeb 01\/01\/2026, khi Lu\u1eadt B\u1ea3o v\u1ec7 d\u1eef li\u1ec7u c\u00e1 nh\u00e2n c\u00f3 hi\u1ec7u l\u1ef1c. File Excel kh\u00f4ng ph\u00e2n quy\u1ec1n \u0111\u01b0\u1ee3c \u1edf m\u1ee9c t\u1eebng c\u1ed9t, n\u00ean ho\u1eb7c l\u00e0 kh\u00f3a c\u1ea3 file, ho\u1eb7c l\u00e0 ai m\u1edf \u0111\u01b0\u1ee3c c\u0169ng xem \u0111\u01b0\u1ee3c t\u1ea5t c\u1ea3.<\/p>\n

Qu\u1ea3n l\u00fd danh s\u00e1ch nh\u00e2n s\u1ef1 tr\u00ean h\u1ec7 th\u1ed1ng<\/h2>\n

Ph\u00e2n h\u1ec7 qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 c\u1ee7a Arito<\/a><\/span> x\u1eed l\u00fd c\u00e1c h\u1ea1n ch\u1ebf \u1edf tr\u00ean:<\/span><\/p>\n