{"id":7972,"date":"2024-12-21T19:13:33","date_gmt":"2024-12-21T19:13:33","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-tinh-trung-binh-trong-so-trong-excel-bang-ham-sum-hoac-sumproduct\/"},"modified":"2024-12-21T19:13:33","modified_gmt":"2024-12-21T19:13:33","slug":"cach-tinh-trung-binh-trong-so-trong-excel-bang-ham-sum-hoac-sumproduct","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-tinh-trung-binh-trong-so-trong-excel-bang-ham-sum-hoac-sumproduct\/","title":{"rendered":"C\u00e1ch t\u00ednh trung b\u00ecnh tr\u1ecdng s\u1ed1 trong Excel b\u1eb1ng h\u00e0m Sum ho\u1eb7c Sumproduct"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">H\u01b0\u1edbng d\u1eabn n\u00e0y \u0111\u01b0a ra hai c\u00e1ch \u0111\u1ec3 t\u00ednh trung b\u00ecnh tr\u1ecdng s\u1ed1 trong Excel \u2013 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng <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\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m SUM<\/a> ho\u1eb7c <a href=\"http:\/\/blog.ezworkapp.com\/47-%e2%97%8f-ham-sumproduct-va-su-khac-nhau-voi-sumifs-countifs-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">SUMPRODUCT<\/a>.<\/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-6767135c4b42f\" 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-trung-binh-trong-so-trong-excel-bang-ham-sum-hoac-sumproduct.html#Trung_binh_trong_so_la_gi\" title=\"Trung b\u00ecnh tr\u1ecdng s\u1ed1 l\u00e0 g\u00ec?\">Trung b\u00ecnh tr\u1ecdng s\u1ed1 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\/cach-tinh-trung-binh-trong-so-trong-excel-bang-ham-sum-hoac-sumproduct.html#Tinh_toan_trung_binh_trong_so_trong_Excel\" title=\"T\u00ednh to\u00e1n trung b\u00ecnh tr\u1ecdng s\u1ed1 trong Excel\">T\u00ednh to\u00e1n trung b\u00ecnh tr\u1ecdng s\u1ed1 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\/cach-tinh-trung-binh-trong-so-trong-excel-bang-ham-sum-hoac-sumproduct.html#Vi_du_1_Tinh_trung_binh_trong_so_bang_cach_su_dung_ham_SUM\" title=\"V\u00ed d\u1ee5 1. T\u00ednh trung b\u00ecnh tr\u1ecdng s\u1ed1 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUM\">V\u00ed d\u1ee5 1. T\u00ednh trung b\u00ecnh tr\u1ecdng s\u1ed1 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUM<\/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\/cach-tinh-trung-binh-trong-so-trong-excel-bang-ham-sum-hoac-sumproduct.html#Vi_du_2_Tim_trung_binh_trong_so_voi_ham_SUMPRODUCT\" title=\"V\u00ed d\u1ee5 2. T\u00ecm trung b\u00ecnh tr\u1ecdng s\u1ed1 v\u1edbi h\u00e0m SUMPRODUCT\">V\u00ed d\u1ee5 2. T\u00ecm trung b\u00ecnh tr\u1ecdng s\u1ed1 v\u1edbi h\u00e0m SUMPRODUCT<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Trung_binh_trong_so_la_gi\"><\/span><strong>Trung b\u00ecnh tr\u1ecdng s\u1ed1 l\u00e0 g\u00ec?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Trung b\u00ecnh tr\u1ecdng s\u1ed1 l\u00e0 m\u1ed9t lo\u1ea1i trung b\u00ecnh s\u1ed1 h\u1ecdc, trong \u0111\u00f3 m\u1ed9t s\u1ed1 ph\u1ea7n t\u1eed c\u1ee7a t\u1eadp d\u1eef li\u1ec7u c\u00f3 t\u1ea7m quan tr\u1ecdng h\u01a1n c\u00e1c y\u1ebfu t\u1ed1 kh\u00e1c. N\u00f3i c\u00e1ch kh\u00e1c, m\u1ed7i gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c t\u00ednh trung b\u00ecnh \u0111\u01b0\u1ee3c g\u00e1n m\u1ed9t t\u1ec9 tr\u1ecdng nh\u1ea5t \u0111\u1ecbnh.<\/p>\n<p style=\"text-align: justify\">\u0110i\u1ec3m c\u1ee7a sinh vi\u00ean th\u01b0\u1eddng \u0111\u01b0\u1ee3c t\u00ednh b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng trung b\u00ecnh tr\u1ecdng s\u1ed1, nh\u01b0 h\u00ecnh sau. Trung b\u00ecnh c\u1ed9ng th\u00f4ng th\u01b0\u1eddng \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n d\u1ec5 d\u00e0ng b\u1eb1ng h\u00e0m Excel AVERAGE. Tuy nhi\u00ean, ta c\u1ea7n c\u00f4ng th\u1ee9c t\u00ednh trung b\u00ecnh cho c\u00e1c ho\u1ea1t \u0111\u1ed9ng chi\u1ebfm t\u1ec9 tr\u1ecdng kh\u00e1c nhau li\u1ec7t k\u00ea trong c\u1ed9t C.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-19.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4444 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-19.bmp\" width=\"295\" height=\"300\" title=\"new-bitmap-image-2-19\"><\/a><\/p>\n<p style=\"text-align: justify\">Trong to\u00e1n h\u1ecdc v\u00e0 th\u1ed1ng k\u00ea, b\u1ea1n t\u00ednh to\u00e1n trung b\u00ecnh tr\u1ecdng s\u1ed1 b\u1eb1ng c\u00e1ch nh\u00e2n m\u1ed7i gi\u00e1 tr\u1ecb v\u1edbi t\u1ec9 tr\u1ecdng c\u1ee7a n\u00f3, sau \u0111\u00f3 c\u1ed9ng c\u00e1c k\u1ebft qu\u1ea3 r\u1ed3i l\u1ea5y t\u1ed5ng \u0111\u00f3 chia cho t\u1ed5ng t\u1ec9 tr\u1ecdng.<\/p>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 n\u00e0y, \u0111\u1ec3 t\u00ednh trung b\u00ecnh tr\u1ecdng s\u1ed1 (c\u1ee7a t\u1ed5ng th\u1ec3), b\u1ea1n nh\u00e2n m\u1ed7i lo\u1ea1i v\u1edbi t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m t\u01b0\u01a1ng \u1ee9ng (\u0111\u01b0\u1ee3c chuy\u1ec3n th\u00e0nh s\u1ed1 th\u1eadp ph\u00e2n), c\u1ed9ng 5 k\u1ebft qu\u1ea3 l\u1ea1i, r\u1ed3i chia cho t\u1ed5ng s\u1ed1 ph\u1ea7n tr\u0103m:<\/p>\n<p style=\"text-align: justify\"><em><strong>((91*0.1)+(65*0.15)+(80*0.2)+(73*0.25)+(68*0.3)) \/ (0.1+0.15+0.2+0.25+0.3)=73.5<\/strong><\/em><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-716.gif\" title=\"ex101_92019-nho-716\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n th\u1ea5y, m\u1ee9c trung b\u00ecnh c\u1ed9ng (75,4) v\u00e0 trung b\u00ecnh tr\u1ecdng s\u1ed1 (73,5) l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c nhau.<\/p>\n<p style=\"text-align: justify\"><strong>Xem th\u00eam:<\/strong>\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-3-cach-tinh-trung-binh-tren-excel-2010.html\">H\u01b0\u1edbng d\u1eabn 3 c\u00e1ch t\u00ednh trung b\u00ecnh tr\u00ean excel 2017, 2010, 2013, 2016<\/a><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tinh_toan_trung_binh_trong_so_trong_Excel\"><\/span><strong>T\u00ednh to\u00e1n trung b\u00ecnh tr\u1ecdng s\u1ed1 trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Trong Microsoft Excel, trung b\u00ecnh tr\u1ecdng s\u1ed1 \u0111\u01b0\u1ee3c t\u00ednh b\u1eb1ng ph\u01b0\u01a1ng ph\u00e1p t\u01b0\u01a1ng t\u1ef1 nh\u01b0ng \u00edt ph\u1ee9c t\u1ea1p h\u01a1n b\u1edfi c\u00e1c h\u00e0m Excel s\u1ebd th\u1ef1c hi\u1ec7n h\u1ea7u h\u1ebft c\u00f4ng vi\u1ec7c cho b\u1ea1n.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_1_Tinh_trung_binh_trong_so_bang_cach_su_dung_ham_SUM\"><\/span><strong>V\u00ed d\u1ee5 1. T\u00ednh trung b\u00ecnh tr\u1ecdng s\u1ed1 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUM<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n c\u00f3 ki\u1ebfn \u200b\u200bth\u1ee9c c\u01a1 b\u1ea3n v\u1ec1 h\u00e0m SUM trong Excel, c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng hi\u1ec3u c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\"><strong><em>= SUM (B2 * C2, B3 * C3, B4 * C4, B5 * C5, B6 * C6,) \/ SUM (C2: C6)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">V\u1ec1 b\u1ea3n ch\u1ea5t, n\u00f3 th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n t\u01b0\u01a1ng t\u1ef1 nh\u01b0 m\u00f4 t\u1ea3 \u1edf tr\u00ean, ngo\u1ea1i tr\u1eeb vi\u1ec7c b\u1ea1n cung c\u1ea5p c\u00e1c tham chi\u1ebfu \u00f4 thay v\u00ec s\u1ed1.<\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n th\u1ea5y trong h\u00ecnh, c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c nh\u01b0 k\u1ebft qu\u1ea3 t\u00ednh ta \u0111\u00e3 l\u00e0m tr\u01b0\u1edbc \u0111\u00f3. Ch\u00fa \u00fd s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa trung b\u00ecnh c\u1ed9ng t\u1eeb h\u00e0m <em><strong>AVERAGE (C8)<\/strong><\/em> v\u00e0 trung b\u00ecnh tr\u1ecdng s\u1ed1 <em><strong>(C9)<\/strong><\/em>.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-20.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4446 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-20.bmp\" width=\"463\" height=\"300\" title=\"new-bitmap-image-2-20\"><\/a><\/p>\n<p style=\"text-align: justify\">M\u1eb7c d\u00f9 h\u00e0m SUM r\u1ea5t \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u01b0ng n\u00f3 kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t l\u1ef1a ch\u1ecdn kh\u1ea3 thi n\u1ebfu t\u00ednh trung b\u00ecnh nhi\u1ec1u s\u1ed1. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n n\u00ean s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT th\u1ec3 hi\u1ec7n trong v\u00ed d\u1ee5 ti\u1ebfp theo.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_2_Tim_trung_binh_trong_so_voi_ham_SUMPRODUCT\"><\/span><strong>V\u00ed d\u1ee5 2. T\u00ecm trung b\u00ecnh tr\u1ecdng s\u1ed1 v\u1edbi h\u00e0m SUMPRODUCT<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">H\u00e0m SUMPRODUCT c\u1ee7a Excel ph\u00f9 h\u1ee3p ho\u00e0n h\u1ea3o cho vi\u1ec7c n\u00e0y v\u00ec n\u00f3 \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 t\u1ed5ng s\u1ed1s\u1ea3n ph\u1ea9m, \u0111\u00f3 ch\u00ednh x\u00e1c l\u00e0 nh\u1eefng g\u00ec ta c\u1ea7n. V\u00ec v\u1eady, thay v\u00ec nh\u00e2n m\u1ed7i gi\u00e1 tr\u1ecb theo tr\u1ecdng s\u1ed1 ri\u00eang l\u1ebb, b\u1ea1n cung c\u1ea5p hai m\u1ea3ng trong c\u00f4ng th\u1ee9c SUMPRODUCT (trong b\u00e0i n\u00e0y, m\u1ea3ng l\u00e0 m\u1ed9t d\u00e3y c\u00e1c \u00f4 li\u00ean ti\u1ebfp) v\u00e0 sau \u0111\u00f3 chia cho t\u1ed5ng tr\u1ecdng s\u1ed1:<\/p>\n<p style=\"text-align: justify\"><em><strong>=SUMPRODUCT(values_range, weights_range) \/ SUM(weights_range)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed c\u00e1c gi\u00e1 tr\u1ecb trung b\u00ecnh n\u1eb1m trong c\u00e1c \u00f4 B2: B6 v\u00e0 tr\u1ecdng s\u1ed1 trong c\u00e1c \u00f4 C2: C6, h\u00e0m SUMPRODUCT c\u00f3 d\u1ea1ng sau:<\/p>\n<p style=\"text-align: justify\"><strong><em>= SUMPRODUCT (B2: B6, C2: C6) \/ SUM (C2: C6)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 xem c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ea3ng, h\u00e3y ch\u1ecdn m\u1ea3ng ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb \u0111\u00f3 trong thanh c\u00f4ng th\u1ee9c v\u00e0 nh\u1ea5n ph\u00edm F9. K\u1ebft qu\u1ea3 s\u1ebd t\u01b0\u01a1ng t\u1ef1 nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-21.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4448 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-21.bmp\" width=\"551\" height=\"301\" title=\"new-bitmap-image-2-21\"><\/a><\/p>\n<p style=\"text-align: justify\">V\u1eady nh\u1eefng g\u00ec h\u00e0m SUMPRODUCT l\u00e0m l\u00e0 nh\u00e2n gi\u00e1 tr\u1ecb th\u1ee9 nh\u1ea5t trong m\u1ea3ng 1 v\u1edbi gi\u00e1 tr\u1ecb th\u1ee9 nh\u1ea5t trong m\u1ea3ng2 (91 * 0,1 trong v\u00ed d\u1ee5 n\u00e0y), sau \u0111\u00f3 nh\u00e2n gi\u00e1 tr\u1ecb th\u1ee9 2 trong m\u1ea3ng 1 b\u1edfi gi\u00e1 tr\u1ecb th\u1ee9 2 trong m\u1ea3ng 2 (65 * 0,15 trong v\u00ed d\u1ee5 n\u00e0y) v\u00e0 c\u1ee9 nh\u01b0 v\u1eady. Khi t\u1ea5t c\u1ea3 c\u00e1c ph\u00e9p nh\u00e2n \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n, h\u00e0m s\u1ebd c\u1ed9ng l\u1ea1i v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u0111\u00f3.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-22.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4449 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-22.bmp\" width=\"356\" height=\"302\" title=\"new-bitmap-image-2-22\"><\/a><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 \u0111\u1ea3m b\u1ea3o r\u1eb1ng h\u00e0m SUMPRODUCT mang l\u1ea1i k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c, h\u00e3y so s\u00e1nh n\u00f3 v\u1edbi h\u00e0m SUM t\u1eeb v\u00ed d\u1ee5 tr\u01b0\u1edbc v\u00e0 b\u1ea1n s\u1ebd th\u1ea5y r\u1eb1ng c\u00e1c con s\u1ed1 gi\u1ed1ng nhau.<\/p>\n<p style=\"text-align: justify\">Khi s\u1eed d\u1ee5ng h\u00e0m SUM ho\u1eb7c SUMPRODUCT \u0111\u1ec3 t\u00ecm tr\u1ecdng l\u01b0\u1ee3ng trung b\u00ecnh trong Excel, t\u1ec9 tr\u1ecdng kh\u00f4ng nh\u1ea5t thi\u1ebft l\u00e0 100% ho\u1eb7c th\u1ec3 th\u1ec3 hi\u1ec7n d\u01b0\u1edbi d\u1ea1ng ph\u1ea7n tr\u0103m. V\u00ed d\u1ee5: b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o ra m\u1ee9c \u0111\u1ed9 \u01b0u ti\u00ean \/ t\u1ea7m quan tr\u1ecdng v\u00e0 ch\u1ec9 \u0111\u1ecbnh m\u1ed9t s\u1ed1 nh\u1ea5t \u0111\u1ecbnh cho m\u1ed7i m\u1ee5c, nh\u01b0 h\u00ecnh sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-23.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4450 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-23.bmp\" width=\"365\" height=\"323\" title=\"new-bitmap-image-2-23\"><\/a><\/p>\n<p><em><strong>Ngu\u1ed3n:<\/strong> Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi Hocexcel Online.<\/em><\/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\u00a0<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-716.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7973,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7972","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\/7972","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=7972"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7972\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7973"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7972"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7972"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7972"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}