{"id":10623,"date":"2025-01-14T17:52:17","date_gmt":"2025-01-14T17:52:17","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/cach-cham-cong-tren-bang-cham-cong-lam-them-gio-tren-excel-2018\/"},"modified":"2025-01-14T17:52:17","modified_gmt":"2025-01-14T17:52:17","slug":"cach-cham-cong-tren-bang-cham-cong-lam-them-gio-tren-excel-2018","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/cach-cham-cong-tren-bang-cham-cong-lam-them-gio-tren-excel-2018\/","title":{"rendered":"C\u00e1ch ch\u1ea5m c\u00f4ng tr\u00ean b\u1ea3ng ch\u1ea5m c\u00f4ng l\u00e0m th\u00eam gi\u1edd tr\u00ean Excel 2018"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u v\u1ec1 m\u1eabu b\u1ea3ng ch\u1ea5m c\u00f4ng l\u00e0m th\u00eam gi\u1edd \u0111\u01b0\u1ee3c quy\u00a0\u0111\u1ecbnh theo th\u00f4ng t\u01b0 133\/2016\/TT-BTC ng\u00e0y 26\/08\/2016 c\u1ee7a B\u1ed9 T\u00e0i ch\u00ednh\u00a0\u00e1p d\u1ee5ng cho doanh nghi\u1ec7p v\u1eeba v\u00e0 nh\u1ecf. C\u00e1ch x\u00e2y d\u1ef1ng b\u1ea3ng ch\u1ea5m c\u00f4ng n\u00e0y tr\u00ean Excel nh\u01b0 th\u1ebf n\u00e0o?\u00a0C\u00e1ch ghi, ch\u1ea5m c\u00f4ng tr\u00ean b\u1ea3ng ch\u1ea5m c\u00f4ng n\u00e0y nh\u01b0 th\u1ebf n\u00e0o? Ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u nh\u00e9:<\/p>\n<p><strong>B\u1ea3ng ch\u1ea5m c\u00f4ng l\u00e0m th\u00eam gi\u1edd<\/strong> \u0111\u01b0\u1ee3c quy \u0111\u1ecbnh theo m\u1eabu s\u1ed1 01b- L\u0110TL<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-16618\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/heo-bcc-them-gio-tt133-01.png\" width=\"1520\" height=\"568\" title=\"heo-bcc-them-gio-tt133-01\"><\/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-6786a450bd969\" 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\/cach-cham-cong-tren-bang-cham-cong-lam-gio-tren-excel-2018.html#Muc_dich\" title=\"M\u1ee5c \u0111\u00edch\">M\u1ee5c \u0111\u00edch<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-cham-cong-tren-bang-cham-cong-lam-gio-tren-excel-2018.html#Phuong_phap_lap_va_trach_nhiem_ghi\" title=\" Ph\u01b0\u01a1ng ph\u00e1p l\u1eadp v\u00e0 tr\u00e1ch nhi\u1ec7m ghi\"> Ph\u01b0\u01a1ng ph\u00e1p l\u1eadp v\u00e0 tr\u00e1ch nhi\u1ec7m ghi<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Muc_dich\"><\/span><strong>M\u1ee5c \u0111\u00edch<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Theo d\u00f5i ng\u00e0y c\u00f4ng th\u1ef1c t\u1ebf l\u00e0m th\u00eam ngo\u00e0i gi\u1edd \u0111\u1ec3 c\u00f3 c\u0103n c\u1ee9 t\u00ednh th\u1eddi gian ngh\u1ec9 b\u00f9 ho\u1eb7c thanh to\u00e1n cho ng\u01b0\u1eddi lao \u0111\u1ed9ng trong \u0111\u01a1n v\u1ecb.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Phuong_phap_lap_va_trach_nhiem_ghi\"><\/span><strong> Ph\u01b0\u01a1ng ph\u00e1p l\u1eadp v\u00e0 tr\u00e1ch nhi\u1ec7m ghi<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>M\u1ed7i b\u1ed9 ph\u1eadn (ph\u00f2ng, ban, t\u1ed5, nh\u00f3m\u2026) c\u00f3 ph\u00e1t sinh l\u00e0m th\u00eam ngo\u00e0i gi\u1edd l\u00e0m vi\u1ec7c theo quy \u0111\u1ecbnh th\u00ec ph\u1ea3i l\u1eadp b\u1ea3ng ch\u1ea5m c\u00f4ng l\u00e0m th\u00eam gi\u1edd.<\/p>\n<ul>\n<li>C\u1ed9t A, B: Ghi s\u1ed1 th\u1ee9 t\u1ef1, h\u1ecd v\u00e0 t\u00ean t\u1eebng ng\u01b0\u1eddi l\u00e0m vi\u1ec7c th\u00eam gi\u1edd trong b\u1ed9 ph\u1eadn c\u00f4ng t\u00e1c.<\/li>\n<li>C\u1ed9t 1 \u0111\u1ebfn c\u1ed9t 31: Ghi s\u1ed1 gi\u1edd l\u00e0m th\u00eam c\u1ee7a c\u00e1c ng\u00e0y (T\u1eeb gi\u1edd\u2026\u0111\u1ebfn gi\u1edd\u2026) t\u1eeb ng\u00e0y 01 \u0111\u1ebfn ng\u00e0y cu\u1ed1i c\u00f9ng c\u1ee7a th\u00e1ng.<\/li>\n<li>C\u1ed9t 32: Ghi t\u1ed5ng s\u1ed1 gi\u1edd l\u00e0m th\u00eam v\u00e0o c\u00e1c ng\u00e0y th\u01b0\u1eddng trong th\u00e1ng.<\/li>\n<li>C\u1ed9t 33: Ghi t\u1ed5ng s\u1ed1 gi\u1edd l\u00e0m th\u00eam v\u00e0o c\u00e1c ng\u00e0y ngh\u1ec9 th\u1ee9 b\u1ea3y, ch\u1ee7 nh\u1eadt.<\/li>\n<li>C\u1ed9t 34: Ghi t\u1ed5ng s\u1ed1 gi\u1edd l\u00e0m th\u00eam v\u00e0o c\u00e1c ng\u00e0y l\u1ec5, t\u1ebft.<\/li>\n<li>C\u1ed9t 35: Ghi t\u1ed5ng s\u1ed1 gi\u1edd l\u00e0m th\u00eam v\u00e0o bu\u1ed5i t\u1ed1i (t\u00ednh theo quy \u0111\u1ecbnh c\u1ee7a ph\u00e1p lu\u1eadt) kh\u00f4ng thu\u1ed9c ca l\u00e0m vi\u1ec7c c\u1ee7a ng\u01b0\u1eddi lao \u0111\u1ed9ng.<\/li>\n<\/ul>\n<p>H\u00e0ng ng\u00e0y t\u1ed5 tr\u01b0\u1edfng (ph\u00f2ng ban, t\u1ed5 nh\u00f3m\u2026) ho\u1eb7c ng\u01b0\u1eddi \u0111\u01b0\u1ee3c \u1ee7y quy\u1ec1n c\u0103n c\u1ee9 v\u00e0o s\u1ed1 gi\u1edd l\u00e0m th\u00eam th\u1ef1c t\u1ebf theo y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ed9 ph\u1eadn m\u00ecnh \u0111\u1ec3 ch\u1ea5m gi\u1edd l\u00e0m th\u00eam cho t\u1eebng ng\u01b0\u1eddi trong ng\u00e0y, ghi v\u00e0o ng\u00e0y t\u01b0\u01a1ng \u1ee9ng trong c\u00e1c c\u1ed9t t\u1eeb 1 \u0111\u1ebfn 31 theo c\u00e1c k\u00fd hi\u1ec7u quy \u0111\u1ecbnh trong ch\u1ee9ng t\u1eeb.<\/p>\n<p>Cu\u1ed1i th\u00e1ng, ng\u01b0\u1eddi ch\u1ea5m c\u00f4ng, ph\u1ee5 tr\u00e1ch b\u1ed9 ph\u1eadn c\u00f3 ng\u01b0\u1eddi l\u00e0m th\u00eam k\u00fd v\u00e0 gi\u00e1m \u0111\u1ed1c ho\u1eb7c ng\u01b0\u1eddi \u0111\u01b0\u1ee3c \u1ee7y quy\u1ec1n duy\u1ec7t v\u00e0o b\u1ea3ng ch\u1ea5m c\u00f4ng l\u00e0m th\u00eam gi\u1edd v\u00e0 chuy\u1ec3n b\u1ea3ng ch\u1ea5m c\u00f4ng l\u00e0m th\u00eam gi\u1edd c\u00f9ng c\u00e1c ch\u1ee9ng t\u1eeb li\u00ean quan v\u1ec1 b\u1ed9 ph\u1eadn k\u1ebf to\u00e1n ki\u1ec3m tra, \u0111\u1ed1i chi\u1ebfu, quy ra c\u00f4ng \u0111\u1ec3 thanh to\u00e1n (tr\u01b0\u1eddng h\u1ee3p thanh to\u00e1n ti\u1ec1n). K\u1ebf to\u00e1n c\u0103n c\u1ee9 v\u00e0o c\u00e1c k\u00fd hi\u1ec7u ch\u1ea5m c\u00f4ng c\u1ee7a t\u1eebng ng\u01b0\u1eddi t\u00ednh ra s\u1ed1 c\u00f4ng theo t\u1eebng lo\u1ea1i t\u01b0\u01a1ng \u1ee9ng \u0111\u1ec3 ghi v\u00e0o c\u00e1c c\u1ed9t 32, 33, 34, 35.<\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-198.gif\" title=\"ex101_92019-nho-198\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-198.gif\" title=\"ex101_92019-nho-198\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>T\u1ea3i m\u1eabu b\u1ea3ng ch\u1ea5m c\u00f4ng l\u00e0m th\u00eam gi\u1edd tr\u00ean\u00a0Excel theo th\u00f4ng t\u01b0 133 m\u1edbi nh\u1ea5t t\u1ea1i\u00a0\u0111\u1ecba ch\u1ec9:\u00a0<a href=\"http:\/\/bit.ly\/2FVqlbz\">http:\/\/bit.ly\/2FVqlbz<\/a><\/p>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/cach-tao-mau-bcc-lam-gio-theo-tt133-tren-excel-nam-2018.html\">C\u00e1ch t\u1ea1o m\u1eabu b\u1ea3ng ch\u1ea5m c\u00f4ng l\u00e0m th\u00eam gi\u1edd theo th\u00f4ng t\u01b0 133 tr\u00ean\u00a0Excel\u00a0m\u1edbi nh\u1ea5t 2018<\/a><\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng H\u1ecdc\u00a0Excel Online!<\/p>\n<p>B\u1ea1n c\u00f3 ngh\u0129 r\u1eb1ng l\u00e0m k\u1ebf to\u00e1n t\u1ed5ng h\u1ee3p tr\u00ean Excel quan tr\u1ecdng kh\u00f4ng, b\u1edfi tr\u00ean\u00a0Excel b\u1ea1n c\u00f3 th\u1ec3 n\u1eafm\u00a0\u0111\u01b0\u1ee3c c\u00e1ch t\u1ed5 ch\u1ee9c, qu\u1ea3n l\u00fd d\u1eef li\u1ec7u k\u1ebf to\u00e1n,\u00a0\u0111\u1ed3ng th\u1eddi t\u1ef1 tay x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c l\u00ean c\u00e1c b\u00e1o c\u00e1o t\u00e0i ch\u00ednh. Khi\u00a0\u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3\u00a0d\u1ec5 d\u00e0ng ki\u1ec3m tra k\u1ebft qu\u1ea3, bi\u1ebft\u00a0\u0111\u01b0\u1ee3c nh\u1eefng thay\u00a0\u0111\u1ed5i d\u1eef li\u1ec7u trong s\u1ed5 NKC s\u1ebd\u00a0\u1ea3nh h\u01b0\u1edfng nh\u01b0 th\u1ebf n\u00e0o t\u1edbi k\u1ebft qu\u1ea3 trong c\u00e1c b\u00e1o c\u00e1o.<\/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<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-198.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10624,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10623","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\/10623","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=10623"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10623\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10624"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10623"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10623"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10623"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}