{"id":1768,"date":"2024-12-02T06:00:25","date_gmt":"2024-12-02T06:00:25","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/lam-the-nao-de-tinh-lai-kep-trong-excel-cong-thuc-cho-tinh-lai-kep-ngay-thang-nam\/"},"modified":"2024-12-02T06:00:25","modified_gmt":"2024-12-02T06:00:25","slug":"lam-the-nao-de-tinh-lai-kep-trong-excel-cong-thuc-cho-tinh-lai-kep-ngay-thang-nam","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/lam-the-nao-de-tinh-lai-kep-trong-excel-cong-thuc-cho-tinh-lai-kep-ngay-thang-nam\/","title":{"rendered":"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh l\u00e3i k\u00e9p trong Excel, c\u00f4ng th\u1ee9c cho t\u00ednh l\u00e3i k\u00e9p ng\u00e0y, th\u00e1ng, n\u0103m"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, <strong><a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a><\/strong> s\u1ebd \u00a0h\u01b0\u1edbng d\u1eabn cho b\u1ea1n c\u00f4ng th\u1ee9c t\u00ednh l\u00e3i k\u00e9p trong Excel v\u00e0 cung c\u1ea5p c\u00e1c v\u00ed d\u1ee5 v\u1ec1 l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai c\u1ee7a kho\u1ea3n \u0111\u1ea7u t\u01b0 theo l\u00e3i su\u1ea5t k\u00e9p h\u00e0ng n\u0103m, h\u00e0ng th\u00e1ng ho\u1eb7c h\u00e0ng ng\u00e0y. B\u1ea1n c\u0169ng s\u1ebd t\u00ecm th\u1ea5y c\u00e1c b\u01b0\u1edbc chi ti\u1ebft \u0111\u1ec3 t\u1ea1o <strong>c\u00f4ng th\u1ee9c t\u00ednh l\u00e3i k\u00e9p<\/strong> trong Excel c\u1ee7a ri\u00eang b\u1ea1n.<\/p>\n<p style=\"text-align: justify\">L\u00e3i k\u00e9p l\u00e0 m\u1ed9t trong nh\u1eefng ph\u1ea7n c\u01a1 b\u1ea3n trong ng\u00e0nh ng\u00e2n h\u00e0ng v\u00e0 l\u00e0 m\u1ed9t trong nh\u1eefng l\u1ef1c l\u01b0\u1ee3ng t\u00e0i ch\u00ednh m\u1ea1nh nh\u1ea5t \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh k\u1ebft qu\u1ea3 \u0111\u1ea7u t\u01b0 c\u1ee7a b\u1ea1n.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t sinh vi\u00ean k\u1ebf to\u00e1n, nh\u00e0 ph\u00e2n t\u00edch t\u00e0i ch\u00ednh ho\u1eb7c m\u1ed9t nh\u00e0 \u0111\u1ea7u t\u01b0 c\u00f3 kinh nghi\u1ec7m, th\u00ec b\u1ea1n c\u00f3 th\u1ec3 s\u1ebd r\u1ea5t kh\u00f3 kh\u0103n \u0111\u1ec3 n\u1eafm b\u1eaft kh\u00e1i ni\u1ec7m t\u1eeb nh\u1eefng cu\u1ed1n s\u00e1ch v\u00e0 s\u1ed5 tay t\u00e0i ch\u00ednh chuy\u00ean bi\u1ec7t. M\u1ee5c \u0111\u00edch c\u1ee7a b\u00e0i vi\u1ebft n\u00e0y l\u00e0 bi\u1ebfn n\u00f3 tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n \ud83d\ude42 B\u1ea1n c\u0169ng s\u1ebd h\u1ecdc c\u00e1ch s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c l\u00e3i su\u1ea5t k\u00e9p trong Excel v\u00e0 t\u1ea1o ra m\u1ed9t m\u00e1y t\u00ednh l\u00e3i su\u1ea5t k\u00e9p ph\u1ed5 bi\u1ebfn cho c\u00e1c b\u1ea3ng t\u00ednh c\u1ee7a ri\u00eang b\u1ea1n.<\/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-674d4cf851ba5\" 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\/lam-the-nao-de-tinh-lai-kep-trong-excel-cong-thuc-cho-tinh-lai-kep-ngay-thang-nam.html#Lai_kep_la_gi\" title=\"L\u00e3i k\u00e9p l\u00e0 g\u00ec?\">L\u00e3i k\u00e9p l\u00e0 g\u00ec?<\/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\/lam-the-nao-de-tinh-lai-kep-trong-excel-cong-thuc-cho-tinh-lai-kep-ngay-thang-nam.html#Lam_the_nao_de_tinh_lai_kep_trong_Excel\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh l\u00e3i k\u00e9p trong Excel:\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh l\u00e3i k\u00e9p trong Excel:<\/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\/lam-the-nao-de-tinh-lai-kep-trong-excel-cong-thuc-cho-tinh-lai-kep-ngay-thang-nam.html#Tinh_lai_kep_hang_nam_trong_Excel\" title=\"T\u00ednh l\u00e3i k\u00e9p h\u00e0ng n\u0103m trong Excel:\">T\u00ednh l\u00e3i k\u00e9p h\u00e0ng n\u0103m trong Excel:<\/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\/lam-the-nao-de-tinh-lai-kep-trong-excel-cong-thuc-cho-tinh-lai-kep-ngay-thang-nam.html#Cong_thuc_tong_quat_ve_lai_kep\" title=\"C\u00f4ng th\u1ee9c t\u1ed5ng qu\u00e1t v\u1ec1 l\u00e3i k\u00e9p:\">C\u00f4ng th\u1ee9c t\u1ed5ng qu\u00e1t v\u1ec1 l\u00e3i k\u00e9p:<\/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-5\" href=\"https:\/\/blog.hocexcel.online\/lam-the-nao-de-tinh-lai-kep-trong-excel-cong-thuc-cho-tinh-lai-kep-ngay-thang-nam.html#Cong_thuc_lai_kep_pho_bien_trong_Excel_ghep_lai_hang_ngay_hang_tuan_hang_thang_hang_nam\" title=\"C\u00f4ng th\u1ee9c l\u00e3i k\u00e9p ph\u1ed5 bi\u1ebfn trong Excel (gh\u00e9p l\u00e3i h\u00e0ng ng\u00e0y, h\u00e0ng tu\u1ea7n, h\u00e0ng th\u00e1ng, h\u00e0ng n\u0103m)\">C\u00f4ng th\u1ee9c l\u00e3i k\u00e9p ph\u1ed5 bi\u1ebfn trong Excel (gh\u00e9p l\u00e3i h\u00e0ng ng\u00e0y, h\u00e0ng tu\u1ea7n, h\u00e0ng th\u00e1ng, h\u00e0ng n\u0103m)<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lai_kep_la_gi\"><\/span><strong>L\u00e3i k\u00e9p l\u00e0 g\u00ec?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">C\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng h\u01a1n khi b\u1eaft \u0111\u1ea7u v\u1edbi l\u00e3i su\u1ea5t \u0111\u01a1n \u2013 ch\u1ec9 \u0111\u01b0\u1ee3c t\u00ednh tr\u00ean s\u1ed1 ti\u1ec1n ch\u00ednh. V\u00ed d\u1ee5: b\u1ea1n \u0111\u1eb7t 10 \u0111\u00f4-la v\u00e0o t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng. Gi\u00e1 tr\u1ecb kho\u1ea3n ti\u1ec1n g\u1eedi c\u1ee7a b\u1ea1n trong m\u1ed9t n\u0103m t\u1edbi v\u1edbi m\u1ee9c l\u00e3i su\u1ea5t h\u00e0ng n\u0103m 7% l\u00e0 bao nhi\u00eau? C\u00e2u tr\u1ea3 l\u1eddi l\u00e0 10,7 \u0111\u00f4-la v\u00e0 l\u00e3i su\u1ea5t ki\u1ebfm \u0111\u01b0\u1ee3c c\u1ee7a b\u1ea1n l\u00e0 0,7 \u0111\u00f4-la.<\/p>\n<p style=\"text-align: justify\">Trong tr\u01b0\u1eddng h\u1ee3p l\u00e3i su\u1ea5t k\u00e9p, kho\u1ea3n ti\u1ec1n g\u1ed1c trong t\u1eebng kho\u1ea3ng th\u1eddi gian kh\u00e1c nhau th\u00ec kh\u00e1c nhau. Ng\u00e2n h\u00e0ng s\u1ebd kh\u00f4ng tr\u1ea3 l\u00e3i su\u1ea5t cho b\u1ea1n, thay v\u00e0o \u0111\u00f3 h\u1ecd s\u1ebd c\u1ed9ng th\u00eam n\u00f3 v\u00e0o kho\u1ea3n ti\u1ec1n g\u1ed1c \u0111\u1ea7u t\u01b0 c\u1ee7a b\u1ea1n. S\u1ed1 ti\u1ec1n t\u0103ng l\u00ean n\u00e0y s\u1ebd tr\u1edf th\u00e0nh kho\u1ea3n g\u1ed1c cho kho\u1ea3ng th\u1eddi gian ti\u1ebfp theo (t\u00ednh l\u00e3i k\u00e9p) v\u00e0 c\u0169ng ti\u1ebfp t\u1ee5c c\u00f3 l\u00e3i. N\u00f3i c\u00e1ch kh\u00e1c, b\u1ea1n kh\u00f4ng ch\u1ec9 quan t\u00e2m \u0111\u1ebfn s\u1ed1 ti\u1ec1n g\u1ed1c m\u00e0 c\u00f2n quan t\u00e2m \u0111\u1ebfn l\u1ee3i \u00edch ki\u1ebfm \u0111\u01b0\u1ee3c trong m\u1ed7i giai \u0111o\u1ea1n t\u00ednh l\u00e3i.<\/p>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 c\u1ee7a ch\u00fang t\u00f4i, ngo\u00e0i s\u1ed1 ti\u1ec1n g\u1ed1c l\u00e0 10 \u0111\u00f4-la, l\u00e3i su\u1ea5t ki\u1ebfm \u0111\u01b0\u1ee3c l\u00e0 0,7 \u0111\u00f4-la c\u0169ng s\u1ebd c\u00f3 l\u00e3i trong n\u0103m t\u1edbi. V\u00ec v\u1eady, kho\u1ea3n ti\u1ec1n g\u1eedi $ 10 c\u1ee7a b\u1ea1n s\u1ebd l\u00e0 bao nhi\u00eau sau 2 n\u0103m v\u1edbi m\u1ee9c l\u00e3i su\u1ea5t h\u00e0ng n\u0103m l\u00e0 7%? C\u00e2u tr\u1ea3 l\u1eddi l\u00e0 $ 11.45 v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh to\u00e1n n\u00f3 b\u1eb1ng nhi\u1ec1u c\u00e1ch, nh\u01b0 \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_tinh_lai_kep_trong_Excel\"><\/span><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh l\u00e3i k\u00e9p trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ea7u t\u01b0 d\u00e0i h\u1ea1n c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t chi\u1ebfn l\u01b0\u1ee3c hi\u1ec7u qu\u1ea3 \u0111\u1ec3 t\u0103ng s\u1ef1 gi\u00e0u c\u00f3 c\u1ee7a b\u1ea1n, v\u00e0 th\u1eadm ch\u00ed c\u00e1c kho\u1ea3n ti\u1ec1n g\u1eedi nh\u1ecf c\u00f3 th\u1ec3 t\u1ea1o ra s\u1ef1 kh\u00e1c bi\u1ec7t l\u1edbn theo th\u1eddi gian. <strong>C\u00f4ng th\u1ee9c t\u00ednh l\u00e3i su\u1ea5t<\/strong> <strong>k\u00e9p<\/strong> c\u1ee7a Excel \u0111\u01b0\u1ee3c gi\u1ea3i th\u00edch th\u00eam ph\u00eda sau s\u1ebd gi\u00fap b\u1ea1n c\u00f3 chi\u1ebfn l\u01b0\u1ee3c ti\u1ebft ki\u1ec7m c\u1ee7a ri\u00eang m\u00ecnh trong c\u00f4ng vi\u1ec7c. Cu\u1ed1i c\u00f9ng, ch\u00fang ta s\u1ebd l\u00e0m ra m\u1ed9t c\u00f4ng th\u1ee9c chung \u0111\u1ec3 t\u00ednh to\u00e1n gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai c\u1ee7a kho\u1ea3n \u0111\u1ea7u t\u01b0 v\u1edbi b\u1ea5t k\u1ef3 m\u1ee9c l\u00e3i su\u1ea5t k\u00e9p n\u00e0o \u2013 h\u00e0ng ng\u00e0y, h\u00e0ng tu\u1ea7n, h\u00e0ng th\u00e1ng, h\u00e0ng qu\u00fd, ho\u1eb7c h\u00e0ng n\u0103m.<\/p>\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-52.gif\" title=\"vba101_92019-nho-52\"><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-127.gif\" title=\"ex101_92019-nho-127\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tinh_lai_kep_hang_nam_trong_Excel\"><\/span><strong>T\u00ednh l\u00e3i k\u00e9p h\u00e0ng n\u0103m trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ec3 hi\u1ec3u \u00fd t\u01b0\u1edfng v\u1ec1 l\u00e3i su\u1ea5t k\u00e9p t\u1ed1t h\u01a1n, h\u00e3y b\u1eaft \u0111\u1ea7u b\u1eb1ng m\u1ed9t v\u00ed d\u1ee5 r\u1ea5t \u0111\u01a1n gi\u1ea3n \u0111\u01b0\u1ee3c th\u1ea3o lu\u1eadn \u1edf ph\u1ea7n \u0111\u1ea7u c\u1ee7a b\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y \u2013 vi\u1ebft m\u1ed9t <strong>c\u00f4ng th\u1ee9c t\u00ednh\u00a0 l\u00e3i k\u00e9p<\/strong> h\u00e0ng n\u0103m trong Excel. Nh\u01b0 b\u1ea1n nh\u1edb, b\u1ea1n \u0111ang \u0111\u1ea7u t\u01b0 $ 10 v\u1edbi l\u00e3i su\u1ea5t h\u00e0ng n\u0103m l\u00e0 7% v\u00e0 mu\u1ed1n bi\u1ebft l\u00e0m th\u1ebf n\u00e0o m\u00e0 t\u0103ng l\u00e3i su\u1ea5t h\u00e0ng n\u0103m l\u1ea1i l\u00e0m t\u0103ng ti\u1ebft ki\u1ec7m c\u1ee7a b\u1ea1n.<\/p>\n<p style=\"text-align: justify\"><strong>M\u1ee9c l\u00e3i su\u1ea5t k\u00e9p h\u00e0ng n\u0103m \u2013 C\u00f4ng th\u1ee9c 1:<\/strong><\/p>\n<p style=\"text-align: justify\">M\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng v\u00e0 \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 t\u00ednh to\u00e1n s\u1ed1 ti\u1ec1n ki\u1ebfm \u0111\u01b0\u1ee3c v\u1edbi l\u00e3i su\u1ea5t k\u00e9p m\u1ed7i n\u0103m l\u00e0 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c:<\/p>\n<p style=\"text-align: justify\">T\u0103ng l\u01b0\u1ee3ng ti\u1ec1n theo t\u1ef7 l\u1ec7 <strong>%\u00a0 = L\u01b0\u1ee3ng ti\u1ec1n * (1 + %)<\/strong><\/p>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 c\u1ee7a ch\u00fang t\u00f4i, c\u00f4ng th\u1ee9c <strong>\u201c= A2 * (1 + $B2)\u201d<\/strong> trong \u0111\u00f3 A2 l\u00e0 kho\u1ea3n ti\u1ec1n g\u1eedi ban \u0111\u1ea7u c\u1ee7a b\u1ea1n v\u00e0 B2 l\u00e0 l\u00e3i su\u1ea5t h\u00e0ng n\u0103m. Vui l\u00f2ng ch\u00fa \u00fd r\u1eb1ng c\u1ed1 \u0111\u1ecbnh tham chi\u1ebfu \u0111\u1ebfn c\u1ed9t B b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng d\u1ea5u $.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/calculating-compound-interest.png\" alt=\"Using an annual compound interest formula in Excel\" title=\"calculating-compound-interest\"><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft, 1% l\u00e0 m\u1ed9t ph\u1ea7n tr\u0103m, t\u1ee9c l\u00e0 0,01, v\u00ec v\u1eady 7% l\u00e0 0,07 v\u00e0 \u0111\u00e2y l\u00e0 c\u00e1ch t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef trong Excel. L\u01b0u \u00fd r\u1eb1ng b\u1ea1n c\u00f3 th\u1ec3 x\u00e1c minh k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 t\u1eeb c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1ch t\u00ednh \u0111\u01a1n gi\u1ea3n l\u00e0 10 * (1 + 0,07) ho\u1eb7c 10 * 1,07 v\u00e0 ch\u1eafc ch\u1eafn r\u1eb1ng s\u1ed1 d\u01b0 c\u1ee7a b\u1ea1n sau 1 n\u0103m s\u1ebd l\u00e0 10,70 \u0111\u00f4-la.<\/p>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd, ch\u00fang ta h\u00e3y t\u00ednh to\u00e1n t\u00e0i kho\u1ea3n sau 2 n\u0103m. V\u1edbi ti\u1ec1n g\u1eedi $10 s\u1ebd c\u00f3 gi\u00e1 tr\u1ecb nh\u01b0 th\u1ebf n\u00e0o trong hai n\u0103m v\u1edbi l\u00e3i su\u1ea5t h\u00e0ng n\u0103m l\u00e0 7%? C\u00e2u tr\u1ea3 l\u1eddi l\u00e0 $ 11.45 v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 l\u1ea5y n\u00f3 b\u1eb1ng c\u00e1ch sao ch\u00e9p c\u00f9ng m\u1ed9t c\u00f4ng th\u1ee9c v\u00e0o c\u1ed9t D.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/calculate-annual-compound-interest.png\" alt=\"Calculating the future value of the investment after 2 years with annual compound interest\" title=\"calculate-annual-compound-interest\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u00ednh to\u00e1n s\u1ed1 ti\u1ec1n b\u1ea1n s\u1ebd t\u00ecm th\u1ea5y trong t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng c\u1ee7a b\u1ea1n v\u00e0o cu\u1ed1i 3 n\u0103m, ch\u1ec9 c\u1ea7n sao ch\u00e9p c\u00f9ng m\u1ed9t c\u00f4ng th\u1ee9c v\u1edbi c\u1ed9t E v\u00e0 b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c $ 12,25.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/compound-interest-3-years.png\" alt=\"Calculating the amount earned after 3 years with annual compound interest\" title=\"compound-interest-3-years\"><\/p>\n<p style=\"text-align: justify\">Nh\u1eefng b\u1ea1n c\u00f3 kinh nghi\u1ec7m l\u00e0m vi\u1ec7c v\u1edbi Excel h\u1eb3n \u0111\u00e3 nh\u1eabn ra r\u1eb1ng nh\u1eefng g\u00ec c\u00f4ng th\u1ee9c tr\u00ean th\u1ef1c s\u1ef1 l\u00e0m l\u00e0 nh\u00e2n s\u1ed1 ti\u1ec1n g\u1eedi ban \u0111\u1ea7u 10$ v\u1edbi l\u00e3i su\u1ea5t h\u00e0ng n\u0103m 1,07 ba l\u1ea7n:<\/p>\n<p style=\"text-align: justify\">= 10 * 1,07 * 1,07 * 1,07 = 12,25043<\/p>\n<p style=\"text-align: justify\">L\u00e0m tr\u00f2n 2 \u00a0ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n cho k\u1ebft qu\u1ea3 v\u00e0 b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c s\u1ed1 gi\u1ed1ng nh\u01b0 b\u1ea1n th\u1ea5y trong \u00f4 E2 trong h\u00ecnh \u1edf tr\u00ean \u2013 $ 12.25. \u0110\u01b0\u01a1ng nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 tr\u1ef1c ti\u1ebfp t\u00ednh to\u00e1n s\u1ed1 d\u01b0 sau 3 n\u0103m s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y:<\/p>\n<p style=\"text-align: justify\">= A2 * 1,07 * 1,07 * 1,07<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/compound-interest-three-years.png\" alt=\"Another way to calculate the balance after 3 years with annual compound interest\" title=\"compound-interest-three-years\"><\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-co-ban\">H\u1ecdc excel c\u01a1 b\u1ea3n<\/a> uy ti\u0301n ta\u0323i Ha\u0300 N\u00f4\u0323i<\/p>\n<\/blockquote>\n<p style=\"text-align: justify\"><strong>T\u00ednh L\u00e3i k\u00e9p h\u00e0ng n\u0103m \u2013 C\u00f4ng th\u1ee9c 2<\/strong><\/p>\n<p style=\"text-align: justify\">M\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 t\u1ea1o ra c\u00f4ng th\u1ee9c t\u00ednh l\u00e3i k\u00e9p h\u00e0ng n\u0103m l\u00e0 t\u00ednh to\u00e1n l\u00e3i su\u1ea5t ki\u1ebfm \u0111\u01b0\u1ee3c cho m\u1ed7i n\u0103m v\u00e0 sau \u0111\u00f3 th\u00eam n\u00f3 v\u00e0o kho\u1ea3n ti\u1ec1n g\u1eedi ban \u0111\u1ea7u.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed kho\u1ea3n ti\u1ec1n g\u1eedi ban \u0111\u1ea7u (Initial deposit) c\u1ee7a b\u1ea1n n\u1eb1m trong \u00f4 B1 v\u00e0 l\u00e3i su\u1ea5t m\u1ed7i n\u0103m (Annual interest rate) trong \u00f4 B2, th\u00ec c\u00f4ng th\u1ee9c sau \u0111\u00e2y \u0111\u00e3 gi\u1ea3i quy\u1ebft n\u00f3: = B1 + B1 * $B$2.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/annual-compound-interest-excel.png\" alt=\"One more formula for calculating annual compound interest in Excel\" title=\"annual-compound-interest-excel\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 c\u00f4ng th\u1ee9c l\u00e0m vi\u1ec7c ch\u00ednh x\u00e1c, xin l\u01b0u \u00fd c\u00e1c chi ti\u1ebft sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>S\u1eeda ti\u00eau ch\u00ed tham chi\u1ebfu \u0111\u1ebfn \u00f4 <strong><em>Annual Interest Rate<\/em><\/strong> (B2 trong tr\u01b0\u1eddng h\u1ee3p c\u1ee7a ch\u00fang ta) b\u1eb1ng c\u00e1ch th\u00eam d\u1ea5u $, n\u00f3 ph\u1ea3i \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh c\u1ea3 c\u1ed9t v\u00e0 d\u00f2ng, nh\u01b0 $B$2.<\/li>\n<li>Cho n\u0103m th\u1ee9 2 (B6) v\u00e0 t\u1ea5t c\u1ea3 nh\u1eefng n\u0103m ti\u1ebfp theo, thay \u0111\u1ed5i c\u00f4ng th\u1ee9c th\u00e0nh:<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong><em>Year 1 balance + Year 1 balance * Interest Rate<\/em><\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (S\u1ed1 d\u01b0 n\u0103m 1 + S\u1ed1 d\u01b0 n\u0103m 1 * L\u00e3i su\u1ea5t)<\/p>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 n\u00e0y, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c = B5 + B5 * $B$2 v\u00e0o \u00f4 B6 v\u00e0 sau \u0111\u00f3 sao ch\u00e9p n\u00f3 xu\u1ed1ng c\u00e1c h\u00e0ng kh\u00e1c, nh\u01b0 th\u1ec3 hi\u1ec7n trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/balance-five-years.png\" alt=\"The balance for 5 years with 7% interest rate compounded yearly\" title=\"balance-five-years\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u00ecm hi\u1ec3u m\u1ee9c l\u00e3i su\u1ea5t m\u00e0 b\u1ea1n th\u1ef1c s\u1ef1 ki\u1ebfm \u0111\u01b0\u1ee3c b\u1eb1ng l\u00e3i su\u1ea5t h\u1ee3p nh\u1ea5t h\u00e0ng n\u0103m, h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c = B5-B1 (S\u1ed1 d\u01b0 sau 1 n\u0103m \u2013 Ti\u1ec1n g\u1eedi ban \u0111\u1ea7u) trong \u00f4 C5.<\/p>\n<p style=\"text-align: justify\">Sau \u0111\u00f3 nh\u1eadp = B6-B5 (S\u1ed1 d\u01b0 sau 2 n\u0103m \u2013 S\u1ed1 d\u01b0 sau 1 n\u0103m) trong \u00f4 C6 v\u00e0 k\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c \u00f4 kh\u00e1c.<\/p>\n<p style=\"text-align: justify\">B\u1ea1n s\u1ebd th\u1ea5y s\u1ef1 t\u0103ng tr\u01b0\u1edfng t\u1eeb ti\u1ec1n l\u00e3i thu \u0111\u01b0\u1ee3c nh\u01b0 trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y cho th\u1ea5y s\u1ee9c m\u1ea1nh th\u1ef1c s\u1ef1 c\u1ee7a l\u00e3i su\u1ea5t k\u00e9p.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/annual-compound-interest-formula.png\" alt=\"A formula to calculate annual compound interest\" title=\"annual-compound-interest-formula\"><\/p>\n<p style=\"text-align: justify\">C\u00e1c v\u00ed d\u1ee5 tr\u00ean l\u00e0m t\u1ed1t c\u00f4ng vi\u1ec7c minh ho\u1ea1 cho \u00fd t\u01b0\u1edfng t\u00ednh l\u00e3i k\u00e9p, ph\u1ea3i kh\u00f4ng? Nh\u01b0ng kh\u00f4ng c\u00f3 c\u00f4ng th\u1ee9c n\u00e0o \u0111\u1ee7 t\u1ed1t \u0111\u1ec3 \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 <strong>c\u00f4ng th\u1ee9c t\u00ednh l\u00e3i su\u1ea5t<\/strong> chung cho Excel. Th\u1ee9 nh\u1ea5t, b\u1edfi v\u00ec h\u1ecd kh\u00f4ng cho ph\u00e9p b\u1ea1n ch\u1ec9 \u0111\u1ecbnh m\u1ed9t giai \u0111o\u1ea1n t\u00ednh l\u00e3i k\u00e9p, v\u00e0 th\u1ee9 hai, b\u1edfi v\u00ec b\u1ea1n ph\u1ea3i x\u00e2y d\u1ef1ng m\u1ed9t to\u00e0n b\u1ed9 b\u1ea3ng ch\u1ee9 kh\u00f4ng ch\u1ec9 \u0111\u01a1n gi\u1ea3n l\u00e0 nh\u1eadp v\u00e0o m\u1ed9t kho\u1ea3ng th\u1eddi gian nh\u1ea5t \u0111\u1ecbnh v\u00e0 l\u00e3i su\u1ea5t.<\/p>\n<p style=\"text-align: justify\">V\u00e2ng, ch\u00fang ta h\u00e3y \u0111i tr\u01b0\u1edbc m\u1ed9t b\u01b0\u1edbc v\u00e0 t\u1ea1o ra m\u1ed9t c\u00f4ng th\u1ee9c l\u00e3i su\u1ea5t chung cho Excel \u2013 c\u00f3 th\u1ec3 t\u00ednh to\u00e1n \u0111\u01b0\u1ee3c bao nhi\u00eau ti\u1ec1n b\u1ea1n s\u1ebd ki\u1ebfm \u0111\u01b0\u1ee3c \u2013 \u1ee9ng v\u1edbi t\u1ef7 l\u1ec7 l\u00e3i su\u1ea5t h\u00e0ng n\u0103m, h\u00e0ng qu\u00fd, h\u00e0ng th\u00e1ng, h\u00e0ng tu\u1ea7n ho\u1eb7c h\u00e0ng ng\u00e0y.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_tong_quat_ve_lai_kep\"><\/span><strong>C\u00f4ng th\u1ee9c t\u1ed5ng qu\u00e1t v\u1ec1 l\u00e3i k\u00e9p:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Khi c\u00e1c chuy\u00ean gia t\u01b0 v\u1ea5n t\u00e0i ch\u00ednh ph\u00e2n t\u00edch t\u00e1c \u0111\u1ed9ng c\u1ee7a l\u00e3i k\u00e9p \u0111\u1ed1i v\u1edbi \u0111\u1ea7u t\u01b0, h\u1ecd th\u01b0\u1eddng xem x\u00e9t ba y\u1ebfu t\u1ed1 x\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai c\u1ee7a \u0111\u1ea7u t\u01b0 (FV):<\/p>\n<ul style=\"text-align: justify\">\n<li>PV \u2013 gi\u00e1 tr\u1ecb hi\u1ec7n t\u1ea1i c\u1ee7a kho\u1ea3n \u0111\u1ea7u t\u01b0<\/li>\n<li>i \u2013 l\u00e3i su\u1ea5t thu \u0111\u01b0\u1ee3c trong t\u1eebng th\u1eddi k\u1ef3<\/li>\n<li>n \u2013 s\u1ed1 chu k\u1ef3<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Sau khi \u0111\u00e3 bi\u1ebft c\u00e1c y\u1ebfu t\u1ed1 n\u00e0y, th\u00ec b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau \u0111\u1ec3 t\u00ecm ra gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai c\u1ee7a kho\u1ea3n \u0111\u1ea7u t\u01b0 v\u1edbi m\u1ee9c l\u00e3i su\u1ea5t k\u00e9p nh\u1ea5t \u0111\u1ecbnh:<\/p>\n<p style=\"text-align: justify\"><strong>FV = PV * (1 + i)<sup>n<\/sup><\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 minh h\u1ecda cho \u0111i\u1ec3m t\u1ed1t h\u01a1n, \u0111\u00e2y l\u00e0 m\u1ed9t v\u00e0i v\u00ed d\u1ee5 nhanh ch\u00f3ng.<\/p>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 1: C\u00f4ng th\u1ee9c l\u00e3i su\u1ea5t k\u00e9p h\u00e0ng th\u00e1ng<\/strong><\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n \u0111\u1ea7u t\u01b0 2.000 USD v\u1edbi l\u00e3i su\u1ea5t 8% v\u00e0 gh\u00e9p l\u00e3i h\u00e0ng th\u00e1ng v\u00e0, b\u1ea1n mu\u1ed1n bi\u1ebft gi\u00e1 tr\u1ecb \u0111\u1ea7u t\u01b0 sau 5 n\u0103m.<\/p>\n<p style=\"text-align: justify\">Tr\u01b0\u1edbc ti\u00ean, h\u00e3y vi\u1ebft xu\u1ed1ng danh s\u00e1ch c\u00e1c y\u1ebfu t\u1ed1 li\u00ean quan \u0111\u1ebfn c\u00f4ng th\u1ee9c l\u00e3i k\u00e9p c\u1ee7a b\u1ea1n:<\/p>\n<ul style=\"text-align: justify\">\n<li>PV = 2.000 \u0111\u00f4-la<\/li>\n<li>i = 8%n\u0103m, gh\u00e9p l\u00e3i h\u00e0ng th\u00e1ng (l\u00e3i su\u1ea5t m\u1ed7i th\u00e1ng = 0.08 \/ 12 = 006666667)<\/li>\n<li>n = 5 n\u0103m x 12 th\u00e1ng (5 * 12 = 60)<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Nh\u1eadp s\u1ed1 li\u1ec7u \u1edf tr\u00ean v\u00e0o c\u00f4ng th\u1ee9c, v\u00e0 b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c:<\/p>\n<p style=\"text-align: justify\"><strong>= $2,000 * (1 + 0.8\/12)<sup>5\u00d712 <\/sup><\/strong><\/p>\n<p style=\"text-align: justify\">ho\u1eb7c l\u00e0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <strong>= $2,000 * 1.006666667<sup>60<\/sup><\/strong><\/p>\n<p style=\"text-align: justify\">ho\u1eb7c l\u00e0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <strong>= $2,000 * 1.489845708 = $2,979.69<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 2: C\u00f4ng th\u1ee9c l\u00e3i su\u1ea5t h\u00e0ng ng\u00e0y<\/strong><\/p>\n<p style=\"text-align: justify\">T\u00f4i hy v\u1ecdng b\u1ea1n \u0111\u00e3 hi\u1ec3u r\u00f5 v\u00ed d\u1ee5 v\u1ec1 l\u00e3i k\u00e9p h\u00e0ng th\u00e1ng, v\u00e0 b\u00e2y gi\u1edd b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u01b0\u01a1ng ph\u00e1p t\u01b0\u01a1ng t\u1ef1 cho tr\u01b0\u1eddng h\u1ee3p gh\u00e9p l\u00e3i h\u00e0ng ng\u00e0y. Kho\u1ea3n \u0111\u1ea7u t\u01b0 ban \u0111\u1ea7u, l\u00e3i su\u1ea5t, th\u1eddi gian v\u00e0 c\u00f4ng th\u1ee9c gi\u1ed1ng h\u1ec7t nh\u01b0 trong v\u00ed d\u1ee5 tr\u00ean, ch\u1ec9 c\u00f3 giai \u0111o\u1ea1n k\u1ebft h\u1ee3p kh\u00e1c nhau:<\/p>\n<ul style=\"text-align: justify\">\n<li>PV = 2.000 \u0111\u00f4 la<\/li>\n<li>i = 8% m\u1ed7i n\u0103m, gh\u00e9p l\u00e3i m\u1ed7i ng\u00e0y (0.08 \/ 365 = 0.000219178)<\/li>\n<li>n = 5 n\u0103m x 365 ng\u00e0y (5 * 365 = 1825)<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Cung c\u1ea5p c\u00e1c con s\u1ed1 cho c\u00f4ng th\u1ee9c l\u00e3i k\u00e9p, v\u00e0 b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 sau:<\/p>\n<p style=\"text-align: justify\"><strong>=$2,000 * (1 + 0.000219178)<sup>1825 <\/sup>= $2,983.52<\/strong><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n th\u1ea5y \u0111\u1ea5y, v\u1edbi tr\u01b0\u1eddng h\u1ee3p gh\u00e9p l\u00e3i h\u00e0ng ng\u00e0y, gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai c\u1ee7a c\u00f9ng m\u1ed9t kho\u1ea3n \u0111\u1ea7u t\u01b0 cao h\u01a1n m\u1ed9t ch\u00fat so v\u1edbi tr\u01b0\u1eddng h\u1ee3p gh\u00e9p l\u00e3i h\u00e0ng th\u00e1ng. \u0110i\u1ec1u n\u00e0y l\u00e0 do l\u00e3i su\u1ea5t 8% l\u00e0m t\u0103ng l\u00e3i su\u1ea5t cho s\u1ed1 ti\u1ec1n g\u1ed1c m\u1ed7i ng\u00e0y thay v\u00ec m\u1ed7i th\u00e1ng. Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 \u0111o\u00e1n, k\u1ebft qu\u1ea3 gh\u00e9p l\u00e3i h\u00e0ng th\u00e1ng s\u1ebd cao h\u01a1n gh\u00e9p l\u00e3i h\u00e0ng n\u0103m.<\/p>\n<p style=\"text-align: justify\">T\u1ea5t c\u1ea3 \u0111\u1ec1u t\u1ed1t cho b\u1ea1n c\u1ea3, nh\u01b0ng nh\u1eefng g\u00ec b\u1ea1n th\u1ef1c s\u1ef1 mu\u1ed1n l\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c Excel cho l\u00e3i k\u00e9p, ph\u1ea3i kh\u00f4ng? Mong b\u1ea1n v\u1eabn c\u00f9ng t\u00f4i ti\u1ebfp t\u1ee5c \u0111i theo \u00fd t\u01b0\u1edfng n\u00e0y. B\u00e2y gi\u1edd ch\u00fang t\u00f4i \u0111ang chu\u1ea9n b\u1ecb \u0111\u1ec1 c\u1eadp t\u1edbi ph\u1ea7n th\u00fa v\u1ecb nh\u1ea5t \u2013 x\u00e2y d\u1ef1ng m\u00e1y t\u00ednh t\u00ednh l\u00e3i k\u00e9p c\u1ee7a ri\u00eang b\u1ea1n m\u1ea1nh v\u00e0 \u0111a n\u0103ng trong Excel.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_lai_kep_pho_bien_trong_Excel_ghep_lai_hang_ngay_hang_tuan_hang_thang_hang_nam\"><\/span><strong>C\u00f4ng th\u1ee9c l\u00e3i k\u00e9p ph\u1ed5 bi\u1ebfn trong Excel (gh\u00e9p l\u00e3i h\u00e0ng ng\u00e0y, h\u00e0ng tu\u1ea7n, h\u00e0ng th\u00e1ng, h\u00e0ng n\u0103m)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Th\u00f4ng th\u01b0\u1eddng, c\u00f3 nhi\u1ec1u c\u00e1ch \u0111\u1ec3 l\u00e0m \u0111i\u1ec1u g\u00ec \u0111\u00f3 trong Excel v\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c t\u00ednh l\u00e3i k\u00e9p c\u0169ng kh\u00f4ng ph\u1ea3i l\u00e0 ngo\u1ea1i l\u1ec7 \ud83d\ude42 M\u1eb7c d\u00f9 Microsoft Excel kh\u00f4ng cung c\u1ea5p h\u00e0m c\u00f4ng th\u1ee9c \u0111\u1eb7c bi\u1ec7t n\u00e0o \u0111\u1ec3 t\u00ednh l\u00e3i k\u00e9p, nh\u01b0ng b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec3 t\u1ea1o ra m\u00e1y t\u00ednh t\u00ednh l\u00e3i k\u00e9p c\u1ee7a ri\u00eang b\u1ea1n.<\/p>\n<p style=\"text-align: justify\">H\u00e3y b\u1eaft \u0111\u1ea7u t\u1ea1o ra m\u1ed9t m\u00e1y t\u00ednh t\u00ednh l\u00e3i k\u00e9p trong Excel c\u1ee7a ch\u00fang t\u00f4i b\u1eb1ng c\u00e1ch nh\u1eadp c\u00e1c y\u1ebfu t\u1ed1 c\u01a1 b\u1ea3n, nh\u1eb1m x\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai c\u1ee7a m\u1ed9t kho\u1ea3n \u0111\u1ea7u t\u01b0 v\u00e0o m\u1ed9t b\u1ea3ng t\u00ednh Excel:<\/p>\n<ul style=\"text-align: justify\">\n<li><strong><em>Initial investment<\/em><\/strong>: Kho\u1ea3n \u0111\u1ea7u t\u01b0 ban \u0111\u1ea7u (A3)<\/li>\n<li><strong><em>Annual interest rate<\/em><\/strong>: L\u00e3i su\u1ea5t n\u0103m (A4)<\/li>\n<li><strong><em>Number of compounding periods per year<\/em><\/strong>: s\u1ed1 k\u00ec tr\u1ea3 l\u00e3i m\u1ed7i n\u0103m (A5)<\/li>\n<li><strong><em>Number of years<\/em><\/strong>: S\u1ed1 n\u0103m (A6)<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Khi k\u1ebft th\u00fac, b\u1ea3ng t\u00ednh Excel c\u1ee7a b\u1ea1n c\u00f3 th\u1ec3 tr\u00f4ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/compound-interest-calculator-excel.png\" alt=\"Creating a compound interest calculator in Excel\" title=\"compound-interest-calculator-excel\"><\/p>\n<p style=\"text-align: justify\">T\u1ea5t c\u1ea3 nh\u1eefng g\u00ec b\u1ea1n c\u1ea7n b\u00e2y gi\u1edd l\u00e0 c\u00f4ng th\u1ee9c l\u00e3i k\u00e9p \u0111\u1ec3 t\u00ednh s\u1ed1 ti\u1ec1n ki\u1ebfm \u0111\u01b0\u1ee3c (S\u1ed1 d\u01b0) d\u1ef1a tr\u00ean c\u00e1c gi\u00e1 tr\u1ecb \u0111\u1ea7u v\u00e0o. \u00a0Ch\u00fang ta s\u1ebd \u0111\u01a1n gi\u1ea3n d\u00f9ng c\u00f4ng th\u1ee9c t\u00ednh l\u00e3i k\u00e9p, m\u00e0 \u0111\u01b0\u1ee3c ng\u00e2n h\u00e0ng v\u00e0 c\u00e1c t\u1ed5 ch\u1ee9c t\u00e0i ch\u00ednh kh\u00e1c s\u1eed d\u1ee5ng v\u00e0 \u0111\u01b0\u1ee3c s\u1eeda \u0111\u1ed5i m\u1ed9t ch\u00fat \u0111\u1ec3 Excel c\u00f3 th\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c n\u00f3.<\/p>\n<p style=\"text-align: justify\"><strong>C\u00f4ng th\u1ee9c t\u00ednh l\u00e3i k\u00e9p cho Excel:<\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em>=<\/em><\/strong><strong><em>Initial investment<\/em><\/strong><strong><em>\u00a0* (1 +\u00a0<\/em><\/strong><strong><em>Annual interest rate<\/em><\/strong><strong><em>\u00a0\/\u00a0<\/em><\/strong><strong><em>Compounding periods per year<\/em><\/strong><strong><em>) ^ (<\/em><\/strong><strong><em>Years<\/em><\/strong><strong><em>\u00a0*\u00a0<\/em><\/strong><strong><em>Compounding periods per year<\/em><\/strong><strong><em>)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Khi \u0111i\u1ec1u ch\u1ec9nh m\u00e1y t\u00ednh t\u00ednh l\u00e3i k\u00e9p (\u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb trong h\u00ecnh \u1edf tr\u00ean), c\u00f4ng th\u1ee9c c\u00f3 d\u1ea1ng sau:<\/p>\n<p style=\"text-align: justify\">= B3 * (1 + B4 \/ B5) ^ (B6 * B5)<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/compound-interest-formula-excel.png\" alt=\"Compound interest formula for Excel\" title=\"compound-interest-formula-excel\"><\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ea5y c\u00e1c con s\u1ed1 kh\u00e1 quen thu\u1ed9c? \u00a0N\u1ebfu b\u1ea1n mu\u1ed1n bi\u1ebft \u0111\u1ea7u t\u01b0 c\u1ee7a b\u1ea1n s\u1ebd c\u00f3 gi\u00e1 tr\u1ecb nh\u01b0 th\u1ebf n\u00e0o v\u1edbi l\u00e3i su\u1ea5t 8% h\u00e0ng n\u0103m trong tr\u01b0\u1eddng h\u1ee3p gh\u00e9p l\u00e3i m\u1ed7i qu\u00fd, ch\u1ec9 c\u1ea7n nh\u1eadp 4 v\u00e0o \u00f4 B5:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/calculate-compound-interest-excel.png\" alt=\"Calculating the future value of the investment with quarterly compounding\" title=\"calculate-compound-interest-excel\"><\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam: T\u00f4\u0309ng h\u01a1\u0323p nh\u01b0\u0303ng ba\u0300i h\u01b0\u01a1\u0301ng d\u00e2\u0303n v\u00ea\u0300\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">Excel c\u01a1 ba\u0309n<\/a> hay nh\u00e2\u0301t mo\u0323i th\u01a1\u0300i \u0111a\u0323i<\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai c\u1ee7a kho\u1ea3n \u0111\u1ea7u t\u01b0 c\u1ee7a b\u1ea1n v\u1edbi gh\u00e9p l\u00e3i m\u1ed7i n\u1eeda n\u0103m, h\u00e3y nh\u1eadp 2 v\u00e0o \u00f4 Compounding periods per year. \u0110\u1ed1i v\u1edbi l\u00e3i su\u1ea5t h\u00e0ng tu\u1ea7n, nh\u1eadp 52, \u0111\u00e2y l\u00e0 s\u1ed1 tu\u1ea7n t\u01b0\u01a1ng \u1ee9ng m\u1ed7i n\u0103m. N\u1ebfu b\u1ea1n quan t\u00e2m \u0111\u1ebfn vi\u1ec7c gh\u00e9p l\u00e3i h\u00e0ng ng\u00e0y, h\u00e3y nh\u1eadp 365, v.v.<\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n th\u1ea5y, ch\u00fang t\u00f4i \u0111\u00e3 t\u1ea1o ra m\u1ed9t m\u00e1y t\u00ednh ph\u1ed5 bi\u1ebfn t\u00ednh l\u00e3i k\u00e9p th\u1ef1c s\u1ef1 cho Excel. Hy v\u1ecdng r\u1eb1ng b\u00e2y gi\u1edd b\u1ea1n kh\u00f4ng h\u1ec1 h\u1ed1i ti\u1ebfc v\u00ec \u0111\u00e3 \u0111\u1ea7u t\u01b0 v\u00e0i ph\u00fat \u0111\u1ec3 t\u00ecm ra c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p m\u00e0 c\u00e1c nh\u00e0 l\u1eadp k\u1ebf ho\u1ea1ch t\u00e0i ch\u00ednh s\u1eed d\u1ee5ng:)<\/p>\n<p style=\"text-align: justify\"><strong>M\u1edf r\u1ed9ng c\u00f4ng th\u1ee9c t\u00ednh l\u00e3i k\u00e9p cho Excel<\/strong><\/p>\n<p style=\"text-align: justify\">N\u1ebfu v\u00ec l\u00fd do n\u00e0o \u0111\u00f3 b\u1ea1n kh\u00f4ng h\u00e0i l\u00f2ng v\u1edbi c\u00f4ng th\u1ee9c l\u00e3i su\u1ea5t chung \u0111\u01b0\u1ee3c th\u1ea3o lu\u1eadn \u1edf tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o ra m\u00e1y t\u00ednh l\u00e3i su\u1ea5t h\u1ee3p ch\u1ea5t Excel c\u1ee7a b\u1ea1n v\u1edbi h\u00e0m Gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai \u2013 c\u00f3 s\u1eb5n trong Microsoft Excel 2013, 2010, 2007, 2003 v\u00e0 2000.<\/p>\n<p style=\"text-align: justify\">H\u00e0m FV c\u1ee7a Excel tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai c\u1ee7a m\u1ed9t kho\u1ea3n \u0111\u1ea7u t\u01b0 d\u1ef1a tr\u00ean c\u00e1c y\u1ebfu t\u1ed1 t\u01b0\u01a1ng t\u1ef1 nh\u01b0 nh\u1eefng g\u00ec ch\u00fang ta v\u1eeba th\u1ea3o lu\u1eadn, m\u1eb7c d\u00f9 c\u00fa ph\u00e1p c\u1ee7a n\u00f3 h\u01a1i kh\u00e1c:<\/p>\n<p style=\"text-align: justify\"><strong><em>FV(rate, nper, pmt, [pv], [type])<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Trong c\u00f4ng th\u1ee9c tr\u00ean, 3 \u0111\u1ed1i s\u1ed1 \u0111\u1ea7u ti\u00ean l\u00e0 b\u1eaft bu\u1ed9c v\u00e0 2 \u0111\u1ed1i s\u1ed1 sau c\u00f9ng l\u00e0 t\u00f9y ch\u1ecdn.<\/p>\n<ul style=\"text-align: justify\">\n<li>rate \u2013 l\u00e3i su\u1ea5t cho m\u1ed7i k\u1ef3, y nh\u01b0 t\u00ean c\u1ee7a \u0111\u1ed1i s\u1ed1.<\/li>\n<li>nper \u2013 s\u1ed1 k\u00ec thanh to\u00e1n.<\/li>\n<li>pmt \u2013 m\u1ed9t kho\u1ea3n thanh to\u00e1n b\u1ed5 sung \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n m\u1ed7i k\u1ef3, \u0111\u1ea1i di\u1ec7n nh\u01b0 m\u1ed9t s\u1ed1 \u00e2m. N\u1ebfu \u0111\u1ed1i s\u1ed1 pmt b\u1ecb b\u1ecf qua, tham s\u1ed1 pv ph\u1ea3i \u0111\u01b0\u1ee3c \u0111\u01b0a v\u00e0o.<\/li>\n<li>pv (t\u00f9y ch\u1ecdn) \u2013 gi\u00e1 tr\u1ecb hi\u1ec7n t\u1ea1i c\u1ee7a \u0111\u1ea7u t\u01b0 (\u0111\u1ea7u t\u01b0 c\u01a1 b\u1ea3n), c\u0169ng l\u00e0 m\u1ed9t con s\u1ed1 \u00e2m. N\u1ebfu \u0111\u1ed1i s\u1ed1 pv b\u1ecb b\u1ecf qua, n\u00f3 \u0111\u01b0\u1ee3c gi\u1ea3 \u0111\u1ecbnh b\u1eb1ng kh\u00f4ng (0), trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y tham s\u1ed1 pmt ph\u1ea3i \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh.<\/li>\n<li>type (t\u00f9y ch\u1ecdn) \u2013 quy \u0111\u1ecbnh khi n\u00e0o c\u00e1c kho\u1ea3n thanh to\u00e1n ph\u1ee5 th\u00eam ph\u1ea3i tr\u1ea3: 0 ho\u1eb7c b\u1ecf qua \u2013 v\u00e0o cu\u1ed1i k\u1ef3, v\u00e0 1 \u2013 v\u00e0o \u0111\u1ea7u k\u1ef3.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">H\u00e3y s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c Excel FV v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb gi\u1ed1ng nh\u01b0 trong c\u00e1c v\u00ed d\u1ee5 v\u1ec1 t\u00ednh l\u00e3i k\u00e9p h\u00e0ng th\u00e1ng v\u00e0 xem li\u1ec7u k\u1ebft qu\u1ea3 c\u00f3 t\u01b0\u01a1ng t\u1ef1 hay kh\u00f4ng nh\u00e9:<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed, ch\u00fang t\u00f4i g\u1eedi $ 2.000 TRONG 5 n\u0103m v\u00e0o t\u00e0i kho\u1ea3n ti\u1ebft ki\u1ec7m v\u1edbi m\u1ee9c l\u00e3i su\u1ea5t 8%\/n\u0103m, k\u1ebf ho\u1ea1ch gh\u00e9p l\u00e3i h\u00e0ng th\u00e1ng, v\u00e0 kh\u00f4ng c\u00f3 kho\u1ea3n thanh to\u00e1n b\u1ed5 sung. V\u00ec v\u1eady, c\u00f4ng th\u1ee9c t\u00ednh l\u00e3i k\u00e9p trong Excel c\u1ee7a ch\u00fang t\u00f4i nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">= FV (0,08 \/12, 5 * 12 , , -2000)<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n c\u1ea7n gi\u1ea3i th\u00edch c\u1ee7a c\u00e1c tham s\u1ed1, h\u00e3y xem ph\u1ea7n b\u00ean d\u01b0\u1edbi:<\/p>\n<ul style=\"text-align: justify\">\n<li>rate \u2013 0.008 \/ 12 v\u00ec b\u1ea1n c\u00f3 l\u00e3i su\u1ea5t 8%\/n\u0103m, gh\u00e9p l\u00e3i h\u00e0ng th\u00e1ng.<\/li>\n<li>nper \u2013 5 * 12, t\u1ee9c l\u00e0 5 n\u0103m * 12 th\u00e1ng<\/li>\n<li>pmt \u0111\u01b0\u1ee3c \u0111\u1ec3 tr\u1ed1ng v\u00ec nhi\u1ec7m v\u1ee5 c\u1ee7a ch\u00fang t\u00f4i kh\u00f4ng li\u00ean quan \u0111\u1ebfn kho\u1ea3n thanh to\u00e1n b\u1ed5 sung cho kho\u1ea3n \u0111\u1ea7u t\u01b0 c\u01a1 b\u1ea3n 2.000 \u0111\u00f4 la.<\/li>\n<li>pv l\u00e0 -2000 v\u00ec c\u00fa ph\u00e1p c\u1ee7a h\u00e0m FV y\u00eau c\u1ea7u s\u1eed d\u1ee5ng m\u1ed9t s\u1ed1 \u00e2m trong \u0111\u1ed1i s\u1ed1 n\u00e0y.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi \u0111\u00e2y, th\u00ec c\u00f4ng th\u1ee9c FV tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1 nh\u01b0 m\u00e1y t\u00ednh t\u00ednh l\u00e3i k\u00e9p m\u00e0 ch\u00fang ta \u0111\u00e3 t\u1ea1o ra trong v\u00ed d\u1ee5 tr\u01b0\u1edbc.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/fv-formula-excel.png\" alt=\"Using the FV function to calculate compound interest in Excel\" title=\"fv-formula-excel\"><\/p>\n<p style=\"text-align: justify\">T\u1ea5t nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 thay th\u1ebf c\u00e1c gi\u00e1 tr\u1ecb trong h\u00e0m FV b\u1eb1ng c\u00e1c tham chi\u1ebfu theo \u00f4.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam: Gia\u0301o tri\u0300nh\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/excel-nang-cao\">Excel n\u00e2ng cao<\/a> m\u01a1\u0301i nh\u00e2\u0301t<\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, \u00a0h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y cho th\u1ea5y gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai c\u1ee7a kho\u1ea3n \u0111\u1ea7u t\u01b0 $ 4.000 sau 15 n\u0103m v\u1edbi m\u1ee9c l\u00e3i su\u1ea5t h\u00e0ng n\u0103m l\u00e0 7%, k\u1ebf ho\u1ea1ch gh\u00e9p l\u00e3i h\u00e0ng tu\u1ea7n:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-compound-interest-formula.png\" alt=\"Calculating the future value of the investment with weekly compounding\" title=\"excel-compound-interest-formula\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 l\u00e0m cho c\u00f4ng th\u1ee9c t\u00ednh l\u00e3i k\u00e9p c\u1ee7a b\u1ea1n m\u1ea1nh h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 m\u1edf r\u1ed9ng n\u00f3 b\u1eb1ng t\u00f9y ch\u1ecdn Additional contribution (thanh to\u00e1n b\u1ed5 sung) v\u00e0 s\u1eeda \u0111\u1ed5i c\u00f4ng th\u1ee9c t\u00ednh l\u00e3i k\u00e9p cho ph\u00f9 h\u1ee3p:<\/p>\n<p style=\"text-align: justify\">= FV (B4 \/ B5, B6 * B5, -B8, -B3, B9)<\/p>\n<p style=\"text-align: justify\">Trong \u0111\u00f3:<\/p>\n<ul style=\"text-align: justify\">\n<li>B3 \u2013 kho\u1ea3n \u0111\u1ea7u t\u01b0 c\u01a1 b\u1ea3n<\/li>\n<li>B4 \u2013 l\u00e3i su\u1ea5t h\u00e0ng n\u0103m<\/li>\n<li>B5 \u2013 s\u1ed1 l\u1ea7n gh\u00e9p l\u00e3i m\u1ed7i n\u0103m<\/li>\n<li>B6 \u2013 s\u1ed1 n\u0103m g\u1eedi ti\u1ebft ki\u1ec7m<\/li>\n<li>B8 \u2013 kho\u1ea3n \u0111\u00f3ng g\u00f3p b\u1ed5 sung (t\u00f9y ch\u1ecdn)<\/li>\n<li>B9 \u2013 lo\u1ea1i \u0111\u00f3ng g\u00f3p b\u1ed5 sung. H\u00e3y nh\u1edb r\u1eb1ng b\u1ea1n nh\u1eadp 1 n\u1ebfu b\u1ea1n g\u1eedi m\u1ed9t kho\u1ea3n ti\u1ec1n b\u1ed5 sung v\u00e0o \u0111\u1ea7u k\u1ef3 t\u00ednh l\u00e3i, v\u00e0 0 ho\u1eb7c b\u1ecf qua n\u1ebfu vi\u1ec7c b\u1ed5 sung \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n v\u00e0o cu\u1ed1i k\u1ef3.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/advanced-compound-interest-calculator-excel.png\" alt=\"An advanced compound interest calculator for Excel\" title=\"advanced-compound-interest-calculator-excel\"><\/p>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2w6YAe8\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: Hoc Excel.Online<\/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\/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-52.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1769,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1768","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\/1768","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=1768"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1768\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1769"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1768"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1768"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1768"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}