{"id":12061,"date":"2022-11-22T08:23:11","date_gmt":"2022-11-22T01:23:11","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=12061"},"modified":"2025-04-15T16:26:15","modified_gmt":"2025-04-15T09:26:15","slug":"ham-cong-tru-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/","title":{"rendered":"H\u00e0m c\u1ed9ng tr\u1eeb trong Excel | H\u01b0\u1edbng d\u1eabn c\u00e1c c\u00e1ch s\u1eed d\u1ee5ng"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;12061&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;10&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;4&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;4\\\/5 - (10 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;H\u00e0m c\u1ed9ng tr\u1eeb trong Excel | H\u01b0\u1edbng d\u1eabn c\u00e1c c\u00e1ch s\u1eed d\u1ee5ng&quot;,&quot;width&quot;:&quot;113.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 113.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            4\/5 - (10 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p style=\"text-align: justify;\"><em><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng <\/span><b>h\u00e0m c\u1ed9ng tr\u1eeb trong Excel<\/b><span style=\"font-weight: 400;\"> gi\u00fap vi\u1ec7c t\u00ednh to\u00e1n trong b\u1ea3ng nhanh ch\u00f3ng, ch\u00ednh x\u00e1c. T\u1eeb \u0111\u00f3, ng\u01b0\u1eddi d\u00f9ng c\u0169ng ti\u1ebft ki\u1ec7m th\u1eddi gian, c\u00f4ng s\u1ee9c h\u01a1n.<\/span><\/em><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1c <\/span><b>h\u00e0m c\u1ed9ng tr\u1eeb trong Excel<\/b><span style=\"font-weight: 400;\"> th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong ph\u1ea7n m\u1ec1m t\u00ednh to\u00e1n n\u00e0y. \u0110\u1eb7c bi\u1ec7t l\u00e0 <\/span><b><i>h\u00e0m tr\u1eeb trong Excel<\/i><\/b><span style=\"font-weight: 400;\">. D\u01b0\u1edbi \u0111\u00e2y, <a href=\"https:\/\/teky.edu.vn\/\">Teky<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n chi ti\u1ebft c\u00e1c c\u00e1ch \u0111\u1ec3 tr\u1eeb trong Excel nhanh ch\u00f3ng b\u1eb1ng h\u00e0m v\u00e0 c\u00e1c to\u00e1n t\u1eed. B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o \u0111\u1ec3 \u00e1p d\u1ee5ng \u0111\u01b0\u1ee3c hi\u1ec7u qu\u1ea3 h\u01a1n trong c\u00f4ng vi\u1ec7c c\u0169ng nh\u01b0 h\u1ecdc t\u1eadp c\u1ee7a m\u00ecnh.<\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">N\u1ed9i dung <\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/#Hieu_the_nao_ve_ham_cong_tru_trong_Excel\" >Hi\u1ec3u th\u1ebf n\u00e0o v\u1ec1 h\u00e0m c\u1ed9ng tr\u1eeb trong Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/#Cach_su_dung_ham_tru_trong_excel_don_gian_hieu_qua\" >C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb trong excel \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/#Su_dung_toan_tu_de_thuc_hien_phep_tru_trong_Excel\" >S\u1eed d\u1ee5ng to\u00e1n t\u1eed \u0111\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p tr\u1eeb trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/#Thuc_hien_ham_tinh_tru_trong_excel_voi_nhieu_o\" >Th\u1ef1c hi\u1ec7n h\u00e0m t\u00ednh tr\u1eeb trong excel v\u1edbi nhi\u1ec1u \u00f4<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/#Cach_su_dung_ham_SUM_de_tru_trong_Excel\" >C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUM \u0111\u1ec3 tr\u1eeb trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/#Su_dung_ham_tinh_tru_trong_excel_de_tinh_ti_le\" >S\u1eed d\u1ee5ng h\u00e0m t\u00ednh tr\u1eeb trong excel \u0111\u1ec3 t\u00ednh t\u1ec9 l\u1ec7 %<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/#Ham_tru_trong_excel_ap_dung_cho_tinh_ngay_thang\" >H\u00e0m tr\u1eeb trong excel \u00e1p d\u1ee5ng cho t\u00ednh ng\u00e0y th\u00e1ng<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/#Su_dung_ham_cong_tru_trong_Excel_de_tru_ky_tu\" >S\u1eed d\u1ee5ng h\u00e0m c\u1ed9ng tr\u1eeb trong Excel \u0111\u1ec3 tr\u1eeb k\u00fd t\u1ef1<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Hieu_the_nao_ve_ham_cong_tru_trong_Excel\"><\/span><b>Hi\u1ec3u th\u1ebf n\u00e0o v\u1ec1 h\u00e0m c\u1ed9ng tr\u1eeb trong Excel?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Th\u1ef1c t\u1ebf th\u00ec <\/span><b>h\u00e0m c\u1ed9ng tr\u1eeb trong Excel<\/b><span style=\"font-weight: 400;\"> kh\u00f4ng \u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3. Ng\u01b0\u1eddi d\u00f9ng ph\u1ea7n m\u1ec1m c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c d\u1ea5u \u201c+\u201d ho\u1eb7c d\u1ea5u \u201c-\u201c \u0111\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh. Ngo\u00e0i ra, vi\u1ec7c \u00e1p d\u1ee5ng h\u00e0m SUM c\u0169ng l\u00e0 gi\u1ea3i ph\u00e1p t\u1ed1i \u01b0u. \u0110\u1ec3 c\u00f3 th\u1ec3 ti\u1ebfn h\u00e0nh t\u00ednh to\u00e1n trong b\u1ea3ng t\u00ednh n\u00e0y m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12062\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-1.jpg\" alt=\"H\u00e0m c\u00f4ng tr\u1eeb trong excel\" width=\"600\" height=\"346\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-1-400x231.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_tru_trong_excel_don_gian_hieu_qua\"><\/span><b>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb trong excel \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f3 nhi\u1ec1u c\u00e1ch \u0111\u1ec3 \u00e1p d\u1ee5ng <\/span><b><i>h\u00e0m tr\u1eeb trong excel<\/i><\/b> <span style=\"font-weight: 400;\">m\u00e0 nhi\u1ec1u ng\u01b0\u1eddi v\u1eabn ch\u01b0a bi\u1ebft. N\u1ebfu b\u1ea1n l\u00e0 \u201ct\u00e2n binh\u201d v\u00e0 \u0111ang g\u1eb7p kh\u00f3 kh\u0103n v\u1edbi c\u00e1c ph\u00e9p t\u00ednh n\u00e0y. Th\u00ec h\u00e3y tham kh\u1ea3o nh\u1eefng c\u00e1ch c\u01a1 b\u1ea3n d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 \u00e1p d\u1ee5ng ph\u00e9p tr\u1eeb hi\u1ec7u qu\u1ea3 nh\u1ea5t khi t\u00ednh to\u00e1n.<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"[11] C\u1ed9ng, tr\u1eeb, nh\u00e2n, chia, l\u0169y th\u1eeba, h\u00e0m sum, h\u00e0m product - Calculations operations\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/MqQmXpPio4U?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Su_dung_toan_tu_de_thuc_hien_phep_tru_trong_Excel\"><\/span><b><i>S\u1eed d\u1ee5ng to\u00e1n t\u1eed \u0111\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p tr\u1eeb trong Excel<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch \u00e1p d\u1ee5ng ph\u00e9p tr\u1eeb trong Excel n\u00e0y c\u0169ng kh\u00e1 \u0111\u01a1n gi\u1ea3n. B\u1ea1n ch\u1ec9 c\u1ea7n \u0111\u1eb7t tr\u01b0\u1edbc ph\u00e9p to\u00e1n d\u1ea5u \u201c=\u201d. Sau \u0111\u00f3, b\u1ea1n ti\u1ebfn h\u00e0nh nh\u1eadp \u00f4 tham chi\u1ebfu hay s\u1ed1 c\u1ea7n tr\u1eeb v\u00e0 k\u1ebft h\u1ee3p v\u1edbi to\u00e1n t\u1eed l\u00e0 d\u1ea5u \u201c-\u201c \u0111\u1ec3 c\u00f3 th\u1ec3 ho\u00e0n th\u00e0nh ph\u00e9p to\u00e1n tr\u1eeb trong Excel \u0111\u01b0\u1ee3c d\u1ec5 d\u00e0ng nh\u1ea5t.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5, b\u1ea1n c\u1ea7n th\u1ef1c hi\u1ec7n ph\u00e9p tr\u1eeb v\u1edbi s\u1ed1 20 \u2013 8. Theo \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp c\u00e1c s\u1ed1 tr\u1ef1c ti\u1ebfp v\u00e0o b\u1ea3ng Excel theo c\u00f4ng th\u1ee9c \u201c=20-8\u201d. Cu\u1ed1i c\u00f9ng, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n Enter l\u00e0 t\u1ea1i \u00f4 tham chi\u1ebfu s\u1ebd xu\u1ea5t hi\u1ec7n k\u1ebft qu\u1ea3 c\u1ee7a ph\u00e9p tr\u1eeb.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12063 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-2.jpg\" alt=\"S\u1eed d\u1ee5ng to\u00e1n t\u1eed \u0111\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p tr\u1eeb trong Excel\" width=\"600\" height=\"265\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-2-400x177.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Thuc_hien_ham_tinh_tru_trong_excel_voi_nhieu_o\"><\/span><b><i>Th\u1ef1c hi\u1ec7n h\u00e0m t\u00ednh tr\u1eeb trong excel v\u1edbi nhi\u1ec1u \u00f4<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n <\/span><b><i>h\u00e0m t\u00ednh tr\u1eeb trong excel<\/i><\/b><span style=\"font-weight: 400;\"> v\u1edbi y\u00eau c\u1ea7u tr\u1eeb nhi\u1ec1u \u00f4 c\u00f9ng l\u00fac. C\u00e1ch l\u00e0m c\u0169ng kh\u00f4ng qu\u00e1 ph\u1ee9c t\u1ea1p. B\u1ea1n ch\u1ec9 c\u1ea7n l\u1ea5y gi\u00e1 tr\u1ecb n\u1eb1m \u1edf \u00f4 tham chi\u1ebfu \u0111\u1ea7u ti\u00ean tr\u1eeb cho c\u00e1c gi\u00e1 tr\u1ecb \u1edf \u00f4 tham chi\u1ebfu c\u00f2n l\u1ea1i v\u00e0 nh\u1ea5n Enter l\u00e0 xong.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 c\u1ee5 th\u1ec3 nh\u01b0 sau: Y\u00eau c\u1ea7u trong b\u1ea3ng c\u00f3 t\u1ed5ng c\u1ee7a 5 lo\u1ea1i tr\u00e1i c\u00e2y g\u1ed3m: cam, xo\u00e0i, T\u00e1o, \u1ed5i v\u00e0 thanh long. Tuy nhi\u00ean, b\u00e0i to\u00e1n cho k\u1ebft qu\u1ea3 c\u1ee7a 4 lo\u1ea1i tr\u00e1i c\u00e2y v\u00e0 t\u1ed5ng, y\u00eau c\u1ea7u t\u00ednh s\u1ed1 tr\u00e1i thanh long. V\u1edbi y\u00eau c\u1ea7u n\u00e0y, b\u1ea1n c\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c c\u1ee5 th\u1ec3: \u201c=A2-B2-C2-D2-E2\u201d nh\u01b0 h\u00ecnh d\u01b0\u1edbi. Sau \u0111\u00f3, b\u1ea1n nh\u1ea5n Enter \u0111\u1ec3 ra k\u1ebft qu\u1ea3 c\u1ee7a Thanh long.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12064 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-3.jpg\" alt=\"Th\u1ef1c hi\u1ec7n h\u00e0m t\u00ednh tr\u1eeb trong excel v\u1edbi nhi\u1ec1u \u00f4\" width=\"600\" height=\"320\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-3-400x213.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u00e1p \u00e1n c\u1ee7a b\u00e0i to\u00e1n sau khi \u00e1p d\u1ee5ng <\/span><b>h\u00e0m c\u1ed9ng tr\u1eeb trong excel<\/b><span style=\"font-weight: 400;\"> nhi\u1ec1u \u00f4 nh\u01b0 sau:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12065\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-4.jpg\" alt=\"\" width=\"600\" height=\"319\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-4.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-4-400x213.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_SUM_de_tru_trong_Excel\"><\/span><b><i>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUM \u0111\u1ec3 tr\u1eeb trong Excel<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u00cdt ai bi\u1ebft r\u1eb1ng, SUM c\u0169ng l\u00e0 m\u1ed9t <\/span><b>h\u00e0m c\u1ed9ng tr\u1eeb trong excel<\/b><span style=\"font-weight: 400;\"> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ea5t ph\u1ed5 bi\u1ebfn hi\u1ec7n nay. Thay v\u00ec vi\u1ec7c d\u00f9ng to\u00e1n t\u1eed th\u00ec b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m SUM \u0111\u1ec3 t\u00ednh c\u00e1c ph\u00e9p tr\u1eeb. \u0110\u00e2y l\u00e0 <\/span><b><i>h\u00e0m tr\u1eeb c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel<\/i><\/b><span style=\"font-weight: 400;\"> v\u1edbi kh\u1ea3 n\u0103ng \u1ee9ng d\u1ee5ng r\u1ea5t ph\u1ed5 bi\u1ebfn. C\u00f3 th\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 vi\u1ec7c d\u00f9ng h\u00e0m SUM \u0111\u1ec3 t\u00ednh ph\u00e9p tr\u1eeb b\u1eb1ng m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><b><i>V\u00ed d\u1ee5 1<\/i><\/b><span style=\"font-weight: 400;\">: B\u1ea1n nh\u1eadp v\u00e0o b\u1ea3ng t\u00ednh Excel c\u00f4ng th\u1ee9c: =A1-SUM(B1:E1) nh\u01b0 h\u00ecnh d\u01b0\u1edbi.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12066 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-5.jpg\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUM \u0111\u1ec3 tr\u1eeb trong Excel\" width=\"600\" height=\"303\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-5.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-5-400x202.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Sau \u0111\u00f3, b\u1ea1n ti\u1ebfn h\u00e0nh nh\u1ea5n Enter \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 ph\u00e9p tr\u1eeb \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 h\u00ecnh:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12067\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-6.jpg\" alt=\"H\u00e0m c\u00f4ng tr\u1eeb trong excel\" width=\"600\" height=\"319\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-6.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-6-400x213.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><b><i>V\u00ed d\u1ee5 2<\/i><\/b><span style=\"font-weight: 400;\">: B\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p tr\u1eeb b\u1eb1ng h\u00e0m SUM nh\u01b0 m\u1ed9t <\/span><b>h\u00e0m c\u1ed9ng tr\u1eeb trong excel<\/b><span style=\"font-weight: 400;\"> \u0111\u01a1n gi\u1ea3n. \u0110\u1ea7u ti\u00ean, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c v\u1edbi c\u00e1c d\u1ea5u \u201c-\u201c n\u1eb1m tr\u01b0\u1edbc c\u00e1c \u0111\u1ed1i s\u1ed1. C\u00e1ch n\u00e0y s\u1ebd gi\u00fap b\u1ea1n bi\u1ebfn \u0111\u1ed1i s\u1ed1 th\u00e0nh h\u1ea1ng \u00e2m. C\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c t\u00ednh l\u00e0<\/span> <span style=\"font-weight: 400;\">=SUM(A1;-B1;-C1;-D1;-E1).<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12068 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-7.jpg\" alt=\"C\u00f4ng th\u1ee9c tr\u1eeb trong excel\" width=\"600\" height=\"301\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-7.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-7-400x201.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u1ea1n ti\u1ebfp t\u1ee5c nh\u1ea5n n\u00fat Enter \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 c\u1ee7a ph\u00e9p tr\u1eeb nh\u01b0 sau:\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12069\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-8.jpg\" alt=\"H\u00e0m c\u00f4ng tr\u1eeb trong excel\" width=\"600\" height=\"304\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-8.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-8-400x203.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Su_dung_ham_tinh_tru_trong_excel_de_tinh_ti_le\"><\/span><b><i>S\u1eed d\u1ee5ng h\u00e0m t\u00ednh tr\u1eeb trong excel \u0111\u1ec3 t\u00ednh t\u1ec9 l\u1ec7 %<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Mu\u1ed1n t\u00ednh t\u1ec9 l\u1ec7 % b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m SUM nh\u01b0 <\/span><b><i>h\u00e0m t\u00ednh tr\u1eeb trong excel<\/i><\/b><span style=\"font-weight: 400;\"> ho\u1eb7c d\u00f9ng d\u1ea5u \u201c-\u201c. Tuy nhi\u00ean, c\u00e1ch n\u00e0y ch\u1ec9 \u00e1p d\u1ee5ng cho c\u00e1c d\u1eef li\u1ec7u \u0111\u00e3 c\u00f3 s\u1eb5n t\u1ec9 l\u1ec7 %. \u0110\u1ed1i v\u1edbi c\u00e1c tr\u01b0\u1eddng h\u1ee3p ch\u01b0a c\u00f3 t\u1ec9 l\u1ec7 % th\u00ec b\u1ea1n ch\u1ec9 c\u1ea7n ti\u1ebfn h\u00e0nh th\u00eam d\u1ea5u % v\u00e0o sau c\u00e1c gi\u00e1 tr\u1ecb \u0111\u1ec3 vi\u1ec7c t\u00ednh to\u00e1n \u0111\u01b0\u1ee3c thu\u1eadn ti\u1ec7n v\u00e0 ch\u00ednh x\u00e1c.\u00a0 D\u01b0\u1edbi \u0111\u00e2y l\u00e0 v\u00ed d\u1ee5 \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00e1ch t\u00ednh tr\u1eeb trong Excel n\u00e0y.<\/span><\/p>\n<p style=\"text-align: justify;\"><b><i>V\u00ed d\u1ee5<\/i><\/b><span style=\"font-weight: 400;\">: Y\u00eau c\u1ea7u t\u00ednh s\u1ed1 % c\u1ee7a h\u1ecdc sinh c\u00f3 h\u1ea1nh ki\u1ec3m \u0111\u1ea1t trung b\u00ecnh trong b\u1ea3ng t\u00ednh sau:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12070 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-9.jpg\" alt=\"S\u1eed d\u1ee5ng h\u00e0m t\u00ednh tr\u1eeb trong excel \u0111\u1ec3 t\u00ednh t\u1ec9 l\u1ec7 %\" width=\"600\" height=\"321\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-9.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-9-400x214.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u1edbi y\u00eau c\u1ea7u n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng d\u1ea5u \u201c-\u201c ho\u1eb7c h\u00e0m SUM \u0111\u1ec3 t\u00ednh to\u00e1n. \u0110\u1ed1i v\u1edbi vi\u1ec7c s\u1eed d\u1ee5ng d\u1ea5u \u201c-\u201c, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c sau: = B1-B2-B3 v\u00e0 k\u1ebft th\u00fac b\u1eb1ng c\u00e1ch nh\u1ea5n n\u00fat Enter \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c \u0111\u00e1p \u00e1n.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12071 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-10.jpg\" alt=\"\" width=\"600\" height=\"321\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-10.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-10-400x214.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n t\u00ednh ph\u00e9p tr\u1eeb % b\u1eb1ng h\u00e0m SUM th\u00ec c\u00f3 th\u1ec3 d\u00f9ng 1 s\u1ed1 \u0111\u1ec3 tr\u1eeb cho h\u00e0m SUM v\u00e0 nh\u1eadp c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n sau: =B1-SUM(B2:B3). Cu\u1ed1i c\u00f9ng, b\u1ea1n nh\u1ea5n Enter \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 \u0111\u00fang c\u1ee7a ph\u00e9p t\u00ednh.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12072 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-11.jpg\" alt=\"\" width=\"600\" height=\"320\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-11.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-11-400x213.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_tru_trong_excel_ap_dung_cho_tinh_ngay_thang\"><\/span><b><i>H\u00e0m tr\u1eeb trong excel \u00e1p d\u1ee5ng cho t\u00ednh ng\u00e0y th\u00e1ng<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n mu\u1ed1n tr\u1eeb ng\u00e0y th\u00e1ng b\u1eb1ng <\/span><b><i>h\u00e0m tr\u1eeb trong excel<\/i><\/b><span style=\"font-weight: 400;\"> th\u00ec b\u1eaft bu\u1ed9c c\u00e1c gi\u00e1 tr\u1ecb c\u1ea7n tr\u1eeb ph\u1ea3i \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng s\u1eb5n trong Excel \u1edf d\u1ea1ng Date. C\u00e1ch tr\u1eeb c\u0169ng \u0111\u01b0\u1ee3c t\u00ednh t\u01b0\u01a1ng t\u1ef1 nh\u01b0 tr\u00ean \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 v\u1edbi gi\u00e1 tr\u1ecb l\u00e0 s\u1ed1 ng\u00e0y ch\u00eanh l\u1ec7ch gi\u1eefa 2 th\u1eddi \u0111i\u1ec3m.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><b><i>V\u00ed d\u1ee5: <\/i><\/b><span style=\"font-weight: 400;\">B\u1ea1n c\u1ea7n tr\u1eeb \u0111\u1ec3 t\u00ednh s\u1ed1 ng\u00e0y ch\u00eanh l\u1ec7ch t\u1eeb ng\u00e0y 18\/08\/2021 v\u1edbi ng\u00e0y 08\/08\/2021. V\u1edbi y\u00eau c\u1ea7u n\u00e0y, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp v\u00e0o b\u1ea3ng Excel c\u00f4ng th\u1ee9c = B1 \u2013 A1.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12073 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-12.jpg\" alt=\"H\u00e0m tr\u1eeb trong excel \u00e1p d\u1ee5ng cho t\u00ednh ng\u00e0y th\u00e1ng\" width=\"600\" height=\"320\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-12.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-12-400x213.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Sau \u0111\u00f3, b\u1ea1n nh\u1ea5n v\u00e0o n\u00fat Enter tr\u00ean b\u00e0n ph\u00edm \u0111\u1ec3 t\u00ecm ra s\u1ed1 ng\u00e0y ch\u00eanh l\u1ec7ch n\u1eb1m \u1edf \u00f4 A2\u00a0 l\u00e0 10 ng\u00e0y.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12074\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-13.jpg\" alt=\"H\u00e0m c\u00f4ng tr\u1eeb trong excel\" width=\"600\" height=\"320\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-13.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-13-400x213.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Su_dung_ham_cong_tru_trong_Excel_de_tru_ky_tu\"><\/span><b><i>S\u1eed d\u1ee5ng h\u00e0m c\u1ed9ng tr\u1eeb trong Excel \u0111\u1ec3 tr\u1eeb k\u00fd t\u1ef1<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng nhi\u1ec1u <\/span><b>h\u00e0m c\u1ed9ng tr\u1eeb trong Excel<\/b><span style=\"font-weight: 400;\"> \u0111\u1ec3 ti\u1ebfn h\u00e0nh tr\u1eeb k\u00fd t\u1ef1 trong b\u1ea3ng t\u00ednh n\u00e0y. Tuy nhi\u00ean, \u0111\u1ec3 th\u1ef1c hi\u1ec7n th\u00ec b\u1ea1n c\u1ea7n ph\u1ea3i k\u1ebft h\u1ee3p nhi\u1ec1u h\u00e0m v\u1edbi nhau. C\u1ee5 th\u1ec3 nh\u01b0:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi y\u00eau c\u1ea7u l\u00e0m ph\u00e9p tr\u1eeb v\u1edbi h\u00e0m ph\u00e2n bi\u1ec7t k\u00fd t\u1ef1. Th\u00ec b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p 2 h\u00e0m l\u00e0 TRIM v\u00e0 SUBSTITUTE l\u1ea1i v\u1edbi nhau.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi y\u00eau c\u1ea7u l\u00e0m ph\u00e9p tr\u1eeb v\u1edbi h\u00e0m kh\u00f4ng bi\u1ec7t k\u00ed t\u1ef1. Th\u00ec h\u00e0m REPLACE k\u1ebft h\u1ee3p SEARCH v\u00e0 h\u00e0m LEN l\u00e0 l\u1ef1a ch\u1ecdn t\u1ed1t nh\u1ea5t.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12075 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-14.jpg\" alt=\"\" width=\"600\" height=\"289\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-14.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-14-400x193.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n v\u1eabn ch\u01b0a bi\u1ebft v\u1ec1 c\u00e1c <\/span><b>h\u00e0m c\u1ed9ng tr\u1eeb trong Excel<\/b><span style=\"font-weight: 400;\"> th\u00ec \u0111\u1eebng b\u1ecf qua b\u00e0i vi\u1ebft c\u1ee7a Teky tr\u00ean. Chia s\u1ebb c\u1ee7a ch\u00fang t\u00f4i s\u1ebd gi\u00fap \u00edch cho b\u1ea1n kh\u00f4ng \u00edt trong qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n. C\u0169ng nh\u01b0 ho\u00e0n th\u00e0nh c\u00e1c c\u00f4ng vi\u1ec7c v\u1edbi ph\u00e9p tr\u1eeb t\u1ea1i ph\u1ea7n m\u1ec1m t\u00ednh to\u00e1n n\u00e0y.<\/span><\/p>\n<p><a href=\"https:\/\/khuyenmai.teky.vn\/tangsachlaptrinh\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24876\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2024\/03\/Free-Asset.png\" alt=\"T\u1eb7ng s\u00e1ch mi\u1ec5n ph\u00ed\" width=\"600\" height=\"314\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Xem th\u00eam:<\/p>\n<ul>\n<li><a href=\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong excel<\/a><\/li>\n<li><a href=\"https:\/\/teky.edu.vn\/blog\/su-dung-ham-dem-co-dieu-kien-sieu-don-gian-trong-excel\/\">S\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel<\/a><\/li>\n<li><a href=\"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/\">Nh\u1eefng \u0111i\u1ec1u c\u1ea7n bi\u1ebft v\u1ec1 h\u00e0m th\u1ed1ng k\u00ea trong excel\u00a0<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/phep-nhan-trong-excel\/\" target=\"_blank\" rel=\"noopener\">4 c\u00e1ch t\u00ednh ph\u00e9p nh\u00e2n trong Excel d\u1ec5 hi\u1ec3u nh\u1ea5t<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u00e2n trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>S\u1eed d\u1ee5ng h\u00e0m c\u1ed9ng tr\u1eeb trong Excel gi\u00fap vi\u1ec7c t\u00ednh to\u00e1n trong b\u1ea3ng nhanh ch\u00f3ng, ch\u00ednh x\u00e1c. T\u1eeb \u0111\u00f3, ng\u01b0\u1eddi d\u00f9ng c\u0169ng ti\u1ebft ki\u1ec7m th\u1eddi gian, c\u00f4ng s\u1ee9c h\u01a1n. C\u00e1c h\u00e0m c\u1ed9ng tr\u1eeb trong Excel th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong ph\u1ea7n m\u1ec1m t\u00ednh to\u00e1n n\u00e0y. \u0110\u1eb7c bi\u1ec7t l\u00e0 h\u00e0m tr\u1eeb trong Excel. D\u01b0\u1edbi &hellip;<\/p>\n","protected":false},"author":3,"featured_media":12062,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-12061","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>H\u01b0\u1edbng d\u1eabn c\u00e1c c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m c\u1ed9ng tr\u1eeb trong Excel<\/title>\n<meta name=\"description\" content=\"S\u1eed d\u1ee5ng h\u00e0m c\u1ed9ng tr\u1eeb trong Excel gi\u00fap vi\u1ec7c t\u00ednh to\u00e1n trong b\u1ea3ng nhanh ch\u00f3ng, ch\u00ednh x\u00e1c. T\u1eeb \u0111\u00f3, ng\u01b0\u1eddi d\u00f9ng c\u0169ng ti\u1ebft ki\u1ec7m th\u1eddi gian.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u01b0\u1edbng d\u1eabn c\u00e1c c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m c\u1ed9ng tr\u1eeb trong Excel\" \/>\n<meta property=\"og:description\" content=\"S\u1eed d\u1ee5ng h\u00e0m c\u1ed9ng tr\u1eeb trong Excel gi\u00fap vi\u1ec7c t\u00ednh to\u00e1n trong b\u1ea3ng nhanh ch\u00f3ng, ch\u00ednh x\u00e1c. T\u1eeb \u0111\u00f3, ng\u01b0\u1eddi d\u00f9ng c\u0169ng ti\u1ebft ki\u1ec7m th\u1eddi gian.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-22T01:23:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-15T09:26:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"346\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Huy \u0110\u00e0m\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Huy \u0110\u00e0m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"H\u00e0m c\u1ed9ng tr\u1eeb trong Excel | H\u01b0\u1edbng d\u1eabn c\u00e1c c\u00e1ch s\u1eed d\u1ee5ng\",\"datePublished\":\"2022-11-22T01:23:11+00:00\",\"dateModified\":\"2025-04-15T09:26:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/\"},\"wordCount\":1874,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-1.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/\",\"name\":\"H\u01b0\u1edbng d\u1eabn c\u00e1c c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m c\u1ed9ng tr\u1eeb trong Excel\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-1.jpg\",\"datePublished\":\"2022-11-22T01:23:11+00:00\",\"dateModified\":\"2025-04-15T09:26:15+00:00\",\"description\":\"S\u1eed d\u1ee5ng h\u00e0m c\u1ed9ng tr\u1eeb trong Excel gi\u00fap vi\u1ec7c t\u00ednh to\u00e1n trong b\u1ea3ng nhanh ch\u00f3ng, ch\u00ednh x\u00e1c. T\u1eeb \u0111\u00f3, ng\u01b0\u1eddi d\u00f9ng c\u0169ng ti\u1ebft ki\u1ec7m th\u1eddi gian.\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-1.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-1.jpg\",\"width\":600,\"height\":346,\"caption\":\"H\u00e0m c\u00f4ng tr\u1eeb trong excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u00e0m c\u1ed9ng tr\u1eeb trong Excel | H\u01b0\u1edbng d\u1eabn c\u00e1c c\u00e1ch s\u1eed d\u1ee5ng\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\",\"name\":\"Huy \u0110\u00e0m\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"caption\":\"Huy \u0110\u00e0m\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u01b0\u1edbng d\u1eabn c\u00e1c c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m c\u1ed9ng tr\u1eeb trong Excel","description":"S\u1eed d\u1ee5ng h\u00e0m c\u1ed9ng tr\u1eeb trong Excel gi\u00fap vi\u1ec7c t\u00ednh to\u00e1n trong b\u1ea3ng nhanh ch\u00f3ng, ch\u00ednh x\u00e1c. T\u1eeb \u0111\u00f3, ng\u01b0\u1eddi d\u00f9ng c\u0169ng ti\u1ebft ki\u1ec7m th\u1eddi gian.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u01b0\u1edbng d\u1eabn c\u00e1c c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m c\u1ed9ng tr\u1eeb trong Excel","og_description":"S\u1eed d\u1ee5ng h\u00e0m c\u1ed9ng tr\u1eeb trong Excel gi\u00fap vi\u1ec7c t\u00ednh to\u00e1n trong b\u1ea3ng nhanh ch\u00f3ng, ch\u00ednh x\u00e1c. T\u1eeb \u0111\u00f3, ng\u01b0\u1eddi d\u00f9ng c\u0169ng ti\u1ebft ki\u1ec7m th\u1eddi gian.","og_url":"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2022-11-22T01:23:11+00:00","article_modified_time":"2025-04-15T09:26:15+00:00","og_image":[{"width":600,"height":346,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-1.jpg","type":"image\/jpeg"}],"author":"Huy \u0110\u00e0m","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Huy \u0110\u00e0m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"10 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"H\u00e0m c\u1ed9ng tr\u1eeb trong Excel | H\u01b0\u1edbng d\u1eabn c\u00e1c c\u00e1ch s\u1eed d\u1ee5ng","datePublished":"2022-11-22T01:23:11+00:00","dateModified":"2025-04-15T09:26:15+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/"},"wordCount":1874,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-1.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/","name":"H\u01b0\u1edbng d\u1eabn c\u00e1c c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m c\u1ed9ng tr\u1eeb trong Excel","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-1.jpg","datePublished":"2022-11-22T01:23:11+00:00","dateModified":"2025-04-15T09:26:15+00:00","description":"S\u1eed d\u1ee5ng h\u00e0m c\u1ed9ng tr\u1eeb trong Excel gi\u00fap vi\u1ec7c t\u00ednh to\u00e1n trong b\u1ea3ng nhanh ch\u00f3ng, ch\u00ednh x\u00e1c. T\u1eeb \u0111\u00f3, ng\u01b0\u1eddi d\u00f9ng c\u0169ng ti\u1ebft ki\u1ec7m th\u1eddi gian.","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-1.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-cong-tru-trong-excel-1.jpg","width":600,"height":346,"caption":"H\u00e0m c\u00f4ng tr\u1eeb trong excel"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"H\u00e0m c\u1ed9ng tr\u1eeb trong Excel | H\u01b0\u1edbng d\u1eabn c\u00e1c c\u00e1ch s\u1eed d\u1ee5ng"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c","name":"Huy \u0110\u00e0m","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","caption":"Huy \u0110\u00e0m"},"url":"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12061","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=12061"}],"version-history":[{"count":2,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12061\/revisions"}],"predecessor-version":[{"id":24945,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12061\/revisions\/24945"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/12062"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=12061"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=12061"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=12061"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}