{"id":11010,"date":"2022-11-10T08:15:27","date_gmt":"2022-11-10T01:15:27","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=11010"},"modified":"2022-12-19T11:14:16","modified_gmt":"2022-12-19T04:14:16","slug":"cach-co-dinh-o-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel nhanh ch\u00f3ng nh\u1ea5t"},"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;11010&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;6&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;4.3&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.3\\\/5 - (6 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;H\u01b0\u1edbng d\u1eabn c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel nhanh ch\u00f3ng nh\u1ea5t&quot;,&quot;width&quot;:&quot;122.2&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: 122.2px;\">\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.3\/5 - (6 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p style=\"text-align: justify;\"><em>Vi\u1ec7c c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel l\u00e0 r\u1ea5t quan tr\u1ecdng v\u00e0 c\u1ea7n thi\u1ebft n\u1ebfu b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n c\u00f3 qu\u00e1 nhi\u1ec1u c\u1ed9t v\u00e0 nhi\u1ec1u h\u00e0ng. \u0110\u1ec3 thu\u1eadn ti\u1ec7n cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 chuy\u00ean nghi\u1ec7p h\u01a1n. Trong b\u00e0i vi\u1ebft n\u00e0y, Teky.edu.vn s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng nh\u1ea5t.<\/em><\/p>\n<p style=\"text-align: justify;\"><!--more--><\/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\/cach-co-dinh-o-trong-excel\/#Muc_dich_co_dinh_o_trong_Excel_la_gi\" >M\u1ee5c \u0111\u00edch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel l\u00e0 g\u00ec?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/#Co_dinh_o_khi_thuc_hien_sao_chep_cong_thuc_trong_excel\" >C\u1ed1 \u0111\u1ecbnh \u00f4 khi th\u1ef1c hi\u1ec7n sao ch\u00e9p c\u00f4ng th\u1ee9c trong excel<\/a><\/li><\/ul><\/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\/cach-co-dinh-o-trong-excel\/#Huong_dan_cach_co_dinh_dia_chi_o_trong_Excel_don_gian\" >H\u01b0\u1edbng d\u1eabn c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u0111\u1ecba ch\u1ec9 \u00f4 trong Excel \u0111\u01a1n gi\u1ea3n<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/#Tim_hieu_ky_hieu_trong_Excel_la_gi\" >T\u00ecm hi\u1ec3u k\u00fd hi\u1ec7u $ trong Excel l\u00e0 g\u00ec?<\/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\/cach-co-dinh-o-trong-excel\/#Huong_dan_cach_co_dinh_o_trong_Excel\" >H\u01b0\u1edbng d\u1eabn c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 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\/cach-co-dinh-o-trong-excel\/#Huong_dan_co_dinh_ham_trong_Excel\" >H\u01b0\u1edbng d\u1eabn c\u1ed1 \u0111\u1ecbnh h\u00e0m trong Excel<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/#Co_dinh_o_khong_bi_di_chuyen_khi_cuon_cot_hoac_hang\" >C\u1ed1 \u0111\u1ecbnh \u00f4 kh\u00f4ng b\u1ecb di chuy\u1ec3n khi cu\u1ed9n c\u1ed9t ho\u1eb7c h\u00e0ng<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/#Muc_dich_co_dinh_cot_hang_trong_Excel\" >M\u1ee5c \u0111\u00edch c\u1ed1 \u0111\u1ecbnh c\u1ed9t, h\u00e0ng trong Excel<\/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\/cach-co-dinh-o-trong-excel\/#Huong_dan_cach_co_dinh_cot_va_dong_trong_Excel\" >H\u01b0\u1edbng d\u1eabn c\u00e1ch c\u1ed1 \u0111\u1ecbnh c\u1ed9t v\u00e0 d\u00f2ng trong Excel<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/#Cach_co_dinh_cot_trong_Excel\" >C\u00e1ch c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/#Cach_co_dinh_dong_trong_Excel\" >C\u00e1ch c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/#Co_dinh_nhieu_cot_va_nhieu_dong\" >C\u1ed1 \u0111\u1ecbnh nhi\u1ec1u c\u1ed9t v\u00e0 nhi\u1ec1u d\u00f2ng<\/a><\/li><\/ul><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/#Cach_bo_co_dinh_dong_cot_trong_excel\" >C\u00e1ch b\u1ecf c\u1ed1 \u0111\u1ecbnh d\u00f2ng, c\u1ed9t trong excel<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Muc_dich_co_dinh_o_trong_Excel_la_gi\"><\/span><strong>M\u1ee5c \u0111\u00edch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel l\u00e0 g\u00ec?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Co_dinh_o_khi_thuc_hien_sao_chep_cong_thuc_trong_excel\"><\/span><strong>C\u1ed1 \u0111\u1ecbnh \u00f4 khi th\u1ef1c hi\u1ec7n sao ch\u00e9p c\u00f4ng th\u1ee9c trong excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\">Khi b\u1ea1n th\u1ef1c hi\u1ec7n sao ch\u00e9p c\u00f4ng th\u1ee9c, vi\u1ec7c c\u1ed1 \u0111\u1ecbnh \u0111\u1ecba ch\u1ec9 \u00f4 trong Excel. S\u1ebd gi\u00fap b\u1ea1n th\u1ef1c hi\u1ec7n d\u1ec5 d\u00e0ng h\u01a1n v\u1edbi c\u00e1c d\u1eef li\u1ec7u. r\u1ea5t nhi\u1ec1u. B\u1edfi khi b\u1ea1n di chuy\u1ec3n hay sao ch\u00e9p c\u00f4ng th\u1ee9c, s\u1ebd c\u00f3 nh\u1eefng \u0111\u1ecba ch\u1ec9 \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n c\u1ed1 \u0111\u1ecbnh. Kh\u00f4ng thay \u0111\u1ed5i v\u00e0 c\u00f3 nh\u1eefng \u00f4 c\u1ea7n l\u1ea1i c\u1ea7n thay \u0111\u1ed5i. N\u1ebfu b\u1ea1n hi\u1ec3u r\u00f5 c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel th\u00ec b\u1ea1n s\u1ebd th\u1ef1c hi\u1ec7n d\u1ec5 d\u00e0ng. V\u00e0 linh ho\u1ea1t h\u01a1n r\u1ea5t nhi\u1ec1u trong khi l\u00e0m vi\u1ec7c. \u0110\u1ed3ng th\u1eddi, t\u1ea1o \u0111\u01b0\u1ee3c s\u1ef1 chuy\u00ean nghi\u1ec7p c\u1ee7a b\u1ea1n khi l\u00e0m b\u00e1o c\u00e1o hay nh\u1eadp li\u1ec7u d\u1eef li\u1ec7u.<\/p>\n<p><iframe loading=\"lazy\" title=\"H\u1ecdc Excel - C\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/8T-xOl1C5wo?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<p style=\"text-align: justify;\">V\u00ed d\u1ee5 nh\u01b0 h\u00ecnh:<\/p>\n<figure id=\"attachment_11103\" aria-describedby=\"caption-attachment-11103\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11103 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h1-1.png\" alt=\"c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h1-1.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h1-1-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h1-1-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11103\" class=\"wp-caption-text\">c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Huong_dan_cach_co_dinh_dia_chi_o_trong_Excel_don_gian\"><\/span><strong>H\u01b0\u1edbng d\u1eabn c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u0111\u1ecba ch\u1ec9 \u00f4 trong Excel \u0111\u01a1n gi\u1ea3n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\">Tr\u01b0\u1edbc ti\u00ean \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel. Ch\u00fang ta c\u1ea7n t\u00ecm hi\u1ec3u v\u1ec1 k\u00fd t\u1ef1 $ trong excel l\u00e0 g\u00ec, \u0111\u1ec3 b\u1ea1n hi\u1ec3u r\u00f5 v\u00e0 d\u1ec5 d\u00e0ng th\u1ef1c hi\u1ec7n h\u01a1n.<\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tim_hieu_ky_hieu_trong_Excel_la_gi\"><\/span><strong>T\u00ecm hi\u1ec3u k\u00fd hi\u1ec7u $ trong Excel l\u00e0 g\u00ec?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\">K\u00fd hi\u1ec7u $ l\u00e0 m\u1ed9t trong nh\u1eefng k\u00fd t\u1ef1 th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong Microsoft Excel. D\u00f9ng khi th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c d\u1eef li\u1ec7u tr\u00ean m\u1ed9t b\u1ea3ng t\u00ednh. T\u00e1c d\u1ee5ng c\u1ee7a k\u00fd t\u1ef1 n\u00e0y l\u00e0 \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel. Hay c\u00f2n g\u1ecdi c\u00e1ch kh\u00e1c l\u00e0 kh\u00f3a gi\u00e1 tr\u1ecb trong excel. Khi c\u00e1c b\u1ea1n s\u1eed d\u1ee5ng k\u00fd hi\u1ec7u n\u00e0y trong m\u1ed9t c\u00f4ng th\u1ee9c hay m\u1ed9t h\u00e0m. V\u00f9ng d\u1eef li\u1ec7u hay gi\u00e1 tr\u1ecb c\u00f3 ch\u1ee9a k\u00fd hi\u1ec7u n\u00e0y s\u1ebd kh\u00f4ng b\u1ecb thay \u0111\u1ed5i m\u00e0 \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh khi b\u1ea1n sao ch\u00e9p hay k\u00e9o th\u1ea3 c\u00f4ng th\u1ee9c.<\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Huong_dan_cach_co_dinh_o_trong_Excel\"><\/span><strong>H\u01b0\u1edbng d\u1eabn c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\">Thao t\u00e1c n\u00e0y r\u1ea5t \u0111\u01a1n gi\u1ea3n, sau khi l\u1ef1a ch\u1ecdn v\u00f9ng \u0111\u1ecba ch\u1ec9. \u0110\u1ec3 c\u1ed1 \u0111\u1ecbnh \u00f4 tham chi\u1ebfu trong Excel, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n F4 tr\u00ean b\u00e0n ph\u00edm. \u0110\u00e2y ch\u00ednh l\u00e0 ph\u00edm c\u1ed1 \u0111\u1ecbnh trong excel tr\u00ean m\u00e1y t\u00ednh b\u00e0n hay laptop m\u00e0 b\u1ea1n c\u1ea7n ghi nh\u1edb. Sau khi ho\u00e0n th\u00e0nh c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel. \u0110\u1ecba ch\u1ec9 trong c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n s\u1ebd c\u00f3 d\u1ea1ng nh\u01b0 sau.<\/p>\n<figure id=\"attachment_11104\" aria-describedby=\"caption-attachment-11104\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11104 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h2-1.png\" alt=\"c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h2-1.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h2-1-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h2-1-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11104\" class=\"wp-caption-text\">c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel<\/figcaption><\/figure>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Huong_dan_co_dinh_ham_trong_Excel\"><\/span><strong>H\u01b0\u1edbng d\u1eabn c\u1ed1 \u0111\u1ecbnh h\u00e0m trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\">Ngo\u00e0i vi\u1ec7c c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel, k\u00fd hi\u1ec7u $ c\u00f2n \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh h\u00e0m trong excel. C\u00f3 3 ki\u1ec3u c\u1ed1 \u0111\u1ecbnh \u00f4 ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u nh\u01b0 b\u00ean d\u01b0\u1edbi:<\/p>\n<ul style=\"list-style-type: circle; text-align: justify;\">\n<li><strong>B$1:<\/strong> K\u00fd t\u1ef1 $ n\u1eb1m \u1edf gi\u1eefa s\u1ed1 v\u00e0 ch\u1eef: c\u00f3 ngh\u0129a l\u00e0 c\u1ed1 \u0111\u1ecbnh d\u00f2ng nh\u01b0ng kh\u00f4ng c\u1ed1 \u0111\u1ecbnh c\u1ed9t. Khi b\u1ea1n copy c\u00f4ng th\u1ee9c sang m\u1ed9t c\u1ed9t kh\u00e1c th\u00ec ch\u1ec9 c\u00f3 \u0111\u1ecba ch\u1ec9 c\u1ee7a c\u1ed9t \u0111\u01b0\u1ee3c thay \u0111\u1ed5i v\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 d\u00f2ng kh\u00f4ng thay \u0111\u1ed5i.<\/li>\n<li><strong>$B1:<\/strong> K\u00fd t\u1ef1 $ n\u1eb1m \u1edf tr\u01b0\u1edbc s\u1ed1 v\u00e0 ch\u1eef: C\u00f3 ngh\u0129a l\u00e0 c\u1ed1 \u0111\u1ecbnh c\u1ed9t nh\u01b0ng kh\u00f4ng c\u1ed1 \u0111\u1ecbnh d\u00f2ng. Khi b\u1ea1n copy c\u00f4ng th\u1ee9c sang m\u1ed9t d\u00f2ng kh\u00e1c th\u00ec \u0111\u1ecba ch\u1ec9 c\u1ed9t kh\u00f4ng thay \u0111\u1ed5i, trong khi \u0111\u00f3 s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a d\u00f2ng thay \u0111\u1ed5i.<\/li>\n<li><strong>$B$1:<\/strong> K\u00fd t\u1ef1 $ n\u1eb1m \u1edf tr\u01b0\u1edbc s\u1ed1 v\u00e0 tr\u01b0\u1edbc ch\u1eef: C\u1ed1 \u0111\u1ecbnh t\u1ea5t c\u1ea3 d\u00f2ng v\u00e0 c\u1ed9t. Khi b\u1ea1n th\u1ef1c hi\u1ec7n copy c\u00f4ng th\u1ee9c sang m\u1ed9t c\u1ed9t kh\u00e1c th\u00ec c\u1ea3 \u0111\u1ecba ch\u1ec9 s\u1ed1 th\u1ee9 t\u1ef1 d\u00f2ng v\u00e0 c\u1ed9t \u0111\u1ec1u kh\u00f4ng thay \u0111\u1ed5i.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">B\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng c\u00e1ch th\u1ee9c tr\u00ean \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh cho m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u theo nguy\u00ean t\u1eafc t\u01b0\u01a1ng t\u1ef1:<\/p>\n<ul style=\"text-align: justify;\">\n<li>C$2:E$15<\/li>\n<li>$C2:$E15<\/li>\n<li>$C$2:$E$15<\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Co_dinh_o_khong_bi_di_chuyen_khi_cuon_cot_hoac_hang\"><\/span>C\u1ed1 \u0111\u1ecbnh \u00f4 kh\u00f4ng b\u1ecb di chuy\u1ec3n khi cu\u1ed9n c\u1ed9t ho\u1eb7c h\u00e0ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Muc_dich_co_dinh_cot_hang_trong_Excel\"><\/span><strong>M\u1ee5c \u0111\u00edch c\u1ed1 \u0111\u1ecbnh c\u1ed9t, h\u00e0ng trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\">N\u1ebfu m\u1ed9t b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n ch\u1ec9 c\u00f3 v\u00e0i ba c\u1ed9t hay d\u00f2ng th\u00ec vi\u1ec7c ki\u1ec3m tra th\u00f4ng tin l\u00e0 kh\u00e1 d\u1ec5 d\u00e0ng. Tuy nhi\u00ean, v\u1edbi m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1 nhi\u1ec1u d\u1eef li\u1ec7u, c\u00f3 t\u1edbi h\u00e0ng ch\u1ee5c, h\u00e0ng tr\u0103m hay h\u00e0ng ng\u00e0n d\u00f2ng hay c\u1ed9t th\u1eed th\u00ec vi\u1ec7c k\u00e9o l\u00ean ho\u1eb7c k\u00e9o xu\u1ed1ng \u0111\u1ec3 xem th\u00f4ng tin d\u1eef li\u1ec7u l\u00e0 kh\u00e1 kh\u00f3 kh\u0103n. B\u1edfi v\u1eady, b\u1ea1n c\u1ea7n ph\u1ea3i c\u1ed1 \u0111\u1ecbnh c\u1ed9t ho\u1eb7c d\u00f2ng trong excel \u0111\u1ec3 xem th\u00f4ng tin c\u00f3 b\u1ecb sai hay kh\u00f4ng, vi\u1ec7c nh\u1eadp d\u1eef li\u1ec7u c\u0169ng tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n r\u1ea5t nhi\u1ec1u. Ngo\u00e0i ra, gi\u00fap b\u1ea1n x\u00e2y d\u1ef1ng \u0111\u01b0\u1ee3c m\u1ed9t b\u1ea3ng t\u00ednh chuy\u00ean nghi\u1ec7p h\u01a1n.<\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Huong_dan_cach_co_dinh_cot_va_dong_trong_Excel\"><\/span><strong>H\u01b0\u1edbng d\u1eabn c\u00e1ch c\u1ed1 \u0111\u1ecbnh c\u1ed9t v\u00e0 d\u00f2ng trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_co_dinh_cot_trong_Excel\"><\/span><strong>C\u00e1ch c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify;\">\u0110\u1ec3 c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong excel, c\u00e1c b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 1:<\/strong> M\u1edf trang t\u00ednh \u0111ang c\u1ea7n th\u1ef1c hi\u1ec7n &gt; ch\u1ecdn th\u1ebb View tr\u00ean thanh ribbon &gt; ch\u1ecdn m\u1ee5c Freeze Panes &gt; ch\u1ecdn <strong>Freeze First Column<\/strong> \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh c\u1ed9t \u0111\u1ea7u ti\u00ean.<\/p>\n<figure id=\"attachment_11106\" aria-describedby=\"caption-attachment-11106\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11106 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h3-1.png\" alt=\"c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h3-1.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h3-1-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h3-1-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11106\" class=\"wp-caption-text\">c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify;\">\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 2:<\/strong> B\u1ea1n s\u1ebd th\u1ea5y \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 sau khi c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong excel. Xu\u1ea5t hi\u1ec7n 1 \u0111\u01b0\u1eddng s\u1eabm m\u00e0u ng\u0103n c\u00e1ch gi\u1eefa c\u1ed9t \u0111\u1ea7u v\u1edbi c\u00e1c c\u1ed9t b\u00ean c\u1ea1nh, ngh\u0129a l\u00e0 b\u1ea1n \u0111\u00e3 th\u1ef1c hi\u1ec7n th\u00e0nh c\u00f4ng.<\/p>\n<figure id=\"attachment_11107\" aria-describedby=\"caption-attachment-11107\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11107 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h3.1-1.png\" alt=\"c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h3.1-1.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h3.1-1-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h3.1-1-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11107\" class=\"wp-caption-text\">c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel<\/figcaption><\/figure>\n<h4 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_co_dinh_dong_trong_Excel\"><\/span><strong>C\u00e1ch c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 1:<\/strong> B\u1ea1n ch\u1ecdn v\u00e0o \u00f4 b\u1ea5t k\u1ef3 trong trang b\u1ea3ng t\u00ednh &gt; <a href=\"https:\/\/www.microsoft.com\/vi-vn\/microsoft-365\/excel\">v\u00e0o View<\/a> &gt; ch\u1ecdn Freeze Panes &gt; sau \u0111\u00f3 ch\u1ecdn <strong>Freeze Top Row.<\/strong><\/p>\n<figure id=\"attachment_11105\" aria-describedby=\"caption-attachment-11105\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11105 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h3.2.2-1.png\" alt=\"c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h3.2.2-1.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h3.2.2-1-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h3.2.2-1-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11105\" class=\"wp-caption-text\">c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 2:<\/strong> B\u00e2y gi\u1edd b\u1ea1n c\u00f3 th\u1ec3 nh\u00ecn th\u1ea5y d\u00f2ng \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh nh\u01b0 h\u00ecnh, n\u00f3 s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u b\u1eb1ng m\u1ed9t \u0111\u01b0\u1eddng k\u1ebb \u0111en, m\u00e0u \u0111\u1eadm h\u01a1n so v\u1edbi \u0111\u01b0\u1eddng k\u1ebb c\u00e1c d\u00f2ng kh\u00e1c \u1edf ngay b\u00ean d\u01b0\u1edbi trong \u00f4 d\u1eef li\u1ec7u \u0111\u00e3 kh\u00f3a. V\u1eady l\u00e0 c\u00e1ch c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong excel \u0111\u01a1n gi\u1ea3n v\u00e0 th\u00e0nh c\u00f4ng r\u1ed3i \u0111\u1ea5y.<\/p>\n<figure id=\"attachment_11109\" aria-describedby=\"caption-attachment-11109\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11109 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h3.2.3-1.png\" alt=\"c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h3.2.3-1.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h3.2.3-1-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h3.2.3-1-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11109\" class=\"wp-caption-text\">c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel<\/figcaption><\/figure>\n<h4 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Co_dinh_nhieu_cot_va_nhieu_dong\"><\/span><strong>C\u1ed1 \u0111\u1ecbnh nhi\u1ec1u c\u1ed9t v\u00e0 nhi\u1ec1u d\u00f2ng <\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify;\">V\u1eady khi mu\u1ed1n c\u1ed1 \u0111\u1ecbnh c\u1ea3 c\u1ed9t v\u00e0 d\u00f2ng, \u0111\u1ec3 khi l\u0103n chu\u1ed9t, ti\u00eau \u0111\u1ec1 h\u00e0ng v\u00e0 d\u00f2ng kh\u00f4ng b\u1ecb m\u1ea5t, ph\u1ea3i l\u00e0m sao \u0111\u00e2y? R\u1ea5t \u0111\u01a1n gi\u1ea3n th\u00f4i, b\u1ea1n h\u00e3y th\u1ef1c hi\u1ec7n theo h\u01b0\u1edbng d\u1eabn b\u00ean d\u01b0\u1edbi nh\u00e9.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 1:<\/strong> \u0110\u1ea7u ti\u00ean, b\u1ea1n c\u1ea7n x\u00e1c \u0111\u1ecbnh c\u00e1c c\u1ed9t, c\u00e1c d\u00f2ng b\u1ea1n mu\u1ed1n c\u1ed1 \u0111\u1ecbnh, sau \u0111\u00f3 nh\u1ea5n v\u00e0o th\u1ebb View &gt; ch\u1ecdn Freeze Panes &gt; nh\u1ea5n ch\u1ecdn <strong>Freeze Panes.<\/strong><\/p>\n<figure id=\"attachment_11110\" aria-describedby=\"caption-attachment-11110\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11110 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h3.2.4-1.png\" alt=\"C\u1ed1 \u0111\u1ecbnh nhi\u1ec1u c\u1ed9t v\u00e0 nhi\u1ec1u d\u00f2ng\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h3.2.4-1.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h3.2.4-1-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h3.2.4-1-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11110\" class=\"wp-caption-text\">C\u1ed1 \u0111\u1ecbnh nhi\u1ec1u c\u1ed9t v\u00e0 nhi\u1ec1u d\u00f2ng<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_bo_co_dinh_dong_cot_trong_excel\"><\/span>C\u00e1ch b\u1ecf c\u1ed1 \u0111\u1ecbnh d\u00f2ng, c\u1ed9t trong excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\">N\u1ebfu b\u1ea1n mu\u1ed1n b\u1ecf c\u1ed1 \u0111\u1ecbnh c\u1ed9t ho\u1eb7c d\u00f2ng trong Excel. B\u1ea1n v\u00e0o th\u1ebb <strong>View &gt; nh\u1ea5n ch\u1ecdn Freeze Panes &gt; Unfreeze Panes.<\/strong><\/p>\n<figure id=\"attachment_11111\" aria-describedby=\"caption-attachment-11111\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11111 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h5-2.png\" alt=\"B\u1ecf c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h5-2.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h5-2-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h5-2-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11111\" class=\"wp-caption-text\">B\u1ecf c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><strong>L\u01b0u \u00fd:<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>Khi b\u1ea1n h\u1ee7y c\u1ed1 \u0111\u1ecbnh c\u1ed9t ho\u1eb7c d\u00f2ng s\u1ebd khi\u1ebfn t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t, d\u00f2ng m\u00e0 b\u1ea1n \u0111\u00e3 c\u1ed1 \u0111\u1ecbnh tr\u1edf l\u1ea1i tr\u1ea1ng th\u00e1i b\u00ecnh th\u01b0\u1eddng nh\u01b0 l\u00fac \u0111\u1ea7u.<\/li>\n<li>Ch\u1ec9 khi b\u1ea1n \u0111\u00e3 th\u1ef1c hi\u1ec7n thao t\u00e1c c\u1ed1 \u0111\u1ecbnh d\u00f2ng ho\u1eb7c c\u1ed9t tr\u00ean b\u1ea3ng t\u00ednh. Th\u00ec l\u1ec7nh Unfreeze Panes m\u1edbi xu\u1ea5t hi\u1ec7n.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Nh\u01b0 v\u1eady, <a href=\"https:\/\/teky.edu.vn\/courses\/\">teky.edu.vn<\/a> \u0111\u00e3 gi\u1edbi thi\u1ec7u v\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel <span style=\"float: none; background-color: #ffffff; color: #333333; cursor: text; font-family: Arial,'Times New Roman','Bitstream Charter',Times,serif; font-size: 16px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none;\">\u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng nh\u1ea5t<\/span>. B\u00ean c\u1ea1nh \u0111\u00f3, c\u1ed1 \u0111\u1ecbnh c\u1ed9t v\u00e0 d\u00f2ng trong excel c\u0169ng kh\u00f4ng k\u00e9m ph\u1ea7n quan tr\u1ecdng. Ch\u00fang t\u00f4i tin r\u1eb1ng n\u00f3 s\u1ebd gi\u00fap \u00edch c\u00e1c b\u1ea1n r\u1ea5t nhi\u1ec1u trong c\u00f4ng vi\u1ec7c c\u0169ng nh\u01b0 h\u1ecdc t\u1eadp. Ch\u00fac b\u1ea1n th\u1ef1c hi\u1ec7n th\u00e0nh c\u00f4ng.<\/p>\n<p>Xem th\u00eam:<\/p>\n<ul>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-them-cot-trong-excel\/\" target=\"_blank\" rel=\"noopener\">3 C\u00e1ch th\u00eam c\u1ed9t trong Excel \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/excel-co-ban-van-phong\/\" target=\"_blank\" rel=\"noopener\">Excel c\u01a1 b\u1ea3n v\u0103n ph\u00f2ng l\u00e0 g\u00ec &#8211; 5 th\u1ee7 thu\u1eadt b\u1ea1n c\u1ea7n bi\u1ebft<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Vi\u1ec7c c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel l\u00e0 r\u1ea5t quan tr\u1ecdng v\u00e0 c\u1ea7n thi\u1ebft n\u1ebfu b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n c\u00f3 qu\u00e1 nhi\u1ec1u c\u1ed9t v\u00e0 nhi\u1ec1u h\u00e0ng. \u0110\u1ec3 thu\u1eadn ti\u1ec7n cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 chuy\u00ean nghi\u1ec7p h\u01a1n. Trong b\u00e0i vi\u1ebft n\u00e0y, Teky.edu.vn s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong &hellip;<\/p>\n","protected":false},"author":3,"featured_media":11102,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[192,193,202,194],"class_list":["post-11010","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","tag-cach-co-dinh-o-trong-excel","tag-co-dinh-cot-trong-excel","tag-co-dinh-dong-trong-excel","tag-khoa-gia-tri-cong-thuc-trong-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\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng nh\u1ea5t<\/title>\n<meta name=\"description\" content=\"B\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel hay ch\u01b0a? C\u00e1ch c\u1ed1 \u0111\u1ecbnh c\u1ed9t v\u00e0 d\u00f2ng nh\u01b0 th\u1ebf n\u00e0o? N\u1ebfu ch\u01b0a th\u00ec h\u00e3y xem ngay b\u00e0i vi\u1ebft n\u00e0y 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\/cach-co-dinh-o-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\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng nh\u1ea5t\" \/>\n<meta property=\"og:description\" content=\"B\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel hay ch\u01b0a? C\u00e1ch c\u1ed1 \u0111\u1ecbnh c\u1ed9t v\u00e0 d\u00f2ng nh\u01b0 th\u1ebf n\u00e0o? N\u1ebfu ch\u01b0a th\u00ec h\u00e3y xem ngay b\u00e0i vi\u1ebft n\u00e0y nh\u00e9\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-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-10T01:15:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-19T04:14:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-co-dinh-o-trong-Excel-1.png\" \/>\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\/png\" \/>\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=\"8 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\/cach-co-dinh-o-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"H\u01b0\u1edbng d\u1eabn c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel nhanh ch\u00f3ng nh\u1ea5t\",\"datePublished\":\"2022-11-10T01:15:27+00:00\",\"dateModified\":\"2022-12-19T04:14:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/\"},\"wordCount\":1857,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-co-dinh-o-trong-Excel-1.png\",\"keywords\":[\"c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel\",\"C\u1ed1 \u0111\u1ecbnh c\u1ed9t trong excel\",\"C\u1ed1 \u0111\u1ecbnh d\u00f2ng trong excel\",\"kh\u00f3a gi\u00e1 tr\u1ecb c\u00f4ng th\u1ee9c trong excel\"],\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/\",\"name\":\"H\u01b0\u1edbng d\u1eabn c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng nh\u1ea5t\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-co-dinh-o-trong-Excel-1.png\",\"datePublished\":\"2022-11-10T01:15:27+00:00\",\"dateModified\":\"2022-12-19T04:14:16+00:00\",\"description\":\"B\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel hay ch\u01b0a? C\u00e1ch c\u1ed1 \u0111\u1ecbnh c\u1ed9t v\u00e0 d\u00f2ng nh\u01b0 th\u1ebf n\u00e0o? N\u1ebfu ch\u01b0a th\u00ec h\u00e3y xem ngay b\u00e0i vi\u1ebft n\u00e0y nh\u00e9\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-co-dinh-o-trong-Excel-1.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-co-dinh-o-trong-Excel-1.png\",\"width\":600,\"height\":400,\"caption\":\"c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-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\u01b0\u1edbng d\u1eabn c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel nhanh ch\u00f3ng nh\u1ea5t\"}]},{\"@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\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng nh\u1ea5t","description":"B\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel hay ch\u01b0a? C\u00e1ch c\u1ed1 \u0111\u1ecbnh c\u1ed9t v\u00e0 d\u00f2ng nh\u01b0 th\u1ebf n\u00e0o? N\u1ebfu ch\u01b0a th\u00ec h\u00e3y xem ngay b\u00e0i vi\u1ebft n\u00e0y 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\/cach-co-dinh-o-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u01b0\u1edbng d\u1eabn c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng nh\u1ea5t","og_description":"B\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel hay ch\u01b0a? C\u00e1ch c\u1ed1 \u0111\u1ecbnh c\u1ed9t v\u00e0 d\u00f2ng nh\u01b0 th\u1ebf n\u00e0o? N\u1ebfu ch\u01b0a th\u00ec h\u00e3y xem ngay b\u00e0i vi\u1ebft n\u00e0y nh\u00e9","og_url":"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-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-10T01:15:27+00:00","article_modified_time":"2022-12-19T04:14:16+00:00","og_image":[{"width":600,"height":400,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-co-dinh-o-trong-Excel-1.png","type":"image\/png"}],"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":"8 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"H\u01b0\u1edbng d\u1eabn c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel nhanh ch\u00f3ng nh\u1ea5t","datePublished":"2022-11-10T01:15:27+00:00","dateModified":"2022-12-19T04:14:16+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/"},"wordCount":1857,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-co-dinh-o-trong-Excel-1.png","keywords":["c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel","C\u1ed1 \u0111\u1ecbnh c\u1ed9t trong excel","C\u1ed1 \u0111\u1ecbnh d\u00f2ng trong excel","kh\u00f3a gi\u00e1 tr\u1ecb c\u00f4ng th\u1ee9c trong excel"],"articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/","name":"H\u01b0\u1edbng d\u1eabn c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng nh\u1ea5t","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-co-dinh-o-trong-Excel-1.png","datePublished":"2022-11-10T01:15:27+00:00","dateModified":"2022-12-19T04:14:16+00:00","description":"B\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel hay ch\u01b0a? C\u00e1ch c\u1ed1 \u0111\u1ecbnh c\u1ed9t v\u00e0 d\u00f2ng nh\u01b0 th\u1ebf n\u00e0o? N\u1ebfu ch\u01b0a th\u00ec h\u00e3y xem ngay b\u00e0i vi\u1ebft n\u00e0y nh\u00e9","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-co-dinh-o-trong-Excel-1.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-cach-co-dinh-o-trong-Excel-1.png","width":600,"height":400,"caption":"c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-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\u01b0\u1edbng d\u1eabn c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel nhanh ch\u00f3ng nh\u1ea5t"}]},{"@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\/11010","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=11010"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11010\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/11102"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=11010"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=11010"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=11010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}