{"id":11652,"date":"2022-11-15T21:27:33","date_gmt":"2022-11-15T14:27:33","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=11652"},"modified":"2022-12-08T11:11:12","modified_gmt":"2022-12-08T04:11:12","slug":"cach-gach-cheo-o-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-o-trong-excel\/","title":{"rendered":"C\u00e1ch g\u1ea1ch ch\u00e9o \u00f4 trong excel nhanh nh\u1ea5t v\u00e0 \u0111\u01a1n gi\u1ea3n 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;11652&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;5&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 - (5 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;C\u00e1ch g\u1ea1ch ch\u00e9o \u00f4 trong excel nhanh nh\u1ea5t v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t&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 - (5 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p style=\"text-align: justify;\"><em>\u0110\u1ec3 con ng\u01b0\u1eddi c\u00f3 nh\u1eefng th\u00e0nh t\u1ef1u khoa h\u1ecdc c\u00f4ng ngh\u1ec7 nh\u01b0 ng\u00e0y h\u00f4m nay th\u00ec kh\u00f4ng th\u1ec3 kh\u00f4ng k\u1ec3 \u0111\u1ebfn s\u1ef1 g\u00f3p m\u1eb7t c\u1ee7a khoa h\u1ecdc hi\u1ec7n \u0111\u1ea1i. C\u00e1c \u1ee9ng d\u1ee5ng \u0111\u01b0\u1ee3c ph\u00e1t minh ra v\u1edbi m\u1ee5c \u0111\u00edch gi\u00fap con ng\u01b0\u1eddi c\u00f3 cu\u1ed9c s\u1ed1ng an nh\u00e0n v\u00e0 tho\u1ea3i m\u00e1i h\u01a1n.\u00a0N\u1ebfu \u1edf th\u1ebf k\u1ef7 tr\u01b0\u1edbc c\u00e1c thi\u1ebft b\u1ecb m\u00e1y m\u00f3c \u0111\u01b0\u1ee3c s\u1ea3n xu\u1ea5t; \u0111\u1ec3 gi\u00fap gi\u1ea3m lao \u0111\u1ed9ng th\u00f4 s\u01a1, ch\u00e2n tay c\u1ee7a con ng\u01b0\u1eddi th\u00ec b\u00e2y gi\u1edd s\u1ef1 ph\u00e1t tri\u1ec3n c\u1ee7a c\u00f4ng ngh\u1ec7; \u0111\u00e3 gi\u00fap ho\u1ea1t \u0111\u1ed9ng tr\u00ed \u00f3c b\u1edbt \u00e1p l\u1ef1c h\u01a1n. \u0110i\u1ec3n h\u00ecnh \u1edf b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang t\u00f4i s\u1ebd gi\u1edbi thi\u1ec7u \u0111\u1ebfn c\u00e1c b\u1ea1n\u00a0<strong>c\u00e1ch g\u1ea1ch ch\u00e9o \u00f4 trong excel<\/strong> hay t\u1ea1o \u0111\u01b0\u1eddng g\u1ea1ch ch\u00e9o trong excel nhanh nh\u1ea5t.\u00a0<\/em><\/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-gach-cheo-o-trong-excel\/#Phan_mem_excel_la_gi\" >Ph\u1ea7n m\u1ec1m excel 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\/cach-gach-cheo-o-trong-excel\/#O_trong_excel\" >\u00d4 trong excel<\/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\/cach-gach-cheo-o-trong-excel\/#Tai_sao_can_gach_cheo_o_trong_excel\" >T\u1ea1i sao c\u1ea7n g\u1ea1ch ch\u00e9o \u00f4 trong excel?<\/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\/cach-gach-cheo-o-trong-excel\/#Cac_cach_tao_duong_gach_cheo_trong_o_excel\" >C\u00e1c c\u00e1ch t\u1ea1o \u0111\u01b0\u1eddng g\u1ea1ch ch\u00e9o trong \u00f4 excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-o-trong-excel\/#Gach_cheo_o_bang_bang_Format_hieu_qua\" >G\u1ea1ch ch\u00e9o \u00f4 b\u1eb1ng b\u1ea3ng Format hi\u1ec7u qu\u1ea3<\/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-gach-cheo-o-trong-excel\/#Su_dung_cong_cu_ve_trong_excel\" >S\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 v\u1ebd trong excel<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Phan_mem_excel_la_gi\"><\/span><b>Ph\u1ea7n m\u1ec1m excel l\u00e0 g\u00ec?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Hi\u1ec3u m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t, excel l\u00e0 c\u00f4ng c\u1ee5 gi\u00fap ch\u00fang ta thao t\u00e1c l\u1eadp b\u1ea3ng t\u00ednh to\u00e1n; ghi c\u00e1c th\u00f4ng tin v\u00e0 d\u1eef li\u1ec7u. Ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i x\u1eed l\u00fd c\u00e1c d\u1eef li\u1ec7u n\u1eb7ng ho\u1eb7c ph\u1ee9c t\u1ea1p ch\u1ec9 b\u1eb1ng v\u00e0i thao t\u00e1c nh\u1ecf.\u00a0<\/span><\/p>\n<figure id=\"attachment_11656\" aria-describedby=\"caption-attachment-11656\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11656 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-gach-cheo-o-trong-excel.jpg\" alt=\"\u00d4 trong excel\" width=\"600\" height=\"547\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-gach-cheo-o-trong-excel.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-gach-cheo-o-trong-excel-400x365.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11656\" class=\"wp-caption-text\">\u00d4 trong excel<\/figcaption><\/figure>\n<p style=\"text-align: justify;\">\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1eb1m trong b\u1ed9 Microsoft Office, c\u00f9ng h\u1ecd h\u00e0ng v\u1edbi Word, PowerPoint v\u00e0 c\u00e1c ph\u1ea7n m\u1ec1m kh\u00e1c. Excel l\u00e0 c\u00f4ng c\u1ee5 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ch\u1ee7 y\u1ebfu cho nh\u00e2n vi\u00ean v\u0103n ph\u00f2ng v\u00e0 sinh vi\u00ean, tuy nhi\u00ean gi\u1edd n\u00f3 \u0111\u00e3 ph\u1ed5 bi\u1ebfn v\u1edbi c\u1ea3 h\u1ecdc sinh.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u1ea1n \u0111\u00e3 bi\u1ebft excel c\u00f3 nh\u1eefng ti\u1ec7n \u00edch g\u00ec v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u1ee7a n\u00f3 ch\u01b0a? C\u00f3 r\u1ea5t nhi\u1ec1u th\u1ee9 c\u00f3 th\u1ec3 khi\u1ebfn b\u1ea1n ng\u1ee1 ng\u00e0ng \u0111\u1ea5y. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u v\u1ec1 \u00f4 trong excel v\u00e0 c\u00e1ch g\u1ea1ch ch\u00e9o \u00f4 trong excel nh\u00e9.\u00a0<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"C\u00e1ch g\u1ea1ch ch\u00e9o \u00f4 trong word | c\u00e1ch gach ch\u00e9o \u00f4 trong word\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/0UilRCBWBB0?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<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"O_trong_excel\"><\/span><b>\u00d4 trong excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u00d4 trong excel c\u00f2n th\u01b0\u1eddng \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 Cells, \u0111\u00e2y l\u00e0 th\u00e0nh ph\u1ea7n quan tr\u1ecdng nh\u1ea5t trong excel; l\u00e0 n\u01a1i b\u1ea1n nh\u1eadp t\u1ea5t c\u1ea3 c\u00e1c th\u00f4ng tin, s\u1ed1 li\u1ec7u v\u00e0 t\u1ea5t c\u1ea3 c\u00e1c thao t\u00e1c \u0111\u1ec1u th\u1ef1c hi\u1ec7n tr\u1ef1c ti\u1ebfp l\u00ean c\u00e1c \u00f4 excel.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Theo h\u00ecnh th\u1ee9c th\u00ec \u00f4 trong excel c\u00f3 h\u00e0ng v\u00e0 c\u1ed9t v\u1edbi th\u1ee9 t\u1ef1 ch\u1eef c\u00e1i (A, B, C, D, E, F&#8230;) trong c\u1ed9t v\u00e0 s\u1ed1 theo h\u00e0ng. M\u1ed7i \u00f4 c\u00f3 \u0111\u1ecba ch\u1ec9 ri\u00eang g\u1ecdi l\u00e0 Cell address, v\u00ed d\u1ee5 c\u1ed9t C v\u00e0 \u00f4 4 giao nhau th\u00ec \u0111\u1ecba ch\u1ec9 s\u1ebd l\u00e0 C4.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1c \u00f4 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng linh ho\u1ea1t v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng nhi\u1ec1u \u00f4 m\u1ed9t l\u00fac v\u00e0 m\u1ed9t l\u1ea7n. Th\u00f4ng th\u01b0\u1eddng ng\u01b0\u1eddi d\u00f9ng s\u1ebd k\u1ebb b\u1ea3ng cho \u00f4; \u0111\u1ec3 note th\u00f4ng tin c\u1ea7n l\u01b0u \u00fd v\u00e0o. \u0110i\u1ec3m \u0111\u1eb7c bi\u1ec7t m\u00e0 excel c\u00f3 \u0111\u01b0\u1ee3c l\u00e0 kh\u1ea3 n\u0103ng ch\u1ee9a th\u00f4ng tin v\u00f4 c\u00f9ng l\u1edbn; m\u1ed9t \u00f4 c\u00f3 th\u1ec3 ch\u1ee9a \u0111\u01b0\u1ee3c c\u00e1c th\u1ec3 lo\u1ea1i th\u00f4ng tin kh\u00e1c nhau.\u00a0<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tai_sao_can_gach_cheo_o_trong_excel\"><\/span>T\u1ea1i<b> sao c\u1ea7n g\u1ea1ch ch\u00e9o \u00f4 trong excel?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">G\u1ea1ch ch\u00e9o \u00f4 trong excel l\u00e0 thao t\u00e1c h\u1ebft s\u1ee9c quen thu\u1ed9c c\u1ee7a c\u00e1c k\u1ebf to\u00e1n vi\u00ean, c\u00e1c gi\u1ea3ng vi\u00ean, gi\u00e1o vi\u00ean; v\u00ec n\u00f3 s\u1eed d\u1ee5ng cho b\u1ea3ng danh s\u00e1ch. Th\u00f4ng th\u01b0\u1eddng c\u00e1c b\u1ea3ng danh s\u00e1ch h\u1ecdc sinh, danh s\u00e1ch b\u1ea3ng l\u01b0\u01a1ng ho\u1eb7c b\u1ea5t c\u1ee9 b\u1ea3ng n\u00e0o; khi b\u1ea1n mu\u1ed1n vi\u1ebft c\u1ea3 t\u00ean v\u00e0 m\u1ed9t th\u00f4ng s\u1ed1 kh\u00e1c v\u00e0o 1 \u00f4.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u01b0\u1edfng t\u01b0\u1ee3ng \u0111\u01a1n gi\u1ea3n nh\u01b0 vi\u1ec7c nh\u00ecn v\u00e0o b\u1ea3ng danh s\u00e1ch h\u1ecdc sinh; t\u00ean h\u00e0ng v\u00e0 t\u00ean c\u1ed9t s\u1ebd \u0111\u01b0\u1ee3c vi\u1ebft chung v\u00e0o 1 \u00f4 \u0111\u1ea7u ti\u00ean. C\u00e1c tr\u01b0\u1eddng h\u1ee3p kh\u00e1c c\u1ee7a vi\u1ec7c t\u1ea1o g\u1ea1ch ch\u00e9o trong \u00f4 excel l\u00e0 \u0111\u1ec3 th\u00eam ch\u00fa th\u00edch cho ng\u01b0\u1eddi xem ho\u1eb7c b\u1ea1n mu\u1ed1n hi\u1ec7n \u00f4 b\u1ecf tr\u1ed1ng.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u1eady c\u00f3 nh\u1eefng <\/span><b>c\u00e1ch g\u1ea1ch ch\u00e9o \u00f4 trong excel <\/b><span style=\"font-weight: 400;\">n\u00e0o? N\u1ebfu b\u1ea1n \u0111ang c\u00f9ng c\u00e2u h\u1ecfi v\u1edbi m\u1ecdi ng\u01b0\u1eddi th\u00ec tham kh\u1ea3o ngay nh\u00e9.\u00a0<\/span><\/p>\n<figure id=\"attachment_11659\" aria-describedby=\"caption-attachment-11659\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11659 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-gach-cheo-o-trong-excel-3.jpg\" alt=\"T\u1ea1i sao c\u1ea7n g\u1ea1ch ch\u00e9o \u00f4 trong excel?\" width=\"600\" height=\"394\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-gach-cheo-o-trong-excel-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-gach-cheo-o-trong-excel-3-400x263.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11659\" class=\"wp-caption-text\">T\u1ea1i sao c\u1ea7n g\u1ea1ch ch\u00e9o \u00f4 trong excel?<\/figcaption><\/figure>\n<p style=\"text-align: justify;\">Xem th\u00eam b\u00e0i vi\u1ebft:<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-trong-excel\/\">C\u00e1ch s\u1eafp x\u1ebfp trong excel c\u00f3 kh\u00f3 nh\u01b0 l\u1eddi \u0111\u1ed3n kh\u00f4ng?<\/a><\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/teky.edu.vn\/blog\/tinh-diem-trung-binh-trong-excel\/\">T\u00ednh \u0111i\u1ec3m trung b\u00ecnh trong Excel b\u1eb1ng c\u00e1c c\u00f4ng th\u1ee9c n\u00e0o?<\/a><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cac_cach_tao_duong_gach_cheo_trong_o_excel\"><\/span><b>C\u00e1c c\u00e1ch t\u1ea1o \u0111\u01b0\u1eddng g\u1ea1ch ch\u00e9o trong \u00f4 excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nhi\u1ec1u ng\u01b0\u1eddi trong ch\u00fang ta m\u1eb7c d\u00f9 \u0111\u00e3 s\u1eed d\u1ee5ng excel r\u1ea5t l\u00e2u; nh\u01b0ng v\u1eabn ch\u01b0a bi\u1ebft h\u1ebft v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng c\u1ee7a excel v\u00ec \u0111\u00e2y kh\u00f4ng ch\u1ec9 \u0111\u01a1n gi\u1ea3n l\u00e0 <a href=\"https:\/\/vi.wikipedia.org\/wiki\/Ph%E1%BA%A7n_m%E1%BB%81m\">ph\u1ea7n m\u1ec1m<\/a> d\u1ec5 s\u1eed d\u1ee5ng. B\u1ea3n th\u00e2n excel gi\u00fap ng\u01b0\u1eddi d\u00f9ng x\u1eed l\u00fd d\u1eef li\u1ec7u v\u00f4 c\u00f9ng nhanh nh\u01b0ng c\u00f3 r\u1ea5t nhi\u1ec1u thao t\u00e1c kh\u00e1c nhau.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00f4m nay ch\u00fang t\u00f4i s\u1ebd gi\u00fap c\u00e1c b\u1ea1n bi\u1ebft <\/span><b>c\u00e1ch g\u1ea1ch ch\u00e9o \u00f4 trong excel<\/b><span style=\"font-weight: 400;\"> nhanh v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t. Ch\u1ec9 v\u1edbi v\u00e0i thao t\u00e1c b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 t\u1ea1o g\u1ea1ch ch\u00e9o trong \u00f4 excel cho b\u1ea3ng d\u1eef li\u1ec7u r\u1ed3i.\u00a0<\/span><\/p>\n<figure id=\"attachment_11657\" aria-describedby=\"caption-attachment-11657\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11657 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-gach-cheo-o-trong-excel-1.jpg\" alt=\"C\u00e1c c\u00e1ch t\u1ea1o \u0111\u01b0\u1eddng g\u1ea1ch ch\u00e9o trong \u00f4 excel\" width=\"600\" height=\"337\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-gach-cheo-o-trong-excel-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-gach-cheo-o-trong-excel-1-400x225.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11657\" class=\"wp-caption-text\">C\u00e1c c\u00e1ch t\u1ea1o \u0111\u01b0\u1eddng g\u1ea1ch ch\u00e9o trong \u00f4 excel<\/figcaption><\/figure>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Gach_cheo_o_bang_bang_Format_hieu_qua\"><\/span><b>G\u1ea1ch ch\u00e9o \u00f4 b\u1eb1ng b\u1ea3ng Format hi\u1ec7u qu\u1ea3<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Format l\u00e0 thao t\u00e1c gi\u00fap \u0111i\u1ec1u ch\u1ec9nh h\u00ecnh d\u00e1ng, c\u1ea5u tr\u00fac c\u1ee7a b\u1ea3ng ho\u1eb7c c\u00e1c \u00f4 trong excel; c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: \u0110\u1ec3 g\u1ea1ch ch\u00e9o \u00f4 \u0111\u1ec3 chia th\u00e0nh 2 th\u00e0nh ph\u1ea7n \u201ct\u00ean\u201d v\u00e0 \u201cl\u1edbp\u201d.<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110i \u0111\u1ebfn ph\u1ea7n \u00f4 c\u1ea7n g\u1ea1ch ch\u00e9o, nh\u1eadp \u201ct\u00ean\u201d sau \u0111\u00f3 \u1ea5n t\u1ed5 h\u1ee3p ph\u00edm Alt + Enter; \u0111\u1ec3 s\u1eed d\u1ee5ng thao t\u00e1c xu\u1ed1ng d\u00f2ng.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ti\u1ebfp t\u1ee5c nh\u1eadp \u201cl\u1edbp\u201d.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: S\u1eed d\u1ee5ng Format \u0111\u1ec3 k\u1ebb \u0111\u01b0\u1eddng ch\u00e9o.\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng thao t\u00e1c \u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn Format Cells, khi n\u00e0y tr\u00ean m\u00e0n h\u00ecnh hi\u1ec7n l\u00ean c\u1eeda s\u1ed5 format<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ch\u1ecdn tab border =&gt; \u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng \u00f4 c\u00f3 \u0111\u01b0\u1eddng g\u1ea1ch ch\u00e9o =&gt; nh\u1ea5n OK \u0111\u1ec3 ho\u00e0n th\u00e0nh thao t\u00e1c.\u00a0<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_11658\" aria-describedby=\"caption-attachment-11658\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11658 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-gach-cheo-o-trong-excel-2-e1647354314732.jpg\" alt=\"G\u1ea1ch ch\u00e9o \u00f4 b\u1eb1ng b\u1ea3ng Format hi\u1ec7u qu\u1ea3\" width=\"600\" height=\"312\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-gach-cheo-o-trong-excel-2-e1647354314732.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-gach-cheo-o-trong-excel-2-e1647354314732-400x208.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11658\" class=\"wp-caption-text\">G\u1ea1ch ch\u00e9o \u00f4 b\u1eb1ng b\u1ea3ng Format hi\u1ec7u qu\u1ea3<\/figcaption><\/figure>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Su_dung_cong_cu_ve_trong_excel\"><\/span><b>S\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 v\u1ebd trong excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u00e2y l\u00e0 <\/span><b>c\u00e1ch g\u1ea1ch ch\u00e9o \u00f4 trong excel<\/b><span style=\"font-weight: 400;\"> t\u01b0\u01a1ng t\u1ef1 v\u1edbi c\u00e1ch tr\u00ean; nh\u01b0ng s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 draw tools thay cho format. Thao t\u00e1c n\u00e0y kh\u00e1 kh\u00f3 s\u1eed d\u1ee5ng n\u1ebfu b\u1ea1n mu\u1ed1n di chuy\u1ec3n k\u00edch th\u01b0\u1edbc c\u1ee7a c\u00e1c \u00f4. Th\u1ee9 t\u1ef1 \u0111\u01a1n gi\u1ea3n nh\u01b0 sau:\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ch\u1ecdn shape, khi n\u00e0y m\u00e0n h\u00ecnh hi\u1ec7n l\u00ean nhi\u1ec1u h\u00ecnh d\u1ea1ng kh\u00e1c nhau; khi n\u00e0y h\u00e3y ch\u1ecdn h\u00ecnh g\u1ea1ch ch\u00e9o.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u1ea4n gi\u1eef chu\u1ed9t v\u00e0 k\u00e9o v\u00e0o \u00f4 mu\u1ed1n g\u1ea1ch ch\u00e9o.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_11660\" aria-describedby=\"caption-attachment-11660\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11660 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-gach-cheo-o-trong-excel-4.jpg\" alt=\"S\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 v\u1ebd trong excel\" width=\"600\" height=\"367\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-gach-cheo-o-trong-excel-4.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-gach-cheo-o-trong-excel-4-400x245.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11660\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 v\u1ebd trong excel<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u00fac n\u00e0y \u00f4 \u0111\u00e3 \u0111\u01b0\u1ee3c chia \u0111\u00f4i tuy nhi\u00ean \u0111\u1ec3 \u0111i\u1ec1u ch\u1ec9nh k\u00edch th\u01b0\u1edbc \u00f4 th\u00ec kh\u00f3.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Qu\u1ea3 th\u1eadt ph\u1ea7n m\u1ec1m excel \u0111em \u0111\u1ebfn cho ch\u00fang ta r\u1ea5t nhi\u1ec1u c\u00f4ng c\u1ee5 h\u1eefu \u00edch m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 x\u1eed l\u00fd v\u1ea5n \u0111\u1ec1 trong v\u00e0i gi\u00e2y. Ch\u00ednh v\u00ec th\u1ebf vi\u1ec7c d\u00e0nh th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c \u0111\u1ec3 t\u00ecm hi\u1ec3u nh\u1eefng th\u00f4ng tin v\u1ec1 \u1ee9ng d\u1ee5ng n\u00e0y th\u1eadt c\u00f3 l\u1ee3i ph\u1ea3i kh\u00f4ng n\u00e0o.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y l\u00e0 nh\u1eefng th\u00f4ng tin v\u1ec1 Excel v\u00e0 <\/span><b>c\u00e1ch g\u1ea1ch ch\u00e9o \u00f4 trong excel <\/b><span style=\"font-weight: 400;\">m\u00e0 ch\u00fang t\u00f4i mu\u1ed1n g\u1eedi \u0111\u1ebfn b\u1ea1n \u0111\u1ecdc. Ch\u00fac c\u00e1c b\u1ea1n c\u00f3 m\u1ed9t ng\u00e0y vui v\u1ebb v\u00e0 ti\u1ebfp t\u1ee5c \u1ee7ng h\u1ed9 ch\u00fang t\u00f4i \u0111\u1ec3 ch\u00fang t\u00f4i c\u00f3 \u0111\u1ed9ng l\u1ef1c t\u1ed5ng h\u1ee3p nh\u1eefng th\u00f4ng tin h\u1eefu \u00edch kh\u00e1c nh\u00e9!\u00a0<\/span><\/p>\n<p><strong>Xem th\u00eam:<\/strong><\/p>\n<ul>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-xoa-gach-do-trong-word\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch x\u00f3a g\u1ea1ch \u0111\u1ecf trong Word nh\u01b0 th\u1ebf n\u00e0o b\u1ea1n bi\u1ebft hay ch\u01b0a?\u00a0<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-gach-chan-trong-word\/\" target=\"_blank\" rel=\"noopener\">3 c\u00e1ch g\u1ea1ch ch\u00e2n trong word \u0111\u01a1n gi\u1ea3n, d\u1ec5 l\u00e0m cho m\u1ecdi phi\u00ean b\u1ea3n<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-gach-ngang-chu-trong-word\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch g\u1ea1ch ngang ch\u1eef trong word nhi\u1ec1u ng\u01b0\u1eddi quan t\u00e2m hi\u1ec7n nay<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/mach-ban-5-cach-gach-ngang-chu-trong-excel\/\" target=\"_blank\" rel=\"noopener\">M\u00e1ch b\u1ea1n 5 c\u00e1ch g\u1ea1ch ngang ch\u1eef trong Excel<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn c\u00e1ch \u1ea9n c\u1ed9t trong Excel chi ti\u1ebft nh\u1ea5t<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u0110\u1ec3 con ng\u01b0\u1eddi c\u00f3 nh\u1eefng th\u00e0nh t\u1ef1u khoa h\u1ecdc c\u00f4ng ngh\u1ec7 nh\u01b0 ng\u00e0y h\u00f4m nay th\u00ec kh\u00f4ng th\u1ec3 kh\u00f4ng k\u1ec3 \u0111\u1ebfn s\u1ef1 g\u00f3p m\u1eb7t c\u1ee7a khoa h\u1ecdc hi\u1ec7n \u0111\u1ea1i. C\u00e1c \u1ee9ng d\u1ee5ng \u0111\u01b0\u1ee3c ph\u00e1t minh ra v\u1edbi m\u1ee5c \u0111\u00edch gi\u00fap con ng\u01b0\u1eddi c\u00f3 cu\u1ed9c s\u1ed1ng an nh\u00e0n v\u00e0 tho\u1ea3i m\u00e1i h\u01a1n.\u00a0N\u1ebfu \u1edf th\u1ebf k\u1ef7 tr\u01b0\u1edbc &hellip;<\/p>\n","protected":false},"author":3,"featured_media":11661,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-11652","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>C\u00e1ch g\u1ea1ch ch\u00e9o \u00f4 trong excel nhanh nh\u1ea5t v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/title>\n<meta name=\"description\" content=\"C\u00e1ch g\u1ea1ch ch\u00e9o \u00f4 trong excel c\u00f3 th\u1ef1c s\u1ef1 kh\u00f3 hay kh\u00f4ng? B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd \u0111\u01b0\u1ee3c ch\u00fang t\u00f4i gi\u1edbi thi\u1ec7u chi ti\u1ebft v\u00e0 c\u1ee5 th\u1ec3 \u0111\u1ec3 c\u00e1c b\u1ea1n \u00e1p d\u1ee5ng\" \/>\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-gach-cheo-o-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch g\u1ea1ch ch\u00e9o \u00f4 trong excel nhanh nh\u1ea5t v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t\" \/>\n<meta property=\"og:description\" content=\"C\u00e1ch g\u1ea1ch ch\u00e9o \u00f4 trong excel c\u00f3 th\u1ef1c s\u1ef1 kh\u00f3 hay kh\u00f4ng? B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd \u0111\u01b0\u1ee3c ch\u00fang t\u00f4i gi\u1edbi thi\u1ec7u chi ti\u1ebft v\u00e0 c\u1ee5 th\u1ec3 \u0111\u1ec3 c\u00e1c b\u1ea1n \u00e1p d\u1ee5ng\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-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-15T14:27:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-08T04:11:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-gach-cheo-o-trong-excel-5.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"420\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Huy \u0110\u00e0m\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Huy \u0110\u00e0m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 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-gach-cheo-o-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-o-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"C\u00e1ch g\u1ea1ch ch\u00e9o \u00f4 trong excel nhanh nh\u1ea5t v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t\",\"datePublished\":\"2022-11-15T14:27:33+00:00\",\"dateModified\":\"2022-12-08T04:11:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-o-trong-excel\/\"},\"wordCount\":1720,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-o-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-gach-cheo-o-trong-excel-5.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-o-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-o-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-o-trong-excel\/\",\"name\":\"C\u00e1ch g\u1ea1ch ch\u00e9o \u00f4 trong excel nhanh nh\u1ea5t v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-o-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-o-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-gach-cheo-o-trong-excel-5.jpg\",\"datePublished\":\"2022-11-15T14:27:33+00:00\",\"dateModified\":\"2022-12-08T04:11:12+00:00\",\"description\":\"C\u00e1ch g\u1ea1ch ch\u00e9o \u00f4 trong excel c\u00f3 th\u1ef1c s\u1ef1 kh\u00f3 hay kh\u00f4ng? B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd \u0111\u01b0\u1ee3c ch\u00fang t\u00f4i gi\u1edbi thi\u1ec7u chi ti\u1ebft v\u00e0 c\u1ee5 th\u1ec3 \u0111\u1ec3 c\u00e1c b\u1ea1n \u00e1p d\u1ee5ng\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-o-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-o-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-o-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-gach-cheo-o-trong-excel-5.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-gach-cheo-o-trong-excel-5.jpg\",\"width\":600,\"height\":420,\"caption\":\"C\u00e1ch g\u1ea1ch ch\u00e9o \u00f4 trong excel nhanh nh\u1ea5t v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-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\":\"C\u00e1ch g\u1ea1ch ch\u00e9o \u00f4 trong excel nhanh nh\u1ea5t v\u00e0 \u0111\u01a1n gi\u1ea3n 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":"C\u00e1ch g\u1ea1ch ch\u00e9o \u00f4 trong excel nhanh nh\u1ea5t v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t","description":"C\u00e1ch g\u1ea1ch ch\u00e9o \u00f4 trong excel c\u00f3 th\u1ef1c s\u1ef1 kh\u00f3 hay kh\u00f4ng? B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd \u0111\u01b0\u1ee3c ch\u00fang t\u00f4i gi\u1edbi thi\u1ec7u chi ti\u1ebft v\u00e0 c\u1ee5 th\u1ec3 \u0111\u1ec3 c\u00e1c b\u1ea1n \u00e1p d\u1ee5ng","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-gach-cheo-o-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch g\u1ea1ch ch\u00e9o \u00f4 trong excel nhanh nh\u1ea5t v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t","og_description":"C\u00e1ch g\u1ea1ch ch\u00e9o \u00f4 trong excel c\u00f3 th\u1ef1c s\u1ef1 kh\u00f3 hay kh\u00f4ng? B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd \u0111\u01b0\u1ee3c ch\u00fang t\u00f4i gi\u1edbi thi\u1ec7u chi ti\u1ebft v\u00e0 c\u1ee5 th\u1ec3 \u0111\u1ec3 c\u00e1c b\u1ea1n \u00e1p d\u1ee5ng","og_url":"https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-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-15T14:27:33+00:00","article_modified_time":"2022-12-08T04:11:12+00:00","og_image":[{"width":600,"height":420,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-gach-cheo-o-trong-excel-5.jpg","type":"image\/jpeg"}],"author":"Huy \u0110\u00e0m","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Huy \u0110\u00e0m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"7 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-o-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-o-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"C\u00e1ch g\u1ea1ch ch\u00e9o \u00f4 trong excel nhanh nh\u1ea5t v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t","datePublished":"2022-11-15T14:27:33+00:00","dateModified":"2022-12-08T04:11:12+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-o-trong-excel\/"},"wordCount":1720,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-o-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-gach-cheo-o-trong-excel-5.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-o-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-o-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-o-trong-excel\/","name":"C\u00e1ch g\u1ea1ch ch\u00e9o \u00f4 trong excel nhanh nh\u1ea5t v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-o-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-o-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-gach-cheo-o-trong-excel-5.jpg","datePublished":"2022-11-15T14:27:33+00:00","dateModified":"2022-12-08T04:11:12+00:00","description":"C\u00e1ch g\u1ea1ch ch\u00e9o \u00f4 trong excel c\u00f3 th\u1ef1c s\u1ef1 kh\u00f3 hay kh\u00f4ng? B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd \u0111\u01b0\u1ee3c ch\u00fang t\u00f4i gi\u1edbi thi\u1ec7u chi ti\u1ebft v\u00e0 c\u1ee5 th\u1ec3 \u0111\u1ec3 c\u00e1c b\u1ea1n \u00e1p d\u1ee5ng","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-o-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-o-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-o-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-gach-cheo-o-trong-excel-5.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-gach-cheo-o-trong-excel-5.jpg","width":600,"height":420,"caption":"C\u00e1ch g\u1ea1ch ch\u00e9o \u00f4 trong excel nhanh nh\u1ea5t v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-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":"C\u00e1ch g\u1ea1ch ch\u00e9o \u00f4 trong excel nhanh nh\u1ea5t v\u00e0 \u0111\u01a1n gi\u1ea3n 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\/11652","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=11652"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11652\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/11661"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=11652"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=11652"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=11652"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}