{"id":12987,"date":"2022-11-22T21:40:39","date_gmt":"2022-11-22T14:40:39","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=12987"},"modified":"2022-12-07T16:56:33","modified_gmt":"2022-12-07T09:56:33","slug":"cach-bo-dau-trong-excel-nhanh-chong-don-gian","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/","title":{"rendered":"C\u00e1ch b\u1ecf d\u1ea5u trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n"},"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;12987&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;C\u00e1ch b\u1ecf d\u1ea5u trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n&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><b>C\u00e1ch b\u1ecf d\u1ea5u trong Excel<\/b><span style=\"font-weight: 400;\"> l\u00e0 th\u1ee7 thu\u1eadt \u0111\u01a1n gi\u1ea3n. \u00c1p d\u1ee5ng th\u00e0nh c\u00f4ng m\u1eb9o n\u00e0y cho tr\u00ecnh \u0111\u1ed9 s\u1eed d\u1ee5ng Excel c\u1ee7a b\u1ea1n tr\u1edf n\u00ean \u201cc\u1ee9ng c\u00e1p\u201d h\u01a1n r\u1ea5t nhi\u1ec1u! N\u1ebfu b\u1ea1n c\u0169ng \u0111ang quan t\u00e2m \u0111\u1ebfn th\u1ee7 thu\u1eadt n\u00e0y th\u00ec h\u00e3y theo d\u00f5i c\u00e1c th\u00f4ng tin d\u01b0\u1edbi \u0111\u00e2y nh\u00e9!<\/span><\/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-bo-dau-trong-excel-nhanh-chong-don-gian\/#Cach_bo_dau_tieng_Viet_trong_Excel_bang_phan_mem_Unikey\" >C\u00e1ch b\u1ecf d\u1ea5u ti\u1ebfng Vi\u1ec7t trong Excel b\u1eb1ng ph\u1ea7n m\u1ec1m Unikey<\/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-bo-dau-trong-excel-nhanh-chong-don-gian\/#Cach_bo_dau_trong_Excel_bang_phan_mem_EVkey\" >C\u00e1ch b\u1ecf d\u1ea5u trong Excel b\u1eb1ng ph\u1ea7n m\u1ec1m EVkey<\/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-bo-dau-trong-excel-nhanh-chong-don-gian\/#Tao_ham_VBA_bo_dau_trong_Excel\" >T\u1ea1o h\u00e0m VBA b\u1ecf d\u1ea5u 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-bo-dau-trong-excel-nhanh-chong-don-gian\/#Cach_bo_dau_phay_trong_Excel_trong_bang_chua_so_lieu_bang_ham_Numbervalue\" >C\u00e1ch b\u1ecf d\u1ea5u ph\u1ea9y trong Excel trong b\u1ea3ng ch\u1ee9a s\u1ed1 li\u1ec7u b\u1eb1ng h\u00e0m Numbervalue<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/#Cach_bo_dau_phay_trong_Excel_thuoc_chuoi_van_ban\" >C\u00e1ch b\u1ecf d\u1ea5u ph\u1ea9y trong Excel thu\u1ed9c chu\u1ed7i v\u0103n b\u1ea3n<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/#Cach_bo_dau_gach_trong_Excel_bang_cong_thuc_Substitute_va_ham_VBA\" >C\u00e1ch b\u1ecf d\u1ea5u g\u1ea1ch trong Excel b\u1eb1ng c\u00f4ng th\u1ee9c Substitute v\u00e0 h\u00e0m VBA<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_bo_dau_tieng_Viet_trong_Excel_bang_phan_mem_Unikey\"><\/span><b>C\u00e1ch b\u1ecf d\u1ea5u ti\u1ebfng Vi\u1ec7t trong Excel b\u1eb1ng ph\u1ea7n m\u1ec1m Unikey<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 b\u1ecf d\u1ea5u trong Excel m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ngay ph\u1ea7n m\u1ec1m quen thu\u1ed9c Unikey. V\u1edbi c\u00e1ch l\u00e0m n\u00e0y, tr\u01b0\u1edbc h\u1ebft b\u1ea1n c\u1ea7n t\u1ea3i ph\u1ea7n m\u1ec1m v\u1ec1 thi\u1ebft b\u1ecb. Sau \u0111\u00f3 l\u00e0m nh\u01b0 sau:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: X\u00e1c \u0111\u1ecbnh font ch\u1eef m\u00e0 b\u1ea1n \u0111ang d\u00f9ng trong b\u1ea3ng Excel. M\u1ee5c \u0111\u00edch \u0111\u1ec3 h\u1ec7 th\u1ed1ng l\u00e0m vi\u1ec7c bi\u1ebft \u0111\u01b0\u1ee3c c\u1ea7n lo\u1ea1i b\u1ecf d\u1ea5u \u1edf v\u00f9ng d\u1eef li\u1ec7u n\u00e0o<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Copy v\u00f9ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n c\u1ea7n b\u1ecf d\u1ea5u<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_12988\" aria-describedby=\"caption-attachment-12988\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12988 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-bo-dau-trong-Excel-1.jpg\" alt=\"C\u00e1ch b\u1ecf d\u1ea5u ti\u1ebfng Vi\u1ec7t trong Excel b\u1eb1ng ph\u1ea7n m\u1ec1m Unikey\" width=\"600\" height=\"356\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-bo-dau-trong-Excel-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-bo-dau-trong-Excel-1-400x237.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12988\" class=\"wp-caption-text\">C\u00e1ch b\u1ecf d\u1ea5u ti\u1ebfng Vi\u1ec7t trong Excel b\u1eb1ng ph\u1ea7n m\u1ec1m Unikey<\/figcaption><\/figure>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: B\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng Unikey \u0111\u1ec3 m\u1edf b\u1ea3ng chuy\u1ec3n \u0111\u1ed5i, sau \u0111\u00f3 ch\u1ecdn c\u00f4ng c\u1ee5<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: Trong b\u1ea3ng chuy\u1ec3n \u0111\u1ed5i, ki\u1ec3m tra xem m\u00e3 Ngu\u1ed3n v\u00e0 m\u00e3 \u0110\u00edch xem c\u00f3 gi\u1ed1ng nhau kh\u00f4ng. \u0110\u1ed3ng th\u1eddi quan s\u00e1t font ch\u1eef xem c\u00f3 gi\u1ed1ng trong b\u1ea3ng kh\u00f4ng.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 5: Ch\u1ecdn m\u1ee5c \u201cLo\u1ea1i b\u1ecf d\u1ea5u\u201d r\u1ed3i ch\u1ecdn \u201cChuy\u1ec3n m\u00e3\u201d. Sau \u0111\u00f3 ch\u1ecdn ti\u1ebfp \u201cOK\u201d<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 6: D\u00e1n d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c lo\u1ea1i b\u1ecf d\u1ea5u v\u00e0o v\u00f9ng b\u1ea1n mu\u1ed1n\u00a0<\/span><\/li>\n<\/ul>\n<p><iframe loading=\"lazy\" title=\"C\u00e1ch b\u1ecf d\u1ea5u trong Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n kh\u00f4ng c\u1ea7n ph\u1ea3i t\u1ea1o h\u00e0m\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/v1g728Bkusk?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=\"Cach_bo_dau_trong_Excel_bang_phan_mem_EVkey\"><\/span><b>C\u00e1ch b\u1ecf d\u1ea5u trong Excel b\u1eb1ng ph\u1ea7n m\u1ec1m EVkey<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1ebfu kh\u00f4ng th\u00edch s\u1eed d\u1ee5ng ph\u1ea7n m\u1ec1m Unikey, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 b\u1ecf d\u1ea5u trong Excel b\u1eb1ng c\u00e1ch d\u00f9ng ph\u1ea7n m\u1ec1m EVkey. \u0110\u00e2y l\u00e0 ph\u1ea7n m\u1ec1m c\u00f3 ch\u1ee9c n\u0103ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 Unikey. V\u1ec1 c\u0103n b\u1ea3n kh\u00f4ng qu\u00e1 kh\u00e1c nhau v\u1ec1 c\u00e1ch th\u1ef1c hi\u1ec7n. H\u00e3y l\u00e0m nh\u01b0 sau:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Ki\u1ec3m tra font ch\u1eef trong EVkey t\u01b0\u01a1ng t\u1ef1 nh\u01b0 c\u00e1ch l\u00e0m \u0111\u1ed1i v\u1edbi Unikey ph\u00eda tr\u00ean<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Copy v\u00f9ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n b\u1ecf d\u1ea5u. Sau \u0111\u00f3 c\u0169ng nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng c\u1ee7a EVkey r\u1ed3i ch\u1ecdn \u201cChuy\u1ec3n m\u00e3\u201d<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_12989\" aria-describedby=\"caption-attachment-12989\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12989 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-bo-dau-trong-Excel-2.jpg\" alt=\"C\u00e1ch b\u1ecf d\u1ea5u trong Excel b\u1eb1ng ph\u1ea7n m\u1ec1m EVkey\" width=\"600\" height=\"473\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-bo-dau-trong-Excel-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-bo-dau-trong-Excel-2-400x315.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12989\" class=\"wp-caption-text\">C\u00e1ch b\u1ecf d\u1ea5u trong Excel b\u1eb1ng ph\u1ea7n m\u1ec1m EVkey<\/figcaption><\/figure>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: L\u00fac n\u00e0y, h\u1ed9p tho\u1ea1i EVkey Toolkit s\u1ebd xu\u1ea5t hi\u1ec7n. B\u1ea1n ph\u1ea3i ki\u1ec3m tra m\u00e3 Ngu\u1ed3n, m\u00e3 \u0110\u00edch xem gi\u1ed1ng nhau hay ch\u01b0a, ti\u1ebfp \u0111\u00f3 ki\u1ec3m tra font ch\u1eef<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: K\u00edch ch\u1ecdn \u201cLo\u1ea1i b\u1ecf d\u1ea5u\u201d, ch\u1ecdn ti\u1ebfp \u201cChuy\u1ec3n m\u00e3\u201d, ch\u1ecdn \u201cOK\u201d r\u1ed3i l\u1ea1i ch\u1ecdn \u201c\u0110\u00f3ng\u201d\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 5: D\u00e1n d\u1eef li\u1ec7u v\u1eeba \u0111\u01b0\u1ee3c b\u1ecf d\u1ea5u v\u00e0o v\u00f9ng b\u1ea1n mong mu\u1ed1n trong Excel l\u00e0 xong<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tao_ham_VBA_bo_dau_trong_Excel\"><\/span><b>T\u1ea1o h\u00e0m VBA b\u1ecf d\u1ea5u trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ngo\u00e0i vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c ph\u1ea7n m\u1ec1m \u0111\u1ec3 b\u1ecf d\u1ea5u trong Excel, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u1ea3 h\u00e0m VBA. \u0110\u00e2y l\u00e0 h\u00e0m b\u1eaft ngu\u1ed3n t\u1eeb ng\u00f4n ng\u1eef l\u1eadp tr\u00ecnh Visual Basic for Applications. H\u00e0m n\u00e0y cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng vi\u1ebft c\u00e1c h\u00e0m ho\u1eb7c l\u1ec7nh trong c\u00e1c t\u00e1c v\u1ee5 c\u1ee7a Microsoft Office. Trong \u0111\u00f3 c\u00f3 c\u1ea3 Excel.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u1eefng c\u00e2u l\u1ec7nh n\u00e0y khi \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng th\u1ef1c hi\u1ec7n thao t\u00e1c ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n l\u00e0m. Sau \u0111\u00f3 th\u1ef1c hi\u1ec7n nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3 h\u01a1n nhi\u1ec1u so v\u1edbi c\u00e1c th\u1ee7 thu\u1eadt b\u1eb1ng tay. Khi d\u00f9ng VBA Excel, b\u1ea1n s\u1ebd c\u00f3 th\u1ec3 vi\u1ebft \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m v\u00e0 ch\u1ee9c n\u0103ng g\u1ecdi l\u00e0 Function gi\u1ed1ng nh\u01b0 c\u00e1c h\u00e0m kh\u00e1c n\u00ean c\u00f3 th\u1ec3 g\u1ecdi l\u00e0 h\u00e0m VBA. N\u00f3i t\u00f3m l\u1ea1i, h\u00e0m n\u00e0y s\u1ebd gi\u00fap b\u1ea1n b\u1ecf d\u1ea5u trong Excel m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u01b0 sau:<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: M\u1edf c\u1eeda s\u1ed5 Microsoft Visual Basic for Applications b\u1eb1ng c\u00e1ch nh\u1ea5n t\u1ed5 h\u1ee3p Alt + F11\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Ch\u1ecdn \u201cInsert\u201d, sau \u0111\u00f3 ch\u1ecdn ti\u1ebfp \u201cModule\u201d<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Copy <\/span><strong><a href=\"https:\/\/docs.google.com\/document\/d\/1va3BrdRm-922AhoHuV2mWf6vbENTdJjzBLX0k0vQcyI\/edit\">b\u1ed9 code<\/a><\/strong><span style=\"font-weight: 400;\"> \u0111\u01b0\u1ee3c cung c\u1ea5p \u0111\u1ec3 d\u00e1n v\u00e0o khung tr\u1ed1ng tr\u00ean c\u1eeda s\u1ed5 Module<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: \u0110\u00f3ng c\u1eeda s\u1ed5 l\u1ea1i v\u00e0 ch\u1ecdn v\u1ecb tr\u00ed b\u1ea1n mu\u1ed1n th\u1ea3 d\u1eef li\u1ec7u. Sau \u0111\u00f3 nh\u1eadp h\u00e0m \u201cbo_dau_tieng_viet\u201d<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_12990\" aria-describedby=\"caption-attachment-12990\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12990 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-bo-dau-trong-Excel-3.jpg\" alt=\"T\u1ea1o h\u00e0m VBA b\u1ecf d\u1ea5u trong Excel\" width=\"600\" height=\"337\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-bo-dau-trong-Excel-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-bo-dau-trong-Excel-3-400x225.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12990\" class=\"wp-caption-text\">T\u1ea1o h\u00e0m VBA b\u1ecf d\u1ea5u trong Excel<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_bo_dau_phay_trong_Excel_trong_bang_chua_so_lieu_bang_ham_Numbervalue\"><\/span><b>C\u00e1ch b\u1ecf d\u1ea5u ph\u1ea9y trong Excel trong b\u1ea3ng ch\u1ee9a s\u1ed1 li\u1ec7u b\u1eb1ng h\u00e0m Numbervalue<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea3ng ch\u1ee9a d\u1eef li\u1ec7u s\u1ed1 v\u00e0 b\u1ea1n mu\u1ed1n b\u1ecf d\u1ea5u ph\u1ea9y gi\u1eefa c\u00e1c s\u1ed1 trong \u00f4 d\u1eef li\u1ec7u th\u00ec c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m Numbervalue. H\u00e0m n\u00e0y s\u1ebd gi\u00fap b\u1ea1n chuy\u1ec3n \u0111\u1ed5i v\u0103n b\u1ea3n th\u00e0nh s\u1ed1 theo c\u00f4ng th\u1ee9c:<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">=NUMBERVALUE(B2)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u01b0u \u00fd: B\u1ea1n c\u1ea7n sao ch\u00e9p c\u00f4ng th\u1ee9c n\u00e0y v\u00e0o t\u1ea5t c\u1ea3 c\u00e1c \u00f4 trong c\u1ed9t c\u1ea1nh c\u00e1c s\u1ed1 c\u1ea7n chuy\u1ec3n \u0111\u1ed5i. Ho\u1eb7c \u0111\u01a1n gi\u1ea3n l\u00e0 nh\u1eadp c\u00f4ng th\u1ee9c \u1edf \u00f4 \u0111\u1ea7u ti\u00ean. K\u00edch chu\u1ed9t v\u00e0o \u00f4 \u0111\u00f3 v\u00e0 h\u01b0\u1edbng chu\u1ed9t v\u00e0o c\u1ea1nh \u00f4 r\u1ed3i k\u00e9o xu\u1ed1ng \u0111\u1ebfn c\u00e1c \u00f4 c\u1ea7n b\u1ecf d\u1ea5u ph\u1ea9y \u0111i l\u00e0 \u0111\u01b0\u1ee3c.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_bo_dau_phay_trong_Excel_thuoc_chuoi_van_ban\"><\/span><b>C\u00e1ch b\u1ecf d\u1ea5u ph\u1ea9y trong Excel thu\u1ed9c chu\u1ed7i v\u0103n b\u1ea3n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1ebfu mu\u1ed1n b\u1ecf d\u1ea5u ph\u1ea9y thu\u1ed9c chu\u1ed7i v\u0103n b\u1ea3n trong Excel, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng Find and Replace. T\u00ednh n\u0103ng n\u00e0y cho ph\u00e9p b\u1ea1n d\u1ec5 d\u00e0ng t\u00ecm t\u1ea5t c\u1ea3 d\u1ea5u ph\u1ea9y trong v\u00f9ng d\u1eef li\u1ec7u. \u0110\u1ed3ng th\u1eddi thay th\u1ebf n\u00f3 b\u1eb1ng m\u1ed9t k\u00fd t\u1ef1 kh\u00e1c ho\u1eb7c m\u1ed9t kho\u1ea3ng tr\u1ed1ng. Tuy nhi\u00ean, ph\u01b0\u01a1ng ph\u00e1p b\u1ecf d\u1ea5u trong Excel n\u00e0y ch\u1ec9 d\u00f9ng trong cho d\u1eef li\u1ec7u v\u0103n b\u1ea3n, kh\u00f4ng \u00e1p d\u1ee5ng cho tr\u01b0\u1eddng h\u1ee3p do \u0111\u1ecbnh d\u1ea1ng s\u1eb5n.<\/span><\/p>\n<figure id=\"attachment_12991\" aria-describedby=\"caption-attachment-12991\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12991 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-bo-dau-trong-Excel-4.jpg\" alt=\"C\u00e1ch b\u1ecf d\u1ea5u ph\u1ea9y trong Excel thu\u1ed9c chu\u1ed7i v\u0103n b\u1ea3n\" width=\"600\" height=\"374\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-bo-dau-trong-Excel-4.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-bo-dau-trong-Excel-4-400x249.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12991\" class=\"wp-caption-text\">C\u00e1ch b\u1ecf d\u1ea5u ph\u1ea9y trong Excel thu\u1ed9c chu\u1ed7i v\u0103n b\u1ea3n<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch l\u00e0m:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Ch\u1ecdn t\u1eadp d\u1eef li\u1ec7u\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: T\u1ea1i th\u1ebb Home tr\u00ean thanh c\u00f4ng c\u1ee5, ch\u1ecdn \u201cEditing\u201d r\u1ed3i ch\u1ecdn ti\u1ebfp \u201cFind and Replace\u201d<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Ch\u1ecdn ti\u1ebfp \u201cReplace\u201d \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i \u201cFind and Replace\u201d<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: T\u1ea1i \u00f4 tr\u1ed1ng \u201cFind what\u201d, nh\u1eadp \u201c,\u201d v\u00e0 \u0111\u1ec3 tr\u1ed1ng \u00f4 \u201cReplace with\u201d, sau \u0111\u00f3 ch\u1ecdn \u201cReplace All\u201d l\u00e0 xong<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tuy nhi\u00ean, c\u00e1ch b\u1ecf d\u1ea5u trong Excel n\u00e0y s\u1ebd x\u00f3a d\u1ea5u ph\u1ea9y kh\u1ecfi t\u1ea5t c\u1ea3 c\u00e1c \u00f4 trong v\u00f9ng d\u1eef li\u1ec7u. Do \u0111\u00f3 b\u1ea1n c\u1ea7n c\u00e2n nh\u1eafc \u0111\u1ec3 kh\u00f4ng b\u1ecb x\u00f3a h\u1ebft c\u00e1c d\u1ea5u ph\u1ea9y c\u1ea7n gi\u1eef l\u1ea1i. Ngo\u00e0i ra, ph\u01b0\u01a1ng ph\u00e1p n\u00e0y c\u0169ng khi\u1ebfn cho t\u1eadp d\u1eef li\u1ec7u ban \u0111\u1ea7u b\u1ecb thay \u0111\u1ed5i n\u00ean b\u1ea1n c\u1ea7n t\u1ea1o m\u1ed9t b\u1ea3n sao d\u1ef1 ph\u00f2ng tr\u01b0\u1edbc r\u1ed3i m\u1edbi th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c nh\u01b0 tr\u00ean.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_bo_dau_gach_trong_Excel_bang_cong_thuc_Substitute_va_ham_VBA\"><\/span><b>C\u00e1ch b\u1ecf d\u1ea5u g\u1ea1ch trong Excel b\u1eb1ng c\u00f4ng th\u1ee9c Substitute v\u00e0 h\u00e0m VBA<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u00e1ch 1: D\u00f9ng c\u00f4ng th\u1ee9c SUBSTITUTE theo c\u00fa ph\u00e1p:<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">=SUBSTITUTE(C2,\u201c-\u201c, \u201c\u201d)<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u00e1ch 2: D\u00f9ng h\u00e0m VBA t\u01b0\u01a1ng t\u1ef1 nh\u01b0 c\u00e1ch l\u00e0m \u1edf ph\u1ea7n b\u1ecf d\u1ea5u ph\u00eda tr\u00ean. Nh\u01b0ng \u0111\u1ebfn b\u01b0\u1edbc 3 th\u00ec d\u00e1n v\u00f9ng code <\/span><strong><a href=\"https:\/\/docs.google.com\/document\/d\/12bdQGuI342Rd3NrfWJ5TmGfljcCfPwMbdHRX7QVmr8o\/edit\">n\u00e0y. <\/a><\/strong>S<span style=\"font-weight: 400;\">au \u0111\u00f3 nh\u1ea5n F5 r\u1ed3i ch\u1ecdn \u201cOK\u201d tr\u00ean h\u1ed9p tho\u1ea1i xu\u1ea5t hi\u1ec7n \u0111\u1ec3 k\u1ebft th\u00fac.<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><\/li>\n<\/ul>\n<p><strong>XEM TH\u00caM:<\/strong><\/p>\n<ul>\n<li class=\"c-detail-head__title\"><span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/teky.edu.vn\/blog\/cach-tinh-tuoi-don-gian-trong-excel-co-the-ban-chua-biet\/\"><strong>C\u00e1ch t\u00ednh tu\u1ed5i \u0111\u01a1n gi\u1ea3n trong Excel c\u00f3 th\u1ec3 b\u1ea1n ch\u01b0a bi\u1ebft<\/strong><\/a><\/span><\/li>\n<li class=\"c-detail-head__title\"><span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/teky.edu.vn\/blog\/su-dung-ham-if-ket-hop-vlookup\/\"><strong>S\u1eed d\u1ee5ng h\u00e0m If k\u1ebft h\u1ee3p Vlookup \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3<\/strong><\/a><\/span><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-doi-dau-phay-thanh-dau-cham-trong-excel\/\" target=\"_blank\" rel=\"noopener\">3 C\u00e1ch \u0111\u1ed5i d\u1ea5u ph\u1ea9y th\u00e0nh d\u1ea5u ch\u1ea5m trong Excel ti\u1ec7n l\u1ee3i<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cai-dat-dau-cham-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e0i \u0111\u1eb7t d\u1ea5u ch\u1ea5m trong excel trong gi\u00e2y l\u00e1t v\u1edbi m\u1eb9o sau<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/\" target=\"_blank\" rel=\"noopener\">L\u1eadp tr\u00ecnh VBA trong Excel &#8211; C\u00e1c b\u01b0\u1edbc l\u1eadp tr\u00ecnh t\u1eeb A-Z<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/vba-excel-la-gi\/\" target=\"_blank\" rel=\"noopener\">VBA Excel l\u00e0 g\u00ec? 5 m\u1eb9o gi\u00fap b\u1ea1n l\u1eadp tr\u00ecnh VBA \u0111\u01a1n gi\u1ea3n trong Excel<\/a><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u01b0 v\u1eady, v\u1edbi c\u00e1c c\u00e1ch h\u01b0\u1edbng d\u1eabn b\u1ecf d\u1ea5u trong Excel nh\u01b0 tr\u00ean. Hy v\u1ecdng b\u1ea1n s\u1ebd \u00e1p d\u1ee5ng th\u1eadt t\u1ed1t \u0111\u1ec3 ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c ch\u1ec9 b\u1eb1ng vi\u1ec7c th\u1ef1c hi\u1ec7n c\u00e1c th\u1ee7 thu\u1eadt \u0111\u01a1n gi\u1ea3n. \u0110\u1eebng qu\u00ean theo d\u00f5i c\u00e1c b\u00e0i vi\u1ebft ti\u1ebfp theo \u0111\u1ec3 b\u1ecf t\u00fai th\u00eam nhi\u1ec1u m\u1eb9o th\u00fa v\u1ecb kh\u00e1c v\u1edbi Excel nh\u00e9!<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>C\u00e1ch b\u1ecf d\u1ea5u trong Excel l\u00e0 th\u1ee7 thu\u1eadt \u0111\u01a1n gi\u1ea3n. \u00c1p d\u1ee5ng th\u00e0nh c\u00f4ng m\u1eb9o n\u00e0y cho tr\u00ecnh \u0111\u1ed9 s\u1eed d\u1ee5ng Excel c\u1ee7a b\u1ea1n tr\u1edf n\u00ean \u201cc\u1ee9ng c\u00e1p\u201d h\u01a1n r\u1ea5t nhi\u1ec1u! N\u1ebfu b\u1ea1n c\u0169ng \u0111ang quan t\u00e2m \u0111\u1ebfn th\u1ee7 thu\u1eadt n\u00e0y th\u00ec h\u00e3y theo d\u00f5i c\u00e1c th\u00f4ng tin d\u01b0\u1edbi \u0111\u00e2y nh\u00e9! C\u00e1ch b\u1ecf d\u1ea5u ti\u1ebfng &hellip;<\/p>\n","protected":false},"author":3,"featured_media":12992,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-12987","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 b\u1ecf d\u1ea5u trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n<\/title>\n<meta name=\"description\" content=\"C\u00e1ch b\u1ecf d\u1ea5u trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n ra sao? C\u00f9ng TEKY kh\u00e1m ph\u00e1 chi ti\u1ebft c\u00e2u tr\u1ea3 l\u1eddi trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y 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-bo-dau-trong-excel-nhanh-chong-don-gian\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch b\u1ecf d\u1ea5u trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n\" \/>\n<meta property=\"og:description\" content=\"C\u00e1ch b\u1ecf d\u1ea5u trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n ra sao? C\u00f9ng TEKY kh\u00e1m ph\u00e1 chi ti\u1ebft c\u00e2u tr\u1ea3 l\u1eddi trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y nh\u00e9!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/\" \/>\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-22T14:40:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-07T09:56:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-bo-dau-trong-Excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"277\" \/>\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-bo-dau-trong-excel-nhanh-chong-don-gian\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"C\u00e1ch b\u1ecf d\u1ea5u trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n\",\"datePublished\":\"2022-11-22T14:40:39+00:00\",\"dateModified\":\"2022-12-07T09:56:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/\"},\"wordCount\":1818,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-bo-dau-trong-Excel.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/\",\"name\":\"C\u00e1ch b\u1ecf d\u1ea5u trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-bo-dau-trong-Excel.jpg\",\"datePublished\":\"2022-11-22T14:40:39+00:00\",\"dateModified\":\"2022-12-07T09:56:33+00:00\",\"description\":\"C\u00e1ch b\u1ecf d\u1ea5u trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n ra sao? C\u00f9ng TEKY kh\u00e1m ph\u00e1 chi ti\u1ebft c\u00e2u tr\u1ea3 l\u1eddi trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y nh\u00e9!\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-bo-dau-trong-Excel.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-bo-dau-trong-Excel.jpg\",\"width\":600,\"height\":277,\"caption\":\"C\u00e1ch b\u1ecf d\u1ea5u trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/#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 b\u1ecf d\u1ea5u trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n\"}]},{\"@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 b\u1ecf d\u1ea5u trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n","description":"C\u00e1ch b\u1ecf d\u1ea5u trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n ra sao? C\u00f9ng TEKY kh\u00e1m ph\u00e1 chi ti\u1ebft c\u00e2u tr\u1ea3 l\u1eddi trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y 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-bo-dau-trong-excel-nhanh-chong-don-gian\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch b\u1ecf d\u1ea5u trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n","og_description":"C\u00e1ch b\u1ecf d\u1ea5u trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n ra sao? C\u00f9ng TEKY kh\u00e1m ph\u00e1 chi ti\u1ebft c\u00e2u tr\u1ea3 l\u1eddi trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y nh\u00e9!","og_url":"https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/","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-22T14:40:39+00:00","article_modified_time":"2022-12-07T09:56:33+00:00","og_image":[{"width":600,"height":277,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-bo-dau-trong-Excel.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-bo-dau-trong-excel-nhanh-chong-don-gian\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"C\u00e1ch b\u1ecf d\u1ea5u trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n","datePublished":"2022-11-22T14:40:39+00:00","dateModified":"2022-12-07T09:56:33+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/"},"wordCount":1818,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-bo-dau-trong-Excel.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/","url":"https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/","name":"C\u00e1ch b\u1ecf d\u1ea5u trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-bo-dau-trong-Excel.jpg","datePublished":"2022-11-22T14:40:39+00:00","dateModified":"2022-12-07T09:56:33+00:00","description":"C\u00e1ch b\u1ecf d\u1ea5u trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n ra sao? C\u00f9ng TEKY kh\u00e1m ph\u00e1 chi ti\u1ebft c\u00e2u tr\u1ea3 l\u1eddi trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y nh\u00e9!","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-bo-dau-trong-Excel.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-bo-dau-trong-Excel.jpg","width":600,"height":277,"caption":"C\u00e1ch b\u1ecf d\u1ea5u trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/#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 b\u1ecf d\u1ea5u trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n"}]},{"@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\/12987","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=12987"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12987\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/12992"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=12987"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=12987"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=12987"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}