{"id":11901,"date":"2025-01-15T05:56:29","date_gmt":"2025-01-15T05:56:29","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cac-ham-excel-moi-trong-phien-ban-excel-2016-va-vi-du\/"},"modified":"2025-01-15T05:56:29","modified_gmt":"2025-01-15T05:56:29","slug":"cac-ham-excel-moi-trong-phien-ban-excel-2016-va-vi-du","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cac-ham-excel-moi-trong-phien-ban-excel-2016-va-vi-du\/","title":{"rendered":"C\u00e1c h\u00e0m Excel m\u1edbi trong phi\u00ean b\u1ea3n Excel 2016 v\u00e0 v\u00ed d\u1ee5"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>N\u1ebfu b\u1ea1n \u0111ang s\u1eed d\u1ee5ng Office v\u00e0 Excel 2016 c\u00f3 b\u1ea3n quy\u1ec1n th\u00ec ch\u00fac m\u1eebng b\u1ea1n, b\u1ea1n s\u1ebd c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ngay l\u1eadp t\u1ee9c c\u00e1c h\u00e0m tuy\u1ec7t v\u1eddi n\u00e0y. N\u1ebfu ch\u1eb3ng may b\u1ea1n \u0111ang kh\u00f4ng s\u1eed d\u1ee5ng Excel 2016 th\u00ec c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tr\u1ea3i nghi\u1ec7m c\u00e1c h\u00e0m n\u00e0y v\u1edbi phi\u00ean b\u1ea3n Excel Online. Sau \u0111\u00e2y l\u00e0 1 s\u1ed1 nh\u00f3m h\u00e0m v\u00e0 h\u00e0m m\u1edbi trong phi\u00ean b\u1ea3n Excel 2016 v\u00e0 v\u00ed d\u1ee5 \u00e1p d\u1ee5ng<\/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-67874e0a3558e\" 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-excel-moi-trong-phien-ban-excel-2016-va-vi-du.html#Nhom_ham_xu_ly_chuoi_%E2%80%93_Text_Functions\" title=\"Nh\u00f3m h\u00e0m x\u1eed l\u00fd chu\u1ed7i \u2013 Text Functions\">Nh\u00f3m h\u00e0m x\u1eed l\u00fd chu\u1ed7i \u2013 Text Functions<\/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-excel-moi-trong-phien-ban-excel-2016-va-vi-du.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-excel-moi-trong-phien-ban-excel-2016-va-vi-du.html#Ham_TEXTJOIN\" title=\"H\u00e0m TEXTJOIN\">H\u00e0m TEXTJOIN<\/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-excel-moi-trong-phien-ban-excel-2016-va-vi-du.html#Ham_Logic_%E2%80%93_Logical_Functions\" title=\"H\u00e0m Logic \u2013 Logical Functions\">H\u00e0m Logic \u2013 Logical Functions<\/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-excel-moi-trong-phien-ban-excel-2016-va-vi-du.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-excel-moi-trong-phien-ban-excel-2016-va-vi-du.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-excel-moi-trong-phien-ban-excel-2016-va-vi-du.html#Nhom_ham_xac_suat_thong_ke_%E2%80%93_Statistical_Functions\" title=\"Nh\u00f3m h\u00e0m x\u00e1c su\u1ea5t th\u1ed1ng k\u00ea \u2013 Statistical Functions\">Nh\u00f3m h\u00e0m x\u00e1c su\u1ea5t th\u1ed1ng k\u00ea \u2013 Statistical Functions<\/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-excel-moi-trong-phien-ban-excel-2016-va-vi-du.html#Ham_FORECASTETS\" title=\"H\u00e0m\u00a0FORECAST.ETS\">H\u00e0m\u00a0FORECAST.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-excel-moi-trong-phien-ban-excel-2016-va-vi-du.html#Ham_FORECASTETSCONFINT\" title=\"H\u00e0m\u00a0FORECAST.ETS.CONFINT\">H\u00e0m\u00a0FORECAST.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-excel-moi-trong-phien-ban-excel-2016-va-vi-du.html#Ham_FORECASTETSSEASONALITY\" title=\"H\u00e0m\u00a0FORECAST.ETS.SEASONALITY\">H\u00e0m\u00a0FORECAST.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-excel-moi-trong-phien-ban-excel-2016-va-vi-du.html#Ham_FORECASTETSSTAT\" title=\"H\u00e0m\u00a0FORECAST.ETS.STAT\">H\u00e0m\u00a0FORECAST.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-excel-moi-trong-phien-ban-excel-2016-va-vi-du.html#Ham_FORECASTLINEAR\" title=\"H\u00e0m\u00a0FORECAST.LINEAR\">H\u00e0m\u00a0FORECAST.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-excel-moi-trong-phien-ban-excel-2016-va-vi-du.html#Ham_MAXIFS\" title=\"H\u00e0m MAXIFS\">H\u00e0m MAXIFS<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-excel-moi-trong-phien-ban-excel-2016-va-vi-du.html#Ham_MINIFS\" title=\"H\u00e0m MINIFS\">H\u00e0m MINIFS<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Nhom_ham_xu_ly_chuoi_%E2%80%93_Text_Functions\"><\/span>Nh\u00f3m h\u00e0m x\u1eed l\u00fd chu\u1ed7i \u2013 Text Functions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Ham_Concat\"><\/span>H\u00e0m Concat<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>T\u00e1c d\u1ee5ng:<\/strong> N\u1ed1i n\u1ed9i dung c\u1ee7a 2 hay nhi\u1ec1u \u00f4 v\u00e0o v\u1edbi nhau<\/p>\n<p>Gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 n\u1ed9i dung trong A1:C1 nh\u01b0 h\u00ecnh v\u1ebd<\/p>\n<figure id=\"attachment_5948\" aria-describedby=\"caption-attachment-5948\" style=\"width: 364px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/01-cac-ham-moi-trong-excel-2016.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5948\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/01-cac-ham-moi-trong-excel-2016.png\" alt=\"01-cac-ham-moi-trong-excel-2016\" width=\"364\" height=\"100\" title=\"01-cac-ham-moi-trong-excel-2016\"><\/a><figcaption id=\"caption-attachment-5948\" class=\"wp-caption-text\">C\u00e1c h\u00e0m m\u1edbi trong Excel 2016<\/figcaption><\/figure>\n<p>H\u00e0m CONCAT v\u1edbi c\u00fa ph\u00e1p l\u00e0<\/p>\n<p><strong>=CONCAT(A1:C1)<\/strong><\/p>\n<p>s\u1ebd cho ch\u00fang ta k\u1ebft qu\u1ea3 l\u00e0 <strong>C:UsersJeff<\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ham_TEXTJOIN\"><\/span>H\u00e0m TEXTJOIN<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>N\u1ed1i 2 hay nhi\u1ec1u chu\u1ed7i v\u1edbi k\u00ed t\u1ef1 ph\u00e2n c\u00e1ch<\/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-334.gif\" title=\"ex101_92019-nho-334\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<figure id=\"attachment_5949\" aria-describedby=\"caption-attachment-5949\" style=\"width: 356px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/02-cac-ham-moi-trong-excel-2016.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5949\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/02-cac-ham-moi-trong-excel-2016.png\" alt=\"02-cac-ham-moi-trong-excel-2016\" width=\"356\" height=\"98\" title=\"02-cac-ham-moi-trong-excel-2016\"><\/a><figcaption id=\"caption-attachment-5949\" class=\"wp-caption-text\">H\u00e0m n\u1ed1i chu\u1ed7i trong Excel 2016<\/figcaption><\/figure>\n<p>H\u00e0m TEXTJOIN c\u00f3 c\u00fa ph\u00e1p l\u00e0<\/p>\n<p><strong>=TEXTJOIN(\u201c\u201d, TRUE, A1:C1)<\/strong><\/p>\n<p>K\u1ebft qu\u1ea3 l\u00e0 <strong>C:UsersJeff<\/strong><\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ecdc th\u00eam v\u1ec1 <a href=\"http:\/\/blog.ezworkapp.com\/ham-noi-chuoi-voi-dau-noi-tuy-chon-trong-excel.html\" target=\"_blank\">h\u00e0m TEXTJOIN v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u1edf \u0111\u00e2y<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_Logic_%E2%80%93_Logical_Functions\"><\/span>H\u00e0m Logic \u2013 Logical Functions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Ham_IFS\"><\/span>H\u00e0m IFS<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ki\u1ec3m tra 1 lo\u1ea1t \u0111i\u1ec1u ki\u1ec7n, v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u1ee9ng v\u1edbi \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang \u0111\u1ea7u ti\u00ean<\/p>\n<figure id=\"attachment_5950\" aria-describedby=\"caption-attachment-5950\" style=\"width: 356px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/03-cac-ham-moi-trong-excel-2016.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5950\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/03-cac-ham-moi-trong-excel-2016.png\" alt=\"03-cac-ham-moi-trong-excel-2016\" width=\"356\" height=\"98\" title=\"03-cac-ham-moi-trong-excel-2016\"><\/a><figcaption id=\"caption-attachment-5950\" class=\"wp-caption-text\">H\u00e0m IFS trong Excel 2016<\/figcaption><\/figure>\n<p>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m IFS nh\u01b0 sau:<\/p>\n<p><strong>=IFS( B1&lt;&gt;0, A1\/B1, C1&lt;&gt;0, A1\/C1 )<\/strong><\/p>\n<p>K\u1ebft qu\u1ea3 l\u00e0 10, v\u00ec bi\u1ec3u th\u1ee9c A1\/C1 \u0111\u01b0\u1ee3c t\u00ednh, \u0111i\u1ec1u ki\u1ec7n C1&lt;&gt;0 l\u00e0 \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang \u0111\u1ea7u ti\u00ean<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ham_SWITCH\"><\/span>H\u00e0m SWITCH<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m Switch s\u1ebd gi\u00fap b\u1ea1n ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n v\u00e0 \u0111\u01b0a ra k\u1ebft qu\u1ea3 t\u01b0\u01a1ng \u1ee9ng. V\u00ed d\u1ee5 nh\u01b0 sau<\/p>\n<blockquote>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/04-cac-ham-moi-trong-excel-2016.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-5951\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/04-cac-ham-moi-trong-excel-2016-1024x578-1.png\" alt=\"04-cac-ham-moi-trong-excel-2016\" width=\"1024\" height=\"578\" title=\"04-cac-ham-moi-trong-excel-2016-1024x578-1\"><\/a><\/p>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/hoc-excel-2016\">h\u01b0\u1edbng d\u1eabn h\u1ecdc excel 2016<\/a><\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Nhom_ham_xac_suat_thong_ke_%E2%80%93_Statistical_Functions\"><\/span>Nh\u00f3m h\u00e0m x\u00e1c su\u1ea5t th\u1ed1ng k\u00ea \u2013 Statistical Functions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Ham_FORECASTETS\"><\/span>H\u00e0m\u00a0FORECAST.ETS<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>D\u1ef1 \u0111o\u00e1n gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai d\u1ef1a tr\u00ean nh\u1eefng gi\u00e1 tr\u1ecb s\u1eb5n c\u00f3 s\u1eed d\u1ee5ng thu\u1eadt to\u00e1n exponential smoothing<\/p>\n<p>V\u00ed d\u1ee5:<\/p>\n<figure id=\"attachment_5952\" aria-describedby=\"caption-attachment-5952\" style=\"width: 579px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/forecast-ets-function-vi-du.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5952\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/forecast-ets-function-vi-du.png\" alt=\"V\u00ed d\u1ee5 h\u00e0m Forecast ETS trong Excel 2016\" width=\"579\" height=\"243\" title=\"forecast-ets-function-vi-du\"><\/a><figcaption id=\"caption-attachment-5952\" class=\"wp-caption-text\">V\u00ed d\u1ee5 h\u00e0m Forecast ETS trong Excel 2016<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Ham_FORECASTETSCONFINT\"><\/span>H\u00e0m\u00a0FORECAST.ETS.CONFINT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Tr\u1ea3 v\u1ec1 kho\u1ea3ng tin c\u1eady (Confidence Interval) cho gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c d\u1ef1 \u0111o\u00e1n v\u00e0o 1 ng\u00e0y nh\u1ea5t \u0111\u1ecbnh<\/p>\n<figure id=\"attachment_5953\" aria-describedby=\"caption-attachment-5953\" style=\"width: 579px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/forecast-ets-confint-function-vi-du.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5953\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/forecast-ets-confint-function-vi-du.png\" alt=\"H\u00e0m Forecast ETS Confint trong Excel 2016\" width=\"579\" height=\"286\" title=\"forecast-ets-confint-function-vi-du\"><\/a><figcaption id=\"caption-attachment-5953\" class=\"wp-caption-text\">H\u00e0m Forecast ETS Confint trong Excel 2016<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Ham_FORECASTETSSEASONALITY\"><\/span>H\u00e0m\u00a0FORECAST.ETS.SEASONALITY<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Tr\u1ea3 v\u1ec1 \u0111\u1ed9 d\u00e0i c\u1ee7a 1 pattern l\u1eb7p \u0111i l\u1eb7p l\u1ea1i trong m\u1ea3ng d\u1eef li\u1ec7u<\/p>\n<figure id=\"attachment_5954\" aria-describedby=\"caption-attachment-5954\" style=\"width: 441px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/forecast-ets-seasonality-function-vi-du.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5954\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/forecast-ets-seasonality-function-vi-du.png\" alt=\"H\u00e0m forecast ets seasonality trong Excel 2016\" width=\"441\" height=\"281\" title=\"forecast-ets-seasonality-function-vi-du\"><\/a><figcaption id=\"caption-attachment-5954\" class=\"wp-caption-text\">H\u00e0m forecast ets seasonality trong Excel 2016<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Ham_FORECASTETSSTAT\"><\/span>H\u00e0m\u00a0FORECAST.ETS.STAT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>D\u1ef1 \u0111o\u00e1n d\u1eef li\u1ec7u d\u1ef1a tr\u00ean Timeseries Data<\/p>\n<figure id=\"attachment_5955\" aria-describedby=\"caption-attachment-5955\" style=\"width: 579px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/forecast-ets-stat-function-vi-du.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5955\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/forecast-ets-stat-function-vi-du.png\" alt=\"H\u00e0m forecast ets stat trong Excel 2016\" width=\"579\" height=\"284\" title=\"forecast-ets-stat-function-vi-du\"><\/a><figcaption id=\"caption-attachment-5955\" class=\"wp-caption-text\">H\u00e0m forecast ets stat trong Excel 2016<\/figcaption><\/figure>\n<blockquote>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-ke-toan.html\">L\u01a1\u0301p h\u1ecdc Excel k\u1ebf to\u00e1n<\/a><\/p>\n<\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"Ham_FORECASTLINEAR\"><\/span>H\u00e0m\u00a0FORECAST.LINEAR<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m n\u1ed9i suy tuy\u1ebfn t\u00ednh trong Excel<\/p>\n<figure id=\"attachment_5956\" aria-describedby=\"caption-attachment-5956\" style=\"width: 579px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/ham-noi-suy-tuyen-tinh-trong-excel-2016.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5956\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-noi-suy-tuyen-tinh-trong-excel-2016.png\" alt=\"H\u00e0m n\u1ed9i suy tuy\u1ebfn t\u00ednh trong Excel 2016\" width=\"579\" height=\"222\" title=\"ham-noi-suy-tuyen-tinh-trong-excel-2016\"><\/a><figcaption id=\"caption-attachment-5956\" class=\"wp-caption-text\">H\u00e0m n\u1ed9i suy tuy\u1ebfn t\u00ednh trong Excel 2016<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Ham_MAXIFS\"><\/span>H\u00e0m MAXIFS<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t d\u1ef1a tr\u00ean 1 hay nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/p>\n<figure id=\"attachment_5957\" aria-describedby=\"caption-attachment-5957\" style=\"width: 434px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/ham-maxifs-trong-excel-2016.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5957\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-maxifs-trong-excel-2016.png\" alt=\"H\u00e0m Maxifs trong Excel 2016\" width=\"434\" height=\"520\" title=\"ham-maxifs-trong-excel-2016\"><\/a><figcaption id=\"caption-attachment-5957\" class=\"wp-caption-text\">H\u00e0m Maxifs trong Excel 2016<\/figcaption><\/figure>\n<p>V\u00ed d\u1ee5: l\u1ea5y Score cao nh\u1ea5t trong Group 1:<\/p>\n<p><strong>=MAXIFS( C2:C9, B2:B9, 1 )<\/strong><\/p>\n<p>k\u1ebft qu\u1ea3 l\u00e0 77%<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ham_MINIFS\"><\/span>H\u00e0m MINIFS<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t d\u1ef1a tr\u00ean 1 hay nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/p>\n<figure id=\"attachment_5957\" aria-describedby=\"caption-attachment-5957\" style=\"width: 434px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/ham-maxifs-trong-excel-2016.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5957\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-maxifs-trong-excel-2016.png\" alt=\"H\u00e0m Maxifs trong Excel 2016\" width=\"434\" height=\"520\" title=\"ham-maxifs-trong-excel-2016\"><\/a><figcaption id=\"caption-attachment-5957\" class=\"wp-caption-text\">H\u00e0m Maxifs\/Minifs trong Excel 2016<\/figcaption><\/figure>\n<p>V\u00ed d\u1ee5: T\u00ecm Score nh\u1ecf nh\u1ea5t c\u1ee7a h\u1ecdc vi\u00ean trong nh\u00f3m 2<\/p>\n<p><strong>=MINIFS( C2:C9, B2:B9, 2 )<\/strong><\/p>\n<p>K\u1ebft qu\u1ea3 l\u00e0 73%<\/p>\n<p>Nh\u01b0 v\u1eady, qua b\u00e0i n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\">Excel Online<\/a> \u0111\u00e3 gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n nh\u1eefng h\u00e0m m\u1edbi c\u00f3 m\u1eb7t trong Excel 2016 r\u1ea5t th\u00fa v\u1ecb v\u00e0 h\u1eefu \u00edch. C\u1ea3m \u01a1n c\u00e1c b\u1ea1n \u0111\u00e3 theo d\u00f5i v\u00e0 h\u00e3y chia s\u1ebb ki\u1ebfn th\u1ee9c n\u00e0y v\u1edbi nhi\u1ec1u ng\u01b0\u1eddi kh\u00e1c.<\/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-334.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11902,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11901","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\/11901","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=11901"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11901\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11902"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11901"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11901"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11901"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}