{"id":11629,"date":"2025-01-15T04:39:51","date_gmt":"2025-01-15T04:39:51","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/toi-da-hoc-excel-nhu-the-nao-phan-2\/"},"modified":"2025-01-15T04:39:51","modified_gmt":"2025-01-15T04:39:51","slug":"toi-da-hoc-excel-nhu-the-nao-phan-2","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/toi-da-hoc-excel-nhu-the-nao-phan-2\/","title":{"rendered":"T\u00f4i \u0111\u00e3 h\u1ecdc Excel nh\u01b0 th\u1ebf n\u00e0o \u2013 Ph\u1ea7n 2"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>B\u00e0i vi\u1ebft n\u00e0y nh\u1eb1m m\u1ee5c \u0111\u00edch chia s\u1ebb nh\u1eefng kinh nghi\u1ec7m\u00a0v\u00e0 c\u1ea3m nh\u1eadn c\u1ee7a b\u1ea3n th\u00e2n t\u00e1c gi\u1ea3. Nh\u1eefng suy ngh\u0129, b\u00e0i h\u1ecdc m\u00e0 t\u00e1c gi\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c khi h\u1ecdc t\u1eadp v\u00e0 l\u00e0m vi\u1ec7c v\u1edbi excel. B\u00e0i vi\u1ebft mang t\u00ednh ch\u1ea5t chia s\u1ebb v\u00e0 \u0111\u1ed9ng vi\u00ean nh\u1eefng ai \u0111\u00e3, \u0111ang v\u00e0 s\u1ebd\u00a0ch\u1ecdn excel l\u00e0m con \u0111\u01b0\u1eddng h\u1ecdc t\u1eadp cho m\u00ecnh.<\/p>\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-67873c169be1b\" 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\/toi-da-hoc-excel-nhu-nao-phan-2.html#4_Buoc_di_dau_tien\" title=\"4. B\u01b0\u1edbc\u00a0\u0111i\u00a0\u0111\u1ea7u ti\u00ean\">4. B\u01b0\u1edbc\u00a0\u0111i\u00a0\u0111\u1ea7u ti\u00ean<\/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\/toi-da-hoc-excel-nhu-nao-phan-2.html#5_Thu_thach\" title=\"5. Th\u1eed th\u00e1ch\">5. Th\u1eed th\u00e1ch<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"4_Buoc_di_dau_tien\"><\/span>4. B\u01b0\u1edbc\u00a0\u0111i\u00a0\u0111\u1ea7u ti\u00ean<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Sau khi v\u01b0\u1ee3t qua b\u00e0i ki\u1ec3m tra\u00a0\u0111\u1ea7u ti\u00ean c\u1ee7a th\u1ea7y b\u1eb1ng th\u00e1i\u00a0\u0111\u1ed9 c\u1ea7u th\u1ecb v\u00e0 th\u1ef1c s\u1ef1 mu\u1ed1n h\u1ecdc h\u1ecfi, th\u1ea7y c\u0169ng\u00a0\u0111\u1ed3ng\u00a0\u00fd ti\u1ebfp t\u1ee5c d\u1ea1y cho t\u00f4i.<\/p>\n<p>B\u00e0i h\u1ecdc\u00a0\u0111\u1ea7u ti\u00ean,\u00a0\u0111\u01a1n gi\u1ea3n ch\u1ec9 l\u00e0 \u201ctrang tr\u00ed v\u00e0 copy\u201d.<\/p>\n<p>Copy c\u00e1i g\u00ec? B\u1ea5t c\u1ee9 th\u1ee9 g\u00ec hay ho m\u00e0 li\u00ean quan t\u1edbi c\u00f4ng vi\u1ec7c c\u1ee7a th\u1ea7y: t\u1edd ho\u00e1\u00a0\u0111\u01a1n, phi\u1ebfu nh\u1eadp kho, b\u1ea3n k\u1ebf ho\u1ea1ch\u2026 t\u1eeb b\u1ea3n in tr\u00ean gi\u1ea5y, t\u00f4i ph\u1ea3i copy v\u00e0 trang tr\u00ed l\u1ea1i tr\u00ean\u00a0excel, b\u1eaft\u00a0\u0111\u1ea7u t\u1eeb 1 sheet tr\u1eafng tinh.<\/p>\n<p>Trang tr\u00ed th\u1ebf n\u00e0o? Y nguy\u00ean v\u1ec1 k\u00edch th\u01b0\u1edbc v\u00e0 c\u00e1c\u00a0\u0111\u1ecbnh d\u1ea1ng,\u00a0\u0111\u1ec3 khi in ra\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u00fang nh\u01b0 t\u1edd gi\u1ea5y\u00a0\u0111\u00e3 in ban\u00a0\u0111\u1ea7u.<\/p>\n<p>T\u01b0\u1edfng kh\u00f4ng kh\u00f3 m\u00e0 kh\u00f3 kh\u00f4ng t\u01b0\u1edfng. Th\u1ea7y ch\u01a1i\u00a0\u00e1c th\u1eadt.<\/p>\n<p>Loay hoay m\u00e3i, t\u00f4i m\u1edbi l\u00e0m xong 1 t\u1edd. Th\u1ef1c s\u1ef1 l\u00e0 to\u00e1t m\u1ed3 h\u00f4i lu\u00f4n\u00a0\u1ea5y.\u00a0\u0110\u1eb7c bi\u1ec7t l\u00e0 khi ph\u1ea3i l\u00e0m\u00a0\u0111i\u1ec1u\u00a0\u0111\u00f3 d\u01b0\u1edbi s\u1ef1 theo d\u00f5i c\u1ee7a th\u1ea7y. L\u00e0m xong, th\u1ea7y kh\u00f4ng n\u00f3i g\u00ec, ch\u1ec9 nh\u1eafc t\u00f4i l\u00e0m ti\u1ebfp cho\u00a0\u0111\u1ebfn h\u1ebft bu\u1ed5i h\u1ecdc.<\/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-313.gif\" title=\"ex101_92019-nho-313\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Cu\u1ed1i bu\u1ed5i h\u1ecdc, t\u00f4i\u00a0\u0111em c\u00e1i th\u1eafc m\u1eafc m\u00e0 m\u00ecnh\u00a0\u1ea5p\u00a0\u1ee7 c\u1ea3 ng\u00e0y ra h\u1ecfi th\u1ea7y: \u201cL\u00e0m v\u1eady th\u00ec c\u00f3\u00a0\u00edch g\u00ec?\u201d<\/p>\n<p>C\u00e2u tr\u1ea3 l\u1eddi t\u00f4i nh\u1eadn\u00a0\u0111\u01b0\u1ee3c l\u00e0:<\/p>\n<ul>\n<li>Tr\u01b0\u1edbc khi l\u00e0m m\u1ed9t vi\u1ec7c g\u00ec, ph\u1ea3i h\u00ecnh dung ra k\u1ebft qu\u1ea3 tr\u01b0\u1edbc. C\u00e0ng h\u00ecnh dung r\u00f5 bao nhi\u00eau, ph\u01b0\u01a1ng ph\u00e1p\u00a0\u0111\u1ec3\u00a0\u0111i\u00a0\u0111\u1ebfn k\u1ebft qu\u1ea3\u00a0\u0111\u00f3 c\u00e0ng c\u1ee5 th\u1ec3 b\u1ea5y nhi\u00eau.<\/li>\n<li>V\u00ec k\u1ebft qu\u1ea3 b\u1ea1n l\u00e0m ra kh\u00f4ng ph\u1ea3i cho b\u1ea1n xem, m\u00e0 cho ng\u01b0\u1eddi kh\u00e1c xem. N\u00ean y\u00eau c\u1ea7u\u00a0\u0111\u1ea7u ti\u00ean l\u00e0 ph\u1ea3i th\u1eadt r\u00f5 r\u00e0ng, s\u1ea1ch s\u1ebd,\u00a0\u0111\u1eb9p, b\u1ed1 c\u1ee5c h\u1ee3p l\u00fd. B\u00e1o c\u00e1o c\u00f3 n\u1ed9i dung hay\u00a0\u0111\u1ebfn m\u1ea5y m\u00e0 h\u00ecnh th\u1ee9c x\u1ea5u, b\u1ed1 c\u1ee5c l\u1ed9n x\u1ed9n th\u00ec s\u1ebd ch\u1eb3ng ai th\u00e8m\u00a0\u0111\u1ec3\u00a0\u00fd\u00a0\u0111\u00e2u<\/li>\n<li>Vi\u1ec7c trang tr\u00ed gi\u00fap b\u1ea1n luy\u1ec7n r\u1ea5t nhi\u1ec1u k\u1ef9 n\u0103ng c\u1ea7n thi\u1ebft cho c\u00f4ng vi\u1ec7c: S\u1eafp x\u1ebfp, t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u, t\u00ednh th\u1ea9m m\u1ef9, ghi nh\u1edb c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a\u00a0excel, v\u00e0\u00a0\u0111\u1eb7c bi\u1ec7t h\u01a1n n\u1eefa l\u00e0 n\u00f3 gi\u00fap b\u1ea1n th\u1ea5y\u00a0excel\u00a0\u0111\u1eb9p h\u01a1n, d\u1ec5 s\u1eed d\u1ee5ng h\u01a1n.<\/li>\n<\/ul>\n<p>C\u00e1i vi\u1ec7c l\u00e0m\u00a0\u0111\u01a1n gi\u1ea3n h\u00e0ng ng\u00e0y\u00a0\u1ea5y, khi b\u1ea1n th\u1ef1c s\u1ef1 y\u00eau th\u00edch n\u00f3, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 bi\u1ebfn n\u00f3 th\u00e0nh ngh\u1ec7 thu\u1eadt. Cho t\u1edbi b\u00e2y gi\u1edd (g\u1ea7n 10 n\u0103m l\u00e0m vi\u1ec7c v\u1edbi\u00a0excel) t\u00f4i v\u1eabn r\u00e8n luy\u1ec7n vi\u1ec7c n\u00e0y, kh\u00f4ng bao gi\u1edd coi th\u01b0\u1eddng n\u00f3.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"5_Thu_thach\"><\/span>5. Th\u1eed th\u00e1ch<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u1ed3i b\u1ea5y gi\u1edd,\u00a0office 2003 l\u00e0 phi\u00ean b\u1ea3n ph\u1ed5 bi\u1ebfn. Hi\u1ebfm l\u1eafm m\u1edbi c\u00f3 ng\u01b0\u1eddi d\u00f9ng\u00a0office 2007. Phi\u00ean b\u1ea3n n\u00e0y ch\u01b0a\u00a0\u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3 nhi\u1ec1u nh\u01b0 b\u00e2y gi\u1edd, n\u00ean c\u00e1c h\u00e0m t\u00ednh to\u00e1n c\u0169ng c\u00f3 nhi\u1ec1u h\u1ea1n ch\u1ebf.<\/p>\n<p>Qu\u1ea3n l\u00fd kho, c\u00e2u h\u1ecfi\u00a0\u0111\u1eb7t ra l\u00e0 \u201cS\u1ed1 l\u01b0\u1ee3ng ph\u00e1t sinh l\u1edbn\u201d, \u201cT\u00ednh to\u00e1n v\u1edbi nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n\u201d. H\u1ecdc\u00a0\u1edf tr\u01b0\u1eddng, t\u00f4i ch\u1ec9 bi\u1ebft\u00a0\u0111\u1ebfn h\u00e0m SUMIF l\u00e0 h\u1ebft. Nh\u01b0ng m\u00e0 SUMIF ch\u1ec9 cho ph\u00e9p t\u00ednh tr\u00ean 1\u00a0\u0111i\u1ec1u ki\u1ec7n m\u00e0 th\u00f4i (ch\u01b0a c\u00f3 SUMIFS nh\u01b0 b\u00e2y gi\u1edd). V\u1eady gi\u1ea3i quy\u1ebft v\u1ea5n\u00a0\u0111\u1ec1\u00a0\u0111\u00f3 nh\u01b0 th\u1ebf n\u00e0o? V\u1eadn d\u1ee5ng n\u00f3 v\u00e0o c\u00f4ng vi\u1ec7c\u00a0ra l\u00e0m sao?\u00a0\u0110\u1ed1i v\u1edbi t\u00f4i l\u00fac b\u1ea5y gi\u1edd,\u00a0\u0111\u00e2y qu\u1ea3 l\u00e0 1 th\u1eed th\u00e1ch l\u1edbn lao.<\/p>\n<p>Th\u1ea7y b\u1eaft t\u00f4i l\u00fac tung c\u00e1c h\u00e0m c\u1ee7a\u00a0excel l\u00ean, xem h\u00e0m n\u00e0o\u00a0\u0111\u00e1p\u00a0\u1ee9ng\u00a0\u0111\u01b0\u1ee3c y\u00eau c\u1ea7u.<\/p>\n<p>Qu\u1ea3 th\u1ef1c l\u00e0m m\u1ed9t th\u1ee9 m\u00ecnh ch\u01b0a l\u00e0m bao gi\u1edd, l\u1ea1i ngo\u00e0i t\u1ea7m hi\u1ec3u bi\u1ebft v\u1ed1n c\u00f3, n\u00f3 khi\u1ebfn t\u00f4i r\u1ea5t\u00a0\u0111i\u00ean\u00a0\u0111\u1ea7u. T\u00f4i nh\u1eadn ngay\u00a0\u0111\u01b0\u1ee3c 1 b\u00e0i h\u1ecdc \u201c<strong><em>Khi b\u1ea1n\u00a0\u0111ang th\u1ef1c s\u1ef1 l\u00e0m vi\u1ec7c, n\u00e3o c\u1ee7a b\u1ea1n s\u1ebd lu\u00f4n ph\u1ea3i ho\u1ea1t\u00a0\u0111\u1ed9ng, n\u00f3 s\u1ebd khi\u1ebfn b\u1ea1n\u00a0\u0111au\u00a0\u0111\u1ea7u. L\u00e0m vi\u1ec7c v\u1edbi\u00a0excel l\u00e0 ph\u1ea3i ch\u1ea5p nh\u1eadn\u00a0\u0111i\u1ec1u\u00a0\u0111\u00f3<\/em><\/strong>\u201c.<\/p>\n<p>Ok, I\u2019m fine. T\u00f4i t\u1ef1 nh\u1ee7. Sau m\u1ed9t th\u1eddi gian m\u00f2 kim\u00a0\u0111\u00e1y b\u1ec3, t\u00f4i c\u0169ng l\u00f4i ra\u00a0\u0111\u01b0\u1ee3c m\u1ed9t th\u1ee9 hay ho:\u00a0IF(\u2026,\u2026,if(\u2026,\u2026,if(\u2026\u2026\u2026\u2026)))))))) ch\u1ea3 bi\u1ebft m\u1ea5y d\u1ea5u ngo\u1eb7c, ch\u1ec9 nh\u1edb l\u00e0 m\u1ed9t\u00a0\u0111\u1ed1ng\u00a0IF<\/p>\n<p>L\u00e0m th\u1ebf n\u00e0y c\u00f3 m\u00e0 ch\u1ebft\u00a0\u00e0! Th\u1ea7y t\u00f4i th\u1ed1t l\u00ean. T\u00f4i th\u00ec x\u1ea5u h\u1ed5 mu\u1ed1n chui xu\u1ed1ng\u00a0\u0111\u1ea5t.<\/p>\n<p><strong><em>V\u00e2ng, khi b\u1ea1n\u00a0\u0111\u00e3 c\u1ed1 g\u1eafng m\u00e0 k\u1ebft qu\u1ea3 ch\u01b0a nh\u01b0 mong mu\u1ed1n, b\u1ea1n c\u00f3 th\u1ec3 x\u1ea5u h\u1ed5. Nh\u01b0ng b\u1ea1n kh\u00f4ng\u00a0\u0111\u01b0\u1ee3c b\u1ecf cu\u1ed9c. S\u1ebd c\u00f3 c\u00e1ch cho b\u1ea1n. Kho t\u00e0ng c\u1ee7a\u00a0excel l\u1edbn h\u01a1n b\u1ea1n t\u01b0\u1edfng. B\u1ea1n kh\u00f4ng t\u00ecm ra kh\u00f4ng c\u00f3 ngh\u0129a l\u00e0 n\u00f3 kh\u00f4ng c\u00f3.<\/em><\/strong><\/p>\n<p>V\u00e0 th\u1ea7y ch\u1ec9 cho t\u00f4i m\u1ed9t h\u00e0m, m\u00e0 n\u00f3 c\u00f2n khi\u1ebfn t\u00f4i g\u1eb7p th\u1eed th\u00e1ch nhi\u1ec1u h\u01a1n g\u1ea5p b\u1ed9i.<\/p>\n<p>\u00a0<\/p>\n<p>(m\u1eddi b\u1ea1n\u00a0\u0111\u00f3n xem ti\u1ebfp ph\u1ea7n 3 c\u1ee7a seri n\u00e0y\u00a0\u0111\u1ec3 bi\u1ebft h\u00e0m\u00a0\u0111\u00f3 l\u00e0 h\u00e0m g\u00ec)<\/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-313.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11630,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11629","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\/11629","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=11629"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11629\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11630"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11629"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11629"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11629"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}