{"id":11944,"date":"2022-03-21T01:53:35","date_gmt":"2022-03-20T18:53:35","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=11944"},"modified":"2022-03-21T01:53:35","modified_gmt":"2022-03-20T18:53:35","slug":"ham-offset-la-gi","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/","title":{"rendered":"H\u00e0m Offset l\u00e0 g\u00ec v\u00e0 c\u00e1c \u0111i\u1ec1u c\u1ea7n l\u01b0u \u00fd c\u1ee7a h\u00e0m Offset trong Excel"},"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;11944&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;4&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&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;5\\\/5 - (4 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;H\u00e0m Offset l\u00e0 g\u00ec v\u00e0 c\u00e1c \u0111i\u1ec1u c\u1ea7n l\u01b0u \u00fd c\u1ee7a h\u00e0m Offset trong Excel&quot;,&quot;width&quot;:&quot;142.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: 142.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            5\/5 - (4 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p><span style=\"font-weight: 400\">Excel \u2013 c\u00e1i t\u00ean kh\u00f4ng c\u00f2n qu\u00e1 xa l\u1ea1 \u0111\u1ed1i v\u1edbi cu\u1ed9c s\u1ed1ng c\u1ee7a ch\u00fang ta n\u1eefa r\u1ed3i, khi m\u00e0 t\u1eeb c\u00f4ng vi\u1ec7c, h\u1ecdc h\u00e0nh h\u1eb1ng ng\u00e0y ch\u00fang ta \u0111\u1ec1u ph\u1ea3i s\u1eed d\u1ee5ng n\u00f3. V\u1eady b\u1ea1n \u0111\u00e3 hi\u1ec3u r\u00f5 h\u1ebft t\u1ea7n t\u1eadt v\u1ec1 Excel ch\u01b0a nh\u1ec9? H\u00f4m nay, ch\u00fang ta s\u1ebd c\u00f9ng nhau b\u00e0n lu\u1eadn v\u1ec1 <\/span><b><a href=\"https:\/\/teky.edu.vn\/blog\/\">h\u00e0m OFFSET l\u00e0 g\u00ec<\/a>, h\u00e0m OFFSET trong Excel l\u00e0 g\u00ec<\/b><span style=\"font-weight: 400\"> v\u00e0 n\u00f3 c\u00f3 \u1ee9ng d\u1ee5ng, l\u1ee3i \u00edch nh\u01b0 th\u1ebf n\u00e0o nh\u00e9!<\/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-offset-la-gi\/#Ham_OFFSET_la_gi\" >H\u00e0m OFFSET l\u00e0 g\u00ec?<\/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-offset-la-gi\/#Cu_phap_cua_ham_OFFSET\" >C\u00fa ph\u00e1p c\u1ee7a h\u00e0m OFFSET<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/#Cac_luu_y_khi_su_dung_ham_OFFSET\" >C\u00e1c l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m OFFSET<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/#Vi_du_co_ban_cua_ham_OFFSET\" >V\u00ed d\u1ee5 c\u01a1 b\u1ea3n c\u1ee7a h\u00e0m OFFSET\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/#Su_ket_hop_cua_ham_OFFSET_voi_cac_ham_khac_trong_Excel\" >S\u1ef1 k\u1ebft h\u1ee3p c\u1ee7a h\u00e0m OFFSET v\u1edbi c\u00e1c h\u00e0m kh\u00e1c trong Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/#Ket_hop_OFFSET_voi_ham_SUM_de_tinh_tong_pham_vi_duoc_tra_ve\" >K\u1ebft h\u1ee3p OFFSET v\u1edbi h\u00e0m SUM \u0111\u1ec3 t\u00ednh t\u1ed5ng ph\u1ea1m vi \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1<\/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-offset-la-gi\/#Ket_hop_ham_OFFSET_voi_ham_AVERAGE_de_tinh_gia_tri_trung_binh_cua_ham\" >K\u1ebft h\u1ee3p h\u00e0m OFFSET v\u1edbi h\u00e0m AVERAGE \u0111\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ee7a h\u00e0m.<\/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-offset-la-gi\/#_Ket_hop_voi_ham_MAX_de_tim_so_lon_nhat\" >\u00a0K\u1ebft h\u1ee3p v\u1edbi h\u00e0m MAX \u0111\u1ec3 t\u00ecm s\u1ed1 l\u1edbn nh\u1ea5t<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/#Ket_hop_voi_ham_MIN_de_tim_so_nho_nhat\" >K\u1ebft h\u1ee3p v\u1edbi h\u00e0m MIN \u0111\u1ec3 t\u00ecm s\u1ed1 nh\u1ecf nh\u1ea5t<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/#Ham_OFFSET_ket_hop_voi_ham_VLOOKUP_de_tra_cuu_thong_tin\" >H\u00e0m OFFSET k\u1ebft h\u1ee3p v\u1edbi h\u00e0m VLOOKUP \u0111\u1ec3 tra c\u1ee9u th\u00f4ng tin<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Ham_OFFSET_la_gi\"><\/span><span style=\"font-weight: 400\">H\u00e0m OFFSET l\u00e0 g\u00ec?<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">H\u00e0m OFFSET l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 xem, t\u00ednh to\u00e1n hay ph\u00e2n t\u00edch d\u1eef li\u1ec7u c\u1ee7a m\u1ed9t \u00f4 hay m\u1ed9t d\u00e3y trong b\u1ea3ng t\u00ednh Excel d\u1ef1a v\u00e0o m\u1ed9t v\u00f9ng tham chi\u1ebfu \u0111\u00e3 c\u00f3 s\u1eb5n tr\u01b0\u1edbc \u0111\u00f3.<\/span><\/p>\n<p><span style=\"font-weight: 400\">H\u00e0m OFFSET\u00a0 \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng trong Excel \u0111\u1ec3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Nhanh ch\u00f3ng v\u00e0 thu\u1eadn l\u1ee3i h\u01a1n khi t\u00ednh to\u00e1n, ph\u00e2n t\u00edch d\u1eef li\u1ec7u c\u1ee7a m\u1ed9t \u00f4 hay m\u1ed9t d\u00e3y trong b\u1ea3ng t\u00ednh.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">M\u1ed9t c\u00f4ng d\u1ee5ng kh\u00e1c n\u1eefa \u0111\u00f3 l\u00e0, k\u1ebft h\u1ee3p h\u00e0m OFFSET\u00a0 v\u1edbi c\u00e1c h\u00e0m kh\u00e1c trong Excel \u0111\u1ec3 h\u1ed7 tr\u1ee3 ho\u00e0n th\u00e0nh c\u00f4ng vi\u1ec7c nhanh h\u01a1n.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u00a0<\/span><span style=\"font-weight: 400\">B\u1ea1n s\u1ebd tr\u1edf n\u00ean chuy\u00ean nghi\u1ec7p h\u01a1n khi l\u00e0m c\u00e1c c\u00f4ng vi\u1ec7c li\u00ean quan \u0111\u1ebfn h\u00e0m Excel, l\u00e0 c\u01a1 h\u1ed9i gi\u00fap b\u1ea1n th\u0103ng ti\u1ebfn trong c\u00f4ng vi\u1ec7c, m\u1ed9t \u0111i\u1ec3m c\u1ed9ng trong m\u1eaft s\u1ebfp.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11957 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/13-3.jpg\" alt=\"\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/13-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/13-3-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cu_phap_cua_ham_OFFSET\"><\/span><span style=\"font-weight: 400\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m OFFSET<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: center\"><strong>OFFSET(reference, rows, cols, [height], [width])<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Reference: \u0111\u1ed1i s\u1ed1 b\u1eaft bu\u1ed9c, l\u00e0 v\u00f9ng tham chi\u1ebfu l\u00e0m c\u01a1 s\u1edf cho h\u00e0m t\u1ea1o v\u00f9ng tham chi\u1ebfu m\u1edbi.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Rows: \u0111\u1ed1i s\u1ed1 b\u1eaft bu\u1ed9c, l\u00e0 s\u1ed1 d\u00f2ng b\u00ean tr\u00ean ho\u1eb7c b\u00ean d\u01b0\u1edbi reference, t\u00ednh t\u1eeb \u00f4 \u0111\u1ea7u ti\u00ean (g\u00f3c b\u00ean tr\u00e1i) c\u1ee7a reference. Rows c\u00f3 th\u1ec3 s\u1ed1 \u00e2m, c\u00f3 s\u1ed1 th\u1ec3 d\u01b0\u01a1ng, n\u1ebfu s\u1ed1 \u00e2m th\u00ec c\u00e1c d\u00f2ng tr\u1ea3 v\u1ec1 n\u1eb1m b\u00ean tr\u00ean reference, n\u1ebfu s\u1ed1 d\u01b0\u01a1ng th\u00ec c\u00e1c d\u00f2ng tr\u1ea3 v\u1ec1 n\u1eb1m b\u00ean d\u01b0\u1edbi reference.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Cols: \u0111\u1ed1i s\u1ed1 b\u1eaft bu\u1ed9c, l\u00e0 s\u1ed1 c\u1ed9t b\u00ean tr\u00e1i ho\u1eb7c b\u00ean ph\u1ea3i reference, t\u00ednh t\u1eeb \u00f4 \u0111\u1ea7u ti\u00ean (g\u00f3c b\u00ean tr\u00e1i) c\u1ee7a reference. Cols c\u00f3 th\u1ec3 l\u00e0 s\u1ed1 \u00e2m, c\u00f3 th\u1ec3 l\u00e0 s\u1ed1 d\u01b0\u01a1ng, n\u1ebfu s\u1ed1 \u00e2m th\u00ec c\u00e1c c\u1ed9t tr\u1ea3 v\u1ec1 n\u1eb1m b\u00ean tr\u00e1i reference, n\u1ebfu s\u1ed1 d\u01b0\u01a1ng th\u00ec c\u00e1c c\u1ed9t n\u1eb1m b\u00ean ph\u1ea3i reference.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u00a0<\/span><span style=\"font-weight: 400\">[height]: l\u00e0 \u0111\u1ed1i s\u1ed1 t\u00f9y ch\u1ecdn bi\u1ec3u th\u1ecb cho s\u1ed1 d\u00f2ng c\u1ea7n tr\u1ea3 v\u1ec1 c\u1ee7a v\u00f9ng tham chi\u1ebfu.<\/span><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u00a0<\/span><span style=\"font-weight: 400\">[width]: l\u00e0 \u0111\u1ed1i s\u1ed1 t\u00f9y ch\u1ecdn bi\u1ec3u th\u1ecb cho s\u1ed1 c\u1ed9t c\u1ea7n tr\u1ea3 v\u1ec1 c\u1ee7a v\u00f9ng tham chi\u1ebfu.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11968 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/11-5.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/11-5.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/11-5-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/11-5-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p>&gt;&gt;&gt; Tham kh\u1ea3o th\u00eam: <a href=\"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/\"><em><span style=\"color: #0000ff\"><strong>H\u00e0m Offset trong Excel<\/strong><\/span><\/em><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cac_luu_y_khi_su_dung_ham_OFFSET\"><\/span><span style=\"font-weight: 400\">C\u00e1c l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m OFFSET<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Khi b\u00e1o l\u1ed7i #REF th\u00ec c\u00e1c \u0111\u1ed1i s\u1ed1 Rows v\u00e0 Cols \u0111\u00e3 l\u00e0m cho v\u00f9ng tham chi\u1ebfu tr\u1ea3 v\u1ec1 v\u01b0\u1ee3t kh\u1ecfi ph\u1ea1m vi c\u1ee7a trang t\u00ednh.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u00a0<\/span><span style=\"font-weight: 400\">Hai \u0111\u1ed1 s\u1ed1 height v\u00e0 width th\u00ec lu\u00f4n ph\u1ea3i l\u00e0 s\u1ed1 d\u01b0\u01a1ng.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">N\u1ebfu b\u1ecf qua hai \u0111\u1ed1i s\u1ed1 height v\u00e0 width th\u00ec tham chi\u1ebfu tr\u1ea3 v\u1ec1 m\u1eb7c \u0111\u1ecbnh c\u00f3 c\u00f9ng chi\u1ec1u cao v\u00e0 \u0111\u1ed9 r\u1ed9ng v\u1edbi v\u00f9ng tham chi\u1ebfu.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">N\u1ebfu c\u00e1c \u0111\u1ed1i s\u1ed1 height v\u00e0 width &gt;1 th\u00ec c\u00f3 ngh\u0129a l\u00e0 h\u00e0m ph\u1ea3i tr\u1ea3 v\u1ec1 nhi\u1ec1u h\u01a1n 1 \u00f4, \u0111\u1ec3 kh\u00f4ng nh\u1eadn l\u1ed7i #VALUE th\u00ec c\u00e1c b\u1ea1n ph\u1ea3i s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng h\u00e0m OFFSET.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">H\u00e0m OFFSET ch\u1ec9 tr\u1ea3 v\u1ec1 m\u1ed9t tham chi\u1ebfu n\u00ean s\u1ebd kh\u00f4ng di chuy\u1ec3n hay l\u00e0m thay \u0111\u1ed5i b\u1ea5t k\u1ef3 ph\u1ea7n n\u00e0o \u0111\u01b0\u1ee3c ch\u1ecdn. Ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m OFFSET k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m c\u1ea7n \u0111\u1ebfn m\u1ed9t \u0111\u1ed1i s\u1ed1 tham chi\u1ebfu.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\"> <img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11965 size-full aligncenter\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-11.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-11.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-11-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-11-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Vi_du_co_ban_cua_ham_OFFSET\"><\/span><span style=\"font-weight: 400\">V\u00ed d\u1ee5 c\u01a1 b\u1ea3n c\u1ee7a h\u00e0m OFFSET\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">N\u00f3i s\u01a1 qua l\u00fd thuy\u1ebft v\u1ec1 <strong>h\u00e0m OFFSET l\u00e0 g\u00ec<\/strong> nghe c\u00f3 v\u1ebb tr\u1eebu t\u01b0\u1ee3ng, d\u01b0\u1edbi \u0111\u00e2y l\u00e0 v\u00ed d\u1ee5 c\u01a1 b\u1ea3n minh h\u1ecda. Cho qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng h\u00e0m OFFSET \u0111\u1ec3 c\u00e1c b\u1ea1n h\u00ecnh dung r\u00f5 h\u01a1n. C\u00e1ch th\u1ef1c hi\u1ec7n h\u1ea7u nh\u01b0 l\u00e0 gi\u1ed1ng nhau tr\u00ean c\u00e1c phi\u00ean b\u1ea3n Excel 2007, 2010, 2013, 2016, 2019 v\u00e0 MacOS.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec1 b\u00e0i: H\u00e3y s\u1eed d\u1ee5ng h\u00e0m OFFSET \u0111\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb \u00f4 \u1edf v\u1ecb tr\u00ed c\u1ed9t 2, d\u00f2ng 3 trong b\u1ea3ng d\u1eef li\u1ec7u sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">B\u01b0\u1edbc 1: Trong b\u1ea3ng t\u00ednh Excel, b\u1ea1n nh\u1eadp h\u00e0m =OFFSET(B3,3,2). V\u00e0o tham chi\u1ebfu m\u00e0 ch\u00fang ta mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11955 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/11-4.jpg\" alt=\"\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/11-4.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/11-4-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">B\u01b0\u1edbc 2: Nh\u1ea5n ph\u00edm Enter v\u00e0 xem k\u1ebft qu\u1ea3 c\u1ea7n t\u00ecm.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11953 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-7.jpg\" alt=\"\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-7.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-7-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_ket_hop_cua_ham_OFFSET_voi_cac_ham_khac_trong_Excel\"><\/span><span style=\"font-weight: 400\">S\u1ef1 k\u1ebft h\u1ee3p c\u1ee7a h\u00e0m OFFSET v\u1edbi c\u00e1c h\u00e0m kh\u00e1c trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Ngo\u00e0i s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh \u0111\u1ed9c l\u1eadp, th\u00ec l\u1ef1a ch\u1ecdn k\u1ebft h\u1ee3p <strong>h\u00e0m OFFSET l\u00e0 g\u00ec<\/strong> v\u1edbi h\u00e0m kh\u00e1c trong Excel. C\u0169ng t\u1ea1o ra c\u00e1c ph\u00e9p t\u00ednh m\u1edbi s\u1ebd gi\u00fap gi\u1ea3i quy\u1ebft c\u00e1c v\u1ea5n \u0111\u1ec1 nhanh ch\u00f3ng v\u00e0 ti\u1ec7n l\u1ee3i. V\u00ed d\u1ee5 nh\u01b0 k\u1ebft h\u1ee3p v\u1edbi h\u00e0m SUM, AVERAGE, MIN, MAX,..<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ket_hop_OFFSET_voi_ham_SUM_de_tinh_tong_pham_vi_duoc_tra_ve\"><\/span><span style=\"font-weight: 400\">K\u1ebft h\u1ee3p OFFSET v\u1edbi h\u00e0m SUM \u0111\u1ec3 t\u00ednh t\u1ed5ng ph\u1ea1m vi \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5 1: T\u00ednh t\u1ed5ng ti\u1ec1n h\u00e0ng c\u1ee7a t\u1ea5t c\u1ea3 s\u1ea3n ph\u1ea9m theo d\u1eef li\u1ec7u sau \u0111\u00e2y.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ch\u00fang ta c\u00f3 th\u1ec3 tham chi\u1ebfu b\u1eaft \u0111\u1ea7u t\u1eeb \u00f4 A1 sau \u0111\u00f3 ph\u1ea3i di chuy\u1ec3n xu\u1ed1ng 1 h\u00e0ng, sang ph\u1ea3i 5 h\u00e0ng. Sau \u0111\u00f3 l\u1ea5y 10 d\u00f2ng v\u00e0 m\u1ed9t c\u1ed9t.<\/span><span style=\"font-weight: 400\">\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">T\u1eeb \u0111\u00f3 k\u1ebft h\u1ee3p l\u1ea1i ta c\u00f3 c\u00f4ng th\u1ee9c: =SUM(OFFSET(A1;1;5;10;1)).<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11954 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/10-5.jpg\" alt=\"\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/10-5.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/10-5-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">Ho\u1eb7c c\u00e1ch kh\u00e1c, tham chi\u1ebfu b\u1eaft \u0111\u1ea7u t\u1eeb \u00f4 C3. Sau \u0111\u00f3 di chuy\u1ec3n l\u00ean 1 h\u00e0ng v\u00e0 sang ph\u1ea3i 3 d\u00f2ng, sau \u0111\u00f3 10 d\u00f2ng v\u00e0 1 c\u1ed9t.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Suy ra ta c\u00f3 c\u00f4ng th\u1ee9c : <\/span><span style=\"font-weight: 400\">=SUM(OFFSET(C3;-1;3;10;1)).\u00a0 V\u00e0 k\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c l\u00e0 nh\u01b0 nhau.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11951 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-14.jpg\" alt=\"\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-14.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-14-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ket_hop_ham_OFFSET_voi_ham_AVERAGE_de_tinh_gia_tri_trung_binh_cua_ham\"><\/span><span style=\"font-weight: 400\">K\u1ebft h\u1ee3p h\u00e0m OFFSET v\u1edbi h\u00e0m AVERAGE \u0111\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ee7a h\u00e0m.<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5 2: H\u00e3y t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u sau.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ee7a b\u1ea3ng l\u00e0, <\/span><span style=\"font-weight: 400\">t\u01b0\u01a1ng t\u1ef1 v\u1edbi c\u00e1ch t\u00ednh ti\u1ec1n th\u01b0\u1edfng cho <\/span><i><span style=\"font-weight: 400\">n <\/span><\/i><span style=\"font-weight: 400\">th\u00e1ng, ch\u00fang ta c\u0169ng c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh cho <\/span><i><span style=\"font-weight: 400\">n <\/span><\/i><span style=\"font-weight: 400\">tu\u1ea7n, <\/span><i><span style=\"font-weight: 400\">n <\/span><\/i><span style=\"font-weight: 400\">ng\u00e0y hay <\/span><i><span style=\"font-weight: 400\">n <\/span><\/i><span style=\"font-weight: 400\">n\u0103m.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ta c\u00f3 c\u00f4ng th\u1ee9c l\u00e0: =AVERAGE(OFFSET(B1,COUNT(B:B)-E2+1,0,E2,1)).<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11950 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-14.jpg\" alt=\"\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-14.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-14-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">\u00a0Nh\u1ea5n Enter v\u00e0 nh\u1eadn k\u1ebft qu\u1ea3.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11949 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-13.jpg\" alt=\"\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-13.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-13-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"_Ket_hop_voi_ham_MAX_de_tim_so_lon_nhat\"><\/span><span style=\"font-weight: 400\">\u00a0<\/span><span style=\"font-weight: 400\">K\u1ebft h\u1ee3p v\u1edbi h\u00e0m MAX \u0111\u1ec3 t\u00ecm s\u1ed1 l\u1edbn nh\u1ea5t<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5 3: T\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t trong b\u1ea3ng t\u00ednh:<\/span><\/p>\n<p><span style=\"font-weight: 400\">Gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t l\u00e0:<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ta c\u00f3 c\u00f4ng th\u1ee9c: =MAX(OFFSET(B1,COUNT(B:B)-E2+1,0,E2,1)).<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11952 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-10.jpg\" alt=\"\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-10.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-10-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">\u00a0Nh\u1ea5n Enter v\u00e0 nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11947 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-16.jpg\" alt=\"\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-16.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-16-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ket_hop_voi_ham_MIN_de_tim_so_nho_nhat\"><\/span><span style=\"font-weight: 400\">K\u1ebft h\u1ee3p v\u1edbi h\u00e0m MIN \u0111\u1ec3 t\u00ecm s\u1ed1 nh\u1ecf nh\u1ea5t<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5 4: T\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong b\u1ea3ng t\u00ednh:<\/span><\/p>\n<p><span style=\"font-weight: 400\">Gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t l\u00e0:<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ta c\u00f3 c\u00f4ng th\u1ee9c: MIN(OFFSET(B1,COUNT(B:B)-E2+1,0,E2,1)).<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11948 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-15.jpg\" alt=\"\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-15.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-15-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">Nh\u1ea5n Enter v\u00e0 nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11946 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-15.jpg\" alt=\"\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-15.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-15-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ham_OFFSET_ket_hop_voi_ham_VLOOKUP_de_tra_cuu_thong_tin\"><\/span><span style=\"font-weight: 400\">H\u00e0m OFFSET k\u1ebft h\u1ee3p v\u1edbi h\u00e0m VLOOKUP \u0111\u1ec3 tra c\u1ee9u th\u00f4ng tin<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">H\u00e0m VLOOKUP trong Excel c\u00f3 m\u1ed9t h\u1ea1n ch\u1ebf \u0111\u00f3 l\u00e0 ch\u1ec9 c\u00f3 kh\u1ea3 n\u0103ng tr\u1ea3 l\u1ea1i m\u1ed9t gi\u00e1 tr\u1ecb nh\u1ea5t \u0111\u1ecbnh. \u1ede b\u00ean ph\u1ea3i c\u1ed9t tra c\u1ee9u n\u00ean \u1ea3nh h\u01b0\u1edfng r\u1ea5t nhi\u1ec1u \u0111\u1ebfn ti\u1ebfn \u0111\u1ed9 l\u00e0m vi\u1ec7c. V\u00ec th\u1ebf c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m OFFSET k\u1ebft h\u1ee3p h\u00e0m VLOOKUP \u0111\u1ec3 tra c\u1ee9u d\u1eef li\u1ec7u b\u00ean tr\u00e1i trong file Excel.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5 5: D\u00f9ng h\u00e0m OFFSET k\u1ebft h\u1ee3p v\u1edbi h\u00e0m VLOOKUP \u0111\u1ec3 hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb l\u01b0\u01a1ng th\u00e1ng 3 trong b\u1ea3ng sau:<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ta c\u00f3 c\u00f4ng th\u1ee9c: =VLOOKUP(B1,A5:B11,2,FALSE).<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11945 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-16.jpg\" alt=\"\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-16.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-16-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">Nh\u1ea5n Enter v\u00e0 nh\u1eadn k\u1ebft qu\u1ea3 c\u1ea7n t\u00ecm.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11962 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-14.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-14.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-14-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-14-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">Tr\u00ean \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 \u1ee9ng d\u1ee5ng m\u00e0 h\u00e0m OFFSET mang l\u1ea1i. Ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m OFFSET trong b\u1ea3ng t\u00ednh \u0111\u1ec3 nh\u1eadn l\u1ea1i k\u1ebft qu\u1ea3 nhanh, ch\u00ednh x\u00e1c nh\u1ea5t.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong cu\u1ed9c s\u1ed1ng hi\u1ec7n nay, h\u1ea7u nh\u01b0 c\u00e1c c\u00f4ng vi\u1ec7c li\u00ean quan \u0111\u1ebfn gi\u1ea5y t\u1edd \u0111\u1ec1u ph\u1ea3i d\u00f9ng \u0111\u1ebfn Excel. Ngay c\u1ea3 khi \u0111ang l\u00e0 h\u1ecdc sinh c\u00e1c b\u1ea1n c\u0169ng \u0111\u01b0\u1ee3c bi\u1ebft v\u1ec1 t\u1ea7m quan tr\u1ecdng c\u1ee7a b\u1ea3ng t\u00ednh n\u00e0y r\u1ed3i. V\u00ec th\u1ebf ch\u00fang ta c\u1ea7n ph\u1ea3i h\u1ecdc c\u00e1c th\u1ee7 thu\u1eadt, ph\u00edm t\u1eaft \u0111\u1ec3 ho\u00e0n th\u00e0nh c\u00f4ng vi\u1ec7c nhanh ch\u00ednh h\u01a1n. V\u1eady l\u00e0 h\u00f4m nay ch\u00fang ta \u0111\u00e3 c\u00f9ng t\u00ecm hi\u1ec3u <\/span><b>h\u00e0m OFFSET l\u00e0 g\u00ec<\/b><span style=\"font-weight: 400\">, <\/span><b>h\u00e0m OFFSET trong Excel l\u00e0 g\u00ec<\/b><span style=\"font-weight: 400\"> v\u00e0 c\u00e1c \u1ee9ng d\u1ee5ng c\u1ea7n thi\u1ebft c\u1ee7a h\u00e0m. \u0110\u1eebng ch\u1ea7n ch\u1edd g\u00ec n\u1eefa m\u00e0 kh\u00f4ng l\u01b0u l\u1ea1i \u0111\u1ec3 khi c\u1ea7n c\u00f3 c\u00e1i m\u00e0 d\u00f9ng.<\/span><\/p>\n<p>&gt;&gt;&gt; Tham kh\u1ea3o th\u00eam: <a href=\"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/\"><span style=\"color: #0000ff\"><em><strong>T\u00e1ch ch\u1eef trong excel<\/strong><\/em><\/span><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel \u2013 c\u00e1i t\u00ean kh\u00f4ng c\u00f2n qu\u00e1 xa l\u1ea1 \u0111\u1ed1i v\u1edbi cu\u1ed9c s\u1ed1ng c\u1ee7a ch\u00fang ta n\u1eefa r\u1ed3i, khi m\u00e0 t\u1eeb c\u00f4ng vi\u1ec7c, h\u1ecdc h\u00e0nh h\u1eb1ng ng\u00e0y ch\u00fang ta \u0111\u1ec1u ph\u1ea3i s\u1eed d\u1ee5ng n\u00f3. V\u1eady b\u1ea1n \u0111\u00e3 hi\u1ec3u r\u00f5 h\u1ebft t\u1ea7n t\u1eadt v\u1ec1 Excel ch\u01b0a nh\u1ec9? H\u00f4m nay, ch\u00fang ta s\u1ebd c\u00f9ng nhau b\u00e0n lu\u1eadn &hellip;<\/p>\n","protected":false},"author":26,"featured_media":11960,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-11944","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\u00e0m Offset l\u00e0 g\u00ec v\u00e0 c\u00e1c \u0111i\u1ec1u c\u1ea7n l\u01b0u \u00fd c\u1ee7a h\u00e0m Offset trong Excel<\/title>\n<meta name=\"description\" content=\"V\u1eady b\u1ea1n \u0111\u00e3 hi\u1ec3u r\u00f5 h\u1ebft t\u1ea7n t\u1eadt v\u1ec1 Excel ch\u01b0a nh\u1ec9? H\u00f4m nay, ch\u00fang ta s\u1ebd c\u00f9ng nhau b\u00e0n lu\u1eadn v\u1ec1 h\u00e0m OFFSET l\u00e0 g\u00ec v\u00e0 n\u00f3 c\u00f3 \u1ee9ng d\u1ee5ng, l\u1ee3i \u00edch nh\u01b0 th\u1ebf n\u00e0o nh\u00e9!\" \/>\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-offset-la-gi\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m Offset l\u00e0 g\u00ec v\u00e0 c\u00e1c \u0111i\u1ec1u c\u1ea7n l\u01b0u \u00fd c\u1ee7a h\u00e0m Offset trong Excel\" \/>\n<meta property=\"og:description\" content=\"V\u1eady b\u1ea1n \u0111\u00e3 hi\u1ec3u r\u00f5 h\u1ebft t\u1ea7n t\u1eadt v\u1ec1 Excel ch\u01b0a nh\u1ec9? H\u00f4m nay, ch\u00fang ta s\u1ebd c\u00f9ng nhau b\u00e0n lu\u1eadn v\u1ec1 h\u00e0m OFFSET l\u00e0 g\u00ec v\u00e0 n\u00f3 c\u00f3 \u1ee9ng d\u1ee5ng, l\u1ee3i \u00edch nh\u01b0 th\u1ebf n\u00e0o nh\u00e9!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/\" \/>\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-03-20T18:53:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-17.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"H\u1eb1ng L\u00ea\" \/>\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=\"H\u1eb1ng L\u00ea\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 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-offset-la-gi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/\"},\"author\":{\"name\":\"H\u1eb1ng L\u00ea\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b\"},\"headline\":\"H\u00e0m Offset l\u00e0 g\u00ec v\u00e0 c\u00e1c \u0111i\u1ec1u c\u1ea7n l\u01b0u \u00fd c\u1ee7a h\u00e0m Offset trong Excel\",\"datePublished\":\"2022-03-20T18:53:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/\"},\"wordCount\":1854,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-17.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/\",\"name\":\"H\u00e0m Offset l\u00e0 g\u00ec v\u00e0 c\u00e1c \u0111i\u1ec1u c\u1ea7n l\u01b0u \u00fd c\u1ee7a h\u00e0m Offset trong Excel\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-17.jpg\",\"datePublished\":\"2022-03-20T18:53:35+00:00\",\"description\":\"V\u1eady b\u1ea1n \u0111\u00e3 hi\u1ec3u r\u00f5 h\u1ebft t\u1ea7n t\u1eadt v\u1ec1 Excel ch\u01b0a nh\u1ec9? H\u00f4m nay, ch\u00fang ta s\u1ebd c\u00f9ng nhau b\u00e0n lu\u1eadn v\u1ec1 h\u00e0m OFFSET l\u00e0 g\u00ec v\u00e0 n\u00f3 c\u00f3 \u1ee9ng d\u1ee5ng, l\u1ee3i \u00edch nh\u01b0 th\u1ebf n\u00e0o nh\u00e9!\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-17.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-17.jpg\",\"width\":600,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/#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 Offset l\u00e0 g\u00ec v\u00e0 c\u00e1c \u0111i\u1ec1u c\u1ea7n l\u01b0u \u00fd c\u1ee7a h\u00e0m Offset trong Excel\"}]},{\"@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\/aba2a2e5a9eb4e0b390280d28d910d8b\",\"name\":\"H\u1eb1ng L\u00ea\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g\",\"caption\":\"H\u1eb1ng L\u00ea\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/lehang\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u00e0m Offset l\u00e0 g\u00ec v\u00e0 c\u00e1c \u0111i\u1ec1u c\u1ea7n l\u01b0u \u00fd c\u1ee7a h\u00e0m Offset trong Excel","description":"V\u1eady b\u1ea1n \u0111\u00e3 hi\u1ec3u r\u00f5 h\u1ebft t\u1ea7n t\u1eadt v\u1ec1 Excel ch\u01b0a nh\u1ec9? H\u00f4m nay, ch\u00fang ta s\u1ebd c\u00f9ng nhau b\u00e0n lu\u1eadn v\u1ec1 h\u00e0m OFFSET l\u00e0 g\u00ec v\u00e0 n\u00f3 c\u00f3 \u1ee9ng d\u1ee5ng, l\u1ee3i \u00edch nh\u01b0 th\u1ebf n\u00e0o nh\u00e9!","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-offset-la-gi\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m Offset l\u00e0 g\u00ec v\u00e0 c\u00e1c \u0111i\u1ec1u c\u1ea7n l\u01b0u \u00fd c\u1ee7a h\u00e0m Offset trong Excel","og_description":"V\u1eady b\u1ea1n \u0111\u00e3 hi\u1ec3u r\u00f5 h\u1ebft t\u1ea7n t\u1eadt v\u1ec1 Excel ch\u01b0a nh\u1ec9? H\u00f4m nay, ch\u00fang ta s\u1ebd c\u00f9ng nhau b\u00e0n lu\u1eadn v\u1ec1 h\u00e0m OFFSET l\u00e0 g\u00ec v\u00e0 n\u00f3 c\u00f3 \u1ee9ng d\u1ee5ng, l\u1ee3i \u00edch nh\u01b0 th\u1ebf n\u00e0o nh\u00e9!","og_url":"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/","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-03-20T18:53:35+00:00","og_image":[{"width":600,"height":400,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-17.jpg","type":"image\/jpeg"}],"author":"H\u1eb1ng L\u00ea","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"H\u1eb1ng L\u00ea","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"9 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/"},"author":{"name":"H\u1eb1ng L\u00ea","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b"},"headline":"H\u00e0m Offset l\u00e0 g\u00ec v\u00e0 c\u00e1c \u0111i\u1ec1u c\u1ea7n l\u01b0u \u00fd c\u1ee7a h\u00e0m Offset trong Excel","datePublished":"2022-03-20T18:53:35+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/"},"wordCount":1854,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-17.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/","url":"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/","name":"H\u00e0m Offset l\u00e0 g\u00ec v\u00e0 c\u00e1c \u0111i\u1ec1u c\u1ea7n l\u01b0u \u00fd c\u1ee7a h\u00e0m Offset trong Excel","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-17.jpg","datePublished":"2022-03-20T18:53:35+00:00","description":"V\u1eady b\u1ea1n \u0111\u00e3 hi\u1ec3u r\u00f5 h\u1ebft t\u1ea7n t\u1eadt v\u1ec1 Excel ch\u01b0a nh\u1ec9? H\u00f4m nay, ch\u00fang ta s\u1ebd c\u00f9ng nhau b\u00e0n lu\u1eadn v\u1ec1 h\u00e0m OFFSET l\u00e0 g\u00ec v\u00e0 n\u00f3 c\u00f3 \u1ee9ng d\u1ee5ng, l\u1ee3i \u00edch nh\u01b0 th\u1ebf n\u00e0o nh\u00e9!","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-17.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-17.jpg","width":600,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/ham-offset-la-gi\/#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 Offset l\u00e0 g\u00ec v\u00e0 c\u00e1c \u0111i\u1ec1u c\u1ea7n l\u01b0u \u00fd c\u1ee7a h\u00e0m Offset trong Excel"}]},{"@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\/aba2a2e5a9eb4e0b390280d28d910d8b","name":"H\u1eb1ng L\u00ea","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g","caption":"H\u1eb1ng L\u00ea"},"url":"https:\/\/teky.edu.vn\/blog\/author\/lehang\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11944","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\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=11944"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11944\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/11960"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=11944"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=11944"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=11944"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}