{"id":59403,"date":"2022-06-27T11:34:39","date_gmt":"2022-06-27T04:34:39","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=59403"},"modified":"2022-06-28T16:44:16","modified_gmt":"2022-06-28T09:44:16","slug":"thu-thuat-excel-cho-dan-van-phong","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/thu-thuat-excel-cho-dan-van-phong\/","title":{"rendered":"M\u00e1ch b\u1ea1n th\u1ee7 thu\u1eadt Excel cho d\u00e2n v\u0103n ph\u00f2ng (P1)"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"59403\" class=\"elementor elementor-59403\" data-elementor-settings=\"[]\">\n\t\t\t\t\t\t<div class=\"elementor-inner\">\n\t\t\t\t\t\t\t<div class=\"elementor-section-wrap\">\n\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b6218ed elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b6218ed\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b2ee491\" data-id=\"b2ee491\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3394c66 elementor-widget elementor-widget-text-editor\" data-id=\"3394c66\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t\t<p>B\u1ea1n l\u00e0 sinh vi\u00ean hay d\u00e2n v\u0103n ph\u00f2ng, th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng Excel \u0111\u1ec3 l\u00e0m vi\u1ec7c. D\u01b0\u1edbi \u0111\u00e2y<a href=\"https:\/\/ben.com.vn\/tin-tuc\" target=\"_blank\" rel=\"noopener\"> BenComputer<\/a> m\u1ea1ch b\u1ea1n m\u1ed9t v\u00e0i th\u1ee7 thu\u1eadt, m\u1eb9o \u0111\u1ec3 b\u1ea1n thao t\u00e1c nhanh h\u01a1n, n\u00e2ng cao hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c nh\u00e9.<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9243562 elementor-widget elementor-widget-heading\" data-id=\"9243562\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">1. Lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p trong Excel<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3d15b57 elementor-widget elementor-widget-text-editor\" data-id=\"3d15b57\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t\t<p>Khi \u0111\u1ed3ng nghi\u1ec7p g\u1eedi cho b\u1ea1n 1 file d\u1eef li\u1ec7u m\u00e0 c\u00f3 c\u00e1c d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p m\u00e0 b\u1ea1n mu\u1ed1n x\u00f3a \u0111i. File ng\u1eafn c\u00f3 th\u1ec3 x\u00f3a th\u1ee7 c\u00f4ng t\u1eebng d\u00f2ng nh\u01b0ng file c\u00f3 h\u00e0ng ngh\u00ecn d\u00f2ng th\u00ec b\u1ea1n kh\u00f4ng th\u1ec3 ng\u1ed3i x\u00f3a nh\u01b0 v\u1eady \u0111\u01b0\u1ee3c.\u00a0<\/p><p><span style=\"color: var( --e-global-color-text ); display: inline !important;\">V\u00ed d\u1ee5 m\u00e3 nh\u00e2n vi\u00ean b\u1ecb tr\u00f9ng (ID). B\u1ea1n h\u00e3y l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau:<\/span><\/p><p><b>B\u01b0\u1edbc 1:<\/b> Ctrl + A , b\u00f4i \u0111en t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u. N\u00ean nh\u1edb b\u00ean ngo\u00e0i b\u1ea3ng d\u1eef li\u1ec7u kh\u00f4ng c\u00f3 n\u1ed9i dung kh\u00e1c.<\/p><p><b>B\u01b0\u1edbc 2: <\/b>Tr\u00ean thanh c\u00f4ng c\u1ee5 ch\u1ecdn <b>Data -&gt; Remove Duplicates.<\/b><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-859d13c elementor-widget elementor-widget-image\" data-id=\"859d13c\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"489\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-1-1024x489.jpg\" class=\"attachment-large size-large\" alt=\"X\u00f3a b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p trong file d\u1eef li\u1ec7u Excel\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-1-1024x489.jpg 1024w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-1-300x143.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-1-768x367.jpg 768w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-1-750x359.jpg 750w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-1-1140x545.jpg 1140w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-1.jpg 1364w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-07ecd99 elementor-widget elementor-widget-text-editor\" data-id=\"07ecd99\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t\t<p><b>B\u01b0\u1edbc 3:<\/b> C\u1eeda s\u1ed5 m\u1edbi hi\u1ec7n ra, t\u1ea1i \u0111\u00e2y b\u1ea1n ch\u1ecdn<b> Unselect All -&gt; ch\u1ecdn c\u1ed9t ID -&gt; OK<\/b><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a01490d elementor-widget elementor-widget-image\" data-id=\"a01490d\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"491\" height=\"306\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-2.jpg\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-2.jpg 491w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-2-300x187.jpg 300w\" sizes=\"auto, (max-width: 491px) 100vw, 491px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-42807b4 elementor-widget elementor-widget-heading\" data-id=\"42807b4\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">2. T\u1ef1 \u0111\u1ed9ng k\u1ebb vi\u1ec1n \u00f4 khi th\u00eam d\u1eef li\u1ec7u trong Excel<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9181667 elementor-widget elementor-widget-text-editor\" data-id=\"9181667\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t\t<p>B\u1ea3ng d\u1eef li\u1ec7u c\u00f3 vi\u1ec1n \u00f4, m\u1ed7i l\u1ea7n b\u1ea1n th\u00eam d\u00f2ng d\u1eef li\u1ec7u l\u1ea1i ph\u1ea3i \u0111\u1ecbnh d\u1ea1ng l\u1ea1i b\u1ea3ng, k\u1ebb th\u00eam vi\u1ec1n \u00f4. D\u01b0\u1edbi \u0111\u00e2y m\u1eb9o gi\u00fap b\u1ea1n t\u1ef1 \u0111\u1ed9ng k\u1ebb vi\u1ec1n \u00f4 khi th\u00eam d\u00f2ng d\u1eef li\u1ec7u m\u1edbi.<\/p><p><b>B\u01b0\u1edbc 1:<\/b> B\u00f4i \u0111en b\u1ea3ng d\u1eef li\u1ec7u, k\u00e9o xu\u1ed1ng c\u1ea3 c\u00e1c d\u00f2ng b\u00ean d\u01b0\u1edbi nh\u01b0 h\u00ecnh \u1ea3nh b\u00ean d\u01b0\u1edbi<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6721244 elementor-widget elementor-widget-image\" data-id=\"6721244\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"980\" height=\"747\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-3.jpg\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-3.jpg 980w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-3-300x229.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-3-768x585.jpg 768w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-3-750x572.jpg 750w\" sizes=\"auto, (max-width: 980px) 100vw, 980px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ed4735f elementor-widget elementor-widget-text-editor\" data-id=\"ed4735f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t\t<p><b>B\u01b0\u1edbc 2:<\/b> Ch\u1ecdn <strong>Conditional Formatting -&gt; New rule&#8230; -&gt; Use a formula to determine which cells to format.<\/strong><\/p><p><b>B\u01b0\u1edbc 3:<\/b> T\u1ea1o c\u00e2u \u0111i\u1ec1u ki\u1ec7n v\u00e0o \u00f4 text<\/p><p>Ch\u1ecdn d\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u. Ti\u1ebfp theo b\u1ea5m F4 2 l\u1ea7n \u0111\u1ec3 lo\u1ea1i b\u1ecf d\u1ea5u $ th\u1ee9 2.<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c91b6fd elementor-widget elementor-widget-image\" data-id=\"c91b6fd\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"948\" height=\"622\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-4.jpg\" class=\"attachment-large size-large\" alt=\"Ch\u1ecdn \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng. Ti\u1ebfp t\u1ee5c b\u1ea5m F4 2 l\u1ea7n. V\u00e0 so s\u00e1nh n\u00f3 v\u1edbi r\u1ed7ng.\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-4.jpg 948w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-4-300x197.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-4-768x504.jpg 768w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-4-750x492.jpg 750w\" sizes=\"auto, (max-width: 948px) 100vw, 948px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Ch\u1ecdn \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng. Ti\u1ebfp t\u1ee5c b\u1ea5m F4 2 l\u1ea7n. V\u00e0 so s\u00e1nh n\u00f3 v\u1edbi r\u1ed7ng. C\u00e2u \u0111i\u1ec1u ki\u1ec7n sau khi t\u1ea1o xong c\u1ee7a t\u00f4i (=$A2<>\"\")\nSau khi t\u1ea1o c\u00e2u \u0111i\u1ec1u ki\u1ec7n xong ch\u1ecdn Format...<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3f273ec elementor-widget elementor-widget-image\" data-id=\"3f273ec\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"884\" height=\"594\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-5.jpg\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-5.jpg 884w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-5-300x202.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-5-768x516.jpg 768w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-5-750x504.jpg 750w\" sizes=\"auto, (max-width: 884px) 100vw, 884px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Sau khi ch\u1ecdn Format...->Border -> Ouline -> OK<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c3138d5 elementor-widget elementor-widget-text-editor\" data-id=\"c3138d5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t\t<p>V\u1eady l\u00e0 xong, b\u1ea1n s\u1ebd kh\u00f4ng c\u00f2n m\u1ea5t th\u1eddi gian k\u1ebb vi\u1ec1n \u00f4 n\u1eefa.<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7251159 elementor-widget elementor-widget-heading\" data-id=\"7251159\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">3. C\u1ed1 \u0111\u1ecbnh ti\u00eau \u0111\u1ec1 c\u1ed9t, h\u00e0ng trong Excel<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e3955aa elementor-widget elementor-widget-text-editor\" data-id=\"e3955aa\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t\t<p>C\u1ed1 \u0111\u1ecbnh ti\u00eau \u0111\u1ec1 gi\u00fap b\u1ea1n xem \u0111\u01b0\u1ee3c ti\u00eau \u0111\u1ec1 k\u1ec3 c\u1ea3 khi b\u1ea1n cu\u1ed9n trang ti\u00eau \u0111\u1ec1 s\u1ebd v\u1eabn lu\u00f4n \u1edf \u0111\u1ea7u, b\u1ea1n v\u1eabn lu\u00f4n nh\u00ecn th\u1ea5y t\u00ean c\u1ed9t, t\u00ean h\u00e0ng \u0111\u00f3 c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 g\u00ec.<\/p><p><b>B\u01b0\u1edbc 1: <\/b>B\u00f4i \u0111en c\u1ed9t, h\u00e0ng c\u1ea7n c\u1ed1 \u0111\u1ecbnh.<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-72aa3c0 elementor-widget elementor-widget-image\" data-id=\"72aa3c0\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"345\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-6-1024x345.jpg\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-6-1024x345.jpg 1024w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-6-300x101.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-6-768x259.jpg 768w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-6-750x253.jpg 750w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-6.jpg 1077w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c7e0a77 elementor-widget elementor-widget-text-editor\" data-id=\"c7e0a77\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t\t<p><b>B\u01b0\u1edbc 2: <\/b>\u0110\u1eb7t con tr\u1ecf chu\u1ed9t \u1edf g\u00f3c ch\u00e9o<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f1f53f7 elementor-widget elementor-widget-image\" data-id=\"f1f53f7\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"286\" height=\"66\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-8.jpg\" class=\"attachment-full size-full\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b8fd3af elementor-widget elementor-widget-image\" data-id=\"b8fd3af\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"569\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-7-1024x569.jpg\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-7-1024x569.jpg 1024w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-7-300x167.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-7-768x427.jpg 768w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-7-750x417.jpg 750w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-7.jpg 1085w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">B\u01b0\u1edbc 3: Ch\u1ecdn View -> Freeze Panes -> Unfreeze Panes<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-826b141 elementor-widget elementor-widget-text-editor\" data-id=\"826b141\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t\t<p>B\u1ea1n h\u00e3y th\u1eed v\u00e0 xem th\u00e0nh qu\u1ea3 nh\u00e9. R\u1ea5t thu\u1eadn ti\u1ec7n khi file d\u1eef li\u1ec7u Excel c\u00f3 h\u00e0ng ngh\u00ecn d\u00f2ng, nhi\u1ec1u c\u1ed9t.<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b51f6de elementor-widget elementor-widget-heading\" data-id=\"b51f6de\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">4. T\u1ea1o d\u00f2ng k\u1ebb ch\u1ea5m trong Excel<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-aabe236 elementor-widget elementor-widget-text-editor\" data-id=\"aabe236\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t\t<p>T\u1ef1 \u0111\u1ed9ng t\u1ea1o d\u00f2ng k\u1ebb ch\u1ea5m<\/p><p><b>B\u01b0\u1edbc 1: <\/b>B\u00f4i \u0111en d\u00f2ng c\u1ea7n th\u00eam d\u1ea5u ch\u1ea5m<\/p><p><b>B\u01b0\u1edbc 2:<\/b> Chu\u1ed9t ph\u1ea3i v\u00e0o ch\u00ednh \u00f4 b\u00f4i \u0111en ch\u1ecdn <b>Format Cells&#8230;-&gt; Custom<\/b>. V\u00e0 nh\u1eadp l\u1ec7nh sau v\u00e0o \u00f4 Type: <strong>@*.<\/strong><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8d8a96f elementor-widget elementor-widget-image\" data-id=\"8d8a96f\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"795\" height=\"654\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-9.jpg\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-9.jpg 795w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-9-300x247.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-9-768x632.jpg 768w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-9-750x617.jpg 750w\" sizes=\"auto, (max-width: 795px) 100vw, 795px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5f039f4 elementor-widget elementor-widget-text-editor\" data-id=\"5f039f4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t\t<p>Cu\u1ed1i c\u00f9ng l\u00e0 b\u1ea5m OK \u0111\u1ec3 \u00e1p d\u1ee5ng v\u00e0 xem k\u1ebft qu\u1ea3 nh\u00e9.<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a0a4068 elementor-widget elementor-widget-heading\" data-id=\"a0a4068\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">5. \u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 b\u1eb1ng h\u00e0m AGGREGATE trong Excel<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a17e66a elementor-widget elementor-widget-text-editor\" data-id=\"a17e66a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t\t<p>C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 b\u1eb1ng h\u00e0m <b>AGGREGATE<\/b>, gi\u00fap b\u1ea1n trong c\u1ea3 vi\u1ec7c l\u1ecdc d\u1eef li\u1ec7u, s\u1eafp x\u1ebfp d\u1eef li\u1ec7u, x\u00f3a h\u00e0ng m\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 kh\u00f4ng b\u1ecb nh\u1ea3y lung tung, s\u1ed1 th\u1ee9 t\u1ef1 v\u1eabn l\u1ea7n l\u01b0\u1ee3t t\u1eeb 1 \u0111\u1ebfn n.<\/p><p><b>B\u01b0\u1edbc 1:<\/b> Ch\u1ecdn \u00f4 c\u1ea7n \u0111\u00e1nh s\u1ed1 v\u00e0 nh\u1eadp l\u1ec7nh theo c\u00fa ph\u00e1p:<\/p><p><strong>=AGGREGATE(function_num; options; array; [k])<\/strong><\/p><p><b>Trong \u0111\u00f3:<\/b><\/p><p><b>function_num = 3 <\/b>(3 l\u00e0 \u1edf \u0111\u00e2y ch\u00fang ta d\u00f9ng h\u00e0m counta)<\/p><p><b>options = 3<\/b> (\u1edf \u0111\u00e2y l\u00e0 b\u1ecf d\u00f2ng \u1ea9n, gi\u00e1 tr\u1ecb l\u1ed7i,&#8230;)<\/p><p><b>array: <\/b>ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn ngay d\u00f2ng b\u00ean c\u1ea1nh. V\u00e0 nh\u1eadp d\u1ea5u<b> : <\/b>Ti\u1ebfp t\u1ee5c b\u00f4i \u0111en gi\u00e1 tr\u1ecb array \u0111\u1ea7u ti\u00ean <b>b\u1ea5m F4<\/b> \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh gi\u00e1 tr\u1ecb.<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a96218a elementor-widget elementor-widget-image\" data-id=\"a96218a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"589\" height=\"267\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-10.jpg\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-10.jpg 589w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-10-300x136.jpg 300w\" sizes=\"auto, (max-width: 589px) 100vw, 589px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">B\u00f4i \u0111en gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean array l\u00e0 C3 r\u1ed3i b\u1ea5m F4 \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh gi\u00e1 tr\u1ecb<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-933e035 elementor-widget elementor-widget-image\" data-id=\"933e035\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"907\" height=\"308\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-11.jpg\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-11.jpg 907w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-11-300x102.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-11-768x261.jpg 768w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/excel-11-750x255.jpg 750w\" sizes=\"auto, (max-width: 907px) 100vw, 907px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Cu\u1ed1i c\u00f9ng ta \u0111\u01b0\u1ee3c l\u1ec7nh nh\u01b0 tr\u00ean v\u00e0 Enter<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5a25603 elementor-widget elementor-widget-text-editor\" data-id=\"5a25603\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t\t<p><strong>B\u01b0\u1edbc 2:<\/strong> Di con tr\u1ecf chu\u1ed9t ra m\u00e9p \u00f4 \u0111\u1ea7u ti\u00ean b\u1ea1n v\u1eeba thao t\u00e1c \u0111\u1ebfn khi n\u00e0o th\u1ea5y d\u1ea5u <strong>+<\/strong> V\u00e0 k\u00e9o xu\u1ed1ng c\u00e1c d\u00f2ng \u0111\u1ebfn khi n\u00e0o b\u1ea1n mu\u1ed1n d\u1eebng \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1.<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8c70fab elementor-widget elementor-widget-text-editor\" data-id=\"8c70fab\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t\t<p>Gi\u1edd \u0111\u00e2y b\u1ea1n c\u00f3 th\u1ec3 x\u00f3a d\u00f2ng d\u1eef li\u1ec7u, l\u1ecdc d\u1eef li\u1ec7u m\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 l\u00e0 tu\u1ea7n t\u1ef1, kh\u00f4ng b\u1ecb l\u1ed9n x\u1ed9n.<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-12ef4d0 elementor-widget elementor-widget-text-editor\" data-id=\"12ef4d0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t\t<p>M\u1ed7i phi\u00ean b\u1ea3n <b>Excel<\/b>, m\u1ed7i m\u00e1y t\u00ednh c\u00f3 th\u1ec3 s\u1ebd th\u00e1o t\u00e1c kh\u00e1c nhau m\u1ed9t ch\u00fat. N\u1ebfu c\u00f3 g\u00ec th\u1eafc m\u1eafc ho\u1eb7c g\u1eb7p v\u1ea5n \u0111\u1ec1 kh\u00e1c trong c\u00e1c thao t\u00e1c tr\u00ean b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ec3 l\u1ea1i b\u00ecnh lu\u1eadn, BenComputer s\u1ebd h\u1ed7 tr\u1ee3.<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>B\u1ea1n l\u00e0 sinh vi\u00ean hay d\u00e2n v\u0103n ph\u00f2ng, th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng Excel \u0111\u1ec3 l\u00e0m vi\u1ec7c. D\u01b0\u1edbi \u0111\u00e2y BenComputer m\u1ea1ch b\u1ea1n m\u1ed9t v\u00e0i th\u1ee7 thu\u1eadt, m\u1eb9o \u0111\u1ec3 b\u1ea1n thao t\u00e1c nhanh h\u01a1n, n\u00e2ng cao hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c nh\u00e9. 1. Lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p trong Excel Khi \u0111\u1ed3ng nghi\u1ec7p g\u1eedi cho b\u1ea1n 1 [&hellip;]<\/p>\n","protected":false},"author":35,"featured_media":31856,"comment_status":"open","ping_status":"closed","sticky":false,"template":"elementor_theme","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[10,11],"tags":[],"class_list":["post-59403","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat-phan-mem","category-thu-thuat-van-phong"],"_links":{"self":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/59403","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/35"}],"replies":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=59403"}],"version-history":[{"count":45,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/59403\/revisions"}],"predecessor-version":[{"id":60611,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/59403\/revisions\/60611"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/31856"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=59403"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=59403"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=59403"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}