{"id":11325,"date":"2025-01-15T02:34:18","date_gmt":"2025-01-15T02:34:18","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-lam-viec-voi-nhieu-ham-excel-phuc-tap\/"},"modified":"2025-01-15T02:34:18","modified_gmt":"2025-01-15T02:34:18","slug":"cach-lam-viec-voi-nhieu-ham-excel-phuc-tap","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-lam-viec-voi-nhieu-ham-excel-phuc-tap\/","title":{"rendered":"C\u00e1ch l\u00e0m vi\u1ec7c v\u1edbi nhi\u1ec1u h\u00e0m Excel ph\u1ee9c t\u1ea1p"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Khi l\u00e0m vi\u1ec7c v\u1edbi Excel, ch\u00fang ta ch\u1eafc ch\u1eafn s\u1ebd g\u1eb7p ph\u1ea3i nh\u1eefng tr\u01b0\u1eddng h\u1ee3p ph\u1ea3i l\u1ed3ng gh\u00e9p nhi\u1ec1u h\u00e0m Excel v\u1edbi nhau m\u1edbi c\u00f3 th\u1ec3 gi\u1ea3i quy\u1ebft \u0111\u01b0\u1ee3c v\u1ea5n \u0111\u1ec1 ho\u1eb7c \u0111em l\u1ea1i k\u1ebft qu\u1ea3 mong mu\u1ed1n. \u0110\u1ec3 l\u00e0m cho vi\u1ec7c n\u00e0y tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n, c\u00f9ng l\u00fac l\u00e0m hi\u1ec7u qu\u1ea3 l\u00e0m vi\u1ec7c c\u1ee7a c\u00e1c b\u1ea1n cao h\u01a1n. H\u1ecdc Excel Online xin chia s\u1ebb v\u1edbi c\u00e1c b\u1ea1n 1 s\u1ed1 c\u00e1ch vi\u1ebft c\u00f4ng th\u1ee9c, v\u00e0 th\u1ee7 thu\u1eadt l\u00e0m vi\u1ec7c v\u1edbi c\u00f4ng th\u1ee9c d\u00e0i trong Excel:<\/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-67871ea98546b\" 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-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-lam-viec-voi-nhieu-ham-excel-phuc-tap.html#Xem_ket_qua_tung_phan_cua_cong_thuc_voi_phim_F9\" title=\"Xem k\u1ebft qu\u1ea3 t\u1eebng ph\u1ea7n c\u1ee7a c\u00f4ng th\u1ee9c v\u1edbi ph\u00edm F9\">Xem k\u1ebft qu\u1ea3 t\u1eebng ph\u1ea7n c\u1ee7a c\u00f4ng th\u1ee9c v\u1edbi ph\u00edm F9<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-lam-viec-voi-nhieu-ham-excel-phuc-tap.html#Xuong_dong_neu_cong_thuc_qua_dai_ALT_ENTER\" title=\"Xu\u1ed1ng d\u00f2ng n\u1ebfu c\u00f4ng th\u1ee9c qu\u00e1 d\u00e0i ALT + ENTER\">Xu\u1ed1ng d\u00f2ng n\u1ebfu c\u00f4ng th\u1ee9c qu\u00e1 d\u00e0i ALT + ENTER<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-lam-viec-voi-nhieu-ham-excel-phuc-tap.html#Tao_ghi_chu_trong_cong_thuc_Excel_bang_ham_N\" title=\"T\u1ea1o ghi ch\u00fa trong c\u00f4ng th\u1ee9c Excel b\u1eb1ng h\u00e0m N\">T\u1ea1o ghi ch\u00fa trong c\u00f4ng th\u1ee9c Excel b\u1eb1ng h\u00e0m N<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-lam-viec-voi-nhieu-ham-excel-phuc-tap.html#Dung_bo_qua_goi_y_nhap_tham_so_cua_ham_Excel_Tooltip\" title=\"\u0110\u1eebng b\u1ecf qua g\u1ee3i \u00fd nh\u1eadp tham s\u1ed1 c\u1ee7a h\u00e0m Excel (Tooltip)\">\u0110\u1eebng b\u1ecf qua g\u1ee3i \u00fd nh\u1eadp tham s\u1ed1 c\u1ee7a h\u00e0m Excel (Tooltip)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cach-lam-viec-voi-nhieu-ham-excel-phuc-tap.html#Su_dung_cong_cu_lam_dep_ham_Excel_cua_Hoc_Excel_Online\" title=\"S\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 l\u00e0m \u0111\u1eb9p h\u00e0m Excel c\u1ee7a H\u1ecdc Excel Online\">S\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 l\u00e0m \u0111\u1eb9p h\u00e0m Excel c\u1ee7a H\u1ecdc Excel Online<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1><span class=\"ez-toc-section\" id=\"Xem_ket_qua_tung_phan_cua_cong_thuc_voi_phim_F9\"><\/span>Xem k\u1ebft qu\u1ea3 t\u1eebng ph\u1ea7n c\u1ee7a c\u00f4ng th\u1ee9c v\u1edbi ph\u00edm F9<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>Khi vi\u1ebft 1 c\u00f4ng th\u1ee9c d\u00e0i, b\u1ea1n r\u1ea5t c\u00f3 th\u1ec3 g\u1eb7p ph\u1ea3i tr\u01b0\u1eddng h\u1ee3p 1 ph\u1ea7n c\u1ee7a c\u00f4ng th\u1ee9c b\u1ecb l\u1ed7i d\u1eabn \u0111\u1ec3 c\u1ea3 c\u00f4ng th\u1ee9c d\u00e0i b\u1ecb l\u1ed7i, v\u00ec v\u1eady, ch\u00fang ta c\u1ea7n ki\u1ec3m tra l\u1ea1i t\u1eebng ph\u1ea7n c\u1ee7a c\u00f4ng th\u1ee9c \u0111\u00f3 b\u1eb1ng c\u00e1ch ch\u1ecdn ph\u1ea7n c\u00f4ng th\u1ee9c mu\u1ed1n ki\u1ec3m tra r\u1ed3i b\u1ea5m ph\u00edm F9:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-9083\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cach-su-dung-cong-thuc-1-1024x563-1.png\" alt=\"cach-su-dung-cong-thuc-1\" width=\"1024\" height=\"563\" title=\"cach-su-dung-cong-thuc-1-1024x563-1\"><\/p>\n<h1><span class=\"ez-toc-section\" id=\"Xuong_dong_neu_cong_thuc_qua_dai_ALT_ENTER\"><\/span>Xu\u1ed1ng d\u00f2ng n\u1ebfu c\u00f4ng th\u1ee9c qu\u00e1 d\u00e0i ALT + ENTER<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>M\u1ed9t c\u00f4ng th\u1ee9c qu\u00e1 d\u00e0i s\u1ebd khi\u1ebfn b\u1ea1n kh\u00f3 theo d\u00f5i v\u00e0 kh\u00f3 ph\u00e2n bi\u1ec7t \u0111\u01b0\u1ee3c ph\u1ea7n n\u00e0o c\u1ee7a c\u00f4ng th\u1ee9c s\u1ebd ph\u1ee5c v\u1ee5 m\u1ee5c \u0111\u00edch g\u00ec, do v\u1eady, vi\u1ec7c ng\u1eaft c\u00f4ng th\u1ee9c d\u00e0i c\u1ee7a b\u1ea1n ra th\u00e0nh nhi\u1ec1u ph\u1ea7n b\u1eb1ng c\u00e1ch xu\u1ed1ng d\u00f2ng s\u1ebd gi\u00fap vi\u1ec7c vi\u1ebft c\u00f4ng th\u1ee9c d\u00e0i tr\u1edf n\u00ean \u0111\u1ee1 v\u1ea5t v\u1ea3 h\u01a1n. \u0110\u1ec3 xu\u1ed1ng d\u00f2ng khi vi\u00e9t c\u00f4ng th\u1ee9c, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm ALT + ENTER<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-9084\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cach-xuong-dong-trong-mot-o-excel-1024x409-1.png\" alt=\"cach-xuong-dong-trong-mot-o-excel\" width=\"1024\" height=\"409\" title=\"cach-xuong-dong-trong-mot-o-excel-1024x409-1\"><\/p>\n<h1><span class=\"ez-toc-section\" id=\"Tao_ghi_chu_trong_cong_thuc_Excel_bang_ham_N\"><\/span>T\u1ea1o ghi ch\u00fa trong c\u00f4ng th\u1ee9c Excel b\u1eb1ng h\u00e0m N<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>Tuy b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng comment c\u1ee7a Excel \u0111\u1ec3 gi\u1ea3i th\u00edch n\u1ed9i dung c\u00f4ng th\u1ee9c trong Excel, tuy nhi\u00ean c\u00e1ch n\u00e0y v\u1eabn kh\u00e1 kh\u00f3 kh\u0103n \u0111\u1ec3 theo d\u00f5i, c\u00e1ch l\u00e0m \u1edf \u0111\u00e2y l\u00e0 ch\u00fang ta s\u1ebd c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m N \u0111\u1ec3 l\u00e0m \u0111i\u1ec1u \u0111\u00f3, h\u00e3y theo d\u00f5i h\u00ecnh minh ho\u1ea1 v\u00e0 c\u00e1c b\u1ea1n s\u1ebd hi\u1ec3u ngay<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-9086\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cach-su-dung-ham-n-trong-excel-1024x508-1.png\" alt=\"cach-su-dung-ham-N-trong-excel\" width=\"1024\" height=\"508\" title=\"cach-su-dung-ham-n-trong-excel-1024x508-1\"><\/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-284.gif\" title=\"ex101_92019-nho-284\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>V\u1edbi h\u00e0m N n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 ghi ch\u00fa v\u00e0 gi\u1ea3i th\u00edch cho t\u1eebng ph\u1ea7n c\u1ee7a c\u00f4ng th\u1ee9c m\u00e0 kh\u00f4ng l\u00e0m \u1ea3nh h\u01b0\u1edfng t\u1edbi k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng c\u1ee7a to\u00e0n c\u00f4ng th\u1ee9c.<\/p>\n<h1><span class=\"ez-toc-section\" id=\"Dung_bo_qua_goi_y_nhap_tham_so_cua_ham_Excel_Tooltip\"><\/span>\u0110\u1eebng b\u1ecf qua g\u1ee3i \u00fd nh\u1eadp tham s\u1ed1 c\u1ee7a h\u00e0m Excel (Tooltip)<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>C\u00e1c b\u1ea1n ch\u1eafc \u0111\u00e3 g\u1eb7p ph\u1ea3i tr\u01b0\u1eddng h\u1ee3p kh\u00f4ng bi\u1ebft d\u1ea5u ng\u0103n c\u00e1ch c\u00e1c tham s\u1ed1 trong Excel l\u00e0 d\u1ea5u ph\u1ea9y hay d\u1ea5u ch\u1ea5m ph\u1ea9y. \u0110\u1ec3 bi\u1ebft \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y, r\u1ea5t \u0111\u01a1n gi\u1ea3n, h\u00e3y d\u1ef1a v\u00e0o tooltip l\u00e0 ch\u1ee9c n\u0103ng excel g\u1ee3i \u00fd cho c\u00e1c b\u1ea1n khi nh\u1eadp h\u00e0m v\u00e0o. N\u1ebfu tr\u00ean tooltip, Excel d\u00f9ng d\u1ea5u ph\u1ea9y, th\u00ec b\u1ea1n s\u1ebd d\u00f9ng theo d\u1ea5u n\u00e0y. Ngo\u00e0i ra tooltip c\u00f2n gi\u00fap c\u00e1c b\u1ea1n bi\u1ebft \u0111\u01b0\u1ee3c ch\u00ednh x\u00e1c v\u1ecb tr\u00ed l\u1ea7n l\u01b0\u1ee3t c\u00e1c tham s\u1ed1 s\u1ebd \u0111\u01b0a v\u00e0o h\u00e0m th\u1ebf n\u00e0o.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-9087\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/su-dung-tooltip-excel-1024x535-1.png\" alt=\"su-dung-tooltip-excel\" width=\"1024\" height=\"535\" title=\"su-dung-tooltip-excel-1024x535-1\"><\/p>\n<h1><span class=\"ez-toc-section\" id=\"Su_dung_cong_cu_lam_dep_ham_Excel_cua_Hoc_Excel_Online\"><\/span>S\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 l\u00e0m \u0111\u1eb9p h\u00e0m Excel c\u1ee7a H\u1ecdc Excel Online<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>B\u1ea1n c\u00f3 th\u1ec3 l\u00e0m cho h\u00e0m Excel \u0111\u1ee1 r\u1ed1i m\u1eaft b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 l\u00e0m \u0111\u1eb9p h\u00e0m Excel c\u1ee7a H\u1ecdc Excel Online t\u1ea1i \u0111\u1ecba ch\u1ec9: <a href=\"https:\/\/blog.hocexcel.online\/schoener\">https:\/\/blog.hocexcel.online\/schoener<\/a><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-9088\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cach-viet-ham-excel-1024x494-1.png\" alt=\"cach-viet-ham-excel\" width=\"1024\" height=\"494\" title=\"cach-viet-ham-excel-1024x494-1\"><\/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-284.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11326,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11325","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\/11325","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=11325"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11325\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11326"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11325"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11325"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11325"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}