{"id":9973,"date":"2025-01-06T09:05:26","date_gmt":"2025-01-06T09:05:26","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/06\/huong-dan-cach-tao-file-excel-tinh-tien-thuong-tet-2019\/"},"modified":"2025-01-06T09:05:26","modified_gmt":"2025-01-06T09:05:26","slug":"huong-dan-cach-tao-file-excel-tinh-tien-thuong-tet-2019","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/06\/huong-dan-cach-tao-file-excel-tinh-tien-thuong-tet-2019\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ea1o file Excel t\u00ednh ti\u1ec1n th\u01b0\u1edfng t\u1ebft 2019"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>C\u1ee9\u00a0\u0111\u1ebfn cu\u1ed1i m\u1ed7i n\u0103m th\u00ec c\u00e2u chuy\u1ec7n ti\u1ec1n th\u01b0\u1edfng l\u1ea1i tr\u1edf th\u00e0nh ch\u1ee7\u00a0\u0111\u1ec1\u00a0\u0111\u01b0\u1ee3c b\u00e0n t\u00e1n kh\u00e1 s\u00f4i n\u1ed5i. V\u1edbi nh\u1eefng ai l\u00e0m c\u00f4ng t\u00e1c qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1, h\u00e0nh ch\u00ednh v\u0103n ph\u00f2ng th\u00ec vi\u1ec7c kh\u00f4ng th\u1ec3 kh\u00f4ng l\u00e0m l\u00e0 ph\u1ea3i l\u1eadp b\u1ea3ng t\u00ednh ti\u1ec1n th\u01b0\u1edfng t\u1ebft. B\u1ea1n c\u00f3 g\u1eb7p kh\u00f3 kh\u0103n g\u00ec v\u1edbi vi\u1ec7c n\u00e0y kh\u00f4ng?\u00a0H\u00e3y c\u00f9ng H\u1ecdc\u00a0Excel Online t\u00ecm hi\u1ec3u\u00a0c\u00e1ch t\u1ea1o file Excel t\u00ednh ti\u1ec1n th\u01b0\u1edfng t\u1ebft 2019 nh\u00e9.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-677b9cd5d29d1\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tao-file-excel-tinh-tien-thuong-tet-2019.html#Nhung_can_cu_tinh_thuong_tet\" title=\"Nh\u1eefng c\u0103n c\u1ee9 t\u00ednh\u00a0th\u01b0\u1edfng t\u1ebft\">Nh\u1eefng c\u0103n c\u1ee9 t\u00ednh\u00a0th\u01b0\u1edfng t\u1ebft<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tao-file-excel-tinh-tien-thuong-tet-2019.html#Nang_suat_lao_dong\" title=\"N\u0103ng su\u1ea5t lao\u00a0\u0111\u1ed9ng\">N\u0103ng su\u1ea5t lao\u00a0\u0111\u1ed9ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tao-file-excel-tinh-tien-thuong-tet-2019.html#Tham_nien_lam_viec\" title=\"Th\u00e2m ni\u00ean l\u00e0m vi\u1ec7c\">Th\u00e2m ni\u00ean l\u00e0m vi\u1ec7c<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tao-file-excel-tinh-tien-thuong-tet-2019.html#Lap_bang_tinh_tien_thuong_tet_tren_Excel\" title=\"L\u1eadp b\u1ea3ng t\u00ednh ti\u1ec1n th\u01b0\u1edfng t\u1ebft tr\u00ean\u00a0Excel\">L\u1eadp b\u1ea3ng t\u00ednh ti\u1ec1n th\u01b0\u1edfng t\u1ebft tr\u00ean\u00a0Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tao-file-excel-tinh-tien-thuong-tet-2019.html#Cach_trinh_bay_dinh_dang_bang_tinh\" title=\"C\u00e1ch tr\u00ecnh b\u00e0y\u00a0\u0111\u1ecbnh d\u1ea1ng b\u1ea3ng t\u00ednh\">C\u00e1ch tr\u00ecnh b\u00e0y\u00a0\u0111\u1ecbnh d\u1ea1ng b\u1ea3ng t\u00ednh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tao-file-excel-tinh-tien-thuong-tet-2019.html#Xay_dung_cong_thuc_tinh\" title=\"X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c t\u00ednh\">X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c t\u00ednh<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tao-file-excel-tinh-tien-thuong-tet-2019.html#Tinh_tham_nien\" title=\"T\u00ednh th\u00e2m ni\u00ean\">T\u00ednh th\u00e2m ni\u00ean<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tao-file-excel-tinh-tien-thuong-tet-2019.html#Tinh_tham_nien_duoc_thuong\" title=\"T\u00ednh % th\u00e2m ni\u00ean\u00a0\u0111\u01b0\u1ee3c th\u01b0\u1edfng\">T\u00ednh % th\u00e2m ni\u00ean\u00a0\u0111\u01b0\u1ee3c th\u01b0\u1edfng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tao-file-excel-tinh-tien-thuong-tet-2019.html#Tinh_nang_suat_duoc_thuong\" title=\"T\u00ednh % n\u0103ng su\u1ea5t\u00a0\u0111\u01b0\u1ee3c th\u01b0\u1edfng\">T\u00ednh % n\u0103ng su\u1ea5t\u00a0\u0111\u01b0\u1ee3c th\u01b0\u1edfng<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Nhung_can_cu_tinh_thuong_tet\"><\/span>Nh\u1eefng c\u0103n c\u1ee9 t\u00ednh\u00a0th\u01b0\u1edfng t\u1ebft<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n l\u1eadp b\u1ea3ng t\u00ednh tr\u00ean\u00a0Excel, ch\u00fang ta c\u1ea7n ph\u1ea3i l\u00e0m r\u00f5 nh\u1eefng c\u0103n c\u1ee9 t\u00ednh th\u01b0\u1edfng t\u1ebft. B\u1edfi trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p vi\u1ec7c quy\u00a0\u0111\u1ecbnh th\u01b0\u1edfng t\u1ebft kh\u00e1 ph\u1ee9c t\u1ea1p, n\u1ebfu kh\u00f4ng l\u00e0m r\u00f5 ngay t\u1eeb\u00a0\u0111\u1ea7u th\u00ec r\u1ea5t d\u1ec5 sai s\u00f3t khi l\u00e0m tr\u00ean\u00a0Excel.<\/p>\n<p>Nh\u1eefng ti\u00eau ch\u00ed l\u00e0m c\u0103n c\u1ee9 t\u00ednh ti\u1ec1n th\u01b0\u1edfng t\u1ebft bao g\u1ed3m:<\/p>\n<ul>\n<li>Ti\u1ec1n l\u01b0\u01a1ng\u00a0\u0111ang h\u01b0\u1edfng: l\u00e0\u00a0m\u1ee9c l\u01b0\u01a1ng\u00a0\u0111ang h\u01b0\u1edfng h\u00e0ng th\u00e1ng c\u1ee7a ng\u01b0\u1eddi lao\u00a0\u0111\u1ed9ng. Kho\u1ea3n n\u00e0y kh\u00f4ng bao g\u1ed3m c\u00e1c ph\u1ea7n v\u1ec1 tr\u1ee3 c\u1ea5p, ph\u1ee5 c\u1ea5p.<\/li>\n<li>C\u00e1c ti\u00eau ch\u00ed x\u00e9t th\u01b0\u1edfng: N\u0103ng su\u1ea5t lao\u00a0\u0111\u1ed9ng, th\u00e2m ni\u00ean l\u00e0m vi\u1ec7c, ch\u1ea5p h\u00e0nh k\u1ef7 lu\u1eadt lao\u00a0\u0111\u1ed9ng\u2026 Ti\u00eau ch\u00ed n\u00e0y ph\u1ee5 thu\u1ed9c v\u00e0o\u00a0\u0111\u1eb7c\u00a0\u0111i\u1ec3m t\u1eebng doanh nghi\u1ec7p. C\u00e1c ti\u00eau ch\u00ed\u00a0\u0111\u1ec1u quy v\u1ec1 gi\u00e1 tr\u1ecb %\u00a0\u0111\u1ec3\u00a0t\u00ednh ra s\u1ed1 ti\u1ec1n th\u01b0\u1edfng.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Nang_suat_lao_dong\"><\/span>N\u0103ng su\u1ea5t lao\u00a0\u0111\u1ed9ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>N\u0103ng su\u1ea5t lao\u00a0\u0111\u1ed9ng th\u1ec3 hi\u1ec7n hi\u1ec7u qu\u1ea3 v\u00e0\u00a0\u00fd th\u1ee9c l\u00e0m vi\u1ec7c. N\u0103ng su\u1ea5t c\u00e0ng cao ch\u1ee9ng t\u1ecf ng\u01b0\u1eddi lao\u00a0\u0111\u1ed9ng\u00a0\u0111\u00e3 c\u1ed1 g\u1eafng v\u00e0 c\u00f3\u00a0\u00fd th\u1ee9c l\u00e0m vi\u1ec7c t\u1ed1t.\u00a0\u0110\u00e2y l\u00e0 m\u1ed9t ti\u00eau ch\u00ed th\u01b0\u1eddng th\u1ea5y khi x\u00e9t th\u01b0\u1edfng cho ng\u01b0\u1eddi lao\u00a0\u0111\u1ed9ng.<\/p>\n<p>V\u00ed d\u1ee5: Trong doanh nghi\u1ec7p A x\u00e9t n\u0103ng su\u1ea5t lao\u00a0\u0111\u1ed9ng theo ph\u01b0\u01a1ng th\u1ee9c ch\u1ea5m\u00a0\u0111i\u1ec3m, trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>\u0110i\u1ec3m S:\u00a0\u0110\u1ea1t\u00a0s\u1ea3n l\u01b0\u1ee3ng quy\u00a0\u0111\u1ecbnh trong 3 th\u00e1ng g\u1ea7n nh\u1ea5t. M\u1ee9c th\u01b0\u1edfng 100%<\/li>\n<li>\u0110i\u1ec3m A:\u00a0\u0110\u1ea1t\u00a0s\u1ea3n l\u01b0\u1ee3ng quy\u00a0\u0111\u1ecbnh trong th\u00e1ng\u00a0\u0111\u00f3. M\u1ee9c th\u01b0\u1edfng 70%<\/li>\n<li>\u0110i\u1ec3m B:\u00a0\u0110\u1ea1t\u00a0\u1edf m\u1ee9c t\u1eeb 80% tr\u1edf l\u00ean. M\u1ee9c th\u01b0\u1edfng 50%<\/li>\n<li>\u0110i\u1ec3m C:\u00a0\u0110\u1ea1t\u00a0\u1edf m\u1ee9c 50% tr\u1edf l\u00ean. M\u1ee9c th\u01b0\u1edfng 20%<\/li>\n<li>\u0110i\u1ec3m D: Kh\u00f4ng\u00a0\u0111\u1ea3m b\u1ea3o n\u0103ng su\u1ea5t y\u00eau c\u1ea7u. M\u1ee9c th\u01b0\u1edfng 0%<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Tham_nien_lam_viec\"><\/span>Th\u00e2m ni\u00ean l\u00e0m vi\u1ec7c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Th\u00e2m ni\u00ean l\u00e0 qu\u00e3ng th\u1eddi gian l\u00e0m vi\u1ec7c li\u00ean t\u1ee5c c\u1ee7a ng\u01b0\u1eddi lao \u0111\u1ed9ng t\u1ea1i doanh nghi\u1ec7p. Th\u00e2m ni\u00ean ph\u1ea3n\u00a0\u00e1nh s\u1ef1 g\u1eafn b\u00f3 v\u1edbi c\u00f4ng vi\u1ec7c, v\u1edbi c\u00f4ng ty. Ngo\u00e0i ra th\u00e2m ni\u00ean\u00a0c\u00f2n th\u1ec3 hi\u1ec7n y\u1ebfu t\u1ed1 kinh nghi\u1ec7m c\u1ee7a ng\u01b0\u1eddi lao\u00a0\u0111\u1ed9ng, gi\u1ea3m\u00a0\u00e1p l\u1ef1c tuy\u1ec3n d\u1ee5ng v\u00e0\u00a0\u0111\u00e0o t\u1ea1o nh\u00e2n s\u1ef1 m\u1edbi. V\u00ec v\u1eady\u00a0\u0111\u1ec3 khuy\u1ebfn kh\u00edch ng\u01b0\u1eddi lao\u00a0\u0111\u1ed9ng\u00a0\u1ed5n\u00a0\u0111\u1ecbnh, g\u1eafn b\u00f3 v\u1edbi c\u00f4ng vi\u1ec7c, c\u00e1c doanh nghi\u1ec7p th\u01b0\u1eddng l\u1ea5y ti\u00eau ch\u00ed th\u00e2m ni\u00ean l\u00e0m vi\u1ec7c\u00a0\u0111\u1ec3 x\u00e9t th\u01b0\u1edfng.<\/p>\n<p>V\u00ed d\u1ee5: Doanh nghi\u1ec7p A\u00a0\u00e1p d\u1ee5ng m\u1ee9c th\u01b0\u1edfng v\u1edbi th\u00e2m ni\u00ean l\u00e0m vi\u1ec7c nh\u01b0 sau:<\/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\/2025\/01\/ex101_92019-nho-116.gif\" title=\"ex101_92019-nho-116\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>D\u01b0\u1edbi 1 n\u0103m \u2013 M\u1ee9c th\u01b0\u1edfng 10%<\/li>\n<li>T\u1eeb 1 n\u0103m\u00a0\u0111\u1ebfn d\u01b0\u1edbi 2 n\u0103m \u2013 M\u1ee9c th\u01b0\u1edfng 20%<\/li>\n<li>T\u1eeb 2 n\u0103m\u00a0\u0111\u1ebfn 5 n\u0103m \u2013 M\u1ee9c th\u01b0\u1edfng 30%<\/li>\n<li>T\u1eeb tr\u00ean 5 n\u0103m \u2013 M\u1ee9c th\u01b0\u1edfng 50%<\/li>\n<\/ul>\n<p>C\u00e1ch t\u00ednh ti\u1ec1n th\u01b0\u1edfng:<\/p>\n<ul>\n<li>T\u1ed5ng % ti\u1ec1n th\u01b0\u1edfng = % n\u0103ng su\u1ea5t lao\u00a0\u0111\u1ed9ng + % th\u00e2m ni\u00ean<\/li>\n<li>Ti\u1ec1n th\u01b0\u1edfng = % ti\u1ec1n th\u01b0\u1edfng * M\u1ee9c l\u01b0\u01a1ng th\u00e1ng<\/li>\n<\/ul>\n<p>Khi\u00a0\u0111\u00e3 x\u00e1c\u00a0\u0111\u1ecbnh h\u1ebft c\u00e1c y\u1ebfu t\u1ed1 li\u00ean quan t\u1edbi c\u00e1ch t\u00ednh ti\u1ec1n th\u01b0\u1edfng, ch\u00fang ta ti\u1ebfn h\u00e0nh l\u1eadp b\u1ea3ng t\u00ednh tr\u00ean\u00a0Excel nh\u01b0 sau<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Lap_bang_tinh_tien_thuong_tet_tren_Excel\"><\/span>L\u1eadp b\u1ea3ng t\u00ednh ti\u1ec1n th\u01b0\u1edfng t\u1ebft tr\u00ean\u00a0Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 b\u1eaft\u00a0\u0111\u1ea7u, ch\u00fang ta c\u1ea7n c\u00f3:<\/p>\n<ul>\n<li>M\u1ed9t b\u1ea3ng g\u1ed3m<strong> danh s\u00e1ch nh\u00e2n vi\u00ean,<\/strong>\u00a0trong\u00a0\u0111\u00f3 c\u00f3 s\u1eb5n c\u00e1c th\u00f4ng tin nh\u01b0 : H\u1ecd t\u00ean, Ng\u00e0y v\u00e0o l\u00e0m,\u00a0\u0110i\u1ec3m, M\u1ee9c l\u01b0\u01a1ng th\u00e1ng<\/li>\n<li>M\u1ed9t b\u1ea3ng v\u1ec1\u00a0<strong>t\u00ednh th\u01b0\u1edfng theo n\u0103ng su\u1ea5t<\/strong>, trong\u00a0\u0111\u00f3 x\u00e1c\u00a0\u0111\u1ecbnh m\u1ee9c % th\u01b0\u1edfng theo t\u1eebng h\u1ec7 s\u1ed1\u00a0\u0111i\u1ec3m (theo n\u1ed9i dung ph\u1ea7n c\u0103n c\u1ee9 th\u01b0\u1edfng)<\/li>\n<li>M\u1ed9t b\u1ea3ng v\u1ec1 <strong>t\u00ednh th\u01b0\u1edfng\u00a0theo th\u00e2m ni\u00ean<\/strong>, trong\u00a0\u0111\u00f3 x\u00e1c\u00a0\u0111\u1ecbnh m\u1ee9c % th\u01b0\u1edfng theo t\u1eebng h\u1ec7 s\u1ed1 n\u0103m th\u00e2m ni\u00ean\u00a0(theo n\u1ed9i dung ph\u1ea7n c\u0103n c\u1ee9 th\u01b0\u1edfng)<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Cach_trinh_bay_dinh_dang_bang_tinh\"><\/span>C\u00e1ch tr\u00ecnh b\u00e0y\u00a0\u0111\u1ecbnh d\u1ea1ng b\u1ea3ng t\u00ednh<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta c\u1ea7n c\u00f3 n\u1ed9i dung nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22474\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/de-bai-bang-tinh-thuong-tet.png\" width=\"1411\" height=\"404\" title=\"de-bai-bang-tinh-thuong-tet\"><\/p>\n<p>V\u1ec1 c\u00e1ch tr\u00ecnh b\u00e0y,\u00a0\u0111\u1ecbnh d\u1ea1ng trong\u00a0Excel\u00a0\u0111\u1ec3 c\u00f3\u00a0\u0111\u01b0\u1ee3c hi\u1ec7u qu\u1ea3 th\u1ea9m m\u1ef9 nh\u01b0 v\u1eady th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 l\u00e0m theo c\u00e1c g\u1ee3i\u00a0\u00fd sau:<\/p>\n<ul>\n<li>A1 \u2013 m\u1ee5c Cell Styles ch\u1ecdn <strong>Title<\/strong>, sau\u00a0\u0111\u00f3 ch\u1ecdn l\u1ea1i font ch\u1eef l\u00e0 Time New Roman (v\u00ec m\u1eb7c\u00a0\u0111\u1ecbnh font ch\u1eef c\u1ee7a Title s\u1ebd theo font ch\u1eef m\u1eb7c\u00a0\u0111\u1ecbnh c\u1ee7a\u00a0Excel)<\/li>\n<li>B2:J2 \u2013\u00a0\u00a0m\u1ee5c Cell Styles ch\u1ecdn <strong>Heading 2<\/strong> (c\u00f3 th\u1ec3\u00a0\u0111\u1eb7t font ch\u1eef nh\u1ecf\u00a0\u0111i 1 ch\u00fat)<\/li>\n<li>A3:J3 \u2013 m\u1ee5c Cell Styles ch\u1ecdn <strong>Heading 3<\/strong>\u00a0(c\u00f3 th\u1ec3\u00a0\u0111\u1eb7t font ch\u1eef nh\u1ecf\u00a0\u0111i 1 ch\u00fat),\u00a0\u00f4 K2:K3 ch\u1ecdn Merge cell (tr\u1ed9n\u00a0\u00f4)<\/li>\n<li>A14:K14 \u2013 m\u1ee5c Cell Styles ch\u1ecdn <strong>Total<\/strong><\/li>\n<li>M1:N1 \u2013\u00a0\u00a0m\u1ee5c Cell Styles ch\u1ecdn\u00a0<strong>Heading 2<\/strong><\/li>\n<li>M2:N2\u00a0\u2013\u00a0\u00a0m\u1ee5c Cell Styles ch\u1ecdn\u00a0<strong>Heading 3<\/strong><\/li>\n<li>M9:N9 \u2013\u00a0\u00a0m\u1ee5c Cell Styles ch\u1ecdn\u00a0<strong>Heading 2<\/strong><\/li>\n<li>M10:N10 \u2013\u00a0\u00a0m\u1ee5c Cell Styles ch\u1ecdn\u00a0<strong>Heading 3<\/strong><\/li>\n<li>C\u00e1c\u00a0\u00f4 I1 v\u00e0 K1 ch\u1ecdn Cell Styles l\u00e0 <strong>Note<\/strong><\/li>\n<\/ul>\n<p>C\u00f2n l\u1ea1i ch\u00fang ta th\u1ef1c hi\u1ec7n k\u1ebb khung cho b\u1ea3ng t\u00ednh b\u1eb1ng <strong>Format Cells\/ Bolder<\/strong><\/p>\n<p>Nh\u01b0 v\u1eady c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y vi\u1ec7c\u00a0\u0111\u1ecbnh d\u1ea1ng b\u1ea3ng t\u00ednh b\u1eb1ng Cell Styles r\u1ea5t nhanh v\u00e0\u00a0\u0111em l\u1ea1i hi\u1ec3u qu\u1ea3 kh\u00e1 t\u1ed1t ph\u1ea3i kh\u00f4ng n\u00e0o. Khi l\u00e0m vi\u1ec7c tr\u00ean\u00a0Excel, ch\u00fang ta c\u1ed1 g\u1eafng n\u00e2ng cao kh\u1ea3 n\u0103ng tr\u00ecnh b\u00e0y sao cho khoa h\u1ecdc v\u00e0 th\u1ea9m m\u1ef9\u00a0\u0111\u1ec3 b\u1ea3ng d\u1eef li\u1ec7u\u00a0\u0111\u1eb9p h\u01a1n, d\u1ec5 nh\u00ecn h\u01a1n nh\u00e9. Cell Styles c\u0169ng l\u00e0 m\u1ed9t n\u1ed9i dung quan tr\u1ecdng khi ch\u00fang ta th\u1ef1c hi\u1ec7n b\u00e0i thi MOS\u00a0Excel n\u1eefa\u00a0\u0111\u00f3.<\/p>\n<p style=\"padding-left: 30px\">Tham kh\u1ea3o:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/thiet-lap-dinh-dang-va-ap-dung-cell-styles-mos-excel.html\">C\u00e1ch thi\u1ebft l\u1eadp, \u0111\u1ecbnh d\u1ea1ng v\u00e0 \u00e1p d\u1ee5ng Cell Styles trong b\u00e0i thi MOS Excel<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Xay_dung_cong_thuc_tinh\"><\/span>X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c t\u00ednh<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00f4ng vi\u1ec7c ti\u1ebfp theo l\u00e0 ch\u00fang ta s\u1ebd ph\u1ea3i s\u1eed d\u1ee5ng c\u00e1c h\u00e0m, c\u00f4ng th\u1ee9c trong\u00a0Excel\u00a0\u0111\u1ec3 t\u00ednh to\u00e1n ra k\u1ebft qu\u1ea3 cho c\u00e1c c\u1ed9t F -&gt; K, gi\u00fap ho\u00e0n thi\u1ec7n b\u1ea3ng t\u00ednh.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Tinh_tham_nien\"><\/span><strong>T\u00ednh th\u00e2m ni\u00ean<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>V\u1ec1 n\u1ed9i dung n\u00e0y, H\u1ecdc\u00a0Excel Online\u00a0\u0111\u00e3 c\u00f3 h\u1eb3n 1 b\u00e0i vi\u1ebft ri\u00eang\u00a0\u0111\u1ec3 ph\u00e2n t\u00edch v\u00e0 x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c t\u00ednh s\u1ed1 th\u00e1ng th\u00e2m ni\u00ean r\u1ed3i. B\u1ea1n h\u00e3y\u00a0\u0111\u1ecdc b\u00e0i vi\u1ebft sau:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-tinh-phu-cap-tham-nien-tren-excel.html\">C\u00e1ch t\u00ednh ph\u1ee5 c\u1ea5p th\u00e2m ni\u00ean tr\u00ean Excel<\/a><\/p>\n<p>\u00c1p d\u1ee5ng v\u00e0o b\u1ea3ng t\u00ednh n\u00e0y ch\u00fang ta c\u00f3:<\/p>\n<p>S\u1ed1 th\u00e0ng th\u00e2m ni\u00ean (t\u00ednh cho \u00f4 F4)\u00a0= S\u1ed1 th\u00e1ng (quy\u00a0\u0111\u1ed5i) theo th\u1eddi gian x\u00e9t th\u01b0\u1edfng \u2013 S\u1ed1 th\u00e1ng (quy\u00a0\u0111\u1ed5i) theo Ng\u00e0y v\u00e0o l\u00e0m<\/p>\n<ul>\n<li>S\u1ed1 th\u00e1ng (quy\u00a0\u0111\u1ed5i) theo th\u1eddi gian x\u00e9t th\u01b0\u1edfng = K1*12+I1. C\u00e1c v\u1ecb tr\u00ed K1, I1 c\u1ea7n c\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u0111\u1ec3 kh\u00f4ng thay\u00a0\u0111\u1ed5i khi filldown c\u00f4ng th\u1ee9c t\u1ea1i F4 xu\u1ed1ng c\u00e1c d\u00f2ng b\u00ean d\u01b0\u1edbi.<\/li>\n<li>S\u1ed1 th\u00e1ng (quy\u00a0\u0111\u1ed5i) theo Ng\u00e0y v\u00e0o l\u00e0m = Year(D4)*12+Month(D4)+IF(DAY(C4)&lt;15,1,0)<\/li>\n<\/ul>\n<p style=\"padding-left: 30px\">Trong\u00a0\u0111\u00f3\u00a0<strong>IF(DAY(C4)&lt;15,1,0)<\/strong> l\u00e0 l\u00e0m tr\u00f2n ng\u00e0y l\u00e0m vi\u1ec7c, n\u1ebfu tr\u01b0\u1edbc ng\u00e0y 15 th\u00ec l\u00e0m tr\u00f2n l\u00ean 1 th\u00e1ng.<\/p>\n<p>Nh\u01b0 v\u1eady t\u1ea1i\u00a0\u00f4 F4 ch\u00fang ta c\u00f3 c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"padding-left: 30px\">=($K$1*12+$I$1)-(YEAR(C4)*12+MONTH(C4)+IF(DAY(C4)&lt;15,1,0))<\/p>\n<p>S\u1ed1 n\u0103m th\u00e2m ni\u00ean: G4=F4\/12<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Tinh_tham_nien_duoc_thuong\"><\/span>T\u00ednh % th\u00e2m ni\u00ean\u00a0\u0111\u01b0\u1ee3c th\u01b0\u1edfng<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Tr\u01b0\u1eddng h\u1ee3p n\u00e0y ch\u00fang ta c\u1ea7n tham chi\u1ebfu <strong>S\u1ed1 n\u0103m th\u00e2m ni\u00ean<\/strong> c\u1ee7a t\u1eebng ng\u01b0\u1eddi v\u1edbi b\u1ea3ng <strong>T\u00ednh th\u01b0\u1edfng theo th\u00e2m ni\u00ean<\/strong>. Do\u00a0\u0111\u00f3 ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m VLOOKUP nh\u01b0 sau:<\/p>\n<p>H4=VLOOKUP(G4,$M$11:$N$14,2,1)<\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li><strong>G4<\/strong>: \u0110\u1ed1i t\u01b0\u1ee3ng tham chi\u1ebfu l\u00e0 <strong>s\u1ed1 n\u0103m th\u00e2m ni\u00ean<\/strong>\u00a0t\u01b0\u01a1ng\u00a0\u1ee9ng c\u1ee7a nh\u00e2n vi\u00ean<\/li>\n<li><strong>M11:N14<\/strong>: B\u1ea3ng\u00a0<strong>T\u00ednh th\u01b0\u1edfng theo th\u00e2m ni\u00ean<\/strong>. B\u1ea3ng n\u00e0y c\u1ea7n c\u1ed1\u00a0\u0111\u1ecbnh b\u1edfi c\u00f4ng th\u1ee9c c\u00f3 th\u1ec3 filldown cho nh\u1eefng nh\u00e2n vi\u00ean kh\u00e1c.<\/li>\n<li><strong>2<\/strong>: K\u1ebft qu\u1ea3 c\u1ea7n tham chi\u1ebfu l\u00e0 % th\u01b0\u1edfng, n\u1eb1m\u00a0\u1edf c\u1ed9t th\u1ee9 2 trong b\u1ea3ng\u00a0<strong>T\u00ednh th\u01b0\u1edfng theo th\u00e2m ni\u00ean<\/strong><\/li>\n<li><strong>1<\/strong>: Ph\u01b0\u01a1ng ph\u00e1p t\u00ecm ki\u1ebfm l\u00e0 t\u01b0\u01a1ng\u00a0\u0111\u1ed1i, b\u1edfi s\u1ed1 n\u0103m th\u00e2m ni\u00ean khi x\u00e9t l\u00e0 x\u00e9t theo\u00a0kho\u1ea3ng n\u0103m ch\u1ee9 kh\u00f4ng ph\u1ea3i ch\u00ednh x\u00e1c\u00a0\u0111\u00fang s\u1ed1 n\u0103m c\u1ee5 th\u1ec3.<\/li>\n<\/ul>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam v\u1ec1 h\u00e0m VLOOKUP t\u1ea1i b\u00e0i vi\u1ebft:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-cong-thuc-excel-thong-dung-trong-ke-toan-tien-luong-nhan-su-ham-vlookup.html\">H\u00e0m, c\u00f4ng th\u1ee9c excel th\u00f4ng d\u1ee5ng trong k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, nh\u00e2n s\u1ef1: H\u00e0m Vlookup<\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Tinh_nang_suat_duoc_thuong\"><\/span>T\u00ednh % n\u0103ng su\u1ea5t\u00a0\u0111\u01b0\u1ee3c th\u01b0\u1edfng<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>T\u01b0\u01a1ng t\u1ef1 nh\u01b0 t\u00ednh % th\u00e2m ni\u00ean th\u01b0\u1edfng, ch\u00fang ta s\u1ebd tham chi\u1ebfu\u00a0<strong>\u0110i\u1ec3m<\/strong> c\u1ee7a t\u1eebng ng\u01b0\u1eddi (c\u1ed9t D) v\u1edbi b\u1ea3ng <strong>T\u00ednh th\u01b0\u1edfng theo n\u0103ng su\u1ea5t<\/strong> b\u1eb1ng h\u00e0m VLOOKUP nh\u01b0 sau:<\/p>\n<p>I4=VLOOKUP(D4,$M$3:$N$7,2,0)<\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li><strong>D4<\/strong>: \u0110\u1ed1i t\u01b0\u1ee3ng tham chi\u1ebfu l\u00e0 <strong>\u0110i\u1ec3m<\/strong> t\u01b0\u01a1ng\u00a0\u1ee9ng c\u1ee7a nh\u00e2n vi\u00ean<\/li>\n<li><strong>M3:N7<\/strong>: B\u1ea3ng\u00a0<strong>T\u00ednh th\u01b0\u1edfng theo n\u0103ng su\u1ea5t<\/strong>. B\u1ea3ng n\u00e0y c\u1ea7n c\u1ed1\u00a0\u0111\u1ecbnh b\u1edfi c\u00f4ng th\u1ee9c c\u00f3 th\u1ec3 filldown cho nh\u1eefng nh\u00e2n vi\u00ean kh\u00e1c.<\/li>\n<li><strong>2<\/strong>: K\u1ebft qu\u1ea3 c\u1ea7n tham chi\u1ebfu l\u00e0 % th\u01b0\u1edfng, n\u1eb1m\u00a0\u1edf c\u1ed9t th\u1ee9 2 trong b\u1ea3ng\u00a0<strong>T\u00ednh th\u01b0\u1edfng theo n\u0103ng su\u1ea5t<\/strong><\/li>\n<li><strong>0<\/strong>: Ph\u01b0\u01a1ng ph\u00e1p t\u00ecm ki\u1ebfm l\u00e0\u00a0tuy\u1ec7t\u00a0\u0111\u1ed1i, b\u1edfi gi\u00e1 tr\u1ecb\u00a0\u1edf D4 l\u00e0 text n\u00ean ph\u1ea3i t\u00ecm ch\u00ednh x\u00e1c theo k\u00fd t\u1ef1 text\u00a0\u0111\u00f3.<\/li>\n<\/ul>\n<p>T\u00ednh s\u1ed1 ti\u1ec1n th\u01b0\u1edfng<\/p>\n<p>T\u1ed5ng %\u00a0\u1ea1i J4=H4+I4<\/p>\n<p>S\u1ed1 ti\u1ec1n th\u01b0\u1edfng\u00a0\u0111\u01b0\u1ee3c t\u00ednh = M\u1ee9c l\u01b0\u01a1ng th\u00e1ng * T\u1ed5ng % th\u01b0\u1edfng<\/p>\n<p style=\"padding-left: 30px\">K4=E4*J4<\/p>\n<p>V\u1eady l\u00e0 xong r\u1ed3i, h\u00e3y c\u00f9ng ki\u1ec3m tra k\u1ebft qu\u1ea3 xem c\u00f3 ch\u00ednh x\u00e1c kh\u00f4ng n\u00e0o:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22475\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ket-qua-bang-tinh-thuong-tet-01.png\" width=\"1405\" height=\"401\" title=\"ket-qua-bang-tinh-thuong-tet-01\"><\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng!<\/p>\n<p>Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i file m\u1eabu c\u1ee7a b\u00e0i vi\u1ebft n\u00e0y t\u1ea1i\u00a0\u0111\u1ecba ch\u1ec9:<a href=\"http:\/\/bit.ly\/2NMKw47\">\u00a0http:\/\/bit.ly\/2NMKw47<\/a><\/p>\n<p>Xem th\u00eam:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/phan-biet-ham-vlookup-voi-hlookup-va-bi-quyet-su-dung-ham.html\">Ph\u00e2n bi\u1ec7t h\u00e0m VLOOKUP v\u1edbi HLOOKUP v\u00e0 b\u00ed quy\u1ebft s\u1eed d\u1ee5ng h\u00e0m<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-ham-vlookup-ket-hop-ham-match-khi-tim-theo-nhieu-cot-chua-ket-qua.html\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup k\u1ebft h\u1ee3p h\u00e0m Match khi t\u00ecm theo nhi\u1ec1u c\u1ed9t ch\u1ee9a k\u1ebft qu\u1ea3<\/a><\/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\/2025\/01\/ex101_92019-nho-116.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9974,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9973","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9973","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=9973"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9973\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9974"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9973"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9973"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9973"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}