{"id":95187,"date":"2024-08-13T10:26:11","date_gmt":"2024-08-13T03:26:11","guid":{"rendered":"https:\/\/phongvu.vn\/cong-nghe\/?p=95187"},"modified":"2025-10-17T14:45:42","modified_gmt":"2025-10-17T07:45:42","slug":"tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi","status":"publish","type":"post","link":"https:\/\/phongvu.vn\/cong-nghe\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi\/","title":{"rendered":"T\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 Excel c\u01a1 b\u1ea3n, d\u1ec5 hi\u1ec3u d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi"},"content":{"rendered":"\n<p>Excel &#8211; c\u00f4ng c\u1ee5 kh\u00f4ng th\u1ec3 thi\u1ebfu trong c\u00f4ng vi\u1ec7c v\u0103n ph\u00f2ng, gi\u00fap b\u1ea1n qu\u1ea3n l\u00fd d\u1eef li\u1ec7u, t\u1ea1o b\u00e1o c\u00e1o m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c. Nh\u01b0ng \u0111\u1ed1i v\u1edbi nh\u1eefng ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u, Excel c\u00f3 th\u1ec3 kh\u00e1 ph\u1ee9c t\u1ea1p. B\u00e0i vi\u1ebft n\u00e0y, <a href=\"https:\/\/phongvu.vn\/cong-nghe\/\">Phong V\u0169 Tech News<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n t\u1eebng b\u01b0\u1edbc t\u1eeb nh\u1eefng ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n nh\u1ea5t, gi\u00fap b\u1ea1n t\u1ef1 tin s\u1eed d\u1ee5ng Excel \u0111\u1ec3 gi\u1ea3i quy\u1ebft c\u00e1c c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y.<\/p>\n\n\n\n<ul>\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/laptop-gaming-la-gi-cac-dong-laptop-gaming-dang-mua-nam-2024\/\">Laptop gaming l\u00e0 g\u00ec? C\u00e1c d\u00f2ng laptop gaming \u0111\u00e1ng mua n\u0103m 2024<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/notion-vu-tru-lam-viec-khong-gioi-han-cho-ban\/\">Notion \u2013 V\u0169 tr\u1ee5 l\u00e0m vi\u1ec7c kh\u00f4ng gi\u1edbi h\u1ea1n cho ri\u00eang b\u1ea1n<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/tieu-chuan-do-ben-mil-std-810h\/\">Ti\u00eau chu\u1ea9n \u0111\u1ed9 b\u1ec1n MIL-STD-810H l\u00e0 g\u00ec?<\/a><\/li>\n<\/ul>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_55 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 \" >M\u1ee5c l\u1ee5c<\/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\" role=\"button\"><label for=\"item-6a2a293d87e5f\" ><span class=\"\"><span 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><\/label><input aria-label=\"Toggle\" aria-label=\"item-6a2a293d87e5f\"  type=\"checkbox\" id=\"item-6a2a293d87e5f\"><\/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:\/\/phongvu.vn\/cong-nghe\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi\/#Gioi_thieu_ve_Excel\" title=\"Gi\u1edbi thi\u1ec7u v\u1ec1 Excel\">Gi\u1edbi thi\u1ec7u v\u1ec1 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:\/\/phongvu.vn\/cong-nghe\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi\/#Giao_dien_va_cac_thanh_phan_co_ban_cua_Excel\" title=\"Giao di\u1ec7n v\u00e0 c\u00e1c th\u00e0nh ph\u1ea7n c\u01a1 b\u1ea3n c\u1ee7a Excel\">Giao di\u1ec7n v\u00e0 c\u00e1c th\u00e0nh ph\u1ea7n c\u01a1 b\u1ea3n c\u1ee7a 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:\/\/phongvu.vn\/cong-nghe\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi\/#Cac_cong_thuc_co_ban\" title=\"C\u00e1c c\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n\">C\u00e1c c\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi\/#Cac_tinh_nang_nang_cao\" title=\"C\u00e1c t\u00ednh n\u0103ng n\u00e2ng cao\">C\u00e1c t\u00ednh n\u0103ng n\u00e2ng cao<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi\/#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Gioi_thieu_ve_Excel\"><\/span><strong>Gi\u1edbi thi\u1ec7u v\u1ec1 Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Excel l\u00e0 m\u1ed9t ph\u1ea7n m\u1ec1m b\u1ea3ng t\u00ednh \u0111i\u1ec7n t\u1eed v\u00f4 c\u00f9ng m\u1ea1nh m\u1ebd v\u00e0 ph\u1ed5 bi\u1ebfn. V\u00ec th\u1ebf, Excel&nbsp; \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i trong nhi\u1ec1u l\u0129nh v\u1ef1c kh\u00e1c nhau, t\u1eeb k\u1ebf to\u00e1n, t\u00e0i ch\u00ednh, \u0111\u1ebfn qu\u1ea3n l\u00fd d\u1ef1 \u00e1n, ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u00e0 th\u1eadm ch\u00ed c\u1ea3 thi\u1ebft k\u1ebf \u0111\u1ed3 h\u1ecda \u0111\u01a1n gi\u1ea3n.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-1-1024x640.jpg\" alt=\"\" class=\"wp-image-95189\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-1-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-1-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-1-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-1-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-1-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-1-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-1-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-1-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-1-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-1-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-1.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Gi\u1edbi thi\u1ec7u v\u1ec1 Excel<\/figcaption><\/figure>\n\n\n\n<p>V\u00ec th\u1ebf, vi\u1ec7c trang b\u1ecb cho m\u00ecnh nh\u1eefng ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n v\u1ec1 Excel s\u1ebd gi\u00fap b\u1ea1n t\u1ef1 tin h\u01a1n trong c\u00f4ng vi\u1ec7c v\u00e0 m\u1edf ra nhi\u1ec1u c\u01a1 h\u1ed9i m\u1edbi:<\/p>\n\n\n\n<ul>\n<li><strong>T\u0103ng n\u0103ng su\u1ea5t l\u00e0m vi\u1ec7c<\/strong>: Excel gi\u00fap b\u1ea1n t\u1ef1 \u0111\u1ed9ng h\u00f3a c\u00e1c c\u00f4ng vi\u1ec7c l\u1eb7p \u0111i l\u1eb7p l\u1ea1i, t\u00ednh to\u00e1n nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c, t\u1eeb \u0111\u00f3 ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c.<\/li>\n\n\n\n<li><strong>Tr\u00ecnh b\u00e0y d\u1eef li\u1ec7u chuy\u00ean nghi\u1ec7p:<\/strong> V\u1edbi Excel, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o ra c\u00e1c b\u1ea3ng t\u00ednh, bi\u1ec3u \u0111\u1ed3 \u0111\u1eb9p m\u1eaft, tr\u1ef1c quan, gi\u00fap b\u1ea1n tr\u00ecnh b\u00e0y th\u00f4ng tin m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 v\u00e0 thuy\u1ebft ph\u1ee5c h\u01a1n.<\/li>\n\n\n\n<li><strong>Ph\u00e2n t\u00edch d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3<\/strong>: Excel cung c\u1ea5p nhi\u1ec1u c\u00f4ng c\u1ee5 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ea1nh m\u1ebd, gi\u00fap b\u1ea1n kh\u00e1m ph\u00e1 nh\u1eefng xu h\u01b0\u1edbng, m\u1ed1i quan h\u1ec7 \u1ea9n sau d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng.<\/li>\n\n\n\n<li><strong>N\u00e2ng cao kh\u1ea3 n\u0103ng c\u1ea1nh tranh<\/strong>: K\u1ef9 n\u0103ng s\u1eed d\u1ee5ng Excel l\u00e0 m\u1ed9t l\u1ee3i th\u1ebf l\u1edbn trong th\u1ecb tr\u01b0\u1eddng lao \u0111\u1ed9ng hi\u1ec7n nay. Nhi\u1ec1u nh\u00e0 tuy\u1ec3n d\u1ee5ng \u0111\u1ec1u y\u00eau c\u1ea7u \u1ee9ng vi\u00ean c\u00f3 kh\u1ea3 n\u0103ng l\u00e0m vi\u1ec7c th\u00e0nh th\u1ea1o v\u1edbi Excel.<\/li>\n<\/ul>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Giao_dien_va_cac_thanh_phan_co_ban_cua_Excel\"><\/span><strong>Giao di\u1ec7n v\u00e0 c\u00e1c th\u00e0nh ph\u1ea7n c\u01a1 b\u1ea3n c\u1ee7a Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 b\u1ea3ng t\u00ednh m\u1ea1nh m\u1ebd v\u00e0 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i. \u0110\u1ec3 l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 v\u1edbi Excel, b\u1ea1n c\u1ea7n hi\u1ec3u r\u00f5 v\u1ec1 giao di\u1ec7n v\u00e0 c\u00e1c th\u00e0nh ph\u1ea7n c\u01a1 b\u1ea3n c\u1ee7a n\u00f3.<\/p>\n\n\n\n<p><strong>Khi m\u1edf Excel, b\u1ea1n s\u1ebd th\u1ea5y m\u1ed9t giao di\u1ec7n ch\u00ednh bao g\u1ed3m c\u00e1c th\u00e0nh ph\u1ea7n sau:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>Thanh ti\u00eau \u0111\u1ec1<\/strong>: Hi\u1ec3n th\u1ecb t\u00ean t\u1ec7p Excel b\u1ea1n \u0111ang l\u00e0m vi\u1ec7c v\u00e0 t\u00ean ch\u01b0\u01a1ng tr\u00ecnh.<\/li>\n\n\n\n<li><strong>Thanh c\u00f4ng c\u1ee5 truy c\u1eadp nhanh<\/strong>: Ch\u1ee9a c\u00e1c l\u1ec7nh \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng th\u01b0\u1eddng xuy\u00ean nh\u01b0 l\u01b0u, ho\u00e0n t\u00e1c, l\u00e0m l\u1ea1i.<\/li>\n\n\n\n<li><strong>Thanh Ribbon<\/strong>: Ch\u1ee9a c\u00e1c tab nh\u01b0 Home, Insert, Data, &#8230; M\u1ed7i tab ch\u1ee9a c\u00e1c nh\u00f3m l\u1ec7nh li\u00ean quan \u0111\u1ebfn c\u00e1c ch\u1ee9c n\u0103ng kh\u00e1c nhau c\u1ee7a Excel.<\/li>\n\n\n\n<li><strong>Thanh c\u00f4ng th\u1ee9c<\/strong>: Hi\u1ec3n th\u1ecb n\u1ed9i dung c\u1ee7a \u00f4 \u0111ang \u0111\u01b0\u1ee3c ch\u1ecdn v\u00e0 cho ph\u00e9p b\u1ea1n nh\u1eadp d\u1eef li\u1ec7u ho\u1eb7c c\u00f4ng th\u1ee9c.<\/li>\n\n\n\n<li><strong>H\u1ed9p t\u00ean<\/strong>: Hi\u1ec3n th\u1ecb \u0111\u1ecba ch\u1ec9 c\u1ee7a \u00f4 \u0111ang \u0111\u01b0\u1ee3c ch\u1ecdn (v\u00ed d\u1ee5: A1, B2).<\/li>\n\n\n\n<li><strong>Trang t\u00ednh<\/strong>: L\u00e0 n\u01a1i b\u1ea1n nh\u1eadp d\u1eef li\u1ec7u, t\u1ea1o b\u1ea3ng, bi\u1ec3u \u0111\u1ed3.<\/li>\n\n\n\n<li><strong>Thanh tr\u1ea1ng th\u00e1i<\/strong>: Hi\u1ec3n th\u1ecb th\u00f4ng tin v\u1ec1 trang t\u00ednh \u0111ang l\u00e0m vi\u1ec7c, ch\u1ebf \u0111\u1ed9 xem, s\u1ed1 trang,&#8230;<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-2-1024x640.jpg\" alt=\"\" class=\"wp-image-95190\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-2-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-2-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-2-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-2-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-2-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-2-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-2-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-2-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-2-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-2-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-2.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Giao di\u1ec7n v\u00e0 c\u00e1c th\u00e0nh ph\u1ea7n c\u01a1 b\u1ea3n c\u1ee7a Excel<\/figcaption><\/figure>\n\n\n\n<p><strong>C\u00e1c th\u00e0nh ph\u1ea7n c\u01a1 b\u1ea3n tr\u00ean trang t\u00ednh:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>\u00d4<\/strong>: L\u00e0 \u0111\u01a1n v\u1ecb nh\u1ecf nh\u1ea5t tr\u00ean trang t\u00ednh, \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh b\u1edfi m\u1ed9t c\u1ed9t v\u00e0 m\u1ed9t h\u00e0ng.<\/li>\n\n\n\n<li><strong>H\u00e0ng<\/strong>: M\u1ed9t d\u00f2ng ngang tr\u00ean trang t\u00ednh, \u0111\u01b0\u1ee3c \u0111\u00e1nh s\u1ed1.<\/li>\n\n\n\n<li><strong>C\u1ed9t<\/strong>: M\u1ed9t d\u00f2ng d\u1ecdc tr\u00ean trang t\u00ednh, \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u b\u1eb1ng c\u00e1c ch\u1eef c\u00e1i.<\/li>\n\n\n\n<li><strong>Kh\u1ed1i<\/strong>: M\u1ed9t nh\u00f3m c\u00e1c \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn.<\/li>\n<\/ul>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Cac_cong_thuc_co_ban\"><\/span><strong>C\u00e1c c\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 v\u00f4 c\u00f9ng 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. M\u1ed9t trong nh\u1eefng t\u00ednh n\u0103ng quan tr\u1ecdng nh\u1ea5t c\u1ee7a Excel ch\u00ednh l\u00e0 kh\u1ea3 n\u0103ng s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c. V\u1edbi c\u00f4ng th\u1ee9c, b\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 \u0111\u1ed9ng h\u00f3a c\u00e1c t\u00ednh to\u00e1n, ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u00e0 \u0111\u01b0a ra quy\u1ebft \u0111\u1ecbnh d\u1ef1a tr\u00ean th\u00f4ng tin ch\u00ednh x\u00e1c.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-3-1024x640.jpg\" alt=\"\" class=\"wp-image-95191\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-3-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-3-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-3-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-3-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-3-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-3-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-3-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-3-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-3-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-3-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-3.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">C\u00e1c c\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n<\/figcaption><\/figure>\n\n\n\n<p>M\u1ed9t c\u00f4ng th\u1ee9c trong Excel lu\u00f4n b\u1eaft \u0111\u1ea7u b\u1eb1ng d\u1ea5u b\u1eb1ng (=) v\u00e0 c\u00f3 th\u1ec3 bao g\u1ed3m:&nbsp;<\/p>\n\n\n\n<ul>\n<li><strong>Tham chi\u1ebfu \u00f4<\/strong>: Ch\u1ec9 \u0111\u1ecbnh \u00f4 ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n s\u1eed d\u1ee5ng trong c\u00f4ng th\u1ee9c (v\u00ed d\u1ee5: A1, B2).<\/li>\n\n\n\n<li><strong>To\u00e1n t\u1eed<\/strong>: C\u00e1c ph\u00e9p to\u00e1n c\u01a1 b\u1ea3n nh\u01b0 c\u1ed9ng (+), tr\u1eeb (-), nh\u00e2n (*), chia (\/).<\/li>\n\n\n\n<li><strong>H\u00e0m<\/strong>: C\u00e1c h\u00e0m \u0111\u01b0\u1ee3c \u0111\u1ecbnh s\u1eb5n \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh ph\u1ee9c t\u1ea1p h\u01a1n (v\u00ed d\u1ee5: SUM, AVERAGE, COUNT).<\/li>\n<\/ul>\n\n\n\n<p>V\u00ed d\u1ee5: C\u00f4ng th\u1ee9c =A1+B2 s\u1ebd c\u1ed9ng gi\u00e1 tr\u1ecb trong \u00f4 A1 v\u00e0 \u00f4 B2.<\/p>\n\n\n\n<p>C\u00e1c h\u00e0m c\u01a1 b\u1ea3n th\u01b0\u1eddng d\u00f9ng:&nbsp;<\/p>\n\n\n\n<ul>\n<li><strong>SUM:<\/strong> T\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t ph\u1ea1m vi \u00f4.<\/li>\n\n\n\n<li><strong>AVERAGE<\/strong>: T\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ee7a m\u1ed9t ph\u1ea1m vi \u00f4.<\/li>\n\n\n\n<li><strong>COUNT<\/strong>: \u0110\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 ch\u1ee9a s\u1ed1 trong m\u1ed9t ph\u1ea1m vi \u00f4.<\/li>\n\n\n\n<li><strong>MAX<\/strong>: T\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t trong m\u1ed9t ph\u1ea1m vi \u00f4.<\/li>\n\n\n\n<li><strong>MIN:<\/strong> T\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong m\u1ed9t ph\u1ea1m vi \u00f4.<\/li>\n<\/ul>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Cac_tinh_nang_nang_cao\"><\/span><strong>C\u00e1c t\u00ednh n\u0103ng n\u00e2ng cao<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Sau khi \u0111\u00e3 l\u00e0m quen v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c v\u00e0 h\u00e0m c\u01a1 b\u1ea3n, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n kh\u00e1m ph\u00e1 th\u00eam nh\u1eefng t\u00ednh n\u0103ng n\u00e2ng cao c\u1ee7a Excel \u0111\u1ec3 n\u00e2ng cao hi\u1ec7u qu\u1ea3 l\u00e0m vi\u1ec7c v\u00e0 x\u1eed l\u00fd nh\u1eefng v\u1ea5n \u0111\u1ec1 ph\u1ee9c t\u1ea1p h\u01a1n. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 t\u00ednh n\u0103ng \u0111\u00e1ng ch\u00fa \u00fd:&nbsp;<\/p>\n\n\n\n<p><strong>PivotTable v\u00e0 PivotChart<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>C\u00f4ng d\u1ee5ng<\/strong>: T\u00f3m t\u1eaft, ph\u00e2n t\u00edch v\u00e0 tr\u00ecnh b\u00e0y d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch tr\u1ef1c quan.<\/li>\n\n\n\n<li><strong>C\u00e1ch s\u1eed d\u1ee5ng<\/strong>: T\u1ea1o m\u1ed9t b\u1ea3ng t\u1ed5ng h\u1ee3p \u0111\u1ec3 nh\u00f3m, s\u1eafp x\u1ebfp v\u00e0 t\u00ednh to\u00e1n d\u1eef li\u1ec7u theo c\u00e1c ti\u00eau ch\u00ed kh\u00e1c nhau. T\u1eeb \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng t\u1ea1o c\u00e1c bi\u1ec3u \u0111\u1ed3 t\u01b0\u01a1ng t\u00e1c \u0111\u1ec3 tr\u1ef1c quan h\u00f3a d\u1eef li\u1ec7u.<\/li>\n\n\n\n<li><strong>\u1ee8ng d\u1ee5ng<\/strong>: Ph\u00e2n t\u00edch doanh s\u1ed1, d\u1eef li\u1ec7u kh\u00e1ch h\u00e0ng, b\u00e1o c\u00e1o t\u00e0i ch\u00ednh\u2026<\/li>\n<\/ul>\n\n\n\n<p><strong>Power Query:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>C\u00f4ng d\u1ee5ng<\/strong>: K\u1ebft n\u1ed1i v\u00e0 bi\u1ebfn \u0111\u1ed5i d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u ngu\u1ed3n kh\u00e1c nhau (Excel, CSV, SQL, web&#8230;) th\u00e0nh m\u1ed9t \u0111\u1ecbnh d\u1ea1ng th\u1ed1ng nh\u1ea5t \u0111\u1ec3 ph\u00e2n t\u00edch.<\/li>\n\n\n\n<li><strong>C\u00e1ch s\u1eed d\u1ee5ng<\/strong>: T\u1ea1o c\u00e1c truy v\u1ea5n \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u t\u1eeb c\u00e1c ngu\u1ed3n kh\u00e1c nhau, sau \u0111\u00f3 l\u00e0m s\u1ea1ch, bi\u1ebfn \u0111\u1ed5i v\u00e0 t\u1ea3i d\u1eef li\u1ec7u v\u00e0o Excel.<\/li>\n\n\n\n<li><strong>\u1ee8ng d\u1ee5ng<\/strong>: K\u1ebft h\u1ee3p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u b\u1ea3ng t\u00ednh, c\u01a1 s\u1edf d\u1eef li\u1ec7u \u0111\u1ec3 t\u1ea1o b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p.<\/li>\n<\/ul>\n\n\n\n<p><strong>Conditional Formatting:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>C\u00f4ng d\u1ee5ng<\/strong>: \u0110\u1ecbnh d\u1ea1ng c\u00e1c \u00f4 d\u1ef1a tr\u00ean c\u00e1c \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh.<\/li>\n\n\n\n<li><strong>C\u00e1ch s\u1eed d\u1ee5ng<\/strong>: \u00c1p d\u1ee5ng c\u00e1c quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng (m\u00e0u s\u1eafc, bi\u1ec3u t\u01b0\u1ee3ng, thanh d\u1eef li\u1ec7u&#8230;) cho c\u00e1c \u00f4 \u0111\u00e1p \u1ee9ng \u0111i\u1ec1u ki\u1ec7n.<\/li>\n\n\n\n<li><strong>\u1ee8ng d\u1ee5ng<\/strong>: Nh\u1eadn bi\u1ebft nhanh c\u00e1c gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t, nh\u1ecf nh\u1ea5t, c\u00e1c \u00f4 tr\u00f9ng l\u1eb7p, c\u00e1c \u00f4 c\u00f3 l\u1ed7i,&#8230;<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-4-1024x640.jpg\" alt=\"\" class=\"wp-image-95192\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-4-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-4-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-4-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-4-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-4-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-4-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-4-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-4-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-4-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-4-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi-4.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">C\u00e1c t\u00ednh n\u0103ng n\u00e2ng cao<\/figcaption><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span><strong>K\u1ebft lu\u1eadn<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Nh\u01b0 v\u1eady, ch\u00fang ta \u0111\u00e3 c\u00f9ng nhau kh\u00e1m ph\u00e1 nh\u1eefng ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n v\u1ec1 Excel. V\u1edbi nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 t\u1ef1 tin h\u01a1n trong vi\u1ec7c s\u1eed d\u1ee5ng Excel \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u, t\u1ea1o b\u00e1o c\u00e1o v\u00e0 n\u00e2ng cao hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c. H\u00e3y ti\u1ebfp t\u1ee5c luy\u1ec7n t\u1eadp v\u00e0 kh\u00e1m ph\u00e1 th\u00eam nhi\u1ec1u t\u00ednh n\u0103ng h\u1ea5p d\u1eabn kh\u00e1c c\u1ee7a Excel nh\u00e9!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel &#8211; c\u00f4ng c\u1ee5 kh\u00f4ng th\u1ec3 thi\u1ebfu trong c\u00f4ng vi\u1ec7c v\u0103n ph\u00f2ng, gi\u00fap b\u1ea1n qu\u1ea3n l\u00fd d\u1eef li\u1ec7u, t\u1ea1o b\u00e1o c\u00e1o m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c. Nh\u01b0ng \u0111\u1ed1i v\u1edbi nh\u1eefng ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u, Excel c\u00f3 th\u1ec3 kh\u00e1 ph\u1ee9c t\u1ea1p. B\u00e0i vi\u1ebft n\u00e0y, Phong V\u0169 Tech News s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n t\u1eebng b\u01b0\u1edbc [&hellip;]<\/p>\n","protected":false},"author":29,"featured_media":95189,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[74],"tags":[],"_links":{"self":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/95187"}],"collection":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/comments?post=95187"}],"version-history":[{"count":2,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/95187\/revisions"}],"predecessor-version":[{"id":100198,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/95187\/revisions\/100198"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media\/95189"}],"wp:attachment":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media?parent=95187"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/categories?post=95187"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/tags?post=95187"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}