{"id":5956,"date":"2024-12-21T11:25:15","date_gmt":"2024-12-21T11:25:15","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/xep-hang-theo-dieu-kien-trong-excel-phan-3\/"},"modified":"2024-12-21T11:25:15","modified_gmt":"2024-12-21T11:25:15","slug":"xep-hang-theo-dieu-kien-trong-excel-phan-3","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/xep-hang-theo-dieu-kien-trong-excel-phan-3\/","title":{"rendered":"X\u1ebfp h\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n trong excel \u2013 Ph\u1ea7n 3"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><a href=\"http:\/\/blog.ezworkapp.com\/xep-hang-theo-dieu-kien-trong-excel-phan-1.html\">Ph\u1ea7n 1:\u00a0Ph\u00e2n bi\u1ec7t c\u00e1c h\u00e0m x\u1ebfp h\u1ea1ng RANK \/ RANK.AVG \/ RANK.EQ<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/xep-hang-theo-dieu-kien-trong-excel-phan-2.html\">Ph\u1ea7n 2:\u00a0x\u1ebfp h\u1ea1ng theo m\u1ed9t \u0111i\u1ec1u ki\u1ec7n<\/a><\/p>\n<p>Sau khi hi\u1ec3u c\u00e1ch x\u1ebfp h\u1ea1ng theo m\u1ed9t\u00a0\u0111i\u1ec1u ki\u1ec7n, ch\u00fang ta c\u00f3 th\u1ec3\u00a0\u00e1p d\u1ee5ng c\u00e1ch\u00a0\u0111\u00f3 cho nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n.<\/p>\n<p>V\u1edbi tr\u01b0\u1eddng h\u1ee3p nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n, ch\u00fang ta c\u1ea7n quan t\u00e2m t\u1edbi 2 ti\u00eau ch\u00ed:<\/p>\n<ul>\n<li>Ti\u00eau ch\u00ed 1: Th\u1ee9 t\u1ef1\u00a0\u01b0u ti\u00ean c\u1ee7a c\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n:\u00a0\u0111i\u1ec1u ki\u1ec7n n\u00e0o x\u00e9t tr\u01b0\u1edbc,\u00a0\u0111i\u1ec1u ki\u1ec7n n\u00e0o x\u00e9t sau<\/li>\n<li>Ti\u00eau ch\u00ed 2: C\u00f4ng th\u1ee9c x\u00e9t h\u1ea1ng c\u1ee7a c\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n ti\u1ebfp theo s\u1ebd ph\u1ee5 thu\u1ed9c v\u00e0o th\u1ee9 h\u1ea1ng c\u1ee7a\u00a0\u0111i\u1ec1u ki\u1ec7n tr\u01b0\u1edbc\u00a0\u0111\u00f3<\/li>\n<\/ul>\n<p><strong>Y\u00eau c\u1ea7u c\u1ee7a b\u00e0i t\u1eadp v\u00ed d\u1ee5 cho ph\u1ea7n x\u1ebfp h\u1ea1ng theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n nh\u01b0 sau:<\/strong><\/p>\n<p>X\u1ebfp h\u1ea1ng theo\u00a0\u0111i\u1ec3m trung b\u00ecnh, n\u1ebfu\u00a0\u0111\u1ed3ng h\u1ea1ng th\u00ec\u00a0\u01b0u ti\u00ean x\u00e9t theo th\u1ee9 t\u1ef1 c\u00e1c m\u00f4n: To\u00e1n &gt; L\u00fd &gt; H\u00f3a<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-11143 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic08-4.png\" width=\"898\" height=\"350\" title=\"pic08-4\"><\/p>\n<blockquote>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">H\u01b0\u1edbng d\u1eabn h\u1ecdc Excel c\u01a1 b\u1ea3n<\/a><\/p>\n<\/blockquote>\n<p>Ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y v\u1edbi tr\u01b0\u1eddng h\u1ee3p d\u00f2ng 7 (D\u01b0\u01a1ng Qu\u1ed1c\u00a0\u0110\u1ea1t) v\u00e0 d\u00f2ng 10 (L\u00ea B\u00e1 Long) khi x\u00e9t theo 1\u00a0\u0111i\u1ec1u ki\u1ec7n th\u00ec v\u1eabn\u00a0\u0111\u1ed3ng x\u1ebfp h\u1ea1ng 6. Do\u00a0\u0111\u00f3 c\u1ea7n x\u00e9t th\u00eam\u00a0\u0111i\u1ec1u ki\u1ec7n\u00a0\u01b0u ti\u00ean kh\u00e1c.<\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-533.gif\" title=\"ex101_92019-nho-533\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-225.gif\" title=\"vba101_92019-nho-225\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-533.gif\" title=\"ex101_92019-nho-533\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Ch\u00fang ta c\u00f9ng ph\u00e2n t\u00edch c\u1ee5 th\u1ec3 c\u00e1ch l\u00e0m nh\u00e9:<\/p>\n<p><em><strong>B\u01b0\u1edbc 1<\/strong><\/em>: X\u00e9t\u00a0\u01b0u ti\u00ean m\u00f4n to\u00e1n khi\u00a0\u0111i\u1ec3m trung b\u00ecnh b\u1eb1ng nhau (gi\u1ed1ng\u00a0\u1edf Ph\u1ea7n 2)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-11144 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic09-4.png\" width=\"898\" height=\"406\" title=\"pic09-4\"><\/p>\n<p><strong>C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng:<\/strong><\/p>\n<blockquote>\n<p>=IF(COUNTIF($E$4:$E$13,E4)&gt;1,RANK.EQ(B4,$B$4:$B$13,1),0)<\/p>\n<\/blockquote>\n<p>N\u1ed9i dung c\u00f4ng th\u1ee9c n\u00e0y\u00a0\u0111\u00e3 ph\u00e2n t\u00edch trong ph\u1ea7n 2, m\u1eddi c\u00e1c b\u1ea1n xem l\u1ea1i\u00a0\u0111\u1ec3 hi\u1ec3u.<\/p>\n<p><em><strong>B\u01b0\u1edbc 2<\/strong><\/em>: X\u00e9t\u00a0\u01b0u ti\u00ean m\u00f4n L\u00fd khi x\u1ebfp h\u1ea1ng \u0111i\u1ec3m m\u00f4n To\u00e1n b\u1eb1ng nhau\u00a0(\u0110\u1ed3ng \u0111i\u1ec3m m\u00f4n To\u00e1n -&gt;theo th\u1ee9 t\u1ef1\u00a0\u01b0u ti\u00ean, c\u00f3 t\u00ednh ph\u1ee5 thu\u1ed9c v\u00e0o th\u1ee9 t\u1ef1 tr\u01b0\u1edbc \u0111\u00f3)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-11145 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic10-3.png\" width=\"899\" height=\"409\" title=\"pic10-3\"><\/p>\n<p><strong>C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng:<\/strong><\/p>\n<blockquote>\n<p>=IF(AND(L4&gt;0,COUNTIF(L$4:L$13,L4)&gt;1),RANK.EQ(C4,C$4:C$13,1),0)<\/p>\n<\/blockquote>\n<p><em>Ph\u00e2n t\u00edch c\u00f4ng th\u1ee9c:<\/em><\/p>\n<ul>\n<li>L4&gt;0:\u00a0 Ch\u1ec9 x\u00e9t khi x\u1ebfp h\u1ea1ng \u01b0u ti\u00ean m\u00f4n To\u00e1n kh\u00e1c 0 (t\u1ee9c l\u00e0\u00a0\u0111i\u1ec3m trung b\u00ecnh ban\u00a0\u0111\u1ea7u ph\u1ea3i tr\u00f9ng nhau)<\/li>\n<li>COUNTIF(L$4:L$13,L4)&gt;1 : Ch\u1ec9 x\u00e9t khi x\u1ebfp h\u1ea1ng\u00a0\u01b0u ti\u00ean m\u00f4n To\u00e1n\u00a0\u0111\u1ed3ng h\u1ea1ng (\u0111\u1ebfm k\u1ebft qu\u1ea3 x\u1ebfp h\u1ea1ng\u00a0\u01b0u ti\u00ean m\u00f4n To\u00e1n n\u1ebfu xu\u1ea5t hi\u1ec7n nhi\u1ec1u h\u01a1n 1 th\u00ec t\u1ee9c l\u00e0 c\u00f3\u00a0\u0111\u1ed3ng h\u1ea1ng)<\/li>\n<li>AND(L4&gt;0,COUNTIF(L$4:L$13,L4)&gt;1): X\u00e9t th\u1ecfa m\u00e3n\u00a0\u0111\u1ed3ng th\u1eddi c\u1ea3 2\u00a0\u0111i\u1ec1u ki\u1ec7n tr\u00ean th\u00ec m\u1edbi\u00a0\u0111\u01b0\u1ee3c t\u00ednh\u00a0\u01b0u ti\u00ean m\u00f4n L\u00fd<\/li>\n<li>RANK.EQ(C4,C$4:C$13,1): X\u1ebfp h\u1ea1ng\u00a0\u0111i\u1ec3m m\u00f4n L\u00fd theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n \u0111\u1ec3 t\u00ednh\u00a0\u0111i\u1ec3m \u01b0u ti\u00ean<\/li>\n<\/ul>\n<blockquote>\n<p>Xem ngay:\u00a0H\u1ecdc Excel n\u00e2ng cao \u1edf \u0111\u00e2u?<\/p>\n<\/blockquote>\n<p><em><strong>B\u01b0\u1edbc 3<\/strong><\/em>: X\u00e9t\u00a0\u01b0u ti\u00ean m\u00f4n\u00a0H\u00f3a\u00a0khi x\u1ebfp h\u1ea1ng\u00a0\u0111i\u1ec3m m\u00f4n To\u00e1n v\u00e0 m\u00f4n L\u00fd b\u1eb1ng nhau (\u0111\u1ed3ng\u00a0\u0111i\u1ec3m c\u1ea3 m\u00f4n To\u00e1n v\u00e0 m\u00f4n L\u00fd)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-11146 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic11-2.png\" width=\"902\" height=\"409\" title=\"pic11-2\"><\/p>\n<p><strong>C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng:<\/strong><\/p>\n<blockquote>\n<p>=IF(AND(M4&gt;0,COUNTIF(M$4:M$13,M4)&gt;1),RANK.EQ(D4,D$4:D$13,1),0)<\/p>\n<\/blockquote>\n<p><em>Ph\u00e2n t\u00edch c\u00f4ng th\u1ee9c:<\/em><\/p>\n<ul>\n<li>M4&gt;0: Ch\u1ec9 x\u00e9t khi x\u1ebfp h\u1ea1ng\u00a0\u01b0u ti\u00ean m\u00f4n\u00a0L\u00fd\u00a0kh\u00e1c 0 (t\u1ee9c l\u00e0 \u00e3\u00e3 bao g\u1ed3m tr\u00f9ng c\u1ee7a m\u00f4n To\u00e1n r\u1ed3i, gi\u1edd x\u00e9t th\u00eam m\u00f4n L\u00fd c\u00f3 th\u1ee9 h\u1ea1ng tr\u00f9ng)<\/li>\n<li>COUNTIF(M$4:M$13,M4)&gt;1: Ch\u1ec9 x\u00e9t khi x\u1ebfp h\u1ea1ng\u00a0\u01b0u ti\u00ean m\u00f4n\u00a0L\u00fd\u00a0\u0111\u1ed3ng h\u1ea1ng (\u0111\u1ebfm k\u1ebft qu\u1ea3 x\u1ebfp h\u1ea1ng\u00a0\u01b0u ti\u00ean m\u00f4n\u00a0L\u00fd\u00a0n\u1ebfu xu\u1ea5t hi\u1ec7n nhi\u1ec1u h\u01a1n 1 th\u00ec t\u1ee9c l\u00e0 c\u00f3\u00a0\u0111\u1ed3ng h\u1ea1ng)<\/li>\n<li>AND(M4&gt;0,COUNTIF(M$4:M$13,M4)&gt;1): X\u00e9t th\u1ecfa m\u00e3n\u00a0\u0111\u1ed3ng th\u1eddi c\u1ea3 2\u00a0\u0111i\u1ec1u ki\u1ec7n tr\u00ean th\u00ec m\u1edbi\u00a0\u0111\u01b0\u1ee3c t\u00ednh\u00a0\u01b0u ti\u00ean m\u00f4n\u00a0H\u00f3a<\/li>\n<li>RANK.EQ(D4,D$4:D$13,1),0):\u00a0 X\u1ebfp h\u1ea1ng\u00a0\u0111i\u1ec3m m\u00f4n\u00a0H\u00f3a\u00a0theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n\u00a0\u0111\u1ec3 t\u00ednh\u00a0\u0111i\u1ec3m\u00a0\u01b0u ti\u00ean<\/li>\n<\/ul>\n<p><em><strong>B\u01b0\u1edbc 4<\/strong><\/em>: T\u00ednh\u00a0\u0111i\u1ec3m trung b\u00ecnh m\u1edbi d\u1ef1a tr\u00ean\u00a0\u0111i\u1ec3m\u00a0\u01b0u ti\u00ean c\u1ee7a c\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-11147 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic12-2.png\" width=\"901\" height=\"409\" title=\"pic12-2\"><\/p>\n<p>\u1ede b\u01b0\u1edbc n\u00e0y, c\u00e1c b\u1ea1n l\u01b0u\u00a0\u00fd l\u00e0 th\u1ee9 t\u1ef1\u00a0\u01b0u ti\u00ean c\u1ee7a c\u00e1c m\u00f4n s\u1ebd\u00a0\u0111\u01b0\u1ee3c c\u1ed9ng v\u00e0o\u00a0\u0111i\u1ec3m trung b\u00ecnh, do\u00a0\u0111\u00f3 m\u1ed7i c\u1ea5p b\u1eadc\u00a0\u01b0u ti\u00ean c\u0169ng\u00a0\u0111\u1ed3ng th\u1eddi ph\u1ea3i x\u00e9t gi\u1ea3m\u00a0\u0111i 10 l\u1ea7n\u00a0\u0111\u1ec3 nh\u00ecn v\u00e0o k\u1ebft qu\u1ea3 ch\u00fang ta c\u00f3 th\u1ec3 ph\u00e2n bi\u1ec7t ngay b\u1eb1ng m\u1eaft th\u01b0\u1eddng\u00a0\u0111\u01b0\u1ee3c =&gt; Khi\u00a0\u0111\u00f3 ki\u1ec3m tra l\u1ea1i c\u0169ng d\u1ec5 h\u01a1n.<\/p>\n<p><em><strong>B\u01b0\u1edbc 5<\/strong><\/em>: X\u1ebfp h\u1ea1ng d\u1ef1a tr\u00ean\u00a0\u0111i\u1ec3m trung b\u00ecnh m\u1edbi<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-11148 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic13-1.png\" width=\"903\" height=\"412\" title=\"pic13-1\"><\/p>\n<p>\u1ede b\u01b0\u1edbc n\u00e0y, ch\u00fang ta x\u1ebfp h\u1ea1ng theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n (\u00a0Order = 0)<\/p>\n<p>Nh\u01b0 v\u1eady b\u1eb1ng vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c c\u1ed9t ph\u1ee5 v\u00e0 x\u1ebfp h\u1ea1ng th\u1ee9 t\u1ef1\u00a0\u01b0u ti\u00ean, ch\u00fang ta c\u00f3 th\u1ec3 ho\u00e0n th\u00e0nh\u00a0\u0111\u01b0\u1ee3c vi\u1ec7c x\u1ebfp h\u1ea1ng theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng v\u00e0 d\u1ec5 hi\u1ec3u.<\/p>\n<p>Hi\u1ec3u v\u00e0 s\u1eed d\u1ee5ng t\u1eebng h\u00e0m trong Excel th\u00f4i l\u00e0 ch\u01b0a \u0111\u1ee7. \u0110\u1ec3 t\u1eadn d\u1ee5ng t\u1ed1i \u0111a t\u00ednh n\u0103ng c\u1ee7a Excel, b\u1ea1n c\u1ea7n k\u1ebft h\u1ee3p c\u00e1c h\u00e0m, c\u00f4ng c\u1ee5 v\u00e0 c\u00e1c t\u00ednh n\u0103ng \u01b0u vi\u1ec7t kh\u00e1c.\u00a0To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\/excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\" target=\"_blank\" rel=\"noopener\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. 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. Chi ti\u1ebft xem t\u1ea1i: <a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">HocExcel.Online<\/a><\/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<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-533.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5957,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5956","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\/5956","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=5956"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5956\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5957"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5956"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5956"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5956"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}