{"id":4845,"date":"2024-12-08T11:03:23","date_gmt":"2024-12-08T11:03:23","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/huong-dan-cach-lap-bang-so-sanh-ke-hoach-voi-thuc-hien-du-an-trong-excel\/"},"modified":"2024-12-08T11:03:23","modified_gmt":"2024-12-08T11:03:23","slug":"huong-dan-cach-lap-bang-so-sanh-ke-hoach-voi-thuc-hien-du-an-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/huong-dan-cach-lap-bang-so-sanh-ke-hoach-voi-thuc-hien-du-an-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp b\u1ea3ng so s\u00e1nh k\u1ebf ho\u1ea1ch v\u1edbi th\u1ef1c hi\u1ec7n d\u1ef1 \u00e1n trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong c\u00f4ng vi\u1ec7c qu\u1ea3n l\u00fd d\u1ef1\u00a0\u00e1n th\u00ec kh\u00f4ng ph\u1ea3i ch\u1ec9 c\u00f3 m\u1ed7i vi\u1ec7c l\u1eadp k\u1ebf ho\u1ea1ch. K\u1ebf ho\u1ea1ch ch\u1ec9 l\u00e0 l\u00fd thuy\u1ebft, l\u00e0 b\u01b0\u1edbc ban\u00a0\u0111\u1ea7u. Khi th\u1ef1c hi\u1ec7n ph\u1ea3i lu\u00f4n lu\u00f4n c\u00f3 s\u1ef1 so s\u00e1nh,\u00a0\u0111\u1ed1i chi\u1ebfu gi\u1eefa k\u1ebf ho\u1ea1ch v\u1edbi th\u1ef1c t\u1ebf\u00a0\u0111\u1ec3\u00a0\u0111i\u1ec1u ch\u1ec9nh c\u00e1c ph\u1ea7n vi\u1ec7c, t\u1ed5 ch\u1ee9c l\u1ea1i c\u00e1c ngu\u1ed3n l\u1ef1c cho ph\u00f9 h\u1ee3p. Trong b\u00e0i vi\u1ebft n\u00e0y H\u1ecdc\u00a0Excel Online s\u1ebd gi\u00fap b\u1ea1n bi\u1ebft c\u00e1ch l\u1eadp b\u1ea3ng so s\u00e1nh k\u1ebf ho\u1ea1ch v\u1edbi th\u1ef1c hi\u1ec7n d\u1ef1\u00a0\u00e1n trong\u00a0Excel.\u00a0\u0110\u00e2y l\u00e0 m\u1ed9t ki\u1ebfn th\u1ee9c r\u1ea5t quan tr\u1ecdng trong c\u00f4ng vi\u1ec7c qu\u1ea3n l\u00fd d\u1eef\u00a0\u00e1n, theo d\u00f5i ti\u1ebfn\u00a0\u0111\u1ed9 d\u1ef1\u00a0\u00e1n tr\u00ean\u00a0Excel.<\/p>\n<p>N\u1ed9i dung trong b\u00e0i h\u1ecdc n\u00e0y s\u1ebd c\u00f3 li\u00ean quan t\u1edbi b\u00e0i \u201c<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-xac-dinh-tien-do-du-an-voi-ham-workday-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch x\u00e1c \u0111\u1ecbnh ti\u1ebfn \u0111\u1ed9 d\u1ef1 \u00e1n v\u1edbi h\u00e0m workday trong Excel<\/a>\u201c, n\u1ebfu b\u1ea1n ch\u01b0a n\u1eafm\u00a0\u0111\u01b0\u1ee3c b\u00e0i\u00a0\u0111\u00f3 th\u00ec c\u1ea7n xem l\u1ea1i.<\/p>\n<p>Y\u00eau c\u1ea7u c\u1ee7a ch\u00fang ta trong b\u00e0i n\u00e0y nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18305\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-gantt-chart-actual-plan-prepare-01.png\" width=\"1396\" height=\"370\" title=\"heo-gantt-chart-actual-plan-prepare-01\"><\/p>\n<p>Trong b\u00e0i h\u1ecdc tr\u01b0\u1edbc ch\u00fang ta\u00a0\u0111\u00e3 bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m\u00a0Workday.INTL\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c ng\u00e0y b\u1eaft \u0111\u1ea7u\u00a0(<em>Start date<\/em>) v\u00e0 ng\u00e0y k\u1ebft th\u00fac (<em>End date<\/em>)\u00a0c\u1ee7a t\u1eebng ph\u1ea7n vi\u1ec7c (<em>Task<\/em>). Nh\u01b0ng\u00a0\u0111\u00f3 m\u1edbi ch\u1ec9 l\u00e0 k\u1ebf ho\u1ea1ch (<em>Plan<\/em>).<\/p>\n<p>Th\u1ef1c t\u1ebf cho th\u1ea5y ph\u1ea7n th\u1eddi gian l\u00e0m vi\u1ec7c (<em>working days<\/em>)\u00a0 trong th\u1ef1c t\u1ebf (<em>Actual<\/em>) kh\u00e1c so v\u1edbi k\u1ebf ho\u1ea1ch (<em>Plan<\/em>).<\/p>\n<p><strong>Y\u00eau c\u1ea7u<\/strong>: L\u1eadp b\u1ea3ng Actual\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh c\u00e1c ch\u1ec9 ti\u00eau ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u, ng\u00e0y k\u1ebft th\u00fac c\u1ee7a t\u1eebng ph\u1ea7n vi\u1ec7c trong th\u1ef1c t\u1ebf, v\u00e0\u00a0th\u1eddi gian th\u1ef1c hi\u1ec7n c\u1ee7a d\u1ef1 \u00e1n\u00a0(<em>Data preparation<\/em>), bi\u1ebft ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u th\u1ef1c hi\u1ec7n task1 gi\u1ed1ng v\u1edbi k\u1ebf ho\u1ea1ch.<\/p>\n<p><em>Data preparation l\u00e0 D\u1eef li\u1ec7u\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng\u00a0\u0111\u1ec3 v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3 gantt chart theo d\u00f5i ti\u1ebfn\u00a0\u0111\u1ed9 c\u1ee7a d\u1ef1\u00a0\u00e1n<\/em><\/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\/2024\/12\/ex101_92019-nho-398.gif\" title=\"ex101_92019-nho-398\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-67557cfa63418\" 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-lap-bang-so-sanh-ke-hoach-voi-thuc-hien-du-an-trong-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-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-lap-bang-so-sanh-ke-hoach-voi-thuc-hien-du-an-trong-excel.html#1_Lap_bang_theo_doi_thuc_te_Actual\" title=\"1. L\u1eadp b\u1ea3ng theo d\u00f5i th\u1ef1c t\u1ebf (Actual)\">1. L\u1eadp b\u1ea3ng theo d\u00f5i th\u1ef1c t\u1ebf (Actual)<\/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-lap-bang-so-sanh-ke-hoach-voi-thuc-hien-du-an-trong-excel.html#2_Lap_bang_so_sanh_thoi_gian_thuc_hien_du_an\" title=\"2. L\u1eadp b\u1ea3ng so s\u00e1nh\u00a0th\u1eddi gian th\u1ef1c hi\u1ec7n\u00a0d\u1ef1\u00a0\u00e1n\">2. L\u1eadp b\u1ea3ng so s\u00e1nh\u00a0th\u1eddi gian th\u1ef1c hi\u1ec7n\u00a0d\u1ef1\u00a0\u00e1n<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-lap-bang-so-sanh-ke-hoach-voi-thuc-hien-du-an-trong-excel.html#Buoc_1_Lap_danh_sach_chon_cho_Project_timeline\" title=\"B\u01b0\u1edbc 1: L\u1eadp danh s\u00e1ch ch\u1ecdn cho Project timeline\">B\u01b0\u1edbc 1: L\u1eadp danh s\u00e1ch ch\u1ecdn cho Project timeline<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-lap-bang-so-sanh-ke-hoach-voi-thuc-hien-du-an-trong-excel.html#Buoc_2_Xay_dung_cong_thuc_cho_bang_Data_Preparation\" title=\"B\u01b0\u1edbc 2: X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c cho b\u1ea3ng Data Preparation\">B\u01b0\u1edbc 2: X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c cho b\u1ea3ng Data Preparation<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><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<h3><span class=\"ez-toc-section\" id=\"1_Lap_bang_theo_doi_thuc_te_Actual\"><\/span>1. L\u1eadp b\u1ea3ng theo d\u00f5i th\u1ef1c t\u1ebf (Actual)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>a. T\u1ea1i ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u th\u1ef1c hi\u1ec7n task 1 (\u00f4 H4)<\/strong> ta c\u00f3:<\/p>\n<p style=\"padding-left: 30px\">H4 = D4 b\u1edfi\u00a0ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u th\u1ef1c hi\u1ec7n task1 gi\u1ed1ng v\u1edbi k\u1ebf ho\u1ea1ch.<\/p>\n<p><strong>b. X\u00e1c\u00a0\u0111\u1ecbnh ng\u00e0y k\u1ebft th\u00fac c\u1ee7a Task 1 t\u1ea1i\u00a0\u00f4 J4<\/strong>:<\/p>\n<p>S\u1eed d\u1ee5ng h\u00e0m\u00a0Workday.INTL gi\u1ed1ng v\u1edbi b\u00e0i tr\u01b0\u1edbc ta c\u00f3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18308\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-gantt-chart-actual-task-01.png\" width=\"1441\" height=\"342\" title=\"heo-gantt-chart-actual-task-01\"><\/p>\n<p style=\"padding-left: 30px\">J4=WORKDAY.INTL(H4,I4,11,$O$2:$O$3)<\/p>\n<p>(theo\u00a0\u0111\u1ec1 b\u00e0i ban\u00a0\u0111\u1ea7u l\u00e0 ngh\u1ec9 c\u00e1c ng\u00e0y ch\u1ee7 nh\u1eadt v\u00e0 ngh\u1ec9 l\u1ec5 ng\u00e0y 30\/4 v\u00e0 01\/05)<\/p>\n<p><strong>c. Ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u c\u1ee7a task 2<\/strong> s\u1ebd l\u00e0:<\/p>\n<p style=\"padding-left: 30px\">H5=J4+1<\/p>\n<p>Ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u task 2 s\u1ebd sau ng\u00e0y k\u1ebft th\u00fac task 1 l\u00e0 1 ng\u00e0y<\/p>\n<p><strong>d. Ng\u00e0y k\u1ebft th\u00fac c\u1ee7a task 2<\/strong>:<\/p>\n<p>\u00c1p d\u1ee5ng t\u01b0\u01a1ng t\u1ef1 v\u1edbi task 1 khi\u00a0\u0111\u00e3 bi\u1ebft ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u (H5) v\u00e0 ng\u00e0y l\u00e0m vi\u1ec7c (I5) b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m\u00a0Workday.INTL nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18309\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-gantt-chart-actual-task-02.png\" width=\"1437\" height=\"384\" title=\"heo-gantt-chart-actual-task-02\"><\/p>\n<p style=\"padding-left: 30px\">J5=WORKDAY.INTL(H5,I5,11,$O$2:$O$3)<\/p>\n<p>\u00c1p d\u1ee5ng t\u01b0\u01a1ng t\u1ef1 v\u1edbi c\u00e1c task c\u00f2n l\u1ea1i theo nguy\u00ean t\u1eafc gi\u1ed1ng task 2 l\u00e0:<\/p>\n<ul>\n<li>Ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u = Ng\u00e0y k\u1ebft th\u00fac task tr\u01b0\u1edbc\u00a0\u0111\u00f3 + 1 ng\u00e0y<\/li>\n<li>Ng\u00e0y k\u1ebft th\u00fac = S\u1eed d\u1ee5ng h\u00e0m\u00a0WORKDAY.INTL (ho\u1eb7c filldown c\u00f4ng th\u1ee9c\u00a0\u1edf c\u1ed9t J)<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"2_Lap_bang_so_sanh_thoi_gian_thuc_hien_du_an\"><\/span>2. L\u1eadp b\u1ea3ng so s\u00e1nh\u00a0th\u1eddi gian th\u1ef1c hi\u1ec7n\u00a0d\u1ef1\u00a0\u00e1n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u0103n c\u1ee9 v\u00e0o 2 b\u1ea3ng l\u00e0 Plan v\u00e0 Actual ch\u00fang ta s\u1ebd\u00a0t\u00ednh to\u00e1n\u00a0\u0111\u1ec3\u00a0\u0111\u01b0a d\u1eef li\u1ec7u v\u00e0o b\u1ea3ng Data Preparation theo Ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u c\u1ee7a m\u1ed7i task v\u00e0 S\u1ed1 ng\u00e0y di\u1ec5n ra c\u00f4ng vi\u1ec7c\u00a0\u0111\u00f3 t\u00ednh c\u1ea3 ng\u00e0y ngh\u1ec9<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Buoc_1_Lap_danh_sach_chon_cho_Project_timeline\"><\/span><strong>B\u01b0\u1edbc 1: L\u1eadp danh s\u00e1ch ch\u1ecdn cho Project timeline<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>B\u01b0\u1edbc n\u00e0y ch\u00ednh l\u00e0 x\u00e9t th\u1eddi gian c\u1ee7a d\u1ef1\u00a0\u00e1n theo k\u1ebf ho\u1ea1ch hay theo th\u1ef1c t\u1ebf. C\u0103n c\u1ee9 v\u00e0o n\u1ed9i dung n\u00e0y s\u1ebd bi\u1ebft d\u1eef li\u1ec7u t\u00ednh trong b\u1ea3ng n\u00e0o.<\/p>\n<p>Ch\u00fang ta s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Data validation cho\u00a0\u00f4 M1 nh\u01b0 sau:<\/p>\n<ul>\n<li>Ch\u1ecdn\u00a0\u00f4 M1<\/li>\n<li>Trong th\u1ebb Data tr\u00ean thanh c\u00f4ng c\u1ee5, ch\u1ecdn Data Validation<\/li>\n<li>Trong h\u1ed9p tho\u1ea1i <strong>Data validation<\/strong> ch\u1ecdn <strong>Allow: List<\/strong> v\u00e0 <strong>Source: Plan, Actual<\/strong> nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18310\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-gantt-chart-data-preparation-list-project.png\" width=\"927\" height=\"583\" title=\"heo-gantt-chart-data-preparation-list-project\"><\/p>\n<p>Khi\u00a0\u0111\u00f3 ch\u00fang ta c\u00f3 th\u1ec3 ch\u1ecdn theo danh s\u00e1ch cho\u00a0\u00f4 M1:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18311\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-gantt-chart-data-preparation-list-project-dropdown-list.png\" width=\"298\" height=\"93\" title=\"heo-gantt-chart-data-preparation-list-project-dropdown-list\"><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Buoc_2_Xay_dung_cong_thuc_cho_bang_Data_Preparation\"><\/span><strong>B\u01b0\u1edbc 2: X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c cho b\u1ea3ng Data Preparation<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><strong><em>a. X\u00e9t ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u:<\/em><\/strong><\/p>\n<p>N\u1ebfu M1 l\u00e0 Plan th\u00ec l\u1ea5y theo c\u1ed9t D, n\u1ebfu M1 l\u00e0 Actual th\u00ec l\u1ea5y theo c\u1ed9t H<\/p>\n<p>Do\u00a0\u0111\u00f3 c\u00f4ng th\u1ee9c t\u1ea1i c\u1ed9t L nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">L4 =IF($M$1=\u201dPlan\u201d,D4,H4)<\/p>\n<p>\u00c1p d\u1ee5ng t\u01b0\u01a1ng t\u1ef1 xu\u1ed1ng c\u00e1c task c\u00f2n l\u1ea1i t\u1eeb L4\u00a0\u0111\u1ebfn L9. Trong c\u00f4ng th\u1ee9c tr\u00ean c\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u00f4 M1\u00a0\u0111\u1ec3 kh\u00f4ng thay\u00a0\u0111\u1ed5i v\u1ecb tr\u00ed\u00a0\u00f4 M1 khi sao ch\u00e9p c\u00f4ng th\u1ee9c.<\/p>\n<p><strong><em>b. X\u00e9t s\u1ed1 ng\u00e0y th\u1ef1c hi\u1ec7n<\/em><\/strong><\/p>\n<p>S\u1ed1 ng\u00e0y n\u00e0y l\u00e0 kho\u1ea3ng th\u1eddi gian gi\u1eefa Ng\u00e0y k\u1ebft th\u00fac \u2013 Ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u c\u1ee7a m\u1ed7i Task (bao g\u1ed3m c\u1ea3 ng\u00e0y ngh\u1ec9)<\/p>\n<p>B\u1edfi v\u00ec trong b\u1ea3ng Plan v\u00e0 Actual ch\u1ec9 x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c\u00a0Working days (s\u1ed1 ng\u00e0y c\u00f4ng l\u00e0m vi\u1ec7c kh\u00f4ng t\u00ednh ng\u00e0y ngh\u1ec9)<\/p>\n<p><strong>Do\u00a0\u0111\u00f3:<\/strong><\/p>\n<ul>\n<li>N\u1ebfu M1 l\u00e0 Plan th\u00ec S\u1ed1 ng\u00e0y = C\u1ed9t F \u2013 C\u1ed9t D<\/li>\n<li>N\u1ebfu M1 l\u00e0 Actual th\u00ec S\u1ed1 ng\u00e0y = C\u1ed9t J \u2013 C\u1ed9t H<\/li>\n<\/ul>\n<p>C\u00f4ng th\u1ee9c t\u1ea1i\u00a0\u00f4 M4 nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">M4=IF($M$1=\u201dPlan\u201d,F4-D4,J4-H4)<\/p>\n<p>\u00c1p d\u1ee5ng t\u01b0\u01a1ng t\u1ef1 cho c\u00e1c task c\u00f2n l\u1ea1i t\u1eeb M4\u00a0\u0111\u1ebfn M9<\/p>\n<p><strong><em>c. C\u00e1c ch\u1ec9 ti\u00eau t\u1ed5ng h\u1ee3p<\/em><\/strong><\/p>\n<p>T\u1ed5ng s\u1ed1 ng\u00e0y M10 = T\u1ed5ng t\u1eeb M4\u00a0\u0111\u1ebfn M9 = SUM(M4:M9)<\/p>\n<p>Ng\u00e0y k\u1ebft th\u00fac d\u1ef1\u00a0\u00e1n = Ng\u00e0y b\u1eaft \u0111\u1ea7u + T\u1ed5ng s\u1ed1 ng\u00e0y + T\u1ed5ng c\u00e1c task (m\u1ed7i task s\u1ebd\u00a0c\u1ed9ng th\u00eam\u00a01 ng\u00e0y) \u2013 1 (l\u00e0 ng\u00e0y start date)<\/p>\n<p>(hay n\u00f3i c\u00e1ch kh\u00e1c ng\u00e0y k\u1ebft th\u00fac d\u1ef1\u00a0\u00e1n l\u00e0 ng\u00e0y End date c\u1ee7a task cu\u1ed1i c\u00f9ng)<\/p>\n<p style=\"padding-left: 30px\">M11=L4+M10+COUNTA(L4:L9)-1<\/p>\n<p>K\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18312\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-gantt-chart-case-02-completed-1.png\" width=\"1425\" height=\"342\" title=\"heo-gantt-chart-case-02-completed-1\"><\/p>\n<p>Nh\u01b0 v\u1eady l\u00e0 ch\u00fang ta\u00a0\u0111\u00e3 ho\u00e0n th\u00e0nh xong b\u1ea3ng theo d\u00f5i, qu\u1ea3n l\u00fd d\u1ef1\u00a0\u00e1n bao g\u1ed3m: B\u1ea3ng l\u1eadp k\u1ebf ho\u1ea1ch, b\u1ea3ng theo d\u00f5i th\u1ef1c hi\u1ec7n, b\u1ea3ng so s\u00e1nh v\u00e0 x\u00e1c\u00a0\u0111\u1ecbnh th\u1eddi gian chu\u1ea9n b\u1ecb cho d\u1ef1\u00a0\u00e1n.<\/p>\n<p>B\u00e0i ti\u1ebfp theo: <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-ve-bieu-do-quan-ly-du-an-trong-excel-chi-tiet-nhat.html\">H\u01b0\u1edbng d\u1eabn v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3 Gantt chart\u00a0\u0111\u1ec3 qu\u1ea3n l\u00fd d\u1ef1\u00a0\u00e1n<\/a><\/p>\n<p>Ngo\u00e0i ra\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 n\u00e2ng cao ki\u1ebfn th\u1ee9c v\u1ec1\u00a0Excel v\u00e0\u00a0\u1ee9ng d\u1ee5ng\u00a0Excel v\u00e0o qu\u1ea3n l\u00fd d\u1ef1\u00a0\u00e1n, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham gia kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2JtN0S8\">EX101 \u2013\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a> c\u1ee7a h\u1ec7 th\u1ed1ng H\u1ecdc\u00a0Excel Online. Kh\u00f3a h\u1ecdc s\u1ebd gi\u00fap b\u1ea1n n\u1eafm v\u1eefng c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 trong Excel,\u00a0\u00a0\u1ee9ng d\u1ee5ng Conditional formatting trong vi\u1ec7c t\u1ea1o gantt chart qu\u1ea3n l\u00fd ti\u1ebfn \u0111\u1ed9 d\u1ef1 \u00e1n. Chi ti\u1ebft kh\u00f3a h\u1ecdc xem t\u1ea1i:<\/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\/2024\/12\/ex101_92019-nho-398.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4846,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4845","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\/4845","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=4845"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4845\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4846"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4845"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4845"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4845"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}