{"id":12510,"date":"2025-01-15T09:11:12","date_gmt":"2025-01-15T09:11:12","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/vba101-vba-co-ban-danh-cho-nguoi-moi-bat-dau\/"},"modified":"2025-01-15T09:11:12","modified_gmt":"2025-01-15T09:11:12","slug":"vba101-vba-co-ban-danh-cho-nguoi-moi-bat-dau","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/vba101-vba-co-ban-danh-cho-nguoi-moi-bat-dau\/","title":{"rendered":"VBA101 \u2013 VBA c\u01a1 b\u1ea3n d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-lap-trinh-vba-trong-excel\">Kho\u0301a ho\u0323c l\u00e2\u0323p tri\u0300nh VBA trong Excel<\/a>\u00a0d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u, d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi l\u00e0m quen v\u1edbi ng\u00f4n ng\u1eef l\u1eadp tr\u00ecnh VBA.<\/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-67877bad7d569\" 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\/vba101-landing.html#Thong_tin_khoa_hoc_lap_trinh_VBA_Excel\" title=\"Th\u00f4ng tin kho\u00e1 h\u1ecdc l\u00e2\u0323p tri\u0300nh VBA Excel\">Th\u00f4ng tin kho\u00e1 h\u1ecdc l\u00e2\u0323p tri\u0300nh VBA Excel<\/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\/vba101-landing.html#Gioi_thieu_chung\" title=\"Gi\u1edbi thi\u1ec7u chung\">Gi\u1edbi thi\u1ec7u chung<\/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\/vba101-landing.html#Doi_tuong_muc_tieu\" title=\"\u0110\u1ed1i t\u01b0\u1ee3ng m\u1ee5c ti\u00eau\">\u0110\u1ed1i t\u01b0\u1ee3ng m\u1ee5c ti\u00eau<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/vba101-landing.html#Hieu_qua_dau_ra_cua_khoa_hoc_VBA_trong_Excel\" title=\"Hi\u1ec7u qu\u1ea3 \u0111\u1ea7u ra cu\u0309a kho\u0301a ho\u0323c VBA trong Excel\">Hi\u1ec7u qu\u1ea3 \u0111\u1ea7u ra cu\u0309a kho\u0301a ho\u0323c VBA trong Excel<\/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-5\" href=\"https:\/\/blog.hocexcel.online\/vba101-landing.html#Giang_vien_Nguyen_Duc_Thanh\" title=\"Gi\u1ea3ng vi\u00ean:\u00a0Nguy\u1ec5n \u0110\u1ee9c Thanh\">Gi\u1ea3ng vi\u00ean:\u00a0Nguy\u1ec5n \u0110\u1ee9c Thanh<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/vba101-landing.html#Hoc_thu_12_bai_dau_tien\" title=\"H\u1ecdc th\u1eed\u00a012 b\u00e0i \u0111\u1ea7u ti\u00ean:\">H\u1ecdc th\u1eed\u00a012 b\u00e0i \u0111\u1ea7u ti\u00ean:<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/vba101-landing.html#Noi_dung_toan_bo_khoa_hoc\" title=\"N\u1ed9i dung to\u00e0n b\u1ed9 kho\u00e1 h\u1ecdc\">N\u1ed9i dung to\u00e0n b\u1ed9 kho\u00e1 h\u1ecdc<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/vba101-landing.html#Giao_dien_hoc\" title=\"Giao di\u1ec7n h\u1ecdc\">Giao di\u1ec7n h\u1ecdc<\/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-9\" href=\"https:\/\/blog.hocexcel.online\/vba101-landing.html#Cach_dang_ky_va_nhan_tai_khoan_hoc\" title=\"C\u00e1ch \u0111\u0103ng k\u00fd v\u00e0 nh\u1eadn t\u00e0i kho\u1ea3n h\u1ecdc\">C\u00e1ch \u0111\u0103ng k\u00fd v\u00e0 nh\u1eadn t\u00e0i kho\u1ea3n h\u1ecdc<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Thong_tin_khoa_hoc_lap_trinh_VBA_Excel\"><\/span>Th\u00f4ng tin kho\u00e1 h\u1ecdc l\u00e2\u0323p tri\u0300nh VBA Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<table style=\"height: 132px;width: 648px;border-color: #000000\">\n<tbody>\n<tr style=\"height: 25px\">\n<td style=\"width: 158.108px;height: 25px\">H\u00ecnh th\u1ee9c h\u1ecdc<\/td>\n<td style=\"width: 478.892px;height: 25px\">Online qua video, t\u01b0\u01a1ng t\u00e1c qua group Facebook<\/td>\n<\/tr>\n<tr style=\"height: 26px\">\n<td style=\"width: 158.108px;height: 26px\">S\u1ed1 b\u00e0i<\/td>\n<td style=\"width: 478.892px;height: 26px\"><del>106.<\/del>\u00a0C\u1eadp nh\u1eadt 14\/06\/2017:\u00a0<strong>117 b\u00e0i<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 26.6945px\">\n<td style=\"width: 158.108px;height: 26.6945px\">Th\u1eddi l\u01b0\u1ee3ng<\/td>\n<td style=\"width: 478.892px;height: 26.6945px\"><del>8 ti\u1ebfng<\/del>\u00a09 Ti\u1ebfng<\/td>\n<\/tr>\n<tr style=\"height: 26px\">\n<td style=\"width: 158.108px;height: 26px\">Tr\u00ecnh \u0111\u1ed9<\/td>\n<td style=\"width: 478.892px;height: 26px\">C\u01a1 b\u1ea3n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3><span class=\"ez-toc-section\" id=\"Gioi_thieu_chung\"><\/span>Gi\u1edbi thi\u1ec7u chung<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div id=\"rmjs-1\" class=\"summary readmore_collapse\" data-readmore=\"\">\n<div class=\"row no-margin\">\n<div class=\"title\">\n<p>V\u1edbi kho\u00e1 h\u1ecdc n\u00e0y, b\u1ea1n s\u1ebd d\u1ea1y Excel l\u00e0m vi\u1ec7c cho b\u1ea1n \u2026<\/p>\n<p>Excel \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t tr\u00ean h\u01a1n 750 tri\u1ec7u m\u00e1y t\u00ednh tr\u00ean th\u1ebf gi\u1edbi, ph\u1ea7n l\u1edbn ng\u01b0\u1eddi l\u00e0m vi\u1ec7c v\u1edbi Excel ch\u1ec9 bi\u1ebft nh\u1eefng ch\u1ee9c n\u0103ng v\u00e0 c\u00f4ng c\u1ee5 c\u01a1 b\u1ea3n.<\/p>\n<p>Trong kho\u00e1 h\u1ecdc n\u00e0y, b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c h\u1ecdc c\u00e1ch d\u1ea1y Excel l\u00e0m vi\u1ec7c cho b\u1ea1n, l\u00e0m khi b\u1ea1n mu\u1ed1n. T\u1eeb vi\u1ec7c t\u1ea1o ra nh\u1eefng b\u00e1o c\u00e1o l\u1eb7p \u0111i l\u1eb7p l\u1ea1i, \u0111\u1ecbnh d\u1ea1ng c\u00e1c b\u1ea3ng t\u00ednh, copy d\u1eef li\u1ec7u \u0111\u1ebfn nh\u1eefng c\u00f4ng vi\u1ec7c ph\u1ee9c t\u1ea1p h\u01a1n nh\u01b0 l\u00e0 t\u00e1ch, g\u1ed9p, t\u1ed5ng h\u1ee3p v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch ho\u00e0n to\u00e0n t\u1ef1 \u0111\u1ed9ng.<\/p>\n<p>H\u00e3y th\u1eed t\u01b0\u1edfng t\u01b0\u1ee3ng, b\u1ea1n l\u00e0m trong ng\u00e2n h\u00e0ng v\u1edbi h\u01a1n 100 chi nh\u00e1nh, m\u1ed7i chi nh\u00e1nh s\u1ebd g\u1eedi b\u00e1o c\u00e1o cho b\u1ea1n khi \u0111\u1ebfn k\u00ec, nhi\u1ec7m v\u1ee5 c\u1ee7a b\u1ea1n l\u00e0 t\u1ed5ng h\u1ee3p t\u1ea5t c\u1ea3 nh\u1eefng b\u00e1o c\u00e1o n\u00e0y v\u00e0o 1 sheet \u0111\u1ec3 c\u00f3 th\u1ec3 t\u1ea1o ra 1 b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p. Vi\u1ec7c copy b\u00e1o c\u00e1o b\u1eb1ng tay s\u1ebd t\u1ed1n c\u1ee7a b\u1ea1n \u00edt nh\u1ea5t 4 \u2013 8 ti\u1ebfng l\u00e0m vi\u1ec7c, trong khi VBA s\u1ebd gi\u00fap b\u1ea1n r\u00fat ng\u1eafn th\u1eddi gian n\u00e0y xu\u1ed1ng \u00edt h\u01a1n 1 ph\u00fat.<\/p>\n<p>VBA l\u00e0 m\u1ed9t ng\u00f4n ng\u1eef \u0111i k\u00e8m v\u1edbi Excel, b\u1ea1n kh\u00f4ng c\u1ea7n c\u00e0i \u0111\u1eb7t th\u00eam g\u00ec tr\u00ean m\u00e1y t\u00ednh \u0111\u1ec3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c VBA! Trong kho\u00e1 h\u1ecdc n\u00e0y, t\u00f4i s\u1ebd gi\u00fap b\u1ea1n c\u00f3 th\u00eam m\u1ed9t k\u0129 n\u0103ng quan tr\u1ecdng \u0111\u1ec3 l\u00e0m cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n hi\u1ec7u qu\u1ea3 h\u01a1n 200%, s\u1ebd gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m h\u00e0ng gi\u1edd c\u00f4ng l\u00e0m b\u00e1o c\u00e1o. Kh\u00f4ng nh\u1eefng th\u1ebf, b\u1ea1n c\u00f2n c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c t\u0103ng l\u01b0\u01a1ng hay th\u0103ng ch\u1ee9c khi l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 nh\u01b0 v\u1eady!<\/p>\n<p>H\u00e3y b\u1ea5m n\u00fat \u0111\u0103ng k\u00fd v\u00e0 h\u1eb9n s\u1edbm g\u1eb7p l\u1ea1i b\u1ea1n trong kho\u00e1 h\u1ecdc!<\/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\/2025\/01\/vba101_92019-nho-78.gif\" title=\"vba101_92019-nho-78\"><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\/2025\/01\/ex101_92019-nho-407.gif\" title=\"ex101_92019-nho-407\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Doi_tuong_muc_tieu\"><\/span>\u0110\u1ed1i t\u01b0\u1ee3ng m\u1ee5c ti\u00eau<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>Chuy\u00ean vi\u00ean v\u0103n ph\u00f2ng: k\u1ebf to\u00e1n, ki\u1ec3m to\u00e1n, t\u00e0i ch\u00ednh, ng\u00e2n h\u00e0ng<\/li>\n<li>Qu\u1ea3n tr\u1ecb c\u00f4ng ty, tr\u01b0\u1eddng h\u1ecdc, b\u1ec7nh vi\u1ec7n, v\u00e0 c\u00e1c c\u01a1 quan h\u00e0nh ch\u00ednh kh\u00e1c<\/li>\n<li>K\u1ef9 s\u01b0 c\u00f4ng tr\u00ecnh x\u00e2y d\u1ef1ng<\/li>\n<li>Sinh vi\u00ean c\u00e1c tr\u01b0\u1eddng kinh t\u1ebf, k\u0129 thu\u1eadt<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Hieu_qua_dau_ra_cua_khoa_hoc_VBA_trong_Excel\"><\/span>Hi\u1ec7u qu\u1ea3 \u0111\u1ea7u ra cu\u0309a kho\u0301a ho\u0323c VBA trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Sau khi h\u1ecdc xong kho\u00e1 h\u1ecdc n\u00e0y:<\/p>\n<ol>\n<li>B\u1ea1n c\u00f3 ki\u1ebfn th\u1ee9c v\u1eefng v\u00e0ng v\u1ec1 VBA c\u01a1 b\u1ea3n<\/li>\n<li>C\u00f3 th\u1ec3 s\u1eed d\u1ee5ng nh\u1eefng t\u00e1c v\u1ee5 x\u1eed l\u00fd d\u1eef li\u1ec7u tr\u00ean Sheet c\u0169ng nh\u01b0 trong m\u1ea3ng ho\u1eb7c t\u1eadp h\u1ee3p c\u1ee7a VBA<\/li>\n<li>C\u00f3 kh\u1ea3 n\u0103ng t\u1ef1 vi\u1ebft ch\u01b0\u01a1ng tr\u00ecnh l\u1ecdc d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n d\u1ef1a tr\u00ean 1 c\u1ed9t hay nhi\u1ec1u c\u1ed9t<\/li>\n<li>L\u1eadp tr\u00ecnh form \u0111\u1ec3 t\u0103ng \u0111\u1ed9 ch\u00ednh x\u00e1c khi nh\u1eadp li\u1ec7u trong Excel<\/li>\n<li>\u0110\u1ee7 kh\u1ea3 n\u0103ng \u0111\u1ec3 l\u1eadp tr\u00ecnh, t\u1ef1 x\u00e2y d\u1ef1ng ph\u1ea7n m\u1ec1m ph\u1ee5c v\u1ee5 c\u00f4ng vi\u1ec7c<\/li>\n<li>\u00c1p d\u1ee5ng VBA n\u00e2ng cao hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c<\/li>\n<\/ol>\n<p>Nhi\u1ec1u b\u1ea1n \u0111\u00e3 tr\u00fang tuy\u1ec3n v\u00e0o c\u00e1c v\u1ecb tr\u00ed c\u00f4ng vi\u1ec7c m\u01a1 \u01b0\u1edbc khi trang b\u1ecb cho m\u00ecnh ki\u1ebfn th\u1ee9c n\u00e0y<\/p>\n<figure id=\"attachment_6943\" aria-describedby=\"caption-attachment-6943\" style=\"width: 576px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2016\/12\/Trung-tru%CC%81ng-tuye%CC%82%CC%89n-MB-nho%CC%9B%CC%80-kha%CC%89-na%CC%86ng-Excel-va%CC%80-VBA.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-6943\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/trung-trucc81ng-tuyecc82cc89n-mb-nhocc9bcc80-khacc89-nacc86ng-excel-vacc80-vba-576x1024-1.png\" alt=\"Trung-tru\u0301ng tuye\u0302\u0309n MB nho\u031b\u0300 kha\u0309 na\u0306ng Excel va\u0300 VBA\" width=\"576\" height=\"1024\" title=\"trung-trucc81ng-tuyecc82cc89n-mb-nhocc9bcc80-khacc89-nacc86ng-excel-vacc80-vba-576x1024-1\"><\/a><figcaption id=\"caption-attachment-6943\" class=\"wp-caption-text\">Trung-tru\u0301ng tuye\u0302\u0309n MB nho\u031b\u0300 kha\u0309 na\u0306ng Excel va\u0300 VBA<\/figcaption><\/figure>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2016\/12\/proof-02.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6945\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/proof-02.png\" width=\"684\" height=\"284\" title=\"proof-02\"><\/a><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2016\/12\/proof-vba101.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-6946\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/proof-vba101.png\" width=\"680\" height=\"186\" title=\"proof-vba101\"><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Giang_vien_Nguyen_Duc_Thanh\"><\/span>Gi\u1ea3ng vi\u00ean:\u00a0<strong>Nguy\u1ec5n \u0110\u1ee9c Thanh<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Chuy\u00ean vi\u00ean t\u01b0 v\u1ea5n gi\u1ea3i ph\u00e1p, ph\u1ea7n m\u1ec1m h\u1ec7 th\u1ed1ng t\u1ea1i t\u1eadp \u0111o\u00e0n KPMG, \u0110\u1ee9c. Linkedin<\/p>\n<p>Gi\u1ea3ng vi\u00ean c\u1ee7a c\u00e1c kho\u00e1 h\u1ecdc:<\/p>\n<ul>\n<li>VBA101 \u2013 VBA c\u01a1 b\u1ea3n cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/li>\n<li>EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao<\/li>\n<li>IM101 \u2013 \u1ee8ng d\u1ee5ng Excel v\u00e0o c\u00f4ng vi\u1ec7c qu\u1ea3n l\u00fd kho h\u00e0ng<\/li>\n<li>Nhi\u1ec1u kho\u00e1 h\u1ecdc online kh\u00e1c<\/li>\n<li>Gi\u1ea3ng d\u1ea1y t\u1ea1i trung t\u00e2m b\u00e1o c\u00e1o s\u1ed1 li\u1ec7u (BICC), ng\u00e2n h\u00e0ng Vi\u1ec7t Nam th\u1ecbnh v\u01b0\u1ee3ng \u2013 VPBank<\/li>\n<li>Gi\u1ea3ng d\u1ea1y cho ph\u00f2ng KHDN, ng\u00e2n h\u00e0ng VietinBank<\/li>\n<\/ul>\n<p>Admin:<\/p>\n<ol>\n<li><a target=\"_blank\" rel=\"noopener noreferrer\" href=\"\">H\u1ecdc Excel Online<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\" target=\"_blank\" rel=\"noopener noreferrer\">Blog H\u1ecdc Excel Online<\/a><\/li>\n<li><a href=\"http:\/\/youtube.com\/c\/hocexcelonline\" target=\"_blank\" rel=\"noopener noreferrer\">K\u00eanh YouTube h\u1ecdc Excel, tin h\u1ecdc v\u0103n ph\u00f2ng<\/a><\/li>\n<li><a href=\"https:\/\/www.facebook.com\/www.hocexcel.online\/\" target=\"_blank\" rel=\"noopener noreferrer\">FanPage H\u1ecdc Excel Online<\/a><\/li>\n<li><a href=\"https:\/\/www.facebook.com\/groups\/hocexcel.online\/\" target=\"_blank\" rel=\"noopener noreferrer\">Group Tin h\u1ecdc v\u0103n ph\u00f2ng Excel Word PowerPoint<\/a><\/li>\n<\/ol>\n<h4><span class=\"ez-toc-section\" id=\"Hoc_thu_12_bai_dau_tien\"><\/span><a id=\"hoc-thu\" href=\"\"><\/a>H\u1ecdc th\u1eed\u00a012 b\u00e0i \u0111\u1ea7u ti\u00ean:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/videoseries?list=PLALCv46JuKELQytuP3xInfPjSfSQYZWdW\" width=\"560\" height=\"315\" frameborder allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Noi_dung_toan_bo_khoa_hoc\"><\/span><a id=\"noi-dung\" href=\"\"><\/a>N\u1ed9i dung to\u00e0n b\u1ed9 kho\u00e1 h\u1ecdc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>01 \u2013 Mo\u031b\u0309 the\u0309 Developer<br \/>\n02 \u2013 Ghi 1 macro, ca\u0301ch cha\u0323y macro tu\u031b\u0300 VBE<br \/>\n03 \u2013 Ca\u0301ch cha\u0323y macro tu\u031b\u0300ng do\u0300ng<br \/>\n04 \u2013 Lu\u031bu va\u0300 mo\u031b\u0309 file excel co\u0301 chu\u031b\u0301a macro<br \/>\n05 \u2013 Loa\u0323i bo\u0309 code VBA trong Excel<br \/>\n06 \u2013 Export va\u0300 Import code VBA tu\u031b\u0300 file Excel na\u0300y sang file Excel kha\u0301c<br \/>\n07 \u2013 Ta\u0323o mo\u031b\u0301i module trong VBA<br \/>\n08 \u2013 Co\u031b ba\u0309n ve\u0302\u0300 \u0111o\u0302\u0301i tu\u031bo\u031b\u0323ng Range trong VBA<br \/>\n09 \u2013 Ca\u0301ch ga\u0301n macro va\u0300o nu\u0301t \u0111e\u0302\u0309 cha\u0323y<br \/>\n10 \u2013 Tie\u0302\u0301p tu\u0323c vo\u031b\u0301i \u0111o\u0302\u0301i tu\u031bo\u031b\u0323ng Range, \u0111ie\u0302\u0300n du\u031b\u0303 lie\u0323\u0302u text ba\u0306\u0300ng VBA<br \/>\n11 \u2013 Thuo\u0323\u0302c ti\u0301nh Text, Value, Row, Column cu\u0309a \u0111o\u0302\u0301i tu\u031bo\u031b\u0323ng Range<br \/>\n12 \u2013 Du\u0300ng code vba \u0111e\u0302\u0309 \u0111ie\u0302\u0300n va\u0300 \u0111i\u0323nh da\u0323ng du\u031b\u0303 lie\u0323\u0302u<br \/>\n13 \u2013 Du\u0300ng VBA \u0111e\u0302\u0309 la\u0300m vie\u0323\u0302c vo\u031b\u0301i Name Range, gio\u031b\u0301i thie\u0323\u0302u ve\u0302\u0300 ClearContents va\u0300 ClearFormats<br \/>\n14 \u2013 Su\u031b\u0309 du\u0323ng thuo\u0323\u0302c ti\u0301nh formula na\u0302ng cao<br \/>\n15 \u2013 \u0110o\u0302\u0301i tu\u031bo\u031b\u0323ng Cells o\u031b\u0309 trong Excel<br \/>\n16 \u2013 O\u0302n ta\u0323\u0302p ve\u0302\u0300 \u0111o\u0302\u0301i tu\u031bo\u031b\u0323ng Range, ca\u0301ch tham chie\u0302\u0301u \u0111e\u0302\u0301n ba\u0309ng ti\u0301nh<br \/>\n17 \u2013 Su\u031b\u0309 du\u0323ng ke\u0302\u0301t ho\u031b\u0323p \u0111o\u0302\u0301i tu\u031bo\u031b\u0323ng Range va\u0300 Cells<br \/>\n18 \u2013 Ha\u0300m offset<br \/>\n19 \u2013 Ca\u0302\u0301u tru\u0301c With va\u0300 End With<br \/>\n20 \u2013 \u0110o\u0323c ghi du\u031b\u0303 lie\u0323\u0302u tu\u031b\u0300 Range to\u031b\u0301i Range<br \/>\n21 \u2013 Bie\u0302\u0301n so\u0302\u0301 va\u0300 kie\u0302\u0309u du\u031b\u0303 lie\u0323\u0302u 01<br \/>\n22 \u2013 Bie\u0302\u0301n so\u0302\u0301 va\u0300 kie\u0302\u0309u du\u031b\u0303 lie\u0323\u0302u 02 \u2013 Boolean, gia\u0301 tri\u0323 ma\u0323\u0306c \u0111i\u0323nh cu\u0309a bie\u0302\u0301n so\u0302\u0301<br \/>\n23 \u2013 Bie\u0302\u0301n so\u0302\u0301 va\u0300 kie\u0302\u0309u du\u031b\u0303 lie\u0323\u0302u 03 \u2013 String<br \/>\n24 \u2013 Function, ca\u0301ch vie\u0302\u0301t Function, tham so\u0302\u0301 tuy\u0300 cho\u0323n<br \/>\n25 \u2013 Copy Range, PasteSpecial<br \/>\n26 \u2013 \u0110o\u0302\u0301i tu\u031bo\u031b\u0323ng Workbook<br \/>\n27 \u2013 \u0110o\u0302\u0301i tu\u031bo\u031b\u0323ng Workbook, \u0111o\u0301ng mo\u031b\u0309 lu\u031bu Workbook<br \/>\n28 \u2013 \u0110o\u0302\u0301i tu\u031bo\u031b\u0323ng Workbook, mo\u031b\u0309 read-only, ta\u0323o workbook mo\u031b\u0301i<br \/>\n29 \u2013 \u0110o\u0302\u0301i tu\u031bo\u031b\u0323ng workbook, kie\u0302\u0309m tra workbook co\u0301 to\u0302\u0300n ta\u0323i kho\u0302ng<br \/>\n30 \u2013 \u0110o\u0302\u0301i tu\u031bo\u031b\u0323ng workbook, copy sao che\u0301p workbook \u0111ang \u0111o\u0301ng<br \/>\n31 \u2013 \u0110o\u0302\u0301i tu\u031bo\u031b\u0323ng Worksheet<br \/>\n32 \u2013 \u0110o\u0302\u0301i tu\u031bo\u031b\u0323ng Worksheets<br \/>\n33 \u2013 Su\u031b\u0309 du\u0323ng object browser \u0111e\u0302\u0309 tra cu\u031b\u0301u trong VBA<br \/>\n34 \u2013 Ca\u0301ch khai ba\u0301o va\u0300 su\u031b\u0309 du\u0323ng bie\u0302\u0301n toa\u0300n cu\u0323c \u2013 Public<br \/>\n35 \u2013 Ca\u0301ch khai ba\u0301o bie\u0302\u0301n cu\u0323c bo\u0323\u0302 \u2013 Private<br \/>\n36 \u2013 Ca\u0301ch khai ba\u0301o va\u0300 su\u031b\u0309 du\u0323ng bie\u0302\u0301n Static<br \/>\n37 \u2013 Mo\u0323\u0302t so\u0302\u0301 toa\u0301n tu\u031b\u0309 trong VBA<br \/>\n38 \u2013 Ca\u0301c toa\u0301n tu\u031b\u0309 Logic trong VBA<br \/>\n39 \u2013 Ca\u0302\u0301u tru\u0301c \u0111ie\u0302\u0300u khie\u0302\u0309n IF \u0111o\u031bn gia\u0309n<br \/>\n40 \u2013 Ca\u0302\u0301u tru\u0301c \u0111ie\u0302\u0300u khie\u0302\u0309n IF na\u0302ng cao<br \/>\n41 \u2013 Vo\u0300ng la\u0323\u0306p For<br \/>\n42 \u2013 Vo\u0300ng la\u0323\u0306p for each<br \/>\n43 \u2013 Vo\u0300ng la\u0323\u0306p For \u2013 Su\u031b\u0309 du\u0323ng Exit For<br \/>\n44 \u2013 Vo\u0300ng la\u0323\u0306p do while loop<br \/>\n45 \u2013 Vo\u0300ng la\u0323\u0306p do until<br \/>\n46 \u2013 Ma\u0309ng trong VBA<br \/>\n47 \u2013 Ma\u0309ng trong VBA, ma\u0309ng ti\u0303nh, ma\u0309ng \u0111o\u0323\u0302ng<br \/>\n48 \u2013 Ma\u0309ng trong VBA \u2013 su\u031b\u0309 du\u0323ng ha\u0300m split<br \/>\n49 \u2013 Ma\u0309ng trong VBA, su\u031b\u0309 du\u0323ng vo\u0300ng la\u0323\u0306p, ta\u0323o so\u0302\u0301 nga\u0302\u0303u nhie\u0302n<br \/>\n50 \u2013 Ma\u0309ng trong VBA, \u0111a\u0323\u0306t la\u0323i du\u031b\u0303 lie\u0323\u0302u \u2013 erase value<br \/>\n51 \u2013 Ma\u0309ng trong VBA, su\u031b\u0309 du\u0323ng erase vo\u031b\u0301i ma\u0309ng \u0111o\u0323\u0302ng<br \/>\n52 \u2013 Ma\u0309ng trong VBA, su\u031b\u0309 du\u0323ng redim preserve thay \u0111o\u0302\u0309i ki\u0301ch thu\u031bo\u031b\u0301c cu\u0309a ma\u0309ng<br \/>\n53 \u2013 Ma\u0309ng trong VBA, du\u0300ng ma\u0309ng la\u0300m tham so\u0302\u0301 cho function<br \/>\n54 \u2013 Ma\u0309ng trong VBA, vie\u0302\u0301t function tra\u0309 ve\u0302\u0300 da\u0323ng array<br \/>\n55 \u2013 Ma\u0309ng 2 chie\u0302\u0300u, ca\u0301ch khai ba\u0301o va\u0300 la\u0323\u0306p<br \/>\n56 \u2013 \u0110o\u0323c du\u031b\u0303 lie\u0323\u0302u tu\u031b\u0300 sheet va\u0300o ma\u0309ng<br \/>\n57 \u2013 Ghi du\u031b\u0303 lie\u0323\u0302u tu\u031b\u0300 ma\u0309ng VBA va\u0300o ba\u0309ng ti\u0301nh Excel<br \/>\n58 \u2013 Ghi du\u031b\u0303 lie\u0323\u0302u ra ma\u0309ng, su\u031b\u0309 du\u0323ng resize<br \/>\n59 \u2013 Mo\u0323\u0302t so\u0302\u0301 ha\u0300m toa\u0301n ho\u0323c hay su\u031b\u0309 du\u0323ng trong VBA<br \/>\n60 \u2013 Mo\u0323\u0302t so\u0302\u0301 ha\u0300m kie\u0302\u0309m tra du\u031b\u0303 lie\u0323\u0302u trong VBA<br \/>\n61 \u2013 Mo\u0323\u0302t so\u0302\u0301 ha\u0300m chuye\u0302\u0309n \u0111o\u0302\u0309i kie\u0302\u0309u du\u031b\u0303 lie\u0323\u0302u trong VBA<br \/>\n62 \u2013 Mo\u0323\u0302t so\u0302\u0301 ha\u0300m xu\u031b\u0309 ly\u0301 chuo\u0302\u0303i trong VBA<br \/>\n63 \u2013 Ha\u0300m xu\u031b\u0309 ly\u0301 nga\u0300y, tha\u0301ng, gio\u031b\u0300 trong VBA<br \/>\n64.1 \u2013 BT lie\u0323\u0302t ke\u0302 ca\u0301c sheet trong ba\u0309ng ti\u0301nh<br \/>\n64.2 \u2013 GBT lie\u0323\u0302t ke\u0302 ca\u0301c sheet trong ba\u0309ng ti\u0301nh<br \/>\n65.1 \u2013 BT lie\u0323\u0302t ke\u0302 te\u0302n sheet, ghi ra ba\u0309ng ti\u0301nh<br \/>\n65.2 \u2013 GBT lie\u0323\u0302t ke\u0302 te\u0302n sheet, ghi ra ba\u0309ng ti\u0301nh<br \/>\n66 \u2013 Ta\u0301ch ca\u0301c sheets trong 1 file excel ra nhie\u0302\u0300u file excel<br \/>\n67.1 \u2013 BT Ti\u0300m do\u0300ng cuo\u0302\u0301i hoa\u0323\u0306c co\u0323\u0302t cuo\u0302\u0301i co\u0301 chu\u031b\u0301a du\u031b\u0303 lie\u0323\u0302u<br \/>\n67.2 \u2013 GBT Ti\u0300m do\u0300ng cuo\u0302\u0301i, co\u0323\u0302t cuo\u0302\u0301i co\u0301 chu\u031b\u0301a du\u031b\u0303 lie\u0323\u0302u trong ba\u0309ng ti\u0301nh<br \/>\n68.1 \u2013 BT Ta\u0323o nhie\u0302\u0300u sheets theo te\u0302n co\u0301 sa\u0306\u0303n<br \/>\n68.2 \u2013 GBT Ta\u0323o nhie\u0302\u0300u sheets theo te\u0302n co\u0301 sa\u0306\u0303n<br \/>\n69 \u2013 Su\u031b\u0309 du\u0323ng Inputbox o\u031b\u0309 trong VBA \u0111e\u0302\u0309 tu\u031bo\u031bng ta\u0301c vo\u031b\u0301i ngu\u031bo\u031b\u0300i du\u0300ng<br \/>\n70 \u2013 To\u0302\u0309ng quan ve\u0302\u0300 lo\u0302\u0303i va\u0300 xu\u031b\u0309 ly\u0301 lo\u0302\u0303i trong VBA<br \/>\n71 \u2013 Vi\u0301 du\u0323 ve\u0302\u0300 ba\u0302\u0303y lo\u0302\u0303i co\u031b ba\u0309n trong VBA<br \/>\n72 \u2013 Qua\u0309n ly\u0301 lo\u0302\u0303i ba\u0306\u0300ng On Error<br \/>\n73 \u2013 Ta\u0323i sao ca\u0302\u0300n co\u0301 exit sub tru\u031bo\u031b\u0301c label lo\u0302\u0303i<br \/>\n74 \u2013 Ba\u0302\u0303y lo\u0302\u0303i va\u0300 thu\u031b\u0309 la\u0323i trong VBA<br \/>\n75 \u2013 \u0110o\u0302\u0301i tu\u031bo\u031b\u0323ng collection (ta\u0323\u0302p ho\u031b\u0323p) trong VBA<br \/>\n76 \u2013 La\u0300m quen vo\u031b\u0301i ta\u0323\u0302p ho\u031b\u0323p (Collection) trong VBA<br \/>\n77 \u2013 Khai ba\u0301o, su\u031b\u0309 du\u0323ng va\u0300 xoa\u0301 tha\u0300nh pha\u0302\u0300n cu\u0309a ta\u0323\u0302p ho\u031b\u0323p<br \/>\n78 \u2013 The\u0302m pha\u0302\u0300n tu\u031b\u0309 va\u0300o collections trong VBA<br \/>\n79 \u2013 Ta\u0323\u0302p ho\u031b\u0323p kho\u0302ng cho phe\u0301p thay \u0111o\u0302\u0309i gia\u0301 tri\u0323 cu\u0309a pha\u0302\u0300n tu\u031b\u0309<br \/>\n80 \u2013 Su\u031b\u0309 du\u0323ng key trong ta\u0323\u0302p ho\u031b\u0323p<br \/>\n81 \u2013 Kie\u0302\u0309m tra key co\u0301 to\u0302\u0300n ta\u0323i trong Collection kho\u0302ng<br \/>\n82 \u2013 Ti\u0301nh kho\u0302ng tru\u0300ng la\u0323\u0306p cu\u0309a key trong ta\u0323\u0302p ho\u031b\u0323p<br \/>\n83 \u2013 Lo\u0323c du\u031b\u0303 lie\u0323\u0302u ba\u0306\u0300ng VBA vo\u031b\u0301i 1 \u0111ie\u0302\u0300u kie\u0323\u0302n<br \/>\n84 \u2013 Mo\u031b\u0309 ro\u0323\u0302ng vi\u0301 du\u0323 lo\u0323c du\u031b\u0303 lie\u0323\u0302u vo\u031b\u0301i 2 hay nhie\u0302\u0300u \u0111ie\u0302\u0300u kie\u0323\u0302n<br \/>\n85 \u2013 Mo\u031b\u0309 ro\u0323\u0302ng vi\u0301 du\u0323 lo\u0323c \u0111ie\u0302\u0300u kie\u0323\u0302n o\u031b\u0309 nhie\u0302\u0300u co\u0323\u0302t<br \/>\n86 \u2013 Su\u031b\u0309 du\u0323ng ma\u0309ng trong \u0111ie\u0302\u0300u kie\u0323\u0302n lo\u0323c<br \/>\n87.1 \u2013 BT Lo\u0323c du\u031b\u0303 lie\u0323\u0302u theo co\u0323\u0302t va\u0300 copy ra sheet mo\u031b\u0301i<br \/>\n87.2 \u2013 GBT Lo\u0323c du\u031b\u0303 lie\u0323\u0302u theo co\u0323\u0302t va\u0300 copy ra sheet mo\u031b\u0301i<br \/>\n88.1 \u2013 BT To\u0302\u0309ng ho\u031b\u0323p du\u031b\u0303 lie\u0323\u0302u tu\u031b\u0300 nhie\u0302\u0300u sheets tha\u0300nh pha\u0302\u0300n va\u0300o 1 sheet<br \/>\n88.2 \u2013 GBT To\u0302\u0309ng ho\u031b\u0323p du\u031b\u0303 lie\u0323\u0302u tu\u031b\u0300 nhie\u0302\u0300u sheets tha\u0300nh pha\u0302\u0300n va\u0300o 1 sheet<br \/>\n89.1 \u2013 BT Xoa\u0301 do\u0300ng tro\u0302\u0301ng ba\u0306\u0300ng VBA<br \/>\n89.2 \u2013 GBT Xoa\u0301 do\u0300ng tro\u0302\u0301ng ba\u0306\u0300ng VBA<br \/>\n90.1 \u2013 BT Sa\u0306\u0301p xe\u0302\u0301p du\u031b\u0303 lie\u0323\u0302u ba\u0306\u0300ng VBA<br \/>\n90.2 \u2013 GBT Sa\u0306\u0301p xe\u0302\u0301p du\u031b\u0303 lie\u0323\u0302u ba\u0306\u0300ng VBA<br \/>\n91 \u2013 Gio\u031b\u0301i thie\u0323\u0302u Userform<br \/>\n92.1 \u2013 Hoa\u0300n tha\u0300nh thie\u0302\u0301t ke\u0302\u0301 UserForm \u0111e\u0302\u0309 nha\u0323\u0302p lie\u0323\u0302u<br \/>\n92.2 \u2013 Hoa\u0300n tha\u0300nh userform \u2013 ghi du\u031b\u0303 lie\u0323\u0302u tu\u031b\u0300 userform xuo\u0302\u0301ng sheets<br \/>\n92.3 \u2013 Chuye\u0302\u0309n du\u031b\u0303 lie\u0323\u0302u userform xuo\u0302\u0301ng ba\u0309ng ti\u0301nh vo\u031b\u0301i \u0111i\u0323nh da\u0323ng so\u0302\u0301<br \/>\n92.4 \u2013 \u0110ie\u0302\u0300n du\u031b\u0303 lie\u0323\u0302u ma\u0323\u0306c \u0111i\u0323nh giu\u0301p vie\u0323\u0302c nha\u0323\u0302p lie\u0323\u0302u de\u0302\u0303 da\u0300ng ho\u031bn<br \/>\n92.5 \u2013 Kie\u0302\u0309m tra du\u031b\u0303 lie\u0323\u0302u nha\u0323\u0302p va\u0300o ba\u0306\u0300ng form, \u0111a\u0309m ba\u0309o nha\u0323\u0302p \u0111u\u0309 du\u031b\u0303 lie\u0323\u0302u<br \/>\n92.6 \u2013 \u0110a\u0309m ba\u0309o ma\u0303 so\u0302\u0301 nha\u0323\u0302p va\u0300o qua userform la\u0300 duy nha\u0302\u0301t<br \/>\n93.1 \u2013 Hie\u0323\u0302n a\u0309nh tre\u0302n form<br \/>\n93.2 \u2013 Bie\u0302\u0309u \u0111o\u0302\u0300 \u0111o\u0323\u0302ng tre\u0302n form<br \/>\n93.3 \u2013 Thie\u0302\u0301t la\u0323\u0302p bie\u0302\u0309u va\u0300 import du\u031b\u0303 lie\u0323\u0302u bie\u0302\u0309u \u0111o\u0302\u0300 \u0111o\u0323\u0302ng<br \/>\n93.4 \u2013 Hoa\u0300n tha\u0300nh bie\u0302\u0309u \u0111o\u0302\u0300 \u0111o\u0323\u0302ng tre\u0302n form<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Giao_dien_hoc\"><\/span>Giao di\u1ec7n h\u1ecdc<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<figure id=\"attachment_6937\" aria-describedby=\"caption-attachment-6937\" style=\"width: 2560px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2016\/09\/giao-dien-khoa-hoc-excel-online.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6937\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/giao-dien-khoa-hoc-excel-online.png\" alt=\"giao-dien-khoa-hoc-excel-online\" width=\"2560\" height=\"1480\" title=\"giao-dien-khoa-hoc-excel-online\"><\/a><figcaption id=\"caption-attachment-6937\" class=\"wp-caption-text\">giao-dien-khoa-hoc-excel-online<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Cach_dang_ky_va_nhan_tai_khoan_hoc\"><\/span><a id=\"dang-ky\" href=\"\"><\/a>C\u00e1ch \u0111\u0103ng k\u00fd v\u00e0 nh\u1eadn t\u00e0i kho\u1ea3n h\u1ecdc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"https:\/\/blog.hocexcel.online\/vba101-landing.html#dang-ky\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2391\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/hucc9bocc9bcc81ng-dacc82cc83n-ck-1010x1024-1.png\" width=\"1010\" height=\"1024\" title=\"hucc9bocc9bcc81ng-dacc82cc83n-ck-1010x1024-1\"><\/a><\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong><\/p>\n<p>Chuy\u1ec3n ti\u1ec1n theo c\u00fa ph\u00e1p sau \u0111\u00e2y. (H\u1ecdc ph\u00ed cho nh\u1eefng b\u1ea1n kh\u00f4ng \u1edf VN, m\u00ecnh nh\u1eadn ti\u1ec1n qua IBAN, SWIFT,Paypal, th\u1ebb \u0111i\u1ec7n tho\u1ea1i tr\u1ea3 tr\u01b0\u1edbc \u2026 li\u00ean h\u1ec7\u00a0<strong><a href=\"http:\/\/m.me\/www.hocexcel.online\" target=\"_blank\" rel=\"noopener noreferrer\">Facebook<\/a><\/strong>\u00a0\u0111\u1ec3 \u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3 n\u1ebfu s\u1eed d\u1ee5ng c\u00e1c h\u00ecnh th\u1ee9c chuy\u1ec3n kho\u1ea3n n\u00e0y)<\/p>\n<table style=\"height: 144px\" width=\"566\">\n<tbody>\n<tr>\n<td style=\"width: 275px\">Ch\u1ee7 TK<\/td>\n<td style=\"width: 275px\"><strong>Nguy\u1ec5n \u0110\u1ee9c Thanh<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 275px\">S\u1ed1 TK<\/td>\n<td style=\"width: 275px\"><strong>99042443<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 275px\">Chi nh\u00e1nh<\/td>\n<td style=\"width: 275px\"><strong>VPBank Th\u0103ng Long<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 275px\">N\u1ed9i dung chuy\u1ec3n kho\u1ea3n<\/td>\n<td style=\"width: 275px\">H\u1ecd T\u00ean b\u1ea1n \u2013 S\u1ed1 \u0111i\u1ec7n tho\u1ea1i b\u1ea1n \u2013\u00a0VBA101<\/p>\n<p>VD: Nguyen Duc Thanh \u2013 &lt;s\u1ed1 \u0111i\u1ec7n tho\u1ea1i&gt;\u00a0\u2013 VBA101<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 275px\">H\u1ecdc Ph\u00ed<\/td>\n<td style=\"width: 275px\"><strong>800.000 VN\u0110<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>* N\u1ebfu mua k\u00e8m v\u1edbi kho\u00e1\u00a0<a href=\"https:\/\/blog.hocexcel.online\/ex101\" target=\"_blank\" rel=\"noopener noreferrer\">EX101<\/a>\u00a0=&gt; Gi\u00e1 cho 2 kho\u00e1: 1.400k VN\u0110<\/p>\n<p>* N\u1ebfu mua k\u00e8m v\u1edbi kho\u00e1\u00a0EX101\u00a0v\u00e0\u00a0<a href=\"https:\/\/blog.hocexcel.online\/im101\" target=\"_blank\" rel=\"noopener noreferrer\">IM101<\/a>\u00a0=&gt; Gi\u00e1 cho 3 kho\u00e1: 1.800k VN\u0110<\/p>\n<p><strong>Ch\u00fa \u00fd<\/strong>: sau khi chuy\u1ec3n h\u1ecdc ph\u00ed m\u00e0 b\u1ea1n kh\u00f4ng th\u1ea5y \u0111\u01b0\u1ee3c li\u00ean l\u1ea1c l\u1ea1i, c\u00f3 th\u1ec3 ph\u1ea7n n\u1ed9i dung chuy\u1ec3n kho\u1ea3n b\u1ecb sai l\u1ec7ch th\u00f4ng tin d\u1eabn \u0111\u1ebfn H\u1ecdc Excel Online kh\u00f4ng th\u1ec3 li\u00ean l\u1ea1c l\u1ea1i v\u1edbi b\u1ea1n th\u00ec b\u1ea1n h\u00e3y g\u1eedi email \u0111\u1ebfn \u0111\u1ecba ch\u1ec9\u00a0<a href=\"mailto:heo@hocexcel.online\" target=\"_blank\" rel=\"noopener noreferrer\">heo@hocexcel.online<\/a>\u00a0v\u1edbi ti\u00eau \u0111\u1ec1<\/p>\n<p><strong>H\u1ecd T\u00ean b\u1ea1n \u2013 S\u1ed1 \u0111i\u1ec7n tho\u1ea1i b\u1ea1n \u2013\u00a0VBA101<\/strong><\/p>\n<p>Nh\u01b0 v\u1eady b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3 s\u1edbm nh\u1ea5t<\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong><\/p>\n<p>Nh\u1eadn h\u01b0\u1edbng d\u1eabn \u0111\u0103ng nh\u1eadp, h\u01b0\u1edbng d\u1eabn v\u1ec1 nh\u00f3m v\u00e0 t\u00e0i li\u1ec7u tr\u1ee3 gi\u00fap trong qu\u00e1 tr\u00ecnh h\u1ecdc v\u00e0 b\u1eaft \u0111\u1ea7u h\u1ecdc ngay tr\u00ean trang ch\u1ee7 c\u1ee7a H\u1ecdc Excel Online.<\/p>\n<p>VBA\u00a0gi\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>C\u00f9ng kh\u00e1m ph\u00e1 th\u1ebf gi\u1edbi c\u1ee7a VBA t\u1ea1i\u00a0kho\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 ngay th\u00f4i n\u00e0o. 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<h4><\/h4>\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\/2025\/01\/vba101_92019-nho-78.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12511,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12510","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12510","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=12510"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12510\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12511"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12510"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12510"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12510"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}