{"id":10861,"date":"2025-01-15T00:06:26","date_gmt":"2025-01-15T00:06:26","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/hoc-excel-ke-toan-khoa-hoc-ung-dung-excel-va-vba-vao-ke-toan-luong-nhan-su\/"},"modified":"2025-01-15T00:06:26","modified_gmt":"2025-01-15T00:06:26","slug":"hoc-excel-ke-toan-khoa-hoc-ung-dung-excel-va-vba-vao-ke-toan-luong-nhan-su","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/hoc-excel-ke-toan-khoa-hoc-ung-dung-excel-va-vba-vao-ke-toan-luong-nhan-su\/","title":{"rendered":"H\u1ecdc Excel k\u1ebf to\u00e1n \u2013 Kh\u00f3a h\u1ecdc \u1ee8ng d\u1ee5ng Excel v\u00e0 VBA v\u00e0o K\u1ebf to\u00e1n l\u01b0\u01a1ng, Nh\u00e2n s\u1ef1"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#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-6786fc0217ccc\" 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\/hoc-excel-ke-toan-khoa-hoc-ung-dung-excel-va-vba-vao-ke-toan-luong-nhan-su.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\/hoc-excel-ke-toan-khoa-hoc-ung-dung-excel-va-vba-vao-ke-toan-luong-nhan-su.html#Tai_sao_chung_ta_can_hoc_khoa_hoc_nay\" title=\"T\u1ea1i sao ch\u00fang ta c\u1ea7n h\u1ecdc\u00a0 kh\u00f3a h\u1ecdc\u00a0 n\u00e0y\">T\u1ea1i sao ch\u00fang ta c\u1ea7n h\u1ecdc\u00a0 kh\u00f3a h\u1ecdc\u00a0 n\u00e0y<\/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\/hoc-excel-ke-toan-khoa-hoc-ung-dung-excel-va-vba-vao-ke-toan-luong-nhan-su.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\/hoc-excel-ke-toan-khoa-hoc-ung-dung-excel-va-vba-vao-ke-toan-luong-nhan-su.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\/hoc-excel-ke-toan-khoa-hoc-ung-dung-excel-va-vba-vao-ke-toan-luong-nhan-su.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\/hoc-excel-ke-toan-khoa-hoc-ung-dung-excel-va-vba-vao-ke-toan-luong-nhan-su.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\/hoc-excel-ke-toan-khoa-hoc-ung-dung-excel-va-vba-vao-ke-toan-luong-nhan-su.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\/hoc-excel-ke-toan-khoa-hoc-ung-dung-excel-va-vba-vao-ke-toan-luong-nhan-su.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_nay\"><\/span>T\u1ea1i sao ch\u00fang ta c\u1ea7n h\u1ecdc\u00a0 kh\u00f3a h\u1ecdc\u00a0 n\u00e0y<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong c\u00f4ng vi\u1ec7c K\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng \/ H\u00e0nh ch\u00ednh nh\u00e2n s\u1ef1 th\u00ec vi\u1ec7c s\u1eed d\u1ee5ng\u00a0Excel l\u00e0 c\u1ef1c k\u1ef3 quan tr\u1ecdng. B\u1edfi n\u00f3 t\u0103ng hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c, t\u0103ng\u00a0\u0111\u1ed9 ch\u00ednh x\u00e1c, ti\u1ebft ki\u1ec7m th\u1eddi gian, gi\u1ea3m\u00a0\u00e1p l\u1ef1c c\u00f4ng vi\u1ec7c. Ngo\u00e0i ra\u00a0\u0111\u00e2y c\u0169ng l\u00e0 m\u1ed9t l\u0129nh v\u1ef1c nh\u1ea1y c\u1ea3m, li\u00ean quan\u00a0\u0111\u1ebfn l\u01b0\u01a1ng, ch\u1ebf\u00a0\u0111\u1ed9 c\u1ee7a ng\u01b0\u1eddi lao\u00a0\u0111\u1ed9ng,\u00a0\u1ea3nh h\u01b0\u1edfng tr\u1ef1c ti\u1ebfp t\u1edbi tinh th\u1ea7n l\u00e0m vi\u1ec7c v\u00e0 hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c.<\/p>\n<p>\u0110\u1eb7c th\u00f9 c\u00f4ng vi\u1ec7c n\u00e0y\u00a0\u0111\u00f2i h\u1ecfi ng\u01b0\u1eddi l\u00e0m vi\u1ec7c v\u1eeba ph\u1ea3i n\u1eafm r\u00f5 c\u00e1c quy\u00a0\u0111\u1ecbnh, quy ch\u1ebf trong doanh nghi\u1ec7p, n\u1eafm r\u00f5 c\u00e1c quy\u00a0\u0111\u1ecbnh trong lu\u1eadt lao\u00a0\u0111\u1ed9ng, lu\u1eadt b\u1ea3o hi\u1ec3m, lu\u1eadt thu\u1ebf thu nh\u1eadp c\u00e1 nh\u00e2n, v\u1eeba ph\u1ea3i t\u00ednh to\u00e1n m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c, ph\u00f9 h\u1ee3p v\u1edbi \u0111\u1eb7c \u0111i\u1ec3m ri\u00eang c\u1ee7a m\u1ed7i doanh nghi\u1ec7p.<\/p>\n<p>Do\u00a0\u0111\u00f3\u00a0\u0111\u00f2i h\u1ecfi ch\u00fang ta c\u1ea7n t\u1edbi m\u1ed9t ch\u01b0\u01a1ng tr\u00ecnh h\u1ecdc c\u00f3 th\u1ec3:<\/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<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>Ki\u1ebfn th\u1ee9c t\u1ed5ng qu\u00e1t: To\u00e0n b\u1ed9 quy tr\u00ecnh c\u00f4ng vi\u1ec7c qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1, ch\u1ea5m c\u00f4ng, t\u00ednh l\u01b0\u01a1ng trong c\u00e1c m\u00f4 h\u00ecnh doanh nghi\u1ec7p, v\u1edbi nhi\u1ec1u b\u1ed9 ph\u1eadn: H\u00e0nh ch\u00ednh, s\u1ea3n xu\u1ea5t.<\/li>\n<li>Ki\u1ebfn th\u1ee9c v\u1ec1 vi\u1ec7c qu\u1ea3n l\u00fd danh s\u00e1ch nh\u00e2n vi\u00ean v\u00e0 c\u00e1ch l\u1eadp c\u00e1c b\u00e1o c\u00e1o nh\u00e2n s\u1ef1 tr\u00ean\u00a0excel<\/li>\n<li>Ki\u1ebfn th\u1ee9c v\u1ec1 vi\u1ec7c x\u00e2y d\u1ef1ng b\u1ea3ng ch\u1ea5m c\u00f4ng, b\u1ea3ng l\u01b0\u01a1ng v\u00e0 c\u00e1c b\u00e1o c\u00e1o ti\u1ec1n l\u01b0\u01a1ng tr\u00ean\u00a0excel<\/li>\n<li>K\u1ef9 n\u0103ng s\u1eafp x\u1ebfp, x\u00e2y d\u1ef1ng b\u1ed1 c\u1ee5c d\u1eef li\u1ec7u trong excel<\/li>\n<li>K\u1ef9 n\u0103ng s\u1eed d\u1ee5ng c\u00e1c h\u00e0m, c\u00f4ng th\u1ee9c\u00a0excel li\u00ean quan t\u1edbi c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng \/ h\u00e0nh ch\u00ednh nh\u00e2n s\u1ef1<\/li>\n<li>K\u1ef9 n\u0103ng\u00a0\u00e1p d\u1ee5ng VBA\u00a0\u0111\u1ec3 t\u0103ng hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c<\/li>\n<li>K\u1ef9 n\u0103ng x\u1eed l\u00fd d\u1eef li\u1ec7u t\u00f9y theo y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c<\/li>\n<li>C\u00f4ng c\u1ee5 l\u00e0m vi\u1ec7c: T\u1ef1 t\u1ea1o\u00a0\u0111\u01b0\u1ee3c ph\u1ea7n m\u1ec1m b\u1eb1ng\u00a0excel \u0111\u1ec3 qu\u1ea3n l\u00fd c\u00f4ng vi\u1ec7c.Ngo\u00e0i ra h\u1ecdc vi\u00ean khi tham gia\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-ke-toan.html\">kho\u0301a h\u1ecdc Excel k\u1ebf to\u00e1n<\/a> s\u1ebd\u00a0\u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3 chia s\u1ebb kinh nghi\u1ec7m, c\u00e1ch\u00a0\u1ee9ng bi\u1ebfn v\u1edbi c\u00e1c v\u1ea5n\u00a0\u0111\u1ec1 ph\u00e1t sinh trong th\u1ef1c t\u1ebf c\u00f4ng vi\u1ec7c b\u1edfi c\u00e1c gi\u1ea3ng vi\u00ean c\u00f3 nhi\u1ec1u kinh nghi\u1ec7m trong l\u0129nh v\u1ef1c k\u1ebf to\u00e1n, h\u00e0nh ch\u00ednh nh\u00e2n s\u1ef1.<\/li>\n<\/ul>\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<p>B\u00e0i 1: Trailer gi\u1edbi thi\u1ec7u kh\u00f3a h\u1ecdc<\/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\/2025\/01\/ex101_92019-nho-230.gif\" title=\"ex101_92019-nho-230\"><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\/2025\/01\/vba101_92019-nho-26.gif\" title=\"vba101_92019-nho-26\"><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-230.gif\" title=\"ex101_92019-nho-230\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>B\u00e0i 2: C\u00e1ch x\u00e2y d\u1ef1ng MENU d\u1ea1ng WEB b\u1eb1ng VBA \u0111\u1ec3 qu\u1ea3n l\u00fd ch\u01b0\u01a1ng tr\u00ecnh<\/p>\n<p>B\u00e0i 3: T\u1ea3i t\u00e0i li\u1ec7u k\u00e8m theo kh\u00f3a h\u1ecdc<\/p>\n<p>B\u00e0i 4: Th\u1ea3o lu\u1eadn, g\u00f3p \u00fd v\u1ec1 n\u1ed9i dung kh\u00f3a h\u1ecdc<\/p>\n<p>B\u00e0i 5: B\u00e0i t\u1eadp \u1ee9ng d\u1ee5ng<\/p>\n<p><strong>Chuy\u00ean\u00a0\u0111\u1ec1 1: Qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 b\u1eb1ng\u00a0Excel v\u00e0 VBA<\/strong><\/p>\n<p>B\u00e0i 1: X\u00e2y d\u1ef1ng b\u1ed1 c\u1ee5c b\u1ea3ng danh s\u00e1ch nh\u00e2n vi\u00ean<\/p>\n<p>B\u00e0i 2: Gi\u1edbi thi\u1ec7u thao t\u00e1c th\u00eam nh\u00e2n vi\u00ean s\u1eed d\u1ee5ng VBA<\/p>\n<p>B\u00e0i 3: Thao t\u00e1c th\u00eam m\u1edbi nh\u00e2n vi\u00ean b\u1eb1ng VBA \u2013 Ph\u1ea7n 1<\/p>\n<p>B\u00e0i 4: Thao t\u00e1c th\u00eam m\u1edbi nh\u00e2n vi\u00ean b\u1eb1ng VBA \u2013 Ph\u1ea7n 2<\/p>\n<p>B\u00e0i 5: Thao t\u00e1c s\u1eeda nh\u00e2n vi\u00ean b\u1eb1ng VBA \u2013 Ph\u1ea7n 1<\/p>\n<p>B\u00e0i 6: Thao t\u00e1c s\u1eeda nh\u00e2n vi\u00ean b\u1eb1ng VBA \u2013 Ph\u1ea7n 2<\/p>\n<p>B\u00e0i 7: S\u1eafp x\u1ebfp th\u1ee9 t\u1ef1 trong danh s\u00e1ch nh\u00e2n vi\u00ean theo Option Button c\u00f3 s\u1eed d\u1ee5ng VBA<\/p>\n<p>B\u00e0i 8: X\u00f3a d\u00f2ng tr\u1ed1ng trong danh s\u00e1ch nh\u00e2n vi\u00ean b\u1eb1ng VBA<\/p>\n<p>B\u00e0i 9: L\u01b0u \u00fd v\u1ec1 vi\u1ec7c s\u1eed d\u1ee5ng VBA trong qu\u1ea3n l\u00fd danh s\u00e1ch nh\u00e2n vi\u00ean<\/p>\n<p>B\u00e0i 10: Theo d\u00f5i sinh nh\u1eadt nh\u00e2n vi\u00ean<\/p>\n<p>B\u00e0i 11: X\u00e2y d\u1ef1ng b\u1ed1 c\u1ee5c H\u1ee3p \u0111\u1ed3ng lao \u0111\u1ed9ng<\/p>\n<p>B\u00e0i 12: Qu\u1ea3n l\u00fd n\u1ed9i dung h\u1ee3p \u0111\u1ed3ng lao \u0111\u1ed9ng<\/p>\n<p><strong>Chuy\u00ean\u00a0\u0111\u1ec1 2: C\u00e1c n\u1ed9i dung v\u1ec1 ch\u1ea5m c\u00f4ng v\u00e0 t\u00ednh c\u00f4ng tr\u00ean\u00a0Excel<\/strong><\/p>\n<p>B\u00e0i 1: T\u00ecm hi\u1ec3u c\u1ea5u tr\u00fac b\u1ea3ng ch\u1ea5m c\u00f4ng c\u01a1 b\u1ea3n<\/p>\n<p>B\u00e0i 2: Thi\u1ebft l\u1eadp ng\u00e0y trong b\u1ea3ng ch\u1ea5m c\u00f4ng<\/p>\n<p>B\u00e0i 3: C\u00e1ch t\u00ednh c\u00f4ng theo k\u00fd hi\u1ec7u \u0111\u01a1n<\/p>\n<p>B\u00e0i 4: C\u00e1ch t\u00ednh c\u00f4ng theo k\u00fd hi\u1ec7u k\u00e9p<\/p>\n<p>B\u00e0i 5: C\u00e1ch t\u00ednh c\u00f4ng \u0111i l\u00e0m mu\u1ed9n<\/p>\n<p>B\u00e0i 6: H\u01b0\u1edbng d\u1eabn c\u00e1ch ch\u1ea5m c\u00f4ng v\u00e0 t\u00ednh c\u00f4ng<\/p>\n<p>B\u00e0i 7: X\u00e2y d\u1ef1ng b\u1ed1 c\u1ee5c b\u00e0ng ch\u1ea5m c\u00f4ng s\u1ea3n xu\u1ea5t<\/p>\n<p>B\u00e0i 8: C\u00e1ch t\u00ednh c\u00f4ng \u1edf b\u1ea3ng ch\u1ea5m c\u00f4ng s\u1ea3n xu\u1ea5t<\/p>\n<p>B\u00e0i 9: L\u01b0u n\u1ed9i dung b\u1ea3ng ch\u1ea5m c\u00f4ng<\/p>\n<p>B\u00e0i 10: T\u1ea1o m\u1edbi b\u1ea3ng ch\u1ea5m c\u00f4ng khi thay \u0111\u1ed5i th\u00e1ng ch\u1ea5m c\u00f4ng<\/p>\n<p>B\u00e0i 11: H\u01b0\u1edbng d\u1eabn x\u1eed l\u00fd n\u1ed9i dung ch\u1ea5m c\u00f4ng tr\u00ean m\u00e1y ch\u1ea5m c\u00f4ng<\/p>\n<p>B\u00e0i 12: H\u01b0\u1edbng d\u1eabn x\u1eed l\u00fd n\u1ed9i dung ch\u1ea5m c\u00f4ng tr\u00ean m\u00e1y ch\u1ea5m c\u00f4ng \u2013 B\u00e0i 2<\/p>\n<p>B\u00e0i 13: T\u1ed5ng k\u1ebft chuy\u00ean \u0111\u1ec1 b\u1ea3ng ch\u1ea5m c\u00f4ng<\/p>\n<p><strong>Chuy\u00ean\u00a0\u0111\u1ec1 3: C\u00e1c n\u1ed9i duung v\u1ec1 b\u1ea3ng l\u01b0\u01a1ng v\u00e0 t\u00ednh l\u01b0\u01a1ng tr\u00ean\u00a0Excel<\/strong><\/p>\n<p>B\u00e0i 1: X\u00e2y d\u1ef1ng c\u1ea5u tr\u00fac b\u1ea3ng l\u01b0\u01a1ng<\/p>\n<p>B\u00e0i 2: X\u00e2y d\u1ef1ng c\u00e1c ch\u1ec9 ti\u00eau t\u00ednh l\u01b0\u01a1ng<\/p>\n<p>B\u00e0i 3: X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c t\u00ednh l\u01b0\u01a1ng theo s\u1ed1 c\u00f4ng l\u00e0m vi\u1ec7c<\/p>\n<p>B\u00e0i 4: X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c t\u00ednh thu nh\u1eadp kh\u00e1c trong b\u1ea3ng l\u01b0\u01a1ng<\/p>\n<p>B\u00e0i 5: X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c t\u00ednh c\u00e1c kho\u1ea3n tr\u00edch theo l\u01b0\u01a1ng<\/p>\n<p>B\u00e0i 6: Ho\u00e0n thi\u1ec7n b\u1ea3ng l\u01b0\u01a1ng<\/p>\n<p>B\u00e0i 7: S\u1eed d\u1ee5ng VBA \u0111\u1ec3 l\u01b0u b\u1ea3ng l\u01b0\u01a1ng<\/p>\n<p><strong>Chuy\u00ean\u00a0\u0111\u1ec1 4: X\u00e2y d\u1ef1ng c\u00e1c b\u00e1o c\u00e1o v\u1ec1 ti\u1ec1n l\u01b0\u01a1ng, nh\u00e2n s\u1ef1<\/strong><\/p>\n<p>B\u00e0i 1: X\u00e2y d\u1ef1ng b\u00e1o c\u00e1o chi ph\u00ed l\u01b0\u01a1ng<\/p>\n<p>B\u00e0i 2: X\u00e2y d\u1ef1ng b\u1ea3ng thanh to\u00e1n l\u01b0\u01a1ng qua ng\u00e2n h\u00e0ng<\/p>\n<p>B\u00e0i 3: X\u00e2y d\u1ef1ng phi\u1ebfu l\u01b0\u01a1ng c\u00e1 nh\u00e2n<\/p>\n<p>B\u00e0i 4: X\u00e2y d\u1ef1ng b\u00e1o c\u00e1o chi ph\u00ed b\u1ea3o hi\u1ec3m<\/p>\n<p>B\u00e0i 5: X\u00e2y d\u1ef1ng b\u00e1o c\u00e1o thu\u1ebf thu nh\u1eadp c\u00e1 nh\u00e2n t\u1ea1m tr\u00edch n\u1ed9p h\u00e0ng qu\u00fd<\/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<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 149px\">S\u1ed1 video<\/td>\n<td style=\"width: 321px\">42 (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\">320 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:\/\/excel-ke-toan-tien-luong2.hocexcel.online\/\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2396\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/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 TL01VD: Nguyen Duc Thanh \u2013 &lt;s\u1ed1 \u0111i\u1ec7n tho\u1ea1i&gt;\u00a0\u2013 TL01<\/td>\n<\/tr>\n<tr>\n<td>H\u1ecdc Ph\u00ed<\/td>\n<td><strong>1.199.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 TL01<\/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>\u00a0<\/p>\n<p><a href=\"http:\/\/excel-ke-toan-tien-luong2.hocexcel.online\/\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2903 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/register_now.png\" alt=\"\u0110\u0103ng k\u00ed kh\u00f3a h\u1ecdc excel online\" width=\"512\" height=\"100\" title=\"register_now\"><\/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\/2025\/01\/ex101_92019-nho-230.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10862,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10861","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\/10861","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=10861"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10861\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10862"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10861"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10861"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10861"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}