{"id":8422,"date":"2024-12-22T14:30:52","date_gmt":"2024-12-22T14:30:52","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/10-buoi-hoc-xay-dung-phan-mem-quan-ly-kho-trong-excel\/"},"modified":"2024-12-22T14:30:52","modified_gmt":"2024-12-22T14:30:52","slug":"10-buoi-hoc-xay-dung-phan-mem-quan-ly-kho-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/10-buoi-hoc-xay-dung-phan-mem-quan-ly-kho-trong-excel\/","title":{"rendered":"10 bu\u1ed5i h\u1ecdc x\u00e2y d\u1ef1ng ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd kho trong Excel"},"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-6768229b418c5\" 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\/10-buoi-hoc-xay-dung-phan-mem-quan-ly-kho-trong-excel.html#Gioi_thieu_ve_khoa_hoc\" title=\"Gi\u1edbi thi\u1ec7u v\u1ec1 kho\u00e1 h\u1ecdc:\">Gi\u1edbi thi\u1ec7u v\u1ec1 kho\u00e1 h\u1ecdc:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/10-buoi-hoc-xay-dung-phan-mem-quan-ly-kho-trong-excel.html#Doi_tuong_huong_den\" title=\"\u0110\u1ed1i t\u01b0\u1ee3ng h\u01b0\u1edbng \u0111\u1ebfn:\">\u0110\u1ed1i t\u01b0\u1ee3ng h\u01b0\u1edbng \u0111\u1ebfn:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/10-buoi-hoc-xay-dung-phan-mem-quan-ly-kho-trong-excel.html#Trinh_do_toi_thieu_de_tham_gia_khoa_hoc\" title=\"Tr\u00ecnh \u0111\u1ed3 t\u1ed1i thi\u1ec3u \u0111\u1ec3 tham gia kho\u00e1 h\u1ecdc:\">Tr\u00ecnh \u0111\u1ed3 t\u1ed1i thi\u1ec3u \u0111\u1ec3 tham gia kho\u00e1 h\u1ecdc:<\/a><\/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\/10-buoi-hoc-xay-dung-phan-mem-quan-ly-kho-trong-excel.html#Ky_nang_hoc_duoc_sau_khoa_hoc\" title=\"K\u1ef9 n\u0103ng h\u1ecdc \u0111\u01b0\u1ee3c sau kho\u00e1 h\u1ecdc:\">K\u1ef9 n\u0103ng h\u1ecdc \u0111\u01b0\u1ee3c sau kho\u00e1 h\u1ecdc:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/10-buoi-hoc-xay-dung-phan-mem-quan-ly-kho-trong-excel.html#Kien_thuc_duoc_su_dung_trong_khoa_hoc\" title=\"Ki\u1ebfn th\u1ee9c \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong kho\u00e1 h\u1ecdc:\">Ki\u1ebfn th\u1ee9c \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong kho\u00e1 h\u1ecdc:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/10-buoi-hoc-xay-dung-phan-mem-quan-ly-kho-trong-excel.html#Lo_trinh_khoa_hoc\" title=\"L\u1ed9 tr\u00ecnh kho\u00e1 h\u1ecdc:\">L\u1ed9 tr\u00ecnh kho\u00e1 h\u1ecdc:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/10-buoi-hoc-xay-dung-phan-mem-quan-ly-kho-trong-excel.html#Vi_sao_ban_nen_tham_gia_khoa_hoc_nay\" title=\"V\u00ec sao b\u1ea1n n\u00ean tham gia kho\u00e1 h\u1ecdc n\u00e0y?\">V\u00ec sao b\u1ea1n n\u00ean tham gia kho\u00e1 h\u1ecdc n\u00e0y?<\/a><\/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\/10-buoi-hoc-xay-dung-phan-mem-quan-ly-kho-trong-excel.html#Khong_phai_khoa_hoc_thong_thuong\" title=\"Kh\u00f4ng ph\u1ea3i kho\u00e1 h\u1ecdc th\u00f4ng th\u01b0\u1eddng:\">Kh\u00f4ng ph\u1ea3i kho\u00e1 h\u1ecdc th\u00f4ng th\u01b0\u1eddng:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/10-buoi-hoc-xay-dung-phan-mem-quan-ly-kho-trong-excel.html#Ai_la_nguoi_huong_dan_ban_trong_khoa_hoc_nay\" title=\"Ai l\u00e0 ng\u01b0\u1eddi h\u01b0\u1edbng d\u1eabn b\u1ea1n trong kho\u00e1 h\u1ecdc n\u00e0y:\">Ai l\u00e0 ng\u01b0\u1eddi h\u01b0\u1edbng d\u1eabn b\u1ea1n trong kho\u00e1 h\u1ecdc n\u00e0y:<\/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-10\" href=\"https:\/\/blog.hocexcel.online\/10-buoi-hoc-xay-dung-phan-mem-quan-ly-kho-trong-excel.html#Demo_phan_mem_sau_khoa_hoc\" title=\"Demo ph\u1ea7n m\u1ec1m sau kho\u00e1 h\u1ecdc:\">Demo ph\u1ea7n m\u1ec1m sau kho\u00e1 h\u1ecdc:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/10-buoi-hoc-xay-dung-phan-mem-quan-ly-kho-trong-excel.html#Thiet_bi_can_co_khi_tham_gia_khoa_hoc\" title=\"Thi\u1ebft b\u1ecb c\u1ea7n c\u00f3 khi tham gia kho\u00e1 h\u1ecdc\">Thi\u1ebft b\u1ecb c\u1ea7n c\u00f3 khi tham gia kho\u00e1 h\u1ecdc<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/10-buoi-hoc-xay-dung-phan-mem-quan-ly-kho-trong-excel.html#Thoi_gian_hoc\" title=\"Th\u1eddi gian h\u1ecdc:\">Th\u1eddi gian 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-13\" href=\"https:\/\/blog.hocexcel.online\/10-buoi-hoc-xay-dung-phan-mem-quan-ly-kho-trong-excel.html#Thong_tin_chuyen_khoan\" title=\"Th\u00f4ng tin chuy\u1ec3n kho\u1ea3n\">Th\u00f4ng tin chuy\u1ec3n kho\u1ea3n<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Gioi_thieu_ve_khoa_hoc\"><\/span><strong>Gi\u1edbi thi\u1ec7u v\u1ec1 kho\u00e1 h\u1ecdc:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nh\u1eefng ki\u1ebfn th\u1ee9c trong kho\u00e1 h\u1ecdc d\u00e0i 10 bu\u1ed5i n\u00e0y s\u1ebd gi\u00fap b\u1ea1n t\u1ef1 gi\u1ea3i quy\u1ebft nh\u1eefng v\u1ea5n \u0111\u1ec1 trong x\u00e2y d\u1ef1ng ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd kho ph\u00f9 h\u1ee3p cho doanh nghi\u1ec7p v\u1eeba v\u00e0 nh\u1ecf.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Doi_tuong_huong_den\"><\/span>\u0110\u1ed1i t\u01b0\u1ee3ng h\u01b0\u1edbng \u0111\u1ebfn:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ed1i t\u01b0\u1ee3ng h\u01b0\u1edbng \u0111\u1ebfn c\u1ee7a kho\u00e1 h\u1ecdc n\u00e0y kh\u00f4ng gi\u1edbi h\u1ea1n nh\u01b0ng \u0111\u1eb7c bi\u1ec7t ph\u00f9 h\u1ee3p\u00a0v\u1edbi c\u00e1c b\u1ea1n sinh vi\u00ean n\u0103m cu\u1ed1i chuy\u00ean ng\u00e0nh k\u1ebf to\u00e1n (h\u1ec7 \u0111\u1ea1i h\u1ecdc ho\u1eb7c cao \u0111\u1eb3ng), nh\u1eefng ng\u01b0\u1eddi m\u1edbi \u0111i l\u00e0m v\u00e0 c\u00f4ng vi\u1ec7c li\u00ean quan nhi\u1ec1u \u0111\u1ebfn kho v\u00e0 qu\u1ea3n l\u00fd h\u00e0ng ho\u00e1.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Trinh_do_toi_thieu_de_tham_gia_khoa_hoc\"><\/span>Tr\u00ecnh \u0111\u1ed3 t\u1ed1i thi\u1ec3u \u0111\u1ec3 tham gia kho\u00e1 h\u1ecdc:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 tham gia kho\u00e1 h\u1ecdc 1 c\u00e1ch t\u1ed1t nh\u1ea5t, b\u1ea1n c\u1ea7n bi\u1ebft s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\" target=\"_blank\">Excel c\u01a1 b\u1ea3n<\/a>, n\u1ebfu bi\u1ebft l\u1eadp tr\u00ecnh VBA trong Excel l\u00e0 1 l\u1ee3i th\u1ebf.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ky_nang_hoc_duoc_sau_khoa_hoc\"><\/span>K\u1ef9 n\u0103ng h\u1ecdc \u0111\u01b0\u1ee3c sau kho\u00e1 h\u1ecdc:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ol>\n<li>S\u1eafp x\u1ebfp v\u00e0 t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u chuy\u00ean nghi\u1ec7p trong Excel<\/li>\n<li>L\u1eadp b\u00e1o c\u00e1o b\u00e1n h\u00e0ng<\/li>\n<li>S\u1eed d\u1ee5ng 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>S\u1eed d\u1ee5ng VBA c\u0103n b\u1ea3n<\/li>\n<li>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, qu\u1ea3n l\u00fd b\u00e1n h\u00e0ng<\/li>\n<\/ol>\n<h2><span class=\"ez-toc-section\" id=\"Kien_thuc_duoc_su_dung_trong_khoa_hoc\"><\/span>Ki\u1ebfn th\u1ee9c \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong kho\u00e1 h\u1ecdc:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ol>\n<li>S\u1eed d\u1ee5ng k\u1ebft h\u1ee3p c\u00e1c h\u00e0m c\u1ee7a Excel: COUNTIF, VLOOKUP, IF, SUMPRODUCT<\/li>\n<li>T\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u trong Excel hi\u1ec7u qu\u1ea3<\/li>\n<li>S\u1eed d\u1ee5ng c\u00e1c ch\u1ee9c n\u0103ng: \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n (Conditional Formatting), ki\u1ec3m tra d\u1eef li\u1ec7u (Data Validation), l\u1ecdc d\u1eef li\u1ec7u (Data Filter), qu\u1ea3n l\u00fd v\u00e0 s\u1eed d\u1ee5ng Name Range.<\/li>\n<li>L\u1eadp tr\u00ecnh c\u01a1 b\u1ea3n trong VBA: l\u1eadp tr\u00ecnh Form, trao \u0111\u1ed5i d\u1eef li\u1ec7u gi\u1eefa sheet v\u00e0 VBA<\/li>\n<li>N\u1eafm \u0111\u01b0\u1ee3c l\u00fd thuy\u1ebft v\u1ec1 vi\u1ec7c qu\u1ea3n l\u00fd kho \u0111\u1ec3 t\u1ef1 c\u1ea3i ti\u1ebfn v\u00e0 ph\u00e1t tri\u1ec3n ph\u1ea7n m\u1ec1m sau kho\u00e1 h\u1ecdc.<\/li>\n<\/ol>\n<h2><span class=\"ez-toc-section\" id=\"Lo_trinh_khoa_hoc\"><\/span>L\u1ed9 tr\u00ecnh kho\u00e1 h\u1ecdc:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<table style=\"height: 196px;width: 467px\">\n<tbody>\n<tr>\n<td style=\"width: 73px\">B\u00e0i 1<\/td>\n<td style=\"width: 380px\">T\u1ea1o v\u00e0 qu\u1ea3n l\u00fd danh m\u1ee5c h\u00e0ng ho\u00e1 (2 bu\u1ed5i)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 73px\">B\u00e0i 2<\/td>\n<td style=\"width: 380px\">T\u1ea1o v\u00e0 qu\u1ea3n l\u00fd b\u1ea3ng ghi s\u1ed5, s\u1ed5 kho (2 bu\u1ed5i)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 73px\">B\u00e0i 3<\/td>\n<td style=\"width: 380px\">T\u1ea1o l\u1eadp b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p (1 bu\u1ed5i)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 73px\">B\u00e0i 4<\/td>\n<td style=\"width: 380px\">T\u1ea1o l\u1eadp b\u00e1o c\u00e1o chi ti\u1ebft (1 bu\u1ed5i)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 73px\">B\u00e0i 5<\/td>\n<td style=\"width: 380px\">\u00c1p d\u1ee5ng VBA \u0111\u1ec3 c\u1ea3i ti\u1ebfn ph\u1ea7n m\u1ec1m (2 bu\u1ed5i)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 73px\">B\u00e0i 6<\/td>\n<td style=\"width: 380px\">\u00d4n t\u1eadp v\u00e0 ki\u1ec3m tra k\u1ebft qu\u1ea3 h\u1ecdc t\u1eadp (1 bu\u1ed5i)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 73px\">B\u00e0i 7<\/td>\n<td style=\"width: 380px\">Gi\u1ea3i \u0111\u00e1p th\u1eafc m\u1eafc v\u00e0 t\u1ed5ng k\u1ebft kho\u00e1 h\u1ecdc (1 bu\u1ed5i)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span class=\"ez-toc-section\" id=\"Vi_sao_ban_nen_tham_gia_khoa_hoc_nay\"><\/span>V\u00ec sao b\u1ea1n n\u00ean tham gia kho\u00e1 h\u1ecdc n\u00e0y?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ol>\n<li>Sau kh\u00f3a h\u1ecdc, h\u1ecdc vi\u00ean c\u00f3 \u0111\u01b0\u1ee3c ki\u1ebfn th\u1ee9c: Hi\u1ec3u bi\u1ebft v\u1ec1 c\u00f4ng vi\u1ec7c qu\u1ea3n l\u00fd kho, n\u00e2ng cao k\u1ef9 n\u0103ng b\u1ea3n th\u00e2n.<\/li>\n<li>Nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng v\u00e0o c\u00f4ng vi\u1ec7c: \u0110\u1ecbnh h\u01b0\u1edbng t\u01b0 duy trong c\u00f4ng vi\u1ec7c, r\u00fat ng\u1eafn th\u1eddi gian v\u00e0 t\u0103ng hi\u1ec7u qu\u1ea3 trong c\u00f4ng vi\u1ec7c, t\u1ea1o l\u1ee3i th\u1ebf khi xin vi\u1ec7c.<\/li>\n<li>V\u1ec1 l\u00e2u d\u00e0i: L\u00e0 ki\u1ebfn th\u1ee9c n\u1ec1n t\u1ea3ng \u0111\u1ec3 l\u00e0m c\u00e1c c\u00f4ng vi\u1ec7c v\u1edbi chuy\u00ean m\u00f4n kh\u00e1c: qu\u1ea3n l\u00fd c\u00f4ng n\u1ee3, qu\u1ef9, ti\u1ec1n l\u01b0\u01a1ng\u2026 N\u00e2ng cao k\u1ef9 n\u0103ng s\u1eafp x\u1ebfp v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u, k\u1ef9 n\u0103ng l\u1eadp tr\u00ecnh trong excel. \u0110\u00e2y l\u00e0 k\u1ef9 n\u0103ng c\u1ea7n thi\u1ebft v\u00e0 c\u00f3 \u00edch l\u1edbn trong m\u1ecdi c\u00f4ng vi\u1ec7c.<\/li>\n<\/ol>\n<h2><span class=\"ez-toc-section\" id=\"Khong_phai_khoa_hoc_thong_thuong\"><\/span>Kh\u00f4ng ph\u1ea3i kho\u00e1 h\u1ecdc th\u00f4ng th\u01b0\u1eddng:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ol>\n<li>T\u00ednh t\u01b0\u01a1ng t\u00e1c cao gi\u1eefa ng\u01b0\u1eddi h\u1ecdc v\u00e0 ng\u01b0\u1eddi d\u1ea1y: h\u1ecdc vi\u00ean, h\u1ecdc v\u00e0 th\u1ef1c h\u00e0nh theo video, m\u1ed7i tu\u1ea7n h\u1ecdc vi\u00ean s\u1ebd c\u00f3 2 gi\u1edd \u0111\u1ec3 trao \u0111\u1ed5i v\u1edbi gi\u1ea3ng vi\u00ean (th\u1eddi gian s\u1ebd \u0111\u01b0\u1ee3c th\u00f4ng b\u00e1o tr\u00ean <a href=\"https:\/\/www.facebook.com\/groups\/imk101\" target=\"_blank\">facebook group<\/a> c\u1ee7a ri\u00eang kho\u00e1 h\u1ecdc)<\/li>\n<li>N\u1ed9i dung ki\u1ebfn th\u1ee9c h\u1eefu \u00edch v\u00e0 m\u1edbi l\u1ea1, ch\u01b0a c\u00f3 ai d\u1ea1y, ph\u00f9 h\u1ee3p v\u1edbi nhu c\u1ea7u c\u1ee7a \u0111\u1ed1i t\u01b0\u1ee3ng h\u1ecdc vi\u00ean<\/li>\n<li>K\u1ebft h\u1ee3p gi\u1eefa: T\u00ecm hi\u1ec3u b\u1ea3n ch\u1ea5t v\u1ea5n \u0111\u1ec1 + Kh\u01a1i g\u1ee3i s\u1ef1 s\u00e1ng t\u1ea1o + T\u00ednh t\u1ef1 h\u1ecdc c\u1ee7a h\u1ecdc vi\u00ean<\/li>\n<\/ol>\n<h2><span class=\"ez-toc-section\" id=\"Ai_la_nguoi_huong_dan_ban_trong_khoa_hoc_nay\"><\/span>Ai l\u00e0 ng\u01b0\u1eddi h\u01b0\u1edbng d\u1eabn b\u1ea1n trong kho\u00e1 h\u1ecdc n\u00e0y:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>Gi\u1ea3ng vi\u00ean: Anh Qu\u00e2n:<\/strong><\/p>\n<ul>\n<li>K\u1ebf to\u00e1n kho t\u1ea1i c\u00f4ng ty CP Qu\u1ed1c t\u1ebf Sao Th\u1ee7y (kho m\u1ef9 ph\u1ea9m)<\/li>\n<li>K\u1ebf to\u00e1n kho t\u1ea1i chu\u1ed7i c\u1eeda h\u00e0ng c\u00e0 ph\u00ea Twitter Beans<\/li>\n<li>T\u01b0 v\u1ea5n, thi\u1ebft k\u1ebf, x\u00e2y d\u1ef1ng h\u1ec7 th\u1ed1ng k\u1ebf to\u00e1n tr\u00ean excel t\u1ea1i c\u00f4ng ty CP truy\u1ec1n th\u00f4ng PSC Media<\/li>\n<li>K\u1ebf to\u00e1n t\u1ea1i c\u00f4ng ty TNHH DTK\u2019VINA (H\u00e0n Qu\u1ed1c)<\/li>\n<\/ul>\n<p><strong>Tr\u1ee3 gi\u1ea3ng: Nguy\u1ec5n \u0110\u1ee9c Thanh:<\/strong><\/p>\n<ul>\n<li>Tr\u1ee3 l\u00fd qu\u1ea3n l\u00fd d\u1ef1 \u00e1n t\u1ea1i \u0110\u1ea1i h\u1ecdc Frankfurt, \u0110\u1ee9c<\/li>\n<li>Senior IT Consultant t\u1ea1i KPMG \u0110\u1ee9c, chuy\u00ean t\u01b0 v\u1ea5n gi\u1ea3i ph\u00e1p qu\u1ea3n l\u00fd doanh nghi\u1ec7p b\u1eb1ng h\u1ec7 th\u1ed1ng ERP SAP, t\u1ef1 \u0111\u1ed9ng ho\u00e1 SAP<\/li>\n<li>Gi\u1ea3ng vi\u00ean Excel Online v\u1edbi 5 n\u0103m kinh nghi\u1ec7m v\u1edbi nhi\u1ec1u kho\u00e1 h\u1ecdc Excel v\u00e0 VBA\u00a0v\u00e0 h\u1ec7 th\u1ed1ng H\u1ecdc Excel Online g\u1ed3m c\u00f3 (<a href=\"https:\/\/www.facebook.com\/www.hocexcel.online\/\" target=\"_blank\">Fanpage<\/a>, <a href=\"https:\/\/www.facebook.com\/groups\/hocexcel.online\/\" target=\"_blank\">Group<\/a>, <a href=\"https:\/\/www.youtube.com\/c\/hocexcelonline\" target=\"_blank\">K\u00eanh YouTube<\/a>)<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Demo_phan_mem_sau_khoa_hoc\"><\/span>Demo ph\u1ea7n m\u1ec1m sau kho\u00e1 h\u1ecdc:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/xIEAGLbcORM\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p><strong>Gi\u1edbi thi\u1ec7u th\u00eam v\u1ec1 kho\u00e1 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-771.gif\" title=\"ex101_92019-nho-771\"><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-343.gif\" title=\"vba101_92019-nho-343\"><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-771.gif\" title=\"ex101_92019-nho-771\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/ZU8-dXYsK4Q\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<blockquote>\n<p style=\"text-align: left\">Xem ngay:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-ke-toan.html\">kho\u0301a h\u1ecdc Excel k\u1ebf to\u00e1n online<\/a><\/p>\n<\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"Thiet_bi_can_co_khi_tham_gia_khoa_hoc\"><\/span>Thi\u1ebft b\u1ecb c\u1ea7n c\u00f3 khi tham gia kho\u00e1 h\u1ecdc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Khi tham gia kho\u00e1 h\u1ecdc n\u00e0y, b\u1ea1n c\u1ea7n c\u00f3 laptop ch\u1ea1y Windows c\u00e0i s\u1eb5n Excel phi\u00ean b\u1ea3n 2010 tr\u1edf l\u00ean.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Thoi_gian_hoc\"><\/span>Th\u1eddi gian h\u1ecdc:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Kho\u00e1 h\u1ecdc \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf theo module, th\u1eddi gian h\u1ecdc 4 tu\u1ea7n, qua c\u00e1c videos \u0111\u01b0\u1ee3c chu\u1ea9n b\u1ecb s\u1eb5n. H\u1ecdc vi\u00ean h\u1ecdc online tu\u1ef3 theo th\u1eddi gian c\u1ee7a m\u00ecnh. M\u1ed7i tu\u1ea7n c\u00f3 2 ti\u1ebfng trao \u0111\u1ed5i tr\u1ef1c ti\u1ebfp v\u1ec1 ki\u1ebfn th\u1ee9c chuy\u00ean m\u00f4n v\u1edbi gi\u1ea3ng vi\u00ean. K\u00e8m theo kho\u00e1 h\u1ecdc c\u00f3 <a href=\"https:\/\/www.facebook.com\/groups\/IMK101\/\" target=\"_blank\">nh\u00f3m h\u1ed7 tr\u1ee3 tr\u1ef1c tuy\u1ebfn qua facebook<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Thong_tin_chuyen_khoan\"><\/span>Th\u00f4ng tin chuy\u1ec3n kho\u1ea3n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<table style=\"height: 236px;width: 629px\">\n<tbody>\n<tr>\n<td style=\"width: 182px\">Ch\u1ee7 t\u00e0i kho\u1ea3n<\/td>\n<td style=\"width: 433px\">Nguy\u1ec5n \u0110\u1ee9c Thanh<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 182px\">S\u1ed1 t\u00e0i kho\u1ea3n<\/td>\n<td style=\"width: 433px\">99042443<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 182px\">Chi nh\u00e1nh<\/td>\n<td style=\"width: 433px\">VPBank Th\u0103ng Long<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 182px\">N\u1ed9i dung chuy\u1ec3n kho\u1ea3n<\/td>\n<td style=\"width: 433px\">H\u1ecd T\u00ean c\u1ee7a b\u1ea1n \u2013 S\u1ed1 \u0111i\u1ec7n tho\u1ea1i c\u1ee7a b\u1ea1n \u2013 IMK01<\/p>\n<p>VD: Nguyen Duc Thanh \u2013 &lt;s\u1ed1 \u0111i\u1ec7n tho\u1ea1i&gt;\u00a0\u2013 IMK01<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 182px\">S\u1ed1 ti\u1ec1n<\/td>\n<td style=\"width: 433px\">800.000 VN\u0110*<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>* N\u1ebfu mua k\u00e8m v\u1edbi kho\u00e1 <a href=\"http:\/\/www.hocexcel.online\/vba101-landing.html\" target=\"_blank\">VBA101 \u2013 VBA c\u01a1 b\u1ea3n<\/a> =&gt; Gi\u00e1 cho 2 kho\u00e1: 1.400k VN\u0110<\/p>\n<p>* N\u1ebfu mua k\u00e8m v\u1edbi kho\u00e1 <a href=\"http:\/\/www.hocexcel.online\/vba101-landing.html\" target=\"_blank\">VBA101<\/a> v\u00e0 <a href=\"http:\/\/www.hocexcel.online\/ex101\" target=\"_blank\">EX101<\/a> =&gt; Gi\u00e1 cho 3 kho\u00e1: 1.800k VN\u0110<\/p>\n<p>Sau khi chuy\u1ec3n ti\u00ean, b\u1ea1n nh\u1eafn th\u00f4ng tin email cho <a href=\"http:\/\/m.me\/www.hocexcel.online\" target=\"_blank\"><strong>FanPage<\/strong><\/a> \u0111\u1ec3 \u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3 t\u1ea1o t\u00e0i kho\u1ea3n h\u1ecd<\/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-771.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8423,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8422","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\/8422","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=8422"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8422\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8423"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8422"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8422"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8422"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}