{"id":2809,"date":"2024-12-02T08:46:25","date_gmt":"2024-12-02T08:46:25","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/tinh-trung-binh-dong-trong-excel-bang-ham-average\/"},"modified":"2024-12-02T08:46:25","modified_gmt":"2024-12-02T08:46:25","slug":"tinh-trung-binh-dong-trong-excel-bang-ham-average","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/tinh-trung-binh-dong-trong-excel-bang-ham-average\/","title":{"rendered":"T\u00cdNH TRUNG B\u00ccNH \u0110\u1ed8NG TRONG EXCEL B\u1eb0NG H\u00c0M AVERAGE"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em><span style=\"font-weight: 400\">Trong b\u00e0i \u0111\u0103ng n\u00e0y c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a>, b\u1ea1n s\u1ebd h\u1ecdc c\u00e1ch t\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel c\u01b0c nhanh v\u00e0 \u0111\u01a1n gi\u1ea3n, v\u1edbi vi\u1ec7c s\u1eed d\u1ee5ng<a href=\"http:\/\/blog.ezworkapp.com\/tinh-trung-binh-dong-trong-excel-bang-ham-average.html\"> <strong>h\u00e0m Average<\/strong><\/a> . Nh\u1eefng tr\u01b0\u1eddng h\u1ee3p n\u00e0o c\u1ea7n s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong N ng\u00e0y, tu\u1ea7n, th\u00e1ng ho\u1eb7c n\u0103m qua v\u00e0 c\u00e1ch th\u00eam xu h\u01b0\u1edbng trung b\u00ecnh \u0111\u1ed9ng v\u00e0o \u0111\u1ed3 th\u1ecb Excel.\u00a0\u00a0<\/span><\/em><\/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-674d73dfdddfd\" 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\/tinh-trung-binh-dong-trong-excel-bang-ham-average.html#Duong_trung_binh_la_gi\" title=\"\u0110\u01b0\u1eddng trung b\u00ecnh l\u00e0 g\u00ec?\u00a0\u00a0\">\u0110\u01b0\u1eddng trung b\u00ecnh l\u00e0 g\u00ec?\u00a0\u00a0<\/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\/tinh-trung-binh-dong-trong-excel-bang-ham-average.html#Vi_du_1_Tinh_toan_duong_trung_binh_trong_mot_khoang_thoi_gian_nhat_dinh\" title=\"V\u00ed d\u1ee5 1: T\u00ednh to\u00e1n \u0111\u01b0\u1eddng trung b\u00ecnh trong m\u1ed9t kho\u1ea3ng th\u1eddi gian nh\u1ea5t \u0111\u1ecbnh\u00a0\">V\u00ed d\u1ee5 1: T\u00ednh to\u00e1n \u0111\u01b0\u1eddng trung b\u00ecnh trong m\u1ed9t kho\u1ea3ng th\u1eddi gian nh\u1ea5t \u0111\u1ecbnh\u00a0<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/tinh-trung-binh-dong-trong-excel-bang-ham-average.html#Vi_du_2_Lay_trung_binh_dong_cho_N_ngay_tuan_thang_nam_qua_trong_mot_cot\" title=\"V\u00ed d\u1ee5 2: L\u1ea5y trung b\u00ecnh \u0111\u1ed9ng cho N ng\u00e0y\/ tu\u1ea7n\/ th\u00e1ng\/ n\u0103m qua trong m\u1ed9t c\u1ed9t\u00a0\">V\u00ed d\u1ee5 2: L\u1ea5y trung b\u00ecnh \u0111\u1ed9ng cho N ng\u00e0y\/ tu\u1ea7n\/ th\u00e1ng\/ n\u0103m qua trong m\u1ed9t c\u1ed9t\u00a0<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/tinh-trung-binh-dong-trong-excel-bang-ham-average.html#Vi_du_3_Lay_trung_binh_dong_cho_N_gia_tri_cuoi_cung_trong_mot_hang\" title=\"V\u00ed d\u1ee5 3: L\u1ea5y trung b\u00ecnh \u0111\u1ed9ng cho N gi\u00e1 tr\u1ecb cu\u1ed1i c\u00f9ng trong m\u1ed9t h\u00e0ng\u00a0\">V\u00ed d\u1ee5 3: L\u1ea5y trung b\u00ecnh \u0111\u1ed9ng cho N gi\u00e1 tr\u1ecb cu\u1ed1i c\u00f9ng trong m\u1ed9t h\u00e0ng\u00a0<\/a><\/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\/tinh-trung-binh-dong-trong-excel-bang-ham-average.html#Tao_bieu_do_trung_binh_dong_trong_Excel\" title=\"T\u1ea1o bi\u1ec3u \u0111\u1ed3 trung b\u00ecnh \u0111\u1ed9ng trong Excel\u00a0\">T\u1ea1o bi\u1ec3u \u0111\u1ed3 trung b\u00ecnh \u0111\u1ed9ng trong Excel\u00a0<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Duong_trung_binh_la_gi\"><\/span><b>\u0110\u01b0\u1eddng trung b\u00ecnh l\u00e0 g\u00ec?\u00a0\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Trong m\u1ed9t v\u00e0i b\u00e0i vi\u1ebft g\u1ea7n \u0111\u00e2y, ch\u00fang ta \u0111\u00e3 xem x\u00e9t k\u1ef9 <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-3-cach-tinh-trung-binh-tren-excel-2010.html\"><strong>c\u00e1ch t\u00ednh trung b\u00ecnh trong Excel<\/strong><\/a>. N\u1ebfu b\u1ea1n \u0111ang theo d\u00f5i blog c\u1ee7a ch\u00fang ta, b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh b\u00ecnh th\u01b0\u1eddng v\u00e0 nh\u1eefng h\u00e0m n\u00e0o c\u1ea7n s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm \u0111\u01b0\u1eddng trung b\u00ecnh c\u00f3 tr\u1ecdng s\u1ed1. Trong h\u01b0\u1edbng d\u1eabn h\u00f4m nay, ch\u00fang ta s\u1ebd th\u1ea3o lu\u1eadn v\u1ec1 hai k\u1ef9 thu\u1eadt c\u01a1 b\u1ea3n \u0111\u1ec3 t\u00ednh to\u00e1n <strong>\u0111\u01b0\u1eddng trung b\u00ecnh trong Excel.<\/strong><\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u00f3i chung, \u0111\u01b0\u1eddng trung b\u00ecnh (c\u00f2n \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 <\/span><i><span style=\"font-weight: 400\">rolling average<\/span><\/i><span style=\"font-weight: 400\">, <\/span><i><span style=\"font-weight: 400\">running average<\/span><\/i><span style=\"font-weight: 400\"> ho\u1eb7c <\/span><i><span style=\"font-weight: 400\">moving mean<\/span><\/i><span style=\"font-weight: 400\">) c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c \u0111\u1ecbnh ngh\u0129a l\u00e0 m\u1ed9t lo\u1ea1t c\u00e1c gi\u00e1 tr\u1ecb trung b\u00ecnh cho c\u00e1c t\u1eadp h\u1ee3p con kh\u00e1c nhau c\u1ee7a c\u00f9ng m\u1ed9t t\u1eadp d\u1eef li\u1ec7u.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u00f3 th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong th\u1ed1ng k\u00ea, d\u1ef1 b\u00e1o th\u1eddi ti\u1ebft v\u00e0 kinh t\u1ebf \u0111\u01b0\u1ee3c \u0111i\u1ec1u ch\u1ec9nh theo m\u00f9a \u0111\u1ec3 hi\u1ec3u c\u00e1c xu h\u01b0\u1edbng ti\u1ec1m \u1ea9n. Trong giao d\u1ecbch ch\u1ee9ng kho\u00e1n, \u0111\u01b0\u1eddng trung b\u00ecnh \u0111\u1ed9ng l\u00e0 m\u1ed9t ch\u1ec9 s\u1ed1 th\u1ec3 hi\u1ec7n gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ee7a m\u1ed9t ch\u1ee9ng kho\u00e1n trong m\u1ed9t kho\u1ea3ng th\u1eddi gian nh\u1ea5t \u0111\u1ecbnh. Trong kinh doanh, m\u1ed9t th\u1ef1c t\u1ebf ph\u1ed5 bi\u1ebfn l\u00e0 t\u00ednh to\u00e1n \u0111\u01b0\u1eddng trung b\u00ecnh c\u1ee7a doanh s\u1ed1 b\u00e1n h\u00e0ng trong 3 th\u00e1ng g\u1ea7n nh\u1ea5t \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh xu h\u01b0\u1edbng g\u1ea7n \u0111\u00e2y.\u00a0<\/span><\/p>\n<figure id=\"attachment_34729\" aria-describedby=\"caption-attachment-34729\" style=\"width: 177px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34729 size-full\" title=\"1- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h1-11.png\" alt=\"1- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average\" width=\"177\" height=\"228\"><figcaption id=\"caption-attachment-34729\" class=\"wp-caption-text\">1- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5, trung b\u00ecnh \u0111\u1ed9ng c\u1ee7a nhi\u1ec7t \u0111\u1ed9 ba th\u00e1ng c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c t\u00ednh b\u1eb1ng c\u00e1ch l\u1ea5y trung b\u00ecnh c\u1ee7a nhi\u1ec7t \u0111\u1ed9 t\u1eeb th\u00e1ng 1 \u0111\u1ebfn th\u00e1ng 3, sau \u0111\u00f3 l\u00e0 trung b\u00ecnh c\u1ee7a nhi\u1ec7t \u0111\u1ed9 t\u1eeb th\u00e1ng 2 \u0111\u1ebfn th\u00e1ng 4, sau \u0111\u00f3 c\u1ee7a th\u00e1ng 3 \u0111\u1ebfn th\u00e1ng 5, v.v.\u00a0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">T\u1ed3n t\u1ea1i c\u00e1c lo\u1ea1i \u0111\u01b0\u1eddng trung b\u00ecnh kh\u00e1c nhau nh\u01b0 \u0111\u01a1n gi\u1ea3n (c\u00f2n \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 s\u1ed1 h\u1ecdc), h\u00e0m m\u0169, bi\u1ebfn, tam gi\u00e1c v\u00e0 tr\u1ecdng s\u1ed1. Trong h\u01b0\u1edbng d\u1eabn n\u00e0y, ch\u00fang ta s\u1ebd xem x\u00e9t \u0111\u01b0\u1eddng trung b\u00ecnh \u0111\u1ed9ng \u0111\u01a1n gi\u1ea3n \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn nh\u1ea5t.<\/span><\/p>\n<p><span style=\"font-weight: 400\">T\u00ednh to\u00e1n \u0111\u01b0\u1eddng trung b\u00ecnh \u0111\u1ed9ng \u0111\u01a1n gi\u1ea3n trong Excel\u00a0<\/span><\/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-216.gif\" title=\"ex101_92019-nho-216\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><span style=\"font-weight: 400\">Nh\u00ecn chung, c\u00f3 hai c\u00e1ch \u0111\u1ec3 t\u00ednh \u0111\u01b0\u1eddng trung b\u00ecnh \u0111\u1ed9ng \u0111\u01a1n gi\u1ea3n trong Excel \u2013 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c v\u00e0 t\u00f9y ch\u1ecdn \u0111\u01b0\u1eddng xu h\u01b0\u1edbng. C\u00e1c v\u00ed d\u1ee5 sau \u0111\u00e2y ch\u1ee9ng minh c\u1ea3 hai k\u1ef9 thu\u1eadt.\u00a0 M\u00ecnh c\u0169ng \u0111\u00e3 d\u00e0nh 2 b\u00e0i vi\u1ebft \u0111\u1ec1 c\u1eadp s\u00e2u h\u01a1n v\u1ec1 c\u00e1ch t\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel:<br \/>\n<\/span><\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-tinh-trung-binh-dong-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel ph\u1ea7n 1<\/a><\/strong><br \/>\n<strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-tinh-trung-binh-dong-trong-excel-2.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel ph\u1ea7n 2<\/a><\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Vi_du_1_Tinh_toan_duong_trung_binh_trong_mot_khoang_thoi_gian_nhat_dinh\"><\/span><b>V\u00ed d\u1ee5 1: T\u00ednh to\u00e1n \u0111\u01b0\u1eddng trung b\u00ecnh trong m\u1ed9t kho\u1ea3ng th\u1eddi gian nh\u1ea5t \u0111\u1ecbnh\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">M\u1ed9t \u0111\u01b0\u1eddng trung b\u00ecnh \u0111\u1ed9ng \u0111\u01a1n gi\u1ea3n c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n nhanh ch\u00f3ng v\u1edbi h\u00e0m AVERAGE. Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 danh s\u00e1ch nhi\u1ec7t \u0111\u1ed9 trung b\u00ecnh h\u00e0ng th\u00e1ng trong c\u1ed9t B v\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm trung b\u00ecnh \u0111\u1ed9ng trong 3 th\u00e1ng (nh\u01b0 trong h\u00ecnh tr\u00ean).\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">Vi\u1ebft c\u00f4ng th\u1ee9c AVERAGE th\u00f4ng th\u01b0\u1eddng cho 3 gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean v\u00e0 nh\u1eadp n\u00f3 v\u00e0o h\u00e0ng t\u01b0\u01a1ng \u1ee9ng v\u1edbi gi\u00e1 tr\u1ecb th\u1ee9 3 t\u1eeb tr\u00ean c\u00f9ng (\u00f4 C4 trong v\u00ed d\u1ee5 n\u00e0y), sau \u0111\u00f3 sao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c \u00f4 kh\u00e1c trong c\u1ed9t:<\/span><\/p>\n<p><b><i>=AVERAGE(B2:B4)<\/i><\/b><\/p>\n<p><span style=\"font-weight: 400\">B\u1ea1n c\u00f3 th\u1ec3 s\u1eeda c\u1ed9t b\u1eb1ng tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i (nh\u01b0 $B2) n\u1ebfu mu\u1ed1n, nh\u01b0ng h\u00e3y \u0111\u1ea3m b\u1ea3o s\u1eed d\u1ee5ng tham chi\u1ebfu h\u00e0ng t\u01b0\u01a1ng \u0111\u1ed1i (kh\u00f4ng c\u00f3 d\u1ea5u $) \u0111\u1ec3 c\u00f4ng th\u1ee9c \u0111i\u1ec1u ch\u1ec9nh \u0111\u00fang cho c\u00e1c \u00f4 kh\u00e1c. H\u00e3y nh\u1edb r\u1eb1ng trung b\u00ecnh \u0111\u01b0\u1ee3c t\u00ednh b\u1eb1ng c\u00e1ch c\u1ed9ng c\u00e1c gi\u00e1 tr\u1ecb r\u1ed3i chia t\u1ed5ng cho s\u1ed1 gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c t\u00ednh trung b\u00ecnh, b\u1ea1n c\u00f3 th\u1ec3 x\u00e1c minh k\u1ebft qu\u1ea3 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c\u00a0<\/span><\/p>\n<p><b><i>=SUM(B2:B4)\/3<\/i><\/b><\/p>\n<figure id=\"attachment_34730\" aria-describedby=\"caption-attachment-34730\" style=\"width: 382px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34730 size-full\" title=\"2- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h2-10.png\" alt=\"2- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average\" width=\"382\" height=\"263\"><figcaption id=\"caption-attachment-34730\" class=\"wp-caption-text\">2- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Vi_du_2_Lay_trung_binh_dong_cho_N_ngay_tuan_thang_nam_qua_trong_mot_cot\"><\/span><b>V\u00ed d\u1ee5 2: L\u1ea5y trung b\u00ecnh \u0111\u1ed9ng cho N ng\u00e0y\/ tu\u1ea7n\/ th\u00e1ng\/ n\u0103m qua trong m\u1ed9t c\u1ed9t\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch d\u1eef li\u1ec7u, v\u00ed d\u1ee5: s\u1ed1 li\u1ec7u b\u00e1n h\u00e0ng ho\u1eb7c b\u00e1o gi\u00e1 c\u1ed5 phi\u1ebfu v\u00e0 b\u1ea1n mu\u1ed1n bi\u1ebft m\u1ee9c trung b\u00ecnh c\u1ee7a 3 th\u00e1ng qua t\u1ea1i b\u1ea5t k\u1ef3 th\u1eddi \u0111i\u1ec3m n\u00e0o. \u0110\u1ed1i v\u1edbi \u0111i\u1ec1u n\u00e0y, b\u1ea1n c\u1ea7n m\u1ed9t c\u00f4ng th\u1ee9c s\u1ebd t\u00ednh l\u1ea1i gi\u00e1 tr\u1ecb trung b\u00ecnh ngay sau khi b\u1ea1n nh\u1eadp gi\u00e1 tr\u1ecb cho th\u00e1ng ti\u1ebfp theo. H\u00e0m Excel n\u00e0o c\u00f3 kh\u1ea3 n\u0103ng l\u00e0m \u0111i\u1ec1u n\u00e0y? AVERAGE c\u0169 k\u1ebft h\u1ee3p v\u1edbi OFFSET v\u00e0 COUNT.\u00a0\u00a0<\/span><\/p>\n<p><b><i>=AVERAGE(OFFSET(<\/i><\/b><b><i>first cell<\/i><\/b><b><i>, COUNT(<\/i><\/b><b><i>entire range<\/i><\/b><b><i>)-<\/i><\/b><b><i>N<\/i><\/b><b><i>,0,<\/i><\/b><b><i>N<\/i><\/b><b><i>,1))<\/i><\/b><\/p>\n<p><span style=\"font-weight: 400\">Trong \u0111\u00f3 N l\u00e0 s\u1ed1 ng\u00e0y\/ tu\u1ea7n\/ th\u00e1ng\/ n\u0103m qua \u0111\u1ec3 t\u00ednh v\u00e0o gi\u00e1 tr\u1ecb trung b\u00ecnh. B\u1ea1n kh\u00f4ng ch\u1eafc ch\u1eafn v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c trung b\u00ecnh \u0111\u1ed9ng n\u00e0y trong trang t\u00ednh Excel c\u1ee7a m\u00ecnh? V\u00ed d\u1ee5 sau s\u1ebd l\u00e0m cho m\u1ecdi th\u1ee9 r\u00f5 r\u00e0ng h\u01a1n.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed r\u1eb1ng c\u00e1c gi\u00e1 tr\u1ecb trung b\u00ecnh n\u1eb1m trong c\u1ed9t B b\u1eaft \u0111\u1ea7u t\u1eeb h\u00e0ng 2, c\u00f4ng th\u1ee9c s\u1ebd nh\u01b0 sau:\u00a0<\/span><\/p>\n<p><b><i>=AVERAGE(OFFSET(B2,COUNT(B2:B100)-3,0,3,1))<\/i><\/b><\/p>\n<figure id=\"attachment_34731\" aria-describedby=\"caption-attachment-34731\" style=\"width: 482px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34731 size-full\" title=\"3- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h3-10.png\" alt=\"3- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average\" width=\"482\" height=\"321\"><figcaption id=\"caption-attachment-34731\" class=\"wp-caption-text\">3- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">V\u00e0 b\u00e2y gi\u1edd, ch\u00fang ta h\u00e3y c\u1ed1 g\u1eafng hi\u1ec3u c\u00f4ng th\u1ee9c trung b\u00ecnh \u0111\u1ed9ng trong Excel n\u00e0y th\u1ef1c s\u1ef1 \u0111ang l\u00e0m g\u00ec.\u00a0\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">H\u00e0m COUNT h\u00e0m COUNT (B2: B100) \u0111\u1ebfm c\u00f3 bao nhi\u00eau gi\u00e1 tr\u1ecb \u0111\u00e3 \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o c\u1ed9t B. Ch\u00fang ta b\u1eaft \u0111\u1ea7u \u0111\u1ebfm trong B2 v\u00ec h\u00e0ng 1 l\u00e0 ti\u00eau \u0111\u1ec1 c\u1ed9t.\u00a0\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">H\u00e0m OFFSET l\u1ea5y \u00f4 B2 (tham s\u1ed1 th\u1ee9 nh\u1ea5t) l\u00e0m \u0111i\u1ec3m b\u1eaft \u0111\u1ea7u v\u00e0 b\u00f9 tr\u1eeb s\u1ed1 l\u01b0\u1ee3ng (gi\u00e1 tr\u1ecb do h\u00e0m COUNT tr\u1ea3 v\u1ec1) b\u1eb1ng c\u00e1ch di chuy\u1ec3n 3 h\u00e0ng l\u00ean tr\u00ean (-3 trong tham s\u1ed1 th\u1ee9 2). K\u1ebft qu\u1ea3 l\u00e0 n\u00f3 tr\u1ea3 v\u1ec1 t\u1ed5ng gi\u00e1 tr\u1ecb trong m\u1ed9t ph\u1ea1m vi bao g\u1ed3m 3 h\u00e0ng (3 trong tham s\u1ed1 th\u1ee9 4) v\u00e0 1 c\u1ed9t (1 trong \u0111\u1ed1i s\u1ed1 cu\u1ed1i c\u00f9ng), l\u00e0 3 th\u00e1ng g\u1ea7n nh\u1ea5t m\u00e0 ch\u00fang ta mu\u1ed1n.\u00a0\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Cu\u1ed1i c\u00f9ng, t\u1ed5ng tr\u1ea3 v\u1ec1 \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ebfn h\u00e0m AVERAGE \u0111\u1ec3 t\u00ednh to\u00e1n \u0111\u01b0\u1eddng trung b\u00ecnh.\u00a0\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">M\u1eb9o: N\u1ebfu b\u1ea1n \u0111ang l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c trang t\u00ednh c\u00f3 th\u1ec3 c\u1eadp nh\u1eadt li\u00ean t\u1ee5c trong \u0111\u00f3 c\u00e1c h\u00e0ng m\u1edbi c\u00f3 kh\u1ea3 n\u0103ng \u0111\u01b0\u1ee3c th\u00eam v\u00e0o trong t\u01b0\u01a1ng lai, h\u00e3y \u0111\u1ea3m b\u1ea3o cung c\u1ea5p \u0111\u1ee7 s\u1ed1 h\u00e0ng cho h\u00e0m COUNT \u0111\u1ec3 ch\u1ee9a c\u00e1c m\u1ee5c nh\u1eadp m\u1edbi ti\u1ec1m n\u0103ng. S\u1ebd kh\u00f4ng th\u00e0nh v\u1ea5n \u0111\u1ec1 n\u1ebfu b\u1ea1n bao g\u1ed3m nhi\u1ec1u h\u00e0ng h\u01a1n th\u1ef1c t\u1ebf c\u1ea7n thi\u1ebft mi\u1ec5n l\u00e0 b\u1ea1n c\u00f3 \u00f4 \u0111\u1ea7u ti\u00ean \u0111\u00fang, h\u00e0m COUNT s\u1ebd lo\u1ea1i b\u1ecf t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng tr\u1ed1ng.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadn th\u1ea5y, b\u1ea3ng trong v\u00ed d\u1ee5 n\u00e0y ch\u1ec9 ch\u1ee9a d\u1eef li\u1ec7u trong 12 th\u00e1ng, nh\u01b0ng ph\u1ea1m vi B2: B100 \u0111\u01b0\u1ee3c cung c\u1ea5p cho COUNT, ch\u1ec9 \u0111\u1ec3 \u1edf ph\u00eda l\u01b0u \ud83d\ude42<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Vi_du_3_Lay_trung_binh_dong_cho_N_gia_tri_cuoi_cung_trong_mot_hang\"><\/span><b>V\u00ed d\u1ee5 3: L\u1ea5y trung b\u00ecnh \u0111\u1ed9ng cho N gi\u00e1 tr\u1ecb cu\u1ed1i c\u00f9ng trong m\u1ed9t h\u00e0ng\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh \u0111\u1ed9ng cho N ng\u00e0y, th\u00e1ng, n\u0103m, v.v. g\u1ea7n nh\u1ea5t trong c\u00f9ng m\u1ed9t h\u00e0ng, b\u1ea1n c\u00f3 th\u1ec3 \u0111i\u1ec1u ch\u1ec9nh c\u00f4ng th\u1ee9c Offset theo c\u00e1ch n\u00e0y:\u00a0<\/span><\/p>\n<p><b><i>=AVERAGE(OFFSET(<\/i><\/b><b><i>first cell<\/i><\/b><b><i>,0,COUNT(<\/i><\/b><b><i>range<\/i><\/b><b><i>)<\/i><\/b><b><i>-N<\/i><\/b><b><i>,1,<\/i><\/b><b><i>N<\/i><\/b><b><i>,))<\/i><\/b><b><i>\u00a0<\/i><\/b><\/p>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed B2 l\u00e0 s\u1ed1 \u0111\u1ea7u ti\u00ean trong h\u00e0ng v\u00e0 b\u1ea1n mu\u1ed1n bao g\u1ed3m 3 s\u1ed1 cu\u1ed1i c\u00f9ng trong gi\u00e1 tr\u1ecb trung b\u00ecnh, c\u00f4ng th\u1ee9c s\u1ebd nh\u01b0 sau\u00a0 shape:\u00a0<\/span><\/p>\n<p><b><i>=AVERAGE(OFFSET(B2,0,COUNT(B2:N2)-3,1,3))<\/i><\/b><\/p>\n<figure id=\"attachment_34732\" aria-describedby=\"caption-attachment-34732\" style=\"width: 597px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34732 size-full\" title=\"4- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h4-11.png\" alt=\"4- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average\" width=\"597\" height=\"144\"><figcaption id=\"caption-attachment-34732\" class=\"wp-caption-text\">4- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Tao_bieu_do_trung_binh_dong_trong_Excel\"><\/span><b>T\u1ea1o bi\u1ec3u \u0111\u1ed3 trung b\u00ecnh \u0111\u1ed9ng trong Excel\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n \u0111\u00e3 t\u1ea1o bi\u1ec3u \u0111\u1ed3 cho d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh, vi\u1ec7c th\u00eam \u0111\u01b0\u1eddng xu h\u01b0\u1edbng trung b\u00ecnh \u0111\u1ed9ng cho bi\u1ec3u \u0111\u1ed3 \u0111\u00f3 ch\u1ec9 m\u1ea5t v\u00e0i gi\u00e2y. \u0110\u1ed1i v\u1edbi \u0111i\u1ec1u n\u00e0y, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng t\u00ednh n\u0103ng <\/span><b>Excel Trendline<\/b><span style=\"font-weight: 400\"> c\u1ee7a Excel v\u00e0 c\u00e1c b\u01b0\u1edbc chi ti\u1ebft theo sau.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ed1i v\u1edbi v\u00ed d\u1ee5 n\u00e0y, t\u00f4i \u0111\u00e3 t\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t 2-D (<\/span><i><span style=\"font-weight: 400\">Insert tab<\/span><\/i><span style=\"font-weight: 400\"> &gt; <\/span><i><span style=\"font-weight: 400\">Charts group<\/span><\/i><span style=\"font-weight: 400\">) cho d\u1eef li\u1ec7u b\u00e1n h\u00e0ng c\u1ee7a ch\u00fang ta:<\/span><\/p>\n<figure id=\"attachment_34734\" aria-describedby=\"caption-attachment-34734\" style=\"width: 629px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34734 size-full\" title=\"5- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h5-11.png\" alt=\"5- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average\" width=\"629\" height=\"220\"><figcaption id=\"caption-attachment-34734\" class=\"wp-caption-text\">5- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">V\u00e0 b\u00e2y gi\u1edd, ch\u00fang ta mu\u1ed1n \u201ch\u00ecnh dung\u201d \u0111\u01b0\u1eddng trung b\u00ecnh \u0111\u1ed9ng trong 3 th\u00e1ng.\u00a0\u00a0<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong Excel 2013, h\u00e3y ch\u1ecdn bi\u1ec3u \u0111\u1ed3, chuy\u1ec3n \u0111\u1ebfn tab <\/span><i><span style=\"font-weight: 400\">Design tab<\/span><\/i><span style=\"font-weight: 400\"> &gt; <\/span><i><span style=\"font-weight: 400\">Chart Layouts Group<\/span><\/i><span style=\"font-weight: 400\"> v\u00e0 nh\u1ea5p v\u00e0o <\/span><span style=\"font-weight: 400\">\u00a0<\/span><i><span style=\"font-weight: 400\">Add Chart Element <\/span><\/i><span style=\"font-weight: 400\">&gt; <\/span><i><span style=\"font-weight: 400\">Trendline<\/span><\/i><span style=\"font-weight: 400\"> &gt; <\/span><i><span style=\"font-weight: 400\">More Trendline Options<\/span><\/i><span style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u2026<\/span><\/span>\n<p><figure id=\"attachment_34733\" aria-describedby=\"caption-attachment-34733\" style=\"width: 329px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34733 size-full\" title=\"6- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h6-11.png\" alt=\"6- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average\" width=\"329\" height=\"540\"><figcaption id=\"caption-attachment-34733\" class=\"wp-caption-text\">6- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average<\/figcaption><\/figure>\n<\/p>\n<\/li>\n<\/ol>\n<p><span style=\"font-weight: 400\">Trong Excel 2010 v\u00e0 Excel 2007, \u0111i t\u1edbi <\/span><i><span style=\"font-weight: 400\">Layout<\/span><\/i><span style=\"font-weight: 400\"> &gt; <\/span><i><span style=\"font-weight: 400\">Trendline<\/span><\/i><span style=\"font-weight: 400\"> &gt; <\/span><i><span style=\"font-weight: 400\">More Trendline Options<\/span><\/i><span style=\"font-weight: 400\">.<\/span><\/p>\n<p><span style=\"font-weight: 400\">M\u1eb9o: N\u1ebfu b\u1ea1n kh\u00f4ng c\u1ea7n ch\u1ec9 \u0111\u1ecbnh c\u00e1c chi ti\u1ebft nh\u01b0 kho\u1ea3ng th\u1eddi gian ho\u1eb7c t\u00ean c\u1ee7a \u0111\u01b0\u1eddng trung b\u00ecnh, b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5p v\u00e0o <\/span><i><span style=\"font-weight: 400\">Design<\/span><\/i><span style=\"font-weight: 400\"> &gt; <\/span><i><span style=\"font-weight: 400\">Add Chart Element<\/span><\/i><span style=\"font-weight: 400\"> &gt; <\/span><i><span style=\"font-weight: 400\">Trendline<\/span><\/i><span style=\"font-weight: 400\"> &gt; <\/span><i><span style=\"font-weight: 400\">Moving Average<\/span><\/i><span style=\"font-weight: 400\"> \u0111\u1ec3 c\u00f3 k\u1ebft qu\u1ea3 ngay l\u1eadp t\u1ee9c.\u00a0\u00a0<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Ng\u0103n <\/span><i><span style=\"font-weight: 400\">Format Trendline<\/span><\/i><span style=\"font-weight: 400\"> s\u1ebd m\u1edf \u1edf b\u00ean ph\u1ea3i trang t\u00ednh c\u1ee7a b\u1ea1n trong Excel 2013 v\u00e0 h\u1ed9p tho\u1ea1i t\u01b0\u01a1ng \u1ee9ng s\u1ebd b\u1eadt l\u00ean trong Excel 2010 v\u00e0 2007.\u00a0<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400\">Tr\u00ean ng\u0103n <\/span><i><span style=\"font-weight: 400\">Format Trendline<\/span><\/i><span style=\"font-weight: 400\">, b\u1ea1n b\u1ea5m v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng <\/span><span style=\"font-weight: 400\">Trendline Options<\/span><span style=\"font-weight: 400\">, ch\u1ecdn <\/span><b>Moving Average<\/b><span style=\"font-weight: 400\"> v\u00e0 ch\u1ec9 \u0111\u1ecbnh kho\u1ea3ng th\u1eddi gian trung b\u00ecnh \u0111\u1ed9ng trong h\u1ed9p <\/span><b>Period<\/b><span style=\"font-weight: 400\">:<\/span><\/p>\n<figure id=\"attachment_34735\" aria-describedby=\"caption-attachment-34735\" style=\"width: 275px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34735 size-full\" title=\"7- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h7-10.png\" alt=\"7- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average\" width=\"275\" height=\"360\"><figcaption id=\"caption-attachment-34735\" class=\"wp-caption-text\">7- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average<\/figcaption><\/figure>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u0110\u00f3ng ng\u0103n <\/span><span style=\"font-weight: 400\">Trendline<\/span><span style=\"font-weight: 400\"><span style=\"font-weight: 400\"> v\u00e0 b\u1ea1n s\u1ebd th\u1ea5y \u0111\u01b0\u1eddng xu h\u01b0\u1edbng trung b\u00ecnh \u0111\u1ed9ng \u0111\u01b0\u1ee3c th\u00eam v\u00e0o bi\u1ec3u \u0111\u1ed3 c\u1ee7a b\u1ea1n:<\/span><\/span>\n<p><figure id=\"attachment_34736\" aria-describedby=\"caption-attachment-34736\" style=\"width: 635px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34736 size-full\" title=\"8- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h8-10.png\" alt=\"8- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average\" width=\"635\" height=\"235\"><figcaption id=\"caption-attachment-34736\" class=\"wp-caption-text\">8- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average<\/figcaption><\/figure>\n<\/p>\n<\/li>\n<\/ol>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 tinh ch\u1ec9nh bi\u1ec3u \u0111\u1ed3 c\u1ee7a m\u00ecnh, b\u1ea1n c\u00f3 th\u1ec3 chuy\u1ec3n sang tab<\/span> <i><span style=\"font-weight: 400\">Fill &amp; Line<\/span><\/i><span style=\"font-weight: 400\"> or <\/span><i><span style=\"font-weight: 400\">Effects<\/span><\/i><span style=\"font-weight: 400\"> tr\u00ean ng\u0103n <\/span><i><span style=\"font-weight: 400\">Format Trendline<\/span><\/i><span style=\"font-weight: 400\"> v\u00e0 l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c t\u00f9y ch\u1ecdn kh\u00e1c nhau nh\u01b0 lo\u1ea1i \u0111\u01b0\u1eddng, m\u00e0u s\u1eafc, chi\u1ec1u r\u1ed9ng, v.v.<\/span><\/p>\n<figure id=\"attachment_34737\" aria-describedby=\"caption-attachment-34737\" style=\"width: 621px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34737 size-full\" title=\"9- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h9-9.png\" alt=\"9- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average\" width=\"621\" height=\"576\"><figcaption id=\"caption-attachment-34737\" class=\"wp-caption-text\">9- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 ph\u00e2n t\u00edch d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n th\u00eam m\u1ed9t v\u00e0i \u0111\u01b0\u1eddng xu h\u01b0\u1edbng trung b\u00ecnh \u0111\u1ed9ng v\u1edbi c\u00e1c kho\u1ea3ng th\u1eddi gian kh\u00e1c nhau \u0111\u1ec3 xem xu h\u01b0\u1edbng ph\u00e1t tri\u1ec3n nh\u01b0 th\u1ebf n\u00e0o. H\u00ecnh sau \u0111\u00e2y cho th\u1ea5y c\u00e1c \u0111\u01b0\u1eddng xu h\u01b0\u1edbng trung b\u00ecnh \u0111\u1ed9ng 2 th\u00e1ng (xanh l\u1ee5c) v\u00e0 3 th\u00e1ng (\u0111\u1ecf g\u1ea1ch):<\/span><\/p>\n<figure id=\"attachment_34738\" aria-describedby=\"caption-attachment-34738\" style=\"width: 623px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34738 size-full\" title=\"10- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/h10-8.png\" alt=\"10- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average\" width=\"623\" height=\"343\"><figcaption id=\"caption-attachment-34738\" class=\"wp-caption-text\">10- T\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m average<\/figcaption><\/figure>\n<p><em><span style=\"font-weight: 400\">\u0110\u00f3 l\u00e0 t\u1ea5t c\u1ea3 v\u1ec1 <strong>t\u00ednh to\u00e1n trung b\u00ecnh \u0111\u1ed9ng trong Excel b\u1eb1ng h\u00e0m Average<\/strong><\/span><span style=\"font-weight: 400\">. T\u00f4i c\u1ea3m \u01a1n b\u1ea1n \u0111\u00e3 \u0111\u1ecdc v\u00e0 mong \u0111\u01b0\u1ee3c g\u1eb7p b\u1ea1n v\u00e0o tu\u1ea7n sau v\u1edbi nh\u1eefng b\u00e0i vi\u1ebft l\u00fd th\u00fa t\u1eeb <strong>H\u1ecdc Excel Online<\/strong><\/span><\/em><\/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-216.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2810,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2809","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\/2809","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=2809"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2809\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2810"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2809"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2809"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2809"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}