{"id":8716,"date":"2024-12-27T06:41:06","date_gmt":"2024-12-27T06:41:06","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/27\/7-tinh-nang-giup-cai-thien-hieu-suat-cong-viec-cua-ban-trong-excel\/"},"modified":"2024-12-27T06:41:06","modified_gmt":"2024-12-27T06:41:06","slug":"7-tinh-nang-giup-cai-thien-hieu-suat-cong-viec-cua-ban-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/27\/7-tinh-nang-giup-cai-thien-hieu-suat-cong-viec-cua-ban-trong-excel\/","title":{"rendered":"7 t\u00ednh n\u0103ng gi\u00fap c\u1ea3i thi\u1ec7n hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong Excel, c\u00f3 nh\u1eefng t\u00ednh n\u0103ng v\u00f4 c\u00f9ng h\u1eefu \u00edch s\u1ebd gi\u00fap c\u1ea3i thi\u1ec7n hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd li\u1ec7t k\u00ea ra 7 t\u00ednh n\u0103ng m\u00e0 ch\u1eafc ch\u1eafn ch\u00fang ta \u0111\u00e3 t\u1eebng s\u1eed d\u1ee5ng \u00edt nh\u1ea5t m\u1ed9t l\u1ea7n. H\u00e3y c\u00f9ng xem \u0111\u00f3 l\u00e0 t\u00ednh n\u0103ng n\u00e0o nh\u00e9:<\/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-676e4c01a0d3b\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cai-thien-hieu-suat-cong-viec-cua-ban-trong-excel.html#Flash_Fill\" title=\"Flash Fill\">Flash Fill<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cai-thien-hieu-suat-cong-viec-cua-ban-trong-excel.html#Pivot_Table\" title=\"Pivot Table\">Pivot Table<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cai-thien-hieu-suat-cong-viec-cua-ban-trong-excel.html#Goal_Seek\" title=\"Goal Seek\">Goal Seek<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cai-thien-hieu-suat-cong-viec-cua-ban-trong-excel.html#Conditional_Formatting\" title=\"Conditional Formatting\">Conditional Formatting<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cai-thien-hieu-suat-cong-viec-cua-ban-trong-excel.html#Index_va_Match\" title=\"Index v\u00e0 Match\">Index v\u00e0 Match<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cai-thien-hieu-suat-cong-viec-cua-ban-trong-excel.html#Bieu_do_thac_nuoc\" title=\"Bi\u1ec3u \u0111\u1ed3 th\u00e1c n\u01b0\u1edbc\">Bi\u1ec3u \u0111\u1ed3 th\u00e1c n\u01b0\u1edbc<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cai-thien-hieu-suat-cong-viec-cua-ban-trong-excel.html#Tinh_nang_du_bao\" title=\"T\u00ednh n\u0103ng d\u1ef1 b\u00e1o\">T\u00ednh n\u0103ng d\u1ef1 b\u00e1o<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Flash_Fill\"><\/span>Flash Fill<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27135\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-tricks_02.jpg\" width=\"720\" height=\"704\" title=\"7-tricks_02\"><\/p>\n<p>Flash fill s\u1ebd d\u1ef1 \u0111o\u00e1n \u0111\u01b0\u1ee3c ta mu\u1ed1n \u0111i\u1ec1n d\u1eef li\u1ec7u g\u00ec v\u00e0 t\u1ef1 \u0111\u1ed9ng \u00e1p d\u1ee5ng cho nh\u1eefng \u00f4 c\u00f2n l\u1ea1i. Th\u1eadt ti\u1ec7n l\u1ee3i ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n<p>Tuy nhi\u00ean, h\u00e3y c\u1ea9n th\u1eadn v\u00ec Flash fill kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o c\u0169ng ch\u00ednh x\u00e1c. C\u00e0ng nhi\u1ec1u m\u1eabu, t\u1ef7 l\u1ec7 \u0111\u00fang c\u00e0ng cao, nh\u01b0ng v\u1eabn c\u00f3 nh\u1eefng tr\u01b0\u1eddng h\u1ee3p d\u1eef li\u1ec7u nh\u1eadp v\u00e0o b\u1ecb sai v\u00e0 ta bu\u1ed9c ph\u1ea3i s\u1eeda th\u1ee7 c\u00f4ng ho\u1eb7c t\u00ecm ra nh\u1eefng ph\u01b0\u01a1ng \u00e1n kh\u00e1c. D\u00f9 g\u00ec \u0111\u00e2y v\u1eabn l\u00e0 m\u1ed9t t\u00ednh n\u0103ng r\u1ea5t c\u00f3 \u00edch ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Pivot_Table\"><\/span>Pivot Table<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27136\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-tricks_03.jpg\" width=\"720\" height=\"734\" title=\"7-tricks_03\"><\/p>\n<p>Pivot Table l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 \u0111\u1eafc l\u1ef1c cho h\u1ea7u h\u1ebft c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng l\u00e0m vi\u1ec7c v\u1edbi Excel. Vi\u1ec7c t\u1ed1i gi\u1ea3n v\u00e0 thay th\u1ebf c\u00f4ng th\u1ee9c b\u1eb1ng b\u1ea3ng t\u00ednh tr\u1ef1c quan, s\u1eed d\u1ee5ng \u0111\u1ec3 b\u00e1o c\u00e1o s\u1ed1 li\u1ec7u\u2026 khi\u1ebfn Pivot Table r\u1ea5t \u0111\u01b0\u1ee3c \u01b0a chu\u1ed9ng.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Goal_Seek\"><\/span>Goal Seek<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27137\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-tricks_04.jpg\" width=\"720\" height=\"754\" title=\"7-tricks_04\"><\/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-812.gif\" title=\"ex101_92019-nho-812\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Goal Seek c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u0103ng tr\u01b0\u1edfng c\u0169ng nh\u01b0 \u0111i\u1ec1u ki\u1ec7n c\u1ea7n thi\u1ebft cho m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u00edch thi\u1ebft l\u1eadp s\u1eb5n. B\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ecdc th\u00eam v\u1ec1 Goal Seek t\u1ea1i\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/su-dung-tinh-nang-goal-seek-trong-excel.html\">\u0110\u00c2Y<\/a>.<\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Conditional_Formatting\"><\/span>Conditional Formatting<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27138\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-tricks_05.jpg\" width=\"720\" height=\"777\" title=\"7-tricks_05\"><\/p>\n<p>Conditional Formatting gi\u00fap \u201cghi \u0111i\u1ec3m\u201d trong m\u1eaft ng\u01b0\u1eddi kh\u00e1c khi b\u1ea1n c\u00f3 th\u1ec3 th\u1ec3 hi\u1ec7n nh\u1eefng s\u1ed1 li\u1ec7u tr\u1ef1c quan v\u00e0 ph\u00e2n bi\u1ec7t v\u1edbi nh\u1eefng gi\u00e1 tr\u1ecb kh\u00e1c th\u00f4ng qua m\u00e0u s\u1eafc hay k\u00ed hi\u1ec7u. Vi\u1ec7c k\u1ebft h\u1ee3p Conditional Formatting v\u1edbi c\u00e1c c\u00f4ng c\u1ee5 hay ch\u1ee9c n\u0103ng kh\u00e1c nh\u01b0 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c s\u1ebd khi\u1ebfn b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n chuy\u00ean nghi\u1ec7p h\u01a1n \u0111\u1ea5y!<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Index_va_Match\"><\/span>Index v\u00e0 Match<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27139\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-tricks_06.jpg\" width=\"720\" height=\"827\" title=\"7-tricks_06\"><\/p>\n<p>Index\/Match l\u00e0 c\u1eb7p h\u00e0m k\u1ebft h\u1ee3p tra c\u1ee9u c\u00f3 th\u1ec3 thay th\u1ebf h\u00e0m t\u00ecm ki\u1ebfm kh\u00e1c nh\u01b0 VLOOKUP hay HLOOKUP trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p b\u1edfi t\u00ednh logic c\u0169ng nh\u01b0 nh\u1eefng gi\u1edbi h\u1ea1n \u0111\u01b0\u1ee3c m\u1edf r\u1ed9ng h\u01a1n.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Bieu_do_thac_nuoc\"><\/span>Bi\u1ec3u \u0111\u1ed3 th\u00e1c n\u01b0\u1edbc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27140\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-tricks_07.jpg\" width=\"720\" height=\"726\" title=\"7-tricks_07\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tinh_nang_du_bao\"><\/span>T\u00ednh n\u0103ng d\u1ef1 b\u00e1o<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27141\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-tricks_08.jpg\" width=\"720\" height=\"873\" title=\"7-tricks_08\"><\/p>\n<p>V\u00e0 cu\u1ed1i c\u00f9ng, \u0111\u1eebng qu\u00ean ngu\u1ed3n c\u1ee7a nh\u1eefng tips h\u1eefu \u00edch n\u00e0y nh\u00e9:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27142\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-tricks_09.jpg\" width=\"720\" height=\"352\" title=\"7-tricks_09\"><\/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-812.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8717,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8716","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\/8716","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=8716"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8716\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8717"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8716"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8716"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8716"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}