Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd \u0111\u1ec3 qu\u1ea3n l\u00fd v\u00e0 s\u1eafp x\u1ebfp b\u1ea3ng t\u00ednh. \u0110\u1ed1i v\u1edbi nh\u00e2n vi\u00ean v\u0103n ph\u00f2ng, vi\u1ec7c th\u00e0nh th\u1ea1o c\u00e1c k\u1ef9 n\u0103ng Excel c\u01a1 b\u1ea3n l\u00e0 r\u1ea5t quan tr\u1ecdng \u0111\u1ec3 l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 h\u01a1n. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u1edbi thi\u1ec7u \u0111\u1ebfn b\u1ea1n top c\u00e1c k\u1ef9 n\u0103ng Excel c\u01a1 b\u1ea3n d\u00e0nh cho d\u00e2n v\u0103n ph\u00f2ng, gi\u00fap c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n.<\/p>\n
Excel l\u00e0 m\u1ed9t trong nh\u1eefng ph\u1ea7n m\u1ec1m t\u1ed1t nh\u1ea5t d\u00f9ng \u0111\u1ec3 t\u1ea1o v\u00e0 qu\u1ea3n l\u00fd b\u1ea3ng t\u00ednh. V\u1edbi h\u01a1n 30 n\u0103m ph\u00e1t tri\u1ec3n, Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i trong kinh doanh v\u00e0 \u0111\u00e3 tr\u1edf th\u00e0nh m\u1ed9t k\u1ef9 n\u0103ng quan tr\u1ecdng \u0111\u1ed1i v\u1edbi c\u00e1c nh\u00e0 tuy\u1ec3n d\u1ee5ng. Th\u00e0nh th\u1ea1o Excel s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u \u0111\u01b0\u1ee3c c\u00e1c ch\u1ee9c n\u0103ng c\u1ed1t l\u00f5i v\u00e0 logic \u0111\u1eb1ng sau c\u00e1c c\u00f4ng th\u1ee9c Excel, t\u1eeb \u0111\u00f3 n\u00e2ng cao n\u0103ng su\u1ea5t l\u00e0m vi\u1ec7c c\u1ee7a b\u1ea1n.<\/p>\n
<\/p>\n C\u00e1c Shortcuts l\u00e0 c\u00e1c ph\u00edm t\u1eaft gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian trong c\u00f4ng vi\u1ec7c. Ngo\u00e0i c\u00e1c ph\u00edm t\u1eaft c\u01a1 b\u1ea3n nh\u01b0 Ctrl+C v\u00e0 Ctrl+V, Excel c\u00f2n nhi\u1ec1u l\u1ef1a ch\u1ecdn Shortcuts kh\u00e1c nh\u01b0 Ctrl+Z \u0111\u1ec3 ho\u00e0n t\u00e1c h\u00e0nh \u0111\u1ed9ng cu\u1ed1i c\u00f9ng, Ctrl+PageUp \u0111\u1ec3 chuy\u1ec3n gi\u1eefa c\u00e1c tab trang t\u00ednh, Ctrl+A \u0111\u1ec3 ch\u1ecdn to\u00e0n b\u1ed9 trang t\u00ednh, Ctrl+F \u0111\u1ec3 t\u00ecm ki\u1ebfm v\u00e0 Ctrl+K \u0111\u1ec3 ch\u00e8n \u0111o\u1ea1n URL.<\/p>\n H\u1ecdc c\u00e1ch nh\u1eadp d\u1eef li\u1ec7u t\u1eeb website l\u00e0 m\u1ed9t k\u1ef9 n\u0103ng quan tr\u1ecdng trong Excel. B\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng t\u00ednh n\u0103ng Import External Data v\u00e0 New Web Query, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb m\u1ed9t trang web b\u1ea5t k\u1ef3 v\u00e0 nh\u1eadp v\u00e0o m\u1ed9t trang t\u00ednh trong Excel.<\/p>\n S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Autofilter gi\u00fap b\u1ea1n l\u1ecdc k\u1ebft qu\u1ea3 trong m\u1ed9t b\u1ea3ng t\u00ednh l\u1edbn. B\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o Data > Filter > Autofilter, b\u1ea1n c\u00f3 th\u1ec3 l\u1ecdc k\u1ebft qu\u1ea3 theo nhu c\u1ea7u c\u1ee7a m\u00ecnh.<\/p>\n AutoCorrect v\u00e0 AutoFill l\u00e0 hai c\u00f4ng c\u1ee5 t\u1ef1 \u0111\u1ed9ng ho\u00e1 trong Excel gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian. AutoCorrect t\u1ef1 \u0111\u1ed9ng s\u1eeda c\u00e1c l\u1ed7i ch\u00ednh t\u1ea3 v\u00e0 ng\u1eef ph\u00e1p c\u01a1 b\u1ea3n, trong khi AutoFill gi\u00fap b\u1ea1n nhanh ch\u00f3ng nh\u1eadp d\u1eef li\u1ec7u theo c\u00e1ch t\u1ef1 \u0111\u1ed9ng.<\/p>\n C\u00f3 m\u1ed9t s\u1ed1 h\u00e0m c\u01a1 b\u1ea3n trong Excel m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft. H\u00e0m SUM cho ph\u00e9p b\u1ea1n t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb, h\u00e0m AVERAGE t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh, h\u00e0m MAXIMUM\/MINIMUM t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t v\u00e0 nh\u1ecf nh\u1ea5t, h\u00e0m COUNT \u0111\u1ebfm s\u1ed1 \u00f4 ch\u1ee9a s\u1ed1.<\/p>\n Qu\u1ea3n l\u00fd b\u1ed1 c\u1ee5c trang trong Excel gi\u00fap b\u1ea1n t\u1ea1o b\u1ea3n in \u0111\u1eb9p nh\u01b0 hi\u1ec3n th\u1ecb tr\u00ean m\u00e0n h\u00ecnh. B\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c t\u00f9y ch\u1ecdn trong tab Page Layout, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u00e1nh s\u1ed1 trang, c\u1ed9t v\u00e0 \u0111\u01b0\u1eddng vi\u1ec1n trang theo \u00fd mu\u1ed1n.<\/p>\n B\u1ea3ng Pivot l\u00e0 m\u1ed9t t\u00ednh n\u0103ng m\u1ea1nh m\u1ebd trong Excel, gi\u00fap b\u1ea1n t\u1ea1o b\u00e1o c\u00e1o t\u1eeb c\u00e1c t\u1eadp d\u1eef li\u1ec7u l\u1edbn. V\u1edbi PivotTable, b\u1ea1n c\u00f3 th\u1ec3 t\u00f3m t\u1eaft, ph\u00e2n t\u00edch v\u00e0 so s\u00e1nh d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u g\u00f3c \u0111\u1ed9 kh\u00e1c nhau.<\/p>\n C\u00e1c bi\u1ec3u \u0111\u1ed3 v\u00e0 \u0111\u1ed3 th\u1ecb trong Excel gi\u00fap b\u1ea1n tr\u1ef1c quan h\u00f3a v\u00e0 hi\u1ec3u d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng. Vi\u1ec7c bi\u1ec3u di\u1ec5n d\u1eef li\u1ec7u b\u1eb1ng bi\u1ec3u \u0111\u1ed3 v\u00e0 \u0111\u1ed3 th\u1ecb gi\u00fap ng\u01b0\u1eddi \u0111\u1ecdc hi\u1ec3u \u0111\u01b0\u1ee3c th\u00f4ng tin m\u1ed9t c\u00e1ch tr\u1ef1c quan.<\/p>\n Macro l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 trong Excel gi\u00fap t\u1ef1 \u0111\u1ed9ng h\u00f3a c\u00e1c t\u00e1c v\u1ee5 l\u1eb7p \u0111i l\u1eb7p l\u1ea1i. B\u1eb1ng c\u00e1ch ghi l\u1ea1i c\u00e1c thao t\u00e1c c\u1ee7a b\u1ea1n, Excel c\u00f3 th\u1ec3 t\u1ef1 \u0111\u1ed9ng th\u1ef1c hi\u1ec7n c\u00e1c h\u00e0nh \u0111\u1ed9ng \u0111\u00f3 tr\u00ean d\u1eef li\u1ec7u.<\/p>\n \u0110\u1ecbnh d\u1ea1ng v\u00e0 l\u1ecdc c\u00f3 \u0111i\u1ec1u ki\u1ec7n gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3 trong b\u1ea3ng t\u00ednh. B\u1eb1ng c\u00e1ch thay \u0111\u1ed5i h\u00ecnh th\u1ee9c c\u1ee7a m\u1ed9t ph\u1ea1m vi \u00f4 d\u1ef1a tr\u00ean c\u00e1c ti\u00eau ch\u00ed c\u1ee5 th\u1ec3, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u00e1nh d\u1ea5u v\u00e0 ph\u00e2n lo\u1ea1i d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng.<\/p>\n V\u1eady l\u00e0 b\u1ea1n \u0111\u00e3 t\u00ecm hi\u1ec3u v\u1ec1 top c\u00e1c k\u1ef9 n\u0103ng Excel c\u01a1 b\u1ea3n c\u1ea7n thi\u1ebft trong c\u00f4ng vi\u1ec7c v\u0103n ph\u00f2ng. N\u1ebfu b\u1ea1n th\u00e0nh th\u1ea1o c\u00e1c k\u1ef9 n\u0103ng n\u00e0y, b\u1ea1n s\u1ebd tr\u1edf th\u00e0nh m\u1ed9t \u1ee9ng vi\u00ean v\u00f4 c\u00f9ng ti\u1ec1m n\u0103ng trong m\u1eaft c\u00e1c nh\u00e0 tuy\u1ec3n d\u1ee5ng. H\u00e3y tham kh\u1ea3o th\u00eam nhi\u1ec1u n\u1ed9i dung b\u1ed5 \u00edch kh\u00e1c t\u1ea1i MH Group<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":" Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd \u0111\u1ec3 qu\u1ea3n l\u00fd v\u00e0 s\u1eafp x\u1ebfp b\u1ea3ng t\u00ednh. \u0110\u1ed1i v\u1edbi nh\u00e2n vi\u00ean v\u0103n ph\u00f2ng, vi\u1ec7c th\u00e0nh th\u1ea1o c\u00e1c k\u1ef9 n\u0103ng Excel c\u01a1 b\u1ea3n l\u00e0 r\u1ea5t quan tr\u1ecdng \u0111\u1ec3 l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 h\u01a1n. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u1edbi thi\u1ec7u \u0111\u1ebfn b\u1ea1n top c\u00e1c k\u1ef9 n\u0103ng Excel c\u01a1 b\u1ea3n […]<\/p>\n","protected":false},"author":1,"featured_media":6375,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[35],"tags":[],"class_list":["post-5170","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ky-nang"],"_links":{"self":[{"href":"https:\/\/mhgvietnam.com\/en\/wp-json\/wp\/v2\/posts\/5170","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mhgvietnam.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mhgvietnam.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mhgvietnam.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mhgvietnam.com\/en\/wp-json\/wp\/v2\/comments?post=5170"}],"version-history":[{"count":1,"href":"https:\/\/mhgvietnam.com\/en\/wp-json\/wp\/v2\/posts\/5170\/revisions"}],"predecessor-version":[{"id":6376,"href":"https:\/\/mhgvietnam.com\/en\/wp-json\/wp\/v2\/posts\/5170\/revisions\/6376"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mhgvietnam.com\/en\/wp-json\/wp\/v2\/media\/6375"}],"wp:attachment":[{"href":"https:\/\/mhgvietnam.com\/en\/wp-json\/wp\/v2\/media?parent=5170"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mhgvietnam.com\/en\/wp-json\/wp\/v2\/categories?post=5170"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mhgvietnam.com\/en\/wp-json\/wp\/v2\/tags?post=5170"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}C\u00e1c K\u1ef9 N\u0103ng Excel C\u01a1 B\u1ea3n C\u1ea7n Thi\u1ebft Trong C\u00f4ng Vi\u1ec7c<\/h2>\n
Th\u00e0nh Th\u1ea1o C\u00e1c Shortcuts<\/h3>\n
Nh\u1eadp Data T\u1eeb C\u00e1c Ngu\u1ed3n Website<\/h3>\n
L\u1ecdc K\u1ebft Qu\u1ea3<\/h3>\n
AutoCorrect v\u00e0 AutoFill<\/h3>\n
S\u1eed D\u1ee5ng C\u00e1c H\u00e0m C\u01a1 B\u1ea3n<\/h3>\n
Qu\u1ea3n L\u00fd Page Layout<\/h3>\n
S\u1eed D\u1ee5ng B\u1ea3ng Pivot<\/h3>\n
S\u1eed D\u1ee5ng Bi\u1ec3u \u0110\u1ed3 V\u00e0 \u0110\u1ed3 Th\u1ecb<\/h3>\n
S\u1eed D\u1ee5ng Macro<\/h3>\n
\u0110\u1ecbnh D\u1ea1ng V\u00e0 L\u1ecdc C\u00f3 \u0110i\u1ec1u Ki\u1ec7n<\/h3>\n