{"id":4416,"date":"2024-12-05T05:11:31","date_gmt":"2024-12-05T05:11:31","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/05\/thay-doi-cach-to-chuc-du-lieu-tren-excel-giup-cong-viec-de-dang-hon\/"},"modified":"2024-12-05T05:11:31","modified_gmt":"2024-12-05T05:11:31","slug":"thay-doi-cach-to-chuc-du-lieu-tren-excel-giup-cong-viec-de-dang-hon","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/05\/thay-doi-cach-to-chuc-du-lieu-tren-excel-giup-cong-viec-de-dang-hon\/","title":{"rendered":"Thay \u0111\u1ed5i c\u00e1ch t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u tr\u00ean Excel gi\u00fap c\u00f4ng vi\u1ec7c d\u1ec5 d\u00e0ng h\u01a1n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">\u201cN\u1ebfu kh\u00f4ng bi\u1ebft c\u00e1ch t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u tr\u00ean\u00a0Excel cho t\u1ed1t, ch\u00fang ta s\u1ebd g\u1eb7p nhi\u1ec1u kh\u00f3 kh\u0103n khi l\u00e0m vi\u1ec7c,\u00a0\u0111\u00f4i khi c\u00f2n b\u1ebf t\u1eafc khi kh\u00f4ng th\u1ec3\u00a0th\u1ed1ng k\u00ea, b\u00e1o c\u00e1o tr\u00ean d\u1eef li\u1ec7u\u00a0\u0111\u00f3\u201d.\u00a0\u0110\u00e2y l\u00e0 chia s\u1ebb c\u1ee7a anh Nguy\u1ec5n H\u1eefu An. Anh hi\u1ec7n\u00a0\u0111ang l\u00e0 h\u1ecdc vi\u00ean c\u1ee7a kh\u00f3a h\u1ecdc K\u1ef9 n\u0103ng l\u1eadp b\u00e1o c\u00e1o \u2013 EX201 t\u1ea1i H\u1ecdc\u00a0Excel Online.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-29244\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/huu-an-ex201-1024x656-1.png\" width=\"600\" height=\"384\" title=\"huu-an-ex201-1024x656-1\"><\/p>\n<p style=\"text-align: justify\"><strong>H\u1ecdc\u00a0Excel Online<\/strong>: <strong>Ch\u00e0o anh An, \u0111\u01b0\u1ee3c bi\u1ebft v\u1eeba qua\u00a0anh \u0111\u00e3 \u00e1p d\u1ee5ng ki\u1ebfn th\u1ee9c h\u1ecdc \u0111\u01b0\u1ee3c v\u00e0o c\u00f4ng vi\u1ec7c v\u00e0 \u0111\u1ea1t hi\u1ec7u qu\u1ea3. Anh c\u00f3 th\u1ec3 gi\u1edbi thi\u1ec7u m\u1ed9t ch\u00fat v\u1ec1 c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh\u00a0\u0111\u01b0\u1ee3c kh\u00f4ng?<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>H\u1eefu An<\/strong>: Ch\u00e0o em, hi\u1ec7n anh\u00a0\u0111ang l\u00e0m tr\u01b0\u1edfng\u00a0ph\u00f2ng\u00a0qu\u1ea3n l\u00fd thi\u1ebft b\u1ecb, t\u00e0i s\u1ea3n c\u1ee7a t\u1eadp\u00a0\u0111o\u00e0n HMD. C\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y c\u1ee7a anh l\u00e0 gi\u00e1m s\u00e1t t\u00ecnh\u00a0tr\u1ea1ng c\u1ee7a c\u00e1c thi\u1ebft b\u1ecb, t\u00e0i s\u1ea3n d\u00f9ng\u00a0\u1edf c\u00e1c v\u0103n ph\u00f2ng, chi nh\u00e1nh\u00a0trong t\u1eadp\u00a0\u0111o\u00e0n: vi\u1ec7c mua s\u1eafm m\u1edbi thi\u1ebft b\u1ecb, s\u1eeda ch\u1eefa nh\u1eefng \u0111\u1ed3 b\u1ecb h\u1ecfng,\u00a0\u0111i\u1ec1u chuy\u1ec3n thi\u1ebft b\u1ecb gi\u1eefa c\u00e1c ph\u00f2ng ban\u2026 v\u00e0\u00a0\u0111\u1ecbnh k\u1ef3 c\u1ea7n b\u00e1o c\u00e1o t\u1ed5ng k\u1ebft c\u00f4ng vi\u1ec7c v\u1edbi ban Gi\u00e1m\u00a0\u0111\u1ed1c. Ngo\u00e0i ra c\u00f2n c\u00f3 nh\u1eefng c\u00f4ng vi\u1ec7c nh\u01b0 l\u1eadp k\u1ebf ho\u1ea1ch cho nh\u1eefng c\u00f4ng vi\u1ec7c mua s\u1eafm, s\u1eeda ch\u1eefa t\u00e0i s\u1ea3n, thi\u1ebft b\u1ecb.<\/p>\n<p style=\"text-align: justify\"><strong>H\u1ecdc\u00a0Excel Online<\/strong>:\u00a0<strong>Hi\u1ec7n anh\u00a0\u0111ang d\u00f9ng c\u00f4ng c\u1ee5 n\u00e0o\u00a0\u0111\u1ec3 qu\u1ea3n l\u00fd c\u00f4ng vi\u1ec7c\u00a0\u1ea1?<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>H\u1eefu An<\/strong>:\u00a0\u00c0, b\u00ean anh d\u00f9ng\u00a0excel\u00a0\u0111\u1ec3 qu\u1ea3n l\u00fd c\u00f4ng vi\u1ec7c th\u00f4i.\u00a0V\u00ec\u00a0excel r\u1ea5t ph\u1ed5 bi\u1ebfn v\u00e0 h\u1ea7u nh\u01b0 ai c\u0169ng s\u1eed d\u1ee5ng\u00a0\u0111\u01b0\u1ee3c m\u00e0 em.\u00a0\u0110\u1eb7c th\u00f9 c\u00f4ng vi\u1ec7c c\u1ee7a anh l\u00e0 th\u00f4ng tin nhi\u1ec1u th\u00f4i ch\u1ee9 kh\u00f4ng qu\u00e1 ph\u1ee9c t\u1ea1p. Quy tr\u00ecnh c\u00f4ng vi\u1ec7c r\u00f5 r\u00e0ng theo t\u1eebng nghi\u1ec7p v\u1ee5 do\u00a0\u0111\u00f3 d\u00f9ng\u00a0excel l\u00e0 c\u00f3 th\u1ec3\u00a0\u0111\u00e1p\u00a0\u1ee9ng\u00a0\u0111\u01b0\u1ee3c y\u00eau c\u1ea7u r\u1ed3i.<\/p>\n<p style=\"text-align: justify\"><strong>H\u1ecdc\u00a0Excel Online: Anh c\u00f3 th\u1ec3 chia s\u1ebb m\u1ed9t ch\u00fat v\u1ec1 nh\u1eefng v\u1ea5n\u00a0\u0111\u1ec1 tr\u01b0\u1edbc\u00a0\u0111\u00e2y m\u00e0 anh g\u1eb7p ph\u1ea3i kh\u00f4ng?<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>H\u1eefu An<\/strong>:\u00a0B\u00ean anh\u00a0l\u00e0 m\u00f4 h\u00ecnh t\u1eadp\u00a0\u0111o\u00e0n n\u00ean c\u00f3 s\u1ef1 ph\u00e2n c\u1ea5p: g\u1ed3m nhi\u1ec1u kh\u1ed1i\u00a0\u0111\u01a1n v\u1ecb, trong m\u1ed7i kh\u1ed1i l\u1ea1i c\u00f3 nhi\u1ec1u v\u0103n ph\u00f2ng, chi nh\u00e1nh kh\u00e1c nhau. Do\u00a0\u0111\u00f3\u00a0\u0111\u1ec3 qu\u1ea3n l\u00fd\u00a0\u0111\u01b0\u1ee3c th\u00ec v\u1edbi t\u1eebng v\u0103n ph\u00f2ng, chi nh\u00e1nh c\u1ea7n theo d\u00f5i tr\u00ean 1 file\u00a0excel ri\u00eang. Sau\u00a0\u0111\u00f3 anh ph\u1ea3i t\u1eadp h\u1ee3p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u file\u00a0excel\u00a0\u0111\u00f3 l\u1ea1i v\u00e0o chung 1 file\u00a0excel t\u1ed5ng h\u1ee3p\u00a0\u0111\u1ec3 b\u00e1o c\u00e1o chung cho to\u00e0n b\u1ed9 c\u00e1c kh\u1ed1i, cho c\u1ea3 t\u1eadp\u00a0\u0111o\u00e0n. L\u01b0\u1ee3ng d\u1eef li\u1ec7u l\u00e0 kh\u00e1 l\u1edbn em\u00a0\u1ea1. Tr\u01b0\u1edbc\u00a0\u0111\u00e2y anh ch\u01b0a bi\u1ebft l\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u khoa h\u1ecdc h\u01a1n n\u00ean c\u1ee9 l\u00e0m theo kinh nghi\u1ec7m th\u00f4i. C\u0169ng v\u00ec d\u1eef li\u1ec7u ch\u01b0a\u00a0\u0111\u01b0\u1ee3c t\u1ed5 ch\u1ee9c khoa h\u1ecdc n\u00ean anh g\u1eb7p 1 v\u00e0i v\u1ea5n\u00a0\u0111\u1ec1 nh\u01b0:<\/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\/2024\/12\/ex101_92019-nho-357.gif\" title=\"ex101_92019-nho-357\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul style=\"text-align: justify\">\n<li>D\u1eef li\u1ec7u nhi\u1ec1u ng\u01b0\u1eddi nh\u1eadp n\u00ean kh\u00f4ng ki\u1ec3m so\u00e1t\u00a0\u0111\u01b0\u1ee3c sai s\u00f3t. Ai nh\u1eadp c\u1ea9n th\u1eadn th\u00ec\u00a0\u00edt l\u1ed7i, ai nh\u1eadp\u00a0\u1ea9u th\u00ec l\u1ed7i nhi\u1ec1u. L\u00fac t\u1ed5ng h\u1ee3p l\u1ea1i anh ph\u1ea3i m\u1ea5t nhi\u1ec1u c\u00f4ng r\u00e0 so\u00e1t c\u00e1c l\u1ed7i.<\/li>\n<li>D\u1eef li\u1ec7u d\u1ec5 b\u1ecb tr\u00f9ng l\u1eb7p,\u00a0\u0111\u1eb7c bi\u1ec7t l\u00e0 khi c\u00f3 s\u1ef1\u00a0\u0111i\u1ec1u chuy\u1ec3n t\u1eeb v\u0103n ph\u00f2ng n\u00e0y sang v\u0103n ph\u00f2ng kh\u00e1c. B\u1edfi v\u00ec\u00a0\u0111\u1ec3\u00a0\u0111\u1ea3m b\u1ea3o th\u00f4ng tin\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7, anh y\u00eau c\u1ea7u c\u00e1c b\u1ea1n ph\u1ea3i ghi ch\u00e9p h\u1ebft th\u00f4ng tin v\u00e0o file\u00a0excel. N\u00ean c\u00f3 s\u1ef1 tr\u00f9ng th\u00f4ng tin khi \u1edf c\u1ea3 2\u00a0\u0111\u01a1n v\u1ecb c\u00f9ng theo d\u00f5i 1 vi\u1ec7c. Tr\u01b0\u1eddng h\u1ee3p n\u00e0y anh c\u0169ng ph\u1ea3i r\u00e0 so\u00e1t l\u1ea1i th\u1ee7 c\u00f4ng, b\u1edfi n\u1ebfu kh\u00f4ng theo d\u00f5i c\u00f2n\u00a0\u1ea3nh h\u01b0\u1edfng nhi\u1ec1u h\u01a1n.<\/li>\n<li>B\u00e1o c\u00e1o anh ph\u1ea3i l\u00e0m theo nhi\u1ec1u c\u1ea5p n\u00ean kh\u00e1 l\u00e0 ph\u1ee9c t\u1ea1p. C\u00f3 l\u00fac c\u00f4ng th\u1ee9c anh d\u00f9ng kh\u00f4ng ra k\u1ebft qu\u1ea3\u00a0\u0111\u00fang m\u00e0 kh\u00f4ng r\u00f5 nguy\u00ean nh\u00e2n t\u1ea1i sao. V\u1edbi nh\u1eefng y\u00eau c\u1ea7u b\u00e1o c\u00e1o ph\u1ee9c t\u1ea1p c\u00f3 khi ph\u1ea3i l\u1ecdc r\u1ed3i th\u1ed1ng k\u00ea l\u1ea1i th\u1ee7 c\u00f4ng ch\u1ee9 kh\u00f4ng bi\u1ebft vi\u1ebft c\u00f4ng th\u1ee9c th\u1ebf n\u00e0o.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>H\u1ecdc\u00a0Excel Online:\u00a0Do\u00a0\u0111\u00e2u m\u00e0 anh bi\u1ebft t\u1edbi H\u1ecdc\u00a0Excel Online? Anh c\u00f3 th\u1ec3 chia s\u1ebb cho em v\u00e0 c\u00e1c b\u1ea1n bi\u1ebft l\u00fd do t\u1ea1i sao anh l\u1ea1i\u00a0\u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y\u00a0\u0111\u01b0\u1ee3c kh\u00f4ng\u00a0\u1ea1?<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>H\u1eefu An<\/strong>:\u00a0C\u00f4ng vi\u1ec7c c\u00f3 nh\u1eefng v\u1ea5n\u00a0\u0111\u1ec1 nh\u01b0 th\u1ebf th\u00ec anh c\u0169ng tr\u0103n tr\u1edf l\u1eafm em\u00a0\u1ea1.\u00a0Anh v\u00e0 c\u00e1c b\u1ea1n trong ph\u00f2ng c\u0169ng kh\u00f4ng ph\u1ea3i y\u1ebfu k\u00e9m v\u1ec1\u00a0Excel. Nh\u01b0ng m\u1ed7i ng\u01b0\u1eddi c\u00f3 1 chuy\u00ean m\u00f4n nh\u1ea5t\u00a0\u0111\u1ecbnh th\u00f4i, kh\u00f3 m\u00e0 l\u00e0m t\u1ed1t h\u1ebft\u00a0\u0111\u01b0\u1ee3c,\u00a0\u0111\u1eb7c bi\u1ec7t l\u00e0 t\u01b0 duy v\u1ec1 t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u l\u00e0 c\u00e1i kh\u00f3. M\u00ecnh l\u00e0 ng\u01b0\u1eddi qu\u1ea3n l\u00fd, mu\u1ed1n c\u00f4ng vi\u1ec7c t\u1ed1t h\u01a1n th\u00ec m\u00ecnh ph\u1ea3i ch\u1ee7\u00a0\u0111\u1ed9ng t\u00ecm c\u00e1ch v\u01b0\u1ee3t qua kh\u00f3 kh\u0103n, m\u00ecnh ph\u1ea3i thay\u00a0\u0111\u1ed5i tr\u01b0\u1edbc. V\u00ec th\u1ebf n\u00ean anh quy\u1ebft\u00a0\u0111\u1ecbnh\u00a0t\u00ecm l\u1edbp\u00a0\u0111\u1ec3 h\u1ecdc c\u00e1ch t\u01b0 duy, t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u sao cho hi\u1ec7u qu\u1ea3.<\/p>\n<p style=\"text-align: justify\">Anh tham kh\u1ea3o c\u1ea3 tr\u00ean m\u1ea1ng l\u1eabn ng\u01b0\u1eddi quen gi\u1edbi thi\u1ec7u th\u00ec\u00a0c\u0169ng t\u00ecm \u0111\u01b0\u1ee3c nhi\u1ec1u n\u01a1i. M\u00e0 v\u1ec1 th\u1eddi gian th\u00ec anh l\u1ea1i b\u1ecb h\u1ea1n ch\u1ebf, kh\u00f3 m\u00e0\u00a0\u0111\u1ebfn h\u1ecdc\u00a0\u1edf c\u00e1c l\u1edbp\u00a0offline d\u1ea1ng trung t\u00e2m\u00a0\u0111\u01b0\u1ee3c. N\u00ean anh t\u00ecm hi\u1ec3u l\u1edbp Online qua m\u1ea1ng xem th\u1ebf n\u00e0o.\u00a0Kh\u00f4ng r\u00f5 anh t\u00ecm kh\u00f4ng ra hay sao ch\u1ee9 anh th\u1ea5y c\u00f3 m\u1ed7i hocexcel.online l\u00e0 c\u00f3 kh\u00f3a h\u1ecdc v\u1ec1 k\u1ef9 n\u0103ng t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u v\u00e0 b\u00e1o c\u00e1o tr\u00ean\u00a0Excel th\u00f4i, m\u00e0 kh\u00f3a n\u00e0y l\u00e0 c\u1ee7a th\u1ea7y Qu\u00e2n d\u1ea1y ch\u1ee9 kh\u00f4ng ph\u1ea3i th\u1ea7y Thanh. Th\u1ea7y Thanh th\u00ec anh bi\u1ebft v\u00ec th\u1ea7y n\u1ed5i ti\u1ebfng v\u1ec1 d\u1ea1y\u00a0excel\u00a0\u1edf Vi\u1ec7t Nam r\u1ed3i. Nh\u01b0ng th\u1ea7y Qu\u00e2n th\u00ec anh ch\u01b0a bi\u1ebft ti\u1ebfng n\u00ean l\u00fac\u00a0\u0111\u1ea7u e d\u00e8 l\u1eafm. Sau anh th\u1eed add facebook c\u1ee7a th\u1ea7y Qu\u00e2n v\u00e0 h\u1ecfi chuy\u1ec7n xem sao. L\u00fac h\u1ecfi chuy\u1ec7n th\u1ea5y th\u1ea7y nhi\u1ec7t t\u00ecnh n\u00ean c\u0169ng c\u00f3 thi\u1ec7n c\u1ea3m. Anh th\u1eed h\u1ecfi th\u1ea7y 1 v\u00e0i t\u00ecnh hu\u1ed1ng xem c\u00e1ch gi\u1ea3i quy\u1ebft c\u1ee7a th\u1ea7y th\u1ebf n\u00e0o. L\u00fac xem k\u1ebft qu\u1ea3 anh th\u1ea5y b\u1ea5t ng\u1edd l\u1eafm. Th\u1ea7y tr\u1ebb m\u00e0 t\u01b0 duy r\u1ea5t t\u1ed1t. Khi th\u1eed thay\u00a0\u0111\u1ed5i c\u00e1ch t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u theo ki\u1ec3u c\u1ee7a th\u1ea7y, nh\u1eefng v\u1ea5n\u00a0\u0111\u1ec1 trong c\u00f4ng vi\u1ec7c tr\u1edf n\u00ean r\u00f5 r\u00e0ng h\u01a1n, nh\u1edd th\u1ebf m\u00e0 t\u1ef1 nhi\u00ean anh ngh\u0129 ti\u1ebfp\u00a0\u0111\u01b0\u1ee3c c\u00e1ch gi\u1ea3i quy\u1ebft v\u1ea5n\u00a0\u0111\u1ec1 trong th\u1ef1c t\u1ebf c\u00f4ng vi\u1ec7c. Th\u1ebf l\u00e0 anh quy\u1ebft\u00a0\u0111\u1ecbnh h\u1ecdc kh\u00f3a h\u1ecdc\u00a0K\u1ef9 n\u0103ng l\u1eadp b\u00e1o c\u00e1o \u2013 EX201\u00a0\u0111\u1ec3 xem c\u1ee5 th\u1ec3 ki\u1ebfn th\u1ee9c trong kh\u00f3a h\u1ecdc n\u00e0y th\u1ebf n\u00e0o.<\/p>\n<p style=\"text-align: justify\"><strong>H\u1ecdc\u00a0Excel Online:\u00a0V\u00e2ng, r\u1ea5t c\u1ea3m\u00a0\u01a1n anh\u00a0\u0111\u00e3 tin t\u01b0\u1edfng v\u00e0 tham gia h\u1ecdc. Trong qu\u00e1 tr\u00ecnh h\u1ecdc t\u1eadp tr\u00ean h\u1ec7 th\u1ed1ng anh c\u00f3 g\u1eb7p kh\u00f3 kh\u0103n g\u00ec kh\u00f4ng\u00a0\u1ea1?<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>H\u1eefu An<\/strong>: L\u00fac\u00a0\u0111\u1ea7u anh c\u0169ng b\u1ed1i r\u1ed1i kh\u00f4ng bi\u1ebft n\u00ean b\u1eaft\u00a0\u0111\u1ea7u th\u1ebf n\u00e0o, v\u00ec\u00a0\u0111\u00e2y l\u00e0 l\u1ea7n\u00a0\u0111\u1ea7u ti\u00ean anh tham gia 1 kh\u00f3a h\u1ecdc online m\u00e0. Sau xem v\u00e0i l\u1ea7n th\u00ec c\u0169ng quen. C\u1ee9 xem l\u1ea7n l\u01b0\u1ee3t t\u1eebng b\u00e0i l\u00e0\u00a0\u0111\u01b0\u1ee3c. L\u00fac h\u1ecdc quen r\u1ed3i th\u00ec kh\u00f4ng g\u1eb7p v\u1ea5n\u00a0\u0111\u1ec1 g\u00ec n\u1eefa. Trong kh\u00f3a h\u1ecdc n\u00e0y v\u1eeba c\u00f3 b\u00e0i gi\u1ea3ng, v\u1eeba c\u00f3 c\u1ea3 b\u00e0i t\u1eadp v\u00e0 b\u00e0i ki\u1ec3m tra n\u1eefa. R\u1ea5t hay\u00a0\u0111\u00f3!\u00a0v\u1eeba h\u1ecdc v\u1eeba th\u1ef1c h\u00e0nh theo n\u00ean d\u1ec5 hi\u1ec3u. C\u00f3 l\u1ebd v\u1ea5n\u00a0\u0111\u1ec1 l\u1edbn nh\u1ea5t l\u00e0 anh ph\u1ea3i h\u1ecdc bu\u1ed5i t\u1ed1i l\u00fac\u00a0\u1edf nh\u00e0 ch\u1ee9 kh\u00f4ng h\u1ecdc\u00a0\u1edf c\u00f4ng ty\u00a0\u0111\u01b0\u1ee3c. S\u1ee3 m\u1ea5y\u00a0\u0111\u1ee9a nh\u00e2n vi\u00ean c\u1ea5p d\u01b0\u1edbi bi\u1ebft m\u00ecnh\u00a0\u0111i h\u1ecdc th\u00eam\u00a0excel n\u00f3 l\u1ea1i c\u01b0\u1eddi m\u00ecnh \u2026 (c\u01b0\u1eddi)\u2026<\/p>\n<p style=\"text-align: justify\"><strong>H\u1ecdc\u00a0Excel Online:\u00a0Vi\u1ec7c thay\u00a0\u0111\u1ed5i\u00a0 c\u00e1ch t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u\u00a0\u0111\u00e3 gi\u00fap anh qu\u1ea3n l\u00fd c\u00f4ng vi\u1ec7c t\u1ed1t h\u01a1n. Anh c\u00f3 th\u1ec3 chia s\u1ebb r\u00f5 h\u01a1n\u00a0\u0111i\u1ec1u n\u00e0y cho em v\u00e0 c\u00e1c b\u1ea1n bi\u1ebft th\u00eam \u0111\u01b0\u1ee3c kh\u00f4ng\u00a0\u1ea1? V\u00ec r\u1ea5t nhi\u1ec1u b\u1ea1n c\u00f3 chung th\u1eafc m\u1eafc n\u00e0y.<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>H\u1eefu An<\/strong>: V\u00ed d\u1ee5 nh\u00e9, v\u1edbi 1 thi\u1ebft b\u1ecb v\u0103n ph\u00f2ng, b\u00ean anh v\u1eeba ph\u1ea3i theo d\u00f5i hi\u1ec7n tr\u1ea1ng xem thi\u1ebft b\u1ecb\u00a0\u0111\u00f3\u00a0\u0111ang\u00a0\u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng hay kh\u00f4ng. R\u1ed3i v\u1eabn thi\u1ebft b\u1ecb\u00a0\u0111\u00f3 ngu\u1ed3n g\u1ed1c h\u00ecnh th\u00e0nh th\u1ebf n\u00e0o, do mua s\u1eafm hay do chuy\u1ec3n t\u1eeb\u00a0\u0111\u01a1n v\u1ecb kh\u00e1c\u00a0\u0111\u1ebfn. N\u1ebfu thi\u1ebft b\u1ecb\u00a0\u0111\u00f3 chuy\u1ec3n\u00a0\u0111i n\u01a1i kh\u00e1c th\u00ec theo d\u00f5i, ghi ch\u00e9p th\u1ebf n\u00e0o. L\u00fac\u00a0\u0111\u1ea7u c\u00e1c b\u1ea1n kh\u00f4ng ph\u00e2n chia r\u00f5 r\u00e0ng nh\u1eefng\u00a0\u0111\u1eb7c\u00a0\u0111i\u1ec3m n\u00e0y, b\u1ecb l\u1eabn v\u1edbi nhau. N\u1ebfu chia r\u00f5 ra th\u00ec bao g\u1ed3m 2 t\u00ednh ch\u1ea5t l\u00e0 Tr\u1ea1ng th\u00e1i\u00a0\u0111\u1ec3 xem x\u00e9t t\u00ecnh tr\u1ea1ng s\u1eed d\u1ee5ng, Ho\u1ea1t\u00a0\u0111\u1ed9ng\u00a0\u0111\u1ec3 xem x\u00e9t s\u1ef1 v\u1eadn\u00a0\u0111\u1ed9ng, lu\u00e2n chuy\u1ec3n thi\u1ebft b\u1ecb. V\u00ec kh\u00f4ng l\u00e0m r\u00f5 v\u1ea5n\u00a0\u0111\u1ec1 n\u00e0y n\u00ean khi b\u00e1o c\u00e1o th\u1ed1ng k\u00ea s\u1ebd d\u1ec5 b\u1ecb nh\u1ea7m l\u1eabn.<\/p>\n<p style=\"text-align: justify\">Ch\u01b0a k\u1ec3 c\u00f3 khi c\u00e1c b\u1ea1n nh\u1eadp sai m\u1ed9t d\u1ea5u c\u00e1ch th\u00f4i c\u0169ng l\u00e0m c\u00f4ng th\u1ee9c t\u00ednh b\u1ecb sai lu\u00f4n. N\u00ean anh\u00a0\u0111\u00e3 h\u1ecdc c\u00e1ch qu\u1ea3n l\u00fd d\u1eef li\u1ec7u theo quy tr\u00ecnh 4 b\u01b0\u1edbc trong kh\u00f3a h\u1ecdc: Nh\u1eadp m\u1edbi d\u1eef li\u1ec7u th\u00ec ph\u1ea3i theo\u00a0\u0111i\u1ec1u ki\u1ec7n, ph\u1ea3i c\u00f3 qu\u1ea3n l\u00fd t\u1eeb l\u00fac nh\u1eadp v\u00e0o. L\u00fac s\u1eeda, x\u00f3a c\u0169ng ph\u1ea3i theo quy tr\u00ecnh ch\u1ee9 kh\u00f4ng\u00a0\u0111\u01b0\u1ee3c t\u1ef1\u00a0\u00fd l\u00e0m b\u1eeba b\u00e3i. Khi t\u1eadp trung v\u00e0o qu\u1ea3n l\u00fd d\u1eef li\u1ec7u cho t\u1ed1t, cho ch\u00ednh x\u00e1c th\u00ec anh\u00a0\u0111\u1ee1\u00a0\u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u c\u00f4ng khi t\u1eadp h\u1ee3p d\u1eef li\u1ec7u. L\u00fac\u00a0\u1ea5y ch\u1ec9 c\u1ea7n d\u00f9ng 1 h\u00e0m SUMIFS nh\u01b0 th\u1ea7y h\u01b0\u1edbng d\u1eabn l\u00e0 ra\u00a0\u0111\u00fang k\u1ebft qu\u1ea3 lu\u00f4n. D\u00f9 t\u00ednh theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n ph\u1ee9c t\u1ea1p th\u00ec anh v\u1eabn ch\u1ec9 d\u00f9ng 1 h\u00e0m n\u00e0y l\u00e0 xong, r\u1ea5t ti\u1ec7n l\u1ee3i. Tr\u01b0\u1edbc anh c\u1ee9 ngh\u0129 ph\u1ea3i h\u1ecdc nhi\u1ec1u h\u00e0m, ph\u1ea3i vi\u1ebft nh\u1eefng h\u00e0m kh\u00f3,\u00a0\u00edt ng\u01b0\u1eddi bi\u1ebft th\u00ec m\u1edbi g\u1ecdi l\u00e0\u00a0Excel n\u00e2ng cao. Nh\u01b0ng sau n\u00e0y m\u1edbi bi\u1ebft m\u00ecnh nh\u1ea7m. T\u1eadp trung ki\u1ec3m so\u00e1t d\u1eef li\u1ec7u, t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u khoa h\u1ecdc m\u1edbi gi\u00fap gi\u1ea3i quy\u1ebft v\u1ea5n\u00a0\u0111\u1ec1.<\/p>\n<p style=\"text-align: justify\"><strong>H\u1ecdc\u00a0Excel Online: C\u1ea3m\u00a0\u01a1n anh v\u1ec1 nh\u1eefng chia s\u1ebb h\u1ebft s\u1ee9c ch\u00e2n th\u00e0nh! Anh c\u00f3 l\u1eddi khuy\u00ean n\u00e0o cho nh\u1eefng b\u1ea1n\u00a0\u0111ang c\u00f3 d\u1ef1 \u0111\u1ecbnh tham gia\u00a0kh\u00f3a h\u1ecdc n\u00e0y kh\u00f4ng\u00a0\u1ea1?<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>H\u1eefu An<\/strong>:\u00a0B\u00e2y gi\u1edd c\u00e1c c\u00f4ng ty\u00a0\u0111\u1ec1u\u00a0y\u00eau c\u1ea7u nh\u00e2n vi\u00ean l\u00e0m vi\u1ec7c nhanh v\u00e0 hi\u1ec7u qu\u1ea3 tr\u00ean\u00a0Excel. M\u00e0\u00a0\u0111\u1ec3 l\u00e0m nhanh v\u00e0 hi\u1ec7u qu\u1ea3, ngo\u00e0i h\u1ecdc\u00a0\u0111\u1ec3 bi\u1ebft c\u00e1c h\u00e0m v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng\u00a0Excel, c\u00e1c em c\u1ea7n ph\u1ea3i hi\u1ec3u v\u1ec1 d\u1eef li\u1ec7u, hi\u1ec3u v\u1ec1 c\u00e1ch\u00a0Excel ho\u1ea1t\u00a0\u0111\u1ed9ng n\u1eefa.\u00a0C\u00f3\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111i\u1ec1u\u00a0\u0111\u00f3 th\u00ec m\u00ecnh m\u1edbi c\u00f3 th\u1ec3 t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u t\u1ed1t tr\u00ean\u00a0excel, m\u1edbi c\u00f3 th\u1ec3 l\u00e0m b\u00e1o c\u00e1o v\u1eeba nhanh, v\u1eeba\u00a0\u0111\u00fang. M\u00e0 nh\u1eefng\u00a0\u0111i\u1ec1u n\u00e0y anh bi\u1ebft l\u00e0 h\u1ea7u h\u1ebft ch\u00fang ta\u00a0\u0111\u1ec1u kh\u00f4ng\u00a0\u0111\u01b0\u1ee3c h\u1ecdc trong tr\u01b0\u1eddng\u00a0\u0111\u1ea1i h\u1ecdc. Th\u1eadm ch\u00ed\u00a0\u0111i l\u00e0m c\u00e1c b\u1ea1n c\u0169ng kh\u00f4ng\u00a0\u0111\u01b0\u1ee3c ai h\u01b0\u1edbng d\u1eabn\u00a0\u0111\u00e2u. N\u00ean c\u00e1c b\u1ea1n c\u1ea7n ch\u1ee7\u00a0\u0111\u1ed9ng v\u00e0 t\u00edch c\u1ef1c t\u1ef1 h\u1ecdc th\u00eam. Anh r\u1ea5t th\u00edch nh\u1eefng nh\u00e2n vi\u00ean ch\u1ee7\u00a0\u0111\u1ed9ng v\u00e0 t\u1ef1 h\u1ecdc.<\/p>\n<p style=\"text-align: justify\"><strong>H\u1ecdc\u00a0Excel Online: M\u1ed9t l\u1ea7n n\u1eefa c\u1ea3m\u00a0\u01a1n anh r\u1ea5t nhi\u1ec1u v\u1ec1 bu\u1ed5i n\u00f3i chuy\u1ec7n ng\u00e0y h\u00f4m nay. Ch\u00fac anh\u00a0s\u1ee9c kh\u1ecfe v\u00e0 th\u00e0nh c\u00f4ng h\u01a1n trong s\u1ef1 nghi\u1ec7p!<\/strong><\/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\/2024\/12\/ex101_92019-nho-357.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4417,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4416","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4416","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=4416"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4416\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4417"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4416"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}