{"id":11230,"date":"2025-01-15T02:09:18","date_gmt":"2025-01-15T02:09:18","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cac-ham-tinh-moi-trong-excel-2016\/"},"modified":"2025-01-15T02:09:18","modified_gmt":"2025-01-15T02:09:18","slug":"cac-ham-tinh-moi-trong-excel-2016","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cac-ham-tinh-moi-trong-excel-2016\/","title":{"rendered":"C\u00c1C H\u00c0M T\u00cdNH M\u1edaI TRONG EXCEL 2016"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong Excel 2016, Microsoft \u0111\u00e3 gi\u1edbi thi\u1ec7u v\u1edbi ch\u00fang ta m\u1ed9t s\u1ed1 h\u00e0m t\u00ednh m\u1edbi. L\u01b0u \u00fd r\u1eebng c\u00e1c h\u00e0m n\u00e0y kh\u00f4ng \u00e1p d\u1ee5ng v\u1edbi phi\u00ean b\u1ea3n Excel 2016 d\u00f9ng cho Mac.<\/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-678718ce03d48\" 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\/cac-ham-tinh-moi-trong-excel-2016.html#TEXT_FUNCTIONS-_NHOM_HAM_XU_LY_VAN_BAN\" title=\"TEXT FUNCTIONS- NH\u00d3M H\u00c0M X\u1eec L\u00dd V\u0102N B\u1ea2N\">TEXT FUNCTIONS- NH\u00d3M H\u00c0M X\u1eec L\u00dd V\u0102N B\u1ea2N<\/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\/cac-ham-tinh-moi-trong-excel-2016.html#Ham_CONCAT\" title=\"H\u00e0m CONCAT\">H\u00e0m CONCAT<\/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\/cac-ham-tinh-moi-trong-excel-2016.html#Ham_TEXT_JOIN\" title=\"H\u00e0m TEXT JOIN\">H\u00e0m TEXT JOIN<\/a><\/li>\n<\/ul>\n<\/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\/cac-ham-tinh-moi-trong-excel-2016.html#LOGICAL_FUNCTIONS-_NHOM_HAM_LOGIC\" title=\"LOGICAL FUNCTIONS- NH\u00d3M H\u00c0M LOGIC\">LOGICAL FUNCTIONS- NH\u00d3M H\u00c0M LOGIC<\/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-5\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-tinh-moi-trong-excel-2016.html#Ham_IFS\" title=\"H\u00e0m IFS\">H\u00e0m IFS<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-tinh-moi-trong-excel-2016.html#Ham_SWITCH\" title=\"H\u00e0m SWITCH\">H\u00e0m SWITCH<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-tinh-moi-trong-excel-2016.html#STATISTICAL_FUNCTION_%E2%80%93_HAM_XAC_SUAT_THONG_KE\" title=\"STATISTICAL FUNCTION \u2013 H\u00c0M X\u00c1C SU\u1ea4T TH\u1ed0NG K\u00ca\">STATISTICAL FUNCTION \u2013 H\u00c0M X\u00c1C SU\u1ea4T TH\u1ed0NG K\u00ca<\/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-8\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-tinh-moi-trong-excel-2016.html#Ham_FORCASTETS\" title=\"H\u00e0m FORCAST.ETS\">H\u00e0m FORCAST.ETS<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-tinh-moi-trong-excel-2016.html#Ham_FORECASTETSCONFINT\" title=\"H\u00e0m FORECAST.ETS.CONFINT\">H\u00e0m FORECAST.ETS.CONFINT<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-tinh-moi-trong-excel-2016.html#Ham_FORECASTETSSEASONALITY\" title=\"H\u00e0m FORECAST.ETS.SEASONALITY\">H\u00e0m FORECAST.ETS.SEASONALITY<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-tinh-moi-trong-excel-2016.html#Ham_FORECASTETSSTAT\" title=\"H\u00e0m FORECAST.ETS.STAT\">H\u00e0m FORECAST.ETS.STAT<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-tinh-moi-trong-excel-2016.html#Ham_FORCASTLINEAR\" title=\"H\u00e0m FORCAST.LINEAR\">H\u00e0m FORCAST.LINEAR<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-tinh-moi-trong-excel-2016.html#Ham_MAXIFS\" title=\"H\u00e0m MAXIFS\">H\u00e0m MAXIFS<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: left\"><span class=\"ez-toc-section\" id=\"TEXT_FUNCTIONS-_NHOM_HAM_XU_LY_VAN_BAN\"><\/span><strong>TEXT FUNCTIONS- NH\u00d3M H\u00c0M X\u1eec L\u00dd V\u0102N B\u1ea2N<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3 style=\"text-align: left\"><span class=\"ez-toc-section\" id=\"Ham_CONCAT\"><\/span>H\u00e0m CONCAT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: left\">N\u1ed1i hai hay nhi\u1ec1u c\u00e1c chu\u1ed7i k\u00fd t\u1ef1 l\u1ea1i v\u1edbi nhau<\/p>\n<p style=\"text-align: left\"><em>V\u00ed d\u1ee5 minh h\u1ecda:<\/em><\/p>\n<p style=\"text-align: left\">Trong b\u1ea3ng t\u00ednh d\u01b0\u1edbi \u0111\u00e2y , c\u00e1c chu\u1ed7i k\u00fd t\u1ef1 trong \u00f4 A1, B1, C1 c\u00f3 th\u1ec3 n\u1ed1i v\u1edbi nhau b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m CONCAT nh\u01b0 sau:<\/p>\n<table class=\" alignleft\" style=\"width: 600px\">\n<tbody>\n<tr style=\"height: 24px\">\n<td style=\"width: 66px;height: 24px\"><\/td>\n<td style=\"width: 166px;text-align: center;height: 24px\"><strong>A<\/strong><\/td>\n<td style=\"width: 166px;text-align: center;height: 24px\"><strong>B<\/strong><\/td>\n<td style=\"width: 174px;text-align: center;height: 24px\"><strong>C<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 66px;text-align: center;height: 24px\"><strong>1<\/strong><\/td>\n<td style=\"width: 166px;height: 24px\">C:<\/td>\n<td style=\"width: 166px;height: 24px\">Users<\/td>\n<td style=\"width: 174px;height: 24px\">Jeff<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: left\">=CONCAT (A1:C1)<\/p>\n<p style=\"text-align: left\">V\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 C:UsersJeft<\/p>\n<h3 style=\"text-align: left\"><span class=\"ez-toc-section\" id=\"Ham_TEXT_JOIN\"><\/span>H\u00e0m TEXT JOIN<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: left\">N\u1ed1i hai hay nhi\u1ec1u chu\u1ed7i k\u00fd t\u1ef1 l\u1ea1i v\u1edbi nhau v\u00e0 \u0111\u01b0\u1ee3c ph\u00e2n c\u00e1ch b\u1edfi d\u1ea5u g\u1ea1ch ch\u00e9o<\/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-272.gif\" title=\"ex101_92019-nho-272\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: left\"><em>V\u00ed d\u1ee5 minh h\u1ecda:<\/em><\/p>\n<p style=\"text-align: left\">Trong b\u1ea3ng t\u00ednh d\u01b0\u1edbi \u0111\u00e2y, c\u00e1c chu\u1ed7i k\u00fd t\u1ef1 trong \u00f4 A1, B1, C1 c\u00f3 th\u1ec3 n\u1ed1i v\u1edbi nhau, \u0111\u01b0\u1ee3c ph\u00e2n c\u00e1ch b\u1edfi d\u1ea5u g\u1ea1ch ch\u00e9o\u00a0 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TEXT JOIN\u00a0 nh\u01b0 sau:<\/p>\n<table class=\" alignleft\" style=\"width: 600px\">\n<tbody>\n<tr style=\"height: 24px\">\n<td style=\"width: 64px;height: 24px\"><\/td>\n<td style=\"width: 194px;height: 24px;text-align: center\"><strong>A<\/strong><\/td>\n<td style=\"width: 184px;height: 24px;text-align: center\"><strong>B<\/strong><\/td>\n<td style=\"width: 176px;height: 24px;text-align: center\"><strong>C<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 64px;height: 24px;text-align: center\"><strong>1<\/strong><\/td>\n<td style=\"width: 194px;height: 24px\">C:<\/td>\n<td style=\"width: 184px;height: 24px\">Users<\/td>\n<td style=\"width: 176px;height: 24px\">Jeff<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: left\">=TEXTJOIN( \u201c\u201d, TRUE, A1:C1 )<\/p>\n<p style=\"text-align: left\">V\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 C:UsersJeff<\/p>\n<h2 style=\"text-align: left\"><span class=\"ez-toc-section\" id=\"LOGICAL_FUNCTIONS-_NHOM_HAM_LOGIC\"><\/span><strong>LOGICAL FUNCTIONS- NH\u00d3M H\u00c0M LOGIC<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3 style=\"text-align: left\"><span class=\"ez-toc-section\" id=\"Ham_IFS\"><\/span>H\u00e0m IFS<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: left\">Ki\u1ec3m tra c\u00e1c \u0111i\u1ec1u ki\u1ec7n c\u00f3 \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng kh\u00f4ng v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u1ee9ng v\u1edbi \u0111i\u1ec1u ki\u1ec7n TRUE \u0111\u1ea7u ti\u00ean<\/p>\n<p style=\"text-align: left\"><em>V\u00ed d\u1ee5 minh h\u1ecda:<\/em><\/p>\n<p style=\"text-align: left\">Trong b\u1ea3ng t\u00ednh d\u01b0\u1edbi \u0111\u00e2y, h\u00e0m IFS \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng khi chia gi\u00e1 tr\u1ecb \u1edf \u00f4 A1 v\u1edbi gi\u00e1 tr\u1ecb kh\u00e1c kh\u00f4ng \u0111\u1ea7u ti\u00ean trong \u00f4 B1-C1:<\/p>\n<table class=\" alignleft\" style=\"width: 601px\">\n<tbody>\n<tr style=\"height: 24px\">\n<td style=\"width: 57px;height: 24px\"><\/td>\n<td style=\"width: 201px;text-align: center;height: 24px\"><strong>A<\/strong><\/td>\n<td style=\"width: 192px;text-align: center;height: 24px\"><strong>B<\/strong><\/td>\n<td style=\"width: 178px;text-align: center;height: 24px\"><strong>C<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 57px;text-align: center;height: 24px\"><strong>1<\/strong><\/td>\n<td style=\"width: 201px;height: 24px;text-align: right\">20<\/td>\n<td style=\"width: 192px;height: 24px;text-align: right\">0<\/td>\n<td style=\"width: 178px;height: 24px;text-align: right\">2<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: left\">=IFS( B1&lt;&gt;0, A1\/B1, C1&lt;&gt;0, A1\/C1 )<\/p>\n<p style=\"text-align: left\">K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 10<\/p>\n<p style=\"text-align: left\">(gi\u00e1 tr\u1ecb trong \u00f4 A1 chia cho gi\u00e1 tr\u1ecb trong \u00f4 C1)<\/p>\n<h3 style=\"text-align: left\"><span class=\"ez-toc-section\" id=\"Ham_SWITCH\"><\/span>H\u00e0m SWITCH<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: left\">Ki\u1ec3m tra c\u00e1c gi\u00e1 tr\u1ecb \u1ee9ng v\u1edbi m\u1ed9t bi\u1ec3u th\u1ee9c cho tr\u01b0\u1edbc v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb kh\u1edbp \u0111\u1ea7u ti\u00ean.<\/p>\n<p style=\"text-align: left\"><em>V\u00ed d\u1ee5 minh h\u1ecda:<\/em><\/p>\n<p style=\"text-align: left\">Trong b\u1ea3ng t\u00ednh d\u01b0\u1edbi \u0111\u00e2y, h\u00e0m SWITCH \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ra m\u00f9a \u1ee9ng v\u1edbi con s\u1ed1 trong \u00f4 A1<\/p>\n<table class=\" alignleft\" style=\"width: 432px\">\n<tbody>\n<tr>\n<td style=\"width: 57px\"><\/td>\n<td style=\"width: 200px;text-align: center\"><strong>A<\/strong><\/td>\n<td style=\"width: 195px;text-align: center\"><strong>B<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 57px;text-align: center\"><strong>1<\/strong><\/td>\n<td style=\"width: 200px;text-align: right\">2<\/td>\n<td style=\"width: 195px\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: left\">=SWITCH( A1, 1, \u201cSpring\u201d, 2, \u201cSummer\u201d, 3, \u201cAutumn\u201d, 4, \u201cWinter\u201d )<\/p>\n<p style=\"text-align: left\">K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 : Summer<\/p>\n<blockquote>\n<p style=\"text-align: left\">Xem ngay: <a href=\"http:\/\/blog.ezworkapp.com\/tag\/cac-ham-co-ban-trong-excel\">C\u00e1c h\u00e0m th\u01b0\u1eddng d\u00f9ng trong Excel<\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: left\"><span class=\"ez-toc-section\" id=\"STATISTICAL_FUNCTION_%E2%80%93_HAM_XAC_SUAT_THONG_KE\"><\/span><strong>STATISTICAL FUNCTION \u2013 H\u00c0M X\u00c1C SU\u1ea4T TH\u1ed0NG K\u00ca<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3 style=\"text-align: left\"><span class=\"ez-toc-section\" id=\"Ham_FORCASTETS\"><\/span>H\u00e0m FORCAST.ETS<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: left\">D\u1ef1 \u0111o\u00e1n gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai tr\u00ean d\u00f2ng th\u1edbi gian, d\u1ef1a tr\u00ean c\u00e1c gi\u00e1 tr\u1ecb hi\u1ec7n c\u00f3 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng thu\u1eadt to\u00e1n L\u00e0m nh\u1eb5n h\u00e0m m\u0169<\/p>\n<p style=\"text-align: left\"><em>V\u00ed d\u1ee5 minh h\u1ecda:<\/em><\/p>\n<p style=\"text-align: left\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 b\u1ea3ng thu nh\u1eadp h\u00e0ng th\u00e1ng, h\u00e0m Forecast.Ets\u00a0 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 d\u1ef1 \u0111o\u00e1n thu nh\u1eadp c\u1ee7a th\u00e1ng ti\u1ebfp theo nh\u01b0 sau:<\/p>\n<p style=\"text-align: left\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-8551 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/forecast_ets_function_example.png\" width=\"579\" height=\"243\" title=\"forecast_ets_function_example\"><\/p>\n<h3 style=\"text-align: left\"><span class=\"ez-toc-section\" id=\"Ham_FORECASTETSCONFINT\"><\/span>H\u00e0m FORECAST.ETS.CONFINT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: left\">Tr\u1ea3 v\u1ec1 kho\u1ea3ng tin c\u1eady cho gi\u00e1 tr\u1ecb d\u1ef1 b\u00e1o t\u1ea1i m\u1ed9t ng\u00e0y \u0111\u00edch c\u1ee5 th\u1ec3.<\/p>\n<p style=\"text-align: left\"><em>V\u00ed d\u1ee5 minh h\u1ecda:<\/em><\/p>\n<p style=\"text-align: left\">B\u1ea3ng t\u00ednh d\u01b0\u1edbi \u0111\u00e2y l\u00e0 thu nh\u1eadp h\u00e0ng th\u00e1ng t\u1eeb th\u00e1ng 8\/2016 \u0111\u1ebfn th\u00e1ng 4\/2017. H\u00e0m Forecast.Ets \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng trong \u00f4 G11 \u0111\u1ec3 d\u1ef1 \u0111o\u00e1n thu nh\u1eadp th\u00e1ng 5\/2017<\/p>\n<p style=\"text-align: left\">\u00c1p d\u1ee5ng h\u00e0m Forecast.Ets.Confint trong \u00f4 C13 \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh kho\u1ea3ng tin c\u1eady cho nh\u1eefng gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c d\u1ef1 \u0111o\u00e1n<\/p>\n<p style=\"text-align: left\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-8553 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/forecast_ets_confint_function_example.png\" width=\"579\" height=\"286\" title=\"forecast_ets_confint_function_example\"><\/p>\n<h3 style=\"text-align: left\"><span class=\"ez-toc-section\" id=\"Ham_FORECASTETSSEASONALITY\"><\/span>H\u00e0m FORECAST.ETS.SEASONALITY<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: left\">Tr\u1ea3 v\u1ec1 \u0111\u1ed9 d\u00e0i c\u1ee7a m\u1eabu h\u00ecnh l\u1eb7p \u0111i l\u1eb7p la\u0323i ma\u0300 Excel ph\u00e1t hi\u1ec7n \u0111\u1ed1i v\u1edbi chu\u1ed7i th\u01a1\u0300i gian c\u1ee5 th\u1ec3.<\/p>\n<p style=\"text-align: left\"><em>V\u00ed d\u1ee5 minh h\u1ecda:<\/em><\/p>\n<p style=\"text-align: left\">V\u1edbi b\u1ea3ng th\u1ed1ng k\u00ea thu nh\u1eadp t\u1eebng th\u00e1ng, h\u00e0m Forecast.Ets.Seasonality \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 ph\u00e1t hi\u1ec7n \u0111\u1ed9 d\u00e0i c\u1ee7a m\u1eabu h\u00ecnh theo th\u1eddi v\u1ee5 nh\u01b0 sau:<\/p>\n<p style=\"text-align: left\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-8554 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/forecast_ets_seasonality_function_example.png\" width=\"441\" height=\"281\" title=\"forecast_ets_seasonality_function_example\"><\/p>\n<h3 style=\"text-align: left\"><span class=\"ez-toc-section\" id=\"Ham_FORECASTETSSTAT\"><\/span>H\u00e0m FORECAST.ETS.STAT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: left\">Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb th\u1ed1ng k\u00ea c\u1ee7a chu\u1ed7i th\u1eddi gian d\u1ef1 b\u00e1o<\/p>\n<p style=\"text-align: left\"><em>V\u00ed d\u1ee5 minh h\u1ecda:<\/em><\/p>\n<p style=\"text-align: left\">B\u1ea3ng t\u00ednh d\u01b0\u1edbi \u0111\u00e2y l\u00e0 thu nh\u1eadp h\u00e0ng th\u00e1ng t\u1eeb th\u00e1ng 8\/2016 \u0111\u1ebfn th\u00e1ng 4\/2017. H\u00e0m Forecast.Ets \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng trong \u00f4 G11 \u0111\u1ec3 d\u1ef1 \u0111o\u00e1n thu nh\u1eadp th\u00e1ng 5\/2017<\/p>\n<p style=\"text-align: left\">H\u00e0m Forecast.Ets.Stat \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong \u00f4 C13 \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh tham s\u1ed1 Alpha c\u1ee7a thu\u1eadt to\u00e1n ETS<\/p>\n<p style=\"text-align: left\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-8555 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/forecast_ets_stat_function_example.png\" width=\"579\" height=\"284\" title=\"forecast_ets_stat_function_example\"><\/p>\n<h3 style=\"text-align: left\"><span class=\"ez-toc-section\" id=\"Ham_FORCASTLINEAR\"><\/span>H\u00e0m FORCAST.LINEAR<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: left\">D\u1ef1 \u0111o\u00e1n m\u1ed9t gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai tr\u00ean \u0111\u01b0\u1eddng xu h\u01b0\u1edbng tuy\u1ebfn t\u00ednh d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb x v\u00e0 y c\u00f3 s\u1eb5n.<\/p>\n<p style=\"text-align: left\"><em>V\u00ed d\u1ee5 minh h\u1ecda:<\/em><\/p>\n<p style=\"text-align: left\">Trong b\u1ea3ng t\u00ednh d\u01b0\u1edbi \u0111\u00e2y, h\u00e0m Forecast.Linear \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 d\u1ef1 \u0111o\u00e1n gi\u00e1 tr\u1ecb tr\u00ean \u0111\u01b0\u1eddng xu h\u01b0\u1edbng th\u00f4ng qua c\u00e1c gi\u00e1 tr\u1ecb x v\u00e0 y hi\u1ec7n c\u00f3 t\u1eeb F2-G7 t\u1ea1i x=7<\/p>\n<p style=\"text-align: left\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-8556 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/forecast_linear_function_example.png\" width=\"579\" height=\"222\" title=\"forecast_linear_function_example\"><\/p>\n<blockquote>\n<p style=\"text-align: left\">\u0110\u1eebng b\u1ecf qua: t\u00e0i li\u1ec7u\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/hoc-excel-2016\">h\u1ecdc Excel 2016<\/a><\/p>\n<\/blockquote>\n<h3 style=\"text-align: left\"><span class=\"ez-toc-section\" id=\"Ham_MAXIFS\"><\/span>H\u00e0m MAXIFS<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: left\">Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t t\u1eeb m\u1ed9t t\u1eadp h\u1ee3p c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh b\u1edfi m\u1ed9t hay nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n.<\/p>\n<p style=\"text-align: left\"><em>V\u00ed d\u1ee5 minh h\u1ecda:<\/em><\/p>\n<p style=\"text-align: left\">Trong b\u1ea3ng t\u00ednh d\u01b0\u1edbi \u0111\u00e2y, \u0111i\u1ec3m ki\u1ec3m tra cao nh\u1ea5t c\u1ee7a Group 1 \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m\u00a0 Maxifs nh\u01b0 sau:<\/p>\n<table class=\" alignleft\" style=\"width: 600px\">\n<tbody>\n<tr style=\"height: 24px\">\n<td style=\"width: 63px;height: 24px\"><\/td>\n<td style=\"width: 166px;height: 24px;text-align: center\"><strong>A<\/strong><\/td>\n<td style=\"width: 175px;height: 24px;text-align: center\"><strong>B<\/strong><\/td>\n<td style=\"width: 179px;height: 24px;text-align: center\"><strong>C<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 63px;height: 24px;text-align: center\"><strong>1<\/strong><\/td>\n<td style=\"width: 166px;height: 24px\"><strong>Student<\/strong><\/td>\n<td style=\"width: 175px;height: 24px\"><strong>Group<\/strong><\/td>\n<td style=\"width: 179px;height: 24px\"><strong>Score<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 63px;height: 24px;text-align: center\"><strong>2<\/strong><\/td>\n<td style=\"width: 166px;height: 24px\">Jane<\/td>\n<td style=\"width: 175px;height: 24px;text-align: right\">1<\/td>\n<td style=\"width: 179px;height: 24px;text-align: right\">57%<\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 63px;height: 24px;text-align: center\"><strong>3<\/strong><\/td>\n<td style=\"width: 166px;height: 24px\">Lucy<\/td>\n<td style=\"width: 175px;height: 24px;text-align: right\">2<\/td>\n<td style=\"width: 179px;height: 24px;text-align: right\">87%<\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 63px;height: 24px;text-align: center\"><strong>4<\/strong><\/td>\n<td style=\"width: 166px;height: 24px\">James<\/td>\n<td style=\"width: 175px;height: 24px;text-align: right\">2<\/td>\n<td style=\"width: 179px;height: 24px;text-align: right\">75%<\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 63px;height: 24px;text-align: center\"><strong>5<\/strong><\/td>\n<td style=\"width: 166px;height: 24px\">Kevin<\/td>\n<td style=\"width: 175px;height: 24px;text-align: right\">1<\/td>\n<td style=\"width: 179px;height: 24px;text-align: right\">41%<\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 63px;height: 24px;text-align: center\"><strong>6<\/strong><\/td>\n<td style=\"width: 166px;height: 24px\">Joseph<\/td>\n<td style=\"width: 175px;height: 24px;text-align: right\">1<\/td>\n<td style=\"width: 179px;height: 24px;text-align: right\">77%<\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 63px;height: 24px;text-align: center\"><strong>7<\/strong><\/td>\n<td style=\"width: 166px;height: 24px\">Emma<\/td>\n<td style=\"width: 175px;height: 24px;text-align: right\">1<\/td>\n<td style=\"width: 179px;height: 24px;text-align: right\">69%<\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 63px;height: 24px;text-align: center\"><strong>8<\/strong><\/td>\n<td style=\"width: 166px;height: 24px\">Alice<\/td>\n<td style=\"width: 175px;height: 24px;text-align: right\">2<\/td>\n<td style=\"width: 179px;height: 24px;text-align: right\">89%<\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 63px;height: 24px;text-align: center\"><strong>9<\/strong><\/td>\n<td style=\"width: 166px;height: 24px\">Graham<\/td>\n<td style=\"width: 175px;height: 24px;text-align: right\">2<\/td>\n<td style=\"width: 179px;height: 24px;text-align: right\">73%<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: left\">=MAXIFS( C2:C9, B2:B9, 1 )<\/p>\n<p style=\"text-align: left\">K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 77%<\/p>\n<p style=\"text-align: left\">H\u00e0m MINIFS<\/p>\n<p style=\"text-align: left\">Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t t\u1eeb m\u1ed9t t\u1eadp h\u1ee3p c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh b\u1edfi m\u1ed9t hay nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n.<\/p>\n<p style=\"text-align: left\"><em>V\u00ed d\u1ee5 minh h\u1ecda:<\/em><\/p>\n<p style=\"text-align: left\">Trong b\u1ea3ng t\u00ednh d\u01b0\u1edbi \u0111\u00e2y, \u0111i\u1ec3m ki\u1ec3m tra th\u1ea5p nh\u1ea5t c\u1ee7a Group 2 \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m\u00a0 Minifs nh\u01b0 sau:<\/p>\n<table class=\" alignleft\" style=\"width: 596px\">\n<tbody>\n<tr>\n<td style=\"width: 62px\"><\/td>\n<td style=\"width: 160px;text-align: center\"><strong>A<\/strong><\/td>\n<td style=\"width: 178px;text-align: center\"><strong>B<\/strong><\/td>\n<td style=\"width: 172px;text-align: center\"><strong>C<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 62px;text-align: center\"><strong>1<\/strong><\/td>\n<td style=\"width: 160px\"><strong>Student<\/strong><\/td>\n<td style=\"width: 178px\"><strong>Group<\/strong><\/td>\n<td style=\"width: 172px\"><strong>Score<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 62px;text-align: center\"><strong>2<\/strong><\/td>\n<td style=\"width: 160px\">Jane<\/td>\n<td style=\"width: 178px;text-align: right\">1<\/td>\n<td style=\"width: 172px;text-align: right\">57%<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 62px;text-align: center\"><strong>3<\/strong><\/td>\n<td style=\"width: 160px\">Lucy<\/td>\n<td style=\"width: 178px;text-align: right\">2<\/td>\n<td style=\"width: 172px;text-align: right\">87%<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 62px;text-align: center\"><strong>4<\/strong><\/td>\n<td style=\"width: 160px\">James<\/td>\n<td style=\"width: 178px;text-align: right\">2<\/td>\n<td style=\"width: 172px;text-align: right\">75%<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 62px;text-align: center\"><strong>5<\/strong><\/td>\n<td style=\"width: 160px\">Kevin<\/td>\n<td style=\"width: 178px;text-align: right\">1<\/td>\n<td style=\"width: 172px;text-align: right\">41%<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 62px;text-align: center\"><strong>6<\/strong><\/td>\n<td style=\"width: 160px\">Joseph<\/td>\n<td style=\"width: 178px;text-align: right\">1<\/td>\n<td style=\"width: 172px;text-align: right\">77%<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 62px;text-align: center\"><strong>7<\/strong><\/td>\n<td style=\"width: 160px\">Emma<\/td>\n<td style=\"width: 178px;text-align: right\">1<\/td>\n<td style=\"width: 172px;text-align: right\">69%<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 62px;text-align: center\"><strong>8<\/strong><\/td>\n<td style=\"width: 160px\">Alice<\/td>\n<td style=\"width: 178px;text-align: right\">2<\/td>\n<td style=\"width: 172px;text-align: right\">89%<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 62px;text-align: center\"><strong>9<\/strong><\/td>\n<td style=\"width: 160px\">Graham<\/td>\n<td style=\"width: 178px;text-align: right\">2<\/td>\n<td style=\"width: 172px;text-align: right\">73%<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u00a0<\/p>\n<p style=\"text-align: left\">=MINIFS( C2:C9, B2:B9, 2)<\/p>\n<p style=\"text-align: left\">K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 73%<\/p>\n<p style=\"text-align: left\"><strong>\u00a0<\/strong><\/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-272.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11231,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11230","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\/11230","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=11230"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11230\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11231"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11230"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11230"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11230"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}