{"id":13095,"date":"2023-11-29T09:48:15","date_gmt":"2023-11-29T09:48:15","guid":{"rendered":"https:\/\/thuvienxaydung.com.vn\/?p=13095"},"modified":"2023-12-07T07:12:47","modified_gmt":"2023-12-07T07:12:47","slug":"combo-8-khoa-hoc-tinh-hoc-van-phong-tu-co-ban-den-nang-cao","status":"publish","type":"post","link":"https:\/\/tailieuxaydung.net\/?p=13095","title":{"rendered":"Combo 8 kh\u00f3a h\u1ecdc tinh h\u1ecdc v\u0103n ph\u00f2ng t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao ch\u1ec9 v\u1edbi 99k"},"content":{"rendered":"

Microsoft Excel\u00a0<\/b>\u0111\u01b0\u1ee3c coi l\u00e0 m\u1ed9t trong nh\u1eefng\u00a0c\u00f4<\/span>ng c\u1ee5 tin h\u1ecdc v\u0103n ph\u00f2ng m\u1ea1nh m\u1ebd v\u00e0 ph\u1ed5 bi\u1ebfn nh\u1ea5t to\u00e0n c\u1ea7u hi\u1ec7n nay, b\u1eb1ng c\u00e1c\u00a0c\u00f4<\/span>ng c\u1ee5 v\u00e0 t\u00ednh n\u0103ng l\u00e0m vi\u1ec7c g\u1ea7n g\u0169i v\u1edbi ng\u01b0\u1eddi d\u00f9ng, Excel gi\u00fap ng\u01b0\u1eddi d\u00f9ng th\u1ef1c hi\u1ec7n v\u00e0 t\u1ed1i \u01b0u\u00a0c\u00f4<\/span>ng vi\u1ec7c m\u1ed9t c\u00e1ch\u00a0hi\u1ec7u qu\u1ea3\u00a0<\/span>v\u00e0 n\u0103ng su\u1ea5t nh\u1ea5t.<\/p>\n

Theo th\u1eddi gian nhu c\u1ea7u t\u00ecm kh\u00f3a h\u1ecdc tin h\u1ecdc v\u0103n ph\u00f2ng,\u00a0c\u00f4<\/span>ng c\u1ee5 Excel c\u1ee7a ng\u01b0\u1eddi d\u00f9ng ng\u00e0y c\u00e0ng nhi\u1ec1u, \u0111\u00f2i h\u1ecfi cao h\u01a1n nh\u1eefng ki\u1ebfn th\u1ee9c ph\u1ed5 bi\u1ebfn hi\u1ec7n nay. Tr\u00ean m\u1ea1ng c\u00f3 r\u1ea5t nhi\u1ec1u kh\u00f3a h\u1ecdc excel online, tuy nhi\u00ean chi ph\u00ed th\u01b0\u1eddng kh\u00e1 cao, ph\u1ea3i \u0111\u0103ng nh\u1eadp tr\u00ean website c\u1ee7a h\u1ecd m\u1edbi h\u1ecdc \u0111\u01b0\u1ee3c.<\/p>\n

Tuy nhi\u00ean \u1edf \u0111\u00e2y ch\u00fang t\u00f4i cung c\u1ea5p cho c\u00e1c b\u1ea1n h\u1eb3n 4\u00a0kh\u00f3a h\u1ecdc excel t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao<\/b>, to\u00e0n b\u1ed9 4 kh\u00f3a h\u1ecdc n\u00e0y ch\u1ec9 v\u1edbi gi\u00e1 99k. Bao g\u1ed3m:<\/p>\n

– Kh\u00f3a h\u1ecdc 1: Excel c\u01a1 b\u1ea3n v\u00e0 n\u00e2ng cao<\/p>\n

– Kh\u00f3a h\u1ecdc 2: T\u1ef1 \u0111\u1ed9ng h\u00f3a Excel v\u1edbi l\u1eadp tr\u00ecnh VBA cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/p>\n

– Kh\u00f3a h\u1ecdc 3:\u00a0T\u0103ng hi\u1ec7u qu\u1ea3 v\u00e0 hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c v\u1edbi VBA v\u00e0 Excel<\/p>\n

– Kh\u00f3a h\u1ecdc 4:\u00a0\u00a0L\u1eadp tr\u00ecnh VBA n\u00e2ng cao trong Excel<\/p>\n

<\/a><\/div>\n

N\u1ed8I DUNG KH\u00d3A H\u1eccC<\/b><\/p>\n

I Kh\u00f3a h\u1ecdc execl t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao<\/b><\/div>\n
\n
1 B\u00e0i 1.C\u00e1c ph\u00edm t\u1eaft th\u00f4ng d\u1ee5ng trong Excel<\/div>\n
2 B\u00e0i 2.C\u00e1ch tr\u1eeb gi\u1edd trong Excel (c\u01a1 b\u1ea3n v\u00e0 n\u00e2ng cao)<\/div>\n
3 B\u00e0i 3.H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ea1o list box trong Excel<\/div>\n
4 B\u00e0i 4.C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 nhanh trong Excel<\/div>\n
5 B\u00e0i 5.C\u00e1ch g\u1ed9p nhi\u1ec1u file excel th\u00e0nh m\u1ed9t file duy nh\u1ea5t<\/div>\n
6 B\u00e0i 6.C\u00e1ch copy b\u1ea3ng d\u1eef li\u1ec7u t\u1eeb Excel sang Word<\/div>\n
7 B\u00e0i 7.C\u00e1ch t\u00f4 m\u00e0u xen k\u1ebd gi\u1eefa c\u00e1c d\u00f2ng trong Excel<\/div>\n
8 B\u00e0i 10.C\u1ed1 \u0111\u1ecbnh d\u00f2ng, c\u1ed9t ti\u00eau \u0111\u1ec1 trong Excel<\/div>\n
9 B\u00e0i 11.C\u00e1ch tr\u1eeb ng\u00e0y trong Excel c\u00f3 t\u00ednh c\u1ea3 gi\u1edd, ph\u00fat<\/div>\n
10 B\u00e0i 12.T\u00ednh t\u1ed5ng c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel – H\u00e0m Sumproduct<\/div>\n
11 B\u00e0i 13.H\u01b0\u1edbng d\u1eabn t\u00e1ch t\u00ean, h\u1ecd v\u00e0 t\u00ean \u0111\u1ec7m trong Excel<\/div>\n
12 B\u00e0i 14.T\u00e1ch h\u1ecd t\u00ean trong Excel kh\u00f4ng c\u1ea7n d\u00f9ng c\u00f4ng th\u1ee9c<\/div>\n
13 B\u00e0i 15.L\u1eb7p l\u1ea1i d\u00f2ng ti\u00eau \u0111\u1ec1 tr\u00ean c\u00e1c trang in trong Excel<\/div>\n
14 B\u00e0i 16.C\u00e1ch t\u1ea1o th\u00f4ng b\u00e1o s\u1eafp h\u1ebft h\u1ea1n trong Excel<\/div>\n
15 B\u00e0i 17.C\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y th\u1ee9 7, ch\u1ee7 nh\u1eadt trong kho\u1ea3ng th\u1eddi gian<\/div>\n
16 B\u00e0i 18.C\u00e1ch \u0111\u00e1nh s\u1ed1 trang trong Excel 2007, 2010, 2013<\/div>\n
17 B\u00e0i 19.Chuy\u1ec3n c\u1ed9t th\u00e0nh h\u00e0ng, h\u00e0ng th\u00e0nh c\u1ed9t trong Excel<\/div>\n
18 B\u00e0i 20.C\u00e1ch chuy\u1ec3n d\u1ea5u ph\u1ea9y th\u00e0nh d\u1ea5u ch\u1ea5m trong Excel 2013, 2010<\/div>\n
19 B\u00e0i 21.H\u01b0\u1edbng d\u1eabn c\u00e1ch xu\u1ed1ng d\u00f2ng trong 1 \u00f4 Excel<\/div>\n
20 B\u00e0i 22.C\u00e1ch c\u0103n ch\u1ec9nh l\u1ec1 trong Excel 2013, 2010, 2007<\/div>\n
21 B\u00e0i 23.C\u00e1ch c\u0103n ch\u1ec9nh l\u1ec1 trong Excel 2013, 2010, 2007<\/div>\n
22 B\u00e0i 24.C\u00e1ch vi\u1ebft s\u1ed1 0 \u1edf \u0111\u1ea7u s\u1ed1 trong Excel<\/div>\n
23 B\u00e0i 25.C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh Excel<\/div>\n
24 B\u00e0i 26.L\u1ecdc d\u1eef li\u1ec7u n\u00e2ng cao trong Excel 2007, 2010, 2013<\/div>\n
25 B\u00e0i 27.C\u00e1ch tr\u1ed9n th\u01b0, tr\u1ed9n v\u0103n b\u1ea3n t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u Excel<\/div>\n
26 B\u00e0i 28.C\u00e1ch \u0111\u1ed5i font ch\u1eef trong Excel kh\u00f4ng b\u1ecb l\u1ed7i c\u00f4ng th\u1ee9c<\/div>\n
27 B\u00e0i 29.C\u00e1ch in trang ch\u1eb5n l\u1ebb trong Excel 2003<\/div>\n
28 B\u00e0i 30.C\u00e1ch in hai m\u1eb7t gi\u1ea5y trong Excel 2003, 2007, 2010, 2013<\/div>\n
29 B\u00e0i 31.C\u00e1ch s\u1eafp x\u1ebfp d\u1eef li\u1ec7u trong Excel<\/div>\n
30 B\u00e0i 32.H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ea1o b\u1ea3ng trong Excel<\/div>\n
31 B\u00e0i 33.C\u00e1ch t\u1ea1o b\u1ea3ng trong Excel 2007, 2010, 2013<\/div>\n
32 B\u00e0i 33.H\u01b0\u1edbng d\u1eabn l\u1eadp b\u00e1o c\u00e1o trong Excel v\u1edbi PivotTable<\/div>\n
33 B\u00e0i 34.H\u01b0\u1edbng d\u1eabn l\u1eadp b\u00e1o c\u00e1o trong Excel v\u1edbi PivotTable<\/div>\n
34 B\u00e0i 35.C\u00e1ch vi\u1ebft c\u00f4ng th\u1ee9c to\u00e1n h\u1ecdc, h\u00f3a h\u1ecdc trong Excel<\/div>\n
35 B\u00e0i 36.C\u00e1ch \u1ea9n c\u00f4ng th\u1ee9c trong Excel 2007, 2010, 2003, 2013<\/div>\n
36 B\u00e0i 37.C\u00e0i \u0111\u1eb7t th\u1eddi gian t\u1ef1 \u0111\u1ed9ng l\u01b0u trong Excel 2007<\/div>\n
37 B\u00e0i 38.C\u00e1ch \u0111\u1ecdc ng\u00e0y th\u00e1ng n\u0103m th\u00e0nh ch\u1eef trong Excel<\/div>\n
38 B\u00e0i 39.H\u01b0\u1edbng d\u1eabn \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel<\/div>\n
39 B\u00e0i 40.C\u00e1ch vi\u1ebft ch\u1eef \u1edf gi\u1eefa \u00f4 trong Excel<\/div>\n
40 B\u00e0i 41.Chuy\u1ec3n \u0111\u1ed5i ch\u1eef in hoa, in th\u01b0\u1eddng trong Excel<\/div>\n
41 B\u00e0i 42.C\u00e1ch t\u1ea1o v\u00e0 s\u1eed d\u1ee5ng ph\u00edm t\u1eaft, ch\u1eef vi\u1ebft t\u1eaft trong Excel<\/div>\n
42 B\u00e0i 43.C\u00e1ch \u0111\u1eb7t m\u1eadt kh\u1ea9u, password cho file Excel 2013, 2010, 2007, 2003<\/div>\n
43 B\u00e0i 44.Chuy\u1ec3n \u0111\u1ed5i ch\u1eef in hoa, in th\u01b0\u1eddng h\u00e0ng lo\u1ea1t trong Excel<\/div>\n
44 B\u00e0i 45.Chuy\u1ec3n \u0111\u1ed5i ch\u1eef in hoa, in th\u01b0\u1eddng h\u00e0ng lo\u1ea1t trong Excel<\/div>\n
45 B\u00e0i 46.Ch\u00e8n d\u00f2ng tr\u1ed1ng xen k\u1ebd m\u1ed7i d\u00f2ng d\u1eef li\u1ec7u trong Excel<\/div>\n
46 B\u00e0i 47.Tr\u1ed9n th\u01b0 v\u00e0 g\u1eedi Email h\u00e0ng lo\u1ea1t trong Excel, Gmail, Outlook<\/div>\n
47 B\u00e0i 48.C\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m trong Excel<\/div>\n
48 B\u00e0i 49.H\u01b0\u1edbng d\u1eabn ch\u00e8n \u1ea3nh c\u1ed1 \u0111\u1ecbnh v\u00e0o \u00f4 trong Excel<\/div>\n
49 B\u00e0i 50.C\u00e1ch x\u00e1c \u0111\u1ecbnh s\u1ed1 ch\u1eb5n, s\u1ed1 l\u1ebb trong Excel<\/div>\n
50 B\u00e0i 51.C\u00e1ch c\u0103n nhanh trang in Excel lu\u00f4n v\u1eeba kh\u00edt trang gi\u1ea5y<\/div>\n
51 B\u00e0i 52.C\u00e1ch t\u1ea1o, n\u1ea1p v\u00e0 s\u1eed d\u1ee5ng Add-Ins trong Excel<\/div>\n
52 B\u00e0i 53.C\u00e1ch t\u00e1ch s\u1ed1 trong chu\u1ed7i Excel<\/div>\n
53 B\u00e0i 54.C\u00e1ch l\u01b0u file Excel c\u00f3 ch\u1ee9a macro VBA<\/div>\n
54 B\u00e0i 55.C\u00e1ch tr\u1eeb ng\u00e0y th\u00e1ng n\u0103m trong Excel<\/div>\n
55 B\u00e0i 56.C\u00e1ch c\u1ed1 \u0111\u1ecbnh d\u00f2ng ti\u00eau \u0111\u1ec1 trong Excel 2007, 2010, 2013<\/div>\n
56 B\u00e0i 57.H\u01b0\u1edbng d\u1eabn k\u1ebft h\u1ee3p h\u00e0m If, Or, And trong Excel<\/div>\n
57 B\u00e0i 58.C\u00e1ch t\u00ednh l\u01b0\u01a1ng th\u01b0\u1edfng theo doanh s\u1ed1 trong Excel<\/div>\n
58 B\u00e0i 59.C\u00e1ch ch\u00e8n h\u00ecnh \u1ea3nh v\u00e0o comment trong Excel<\/div>\n
59 B\u00e0i 60.C\u00e1ch vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean trong \u00f4 Excel<\/div>\n
60 B\u00e0i 61.C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 sau khi l\u1ecdc d\u1eef li\u1ec7u Excel<\/div>\n
61 B\u00e0i 62.C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 \u0111\u1ebfn 0,5 trong Excel – YouTube<\/div>\n
62 B\u00e0i 63.C\u00e1ch x\u00e1c \u0111\u1ecbnh s\u1ed1 ng\u00e0y trong th\u00e1ng trong Excel<\/div>\n
63 B\u00e0i 64.C\u00e1ch x\u00e1c \u0111\u1ecbnh th\u1ee9 trong tu\u1ea7n khi bi\u1ebft ng\u00e0y th\u00e1ng n\u0103m<\/div>\n
64 B\u00e0i 65.M\u1eb9o hay s\u1eed d\u1ee5ng h\u00e0m Sumproduct trong k\u1ebf to\u00e1n<\/div>\n
65 B\u00e0i 66.C\u00e1ch \u0111\u1ecdc s\u1ed1 th\u00e0nh ch\u1eef trong Excel kh\u00f4ng b\u1ecb l\u1ed7i font<\/div>\n
66 B\u00e0i 67.C\u00e1ch ch\u00e8n th\u00eam h\u00e0ng, th\u00eam c\u1ed9t trong Excel<\/div>\n
67 B\u00e0i 68.T\u00e1ch h\u1ecd t\u00ean trong Excel 2013 b\u1eb1ng Flash Fill<\/div>\n
68 B\u00e0i 69.H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng Flash Fill trong Excel 2013<\/div>\n
69 B\u00e0i 70.C\u00e1ch t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel v\u1edbi h\u00e0m Sumif<\/div>\n
70 B\u00e0i 71.L\u1ed7i #N-_A khi d\u00f9ng h\u00e0m VLookup v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c<\/div>\n
71 B\u00e0i 72.T\u00e1ch s\u1ed1 nh\u00e0 ra kh\u1ecfi \u0111\u1ecba ch\u1ec9 trong Excel 2013<\/div>\n
72 B\u00e0i 73.H\u01b0\u1edbng d\u1eabn t\u00e1ch \u0111\u1ecba ch\u1ec9 trong Excel 2013<\/div>\n
73 B\u00e0i 74.T\u00e1ch s\u1ed1 ra kh\u1ecfi chu\u1ed7i trong Excel 2013 c\u1ef1c nhanh<\/div>\n
74 B\u00e0i 75.H\u01b0\u1edbng d\u1eabn v\u1ebd bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n trong Excel<\/div>\n
75 B\u00e0i 76.H\u01b0\u1edbng d\u1eabn v\u1ebd bi\u1ec3u \u0111\u1ed3 h\u00ecnh c\u1ed9t trong Excel<\/div>\n
76 B\u00e0i 77.L\u1ecdc v\u00e0 li\u00ean k\u1ebft d\u1eef li\u1ec7u gi\u1eefa c\u00e1c sheet trong Excel<\/div>\n
77 B\u00e0i 100.S\u1eed d\u1ee5ng Consolidate trong Excel \u0111\u1ec3 t\u1ed5ng h\u1ee3p l\u01b0\u01a1ng<\/div>\n
78 B\u00e0i 101.T\u00e1ch c\u00e1c sheet th\u00e0nh file trong Excel [Code Macro VBA]<\/div>\n
79 B\u00e0i 102.[Macro VBA] G\u1ed9p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u file Excel v\u00e0o 1 file duy nh\u1ea5t<\/div>\n
80 B\u00e0i 103.H\u00e0m t\u00e1ch s\u1ed1 ra kh\u1ecfi chu\u1ed7i trong Excel 2003, 2007, 2010<\/div>\n
81 B\u00e0i 104.C\u00e1ch t\u00ecm c\u00e1c s\u1ed1 c\u00f2n thi\u1ebfu trong 1 c\u1ed9t tr\u00ean Excel<\/div>\n
82 B\u00e0i 105.H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Macro trong Excel hi\u1ec7u qu\u1ea3 nh\u1ea5t<\/div>\n
83 B\u00e0i 106.T\u00ednh t\u1ed5ng c\u00e1c ch\u1eef s\u1ed1 c\u1ee7a m\u1ed9t s\u1ed1 trong Excel<\/div>\n
84 B\u00e0i 107.C\u00e1ch g\u1ed9p \u00f4 kh\u00f4ng m\u1ea5t d\u1eef li\u1ec7u trong Excel<\/div>\n
85 B\u00e0i 108.H\u01b0\u1edbng d\u1eabn v\u1ebd \u0111\u1ed3 th\u1ecb c\u00f3 \u0111\u1ed9 l\u1ec7ch chu\u1ea9n trong Excel<\/div>\n
86 B\u00e0i 109.C\u00e1ch d\u00f9ng h\u00e0m Vlookup d\u00f2 ng\u01b0\u1ee3c t\u1eeb ph\u1ea3i sang tr\u00e1i<\/div>\n
87 B\u00e0i 110.T\u00e1ch m\u00e3 s\u1ed1 ra c\u00e1c \u00f4 ho\u1eb7c c\u1ed9t li\u00ean ti\u1ebfp trong Excel<\/div>\n
88 B\u00e0i 111.H\u00e0m Vlookup d\u00f2 t\u00ecm v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel<\/div>\n
89 B\u00e0i 112.T\u00ednh t\u1ed5ng c\u00e1c \u00f4 \u1edf h\u00e0ng, c\u1ed9t ch\u1eb5n l\u1ebb trong Excel<\/div>\n
90 B\u00e0i 113.H\u00e0m HLookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel<\/div>\n
91 B\u00e0i 114.C\u00e1ch thu nh\u1ecf b\u1ea3ng Excel v\u1eeba kh\u00edt trang gi\u1ea5y khi in [C\u00e1ch 2]<\/div>\n
92 B\u00e0i 115.B\u1ea3ng d\u00f2 2 chi\u1ec1u Index Match nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel<\/div>\n
93 B\u00e0i 116.C\u1ea5u tr\u00fac m\u1ea3ng Row(Indirect()) trong Excel v\u00e0 \u1ee8ng d\u1ee5ng<\/div>\n
94 B\u00e0i 117.T\u00ednh s\u1ed1 th\u1ee9 trong tu\u1ea7n trong kho\u1ea3ng th\u1eddi gian<\/div>\n
95 B\u00e0i 118.C\u00e1ch x\u00f3a c\u00f4ng th\u1ee9c ch\u1ec9 \u0111\u1ec3 l\u1ea1i gi\u00e1 tr\u1ecb trong Excel<\/div>\n
96 B\u00e0i 119.C\u00e1ch x\u1ebfp th\u1ee9 h\u1ea1ng c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel<\/div>\n
97 B\u00e0i 120.K\u1ebft h\u1ee3p h\u00e0m Vlookup -u0026 Choose \u0111\u1ec3 Vlookup t\u1eeb nhi\u1ec1u b\u1ea3ng<\/div>\n
98 B\u00e0i 121.K\u1ebft h\u1ee3p h\u00e0m Vlookup v\u00e0 Indirect \u0111\u1ec3 d\u00f2 t\u00ecm t\u1eeb nhi\u1ec1u b\u1ea3ng<\/div>\n
<\/div>\n
II T\u1ef1 \u0111\u1ed9ng h\u00f3a Excel v\u1edbi l\u1eadp tr\u00ecnh VBA cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/b><\/div>\n
II.1 Ch\u01b0\u01a1ng 01- C\u01a1 b\u1ea3n t\u1ed5ng quan v\u1ec1 VBA v\u00e0 Macro trong Excel<\/b><\/div>\n
1 C\u00e1ch b\u1eaft \u0111\u1ea7u h\u1ecdc tr\u00ean H\u1ecdc Excel Online<\/div>\n
2 M\u1edf th\u1ebb developer.<\/div>\n
3 C\u00e1ch s\u1eafp x\u1ebfp c\u00e1c th\u00e0nh ph\u1ea7n c\u1eeda s\u1ed5 trong tr\u00ecnh so\u1ea1n th\u1ea3o VBA.<\/div>\n
4 S\u1eafp x\u1ebfp c\u1eeda s\u1ed5 Excel v\u00e0 c\u1eeda s\u1ed5 VBA k\u1ec1 nhau<\/div>\n
5 Ghi 1 macro, c\u00e1ch ch\u1ea1y macro t\u1eeb VBE.<\/div>\n
6 C\u00e1ch ch\u1ea1y Macro, Code VBA theo t\u1eebng d\u00f2ng<\/div>\n
7 Export v\u00e0 Import code VBA t\u1eeb file Excel n\u00e0y sang file Excel kh\u00e1c<\/div>\n
8 Lo\u1ea1i b\u1ecf code VBA trong file Excel.<\/div>\n
9 L\u01b0u v\u00e0 m\u1edf file excel c\u00f3 ch\u1ee9a macro, code VBA<\/div>\n
II.2 Ch\u01b0\u01a1ng 02- B\u1eaft \u0111\u1ea7u code VBA, c\u01a1 b\u1ea3n v\u1ec1 \u0111\u1ed1i t\u01b0\u1ee3ng\u00a0 Ranger<\/b><\/div>\n
1 T\u1ea1o m\u1edbi module trong VBA<\/div>\n
2 C\u01a1 b\u1ea3n v\u1ec1 \u0111\u1ed1i t\u01b0\u1ee3ng Range trong VBA.<\/div>\n
3 C\u00e1ch g\u00e1n macro v\u00e0o n\u00fat \u0111\u1ec3 ch\u1ea1y.<\/div>\n
4 Ti\u1ebfp t\u1ee5c v\u1edbi \u0111\u1ed1i t\u01b0\u1ee3ng Range, \u0111i\u1ec1n d\u1eef li\u1ec7u text b\u1eb1ng VBA<\/div>\n
5 Thu\u1ed9c t\u00ednh Text, Value, Row, Column c\u1ee7a \u0111\u1ed1i t\u01b0\u1ee3ng Range<\/div>\n
6 D\u00f9ng code VBA \u0111\u1ec3 \u0111i\u1ec1n v\u00e0 \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u<\/div>\n
8 8 Thu\u1ed9c t\u00ednh Count, Formula, Address c\u1ee7a \u0111\u1ed1i t\u01b0\u1ee3ng Range<\/div>\n
9 S\u1eed d\u1ee5ng thu\u1ed9c t\u00ednh Formula n\u00e2ng cao<\/div>\n
10 \u0110\u1ed1i t\u01b0\u1ee3ng Cells \u1edf trong Excel.<\/div>\n
11 \u00d4n t\u1eadp v\u1ec1 \u0111\u1ed1i t\u01b0\u1ee3ng Range, c\u00e1ch tham chi\u1ebfu \u0111\u1ebfn b\u1ea3ng t\u00ednh<\/div>\n
12 S\u1eed d\u1ee5ng k\u1ebft h\u1ee3p \u0111\u1ed1i t\u01b0\u1ee3ng Range v\u00e0 Cells.<\/div>\n
13 H\u00e0m Offet 01.<\/div>\n
14 H\u00e0m Offet c\u1ee7a \u0111\u1ed1i t\u01b0\u1ee3ng Range<\/div>\n
15 B\u00e0i t\u1eadp v\u1ec1 nh\u00e0 Ch\u01b0\u01a1ng 2<\/div>\n
16 Gi\u1ea3i b\u00e0i t\u1eadp Ch\u01b0\u01a1ng 2- Form nh\u1eadp li\u1ec7u tr\u00ean sheet<\/div>\n
17 Gi\u1ea3i b\u00e0i t\u1eadp ch\u01b0\u01a1ng 2- T\u00e1ch d\u1eef li\u1ec7u t\u1ef1 \u0111\u1ed9ng<\/div>\n
18 B\u00e0i t\u1eadp \u1ee9ng d\u1ee5ng VBA t\u1ea1o ph\u1ea7n m\u1ec1m h\u1ecdc v\u00e0 ph\u00e1t \u00e2m ti\u1ebfng Anh<\/div>\n
19 Gi\u1ea3i b\u00e0i t\u1eadp \u1ee9ng dungk VBA t\u1ea1o ph\u1ea7n m\u1ec1m h\u1ecdc v\u00e0 ph\u00e1t \u00e2m ti\u1ebfng Anh<\/div>\n
II.3 Ch\u01b0\u01a1ng 03- C\u1ea7u tr\u00fac \u0111i\u1ec1u khi\u1ec3n, d\u1eef li\u1ec7u, ki\u1ec3u bi\u1ec3n trong VBA<\/b><\/div>\n
1 C\u1ea5u tr\u00fac With v\u00e0 End With<\/div>\n
2 \u00a0\u0110\u1ecdc ghi d\u1eef li\u1ec7u t\u1eeb Range t\u1edbi Range<\/div>\n
3 Bi\u1ebfn s\u1ed1 v\u00e0 ki\u1ec3u d\u1eef li\u1ec7u 01.<\/div>\n
4 Bi\u1ebfn s\u1ed1 v\u00e0 ki\u1ec3u d\u1eef li\u1ec7u 03<\/div>\n
5 Function, c\u00e1ch vi\u1ebft Function, tham s\u1ed1 tu\u1ef3 ch\u1ecdn<\/div>\n
6 Copy Range, PasteSpecial.<\/div>\n
7 \u0110\u1ed1i t\u01b0\u1ee3ng Workbook<\/div>\n
8 \u0110\u1ed1i t\u01b0\u1ee3ng Workbook, \u0111\u00f3ng m\u1edf l\u01b0u Workbook<\/div>\n
9 \u0110\u1ed1i t\u01b0\u1ee3ng Workbook, m\u1edf read-only, t\u1ea1o workbook m\u1edbi.<\/div>\n
10 \u0110\u1ed1i t\u01b0\u1ee3ng workbook, ki\u1ec3m tra workbook c\u00f3 t\u1ed3n t\u1ea1i kh\u00f4ng.<\/div>\n
11 \u0110\u1ed1i t\u01b0\u1ee3ng workbook, copy sao ch\u00e9p workbook \u0111ang \u0111\u00f3ng<\/div>\n
12 \u0110\u1ed1i t\u01b0\u1ee3ng Worksheet<\/div>\n
13 \u0110\u1ed1i t\u01b0\u1ee3ng Worksheets.<\/div>\n
14 S\u1eed d\u1ee5ng object browser \u0111\u1ec3 tra c\u1ee9u trong VBA<\/div>\n
15 C\u00e1ch khai b\u00e1o v\u00e0 s\u1eed d\u1ee5ng bi\u1ebfn to\u00e0n c\u1ee5c \u2013 Public<\/div>\n
16 C\u00e1ch khai b\u00e1o bi\u1ebfn c\u1ee5c b\u1ed9 \u2013 Private<\/div>\n
17 C\u00e1ch khai b\u00e1o v\u00e0 s\u1eed d\u1ee5ng bi\u1ebfn Static.<\/div>\n
18 M\u1ed9t s\u1ed1 to\u00e1n t\u1eed trong VBA<\/div>\n
19 C\u00e1c to\u00e1n t\u1eed Logic trong VBA<\/div>\n
20 C\u1ea5u tr\u00fac \u0111i\u1ec1u khi\u1ec3n IF \u0111\u01a1n gi\u1ea3n<\/div>\n
21 C\u1ea5u tr\u00fac \u0111i\u1ec1u khi\u1ec3n IF n\u00e2ng cao.<\/div>\n
22 V\u00f2ng l\u1eb7p For.<\/div>\n
23 V\u00f2ng l\u1eb7p for each.<\/div>\n
24 V\u00f2ng l\u1eb7p For \u2013 S\u1eed d\u1ee5ng Exit For<\/div>\n
25 V\u00f2ng l\u1eb7p do while loop<\/div>\n
26 V\u00f2ng l\u1eb7p do until<\/div>\n
27 C\u00e1ch s\u1eed d\u1ee5ng c\u1ea5u tr\u00fac Select Case Case IS.<\/div>\n
28 C\u1ea5u tr\u00fac Case to<\/div>\n
29 C\u1ea7u tr\u00fac Select Case<\/div>\n
30 B\u00e0i t\u1eadp Ph\u00e2n t\u00edch m\u00f4 ph\u1ecfng VLookup trong VBA.<\/div>\n
Ch\u01b0\u01a1ng 03.01 c\u00e1c h\u00e0m x\u1eed l\u00fd chu\u00f4i trong VBA<\/b><\/div>\n
1 Khai b\u00e1o v\u00e0 g\u00e1n gi\u00e1 tr\u1ecb cho bi\u1ebfn String trong VBA<\/div>\n
2 String manipulation, x\u1eed l\u00fd chu\u1ed7i h\u00e0m InStr.<\/div>\n
3 String manipulation, x\u1eed l\u00fd chu\u1ed7i h\u00e0m InStrRev.<\/div>\n
4 String manipulation, x\u1eed l\u00fd chu\u1ed7i h\u00e0m Lcase, Ucase<\/div>\n
5 String manipulation, x\u1eed l\u00fd chu\u1ed7i h\u00e0m Left, Right<\/div>\n
6 String manipulation, x\u1eed l\u00fd chu\u1ed7i h\u00e0m len, space.<\/div>\n
7 String manipulation, x\u1eed l\u00fd chu\u1ed7i h\u00e0m Replace<\/div>\n
II.4 Ch\u01b0\u01a1ng 04 s\u1eed s\u1ee5ng m\u1ea3ng trong VBA<\/b><\/div>\n
1 M\u1ea3ng trong VBA<\/div>\n
2 M\u1ea3ng trong VBA, m\u1ea3ng t\u0129nh, m\u1ea3ng \u0111\u1ed9ng<\/div>\n
3 M\u1ea3ng trong VBA \u2013 s\u1eed d\u1ee5ng h\u00e0m split.<\/div>\n
4 M\u1ea3ng trong VBA, s\u1eed d\u1ee5ng v\u00f2ng l\u1eb7p, t\u1ea1o s\u1ed1 ng\u1eabu nhi\u00ean<\/div>\n
5 M\u1ea3ng trong VBA, \u0111\u1eb7t l\u1ea1i d\u1eef li\u1ec7u<\/div>\n
6 M\u1ea3ng trong VBA, s\u1eed d\u1ee5ng erase v\u1edbi m\u1ea3ng \u0111\u1ed9ng<\/div>\n
7 M\u1ea3ng trong VBA, s\u1eed d\u1ee5ng redim preserve thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc c\u1ee7a m\u1ea3ng<\/div>\n
8 M\u1ea3ng trong VBA, d\u00f9ng m\u1ea3ng l\u00e0m tham s\u1ed1 cho function<\/div>\n
9 M\u1ea3ng trong VBA, vi\u1ebft function tr\u1ea3 v\u1ec1 d\u1ea1ng array<\/div>\n
10 M\u1ea3ng 2 chi\u1ec1u, c\u00e1ch khai b\u00e1o v\u00e0 l\u1eb7p.<\/div>\n
11 \u0110\u1ecdc d\u1eef li\u1ec7u t\u1eeb sheet v\u00e0o m\u1ea3ng.<\/div>\n
12 Ghi d\u1eef li\u1ec7u t\u1eeb m\u1ea3ng VBA v\u00e0o b\u1ea3ng t\u00ednh Excel<\/div>\n
13 Ghi d\u1eef li\u1ec7u ra m\u1ea3ng, s\u1eed d\u1ee5ng resize<\/div>\n
II.5 Ch\u01b0\u01a1ng 05- m\u1ed9t s\u1ed1 h\u00e0m th\u01b0\u1eddng d\u00f9ng trong VBA<\/b><\/div>\n
1 M\u1ed9t s\u1ed1 h\u00e0m ki\u1ec3m tra d\u1eef li\u1ec7u trong VBA<\/div>\n
2 M\u1ed9t s\u1ed1 h\u00e0m chuy\u1ec3n \u0111\u1ed5i ki\u1ec3u d\u1eef li\u1ec7u trong VBA<\/div>\n
3 M\u1ed9t s\u1ed1 h\u00e0m to\u00e1n h\u1ecdc hay s\u1eed d\u1ee5ng trong VBA.<\/div>\n
4 H\u00e0m x\u1eed l\u00fd ng\u00e0y, th\u00e1ng, gi\u1edd trong VBA<\/div>\n
5 M\u1ed9t s\u1ed1 h\u00e0m x\u1eed l\u00fd chu\u1ed7i trong VBA.<\/div>\n
II.6 Ch\u01b0\u01a1ng 06- M\u1ed9t s\u1ed1 b\u00e0i t\u1eadp \u1ee9ng d\u1ee5ng c\u1ee7a VBA<\/b><\/div>\n
1 BT li\u1ec7t k\u00ea c\u00e1c sheet trong b\u1ea3ng t\u00ednh<\/div>\n
2 GBT li\u1ec7t k\u00ea c\u00e1c sheet trong b\u1ea3ng t\u00ednh<\/div>\n
3 BT li\u1ec7t k\u00ea t\u00ean sheet, ghi ra b\u1ea3ng t\u00ednh.<\/div>\n
4 GBT li\u1ec7t k\u00ea t\u00ean sheet, ghi ra b\u1ea3ng t\u00ednh<\/div>\n
5 \u00e1ch c\u00e1c sheets trong 1 file excel ra nhi\u1ec1u file excel<\/div>\n
6 BT T\u00ecm d\u00f2ng cu\u1ed1i ho\u1eb7c c\u1ed9t cu\u1ed1i c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u.<\/div>\n
7 GBT T\u00ecm d\u00f2ng cu\u1ed1i, c\u1ed9t cu\u1ed1i c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh<\/div>\n
8 BT T\u1ea1o nhi\u1ec1u sheets theo t\u00ean c\u00f3 s\u1eb5n<\/div>\n
9 GBT T\u1ea1o nhi\u1ec1u sheets theo t\u00ean c\u00f3 s\u1eb5n<\/div>\n
10 S\u1eed d\u1ee5ng Inputbox \u1edf trong VBA \u0111\u1ec3 t\u01b0\u01a1ng t\u00e1c v\u1edbi ng\u01b0\u1eddi d\u00f9ng.<\/div>\n
II.7 Ch\u01b0\u01a1ng 07- T\u1ed5ng quan v\u1ec1 x\u1eed l\u00fd l\u1ed7i c\u01a1 b\u1ea3n trong VBA<\/b><\/div>\n
1 T\u1ed5ng quan v\u1ec1 l\u1ed7i v\u00e0 x\u1eed l\u00ed l\u1ed7i trong VBA.<\/div>\n
2 V\u00ed d\u1ee5 v\u1ec1 b\u1eaby l\u1ed7i c\u01a1 b\u1ea3n trong VBA.<\/div>\n
3 Qu\u1ea3n l\u00ed l\u1ed7i b\u1eb1ng On Error<\/div>\n
4 T\u1ea1i sao c\u1ea7n c\u00f3 Exit Sub tr\u01b0\u1edbc Label l\u1ed7i.<\/div>\n
5 B\u1eaby l\u1ed7i v\u00e0 th\u1eed l\u1ea1i trong VBA.<\/div>\n
II.8 Ch\u01b0\u01a1ng 08- S\u1eed d\u1ee5ng \u0111\u1ed1i t\u01b0\u1ee3ng collection trong VBA<\/b><\/div>\n
1 \u0110\u1ed1i t\u01b0\u1ee3ng Collection (t\u1eadp h\u1ee3p) trong VBA<\/div>\n
2 L\u00e0m quen v\u1edbi t\u1eadp h\u1ee3p Collection trong VBA<\/div>\n
3 Khai b\u00e1o, s\u1eed d\u1ee5ng v\u00e0 x\u00f3a th\u00e0nh ph\u1ea7n c\u1ee7a t\u1eadp h\u1ee3p.<\/div>\n
4 Th\u00eam ph\u1ea7n t\u1eed v\u00e0o trong Collections trong VBA<\/div>\n
5 T\u1eadp h\u1ee3p kh\u00f4ng cho ph\u00e9p thay \u0111\u1ed5i gi\u00e1 tr\u1ecb c\u1ee7a ph\u1ea7n t\u1eed<\/div>\n
6 S\u1eed d\u1ee5ng Key trong t\u1eadp h\u1ee3p.<\/div>\n
7 Ki\u1ec3m tra Key c\u00f3 t\u1ed3n t\u1ea1i trong Collection kh\u00f4ng<\/div>\n
II.9 Ch\u01b0\u01a1ng 09- M\u1ed9t s\u1ed1 \u1ee9ng d\u1ee5ng l\u1ecdc d\u1eef li\u1ec7u t\u1ef1 \u0111\u1ed9ng h\u00f3a Ecel<\/b><\/div>\n
1 T\u00ednh kh\u00f4ng tr\u00f9ng l\u1eb7p c\u1ee7a key trong t\u1eadp h\u1ee3p.<\/div>\n
2 L\u1ecdc d\u1eef li\u1ec7u b\u1eb1ng VBA v\u1edbi 1 \u0111i\u1ec1u ki\u1ec7n.<\/div>\n
3 M\u1edf r\u1ed9ng v\u00ed d\u1ee5 l\u1ecdc d\u1eef li\u1ec7u v\u1edbi 2 hay nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/div>\n
4 M\u1edf r\u1ed9ng v\u00ed d\u1ee5 l\u1ecdc \u0111i\u1ec1u ki\u1ec7n \u1edf nhi\u1ec1u c\u1ed9t<\/div>\n
5 S\u1eed d\u1ee5ng m\u1ea3ng trong \u0111i\u1ec1u ki\u1ec7n l\u1ecdc<\/div>\n
6 BT l\u1ecdc d\u1eef li\u1ec7u theo c\u1ed9t v\u00e0 copy ra sheet m\u1edbi<\/div>\n
7 GBT L\u1ecdc d\u1eef li\u1ec7u theo c\u1ed9t v\u00e0 copy ra sheet m\u1edbi<\/div>\n
8 BT T\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u sheets th\u00e0nh ph\u1ea7n v\u00e0o 1 sheet<\/div>\n
9 GBT T\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u sheets th\u00e0nh ph\u1ea7n v\u00e0o 1 sheet<\/div>\n
10 BT X\u00f3a d\u00f2ng tr\u1ed1ng b\u1eb1ng VBA.<\/div>\n
11 GBT X\u00f3a d\u00f2ng tr\u1ed1ng b\u1eb1ng VBA.<\/div>\n
12 BT S\u1eafp x\u1ebfp d\u1eef li\u1ec7u b\u1eb1ng VBA.<\/div>\n
13 GBT S\u1eafp x\u1ebfp d\u1eef li\u1ec7u b\u1eb1ng VBA<\/div>\n
II.10 Ch\u01b0\u01a1ng 10- Gi\u1edbi thi\u1ec7u Userfrorm trong VBA<\/b><\/div>\n
1 Gi\u1edbi thi\u1ec7u Userform.<\/div>\n
2 Ho\u00e0n th\u00e0nh thi\u1ebft k\u1ebf Userform \u0111\u1ec3 nh\u1eadp li\u1ec7u<\/div>\n
3 Ho\u00e0n th\u00e0nh Userform – ghi d\u1eef li\u1ec7u t\u1eeb Userform xu\u1ed1ng sheets<\/div>\n
4 Chuy\u1ec3n d\u1eef li\u1ec7u Userform xu\u1ed1ng b\u1ea3ng t\u00ednh v\u1edbi \u0111\u1ecbnh d\u1ea1ng s\u1ed1<\/div>\n
5 \u0110i\u1ec1n d\u1eef li\u1ec7u m\u1eb7c \u0111\u1ecbnh gi\u00fap gi\u00fap vi\u1ec7c nh\u1eadp li\u1ec7u d\u1ec5 d\u00e0ng h\u01a1n<\/div>\n
6 Ki\u1ec3m tra d\u1eef li\u1ec7u nh\u1eadp v\u00e0o b\u1eb1ng form, \u0111\u1ea3m b\u1ea3o nh\u1eadp \u0111\u1ee7 d\u1eef li\u1ec7u<\/div>\n
7 \u0110\u1ea3m b\u1ea3o m\u00e3 s\u1ed1 nh\u1eadp v\u00e0o qua Userform l\u00e0 duy nh\u1ea5t.<\/div>\n
8 Hi\u1ec7n \u1ea3nh tr\u00ean form.<\/div>\n
9 Bi\u1ec3u \u0111\u1ed3 \u0111\u1ed9ng tr\u00ean form<\/div>\n
10 Thi\u1ebft l\u1eadp bi\u1ec3u v\u00e0 import d\u1eef li\u1ec7u bi\u1ec3u \u0111\u1ed3 \u0111\u1ed9ng<\/div>\n
11 Ho\u00e0n th\u00e0nh bi\u1ec3u \u0111\u1ed3 \u0111\u1ed9ng tr\u00ean form<\/div>\n
12 Ph\u00e1t \u00e2m ti\u1ebfng anh v\u1edbi VBA ngay trong Excel.<\/div>\n
13 M\u1ed9t v\u00ed d\u1ee5 v\u1ec1 Form nh\u1eadp li\u1ec7u c\u01a1 b\u1ea3n<\/div>\n
II.11 Ch\u01b0\u01a1ng 11- Gi\u1edbi thi\u1ec7u v\u1ec1 l\u1eadp tr\u00ecnh s\u1ef1 ki\u1ec7n \u0111\u1ed1i v\u1edbi c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng Wordbook, Worksheet<\/b><\/div>\n
1 \u00a0S\u1ef1 ki\u1ec7n Workbook open<\/div>\n
2 S\u1ef1 ki\u1ec7n Workbook AfterSave<\/div>\n
3 S\u1ef1 ki\u1ec7n Workbook SheetActivate.<\/div>\n
4 S\u1ef1 ki\u1ec7n WorkSheet SelectionChange.<\/div>\n
5 S\u1ef1 ki\u1ec7n Worksheet Change, ch\u1eefa b\u00e0i t\u1eadp<\/div>\n
6 Hyperlinker<\/div>\n
<\/div>\n
III T\u0103ng hi\u1ec7u qu\u1ea3 v\u00e0 hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c v\u1edbi VBA v\u00e0 Excel<\/b><\/div>\n
31 video b\u00e0i gi\u1ea3ng<\/div>\n
<\/div>\n
IV L\u1eadp tr\u00ecnh VBA n\u00e2ng cao trong Excel<\/b><\/div>\n
IV.1 Ph\u1ea7n 1 L\u1eadp tr\u00ecnh Userform c\u01a1 b\u1ea3n trong VBA<\/b><\/div>\n
1 Gi\u1edbi thi\u1ec7u v\u1ec1 Userform C\u00e1c th\u00e0nh ph\u1ea7n c\u01a1 b\u1ea3n tr\u00ean 1 Userform trong VBA<\/div>\n
2 Userform InputBox l\u00e0 1 trong nh\u1eefng userform d\u1ef1ng s\u1eb5n trong VBA<\/div>\n
3 Userform MessageBox l\u00e0 1 trong nh\u1eefng userform d\u1ef1ng s\u1eb5n trong VBA<\/div>\n
4 Userform S\u1eed d\u1ee5ng GetOpenFilename \u0111\u1ec3 l\u1ea5y t\u00ean file \u0111\u01b0\u1ee3c ch\u1ecdn<\/div>\n
5 Userform T\u1ea1o userform \u0111\u1ea7u ti\u00ean<\/div>\n
6 Userform Th\u00eam c\u00e1c controls l\u00ean tr\u00ean Userform<\/div>\n
7 L\u00e0m quen v\u1edbi s\u1ef1 ki\u1ec7n trong l\u1eadp tr\u00ecnh VBA<\/div>\n
8 Userform su kien khoi tao userform<\/div>\n
9 \u00a0Userform ph\u00e2n bi\u1ec7t modal v\u00e0 modeless userform<\/div>\n
10 Userform show, hide, unload m\u1ed9t userform<\/div>\n
11 Userform, vi\u1ebft 1 thu\u1ed9c t\u00ednh cho userform<\/div>\n
12 Userform, x\u1eed l\u00fd l\u1ed7i automation error<\/div>\n
13 Userform, m\u1ed9t v\u00ed d\u1ee5 v\u1ec1 nh\u1eadp li\u1ec7u t\u1eeb form v\u00e0o sheet<\/div>\n
14 Userform, s\u1eed d\u1ee5ng s\u1ef1 ki\u1ec7n click c\u1ee7a button, s\u1ef1 ki\u1ec7n change c\u1ee7a textbox<\/div>\n
15 Textbox, ch\u1ec9 cho nh\u1eadp s\u1ed1 v\u00e0o textbox<\/div>\n
16 Textbox, gi\u1edbi h\u1ea1n s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 nh\u1eadp v\u00e0o textbox<\/div>\n
17 Userform, c\u00e1ch s\u1eed d\u1ee5ng thu\u1ed9c t\u00ednh TabIndex c\u1ee7a c\u00e1c controls<\/div>\n
18 Textbox, m\u1ed9t s\u1ed1 s\u1ef1 ki\u1ec7n kh\u00e1c li\u00ean quan \u0111\u1ebfn textbox control<\/div>\n
19 Combobox, kh\u1edfi t\u1ea1o, th\u00eam d\u1eef li\u1ec7u v\u00e0o combobox<\/div>\n
20 Combobox, s\u1ef1 ki\u1ec7n change c\u1ee7a combobox<\/div>\n
21 Combobox, t\u1ea1o combobox ph\u1ee5 thu\u1ed9c nhau<\/div>\n
22 Combobox, s\u1eed d\u1ee5ng combobox v\u1edbi name \u0111\u1ed9ng<\/div>\n
IV.2 Ph\u1ea7n 2 Ki\u1ec3u d\u1eef li\u1ec7u t\u1eeb \u0111i\u1ec3n – dictionary v\u00e0 \u1ee9ng d\u1ee5ng trong VBA<\/b><\/div>\n
1 Dictionary, khai b\u00e1o dictionary, early,late binding, add, exists<\/div>\n
2 Dictionary, s\u1eeda d\u1eef li\u1ec7u, xo\u00e1 d\u1eef li\u1ec7u, xo\u00e1 to\u00e0n b\u1ed9 trong t\u1eeb \u0111i\u1ec3n<\/div>\n
3 Dictionary, l\u1eb7p qua keys v\u00e0 values c\u1ee7a t\u1eeb \u0111i\u1ec3n<\/div>\n
4 Dictionary, lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p<\/div>\n
5 Dictionary, comparemode, ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng<\/div>\n
6 Dictionary, \u1ee9ng d\u1ee5ng dict \u0111\u1ec3 t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u sales<\/div>\n
IV.3 Ph\u1ea7n 3 L\u1eadp tr\u00ecnh Userform n\u00e2ng cao trong VBA<\/b><\/div>\n
1 Listbox, gi\u1edbi thi\u1ec7u v\u1ec1 Listbox Control<\/div>\n
2 Listbox, t\u1ea1o form \u0111\u1ec3 ch\u1ee9a Listbox<\/div>\n
3 Listbox, n\u1ea1p d\u1eef li\u1ec7u cho Listbox<\/div>\n
4 Listbox, l\u1ea5y d\u1eef li\u1ec7u t\u1eeb Listbox xu\u1ed1ng sheet<\/div>\n
5 Listbox, ho\u00e0n th\u00e0nh l\u1ea5y d\u1eef li\u1ec7u t\u1eeb listbox xu\u1ed1ng sheet<\/div>\n
6 Listbox, ho\u00e0n th\u00e0nh t\u00ednh n\u0103ng t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u tr\u00ean listbox<\/div>\n
IV.4 Ph\u1ea7n 4 T\u1ed5ng h\u1ee3p, l\u1ecdc t\u00e1ch d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u ngu\u1ed3n v\u1edbi VBA<\/b><\/div>\n
1 G\u1ed9p d\u1eef li\u1ec7u nhi\u1ec1u sheets v\u00e0o 1 sheet trong Excel<\/div>\n
2 G\u1ed9p nhi\u1ec1u files v\u00e0o 1 file trong Excel<\/div>\n
3 Demo t\u00e1ch d\u1eef li\u1ec7u t\u1eeb 1 b\u1ea3ng ra 169 files trong 2 ph\u00fat<\/div>\n
IV.5 Ph\u1ea7n 5 T\u1ef1 \u0111\u1ed9gn h\u00f3a, \u0111i\u1ec1u khi\u1ec3n Powerpoint t\u1eeb \u1ee9ng d\u1ee5ng VBA<\/b><\/div>\n
1 B\u01b0\u1edbc \u0111\u1ea7u \u0111\u1ec3 \u0111i\u1ec1u khi\u1ec3n PowerPoint b\u1eb1ng VBA<\/div>\n
2 X\u1eed l\u00fd code trong tr\u01b0\u1eddng h\u1ee3p PowerPoint \u0111ang ch\u1ea1y<\/div>\n
3 Copy 1 v\u00f9ng t\u1eeb Excel sang PPT<\/div>\n
4 V\u1ebd h\u00ecnh tr\u00ean PPT t\u1eeb VBA Excel<\/div>\n
5 Truy\u1ec1n d\u1eef li\u1ec7u t\u1eeb Excel sang PowerPoint<\/div>\n
6 S\u1eed d\u1ee5ng template trong vi\u1ec7c \u0111i\u1ec1n d\u1eef li\u1ec7u t\u1eeb Excel sang PPT<\/div>\n
IV.6 Ph\u1ea7n 6 T\u1ef1 \u0111\u1ed9ng h\u00f3a, \u0111i\u1ec1u khi\u1ec3n Word t\u1eeb Excel \u1ee9ng d\u1ee5ng VBA<\/b><\/div>\n
1 \u0110i\u1ec1n d\u1eef li\u1ec7u v\u00e0o Word t\u1eeb Excel (Mailing b\u1eb1ng VBA t\u1eeb Excel sang Word)<\/div>\n
2 T\u1ef1 \u0110\u1ed9ng tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb File Word v\u00e0 Copy v\u00e0o Excel<\/div>\n
3 T\u1ea1o b\u00e1o c\u00e1o Word t\u1eeb Excel<\/div>\n
IV.7 Ph\u1ea7n 7 T\u1ef1 \u0111\u1ed9ng h\u00f3a, \u0111i\u1ec1u khi\u1ec3n outlook t\u1eeb Excel \u1ee9ng d\u1ee5ng VBA g\u1eedi email t\u1ef1 \u0111\u1ed9ng<\/b><\/div>\n
1 Thi\u1ebft l\u1eadp outlook \u0111\u1ec3 g\u1eedi mail th\u00f4ng qua VBA<\/div>\n
2 C\u00e1c v\u00ed d\u1ee5 v\u1ec1 tr\u01b0\u1eddng h\u1ee3p g\u1eedi mail v\u1edbi Outlook<\/div>\n
IV.8 Ph\u1ea7n 8 Truy v\u1ea5n, l\u1ecdc d\u1eef li\u1ec7u si\u00eau t\u1ed1c v\u1edbi ng\u00f4n ng\u1eef truy v\u1ea5n d\u1eef li\u1ec7u SQL ngay trong Excel<\/b><\/div>\n
1 Thi\u1ebft l\u1eadp ADODB late binding<\/div>\n
2 Thu\u1ed9c t\u00ednh source c\u1ee7a RecordSet<\/div>\n
3 D\u00f9ng access \u0111\u1ec3 t\u1ef1 vi\u1ebft code SQL<\/div>\n
4 T\u1ea1o d\u1eef li\u1ec7u m\u1edbi cho CSDL Access v\u1edbi VBA<\/div>\n
5 Thay \u0111\u1ed5i d\u1eef li\u1ec7u trong Database<\/div>\n
6 Xo\u00e1 d\u00f2ng trong CSDL Access<\/div>\n
7 T\u00ecm hi\u1ec3u v\u1ec1 Transaction trong CSDL<\/div>\n
8 Download d\u1eef li\u1ec7u m\u1eabu, gi\u1edbi thi\u1ec7u v\u1ec1 SQL<\/div>\n
9 hi\u1ebft l\u1eadp c\u00f4ng c\u1ee5 \u0111\u1ec3 h\u1ecdc SQL t\u1ed1t h\u01a1n<\/div>\n
10 Ho\u00e0n thi\u1ec7n c\u00f4ng c\u1ee5 t\u1ef1 h\u1ecdc SQL<\/div>\n
11 C\u00fa ph\u00e1p select<\/div>\n
12 C\u00fa ph\u00e1p select \u0111\u1eb7t t\u00ean l\u1ea1i c\u1ed9t<\/div>\n
13 \u0110i\u1ec1u ch\u1ec9nh l\u1ea1i c\u00f4ng c\u1ee5 h\u1ecdc SQL<\/div>\n
14 C\u1ed9ng tr\u1eeb nh\u00e2n chia tr\u1ef1c ti\u1ebfp tr\u00ean SQL<\/div>\n
15 SELECT COUNT \u0111\u1ebfm s\u1ed1 d\u00f2ng d\u1eef li\u1ec7u<\/div>\n
16 SELECT SUM \u0111\u1ebfm t\u1ed5ng c\u1ee7a c\u1ed9t<\/div>\n
17 S\u1eed d\u1ee5ng WHERE v\u1edbi IN<\/div>\n
18 S\u1eed d\u1ee5ng WHERE v\u1edbi BETWEEN<\/div>\n
19 WHERE v\u1edbi LIKE<\/div>\n
20 ORDER BY s\u1eafp x\u1ebfp d\u1eef li\u1ec7u<\/div>\n
21 GROUP BY t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u theo nh\u00f3m<\/div>\n
22 T\u00ecm 3 s\u1ea3n ph\u1ea9m v\u1edbi doanh thu l\u1edbn nh\u1ea5t<\/div>\n
23 \u00c1p d\u1ee5ng SQL tr\u1edf l\u1ea1i v\u00ed d\u1ee5 listbox<\/div>\n
24 C\u00e2u l\u1ec7nh JOIN trong SQL<\/div>\n
IV.9 Ph\u1ea7n 9 L\u1eadp tr\u00ecnh, t\u1ef1 tay t\u1ea1p Addins Ribbon v\u1edbi CustomUI Editor<\/b><\/div>\n
1 B\u00e0i 92. VBA201 ADI 01 Gi\u1edbi thi\u1ec7u module t\u1ea1o addin ribbon trong Excel<\/div>\n
2 B\u00e0i 93. VBA201 ADI 02 T\u1ea1o Ribbon Addin \u0111\u1ea7u ti\u00ean<\/div>\n
IV.10 Ph\u1ea7n 10 Web Scraper Crawler, l\u1ea5y th\u00f4ng tin t\u1eeb trang web ho\u1eb7c qua JSON API t\u1eeb c\u00e1c d\u1ecbch v\u1ee5<\/b><\/div>\n
1 Gi\u1edbi thi\u1ec7u<\/div>\n<\/div>\n
\r\n

H\u00ccNH TH\u1ee8C H\u1eccC V\u00c0 THANH TO\u00c1N<\/b><\/span><\/p>\r\n

\r\n
\r\n

\u2714\ufe0f\u00a0H\u00ecnh th\u1ee9c thanh to\u00e1n<\/strong><\/span><\/p>\r\n

C\u00e1c b\u1ea1n chuy\u1ec3n kho\u1ea3n ti\u1ec1n cho\u00a0ch\u00fa<\/span>ng t\u00f4i, v\u00e0 g\u1eedi cho\u00a0ch\u00fa<\/span>ng t\u00f4i email c\u1ee7a b\u1ea1n.\u00a0Ch\u00fa<\/span>ng t\u00f4i s\u1ebd setup quy\u1ec1n truy c\u1eadp Google Drive v\u00e0 g\u1eedi link kh\u00f3a h\u1ecdc cho c\u00e1c b\u1ea1n.\u00a0 (Link n\u00e0y l\u00e0 v\u0129nh vi\u1ec5n, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i c\u00e1c video b\u00e0i gi\u1ea3ng v\u1ec1 m\u00e1y t\u00ednh b\u1ea5t k\u1ef3 l\u00fac n\u00e0o)<\/p>\r\n

\u2714\ufe0f\u00a0H\u00ecnh th\u1ee9c h\u1ecdc<\/strong><\/span><\/p>\r\n

H\u1ecdc v\u00e0 th\u1ef1c h\u00e0nh qua c\u00e1c video b\u00e0i gi\u1ea3ng. C\u00f3 th\u1ec3 h\u1ecdc tr\u1ef1c ti\u1ebfp tr\u00ean Google drive, ho\u1eb7c t\u1ea3i video b\u00e0i gi\u1ea3ng v\u1ec1 m\u00e1y t\u00ednh, copy v\u00e0o \u0111i\u1ec7n th\u00f4\u1ea1i \u0111\u1ec3 h\u1ecdc m\u1ecdi l\u00fac m\u1ecdi n\u01a1i b\u1ea5t k\u1ef3 khi n\u00e0o b\u1ea1n r\u1ea3nh r\u1ed7i.\u00a0<\/p>\r\n

\u2714\ufe0f\u00a0Li\u00ean h\u1ec7<\/strong><\/span><\/p>\r\n

\u0110\u1ec3 \u0111\u01b0\u1ee3c t\u01b0 v\u1ea5n v\u00e0 h\u1ed7 tr\u1ee3 c\u00e1c b\u1ea1n li\u00ean h\u1ec7 S\u0110T 0904.87.33.88<\/span> (Call\/Zalo)<\/span><\/strong><\/em><\/p>\r\n<\/div>\r\n<\/div>\r\n

MUA KH\u00d3A NG\u1eccC NGAY<\/span><\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"

Microsoft Excel\u00a0\u0111\u01b0\u1ee3c coi l\u00e0 m\u1ed9t trong nh\u1eefng\u00a0c\u00f4ng c\u1ee5 tin h\u1ecdc v\u0103n ph\u00f2ng m\u1ea1nh m\u1ebd v\u00e0 ph\u1ed5 bi\u1ebfn nh\u1ea5t to\u00e0n c\u1ea7u hi\u1ec7n nay, b\u1eb1ng c\u00e1c\u00a0c\u00f4ng c\u1ee5 v\u00e0 t\u00ednh n\u0103ng l\u00e0m vi\u1ec7c g\u1ea7n g\u0169i v\u1edbi ng\u01b0\u1eddi d\u00f9ng, Excel gi\u00fap ng\u01b0\u1eddi d\u00f9ng th\u1ef1c hi\u1ec7n v\u00e0 t\u1ed1i \u01b0u\u00a0c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch\u00a0hi\u1ec7u qu\u1ea3\u00a0v\u00e0 n\u0103ng su\u1ea5t nh\u1ea5t. Theo th\u1eddi gian nhu…<\/p>\n","protected":false},"author":1,"featured_media":13221,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[410],"tags":[],"class_list":["post-13095","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tai-lieu-ban"],"_links":{"self":[{"href":"https:\/\/tailieuxaydung.net\/index.php?rest_route=\/wp\/v2\/posts\/13095","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tailieuxaydung.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tailieuxaydung.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tailieuxaydung.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tailieuxaydung.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=13095"}],"version-history":[{"count":3,"href":"https:\/\/tailieuxaydung.net\/index.php?rest_route=\/wp\/v2\/posts\/13095\/revisions"}],"predecessor-version":[{"id":13299,"href":"https:\/\/tailieuxaydung.net\/index.php?rest_route=\/wp\/v2\/posts\/13095\/revisions\/13299"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tailieuxaydung.net\/index.php?rest_route=\/wp\/v2\/media\/13221"}],"wp:attachment":[{"href":"https:\/\/tailieuxaydung.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13095"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tailieuxaydung.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=13095"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tailieuxaydung.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=13095"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}