{"id":8237,"date":"2024-12-22T04:22:20","date_gmt":"2024-12-22T04:22:20","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/10-bi-kip-excel-song-con-trong-cong-viec-o-ngan-hang-nam-2017\/"},"modified":"2024-12-22T04:22:20","modified_gmt":"2024-12-22T04:22:20","slug":"10-bi-kip-excel-song-con-trong-cong-viec-o-ngan-hang-nam-2017","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/10-bi-kip-excel-song-con-trong-cong-viec-o-ngan-hang-nam-2017\/","title":{"rendered":"10 b\u00ed k\u00edp Excel s\u1ed1ng c\u00f2n trong c\u00f4ng vi\u1ec7c \u1edf ng\u00e2n h\u00e0ng n\u0103m 2017"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>V\u1edbi s\u1ef1 ph\u00e1t tri\u1ec3n c\u1ee7a n\u1ec1n c\u00f4ng ngh\u1ec7 th\u00f4ng tin nh\u01b0 hi\u1ec7n nay, Excel v\u1eabn kh\u00f4ng m\u1ea5t \u0111i vai tr\u00f2 l\u00e0 m\u1ed9t ph\u1ea7n m\u1ec1m kh\u00f4ng th\u1ec3 thi\u1ebfu trong c\u00e1c doanh nghi\u1ec7p \u0111\u1eb7c bi\u1ec7t l\u00e0 trong c\u00e1c ng\u00e2n h\u00e0ng. K\u1ef9 n\u0103ng Excel lu\u00f4n lu\u00f4n \u0111\u01b0\u1ee3c \u0111\u1ec1 cao trong CV c\u1ee7a 1 \u1ee9ng vi\u00ean thi tuy\u1ec3n v\u00e0o c\u00e1c v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u ho\u1eb7c v\u1ecb tr\u00ed t\u1ea7m trung trong ng\u00e2n h\u00e0ng v\u00e0 c\u00e1c doanh nghi\u1ec7p kh\u00e1c. H\u1ecdc Excel Online xin chia s\u1ebb v\u1edbi c\u00e1c b\u1ea1n 10 b\u00ed k\u00edp Excel s\u1ed1ng c\u00f2n \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 ho\u00e0n th\u00e0nh c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh v\u1edbi hi\u1ec7u qu\u1ea3 cao nh\u1ea5t.<\/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-676793fb2d6c8\" 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\/10-bi-kip-excel-song-con-trong-cong-viec-o-ngan-hang-nam-2017.html#Nhung_tinh_nang_cua_Excel_hay_duoc_su_dung_nhat\" title=\"Nh\u1eefng t\u00ednh n\u0103ng c\u1ee7a Excel hay \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u1ea5t\">Nh\u1eefng t\u00ednh n\u0103ng c\u1ee7a Excel hay \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u1ea5t<\/a>\n<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/10-bi-kip-excel-song-con-trong-cong-viec-o-ngan-hang-nam-2017.html#Ham_co_ban\" title=\"H\u00e0m c\u01a1 b\u1ea3n\">H\u00e0m c\u01a1 b\u1ea3n<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/10-bi-kip-excel-song-con-trong-cong-viec-o-ngan-hang-nam-2017.html#1_Ham_tinh_gia_tri_trung_binh_average\" title=\"1. H\u00e0m t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh average\">1. H\u00e0m t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh average<\/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\/10-bi-kip-excel-song-con-trong-cong-viec-o-ngan-hang-nam-2017.html#2_Ham_tinh_tong\" title=\"2. H\u00e0m t\u00ednh t\u1ed5ng\">2. H\u00e0m t\u00ednh t\u1ed5ng<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/10-bi-kip-excel-song-con-trong-cong-viec-o-ngan-hang-nam-2017.html#Ham_SUM_SUMA1_A4\" title=\"H\u00e0m SUM: =SUM(A1:A4)\">H\u00e0m SUM: =SUM(A1:A4)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/10-bi-kip-excel-song-con-trong-cong-viec-o-ngan-hang-nam-2017.html#Ham_Subtotal_de_tinh_tong_SUBTOTAL9_A1_A4\" title=\"H\u00e0m Subtotal \u0111\u1ec3 t\u00ednh t\u1ed5ng: =SUBTOTAL(9, A1:A4)\">H\u00e0m Subtotal \u0111\u1ec3 t\u00ednh t\u1ed5ng: =SUBTOTAL(9, A1:A4)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/10-bi-kip-excel-song-con-trong-cong-viec-o-ngan-hang-nam-2017.html#3_Ham_tinh_gia_tri_lon_nhat_MAX_ham_tinh_gia_tri_nho_nhat_MIN\" title=\"3. H\u00e0m t\u00ednh gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t MAX, h\u00e0m t\u00ednh gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t MIN\">3. H\u00e0m t\u00ednh gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t MAX, h\u00e0m t\u00ednh gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t MIN<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/10-bi-kip-excel-song-con-trong-cong-viec-o-ngan-hang-nam-2017.html#4_Ham_dem_theo_dieu_kien\" title=\"4. H\u00e0m \u0111\u1ebfm theo \u0111i\u1ec1u ki\u1ec7n\">4. H\u00e0m \u0111\u1ebfm theo \u0111i\u1ec1u ki\u1ec7n<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/10-bi-kip-excel-song-con-trong-cong-viec-o-ngan-hang-nam-2017.html#Cac_phim_tat_can_thuoc_long_trong_Excel\" title=\"C\u00e1c ph\u00edm t\u1eaft c\u1ea7n thu\u1ed9c l\u00f2ng trong Excel\">C\u00e1c ph\u00edm t\u1eaft c\u1ea7n thu\u1ed9c l\u00f2ng trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/10-bi-kip-excel-song-con-trong-cong-viec-o-ngan-hang-nam-2017.html#Bi_kip_phan_tich_du_lieu_voi_Excel\" title=\"B\u00ed k\u00edp ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u1edbi Excel\">B\u00ed k\u00edp ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u1edbi Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/10-bi-kip-excel-song-con-trong-cong-viec-o-ngan-hang-nam-2017.html#1_Su_dung_cong_thuc_SUMIFS\" title=\"1. S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c SUMIFS\">1. S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c SUMIFS<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/10-bi-kip-excel-song-con-trong-cong-viec-o-ngan-hang-nam-2017.html#2_Su_dung_ham_do_tim_VLOOKUP_INDEX_ket_hop_voi_MATCH_trong_Excel\" title=\"2. S\u1eed d\u1ee5ng h\u00e0m d\u00f2 t\u00ecm VLOOKUP, INDEX k\u1ebft h\u1ee3p v\u1edbi MATCH trong Excel\">2. S\u1eed d\u1ee5ng h\u00e0m d\u00f2 t\u00ecm VLOOKUP, INDEX k\u1ebft h\u1ee3p v\u1edbi MATCH trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/10-bi-kip-excel-song-con-trong-cong-viec-o-ngan-hang-nam-2017.html#3_Phan_tich_du_lieu_voi_Pivot_Tables\" title=\"3. Ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u1edbi Pivot Tables\">3. Ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u1edbi Pivot Tables<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/10-bi-kip-excel-song-con-trong-cong-viec-o-ngan-hang-nam-2017.html#4_Bo_qua_VBA_de_tu_dong_hoa_la_1_sai_lam\" title=\"4. B\u1ecf qua VBA \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng ho\u00e1 l\u00e0 1 sai l\u1ea7m\">4. B\u1ecf qua VBA \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng ho\u00e1 l\u00e0 1 sai l\u1ea7m<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/blog.hocexcel.online\/10-bi-kip-excel-song-con-trong-cong-viec-o-ngan-hang-nam-2017.html#Trich_loc_du_lieu\" title=\"Tr\u00edch l\u1ecdc d\u1eef li\u1ec7u\">Tr\u00edch l\u1ecdc d\u1eef li\u1ec7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/blog.hocexcel.online\/10-bi-kip-excel-song-con-trong-cong-viec-o-ngan-hang-nam-2017.html#Tao_bao_cao_va_cap_nhat_bao_cao_khi_co_du_lieu_moi\" title=\"T\u1ea1o b\u00e1o c\u00e1o v\u00e0 c\u1eadp nh\u1eadt b\u00e1o c\u00e1o khi c\u00f3 d\u1eef li\u1ec7u m\u1edbi\">T\u1ea1o b\u00e1o c\u00e1o v\u00e0 c\u1eadp nh\u1eadt b\u00e1o c\u00e1o khi c\u00f3 d\u1eef li\u1ec7u m\u1edbi<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/blog.hocexcel.online\/10-bi-kip-excel-song-con-trong-cong-viec-o-ngan-hang-nam-2017.html#Tach_du_lieu_tu_1_file_ra_nhieu_file\" title=\"T\u00e1ch d\u1eef li\u1ec7u t\u1eeb 1 file ra nhi\u1ec1u file\">T\u00e1ch d\u1eef li\u1ec7u t\u1eeb 1 file ra nhi\u1ec1u file<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/blog.hocexcel.online\/10-bi-kip-excel-song-con-trong-cong-viec-o-ngan-hang-nam-2017.html#Gop_du_lieu_tu_nhieu_file_vao_1_file\" title=\"G\u1ed9p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u file v\u00e0o 1 file\">G\u1ed9p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u file v\u00e0o 1 file<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/blog.hocexcel.online\/10-bi-kip-excel-song-con-trong-cong-viec-o-ngan-hang-nam-2017.html#5_Phan_tich_du_lieu_bang_cach_ve_bieu_do_trong_Excel\" title=\"5. Ph\u00e2n t\u00edch d\u1eef li\u1ec7u b\u1eb1ng c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 trong Excel\">5. Ph\u00e2n t\u00edch d\u1eef li\u1ec7u b\u1eb1ng c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/blog.hocexcel.online\/10-bi-kip-excel-song-con-trong-cong-viec-o-ngan-hang-nam-2017.html#6_Hay_su_dung_Goal_Seek_va_bien_muc_tieu_cua_ban_thanh_su_that\" title=\"6. H\u00e3y s\u1eed d\u1ee5ng Goal Seek v\u00e0 bi\u1ebfn m\u1ee5c ti\u00eau c\u1ee7a b\u1ea1n th\u00e0nh s\u1ef1 th\u1eadt\">6. H\u00e3y s\u1eed d\u1ee5ng Goal Seek v\u00e0 bi\u1ebfn m\u1ee5c ti\u00eau c\u1ee7a b\u1ea1n th\u00e0nh s\u1ef1 th\u1eadt<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/blog.hocexcel.online\/10-bi-kip-excel-song-con-trong-cong-viec-o-ngan-hang-nam-2017.html#Lam_the_nao_de_hoc_duoc_tat_ca_nhung_kien_thuc_tren\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c t\u1ea5t c\u1ea3 nh\u1eefng ki\u1ebfn th\u1ee9c tr\u00ean?\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c t\u1ea5t c\u1ea3 nh\u1eefng ki\u1ebfn th\u1ee9c tr\u00ean?<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1><span class=\"ez-toc-section\" id=\"Nhung_tinh_nang_cua_Excel_hay_duoc_su_dung_nhat\"><\/span>Nh\u1eefng t\u00ednh n\u0103ng c\u1ee7a Excel hay \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u1ea5t<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>Theo 1 ex managing director c\u1ee7a ng\u00e2n h\u00e0ng \u0111\u1ea7u t\u01b0 qu\u1ed1c t\u1ebf Goldman Sachs, th\u00ec nh\u1eefng ch\u1ee9c n\u0103ng Excel sau \u0111\u00e2y l\u00e0 nh\u1eefng ch\u1ee9c n\u0103ng hay \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u1ea5t trong Excel<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_co_ban\"><\/span>H\u00e0m c\u01a1 b\u1ea3n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"1_Ham_tinh_gia_tri_trung_binh_average\"><\/span>1. H\u00e0m t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh average<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ee7a 1 v\u00f9ng trong b\u1ea3ng t\u00ednh: <strong>=AVERAGE(A1:A4)<\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Ham_tinh_tong\"><\/span>2. H\u00e0m t\u00ednh t\u1ed5ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m t\u00ednh t\u1ed5ng hay \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong Excel:<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Ham_SUM_SUMA1_A4\"><\/span>H\u00e0m SUM: =SUM(A1:A4)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<h4><span class=\"ez-toc-section\" id=\"Ham_Subtotal_de_tinh_tong_SUBTOTAL9_A1_A4\"><\/span>H\u00e0m Subtotal \u0111\u1ec3 t\u00ednh t\u1ed5ng: =SUBTOTAL(9, A1:A4)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>B\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u th\u00eam v\u1ec1 <a href=\"https:\/\/blog.hocexcel.online\/44-%e2%97%8f-su-dung-cong-cu-subtotal-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m Subtotal qua b\u00e0i vi\u1ebft n\u00e0y c\u1ee7a H\u1ecdc Excel Online<\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"3_Ham_tinh_gia_tri_lon_nhat_MAX_ham_tinh_gia_tri_nho_nhat_MIN\"><\/span>3. H\u00e0m t\u00ednh gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t MAX, h\u00e0m t\u00ednh gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t MIN<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>V\u1ec1 \u1ee9ng d\u1ee5ng k\u1ebft h\u1ee3p c\u1ee7a h\u00e0m MIN, MAX trong Excel \u0111\u1ec3 t\u00ednh t\u1ed5ng theo \u0111i\u1ec1u ki\u1ec7n, b\u1ea1n tham kh\u1ea3o <a href=\"https:\/\/blog.hocexcel.online\/tinh-min-max-theo-dieu-kien-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">b\u00e0i vi\u1ebft n\u00e0y<\/a>\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t ho\u1eb7c gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t theo \u0111i\u1ec1u ki\u1ec7n t\u1eeb H\u1ecdc Excel Online.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"4_Ham_dem_theo_dieu_kien\"><\/span>4. H\u00e0m \u0111\u1ebfm theo \u0111i\u1ec1u ki\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Nh\u00f3m h\u00e0m \u0111\u1ebfm theo \u0111i\u1ec1u ki\u1ec7n l\u00e0 m\u1ed9t trong nh\u1eefng nh\u00f3m h\u00e0m r\u1ea5t hay \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong c\u00f4ng vi\u1ec7c t\u1ea1i ng\u00e2n h\u00e0ng \u0111\u1ea7u t\u01b0, \u0111\u1ec3 th\u00e0nh th\u1ea1o ki\u1ebfn th\u1ee9c n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 click v\u00e0o link \u0111\u1ec3 tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft sau \u0111\u00e2y:<\/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-747.gif\" title=\"ex101_92019-nho-747\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul style=\"list-style-type: square\">\n<li><a href=\"https:\/\/blog.hocexcel.online\/su-dung-countif-nang-cao-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">9 tuy\u1ec7t chi\u00eau s\u1eed d\u1ee5ng COUNTIF hi\u1ec7u qu\u1ea3 trong Excel<\/a><\/li>\n<li><a href=\"https:\/\/blog.hocexcel.online\/47-%e2%97%8f-ham-sumproduct-va-su-khac-nhau-voi-sumifs-countifs-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">H\u00e0m SUMPRODUCT v\u00e0 s\u1ef1 kh\u00e1c bi\u1ec7t so v\u1edbi COUNTIFS<\/a><\/li>\n<li><a href=\"https:\/\/blog.hocexcel.online\/45-%e2%97%8f-danh-dau-du-lieu-lap-trong-cot-bang-conditional-formatting-countif-vba.html\" target=\"_blank\" rel=\"noopener noreferrer\">\u0110\u00e1nh d\u1ea5u d\u1eef li\u1ec7u l\u1eb7p l\u1ea1i v\u1edbi COUNTIF<\/a><\/li>\n<li><a href=\"https:\/\/blog.hocexcel.online\/43-%e2%97%8f-cach-su-dung-ham-countif-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">5 b\u01b0\u1edbc \u0111\u1ec3 s\u1eed d\u1ee5ng COUNTIF<\/a><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Cac_phim_tat_can_thuoc_long_trong_Excel\"><\/span>C\u00e1c ph\u00edm t\u1eaft c\u1ea7n thu\u1ed9c l\u00f2ng trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ch\u1ec9 v\u1edbi 10 ph\u00edm t\u1eaft n\u00e0y, b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 t\u0103ng n\u0103ng su\u1ea5t l\u00e0m vi\u1ec7c l\u00ean g\u1ea5p 2 l\u1ea7n:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2598\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/phim-tat-excel-674x1024-1.jpg\" alt=\"phim-tat-excel\" width=\"674\" height=\"1024\" title=\"phim-tat-excel-674x1024-1\"><\/p>\n<p>Ngo\u00e0i ra, \u0111\u1ec3 tra c\u1ee9u ph\u00edm t\u1eaft, h\u00e3y click \u0111\u1ec3 xem b\u1ea3ng trang c\u1ee9u ph\u00edm t\u1eaft tr\u1ef1c tuy\u1ebfn c\u1ee7a H\u1ecdc Excel Online t\u1ea1i \u0111\u1ecba ch\u1ec9 nh\u01b0 sau<\/p>\n<p><a href=\"https:\/\/www.hocexcel.online\/phim-tat\">https:\/\/www.hocexcel.online\/phim-tat<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Bi_kip_phan_tich_du_lieu_voi_Excel\"><\/span>B\u00ed k\u00edp ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u1edbi Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong c\u00e1c JD (Job Description) c\u1ee7a c\u00e1c ng\u00e2n h\u00e0ng bao gi\u1edd c\u0169ng t\u00ecm nh\u1eefng \u1ee9ng vi\u00ean c\u00f3 kh\u1ea3 n\u0103ng ph\u00e2n t\u00edch, c\u1ee5 th\u1ec3 kh\u1ea3 n\u0103ng ph\u00e2n t\u00edch li\u00ean quan t\u1edbi nghi\u1ec7p v\u1ee5 ng\u00e2n h\u00e0ng th\u01b0\u1eddng l\u00e0 kh\u1ea3 n\u0103ng ph\u00e2n t\u00edch d\u1eef li\u1ec7u \u0111\u1ec3 \u0111\u01b0a ra b\u00e1o c\u00e1o v\u00e0 quy\u1ebft \u0111\u1ecbnh.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"1_Su_dung_cong_thuc_SUMIFS\"><\/span>1. S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c SUMIFS<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>SUMIFS c\u00f3 th\u1ec3 d\u00f9ng nh\u01b0 m\u1ed9t c\u00f4ng c\u1ee5 ph\u00e2n t\u00edch d\u1eef li\u1ec7u \u0111\u01a1n gi\u1ea3n, d\u1ec5 s\u1eed d\u1ee5ng m\u00e0 l\u1ea1i r\u1ea5t h\u1eefu hi\u1ec7u. B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o ngay nh\u1eefng b\u00e0i vi\u1ebft li\u00ean quan sau \u0111\u00e2y:<\/p>\n<ul style=\"list-style-type: square\">\n<li><a href=\"https:\/\/blog.hocexcel.online\/42-%e2%97%8f-su-dung-ham-sumif-sumifs-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">4 b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m SUMIF hi\u1ec7u qu\u1ea3<\/a><\/li>\n<li><a href=\"https:\/\/blog.hocexcel.online\/ham-sumifs-tinh-tong-theo-tuan-thang-nam.html\" target=\"_blank\" rel=\"noopener noreferrer\">2 tr\u01b0\u1eddng h\u1ee3p s\u1eed d\u1ee5ng SUMIF \u0111\u1ec3 t\u00ednh t\u1ed5ng theo kho\u1ea3ng th\u1eddi gian<\/a><\/li>\n<li><a href=\"https:\/\/blog.hocexcel.online\/ham-sumif-tinh-tong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">3 tuy\u1ec7t chi\u00eau v\u1edbi h\u00e0m SUMIFS trong Excel<\/a><\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"2_Su_dung_ham_do_tim_VLOOKUP_INDEX_ket_hop_voi_MATCH_trong_Excel\"><\/span>2. S\u1eed d\u1ee5ng h\u00e0m d\u00f2 t\u00ecm VLOOKUP, INDEX k\u1ebft h\u1ee3p v\u1edbi MATCH trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Nh\u1eefng h\u00e0m d\u00f2 t\u00ecm v\u00e0 t\u00ecm ki\u1ebfm trong Excel lu\u00f4n lu\u00f4n l\u00e0 1 ch\u1ee7 \u0111\u1ec1 lu\u00f4n \u0111\u01b0\u1ee3c th\u1ea3o lu\u1eadn v\u00e0 h\u1ecfi r\u1ea5t nhi\u1ec1u trong c\u00e1c cu\u1ed9c ph\u1ecfng v\u1ea5n xin vi\u1ec7c c\u0169ng nh\u01b0 trong c\u00e1c \u0111\u1ec1 ki\u1ec3m tra, ch\u1ec9 c\u1ea7n \u0111\u1ecdc c\u00e1c b\u00e0i sau \u0111\u00e2y l\u00e0 b\u1ea1n \u0111\u00e3 n\u1eafm ch\u1eafc 70% c\u01a1 h\u1ed9i \u0111\u1ec3 v\u01b0\u1ee3t qua nh\u1eefng c\u00e2u h\u1ecfi n\u00e0y r\u1ed3i.<\/p>\n<p>\u00a0<\/p>\n<p><a href=\"https:\/\/www.hocexcel.online\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html\">https:\/\/www.hocexcel.online\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_Phan_tich_du_lieu_voi_Pivot_Tables\"><\/span>3. Ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u1edbi Pivot Tables<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>1 trong nh\u1eefng ch\u1ee9c n\u0103ng hay nh\u1ea5t c\u1ee7a Excel m\u00e0 b\u1ea1n kh\u00f4ng th\u1ec3 b\u1ecf qua \u0111\u00f3 ch\u00ednh l\u00e0 Pivot Tables, k\u1ec3 c\u1ea3 b\u1ea1n kh\u00f4ng c\u00f3 ki\u1ebfn th\u1ee9c g\u00ec v\u1ec1 h\u00e0m Excel, b\u1ea1n v\u1eabn c\u00f3 th\u1ec3 ph\u00e2n t\u00edch \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u v\u00e0 nhanh ch\u00f3ng t\u1ea1o ra nh\u1eefng b\u00e1o c\u00e1o v\u1edbi Pivot Tables.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_Bo_qua_VBA_de_tu_dong_hoa_la_1_sai_lam\"><\/span>4. B\u1ecf qua VBA \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng ho\u00e1 l\u00e0 1 sai l\u1ea7m<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y c\u1ee7a b\u1ea1n s\u1ebd tr\u1edf n\u00ean nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3 h\u01a1n r\u1ea5t r\u1ea5t nhi\u1ec1u l\u1ea7n n\u1ebfu b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng VBA \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng ho\u00e1 nhi\u1ec1u thao t\u00e1c l\u1eb7p l\u1ea1i, trong \u0111\u00f3 c\u00f3:<\/p>\n<ul style=\"list-style-type: square\">\n<li>\n<h4><span class=\"ez-toc-section\" id=\"Trich_loc_du_lieu\"><\/span>Tr\u00edch l\u1ecdc d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<\/li>\n<li>\n<h4><span class=\"ez-toc-section\" id=\"Tao_bao_cao_va_cap_nhat_bao_cao_khi_co_du_lieu_moi\"><\/span>T\u1ea1o b\u00e1o c\u00e1o v\u00e0 c\u1eadp nh\u1eadt b\u00e1o c\u00e1o khi c\u00f3 d\u1eef li\u1ec7u m\u1edbi<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<\/li>\n<li>\n<h4><span class=\"ez-toc-section\" id=\"Tach_du_lieu_tu_1_file_ra_nhieu_file\"><\/span>T\u00e1ch d\u1eef li\u1ec7u t\u1eeb 1 file ra nhi\u1ec1u file<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<\/li>\n<li>\n<h4><span class=\"ez-toc-section\" id=\"Gop_du_lieu_tu_nhieu_file_vao_1_file\"><\/span>G\u1ed9p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u file v\u00e0o 1 file<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<\/li>\n<\/ul>\n<p>Ch\u01b0a bi\u1ebft b\u1eaft \u0111\u1ea7u v\u1edbi VBA nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y h\u1ecdc ngay <a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\" target=\"_blank\" rel=\"noopener noreferrer\">VBA101 \u2013 l\u1eadp tr\u00ecnh VBA d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_Phan_tich_du_lieu_bang_cach_ve_bieu_do_trong_Excel\"><\/span>5. Ph\u00e2n t\u00edch d\u1eef li\u1ec7u b\u1eb1ng c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>S\u1ebfp n\u00e0o c\u0169ng s\u1ebd \u0111\u00e1nh gi\u00e1 cao n\u1ebfu b\u1ea1n c\u00f3 kh\u1ea3 n\u0103ng t\u1ea1o ra nh\u1eefng b\u00e1o c\u00e1o \u0111\u1ed9ng nhanh, \u0111\u1eb9p v\u00e0 c\u00f3 t\u00ednh t\u01b0\u01a1ng t\u00e1c t\u1ed1t nh\u01b0 th\u1ebf n\u00e0y<\/p>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/oKoOxjgt17k?rel=0\" width=\"720\" height=\"400\" frameborder allowfullscreen=\"allowfullscreen\"><\/iframe>\n<h3><span class=\"ez-toc-section\" id=\"6_Hay_su_dung_Goal_Seek_va_bien_muc_tieu_cua_ban_thanh_su_that\"><\/span>6. H\u00e3y s\u1eed d\u1ee5ng Goal Seek v\u00e0 bi\u1ebfn m\u1ee5c ti\u00eau c\u1ee7a b\u1ea1n th\u00e0nh s\u1ef1 th\u1eadt<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Goal Seek l\u00e0 1 c\u00f4ng c\u1ee5 ph\u00e2n t\u00edch t\u00ecnh hu\u1ed1ng trong Excel gi\u00fap t\u00ecm ph\u01b0\u01a1ng \u00e1n t\u1ed1i \u01b0u cho business c\u1ee7a b\u1ea1n. Sau \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn b\u1eb1ng Videos:<\/p>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/5b4HxuMnWQc?rel=0\" width=\"720\" height=\"400\" frameborder allowfullscreen=\"allowfullscreen\"><\/iframe>\n<h1><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_hoc_duoc_tat_ca_nhung_kien_thuc_tren\"><\/span>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c t\u1ea5t c\u1ea3 nh\u1eefng ki\u1ebfn th\u1ee9c tr\u00ean?<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>\u0110\u1ec3 n\u1eafm \u0111\u01b0\u1ee3c t\u1ea5t c\u1ea3 c\u00e1c b\u00ed k\u00edp tr\u00ean, H\u1ecdc Excel Online xin \u0111\u1ed3ng h\u00e0nh c\u00f9ng b\u1ea1n qua c\u00e1c kho\u00e1 h\u1ecdc:<\/p>\n<ul style=\"list-style-type: square\">\n<li>H\u1ecdc Excel, C\u00f3 Vi\u1ec7c Ngay: <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">https:\/\/www.hocexcel.online\/ex101<\/a><\/li>\n<li>H\u00e3y \u0111\u1ec3 VBA gi\u00fap b\u1ea1n: <a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\">https:\/\/www.hocexcel.online\/vba101<\/a><\/li>\n<li>Hi\u1ec3u v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u1edbi Excel: <a href=\"https:\/\/hocexcel.online\/course\/preview\/dv101-truc-quan-hoa-du-lieu-voi-bieu-do-trong-excel-dashboard-va-data-visualization\">https:\/\/www.hocexcel.online\/dv101<\/a><\/li>\n<\/ul>\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-747.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8238,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8237","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\/8237","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=8237"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8237\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8238"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8237"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8237"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8237"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}