{"id":505842,"date":"2025-11-16T09:45:16","date_gmt":"2025-11-16T02:45:16","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=505842"},"modified":"2025-11-16T09:45:16","modified_gmt":"2025-11-16T02:45:16","slug":"bai-tap-excel-co-ban","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/bai-tap-excel-co-ban\/","title":{"rendered":"20+ b\u00e0i t\u1eadp Excel c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao chi ti\u1ebft [C\u00d3 L\u1edcI GI\u1ea2I]"},"content":{"rendered":"<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Excel l\u00e0 c\u00f4ng c\u1ee5 kh\u00f4ng th\u1ec3 thi\u1ebfu trong m\u1ecdi l\u0129nh v\u1ef1c \u2014 t\u1eeb k\u1ebf to\u00e1n, h\u00e0nh ch\u00ednh, nh\u00e2n s\u1ef1 \u0111\u1ebfn qu\u1ea3n tr\u1ecb d\u1eef li\u1ec7u. Tuy nhi\u00ean, nhi\u1ec1u ng\u01b0\u1eddi h\u1ecdc Excel ch\u1ec9 d\u1eebng l\u1ea1i \u1edf m\u1ee9c s\u1eed d\u1ee5ng v\u00e0i c\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n m\u00e0 ch\u01b0a bi\u1ebft c\u00e1ch v\u1eadn d\u1ee5ng ch\u00fang trong th\u1ef1c t\u1ebf. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n <\/span><b>h\u1ecdc v\u00e0 th\u1ef1c h\u00e0nh Excel th\u00f4ng qua h\u01a1n 20 b\u00e0i t\u1eadp c\u00f3 l\u1eddi gi\u1ea3i chi ti\u1ebft<\/b><span style=\"font-weight: 400;\">, \u0111i t\u1eeb <\/span><b>c\u00e1c h\u00e0m c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao v\u00e0 \u1ee9ng d\u1ee5ng th\u1ef1c t\u1ebf trong v\u0103n ph\u00f2ng<\/b><span style=\"font-weight: 400;\">. B\u1ea1n c\u00f3 th\u1ec3 m\u1edf Excel, t\u1ea1o file m\u1edbi v\u00e0 l\u00e0m theo t\u1eebng b\u01b0\u1edbc \u0111\u1ec3 hi\u1ec3u s\u00e2u v\u00e0 nh\u1edb l\u00e2u.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>B\u00e0i t\u1eadp Excel c\u01a1 b\u1ea3n cho ng\u01b0\u1eddi m\u1edbi<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u00f3m b\u00e0i t\u1eadp \u0111\u1ea7u ti\u00ean gi\u00fap b\u1ea1n l\u00e0m quen v\u1edbi nh\u1eefng h\u00e0m c\u01a1 b\u1ea3n nh\u1ea5t: <\/span><b>SUM, AVERAGE, IF, COUNT, LEFT, RIGHT, VLOOKUP,\u2026 <\/b><span style=\"font-weight: 400;\">M\u1ed7i b\u00e0i \u0111\u1ec1u c\u00f3 <\/span><b>\u0111\u1ec1 b\u00e0i, b\u1ea3ng d\u1eef li\u1ec7u m\u1eabu, h\u01b0\u1edbng d\u1eabn th\u1ef1c hi\u1ec7n v\u00e0 l\u1eddi gi\u1ea3i<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>B\u00e0i t\u1eadp Excel v\u1ec1 c\u00e1c h\u00e0m to\u00e1n h\u1ecdc<\/b><\/h3>\n<p style=\"text-align: justify;\"><b>M\u1ee5c ti\u00eau h\u1ecdc: <\/b><span style=\"font-weight: 400;\">Gi\u00fap b\u1ea1n l\u00e0m quen v\u1edbi c\u00e1c h\u00e0m t\u00ednh to\u00e1n c\u01a1 b\u1ea3n nh\u01b0 <\/span><span style=\"font-weight: 400;\">SUM<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">AVERAGE<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">MAX<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">MIN<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">ROUND<\/span><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p style=\"text-align: justify;\"><b>V\u00ed d\u1ee5: <\/b><span style=\"font-weight: 400;\">T\u1ea1o b\u1ea3ng \u0111i\u1ec3m sau:<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><b>H\u1ecd t\u00ean<\/b><\/td>\n<td><b>To\u00e1n<\/b><\/td>\n<td><b>V\u0103n<\/b><\/td>\n<td><b>Anh<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">An<\/span><\/td>\n<td><span style=\"font-weight: 400;\">8<\/span><\/td>\n<td><span style=\"font-weight: 400;\">7<\/span><\/td>\n<td><span style=\"font-weight: 400;\">6<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">B\u00ecnh<\/span><\/td>\n<td><span style=\"font-weight: 400;\">9<\/span><\/td>\n<td><span style=\"font-weight: 400;\">8<\/span><\/td>\n<td><span style=\"font-weight: 400;\">7<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Chi<\/span><\/td>\n<td><span style=\"font-weight: 400;\">6<\/span><\/td>\n<td><span style=\"font-weight: 400;\">7<\/span><\/td>\n<td><span style=\"font-weight: 400;\">8<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify;\"><b>Y\u00eau c\u1ea7u:<\/b><\/p>\n<ol style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ednh t\u1ed5ng \u0111i\u1ec3m 3 m\u00f4n<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ednh \u0111i\u1ec3m trung b\u00ecnh<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">L\u00e0m tr\u00f2n \u0111i\u1ec3m trung b\u00ecnh \u0111\u1ebfn 1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ednh hi\u1ec7u gi\u1eefa \u0111i\u1ec3m cao nh\u1ea5t v\u00e0 th\u1ea5p nh\u1ea5t<\/span><\/li>\n<\/ol>\n<p style=\"text-align: justify;\"><b>H\u01b0\u1edbng d\u1eabn &amp; l\u1eddi gi\u1ea3i:<\/b><\/p>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc 1:<\/b><span style=\"font-weight: 400;\"> Nh\u1eadp d\u1eef li\u1ec7u v\u00e0o Excel t\u1eeb A1:D4<\/span><\/p>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc 2:<\/b><span style=\"font-weight: 400;\"> \u1ede c\u1ed9t E, nh\u1eadp c\u00f4ng th\u1ee9c:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u1ed5ng \u0111i\u1ec3m: <\/span><span style=\"font-weight: 400;\">=SUM(B2:D2)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Trung b\u00ecnh: <\/span><span style=\"font-weight: 400;\">=AVERAGE(B2:D2)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">L\u00e0m tr\u00f2n: <\/span><span style=\"font-weight: 400;\">=ROUND(AVERAGE(B2:D2),1)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Hi\u1ec7u \u0111i\u1ec3m: <\/span><span style=\"font-weight: 400;\">=MAX(B2:D2)-MIN(B2:D2)<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><b>K\u1ebft qu\u1ea3:<\/b><span style=\"font-weight: 400;\"> B\u1ea1n s\u1ebd hi\u1ec3u c\u00e1ch k\u1ebft h\u1ee3p nhi\u1ec1u h\u00e0m \u0111\u1ec3 x\u1eed l\u00fd s\u1ed1 li\u1ec7u h\u1ecdc t\u1eadp, doanh thu, chi ph\u00ed,&#8230;<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-01.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-01-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-01-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-505844 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-01.jpg\" alt=\"bai-tap-excel-co-ban-01\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-01.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-01-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-01-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><b>B\u00e0i t\u1eadp Excel c\u01a1 b\u1ea3n v\u1ec1 c\u00e1c h\u00e0m th\u1ed1ng k\u00ea<\/b><\/h3>\n<p style=\"text-align: justify;\"><b>M\u1ee5c ti\u00eau h\u1ecdc: <\/b><span style=\"font-weight: 400;\">N\u1eafm v\u1eefng c\u00e1c h\u00e0m th\u1ed1ng k\u00ea c\u01a1 b\u1ea3n \u2014 <\/span><span style=\"font-weight: 400;\">SUM<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">AVERAGE<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">COUNT<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">COUNTIF<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">MAX<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">MIN<\/span><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p style=\"text-align: justify;\"><b>B\u00e0i t\u1eadp:<\/b><\/p>\n<table>\n<tbody>\n<tr>\n<td><b>S\u1ea3n ph\u1ea9m<\/b><\/td>\n<td><b>Doanh thu<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">A<\/span><\/td>\n<td><span style=\"font-weight: 400;\">5,000,000<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">B<\/span><\/td>\n<td><span style=\"font-weight: 400;\">7,500,000<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">C<\/span><\/td>\n<td><span style=\"font-weight: 400;\">3,000,000<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">D<\/span><\/td>\n<td><span style=\"font-weight: 400;\">10,000,000<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify;\"><b>Y\u00eau c\u1ea7u:<\/b><\/p>\n<ol style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ednh t\u1ed5ng doanh thu<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ednh doanh thu trung b\u00ecnh<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u1ebfm s\u1ed1 s\u1ea3n ph\u1ea9m c\u00f3 doanh thu tr\u00ean 5 tri\u1ec7u<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ecm doanh thu cao nh\u1ea5t, th\u1ea5p nh\u1ea5t<\/span><\/li>\n<\/ol>\n<p style=\"text-align: justify;\"><b>L\u1eddi gi\u1ea3i:<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u1ed5ng doanh thu: <\/span><span style=\"font-weight: 400;\">=SUM(B2:B5)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Trung b\u00ecnh: <\/span><span style=\"font-weight: 400;\">=AVERAGE(B2:B5)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u1ebfm &gt;5 tri\u1ec7u: <\/span><span style=\"font-weight: 400;\">=COUNTIF(B2:B5,&#8221;&gt;5000000&#8243;)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Doanh thu cao nh\u1ea5t: <\/span><span style=\"font-weight: 400;\">=MAX(B2:B5)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Doanh thu th\u1ea5p nh\u1ea5t: <\/span><span style=\"font-weight: 400;\">=MIN(B2:B5)<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><b>Gi\u1ea3i th\u00edch:<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m <\/span><span style=\"font-weight: 400;\">COUNTIF<\/span><span style=\"font-weight: 400;\"> \u0111\u1ebfm theo \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u00e1c h\u00e0m <\/span><span style=\"font-weight: 400;\">MAX<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">MIN<\/span><span style=\"font-weight: 400;\"> gi\u00fap b\u1ea1n ph\u00e2n t\u00edch d\u1eef li\u1ec7u nhanh ch\u00f3ng.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-02.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-02-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-02-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-505845 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-02.jpg\" alt=\"bai-tap-excel-co-ban-02\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-02.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-02-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-02-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><b>B\u00e0i t\u1eadp Excel c\u01a1 b\u1ea3n v\u1ec1 c\u00e1c h\u00e0m th\u1eddi gian, ng\u00e0y th\u00e1ng<\/b><\/h3>\n<p style=\"text-align: justify;\"><b>M\u1ee5c ti\u00eau h\u1ecdc: <\/b><span style=\"font-weight: 400;\">Bi\u1ebft c\u00e1ch d\u00f9ng c\u00e1c h\u00e0m <\/span><b>TODAY, NOW, DATEDIF, YEAR, MONTH, DAY<\/b><span style=\"font-weight: 400;\"> \u0111\u1ec3 x\u1eed l\u00fd th\u1eddi gian.<\/span><\/p>\n<h4 style=\"text-align: justify;\"><b>B\u00e0i t\u1eadp:<\/b><\/h4>\n<table>\n<tbody>\n<tr>\n<td><b>H\u1ecd t\u00ean<\/b><\/td>\n<td><b>Ng\u00e0y b\u1eaft \u0111\u1ea7u<\/b><\/td>\n<td><b>Ng\u00e0y k\u1ebft th\u00fac<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Lan<\/span><\/td>\n<td><span style=\"font-weight: 400;\">01\/03\/2024<\/span><\/td>\n<td><span style=\"font-weight: 400;\">10\/03\/2024<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">H\u00f9ng<\/span><\/td>\n<td><span style=\"font-weight: 400;\">05\/03\/2024<\/span><\/td>\n<td><span style=\"font-weight: 400;\">20\/03\/2024<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify;\"><b>Y\u00eau c\u1ea7u:<\/b><\/p>\n<ol style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ednh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c th\u1ef1c t\u1ebf<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ednh s\u1ed1 th\u00e1ng gi\u1eefa hai m\u1ed1c th\u1eddi gian<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u1ef1 \u0111\u1ed9ng hi\u1ec3n th\u1ecb ng\u00e0y hi\u1ec7n t\u1ea1i<\/span><\/li>\n<\/ol>\n<p style=\"text-align: justify;\"><b>L\u1eddi gi\u1ea3i:<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">S\u1ed1 ng\u00e0y: <\/span><span style=\"font-weight: 400;\">=D2-C2<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">S\u1ed1 th\u00e1ng: <\/span><span style=\"font-weight: 400;\">=DATEDIF(C2,D2,&#8221;m&#8221;)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ng\u00e0y hi\u1ec7n t\u1ea1i: <\/span><span style=\"font-weight: 400;\">=TODAY()<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><b>Gi\u1ea3i th\u00edch:<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">DATEDIF<\/span><span style=\"font-weight: 400;\"> l\u00e0 h\u00e0m \u201c\u1ea9n\u201d trong Excel, r\u1ea5t h\u1eefu \u00edch cho k\u1ebf to\u00e1n \u2013 nh\u00e2n s\u1ef1.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">TODAY()<\/span><span style=\"font-weight: 400;\"> c\u1eadp nh\u1eadt t\u1ef1 \u0111\u1ed9ng, kh\u00f4ng c\u1ea7n nh\u1eadp th\u1ee7 c\u00f4ng.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-03.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-03-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-03-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-505846 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-03.jpg\" alt=\"bai-tap-excel-co-ban-03\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-03.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-03-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-03-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><b>B\u00e0i t\u1eadp Excel c\u01a1 b\u1ea3n v\u1ec1 c\u00e1c h\u00e0m x\u1eed l\u00fd chu\u1ed7i<\/b><\/h3>\n<p style=\"text-align: justify;\"><b>M\u1ee5c ti\u00eau h\u1ecdc: <\/b><span style=\"font-weight: 400;\">Hi\u1ec3u v\u00e0 \u00e1p d\u1ee5ng c\u00e1c h\u00e0m: <\/span><span style=\"font-weight: 400;\">LEFT<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">RIGHT<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">MID<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">LEN<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">PROPER<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">TRIM<\/span><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p style=\"text-align: justify;\"><b>B\u00e0i t\u1eadp:<\/b><\/p>\n<table>\n<tbody>\n<tr>\n<td><b>H\u1ecd v\u00e0 t\u00ean \u0111\u1ea7y \u0111\u1ee7<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">nguy\u1ec5n v\u0103n a<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">l\u00ea th\u1ecb b<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify;\"><b>Y\u00eau c\u1ea7u:<\/b><\/p>\n<ol style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Chu\u1ea9n h\u00f3a h\u1ecd t\u00ean vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">X\u00f3a kho\u1ea3ng tr\u1eafng th\u1eeba<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00e1ch h\u1ecd v\u00e0 t\u00ean ri\u00eang<\/span><\/li>\n<\/ol>\n<p style=\"text-align: justify;\"><b>L\u1eddi gi\u1ea3i:<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Vi\u1ebft hoa chu\u1ea9n: <\/span><span style=\"font-weight: 400;\">=PROPER(TRIM(A2))<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u1ecd: <\/span><span style=\"font-weight: 400;\">=LEFT(A2,FIND(&#8221; &#8220;,A2)-1)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ean:<\/span><span style=\"font-weight: 400;\">=RIGHT(A2,LEN(A2)-FIND(&#8220;*&#8221;,SUBSTITUTE(A2,&#8221;&#8221;,&#8221;*&#8221;,LEN(A2)-LEN(SUBSTITUTE(A2,&#8221; &#8220;,&#8221;&#8221;)))))<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><b>Gi\u1ea3i th\u00edch:<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">TRIM<\/span><span style=\"font-weight: 400;\"> x\u00f3a kho\u1ea3ng tr\u1eafng th\u1eeba<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">PROPER<\/span><span style=\"font-weight: 400;\"> vi\u1ebft hoa ch\u1eef \u0111\u1ea7u ti\u00ean<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m k\u1ebft h\u1ee3p ph\u1ee9c t\u1ea1p d\u00f9ng \u0111\u1ec3 t\u00e1ch ph\u1ea7n \u201ct\u00ean\u201d cu\u1ed1i c\u00f9ng, r\u1ea5t th\u1ef1c t\u1ebf khi x\u1eed l\u00fd danh s\u00e1ch nh\u00e2n vi\u00ean ho\u1eb7c kh\u00e1ch h\u00e0ng.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-04.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-04-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-04-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-505847 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-04.jpg\" alt=\"bai-tap-excel-co-ban-04\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-04.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-04-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-04-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><b>B\u00e0i t\u1eadp Excel v\u1ec1 c\u00e1c h\u00e0m d\u00f2 t\u00ecm<\/b><\/h3>\n<p style=\"text-align: justify;\"><b>M\u1ee5c ti\u00eau h\u1ecdc: <\/b><span style=\"font-weight: 400;\">Hi\u1ec3u r\u00f5 c\u00e1ch d\u00f9ng <\/span><span style=\"font-weight: 400;\">VLOOKUP<\/span><span style=\"font-weight: 400;\"> v\u00e0 <\/span><span style=\"font-weight: 400;\">HLOOKUP<\/span><span style=\"font-weight: 400;\"> \u0111\u1ec3 tra c\u1ee9u d\u1eef li\u1ec7u.<\/span><\/p>\n<p style=\"text-align: justify;\"><b>B\u00e0i t\u1eadp excel c\u01a1 b\u1ea3n:<\/b><\/p>\n<table>\n<tbody>\n<tr>\n<td><b>M\u00e3 HS<\/b><\/td>\n<td><b>H\u1ecd t\u00ean<\/b><\/td>\n<td><b>\u0110i\u1ec3m<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">HS01<\/span><\/td>\n<td><span style=\"font-weight: 400;\">An<\/span><\/td>\n<td><span style=\"font-weight: 400;\">8<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">HS02<\/span><\/td>\n<td><span style=\"font-weight: 400;\">B\u00ecnh<\/span><\/td>\n<td><span style=\"font-weight: 400;\">9<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify;\"><b>Y\u00eau c\u1ea7u: <\/b><span style=\"font-weight: 400;\">Khi nh\u1eadp m\u00e3 h\u1ecdc sinh, Excel t\u1ef1 \u0111\u1ed9ng hi\u1ec3n th\u1ecb \u0111i\u1ec3m.<\/span><\/p>\n<p style=\"text-align: justify;\"><b>L\u1eddi gi\u1ea3i: <\/b><span style=\"font-weight: 400;\">Gi\u1ea3 s\u1eed \u00f4 nh\u1eadp m\u00e3 l\u00e0 <\/span><span style=\"font-weight: 400;\">E2<\/span><span style=\"font-weight: 400;\">: <\/span><span style=\"font-weight: 400;\">=VLOOKUP(E2,A2:C3,3,FALSE)<\/span><\/p>\n<p style=\"text-align: justify;\"><b>Gi\u1ea3i th\u00edch:<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">E2<\/span><span style=\"font-weight: 400;\">: \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n tra<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">A2:C3<\/span><span style=\"font-weight: 400;\">: v\u00f9ng d\u1eef li\u1ec7u<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">3<\/span><span style=\"font-weight: 400;\">: c\u1ed9t tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">FALSE<\/span><span style=\"font-weight: 400;\">: tra c\u1ee9u ch\u00ednh x\u00e1c.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">D\u00f9ng th\u01b0\u1eddng xuy\u00ean trong tra c\u1ee9u l\u01b0\u01a1ng, m\u00e3 s\u1ea3n ph\u1ea9m, th\u00f4ng tin nh\u00e2n s\u1ef1.<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-05.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-05-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-05-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-505848 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-05.jpg\" alt=\"bai-tap-excel-co-ban-05\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-05.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-05-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-05-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2 style=\"text-align: justify;\"><b>B\u00e0i t\u1eadp Excel n\u00e2ng cao \u0111\u1ec3 luy\u1ec7n t\u1eadp, n\u00e2ng c\u1ea5p k\u1ef9 n\u0103ng<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ti\u1ebfp n\u1ed1i n\u1ed9i dung c\u00e1c b\u00e0i t\u1eadp excel c\u01a1 b\u1ea3n, ph\u1ea7n n\u00e0y ph\u00f9 h\u1ee3p cho ng\u01b0\u1eddi \u0111\u00e3 n\u1eafm v\u1eefng h\u00e0m c\u01a1 b\u1ea3n, mu\u1ed1n r\u00e8n luy\u1ec7n k\u1ef9 n\u0103ng v\u1edbi c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p, k\u1ebft h\u1ee3p nhi\u1ec1u h\u00e0m ho\u1eb7c thao t\u00e1c d\u1eef li\u1ec7u l\u1edbn.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>B\u00e0i t\u1eadp 1: Ph\u00e2n lo\u1ea1i nh\u00e2n vi\u00ean theo hi\u1ec7u su\u1ea5t<\/b><\/h3>\n<table>\n<tbody>\n<tr>\n<td><b>H\u1ecd t\u00ean<\/b><\/td>\n<td><b>Doanh s\u1ed1<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Nam<\/span><\/td>\n<td><span style=\"font-weight: 400;\">15000000<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Hoa<\/span><\/td>\n<td><span style=\"font-weight: 400;\">9000000<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">T\u00f9ng<\/span><\/td>\n<td><span style=\"font-weight: 400;\">20000000<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify;\"><b>Y\u00eau c\u1ea7u:<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu doanh s\u1ed1 \u2265 15 tri\u1ec7u \u2192 \u201cXu\u1ea5t s\u1eafc\u201d<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u1eeb 10\u201315 tri\u1ec7u \u2192 \u201cKh\u00e1\u201d<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">D\u01b0\u1edbi 10 tri\u1ec7u \u2192 \u201cTrung b\u00ecnh\u201d<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><b>L\u1eddi gi\u1ea3i:<\/b><span style=\"font-weight: 400;\">=IF(B2&gt;=15000000,&#8221;Xu\u1ea5t s\u1eafc&#8221;,IF(B2&gt;=10000000,&#8221;Kh\u00e1&#8221;,&#8221;Trung b\u00ecnh&#8221;))<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u00e0i n\u00e0y gi\u00fap b\u1ea1n luy\u1ec7n <\/span><b>IF l\u1ed3ng nhau<\/b><span style=\"font-weight: 400;\">, d\u00f9ng nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong c\u00f9ng m\u1ed9t c\u00f4ng th\u1ee9c.<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-06.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-06-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-06-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-505849 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-06.jpg\" alt=\"bai-tap-excel-co-ban-06\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-06.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-06-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-06-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><b>B\u00e0i t\u1eadp excel c\u01a1 b\u1ea3n &#8211; n\u00e2ng cao 2: T\u00ednh hoa h\u1ed3ng b\u00e1n h\u00e0ng<\/b><\/h3>\n<table>\n<tbody>\n<tr>\n<td><b>Nh\u00e2n vi\u00ean<\/b><\/td>\n<td><b>Doanh s\u1ed1<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">A<\/span><\/td>\n<td><span style=\"font-weight: 400;\">5,000,000<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">B<\/span><\/td>\n<td><span style=\"font-weight: 400;\">15,000,000<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify;\"><b>Y\u00eau c\u1ea7u:<\/b><b><br \/>\n<\/b><span style=\"font-weight: 400;\"> T\u00ednh hoa h\u1ed3ng:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">D\u01b0\u1edbi 10 tri\u1ec7u: 3%<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u1eeb 10\u201320 tri\u1ec7u: 5%<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Tr\u00ean 20 tri\u1ec7u: 7%<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><b>L\u1eddi gi\u1ea3i: <\/b><span style=\"font-weight: 400;\">\u00a0<\/span><span style=\"font-weight: 400;\">=IF(B2&lt;10000000,B2*3%,IF(B2&lt;=20000000,B2*5%,B2*7%))<\/span><\/p>\n<p style=\"text-align: justify;\"><b>Gi\u1ea3i th\u00edch: <\/b><span style=\"font-weight: 400;\">H\u00e0m IF c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p to\u00e1n ngay trong bi\u1ec3u th\u1ee9c, c\u1ef1c k\u1ef3 h\u1eefu d\u1ee5ng khi t\u00ednh hoa h\u1ed3ng, th\u01b0\u1edfng KPI.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1ed9t v\u00ed d\u1ee5 \u0111i\u1ec3n h\u00ecnh cho vi\u1ec7c \u00e1p d\u1ee5ng <\/span><b>h\u00e0m IF k\u1ebft h\u1ee3p ph\u00e9p nh\u00e2n v\u00e0 \u0111i\u1ec1u ki\u1ec7n kinh doanh.<\/b><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-07.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-07-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-07-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-505850 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-07.jpg\" alt=\"bai-tap-excel-co-ban-07\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-07.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-07-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-07-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><b>B\u00e0i t\u1eadp 3: T\u1ed5ng h\u1ee3p doanh thu theo th\u00e1ng<\/b><\/h3>\n<table>\n<tbody>\n<tr>\n<td><b>Th\u00e1ng<\/b><\/td>\n<td><b>Doanh thu<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">1<\/span><\/td>\n<td><span style=\"font-weight: 400;\">5,000,000<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">1<\/span><\/td>\n<td><span style=\"font-weight: 400;\">3,000,000<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">2<\/span><\/td>\n<td><span style=\"font-weight: 400;\">4,500,000<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify;\"><b>Y\u00eau c\u1ea7u:<\/b><span style=\"font-weight: 400;\"> T\u00ednh t\u1ed5ng doanh thu theo t\u1eebng th\u00e1ng.<\/span><\/p>\n<p style=\"text-align: justify;\"><b>L\u1eddi gi\u1ea3i:<\/b><b><br \/>\n<\/b> <span style=\"font-weight: 400;\">=SUMIF(A2:A4,1,B2:B4)<\/span><span style=\"font-weight: 400;\"> \u2192 t\u1ed5ng th\u00e1ng 1<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span> <span style=\"font-weight: 400;\">=SUMIF(A2:A4,2,B2:B4)<\/span><span style=\"font-weight: 400;\"> \u2192 t\u1ed5ng th\u00e1ng 2<\/span><\/p>\n<p style=\"text-align: justify;\"><b>Gi\u1ea3i th\u00edch: <\/b><span style=\"font-weight: 400;\">SUMIF<\/span><span style=\"font-weight: 400;\"> cho ph\u00e9p t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n, \u00e1p d\u1ee5ng trong b\u00e1o c\u00e1o doanh thu, th\u1ed1ng k\u00ea s\u1ea3n l\u01b0\u1ee3ng, ch\u1ea5m c\u00f4ng,\u2026<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u00e0i t\u1eadp excel c\u01a1 b\u1ea3n n\u00e2ng cao gi\u00fap l\u00e0m quen v\u1edbi <\/span><b>SUMIF<\/b><span style=\"font-weight: 400;\">, r\u1ea5t h\u1eefu \u00edch trong t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u b\u00e1o c\u00e1o.<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-08.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-08-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-08-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-505861 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-08.jpg\" alt=\"bai-tap-excel-co-ban-08\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-08.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-08-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-08-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2 style=\"text-align: justify;\"><b>B\u00e0i t\u1eadp Excel v\u0103n ph\u00f2ng \u1ee9ng d\u1ee5ng cho ng\u01b0\u1eddi \u0111i l\u00e0m<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c b\u00e0i t\u1eadp m\u00f4 ph\u1ecfng t\u00ecnh hu\u1ed1ng th\u1ef1c t\u1ebf trong c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n, nh\u00e2n s\u1ef1, h\u00e0nh ch\u00ednh\u2026<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>B\u00e0i t\u1eadp 1: Qu\u1ea3n l\u00fd l\u01b0\u01a1ng nh\u00e2n vi\u00ean<\/b><\/h3>\n<table>\n<tbody>\n<tr>\n<td><b>H\u1ecd t\u00ean<\/b><\/td>\n<td><b>L\u01b0\u01a1ng c\u01a1 b\u1ea3n<\/b><\/td>\n<td><b>Th\u01b0\u1edfng<\/b><\/td>\n<td><b>Ph\u1ea1t<\/b><\/td>\n<td><b>T\u1ed5ng l\u01b0\u01a1ng<\/b><\/td>\n<td><b>Thu\u1ebf (10%)<\/b><\/td>\n<td><b>L\u01b0\u01a1ng nh\u1eadn<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Nam<\/span><\/td>\n<td><span style=\"font-weight: 400;\">10,000,000<\/span><\/td>\n<td><span style=\"font-weight: 400;\">2,000,000<\/span><\/td>\n<td><span style=\"font-weight: 400;\">500,000<\/span><\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Hoa<\/span><\/td>\n<td><span style=\"font-weight: 400;\">12,000,000<\/span><\/td>\n<td><span style=\"font-weight: 400;\">1,500,000<\/span><\/td>\n<td><span style=\"font-weight: 400;\">800,000<\/span><\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">T\u00f9ng<\/span><\/td>\n<td><span style=\"font-weight: 400;\">9,000,000<\/span><\/td>\n<td><span style=\"font-weight: 400;\">1,000,000<\/span><\/td>\n<td><span style=\"font-weight: 400;\">0<\/span><\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify;\"><b>Y\u00eau c\u1ea7u:<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ednh <\/span><b>T\u1ed5ng l\u01b0\u01a1ng<\/b><span style=\"font-weight: 400;\"> = L\u01b0\u01a1ng c\u01a1 b\u1ea3n + Th\u01b0\u1edfng \u2013 Ph\u1ea1t<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ednh <\/span><b>Thu\u1ebf thu nh\u1eadp<\/b><span style=\"font-weight: 400;\"> = 10% c\u1ee7a T\u1ed5ng l\u01b0\u01a1ng<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ednh <\/span><b>L\u01b0\u01a1ng nh\u1eadn<\/b><span style=\"font-weight: 400;\"> = T\u1ed5ng l\u01b0\u01a1ng \u2013 Thu\u1ebf<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00f4 m\u00e0u \u00f4 <\/span><b>L\u01b0\u01a1ng nh\u1eadn<\/b><span style=\"font-weight: 400;\"> n\u1ebfu &gt; 10 tri\u1ec7u<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">S\u1eafp x\u1ebfp danh s\u00e1ch nh\u00e2n vi\u00ean theo <\/span><b>L\u01b0\u01a1ng nh\u1eadn<\/b><span style=\"font-weight: 400;\"> t\u1eeb cao xu\u1ed1ng th\u1ea5p<\/span><\/li>\n<\/ul>\n<h4 style=\"text-align: justify;\"><b>H\u01b0\u1edbng d\u1eabn th\u1ef1c h\u00e0nh &amp; l\u1eddi gi\u1ea3i t\u1eebng b\u01b0\u1edbc b\u00e0i t\u1eadp excel c\u01a1 b\u1ea3n<\/b><\/h4>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc 1: T\u00ednh T\u1ed5ng l\u01b0\u01a1ng<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u1ede \u00f4 <\/span><span style=\"font-weight: 400;\">E2<\/span><span style=\"font-weight: 400;\"> (c\u1ed9t T\u1ed5ng l\u01b0\u01a1ng) nh\u1eadp c\u00f4ng th\u1ee9c: <\/span><span style=\"font-weight: 400;\">=B2+C2-D2<\/span><\/li>\n<\/ul>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">K\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng cho c\u00e1c nh\u00e2n vi\u00ean c\u00f2n l\u1ea1i.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc 2: T\u00ednh Thu\u1ebf thu nh\u1eadp<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u1ede \u00f4 <\/span><span style=\"font-weight: 400;\">F2<\/span><span style=\"font-weight: 400;\"> nh\u1eadp c\u00f4ng th\u1ee9c: <\/span><span style=\"font-weight: 400;\">=E2*10%<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc 3: T\u00ednh L\u01b0\u01a1ng nh\u1eadn th\u1ef1c t\u1ebf<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u1ede \u00f4 <\/span><span style=\"font-weight: 400;\">G2<\/span><span style=\"font-weight: 400;\"> nh\u1eadp c\u00f4ng th\u1ee9c: <\/span><span style=\"font-weight: 400;\">=E2-F2<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc 4: \u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ch\u1ecdn c\u1ed9t \u201cL\u01b0\u01a1ng nh\u1eadn\u201d \u2192 Home \u2192 Conditional Formatting \u2192 Highlight Cell Rules \u2192 Greater Than \u2192 nh\u1eadp <\/span><span style=\"font-weight: 400;\">10000000<\/span><span style=\"font-weight: 400;\"> \u2192 ch\u1ecdn m\u00e0u n\u1ed5i b\u1eadt.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3: nh\u1eefng nh\u00e2n vi\u00ean c\u00f3 l\u01b0\u01a1ng &gt;10 tri\u1ec7u s\u1ebd \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u \u0111\u1ec3 d\u1ec5 nh\u1eadn bi\u1ebft.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-09.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-09-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-09-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-505863 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-09.jpg\" alt=\"bai-tap-excel-co-ban-09\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-09.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-09-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-09-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc 5: S\u1eafp x\u1ebfp d\u1eef li\u1ec7u<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng \u2192 Data \u2192 Sort \u2192 Sort by \u201cL\u01b0\u01a1ng nh\u1eadn\u201d \u2192 Largest to Smallest.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3: nh\u00e2n vi\u00ean c\u00f3 l\u01b0\u01a1ng cao nh\u1ea5t s\u1ebd \u0111\u1ee9ng \u0111\u1ea7u b\u1ea3ng.<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><b>B\u00e0i t\u1eadp excel c\u01a1 b\u1ea3n n\u00e2ng cao 2: Theo d\u00f5i t\u1ed3n kho h\u00e0ng h\u00f3a<\/b><\/h3>\n<table>\n<tbody>\n<tr>\n<td><b>M\u00e3 SP<\/b><\/td>\n<td><b>T\u00ean s\u1ea3n ph\u1ea9m<\/b><\/td>\n<td><b>Nh\u1eadp<\/b><\/td>\n<td><b>Xu\u1ea5t<\/b><\/td>\n<td><b>T\u1ed3n kho<\/b><\/td>\n<td><b>T\u1ed3n t\u1ed1i thi\u1ec3u<\/b><\/td>\n<td><b>T\u00ecnh tr\u1ea1ng<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">A01<\/span><\/td>\n<td><span style=\"font-weight: 400;\">S\u1eefa<\/span><\/td>\n<td><span style=\"font-weight: 400;\">100<\/span><\/td>\n<td><span style=\"font-weight: 400;\">30<\/span><\/td>\n<td><\/td>\n<td><span style=\"font-weight: 400;\">50<\/span><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">A02<\/span><\/td>\n<td><span style=\"font-weight: 400;\">B\u00e1nh m\u00ec<\/span><\/td>\n<td><span style=\"font-weight: 400;\">200<\/span><\/td>\n<td><span style=\"font-weight: 400;\">180<\/span><\/td>\n<td><\/td>\n<td><span style=\"font-weight: 400;\">50<\/span><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">A03<\/span><\/td>\n<td><span style=\"font-weight: 400;\">N\u01b0\u1edbc ng\u1ecdt<\/span><\/td>\n<td><span style=\"font-weight: 400;\">150<\/span><\/td>\n<td><span style=\"font-weight: 400;\">80<\/span><\/td>\n<td><\/td>\n<td><span style=\"font-weight: 400;\">40<\/span><\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify;\"><b>Y\u00eau c\u1ea7u:<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ednh <\/span><b>T\u1ed3n kho<\/b><span style=\"font-weight: 400;\"> = Nh\u1eadp \u2013 Xu\u1ea5t<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">X\u00e1c \u0111\u1ecbnh <\/span><b>t\u00ecnh tr\u1ea1ng s\u1ea3n ph\u1ea9m<\/b><span style=\"font-weight: 400;\">: N\u1ebfu t\u1ed3n kho &lt; t\u1ed3n t\u1ed1i thi\u1ec3u \u2192 \u201cC\u1ea7n nh\u1eadp th\u00eam\u201d. N\u1ebfu t\u1ed3n kho \u2265 t\u1ed3n t\u1ed1i thi\u1ec3u \u2192 \u201c\u0110\u1ee7 h\u00e0ng\u201d<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00f4 m\u00e0u c\u00e1c s\u1ea3n ph\u1ea9m <\/span><b>c\u1ea7n nh\u1eadp th\u00eam<\/b><span style=\"font-weight: 400;\"> b\u1eb1ng <\/span><b>Conditional Formatting<\/b><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">S\u1eafp x\u1ebfp danh s\u00e1ch s\u1ea3n ph\u1ea9m theo t\u1ed3n kho t\u1eeb th\u1ea5p \u0111\u1ebfn cao<\/span><\/li>\n<\/ul>\n<h4 style=\"text-align: justify;\"><b>H\u01b0\u1edbng d\u1eabn th\u1ef1c h\u00e0nh &amp; l\u1eddi gi\u1ea3i t\u1eebng b\u01b0\u1edbc<\/b><\/h4>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc 1: T\u00ednh T\u1ed3n kho<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u00d4 <\/span><span style=\"font-weight: 400;\">E2<\/span><span style=\"font-weight: 400;\"> nh\u1eadp c\u00f4ng th\u1ee9c: <\/span><span style=\"font-weight: 400;\">=C2-D2<\/span><\/li>\n<\/ul>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">K\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng cho c\u00e1c s\u1ea3n ph\u1ea9m c\u00f2n l\u1ea1i.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc 2: X\u00e1c \u0111\u1ecbnh t\u00ecnh tr\u1ea1ng s\u1ea3n ph\u1ea9m<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u00d4 <\/span><span style=\"font-weight: 400;\">G2<\/span><span style=\"font-weight: 400;\"> nh\u1eadp c\u00f4ng th\u1ee9c: <\/span><span style=\"font-weight: 400;\">=IF(E2&lt;F2,&#8221;C\u1ea7n nh\u1eadp th\u00eam&#8221;,&#8221;\u0110\u1ee7 h\u00e0ng&#8221;)<\/span><\/li>\n<\/ul>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">K\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng cho c\u00e1c s\u1ea3n ph\u1ea9m c\u00f2n l\u1ea1i.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc 3: \u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ch\u1ecdn c\u1ed9t \u201cT\u00ecnh tr\u1ea1ng\u201d \u2192 Home \u2192 Conditional Formatting \u2192 Highlight Cell Rules \u2192 Text that Contains \u2192 nh\u1eadp <\/span><span style=\"font-weight: 400;\">&#8220;C\u1ea7n nh\u1eadp th\u00eam&#8221;<\/span><span style=\"font-weight: 400;\"> \u2192 ch\u1ecdn m\u00e0u \u0111\u1ecf.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3: c\u00e1c s\u1ea3n ph\u1ea9m c\u1ea7n nh\u1eadp th\u00eam s\u1ebd \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u n\u1ed5i b\u1eadt.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-505864 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-10.jpg\" alt=\"bai-tap-excel-co-ban-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc 4: S\u1eafp x\u1ebfp s\u1ea3n ph\u1ea9m theo t\u1ed3n kho<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng \u2192 Data \u2192 Sort \u2192 Sort by \u201cT\u1ed3n kho\u201d \u2192 Smallest to Largest<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3: c\u00e1c s\u1ea3n ph\u1ea9m c\u00f3 t\u1ed3n kho th\u1ea5p nh\u1ea5t s\u1ebd \u0111\u1ee9ng \u0111\u1ea7u b\u1ea3ng, d\u1ec5 theo d\u00f5i v\u00e0 ra quy\u1ebft \u0111\u1ecbnh nh\u1eadp h\u00e0ng.<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><b>B\u00e0i t\u1eadp excel c\u01a1 b\u1ea3n n\u00e2ng cao 3: B\u00e1o c\u00e1o doanh thu theo nh\u00e2n vi\u00ean b\u00e1n h\u00e0ng<\/b><\/h3>\n<table>\n<tbody>\n<tr>\n<td><b>Nh\u00e2n vi\u00ean<\/b><\/td>\n<td><b>Doanh thu Th\u00e1ng 1<\/b><\/td>\n<td><b>Doanh thu Th\u00e1ng 2<\/b><\/td>\n<td><b>Doanh thu Th\u00e1ng 3<\/b><\/td>\n<td><b>T\u1ed5ng qu\u00fd I<\/b><\/td>\n<td><b>Trung b\u00ecnh<\/b><\/td>\n<td><b>KPI \u0111\u1ea1t<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Lan<\/span><\/td>\n<td><span style=\"font-weight: 400;\">10,000,000<\/span><\/td>\n<td><span style=\"font-weight: 400;\">12,000,000<\/span><\/td>\n<td><span style=\"font-weight: 400;\">8,000,000<\/span><\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Nam<\/span><\/td>\n<td><span style=\"font-weight: 400;\">15,000,000<\/span><\/td>\n<td><span style=\"font-weight: 400;\">14,000,000<\/span><\/td>\n<td><span style=\"font-weight: 400;\">16,000,000<\/span><\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Hoa<\/span><\/td>\n<td><span style=\"font-weight: 400;\">7,000,000<\/span><\/td>\n<td><span style=\"font-weight: 400;\">9,000,000<\/span><\/td>\n<td><span style=\"font-weight: 400;\">8,500,000<\/span><\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify;\"><b>Y\u00eau c\u1ea7u:<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ednh <\/span><b>T\u1ed5ng doanh thu qu\u00fd I<\/b><span style=\"font-weight: 400;\"> cho t\u1eebng nh\u00e2n vi\u00ean<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ednh <\/span><b>Doanh thu trung b\u00ecnh<\/b><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">X\u00e1c \u0111\u1ecbnh <\/span><b>KPI \u0111\u1ea1t\/kh\u00f4ng \u0111\u1ea1t<\/b><span style=\"font-weight: 400;\">: n\u1ebfu doanh thu trung b\u00ecnh \u2265 10 tri\u1ec7u \u2192 \u201c\u0110\u1ea1t\u201d, ng\u01b0\u1ee3c l\u1ea1i \u2192 \u201cCh\u01b0a \u0111\u1ea1t\u201d<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00f4 m\u00e0u c\u00e1c nh\u00e2n vi\u00ean <\/span><b>ch\u01b0a \u0111\u1ea1t KPI<\/b><span style=\"font-weight: 400;\"> b\u1eb1ng <\/span><b>Conditional Formatting<\/b><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">S\u1eafp x\u1ebfp danh s\u00e1ch nh\u00e2n vi\u00ean theo <\/span><b>t\u1ed5ng doanh thu<\/b><span style=\"font-weight: 400;\"> t\u1eeb cao xu\u1ed1ng th\u1ea5p<\/span><\/li>\n<\/ul>\n<h4 style=\"text-align: justify;\"><b>H\u01b0\u1edbng d\u1eabn th\u1ef1c h\u00e0nh &amp; l\u1eddi gi\u1ea3i t\u1eebng b\u01b0\u1edbc<\/b><\/h4>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc 1: T\u00ednh t\u1ed5ng doanh thu qu\u00fd I<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u00d4 <\/span><span style=\"font-weight: 400;\">E2<\/span><span style=\"font-weight: 400;\"> nh\u1eadp c\u00f4ng th\u1ee9c: <\/span><span style=\"font-weight: 400;\">=SUM(B2:D2)<\/span><\/li>\n<\/ul>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">K\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng cho c\u00e1c nh\u00e2n vi\u00ean c\u00f2n l\u1ea1i.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc 2: T\u00ednh doanh thu trung b\u00ecnh<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u00d4 <\/span><span style=\"font-weight: 400;\">F2<\/span><span style=\"font-weight: 400;\"> nh\u1eadp c\u00f4ng th\u1ee9c: <\/span><span style=\"font-weight: 400;\">=AVERAGE(B2:D2)<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc 3: X\u00e1c \u0111\u1ecbnh KPI \u0111\u1ea1t\/kh\u00f4ng \u0111\u1ea1t<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u00d4 <\/span><span style=\"font-weight: 400;\">G2<\/span><span style=\"font-weight: 400;\"> nh\u1eadp c\u00f4ng th\u1ee9c: <\/span><span style=\"font-weight: 400;\">=IF(F2&gt;=10000000,&#8221;\u0110\u1ea1t&#8221;,&#8221;Ch\u01b0a \u0111\u1ea1t&#8221;)<\/span><\/li>\n<\/ul>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">K\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng cho c\u00e1c nh\u00e2n vi\u00ean c\u00f2n l\u1ea1i.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc 4: \u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ch\u1ecdn c\u1ed9t \u201cKPI \u0111\u1ea1t\u201d \u2192 Home \u2192 Conditional Formatting \u2192 Highlight Cell Rules \u2192 Text that Contains \u2192 nh\u1eadp <\/span><span style=\"font-weight: 400;\">&#8220;Ch\u01b0a \u0111\u1ea1t&#8221;<\/span><span style=\"font-weight: 400;\"> \u2192 ch\u1ecdn m\u00e0u \u0111\u1ecf.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3: c\u00e1c nh\u00e2n vi\u00ean ch\u01b0a \u0111\u1ea1t KPI \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u \u0111\u1ec3 d\u1ec5 nh\u1eadn bi\u1ebft.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-505865 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-11.jpg\" alt=\"bai-tap-excel-co-ban-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc 5: S\u1eafp x\u1ebfp nh\u00e2n vi\u00ean theo t\u1ed5ng doanh thu<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng \u2192 Data \u2192 Sort \u2192 Sort by \u201cT\u1ed5ng qu\u00fd I\u201d \u2192 Largest to Smallest<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3: nh\u00e2n vi\u00ean c\u00f3 t\u1ed5ng doanh thu cao nh\u1ea5t s\u1ebd \u0111\u1ee9ng \u0111\u1ea7u b\u1ea3ng.<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><b>B\u00e0i t\u1eadp excel c\u01a1 b\u1ea3n n\u00e2ng cao 4: T\u1ef1 \u0111\u1ed9ng ph\u00e2n lo\u1ea1i nh\u00e2n vi\u00ean \u0111\u1ea1t KPI<\/b><\/h3>\n<table>\n<tbody>\n<tr>\n<td><b>Nh\u00e2n vi\u00ean<\/b><\/td>\n<td><b>Doanh s\u1ed1<\/b><\/td>\n<td><b>M\u1ee5c ti\u00eau<\/b><\/td>\n<td><b>K\u1ebft qu\u1ea3<\/b><\/td>\n<td><b>Ghi ch\u00fa<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">A<\/span><\/td>\n<td><span style=\"font-weight: 400;\">11,000,000<\/span><\/td>\n<td><span style=\"font-weight: 400;\">10,000,000<\/span><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">B<\/span><\/td>\n<td><span style=\"font-weight: 400;\">9,500,000<\/span><\/td>\n<td><span style=\"font-weight: 400;\">10,000,000<\/span><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">C<\/span><\/td>\n<td><span style=\"font-weight: 400;\">12,500,000<\/span><\/td>\n<td><span style=\"font-weight: 400;\">12,000,000<\/span><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">D<\/span><\/td>\n<td><span style=\"font-weight: 400;\">8,000,000<\/span><\/td>\n<td><span style=\"font-weight: 400;\">9,000,000<\/span><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify;\"><b>Y\u00eau c\u1ea7u:<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">X\u00e1c \u0111\u1ecbnh k\u1ebft qu\u1ea3 KPI: N\u1ebfu doanh s\u1ed1 \u2265 m\u1ee5c ti\u00eau \u2192 \u201c\u0110\u1ea1t\u201d. N\u1ebfu doanh s\u1ed1 &lt; m\u1ee5c ti\u00eau \u2192 \u201cCh\u01b0a \u0111\u1ea1t\u201d<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00f4 m\u00e0u c\u00e1c nh\u00e2n vi\u00ean ch\u01b0a \u0111\u1ea1t KPI b\u1eb1ng <\/span><b>Conditional Formatting<\/b><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u1ea1o c\u1ed9t ghi ch\u00fa: N\u1ebfu ch\u01b0a \u0111\u1ea1t KPI v\u00e0 doanh s\u1ed1 &lt; 50% m\u1ee5c ti\u00eau \u2192 \u201cC\u1ea3nh b\u00e1o\u201d. Ng\u01b0\u1ee3c l\u1ea1i \u0111\u1ec3 tr\u1ed1ng.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">S\u1eafp x\u1ebfp danh s\u00e1ch nh\u00e2n vi\u00ean theo k\u1ebft qu\u1ea3 KPI, \u01b0u ti\u00ean \u201cCh\u01b0a \u0111\u1ea1t\u201d l\u00ean \u0111\u1ea7u<\/span><\/li>\n<\/ul>\n<h4 style=\"text-align: justify;\"><b>H\u01b0\u1edbng d\u1eabn th\u1ef1c h\u00e0nh &amp; l\u1eddi gi\u1ea3i t\u1eebng b\u01b0\u1edbc<\/b><\/h4>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc 1: X\u00e1c \u0111\u1ecbnh k\u1ebft qu\u1ea3 KPI<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u00d4 <\/span><span style=\"font-weight: 400;\">D2<\/span><span style=\"font-weight: 400;\"> nh\u1eadp c\u00f4ng th\u1ee9c: <\/span><span style=\"font-weight: 400;\">=IF(B2&gt;=C2,&#8221;\u0110\u1ea1t&#8221;,&#8221;Ch\u01b0a \u0111\u1ea1t&#8221;)<\/span><\/li>\n<\/ul>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">K\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng cho c\u00e1c nh\u00e2n vi\u00ean c\u00f2n l\u1ea1i<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/bai-tap-excel-co-ban-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-505866 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-12.jpg\" alt=\"bai-tap-excel-co-ban-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc 2: \u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ch\u1ecdn c\u1ed9t \u201cK\u1ebft qu\u1ea3\u201d \u2192 Home \u2192 Conditional Formatting \u2192 Highlight Cell Rules \u2192 Text that Contains \u2192 nh\u1eadp <\/span><span style=\"font-weight: 400;\">&#8220;Ch\u01b0a \u0111\u1ea1t&#8221;<\/span><span style=\"font-weight: 400;\"> \u2192 ch\u1ecdn m\u00e0u \u0111\u1ecf<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc 3: T\u1ea1o ghi ch\u00fa c\u1ea3nh b\u00e1o<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u00d4 <\/span><span style=\"font-weight: 400;\">E2<\/span><span style=\"font-weight: 400;\"> nh\u1eadp c\u00f4ng th\u1ee9c: <\/span><span style=\"font-weight: 400;\">=IF(AND(B2&lt;C2,B2&lt;0.5*C2),&#8221;C\u1ea3nh b\u00e1o&#8221;,&#8221;&#8221;)<\/span><\/li>\n<\/ul>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">K\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3: nh\u00e2n vi\u00ean ch\u01b0a \u0111\u1ea1t KPI nghi\u00eam tr\u1ecdng s\u1ebd \u0111\u01b0\u1ee3c c\u1ea3nh b\u00e1o<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><b>B\u01b0\u1edbc 4: S\u1eafp x\u1ebfp nh\u00e2n vi\u00ean theo k\u1ebft qu\u1ea3 KPI<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng \u2192 Data \u2192 Sort \u2192 Sort by \u201cK\u1ebft qu\u1ea3\u201d \u2192 \u201cCh\u01b0a \u0111\u1ea1t\u201d l\u00ean tr\u00ean<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3: d\u1ec5 nh\u1eadn bi\u1ebft ai c\u1ea7n c\u1ea3i thi\u1ec7n hi\u1ec7u su\u1ea5t<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><b>T\u1ea1m k\u1ebft<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Vi\u1ec7c luy\u1ec7n t\u1eadp c\u00e1c <\/span><b>b\u00e0i t\u1eadp Excel c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao<\/b><span style=\"font-weight: 400;\"> l\u00e0 c\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 th\u00e0nh th\u1ea1o c\u00f4ng c\u1ee5 n\u00e0y. Khi \u0111\u00e3 quen v\u1edbi h\u00e0m, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng t\u1ea1o b\u00e1o c\u00e1o, t\u00ednh to\u00e1n, ph\u00e2n t\u00edch d\u1eef li\u1ec7u ch\u1ec9 trong v\u00e0i ph\u00fat. Hy v\u1ecdng b\u1ed9 b\u00e0i t\u1eadp tr\u00ean s\u1ebd gi\u00fap b\u1ea1n c\u1ee7ng c\u1ed1 ki\u1ebfn th\u1ee9c, l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 v\u00e0 chuy\u00ean nghi\u1ec7p h\u01a1n trong m\u00f4i tr\u01b0\u1eddng v\u0103n ph\u00f2ng.<\/span><\/p>\n<p style=\"text-align: justify;\"><strong>XEM TH\u00caM:<\/strong><\/p>\n<p><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-random-trong-excel\/\">H\u00e0m Random trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda c\u1ee5 th\u1ec3<\/a><\/strong><\/p>\n<p><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/tim-kiem-trong-excel\/\">7 c\u00e1ch t\u00ecm ki\u1ebfm trong Excel v\u00e0 thay th\u1ebf v\u1edbi Find v\u00e0 Replace<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel l\u00e0 c\u00f4ng c\u1ee5 kh\u00f4ng th\u1ec3 thi\u1ebfu trong m\u1ecdi l\u0129nh v\u1ef1c \u2014 t\u1eeb k\u1ebf to\u00e1n, h\u00e0nh ch\u00ednh, nh\u00e2n s\u1ef1 \u0111\u1ebfn qu\u1ea3n tr\u1ecb d\u1eef li\u1ec7u. Tuy nhi\u00ean, nhi\u1ec1u ng\u01b0\u1eddi h\u1ecdc Excel ch\u1ec9 d\u1eebng l\u1ea1i \u1edf m\u1ee9c s\u1eed d\u1ee5ng v\u00e0i c\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n m\u00e0 ch\u01b0a bi\u1ebft c\u00e1ch v\u1eadn d\u1ee5ng ch\u00fang trong th\u1ef1c t\u1ebf. B\u00e0i vi\u1ebft n\u00e0y [&hellip;]<\/p>\n","protected":false},"author":113,"featured_media":505867,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-505842","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat","category-thu-thuat-may-tinh"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>20+ b\u00e0i t\u1eadp Excel c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao chi ti\u1ebft [C\u00d3 L\u1edcI GI\u1ea2I]<\/title>\n<meta name=\"description\" content=\"T\u1ed5ng h\u1ee3p 20+ b\u00e0i t\u1eadp Excel t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao k\u00e8m l\u1eddi gi\u1ea3i, gi\u00fap h\u1ecdc v\u00e0 luy\u1ec7n k\u1ef9 n\u0103ng Excel th\u1ef1c h\u00e0nh, l\u1eadp b\u00e1o c\u00e1o, qu\u1ea3n l\u00fd d\u1eef li\u1ec7u.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/bai-tap-excel-co-ban\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"20+ b\u00e0i t\u1eadp Excel c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao chi ti\u1ebft [C\u00d3 L\u1edcI GI\u1ea2I]\" \/>\n<meta property=\"og:description\" content=\"T\u1ed5ng h\u1ee3p 20+ b\u00e0i t\u1eadp Excel t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao k\u00e8m l\u1eddi gi\u1ea3i, gi\u00fap h\u1ecdc v\u00e0 luy\u1ec7n k\u1ef9 n\u0103ng Excel th\u1ef1c h\u00e0nh, l\u1eadp b\u00e1o c\u00e1o, qu\u1ea3n l\u00fd d\u1eef li\u1ec7u.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/bai-tap-excel-co-ban\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2025-11-16T02:45:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-thumbnail.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Nguy\u1ec5n L\u00e2m Oanh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nguy\u1ec5n L\u00e2m Oanh\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"15 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/bai-tap-excel-co-ban\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/bai-tap-excel-co-ban\/\"},\"author\":{\"name\":\"Nguy\u1ec5n L\u00e2m Oanh\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/e2da5c62c25607002135e64d8a6ccd66\"},\"headline\":\"20+ b\u00e0i t\u1eadp Excel c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao chi ti\u1ebft [C\u00d3 L\u1edcI GI\u1ea2I]\",\"datePublished\":\"2025-11-16T02:45:16+00:00\",\"dateModified\":\"2025-11-16T02:45:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/bai-tap-excel-co-ban\/\"},\"wordCount\":3254,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/bai-tap-excel-co-ban\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-thumbnail.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\"],\"inLanguage\":\"vi\",\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/bai-tap-excel-co-ban\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/bai-tap-excel-co-ban\/\",\"name\":\"20+ b\u00e0i t\u1eadp Excel c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao chi ti\u1ebft [C\u00d3 L\u1edcI GI\u1ea2I]\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/bai-tap-excel-co-ban\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/bai-tap-excel-co-ban\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-thumbnail.jpg\",\"datePublished\":\"2025-11-16T02:45:16+00:00\",\"dateModified\":\"2025-11-16T02:45:16+00:00\",\"description\":\"T\u1ed5ng h\u1ee3p 20+ b\u00e0i t\u1eadp Excel t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao k\u00e8m l\u1eddi gi\u1ea3i, gi\u00fap h\u1ecdc v\u00e0 luy\u1ec7n k\u1ef9 n\u0103ng Excel th\u1ef1c h\u00e0nh, l\u1eadp b\u00e1o c\u00e1o, qu\u1ea3n l\u00fd d\u1eef li\u1ec7u.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/bai-tap-excel-co-ban\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/bai-tap-excel-co-ban\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/bai-tap-excel-co-ban\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-thumbnail.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-thumbnail.jpg\",\"width\":1200,\"height\":628,\"caption\":\"bai-tap-excel-co-ban-thumbnail\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/bai-tap-excel-co-ban\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"20+ b\u00e0i t\u1eadp Excel c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao chi ti\u1ebft [C\u00d3 L\u1edcI GI\u1ea2I]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/e2da5c62c25607002135e64d8a6ccd66\",\"name\":\"Nguy\u1ec5n L\u00e2m Oanh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/d3e93853a07df410725e38bc854e49cd.jpg?ver=1775470092\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/d3e93853a07df410725e38bc854e49cd.jpg?ver=1775470092\",\"caption\":\"Nguy\u1ec5n L\u00e2m Oanh\"},\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-thi-lam-oanh\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"20+ b\u00e0i t\u1eadp Excel c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao chi ti\u1ebft [C\u00d3 L\u1edcI GI\u1ea2I]","description":"T\u1ed5ng h\u1ee3p 20+ b\u00e0i t\u1eadp Excel t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao k\u00e8m l\u1eddi gi\u1ea3i, gi\u00fap h\u1ecdc v\u00e0 luy\u1ec7n k\u1ef9 n\u0103ng Excel th\u1ef1c h\u00e0nh, l\u1eadp b\u00e1o c\u00e1o, qu\u1ea3n l\u00fd d\u1eef li\u1ec7u.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/bai-tap-excel-co-ban\/","og_locale":"vi_VN","og_type":"article","og_title":"20+ b\u00e0i t\u1eadp Excel c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao chi ti\u1ebft [C\u00d3 L\u1edcI GI\u1ea2I]","og_description":"T\u1ed5ng h\u1ee3p 20+ b\u00e0i t\u1eadp Excel t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao k\u00e8m l\u1eddi gi\u1ea3i, gi\u00fap h\u1ecdc v\u00e0 luy\u1ec7n k\u1ef9 n\u0103ng Excel th\u1ef1c h\u00e0nh, l\u1eadp b\u00e1o c\u00e1o, qu\u1ea3n l\u00fd d\u1eef li\u1ec7u.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/bai-tap-excel-co-ban\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2025-11-16T02:45:16+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-thumbnail.jpg","type":"image\/jpeg"}],"author":"Nguy\u1ec5n L\u00e2m Oanh","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Nguy\u1ec5n L\u00e2m Oanh","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"15 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/bai-tap-excel-co-ban\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/bai-tap-excel-co-ban\/"},"author":{"name":"Nguy\u1ec5n L\u00e2m Oanh","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/e2da5c62c25607002135e64d8a6ccd66"},"headline":"20+ b\u00e0i t\u1eadp Excel c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao chi ti\u1ebft [C\u00d3 L\u1edcI GI\u1ea2I]","datePublished":"2025-11-16T02:45:16+00:00","dateModified":"2025-11-16T02:45:16+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/bai-tap-excel-co-ban\/"},"wordCount":3254,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/bai-tap-excel-co-ban\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-thumbnail.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh"],"inLanguage":"vi","copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/bai-tap-excel-co-ban\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/bai-tap-excel-co-ban\/","name":"20+ b\u00e0i t\u1eadp Excel c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao chi ti\u1ebft [C\u00d3 L\u1edcI GI\u1ea2I]","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/bai-tap-excel-co-ban\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/bai-tap-excel-co-ban\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-thumbnail.jpg","datePublished":"2025-11-16T02:45:16+00:00","dateModified":"2025-11-16T02:45:16+00:00","description":"T\u1ed5ng h\u1ee3p 20+ b\u00e0i t\u1eadp Excel t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao k\u00e8m l\u1eddi gi\u1ea3i, gi\u00fap h\u1ecdc v\u00e0 luy\u1ec7n k\u1ef9 n\u0103ng Excel th\u1ef1c h\u00e0nh, l\u1eadp b\u00e1o c\u00e1o, qu\u1ea3n l\u00fd d\u1eef li\u1ec7u.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/bai-tap-excel-co-ban\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/bai-tap-excel-co-ban\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/bai-tap-excel-co-ban\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-thumbnail.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/bai-tap-excel-co-ban-thumbnail.jpg","width":1200,"height":628,"caption":"bai-tap-excel-co-ban-thumbnail"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/bai-tap-excel-co-ban\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"20+ b\u00e0i t\u1eadp Excel c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao chi ti\u1ebft [C\u00d3 L\u1edcI GI\u1ea2I]"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/e2da5c62c25607002135e64d8a6ccd66","name":"Nguy\u1ec5n L\u00e2m Oanh","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/d3e93853a07df410725e38bc854e49cd.jpg?ver=1775470092","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/d3e93853a07df410725e38bc854e49cd.jpg?ver=1775470092","caption":"Nguy\u1ec5n L\u00e2m Oanh"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-thi-lam-oanh\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/505842","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/113"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=505842"}],"version-history":[{"count":4,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/505842\/revisions"}],"predecessor-version":[{"id":506635,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/505842\/revisions\/506635"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/505867"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=505842"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=505842"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=505842"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}