{"id":1135,"date":"2024-12-02T04:16:52","date_gmt":"2024-12-02T04:16:52","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/lam-the-nao-de-tinh-toc-do-tang-truong-binh-quan-tang-truong-hang-nam-trong-excel\/"},"modified":"2024-12-02T04:16:52","modified_gmt":"2024-12-02T04:16:52","slug":"lam-the-nao-de-tinh-toc-do-tang-truong-binh-quan-tang-truong-hang-nam-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/lam-the-nao-de-tinh-toc-do-tang-truong-binh-quan-tang-truong-hang-nam-trong-excel\/","title":{"rendered":"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh t\u1ed1c \u0111\u1ed9 t\u0103ng tr\u01b0\u1edfng b\u00ecnh qu\u00e2n, t\u0103ng tr\u01b0\u1edfng h\u00e0ng n\u0103m trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id=\"t\u00ednh-t\u1ed1c-\u0111\u1ed9-t\u0103ng-tr\u01b0\u1edfng\" cite=\"https:\/\/blog.hocexcel.online\/lam-nao-de-tinh-toc-tang-truong-binh-quan-tang-truong-hang-nam-trong-excel-chua.html?tinh-toc-do-tang-truong\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong> <\/a>s\u1ebd n\u00f3i v\u1ec1 c\u00e1c c\u00e1ch<strong> t\u00ednh t\u1ed1c \u0111\u1ed9 t\u0103ng tr\u01b0\u1edfng<\/strong> trung b\u00ecnh h\u00e0ng n\u0103m (AAGR) v\u00e0 t\u1ef7 l\u1ec7 t\u0103ng tr\u01b0\u1edfng h\u00e0ng n\u0103m (CAGR) trong Excel.<\/p>\n<\/blockquote>\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-674d34b41b43a\" 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-nao-de-tinh-toc-tang-truong-binh-quan-tang-truong-hang-nam-trong-excel-chua.html#Tinh_ty_le_tang_truong_hang_nam_trong_Excel\" title=\"T\u00ednh t\u1ef7 l\u1ec7 t\u0103ng tr\u01b0\u1edfng h\u00e0ng n\u0103m trong Excel\">T\u00ednh t\u1ef7 l\u1ec7 t\u0103ng tr\u01b0\u1edfng h\u00e0ng n\u0103m 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-2\" href=\"https:\/\/blog.hocexcel.online\/lam-nao-de-tinh-toc-tang-truong-binh-quan-tang-truong-hang-nam-trong-excel-chua.html#Tinh_ti_le_tang_truong_hang_nam_voi_ham_XIRR_trong_Excel\" title=\"T\u00ednh t\u1ec9 l\u1ec7 t\u0103ng tr\u01b0\u1edfng h\u00e0ng n\u0103m v\u1edbi h\u00e0m XIRR trong Excel\">T\u00ednh t\u1ec9 l\u1ec7 t\u0103ng tr\u01b0\u1edfng h\u00e0ng n\u0103m v\u1edbi h\u00e0m XIRR 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=\"Tinh_ty_le_tang_truong_hang_nam_trong_Excel\"><\/span>T\u00ednh t\u1ef7 l\u1ec7 t\u0103ng tr\u01b0\u1edfng h\u00e0ng n\u0103m trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u00ednh to\u00e1n t\u1ef7 l\u1ec7 t\u0103ng tr\u01b0\u1edfng h\u00e0ng n\u0103m trong Excel, c\u00f3 m\u1ed9t c\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n nh\u01b0 sau: = ((Gi\u00e1 tr\u1ecb Cu\u1ed1i \/ Gi\u00e1 tr\u1ecb \u0111\u1ea9u) ^ (1 \/ (kho\u1ea3ng th\u1eddi gian- 1)) -1. V\u00e0 ch\u00fang ta c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">1. Ch\u1ecdn \u00f4 tr\u1ed1ng, v\u00ed d\u1ee5 C6, nh\u1eadp c\u00f4ng th\u1ee9c = (B11 \/ B2) ^ (1 \/ (10-1)) \u2013 1 v\u00e0o \u0111\u00f3, v\u00e0 nh\u1ea5n ph\u00edm Enter. Xem h\u00ecnh sau:<\/p>\n<p style=\"text-align: justify\">Ch\u00fa \u00fd: Trong c\u00f4ng th\u1ee9c = (B11 \/ B2) ^ (1 \/ (10-1)) -1, B11 l\u00e0 \u00f4 c\u00f3 gi\u00e1 tr\u1ecb cu\u1ed1i, B2 l\u00e0 \u00f4 c\u00f3 gi\u00e1 tr\u1ecb \u0111\u1ea7u, v\u00e0 10 l\u00e0 kho\u1ea3ng th\u1eddi gian gi\u1eefa gi\u00e1 tr\u1ecb b\u1eaft \u0111\u1ea7u v\u00e0 k\u1ebft th\u00fac v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i ch\u00fang theo \u00fd mu\u1ed1n.<\/p>\n<p style=\"text-align: justify\">2. Ch\u1ecdn \u00f4 m\u00e0 b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c (trong tr\u01b0\u1eddng h\u1ee3p c\u1ee7a ch\u00fang ta l\u00e0 C6), nh\u1ea5p v\u00e0o n\u00fat <strong>Percent Style<\/strong> tr\u00ean tab <strong>Home<\/strong> \u0111\u1ec3 thay \u0111\u1ed5i s\u1ed1 th\u00e0nh \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m, v\u00e0 sau \u0111\u00f3 thay \u0111\u1ed5i v\u1ecb tr\u00ed th\u1eadp ph\u00e2n c\u1ee7a n\u00f3 b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o n\u00fat <strong>Increase Decimal<\/strong> ho\u1eb7c <strong>Decrease Decimal<\/strong>. Xem h\u00ecnh sau:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-aagr-cagr-3.png\" title=\"doc-aagr-cagr-3\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tinh_ti_le_tang_truong_hang_nam_voi_ham_XIRR_trong_Excel\"><\/span>T\u00ednh t\u1ec9 l\u1ec7 t\u0103ng tr\u01b0\u1edfng h\u00e0ng n\u0103m v\u1edbi h\u00e0m XIRR trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Th\u1eadt ra, h\u00e0m XIRR c\u00f3 th\u1ec3 gi\u00fap ch\u00fang ta t\u00ednh to\u00e1n l\u1ec7 t\u0103ng tr\u01b0\u1edfng h\u00e0ng n\u0103m trong Excel d\u1ec5 d\u00e0ng, nh\u01b0ng n\u00f3 c\u1ea7n b\u1ea1n t\u1ea1o m\u1ed9t b\u1ea3ng m\u1edbi c\u00f3 gi\u00e1 tr\u1ecb \u0111\u1ea7u v\u00e0 cu\u1ed1i.<\/p>\n<p style=\"text-align: justify\">1.T\u1ea1o m\u1ed9t b\u1ea3ng c\u00f3 gi\u00e1 tr\u1ecb \u0111\u1ea7u v\u00e0 cu\u1ed1i nh\u01b0 h\u00ecnh sau<\/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-26.gif\" title=\"vba101_92019-nho-26\"><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-80.gif\" title=\"ex101_92019-nho-80\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6220\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-163.png\" width=\"261\" height=\"361\" title=\"excel-dialog-box-launcher-1-163\"><\/p>\n<p style=\"text-align: justify\"><strong>L\u01b0u \u00fd:<\/strong> Trong \u00f4 B30 nh\u1eadp <strong>= B2<\/strong>, trong \u00f4 C30 nh\u1eadp <strong>= A2<\/strong>, trong \u00f4 B31 nh\u1eadp <strong>= -B11<\/strong> v\u00e0 trong \u00f4 C31 nh\u1eadp <strong>= A11<\/strong> ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp d\u1eef li\u1ec7u ban \u0111\u1ea7u c\u1ee7a b\u1ea1n v\u00e0o b\u1ea3ng n\u00e0y tr\u1ef1c ti\u1ebfp. Nh\u00e2n ti\u1ec7n, b\u1ea1n ph\u1ea3i th\u00eam d\u1ea5u tr\u1eeb tr\u01b0\u1edbc Gi\u00e1 tr\u1ecb Cu\u1ed1i.<\/p>\n<p style=\"text-align: justify\">2. Ch\u1ecdn m\u1ed9t \u00f4 tr\u1ed1ng b\u00ean d\u01b0\u1edbi b\u1ea3ng n\u00e0y, nh\u1eadp c\u00f4ng th\u1ee9c<strong> = XIRR (B30: B31, C30: C31)<\/strong> v\u00e0o \u0111\u00f3, v\u00e0 nh\u1ea5n ph\u00edm Enter.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-aagr-cagr-11.png\" title=\"doc-aagr-cagr-11\"><\/p>\n<p style=\"text-align: justify\">3. \u0110\u1ec3 thay \u0111\u1ed5i k\u1ebft qu\u1ea3 th\u00e0nh \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m, h\u00e3y ch\u1ecdn \u00f4 c\u00f3 h\u00e0m XIRR, nh\u1ea5p v\u00e0o n\u00fat <strong>Percent Style <\/strong>tr\u00ean tab <strong>Home<\/strong> v\u00e0 sau \u0111\u00f3 thay \u0111\u1ed5i v\u1ecb tr\u00ed th\u1eadp ph\u00e2n b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o n\u00fat <strong>Increase Decimal<\/strong> ho\u1eb7c <strong>Decrease Decimal<\/strong>. Xem h\u00ecnh sau:<\/p>\n<h1 style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-aagr-cagr-3.png\" title=\"doc-aagr-cagr-3\"><\/h1>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u00ednh t\u1ec9 l\u1ec7 t\u0103ng tr\u01b0\u1edfng trung b\u00ecnh h\u00e0ng n\u0103m trong excel, th\u00f4ng th\u01b0\u1eddng ch\u00fang ta ph\u1ea3i t\u00ednh to\u00e1n t\u1ec9 l\u1ec7 t\u0103ng tr\u01b0\u1edfng h\u00e0ng n\u0103m c\u1ee7a m\u1ed7i n\u0103m b\u1eb1ng c\u00f4ng th\u1ee9c = (Gi\u00e1 tr\u1ecb cu\u1ed1i \u2013 Gi\u00e1 tr\u1ecb \u00a0\u0111\u1ea7u) \/ Gi\u00e1 tr\u1ecb \u0111\u1ea7u, v\u00e0 sau \u0111\u00f3 t\u00ednh tr\u00f9ng b\u00ecnh c\u00e1c t\u1ef7 l\u1ec7 t\u0103ng tr\u01b0\u1edfng h\u00e0ng n\u0103m n\u00e0y. B\u1ea1n c\u00f3 th\u1ec3 l\u00e0m nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">1. B\u00ean c\u1ea1nh b\u1ea3ng ban \u0111\u1ea7u, h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c = (B3-B2) \/ B2 v\u00e0o \u00f4 C3 tr\u1ed1ng, v\u00e0 k\u00e9o c\u00f4ng th\u1ee9c t\u1eeb C3 \u0111\u1ebfn C11.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6221\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-164.png\" width=\"469\" height=\"404\" title=\"excel-dialog-box-launcher-1-164\"><\/p>\n<p style=\"text-align: justify\">2. Ch\u1ecdn v\u00f9ng C3: C11, nh\u1ea5p v\u00e0o n\u00fat <strong>Percent Style<\/strong> tr\u00ean tab <strong>Home<\/strong> v\u00e0 sau \u0111\u00f3 thay \u0111\u1ed5i v\u1ecb tr\u00ed th\u1eadp ph\u00e2n b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o n\u00fat <strong>Increase Decimal<\/strong> ho\u1eb7c <strong>Decrease Decimal<\/strong>. Xem h\u00ecnh tr\u00ean:<\/p>\n<p style=\"text-align: justify\">3. Trung b\u00ecnh t\u1ef7 l\u1ec7 t\u0103ng tr\u01b0\u1edfng qua c\u00e1c n\u0103m \u0111\u01b0\u1ee3c t\u00ednh b\u1eb1ng c\u00f4ng th\u1ee9c = AVERAGE(C3: C11) trong \u00f4 C12, v\u00e0 nh\u1ea5n ph\u00edm Enter.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-aagr-cagr-9.png\" title=\"doc-aagr-cagr-9\"><\/p>\n<p>Mong r\u0103\u0300ng v\u01a1\u0301i ba\u0300i vi\u00ea\u0301t na\u0300y se\u0303 giu\u0301p ca\u0301c ba\u0323n co\u0301 th\u00ea\u0309 bi\u00ea\u0301t ca\u0301ch\u00a0l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh t\u1ed1c \u0111\u1ed9 t\u0103ng tr\u01b0\u1edfng b\u00ecnh qu\u00e2n, t\u0103ng tr\u01b0\u1edfng h\u00e0ng n\u0103m trong Excel m\u00f4\u0323t ca\u0301ch \u0111\u01a1n gia\u0309n va\u0300 hi\u00ea\u0323u qua\u0309 nh\u00e2\u0301t.<\/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<\/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-26.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1136,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1135","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\/1135","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=1135"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1135\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1136"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1135"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1135"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1135"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}