{"id":7963,"date":"2024-12-21T19:02:26","date_gmt":"2024-12-21T19:02:26","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-lap-so-nhat-ky-chung-tren-excel\/"},"modified":"2024-12-21T19:02:26","modified_gmt":"2024-12-21T19:02:26","slug":"huong-dan-lap-so-nhat-ky-chung-tren-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-lap-so-nhat-ky-chung-tren-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn l\u1eadp s\u1ed5 Nh\u1eadt k\u00fd chung tr\u00ean Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em>Trong b\u00e0i vi\u1ebft n\u00e0y, <strong><a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a><\/strong> s\u1ebd <strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lap-nhat-ky-chung-tren-excel.html\">h\u01b0\u1edbng d\u1eabn l\u1eadp S\u1ed5 Nh\u1eadt k\u00fd chung tr\u00ean Excel<\/a>.<\/strong> B\u1eb1ng vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n m\u00e0 h\u1ea7u h\u1ebft ch\u00fang ta \u0111\u1ec1u c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n.<\/em><\/p>\n<p style=\"text-align: justify\">Trong m\u1ed9t b\u00e0i vi\u1ebft g\u1ea7n \u0111\u00e2y, <strong>H\u1ecdc Excel Online<\/strong> c\u0169ng \u0111\u00e3 c\u00f3 b\u00e0i vi\u1ebft t\u01b0\u01a1ng t\u1ef1 tuy nhi\u00ean v\u1edbi ki\u1ebfn th\u1ee9c kh\u00e1 n\u00e2ng cao h\u01a1n \u0111\u00f3 l\u00e0 s\u1eed d\u1ee5ng c\u00e2u truy v\u1ea5n SQL v\u1edbi h\u00e0 m <strong>\u201cHeoSQL\u201d<\/strong> trong <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cai-dat-add-ins-hocexcelonline.html\">Add \u2013 Ins HocExcelOnline. <\/a>B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o\u00a0b\u00e0i vi\u1ebft \u0111\u00f3\u00a0ngay d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lap-nhat-ky-chung-bang-ham-heosql.html\"><em><strong>H\u01b0\u1edbng d\u1eabn l\u1eadp S\u1ed5 Nh\u1eadt k\u00fd chung b\u1eb1ng h\u00e0m \u201cHeoSQL\u201d<\/strong><\/em><\/a><\/p>\n<p style=\"text-align: justify\">Th\u00ec trong b\u00e0i vi\u1ebft n\u00e0y, c\u0169ng v\u1edbi d\u1eef li\u1ec7u \u0111\u00f3 v\u00e0 c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n trong Excel. <a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online <\/a>s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n l\u1eadp ra \u0111\u01b0\u1ee3c S\u1ed5 Nh\u1eadt k\u00fd chung, <em><strong>Let\u2019s Go!<\/strong><\/em><\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cai-dat-add-ins-hocexcelonline.html\"><em><strong>H\u01b0\u1edbng d\u1eabn c\u00e0i \u0111\u1eb7t add ins hocexcelonline<\/strong><\/em><\/a><\/p>\n<p style=\"text-align: justify\">C\u1ee5 th\u1ec3 v\u1edbi DATA nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/09\/1-10.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30219 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-10-1024x519-1.png\" alt=\"huong-dan-lap-so-nhat-ky-chung-tren-excel-1\" width=\"1024\" height=\"519\" title=\"1-10-1024x519-1\"><\/a><\/p>\n<p style=\"text-align: justify\">V\u00e0\u00a0m\u1eabu S\u1ed5 Nh\u1eadt k\u00fd chung. b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t m\u1eabu S\u1ed5 Nh\u1eadt k\u00fd chung kh\u00e1c, kh\u00f4ng nh\u1ea5t thi\u1ebft ph\u1ea3i ho\u00e0n to\u00e0n gi\u1ed1ng y h\u1ec7t m\u1eabu n\u00e0y. Mi\u1ec5n l\u00e0 n\u00f3 v\u1eabn \u0111\u1ea3m b\u1ea3o \u0111\u01b0\u1ee3c c\u00e1c th\u00f4ng tin c\u1ea7n thi\u1ebft, \u0111\u00fang m\u1ee5c \u0111\u00edch c\u0169ng nh\u01b0 vai tr\u00f2 c\u1ee7a s\u1ed5 l\u00e0 ph\u1ea3n \u00e1nh \u0111\u01b0\u1ee3c t\u00ecnh h\u00ecnh c\u00e1c nghi\u1ec7p v\u1ee5 kinh t\u1ebf ph\u00e1t sinh trong k\u1ef3, b\u1ea1n c\u00f3 th\u1ec3 Download m\u1eabu n\u00e0y \u1edf Link cu\u1ed1i b\u00e0i vi\u1ebft v\u1ec1 \u0111\u1ec3 tham kh\u1ea3o.<\/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\/2024\/12\/ex101_92019-nho-715.gif\" title=\"ex101_92019-nho-715\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-328.gif\" title=\"vba101_92019-nho-328\"><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\/2024\/12\/ex101_92019-nho-715.gif\" title=\"ex101_92019-nho-715\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/09\/2-9.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30220 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-9-1024x760-1.png\" alt=\"huong-dan-lap-so-nhat-ky-chung-tren-excel-2\" width=\"1024\" height=\"760\" title=\"2-9-1024x760-1\"><\/a><\/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-676710c19a487\" 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-lap-nhat-ky-chung-tren-excel.html#Ham_Excel_su_dung\" title=\"H\u00e0m Excel s\u1eed d\u1ee5ng\">H\u00e0m Excel s\u1eed d\u1ee5ng<\/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\/huong-dan-lap-nhat-ky-chung-tren-excel.html#Cach_thuc_hien\" title=\"C\u00e1ch th\u1ef1c hi\u1ec7n\">C\u00e1ch th\u1ef1c hi\u1ec7n<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-lap-nhat-ky-chung-tren-excel.html#Voi_cot_ngay_thang_chung_tu\" title=\"V\u1edbi c\u1ed9t ng\u00e0y th\u00e1ng ch\u1ee9ng t\u1eeb\">V\u1edbi c\u1ed9t ng\u00e0y th\u00e1ng ch\u1ee9ng t\u1eeb<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-lap-nhat-ky-chung-tren-excel.html#Voi_cac_cot_con_lai\" title=\"V\u1edbi c\u00e1c c\u1ed9t c\u00f2n l\u1ea1i\">V\u1edbi c\u00e1c c\u1ed9t c\u00f2n l\u1ea1i<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-lap-nhat-ky-chung-tren-excel.html#Cot_STT_va_cot_phu_de_loc\" title=\"C\u1ed9t STT v\u00e0 c\u1ed9t ph\u1ee5 \u0111\u1ec3 l\u1ecdc\">C\u1ed9t STT v\u00e0 c\u1ed9t ph\u1ee5 \u0111\u1ec3 l\u1ecdc<\/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-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-lap-nhat-ky-chung-tren-excel.html#Mot_so_luu_y\" title=\"M\u1ed9t s\u1ed1 l\u01b0u \u00fd\">M\u1ed9t s\u1ed1 l\u01b0u \u00fd<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-lap-nhat-ky-chung-tren-excel.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_Excel_su_dung\"><\/span>H\u00e0m Excel s\u1eed d\u1ee5ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">V\u1edbi d\u1eef li\u1ec7u v\u00e0 m\u1eabu\u00a0S\u1ed5 Nh\u1eadt k\u00fd chung\u00a0nh\u01b0 tr\u00ean th\u00ec ta ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m IF, h\u00e0m AND \u0111\u1ec3 bi\u1ec7n lu\u1eadn l\u00e0 ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 l\u1eadp \u0111\u01b0\u1ee3c S\u1ed5 Nh\u1eadt k\u00fd chung r\u1ed3i.<\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html\"><em><strong>C\u00e1ch d\u00f9ng h\u00e0m if trong excel 2016, 2010, 2017<\/strong><\/em><\/a><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_thuc_hien\"><\/span>C\u00e1ch th\u1ef1c hi\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n \u0111\u1ec3 \u00fd th\u00ec tr\u00ean m\u1eabu s\u1ed5 m\u00ecnh c\u00f3 t\u00f4 m\u00e0u 2 \u00f4 <strong>(E8, E9)<\/strong>, 2 \u00f4 \u0111\u00f3 v\u1edbi m\u1ee5c \u0111\u00edch l\u00e0 ta s\u1ebd l\u1eadp s\u1ed5 v\u1edbi d\u1eef li\u1ec7u ph\u00e1t sinh trong k\u1ef3 trong kho\u1ea3ng th\u1eddi gian \u0111\u00f3. T\u1ee9c l\u00e0, d\u1eef li\u1ec7u l\u1ea5y l\u00ean S\u1ed5 Nh\u1eadt k\u00fd chung n\u00e0y s\u1ebd l\u00e0 nh\u1eefng ph\u00e1t sinh c\u00f3 ng\u00e0y &gt;= t\u1eeb ng\u00e0y <strong>(E8)<\/strong> v\u00e0 &lt;= \u0111\u1ebfn ng\u00e0y <strong>(E9).<\/strong> C\u1ee5 th\u1ec3 ta s\u1ebd l\u00e0m nh\u01b0 sau:<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Voi_cot_ngay_thang_chung_tu\"><\/span>V\u1edbi c\u1ed9t ng\u00e0y th\u00e1ng ch\u1ee9ng t\u1eeb<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Nh\u01b0 \u0111\u00e3 tr\u00ecnh b\u00e0y \u1edf tr\u00ean th\u00ec ng\u00e0y th\u00e1ng tr\u00ean s\u1ed5 nh\u1eadt k\u00fd chung ph\u1ea3i n\u1eb1m trong kho\u1ea3ng &lt;t\u1eeb ng\u00e0y&gt; <strong>(\u00f4 E8)<\/strong> \u0111\u1ebfn &lt;\u0111\u1ebfn ng\u00e0y&gt; <strong>(\u00f4 E9).<\/strong> Ta c\u00f3 c\u00f4ng th\u1ee9c bi\u1ec7n lu\u1eadn t\u1ea1i \u00f4 <strong>D15<\/strong> nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=IF(AND(DATA!B3&gt;=$E$8,DATA!B3&lt;=$E$9),DATA!B3,\u201d\u201d)<\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c tr\u00ean c\u00f3 th\u1ec3 di\u1ec5n gi\u1ea3i b\u1eb1ng l\u1eddi nh\u01b0 sau: N\u1ebfu gi\u00e1 tr\u1ecb trong \u00f4 B3 b\u00ean Sheet DATA (t\u1ee9c ng\u00e0y th\u00e1ng) \u0111\u1ed3ng th\u1eddi tho\u1ea3 m\u00e3n 2 \u0111i\u1ec1u ki\u1ec7n l\u00e0 l\u1edbn h\u01a1n &lt;t\u1eeb ng\u00e0y&gt; trong \u00f4 E8 v\u00e0 b\u00e9 h\u01a1n ho\u1eb7c b\u1eb1ng &lt;\u0111\u1ebfn ng\u00e0y&gt; trong \u00f4 E9 th\u00ec s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb trong \u00f4 B3 b\u00ean Sheet DATA (t\u1ee9c ng\u00e0y th\u00e1ng).<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/09\/NKC1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30222 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/nkc1-1024x400-1.png\" alt=\"huong-dan-lap-so-nhat-ky-chung-tren-excel-3\" width=\"1024\" height=\"400\" title=\"nkc1-1024x400-1\"><\/a><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Voi_cac_cot_con_lai\"><\/span>V\u1edbi c\u00e1c c\u1ed9t c\u00f2n l\u1ea1i<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Sau khi \u0111\u00e3 x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c ng\u00e0y th\u00e1ng, th\u00ec v\u1edbi c\u00e1c c\u1ed9t c\u00f2n l\u1ea1i (c\u00e1c ch\u1ec9 ti\u00eau c\u00f2n l\u1ea1i) tr\u00ean S\u1ed5 Nh\u1eadt k\u00fd chung ta \u0111\u01a1n gi\u1ea3n l\u00e0 ch\u1ec9 c\u1ea7n c\u0103n c\u1ee9 v\u00e0o c\u1ed9t ng\u00e0y th\u00e1ng n\u00e0y \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh. C\u1ee5 th\u1ec3 ta s\u1ebd c\u00f3 c\u00f4ng th\u1ee9c t\u1ea1i c\u00e1c tr\u01b0\u1eddng th\u00f4ng tin c\u00f2n l\u1ea1i c\u1ee7a s\u1ed5 nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/09\/NKC2-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30231 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/nkc2-2-1024x563-1.png\" alt=\"huong-dan-lap-so-nhat-ky-chung-tren-excel-4\" width=\"1024\" height=\"563\" title=\"nkc2-2-1024x563-1\"><\/a><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cot_STT_va_cot_phu_de_loc\"><\/span>C\u1ed9t STT v\u00e0 c\u1ed9t ph\u1ee5 \u0111\u1ec3 l\u1ecdc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Ti\u1ebfp theo, ta s\u1ebd \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 cho c\u00e1c d\u00f2ng c\u00f3 ph\u00e1t sinh tr\u00ean S\u1ed5 Nh\u1eadt k\u00fd chung v\u00e0 th\u1ef1c hi\u1ec7n t\u1ea1o 1 c\u1ed9t ph\u1ee5 \u0111\u1ec3 l\u1ecdc.<\/p>\n<p style=\"text-align: justify\">V\u1ec1 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1, ta ch\u1ec9 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 cho nh\u1eefng d\u00f2ng d\u1eef li\u1ec7u kh\u00e1c r\u1ed7ng th\u00f4i (t\u1ee9c c\u00f3 ph\u00e1t sinh). B\u1ea1n c\u00f3 th\u1ec3 c\u00f3 nhi\u1ec1u c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 kh\u00e1c nhau nh\u01b0 d\u00f9ng h\u00e0m COUNTIF, SUBTOTAL,\u2026Trong b\u00e0i vi\u1ebft n\u00e0y m\u00ecnh s\u1eed d\u1ee5ng h\u00e0m sau:<\/p>\n<blockquote>\n<p><strong>=IF(D15=\u201d\u201d,\u201d\u201d,MAX($B$14:B14)+1)<\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">V\u1ec1 c\u1ed9t l\u1ecdc th\u00ec b\u1ea1n c\u00f3 th\u1ec3 d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n nh\u01b0 sau (l\u1ea1i ti\u1ebfp t\u1ee5c IF th\u00f4i ):<\/p>\n<blockquote>\n<p><strong>=IF(D15=\u201d\u201d,\u201d\u201d,\u201dx\u201d)<\/strong><\/p>\n<\/blockquote>\n<p>Sau khi \u0111\u00e3 ho\u00e0n th\u00e0nh c\u00e1c c\u00f4ng th\u1ee9c c\u1ea7n thi\u1ebft b\u1ea1n th\u1ef1c hi\u1ec7n <strong>FillDown<\/strong> c\u00f4ng th\u1ee9c xu\u1ed1ng cho c\u00e1c d\u00f2ng c\u00f2n l\u1ea1i.<\/p>\n<p style=\"text-align: justify\">Nh\u01b0 v\u1eady l\u00e0 xong r\u1ed3i, m\u1ed7i l\u1ea7n b\u1ea1n mu\u1ed1n xem s\u1ed5 trong kho\u1ea3ng th\u1eddi gian n\u00e0o \u0111\u00f3 th\u00ec b\u1ea1n ch\u1ec9 c\u1ea7n thay \u0111\u1ed5i ng\u00e0y th\u00e1ng trong 2 \u00f4 <strong>E8<\/strong> v\u00e0 <strong>E9<\/strong>, r\u1ed3i th\u1ef1c hi\u1ec7n thao t\u00e1c l\u1ecdc l\u00e0 b\u1ea1n \u0111\u00e3 ho\u00e0n th\u00e0nh \u0111\u01b0\u1ee3c S\u1ed5 Nh\u1eadt k\u00fd chung m\u1ed9t c\u00e1ch nhanh ch\u00f3ng r\u1ed3i ph\u1ea3i kh\u00f4ng n\u00e0o<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/09\/NKC3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30224 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/nkc3-926x1024-1.png\" alt=\"huong-dan-lap-so-nhat-ky-chung-tren-excel-5\" width=\"926\" height=\"1024\" title=\"nkc3-926x1024-1\"><\/a><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Mot_so_luu_y\"><\/span>M\u1ed9t s\u1ed1 l\u01b0u \u00fd<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">V\u1edbi c\u00e1ch l\u00e0m kh\u00e1 \u0111\u01a1n gi\u1ea3n n\u00e0y b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 l\u1eadp \u0111\u01b0\u1ee3c S\u1ed5 Nh\u1eadt k\u00fd chung 1 c\u00e1ch ch\u00ednh x\u00e1c, nhanh ch\u00f3ng v\u00e0 s\u1ed5 c\u0169ng c\u00f3 th\u1ec3 c\u1eadp nh\u1eadt, linh ho\u1ea1t khi thay \u0111\u1ed5i kho\u1ea3ng th\u1eddi gian. Tuy nhi\u00ean, n\u00f3 c\u0169ng c\u00f3 m\u1ed9t s\u1ed1 \u0111i\u1ec3m c\u1ea7n l\u01b0u \u00fd nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">\u2013 V\u1edbi d\u1eef li\u1ec7u\u00a0ph\u00e1t sinh b\u00ean Sheet DATA \u00edt th\u00ec kh\u00f4ng sao, tuy nhi\u00ean khi d\u1eef li\u1ec7u l\u1edbn, l\u00ean t\u1edbi h\u00e0ng ch\u1ee5c, h\u00e0ng tr\u0103m ng\u00e0n d\u00f2ng th\u00ec s\u1ebd khi\u1ebfn File Excel c\u1ee7a b\u1ea1n l\u00e0m vi\u1ec7c r\u1ea5t v\u1ea5t v\u1ea3 \u0111\u1ea5y, v\u00ec v\u1edbi vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u01a1n gi\u1ea3n n\u00e0y th\u00ec d\u1eef li\u1ec7u b\u00ean Sheet DATA c\u1ee7a b\u1ea1n c\u00f3 bao nhi\u00eau d\u00f2ng th\u00ec b\u00ean S\u1ed5 Nh\u1eadt k\u00fd chung c\u1ee7a b\u1ea1n c\u0169ng c\u1ea7n c\u00f3 t\u1eebng \u0111\u00f3 d\u00f2ng. Vi\u1ec7c \u00e1p d\u1ee5ng qu\u00e1 nhi\u1ec1u c\u00f4ng th\u1ee9c trong Excel s\u1ebd l\u00e0m cho File c\u1ee7a b\u1ea1n ho\u1ea1t \u0111\u1ed9ng r\u1ea5t ch\u1eadt v\u1eadt.<\/p>\n<p style=\"text-align: justify\">\u2013 V\u1eady, l\u00e0m nh\u01b0 th\u1ebf n\u00e0o \u0111\u1ec3 kh\u1eafc ph\u1ee5c t\u00ecnh tr\u1ea1ng tr\u00ean? (t\u1ea5t nhi\u00ean l\u00e0 ph\u1ea3i c\u00f3 c\u00e1ch r\u1ed3i ). B\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/excel-vba\">VBA <strong>Excel<\/strong><\/a><strong>,<\/strong> SQL v\u1edbi h\u00e0m <strong>\u201cHeoSQL\u201d<\/strong> trong<strong> Add \u2013 Ins HocExcelOnline<\/strong>, ho\u1eb7c c\u0169ng c\u00f3 th\u1ec3 l\u00e0 c\u00f4ng th\u1ee9c m\u1ea3ng,\u2026.c\u0169ng c\u00f3 kh\u00e1 nhi\u1ec1u c\u00e1ch ph\u1ea3i kh\u00f4ng n\u00e0o. Tuy nhi\u00ean,\u00a0m\u1ee5c \u0111\u00edch ch\u00ednh c\u1ee7a b\u00e0i vi\u1ebft n\u00e0y l\u00e0 gi\u00fap b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m Excel c\u01a1 b\u1ea3n m\u00e0 v\u1edbi h\u1ea7u h\u1ebft ch\u00fang ta \u0111\u1ec1u c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n n\u00ean m\u00ecnh xin ph\u00e9p kh\u00f4ng \u0111\u1ec1 c\u1eadp t\u1edbi c\u00e1c v\u1ea5n \u0111\u1ec1 n\u00e2ng cao h\u01a1n. <strong>H\u1ecdc Excel Online<\/strong> s\u1ebd c\u00f3 c\u00e1c b\u00e0i vi\u1ebft kh\u00e1c \u0111\u1ec3 h\u01b0\u1edbng d\u1eabn b\u1ea1n s\u1eed d\u1ee5ng c\u00e1c h\u00e0m n\u00e2ng cao \u0111\u00f3, \u0111\u01a1n c\u1eed nh\u01b0 b\u00e0i vi\u1ebft sau:<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">H\u1ecdc Excel Online hy v\u1ecdng qua b\u00e0i vi\u1ebft n\u00e0y b\u1ea1n \u0111\u00e3 n\u1eafm \u0111\u01b0\u1ee3c <strong>c\u00e1ch \u0111\u1ec3 l\u1eadp S\u1ed5 Nh\u1eadt k\u00fd chung tr\u00ean Excel<\/strong> m\u1ed9t c\u00e1ch kh\u00e1 \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3 v\u00e0 nhanh ch\u00f3ng. Ph\u1ea3n \u00e1nh \u0111\u01b0\u1ee3c t\u00ecnh h\u00ecnh ph\u00e1t sinh trong k\u1ef3 v\u00e0 ho\u00e0n to\u00e0n linh ho\u1ea1t theo kho\u1ea3ng th\u1eddi gian mu\u1ed1n xem s\u1ed5. V\u1ec1 File \u0111\u00ednh k\u00e8m b\u00e0i vi\u1ebft b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i v\u1ec1 ngay d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p style=\"text-align: justify\">Download File \u0111\u00ednh k\u00e8m b\u00e0i vi\u1ebft t\u1ea1i \u0111\u00e2y:\u00a0<a href=\"https:\/\/drive.google.com\/file\/d\/108TJWhT8FrBUGIUWkLeqkRV031ph7cAV\/view\"><em><strong>H\u01b0\u1edbng d\u1eabn l\u1eadp s\u1ed5 Nh\u1eadt k\u00fd chung tr\u00ean Excel<\/strong><\/em><\/a><\/p>\n<p style=\"text-align: justify;padding-left: 30px\">\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lap-cai-bang-ham-heosql.html\">H\u01b0\u1edbng d\u1eabn l\u1eadp S\u1ed5 C\u00e1i b\u1eb1ng h\u00e0m \u201cHeoSQL\u201d<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lap-bang-tong-hop-cong-no-phai-thu-khach-hang-tren-excel-2.html\">H\u01b0\u1edbng d\u1eabn l\u1eadp b\u1ea3ng t\u1ed5ng h\u1ee3p c\u00f4ng n\u1ee3 ph\u1ea3i thu kh\u00e1ch h\u00e0ng tr\u00ean excel<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-lam-ke-toan-chi-tiet-vat-tu-san-pham-hang-hoa-tren-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u00e0m s\u1ed5 k\u1ebf to\u00e1n chi ti\u1ebft v\u1eadt t\u01b0, s\u1ea3n ph\u1ea9m, h\u00e0ng ho\u00e1 tr\u00ean excel<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-lam-chi-tiet-tien-gui-ngan-hang-trong-excel.html\">h\u01b0\u1edbng d\u1eabn c\u00e1ch l\u00e0m s\u1ed5 k\u1ebf to\u00e1n chi ti\u1ebft ti\u1ec1n g\u1eedi ng\u00e2n h\u00e0ng tr\u00ean excel<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lam-quy-tien-mat-trong-excel.html\">H\u01b0\u1edbng d\u1eabn l\u00e0m s\u1ed5 qu\u1ef9 ti\u1ec1n m\u1eb7t, s\u1ed5 k\u1ebf to\u00e1n chi ti\u1ebft ti\u1ec1n m\u1eb7t tr\u00ean excel<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lap-bang-tong-hop-cong-no-phai-thu-khach-hang-tren-excel.html\">C\u00e1ch ghi b\u1ea3ng t\u1ed5ng h\u1ee3p c\u00f4ng n\u1ee3 ph\u1ea3i thu kh\u00e1ch h\u00e0ng<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lan-so-ke-toan-chi-tiet-cong-no-phai-thu.html\">H\u01b0\u1edbng d\u1eabn l\u00e0m s\u1ed5 k\u1ebf to\u00e1n chi ti\u1ebft thanh to\u00e1n v\u1edbi kh\u00e1ch h\u00e0ng trong excel<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lap-bang-tong-hop-tk-ngan-hang-tren-excel.html\">H\u01b0\u1edbng d\u1eabn l\u1eadp b\u1ea3ng t\u1ed5ng h\u1ee3p c\u00e1c t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng tr\u00ean excel<\/a><\/strong><\/em><\/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\/2024\/12\/ex101_92019-nho-715.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7964,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-7963","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\/7963","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=7963"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7963\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7964"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7963"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7963"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7963"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}