{"id":223872,"date":"2023-06-26T14:18:00","date_gmt":"2023-06-26T07:18:00","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=223872"},"modified":"2023-06-26T15:27:20","modified_gmt":"2023-06-26T08:27:20","slug":"tu-hoc-excel-cac-phuong-phap-de-dang-va-hieu-qua","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/tu-hoc-excel-cac-phuong-phap-de-dang-va-hieu-qua\/","title":{"rendered":"T\u1ef1 h\u1ecdc Excel: C\u00e1c ph\u01b0\u01a1ng ph\u00e1p d\u1ec5 d\u00e0ng v\u00e0 hi\u1ec7u qu\u1ea3"},"content":{"rendered":"

H\u1ea7u h\u1ebft m\u1ecdi ng\u01b0\u1eddi t\u1eeb h\u1ecdc sinh, sinh vi\u00ean \u0111\u1ebfn gi\u1edbi v\u0103n ph\u00f2ng \u0111\u1ec1u bi\u1ebft s\u1ee9c m\u1ea1nh Excel mang l\u1ea1i, nh\u01b0ng v\u1eabn kh\u00f4ng \u00edt ng\u01b0\u1eddi bi\u1ebft c\u00e1ch t\u1eadn d\u1ee5ng t\u1ed1i \u0111a c\u00f4ng c\u1ee5 n\u00e0y. H\u00e3y c\u00f9ng tham kh\u1ea3o c\u00e1c c\u00e1ch t\u1ef1 h\u1ecdc Excel \u1edf \u0111\u00e2y nh\u00e9.\u00a0<\/strong><\/p>\n

\"cac-phuong-phap-tu-hoc-excel-de-dang-va-hieu-qua-2\"<\/picture>
Excel l\u00e0 c\u00f4ng c\u1ee5 quan tr\u1ecdng trong m\u1ecdi l\u0129nh v\u1ef1c<\/figcaption><\/figure>\n

V\u00ec sao Microsoft Excel ch\u01b0a bao gi\u1edd l\u1ed7i th\u1eddi?<\/strong><\/h2>\n

Khi c\u00f4ng ngh\u1ec7 n\u00e0y c\u00e0ng ph\u00e1t tri\u1ec3n, con ng\u01b0\u1eddi s\u1ebd t\u1ea1o v\u00e0 ph\u00e1t tri\u1ec3n ra nhi\u1ec1u c\u00f4ng c\u1ee5 hi\u1ec7n \u0111\u1ea1i h\u01a1n. Tuy nhi\u00ean c\u00f3 nh\u1eefng c\u00f4ng c\u1ee5 kh\u00f4ng bao gi\u1edd “l\u1ed7i th\u1eddi”, m\u00e0 Microsoft Excel l\u00e0 v\u00ed d\u1ee5 \u0111i\u1ec3n h\u00ecnh. \u0110\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng ph\u1ea7n m\u1ec1m t\u1ed1i quan tr\u1ecdng v\u00e0 ph\u1ed5 bi\u1ebfn nh\u1ea5t trong qu\u1ea3n l\u00fd d\u1eef li\u1ec7u n\u00f3i ri\u00eang v\u00e0 qu\u1ea3n l\u00fd doanh nghi\u1ec7p n\u00f3i chung. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 nh\u1eefng l\u00fd do \u0111\u1ec3 Excel l\u00fac n\u00e0o c\u0169ng c\u00f3 vai tr\u00f2 quan tr\u1ecdng.<\/p>\n

\"cac-phuong-phap-tu-hoc-excel-de-dang-va-hieu-qua-1\"<\/picture>
Excel d\u1ec5 h\u1ecdc v\u00e0 d\u1ec5 ti\u1ebfp c\u1eadn<\/figcaption><\/figure>\n

D\u1ec5 ti\u1ebfp c\u1eadn v\u00e0 \u00e1p d\u1ee5ng<\/strong><\/h3>\n

Trong s\u1ed1 t\u1ea5t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 ph\u00e2n t\u00edch d\u1eef li\u1ec7u hi\u1ec7n c\u00f3, b\u1ea3ng t\u00ednh v\u1eabn l\u00e0 c\u00f4ng c\u1ee5 truy\u1ec1n th\u1ed1ng v\u00e0 d\u1ec5 \u00e1p d\u1ee5ng nh\u1ea5t \u0111\u1ec3 ph\u00e2n t\u00edch kinh doanh. T\u1ea3i v\u00e0 mua ph\u1ea7n m\u1ec1m Excel c\u0169ng d\u1ec5 d\u00e0ng v\u00e0 gi\u00e1 c\u1ea3 ph\u1ea3i ch\u0103ng h\u01a1n nhi\u1ec1u so v\u1edbi c\u00e1c h\u1ec7 th\u1ed1ng qu\u1ea3n l\u00fd th\u00f4ng tin kh\u00e1c. Vi\u1ec7c h\u1ecdc Excel<\/strong> v\u00e0 s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o n\u00f3 th\u1eadm ch\u00ed c\u00f2n l\u00e0 y\u1ebfu t\u1ed1 b\u1eaft bu\u1ed9c khi tuy\u1ec3n d\u1ee5ng nh\u1eefng v\u1ecb tr\u00ed l\u00e0m v\u1ec1 d\u1eef li\u1ec7u nh\u01b0 k\u1ebf to\u00e1n, ki\u1ec3m to\u00e1n…<\/p>\n

C\u00e2n b\u1eb1ng gi\u1eefa t\u00ednh n\u0103ng m\u1ea1nh m\u1ebd v\u00e0 vi\u1ec7c d\u1ec5 s\u1eed d\u1ee5ng<\/strong><\/h3>\n

Th\u01b0\u1eddng nh\u1eefng c\u00f4ng c\u1ee5 qu\u00e1 hi\u1ec7n \u0111\u1ea1i th\u00ec \u0111i k\u00e8m v\u1edbi nh\u01b0\u1ee3c \u0111i\u1ec3m l\u00e0 kh\u00f3 s\u1eed d\u1ee5ng. Tuy nhi\u00ean, trong s\u1ed1 c\u00e1c t\u00f9y ch\u1ecdn c\u00f3 s\u1eb5n \u0111\u1ec3 ph\u00e2n t\u00edch d\u1eef li\u1ec7u, Excel \u0111\u01b0\u1ee3c cho l\u00e0 cung c\u1ea5p s\u1ef1 c\u00e2n b\u1eb1ng t\u1ed1t nh\u1ea5t gi\u1eefa s\u1ee9c m\u1ea1nh v\u00e0 kh\u1ea3 n\u0103ng truy c\u1eadp. Ph\u1ea7n m\u1ec1m b\u1ea3ng t\u00ednh n\u00e0y \u0111em \u0111\u1ebfn nh\u1eefng t\u00ednh n\u0103ng h\u1eefu \u00edch ch\u1eb3ng h\u1ea1n nh\u01b0 bi\u1ec3u \u0111\u1ed3, b\u1ea3ng t\u1ed5ng h\u1ee3p v\u00e0 c\u00f4ng th\u1ee9c nh\u01b0ng d\u1ec5 truy c\u1eadp h\u01a1n c\u00e1c c\u00f4ng c\u1ee5 n\u00e2ng cao nh\u01b0 SQL, Python.<\/p>\n

T\u01b0\u01a1ng th\u00edch v\u1edbi nhi\u1ec1u c\u00f4ng c\u1ee5 kh\u00e1c<\/strong><\/h3>\n

Kh\u1ea3 n\u0103ng t\u01b0\u01a1ng th\u00edch tuy\u1ec7t v\u1eddi c\u1ee7a Excel v\u1edbi c\u00e1c c\u00f4ng c\u1ee5 ph\u1ed5 bi\u1ebfn kh\u00e1c nh\u01b0 ch\u1eb3ng h\u1ea1n nh\u01b0 Google Sheets, Smartsheet… B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 l\u00e0m quen giao di\u1ec7n Excel tr\u01b0\u1edbc khi t\u00ecm hi\u1ec3u sang c\u00e1c t\u00f9y ch\u1ecdn ph\u00e2n t\u00edch d\u1eef li\u1ec7u n\u00e2ng cao h\u01a1n, ch\u1eb3ng h\u1ea1n nh\u01b0 g\u00f3i g\u1ea5u tr\u00fac c\u1ee7a Python \u2014 v\u00ec c\u1ea3 hai \u0111\u1ec1u t\u01b0\u01a1ng th\u00edch v\u1edbi \u0111\u1ecbnh d\u1ea1ng l\u01b0u tr\u1eef d\u1eef li\u1ec7u \u201ccsv\u201d ph\u1ed5 bi\u1ebfn.<\/p>\n

C\u00e1c ph\u01b0\u01a1ng ph\u00e1p t\u1ef1 h\u1ecdc Excel m\u00e0 ai c\u0169ng c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng<\/strong><\/h2>\n

Vi\u1ec7c h\u1ecdc Excel<\/strong> c\u00f3 th\u1ec3 mang l\u1ea1i nhi\u1ec1u l\u1ee3i \u00edch cho b\u1ea1n, t\u1eeb c\u1ea3i thi\u1ec7n hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c cho \u0111\u1ebfn t\u1ea1o ra nh\u1eefng b\u00e1o c\u00e1o ph\u00e2n t\u00edch tuy\u1ec7t v\u1eddi. N\u1ebfu b\u1ea1n mu\u1ed1n tr\u1edf th\u00e0nh m\u1ed9t chuy\u00ean gia, h\u00e3y th\u1eed \u00e1p d\u1ee5ng nh\u1eefng ph\u01b0\u01a1ng ph\u00e1p t\u1ef1 h\u1ecdc sau \u0111\u00e2y:<\/p>\n

T\u00ecm hi\u1ec3u qua c\u00e1c t\u00e0i li\u1ec7u h\u1ecdc Excel online<\/strong><\/h3>\n

Ng\u00e0y nay, h\u1ecdc online l\u00e0 xu h\u01b0\u1edbng kh\u00f4ng c\u00f2n qu\u00e1 xa l\u1ea1, \u0111\u1eb7c bi\u1ec7t v\u1edbi h\u1ecdc Excel th\u00ec ng\u01b0\u1eddi d\u00f9ng ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 v\u1eeba h\u1ecdc v\u1eeba th\u1ef1c h\u00e0nh tr\u00ean m\u00e1y. C\u00f3 r\u1ea5t nhi\u1ec1u t\u00e0i li\u1ec7u mi\u1ec5n ph\u00ed v\u00e0 c\u00f3 tr\u1ea3 ph\u00ed \u0111\u1ec3 h\u1ed7 tr\u1ee3 h\u1ecdc Excel online<\/strong>. B\u1ea1n th\u1ec3 t\u00ecm ki\u1ebfm c\u00e1c b\u00e0i vi\u1ebft, video h\u01b0\u1edbng d\u1eabn thao t\u00e1c Excel, c\u00e1c kh\u00f3a h\u1ecdc tr\u1ef1c tuy\u1ebfn. Tham gia v\u00e0o c\u00e1c c\u1ed9ng \u0111\u1ed3ng Excel \u0111\u1ec3 trao \u0111\u1ed5i v\u00e0 h\u1ecdc h\u1ecfi kinh nghi\u1ec7m c\u0169ng l\u00e0 m\u1ed9t \u00fd ki\u1ebfn hay.<\/p>\n

\"cac-phuong-phap-tu-hoc-excel-de-dang-va-hieu-qua-5\"<\/picture>
T\u1ef1 h\u1ecdc Excel qua t\u00e0i li\u1ec7u tr\u1ef1c tuy\u1ebfn<\/figcaption><\/figure>\n

Xem video h\u01b0\u1edbng d\u1eabn online<\/strong><\/h3>\n

\u0110\u00e2y l\u00e0 m\u1ed9t ph\u01b0\u01a1ng ph\u00e1p hi\u1ec7u qu\u1ea3 v\u1edbi nh\u1eefng ai mu\u1ed1n h\u1ecdc Excel online<\/strong> theo ki\u1ec3u “m\u00ec \u0103n li\u1ec1n”. M\u1ed9t s\u1ed1 ng\u01b0\u1eddi h\u1ecdc nhanh h\u01a1n t\u1eeb c\u00e1c h\u01b0\u1edbng d\u1eabn b\u1eb1ng video v\u00ec s\u1ef1 ti\u1ec7n l\u1ee3i \u0111i k\u00e8m v\u1ed1i minh h\u1ecda tr\u1ef1c quan. N\u1ed5i b\u1eadt nh\u1ea5t ch\u00ednh l\u00e0 YouTube, m\u1ed9t kho t\u00e0ng th\u00f4ng tin v\u00f4 t\u1eadn, ch\u1ee9a \u0111\u1ef1ng h\u00e0ng ng\u00e0n video h\u01b0\u1edbng d\u1eabn mi\u1ec5n ph\u00ed, th\u1eadm ch\u00ed c\u00f3 c\u1ea3 c\u00e1c th\u00f4ng tin n\u00e2ng cao. B\u00ean c\u1ea1nh \u0111\u00f3, Tiktok hi\u1ec7n nay n\u1ed5i l\u00ean nh\u01b0 m\u1ed9t k\u00eanh th\u00f4ng tin ng\u1eafn nh\u01b0ng d\u1ec5 nh\u1edb, hi\u1ec7u qu\u1ea3.<\/p>\n

Tham gia c\u00e1c kh\u00f3a \u0111\u00e0o t\u1ea1o ch\u00ednh th\u1ee9c<\/strong><\/h3>\n

N\u1ebfu b\u1ea1n mu\u1ed1n ti\u1ebfp c\u1eadn ki\u1ebfn th\u1ee9c chuy\u00ean s\u00e2u h\u01a1n, \u0111\u1ed3ng th\u1eddi mong mu\u1ed1n c\u00f3 s\u1ef1 h\u01b0\u1edbng d\u1eabn c\u1ee5 th\u1ec3 trong qu\u00e1 tr\u00ecnh h\u1ecdc, tham gia m\u1ed9t kh\u00f3a v\u1ec1 Excel t\u1ea1i c\u00e1c trung t\u00e2m \u0111\u00e0o t\u1ea1o ch\u00ednh l\u00e0 l\u1ef1a ch\u1ecdn t\u1ed1t nh\u1ea5t. B\u00ean c\u1ea1nh \u0111\u00f3, vi\u1ec7c c\u00f3 ch\u1ee9ng ch\u1ec9 Excel s\u1ebd l\u00e0 m\u1ed9t l\u1ee3i th\u1ebf khi b\u1ea1n \u1ee9ng tuy\u1ec3n v\u00e0o nh\u1eefng vi\u1ec7c y\u00eau c\u1ea7u \u0111\u1eb7c th\u00f9 ph\u1ea3i s\u1eed d\u1ee5ng Excel th\u01b0\u1eddng xuy\u00ean. N\u00f3 ch\u1ee9ng minh ki\u1ebfn th\u1ee9c v\u00e0 kh\u1ea3 n\u0103ng \u00e1p d\u1ee5ng Excel c\u1ee7a b\u1ea1n \u0111\u1ec3 thuy\u1ebft ph\u1ee5c nh\u00e0 tuy\u1ec3n d\u1ee5ng.<\/p>\n

\"cac-phuong-phap-tu-hoc-excel-de-dang-va-hieu-qua-3\"<\/picture>
C\u00e1c kh\u00f3a h\u1ecdc Excel gi\u00fap ng\u01b0\u1eddi h\u1ecdc l\u1ea5y ch\u1ee9ng ch\u1ec9<\/figcaption><\/figure>\n

M\u1eb9o t\u1ef1 h\u1ecdc Excel nhanh v\u00e0 hi\u1ec7u qu\u1ea3<\/strong><\/h2>\n

C\u00f3 r\u1ea5t nhi\u1ec1u c\u00e1ch \u0111\u1ec3 \u00e1p d\u1ee5ng Excel, t\u1eeb nh\u1eadp s\u1ed1 \u0111\u1ebfn t\u00ednh to\u00e1n c\u01a1 b\u1ea3n c\u00e1c c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p, th\u1eadm ch\u00ed l\u00e0 xu\u1ea5t b\u00e1o c\u00e1o. Tuy nhi\u00ean, \u0111\u1ec3 h\u1ecdc Excel <\/strong>hi\u1ec7u qu\u1ea3, th\u00ec b\u1ea1n \u0111\u1eebng b\u1ecf qua nh\u1eefng tips d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n

\u0110i\u1ec1u h\u01b0\u1edbng giao di\u1ec7n<\/strong><\/h3>\n

L\u00e0m quen v\u1edbi giao di\u1ec7n l\u00e0 m\u1ed9t trong nh\u1eefng \u0111i\u1ec1u c\u01a1 b\u1ea3n nh\u1ea5t m\u00e0 b\u1ea1n c\u1ea7n n\u1eafm khi t\u1ef1 h\u1ecdc Excel<\/strong>. Ch\u1eb3ng h\u1ea1n nh\u01b0 khi nh\u1eadp d\u1eef li\u1ec7u, ph\u00edm Tab d\u00f9ng \u0111\u1ec3 di chuy\u1ec3n sang \u00f4 k\u1ebf b\u00ean ph\u1ea3i, t\u1ed5 h\u1ee3p ph\u00edm Shift + Tab \u0111\u1ec3 di chuy\u1ec3n ng\u01b0\u1ee3c t\u1eeb tr\u01b0\u1eddng n\u00e0y sang tr\u01b0\u1eddng kh\u00e1c. Ctrl + Shift + Tab \u0111\u1ec3 di chuy\u1ec3n ng\u01b0\u1ee3c qua t\u1eebng tab m\u1ed9t, c\u00f2n t\u1ed5 h\u1ee3p Ctrl + Tab \u0111\u1ec3 di chuy\u1ec3n sang c\u00e1c file Excel \u0111ang \u0111\u01b0\u1ee3c m\u1edf.<\/p>\n

Ngo\u00e0i ra, thay v\u00ec r\u00ea chu\u1ed9t \u0111\u1ebfn m\u00f2n m\u1ecfi, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng ph\u00edm Ctrl v\u00e0 c\u00e1c ph\u00edm m\u0169i t\u00ean \u0111i\u1ec1u h\u01b0\u1edbng nh\u01b0 L\u00ean, Xu\u1ed1ng, Tr\u00e1i ho\u1eb7c Ph\u1ea3i s\u1ebd di chuy\u1ec3n b\u1ea1n \u0111\u1ebfn \u00f4 cu\u1ed1i c\u00f9ng theo t\u01b0\u01a1ng \u1ee9ng theo h\u01b0\u1edbng \u0111\u01b0\u1ee3c ch\u1ecdn. \u0110i\u1ec1u n\u00e0y r\u1ea5t h\u1eefu \u00edch \u0111\u1ec3 \u0111i\u1ec1u h\u01b0\u1edbng tr\u00ean c\u00e1c danh s\u00e1ch l\u1edbn. V\u00ed d\u1ee5: Ctrl + Home s\u1ebd di chuy\u1ec3n v\u1ec1 \u00f4 \u0111\u1ea7u ti\u00ean, c\u00f2n Ctrl + End s\u1ebd \u0111\u1ea9y ra \u00f4 cu\u1ed1i c\u00f9ng trong b\u1ea3ng t\u00ednh.<\/p>\n

\"cac-phuong-phap-tu-hoc-excel-de-dang-va-hieu-qua-6\"<\/picture>
Giao di\u1ec7n Excel<\/figcaption><\/figure>\n

S\u1eed d\u1ee5ng m\u1ed9t s\u1ed1 ph\u00edm t\u1eaft h\u1eefu \u00edch<\/strong><\/h3>\n

Excel c\u00f3 h\u01a1n 500 ph\u00edm t\u1eaft<\/a> v\u00e0 r\u1ea5t nhi\u1ec1u th\u1ee7 thu\u1eadt h\u1eefu \u00edch \u0111\u1ec3 t\u0103ng t\u1ed1c c\u00e1ch b\u1ea1n l\u00e0m vi\u1ec7c. C\u00e1ch t\u1ed1t nh\u1ea5t \u0111\u1ec3 t\u0103ng t\u1ed1c c\u00f4ng vi\u1ec7c Excel h\u00e0ng ng\u00e0y c\u1ee7a b\u1ea1n l\u00e0 t\u00ecm hi\u1ec3u m\u1ed9t s\u1ed1 ph\u00edm t\u1eaft h\u1eefu \u00edch, thay v\u00ec d\u00f9ng chu\u1ed9t hay b\u00e0n ph\u00edm g\u00f5 th\u1ee7 c\u00f4ng. M\u1eb7c d\u00f9 b\u1ea1n s\u1ebd kh\u00f4ng c\u1ea7n t\u1ea5t c\u1ea3 nh\u01b0ng s\u1ebd c\u00f3 m\u1ed9t s\u1ed1 ph\u00edm t\u1eaft m\u00e0 b\u1ea1n c\u1ea7n “thu\u1ed9c n\u1eb1m l\u00f2ng”.<\/p>\n

N\u1ebfu b\u1ea1n l\u00e0 ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u h\u1ecdc Excel<\/strong>, th\u00ec h\u00e3y b\u1eaft \u0111\u1ea7u b\u1eb1ng c\u00e1ch h\u1ecdc c\u00e1c ph\u00edm t\u1eaft chung, m\u00e0 \u0111i\u1ec3n h\u00ecnh l\u00e0 c\u00f4ng th\u1ee9c sao ch\u00e9p v\u00e0 d\u00e1n: Ctrl + C \u0111\u1ec3 sao ch\u00e9p v\u00e0 Ctrl + V \u0111\u1ec3 d\u00e1n. Ngo\u00e0i ra, c\u00f3 Ctrl + Z \u0111\u1ec3 ho\u00e0n t\u00e1c h\u00e0nh \u0111\u1ed9ng cu\u1ed1i c\u00f9ng, Ctrl+Y \u0111\u1ec3 l\u00e0m l\u1ea1i h\u00e0nh \u0111\u1ed9ng \u0111\u00e3 ho\u00e0n t\u00e1c, Ctrl + A \u0111\u1ec3 ch\u1ecdn to\u00e0n b\u1ed9 v\u0103n b\u1ea3n, Ctrl + X \u0111\u1ec3 c\u1eaft d\u1eef li\u1ec7u, Ctrl + F \u0111\u1ec3 b\u1eadt ch\u1ebf \u0111\u1ed9 t\u00ecm ki\u1ebfm.<\/p>\n

\"cac-phuong-phap-tu-hoc-excel-de-dang-va-hieu-qua-7\"<\/picture>
S\u1eed d\u1ee5ng ph\u00edm t\u1eaft Excel<\/figcaption><\/figure>\n

Freeze Panes \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh d\u00f2ng\/c\u1ed9t<\/strong><\/h3>\n

Freeze Panes l\u00e0 m\u1ed9t t\u00ednh n\u0103ng ti\u1ec7n d\u1ee5ng m\u00e0 ng\u01b0\u1eddi h\u1ecdc Excel gi\u00fap ti\u00eau \u0111\u1ec1 hay n\u1ed9i dung b\u1ea1n ch\u1ecdn v\u1eabn lu\u00f4n hi\u1ec7n, gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng quan s\u00e1t d\u00f9 b\u1ea1n c\u00f3 di chuy\u1ec3n \u0111\u1ebfn b\u1ea5t c\u1ee9 v\u1ecb tr\u00ed n\u00e0o trong b\u1ea3n t\u00ednh. \u0110\u00e2y l\u00e0 m\u1ed9t k\u1ef9 n\u0103ng h\u1ecdc Excel<\/strong> c\u1ea7n thi\u1ebft \u0111\u1ec3 bi\u1ebft \u0111\u1ec3 h\u1ed7 tr\u1ee3 vi\u1ec7c s\u1eed d\u1ee5ng Excel d\u1ec5 d\u00e0ng, \u0111\u1ed3ng th\u1eddi ti\u1ebft ki\u1ec7m th\u1eddi gian k\u00e9o chu\u1ed9t li\u00ean t\u1ee5c \u0111\u1ec3 quan s\u00e1t cho ng\u01b0\u1eddi d\u00f9ng.<\/p>\n

C\u00e1c ti\u00eau \u0111\u1ec1 cho b\u1ea3ng t\u00ednh th\u01b0\u1eddng ch\u1ec9 \u00e1p d\u1ee5ng \u1edf h\u00e0ng ph\u00eda tr\u00ean c\u00f9ng. \u0110\u1ec3 ghim c\u1ed1 \u0111\u1ecbnh h\u00e0ng n\u00e0y, h\u00e3y nh\u1ea5p v\u00e0o View > Freeze Panes > Freeze Top Row. \u0110i\u1ec1u \u0111\u00f3 \u00e1p d\u1ee5ng t\u01b0\u01a1ng t\u1ef1 khi b\u1ea1n mu\u1ed1n \u0111\u00f3ng b\u0103ng c\u1ed9t, th\u00ec h\u00e3y ch\u1ecdn Freeze Top Column. B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 c\u1ed1 \u0111\u1ecbnh bao nhi\u00eau h\u00e0ng v\u00e0 c\u1ed9t t\u00f9y th\u00edch, ch\u1ec9 c\u1ea7n ch\u1ecdn v\u00e0o h\u00e0ng b\u00ean d\u01b0\u1edbi h\u00e0ng cu\u1ed1i c\u00f9ng\/c\u1ed9t b\u00ean ph\u1ea3i c\u1ed9t cu\u1ed1i c\u00f9ng m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u00f3ng b\u0103ng.<\/p>\n

\"cac-phuong-phap-tu-hoc-excel-de-dang-va-hieu-qua-8\"<\/picture>
Freeze Panes<\/figcaption><\/figure>\n

Thu\u1ed9c c\u00f4ng th\u1ee9c Excel<\/strong><\/h3>\n

\u0110\u1ec3 th\u00e0nh th\u1ea1o Excel, b\u1ea1n kh\u00f4ng th\u1ec3 kh\u00f4ng n\u1eafm v\u1eefng c\u00f4ng th\u1ee9c<\/a>. T\u1eeb c\u00e1c c\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n nh\u1ea5t nh\u01b0 SUM, IF, COUNT, COUNTIF…cho \u0111\u1ebfn c\u00e1c c\u00f4ng th\u1ee9c n\u00e2ng cao h\u01a1n nh\u01b0 CONCATENATE, TRIM, SUBSTITUTE, VLOOKUP, HLOOKUP… n\u1ebfu b\u1ea1n bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m n\u00e0y, b\u1ea1n s\u1ebd \u00e1p d\u1ee5ng Excel d\u1ec5 d\u00e0ng h\u01a1n nhi\u1ec1u, b\u1edfi v\u00ec gi\u00e1 tr\u1ecb c\u1ed1t l\u00f5i c\u1ee7a Excel n\u1eb1m \u1edf c\u00e1c h\u00e0m c\u01a1 m\u00e0. M\u1ed9t khi b\u1ea1n c\u1ea3m th\u1ea5y c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c nhu\u1ea7n nhuy\u1ec5n, m\u1ecdi thao t\u00e1c tr\u00ean Excel c\u0169ng s\u1ebd tr\u1edf n\u00ean \u0111\u01a1n gi\u1ea3n h\u01a1n.<\/p>\n

\"cac-phuong-phap-tu-hoc-excel-de-dang-va-hieu-qua-9\"<\/picture>
C\u00f4ng th\u1ee9c l\u00e0 c\u1ed1t l\u00f5i c\u1ee7a Excel<\/figcaption><\/figure>\n

T\u1ea1o danh s\u00e1ch th\u1ea3 xu\u1ed1ng trong Excel<\/strong><\/h3>\n

M\u1ed9t danh s\u00e1ch th\u1ea3 xu\u1ed1ng (Drop List) r\u1ea5t h\u1eefu \u00edch \u0111\u1ec3 ki\u1ec3m so\u00e1t d\u1eef li\u1ec7u \u0111ang nh\u1eadp, \u0111\u1eb7c bi\u1ec7t khi nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng c\u00f9ng s\u1eed d\u1ee5ng m\u1ed9t t\u1eadp tin Excel.\u00a0B\u1eb1ng c\u00e1ch n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ea3m b\u1ea3o r\u1eb1ng h\u1ecd s\u1ebd kh\u00f4ng nh\u1eadp d\u1eef li\u1ec7u kh\u00f4ng ch\u00ednh x\u00e1c, \u0111i\u1ec1u n\u00e0y s\u1ebd t\u1ea1o ra l\u1ed7i trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n khi t\u00ednh to\u00e1n \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n d\u1ef1a tr\u00ean \u0111\u1ea7u v\u00e0o c\u1ee7a ng\u01b0\u1eddi d\u00f9ng. \u0110\u1ec3 t\u1ea1o danh s\u00e1ch th\u1ea3 xu\u1ed1ng trong Excel, b\u1ea1n l\u00e0m c\u00e1c b\u01b0\u1edbc sau:<\/p>\n

1. Ch\u1ecdn \u00f4 d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n t\u1ea1o danh s\u00e1ch cho n\u00f3<\/p>\n

2. Nh\u1ea5p v\u00e0o DATA > Data Validation.<\/p>\n

3. Chuy\u1ec3n \u0111\u1ebfn menu th\u1ea3 xu\u1ed1ng b\u00ean d\u01b0\u1edbi, ch\u1ecdn Allow r\u1ed3i ch\u1ecdn List.<\/p>\n

4. Sau \u0111\u00f3, h\u00e3y nh\u1eadp c\u00e1c m\u1ee5c b\u1ea1n mu\u1ed1n c\u00f3 th\u1ec3 ch\u1ecdn trong danh s\u00e1ch th\u1ea3 xu\u1ed1ng c\u1ee7a m\u00ecnh, m\u1ed7i m\u1ee5c ch\u1ec9 \u0111\u01b0\u1ee3c ph\u00e2n t\u00e1ch b\u1eb1ng d\u1ea5u ph\u1ea9y, ho\u1eb7c b\u1ea1n ch\u1ecdn m\u1ed9t d\u1ea3i \u00f4 c\u00f3 ch\u1ee9a c\u00e1c m\u1ee5c b\u1ea1n mu\u1ed1n \u0111\u01b0a v\u00e0o danh s\u00e1ch. Sau khi ho\u00e0n t\u1ea5t, b\u1ea1n nh\u1ea5n OK.<\/p>\n

\"cac-phuong-phap-tu-hoc-excel-de-dang-va-hieu-qua-10\"<\/picture>
DropDown List<\/figcaption><\/figure>\n

T\u00f3m t\u1eaft d\u1eef li\u1ec7u v\u1edbi PivotTable<\/strong><\/h3>\n

Ch\u1eafc h\u1eb3n ng\u01b0\u1eddi h\u1ecdc Excel<\/strong> n\u00e0o c\u0169ng \u0111\u00e3 nghe qua v\u1ec1 s\u1ef1 l\u1ee3i h\u1ea1i c\u1ee7a PivotTable. \u0110\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 \u0111\u1ea7y uy l\u1ef1c trong Excel, d\u00f9ng \u0111\u1ec3 t\u00ednh to\u00e1n, t\u00f3m t\u1eaft v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u cho ph\u00e9p b\u1ea1n xem c\u00e1c so s\u00e1nh, m\u1eabu v\u00e0 xu h\u01b0\u1edbng d\u1eef li\u1ec7u d\u1ec5 d\u00e0ng trong v\u00e0i n\u1ed1t nh\u1ea1c. N\u00f3 l\u1ea5y d\u1eef li\u1ec7u do ng\u01b0\u1eddi d\u00f9ng ch\u1ec9 \u0111\u1ecbnh v\u00e0 chuy\u1ec3n \u0111\u1ed5i ti\u00eau \u0111\u1ec1 c\u1ee7a m\u1ed7i c\u1ed9t th\u00e0nh m\u1ed9t t\u00f9y ch\u1ecdn d\u1eef li\u1ec7u theo y\u00eau c\u1ea7u. C\u00e1c c\u1ed9t ch\u1ee9a d\u1eef li\u1ec7u c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c lo\u1ea1i b\u1ecf, th\u00eam v\u00e0o ho\u1eb7c di chuy\u1ec3n d\u1ec5 d\u00e0ng, \u0111\u1ed3ng th\u1eddi gi\u00fap ng\u01b0\u1eddi d\u00f9ng d\u1ec5 quan s\u00e1t t\u1ed5ng quan. \u0110\u1ec3 t\u1ea1o PivotTable:<\/p>\n

1. Nh\u1ea5p v\u00e0o v\u00f9ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n PivotTable.<\/p>\n

2. Nh\u1ea5p v\u00e0o Ch\u00e8n > PivotTable. Thao t\u00e1c n\u00e0y s\u1ebd t\u1ea1o PivotTable d\u1ef1a tr\u00ean d\u1eef li\u1ec7u hi\u1ec7n c\u00f3<\/p>\n

3. Ch\u1ecdn n\u01a1i \u0111\u1ec3 xu\u1ea5t PivotTable (sheet \u0111ang thao t\u00e1c hi\u1ec7n t\u1ea1i ho\u1eb7c sheet m\u1edbi ho\u1eb7c l\u00e0 b\u1ea3ng t\u00ednh m\u1edbi)<\/p>\n

4. K\u00e9o th\u1ea3 c\u00e1c tr\u01b0\u1eddng b\u1ed1n khu v\u1ef1c t\u01b0\u01a1ng \u1ee9ng \u0111\u1ec3 t\u1ea1o PivotTable<\/p>\n

\"cac-phuong-phap-tu-hoc-excel-de-dang-va-hieu-qua-11\"<\/picture>
PivotTable<\/figcaption><\/figure>\n

Power Query v\u00e0 Power Pivot<\/strong><\/h3>\n

Power Query l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 c\u00f3 s\u1eb5n trong Excel cho ph\u00e9p b\u1ea1n nh\u1eadp d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u ngu\u1ed3n kh\u00e1c nhau, sau \u0111\u00f3 l\u00e0m s\u1ea1ch, chuy\u1ec3n \u0111\u1ed5i v\u00e0 \u0111\u1ecbnh h\u00ecnh l\u1ea1i d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n n\u1ebfu c\u1ea7n. B\u1ea1n c\u00f3 th\u1ec3 t\u00ecm th\u1ea5y n\u00f3 tr\u00ean tab Data c\u1ee7a Ribbon. Ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 nh\u1eadp v\u00e0 x\u00f3a h\u00e0ng tri\u1ec7u h\u00e0ng v\u00e0o m\u00f4 h\u00ecnh d\u1eef li\u1ec7u r\u1ed3i ti\u1ebfn h\u00e0nh ph\u00e2n t\u00edch sau \u0111\u00f3. Giao di\u1ec7n c\u1ee7a c\u00f4ng c\u1ee5 n\u00e0y tr\u1ef1c quan v\u00e0 \u0111\u01b0\u1ee3c b\u1ed1 tr\u00ed h\u1ee3p l\u00fd n\u00ean c\u0169ng r\u1ea5t d\u1ec5 s\u1eed d\u1ee5ng.<\/p>\n

V\u1ec1 Power Pivot, \u0111\u00e2y l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 b\u1ed5 tr\u1ee3 c\u00f3 s\u1eb5n trong Excel. N\u00f3 \u0111\u01b0a m\u1ed9t s\u1ed1 ch\u1ee9c n\u0103ng quan tr\u1ecdng v\u00e0o trung t\u00e2m c\u1ee7a Excel, cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng c\u00f3 \u0111\u01b0\u1ee3c th\u00f4ng tin chuy\u00ean s\u00e2u nhanh h\u01a1n. Ch\u1ee9c n\u0103ng n\u00e0y bao g\u1ed3m l\u1eadp m\u00f4 h\u00ecnh d\u1eef li\u1ec7u, t\u0103ng dung l\u01b0\u1ee3ng d\u1eef li\u1ec7u so v\u1edbi trang t\u00ednh Excel v\u00e0 ng\u00f4n ng\u1eef trong c\u00e1c c\u00f4ng c\u1ee5 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ea1nh m\u1ebd DAX.<\/p>\n

N\u1ebfu b\u1ea1n mu\u1ed1n h\u1ecdc Excel n\u00e2ng cao sau khi n\u1eafm v\u1eefng m\u1ecdi ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n, hai c\u00f4ng c\u1ee5 n\u00e0y ch\u00ednh l\u00e0 “v\u00f9ng \u0111\u1ea5t l\u00fd t\u01b0\u1edfng” \u0111\u1ec3 b\u1ea1n kh\u00e1m ph\u00e1. N\u1eafm v\u1eefng thao t\u00e1c v\u1ec1 hai c\u00f4ng c\u1ee5 quy\u1ec1n l\u1ef1c n\u00e0y s\u1ebd gi\u00fap b\u1ea1n chi\u1ebfm \u01b0u th\u1ebf v\u01b0\u1ee3t tr\u1ed9i so v\u1edbi ng\u01b0\u1eddi h\u1ecdc Excel<\/strong> th\u00f4ng th\u01b0\u1eddng, \u0111\u1eb7c bi\u1ec7t khi b\u1ea1n c\u1ea7n ph\u00e2n t\u00edch s\u1ed1 l\u01b0\u1ee3ng d\u1eef li\u1ec7u kh\u1ed5ng l\u1ed3 v\u00e0 ph\u1ee9c t\u1ea1p.<\/p>\n

\"cac-phuong-phap-tu-hoc-excel-de-dang-va-hieu-qua-12\"<\/picture>
Power Query v\u00e0 Power Pivot<\/figcaption><\/figure>\n

Nh\u00ecn chung tuy Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 r\u1ea5t ph\u1ed5 bi\u1ebfn nh\u01b0ng \u0111\u1ec3 kh\u00e1m ph\u00e1 h\u1ebft nh\u1eefng t\u00ednh n\u0103ng m\u1ea1nh m\u1ebd c\u1ee7a n\u00f3 th\u00ec c\u1ea7n ng\u01b0\u1eddi h\u1ecdc ph\u1ea3i \u0111\u1ea7u t\u01b0 v\u1ec1 th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c, \u0111\u1eb7c bi\u1ec7t l\u00e0 kh\u00f4ng qu\u00ean th\u01b0\u1eddng xuy\u00ean th\u1ef1c h\u00e0nh nh\u00e9. Hy v\u1ecdng nh\u1eefng chia s\u1ebb h\u1eefu \u00edch tr\u00ean s\u1ebd gi\u00fap \u00edch cho nh\u1eefng ai \u0111ang v\u00e0 c\u00f3 d\u1ef1 \u0111\u1ecbnh h\u1ecdc Excel.<\/strong><\/p>\n

Th\u00f4ng tin tr\u00ean \u0111\u1ec1u do Ho\u00e0ng H\u00e0 Mobile t\u1ed5ng h\u1ee3p. \u0110\u1eebng qu\u00ean theo d\u00f5i fanpage Ho\u00e0ng H\u00e0 Mobile<\/a>\u00a0\u0111\u1ec3 c\u1eadp nh\u1eadt c\u00e1c tin t\u1ee9c c\u00f4ng ngh\u1ec7 m\u1edbi nh\u1ea5t nh\u00e9!<\/p>\n

Tham gia\u00a0Ho\u00e0ng H\u00e0 Mobile\u00a0Group<\/a>\u00a0\u0111\u1ec3 c\u1eadp nh\u1eadt nh\u1eefng ch\u01b0\u01a1ng tr\u00ecnh v\u00e0 \u01b0u \u0111\u00e3i s\u1edbm nh\u1ea5t<\/p><\/blockquote>\n

Xem th\u00eam:<\/strong><\/em> REDMIBOOK 15: 8 tri\u1ec7u cho m\u1ed9t chi\u1ebfc laptop TO\u00c0N DI\u1ec6N ?!!<\/p>\n