{"id":94915,"date":"2024-08-10T02:36:39","date_gmt":"2024-08-09T19:36:39","guid":{"rendered":"https:\/\/phongvu.vn\/cong-nghe\/?p=94915"},"modified":"2024-08-12T23:49:35","modified_gmt":"2024-08-12T16:49:35","slug":"sinh-vien-quan-ly-chi-tieu-hieu-qua-voi-excel","status":"publish","type":"post","link":"https:\/\/phongvu.vn\/cong-nghe\/sinh-vien-quan-ly-chi-tieu-hieu-qua-voi-excel\/","title":{"rendered":"Sinh vi\u00ean l\u00e0m ch\u1ee7 t\u00e0i ch\u00ednh: C\u1ea9m nang s\u1eed d\u1ee5ng Excel qu\u1ea3n l\u00fd chi ti\u00eau"},"content":{"rendered":"\n<p>Th\u1eddi sinh vi\u00ean th\u01b0\u1eddng g\u1eafn li\u1ec1n v\u1edbi nh\u1eefng tr\u1ea3i nghi\u1ec7m \u0111\u1ea7u \u0111\u1eddi v\u1ec1 t\u1ef1 l\u1eadp t\u00e0i ch\u00ednh. Gi\u1eefa h\u1ecdc ph\u00ed, chi ph\u00ed sinh ho\u1ea1t, s\u00e1ch v\u1edf v\u00e0 \u0111i l\u1ea1i, vi\u1ec7c c\u00e2n \u0111\u1ed1i chi ti\u00eau tr\u1edf th\u00e0nh m\u1ed9t b\u00e0i to\u00e1n kh\u00f4ng h\u1ec1 \u0111\u01a1n gi\u1ea3n. Trong b\u1ed1i c\u1ea3nh \u0111\u00f3, Excel s\u1ebd l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1eefu hi\u1ec7u gi\u00fap sinh vi\u00ean theo d\u00f5i v\u00e0 qu\u1ea3n l\u00fd t\u00e0i ch\u00ednh c\u00e1 nh\u00e2n m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3. H\u00e3y c\u00f9ng <a href=\"https:\/\/phongvu.vn\/cong-nghe\/\" target=\"_blank\" rel=\"noreferrer noopener\">Phong V\u0169<\/a> kh\u00e1m ph\u00e1 c\u00e1ch Excel c\u00f3 th\u1ec3 tr\u1edf th\u00e0nh &#8220;tr\u1ee3 l\u00fd t\u00e0i ch\u00ednh&#8221; \u0111\u1eafc l\u1ef1c cho b\u1ea1n trong su\u1ed1t qu\u00e3ng \u0111\u1eddi sinh vi\u00ean.<\/p>\n\n\n\n<ul>\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/cac-phan-mem-ma-hoc-sinh-sinh-vien-nen-co\/?srsltid=AfmBOorWoTj4_4Tqs-7JYddEso6LuPwCsHtVv0QHQ8SWw6bm2JLzZfLp\" target=\"_blank\" rel=\"noreferrer noopener\">C\u00e1c ph\u1ea7n m\u1ec1m c\u1ea7n thi\u1ebft cho sinh vi\u00ean n\u00ean c\u00f3 trong laptop gi\u00fap h\u1ecdc t\u1eadp hi\u1ec7u qu\u1ea3<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/rui-ro-khi-su-dung-office-crack\/?srsltid=AfmBOoqlk34S5V8oXeWOKEeOKkec6KfA4qq4xZw5UDz0c0YBqpmhuJ2d\" target=\"_blank\" rel=\"noreferrer noopener\">Nh\u1eefng r\u1ee7i ro khi s\u1eed d\u1ee5ng Office crack<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/mua-laptop-hp-tai-phong-vu-nhan-ngay-bo-qua-tang-microsoft-office-len-den-1-78-trieu\/?srsltid=AfmBOopGNqywgF3rgTWycOA48shexCmVlzfk_fZScgV2JsK4uCar4S1Z\" target=\"_blank\" rel=\"noreferrer noopener\">Mua laptop HP t\u1ea1i Phong V\u0169 \u2013 Nh\u1eadn ngay b\u1ed9 qu\u00e0 t\u1eb7ng Microsoft Office l\u00ean \u0111\u1ebfn 1.78 tri\u1ec7u<\/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-6a1dbbefe1ee8\" ><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-6a1dbbefe1ee8\"  type=\"checkbox\" id=\"item-6a1dbbefe1ee8\"><\/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\/sinh-vien-quan-ly-chi-tieu-hieu-qua-voi-excel\/#Dung_Excel_quan_ly_chi_tieu_co_hieu_qua_khong\" title=\"D\u00f9ng Excel qu\u1ea3n l\u00fd chi ti\u00eau c\u00f3 hi\u1ec7u qu\u1ea3 kh\u00f4ng?\">D\u00f9ng Excel qu\u1ea3n l\u00fd chi ti\u00eau c\u00f3 hi\u1ec7u qu\u1ea3 kh\u00f4ng?<\/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\/sinh-vien-quan-ly-chi-tieu-hieu-qua-voi-excel\/#Cac_ham_Excel_thuong_dung_de_quan_ly_chi_tieu\" title=\"C\u00e1c h\u00e0m Excel th\u01b0\u1eddng d\u00f9ng \u0111\u1ec3 qu\u1ea3n l\u00fd chi ti\u00eau\">C\u00e1c h\u00e0m Excel th\u01b0\u1eddng d\u00f9ng \u0111\u1ec3 qu\u1ea3n l\u00fd chi ti\u00eau<\/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\/sinh-vien-quan-ly-chi-tieu-hieu-qua-voi-excel\/#Huong_dan_mot_vi_du_ve_quan_ly_chi_tieu\" title=\"H\u01b0\u1edbng d\u1eabn m\u1ed9t v\u00ed d\u1ee5 v\u1ec1 qu\u1ea3n l\u00fd chi ti\u00eau\">H\u01b0\u1edbng d\u1eabn m\u1ed9t v\u00ed d\u1ee5 v\u1ec1 qu\u1ea3n l\u00fd chi ti\u00eau<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Dung_Excel_quan_ly_chi_tieu_co_hieu_qua_khong\"><\/span><strong>D\u00f9ng Excel qu\u1ea3n l\u00fd chi ti\u00eau c\u00f3 hi\u1ec7u qu\u1ea3 kh\u00f4ng?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Excel v\u1edbi kh\u1ea3 n\u0103ng t\u00ednh to\u00e1n v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ea1nh m\u1ebd, c\u00f9ng v\u1edbi t\u00ednh linh ho\u1ea1t trong t\u00f9y ch\u1ec9nh, mang l\u1ea1i nhi\u1ec1u l\u1ee3i \u00edch v\u01b0\u1ee3t tr\u1ed9i trong vi\u1ec7c qu\u1ea3n l\u00fd chi ti\u00eau:<\/p>\n\n\n\n<ul>\n<li><strong>Theo d\u00f5i chi ti\u00eau chi ti\u1ebft:<\/strong> Excel cho ph\u00e9p b\u1ea1n ghi l\u1ea1i t\u1eebng kho\u1ea3n chi ti\u00eau m\u1ed9t c\u00e1ch chi ti\u1ebft, t\u1eeb nh\u1eefng kho\u1ea3n l\u1edbn nh\u01b0 ti\u1ec1n nh\u00e0, h\u1ecdc ph\u00ed \u0111\u1ebfn nh\u1eefng kho\u1ea3n nh\u1ecf nh\u01b0 ti\u1ec1n \u0103n, cafe. B\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o c\u00e1c c\u1ed9t \u0111\u1ec3 ghi ng\u00e0y th\u00e1ng, n\u1ed9i dung chi ti\u00eau, s\u1ed1 ti\u1ec1n, v\u00e0 th\u1eadm ch\u00ed l\u00e0 ph\u00e2n lo\u1ea1i chi ti\u00eau (\u0103n u\u1ed1ng, \u0111i l\u1ea1i, gi\u1ea3i tr\u00ed,&#8230;). \u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea1n c\u00f3 c\u00e1i nh\u00ecn t\u1ed5ng quan v\u00e0 ch\u00ednh x\u00e1c v\u1ec1 d\u00f2ng ti\u1ec1n c\u1ee7a m\u00ecnh.<\/li>\n\n\n\n<li><strong>Ph\u00e2n lo\u1ea1i chi ti\u00eau:<\/strong> V\u1edbi c\u00e1c c\u00f4ng th\u1ee9c v\u00e0 bi\u1ec3u \u0111\u1ed3 trong Excel, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng ph\u00e2n t\u00edch th\u00f3i quen chi ti\u00eau c\u1ee7a m\u00ecnh. B\u1ea1n s\u1ebd th\u1ea5y r\u00f5 m\u00ecnh \u0111ang chi ti\u00eau nhi\u1ec1u nh\u1ea5t cho m\u1ee5c n\u00e0o, kho\u1ea3n n\u00e0o c\u00f3 th\u1ec3 c\u1eaft gi\u1ea3m, v\u00e0 t\u1eeb \u0111\u00f3 \u0111\u01b0a ra c\u00e1c quy\u1ebft \u0111\u1ecbnh t\u00e0i ch\u00ednh th\u00f4ng minh h\u01a1n.<\/li>\n\n\n\n<li><strong>L\u1eadp ng\u00e2n s\u00e1ch v\u00e0 b\u00e1m s\u00e1t m\u1ee5c ti\u00eau:<\/strong> Excel gi\u00fap b\u1ea1n l\u1eadp k\u1ebf ho\u1ea1ch ng\u00e2n s\u00e1ch m\u1ed9t c\u00e1ch khoa h\u1ecdc v\u00e0 chi ti\u1ebft. B\u1ea1n c\u00f3 th\u1ec3 \u0111\u1eb7t m\u1ee5c ti\u00eau ti\u1ebft ki\u1ec7m, ph\u00e2n b\u1ed5 ng\u00e2n s\u00e1ch cho t\u1eebng m\u1ee5c chi ti\u00eau, v\u00e0 theo d\u00f5i xem m\u00ecnh c\u00f3 \u0111ang \u0111i \u0111\u00fang h\u01b0\u1edbng hay kh\u00f4ng.<\/li>\n\n\n\n<li><strong>Ph\u00e2n t\u00edch v\u00e0 t\u1ed1i \u01b0u chi ti\u00eau:<\/strong> Excel c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng tr\u00ean nhi\u1ec1u thi\u1ebft b\u1ecb kh\u00e1c nhau, t\u1eeb m\u00e1y t\u00ednh \u0111\u1ebfn \u0111i\u1ec7n tho\u1ea1i, gi\u00fap b\u1ea1n qu\u1ea3n l\u00fd chi ti\u00eau m\u1ecdi l\u00fac m\u1ecdi n\u01a1i. B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh b\u1ea3ng t\u00ednh theo \u00fd mu\u1ed1n, th\u00eam c\u00e1c c\u1ed9t, c\u00f4ng th\u1ee9c, bi\u1ec3u \u0111\u1ed3 \u0111\u1ec3 ph\u00f9 h\u1ee3p v\u1edbi nhu c\u1ea7u c\u00e1 nh\u00e2n.<\/li>\n\n\n\n<li><strong>Ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c:<\/strong> Thay v\u00ec ghi ch\u00e9p th\u1ee7 c\u00f4ng, Excel t\u1ef1 \u0111\u1ed9ng t\u00ednh to\u00e1n v\u00e0 t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u, gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 tr\u00e1nh sai s\u00f3t.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-5.png\" alt=\"Excel mang \u0111\u1ebfn ph\u01b0\u01a1ng ph\u00e1p qu\u1ea3n l\u00fd chi ti\u00eau cho sinh vi\u00ean v\u00f4 c\u00f9ng hi\u1ec7u qu\u1ea3\" class=\"wp-image-95162\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-5.png 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-5-300x188.png 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-5-768x480.png 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-5-150x94.png 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-5-600x375.png 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-5-696x435.png 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-5-672x420.png 672w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Excel mang \u0111\u1ebfn ph\u01b0\u01a1ng ph\u00e1p qu\u1ea3n l\u00fd chi ti\u00eau cho sinh vi\u00ean v\u00f4 c\u00f9ng hi\u1ec7u qu\u1ea3<\/figcaption><\/figure>\n\n\n\n<p>T\u00f3m l\u1ea1i, Excel kh\u00f4ng ch\u1ec9 gi\u00fap sinh vi\u00ean qu\u1ea3n l\u00fd chi ti\u00eau hi\u1ec7u qu\u1ea3 m\u00e0 c\u00f2n trang b\u1ecb nh\u1eefng k\u1ef9 n\u0103ng t\u00e0i ch\u00ednh quan tr\u1ecdng, l\u00e0m n\u1ec1n t\u1ea3ng v\u1eefng ch\u1eafc cho t\u01b0\u01a1ng lai.<\/p>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Cac_ham_Excel_thuong_dung_de_quan_ly_chi_tieu\"><\/span><strong>C\u00e1c h\u00e0m Excel th\u01b0\u1eddng d\u00f9ng \u0111\u1ec3 qu\u1ea3n l\u00fd chi ti\u00eau<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u0110\u1ec3 t\u1eadn d\u1ee5ng t\u1ed1i \u0111a s\u1ee9c m\u1ea1nh c\u1ee7a Excel trong qu\u1ea3n l\u00fd t\u00e0i ch\u00ednh, b\u1ea1n c\u1ea7n n\u1eafm v\u1eefng m\u1ed9t s\u1ed1 h\u00e0m c\u01a1 b\u1ea3n sau:<\/p>\n\n\n\n<p><strong>1. SUM:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>C\u00f4ng d\u1ee5ng:<\/strong> T\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u.<\/li>\n\n\n\n<li><strong>V\u00ed d\u1ee5:<\/strong> =SUM(C2:C10) s\u1ebd t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb t\u1eeb \u00f4 C2 \u0111\u1ebfn C10. H\u00e0m n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch \u0111\u1ec3 t\u00ednh t\u1ed5ng chi ti\u00eau theo t\u1eebng h\u1ea1ng m\u1ee5c ho\u1eb7c trong m\u1ed9t kho\u1ea3ng th\u1eddi gian nh\u1ea5t \u0111\u1ecbnh.<\/li>\n<\/ul>\n\n\n\n<p><strong>2. AVERAGE:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>C\u00f4ng d\u1ee5ng:<\/strong> T\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ee7a m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u.<\/li>\n\n\n\n<li><strong>V\u00ed d\u1ee5:<\/strong> =AVERAGE(D2:D10) s\u1ebd t\u00ednh chi ti\u00eau trung b\u00ecnh h\u00e0ng ng\u00e0y\/tu\u1ea7n\/th\u00e1ng, gi\u00fap b\u1ea1n nh\u1eadn bi\u1ebft xu h\u01b0\u1edbng chi ti\u00eau c\u1ee7a m\u00ecnh.<\/li>\n<\/ul>\n\n\n\n<p><strong>3. MAX &amp; MIN:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>C\u00f4ng d\u1ee5ng:<\/strong> T\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t v\u00e0 nh\u1ecf nh\u1ea5t trong m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u.<\/li>\n\n\n\n<li><strong>V\u00ed d\u1ee5:<\/strong> =MAX(E2:E10) v\u00e0 =MIN(E2:E10) s\u1ebd cho bi\u1ebft kho\u1ea3n chi ti\u00eau l\u1edbn nh\u1ea5t v\u00e0 nh\u1ecf nh\u1ea5t trong th\u00e1ng, gi\u00fap b\u1ea1n nh\u1eadn ra nh\u1eefng kho\u1ea3n chi ti\u00eau b\u1ea5t th\u01b0\u1eddng.<\/li>\n<\/ul>\n\n\n\n<p><strong>4. COUNT &amp; COUNTA:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>C\u00f4ng d\u1ee5ng:<\/strong> \u0110\u1ebfm s\u1ed1 \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb s\u1ed1 (COUNT) ho\u1eb7c b\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb n\u00e0o (COUNTA) trong m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u.<\/li>\n\n\n\n<li><strong>V\u00ed d\u1ee5:<\/strong> =COUNT(F2:F10) s\u1ebd cho bi\u1ebft s\u1ed1 l\u1ea7n b\u1ea1n \u0111i \u0103n ngo\u00e0i trong th\u00e1ng, t\u1eeb \u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3 \u0111i\u1ec1u ch\u1ec9nh th\u00f3i quen chi ti\u00eau cho ph\u00f9 h\u1ee3p.<\/li>\n<\/ul>\n\n\n\n<p><strong>5. IF:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>C\u00f4ng d\u1ee5ng:<\/strong> Ki\u1ec3m tra m\u1ed9t \u0111i\u1ec1u ki\u1ec7n v\u00e0 tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb n\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang, m\u1ed9t gi\u00e1 tr\u1ecb kh\u00e1c n\u1ebfu \u0111i\u1ec1u ki\u1ec7n sai.<\/li>\n\n\n\n<li><strong>V\u00ed d\u1ee5:<\/strong> =IF(G2&gt;1000000,&#8221;V\u01b0\u1ee3t ng\u00e2n s\u00e1ch&#8221;,&#8221;Trong ng\u00e2n s\u00e1ch&#8221;) s\u1ebd ki\u1ec3m tra xem chi ti\u00eau trong \u00f4 G2 c\u00f3 v\u01b0\u1ee3t qu\u00e1 1 tri\u1ec7u \u0111\u1ed3ng hay kh\u00f4ng, v\u00e0 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 t\u01b0\u01a1ng \u1ee9ng. H\u00e0m IF gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng theo d\u00f5i vi\u1ec7c tu\u00e2n th\u1ee7 ng\u00e2n s\u00e1ch.<\/li>\n<\/ul>\n\n\n\n<p><strong>6. SUMIF v\u00e0 COUNTIF:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>C\u00f4ng d\u1ee5ng:<\/strong> T\u00ednh t\u1ed5ng ho\u1eb7c \u0111\u1ebfm s\u1ed1 \u00f4 th\u1ecfa m\u00e3n m\u1ed9t \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3 trong m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u.<\/li>\n\n\n\n<li><strong>V\u00ed d\u1ee5:<\/strong> =SUMIF(B2:B10,&#8221;\u0102n u\u1ed1ng&#8221;,C2:C10) s\u1ebd t\u00ednh t\u1ed5ng chi ti\u00eau cho \u0103n u\u1ed1ng, gi\u00fap b\u1ea1n bi\u1ebft m\u00ecnh \u0111\u00e3 d\u00e0nh bao nhi\u00eau ti\u1ec1n cho nhu c\u1ea7u n\u00e0y.<\/li>\n<\/ul>\n\n\n\n<p><strong>7. VLOOKUP:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>C\u00f4ng d\u1ee5ng:<\/strong> T\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb trong c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a m\u1ed9t b\u1ea3ng v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng t\u1eeb m\u1ed9t c\u1ed9t kh\u00e1c trong c\u00f9ng h\u00e0ng \u0111\u00f3.<\/li>\n\n\n\n<li><strong>V\u00ed d\u1ee5:<\/strong> =VLOOKUP(H2, A2:C10, 3, FALSE) s\u1ebd t\u00ecm ki\u1ebfm t\u00ean m\u1ed9t m\u1eb7t h\u00e0ng trong c\u1ed9t A v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 c\u1ee7a n\u00f3 t\u1eeb c\u1ed9t C, \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n t\u00ean h\u1ea1ng m\u1ee5c chi ti\u00eau d\u1ef1a tr\u00ean m\u00e3 s\u1ed1 ho\u1eb7c t\u1eeb kh\u00f3a, gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 gi\u1ea3m thi\u1ec3u sai s\u00f3t khi nh\u1eadp li\u1ec7u.<\/li>\n<\/ul>\n\n\n\n<p><strong>8. Pivot Table:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>C\u00f4ng d\u1ee5ng:<\/strong> T\u1ed5ng h\u1ee3p v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u theo nhi\u1ec1u ti\u00eau ch\u00ed kh\u00e1c nhau.<\/li>\n\n\n\n<li><strong>V\u00ed d\u1ee5:<\/strong> B\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng Pivot Table \u0111\u1ec3 xem t\u1ed5ng chi ti\u00eau theo t\u1eebng h\u1ea1ng m\u1ee5c, theo tu\u1ea7n, theo th\u00e1ng ho\u1eb7c theo b\u1ea5t k\u1ef3 ti\u00eau ch\u00ed n\u00e0o b\u1ea1n mu\u1ed1n. Pivot Table cung c\u1ea5p c\u00e1i nh\u00ecn t\u1ed5ng quan v\u00e0 chi ti\u1ebft v\u1ec1 t\u00ecnh h\u00ecnh t\u00e0i ch\u00ednh c\u1ee7a b\u1ea1n.<\/li>\n<\/ul>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Huong_dan_mot_vi_du_ve_quan_ly_chi_tieu\"><\/span><strong>H\u01b0\u1edbng d\u1eabn m\u1ed9t v\u00ed d\u1ee5 v\u1ec1 qu\u1ea3n l\u00fd chi ti\u00eau<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><strong>B\u01b0\u1edbc 1: T\u1ea1o b\u1ea3ng t\u00ednh chi ti\u00eau<\/strong><\/p>\n\n\n\n<p>M\u1edf Excel v\u00e0 t\u1ea1o m\u1ed9t b\u1ea3ng t\u00ednh m\u1edbi. B\u1ea1n c\u00f3 th\u1ec3 \u0111\u1eb7t t\u00ean cho c\u00e1c c\u1ed9t nh\u01b0 sau:<\/p>\n\n\n\n<ul>\n<li>Ng\u00e0y th\u00e1ng<\/li>\n\n\n\n<li>M\u00f4 t\u1ea3<\/li>\n\n\n\n<li>Lo\u1ea1i chi ph\u00ed &#8211; Ph\u00e2n lo\u1ea1i (v\u00ed d\u1ee5: \u0102n u\u1ed1ng, \u0110i l\u1ea1i, H\u1ecdc t\u1eadp, Gi\u1ea3i tr\u00ed, &#8230;)<\/li>\n\n\n\n<li>S\u1ed1 ti\u1ec1n chi<\/li>\n<\/ul>\n\n\n\n<p><strong>B\u01b0\u1edbc 2: Nh\u1eadp d\u1eef li\u1ec7u chi ti\u00eau<\/strong><\/p>\n\n\n\n<p>B\u1eaft \u0111\u1ea7u ghi l\u1ea1i c\u00e1c kho\u1ea3n chi ti\u00eau c\u1ee7a b\u1ea1n v\u00e0o b\u1ea3ng t\u00ednh. \u0110\u1ea3m b\u1ea3o nh\u1eadp \u0111\u1ea7y \u0111\u1ee7 th\u00f4ng tin cho m\u1ed7i kho\u1ea3n chi ti\u00eau, bao g\u1ed3m ng\u00e0y th\u00e1ng, n\u1ed9i dung, s\u1ed1 ti\u1ec1n v\u00e0 ph\u00e2n lo\u1ea1i.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-2.png\" alt=\"L\u1eadp b\u1ea3ng th\u1ed1ng k\u00ea c\u00e1c kho\u1ea3n chi ti\u00eau trong th\u00e1ng\" class=\"wp-image-95163\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-2.png 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-2-300x188.png 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-2-768x480.png 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-2-150x94.png 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-2-600x375.png 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-2-696x435.png 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-2-672x420.png 672w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">L\u1eadp b\u1ea3ng th\u1ed1ng k\u00ea c\u00e1c chi ti\u00eau trong th\u00e1ng<\/figcaption><\/figure>\n\n\n\n<p><strong>B\u01b0\u1edbc 3: S\u1eed d\u1ee5ng c\u00e1c h\u00e0m \u0111\u1ec3 ph\u00e2n t\u00edch<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>T\u00ednh t\u1ed5ng chi ti\u00eau trong th\u00e1ng:<\/strong>\n<ul>\n<li>\u1ede cu\u1ed1i b\u1ea3ng t\u00ednh, h\u00e3y l\u1eadp m\u1ed9t b\u1ea3ng t\u00ednh m\u1edbi v\u00e0 t\u1ea1o m\u1ed9t h\u00e0ng m\u1edbi \u0111\u1eb7t t\u00ean l\u00e0 &#8220;T\u1ed5ng chi ti\u00eau trong th\u00e1ng&#8221;.<\/li>\n\n\n\n<li>Trong c\u1ed9t k\u1ebf b\u00ean, nh\u1eadp c\u00f4ng th\u1ee9c =SUM(D2:D20) (gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 d\u1eef li\u1ec7u chi ti\u00eau t\u1eeb h\u00e0ng 2 \u0111\u1ebfn h\u00e0ng 20). S\u1ed1 ti\u1ec1n t\u1ed5ng chi ti\u00eau trong th\u00e1ng c\u1ee7a b\u1ea1n s\u1ebd hi\u1ec7n ra.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-9.png\" alt=\"D\u00f9ng h\u00e0m SUM \u0111\u1ec3 t\u00ednh t\u1ed5ng chi ti\u00eau trong th\u00e1ng\" class=\"wp-image-95164\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-9.png 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-9-300x188.png 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-9-768x480.png 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-9-150x94.png 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-9-600x375.png 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-9-696x435.png 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-9-672x420.png 672w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">D\u00f9ng h\u00e0m SUM \u0111\u1ec3 t\u00ednh t\u1ed5ng chi ti\u00eau trong th\u00e1ng<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>T\u00ednh chi ti\u00eau trung b\u00ecnh trong th\u00e1ng<\/strong>:\n<ul>\n<li>T\u1ea1o m\u1ed9t h\u00e0ng m\u1edbi trong b\u1ea3ng t\u00ednh v\u00e0 \u0111\u1eb7t t\u00ean &#8220;Chi ti\u00eau trung b\u00ecnh&#8221;<\/li>\n\n\n\n<li>Trong c\u1ed9t k\u1ebf b\u00ean, nh\u1eadp c\u00f4ng th\u1ee9c =AVERAGE(D2:D20), k\u1ebft qu\u1ea3 v\u1ec1 m\u1ee9c chi ti\u00eau trung b\u00ecnh trong th\u00e1ng s\u1ebd hi\u1ec7n ra.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-4.png\" alt=\"D\u00f9ng h\u00e0m AVERAGE \u0111\u1ec3 t\u00ednh chi ti\u00eau trung b\u00ecnh trong th\u00e1ng\" class=\"wp-image-95165\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-4.png 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-4-300x188.png 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-4-768x480.png 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-4-150x94.png 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-4-600x375.png 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-4-696x435.png 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-4-672x420.png 672w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">D\u00f9ng h\u00e0m AVERAGE \u0111\u1ec3 t\u00ednh chi ti\u00eau trung b\u00ecnh trong th\u00e1ng<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>T\u00ednh t\u1ed5ng chi ti\u00eau theo ph\u00e2n lo\u1ea1i:<\/strong>\n\n\n\n\n<ul>\n<li>T\u1ea1o m\u1ed9t h\u00e0ng m\u1edbi v\u00e0 \u0111\u1eb7t t\u00ean l\u00e0 &#8220;T\u1ed5ng chi ti\u00eau cho \u0103n u\u1ed1ng&#8221; (b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn theo ti\u00eau ch\u00ed mong mu\u1ed1n)<\/li>\n<\/ul>\n\n\n\n<ul>\n<li>Trong c\u1ed9t k\u1ebf b\u00ean, s\u1eed d\u1ee5ng h\u00e0m SUMIF \u0111\u1ec3 t\u00ednh t\u1ed5ng chi ti\u00eau cho t\u1eebng ph\u00e2n lo\u1ea1i. V\u00ed d\u1ee5, \u0111\u1ec3 t\u00ednh t\u1ed5ng chi ti\u00eau cho m\u1ee5c &#8220;\u0102n u\u1ed1ng&#8221;, nh\u1eadp c\u00f4ng th\u1ee9c =SUMIF(C2:C20,&#8221;\u0102n u\u1ed1ng&#8221;,D2:D20). L\u1eadp t\u1ee9c k\u1ebft qu\u1ea3 v\u1ec1 t\u1ed5ng m\u1ee9c chi ti\u00eau cho \u0103n u\u1ed1ng s\u1ebd hi\u1ec7n ra.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-1.png\" alt=\"D\u00f9ng h\u00e0m SUMIF \u0111\u1ec3 t\u00ednh t\u1ed5ng chi ti\u00eau theo ph\u00e2n ti\u00eau ch\u00ed\" class=\"wp-image-95166\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-1.png 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-1-300x188.png 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-1-768x480.png 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-1-150x94.png 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-1-600x375.png 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-1-696x435.png 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-1-672x420.png 672w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">D\u00f9ng h\u00e0m SUMIF \u0111\u1ec3 t\u00ednh t\u1ed5ng chi ti\u00eau theo ph\u00e2n ti\u00eau ch\u00ed<\/figcaption><\/figure>\n\n\n\n<p><strong>B\u01b0\u1edbc 4: T\u1ea1o bi\u1ec3u \u0111\u1ed3<\/strong><\/p>\n\n\n\n<ul>\n<li>Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb tr\u00ean bi\u1ec3u \u0111\u1ed3 (v\u00ed d\u1ee5: t\u1ed5ng chi ti\u00eau theo th\u00e1ng ho\u1eb7c theo ph\u00e2n lo\u1ea1i).<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-8.png\" alt=\"Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n l\u1eadp bi\u1ec3u \u0111\u1ed3\" class=\"wp-image-95167\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-8.png 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-8-300x188.png 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-8-768x480.png 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-8-150x94.png 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-8-600x375.png 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-8-696x435.png 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-8-672x420.png 672w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n l\u1eadp bi\u1ec3u \u0111\u1ed3<\/figcaption><\/figure>\n\n\n\n<ul>\n<li>V\u00e0o tab &#8220;Insert&#8221; v\u00e0 ch\u1ecdn lo\u1ea1i bi\u1ec3u \u0111\u1ed3 ph\u00f9 h\u1ee3p (v\u00ed d\u1ee5: bi\u1ec3u \u0111\u1ed3 c\u1ed9t ho\u1eb7c bi\u1ec3u \u0111\u1ed3 tr\u00f2n).<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-6.png\" alt=\"Ch\u1ecdn d\u1ea1ng bi\u1ec3u \u0111\u1ed3 ph\u00f9 h\u1ee3p \u0111\u1ec3 th\u1ed1ng k\u00ea\" class=\"wp-image-95168\" width=\"1026\" height=\"641\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-6.png 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-6-300x188.png 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-6-768x480.png 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-6-150x94.png 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-6-600x375.png 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-6-696x435.png 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-6-672x420.png 672w\" sizes=\"(max-width: 1026px) 100vw, 1026px\" title=\"\"><figcaption class=\"wp-element-caption\">Ch\u1ecdn d\u1ea1ng bi\u1ec3u \u0111\u1ed3 ph\u00f9 h\u1ee3p <\/figcaption><\/figure>\n\n\n\n<ul>\n<li>T\u00f9y ch\u1ec9nh bi\u1ec3u \u0111\u1ed3 theo \u00fd mu\u1ed1n (v\u00ed d\u1ee5: th\u00eam ti\u00eau \u0111\u1ec1, ch\u00fa th\u00edch, thay \u0111\u1ed5i m\u00e0u s\u1eafc).<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-7.png\" alt=\"T\u00f9y ch\u1ec9nh ch\u00fa th\u00edch, m\u00e0u s\u1eafc v\u00e0 t\u00ean g\u1ecdi c\u1ee7a bi\u1ec3u \u0111\u1ed3 theo mong mu\u1ed1n\" class=\"wp-image-95169\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-7.png 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-7-300x188.png 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-7-768x480.png 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-7-150x94.png 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-7-600x375.png 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-7-696x435.png 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/cam-nang-su-dung-excel-quan-ly-chi-tieu-cho-sinh-vien-7-672x420.png 672w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">T\u00f9y ch\u1ec9nh ch\u00fa th\u00edch, m\u00e0u s\u1eafc v\u00e0 t\u00ean g\u1ecdi c\u1ee7a bi\u1ec3u \u0111\u1ed3 theo mong mu\u1ed1n<\/figcaption><\/figure>\n\n\n\n<p>B\u00ean c\u1ea1nh c\u00e1c h\u00e0m v\u00e0 v\u00ed d\u1ee5 k\u1ec3 tr\u00ean, Excel c\u00f2n c\u00f3 r\u1ea5t nhi\u1ec1u c\u00f4ng c\u1ee5 kh\u00e1c nh\u01b0 Conditional Formatting, Data Validation&#8230; gi\u00fap b\u1ea1n qu\u1ea3n l\u00fd chi ti\u00eau m\u1ed9t c\u00e1ch tr\u1ef1c quan v\u00e0 hi\u1ec7u qu\u1ea3. H\u00e3y d\u00e0nh th\u1eddi gian kh\u00e1m ph\u00e1 v\u00e0 tr\u1ea3i nghi\u1ec7m, b\u1ea1n s\u1ebd th\u1ea5y Excel kh\u00f4ng ch\u1ec9 l\u00e0 c\u00f4ng c\u1ee5 b\u1ea3ng t\u00ednh m\u00e0 c\u00f2n l\u00e0 ng\u01b0\u1eddi b\u1ea1n \u0111\u1ed3ng h\u00e0nh \u0111\u00e1ng tin c\u1eady tr\u00ean con \u0111\u01b0\u1eddng chinh ph\u1ee5c m\u1ee5c ti\u00eau t\u00e0i ch\u00ednh c\u1ee7a b\u1ea1n.<\/p>\n\n\n\n<p>C\u00e1c b\u1ea1n c\u0169ng \u0111\u1eebng qu\u00ean Phong V\u0169 \u0111ang c\u00f3 ch\u01b0\u01a1ng tr\u00ecnh khuy\u1ebfn m\u00e3i h\u1ea5p d\u1eabn d\u00e0nh cho c\u00e1c b\u1ea1n h\u1ecdc sinh, sinh vi\u00ean v\u00e0 nh\u1eefng ng\u01b0\u1eddi \u0111ang t\u00ecm ki\u1ebfm laptop m\u1edbi. T\u1eeb nay \u0111\u1ebfn 31\/10, khi mua b\u1ea5t k\u1ef3 <a href=\"https:\/\/phongvu.vn\/c\/laptop-hp\" target=\"_blank\" rel=\"noreferrer noopener\">laptop HP<\/a> n\u00e0o t\u1ea1i Phong V\u0169, b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c qu\u00e0 t\u1eb7ng gi\u00e1 tr\u1ecb l\u00ean \u0111\u1ebfn 1.78 tri\u1ec7u \u0111\u1ed3ng. <\/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\/mua-laptop-hp-nhan-uu-dai-microsoft-office-01-1024x499.jpg\" alt=\"Mua laptop HP t\u1ea1i Phong V\u0169 - Nh\u1eadn ngay b\u1ed9 qu\u00e0 t\u1eb7ng Microsoft Office l\u00ean \u0111\u1ebfn 1.78 tri\u1ec7u\" class=\"wp-image-94690\" width=\"1024\" height=\"499\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/mua-laptop-hp-nhan-uu-dai-microsoft-office-01-1024x499.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/mua-laptop-hp-nhan-uu-dai-microsoft-office-01-300x146.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/mua-laptop-hp-nhan-uu-dai-microsoft-office-01-768x374.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/mua-laptop-hp-nhan-uu-dai-microsoft-office-01-150x73.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/mua-laptop-hp-nhan-uu-dai-microsoft-office-01-600x293.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/mua-laptop-hp-nhan-uu-dai-microsoft-office-01-696x339.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/mua-laptop-hp-nhan-uu-dai-microsoft-office-01-861x420.jpg 861w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/mua-laptop-hp-nhan-uu-dai-microsoft-office-01-533x261.jpg 533w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/08\/mua-laptop-hp-nhan-uu-dai-microsoft-office-01.jpg 1046w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Ch\u01b0\u01a1ng tr\u00ecnh &#8220;Mua laptop HP t\u1ea1i Phong V\u0169 \u2013 Nh\u1eadn ngay b\u1ed9 qu\u00e0 t\u1eb7ng Microsoft Office&#8221;<\/figcaption><\/figure>\n\n\n\n<p>C\u1ee5 th\u1ec3, v\u1edbi laptop HP c\u1ea5u h\u00ecnh CPU i3\/i5\/r3\/r5, b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c t\u1eb7ng Balo Phong V\u0169. N\u1ebfu ch\u1ecdn mua laptop HP c\u1ea5u h\u00ecnh cao h\u01a1n v\u1edbi CPU i7\/r7\/i9\/r9, b\u1ea1n s\u1ebd nh\u1eadn th\u00eam ph\u1ea7n m\u1ec1m Microsoft 365 Personal b\u1ea3n quy\u1ec1n 12 th\u00e1ng. \u0110\u1eebng b\u1ecf l\u1ee1 c\u01a1 h\u1ed9i n\u00e0y \u0111\u1ec3 s\u1edf h\u1eefu laptop HP v\u1edbi \u01b0u \u0111\u00e3i h\u1ea5p d\u1eabn t\u1eeb Phong V\u0169!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Th\u1eddi sinh vi\u00ean th\u01b0\u1eddng g\u1eafn li\u1ec1n v\u1edbi nh\u1eefng tr\u1ea3i nghi\u1ec7m \u0111\u1ea7u \u0111\u1eddi v\u1ec1 t\u1ef1 l\u1eadp t\u00e0i ch\u00ednh. Gi\u1eefa h\u1ecdc ph\u00ed, chi ph\u00ed sinh ho\u1ea1t, s\u00e1ch v\u1edf v\u00e0 \u0111i l\u1ea1i, vi\u1ec7c c\u00e2n \u0111\u1ed1i chi ti\u00eau tr\u1edf th\u00e0nh m\u1ed9t b\u00e0i to\u00e1n kh\u00f4ng h\u1ec1 \u0111\u01a1n gi\u1ea3n. Trong b\u1ed1i c\u1ea3nh \u0111\u00f3, Excel s\u1ebd l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1eefu hi\u1ec7u [&hellip;]<\/p>\n","protected":false},"author":19,"featured_media":94917,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[74,1029,24],"tags":[],"_links":{"self":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/94915"}],"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\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/comments?post=94915"}],"version-history":[{"count":4,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/94915\/revisions"}],"predecessor-version":[{"id":95170,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/94915\/revisions\/95170"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media\/94917"}],"wp:attachment":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media?parent=94915"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/categories?post=94915"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/tags?post=94915"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}