{"id":7137,"date":"2024-12-21T16:57:37","date_gmt":"2024-12-21T16:57:37","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/chia-se-file-excel-cham-cong-tinh-luong-hoan-chinh\/"},"modified":"2024-12-21T16:57:37","modified_gmt":"2024-12-21T16:57:37","slug":"chia-se-file-excel-cham-cong-tinh-luong-hoan-chinh","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/chia-se-file-excel-cham-cong-tinh-luong-hoan-chinh\/","title":{"rendered":"Chia s\u1ebb file Excel ch\u1ea5m c\u00f4ng t\u00ednh l\u01b0\u01a1ng ho\u00e0n ch\u1ec9nh"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\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-6766f380e228d\" 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\/chia-se-file-excel-cham-cong-tinh-luong-hoan-chinh.html#Loi_noi_dau\" title=\"L\u1eddi n\u00f3i \u0111\u1ea7u\">L\u1eddi n\u00f3i \u0111\u1ea7u<\/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\/chia-se-file-excel-cham-cong-tinh-luong-hoan-chinh.html#Lam_sao_biet_nam_nao_la_nam_nhuan_trong_Excel\" title=\"L\u00e0m sao bi\u1ebft n\u0103m n\u00e0o l\u00e0 n\u0103m nhu\u1eadn trong Excel\">L\u00e0m sao bi\u1ebft n\u0103m n\u00e0o l\u00e0 n\u0103m nhu\u1eadn trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/chia-se-file-excel-cham-cong-tinh-luong-hoan-chinh.html#Xu_ly_ngay_thang_cua_thang_2_nam_nhuan_trong_Excel\" title=\"X\u1eed l\u00fd ng\u00e0y th\u00e1ng c\u1ee7a th\u00e1ng 2 n\u0103m nhu\u1eadn trong Excel\">X\u1eed l\u00fd ng\u00e0y th\u00e1ng c\u1ee7a th\u00e1ng 2 n\u0103m nhu\u1eadn trong Excel<\/a><\/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\/chia-se-file-excel-cham-cong-tinh-luong-hoan-chinh.html#Thiet_lap_bang_cham_cong_tinh_luong_trong_Excel\" title=\"Thi\u1ebft l\u1eadp b\u1ea3ng ch\u1ea5m c\u00f4ng t\u00ednh l\u01b0\u01a1ng trong Excel\">Thi\u1ebft l\u1eadp b\u1ea3ng ch\u1ea5m c\u00f4ng t\u00ednh l\u01b0\u01a1ng trong Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Loi_noi_dau\"><\/span>L\u1eddi n\u00f3i \u0111\u1ea7u<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ti\u00eau \u0111\u1ec1 c\u1ee7a b\u00e0i vi\u1ebft n\u00e0y l\u00e0 \u201cChia s\u1ebb file Excel ch\u1ea5m c\u00f4ng t\u00ednh l\u01b0\u01a1ng ho\u00e0n ch\u1ec9nh\u201d nh\u01b0ng trong b\u00e0i vi\u1ebft n\u00e0y c\u00e1c b\u1ea1n kh\u00f4ng nh\u1eefng c\u00f3 th\u1ec3 download \u0111\u01b0\u1ee3c 1 file Excel ch\u1ea5m c\u00f4ng ho\u00e0n ch\u1ec9nh m\u00e0 c\u00f2n c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c c\u00e1ch t\u1ea1o ra 1 file Excel nh\u01b0 v\u1eady t\u1eeb 1 File Excel m\u1edbi ho\u00e0n to\u00e0n.<\/p>\n<ol>\n<li><a href=\"http:\/\/bit.ly\/heochamcong\" target=\"_blank\">N\u1ebfu b\u1ea1n c\u1ea7n d\u00f9ng ngay ho\u1eb7c tham kh\u1ea3o, h\u00e3y click download ngay.<\/a><\/li>\n<li>N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ecm hi\u1ec3u t\u1eebng b\u01b0\u1edbc th\u1ef1c hi\u1ec7n, h\u00e3y \u0111\u1ecdc ti\u1ebfp b\u00e0i n\u00e0y<\/li>\n<\/ol>\n<h2><span class=\"ez-toc-section\" id=\"Lam_sao_biet_nam_nao_la_nam_nhuan_trong_Excel\"><\/span>L\u00e0m sao bi\u1ebft n\u0103m n\u00e0o l\u00e0 n\u0103m nhu\u1eadn trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tr\u01b0\u1edbc ti\u00ean, ch\u00fang ta h\u00e3y b\u1eaft \u0111\u1ea7u v\u1edbi 1 video nh\u1eb9 nh\u00e0ng gi\u00fap ch\u00fang ta bi\u1ebft \u0111\u01b0\u1ee3c n\u0103m n\u00e0o l\u00e0 n\u0103m nhu\u1eadn \u1edf trong Excel. N\u0103m nhu\u1eadn c\u00f3 \u0111\u1eb7c \u0111i\u1ec3m l\u00e0 n\u0103m chia h\u1ebft cho 400 ho\u1eb7c kh\u00f4ng chia h\u1ebft cho 100 nh\u01b0ng chia h\u1ebft cho 4. Trong video sau \u0111\u00e2y, b\u1ea1n s\u1ebd h\u1ecdc c\u00e1ch ph\u00e1t hi\u1ec7n ra n\u0103m nhu\u1eadn \u1edf trong Excel<\/p>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/1ceBv6rK4nw\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe>\n<h2><span class=\"ez-toc-section\" id=\"Xu_ly_ngay_thang_cua_thang_2_nam_nhuan_trong_Excel\"><\/span>X\u1eed l\u00fd ng\u00e0y th\u00e1ng c\u1ee7a th\u00e1ng 2 n\u0103m nhu\u1eadn trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Sau khi \u0111\u00e3 bi\u1ebft n\u0103m n\u00e0o l\u00e0 n\u0103m nhu\u1eadn th\u00ec vi\u1ec7c ti\u1ebfp theo ch\u00fang ta s\u1ebd \u0111i l\u00e0m l\u00e0 x\u1eed l\u00fd s\u1ed1 ng\u00e0y c\u1ee7a th\u00e1ng 2 trong n\u0103m nhu\u1eadn. Video sau \u0111\u00e2y s\u1ebd gi\u00fap c\u00e1c b\u1ea1n l\u00e0m \u0111i\u1ec1u n\u00e0y<\/p>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/tX80hRH5iKk\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe>\n<h2><span class=\"ez-toc-section\" id=\"Thiet_lap_bang_cham_cong_tinh_luong_trong_Excel\"><\/span>Thi\u1ebft l\u1eadp b\u1ea3ng ch\u1ea5m c\u00f4ng t\u00ednh l\u01b0\u01a1ng trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Sau khi \u0111\u00e3 c\u00f3 ki\u1ebfn th\u1ee9c n\u1ec1n t\u1ea3ng v\u1eefng ch\u1eafc, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 theo d\u00f5i video sau \u0111\u00e2y \u0111\u1ec3 c\u00f3 th\u1ec3 t\u1ef1 m\u00ecnh t\u1ea1o ra 1 b\u1ea3ng ch\u1ea5m c\u00f4ng t\u00ednh l\u01b0\u01a1ng trong Excel m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 c\u1ef1c k\u00ec chi ti\u1ebft. Ki\u1ebfn th\u1ee9c d\u00f9ng \u0111\u1ec3 t\u1ea1o ra b\u1ea3ng ch\u1ea5m c\u00f4ng n\u00e0y bao g\u1ed3m:<\/p>\n<ol>\n<li>S\u1eed d\u1ee5ng h\u00e0m Date<\/li>\n<li>S\u1eed d\u1ee5ng h\u00e0m Weekday<\/li>\n<li>Ki\u1ebfn th\u1ee9c v\u1ec1 tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i trong Excel<\/li>\n<li>Ki\u1ebfn th\u1ee9c v\u1ec1 \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n \u2013 Conditional Formatting<\/li>\n<li>S\u1eed d\u1ee5ng h\u00e0m Countif \u0111\u1ec3 \u0111\u1ebfm d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>C\u00e1c ki\u1ebfn th\u1ee9c chung v\u1ec1 \u0111\u1ecbnh d\u1ea1ng v\u00f9ng d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh<\/li>\n<\/ol>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/aQGdU-MnBxU\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-643.gif\" title=\"ex101_92019-nho-643\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-643.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7138,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7137","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7137","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=7137"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7137\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7138"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7137"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7137"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7137"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}