{"id":1465,"date":"2024-12-02T05:12:03","date_gmt":"2024-12-02T05:12:03","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-lap-bao-cao-tong-hop-tu-dong-voi-excel-va-vba\/"},"modified":"2024-12-02T05:12:03","modified_gmt":"2024-12-02T05:12:03","slug":"huong-dan-cach-lap-bao-cao-tong-hop-tu-dong-voi-excel-va-vba","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-lap-bao-cao-tong-hop-tu-dong-voi-excel-va-vba\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p t\u1ef1 \u0111\u1ed9ng v\u1edbi Excel v\u00e0 VBA"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p><em>B\u1ea1n th\u01b0\u1eddng ph\u1ea3i <strong>l\u1eadp b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p tr\u00ean Excel<\/strong>? L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 b\u00e1o c\u00e1o t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt s\u1ed1 li\u1ec7u m\u1ed7i khi b\u1ea1n thay \u0111\u1ed5i th\u1eddi gian b\u00e1o c\u00e1o? Ch\u1eafc h\u1eb3n b\u1ea1n s\u1ebd r\u1ea5t vui khi bi\u1ebft r\u1eb1ng VBA s\u1ebd gi\u00fap b\u1ea1n th\u1ef1c hi\u1ec7n \u0111i\u1ec1u \u0111\u00f3 m\u1ed9t c\u00e1ch r\u1ea5t d\u1ec5 d\u00e0ng. <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd t\u00ecm hi\u1ec3u c\u0169ng b\u1ea1n nh\u00e9:<\/em><\/p>\n<p><strong>\u0110\u1ec1 b\u00e0i:\u00a0<\/strong>Cho b\u1ea3ng d\u1eef li\u1ec7u<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12700 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic01-1.png\" width=\"814\" height=\"705\" title=\"pic01-1\"><\/p>\n<p><strong>Y\u00eau c\u1ea7u: <\/strong><em>l\u1eadp b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p tr\u00ean Excel<\/em>\u00a0c\u00f3 th\u1ec3 t\u1ef1\u00a0\u0111\u1ed9ng c\u1eadp nh\u1eadt khi thay\u00a0\u0111\u1ed5i th\u1eddi gian c\u1ee7a b\u00e1o c\u00e1o<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12697 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic2-1.png\" width=\"630\" height=\"432\" title=\"pic2-1\"><\/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-674d41a2a293b\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/lap-bao-cao-tong-hop-tu-dong-voi-excel-va-vba.html#Cach_lam\" title=\"C\u00e1ch l\u00e0m:\">C\u00e1ch l\u00e0m:<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/lap-bao-cao-tong-hop-tu-dong-voi-excel-va-vba.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn:\">K\u1ebft lu\u1eadn:<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_lam\"><\/span><strong>C\u00e1ch l\u00e0m:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>B\u01b0\u1edbc 1<\/strong>:\u00a0\u0110\u1eb7t t\u00ean cho c\u00e1c c\u1ed9t d\u1eef li\u1ec7u trong b\u1ea3ng Data\u00a0\u0111\u1ec3 s\u1eed d\u1ee5ng trong c\u00f4ng th\u1ee9c cho d\u1ec5 th\u1ef1c hi\u1ec7n h\u01a1n<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12698 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic3-1.png\" width=\"954\" height=\"562\" title=\"pic3-1\"><\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-106.gif\" title=\"ex101_92019-nho-106\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-42.gif\" title=\"vba101_92019-nho-42\"><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-106.gif\" title=\"ex101_92019-nho-106\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>M\u1edf tab Formulas =&gt; Ch\u1ecdn Define Name v\u00e0\u00a0\u0111\u1eb7t t\u00ean cho c\u1ed9t Ng\u00e0y c\u1ee7a Sheet Data. L\u01b0u\u00a0\u00fd gi\u1edbi h\u1ea1n c\u1ee7a v\u00f9ng d\u1eef li\u1ec7u trong c\u1ed9t<\/li>\n<li>L\u00e0m t\u01b0\u01a1ng t\u1ef1 cho c\u00e1c c\u1ed9t kh\u00e1c. L\u01b0u\u00a0\u00fd\u00a0\u0111\u1ed9 r\u1ed9ng c\u1ee7a c\u00e1c v\u00f9ng T\u00ean trong c\u00f9ng 1 b\u1ea3ng ph\u1ea3i b\u1eb1ng nhau<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c\u00a0Excel \u0111\u1ec3 t\u00ednh d\u1eef li\u1ec7u v\u00e0o b\u1ea3ng <strong>B\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p<\/strong><\/p>\n<p>M\u1ed7i\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng trong B\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p\u00a0\u0111\u01b0\u1ee3c t\u00ednh d\u1ef1a theo c\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n:<\/p>\n<ul>\n<li>N\u1ed9i dung c\u1ea7n t\u00ednh: S\u1ed1 l\u01b0\u1ee3ng \/\u00a0\u0110\u01a1n gi\u00e1 \/ Th\u00e0nh ti\u1ec1n. X\u00e9t tr\u00ean n\u1ed9i dung S\u1ed1 l\u01b0\u1ee3ng tr\u01b0\u1edbc, c\u00e1c n\u1ed9i dung kh\u00e1c c\u00f3 th\u1ec3 l\u00e0m t\u01b0\u01a1ng t\u1ef1<\/li>\n<li>Th\u1eddi gian gi\u1edbi h\u1ea1n \u0111i\u1ec3m \u0111\u1ea7u: &gt;= T\u1eeb ng\u00e0y<\/li>\n<li>Th\u1eddi gian gi\u1edbi h\u1ea1n\u00a0\u0111i\u1ec3m cu\u1ed1i: &lt;=\u00a0\u0110\u1ebfn ng\u00e0y<\/li>\n<li>M\u00e3 h\u00e0ng h\u00f3a c\u1ea7n t\u00ednh: d\u1ef1a theo m\u1ed7i m\u00e3 h\u00e0ng trong b\u00e1o c\u00e1o.<\/li>\n<\/ul>\n<blockquote>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-ke-toan.html\">l\u01a1\u0301p h\u1ecdc Excel k\u1ebf to\u00e1n<\/a> t\u1ea1i H\u00e0 N\u1ed9i<\/p>\n<\/blockquote>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m SUMIFS\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 t\u00ednh t\u1ed5ng theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12701 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic4-1.png\" width=\"1288\" height=\"498\" title=\"pic4-1\"><\/p>\n<p><strong>C\u1ea5u tr\u00fac c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\/ham-sumif-tinh-tong-excel.html\">h\u00e0m SUMIFS<\/a> cho y\u00eau c\u1ea7u t\u00ednh S\u1ed1 l\u01b0\u1ee3ng:<\/strong><\/p>\n<ul>\n<li>V\u00f9ng c\u1ea7n t\u00ednh t\u1ed5ng = Data_Cot_SoLuong<\/li>\n<li>V\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n th\u1ee9 1 = Data_Cot_TenHang<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n th\u1ee9 1 trong v\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n th\u1ee9 1 = H\u00e0ng A (\u00f4 A5)<\/li>\n<li>V\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n th\u1ee9 2 = Data_Cot_Ngay<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n th\u1ee9 2 trong v\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n th\u1ee9 2 l\u00e0 &gt;= T\u1eeb ng\u00e0y, v\u00ec d\u1ea5u &gt;= l\u00e0 d\u1ea5u to\u00e1n t\u1eed n\u00ean ph\u1ea3i\u00a0\u0111\u1eb7t trong d\u1ea5u nh\u00e1y k\u00e9p<\/li>\n<li>V\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n th\u1ee9\u00a03 = Data_Cot_Ngay<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n th\u1ee9 2 trong v\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n th\u1ee9\u00a03 l\u00e0 &lt;=\u00a0\u0110\u1ebfn\u00a0ng\u00e0y, v\u00ec d\u1ea5u &lt;= l\u00e0 d\u1ea5u to\u00e1n t\u1eed n\u00ean ph\u1ea3i\u00a0\u0111\u1eb7t trong d\u1ea5u nh\u00e1y k\u00e9p<\/li>\n<\/ul>\n<p>T\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u1eady v\u1edbi y\u00eau c\u1ea7u t\u00ednh Th\u00e0nh ti\u1ec1n, ch\u00fang ta ch\u1ec9 c\u1ea7n thay V\u00f9ng c\u1ea7n t\u00ednh t\u1ed5ng trong h\u00e0m SUMIFS th\u00e0nh Data_Cot_ThanhTien<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12702 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic5-1.png\" width=\"1178\" height=\"507\" title=\"pic5-1\"><\/p>\n<p>V\u1edbi y\u00eau c\u1ea7u t\u00ednh\u00a0\u0111\u01a1n gi\u00e1, ch\u00fang ta t\u00ednh b\u1eb1ng c\u00e1ch l\u1ea5y Th\u00e0nh ti\u1ec1n \/ S\u1ed1 l\u01b0\u1ee3ng<\/p>\n<p>N\u1ebfu S\u1ed1 l\u01b0\u1ee3ng = 0 th\u00ec\u00a0\u0110\u01a1n gi\u00e1 s\u1ebd = 0 (v\u00ec m\u1eabu s\u1ed1 c\u1ee7a ph\u00e9p chia = 0 th\u00ec s\u1ebd c\u00f3 l\u1ed7i, n\u00ean c\u1ea7n bi\u1ec7n lu\u1eadn tr\u01b0\u1eddng h\u1ee3p n\u00e0y tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n ph\u00e9p chia<\/p>\n<blockquote>\n<p>C5 =\u00a0IF(B5=0,0,D5\/B5)<\/p>\n<\/blockquote>\n<p>=&gt; Filldown to\u00e0n b\u1ed9 c\u00f4ng th\u1ee9c\u00a0\u1edf c\u00e1c c\u1ed9t B, C, D t\u1eeb h\u00e0ng 5 xu\u1ed1ng h\u00e0ng 11 cho c\u00e1c H\u00e0ng h\u00f3a ti\u1ebfp theo<\/p>\n<p><strong>B\u01b0\u1edbc 3: L\u1ecdc d\u1eef li\u1ec7u trong b\u00e1o c\u00e1o<\/strong><\/p>\n<p>T\u1ea1i c\u1ed9t E, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c l\u1ecdc b\u1ecf nh\u1eefng n\u1ed9i dung c\u00f3 ph\u00e1t sinh = 0 (ho\u1eb7c kh\u00f4ng ph\u00e1t sinh) nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12703 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic6-1.png\" width=\"632\" height=\"498\" title=\"pic6-1\"><\/p>\n<blockquote>\n<p>E5 = IF(SUM(B5:D5)=0,\u201d\u201d,\u201dx\u201d)<\/p>\n<\/blockquote>\n<p>Filldown c\u00f4ng th\u1ee9c t\u1eeb E5 xu\u1ed1ng E11<\/p>\n<blockquote>\n<p>\u0110\u1eebng b\u1ecf l\u1ee1:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\">l\u1edbp h\u1ecdc word excel \u1edf H\u00e0 N\u1ed9i<\/a><\/p>\n<\/blockquote>\n<p><strong>B\u01b0\u1edbc 4<\/strong>: Thi\u1ebft l\u1eadp t\u1ef1\u00a0\u0111\u1ed9ng c\u1eadp nh\u1eadt b\u00e1o c\u00e1o trong VBA<\/p>\n<ul>\n<li>Record Macro cho thao t\u00e1c L\u1ecdc d\u1eef li\u1ec7u \u2013 L\u1ecdc b\u1ecf d\u00f2ng tr\u1ed1ng<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12704 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic7-1.png\" width=\"1168\" height=\"661\" title=\"pic7-1\"><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12705 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic8-1.png\" width=\"626\" height=\"624\" title=\"pic8-1\"><\/p>\n<ul>\n<li>M\u1edf c\u1eeda s\u1ed5 VBA (Alt + F11), thi\u1ebft l\u1eadp s\u1ef1 ki\u1ec7n Change trong sheet BCTH:\u00a0thay\u00a0\u0111\u1ed5i d\u1eef li\u1ec7u\u00a0\u1edf\u00a0\u00f4 B2 ho\u1eb7c\u00a0\u00f4 B3<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12706 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic9-1.png\" width=\"1182\" height=\"265\" title=\"pic9-1\"><\/p>\n<blockquote>\n<p>If Not Application.Intersect(Range(\u201cB2:B3\u201d), Range(Target.Address)) Is Nothing Then<\/p>\n<p>\u2026<\/p>\n<p>End\u00a0if<\/p>\n<\/blockquote>\n<p>D\u00f2ng code n\u00e0y\u00a0\u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0: N\u1ebfu c\u00f3 s\u1ef1 thay\u00a0\u0111\u1ed5i d\u1eef li\u1ec7u\u00a0\u1edf v\u00f9ng B2:B3 th\u00ec\u2026<\/p>\n<blockquote>\n<p>ActiveSheet.Range(\u201c$E$4:$E$11\u2033).AutoFilter Field:=1, Criteria1:=\u201d&lt;&gt;\u201d<\/p>\n<\/blockquote>\n<p>D\u00f2ng code n\u00e0y c\u00f3\u00a0\u0111\u01b0\u1ee3c t\u1eeb vi\u1ec7c Record Macro\u00a0\u1edf tr\u00ean,\u00a0\u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 l\u1ecdc b\u1ecf gi\u00e1 tr\u1ecb d\u00f2ng tr\u1ed1ng (blanks)\u00a0\u1edf c\u1ed9t L\u1ecdc (c\u1ed9t E,\u00a0\u00e1p d\u1ee5ng t\u1eeb d\u00f2ng 4\u00a0\u0111\u1ebfn d\u00f2ng 11)<\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta\u00a0\u0111\u00e3 ho\u00e0n th\u00e0nh c\u00f4ng vi\u1ec7c l\u1eadp b\u00e1o c\u00e1o t\u1ef1\u00a0\u0111\u1ed9ng c\u1eadp nh\u1eadt khi thay\u00a0\u0111\u1ed5i th\u1eddi gian b\u00e1o c\u00e1o.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Nh\u1eefng n\u1ed9i dung h\u1ecdc\u00a0\u0111\u01b0\u1ee3c qua b\u00e0i n\u00e0y l\u00e0:<\/p>\n<ul>\n<li>C\u00e1ch g\u00e1n t\u00ean cho v\u00f9ng d\u1eef li\u1ec7u, s\u1eed d\u1ee5ng t\u00ean trong c\u00f4ng th\u1ee9c\u00a0\u0111\u1ec3 l\u1eadp c\u00f4ng th\u1ee9c t\u1ed1t h\u01a1n<\/li>\n<li>C\u00e1ch l\u1eadp c\u00f4ng th\u1ee9c t\u1ed5ng h\u1ee3p k\u1ebft qu\u1ea3 theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n trong b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p (SUMIFS)<\/li>\n<li>C\u00e1ch l\u1ecdc b\u1ecf d\u1eef li\u1ec7u kh\u00f4ng c\u1ea7n thi\u1ebft\u00a0trong B\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p<\/li>\n<li>C\u00e1ch record macro\u00a0\u0111\u1ec3 l\u1ea5y code nhanh trong\u00a0excel vba<\/li>\n<li>C\u00e1ch\u00a0\u0111\u1ecdc hi\u1ec3u v\u00e0 vi\u1ebft code trong VBA<\/li>\n<li>Tr\u00ecnh t\u1ef1 logic c\u1ee7a vi\u1ec7c l\u1eadp b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p<\/li>\n<\/ul>\n<p>B\u1ea1n th\u1ea5y\u00a0\u0111\u00f3,\u00a0\u0111\u1ec3 n\u1eafm v\u1eefng k\u1ef9 thu\u1eadt <strong>l\u1eadp b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p trong\u00a0Excel<\/strong> c\u0169ng kh\u00f4ng qu\u00e1 kh\u00f3, v\u00e0 khi c\u00f3 th\u00eam VBA th\u00ec ch\u00fang ta ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 gi\u00fap b\u00e1o c\u00e1o tr\u1edf n\u00ean h\u1eefu d\u1ee5ng v\u00e0 th\u00e2n thi\u1ec7n h\u01a1n. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd t\u1ea1o ti\u1ec1n\u00a0\u0111\u1ec1 cho c\u00e1c b\u1ea1n l\u00e0m quen v\u1edbi VBA, c\u00e1ch h\u1ecdc VBA d\u1ec5 d\u00e0ng v\u00e0 l\u00e0m quen d\u1ea7n v\u1edbi k\u1ef9 thu\u1eadt VBA gi\u00fap t\u1ef1\u00a0\u0111\u1ed9ng h\u00f3a khi s\u1eed d\u1ee5ng\u00a0Excel.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/excel-vba\"><strong>VBA Excel<\/strong><\/a> gi\u00fap \u00edch\u00a0r\u1ea5t nhi\u1ec1u trong c\u00f4ng vi\u1ec7c: gi\u00fap b\u1ea1n t\u0103ng t\u1ed1c trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd tr\u00ean Excel, gi\u00fap l\u1eadp c\u00e1c b\u00e1o c\u00e1o t\u1ef1 \u0111\u1ed9ng, \u0111i\u1ec1u khi\u1ec3n c\u00e1c ch\u01b0\u01a1ng tr\u00ecnh kh\u00e1c nh\u01b0 Word, Power Point, Outlook\u2026 gi\u00fap bi\u1ebfn file Excel c\u1ee7a b\u1ea1n tr\u1edf th\u00e0nh 1 ph\u1ea7n m\u1ec1m chuy\u00ean nghi\u1ec7p\u2026<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 h\u1ecdc VBA m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, c\u00f3 h\u1ec7 th\u1ed1ng, b\u1ea1n h\u00e3y tham gia kho\u00e1 h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2OAUBOg\">VBA101 \u2013 VBA c\u01a1 b\u1ea3n d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/a>\u00a0c\u1ee7a h\u1ec7 th\u1ed1ng H\u1ecdc Excel Online. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. Chi ti\u1ebft xem t\u1ea1i:<\/p>\n<p>\u00a0<\/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<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-106.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1466,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1465","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\/1465","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=1465"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1465\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1466"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1465"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1465"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1465"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}