{"id":5793,"date":"2024-12-20T20:38:16","date_gmt":"2024-12-20T20:38:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/20\/hoc-excel-ke-toan-tu-tao-phan-mem-quan-ly-kho-voi-excel-va-vba\/"},"modified":"2024-12-20T20:38:16","modified_gmt":"2024-12-20T20:38:16","slug":"hoc-excel-ke-toan-tu-tao-phan-mem-quan-ly-kho-voi-excel-va-vba","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/20\/hoc-excel-ke-toan-tu-tao-phan-mem-quan-ly-kho-voi-excel-va-vba\/","title":{"rendered":"H\u1ecdc Excel k\u1ebf to\u00e1n \u2013 T\u1ef1 t\u1ea1o ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd kho v\u1edbi Excel v\u00e0 VBA"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\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-6765d5b718df6\" 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\/khoa-hoc-excel-ke-toan.html#TONG_QUAN_VE_KHOA_HOC\" title=\"T\u1ed4NG QUAN V\u1ec0 KH\u00d3A\u00a0 H\u1eccC:\">T\u1ed4NG QUAN V\u1ec0 KH\u00d3A\u00a0 H\u1eccC:<\/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\/khoa-hoc-excel-ke-toan.html#Tai_sao_chung_ta_can_hoc_khoa_hoc_Excel_ke_toan_nay\" title=\"T\u1ea1i sao ch\u00fang ta c\u1ea7n h\u1ecdc\u00a0 kh\u00f3a h\u1ecdc Excel k\u00ea\u0301 toa\u0301n na\u0300y\">T\u1ea1i sao ch\u00fang ta c\u1ea7n h\u1ecdc\u00a0 kh\u00f3a h\u1ecdc Excel k\u00ea\u0301 toa\u0301n na\u0300y<\/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\/khoa-hoc-excel-ke-toan.html#Hieu_qua_dau_ra_cua_khoa_hoc\" title=\"Hi\u1ec7u qu\u1ea3\u00a0\u0111\u1ea7u ra c\u1ee7a kh\u00f3a h\u1ecdc\">Hi\u1ec7u qu\u1ea3\u00a0\u0111\u1ea7u ra c\u1ee7a kh\u00f3a 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-4\" href=\"https:\/\/blog.hocexcel.online\/khoa-hoc-excel-ke-toan.html#THONG_TIN_CHI_TIET_CUA_KHOA_HOC\" title=\"TH\u00d4NG TIN\u00a0CHI TI\u1ebeT C\u1ee6A KH\u00d3A H\u1eccC:\">TH\u00d4NG TIN\u00a0CHI TI\u1ebeT C\u1ee6A KH\u00d3A H\u1eccC:<\/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\/khoa-hoc-excel-ke-toan.html#Thong_tin_ve_giang_vien\" title=\"Th\u00f4ng tin v\u1ec1 gi\u1ea3ng vi\u00ean\">Th\u00f4ng tin v\u1ec1 gi\u1ea3ng vi\u00ean<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/khoa-hoc-excel-ke-toan.html#Giao_trinh_chi_tiet\" title=\"Gi\u00e1o tr\u00ecnh chi ti\u1ebft\">Gi\u00e1o tr\u00ecnh chi ti\u1ebft<\/a><\/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\/khoa-hoc-excel-ke-toan.html#Thong_tin_ve_hinh_thuc_hoc\" title=\"Th\u00f4ng tin v\u1ec1 h\u00ecnh th\u1ee9c\u00a0 h\u1ecdc\">Th\u00f4ng tin v\u1ec1 h\u00ecnh th\u1ee9c\u00a0 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\/khoa-hoc-excel-ke-toan.html#CACH_DANG_KY_VA_NHAN_TAI_KHOAN_HOC\" title=\"C\u00c1CH \u0110\u0102NG K\u00dd V\u00c0 NH\u1eacN T\u00c0I KHO\u1ea2N H\u1eccC:\">C\u00c1CH \u0110\u0102NG K\u00dd V\u00c0 NH\u1eacN T\u00c0I KHO\u1ea2N H\u1eccC:<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"TONG_QUAN_VE_KHOA_HOC\"><\/span><span id=\"Chi_tiet_ve_khoa_hoc_Excel_co_ban\">T\u1ed4NG QUAN V\u1ec0 KH\u00d3A\u00a0 H\u1eccC:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Tai_sao_chung_ta_can_hoc_khoa_hoc_Excel_ke_toan_nay\"><\/span>T\u1ea1i sao ch\u00fang ta c\u1ea7n h\u1ecdc\u00a0 kh\u00f3a h\u1ecdc Excel k\u00ea\u0301 toa\u0301n na\u0300y<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u1ea1n l\u00e0 k\u1ebf to\u00e1n cho doanh nghi\u1ec7p v\u1eeba v\u00e0 nh\u1ecf, kho h\u00e0ng c\u1ee7a c\u00f4ng ty b\u1ea1n c\u1ea7n \u0111\u01b0\u1ee3c qu\u1ea3n l\u00fd. Doanh nghi\u1ec7p kh\u00f4ng c\u00f3 ph\u1ea7n m\u1ec1m chuy\u00ean d\u1ee5ng \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c qu\u1ea3n l\u00fd kho n\u00e0y? Trong tay b\u1ea1n ch\u1ec9 c\u00f3 Excel \u2013 v\u1edbi kho\u00e1 h\u1ecdc n\u00e0y, ch\u1ec9 c\u1ea7n Excel l\u00e0 b\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 t\u1ea1o ra cho m\u00ecnh m\u1ed9t ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd kho c\u1ef1c k\u00ec chuy\u00ean nghi\u1ec7p v\u00e0 \u0111\u00e1p \u1ee9ng y\u00eau c\u1ea7u qu\u1ea3n l\u00fd xu\u1ea5t nh\u1eadp t\u1ed3n, t\u1ea1o b\u00e1o c\u00e1o chi ti\u1ebft, b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p v\u1ec1 t\u00ecnh tr\u1ea1ng h\u00e0ng ho\u00e1 trong kho h\u00e0ng c\u1ee7a m\u00ecnh. V\u01a1\u0301i ba\u0300i vi\u00ea\u0301t na\u0300y, blog.hocexcel.online se\u0303 gi\u01a1\u0301i thi\u00ea\u0323u \u0111\u00ea\u0301n ca\u0301c ba\u0323n <a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-ke-toan.html\">kho\u0301a ho\u0323c Excel k\u00ea\u0301 toa\u0301n<\/a> v\u01a1\u0301i h\u01b0\u01a1\u0301ng d\u00e2\u0303n b\u01a1\u0309i chuy\u00ean gia v\u00ea\u0300 Excel ha\u0300ng \u0111\u00e2\u0300u ta\u0323i Vi\u00ea\u0323t Nam, se\u0303 mang \u0111\u00ea\u0301n cho ba\u0323n nh\u01b0\u0303ng ki\u00ea\u0301n th\u01b0\u0301c t\u00f4\u0301t nh\u00e2\u0301t \u0111\u00ea\u0309 a\u0301p du\u0323ng tha\u0300nh tha\u0323o trong c\u00f4ng vi\u00ea\u0323c.<\/p>\n<p><strong>Khi h\u1ecdc kh\u00f3a h\u1ecdc n\u00e0y b\u1ea1n s\u1ebd th\u1ea5y:<\/strong><\/p>\n<ul>\n<li>Tr\u1ef1c quan, d\u1ec5 h\u1ecdc,\u00a0 d\u1ec5 hi\u1ec3u<\/li>\n<li>Kh\u00e1i qu\u00e1t ki\u1ebfn th\u1ee9c theo h\u1ec7 th\u1ed1ng<\/li>\n<li>V\u1eeba h\u1ecdc, v\u1eeba luy\u1ec7n t\u1eadp v\u00e0 c\u00f3 th\u1ec3 v\u1eadn d\u1ee5ng ngay trong th\u1ef1c t\u1ebf<\/li>\n<li>D\u1ec5 d\u00e0ng t\u01b0\u01a1ng t\u00e1c v\u1edbi gi\u1ea3ng vi\u00ean v\u00e0 c\u00e1c h\u1ecdc vi\u00ean trong kh\u00f3a h\u1ecdc<\/li>\n<li>Kh\u00f4ng gi\u1edbi h\u1ea1n th\u1eddi gian\u00a0 h\u1ecdc, kh\u00f4ng c\u1ea7n t\u1edbi l\u1edbp h\u1ecdc v\u1eabn c\u00f3 th\u1ec3 h\u1ecdc\u00a0\u00a0\u0111\u01b0\u1ee3c.<\/li>\n<li>Ki\u1ebfn th\u1ee9c th\u01b0\u1eddng xuy\u00ean\u00a0\u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12102 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/khoa-hoc-excel-ke-toan.jpeg\" alt=\"Kho\u0301a ho\u0323c Excel k\u00ea\u0301 toa\u0301n Online\" width=\"600\" height=\"398\" title=\"khoa-hoc-excel-ke-toan\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Hieu_qua_dau_ra_cua_khoa_hoc\"><\/span><span id=\"Hieu_qua_dau_ra_cua_khoa_hoc\">Hi\u1ec7u qu\u1ea3\u00a0\u0111\u1ea7u ra c\u1ee7a kh\u00f3a h\u1ecdc<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Kh\u00f3a h\u1ecdc n\u00e0y cung c\u1ea5p\u00a0 cho b\u1ea1n nh\u1eefng ki\u1ebfn th\u1ee9c sau:<\/p>\n<ul>\n<li>\u0110\u1ea1t \u0111\u01b0\u1ee3c k\u1ef9 n\u0103ng s\u1eafp x\u1ebfp v\u00e0 t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u kho h\u00e0ng chuy\u00ean nghi\u1ec7p<\/li>\n<li>L\u1eadp b\u00e1o c\u00e1o chi ti\u1ebft v\u00e0 b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p v\u1ec1 c\u00e1c m\u1eb7t h\u00e0ng trong kho<\/li>\n<li>S\u1eed d\u1ee5ng k\u1ebft h\u1ee3p h\u00e0m v\u00e0 c\u00e1c c\u00f4ng c\u1ee5 Excel \u0111\u1ec3 gi\u1ea3i quy\u1ebft c\u00e1c nghi\u1ec7p v\u1ee5 li\u00ean quan \u0111\u1ebfn qu\u1ea3n l\u00fd kho<\/li>\n<li>N\u0103m \u0111\u01b0\u1ee3c ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n v\u1ec1 ph\u00e2n t\u00edch, thi\u1ebft k\u1ebf v\u00e0 th\u1ef1c hi\u1ec7n 1 ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd kho<\/li>\n<\/ul>\n<p>90% h\u1ecdc vi\u00ean sau khi h\u1ecdc xong kh\u00f3a h\u1ecdc n\u00e0y\u00a0\u0111\u1ec1u c\u00f3 th\u1ec3 t\u1ef1 tay x\u00e2y d\u1ef1ng ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd kho cho c\u00e1 nh\u00e2n.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"THONG_TIN_CHI_TIET_CUA_KHOA_HOC\"><\/span>TH\u00d4NG TIN\u00a0CHI TI\u1ebeT C\u1ee6A KH\u00d3A H\u1eccC:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Thong_tin_ve_giang_vien\"><\/span><span id=\"Giang_Vien\">Th\u00f4ng tin v\u1ec1 gi\u1ea3ng vi\u00ean<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u1ecd t\u00ean: D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n<\/p>\n<ul>\n<li>N\u01a1i c\u00f4ng t\u00e1c hi\u1ec7n t\u1ea1i: Gi\u1ea3ng vi\u00ean t\u1ea1i hocexcel.online<\/li>\n<li>T\u1eebng l\u00e0m k\u1ebf to\u00e1n qu\u1ea3n tr\u1ecb t\u1ea1i c\u00f4ng ty TNHH DTK\u2019Vina, tr\u1ef1c thu\u1ed9c t\u1eadp\u00a0\u0111o\u00e0n DEAHO, H\u00e0n Qu\u1ed1c.<\/li>\n<li>H\u01a1n 7 n\u0103m kinh nghi\u1ec7m l\u00e0m vi\u1ec7c v\u1edbi\u00a0excel trong l\u0129nh v\u1ef1c k\u1ebf to\u00e1n, t\u00e0i ch\u00ednh<\/li>\n<li>X\u00e2y d\u1ef1ng nhi\u1ec1u ph\u1ea7n m\u1ec1m\u00a0excel trong c\u00e1c l\u0129nh v\u1ef1c: K\u1ebf to\u00e1n kho, k\u1ebf to\u00e1n c\u00f4ng n\u1ee3, k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng\u2026 trong nhi\u1ec1u lo\u1ea1i h\u00ecnh doanh nghi\u1ec7p kh\u00e1c nhau.<\/li>\n<li>X\u00e2y d\u1ef1ng ph\u1ea7n m\u1ec1m\u00a0excel trong l\u0129nh v\u1ef1c t\u00e0i ch\u00ednh: l\u1eadp ph\u01b0\u01a1ng\u00a0\u00e1n kinh doanh, qu\u1ea3n tr\u1ecb d\u00f2ng ti\u1ec1n trong doanh nghi\u1ec7p\u2026<\/li>\n<li>T\u01b0 v\u1ea5n gi\u1ea3i ph\u00e1p ho\u00e0n thi\u1ec7n quy tr\u00ecnh qu\u1ea3n l\u00fd doanh nghi\u1ec7p,\u00a0\u00e1p d\u1ee5ng ph\u1ea7n m\u1ec1m\u00a0excel n\u00e2ng cao hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Giao_trinh_chi_tiet\"><\/span>Gi\u00e1o tr\u00ecnh chi ti\u1ebft<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>N\u1ed9i dung h\u1ed7 tr\u1ee3 kh\u00f3a h\u1ecdc<\/strong><\/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-508.gif\" title=\"ex101_92019-nho-508\"><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-214.gif\" title=\"vba101_92019-nho-214\"><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-508.gif\" title=\"ex101_92019-nho-508\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>B\u00e0i 1: Trailer gi\u1edbi thi\u1ec7u kh\u00f3a h\u1ecdc<\/p>\n<p>B\u00e0i 2: Download t\u00e0i li\u1ec7u k\u00e8m theo kho\u00e1 h\u1ecdc<\/p>\n<p>B\u00e0i 3: C\u00e1ch nh\u1eadn s\u1ef1 tr\u1ee3 gi\u00fap t\u1eeb gi\u1ea3ng vi\u00ean v\u00e0 th\u1ea3o lu\u1eadn<\/p>\n<p>\u00a0<\/p>\n<p><strong>Ph\u1ea7n\u00a01: T\u1ea1o danh m\u1ee5c h\u00e0ng ho\u00e1 trong kho<\/strong><\/p>\n<p>01 \u2013 Ta\u0323o danh mu\u0323c ha\u0300ng hoa\u0301<\/p>\n<p>02 \u2013 Ta\u0323o danh mu\u0323c ha\u0300ng hoa\u0301 Tra cu\u031b\u0301u tho\u0302ng tin<\/p>\n<p>03 \u2013 Ta\u0323o danh mu\u0323c ha\u0300ng hoa\u0301 Su\u031b\u0309 du\u0323ng Name \u0111o\u0323\u0302ng<\/p>\n<p>04 \u2013 Ta\u0323o danh mu\u0323c ha\u0300ng hoa\u0301 Xu\u031b\u0309 ly\u0301 vu\u0300ng tra cu\u031b\u0301u cu\u0309a VLOOKUP<\/p>\n<p>05 \u2013 Ta\u0323o danh mu\u0323c ha\u0300ng hoa\u0301 Xu\u031b\u0309 ly\u0301 VLOOKUP khi the\u0302m co\u0323\u0302t mo\u031b\u0301i<\/p>\n<p>06 \u2013 Ta\u0323o danh mu\u0323c ha\u0300ng hoa\u0301 xu\u031b\u0309 ly\u0301 VLOOKUP ke\u0302\u0301t ho\u031b\u0323p vlookup<\/p>\n<p>07 \u2013 Ta\u0323o danh mu\u0323c ha\u0300ng hoa\u0301 mo\u0323\u0302t so\u0302\u0301 lu\u031bu y\u0301 khi la\u0300m vie\u0323\u0302c vo\u031b\u0301i danh mu\u0323c ha\u0300ng hoa\u0301<\/p>\n<p>08 \u2013 Ta\u0323o danh mu\u0323c ha\u0300ng hoa\u0301 ba\u0301o hie\u0323\u0302u tru\u0300ng la\u0323\u0306p ma\u0303 ha\u0300ng<\/p>\n<p><strong>Ph\u1ea7n 02 \u2013 T\u1ea1o danh m\u1ee5c h\u00e0ng ho\u00e1 s\u1eed d\u1ee5ng VBA<\/strong><\/p>\n<p>09 \u2013 VBA Ta\u0323o danh mu\u0323c ha\u0300ng hoa\u0301 Ta\u0323o userform<\/p>\n<p>10 \u2013 VBA Ta\u0323o danh mu\u0323c ha\u0300ng hoa\u0301 \u0110a\u0323\u0306t te\u0302n cho controls va\u0300 su\u031b\u0309a \u0111i\u0323nh da\u0323ng so\u0302\u0301<\/p>\n<p>11 \u2013 VBA Ta\u0323o danh mu\u0323c ha\u0300ng hoa\u0301 ti\u0301nh toa\u0301n tha\u0300nh tie\u0302\u0300n tru\u031b\u0323c tie\u0302\u0301p tre\u0302n form<\/p>\n<p><span class=\"lecture_name\">12 \u2013 VBA Ta\u0323o danh mu\u0323c ha\u0300ng hoa\u0301 lu\u031bu y\u0301 khi nha\u0323\u0302p du\u031b\u0303 lie\u0323\u0302u tre\u0302n form<\/span><\/p>\n<p><span class=\"lecture_name\">13 \u2013 VBA Ta\u0323o danh mu\u0323c ha\u0300ng hoa\u0301 xu\u031b\u0309 ly\u0301 lo\u0302\u0303i khi textbox ro\u0302\u0303ng<\/span><\/p>\n<p><span class=\"lecture_name\">14 \u2013 VBA Ta\u0323o danh mu\u0323c ha\u0300ng hoa\u0301 kie\u0302\u0309m tra ma\u0303 \u0111a\u0303 co\u0301 trong kho hay chu\u031ba<\/span><\/p>\n<p><span class=\"lecture_name\">15 \u2013 VBA Ta\u0323o danh mu\u0323c ha\u0300ng hoa\u0301 kie\u0302\u0309m tra ma\u0303 ha\u0300ng \u0111a\u0303 co\u0301 trong kho hay chu\u031ba 02<\/span><\/p>\n<p><span class=\"lecture_name\">16 \u2013 VBA Ta\u0323o danh mu\u0323c ha\u0300ng hoa\u0301 xa\u0301c nha\u0323\u0302n nha\u0323\u0302p ha\u0300ng hoa\u0301 tha\u0300nh co\u0302ng<\/span><\/p>\n<p><span class=\"lecture_name\">17 \u2013 VBA Ta\u0323o danh mu\u0323c ha\u0300ng hoa\u0301 reset form nha\u0323\u0302p lie\u0323\u0302u<\/span><\/p>\n<p><span class=\"lecture_name\">18 \u2013 VBA Ta\u0323o danh mu\u0323c ha\u0300ng hoa\u0301 ta\u0323o nu\u0301t go\u0323i form tre\u0302n sheet<\/span><\/p>\n<p><span class=\"lecture_name\">19 \u2013 VBA Ta\u0323o danh mu\u0323c ha\u0300ng hoa\u0301 ta\u0323o form su\u031b\u0309a tho\u0302ng tin ha\u0300ng hoa\u0301<\/span><\/p>\n<p><span class=\"lecture_name\">20 \u2013 VBA Ta\u0323o danh mu\u0323c ha\u0300ng hoa\u0301 \u0111ie\u0302\u0300n tho\u0302ng tin cho combobox ma\u0303 ha\u0300ng<\/span><\/p>\n<p><span class=\"lecture_name\">21 \u2013 VBA Ta\u0323o danh mu\u0323c ha\u0300ng hoa\u0301 la\u0302\u0301y tho\u0302ng tin tu\u031b\u0300 sheet le\u0302n form theo ma\u0303 ha\u0300ng<\/span><\/p>\n<p><span class=\"lecture_name\">22 \u2013 VBA Ta\u0323o danh mu\u0323c ha\u0300ng hoa\u0301 ca\u0323\u0302p nha\u0323\u0302t tho\u0302ng tin ha\u0300ng hoa\u0301<\/span><\/p>\n<p><strong>Ph\u1ea7n 03 \u2013 T\u1ea1o phi\u1ebfu nh\u1eadp kho\u00a0<\/strong><\/p>\n<p>23 \u2013 Ta\u0323o PNK Ca\u0302\u0301u tru\u0301c PNK<\/p>\n<p>24 \u2013 Ta\u0323o PNK Thie\u0302\u0301t la\u0323\u0302p \u0111i\u0323nh da\u0323ng va\u0300 Data Validation cho PNK<\/p>\n<p><strong>Ph\u1ea7n 04 \u2013 T\u1ea1o b\u1ea3ng ghi s\u1ed5 <\/strong><\/p>\n<p>25 \u2013 Ta\u0323o ba\u0309ng ghi so\u0302\u0309 Thie\u0302\u0301t la\u0323\u0302p ca\u0302\u0301u tru\u0301c<\/p>\n<p>26 \u2013 Ta\u0323o ba\u0309ng ghi so\u0302\u0309 Ghi so\u0302\u0309 trong thu\u031b\u0323c te\u0302\u0301<\/p>\n<p><strong><span class=\"section_name\">Ph\u1ea7n 05 \u2013 Ghi d\u1eef li\u1ec7u t\u1eeb phi\u1ebfu nh\u1eadp kho v\u00e0o b\u1ea3ng ghi s\u1ed5\u00a0<\/span><\/strong><\/p>\n<p>27 \u2013 Ghi tu\u031b\u0300 PNK va\u0300o GHISO La\u0300m ba\u0306\u0300ng tay<\/p>\n<p>28 \u2013 Ghi tu\u031b\u0300 PNK va\u0300o GHISO La\u0300m ba\u0306\u0300ng Macro Recorder<\/p>\n<p>29 \u2013 Ghi tu\u031b\u0300 PNK va\u0300o GHISO Tinh chi\u0309nh Macro<\/p>\n<p>30 \u2013 Ghi tu\u031b\u0300 PNK va\u0300o GHISO Tinh chi\u0309nh macro 02<\/p>\n<p>31 \u2013 Ghi tu\u031b\u0300 PNK va\u0300o GHISO Tinh chi\u0309nh Macro 03<\/p>\n<p>32 \u2013 Ghi tu\u031b\u0300 PNK va\u0300o GHISO Nha\u0323\u0302p kho ba\u0306\u0300ng VBA<\/p>\n<p>33 \u2013 Ghi tu\u031b\u0300 PNK va\u0300o GHISO tho\u0302ng ba\u0301o tha\u0300nh co\u0302ng<\/p>\n<p>34 \u2013 Ghi tu\u031b\u0300 PNK va\u0300o GHISO kie\u0302\u0309m tra du\u031b\u0303 lie\u0323\u0302u<\/p>\n<p>35 \u2013 Ghi tu\u031b\u0300 PNK va\u0300o GHISO tho\u0302ng ba\u0301o phie\u0302\u0301u tru\u0300ng<\/p>\n<p>36 \u2013 Ghi tu\u031b\u0300 PNK va\u0300o GHISO kho\u0302ng cho nha\u0323\u0302p phie\u0302\u0301u tru\u0300ng<\/p>\n<p>37 \u2013 Ghi tu\u031b\u0300 PNK va\u0300o GHISO sinh so\u0302\u0301 phie\u0302\u0301u nha\u0323\u0302p kho tu\u031b\u0323 \u0111o\u0323\u0302ng<\/p>\n<p>38 \u2013 Ghi tu\u031b\u0300 PNK va\u0300o GHISO xoa\u0301 phie\u0302\u0301u<\/p>\n<p>39 \u2013 Ghi tu\u031b\u0300 PNK va\u0300o GHISO hoa\u0300n thie\u0323\u0302n PNK<\/p>\n<p><strong>Ph\u1ea7n 06 \u2013 T\u1ea1o phi\u1ebfu xu\u1ea5t kho <\/strong><\/p>\n<p>40 \u2013 Ta\u0323o PXK Thie\u0302\u0301t la\u0323\u0302p ca\u0302\u0301u tru\u0301c phie\u0302\u0301u<\/p>\n<p>41 \u2013 Ta\u0323o PXK Ti\u0301nh so\u0302\u0301 lu\u031bo\u031b\u0323ng to\u0302\u0300n trong kho<\/p>\n<p>42 \u2013 Ta\u0323o PXK Ti\u0301nh \u0111o\u031bn gia\u0301 ba\u0306\u0300ng phu\u031bo\u031bng pha\u0301p bi\u0300nh qua\u0302n<\/p>\n<p>43 \u2013 Ta\u0323o PXK Lu\u031bu PXK va\u0300o GHISO<\/p>\n<p>44 \u2013 Ta\u0323o PXK Hoa\u0300n tha\u0300nh PXK<\/p>\n<p><strong>Ph\u1ea7n 07 \u2013 T\u1ea1o b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p <\/strong><\/p>\n<p>45 \u2013 BCTH Ta\u0323o khung ba\u0301o ca\u0301o<\/p>\n<p>46 \u2013 BCTH Co\u0302ng thu\u031b\u0301c ti\u0301nh nha\u0323\u0302p kho, xua\u0302\u0301t kho<\/p>\n<p>47 \u2013 BCTH Co\u0302ng thu\u031b\u0301c to\u0302\u0300n \u0111a\u0302\u0300u, to\u0302\u0300n cuo\u0302\u0301i<\/p>\n<p>48 \u2013 BCTH Hoa\u0300n tha\u0300nh<\/p>\n<p><strong>Ph\u1ea7n\u00a008 \u2013 T\u1ea1o b\u00e1o c\u00e1o chi ti\u1ebft <\/strong><\/p>\n<p>49 \u2013 BCCT Ghi Macro \u0111e\u0302\u0309 thu\u031b\u0323c hie\u0323\u0302n vie\u0323\u0302c lo\u0323c trong ba\u0309ng ghi so\u0302\u0309<\/p>\n<p>50 \u2013 BCCT Vi\u0300 sao Autofilter lo\u0323c nga\u0300y tha\u0301ng kho\u0302ng cha\u0323y va\u0300 gia\u0309i pha\u0301p<\/p>\n<p>51 \u2013 BCCT Gia\u0309i pha\u0301p su\u031b\u0309 du\u0323ng Autofilter vo\u031b\u0301i du\u031b\u0303 lie\u0323\u0302u nga\u0300y tha\u0301ng<\/p>\n<p>52 \u2013 BCCT Ba\u0306\u0301t \u0111a\u0302\u0300u copy du\u031b\u0303 lie\u0323\u0302u cho ba\u0301o ca\u0301o chi tie\u0302\u0301t<\/p>\n<p>53 \u2013 BCCT a\u0302\u0309n ca\u0301c co\u0323\u0302t kho\u0302ng ca\u0302\u0300n thie\u0302\u0301t<\/p>\n<p>54 \u2013 BCCT Hoa\u0300n tha\u0300nh copy du\u031b\u0303 lie\u0323\u0302u sang BCCT<\/p>\n<p>55 \u2013 BCCT Xoa\u0301 du\u031b\u0303 lie\u0323\u0302u cu\u0303 trong BCCT<\/p>\n<p>56 \u2013 BCCT hoa\u0300n tha\u0300nh BCCT ba\u0300i ta\u0323\u0302p ve\u0302\u0300 nha\u0300<\/p>\n<p>57 \u2013 BCCT Su\u031b\u0309 du\u0323ng su\u031b\u0323 kie\u0323\u0302n \u0111e\u0302\u0309 ta\u0323o BCCT khi du\u031b\u0303 lie\u0323\u0302u thay \u0111o\u0302\u0309i<\/p>\n<p>58 \u2013 BCCT kho\u0302i phu\u0323c Ghi So\u0302\u0309<\/p>\n<p>59 \u2013 BCCT Hoa\u0300n thie\u0323\u0302n, ba\u0302\u0303y lo\u0302\u0303i nha\u0323\u0302p lie\u0323\u0302u nga\u0300y tha\u0301ng<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Thong_tin_ve_hinh_thuc_hoc\"><\/span><span id=\"Thong_tin_ve_hinh_thuc_hoc\">Th\u00f4ng tin v\u1ec1 h\u00ecnh th\u1ee9c\u00a0 h\u1ecdc<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<table style=\"width: 480px\">\n<tbody>\n<tr>\n<td style=\"width: 149px\">H\u00ecnh th\u1ee9c h\u1ecdc<\/td>\n<td style=\"width: 321px\">Online qua video, h\u1ed7 tr\u1ee3 qua\u00a0<a href=\"https:\/\/www.facebook.com\/groups\/ex101\/\" target=\"_blank\" rel=\"noopener noreferrer\">facebook group<\/a><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 149px\">S\u1ed1 video<\/td>\n<td style=\"width: 321px\">63\u00a0(s\u1ebd c\u1eadp nh\u1eadt th\u00eam video h\u00e0ng th\u00e1ng)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 149px\">T\u1ed5ng th\u1eddi l\u01b0\u1ee3ng<\/td>\n<td style=\"width: 321px\">300 ph\u00fat<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 149px\">Tr\u00ecnh \u0111\u1ed9<\/td>\n<td style=\"width: 321px\">Excel c\u01a1 b\u1ea3n, VBA c\u01a1 b\u1ea3n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span class=\"ez-toc-section\" id=\"CACH_DANG_KY_VA_NHAN_TAI_KHOAN_HOC\"><\/span><span id=\"Cach_dang_ky_va_nhan_tai_khoan_hoc\">C\u00c1CH \u0110\u0102NG K\u00dd V\u00c0 NH\u1eacN T\u00c0I KHO\u1ea2N H\u1eccC:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"http:\/\/ung-dung-quan-ly-kho-excel2.hocexcel.online\/\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2396\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/hdck_ex101.png\" width=\"740\" height=\"750\" title=\"hdck_ex101\"><\/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 ho\u1eb7c l\u00e0 Paypal, li\u00ean h\u1ec7\u00a0<strong>Facebook<\/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 width=\"566\">\n<tbody>\n<tr>\n<td>Ch\u1ee7 TK<\/td>\n<td><strong>Nguy\u1ec5n \u0110\u1ee9c Thanh<\/strong><\/td>\n<\/tr>\n<tr>\n<td>S\u1ed1 TK<\/td>\n<td><strong>99042443<\/strong><\/td>\n<\/tr>\n<tr>\n<td>Chi nh\u00e1nh<\/td>\n<td><strong>VPBank Th\u0103ng Long<\/strong><\/td>\n<\/tr>\n<tr>\n<td>N\u1ed9i dung chuy\u1ec3n kho\u1ea3n<\/td>\n<td>H\u1ecd T\u00ean b\u1ea1n \u2013 S\u1ed1 \u0111i\u1ec7n tho\u1ea1i b\u1ea1n \u2013 IM101<\/p>\n<p>VD: Nguyen Duc Thanh \u2013 &lt;s\u1ed1 \u0111i\u1ec7n tho\u1ea1i&gt;\u00a0\u2013\u00a0IM101<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>H\u1ecdc Ph\u00ed<\/td>\n<td><strong>799.000 VN\u0110*<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\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 IM101<\/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>N\u1ebfu b\u1ea1n c\u00f3 nhu c\u1ea7u \u0111\u0103ng k\u00fd kh\u00f3a\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/\">h\u1ecdc excel t\u1ea1i nh\u00e0<\/a>\u00a0c\u00f3 th\u1ec3 li\u00ean h\u1ec7 v\u1edbi ch\u00fang t\u00f4i qua hotline:\u00a0097797222 ho\u1eb7c c\u00f3 th\u1ec3 \u0111\u0103ng k\u00fd link \u1edf \u0111\u00e2y.<\/p>\n<p><a href=\"http:\/\/ung-dung-quan-ly-kho-excel2.hocexcel.online\/\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2903 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/register_now-2.png\" alt=\"\u0110\u0103ng k\u00ed kh\u00f3a h\u1ecdc excel online\" width=\"512\" height=\"100\" title=\"register_now-2\"><\/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<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-508.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5794,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5793","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\/5793","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=5793"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5793\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5794"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5793"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5793"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5793"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}