{"id":11927,"date":"2025-01-15T06:13:37","date_gmt":"2025-01-15T06:13:37","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-tinh-ty-le-tang-truong-luy-ke-hang-nam-cagr-compound-annual-growth-rate-bang-excel-va-cong-thuc-vi-du\/"},"modified":"2025-01-15T06:13:37","modified_gmt":"2025-01-15T06:13:37","slug":"cach-tinh-ty-le-tang-truong-luy-ke-hang-nam-cagr-compound-annual-growth-rate-bang-excel-va-cong-thuc-vi-du","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-tinh-ty-le-tang-truong-luy-ke-hang-nam-cagr-compound-annual-growth-rate-bang-excel-va-cong-thuc-vi-du\/","title":{"rendered":"C\u00e1ch t\u00ednh t\u1ef7 l\u1ec7 t\u0103ng tr\u01b0\u1edfng lu\u1ef9 k\u1ebf h\u00e0ng n\u0103m, CAGR (compound annual growth rate) b\u1eb1ng Excel v\u00e0 c\u00f4ng th\u1ee9c v\u00ed d\u1ee5"},"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, <a href=\"http:\/\/blog.ezworkapp.com\">blog.hocexcel.online<\/a> s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u \u0111\u01b0\u1ee3c t\u1ec9 l\u1ec7 t\u0103ng tr\u01b0\u1edfng lu\u1ef9 k\u1ebf h\u00e0ng n\u0103m (CAGR) l\u00e0 g\u00ec v\u00e0 c\u00e1ch x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c CAGR r\u00f5 r\u00e0ng, d\u1ec5 hi\u1ec3u trong Excel<\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">N\u00f3i m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n, CAGR \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 \u0111o t\u1ec9 l\u1ec7 ho\u00e0n v\u1ed1n khi b\u1ea1n th\u1ef1c hi\u1ec7n m\u1ed9t \u0111\u1ea7u t\u01b0 n\u00e0o \u0111\u00f3 trong m\u1ed9t kho\u1ea3ng th\u1eddi gian nh\u1ea5t \u0111\u1ecbnh. C\u1ee5 th\u1ec3 h\u01a1n, \u0111\u00e2y kh\u00f4ng ph\u1ea3i m\u1ed9t thu\u1eadt ng\u1eef k\u1ebf to\u00e1n nh\u01b0ng l\u1ea1i \u0111\u01b0\u1ee3c th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng b\u1edfi c\u00e1c nh\u00e0 ph\u00e2n t\u00edch t\u00e0i ch\u00ednh, c\u00e1c nh\u00e0 qu\u1ea3n l\u00fd \u0111\u1ea7u t\u01b0 hay ch\u1ee7 doanh nghi\u1ec7p gi\u00fap h\u1ecd bi\u1ebft \u0111\u01b0\u1ee3c c\u00f4ng vi\u1ec7c kinh doanh c\u00f3 ph\u00e1t tri\u1ec3n hay kh\u00f4ng ho\u1eb7c \u0111\u1ec3 so s\u00e1nh v\u1edbi s\u1ee9c t\u0103ng tr\u01b0\u1edfng doanh thu c\u1ee7a c\u00f4ng ty \u0111\u1ed1i th\u1ee7. \u00a0<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">V\u1edbi b\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y, HEO\u00a0s\u1ebd kh\u00f4ng \u0111\u00e0o s\u00e2u v\u00e0o v\u1ea5n \u0111\u1ec1 li\u00ean quan \u0111\u1ebfn s\u1ed1 h\u1ecdc m\u00e0 t\u1eadp trung v\u00e0o c\u00e1ch x\u00e2y d\u1ef1ng m\u1ed9t c\u00f4ng th\u1ee9c CAGR trong Excel m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 d\u1ef1a tr\u00ean 3 gi\u00e1 tr\u1ecb: gi\u00e1 tr\u1ecb \u0111\u1ea7u t\u01b0 l\u00fac \u0111\u1ea7u, gi\u00e1 tr\u1ecb k\u1ebft th\u00fac v\u00e0 th\u1eddi gian. <\/span><\/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-6787520e4aca7\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-ti-le-tang-truong-luy-ke-hang-nam-cagr-compound-annual-growth-rate-bang-excel-va-cong-thuc-vi-du.html#TI_LE_TANG_TRUONG_LUY_KE_HANG_NAM_LA_GI\" title=\"T\u1ec8 L\u1ec6 T\u0102NG TR\u01af\u1edeNG LU\u1ef8 K\u1ebe H\u00c0NG N\u0102M L\u00c0 G\u00cc?\">T\u1ec8 L\u1ec6 T\u0102NG TR\u01af\u1edeNG LU\u1ef8 K\u1ebe H\u00c0NG N\u0102M L\u00c0 G\u00cc?<\/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\/cach-tinh-ti-le-tang-truong-luy-ke-hang-nam-cagr-compound-annual-growth-rate-bang-excel-va-cong-thuc-vi-du.html#CONG_THUC_CAGR\" title=\"C\u00d4NG TH\u1ee8C CAGR:\">C\u00d4NG TH\u1ee8C CAGR:<\/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\/cach-tinh-ti-le-tang-truong-luy-ke-hang-nam-cagr-compound-annual-growth-rate-bang-excel-va-cong-thuc-vi-du.html#CACH_TINH_CAGR_TRONG_EXCEL\" title=\"C\u00c1CH T\u00cdNH CAGR TRONG EXCEL:\">C\u00c1CH T\u00cdNH CAGR TRONG EXCEL:<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"TI_LE_TANG_TRUONG_LUY_KE_HANG_NAM_LA_GI\"><\/span><span style=\"font-weight: 400\">T\u1ec8 L\u1ec6 T\u0102NG TR\u01af\u1edeNG LU\u1ef8 K\u1ebe H\u00c0NG N\u0102M L\u00c0 G\u00cc?<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">T\u1ec9 l\u1ec7 t\u0103ng tr\u01b0\u1edfng lu\u1ef9 k\u1ebf h\u00e0ng n\u0103m (CAGR) l\u00e0 m\u1ed9t thu\u1eadt ng\u1eef t\u00e0i ch\u00ednh d\u00f9ng \u0111\u1ec3 \u0111o l\u01b0\u1eddng t\u1ec9 l\u1ec7 t\u0103ng tr\u01b0\u1edfng trung b\u00ecnh h\u00e0ng n\u0103m c\u1ee7a m\u1ed9t \u0111\u1ea7u t\u01b0 trong m\u1ed9t kho\u1ea3ng th\u1eddi gian.<\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">\u0110\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n logic c\u1ee7a CAGR, ch\u00fang ta h\u00e3y c\u00f9ng xem v\u00ed d\u1ee5 sau \u0111\u00e2y. Gi\u1ea3 s\u1eed nh\u1eefng s\u1ed1 li\u1ec7u d\u01b0\u1edbi \u0111\u00e2y n\u1eb1m trong b\u00e1o c\u00e1o t\u00e0i ch\u00ednh c\u1ee7a c\u00f4ng ty b\u1ea1n<\/span><\/p>\n<table style=\"height: 206px;width: 227px\">\n<tbody>\n<tr style=\"height: 24px\">\n<td style=\"width: 70px;height: 24px\">N\u0103m<\/td>\n<td style=\"width: 147px;height: 24px\">Doanh thu (Tri\u1ec7u)<\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 70px;height: 24px\">2010<\/td>\n<td style=\"width: 147px;height: 24px;text-align: right\">10<\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 70px;height: 24px\">2011<\/td>\n<td style=\"width: 147px;height: 24px;text-align: right\">12<\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 70px;height: 24px\">2012<\/td>\n<td style=\"width: 147px;height: 24px;text-align: right\">11<\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 70px;height: 24px\">2013<\/td>\n<td style=\"width: 147px;height: 24px;text-align: right\">15<\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 70px;height: 24px\">2014<\/td>\n<td style=\"width: 147px;height: 24px;text-align: right\">17<\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 70px;height: 24px\">2015<\/td>\n<td style=\"width: 147px;height: 24px;text-align: right\">22<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">B\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y th\u1ec3 hi\u1ec7n c\u00e1ch t\u00ednh t\u1ec9 l\u1ec7 t\u0103ng tr\u01b0\u1edfng sau m\u1ed7i n\u0103m s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c t\u00ednh t\u1ec9 l\u1ec7 t\u0103ng ph\u1ea7n tr\u0103m.<\/span><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5234\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2017-05-09-at-23-04-22.png\" width=\"580\" height=\"466\" title=\"screen-shot-2017-05-09-at-23-04-22\"><\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-336.gif\" title=\"ex101_92019-nho-336\"><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\/2025\/01\/vba101_92019-nho-67.gif\" title=\"vba101_92019-nho-67\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-336.gif\" title=\"ex101_92019-nho-336\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Nh\u01b0ng l\u00e0m c\u00e1ch n\u00e0o \u0111\u1ec3 t\u00ednh t\u1ec9 l\u1ec7 t\u0103ng tr\u01b0\u1edfng trong v\u00f2ng 5 n\u0103m? C\u00f3 hai c\u00e1ch \u0111\u00f3 l\u00e0 t\u00ednh t\u1ec9 l\u1ec7 t\u0103ng tr\u01b0\u1edfng lu\u1ef9 k\u1ebf ho\u1eb7c trung b\u00ecnh. S\u1eed d\u1ee5ng t\u1ec9 l\u1ec7 t\u0103ng tr\u01b0\u1edfng lu\u1ef9 k\u1ebf c\u00f3 l\u1ee3i h\u01a1n b\u1edfi hai l\u00fd do sau:<\/span><\/p>\n<ul style=\"text-align: justify\">\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">T\u1ec9 l\u1ec7 t\u0103ng tr\u01b0\u1edfng trung b\u00ecnh h\u00e0ng n\u0103m (AAGR) l\u00e0 gi\u00e1 tr\u1ecb trung b\u00ecnh s\u1ed1 h\u1ecdc c\u1ee7a m\u1ed9t chu\u1ed7i c\u00e1c t\u1ec9 l\u1ec7 t\u0103ng tr\u01b0\u1edfng v\u00e0 d\u1ec5 d\u00e0ng t\u00ednh \u0111\u01b0\u1ee3c b\u1eb1ng c\u00f4ng th\u1ee9c trung b\u00ecnh AVERAGE trong Excel. Tuy nhi\u00ean, n\u00f3 kh\u00f4ng h\u1ec1 t\u00ednh \u0111\u1ebfn hi\u1ec7u \u1ee9ng lu\u1ef9 k\u00e9p d\u1eabn \u0111\u1ebfn s\u1ef1 t\u0103ng tr\u01b0\u1edfng c\u1ee7a m\u1ed9t \u0111\u1ea7u t\u01b0 c\u00f3 th\u1ec3 b\u1ecb \u0111\u00e1nh gi\u00e1 cao h\u01a1n so v\u1edbi th\u1ef1c t\u1ebf.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">T\u1ec9 l\u1ec7 t\u0103ng tr\u01b0\u1edfng lu\u1ef9 k\u1ebf h\u00e0ng n\u0103m (CAGR) l\u00e0 tr\u00e1 tr\u1ecb trung b\u00ecnh h\u00ecnh h\u1ecdc th\u1ec3 hi\u1ec7n t\u1ec9 l\u1ec7 ho\u00e0n v\u1ed1n c\u1ee7a m\u1ed9t \u0111\u1ea7u t\u01b0 \u0111\u01b0\u1ee3c lu\u1ef9 k\u1ebf v\u1edbi t\u1ec9 l\u1ec7 \u1ed5n \u0111\u1ecbnh m\u1ed7i n\u0103m.<\/span><\/li>\n<\/ul>\n<blockquote>\n<p>Xem th\u00eam:\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/dv101-truc-quan-hoa-du-lieu-voi-bieu-do-trong-excel-dashboard-va-data-visualization\" target=\"_blank\" rel=\"noopener noreferrer\">Hi\u1ec3u v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u, ra quy\u1ebft \u0111\u1ecbnh v\u1edbi bi\u1ec3u \u0111\u1ed3 Excel d\u00e0nh cho CFO v\u00e0 CEO<\/a><\/p>\n<\/blockquote>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CONG_THUC_CAGR\"><\/span><span style=\"font-weight: 400\">C\u00d4NG TH\u1ee8C CAGR:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c t\u00ednh CAGR \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong kinh doanh, ph\u00e2n t\u00edch t\u00e0i ch\u00ednh v\u00e0 \u0111\u1ea7u t\u01b0 nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5235\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2017-05-11-at-02-31-44.png\" width=\"600\" height=\"235\" title=\"screen-shot-2017-05-11-at-02-31-44\"><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">V\u1edbi<\/span><\/p>\n<ul style=\"text-align: justify\">\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">BV: gi\u00e1 tr\u1ecb ban \u0111\u1ea7u c\u1ee7a \u0111\u1ea7u t\u01b0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">EV: gi\u00e1 tr\u1ecb k\u1ebft th\u00fac c\u1ee7a \u0111\u1ea7u t\u01b0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">N: s\u1ed1 chu k\u00ec (v\u00ed d\u1ee5 s\u1ed1 n\u0103m, s\u1ed1 qu\u00fd ho\u1eb7c th\u00e1ng, ng\u00e0y\u2026)<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y, c\u00f4ng th\u1ee9c Average v\u00e0 CAGR tr\u1ea3 l\u1ea1i hai k\u1ebft qu\u1ea3 kh\u00e1c nhau <\/span><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5236\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2017-05-09-at-23-07-18.png\" width=\"600\" height=\"313\" title=\"screen-shot-2017-05-09-at-23-07-18\"><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">\u0110\u1ec3 gi\u00fap d\u1ec5 hi\u1ec3u h\u01a1n, h\u00ecnh \u1ea3nh d\u01b0\u1edbi \u0111\u1eady th\u1ec3 hi\u1ec7n c\u00e1ch CAGR \u0111\u01b0\u1ee3c t\u00ednh trong t\u1eebng th\u1eddi k\u00ec kh\u00e1c nhau <\/span><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5237\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2017-05-10-at-00-24-54-1024x258-1.png\" width=\"600\" height=\"151\" title=\"screen-shot-2017-05-10-at-00-24-54-1024x258-1\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CACH_TINH_CAGR_TRONG_EXCEL\"><\/span><span style=\"font-weight: 400\">C\u00c1CH T\u00cdNH CAGR TRONG EXCEL:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Sau khi hi\u1ec3u \u0111\u01b0\u1ee3c \u00fd t\u01b0\u1edfng c\u01a1 b\u1ea3n c\u1ee7a kh\u00e1i ni\u1ec7m t\u1ec9 l\u1ec7 t\u0103ng tr\u01b0\u1edfng lu\u1ef9 k\u1ebf h\u00e0ng n\u0103m, ch\u00fang ta h\u00e3y c\u00f9ng xem c\u00e1ch t\u00ednh t\u1ec9 l\u1ec7 n\u00e0y trong trang t\u00ednh Excel nh\u01b0 th\u1ebf n\u00e0o. C\u00f3 t\u1ea5t c\u1ea3 4 c\u00e1ch \u0111\u1ec3 x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c t\u00ednh CAGR<\/span><\/p>\n<ul style=\"text-align: justify\">\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c CAGR<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">S\u1eed d\u1ee5ng h\u00e0m POWER<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">S\u1eed d\u1ee5ng h\u00e0m RATE<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">S\u1eed d\u1ee5ng h\u00e0m IRR<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>C\u00d4NG TH\u1ee8C 1: C\u00e1ch t\u1ea1o tr\u1ef1c ti\u1ebfp c\u00f4ng th\u1ee9c t\u00ednh CAGR <\/strong><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">T\u1eeb c\u00f4ng th\u1ee9c CAGR \u1edf tr\u00ean, ch\u00fang ta ch\u1ec9 c\u1ea7n v\u00e0i ph\u00fat l\u00e0 t\u1ea1o \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c t\u00ednh CAGR trong Excel . Ch\u1ec9 c\u1ea7n ch\u1ec9 r\u00f5 c\u00e1c gi\u00e1 tr\u1ecb sau trong trang t\u00ednh:<\/span><\/p>\n<ul style=\"text-align: justify\">\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">BV: gi\u00e1 tr\u1ecb ban \u0111\u1ea7u c\u1ee7a \u0111\u1ea7u t\u01b0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">EV: gi\u00e1 tr\u1ecb k\u1ebft th\u00fac c\u1ee7a \u0111\u1ea7u t\u01b0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">n: s\u1ed1 chu k\u00ec (v\u00ed d\u1ee5 s\u1ed1 n\u0103m, s\u1ed1 qu\u00fd ho\u1eb7c th\u00e1ng, ng\u00e0y\u2026)<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Sau \u0111\u00f3 vi\u1ebft c\u00f4ng th\u1ee9c CAGR v\u00e0o \u00f4 tr\u1ed1ng nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify\"><b>=(EV\/BV)^(1\/n)-1<\/b><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Trong v\u00ed d\u1ee5 n\u00e0y, BV \u1edf \u00f4 B1, EV \u1edf \u00f4 B2, v\u00e0 n \u00f4 B3. Do \u0111\u00f3, ch\u00fang ta nh\u1eadp c\u00f4ng th\u1ee9c sau v\u00e0o \u00f4 B5<\/span><\/p>\n<p style=\"text-align: justify\"><b>=(B2\/B1)^(1\/B3)-1<\/b><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5238\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2017-05-11-at-03-15-55.png\" width=\"600\" height=\"280\" title=\"screen-shot-2017-05-11-at-03-15-55\"><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n c\u00f3 t\u1ea5t c\u1ea3 c\u00e1c kho\u1ea3n \u0111\u1ea7u t\u01b0 \u0111\u01b0\u1ee3c li\u1ec7t k\u00ea trong m\u1ed9t c\u1ed9t, b\u1ea1n c\u00f3 th\u1ec3 linh ho\u1ea1t c\u00f4ng th\u1ee9c CAGR \u0111\u1ec3 t\u00ednh s\u1ed1 chu k\u00ec m\u1ed9t c\u00e1ch t\u1ef1 \u0111\u1ed9ng<\/span><\/p>\n<p style=\"text-align: justify\"><b>=(EV\/BV)^(1\/(ROW(EV)-ROW(BV)))-1<\/b><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5239\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2017-05-10-at-21-32-55.png\" width=\"600\" height=\"255\" title=\"screen-shot-2017-05-10-at-21-32-55\"><\/p>\n<p style=\"text-align: justify\"><em><b>Tip: <\/b><span style=\"font-weight: 400\">N\u1ebfu k\u1ebft qu\u1ea3 l\u00e0 s\u1ed1 th\u1eadp ph\u00e2n, s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng Percentage (ph\u1ea7n tr\u0103m) \u00a0cho \u00f4 c\u00f4ng th\u1ee9c.<\/span><\/em><\/p>\n<blockquote>\n<p style=\"text-align: justify\"><em><a href=\"https:\/\/hocexcel.online\/course\/preview\/dv101-truc-quan-hoa-du-lieu-voi-bieu-do-trong-excel-dashboard-va-data-visualization\" target=\"_blank\" rel=\"noopener noreferrer\">HI\u1ec2U V\u00c0 PH\u00c2N T\u00cdCH D\u1eee LI\u1ec6U, RA QUY\u1ebeT \u0110\u1ecaNH V\u1edaI BI\u1ec2U \u0110\u1ed2 EXCEL<\/a><\/em><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">C\u00d4NG TH\u1ee8C 2: <a href=\"http:\/\/blog.ezworkapp.com\/ham-power-ham-tinh-luy-thua-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">H\u00e0m POWER<\/a><\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">M\u1ed9t c\u00e1ch kh\u00e1c gi\u00fap c\u00e1c b\u1ea1n t\u00ednh CAGR nhanh ch\u00f3ng l\u00e0 s\u1eed d\u1ee5ng h\u00e0m POWER cho k\u1ebft qu\u1ea3 l\u00e0 m\u1ed9t s\u1ed1 \u0111\u01b0\u1ee3c n\u00e2ng l\u00ean theo lu\u1ef9 th\u1eeba.<\/span><\/p>\n<p style=\"text-align: justify\"><strong>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m POWER nh\u01b0 sau:<\/strong><\/p>\n<p style=\"text-align: justify\"><b>POWER (number, power)<\/b><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">V\u1edbi <\/span><b>number <\/b><span style=\"font-weight: 400\">l\u00e0 c\u01a1 s\u1ed1 v\u00e0 <\/span><b>power <\/b><span style=\"font-weight: 400\">l\u00e0 s\u1ed1 m\u0169.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">\u0110\u1ec3 t\u1ea1o c\u00f4ng th\u1ee9c t\u00ednh CAGR d\u1ef1a tr\u00ean h\u00e0m POWER, x\u00e1c \u0111\u1ecbnh tham s\u1ed1 nh\u01b0 sau:<\/span><\/p>\n<ul style=\"text-align: justify\">\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Number: gi\u00e1 tr\u1ecb k\u1ebft th\u00fac (EV)\/gi\u00e1 tr\u1ecb b\u1eaft \u0111\u1ea7u (BV)<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Power : 1\/s\u1ed1 chu k\u00ec (n)<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><b>=POWER (EV\/BV, 1\/n)-1<\/b><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 v\u00ed d\u1ee5 c\u00e1ch t\u00ednh CAGR d\u1ef1a tr\u00ean h\u00e0m POWER<\/span><\/p>\n<p style=\"text-align: justify\"><b>=POWER (B7\/B2, 1\/5)-1<\/b><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5240\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2017-05-11-at-03-22-19.png\" width=\"600\" height=\"276\" title=\"screen-shot-2017-05-11-at-03-22-19\"><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Nh\u01b0 trong v\u00ed d\u1ee5 tr\u01b0\u1edbc, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m ROW \u0111\u1ec3 t\u00ednh s\u1ed1 chu k\u00ec <\/span><\/p>\n<p style=\"text-align: justify\"><b>=POWER (B7\/B2, 1\/(ROW (B7)-ROW (B2)))-1<\/b><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">C\u00d4NG TH\u1ee8C 3: <a href=\"http:\/\/blog.ezworkapp.com\/ham-rate-ham-tinh-lai-suat-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">H\u00e0m RATE<\/a><\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">M\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 t\u00ednh CAGR l\u00e0 s\u1eed d\u1ee5ng h\u00e0m RATE cho k\u1ebft qu\u1ea3 l\u00e0 t\u1ec9 l\u1ec7 l\u00e3i su\u1ea5t m\u1ed7i chu k\u00ec c\u1ee7a m\u1ed9t ni\u00ean kim <\/span><\/p>\n<p style=\"text-align: justify\"><b>RATE(nper, pmt, pv, [fv], [type], [guess])<\/b><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">T\u1eeb c\u00e1i nh\u00ecn \u0111\u1ea7u ti\u00ean, c\u00fa ph\u00e1p n\u00e0y tr\u00f4ng c\u00f3 v\u1ebb ph\u1ee9c t\u1ea1p nh\u01b0ng m\u1ed9t khi b\u1ea1n \u0111\u00e3 hi\u1ec3u c\u00e1c tham s\u1ed1 c\u1ee7a n\u00f3, b\u1ea1n c\u00f3 th\u1ec3 s\u1ebd th\u00edch c\u00e1ch n\u00e0y \u0111\u1ec3 t\u00ednh CAGR h\u01a1n<\/span><\/p>\n<ul style=\"text-align: justify\">\n<li><b>Nper (b\u1eaft bu\u1ed9c) : <span style=\"font-weight: 400\">t\u1ed5ng s\u1ed1 l\u1ea7n tr\u1ea3 cho m\u1ed9t ni\u00ean kim. V\u00ed d\u1ee5 s\u1ed1 chu k\u00ec c\u1ee7a m\u1ed9t kho\u1ea3n vay ho\u1eb7c \u0111\u1ea7u t\u01b0 c\u1ea7n ph\u1ea3i tr\u1ea3<\/span><\/b><\/li>\n<\/ul>\n<ul style=\"text-align: justify\">\n<li>Pmt: <span style=\"font-weight: 400\">kho\u1ea3n ti\u1ec1n ph\u1ea3i tr\u1ea3 m\u1ed7i k\u00ec. N\u1ebfu b\u1ecf tr\u1ed1ng, tham s\u1ed1 fv ph\u1ea3i \u0111\u01b0\u1ee3c cung c\u1ea5p<\/span><\/li>\n<\/ul>\n<ul style=\"text-align: justify\">\n<li>Pv (b\u1eaft bu\u1ed9c): <span style=\"font-weight: 400\">gi\u00e1 tr\u1ecb hi\u1ec7n t\u1ea1i c\u1ee7a kho\u1ea3n \u0111\u1ea7u t\u01b0<\/span><\/li>\n<\/ul>\n<ul style=\"text-align: justify\">\n<li>Fv: <span style=\"font-weight: 400\">gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai c\u1ee7a kho\u1ea3n \u0111\u1ea7u t\u01b0 sau khi th\u1ef1c hi\u1ec7n l\u1ea7n thanh to\u00e1n cu\u1ed1i c\u00f9ng. N\u1ebfu b\u1ecb b\u1ecf tr\u1ed1ng, c\u00f4ng th\u1ee9c s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111\u1eb7t gi\u00e1 tr\u1ecb m\u1eb7c \u0111\u1ecbnh 0<\/span><\/li>\n<\/ul>\n<ul style=\"text-align: justify\">\n<li>Type: <span style=\"font-weight: 400\">gi\u00e1 tr\u1ecb tu\u1ef3 ch\u1ecdn x\u00e1c \u0111\u1ecbnh th\u1eddi \u0111i\u1ec3m c\u00e1c kho\u1ea3n thanh to\u00e1n \u0111\u1ebfn h\u1ea1n<\/span><\/li>\n<\/ul>\n<ul style=\"text-align: justify\">\n<li><span style=\"font-weight: 400\">0 (m\u1eb7c \u0111\u1ecbnh): c\u00e1c kho\u1ea3n thanh to\u00e1n \u0111\u1ebfn k\u00ec h\u1ea1n cu\u1ed1i m\u1ed7i chu k\u00ec<\/span><\/li>\n<\/ul>\n<ul style=\"text-align: justify\">\n<li><span style=\"font-weight: 400\">1: c\u00e1c kho\u1ea3n thanh to\u00e1n \u0111\u1ebfn k\u00ec h\u1ea1n \u0111\u1ea7u m\u1ed7i chu k\u00ec \u00a0<\/span><\/li>\n<\/ul>\n<ul style=\"text-align: justify\">\n<li>Guess: <span style=\"font-weight: 400\">d\u1ef1 \u0111o\u00e1n c\u1ee7a b\u1ea1n v\u1ec1 t\u1ec9 l\u1ec7. N\u1ebfu b\u1ecf qua, c\u00f4ng th\u1ee9c gi\u1ea3 \u0111\u1ecbnh l\u00e0 10%<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">\u0110\u1ec3 bi\u1ebfn h\u00e0m RATE th\u00e0nh c\u00f4ng th\u1ee9c t\u00ednh CAGR, b\u1ea1n c\u1ea7n x\u00e1c \u0111\u1ecbnh tham s\u1ed1 \u0111\u1ea7u (nper), th\u1ee9 3 (pv) v\u00e0 th\u1ee9 4 (fv) nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify\"><b>=RATE (n,, -BV, EV)<\/b><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">V\u1edbi <\/span><\/p>\n<ul style=\"text-align: justify\">\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">BV l\u00e0 gi\u00e1 tr\u1ecb \u0111\u1ea7u c\u1ee7a \u0111\u1ea7u t\u01b0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">EV l\u00e0 gi\u00e1 tr\u1ecb cu\u1ed1i c\u1ee7a \u0111\u1ea7u t\u01b0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">n l\u00e0 s\u1ed1 chu k\u00ec<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><b>L\u01b0u \u00fd: <\/b><span style=\"font-weight: 400\">B\u1ea1n c\u1ea7n x\u00e1c \u0111\u1ecbnh r\u00f5 gi\u00e1 tr\u1ecb ban \u0111\u1ea7u (BV) l\u00e0 s\u1ed1 \u00e2m, n\u1ebfu kh\u00f4ng h\u00e0m CAGR s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #NUM!<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">\u0110\u1ec3 t\u00ednh t\u1ec9 l\u1ec7 t\u0103ng tr\u01b0\u1edfng lu\u1ef9 k\u1ebf trong v\u00ed d\u1ee5 n\u00e0y, c\u00f4ng th\u1ee9c s\u1ebd nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify\"><b>=RATE (5,,-B2, B7)<\/b><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">\u0110\u1ec3 tr\u00e1nh kh\u1ecfi r\u1eafc r\u1ed1i khi t\u00ednh s\u1ed1 chu k\u00ec b\u1eb1ng tay, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m ROW:<\/span><\/p>\n<p style=\"text-align: justify\"><b>=RATE (ROW (B7)-ROW (B2),,-B2, B7)<\/b><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5241\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2017-05-11-at-01-38-00.png\" width=\"600\" height=\"270\" title=\"screen-shot-2017-05-11-at-01-38-00\"><\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0H\u1ecdc Excel k\u1ebf to\u00e1n<\/p>\n<\/blockquote>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">C\u00d4NG TH\u1ee8C 4: H\u00e0m IRR<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">H\u00e0m IRR trong Excel cho k\u1ebft qu\u1ea3 l\u00e0 t\u1ec9 su\u1ea5t ho\u00e0n v\u1ed1n n\u1ed9i b\u1ed9 cho m\u1ed9t chu\u1ed7i c\u00e1c d\u00f2ng ti\u1ec1n x\u1ea3y ra t\u1ea1i c\u00e1c kho\u1ea3ng th\u1eddi gian \u0111\u1ec1u \u0111\u1eb7n (v\u00ed d\u1ee5 ng\u00e0y, th\u00e1ng, qu\u00fd, n\u0103m, v.v). C\u00fa ph\u00e1p nh\u01b0 sau<\/span><\/p>\n<p style=\"text-align: justify\"><b>IRR(values, [quess])<\/b><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">V\u1edbi<\/span><\/p>\n<ul style=\"text-align: justify\">\n<li><b>Values: <span style=\"font-weight: 400\">m\u1ed9t d\u00e3y c\u00e1c s\u1ed1 th\u1ec3 hi\u1ec7n cho d\u00f2ng ti\u1ec1n. D\u00e3y n\u00e0y ph\u1ea3i ch\u1ee9a \u00edt nh\u1ea5t m\u1ed9t gi\u00e1 tr\u1ecb \u00e2m v\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb d\u01b0\u01a1ng.<\/span><\/b><\/li>\n<\/ul>\n<ul style=\"text-align: justify\">\n<li>[Guess]: <span style=\"font-weight: 400\">tham s\u1ed1 tu\u1ef3 ch\u1ecdn th\u1ec3 hi\u1ec7n d\u1ef1 \u0111o\u00e1n c\u1ee7a b\u1ea1n v\u1ec1 t\u1ec9 su\u1ea5t ho\u00e0n v\u1ed1n. N\u1ebfu b\u1ecf tr\u1ed1ng, g\u00e1i tr\u1ecb m\u1eb7c \u0111\u1ecbnh s\u1ebd l\u00e0 10%<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Do h\u00e0m IRR kh\u00f4ng \u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng \u0111\u1ec3 t\u00ednh t\u1ec9 l\u1ec7 t\u0103ng tr\u01b0\u1edfng lu\u1ef9 k\u1ebf, b\u1ea1n s\u1ebd ph\u1ea3i bi\u1ebfn \u0111\u1ed5i d\u1eef li\u1ec7u nh\u01b0 sau:<\/span><\/p>\n<ul style=\"text-align: justify\">\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Gi\u00e1 tr\u1ecb ban \u0111\u1ea7u c\u1ee7a \u0111\u1ea7u t\u01b0 l\u00e0 s\u1ed1 \u00e2m<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Gi\u00e1 tr\u1ecb cu\u1ed1i c\u1ee7a \u0111\u1ea7u t\u01b0 l\u00e0 m\u1ed9t s\u1ed1 d\u01b0\u01a1ng<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">T\u1ea5t c\u1ea3 gi\u00e1 tr\u1ecb n\u1eb1m gi\u1eefa l\u00e0 s\u1ed1 0<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5242\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2017-05-11-at-02-12-37.png\" width=\"600\" height=\"205\" title=\"screen-shot-2017-05-11-at-02-12-37\"><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Sau khi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp l\u1ea1i, b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh CAGR v\u1edbi c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n sau:<\/span><\/p>\n<p style=\"text-align: justify\"><b>=IRR (B2:B7)<\/b><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">V\u1edbi B2 l\u00e0 gi\u00e1 tr\u1ecb ban \u0111\u1ea7u v\u00e0 B7 l\u00e0 gi\u00e1 tr\u1ecb cu\u1ed1i c\u1ee7a kho\u1ea3n \u0111\u1ea7u t\u01b0<\/span><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5243\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2017-05-11-at-02-15-54.png\" width=\"600\" height=\"295\" title=\"screen-shot-2017-05-11-at-02-15-54\"><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Nh\u01b0 v\u1eady, b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch t\u00ednh CAGR trong Excel. N\u1ebfu b\u1ea1n theo d\u00f5i c\u00e1c v\u00ed d\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadn th\u1ea5y r\u1eb1ng c\u1ea3 4 c\u00f4ng th\u1ee9c \u0111\u1ec1u tr\u1ea3 v\u1ec1 c\u00f9ng m\u1ed9t k\u1ebft qu\u1ea3 l\u00e0 17.61%.<\/span><\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n<p>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 <a href=\"https:\/\/hocexcel.online\/course\/preview\/dv101-truc-quan-hoa-du-lieu-voi-bieu-do-trong-excel-dashboard-va-data-visualization\">tr\u1ecdn b\u1ed9 ph\u00e2n t\u00edch d\u1eef li\u1ec7u trong Excel b\u1eb1ng bi\u1ec3u \u0111\u1ed3.<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-336.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11928,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11927","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\/11927","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=11927"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11927\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11928"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11927"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11927"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11927"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}