{"id":11955,"date":"2025-01-15T06:23:27","date_gmt":"2025-01-15T06:23:27","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-tinh-luy-ke-doanh-so-ban-hang-bang-ham-sum-va-ve-do-thi-doanh-so\/"},"modified":"2025-01-15T06:23:27","modified_gmt":"2025-01-15T06:23:27","slug":"huong-dan-tinh-luy-ke-doanh-so-ban-hang-bang-ham-sum-va-ve-do-thi-doanh-so","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-tinh-luy-ke-doanh-so-ban-hang-bang-ham-sum-va-ve-do-thi-doanh-so\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn t\u00ednh l\u0169y k\u1ebf doanh s\u1ed1 b\u00e1n h\u00e0ng b\u1eb1ng h\u00e0m SUM v\u00e0 v\u1ebd \u0111\u1ed3 th\u1ecb doanh s\u1ed1"},"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\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn cho c\u00e1c b\u1ea1n c\u00e1ch d\u00f9ng n\u00e2ng cao c\u1ee7a h\u00e0m SUM \u0111\u1ec3 nhanh ch\u00f3ng t\u00ednh ra 1 lu\u1ef9 k\u1ebf (<em>cumulative sum<\/em>\/<em>running total<\/em>) trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n.<\/p>\n<p style=\"text-align: justify\">Lu\u1ef9 k\u1ebf l\u00e0 t\u1ed5ng c\u00e1c s\u1ed1 \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt li\u00ean t\u1ee5c, lu\u00f4n c\u00f3 s\u1ed1 m\u1edbi \u0111\u01b0\u1ee3c th\u00eam v\u00e0o d\u00e3y.<\/p>\n<p style=\"text-align: justify\">Lu\u1ef9 k\u1ebf \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng ph\u1ed5 bi\u1ebfn trong cu\u1ed9c s\u1ed1ng h\u1eb1ng ng\u00e0y, v\u00ed d\u1ee5 nh\u01b0 t\u00ednh t\u1ec9 s\u1ed1 hi\u1ec7n t\u1ea1i c\u1ee7a tr\u1eadn \u0111\u1ea5u, bi\u1ec3u th\u1ecb doanh s\u1ed1 b\u00e1n h\u00e0ng, t\u00ednh to\u00e1n s\u1ed1 d\u01b0 sau m\u1ed7i l\u1ea7n r\u00fat v\u00e0 g\u1eedi ti\u1ec1n. Nh\u1eefng v\u00ed d\u1ee5 sau s\u1ebd minh ho\u1ea1 cho b\u1ea1n c\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 t\u00ecm ra lu\u1ef9 k\u1ebf v\u00e0 t\u1ea1o bi\u1ec3u \u0111\u1ed3 lu\u1ef9 k\u1ebf.<\/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-6787545c07b5d\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-tinh-luy-ke-doanh-so-ban-hang-bang-ham-sum-va-ve-do-thi-doanh-so.html#TINH_LUY_KE_TRONG_EXCEL\" title=\"T\u00cdNH LU\u1ef8 K\u1ebe TRONG EXCEL:\">T\u00cdNH LU\u1ef8 K\u1ebe TRONG EXCEL:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-tinh-luy-ke-doanh-so-ban-hang-bang-ham-sum-va-ve-do-thi-doanh-so.html#CACH_TAO_BIEU_DO_LUY_KE\" title=\"C\u00c1CH T\u1ea0O BI\u1ec2U \u0110\u1ed2 LU\u1ef8 K\u1ebe\">C\u00c1CH T\u1ea0O BI\u1ec2U \u0110\u1ed2 LU\u1ef8 K\u1ebe<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"TINH_LUY_KE_TRONG_EXCEL\"><\/span><strong>T\u00cdNH LU\u1ef8 K\u1ebe TRONG EXCEL:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u00ednh lu\u1ef9 k\u1ebf trong Excel, b\u1ea1n d\u00f9ng h\u00e0m SUM k\u1ebft h\u1ee3p v\u1edbi vi\u1ec7c s\u1eed d\u1ee5ng tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i v\u00e0 tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, \u0111\u1ec3 t\u00ednh lu\u1ef9 k\u1ebf cho c\u00e1c s\u1ed1 trong c\u1ed9t B b\u1eaft \u0111\u1ea7u t\u1eeb \u00f4 B2, nh\u1eadp c\u00f4ng th\u1ee9c sau v\u00e0o \u00f4 C2 v\u00e0 sao ch\u00e9p xu\u1ed1ng c\u00e1c \u00f4 d\u01b0\u1edbi.<\/p>\n<p style=\"text-align: justify\"><strong>=SUM($B$2:B2)<\/strong><\/p>\n<p style=\"text-align: justify\">Trong c\u00f4ng th\u1ee9c lu\u1ef9 k\u1ebf, tham chi\u1ebfu \u0111\u1ea7u ti\u00ean s\u1ebd lu\u00f4n l\u00e0 tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i v\u1edbi k\u00fd hi\u1ec7u $ ($B$2). V\u00ec tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i kh\u00f4ng bao gi\u1edd thay \u0111\u1ed5i d\u00f9 c\u00f4ng th\u1ee9c di chuy\u1ec3n, n\u00ean n\u00f3 lu\u00f4n tham chi\u1ebfu v\u1ec1 \u00f4 B2. Tham chi\u1ebfu th\u1ee9 2 kh\u00f4ng c\u00f3 k\u00fd hi\u1ec7u $ l\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 n\u00f3 s\u1ebd \u0111i\u1ec1u ch\u1ec9nh d\u1ef1a tr\u00ean v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a \u00f4 m\u00e0 c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c sao ch\u00e9p.<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-338.gif\" title=\"ex101_92019-nho-338\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">V\u00ec th\u1ebf, khi c\u00f4ng th\u1ee9c SUM \u0111\u01b0\u1ee3c sao ch\u00e9p t\u1edbi \u00f4 B3, n\u00f3 tr\u1edf th\u00e0nh SUM($B$2:B3), v\u00e0 tr\u1ea3 t\u1ed5ng gi\u00e1 tr\u1ecb c\u00e1c \u00f4 t\u1eeb B2 \u0111\u1ebfn B3. Trong \u00f4 B4, c\u00f4ng th\u1ee9c tr\u1edf th\u00e0nh SUM($B$2:B4), v\u00e0 t\u1ed5ng gi\u00e1 tr\u1ecb t\u1eeb B2 \u0111\u1ebfn B4, v\u00e0 c\u1ee9 th\u1ebf ti\u1ebfp t\u1ee5c.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5065 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-cumulative-sum.png\" width=\"275\" height=\"260\" title=\"excel-cumulative-sum\"><\/p>\n<p style=\"text-align: justify\">T\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m SUM \u0111\u1ec3 t\u00ednh lu\u1ef9 k\u1ebf cho s\u1ed1 d\u01b0 t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng. \u0110\u1ec3 t\u00ednh to\u00e1n, b\u1ea1n nh\u1eadp s\u1ed1 ti\u1ec1n g\u1eedi l\u00e0 s\u1ed1 d\u01b0\u01a1ng, s\u1ed1 ti\u1ec1n r\u00fat ra l\u00e0 s\u1ed1 \u00e2m trong 1 c\u1ed9t (v\u00ed d\u1ee5 c\u1ed9t C). Sau \u0111\u00f3, nh\u1eadp c\u00f4ng th\u1ee9c t\u00ednh lu\u1ef9 k\u1ebf sau v\u00e0o c\u1ed9t D:<\/p>\n<p style=\"text-align: justify\"><strong>=SUM($B$C:C2)<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5066 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-running-total.png\" width=\"374\" height=\"219\" title=\"excel-running-total\"><\/p>\n<p style=\"text-align: justify\">Th\u1ef1c t\u1ebf, h\u00ecnh tr\u00ean kh\u00f4ng ph\u1ea3i minh ho\u1ea1 ch\u00ednh x\u00e1c 1 lu\u1ef9 k\u1ebf. Tuy nhi\u00ean, b\u1ea1n \u0111\u00e3 c\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 m\u00ecnh mong mu\u1ed1n.<\/p>\n<p style=\"text-align: justify\"><strong>Xem th\u00eam<\/strong>:\u00a0<strong>C\u00e1c v\u00ed d\u1ee5 v\u1ec1 <a href=\"http:\/\/blog.ezworkapp.com\/cac-vi-du-ve-ham-sum-trong-excel-cach-chi-tinh-tong-cac-cot-hang-hoac-o-duoc-hien-thi.html\">h\u00e0m Sum trong Excel<\/a> \u2013 C\u00e1ch ch\u1ec9 t\u00ednh t\u1ed5ng c\u00e1c c\u1ed9t, h\u00e0ng ho\u1eb7c \u00f4 \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb<\/strong><\/p>\n<p style=\"text-align: justify\">Nh\u00ecn qua, c\u00f4ng th\u1ee9c t\u00ednh lu\u1ef9 k\u1ebf c\u1ee7a ch\u00fang ta tr\u00f4ng ho\u00e0n h\u1ea3o, nh\u01b0ng l\u1ea1i c\u00f3 1 \u0111i\u1ec3m h\u1ea1n ch\u1ebf l\u1edbn. Khi b\u1ea1n sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0o c\u1ed9t, b\u1ea1n s\u1ebd \u0111\u1ec3 \u00fd th\u1ea5y gi\u00e1 tr\u1ecb lu\u1ef9 k\u1ebf trong c\u00e1c \u00f4 gi\u1ed1ng nhau t\u1eeb \u00f4 cu\u1ed1i c\u00f9ng tr\u1edf xu\u1ed1ng.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5067 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-cummulative-sum-formula.png\" width=\"398\" height=\"284\" title=\"excel-cummulative-sum-formula\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 ch\u1eefa l\u1ed7i n\u00e0y, ch\u00fang ta l\u1ed3ng c\u00f4ng th\u1ee9c t\u00ednh lu\u1ef9 k\u1ebf v\u00e0o <strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-if-va-cach-su-dung-ham-if-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m IF<\/a>:<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>=IF(C2=\u201d\u201d,\u201d\u201d,SUM($C$2:C2))<\/strong><\/p>\n<p style=\"text-align: justify\">V\u1edbi c\u00f4ng th\u1ee9c tr\u00ean, Excel s\u1ebd th\u1ef1c hi\u1ec7n nh\u01b0 sau: Khi \u00f4 B2 tr\u1ed1ng, s\u1ebd tr\u1ea3 k\u1ebft qu\u1ea3 l\u00e0 1 chu\u1ed7i tr\u1ed1ng, ho\u1eb7c kh\u00f4ng s\u1ebd \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c t\u00ednh lu\u1ef9 k\u1ebf.<\/p>\n<p style=\"text-align: justify\">Gi\u1edd b\u1ea1n c\u00f3 th\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c cho c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n, v\u00e0 \u00f4 c\u00f4ng th\u1ee9c s\u1ebd tr\u1ed1ng \u0111\u1ebfn khi b\u1ea1n nh\u1eadp s\u1ed1 v\u00e0o h\u00e0ng t\u01b0\u01a1ng \u1ee9ng \u1edf c\u1ed9t C. Ngay khi b\u1ea1n l\u00e0m vi\u1ec7c n\u00e0y, lu\u1ef9 k\u1ebf t\u00ednh \u0111\u01b0\u1ee3c s\u1ebd xu\u1ea5t hi\u1ec7n.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5068 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cummulative-sum-formula-improved.png\" width=\"399\" height=\"242\" title=\"cummulative-sum-formula-improved\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CACH_TAO_BIEU_DO_LUY_KE\"><\/span><strong>C\u00c1CH T\u1ea0O BI\u1ec2U \u0110\u1ed2 LU\u1ef8 K\u1ebe<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Khi b\u1ea1n t\u00ednh \u0111\u01b0\u1ee3c lu\u1ef9 k\u1ebf b\u1eb1ng c\u00f4ng th\u1ee9c SUM, t\u1ea1o bi\u1ec3u \u0111\u1ed3 lu\u1ef9 k\u1ebf ch\u1ec9 m\u1ea5t v\u00e0i ph\u00fat.<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n, bao g\u1ed3m c\u1ea3 c\u1ed9t lu\u1ef9 k\u1ebf, v\u00e0 t\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t d\u1ea1ng 2D b\u1eb1ng c\u00e1ch nh\u1ea5n n\u00fat t\u01b0\u01a1ng \u1ee9ng trong tab <strong>Insert<\/strong>, nh\u00f3m <strong>Charts<\/strong>:<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5069 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/clustered-column-chart.png\" width=\"634\" height=\"583\" title=\"clustered-column-chart\"><\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>Trong bi\u1ec3u \u0111\u1ed3 m\u1edbi t\u1ea1o, ch\u1ecdn d\u1ea1ng d\u1eef li\u1ec7u <strong>Cumulative Sum<\/strong>, nh\u1ea5n chu\u1ed9t ph\u1ea3i \u0111\u1ec3 ch\u1ecdn <strong>Change Series Chart Type\u2026<\/strong>trong menu.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5070 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/make-cumulative-graph-excel.png\" width=\"592\" height=\"368\" title=\"make-cumulative-graph-excel\"><\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li>N\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng Excel 2013 ho\u1eb7c 2016, ch\u1ecdn d\u1ea1ng bi\u1ec3u \u0111\u1ed3 <strong>Combo<\/strong>, v\u00e0 nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng \u0111\u1ea7u ti\u00ean trong h\u1ed9p tho\u1ea1i <strong>Change Chart Type<\/strong>.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5071 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/clustered-column-line.png\" width=\"640\" height=\"392\" title=\"clustered-column-line\"><\/p>\n<p style=\"text-align: justify\">Ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 v\u00e0o <strong>Custom Combination<\/strong> \u0111\u1ec3 ch\u1ecdn ki\u1ec3u bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1eddng cho d\u1eef li\u1ec7u Cumulative Sum (trong v\u00ed d\u1ee5 l\u00e0 <strong>Line with Markers<\/strong>).<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5072 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/custom-combination.png\" width=\"640\" height=\"558\" title=\"custom-combination\"><\/p>\n<p style=\"text-align: justify\">Trong Excel 2010 tr\u1edf v\u1ec1 tr\u01b0\u1edbc, ch\u1ec9 c\u1ea7n ch\u1ecdn d\u1ea1ng bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1eddng cho d\u1eef li\u1ec7u Cumulative Sum.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5073 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cumulative-graph-excel2010.png\" width=\"570\" height=\"362\" title=\"cumulative-graph-excel2010\"><\/p>\n<ol style=\"text-align: justify\" start=\"4\">\n<li>Nh\u1ea5n <strong>OK<\/strong>. V\u00e0 b\u1ea1n \u0111\u00e3 c\u00f3 bi\u1ec3u \u0111\u1ed3 lu\u1ef9 k\u1ebf<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5074 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-cumulative-chart.png\" width=\"409\" height=\"287\" title=\"excel-cumulative-chart\"><\/li>\n<li>B\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0o \u0111\u01b0\u1eddng lu\u1ef9 k\u1ebf trong bi\u1ec3u \u0111\u1ed3, v\u00e0 ch\u1ecdn <strong>Add Data Labels<\/strong> t\u1eeb menu.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5075 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/add-data-labels.png\" width=\"509\" height=\"321\" title=\"add-data-labels\"><\/p>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3, bi\u1ec3u \u0111\u1ed3 lu\u1ef9 k\u1ebf c\u1ee7a b\u1ea1n s\u1ebd tr\u00f4ng nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5076 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/improved-cumulative-graph-excel.png\" width=\"583\" height=\"338\" title=\"improved-cumulative-graph-excel\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u00f4 \u0111i\u1ec3m th\u00eam cho bi\u1ec3u \u0111\u1ed3, b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i t\u00ean bi\u1ec3u \u0111\u1ed3, ch\u1ecdn m\u1eabu bi\u1ec3u \u0111\u1ed3 kh\u00e1c, m\u00e0u kh\u00e1c\u2026<\/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 <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html\"><strong>h\u00e0m SUMIF<\/strong><\/a>, 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\/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-338.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11956,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11955","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\/11955","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=11955"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11955\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11956"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11955"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11955"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11955"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}