{"id":2664,"date":"2024-12-02T08:20:20","date_gmt":"2024-12-02T08:20:20","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-ve-bieu-do-cot-ket-hop-duong-bieu-dien-tren-excel-chi-tiet-nhat\/"},"modified":"2024-12-02T08:20:20","modified_gmt":"2024-12-02T08:20:20","slug":"cach-ve-bieu-do-cot-ket-hop-duong-bieu-dien-tren-excel-chi-tiet-nhat","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-ve-bieu-do-cot-ket-hop-duong-bieu-dien-tren-excel-chi-tiet-nhat\/","title":{"rendered":"C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t k\u1ebft h\u1ee3p \u0111\u01b0\u1eddng bi\u1ec3u di\u1ec5n tr\u00ean Excel chi ti\u1ebft nh\u1ea5t"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>B\u1ea1n s\u1ebd v\u1ebd bi\u1ec3u \u0111\u1ed3 th\u1ebf n\u00e0o khi d\u1eef li\u1ec7u c\u1ea7n bi\u1ec3u di\u1ec5n v\u1eeba \u1edf d\u1ea1ng s\u1ed1, v\u1eeba \u1edf d\u1ea1ng %? Hay l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 v\u1ebd \u0111\u01b0\u1ee3c bi\u1ec3u \u0111\u1ed3 v\u1eeba th\u1ec3 hi\u1ec7n c\u00e1c c\u1ed9t bi\u1ec3u di\u1ec5n c\u00e1c con s\u1ed1, v\u1eeba th\u1ec3 hi\u1ec7n \u0111\u01b0\u1eddng bi\u1ec3u di\u1ec5n cho c\u00e1c t\u1ef7 l\u1ec7 % tr\u00ean c\u00f9ng 1 bi\u1ec3u \u0111\u1ed3? H\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> t\u00ecm hi\u1ec3u<strong> c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t k\u1ebft h\u1ee3p \u0111\u01b0\u1eddng<\/strong> bi\u1ec3u di\u1ec5n tr\u00ean Excel nh\u00e9.<\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-674d6dc3c4f2b\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-cot-ket-hop-duong-bieu-dien-tren-excel-chi-tiet-nhat.html#Xet_vi_du\" title=\"X\u00e9t v\u00ed d\u1ee5\">X\u00e9t v\u00ed d\u1ee5<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-cot-ket-hop-duong-bieu-dien-tren-excel-chi-tiet-nhat.html#Phan_tich_du_lieu_va_yeu_cau_ve_bieu_do\" title=\"Ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u00e0 y\u00eau c\u1ea7u v\u1ebd bi\u1ec3u \u0111\u1ed3\">Ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u00e0 y\u00eau c\u1ea7u v\u1ebd bi\u1ec3u \u0111\u1ed3<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-cot-ket-hop-duong-bieu-dien-tren-excel-chi-tiet-nhat.html#1_Loc_bo_cac_gia_tri_trung_trong_cot_Nhan_vien\" title=\"1. L\u1ecdc b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng trong c\u1ed9t Nh\u00e2n vi\u00ean\">1. L\u1ecdc b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng trong c\u1ed9t Nh\u00e2n vi\u00ean<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-cot-ket-hop-duong-bieu-dien-tren-excel-chi-tiet-nhat.html#2_Tinh_ket_qua_doanh_so_theo_tung_nhan_vien\" title=\"2. T\u00ednh k\u1ebft qu\u1ea3 doanh s\u1ed1 theo t\u1eebng nh\u00e2n vi\u00ean\">2. T\u00ednh k\u1ebft qu\u1ea3 doanh s\u1ed1 theo t\u1eebng nh\u00e2n vi\u00ean<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-cot-ket-hop-duong-bieu-dien-tren-excel-chi-tiet-nhat.html#3_Sap_xep_du_lieu_theo_thu_tu\" title=\"3. S\u1eafp x\u1ebfp d\u1eef li\u1ec7u theo th\u1ee9 t\u1ef1\">3. S\u1eafp x\u1ebfp d\u1eef li\u1ec7u theo th\u1ee9 t\u1ef1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-cot-ket-hop-duong-bieu-dien-tren-excel-chi-tiet-nhat.html#4_Tinh_phan_tram_doanh_so_cua_moi_nhan_vien\" title=\"4. T\u00ednh ph\u1ea7n tr\u0103m doanh s\u1ed1 c\u1ee7a m\u1ed7i nh\u00e2n vi\u00ean\">4. T\u00ednh ph\u1ea7n tr\u0103m doanh s\u1ed1 c\u1ee7a m\u1ed7i nh\u00e2n vi\u00ean<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-cot-ket-hop-duong-bieu-dien-tren-excel-chi-tiet-nhat.html#Lua_chon_bieu_do_va_ve_bieu_do\" title=\"L\u1ef1a ch\u1ecdn bi\u1ec3u \u0111\u1ed3 v\u00e0 v\u1ebd bi\u1ec3u \u0111\u1ed3\">L\u1ef1a ch\u1ecdn bi\u1ec3u \u0111\u1ed3 v\u00e0 v\u1ebd bi\u1ec3u \u0111\u1ed3<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-cot-ket-hop-duong-bieu-dien-tren-excel-chi-tiet-nhat.html#Nhan_dang_bieu_do\" title=\"Nh\u1eadn d\u1ea1ng bi\u1ec3u \u0111\u1ed3\">Nh\u1eadn d\u1ea1ng bi\u1ec3u \u0111\u1ed3<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-cot-ket-hop-duong-bieu-dien-tren-excel-chi-tiet-nhat.html#Cach_ve_bieu_do_cot_trong_Excel\" title=\"C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel\">C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-cot-ket-hop-duong-bieu-dien-tren-excel-chi-tiet-nhat.html#Them_truc_toa_do_vao_ben_phai_bieu_do\" title=\"Th\u00eam tr\u1ee5c t\u1ecda \u0111\u1ed9 % v\u00e0o b\u00ean ph\u1ea3i bi\u1ec3u \u0111\u1ed3\">Th\u00eam tr\u1ee5c t\u1ecda \u0111\u1ed9 % v\u00e0o b\u00ean ph\u1ea3i bi\u1ec3u \u0111\u1ed3<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Xet_vi_du\"><\/span>X\u00e9t v\u00ed d\u1ee5<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Cho b\u1ea3ng d\u1eef li\u1ec7u th\u1ec3 hi\u1ec7n doanh s\u1ed1 c\u1ee7a c\u00e1c nh\u00e2n vi\u00ean nh\u01b0 sau:<\/p>\n<figure id=\"attachment_20281\" aria-describedby=\"caption-attachment-20281\" style=\"width: 240px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20281 size-full\" title=\"c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t k\u1ebft h\u1ee3p \u0111\u01b0\u1eddng\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data-ve-bieu-do-chenh-lech-lon.png\" alt=\"c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t k\u1ebft h\u1ee3p \u0111\u01b0\u1eddng\" width=\"240\" height=\"346\"><figcaption id=\"caption-attachment-20281\" class=\"wp-caption-text\">c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t k\u1ebft h\u1ee3p \u0111\u01b0\u1eddng<\/figcaption><\/figure>\n<p><strong>Y\u00eau c\u1ea7u<\/strong>: V\u1ebd bi\u1ec3u \u0111\u1ed3 th\u1ec3 hi\u1ec7n doanh s\u1ed1 c\u1ee7a c\u00e1c nh\u00e2n vi\u00ean v\u00e0 t\u1ef7 l\u1ec7 % doanh s\u1ed1 c\u1ee7a m\u1ed7i ng\u01b0\u1eddi trong t\u1ed5ng s\u1ed1 to\u00e0n c\u00f4ng ty.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Phan_tich_du_lieu_va_yeu_cau_ve_bieu_do\"><\/span>Ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u00e0 y\u00eau c\u1ea7u v\u1ebd bi\u1ec3u \u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u00e2y l\u00e0 b\u01b0\u1edbc r\u1ea5t quan tr\u1ecdng khi th\u1ef1c hi\u1ec7n b\u1ea5t k\u1ef3 y\u00eau c\u1ea7u <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-ve-bieu-do-trong-excel-2010-2013-2016.html\"><strong>v\u1ebd bi\u1ec3u \u0111\u1ed3trong Excel<\/strong><\/a> n\u00e0o. Nguy\u00ean t\u1eafc \u0111\u1ec3 c\u00f3 th\u1ec3 v\u1ebd \u0111\u01b0\u1ee3c bi\u1ec3u \u0111\u1ed3 l\u00e0 d\u1eef li\u1ec7u ph\u1ea3i l\u00e0 d\u1ea1ng \u0111\u00e3 \u0111\u01b0\u1ee3c t\u1ed5ng h\u1ee3p, kh\u00f4ng ph\u1ea3i nguy\u00ean li\u1ec7u th\u00f4. Trong v\u00ed d\u1ee5 tr\u00ean ch\u00fang ta th\u1ea5y d\u1eef li\u1ec7u \u0111ang \u1edf d\u1ea1ng th\u00f4, ch\u01b0a qua x\u1eed l\u00fd:<\/p>\n<ul>\n<li>C\u00e1c nh\u00e2n vi\u00ean c\u00f3 s\u1ef1 l\u1eb7p l\u1ea1i. Khi t\u1ed5ng h\u1ee3p th\u00ec c\u00e1c nh\u00e2n vi\u00ean ch\u1ec9 xu\u1ea5t hi\u1ec7n 1 l\u1ea7n trong b\u00e1o c\u00e1o.<\/li>\n<li>Ch\u01b0a c\u00f3 d\u1eef li\u1ec7u d\u1ea1ng %. Ph\u1ea3i t\u00ednh to\u00e1n \u0111\u1ec3 ra \u0111\u01b0\u1ee3c d\u1ea1ng d\u1eef li\u1ec7u n\u00e0y.<\/li>\n<\/ul>\n<p>\u0110\u1ec3 t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 l\u00e0m theo c\u00e1ch sau:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"1_Loc_bo_cac_gia_tri_trung_trong_cot_Nhan_vien\"><\/span>1. L\u1ecdc b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng trong c\u1ed9t Nh\u00e2n vi\u00ean<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n:<\/p>\n<ul>\n<li>Copy c\u1ed9t Nh\u00e2n vi\u00ean sang c\u1ed9t D (l\u00e0 1 c\u1ed9t tr\u1ed1ng)<\/li>\n<li>T\u1ea1i c\u1ed9t D ch\u1ecdn ch\u1ee9c n\u0103ng\u00a0<strong>Remove Duplicates<\/strong>\u00a0trong th\u1ebb\u00a0<strong>Data<\/strong><\/li>\n<li>Sau khi th\u1ef1c hi\u1ec7n ch\u1ee9c n\u0103ng\u00a0<strong>Remove Duplicates<\/strong>\u00a0th\u00ec k\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/li>\n<\/ul>\n<figure id=\"attachment_20283\" aria-describedby=\"caption-attachment-20283\" style=\"width: 1091px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20283 size-full\" title=\"L\u1ecdc b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng trong c\u1ed9t\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/loc-du-lieu-trung-voi-data-remove-duplicates.png\" alt=\"L\u1ecdc b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng trong c\u1ed9t\" width=\"1091\" height=\"552\"><figcaption id=\"caption-attachment-20283\" class=\"wp-caption-text\">L\u1ecdc b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng trong c\u1ed9t<\/figcaption><\/figure>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-ky-thuat-loai-bo-gia-tri-trung-lap-trong-danh-sach-excel.html\">H\u01b0\u1edbng d\u1eabn k\u1ef9 thu\u1eadt lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p trong danh s\u00e1ch Excel<\/a><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-206.gif\" title=\"ex101_92019-nho-206\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"2_Tinh_ket_qua_doanh_so_theo_tung_nhan_vien\"><\/span>2. T\u00ednh k\u1ebft qu\u1ea3 doanh s\u1ed1 theo t\u1eebng nh\u00e2n vi\u00ean<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Tr\u01b0\u1eddng h\u1ee3p n\u00e0y t\u00ednh theo \u0111i\u1ec1u ki\u1ec7n t\u00ean nh\u00e2n vi\u00ean, do \u0111\u00f3 s\u1eed d\u1ee5ng\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-sumif-tinh-tong-excel.html\">h\u00e0m SUMIF<\/a><\/strong>\u00a0\u0111\u1ec3 t\u00ednh:<\/p>\n<p>C\u1ea5u tr\u00fac h\u00e0m =SUMIF(range,criteria,sum_range)<\/p>\n<ul>\n<li>range: c\u1ed9t Nh\u00e2n vi\u00ean (c\u1ed9t A) l\u00e0 n\u01a1i ch\u1ee9a \u0111i\u1ec1u ki\u1ec7n T\u00ean nh\u00e2n vi\u00ean<\/li>\n<li>criteria: \u0111i\u1ec1u ki\u1ec7n t\u00ean nh\u00e2n vi\u00ean t\u1ea1i c\u1ed9t D.<\/li>\n<li>sum_range: v\u00f9ng t\u00ednh t\u1ed5ng l\u00e0 c\u1ed9t Doanh s\u1ed1 (c\u1ed9t B)<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<figure id=\"attachment_20284\" aria-describedby=\"caption-attachment-20284\" style=\"width: 838px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20284 size-full\" title=\"Ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t k\u1ebft h\u1ee3p \u0111\u01b0\u1eddng\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tong-hop-du-lieu-bang-sumif-truoc-khi-ve-bieu-do.png\" alt=\"Ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t k\u1ebft h\u1ee3p \u0111\u01b0\u1eddng\" width=\"838\" height=\"345\"><figcaption id=\"caption-attachment-20284\" class=\"wp-caption-text\">Ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t k\u1ebft h\u1ee3p \u0111\u01b0\u1eddng<\/figcaption><\/figure>\n<p>Trong b\u1ea3ng k\u1ebft qu\u1ea3 ta th\u1ea5y:<\/p>\n<ul>\n<li>D\u1eef li\u1ec7u c\u00f3 s\u1ef1 ch\u00eanh l\u1ec7ch l\u1edbn khi s\u1ed1 th\u1ea5p nh\u1ea5t l\u00e0 10, s\u1ed1 l\u1edbn nh\u1ea5t l\u00e0 260 (g\u1ea5p 26 l\u1ea7n)<\/li>\n<li>D\u1eef li\u1ec7u ch\u01b0a \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"3_Sap_xep_du_lieu_theo_thu_tu\"><\/span>3. S\u1eafp x\u1ebfp d\u1eef li\u1ec7u theo th\u1ee9 t\u1ef1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 thu\u1eadn l\u1ee3i h\u01a1n trong vi\u1ec7c v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t, ch\u00fang ta c\u1ea7n s\u1eafp x\u1ebfp l\u1ea1i d\u1eef li\u1ec7u theo th\u1ee9 t\u1ef1. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y th\u1ee9 t\u1ef1 s\u1eafp x\u1ebfp l\u00e0 t\u1eeb l\u1edbn \u0111\u1ebfn nh\u1ecf.<\/p>\n<p>C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n:<\/p>\n<ul>\n<li>Ch\u1ecdn b\u1ea3ng d\u1eef li\u1ec7u t\u1ed5ng h\u1ee3p (c\u00f3 bao g\u1ed3m d\u00f2ng ti\u00eau \u0111\u1ec1)<\/li>\n<li>Trong th\u1ebb Data ch\u1ecdn Sort<\/li>\n<li>Trong b\u1ea3ng Sort ch\u1ecdn c\u1ed9t c\u1ea7n s\u1eafp x\u1ebfp l\u00e0 c\u1ed9t Doanh s\u1ed1. Th\u1ee9 t\u1ef1 s\u1eafp x\u1ebfp l\u00e0 t\u1eeb l\u1edbn \u0111\u1ebfn nh\u1ecf (Largest to Smallest)<\/li>\n<\/ul>\n<figure id=\"attachment_20287\" aria-describedby=\"caption-attachment-20287\" style=\"width: 946px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20287 size-full\" title=\"Ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t k\u1ebft h\u1ee3p \u0111\u01b0\u1eddng 1\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data-sap-xep-theo-thu-tu-truoc-khi-ve-bieu-do.png\" alt=\"Ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t k\u1ebft h\u1ee3p \u0111\u01b0\u1eddng 1\" width=\"946\" height=\"336\"><figcaption id=\"caption-attachment-20287\" class=\"wp-caption-text\">Ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t k\u1ebft h\u1ee3p \u0111\u01b0\u1eddng 1<\/figcaption><\/figure>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/sap-xep-du-lieu-theo-nhieu-dieu-kien-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eafp x\u1ebfp d\u1eef li\u1ec7u theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_Tinh_phan_tram_doanh_so_cua_moi_nhan_vien\"><\/span>4. T\u00ednh ph\u1ea7n tr\u0103m doanh s\u1ed1 c\u1ee7a m\u1ed7i nh\u00e2n vi\u00ean<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 t\u00ednh % doanh s\u1ed1 c\u1ee7a m\u1ed7i nh\u00e2n vi\u00ean trong t\u1ed5ng s\u1ed1 c\u1ea3 c\u00f4ng ty, ch\u00fang ta s\u1ebd c\u1ea7n th\u00eam d\u00f2ng T\u1ed5ng c\u1ed9ng.<\/p>\n<p>%doanh s\u1ed1 m\u1ed7i nh\u00e2n vi\u00ean = Doanh s\u1ed1 c\u1ee7a nh\u00e2n vi\u00ean \/ T\u1ed5ng doanh s\u1ed1 c\u1ea3 c\u00f4ng ty<\/p>\n<p>D\u1ef1a theo nguy\u00ean t\u1eafc n\u00e0y ch\u00fang ta t\u1ea1o th\u00eam c\u1ed9t T\u1ef7 l\u1ec7 v\u00e0 t\u00ednh nh\u01b0 sau:<\/p>\n<figure id=\"attachment_20310\" aria-describedby=\"caption-attachment-20310\" style=\"width: 610px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20310 size-full\" title=\"Ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t k\u1ebft h\u1ee3p \u0111\u01b0\u1eddng 2\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bang-tinh-ty-le.png\" alt=\"Ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t k\u1ebft h\u1ee3p \u0111\u01b0\u1eddng 2\" width=\"610\" height=\"390\"><figcaption id=\"caption-attachment-20310\" class=\"wp-caption-text\">Ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t k\u1ebft h\u1ee3p \u0111\u01b0\u1eddng 2<\/figcaption><\/figure>\n<p>L\u01b0u \u00fd: Ph\u1ea3i \u0111\u1ecbnh d\u1ea1ng cho d\u1eef li\u1ec7u trong c\u1ed9t t\u1ef7 l\u1ec7 l\u00e0 d\u1ea1ng Percentage (%), c\u00f3 th\u1ec3 c\u00f3 2 s\u1ed1 sau d\u1ea5u th\u1eadp ph\u00e2n.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Lua_chon_bieu_do_va_ve_bieu_do\"><\/span>L\u1ef1a ch\u1ecdn bi\u1ec3u \u0111\u1ed3 v\u00e0 v\u1ebd bi\u1ec3u \u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Nhan_dang_bieu_do\"><\/span>Nh\u1eadn d\u1ea1ng bi\u1ec3u \u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u1edbi y\u00eau c\u1ea7u v\u1ebd bi\u1ec3u \u0111\u1ed3 v\u1eeba bao g\u1ed3m d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1, v\u1eeba c\u00f3 d\u1eef li\u1ec7u d\u1ea1ng % th\u00ec ch\u00fang ta h\u00ecnh dung t\u1edbi lo\u1ea1i bi\u1ec3u \u0111\u1ed3 h\u1ed7n h\u1ee3p. Trong m\u00f4n \u0111\u1ecba l\u00fd ch\u00fang ta th\u01b0\u1eddng bi\u1ebft t\u1edbi lo\u1ea1i bi\u1ec3u \u0111\u1ed3 h\u1ed7n h\u1ee3p gi\u1eefa \u0111\u1ed9 \u1ea9m (%) v\u1edbi l\u01b0\u1ee3ng m\u01b0a (mm \u2013 l\u00e0 d\u1ea1ng s\u1ed1). D\u1ea1ng bi\u1ec3u \u0111\u1ed3 \u0111\u00f3 trong Excel n\u1eb1m \u1edf m\u1ee5c Combo Chart<\/p>\n<p>Trong th\u1ebb <strong>Insert<\/strong>, ch\u1ecdn t\u1edbi nh\u00f3m <strong>Chart<\/strong> (bi\u1ec3u \u0111\u1ed3) v\u00e0 ch\u1ecdn <strong>Combo Chart<\/strong><\/p>\n<figure id=\"attachment_20311\" aria-describedby=\"caption-attachment-20311\" style=\"width: 795px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20311 size-full\" title=\"L\u1ef1a ch\u1ecdn bi\u1ec3u \u0111\u1ed3 v\u00e0 v\u1ebd bi\u1ec3u \u0111\u1ed3\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/insert-combo-chart.png\" alt=\"L\u1ef1a ch\u1ecdn bi\u1ec3u \u0111\u1ed3 v\u00e0 v\u1ebd bi\u1ec3u \u0111\u1ed3\" width=\"795\" height=\"230\"><figcaption id=\"caption-attachment-20311\" class=\"wp-caption-text\">L\u1ef1a ch\u1ecdn bi\u1ec3u \u0111\u1ed3 v\u00e0 v\u1ebd bi\u1ec3u \u0111\u1ed3<\/figcaption><\/figure>\n<p>Trong d\u1ea1ng n\u00e0y ch\u00fang ta th\u1ea5y c\u00f3 g\u1ee3i \u00fd v\u1ec1 d\u1ea1ng <strong>bi\u1ec3u \u0111\u1ed3c\u1ed9t<\/strong>, v\u1eeba c\u00f3 \u0111\u01b0\u1eddng bi\u1ec3u di\u1ec5n.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_ve_bieu_do_cot_trong_Excel\"><\/span>C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Th\u1ef1c t\u1ebf th\u00ec b\u1ea1n c\u00f3 th\u1ec3 v\u1ebd bi\u1ec3u \u0111\u1ed3 n\u00e0y theo 2 c\u00e1ch:<\/p>\n<ul>\n<li>C\u00e1ch 1: V\u1ebd tr\u1ef1c ti\u1ebfp t\u1eeb Combo Chart (d\u1ea1ng th\u1ee9 2). Ch\u1ee9c n\u0103ng n\u00e0y \u00e1p d\u1ee5ng t\u1eeb Excel 2013 tr\u1edf \u0111i.<\/li>\n<li>C\u00e1ch 2: V\u1ebd t\u1eeb d\u1ea1ng bi\u1ec3u \u0111\u1ed3 h\u00ecnh c\u1ed9t th\u00f4ng th\u01b0\u1eddng, sau \u0111\u00f3 ch\u00fang ta s\u1ebd t\u00f9y bi\u1ebfn n\u00f3 v\u1ec1 d\u1ea1ng Combo Chart. \u00c1p d\u1ee5ng cho m\u1ecdi phi\u00ean b\u1ea3n Excel.<\/li>\n<\/ul>\n<p>C\u00e1ch 1 nhanh h\u01a1n v\u00e0 d\u1ec5 d\u00e0ng h\u01a1n nhi\u1ec1u. Nh\u01b0ng trong tr\u01b0\u1eddng h\u1ee3p kh\u00f4ng c\u00f3 phi\u00ean b\u1ea3n Excel 2013, 2016 th\u00ec l\u00e0m th\u1ebf n\u00e0o? Sau \u0111\u00e2y ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch th\u1ee9 2 nh\u00e9.<\/p>\n<p>B\u1eaft \u0111\u1ea7u b\u1eb1ng vi\u1ec7c ch\u1ecdn b\u1ea3ng d\u1eef li\u1ec7u c\u1ea7n v\u1ebd (v\u00f9ng D1:F10, kh\u00f4ng bao g\u1ed3m d\u00f2ng t\u1ed5ng c\u1ed9ng), trong th\u1ebb<strong> Insert<\/strong> 1 bi\u1ec3u \u0111\u1ed3 h\u00ecnh c\u1ed9t th\u00f4ng th\u01b0\u1eddng:<\/p>\n<figure id=\"attachment_20312\" aria-describedby=\"caption-attachment-20312\" style=\"width: 1097px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20312 size-full\" title=\"C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t k\u1ebft h\u1ee3p \u0111\u01b0\u1eddng\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cac-buoc-ve-bieu-do-cot-thong-thuong.png\" alt=\"C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t k\u1ebft h\u1ee3p \u0111\u01b0\u1eddng\" width=\"1097\" height=\"739\"><figcaption id=\"caption-attachment-20312\" class=\"wp-caption-text\">C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t k\u1ebft h\u1ee3p \u0111\u01b0\u1eddng<\/figcaption><\/figure>\n<p>K\u1ebft qu\u1ea3 ch\u00fang ta c\u00f3 \u0111\u01b0\u1ee3c 1 bi\u1ec3u \u0111\u1ed3 h\u00ecnh c\u1ed9t trong \u0111\u00f3:<\/p>\n<figure id=\"attachment_20317\" aria-describedby=\"caption-attachment-20317\" style=\"width: 583px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20317 size-full\" title=\"C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t k\u1ebft h\u1ee3p \u0111\u01b0\u1eddng 2\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bieu-do-hinh-cot-doanh-so-ty-le.png\" alt=\"C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t k\u1ebft h\u1ee3p \u0111\u01b0\u1eddng 2\" width=\"583\" height=\"347\"><figcaption id=\"caption-attachment-20317\" class=\"wp-caption-text\">C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t k\u1ebft h\u1ee3p \u0111\u01b0\u1eddng 2<\/figcaption><\/figure>\n<p>Ph\u1ea7n t\u1ef7 l\u1ec7 chi\u1ebfm ph\u1ea7n r\u1ea5t nh\u1ecf, g\u1ea7n nh\u01b0 kh\u00f3 th\u1ea5y \u0111\u01b0\u1ee3c tr\u00ean bi\u1ec3u \u0111\u1ed3 d\u1ea1ng n\u00e0y.<\/p>\n<p>Khi \u0111\u00f3 ch\u00fang ta ph\u1ea3i ti\u1ebfn h\u00e0nh thay \u0111\u1ed5i ph\u01b0\u01a1ng ph\u00e1p bi\u1ec3u di\u1ec5n ph\u1ea7n t\u1ef7 l\u1ec7 th\u00e0nh d\u1ea1ng \u0111\u01b0\u1eddng bi\u1ec3u di\u1ec5n theo %<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Them_truc_toa_do_vao_ben_phai_bieu_do\"><\/span>Th\u00eam tr\u1ee5c t\u1ecda \u0111\u1ed9 % v\u00e0o b\u00ean ph\u1ea3i bi\u1ec3u \u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Vi\u1ec7c n\u00e0y \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 v\u1ebd bi\u1ec3u \u0111\u1ed3 h\u00ecnh c\u1ed9t trong \u0111\u00f3 c\u00f3 2 tr\u1ee5c tung, 1 tr\u1ee5c ho\u00e0nh. Trong \u0111\u00f3 1 tr\u1ee5c tung bi\u1ec3u di\u1ec5n d\u1ea1ng s\u1ed1, 1 tr\u1ee5c tung bi\u1ec3u di\u1ec5n d\u1ea1ng %. C\u00e1ch th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<ul>\n<li>Ch\u1ecdn m\u1ed9t c\u1ed9t b\u1ea5t k\u1ef3 tr\u00ean c\u1ed9t Doanh s\u1ed1, sau \u0111\u00f3 b\u1ea5m ph\u00edm <strong>Ctrl + M\u0169i t\u00ean l\u00ean<\/strong> \u0111\u1ec3 chuy\u1ec3n sang ch\u1ecdn ph\u1ea7n c\u1ed9t t\u1ef7 l\u1ec7<\/li>\n<li>Click chu\u1ed9t ph\u1ea3i v\u00e0o c\u1ed9t t\u1ef7 l\u1ec7 v\u00e0 ch\u1ecdn <strong>Change Series Chart Type<\/strong><\/li>\n<\/ul>\n<figure id=\"attachment_20319\" aria-describedby=\"caption-attachment-20319\" style=\"width: 607px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20319 size-full\" title=\"Th\u00eam tr\u1ee5c t\u1ecda \u0111\u1ed9 % v\u00e0o b\u00ean ph\u1ea3i bi\u1ec3u \u0111\u1ed3 1\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bieu-do-hinh-cot-change-serie-chart-type.png\" alt=\"Th\u00eam tr\u1ee5c t\u1ecda \u0111\u1ed9 % v\u00e0o b\u00ean ph\u1ea3i bi\u1ec3u \u0111\u1ed3 1\" width=\"607\" height=\"533\"><figcaption id=\"caption-attachment-20319\" class=\"wp-caption-text\">Th\u00eam tr\u1ee5c t\u1ecda \u0111\u1ed9 % v\u00e0o b\u00ean ph\u1ea3i bi\u1ec3u \u0111\u1ed3 1<\/figcaption><\/figure>\n<p>Trong b\u1ea3ng Change Chart Type, ph\u1ea7n T\u1ef7 l\u1ec7 ch\u00fang ta ch\u1ecdn thi\u1ebft l\u1eadp nh\u01b0 sau:<\/p>\n<ul>\n<li><strong>Chart Type<\/strong> l\u00e0 d\u1ea1ng \u0111\u01b0\u1eddng k\u1ebb (Line with Markers = \u0110\u01b0\u1eddng\u00a0n\u1ed1i c\u00e1c \u0111i\u1ec3m tr\u00ean m\u1ed7i c\u1ed9t)<\/li>\n<li><strong>Secondary Axis<\/strong>: \u0111\u00e1nh d\u1ea5u t\u00edch. M\u1ee5c n\u00e0y c\u00f3 ngh\u0129a l\u00e0 t\u1ea1o th\u00eam 1 tr\u1ee5c tung th\u1ee9 2 b\u00ean ph\u1ea3i bi\u1ec3u \u0111\u1ed3.<\/li>\n<\/ul>\n<figure id=\"attachment_20320\" aria-describedby=\"caption-attachment-20320\" style=\"width: 795px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"Th\u00eam tr\u1ee5c t\u1ecda \u0111\u1ed9 % v\u00e0o b\u00ean ph\u1ea3i bi\u1ec3u \u0111\u1ed3 2 wp-image-20320 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bieu-do-hinh-cot-combo-secondary-axis.png\" alt=\"Th\u00eam tr\u1ee5c t\u1ecda \u0111\u1ed9 % v\u00e0o b\u00ean ph\u1ea3i bi\u1ec3u \u0111\u1ed3 2\" width=\"795\" height=\"752\" title=\"bieu-do-hinh-cot-combo-secondary-axis\"><figcaption id=\"caption-attachment-20320\" class=\"wp-caption-text\">Th\u00eam tr\u1ee5c t\u1ecda \u0111\u1ed9 % v\u00e0o b\u00ean ph\u1ea3i bi\u1ec3u \u0111\u1ed3 2<\/figcaption><\/figure>\n<p>Khi thi\u1ebft l\u1eadp ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y m\u1eabu bi\u1ec3u \u0111\u1ed3 th\u1ec3 hi\u1ec7n ngay ph\u00eda tr\u00ean. Khi \u0111\u00e3 th\u1ef1c hi\u1ec7n xong vi\u1ec7c thi\u1ebft l\u1eadp, b\u1ea5m OK \u0111\u1ec3 ho\u00e0n t\u1ea5t bi\u1ec3u \u0111\u1ed3:<\/p>\n<figure id=\"attachment_20321\" aria-describedby=\"caption-attachment-20321\" style=\"width: 1278px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20321 size-full\" title=\"C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t k\u1ebft h\u1ee3p \u0111\u01b0\u1eddng trong excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-bieu-do-ket-hop.png\" alt=\"C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t k\u1ebft h\u1ee3p \u0111\u01b0\u1eddng trong excel\" width=\"1278\" height=\"391\"><figcaption id=\"caption-attachment-20321\" class=\"wp-caption-text\">C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t k\u1ebft h\u1ee3p \u0111\u01b0\u1eddng trong excel<\/figcaption><\/figure>\n<p>Tham kh\u1ea3o kh\u00f3a h\u1ecdc <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia c\u1ee7a H\u1ecdc Excel Online<\/a>. Trong kh\u00f3a h\u1ecdc n\u00e0y b\u1ea1n s\u1ebd v\u1eeba h\u1ecdc \u0111\u01b0\u1ee3c nh\u1eefng ki\u1ebfn th\u1ee9c v\u1ec1 Excel nh\u01b0 c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel, c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3, v\u1eeba bi\u1ebft c\u00e1ch k\u1ebft h\u1ee3p c\u00e1c ki\u1ebfn th\u1ee9c tr\u00ean \u0111\u1ec3 \u00e1p d\u1ee5ng v\u00e0o c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3. H\u00e3y tham gia ngay kh\u00f3a h\u1ecdc \u0111\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c nhi\u1ec1u \u01b0u \u0111\u00e3i t\u1eeb h\u1ec7 th\u1ed1ng H\u1ecdc Excel Online. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">H\u1ecdc Excel 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<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-206.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2665,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2664","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2664","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=2664"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2664\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2665"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2664"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2664"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2664"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}