{"id":8322,"date":"2024-12-22T06:34:29","date_gmt":"2024-12-22T06:34:29","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/ex101-hoc-excel-tu-co-ban-den-nang-cao\/"},"modified":"2024-12-22T06:34:29","modified_gmt":"2024-12-22T06:34:29","slug":"ex101-hoc-excel-tu-co-ban-den-nang-cao","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/ex101-hoc-excel-tu-co-ban-den-nang-cao\/","title":{"rendered":"EX101 \u2013 H\u1ecdc Excel t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\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-6767b2f424891\" 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\/ex101-excel-tu-co-ban-den-nang-cao.html#Chi_tiet_khoa_hoc_Excel\" title=\"Chi ti\u1ebft kho\u00e1 h\u1ecdc Excel\">Chi ti\u1ebft kho\u00e1 h\u1ecdc Excel<\/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\/ex101-excel-tu-co-ban-den-nang-cao.html#Hieu_qua_dau_ra_cua_khoa_hoc_Excel\" title=\"Hi\u1ec7u qu\u1ea3 \u0111\u1ea7u ra c\u1ee7a kho\u00e1 h\u1ecdc Excel\">Hi\u1ec7u qu\u1ea3 \u0111\u1ea7u ra c\u1ee7a kho\u00e1 h\u1ecdc Excel<\/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\/ex101-excel-tu-co-ban-den-nang-cao.html#Giang_Vien\" title=\"Gi\u1ea3ng Vi\u00ean\">Gi\u1ea3ng Vi\u00ean<\/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\/ex101-excel-tu-co-ban-den-nang-cao.html#Giao_trinh_chi_tiet_cua_khoa_hoc_Excel\" title=\"Gi\u00e1o tr\u00ecnh chi ti\u1ebft c\u1ee7a kho\u00e1 h\u1ecdc Excel\">Gi\u00e1o tr\u00ecnh chi ti\u1ebft c\u1ee7a kho\u00e1 h\u1ecdc Excel<\/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\/ex101-excel-tu-co-ban-den-nang-cao.html#Thong_tin_ve_hinh_thuc_hoc_Excel\" title=\"Th\u00f4ng tin v\u1ec1 h\u00ecnh th\u1ee9c h\u1ecdc Excel\">Th\u00f4ng tin v\u1ec1 h\u00ecnh th\u1ee9c h\u1ecdc Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/ex101-excel-tu-co-ban-den-nang-cao.html#Cach_dang_ky_va_nhan_tai_khoan_hoc_Excel\" title=\"C\u00e1ch \u0111\u0103ng k\u00fd v\u00e0 nh\u1eadn t\u00e0i kho\u1ea3n h\u1ecdc Excel\">C\u00e1ch \u0111\u0103ng k\u00fd v\u00e0 nh\u1eadn t\u00e0i kho\u1ea3n h\u1ecdc Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1><span class=\"ez-toc-section\" id=\"Chi_tiet_khoa_hoc_Excel\"><\/span>Chi ti\u1ebft kho\u00e1 h\u1ecdc Excel<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>Kho\u00e1 h\u1ecdc EX101 \u2013 H\u1ecdc Excel t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao. \u0110\u00fang nh\u01b0 t\u00ean g\u1ecdi, \u0111\u00e2y l\u00e0 1 kho\u00e1 h\u1ecdc Excel r\u1ea5t bao qu\u00e1t s\u1ebd gi\u00fap b\u1ea1n ti\u1ebfp thu v\u00e0 \u1ee9ng d\u1ee5ng ki\u1ebfn th\u1ee9c Excel t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 ti\u1ec7n l\u1ee3i nh\u1ea5t b\u1edfi gi\u1ea3ng vi\u00ean d\u00e0y d\u1eb7n kinh nghi\u1ec7m.<\/p>\n<h1><span class=\"ez-toc-section\" id=\"Hieu_qua_dau_ra_cua_khoa_hoc_Excel\"><\/span>Hi\u1ec7u qu\u1ea3 \u0111\u1ea7u ra c\u1ee7a kho\u00e1 h\u1ecdc Excel<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<ul>\n<li>H\u01a1n 100 b\u00e0i gi\u1ea3ng c\u1ef1c k\u00ec chi ti\u1ebft v\u00e0 d\u1ec5 hi\u1ec3u bao g\u1ed3m nhi\u1ec1u k\u0129 thu\u1eadt t\u1eeb \u0111\u01a1n gi\u1ea3n \u0111\u1ebfn n\u00e2ng cao c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng \u0111\u01b0\u1ee3c cho Excel 2007, Excel 2010, Excel 2013, Excel 2016 \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y khoa h\u1ecdc s\u1ebd gi\u00fap b\u1ea1n l\u00e0m ch\u1ee7 \u0111\u01b0\u1ee3c ph\u1ea7n m\u1ec1m Excel ngay sau kho\u00e1 h\u1ecdc.<\/li>\n<li>C\u00e1c b\u00e0i gi\u1ea3ng \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf theo d\u1ea1ng c\u1ea7m tay ch\u1ec9 vi\u1ec7c, h\u1ecdc vi\u00ean c\u00f3 th\u1ec3 th\u1ef1c h\u00e0nh, \u00e1p d\u1ee5ng \u0111\u01b0\u1ee3c ngay v\u00e0o trong c\u00f4ng vi\u1ec7c.<\/li>\n<li>Kh\u00f3a h\u1ecdc nh\u01b0 m\u1ed9t cu\u1ed1n s\u00e1ch tra c\u1ee9u c\u00e1c th\u1ee7 thu\u1eadt, c\u00e1ch gi\u1ea3i quy\u1ebft c\u00e1c v\u1ea5n \u0111\u1ec1 g\u1eb7p ph\u1ea3i trong Excel.<\/li>\n<li>Sau kho\u00e1 h\u1ecdc, h\u1ecdc vi\u00ean c\u00f3 th\u1ec3 t\u1ef1 tin \u0111i xin vi\u1ec7c ho\u1eb7c \u00e1p d\u1ee5ng nh\u1eefng ki\u1ebfn th\u1ee9c \u0111\u00e3 h\u1ecdc \u0111\u1ec3 ph\u00e1t tri\u1ec3n nh\u1eefng c\u00f4ng c\u1ee5 s\u1eed d\u1ee5ng trong Excel c\u1ee7a ri\u00eang m\u00ecnh<\/li>\n<\/ul>\n<h1><span class=\"ez-toc-section\" id=\"Giang_Vien\"><\/span>Gi\u1ea3ng Vi\u00ean<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p><strong>Ths. Nguy\u1ec5n \u0110\u1ee9c Thanh<\/strong><\/p>\n<p>Chuy\u00ean vi\u00ean t\u01b0 v\u1ea5n gi\u1ea3i ph\u00e1p, ph\u1ea7n m\u1ec1m h\u1ec7 th\u1ed1ng t\u1ea1i t\u1eadp \u0111o\u00e0n KPMG, \u0110\u1ee9c. <strong><a href=\"http:\/\/www.linkedin.com\/in\/ducthanhnguyen\" target=\"_blank\" rel=\"noopener noreferrer\">Linkedin<\/a><\/strong><\/p>\n<p>Gi\u1ea3ng vi\u00ean c\u1ee7a c\u00e1c kho\u00e1 h\u1ecdc:<\/p>\n<ul>\n<li><a href=\"https:\/\/blog.hocexcel.online\/vba101-landing.html\" target=\"_blank\" rel=\"noopener noreferrer\">VBA101 \u2013 VBA c\u01a1 b\u1ea3n cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/a><\/li>\n<li><a href=\"https:\/\/blog.hocexcel.online\/subscribe\" target=\"_blank\" rel=\"noopener noreferrer\">nhi\u1ec1u kho\u00e1 h\u1ecdc online kh\u00e1c<\/a><\/li>\n<li>Gi\u1ea3ng d\u1ea1y t\u1ea1i trung t\u00e2m b\u00e1o c\u00e1o s\u1ed1 li\u1ec7u (BICC), ng\u00e2n h\u00e0ng Vi\u1ec7t Nam th\u1ecbnh v\u01b0\u1ee3ng \u2013 VPBank<\/li>\n<li>Gi\u1ea3ng d\u1ea1y t\u1ea1i t\u1eadp \u0111o\u00e0n Vingroup<\/li>\n<\/ul>\n<p>Admin:<\/p>\n<ol>\n<li><a href=\"https:\/\/blog.hocexcel.online\/\" target=\"_blank\" rel=\"noopener noreferrer\">H\u1ecdc Excel Online<\/a><\/li>\n<li><a href=\"http:\/\/youtube.com\/c\/hocexcelonline\" target=\"_blank\" rel=\"noopener noreferrer\">K\u00eanh YouTube h\u1ecdc Excel, tin h\u1ecdc v\u0103n ph\u00f2ng<\/a><\/li>\n<li><a href=\"https:\/\/www.facebook.com\/www.hocexcel.online\/\" target=\"_blank\" rel=\"noopener noreferrer\">FanPage H\u1ecdc Excel Online<\/a><\/li>\n<li><a href=\"https:\/\/www.facebook.com\/groups\/hocexcel.online\/\" target=\"_blank\" rel=\"noopener noreferrer\">Group Tin h\u1ecdc v\u0103n ph\u00f2ng Excel Word PowerPoint<\/a><\/li>\n<\/ol>\n<p><a href=\"https:\/\/blog.hocexcel.online\/ex101-excel-tu-co-ban-den-nang-cao.html#dang-ky\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2228 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/register_now-4.png\" width=\"512\" height=\"100\" title=\"register_now-4\"><\/a><\/p>\n<h1><span class=\"ez-toc-section\" id=\"Giao_trinh_chi_tiet_cua_khoa_hoc_Excel\"><\/span>Gi\u00e1o tr\u00ecnh chi ti\u1ebft c\u1ee7a kho\u00e1 h\u1ecdc Excel<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p><strong>Ph\u1ea7n 1: T\u1ed5ng quan v\u1ec1 ph\u1ea7n m\u1ec1m Excel<\/strong><br \/>\n01 \u2013 Gio\u031b\u0301i thie\u0323\u0302u giao die\u0323\u0302n Excel 2016<br \/>\n02 \u2013 The\u0309 File trong Excel<br \/>\n03 \u2013 Thao ta\u0301c mo\u031b\u0309 va\u0300 lu\u031bu file Excel<br \/>\n04 \u2013 Ca\u0301c thao ta\u0301c co\u031b ba\u0309n vo\u031b\u0301i vu\u0300ng du\u031b\u0303 lie\u0323\u0302u<br \/>\n05 \u2013 Ca\u0301c thao ta\u0301c co\u031b ba\u0309n vo\u031b\u0301i sheets o\u031b\u0309 trong Excel<br \/>\n06 \u2013 Di chuye\u0302\u0309n nhanh trong 1 vu\u0300ng du\u031b\u0303 lie\u0323\u0302u<br \/>\n07 \u2013 Ti\u0300m kie\u0302\u0301m du\u031b\u0303 lie\u0323\u0302u trong Excel<br \/>\n08 \u2013 Ti\u0300m kie\u0302\u0301m va\u0300 thay the\u0302\u0301 du\u031b\u0303 lie\u0323\u0302u trong Excel<br \/>\n09 \u2013 Ti\u0300m kie\u0302\u0301m du\u031b\u0303 lie\u0323\u0302u theo \u0111i\u0323nh da\u0323ng trong Excel<br \/>\n10 \u2013 Ca\u0301ch nha\u0323\u0302p du\u031b\u0303 lie\u0323\u0302u trong ba\u0309ng ti\u0301nh Excel<br \/>\n11 \u2013 Ca\u0301c kie\u0302\u0309u du\u031b\u0303 lie\u0323\u0302u trong Excel va\u0300 ca\u0301ch pha\u0302n bie\u0323\u0302t<br \/>\n12 \u2013 Thay \u0111o\u0302\u0309i \u0111o\u0323\u0302 ro\u0323\u0302ng ha\u0300ng co\u0323\u0302t.<br \/>\n13 \u2013 The\u0302m co\u0323\u0302t the\u0302m do\u0300ng trong Excel<br \/>\n14 \u2013 Xoa\u0301 ha\u0300ng hoa\u0323\u0306c co\u0323\u0302t trong Excel<br \/>\n15 \u2013 Di chuye\u0302\u0309n co\u0323\u0302t trong Excel<br \/>\n16 \u2013 A\u0302\u0309n hie\u0323\u0302n do\u0300ng va\u0300 co\u0323\u0302t trong Excel<br \/>\n17 \u2013 Chu\u031b\u0301c na\u0306ng Wrap Text va\u0300 ca\u0301ch xuo\u0302\u0301ng do\u0300ng trong 1 o\u0302<br \/>\n18 \u2013 Chu\u031b\u0301c na\u0306ng tro\u0323\u0302n o\u0302 \u2013 Merge Cells<br \/>\n19 \u2013 Su\u031b\u0309a du\u031b\u0303 lie\u0323\u0302u bi\u0323 tro\u0323\u0302n o\u0302, bi\u0323 merge cell<br \/>\n<strong>Ph\u1ea7n 2: C\u00e1c thao t\u00e1c \u0111\u1ecbnh d\u1ea1ng c\u01a1 b\u1ea3n<\/strong><br \/>\n20 \u2013 \u0110i\u0323nh da\u0323ng tie\u0302u \u0111e\u0302\u0300 nghie\u0302ng trong 1 ba\u0309ng<br \/>\n21 \u2013 \u0110i\u0323nh da\u0323ng co\u031b ba\u0309n cho ba\u0309ng ti\u0301nh, co\u0302ng cu\u0323 format painters<br \/>\n22 \u2013 Co\u0302\u0301 \u0111i\u0323nh ha\u0300ng co\u0323\u0302t trong Excel vo\u031b\u0301i Freeze Panes<br \/>\n23 \u2013 Ca\u0301ch ta\u0323o \u0111u\u031bo\u031b\u0300ng che\u0301o trong 1 o\u0302, xuo\u0302\u0301ng do\u0300ng trong 1 o\u0302 Excel<br \/>\n24 \u2013 Co\u031b ba\u0309n ve\u0302\u0300 \u0111i\u0323nh da\u0323ng du\u031b\u0303 lie\u0323\u0302u 01<br \/>\n25 \u2013 Co\u031b ba\u0309n ve\u0302\u0300 \u0111i\u0323nh da\u0323ng du\u031b\u0303 lie\u0323\u0302u 02<br \/>\n26 \u2013 Thu\u031b\u0323c ha\u0300nh \u0111i\u0323nh da\u0323ng du\u031b\u0303 lie\u0323\u0302u<br \/>\n27 \u2013 Chu\u031b\u0301c na\u0306ng Wrap Text va\u0300 ca\u0301ch xuo\u0302\u0301ng do\u0300ng trong 1 o\u0302<br \/>\n28 \u2013 Chu\u031b\u0301c na\u0306ng Text To Columns<br \/>\n29 \u2013 Sa\u0306\u0301p xe\u0302\u0301p du\u031b\u0303 lie\u0323\u0302u theo 1 co\u0323\u0302t va\u0300 nhie\u0302\u0300u co\u0323\u0302t<a href=\"https:\/\/blog.hocexcel.online\/ex101-excel-tu-co-ban-den-nang-cao.html#dang-ky\"><br \/>\n<\/a><br \/>\n<strong>Ph\u1ea7n3: C\u00e1c ch\u1ee9c n\u0103ng l\u1ecdc d\u1eef li\u1ec7u<\/strong><br \/>\n30 \u2013 Gio\u031b\u0301i thie\u0323\u0302u co\u031b ba\u0309n ve\u0302\u0300 lo\u0323c du\u031b\u0303 lie\u0323\u0302u trong Excel<br \/>\n31 \u2013 Xoa\u0301 Filter, kho\u0302i phu\u0323c du\u031b\u0303 lie\u0323\u0302u tru\u031bo\u031b\u0301c khi lo\u0323c<br \/>\n32 \u2013 Lo\u0323c du\u031b\u0303 lie\u0323\u0302u theo nhie\u0302\u0300u co\u0323\u0302t<br \/>\n33 \u2013 Lo\u0323c du\u031b\u0303 lie\u0323\u0302u da\u0323ng Text<br \/>\n34 \u2013 Lo\u0323c du\u031b\u0303 lie\u0323\u0302u da\u0323ng so\u0302\u0301<br \/>\n35 \u2013 Lo\u0323c du\u031b\u0303 lie\u0323\u0302u nga\u0300y tha\u0301ng<br \/>\n36 \u2013 Ba\u0306\u0301t \u0111a\u0302\u0300u vo\u031b\u0301i Advanced Filter<br \/>\n37 \u2013 Copy ke\u0302\u0301t qua\u0309 lo\u0323c advanced Filter ra 1 sheet mo\u031b\u0301i<br \/>\n38 \u2013 Su\u031b\u0309 du\u0323ng advanced filter vo\u031b\u0301i ca\u0301c phe\u0301p so sa\u0301nh<br \/>\n39 \u2013 Su\u031b\u0309 du\u0323ng \u0111ie\u0302\u0300u kie\u0323\u0302n VA\u0300 trong advanced filter<br \/>\n40 \u2013 Su\u031b\u0309 du\u0323ng co\u0302ng thu\u031b\u0301c o\u031b\u0309 vu\u0300ng \u0111ie\u0302\u0300u kie\u0323\u0302n cu\u0309a advanced filter<br \/>\n41 \u2013 To\u0302\u0309ng ke\u0302\u0301t ve\u0302\u0300 \u0111ie\u0302\u0300u kie\u0323\u0302n AND va\u0300 OR khi su\u031b\u0309 du\u0323ng Advanced Filter<br \/>\n42 \u2013 Su\u031b\u0309 du\u0323ng ki\u0301 tu\u031b\u0323 \u0111a\u0323i die\u0323\u0302n trong advanced filter<br \/>\n43 \u2013 Lo\u0323c du\u031b\u0303 lie\u0323\u0302u text chi\u0301nh xa\u0301c<br \/>\n44 \u2013 Lo\u0323c du\u031b\u0303 lie\u0323\u0302u co\u0323\u0302t nga\u0300y tha\u0301ng vo\u031b\u0301i advanced filter<br \/>\n45 \u2013 Lo\u0323c du\u031b\u0303 lie\u0323\u0302u duy nha\u0302\u0301t ba\u0306\u0300ng advanced filter<br \/>\n46 \u2013 Lo\u0323c du\u031b\u0303 lie\u0323\u0302u co\u0301 pha\u0302n bie\u0323\u0302t chu\u031b\u0303 hoa, chu\u031b\u0303 thu\u031bo\u031b\u0300ng du\u0300ng advanced filter<br \/>\n47 \u2013 Lo\u0323c du\u031b\u0303 lie\u0323\u0302u ba\u0306\u0300ng advanced filter va\u0300 ha\u0300m average<br \/>\n<strong>Ph\u1ea7n 4: Gi\u1edbi thi\u1ec7u v\u1ec1 h\u00e0m trong Excel<\/strong><br \/>\n48 \u2013 Ca\u0301c phe\u0301p toa\u0301n co\u0323\u0302ng tru\u031b\u0300 nha\u0302n chia, luy\u0303 thu\u031b\u0300a trong Excel<br \/>\n49 \u2013 Gio\u031b\u0301i thie\u0323\u0302u ve\u0302\u0300 ca\u0301ch su\u031b\u0309 du\u0323ng 1 ha\u0300m trong Excel<br \/>\n50 \u2013 BT hoa\u0300n tha\u0300nh ba\u0309ng ti\u0301nh du\u031b\u0323a tre\u0302n kie\u0302\u0301n thu\u031b\u0301c \u0111a\u0303 ho\u0323c<br \/>\n51 \u2013 Khoa\u0301 \u0111i\u0323a chi\u0309 o\u0302 trong Excel khi su\u031b\u0309 du\u0323ng co\u0302ng thu\u031b\u0301c<br \/>\n52 \u2013 Ha\u0300m toa\u0301n ho\u0323c \u2013 ABS, INT<br \/>\n52 \u2013 Ha\u0300m toa\u0301n ho\u0323c \u2013 MOD, ROUND<br \/>\n53 \u2013 Ha\u0300m toa\u0301n ho\u0323c \u2013 ti\u0301nh ca\u0306n, ti\u0301nh luy\u0303 thu\u031b\u0300a<br \/>\n54 \u2013 A\u0301p du\u0323ng ha\u0300m toa\u0301n ho\u0323c gia\u0309i phu\u031bo\u031bng tri\u0300nh trong Excel<br \/>\n55 \u2013 Ha\u0300m SUM, MIN, MAX, AVERAGE<br \/>\n56 \u2013 Ca\u0301c ha\u0300m xu\u031b\u0309 ly\u0301 chuo\u0302\u0303i trong Excel<br \/>\n57 \u2013 Ta\u0301ch te\u0302n, su\u031b\u0309 du\u0323ng phi\u0301m F9 \u0111e\u0302\u0309 ti\u0300m hie\u0302\u0309u co\u0302ng thu\u031b\u0301c<br \/>\n57.1 \u2013 Huong dan tach ten ho va ten dem trong excel<br \/>\n58 \u2013 Ha\u0300m IF, AND, OR<\/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-757.gif\" title=\"ex101_92019-nho-757\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><a href=\"https:\/\/blog.hocexcel.online\/ex101-excel-tu-co-ban-den-nang-cao.html#dang-ky\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2228 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/register_now-4.png\" width=\"512\" height=\"100\" title=\"register_now-4\"><\/a><br \/>\n<strong>Ph\u1ea7n 5: C\u00e1c h\u00e0m n\u00e2ng cao trong Excel<\/strong><br \/>\n59 \u2013 La\u0300m vie\u0323\u0302c vo\u031b\u0301i thu\u031b\u0301 nga\u0300y tha\u0301ng trong Excel<br \/>\n60 \u2013 Ha\u0300m do\u0300 ti\u0300m VLOOKUP<br \/>\n61 \u2013 VLOOKUP nhie\u0302\u0300u \u0111ie\u0302\u0300u kie\u0323\u0302n<br \/>\n62 \u2013 Ha\u0300m Index va\u0300 Match<br \/>\n63 \u2013 Luye\u0323\u0302n ta\u0323\u0302p Index va\u0300 Match<br \/>\n64 \u2013 Ba\u0309o ve\u0323\u0302 vu\u0300ng ba\u0309ng ti\u0301nh kho\u0302ng cho phe\u0301p su\u031b\u0309a<br \/>\n65 \u2013 Ha\u0300m Forecast<br \/>\n66 \u2013 Ha\u0300m Trend<br \/>\n67 \u2013 Su\u031b\u0309 du\u0323ng ti\u0301nh na\u0306ng Goal Seek<br \/>\n68 \u2013 Ca\u0301c tho\u0302ng ba\u0301o lo\u0302\u0303i thu\u031bo\u031b\u0300ng ga\u0323\u0306p khi su\u031b\u0309 du\u0323ng ha\u0300m, su\u031b\u0309 du\u0323ng IFERROR<br \/>\n69 \u2013 Countif \u0111e\u0302\u0301m theo \u0111ie\u0302\u0300u kie\u0323\u0302n<br \/>\n70 \u2013 Danh sa\u0301ch ngu\u031bo\u031b\u0300i du\u0300ng \u0111e\u0302\u0300 ra \u0111e\u0302\u0309 sa\u0306\u0301p xe\u0302\u0301p va\u0300 fill du\u031b\u0303 lie\u0323\u0302u<br \/>\n71 \u2013 Ti\u0301nh to\u0302\u0309ng theo \u0111ie\u0302\u0300u kie\u0323\u0302n vo\u031b\u0301i ha\u0300m sumif<br \/>\n72 \u2013 Su\u031b\u0309 du\u0323ng SUMIF vo\u031b\u0301i da\u0302\u0301u * va\u0300 ? \u0111e\u0302\u0309 \u0111e\u0302\u0301m theo \u0111ie\u0302\u0300u kie\u0323n<br \/>\n73 \u2013 SUMPRODUCT<br \/>\n74 \u2013 La\u0302\u0301y du\u031b\u0303 lie\u0323\u0302u tu\u031b\u0300 nhie\u0302\u0300u ba\u0309ng la\u0300m ba\u0301o ca\u0301o<br \/>\n75 \u2013 To\u0302 ma\u0300u co\u0301 \u0111ie\u0302\u0300u kie\u0323\u0302n cho ca\u0309 do\u0300ng du\u031b\u0303 lie\u0323\u0302u trong Excel [\u0111u\u0301ng]<br \/>\n76 \u2013 Qu\u1ea3n l\u00fd gi\u1edd nh\u00e2n s\u1ef1 trong Excel<br \/>\n77 Array formula \u2013 Co\u0302ng thu\u031b\u0301c ma\u0309ng trong Excel<br \/>\n78 Cong cu Flash Fill tach ten ho khong dung cong thuc<br \/>\n<strong>Ph\u1ea7n 6: \u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n<\/strong><br \/>\n79.1 \u0110i\u0323nh da\u0323ng du\u031b\u0303 lie\u0323\u0302u theo \u0111ie\u0302\u0300u kie\u0323\u0302n lo\u031b\u0301n ho\u031bn hoa\u0323\u0306c nho\u0309 ho\u031bn mo\u0323\u0302t so\u0302\u0301<br \/>\n79.2 \u0110i\u0323nh da\u0323ng du\u031b\u0303 lie\u0323\u0302u giu\u031b\u0303a 1 khoa\u0309ng<br \/>\n79.3 U\u031b\u0301ng du\u0323ng cu\u0309a \u0111i\u0323nh da\u0323ng du\u031b\u0303 lie\u0323\u0302u theo \u0111k 1<br \/>\n79.4 To\u0302 ma\u0300u o\u0302 co\u0301 gia\u0301 tri\u0323 ba\u0306\u0300ng mo\u0323\u0302t gia\u0301 tri\u0323 kha\u0301c<br \/>\n79.5 To\u0302 ma\u0300u o\u0302 co\u0301 chu\u031b\u0301a ki\u0301 tu\u031b\u0323 cho tru\u031bo\u031b\u0301c<br \/>\n79.6 To\u0302 ma\u0300u du\u031b\u0303 lie\u0323\u0302u la\u0323\u0306p, duy nha\u0302\u0301t<br \/>\n79.7 \u2013 Ti\u0300m kie\u0302\u0301m va\u0300 thay the\u0302\u0301 theo \u0111i\u0323nh da\u0323ng<br \/>\n<strong>Ph\u1ea7n 7: Ph\u00e2n t\u00edch d\u1eef li\u1ec7u b\u1eb1ng Pivot Table<\/strong><br \/>\n80.01 Pivot table so sa\u0301nh vo\u031b\u0301i co\u0302ng thu\u031b\u0301c bi\u0300nh thu\u031bo\u031b\u0300ng<br \/>\n80.02 Pivot table la\u0300 gi\u0300<br \/>\n80.03 Cach tao pivot table<br \/>\n80.04 Ca\u0323\u0302p nha\u0323\u0302t du\u031b\u0303 lie\u0323\u0302u cho Pivot table<br \/>\n80.05 Cach xem du lieu ben duoi cua Pivot table<br \/>\n80.06 Vi sao nen dinh dang du lieu nguon duoi dang bang<br \/>\n80.07 Ca\u0301ch ke\u0301o du\u031b\u0303 lie\u0323\u0302u \u0111e\u0302\u0309 pha\u0302n ti\u0301ch va\u0300o Pivot table<br \/>\n80.08 Ca\u0301ch \u0111ie\u0302\u0300u chi\u0309nh mo\u0323\u0302t so\u0302\u0301 tha\u0300nh pha\u0302\u0300n cu\u0309a Pivot table<br \/>\n80.09 Ca\u0301ch \u0111i\u0323nh da\u0323ng so\u0302\u0301 trong Pivot table<br \/>\n80.10 Ca\u0301ch chuye\u0302\u0309n co\u0302ng thu\u031b\u0301c a\u0301p du\u0323ng tre\u0302n Pivot Table<br \/>\n80.11 Ca\u0301ch a\u0302\u0309n hie\u0323\u0302n grand total trong Pivot table<br \/>\n80.12 La\u0300m vie\u0323\u0302c vo\u031b\u0301i Subtotal trong ba\u0309ng Pivot<br \/>\n80.13 Nho\u0301m du\u031b\u0303 lie\u0323\u0302u theo nga\u0300y tha\u0301ng na\u0306m<br \/>\n80.14 Nho\u0301m du\u031b\u0303 lie\u0323\u0302u theo tu\u031b\u0300ng khoa\u0309ng gia\u0301 tri\u0323<br \/>\n80.15 \u2013 Sales Dashboard<br \/>\n<strong>Ph\u1ea7n 8: Bi\u1ec3u \u0111\u1ed3 trong Excel, c\u01a1 b\u1ea3n v\u1ec1 bi\u1ec3u \u0111\u1ed3<\/strong><br \/>\n81.1 \u2013 Pha\u0302\u0300n co\u031b ba\u0309n \u2013 Ve\u0303 bie\u0302\u0309u \u0111o\u0302\u0300 trong Excel 01<br \/>\n81.2 \u2013 Pha\u0302\u0300n co\u031b ba\u0309n \u2013 Ve\u0303 bie\u0302\u0309u \u0111o\u0302\u0300 trong Excel 02<br \/>\n81.3 \u2013 Pha\u0302\u0300n co\u031b ba\u0309n \u2013 Ve\u0303 bie\u0302\u0309u \u0111o\u0302\u0300 trong Excel 03<br \/>\n81.4 \u2013 Pha\u0302\u0300n co\u031b ba\u0309n \u2013 Tri\u0300nh ba\u0300y ba\u0309ng<br \/>\n81.5 \u2013 Pha\u0302\u0300n co\u031b ba\u0309n \u2013 Ve\u0303 \u0111o\u0302\u0300 thi\u0323 sao cho \u0111e\u0323p<br \/>\n81.6 \u2013 Pha\u0302\u0300n co\u031b ba\u0309n \u2013 Nh\u1ea5n m\u1ea1nh v\u00e0o th\u00f4ng \u0111i\u1ec7p c\u1ea7n truy\u1ec1n \u0111\u1ea1t qua bi\u1ec3u \u0111\u1ed3<br \/>\n81.7 \u2013 Pha\u0302\u0300n co\u031b ba\u0309n \u2013 ca\u0301c bu\u031bo\u031b\u0301c \u0111e\u0302\u0309 ve\u0303 bie\u0302\u0309u \u0111o\u0302\u0300 hie\u0323\u0302u qua\u0309<br \/>\n81.8 \u2013 Nha\u0302\u0301n ma\u0323nh tho\u0302ng tin tre\u0302n bie\u0302\u0309u \u0111o\u0302\u0300<br \/>\n81.9 \u2013 Bie\u0302\u0309u \u0111o\u0302\u0300 2 tru\u0323c tung<\/p>\n<p>\u00a0<\/p>\n<h1><span class=\"ez-toc-section\" id=\"Thong_tin_ve_hinh_thuc_hoc_Excel\"><\/span>Th\u00f4ng tin v\u1ec1 h\u00ecnh th\u1ee9c h\u1ecdc Excel<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<table style=\"height: 150px;width: 584px\">\n<tbody>\n<tr>\n<td style=\"width: 226px\">H\u00ecnh th\u1ee9c h\u1ecdc<\/td>\n<td style=\"width: 344px\">Online qua video, h\u1ed7 tr\u1ee3 qua <a href=\"https:\/\/www.facebook.com\/groups\/ex101\/\" target=\"_blank\" rel=\"noopener noreferrer\">facebook group<\/a><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 226px\">S\u1ed1 video<\/td>\n<td style=\"width: 344px\">111 (s\u1ebd c\u1eadp nh\u1eadt th\u00eam video h\u00e0ng th\u00e1ng)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 226px\">Th\u1eddi l\u01b0\u1ee3ng<\/td>\n<td style=\"width: 344px\">10 gi\u1edd<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 226px\">Tr\u00ecnh \u0111\u1ed9<\/td>\n<td style=\"width: 344px\">C\u01a1 b\u1ea3n, n\u00e2ng cao<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h1><span class=\"ez-toc-section\" id=\"Cach_dang_ky_va_nhan_tai_khoan_hoc_Excel\"><\/span><a id=\"dang-ky\" href=\"\"><\/a>C\u00e1ch \u0111\u0103ng k\u00fd v\u00e0 nh\u1eadn t\u00e0i kho\u1ea3n h\u1ecdc Excel<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p><strong>B\u01b0\u1edbc 1<\/strong><\/p>\n<p>Chuy\u1ec3n ti\u1ec1n theo c\u00fa ph\u00e1p sau \u0111\u00e2y. (H\u1ecdc ph\u00ed cho nh\u1eefng b\u1ea1n kh\u00f4ng \u1edf VN, m\u00ecnh nh\u1eadn ti\u1ec1n qua IBAN, SWIFT ho\u1eb7c l\u00e0 Paypal, li\u00ean h\u1ec7 <strong><a href=\"http:\/\/m.me\/www.hocexcel.online\" target=\"_blank\" rel=\"noopener noreferrer\">Facebook<\/a><\/strong> \u0111\u1ec3 \u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3 n\u1ebfu s\u1eed d\u1ee5ng c\u00e1c h\u00ecnh th\u1ee9c chuy\u1ec3n kho\u1ea3n n\u00e0y)<\/p>\n<table width=\"566\">\n<tbody>\n<tr>\n<td>Ch\u1ee7 TK<\/td>\n<td><strong>Nguy\u1ec5n \u0110\u1ee9c Thanh<\/strong><\/td>\n<\/tr>\n<tr>\n<td>S\u1ed1 TK<\/td>\n<td><strong>99042443<\/strong><\/td>\n<\/tr>\n<tr>\n<td>Chi nh\u00e1nh<\/td>\n<td><strong>VPBank Th\u0103ng Long<\/strong><\/td>\n<\/tr>\n<tr>\n<td>N\u1ed9i dung chuy\u1ec3n kho\u1ea3n<\/td>\n<td>H\u1ecd T\u00ean b\u1ea1n \u2013 S\u1ed1 \u0111i\u1ec7n tho\u1ea1i b\u1ea1n \u2013\u00a0EX101<\/p>\n<p>VD: Nguyen Duc Thanh \u2013 &lt;s\u1ed1 \u0111i\u1ec7n tho\u1ea1i&gt;\u00a0\u2013 EX101<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>H\u1ecdc Ph\u00ed<\/td>\n<td><strong>800.000 VN\u0110*<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>*Gi\u1ea3m ngay <strong>200.000 VN\u0110<\/strong> khi mua k\u00e8m <a href=\"https:\/\/blog.hocexcel.online\/vba101-landing.html\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>kho\u00e1 h\u1ecdc VBA101 \u2013 VBA c\u01a1 b\u1ea3n<\/strong><\/a><\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong><\/p>\n<p>Nh\u1eadn h\u01b0\u1edbng d\u1eabn \u0111\u0103ng nh\u1eadp, h\u01b0\u1edbng d\u1eabn v\u1ec1 nh\u00f3m v\u00e0 t\u00e0i li\u1ec7u tr\u1ee3 gi\u00fap trong qu\u00e1 tr\u00ecnh h\u1ecdc v\u00e0 b\u1eaft \u0111\u1ea7u h\u1ecdc ngay tr\u00ean trang ch\u1ee7 c\u1ee7a H\u1ecdc Excel Online.<\/p>\n<p><strong><a href=\"https:\/\/blog.hocexcel.online\/ex101-learn\" target=\"_blank\" rel=\"noopener noreferrer\">B\u1eaft \u0111\u1ea7u h\u1ecdc<\/a>\u00a0<\/strong>ho\u1eb7c<a href=\"http:\/\/m.me\/www.hocexcel.online\" target=\"_blank\" rel=\"noopener noreferrer\"><strong> nh\u1eafn tin \u0111\u1ec3 nh\u1eadn t\u01b0 v\u1ea5n<\/strong><\/a><\/p>\n<p><a href=\"https:\/\/blog.hocexcel.online\/ex101-excel-tu-co-ban-den-nang-cao.html#dang-ky\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2228 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/register_now-4.png\" width=\"512\" height=\"100\" title=\"register_now-4\"><\/a><\/p>\n<p>\u00a0<\/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-757.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8323,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8322","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\/8322","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=8322"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8322\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8323"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8322"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8322"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8322"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}