{"id":21663,"date":"2023-10-10T14:08:13","date_gmt":"2023-10-10T07:08:13","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=21663"},"modified":"2024-01-25T09:21:14","modified_gmt":"2024-01-25T02:21:14","slug":"cach-hoc-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/cach-hoc-excel\/","title":{"rendered":"3 C\u00e1ch h\u1ecdc Excel nhanh nh\u1ea5t cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u hi\u1ec7u qu\u1ea3"},"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;21663&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;3 C\u00e1ch h\u1ecdc Excel nhanh nh\u1ea5t cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u hi\u1ec7u qu\u1ea3&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><em><span style=\"font-weight: 400;\"><strong>C\u00e1ch h\u1ecdc Excel<\/strong> l\u00e0 m\u1ed9t ch\u1ee7 \u0111\u1ec1 \u0111\u01b0\u1ee3c quan t\u00e2m nh\u1ea5t, \u0111\u1eb7c bi\u1ec7t \u0111\u1ed1i v\u1edbi nh\u1eefng ng\u01b0\u1eddi mu\u1ed1n n\u1eafm b\u1eaft \u0111\u01b0\u1ee3c nh\u1eefng kh\u00eda c\u1ea1nh quan tr\u1ecdng c\u1ee7a vi\u1ec7c l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3. B\u1eb1ng c\u00e1ch t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c nguy\u00ean t\u1eafc c\u01a1 b\u1ea3n, h\u1ecdc thu\u1eadt to\u00e1n v\u00e0 th\u1ef1c h\u00e0nh th\u01b0\u1eddng xuy\u00ean, b\u1ea1n c\u00f3 th\u1ec3 x\u00e2y d\u1ef1ng n\u1ec1n t\u1ea3ng v\u1eefng ch\u1eafc trong vi\u1ec7c s\u1eed d\u1ee5ng Excel. H\u00e3y kh\u00e1m ph\u00e1 c\u00e1ch h\u1ecdc Excel m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 v\u00e0 n\u00e2ng cao k\u1ef9 n\u0103ng c\u1ee7a b\u1ea1n trong vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u v\u00e0 ph\u00e2n t\u00edch s\u1ed1 li\u1ec7u.<\/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-hoc-excel\/#Excel_la_gi_Tai_sao_can_phai_hoc_Excel\" >Excel l\u00e0 g\u00ec? T\u1ea1i sao c\u1ea7n ph\u1ea3i h\u1ecdc Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/cach-hoc-excel\/#3_Cach_hoc_Excel_nhanh_nhat_cho_nguoi_moi_bat_dau_hieu_qua\" >3 C\u00e1ch h\u1ecdc Excel nhanh nh\u1ea5t cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u hi\u1ec7u qu\u1ea3<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/cach-hoc-excel\/#Ren_luyen_tinh_kien_tri\" >R\u00e8n luy\u1ec7n t\u00ednh ki\u00ean tr\u00ec\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/cach-hoc-excel\/#Hoc_thuoc_cac_ham_co_ban\" >H\u1ecdc thu\u1ed9c c\u00e1c h\u00e0m c\u01a1 b\u1ea3n<\/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-hoc-excel\/#Hoc_cach_phan_tich_thuat_toan\" >H\u1ecdc c\u00e1ch ph\u00e2n t\u00edch thu\u1eadt to\u00e1n<\/a><\/li><\/ul><\/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-hoc-excel\/#Bi_kip_tu_hoc_Excel_co_ban_tu_A_den_Z\" >B\u00ed k\u00edp t\u1ef1 h\u1ecdc Excel c\u01a1 b\u1ea3n t\u1eeb A \u0111\u1ebfn Z<\/a><\/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-hoc-excel\/#Ket_luan\" >K\u1ebft lu\u1eadn<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Excel_la_gi_Tai_sao_can_phai_hoc_Excel\"><\/span><b>Excel l\u00e0 g\u00ec? T\u1ea1i sao c\u1ea7n ph\u1ea3i h\u1ecdc Excel?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Excel l\u00e0 m\u1ed9t ph\u1ea7n m\u1ec1m b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c ph\u00e1t tri\u1ec3n b\u1edfi Microsoft, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i tr\u00ean to\u00e0n th\u1ebf gi\u1edbi. N\u00f3 cung c\u1ea5p \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c t\u00ednh to\u00e1n, ph\u00e2n t\u00edch d\u1eef li\u1ec7u, t\u1ea1o ra b\u1ea3ng bi\u1ec3u, \u0111\u1ed3 th\u1ecb v\u00e0 raport. C\u00f3 nhi\u1ec1u l\u00fd do v\u00ec sao c\u1ea7n ph\u1ea3i h\u1ecdc Excel:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ednh \u1ee9ng d\u1ee5ng r\u1ed9ng: Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong nhi\u1ec1u l\u0129nh v\u1ef1c v\u00e0 ng\u00e0nh ngh\u1ec1. T\u1eeb kinh doanh, t\u00e0i ch\u00ednh, k\u1ebf to\u00e1n, marketing, qu\u1ea3n l\u00fd d\u1ef1 \u00e1n cho \u0111\u1ebfn gi\u00e1o d\u1ee5c v\u00e0 nghi\u00ean c\u1ee9u. Vi\u1ec7c n\u1eafm v\u1eefng Excel s\u1ebd gi\u00fap b\u1ea1n n\u00e2ng cao kh\u1ea3 n\u0103ng l\u00e0m vi\u1ec7c v\u00e0 cung c\u1ea5p m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ednh linh ho\u1ea1t v\u00e0 ti\u1ec7n l\u1ee3i: Excel cho ph\u00e9p b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh to\u00e1n ph\u1ee9c t\u1ea1p, t\u1ed5 ch\u1ee9c v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng. B\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o b\u1ea3ng t\u00ednh, \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u, \u00e1p d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c. V\u00e0 h\u00e0m t\u00ednh to\u00e1n \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c t\u00e1c v\u1ee5 theo y\u00eau c\u1ea7u.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u1ed1i \u01b0u h\u00f3a c\u00f4ng vi\u1ec7c: Excel gi\u00fap t\u0103ng hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c b\u1eb1ng c\u00e1ch t\u1ef1 \u0111\u1ed9ng h\u00f3a c\u00e1c quy tr\u00ecnh v\u00e0 c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5 nh\u01b0 PivotTable, Macro, Solver. \u0110\u1ec3 t\u1ea1o ra c\u00e1c b\u00e1o c\u00e1o t\u1ef1 \u0111\u1ed9ng, ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u00e0 gi\u1ea3i quy\u1ebft c\u00e1c v\u1ea5n \u0111\u1ec1 ph\u1ee9c t\u1ea1p.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u1ea1o s\u1ef1 chuy\u00ean nghi\u1ec7p: Excel l\u00e0 m\u1ed9t k\u1ef9 n\u0103ng c\u1ea7n thi\u1ebft trong nhi\u1ec1u ng\u00e0nh ngh\u1ec1. \u0110\u00e2y \u0111\u01b0\u1ee3c coi l\u00e0 m\u1ed9t y\u1ebfu t\u1ed1 quan tr\u1ecdng trong vi\u1ec7c tuy\u1ec3n d\u1ee5ng. Hi\u1ec3u bi\u1ebft v\u1ec1 Excel v\u00e0 kh\u1ea3 n\u0103ng s\u1eed d\u1ee5ng n\u00f3 m\u1ed9t c\u00e1ch th\u00e0nh th\u1ea1o s\u1ebd t\u1ea1o ra m\u1ed9t \u1ea5n t\u01b0\u1ee3ng chuy\u00ean nghi\u1ec7p gi\u00fap b\u1ea1n n\u1ed5i b\u1eadt trong c\u00f4ng vi\u1ec7c.<\/span><\/li>\n<\/ul>\n<p><a href=\"https:\/\/docs.google.com\/forms\/d\/e\/1FAIpQLSfbjTymoZCWmKHb405VN4vv6mI5JM2JU4YdL1IvvnoYX_j86w\/viewform\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24124\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2024\/01\/thanh-thao-microsoft.png\" alt=\"thanh-thao-microsoft\" width=\"600\" height=\"314\" \/><\/a><\/p>\n<p>&gt;&gt;&gt;Xem th\u00eam: <span data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;H\u1ecdc Excel Online - B\u00ed k\u00edp th\u00e0nh th\u1ea1o c\u00f4ng c\u1ee5 trong 1 th\u00e1ng&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:4481,&quot;3&quot;:{&quot;1&quot;:0},&quot;10&quot;:2,&quot;11&quot;:0,&quot;15&quot;:&quot;Arial&quot;}\"><a href=\"https:\/\/teky.edu.vn\/blog\/hoc-excel-online\/\">H\u1ecdc Excel Online<\/a> &#8211; B\u00ed k\u00edp th\u00e0nh th\u1ea1o c\u00f4ng c\u1ee5 trong 1 th\u00e1ng<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"3_Cach_hoc_Excel_nhanh_nhat_cho_nguoi_moi_bat_dau_hieu_qua\"><\/span><b>3 C\u00e1ch h\u1ecdc Excel nhanh nh\u1ea5t cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u hi\u1ec7u qu\u1ea3<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u h\u1ecdc Excel, c\u00f3 m\u1ed9t s\u1ed1 c\u00e1ch h\u1ecdc nhanh v\u00e0 hi\u1ec7u qu\u1ea3 \u0111\u1ec3 n\u1eafm v\u1eefng k\u1ef9 n\u0103ng n\u00e0y:<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ren_luyen_tinh_kien_tri\"><\/span><b>R\u00e8n luy\u1ec7n t\u00ednh ki\u00ean tr\u00ec\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">H\u1ecdc Excel \u0111\u00f2i h\u1ecfi s\u1ef1 ki\u00ean nh\u1eabn v\u00e0 th\u1ef1c h\u00e0nh \u0111\u1ec1u \u0111\u1eb7n. T\u00ecm th\u1eddi gian h\u00e0ng ng\u00e0y ho\u1eb7c h\u00e0ng tu\u1ea7n \u0111\u1ec3 t\u1eadp trung v\u00e0o vi\u1ec7c h\u1ecdc Excel. D\u00e0nh \u00edt nh\u1ea5t 15-30 ph\u00fat m\u1ed7i ng\u00e0y \u0111\u1ec3 l\u00e0m quen v\u1edbi c\u00e1c ch\u1ee9c n\u0103ng v\u00e0 thao t\u00e1c c\u01a1 b\u1ea3n c\u1ee7a Excel. \u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea1n t\u1ea1o th\u00f3i quen h\u1ecdc t\u1eadp li\u00ean t\u1ee5c, nhanh ch\u00f3ng ti\u1ebfp c\u1eadn v\u1edbi c\u00e1c kh\u00e1i ni\u1ec7m m\u1edbi.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Hoc_thuoc_cac_ham_co_ban\"><\/span><b>H\u1ecdc thu\u1ed9c c\u00e1c h\u00e0m c\u01a1 b\u1ea3n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Excel c\u00f3 nhi\u1ec1u h\u00e0m m\u1ea1nh m\u1ebd \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u v\u00e0 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh ph\u1ee9c t\u1ea1p. B\u1eaft \u0111\u1ea7u b\u1eb1ng vi\u1ec7c h\u1ecdc c\u00e1c h\u00e0m c\u01a1 b\u1ea3n nh\u01b0 SUM, AVERAGE, COUNT v\u00e0 IF. T\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng ch\u00fang v\u00e0 \u00e1p d\u1ee5ng v\u00e0o c\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">Khi b\u1ea1n l\u00e0m quen v\u1edbi c\u00e1c h\u00e0m c\u01a1 b\u1ea3n, b\u1ea1n c\u00f3 th\u1ec3 m\u1edf r\u1ed9ng ki\u1ebfn th\u1ee9c c\u1ee7a m\u00ecnh. B\u1eb1ng c\u00e1ch h\u1ecdc c\u00e1c h\u00e0m ph\u1ee9c t\u1ea1p h\u01a1n, bi\u1ebft c\u00e1ch k\u1ebft h\u1ee3p ch\u00fang \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e2n t\u00edch v\u00e0 t\u00ednh to\u00e1n ph\u1ee9c t\u1ea1p.<\/span><\/p>\n<p>&gt;&gt;&gt; Xem th\u00eam: <span data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Excel c\u01a1 b\u1ea3n v\u0103n ph\u00f2ng Full t\u00e0i li\u1ec7u A-Z c\u01a1 b\u1ea3n \u2013 n\u00e2ng cao&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:4481,&quot;3&quot;:{&quot;1&quot;:0},&quot;10&quot;:2,&quot;11&quot;:0,&quot;15&quot;:&quot;Arial&quot;}\"><a href=\"https:\/\/teky.edu.vn\/blog\/excel-co-ban-van-phong-2\/\">Excel c\u01a1 b\u1ea3n v\u0103n ph\u00f2ng Full t\u00e0i li\u1ec7u A-Z c\u01a1 b\u1ea3n<\/a> \u2013 n\u00e2ng cao<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Hoc_cach_phan_tich_thuat_toan\"><\/span><b>H\u1ecdc c\u00e1ch ph\u00e2n t\u00edch thu\u1eadt to\u00e1n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Excel kh\u00f4ng ch\u1ec9 l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 t\u00ednh to\u00e1n, m\u00e0 c\u00f2n l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ea1nh m\u1ebd. H\u00e3y t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c ph\u01b0\u01a1ng ph\u00e1p, k\u1ef9 thu\u1eadt ph\u00e2n t\u00edch d\u1eef li\u1ec7u trong Excel nh\u01b0 b\u1ed9 l\u1ecdc, t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u v\u00e0 \u0111\u1ed3 th\u1ecb. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">Hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5 n\u00e0y s\u1ebd gi\u00fap b\u1ea1n tr\u00ecnh b\u00e0y d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch logic v\u00e0 d\u1ec5 hi\u1ec3u. N\u1eafm v\u1eefng vi\u1ec7c ph\u00e2n t\u00edch thu\u1eadt to\u00e1n gi\u00fap b\u1ea1n t\u00ecm ra c\u00e1ch gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1. V\u00e0 \u0111\u01b0a ra nh\u1eefng quy\u1ebft \u0111\u1ecbnh th\u00f4ng minh d\u1ef1a tr\u00ean d\u1eef li\u1ec7u.<\/span><\/p>\n<p><a href=\"https:\/\/drive.google.com\/drive\/folders\/1R7okb2m-xreZ5_a5_MQehZnEi0DETjCF\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24123\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2024\/01\/tang-36-video-resize-web.png\" alt=\"tang-36-video\" width=\"600\" height=\"314\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">H\u00e3y ch\u00fa tr\u1ecdng v\u00e0o vi\u1ec7c th\u1ef1c h\u00e0nh, \u00e1p d\u1ee5ng Excel v\u00e0o c\u00e1c t\u00ecnh hu\u1ed1ng th\u1ef1c t\u1ebf. \u0110\u1ed3ng th\u1eddi, s\u1eed d\u1ee5ng c\u00e1c t\u00e0i li\u1ec7u h\u1ecdc tr\u1ef1c tuy\u1ebfn, video h\u01b0\u1edbng d\u1eabn v\u00e0 c\u00e1c b\u00e0i t\u1eadp \u0111\u1ec3 r\u00e8n k\u1ef9 n\u0103ng. S\u1ef1 ki\u00ean tr\u00ec, h\u1ecdc c\u00e1c h\u00e0m c\u01a1 b\u1ea3n v\u00e0 ph\u00e2n t\u00edch thu\u1eadt to\u00e1n s\u1ebd gi\u00fap b\u1ea1n h\u1ecdc Excel nhanh ch\u00f3ng, th\u00e0nh th\u1ea1o.<\/span><\/p>\n<p>N\u1ebfu b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm b\u00ed k\u00edp t\u1ef1 h\u1ecdc Excel c\u01a1 b\u1ea3n t\u1eeb A \u0111\u1ebfn Z, h\u00e3y kh\u00e1m ph\u00e1 ngay h\u01b0\u1edbng d\u1eabn chi ti\u1ebft d\u01b0\u1edbi \u0111\u00e2y. B\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c h\u01b0\u1edbng d\u1eabn qua t\u1eebng b\u01b0\u1edbc c\u01a1 b\u1ea3n t\u1eeb vi\u1ec7c l\u00e0m quen v\u1edbi giao di\u1ec7n Excel, h\u1ecdc c\u00e1ch nh\u1eadp li\u1ec7u. V\u00e0 \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u, \u0111\u1ebfn vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c, h\u00e0m c\u01a1 b\u1ea3n. B\u1ea1n c\u0169ng s\u1ebd t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c t\u00ednh n\u0103ng \u0111\u1eb7c bi\u1ec7t nh\u01b0 b\u1ea3ng t\u00ednh \u0111i\u1ec1u khi\u1ec3n, t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u v\u00e0 t\u1ea1o bi\u1ec3u \u0111\u1ed3.<\/p>\n<figure id=\"attachment_21666\" aria-describedby=\"caption-attachment-21666\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-21666 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2023\/05\/cach-hoc-excel-2.jpg\" alt=\"H\u1ecdc c\u00e1ch ph\u00e2n t\u00edch thu\u1eadt to\u00e1n\" width=\"800\" height=\"480\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2023\/05\/cach-hoc-excel-2.jpg 800w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2023\/05\/cach-hoc-excel-2-400x240.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2023\/05\/cach-hoc-excel-2-768x461.jpg 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-21666\" class=\"wp-caption-text\">H\u1ecdc c\u00e1ch ph\u00e2n t\u00edch thu\u1eadt to\u00e1n<\/figcaption><\/figure>\n<p style=\"text-align: center;\"><i><span style=\"font-weight: 400;\">H\u1ecdc c\u00e1ch ph\u00e2n t\u00edch thu\u1eadt to\u00e1n<\/span><\/i><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Bi_kip_tu_hoc_Excel_co_ban_tu_A_den_Z\"><\/span><b>B\u00ed k\u00edp t\u1ef1 h\u1ecdc Excel c\u01a1 b\u1ea3n t\u1eeb A \u0111\u1ebfn Z<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">V\u1edbi b\u00ed k\u00edp n\u00e0y, b\u1ea1n s\u1ebd c\u00f3 \u0111\u1ea7y \u0111\u1ee7 ki\u1ebfn th\u1ee9c, k\u1ef9 n\u0103ng c\u1ea7n thi\u1ebft \u0111\u1ec3 s\u1eed d\u1ee5ng Excel. H\u00e3y b\u1eaft \u0111\u1ea7u h\u00e0nh tr\u00ecnh t\u1ef1 h\u1ecdc Excel c\u00f9ng ch\u00fang t\u00f4i \u0111\u1ec3 tr\u1edf th\u00e0nh ng\u01b0\u1eddi gi\u1ecfi nh\u1ea5t. B\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng c\u00e1c b\u01b0\u1edbc sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">X\u00e1c \u0111\u1ecbnh m\u1ee5c ti\u00eau v\u00e0 ph\u1ea1m vi h\u1ecdc: \u0110\u1ea7u ti\u00ean, x\u00e1c \u0111\u1ecbnh nh\u1eefng kh\u00e1i ni\u1ec7m c\u01a1 b\u1ea3n b\u1ea1n mu\u1ed1n h\u1ecdc trong Excel. \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 bao g\u1ed3m c\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n, \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u, b\u1ea3ng t\u00ednh, bi\u1ec3u \u0111\u1ed3, h\u00e0m.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ecm ki\u1ebfm t\u00e0i li\u1ec7u h\u1ecdc: C\u00f3 nhi\u1ec1u t\u00e0i li\u1ec7u <em><strong>h\u1ecdc Excel<\/strong> <\/em>mi\u1ec5n ph\u00ed tr\u00ean m\u1ea1ng. Bao g\u1ed3m s\u00e1ch, video h\u01b0\u1edbng d\u1eabn v\u00e0 b\u00e0i vi\u1ebft. T\u00ecm nh\u1eefng ngu\u1ed3n h\u1ecdc ph\u00f9 h\u1ee3p v\u1edbi m\u1ee5c ti\u00eau c\u1ee7a b\u1ea1n.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Th\u1ef1c h\u00e0nh th\u01b0\u1eddng xuy\u00ean: \u0110\u1ec3 tr\u1edf n\u00ean th\u00e0nh th\u1ea1o Excel, th\u1ef1c h\u00e0nh l\u00e0 \u0111i\u1ec1u c\u1ea7n thi\u1ebft. T\u1ea1o c\u00e1c b\u00e0i t\u1eadp th\u1ef1c t\u1ebf, t\u1ea1o b\u1ea3ng t\u00ednh, th\u1eed \u00e1p d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c v\u00e0 h\u00e0m.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Kh\u00e1m ph\u00e1 c\u00e1c t\u00ednh n\u0103ng ti\u00ean ti\u1ebfn: Sau khi l\u00e0m quen v\u1edbi c\u00e1c kh\u00e1i ni\u1ec7m c\u01a1 b\u1ea3n, b\u1ea1n c\u00f3 th\u1ec3 kh\u00e1m ph\u00e1 c\u00e1c t\u00ednh n\u0103ng ti\u00ean ti\u1ebfn c\u1ee7a Excel. \u0110\u00f3 c\u00f3 th\u1ec3 l\u00e0 PivotTable, Macro, Solver v\u00e0 c\u00e1c c\u00f4ng c\u1ee5 ph\u00e2n t\u00edch d\u1eef li\u1ec7u kh\u00e1c.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Tham gia c\u1ed9ng \u0111\u1ed3ng h\u1ecdc Excel: B\u1ea1n c\u00f3 th\u1ec3 h\u1ecdc h\u1ecfi v\u00e0 trao \u0111\u1ed5i kinh nghi\u1ec7m v\u1edbi nh\u1eefng ng\u01b0\u1eddi kh\u00e1c. Tham gia v\u00e0o c\u00e1c nh\u00f3m, di\u1ec5n \u0111\u00e0n ho\u1eb7c c\u00e1c kh\u00f3a h\u1ecdc tr\u1ef1c tuy\u1ebfn \u0111\u1ec3 \u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u00c1p d\u1ee5ng Excel v\u00e0o c\u00f4ng vi\u1ec7c th\u1ef1c t\u1ebf: \u0110\u1ec3 n\u1eafm v\u1eefng Excel, h\u00e3y \u00e1p d\u1ee5ng ki\u1ebfn th\u1ee9c c\u1ee7a m\u00ecnh v\u00e0o c\u00f4ng vi\u1ec7c th\u1ef1c t\u1ebf. S\u1eed d\u1ee5ng Excel \u0111\u1ec3 t\u1ea1o b\u00e1o c\u00e1o, ph\u00e2n t\u00edch d\u1eef li\u1ec7u, qu\u1ea3n l\u00fd d\u1ef1 \u00e1n&#8230;\u00a0<\/span><\/li>\n<\/ul>\n<p>&gt;&gt;&gt;Xem th\u00eam: <span data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Export Excel PHP nh\u01b0 th\u1ebf n\u00e0o? H\u01b0\u1edbng d\u1eabn thao t\u00e1c trong PHPExcel&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:4993,&quot;3&quot;:{&quot;1&quot;:0},&quot;10&quot;:2,&quot;11&quot;:0,&quot;12&quot;:0,&quot;15&quot;:&quot;Arial&quot;}\"><a href=\"https:\/\/teky.edu.vn\/blog\/export-excel-php\/\">Export Excel PHP<\/a> nh\u01b0 th\u1ebf n\u00e0o? H\u01b0\u1edbng d\u1eabn thao t\u00e1c trong PHPExcel<\/span><\/p>\n<figure id=\"attachment_21665\" aria-describedby=\"caption-attachment-21665\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-21665 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2023\/05\/cach-hoc-excel-1.jpg\" alt=\"B\u00ed k\u00edp t\u1ef1 h\u1ecdc Excel c\u01a1 b\u1ea3n t\u1eeb A \u0111\u1ebfn Z\" width=\"800\" height=\"480\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2023\/05\/cach-hoc-excel-1.jpg 800w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2023\/05\/cach-hoc-excel-1-400x240.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2023\/05\/cach-hoc-excel-1-768x461.jpg 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-21665\" class=\"wp-caption-text\">B\u00ed k\u00edp t\u1ef1 h\u1ecdc Excel c\u01a1 b\u1ea3n t\u1eeb A \u0111\u1ebfn Z<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\"><em><strong>C\u00e1ch h\u1ecdc Excel<\/strong><\/em> l\u00e0 m\u1ed9t ch\u1ee7 \u0111\u1ec1 r\u1ea5t quan tr\u1ecdng \u0111\u1ed1i v\u1edbi nh\u1eefng ng\u01b0\u1eddi mong mu\u1ed1n n\u1eafm v\u1eefng k\u1ef9 n\u0103ng x\u1eed l\u00fd b\u1ea3ng t\u00ednh hi\u1ec7u qu\u1ea3. B\u1ea1n c\u1ea7n r\u00e8n luy\u1ec7n t\u00ednh ki\u00ean tr\u00ec, h\u1ecdc thu\u1ed9c c\u00e1c h\u00e0m c\u01a1 b\u1ea3n v\u00e0 bi\u1ebft c\u00e1ch ph\u00e2n t\u00edch thu\u1eadt to\u00e1n. V\u1edbi b\u00ed k\u00edp n\u00e0y, b\u1ea1n s\u1ebd c\u00f3 th\u1ec3 h\u1ecdc Excel c\u01a1 b\u1ea3n t\u1eeb A \u0111\u1ebfn Z m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3. H\u00e3y b\u1eaft \u0111\u1ea7u h\u1ecdc ngay h\u00f4m nay \u0111\u1ec3 c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng k\u1ef9 n\u0103ng Excel v\u00e0o c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh.<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"C\u00e1c K\u1ef9 N\u0103ng Excel C\u1ea7n Thi\u1ebft Cho Ng\u01b0\u1eddi \u0110i L\u00e0m (FULL 68 ph\u00fat)\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/10geolzI2Ec?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><em><strong>Xem th\u00eam: <\/strong><\/em><\/p>\n<ul>\n<li><em><strong><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 iyHtHS\" href=\"https:\/\/teky.edu.vn\/blog\/cach-danh-dau-tich-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch \u0111\u00e1nh d\u1ea5u t\u00edch trong Excel ch\u1ec9 v\u1edbi v\u00e0i thao t\u00e1c \u0111\u01a1n gi\u1ea3n<\/a><\/strong><\/em><\/li>\n<li><em><strong><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 iyHtHS\" href=\"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u00e2n trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n<\/a><\/strong><\/em><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>C\u00e1ch h\u1ecdc Excel l\u00e0 m\u1ed9t ch\u1ee7 \u0111\u1ec1 \u0111\u01b0\u1ee3c quan t\u00e2m nh\u1ea5t, \u0111\u1eb7c bi\u1ec7t \u0111\u1ed1i v\u1edbi nh\u1eefng ng\u01b0\u1eddi mu\u1ed1n n\u1eafm b\u1eaft \u0111\u01b0\u1ee3c nh\u1eefng kh\u00eda c\u1ea1nh quan tr\u1ecdng c\u1ee7a vi\u1ec7c l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3. B\u1eb1ng c\u00e1ch t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c nguy\u00ean t\u1eafc c\u01a1 b\u1ea3n, h\u1ecdc thu\u1eadt to\u00e1n v\u00e0 th\u1ef1c h\u00e0nh th\u01b0\u1eddng xuy\u00ean, &hellip;<\/p>\n","protected":false},"author":26,"featured_media":21664,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"show_on_app":false,"footnotes":""},"categories":[28],"tags":[],"class_list":["post-21663","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-lap-trinh"],"acf":{"show_on_app":false},"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>3 C\u00e1ch h\u1ecdc Excel nhanh nh\u1ea5t cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u hi\u1ec7u qu\u1ea3<\/title>\n<meta name=\"description\" content=\"B\u1ea1n mu\u1ed1n h\u1ecdc Excel m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3? H\u00e3y kh\u00e1m ph\u00e1 c\u00e1ch h\u1ecdc Excel ngay sau \u0111\u00e2y th\u00f4ng qua r\u00e8n luy\u1ec7n ki\u00ean tr\u00ec, h\u1ecdc thu\u1ed9c c\u00e1c h\u00e0m c\u01a1 b\u1ea3n v\u00e0 ph\u00e2n t\u00edch thu\u1eadt to\u00e1n.\u00a0\" \/>\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-hoc-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"3 C\u00e1ch h\u1ecdc Excel nhanh nh\u1ea5t cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u hi\u1ec7u qu\u1ea3\" \/>\n<meta property=\"og:description\" content=\"B\u1ea1n mu\u1ed1n h\u1ecdc Excel m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3? H\u00e3y kh\u00e1m ph\u00e1 c\u00e1ch h\u1ecdc Excel ngay sau \u0111\u00e2y th\u00f4ng qua r\u00e8n luy\u1ec7n ki\u00ean tr\u00ec, h\u1ecdc thu\u1ed9c c\u00e1c h\u00e0m c\u01a1 b\u1ea3n v\u00e0 ph\u00e2n t\u00edch thu\u1eadt to\u00e1n.\u00a0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/cach-hoc-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=\"2023-10-10T07:08:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-25T02:21:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2023\/05\/cach-hoc-excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"480\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"H\u1eb1ng L\u00ea\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"H\u1eb1ng L\u00ea\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"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-hoc-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-hoc-excel\/\"},\"author\":{\"name\":\"H\u1eb1ng L\u00ea\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b\"},\"headline\":\"3 C\u00e1ch h\u1ecdc Excel nhanh nh\u1ea5t cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u hi\u1ec7u qu\u1ea3\",\"datePublished\":\"2023-10-10T07:08:13+00:00\",\"dateModified\":\"2024-01-25T02:21:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-hoc-excel\/\"},\"wordCount\":2151,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-hoc-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2023\/05\/cach-hoc-excel.jpg\",\"articleSection\":[\"IT - L\u1eadp tr\u00ecnh\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-hoc-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-hoc-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/cach-hoc-excel\/\",\"name\":\"3 C\u00e1ch h\u1ecdc Excel nhanh nh\u1ea5t cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u hi\u1ec7u qu\u1ea3\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-hoc-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-hoc-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2023\/05\/cach-hoc-excel.jpg\",\"datePublished\":\"2023-10-10T07:08:13+00:00\",\"dateModified\":\"2024-01-25T02:21:14+00:00\",\"description\":\"B\u1ea1n mu\u1ed1n h\u1ecdc Excel m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3? H\u00e3y kh\u00e1m ph\u00e1 c\u00e1ch h\u1ecdc Excel ngay sau \u0111\u00e2y th\u00f4ng qua r\u00e8n luy\u1ec7n ki\u00ean tr\u00ec, h\u1ecdc thu\u1ed9c c\u00e1c h\u00e0m c\u01a1 b\u1ea3n v\u00e0 ph\u00e2n t\u00edch thu\u1eadt to\u00e1n.\u00a0\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-hoc-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-hoc-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-hoc-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2023\/05\/cach-hoc-excel.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2023\/05\/cach-hoc-excel.jpg\",\"width\":800,\"height\":480,\"caption\":\"C\u00e1ch h\u1ecdc Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-hoc-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"IT - L\u1eadp tr\u00ecnh\",\"item\":\"https:\/\/teky.edu.vn\/blog\/lap-trinh\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"3 C\u00e1ch h\u1ecdc Excel nhanh nh\u1ea5t cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u hi\u1ec7u qu\u1ea3\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b\",\"name\":\"H\u1eb1ng L\u00ea\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g\",\"caption\":\"H\u1eb1ng L\u00ea\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/lehang\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"3 C\u00e1ch h\u1ecdc Excel nhanh nh\u1ea5t cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u hi\u1ec7u qu\u1ea3","description":"B\u1ea1n mu\u1ed1n h\u1ecdc Excel m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3? H\u00e3y kh\u00e1m ph\u00e1 c\u00e1ch h\u1ecdc Excel ngay sau \u0111\u00e2y th\u00f4ng qua r\u00e8n luy\u1ec7n ki\u00ean tr\u00ec, h\u1ecdc thu\u1ed9c c\u00e1c h\u00e0m c\u01a1 b\u1ea3n v\u00e0 ph\u00e2n t\u00edch thu\u1eadt to\u00e1n.\u00a0","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-hoc-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"3 C\u00e1ch h\u1ecdc Excel nhanh nh\u1ea5t cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u hi\u1ec7u qu\u1ea3","og_description":"B\u1ea1n mu\u1ed1n h\u1ecdc Excel m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3? H\u00e3y kh\u00e1m ph\u00e1 c\u00e1ch h\u1ecdc Excel ngay sau \u0111\u00e2y th\u00f4ng qua r\u00e8n luy\u1ec7n ki\u00ean tr\u00ec, h\u1ecdc thu\u1ed9c c\u00e1c h\u00e0m c\u01a1 b\u1ea3n v\u00e0 ph\u00e2n t\u00edch thu\u1eadt to\u00e1n.\u00a0","og_url":"https:\/\/teky.edu.vn\/blog\/cach-hoc-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":"2023-10-10T07:08:13+00:00","article_modified_time":"2024-01-25T02:21:14+00:00","og_image":[{"width":800,"height":480,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2023\/05\/cach-hoc-excel.jpg","type":"image\/jpeg"}],"author":"H\u1eb1ng L\u00ea","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"H\u1eb1ng L\u00ea","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"8 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/cach-hoc-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-hoc-excel\/"},"author":{"name":"H\u1eb1ng L\u00ea","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b"},"headline":"3 C\u00e1ch h\u1ecdc Excel nhanh nh\u1ea5t cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u hi\u1ec7u qu\u1ea3","datePublished":"2023-10-10T07:08:13+00:00","dateModified":"2024-01-25T02:21:14+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-hoc-excel\/"},"wordCount":2151,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-hoc-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2023\/05\/cach-hoc-excel.jpg","articleSection":["IT - L\u1eadp tr\u00ecnh"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/cach-hoc-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/cach-hoc-excel\/","url":"https:\/\/teky.edu.vn\/blog\/cach-hoc-excel\/","name":"3 C\u00e1ch h\u1ecdc Excel nhanh nh\u1ea5t cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u hi\u1ec7u qu\u1ea3","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-hoc-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-hoc-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2023\/05\/cach-hoc-excel.jpg","datePublished":"2023-10-10T07:08:13+00:00","dateModified":"2024-01-25T02:21:14+00:00","description":"B\u1ea1n mu\u1ed1n h\u1ecdc Excel m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3? H\u00e3y kh\u00e1m ph\u00e1 c\u00e1ch h\u1ecdc Excel ngay sau \u0111\u00e2y th\u00f4ng qua r\u00e8n luy\u1ec7n ki\u00ean tr\u00ec, h\u1ecdc thu\u1ed9c c\u00e1c h\u00e0m c\u01a1 b\u1ea3n v\u00e0 ph\u00e2n t\u00edch thu\u1eadt to\u00e1n.\u00a0","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-hoc-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/cach-hoc-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/cach-hoc-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2023\/05\/cach-hoc-excel.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2023\/05\/cach-hoc-excel.jpg","width":800,"height":480,"caption":"C\u00e1ch h\u1ecdc Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/cach-hoc-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"IT - L\u1eadp tr\u00ecnh","item":"https:\/\/teky.edu.vn\/blog\/lap-trinh\/"},{"@type":"ListItem","position":2,"name":"3 C\u00e1ch h\u1ecdc Excel nhanh nh\u1ea5t cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u hi\u1ec7u qu\u1ea3"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b","name":"H\u1eb1ng L\u00ea","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g","caption":"H\u1eb1ng L\u00ea"},"url":"https:\/\/teky.edu.vn\/blog\/author\/lehang\/"}]}},"thumbnail":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2023\/05\/cach-hoc-excel-400x240.jpg","_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/21663","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=21663"}],"version-history":[{"count":11,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/21663\/revisions"}],"predecessor-version":[{"id":24144,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/21663\/revisions\/24144"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/21664"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=21663"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=21663"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=21663"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}