{"id":11649,"date":"2025-01-15T04:47:18","date_gmt":"2025-01-15T04:47:18","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/thiet-ke-so-quy-tien-mat-tren-excel\/"},"modified":"2025-01-15T04:47:18","modified_gmt":"2025-01-15T04:47:18","slug":"thiet-ke-so-quy-tien-mat-tren-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/thiet-ke-so-quy-tien-mat-tren-excel\/","title":{"rendered":"Thi\u1ebft k\u1ebf S\u1ed5 qu\u1ef9 ti\u1ec1n m\u1eb7t tr\u00ean Excel"},"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-67873dd502bb8\" 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\/thiet-ke-quy-tien-mat-tren-excel.html#QUAN_LY_SO_QUY_TIEN_MAT_BANG_EXCEL\" title=\"QU\u1ea2N L\u00dd S\u1ed4 QU\u1ef8 TI\u1ec0N M\u1eb6T B\u1eb0NG EXCEL\">QU\u1ea2N L\u00dd S\u1ed4 QU\u1ef8 TI\u1ec0N M\u1eb6T B\u1eb0NG EXCEL<\/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\/thiet-ke-quy-tien-mat-tren-excel.html#THIET_KE_THEO_YEU_CAU_TU_DONG_HOA_BANG_VBA\" title=\"THI\u1ebeT K\u1ebe THEO Y\u00caU C\u1ea6U, T\u1ef0 \u0110\u1ed8NG HO\u00c1 B\u1eb0NG VBA\">THI\u1ebeT K\u1ebe THEO Y\u00caU C\u1ea6U, T\u1ef0 \u0110\u1ed8NG HO\u00c1 B\u1eb0NG VBA<\/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\/thiet-ke-quy-tien-mat-tren-excel.html#THIET_KE_PHAN_MEM_CUNG_HEO\" title=\"THI\u1ebeT K\u1ebe PH\u1ea6N M\u1ec0M C\u00d9NG H.E.O\">THI\u1ebeT K\u1ebe PH\u1ea6N M\u1ec0M C\u00d9NG H.E.O<\/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\/thiet-ke-quy-tien-mat-tren-excel.html#MO_HINH_MAU_%E2%80%93_THAM_KHAO\" title=\"M\u00d4 H\u00ccNH M\u1eaaU \u2013 THAM KH\u1ea2O\">M\u00d4 H\u00ccNH M\u1eaaU \u2013 THAM KH\u1ea2O<\/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\/thiet-ke-quy-tien-mat-tren-excel.html#CHI_PHI_DAT_HANG\" title=\"CHI PH\u00cd \u0110\u1eb6T H\u00c0NG\">CHI PH\u00cd \u0110\u1eb6T H\u00c0NG<\/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\/thiet-ke-quy-tien-mat-tren-excel.html#QUYEN_LOI_KHI_DAT_HANG\" title=\"QUY\u1ec0N L\u1ee2I KHI \u0110\u1eb6T H\u00c0NG\">QUY\u1ec0N L\u1ee2I KHI \u0110\u1eb6T H\u00c0NG<\/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\/thiet-ke-quy-tien-mat-tren-excel.html#YEU_CAU_VE_PHIA_KHACH_HANG\" title=\"Y\u00caU C\u1ea6U V\u1ec0 PH\u00cdA KH\u00c1CH H\u00c0NG\">Y\u00caU C\u1ea6U V\u1ec0 PH\u00cdA KH\u00c1CH H\u00c0NG<\/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\/thiet-ke-quy-tien-mat-tren-excel.html#DAT_HANG_THIET_KE\" title=\"\u0110\u1eb6T H\u00c0NG THI\u1ebeT K\u1ebe\">\u0110\u1eb6T H\u00c0NG THI\u1ebeT K\u1ebe<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"QUAN_LY_SO_QUY_TIEN_MAT_BANG_EXCEL\"><\/span><strong>QU\u1ea2N L\u00dd S\u1ed4 QU\u1ef8 TI\u1ec0N M\u1eb6T B\u1eb0NG EXCEL<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"THIET_KE_THEO_YEU_CAU_TU_DONG_HOA_BANG_VBA\"><\/span><strong>THI\u1ebeT K\u1ebe THEO Y\u00caU C\u1ea6U, T\u1ef0 \u0110\u1ed8NG HO\u00c1 B\u1eb0NG VBA<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u00a0<\/p>\n<p>Gi\u1ea3i quy\u1ebft c\u00e1c y\u00eau c\u1ea7u: Theo d\u00f5i c\u00e1c nghi\u1ec7p v\u1ee5 Thu, Chi, T\u1ea1m \u1ee9ng, Ho\u00e0n t\u1ea1m \u1ee9ng. T\u1ef1 \u0111\u1ed9ng l\u01b0u tr\u1eef v\u00e0 ki\u1ec3m tra ch\u1ee9ng t\u1eeb, tr\u00e1nh nh\u1ea7m l\u1eabn, thi\u1ebfu s\u00f3t.<\/p>\n<p>Thi\u1ebft k\u1ebf linh ho\u1ea1t, theo y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c: C\u00e1 nh\u00e2n, c\u00f4ng ty, qu\u1ea3n l\u00fd chi ph\u00ed theo nhi\u1ec1u lo\u1ea1i \u0111\u1ed1i t\u01b0\u1ee3ng. K\u1ebft n\u1ed1i nhi\u1ec1u ph\u1ea7n h\u00e0nh k\u1ebf to\u00e1n kh\u00e1c \u0111\u1ec3 thu\u1eadn ti\u1ec7n trong c\u00f4ng vi\u1ec7c: C\u00f4ng n\u1ee3, b\u00e1n h\u00e0ng\u2026 B\u00e1o c\u00e1o theo \u0111\u1ed1i t\u01b0\u1ee3ng v\u00e0 th\u1eddi gian tu\u1ef3 \u00fd. \u0110a d\u1ea1ng c\u00e1c lo\u1ea1i b\u00e1o c\u00e1o theo y\u00eau c\u1ea7u thi\u1ebft k\u1ebf.<\/p>\n<p>Khi ph\u1ea7n m\u1ec1m vi\u1ebft s\u1eb5n kh\u00f4ng \u0111\u00fang \u00fd mu\u1ed1n, khi nghi\u1ec7p v\u1ee5 ph\u1ee9c t\u1ea1p \u0111\u00f2i h\u1ecfi ph\u1ea3i theo d\u00f5i ri\u00eang tr\u00ean excel, khi c\u00f4ng ty kh\u00f4ng trang b\u1ecb ph\u1ea7n m\u1ec1m m\u00e0 ch\u1ec9 cho b\u1ea1n s\u1eed d\u1ee5ng m\u1ed7i excel, khi b\u1ea1n kh\u00f4ng bi\u1ebft l\u1eadp tr\u00ecnh, thi\u1ebft k\u1ebf ph\u1ea7n m\u1ec1m nh\u01b0ng v\u1eabn mu\u1ed1n c\u00f3 1 ph\u1ea7n m\u1ec1m thi\u1ebft k\u1ebf ri\u00eang cho m\u00ecnh\u2026 \u0111\u00e2y l\u00e0 khi b\u1ea1n nh\u1eadn \u0111\u01b0\u1ee3c c\u00e2u tr\u1ea3 l\u1eddi.<\/p>\n<p>T\u0103ng t\u1ed1c \u0111\u1ed9 l\u00e0m vi\u1ec7c nh\u1edd quy tr\u00ecnh ho\u00e0n thi\u1ec7n, gi\u1ea3m th\u1eddi gian x\u1eed l\u00fd c\u00f4ng vi\u1ec7c, b\u00e1o c\u00e1o theo \u00fd mu\u1ed1n b\u1ea5t c\u1ee9 khi n\u00e0o c\u00f3 y\u00eau c\u1ea7u =&gt; T\u0103ng hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c. L\u1ee3i \u00edch cho ch\u00ednh b\u1ea1n v\u00e0 cho c\u1ea3 c\u00f4ng ty c\u1ee7a b\u1ea1n.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"THIET_KE_PHAN_MEM_CUNG_HEO\"><\/span><strong>THI\u1ebeT K\u1ebe PH\u1ea6N M\u1ec0M C\u00d9NG H.E.O<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ed9i ng\u0169 thi\u1ebft k\u1ebf v\u1eefng v\u00e0ng ki\u1ebfn th\u1ee9c v\u00e0 nhi\u1ec1u kinh nghi\u1ec7m trong vi\u1ec7c thi\u1ebft k\u1ebf v\u00e0 l\u1eadp tr\u00ecnh VBA. B\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 y\u00ean t\u00e2m v\u1ec1 ch\u1ea5t l\u01b0\u1ee3ng s\u1ea3n ph\u1ea9m v\u00e0 uy t\u00edn c\u1ee7a ch\u00fang t\u00f4i.<\/p>\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-316.gif\" title=\"ex101_92019-nho-316\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Th\u00f4ng tin r\u00f5 r\u00e0ng, \u0111\u1ea7y \u0111\u1ee7 v\u00e0 c\u00e1ch l\u00e0m vi\u1ec7c c\u1edfi m\u1edf. Gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 s\u1ea3n ph\u1ea9m v\u00e0 s\u1eed d\u1ee5ng m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng, thu\u1eadn l\u1ee3i.<\/p>\n<p>\u0110\u1ecba ch\u1ec9 tin c\u1eady, m\u1ee9c gi\u00e1 h\u1ee3p l\u00fd. \u0110\u1eb7c bi\u1ec7t b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c nhi\u1ec1u \u01b0u \u0111\u00e3i khi \u0111\u00e3 t\u1eebng tham gia c\u00e1c kho\u00e1 h\u1ecdc online c\u00f9ng H.E.O<\/p>\n<p>\u00a0<\/p>\n<h2><span class=\"ez-toc-section\" id=\"MO_HINH_MAU_%E2%80%93_THAM_KHAO\"><\/span><strong>M\u00d4 H\u00ccNH M\u1eaaU \u2013 THAM KH\u1ea2O<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u00e2y l\u00e0 m\u00f4 h\u00ecnh m\u1eabu \u0111\u1ec3 c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o, gi\u00fap cho b\u1ea1n c\u00f3 c\u00e1i nh\u00ecn c\u1ee5 th\u1ec3 h\u01a1n v\u1ec1 s\u1ea3n ph\u1ea9m:<\/p>\n<ol>\n<li><strong>X\u00e1c \u0111\u1ecbnh n\u1ed9i dung v\u00e0 c\u00e1c c\u00f4ng vi\u1ec7c ph\u1ea3i l\u00e0m<\/strong><\/li>\n<\/ol>\n<table width=\"642\">\n<tbody>\n<tr>\n<td width=\"138\"><strong>N\u1ed9i dung ch\u00ednh<\/strong><\/td>\n<td width=\"222\"><strong>Di\u1ec5n gi\u1ea3i<\/strong><\/td>\n<td width=\"282\"><strong>M\u00f4 t\u1ea3<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"138\"><strong>1. Danh m\u1ee5c \u0111\u1ed1i t\u01b0\u1ee3ng<\/strong><\/td>\n<td width=\"222\">T\u1eadp h\u1ee3p c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng c\u1ea7n theo d\u00f5i<\/td>\n<td width=\"282\">Tr\u00ean 1 Sheet ho\u1eb7c nhi\u1ec1u Sheet<\/td>\n<\/tr>\n<tr>\n<td width=\"138\"><strong>2. L\u1eadp c\u00e1c phi\u1ebfu<\/strong><\/td>\n<td width=\"222\">T\u1ea1o m\u1edbi c\u00e1c phi\u1ebfu: Thu, chi, t\u1ea1m \u1ee9ng theo c\u00f4ng vi\u1ec7c ph\u00e1t sinh.<\/p>\n<p>L\u1eadp phi\u1ebfu ho\u00e0n \u1ee9ng \u0111\u1ec3 th\u1ef1c hi\u1ec7n ho\u00e0n \u1ee9ng cho c\u00e1c phi\u1ebfu t\u1ea1m \u1ee9ng.<\/p>\n<\/td>\n<td width=\"282\">M\u1ed7i phi\u1ebfu l\u1eadp tr\u00ean 1 m\u1eabu ri\u00eang, c\u00f3 th\u1ec3 l\u01b0u l\u1ea1i phi\u1ebfu v\u00e0o b\u1ea3ng l\u01b0u. S\u1ed1 phi\u1ebfu \u0111\u01b0\u1ee3c t\u1ea1o t\u1ef1 \u0111\u1ed9ng.<\/p>\n<p>Ki\u1ec3m so\u00e1t c\u00e1c l\u1ed7i, kh\u00f4ng l\u01b0u tr\u00f9ng phi\u1ebfu<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"138\"><strong>3. B\u1ea3ng k\u00ea ph\u00e1t sinh<\/strong><\/td>\n<td width=\"222\">L\u00e0 n\u01a1i t\u1eadp h\u1ee3p\u00a0n\u1ed9i dung ph\u00e1t sinh, l\u01b0u tr\u1eef v\u00e0 b\u1ea3o v\u1ec7 th\u00f4ng tin.<\/td>\n<td width=\"282\">N\u1ed9i dung c\u00e1c phi\u1ebfu \u0111\u01b0\u1ee3c l\u01b0u m\u1ed9t c\u00e1ch t\u1ef1 \u0111\u1ed9ng v\u00e0o b\u1ea3ng k\u00ea.<\/td>\n<\/tr>\n<tr>\n<td width=\"138\"><strong>4. L\u1eadp b\u00e1o c\u00e1o<\/strong><\/td>\n<td width=\"222\">L\u1eadp c\u00e1c b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p, b\u00e1o c\u00e1o chi ti\u1ebft theo y\u00eau c\u1ea7u qu\u1ea3n l\u00fd<\/td>\n<td width=\"282\">N\u1ed9i dung b\u00e1o c\u00e1o t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt khi thay \u0111\u1ed5i c\u00e1c ti\u00eau ch\u00ed b\u00e1o c\u00e1o: Th\u1eddi gian, \u0111\u1ed1i t\u01b0\u1ee3ng\u2026<\/td>\n<\/tr>\n<tr>\n<td width=\"138\"><strong>5. In phi\u1ebfu<\/strong><\/td>\n<td width=\"222\">In c\u00e1c phi\u1ebfu Thu, chi theo y\u00eau c\u1ea7u<\/td>\n<td width=\"282\">Ki\u1ec3m so\u00e1t vi\u1ec7c in ch\u1ee9ng t\u1eeb. Theo d\u00f5i phi\u1ebfu \u0111\u00e3 in \/ ch\u01b0a in<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>\u00a0<\/strong><\/p>\n<ol start=\"2\">\n<li><strong>X\u00e2y d\u1ef1ng n\u1ed9i dung (c\u00f3 th\u1ec3 b\u1ea5m v\u00e0o d\u00f2ng ch\u1eef \u0111\u1ec3 hi\u1ec7n ra \u1ea3nh cho g\u1ecdn \u2013 c\u00e1i n\u00e0y em xem c\u00f3 l\u00e0m \u0111\u01b0\u1ee3c kh\u00f4ng)<\/strong><\/li>\n<\/ol>\n<ul>\n<li>Menu \u0111\u1ec3 qu\u1ea3n l\u00fd to\u00e0n b\u1ed9 ch\u01b0\u01a1ng tr\u00ecnh<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-8052 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/pic3_menu.png\" width=\"940\" height=\"610\" title=\"pic3_menu\"><\/p>\n<ul>\n<li>Danh m\u1ee5c \u0111\u1ed1i t\u01b0\u1ee3ng<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7972 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/pic1_danhmuc.jpg\" width=\"678\" height=\"789\" title=\"pic1_danhmuc\"><\/p>\n<ul>\n<li>L\u1eadp c\u00e1c phi\u1ebfu<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7996 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/pic5_lap_pthu-1024x502-1.png\" width=\"1024\" height=\"502\" title=\"pic5_lap_pthu-1024x502-1\"><\/p>\n<ul>\n<li>B\u1ea3ng k\u00ea l\u01b0u tr\u1eef n\u1ed9i dung c\u00e1c phi\u1ebfu<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7973 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/pic2_bangke-1024x369-1.png\" width=\"1024\" height=\"369\" title=\"pic2_bangke-1024x369-1\"><\/p>\n<ul>\n<li>B\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7994 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/pic6_bcth_01-1.png\" width=\"1015\" height=\"394\" title=\"pic6_bcth_01-1\"><\/p>\n<ul>\n<li>B\u00e1o c\u00e1o chi ti\u1ebft<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7975 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/pic6_bcth_01.png\" width=\"1010\" height=\"402\" title=\"pic6_bcth_01\"><\/p>\n<ul>\n<li>In phi\u1ebfu<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7976 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/pic7_inpthu-1024x689-1.png\" width=\"1024\" height=\"689\" title=\"pic7_inpthu-1024x689-1\"><\/p>\n<p>\u00a0<\/p>\n<p>B\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i file d\u00f9ng th\u1eed t\u1ea1i \u0111\u1ecba ch\u1ec9: <a href=\"http:\/\/bit.ly\/2u8Mul7\">http:\/\/bit.ly\/2u8Mul7<\/a><\/p>\n<p>\u00a0<\/p>\n<h2><span class=\"ez-toc-section\" id=\"CHI_PHI_DAT_HANG\"><\/span><strong>CHI PH\u00cd \u0110\u1eb6T H\u00c0NG<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>Kho\u00e1 VBA (m\u1eb7c \u0111\u1ecbnh, \u0111\u1ec3 b\u1ea3o v\u1ec7 quy\u1ec1n t\u00e1c gi\u1ea3 thi\u1ebft k\u1ebf)<\/li>\n<li>N\u1ed9i dung c\u01a1 b\u1ea3n gi\u1ed1ng nh\u01b0 m\u00f4 h\u00ecnh m\u1eabu: 800.000 \u0111\/file (c\u00f3 th\u1ec3 d\u00f9ng c\u00e1c ch\u01b0\u01a1ng tr\u00ecnh \u01b0u \u0111\u00e3i \u0111\u1ec3 gi\u1ea3m gi\u00e1, t\u1ed1i thi\u1ec3u l\u00e0 600.000\u0111\/file)<\/li>\n<li>V\u00ec thi\u1ebft k\u1ebf theo y\u00eau c\u1ea7u n\u00ean chi ph\u00ed c\u00f3 th\u1ec3 thay \u0111\u1ed5i tu\u1ef3 theo t\u00ednh ph\u1ee9c t\u1ea1p c\u1ee7a y\u00eau c\u1ea7u. Ch\u00fang t\u00f4i s\u1ebd c\u0103n c\u1ee9 theo n\u1ed9i dung y\u00eau c\u1ea7u c\u1ee7a b\u1ea1n \u0111\u1ec3 b\u00e1o gi\u00e1 c\u1ee5 th\u1ec3.<\/li>\n<li>Chi ph\u00ed tr\u1ecdn g\u00f3i, kh\u00f4ng ph\u00e1t sinh th\u00eam trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c.<\/li>\n<li>Kh\u00f4ng kho\u00e1 VBA (m\u00e3 ngu\u1ed3n m\u1edf): + 50% gi\u00e1 tr\u1ecb file \u0111\u1eb7t h\u00e0ng<\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<h2><span class=\"ez-toc-section\" id=\"QUYEN_LOI_KHI_DAT_HANG\"><\/span><strong>QUY\u1ec0N L\u1ee2I KHI \u0110\u1eb6T H\u00c0NG<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>B\u1ea3o m\u1eadt th\u00f4ng tin kh\u00e1ch h\u00e0ng.<\/li>\n<li>B\u1ea3o h\u00e0nh tr\u1ecdn \u0111\u1eddi v\u1edbi c\u00e1c v\u1ea5n \u0111\u1ec1 x\u1ea3y ra do l\u1ed7i thi\u1ebft k\u1ebf, l\u1eadp tr\u00ecnh<\/li>\n<li>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng chi ti\u1ebft v\u00e0 nhanh ch\u00f3ng<\/li>\n<li>T\u00edch lu\u1ef9 cho \u0111\u01a1n h\u00e0ng ti\u1ebfp theo: B\u1ea1n \u0111\u01b0\u1ee3c t\u00edch lu\u1ef9 10% gi\u00e1 tr\u1ecb \u0111\u01a1n h\u00e0ng \u0111\u00e3 \u0111\u1eb7t, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng cho \u0111\u01a1n h\u00e0ng ti\u1ebfp theo<\/li>\n<\/ul>\n<p><strong>Quy\u1ec1n l\u1ee3i v\u1edbi kh\u00e1ch h\u00e0ng s\u1eed d\u1ee5ng m\u00e3 ngu\u1ed3n m\u1edf (b\u1ed5 sung th\u00eam ngo\u00e0i c\u00e1c quy\u1ec1n l\u1ee3i \u0111\u00e3 n\u00eau \u1edf tr\u00ean):<\/strong><\/p>\n<ul>\n<li>Gi\u1ea3i th\u00edch n\u1ed9i dung code, c\u00f4ng th\u1ee9c, h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong ch\u01b0\u01a1ng tr\u00ecnh n\u1ebfu c\u00f3 th\u1eafc m\u1eafc<\/li>\n<li>T\u01b0 v\u1ea5n c\u00e1ch l\u00e0m \u0111\u1ec3 c\u00f3 th\u1ec3 t\u1ef1 s\u00e1ng t\u1ea1o, l\u00e0m ch\u1ee7 ho\u00e0n to\u00e0n ch\u01b0\u01a1ng tr\u00ecnh.<\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<h2><span class=\"ez-toc-section\" id=\"YEU_CAU_VE_PHIA_KHACH_HANG\"><\/span><strong>Y\u00caU C\u1ea6U V\u1ec0 PH\u00cdA KH\u00c1CH H\u00c0NG<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>Ch\u01b0\u01a1ng tr\u00ecnh ch\u1ec9 s\u1eed d\u1ee5ng tr\u00ean Microsoft Office phi\u00ean b\u1ea3n 2010 tr\u1edf l\u00ean (c\u00e1c phi\u00ean b\u1ea3n 2007, 2003 kh\u00f4ng s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c)<\/li>\n<li>Thanh to\u00e1n 30% khi \u0111\u1eb7t h\u00e0ng (\u0111\u1eb7t c\u1ecdc). S\u1ed1 c\u00f2n l\u1ea1i thanh to\u00e1n khi ho\u00e0n th\u00e0nh ch\u01b0\u01a1ng tr\u00ecnh.<\/li>\n<li>Vi\u1ec7c s\u1eed d\u1ee5ng m\u00e3 ngu\u1ed3n m\u1edf nh\u1eb1m m\u1ee5c \u0111\u00edch gi\u00fap kh\u00e1ch h\u00e0ng t\u1ef1 h\u1ecdc v\u00e0 l\u00e0m ch\u1ee7 \u0111\u01b0\u1ee3c ch\u01b0\u01a1ng tr\u00ecnh do m\u00ecnh \u0111\u1eb7t h\u00e0ng. Nghi\u00eam c\u1ea5m s\u1eed d\u1ee5ng v\u00e0o m\u1ee5c \u0111\u00edch th\u01b0\u01a1ng m\u1ea1i.<\/li>\n<\/ul>\n<p><strong>\u00a0<\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"DAT_HANG_THIET_KE\"><\/span><strong>\u0110\u1eb6T H\u00c0NG THI\u1ebeT K\u1ebe<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u1ecd t\u00ean:<\/p>\n<p>Ng\u00e0y sinh:<\/p>\n<p>Email li\u00ean h\u1ec7:<\/p>\n<p>S\u0110T li\u00ean h\u1ec7:<\/p>\n<p>N\u1ed9i dung y\u00eau c\u1ea7u:<\/p>\n<p>\u00a0<\/p>\n<p>\u0110\u1ecba ch\u1ec9 nh\u1eadn m\u00e3 k\u00edch ho\u1ea1t:<\/p>\n<p>M\u1ecdi th\u00f4ng tin v\u00e0 c\u00e2u h\u1ecfi xin li\u00ean h\u1ec7 email: <strong>quan@hocexcel.online<\/strong> \u0111\u1ec3 \u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3.<\/p>\n<p>\u00a0<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<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-316.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11650,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11649","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\/11649","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=11649"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11649\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11650"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11649"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11649"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11649"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}