{"id":1954,"date":"2024-12-02T06:36:18","date_gmt":"2024-12-02T06:36:18","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-vlookup-nang-cao-vlookup-nhieu-cot-nhieu-dieu-kien\/"},"modified":"2024-12-02T06:36:18","modified_gmt":"2024-12-02T06:36:18","slug":"ham-vlookup-nang-cao-vlookup-nhieu-cot-nhieu-dieu-kien","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-vlookup-nang-cao-vlookup-nhieu-cot-nhieu-dieu-kien\/","title":{"rendered":"H\u00e0m VLOOKUP n\u00e2ng cao \u2013 VLOOKUP nhi\u1ec1u c\u1ed9t, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Sau khi \u0111\u00e3 bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\"><strong>h\u00e0m Vlookup<\/strong><\/a>, b\u1ea1n s\u1ebd r\u1ea5t t\u1ef1 tin \u0111i d\u00f2 t\u00ecm b\u1ea3ng t\u00ednh. Nh\u1eefng b\u01b0\u01a1\u0301c sau \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n c\u00f2n t\u1ef1 tin h\u01a1n n\u1eefa khi th\u00e0nh th\u1ea1o <strong>h\u00e0m vlookup c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/strong>. N\u1ebfu b\u1ea1n ch\u01b0a bi\u1ebft \u0111\u01b0\u1ee3c <strong><code class=\"highlighter-rouge\">VLOOKUP<\/code><\/strong> c\u01a1 b\u1ea3n th\u1ebf n\u00e0o, b\u1ea1n c\u00f3 th\u1ec3 theo d\u00f5i video n\u00e0y tr\u01b0\u1edbc khi \u0111\u1ecdc ti\u1ebfp<\/em><\/p>\n<div class=\"videowrapper\" style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/G2YpPjLgO9k?list=PLALCv46JuKEIb30S1S2jPgHLQnUvPpmsz&amp;wmode=transparent\" width=\"560\" height=\"315\" frameborder allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 b\u1ea3ng t\u00ednh Excel minh ho\u1ea1 cho v\u00ed d\u1ee5 n\u00e0y. B\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c h\u00e0nh tr\u1ef1c ti\u1ebfp tr\u00ean b\u1ea3ng t\u00ednh Excel n\u00e0y. N\u00e0o c\u00f9ng b\u1eaft \u0111\u1ea7u t\u00ecm hi\u1ec3u <strong>h\u00e0m vlookup c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/strong> th\u00f4i!<\/p>\n<p style=\"text-align: center\"><\/p>\n<p>H\u00e3y b\u1eaft \u0111\u1ea7u b\u1eb1ng v\u00ed d\u1ee5 sau \u0111\u00e2y (C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm th\u1ea5y VD n\u00e0y trong <strong><code class=\"highlighter-rouge\">Sheet1<\/code><\/strong> \u1edf b\u1ea3ng t\u00ednh Excel ph\u00eda tr\u00ean)<br \/>\n<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2015\/11\/2015-11-11-excel-su-dung-vlookup-nhieu-dieu-kien-01.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32269\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2015-11-11-excel-su-dung-vlookup-nhieu-dieu-kien-01.png\" alt=\"Excel s\u1eed d\u1ee5ng vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" width=\"1440\" height=\"720\" title=\"2015-11-11-excel-su-dung-vlookup-nhieu-dieu-kien-01\"><\/a><\/p>\n<p>\u1ede \u0111\u00e2y, \u0111\u1ec3 tra c\u1ee9u \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb \u1edf <strong>C\u1ed9t C<\/strong> m\u00e0 \u0111i\u1ec1u ki\u1ec7n l\u00e0 <strong><code class=\"highlighter-rouge\">Bb<\/code><\/strong> th\u00ec ch\u00fang ta c\u1ea7n th\u00eam m\u1ed9t <strong>C\u1ed9t ph\u1ee5<\/strong> nh\u01b0 \u1edf <strong><code class=\"highlighter-rouge\">C9:C15<\/code><\/strong>. Nh\u01b0ng khi ch\u00fang ta kh\u00f4ng \u0111\u01b0\u1ee3c ph\u00e9p thay \u0111\u1ed5i c\u1ea5u tr\u00fac c\u1ee7a b\u1ea3ng t\u00ednh, th\u00ec ch\u00fang ta kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng c\u00e1ch n\u00e0y. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u00f3 th\u1ec3 kh\u00f4ng thay \u0111\u1ed5i c\u1ea5u tr\u00fac c\u1ee7a b\u1ea3ng t\u00ednh m\u00e0 v\u1eabn c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c vi\u1ec7c n\u00e0y? Ch\u00fang ta c\u00f3 th\u1ec3 chuy\u1ec3n sang <strong><code class=\"highlighter-rouge\">Sheet2<\/code><\/strong>.<\/p>\n<p>Xem th\u00eam: T\u00f4\u0309ng h\u01a1\u0323p b\u00f4\u0323 ta\u0300i li\u00ea\u0323u <a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">h\u01b0\u01a1\u0301ng d\u00e2\u0303n ho\u0323c excel c\u01a1 ba\u0309n<\/a><\/p>\n<h3 id=\"s-dng-vlookup-cng-vi-choose-v-cng-thc-mng--tra-cu-d-liu-da-trn-nhiu-ct\">S\u1eed d\u1ee5ng VLOOKUP c\u00f9ng v\u1edbi CHOOSE v\u00e0 c\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ec3 tra c\u1ee9u d\u1eef li\u1ec7u d\u1ef1a tr\u00ean nhi\u1ec1u c\u1ed9t:<br \/>\n<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2015\/11\/2015-11-11-excel-su-dung-vlookup-nhieu-dieu-kien-02-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32270\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2015-11-11-excel-su-dung-vlookup-nhieu-dieu-kien-02-1.png\" alt=\"Excel s\u1eed d\u1ee5ng vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" width=\"1440\" height=\"720\" title=\"2015-11-11-excel-su-dung-vlookup-nhieu-dieu-kien-02-1\"><\/a><\/h3>\n<p>Trong <strong><code class=\"highlighter-rouge\">Sheet2<\/code><\/strong>, ch\u00fang ta s\u1eed d\u1ee5ng <strong>c\u00f4ng th\u1ee9c m\u1ea3ng<\/strong> sau \u0111\u00e2y t\u1ea1i \u00f4 <strong><code class=\"highlighter-rouge\">F2<\/code><\/strong> \u0111\u1ec3 c\u00f3 th\u1ec3 tra c\u1ee9u \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u. \u0110\u1ec3 nh\u1eadp c\u00f4ng th\u1ee9c n\u00e0y, c\u00e1c b\u1ea1n nh\u1edb d\u00f9ng t\u1ed5 h\u1ee3p ph\u00edm <strong><code class=\"highlighter-rouge\">CTRL<\/code><\/strong> + <strong><code class=\"highlighter-rouge\">SHIFT<\/code><\/strong> + <strong><code class=\"highlighter-rouge\">ENTER<\/code><\/strong><\/p>\n<div class=\"highlighter-rouge\">\n<pre class=\"highlight\"><code>=VLOOKUP(E2,CHOOSE({1,2},$A$2:$A$7&amp;$B$2:$B$7,$C$2:$C$7),2,0)\r\n<\/code><\/pre>\n<\/div>\n<p>\u1ede trong c\u00f4ng th\u1ee9c, c\u00e1c ph\u1ea7n \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u l\u00e0 ph\u1ea7n c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i tu\u1ef3 theo nhu c\u1ea7u s\u1eed d\u1ee5ng. \u0110\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c, ch\u00fang ta c\u00f3 th\u1ec3 theo d\u00f5i \u1ea3nh sau c\u00f9ng v\u1edbi t\u1eebng b\u01b0\u1edbc c\u1ee7a h\u00e0m <strong><code class=\"highlighter-rouge\">CHOOSE<\/code><\/strong>.<\/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-143.gif\" title=\"ex101_92019-nho-143\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p class=\"post-img\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2015\/11\/2015-11-11-excel-su-dung-vlookup-nhieu-dieu-kien-03.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32271\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2015-11-11-excel-su-dung-vlookup-nhieu-dieu-kien-03.png\" alt=\"Excel s\u1eed d\u1ee5ng vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" width=\"1440\" height=\"840\" title=\"2015-11-11-excel-su-dung-vlookup-nhieu-dieu-kien-03\"><\/a><\/p>\n<p>\u1ede \u0111\u00e2y, h\u00e0m <strong><code class=\"highlighter-rouge\">CHOOSE<\/code><\/strong> \u0111\u00e3 t\u1ea1o cho ch\u00fang ta 1 b\u1ea3ng d\u1eef li\u1ec7u g\u1ed3m 2 c\u1ed9t ngay trong c\u00f4ng th\u1ee9c \u0111\u1ec3 ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c ha\u0300m\u00a0<code class=\"highlighter-rouge\">VLOOKUP<\/code> m\u1ed9t c\u00e1ch ho\u00e0n to\u00e0n b\u00ecnh th\u01b0\u1eddng. C\u00e1ch d\u00f9ng h\u00e0m <strong><code class=\"highlighter-rouge\">CHOOSE<\/code><\/strong>, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 xem th\u00eam \u1edf \u1ea3nh sau \u0111\u00e2y ho\u1eb7c \u1edf trong b\u1ea3ng t\u00ednh Excel k\u00e8m theo b\u00e0i h\u1ecdc.<\/p>\n<p class=\"post-img\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2015\/11\/2015-11-11-excel-su-dung-vlookup-nhieu-dieu-kien-04.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32272\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2015-11-11-excel-su-dung-vlookup-nhieu-dieu-kien-04.png\" alt=\"Excel s\u1eed d\u1ee5ng vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" width=\"1440\" height=\"640\" title=\"2015-11-11-excel-su-dung-vlookup-nhieu-dieu-kien-04\"><\/a><\/p>\n<p>H\u00e0m <strong><code class=\"highlighter-rouge\">CHOOSE<\/code><\/strong> s\u1eed d\u1ee5ng trong b\u00e0i n\u00e0y c\u1ee7a ch\u00fang ta l\u00e0 <strong>h\u00e0m m\u1ea3ng<\/strong> n\u00ean n\u1ebfu b\u1ea1n mu\u1ed1n th\u1eed k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m <strong><code class=\"highlighter-rouge\">CHOOSE<\/code><\/strong> tr\u00ean b\u1ea3ng t\u00ednh Excel th\u00ec c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau \u1edf trong thanh c\u00f4ng th\u1ee9c tr\u00ean Excel \u1edf m\u00e1y t\u00ednh c\u1ee7a b\u1ea1n, nh\u1edb \u0111\u00e1nh d\u1ea5u c\u00f4ng th\u1ee9c tr\u00ean thanh c\u00f4ng th\u1ee9c v\u00e0 nh\u1ea5n ph\u00edm <strong><code class=\"highlighter-rouge\">F9<\/code><\/strong>, n\u1ebfu b\u1ea1n d\u00f9ng laptop, c\u00f3 th\u1ec3 b\u1ea1n ph\u1ea3i d\u00f9ng t\u1ed5 h\u1ee3p ph\u00edm <strong><code class=\"highlighter-rouge\">FN<\/code><\/strong> + <strong><code class=\"highlighter-rouge\">F9<\/code><\/strong>:<\/p>\n<div class=\"highlighter-rouge\">\n<pre class=\"highlight\"><code>=CHOOSE({1,2},\"H\u1ecdc\",\"Excel\",\"Online\",'Mi\u1ec5n\",\"Ph\u00ed\")\r\n<\/code><\/pre>\n<\/div>\n<p>K\u1ebft qu\u1ea3 b\u1ea1n nh\u1eadn \u0111\u01b0\u1ee3c \u1edf ngay tr\u00ean thanh c\u00f4ng th\u1ee9c l\u00e0 <code class=\"highlighter-rouge\">={\"H\u1ecdc\",\"Excel\"}<\/code><\/p>\n<p>N\u1ebfu ch\u01b0a hi\u1ec3u, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 xem th\u00eam videos sau \u0111\u00e2y:<\/p>\n<p style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/IA9RJpNIAs0\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<h3 id=\"thm-2-v-d-vi-vlookup-v-choose\"><span class=\"ez-toc-section\" id=\"Them_2_vi_du_voi_ham_vlookup_co_dieu_kien_va_CHOOSE\"><\/span>Th\u00eam 2 v\u00ed d\u1ee5 v\u1edbi h\u00e0m vlookup c\u00f3 \u0111i\u1ec1u ki\u1ec7n v\u00e0 CHOOSE:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h3 id=\"tra-cu-d-liu-da-trn-iu-kin-t-3-ct\"><span class=\"ez-toc-section\" id=\"Tra_cuu_du_lieu_dua_tren_dieu_kien_tu_3_cot\"><\/span>Tra c\u1ee9u d\u1eef li\u1ec7u d\u1ef1a tr\u00ean \u0111i\u1ec1u ki\u1ec7n t\u1eeb 3 c\u1ed9t<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u00ed d\u1ee5 n\u00e0y \u0111\u01b0\u1ee3c l\u01b0u trong <strong><code class=\"highlighter-rouge\">Sheet3<\/code><\/strong> c\u1ee7a b\u1ea3ng t\u00ednh \u1edf ph\u00eda tr\u00ean. Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 d\u00f9ng k\u0129 thu\u1eadt v\u1eeba \u0111\u01b0\u1ee3c mi\u00eau t\u1ea3 \u0111\u1ec3 tra c\u1ee9u d\u1eef li\u1ec7u t\u1eeb c\u1ed9t D d\u1ef1a tr\u00ean d\u1eef li\u1ec7u \u1edf c\u1ed9t A, c\u1ed9t B v\u00e0 c\u1ed9t C. \u0110\u1ebfn \u0111\u00e2y, hi v\u1ecdng c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 x\u1eed l\u00fd th\u00e0nh th\u1ea1o d\u00f9 d\u1eef li\u1ec7u c\u00f3 \u0111\u1ebfn t\u1eeb bao nhi\u00eau c\u1ed9t \u0111i n\u1eefa.<\/p>\n<p>Xem th\u00eam: B\u00f4\u0323 ta\u0300i li\u00ea\u0323u\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/excel-nang-cao\">Excel n\u00e2ng cao<\/a>\u00a0m\u01a1\u0301i nh\u00e2\u0301t<\/p>\n<p class=\"post-img\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2015\/11\/2015-11-11-excel-su-dung-vlookup-nhieu-dieu-kien-05.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32273\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2015-11-11-excel-su-dung-vlookup-nhieu-dieu-kien-05.png\" alt=\"Excel s\u1eed d\u1ee5ng vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" width=\"1440\" height=\"700\" title=\"2015-11-11-excel-su-dung-vlookup-nhieu-dieu-kien-05\"><\/a><\/p>\n<h3 id=\"tra-cu-d-liu-c-bit\"><span class=\"ez-toc-section\" id=\"Tra_cuu_du_lieu_dac_biet\"><\/span>Tra c\u1ee9u d\u1eef li\u1ec7u \u0111\u1eb7c bi\u1ec7t<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u00ed d\u1ee5 n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y trong <strong><code class=\"highlighter-rouge\">Sheet4<\/code><\/strong> c\u1ee7a b\u1ea3ng t\u00ednh ph\u00eda tr\u00ean. Ch\u00fang ta c\u00f3 2 c\u1ed9t H\u1ecd v\u00e0 T\u00ean, d\u1ef1a tr\u00ean 2 c\u1ed9t n\u00e0y ch\u00fang ta mu\u1ed1n t\u00ecm ra s\u1ed1 b\u00e1o danh c\u1ee7a m\u1ed9t ng\u01b0\u1eddi. \u1ede v\u00ed d\u1ee5 n\u00e0y, c\u00e1ch n\u1ed1i H\u1ecd v\u00e0 T\u00ean \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u1ea1o n\u00ean t\u00ean \u0111\u1ea7y \u0111\u1ee7, c\u00f3 th\u1ec3 n\u1ed1i H\u1ecd v\u00e0 T\u00ean b\u1edfi d\u1ea5u c\u00e1ch, d\u1ea5u n\u1ed1i, ho\u1eb7c d\u1ea5u ph\u1ea9y c\u1ed9ng th\u00eam d\u1ea5u c\u00e1ch, c\u00e1c c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng cho t\u1eebng tr\u01b0\u1eddng h\u1ee3p \u0111\u00f3 l\u00e0 (l\u01b0u \u00fd, c\u00f4ng th\u1ee9c m\u1ea3ng, nh\u1ea5n <strong><code class=\"highlighter-rouge\">CTRL<\/code><\/strong> + <strong><code class=\"highlighter-rouge\">SHIFT<\/code><\/strong> + <strong><code class=\"highlighter-rouge\">ENTER<\/code><\/strong>\u0111\u1ec3 nh\u1eadp):<\/p>\n<ul>\n<li><code class=\"highlighter-rouge\">=VLOOKUP(A7,CHOOSE({1,2},$A$2:$A$4&amp;\" \"&amp;$B$2:$B$4,$C$2:$C$4),2,0)<\/code><\/li>\n<li><code class=\"highlighter-rouge\">=VLOOKUP(A8,CHOOSE({1,2},$A$2:$A$4&amp;\"-\"&amp;$B$2:$B$4,$C$2:$C$4),2,0)<\/code><\/li>\n<li><code class=\"highlighter-rouge\">=VLOOKUP(A9,CHOOSE({1,2},$A$2:$A$4&amp;\", \"&amp;$B$2:$B$4,$C$2:$C$4),2,0)<\/code><\/li>\n<\/ul>\n<p class=\"post-img\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2015\/11\/2015-11-11-excel-su-dung-vlookup-nhieu-dieu-kien-06.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32274\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2015-11-11-excel-su-dung-vlookup-nhieu-dieu-kien-06.png\" alt=\"Excel s\u1eed d\u1ee5ng vlookup nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" width=\"1440\" height=\"450\" title=\"2015-11-11-excel-su-dung-vlookup-nhieu-dieu-kien-06\"><\/a><\/p>\n<h4 id=\"kt-lun\"><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Nh\u01b0 v\u1eady, hi v\u1ecdng qua b\u00e0i n\u00e0y c\u00e1c b\u1ea1n \u0111\u00e3 bi\u1ebft th\u00eam m\u1ed9t c\u00e1ch s\u1eed d\u1ee5ng <strong>h\u00e0m vlookup c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/strong> \u0111\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng linh ho\u1ea1t h\u01a1n. H\u00e3y \u0111\u1eebng qu\u00ean download t\u00e0i li\u1ec7u k\u00e8m theo video v\u00e0 b\u00e0i vi\u1ebft \u0111\u1ec3 th\u1ef1c h\u00e0nh m\u1ed9t c\u00e1ch thu\u1eadn ti\u1ec7n nh\u1ea5t!<\/p>\n<p>Nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ea1n \u0111ang xem c\u00f3 trong\u00a0kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-tu-co-ban-toi-nang-cao-danh-cho-dan-van-phong-2010-20132016\"><em><strong>EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/strong><\/em><\/a> c\u1ee7a H\u1ecdc Excel Online.\u00a0Trong kh\u00f3a h\u1ecdc n\u00e0y b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5: conditional formatting, data validation, pivot table\u2026 \u0111\u1ec3 \u1ee9ng d\u1ee5ng v\u00e0o trong c\u00f4ng vi\u1ec7c. Ngo\u00e0i ra b\u1ea1n c\u00f2n bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m trong excel, t\u1eeb c\u00e1c h\u00e0m c\u01a1 b\u1ea3n cho t\u1edbi c\u00e1c h\u00e0m n\u00e2ng cao, ph\u1ee9c t\u1ea1p. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc.<\/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-143.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1955,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1954","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\/1954","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=1954"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1954\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1955"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1954"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1954"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1954"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}