{"id":5265,"date":"2024-12-10T07:04:30","date_gmt":"2024-12-10T07:04:30","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/10\/ham-lay-ten-worksheet-dang-lam-viec\/"},"modified":"2024-12-10T07:04:30","modified_gmt":"2024-12-10T07:04:30","slug":"ham-lay-ten-worksheet-dang-lam-viec","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/10\/ham-lay-ten-worksheet-dang-lam-viec\/","title":{"rendered":"H\u00e0m l\u1ea5y t\u00ean Worksheet \u0111ang l\u00e0m vi\u1ec7c"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>C\u00f3 bao gi\u1edd b\u1ea1n g\u1eb7p ph\u1ea3i v\u1ea5n\u00a0\u0111\u1ec1 n\u00e0y: \u201cl\u00e0m c\u00e1ch n\u00e0o l\u1ea5y t\u00ean\u00a0Worksheet (hay c\u00f2n g\u1ecdi l\u00e0 Sheet)\u00a0\u0111ang\u00a0 l\u00e0m vi\u1ec7c?\u201d.\u00a0Vi\u1ec7c n\u00e0y th\u00ec c\u00f3 t\u00e1c d\u1ee5ng g\u00ec? H\u00e3y c\u00f9ng H\u1ecdc\u00a0Excel Online t\u00ecm hi\u1ec3u ch\u1ee7\u00a0\u0111\u1ec1 n\u00e0y nh\u00e9:<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6757e7fe1f500\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/ham-lay-ten-worksheet-dang-lam-viec.html#1_Muc_dich_ung_dung\" title=\"1. M\u1ee5c\u00a0\u0111\u00edch,\u00a0\u1ee9ng d\u1ee5ng\">1. M\u1ee5c\u00a0\u0111\u00edch,\u00a0\u1ee9ng d\u1ee5ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/ham-lay-ten-worksheet-dang-lam-viec.html#2_Ham_lay_ten_workbook_va_tach_ten_Sheet\" title=\"2. H\u00e0m l\u1ea5y t\u00ean\u00a0workbook v\u00e0 t\u00e1ch t\u00ean Sheet\">2. H\u00e0m l\u1ea5y t\u00ean\u00a0workbook v\u00e0 t\u00e1ch t\u00ean Sheet<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ham-lay-ten-worksheet-dang-lam-viec.html#3_Tach_Ten_Sheet_bang_ham_MID_ket_hop_ham_CELL_FIND\" title=\"3. T\u00e1ch T\u00ean Sheet b\u1eb1ng h\u00e0m MID k\u1ebft h\u1ee3p h\u00e0m CELL, FIND\">3. T\u00e1ch T\u00ean Sheet b\u1eb1ng h\u00e0m MID k\u1ebft h\u1ee3p h\u00e0m CELL, FIND<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/ham-lay-ten-worksheet-dang-lam-viec.html#4_Su_dung_ham_INDEX_voi_Name_de_xac_dinh_ten_Sheet\" title=\"4. S\u1eed d\u1ee5ng h\u00e0m INDEX v\u1edbi Name \u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh t\u00ean Sheet\">4. S\u1eed d\u1ee5ng h\u00e0m INDEX v\u1edbi Name \u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh t\u00ean Sheet<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"1_Muc_dich_ung_dung\"><\/span>1. M\u1ee5c\u00a0\u0111\u00edch,\u00a0\u1ee9ng d\u1ee5ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Khi\u00a0workbook c\u1ee7a b\u1ea1n\u00a0\u0111ang l\u00e0m vi\u1ec7c c\u00f3 ch\u1ee9a r\u1ea5t nhi\u1ec1u sheet, vi\u1ec7c di chuy\u1ec3n t\u1edbi c\u00e1c sheet m\u1ea5t nhi\u1ec1u th\u1eddi gian. B\u1ea1n mu\u1ed1n t\u00ecm c\u00e1ch\u00a0\u0111\u1ec3 t\u1ea1o li\u00ean k\u1ebft\u00a0\u0111i t\u1edbi t\u1eebng\u00a0sheet\u00a0m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng =&gt; B\u1ea1n c\u1ea7n ph\u1ea3i l\u1ea5y\u00a0\u0111\u01b0\u1ee3c t\u00ean c\u00e1c Sheet\u00a0\u0111\u1ec3 t\u1ea1o li\u00ean k\u1ebft t\u1edbi c\u00e1c sheet\u00a0\u0111\u00f3.<\/p>\n<p>Khi b\u1ea1n c\u00f3 nhi\u1ec1u sheet\u00a0\u0111\u1ec3 theo d\u00f5i c\u00f4ng n\u1ee3 c\u1ee7a t\u1eebng kh\u00e1ch h\u00e0ng. V\u00e0 b\u1ea1n mu\u1ed1n trong 1 b\u00e1o c\u00e1o c\u00f3 th\u1ec3 ch\u1ecdn t\u00ean kh\u00e1ch h\u00e0ng t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi Sheet\u00a0\u0111\u00f3 l\u00e0 c\u00f3 th\u1ec3 ra\u00a0\u0111\u01b0\u1ee3c b\u00e1o c\u00e1o t\u1ed5ng qu\u00e1t c\u00f4ng n\u1ee3 =&gt; B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 l\u00e0m\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111i\u1ec1u n\u00e0y b\u1eb1ng c\u00e1ch b\u1eaft\u00a0\u0111\u1ea7u v\u1edbi vi\u1ec7c l\u1ea5y t\u00ean c\u00e1c sheet kh\u00e1ch h\u00e0ng.<\/p>\n<p>Tr\u00ean\u00a0\u0111\u00e2y l\u00e0 hai trong s\u1ed1\u00a0r\u1ea5t nhi\u1ec1u m\u1ee5c\u00a0\u0111\u00edch m\u00e0 ch\u00fang ta c\u1ea7n th\u1ef1c hi\u1ec7n trong th\u1ef1c t\u1ebf. V\u1eady ch\u00fang ta h\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch l\u00e0m ngay n\u00e0o.<\/p>\n<p>B\u1eadt m\u00ed v\u1edbi b\u1ea1n l\u00e0 ch\u00fang ta c\u00f3 t\u1edbi 2 c\u00e1ch l\u00e0m\u00a0\u0111i\u1ec1u n\u00e0y.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Ham_lay_ten_workbook_va_tach_ten_Sheet\"><\/span>2. H\u00e0m l\u1ea5y t\u00ean\u00a0workbook v\u00e0 t\u00e1ch t\u00ean Sheet<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong\u00a0Excel c\u00f3 s\u1eb5n 1 h\u00e0m gi\u00fap ch\u00fang ta l\u1ea5y\u00a0\u0111\u01b0\u1ee3c t\u00ean\u00a0Workbook l\u00e0:<\/p>\n<blockquote>\n<p>=CELL(\u201cfilename\u201d,A1)<\/p>\n<\/blockquote>\n<p>\u0110\u00e2y l\u00e0 c\u00e2u l\u1ec7nh m\u1eb7c\u00a0\u0111\u1ecbnh, ch\u1eef FileName\u00a0\u0111\u1eb7t trong d\u1ea5u nh\u00e1y k\u00e9p.<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-179.gif\" title=\"vba101_92019-nho-179\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-450.gif\" title=\"ex101_92019-nho-450\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>* <em><strong>L\u01b0u\u00a0\u00fd<\/strong><\/em>:\u00a0N\u1ebfu\u00a0Workbook ch\u01b0a\u00a0\u0111\u01b0\u1ee3c l\u01b0u t\u1ea1i\u00a0\u0111\u00e2u th\u00ec h\u00e0m Cell\u00a0\u1edf tr\u00ean kh\u00f4ng ra k\u1ebft qu\u1ea3<\/p>\n<p>V\u00ed d\u1ee5:<\/p>\n<p>T\u1ea1i\u00a0\u00f4 A1, ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m Cell\u00a0\u0111\u1ec3 l\u1ea5y t\u00ean\u00a0workbook\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14647\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-get_sheet_name-01.png\" width=\"586\" height=\"119\" title=\"heo-get_sheet_name-01\"><\/p>\n<p>Nh\u01b0 v\u1eady c\u00f3 th\u1ec3 th\u1ea5y trong ph\u1ea7n T\u00ean\u00a0Workbook v\u1eeba l\u1ea5y\u00a0\u0111\u01b0\u1ee3c\u00a0\u1edf tr\u00ean lu\u00f4n c\u00f3\u00a03 th\u00e0nh ph\u1ea7n:<\/p>\n<ul>\n<li>C:UsersQuanDesktop l\u00e0 \u0111\u01b0\u1eddng d\u1eabn n\u01a1i l\u01b0u\u00a0workbook, c\u1ee5 th\u1ec3 l\u00e0 l\u01b0u t\u1ea1i Desktop<\/li>\n<li>[Test.xlsx] : t\u00ean\u00a0workbook\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c vu\u00f4ng (T\u00ean file v\u00e0 lo\u1ea1i file .xlsx)<\/li>\n<li>Sheet1 : T\u00ean Sheet\u00a0\u0111ang ho\u1ea1t\u00a0\u0111\u1ed9ng (ch\u1ee9a v\u1ecb tr\u00ed A1 trong c\u00f4ng th\u1ee9c Cell)<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta c\u00f3 th\u1ec3:<\/p>\n<ul>\n<li>Mu\u1ed1n l\u1ea5y t\u00ean Sheet n\u00e0o th\u00ec\u00a0\u0111\u1eb7t tham chi\u1ebfu c\u1ee7a h\u00e0m CELL t\u1ea1i sheet\u00a0\u0111\u00f3,\u00a0\u00f4 b\u1ea5t k\u1ef3 (thay cho A1)<\/li>\n<li>T\u00e1ch ph\u1ea7n t\u00ean Sheet b\u1eb1ng c\u00e1ch l\u1ea5y to\u00e0n b\u1ed9 s\u1ed1 k\u00fd t\u1ef1 sau d\u1ea5u\u00a0] : tr\u01b0\u1edbc d\u1ea5u\u00a0] l\u00e0\u00a0\u0111\u01b0\u1eddng d\u1eabn v\u00e0 t\u00ean\u00a0workbook, sau d\u1ea5u\u00a0] l\u00e0 t\u00ean sheet<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"3_Tach_Ten_Sheet_bang_ham_MID_ket_hop_ham_CELL_FIND\"><\/span>3. T\u00e1ch T\u00ean Sheet b\u1eb1ng h\u00e0m MID k\u1ebft h\u1ee3p h\u00e0m CELL, FIND<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh v\u1ecb tr\u00ed d\u1ea5u\u00a0] trong k\u1ebft qu\u1ea3 t\u1ea1i\u00a0\u00f4 A1, ch\u00fang ta d\u00f9ng h\u00e0m FIND nh\u01b0 sau:<\/p>\n<blockquote>\n<p>FIND(\u201c]\u201d,A1)<\/p>\n<\/blockquote>\n<p>K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m Find s\u1ebd cho ra s\u1ed1 th\u1ec3 hi\u1ec7n v\u1ecb\u00a0 tr\u00ed k\u00fd t\u1ef1 d\u1ea5u\u00a0]<\/p>\n<p>Nh\u01b0 v\u1eady ph\u1ea7n sau d\u1ea5u\u00a0] s\u1ebd b\u1eaft\u00a0\u0111\u1ea7u\u00a0\u1edf v\u1ecb tr\u00ed FIND(\u201c]\u201d,A1)+1<\/p>\n<p>\u0110\u1ed9 d\u00e0i t\u1ed1i\u00a0\u0111a c\u1ee7a t\u00ean Sheet trong\u00a0Excel l\u00e0 255 k\u00fd t\u1ef1.<\/p>\n<p>K\u1ebft h\u1ee3p v\u1edbi h\u00e0m MID ta l\u1ea5y s\u1ed1 k\u00fd t\u1ef1 b\u00ean ph\u1ea3i d\u1ea5u\u00a0] nh\u01b0 sau:<\/p>\n<p>=MID(A1,FIND(\u201c]\u201d,A1)+1,255)<\/p>\n<ul>\n<li>A1 l\u00e0 h\u00e0m CELL(\u201cFileName\u201d,A1)<\/li>\n<li>FIND(\u201c]\u201d,A1)+1 l\u00e0 v\u1ecb tr\u00ed b\u1eaft\u00a0\u0111\u1ea7u\u00a0\u0111o\u1ea1n k\u00fd t\u1ef1 c\u1ea7n l\u1ea5y<\/li>\n<li>255 l\u00e0\u00a0\u0111\u1ed9 d\u00e0i c\u1ee7a\u00a0\u0111o\u1ea1n k\u00fd t\u1ef1 c\u1ea7n l\u1ea5y. N\u1ebfu\u00a0\u0111o\u1ea1n k\u00fd t\u1ef1 c\u1ea7n l\u1ea5y nh\u1ecf h\u01a1n 255 th\u00ec s\u1ebd ra b\u1eb1ng\u00a0\u0111\u1ed9 d\u00e0i\u00a0\u0111o\u1ea1n k\u00fd t\u1ef1\u00a0\u0111\u00f3.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14649\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-get_sheet_name-02.png\" width=\"492\" height=\"167\" title=\"heo-get_sheet_name-02\"><\/p>\n<p>N\u1ebfu l\u1ed3ng h\u00e0m CELL trong h\u00e0m MID v\u00e0\u00a0\u0111\u1eb7t c\u00f4ng th\u1ee9c n\u00e0y v\u00e0o duy nh\u1ea5t 1 v\u1ecb tr\u00ed th\u00ec ch\u00fang ta s\u1ebd c\u00f3 k\u1ebft qu\u1ea3 l\u00e0 T\u00ean Sheet<\/p>\n<blockquote>\n<p>=MID(CELL(\u201cfilename\u201d,A1),FIND(\u201c]\u201d,CELL(\u201cfilename\u201d,A1))+1,255)<\/p>\n<\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"4_Su_dung_ham_INDEX_voi_Name_de_xac_dinh_ten_Sheet\"><\/span>4. S\u1eed d\u1ee5ng h\u00e0m INDEX v\u1edbi Name \u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh t\u00ean Sheet<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ngo\u00e0i c\u00e1ch\u00a0\u0111\u00e3 gi\u1edbi thi\u1ec7u\u00a0\u1edf tr\u00ean, ch\u00fang ta c\u00f2n c\u00f3 1 c\u00e1ch n\u1eefa\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh t\u00ean c\u00e1c Sheet trong\u00a0Workbook b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Index v\u1edbi ch\u1ee9c n\u0103ng Define Name.<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: T\u1ea1o 1 t\u00ean\u00a0\u0111\u1ed9ng x\u00e1c\u00a0\u0111\u1ecbnh t\u00ean Sheet<\/p>\n<ul>\n<li>Trong tab <strong>Formulas<\/strong> ch\u1ecdn ch\u1ee9c n\u0103ng<strong> Define Name<\/strong><\/li>\n<li>Trong m\u1ee5c<strong> Name<\/strong>\u00a0\u0111\u1eb7t t\u00ean cho n\u1ed9i dung n\u00e0y l\u00e0 <strong>Ten_Sheet<\/strong><\/li>\n<li>Trong m\u1ee5c <strong>Refers to<\/strong> vi\u1ebft c\u00e2u l\u1ec7nh nh\u01b0 sau:<\/li>\n<\/ul>\n<blockquote>\n<p>=REPLACE(GET.WORKBOOK(1),1,FIND(\u201c]\u201d,GET.WORKBOOK(1)),\u201d\u201d)<\/p>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14650\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-get_sheet_name-03.png\" width=\"568\" height=\"461\" title=\"heo-get_sheet_name-03\"><\/p>\n<p>C\u00e2u l\u1ec7nh tr\u00ean t\u01b0\u01a1ng t\u1ef1 nh\u01b0 c\u00e2u l\u1ec7ch\u00a0\u1edf ph\u1ea7n tr\u00ean\u00a0\u0111\u00e3 m\u00f4 t\u1ea3, nh\u01b0ng n\u00f3 ch\u1ec9 th\u1ef1c hi\u1ec7n\u00a0\u0111\u01b0\u1ee3c khi\u00a0\u0111\u1eb7t trong 1 Name v\u00e0\u00a0\u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong 1 c\u00f4ng th\u1ee9c kh\u00e1c, c\u1ee5 th\u1ec3\u00a0\u1edf\u00a0\u0111\u00e2y l\u00e0 Index<\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: S\u1eed d\u1ee5ng h\u00e0m INDEX v\u1edbi Name v\u1eeba t\u1ea1o<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14651\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-get_sheet_name-04.png\" width=\"493\" height=\"464\" title=\"heo-get_sheet_name-04\"><\/p>\n<p>Trong h\u00ecnh tr\u00ean ch\u00fang ta ch\u00fa\u00a0\u00fd:<\/p>\n<p>\u0110\u1ec3 l\u1ea5y t\u00ean sheet n\u00e0o th\u00ec c\u1ea7n x\u00e1c\u00a0\u0111\u1ecbnh Sheet\u00a0\u0111\u00f3 l\u00e0 sheet th\u1ee9 m\u1ea5y<\/p>\n<p>N\u1ebfu Sheet ch\u01b0a c\u00f3 theo s\u1ed1 th\u1ee9 t\u1ef1 th\u00ec s\u1ebd b\u00e1o l\u1ed7i #REF (l\u1ed7i tham chi\u1ebfu do kh\u00f4ng c\u00f3 s\u1ed1 th\u1ee9 t\u1ef1 sheet t\u01b0\u01a1ng\u00a0\u1ee9ng)<\/p>\n<p>Nh\u01b0 v\u1eady v\u1edbi 2 c\u00e1ch tr\u00ean ch\u00fang ta c\u00f3 th\u1ec3 t\u00f9y theo t\u1eebng y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c\u00a0\u0111\u1ec3\u00a0\u1ee9ng d\u1ee5ng cho ph\u00f9 h\u1ee3p.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng H\u1ecdc\u00a0Excel Online!<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta c\u1ea7n\u00a0n\u1eafm v\u1eefng v\u00e0 s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m\u00a0v\u00e0\u00a0c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2mWmtzP\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\" target=\"_blank\">HocExcel.Online<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-179.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5266,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5265","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5265","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=5265"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5265\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5266"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5265"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5265"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5265"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}