{"id":10196,"date":"2025-01-10T05:58:39","date_gmt":"2025-01-10T05:58:39","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/10\/huong-dan-cach-lap-bao-cao-tien-do-thuc-hien-cong-viec-bang-pivottable-tren-excel\/"},"modified":"2025-01-10T05:58:39","modified_gmt":"2025-01-10T05:58:39","slug":"huong-dan-cach-lap-bao-cao-tien-do-thuc-hien-cong-viec-bang-pivottable-tren-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/10\/huong-dan-cach-lap-bao-cao-tien-do-thuc-hien-cong-viec-bang-pivottable-tren-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp b\u00e1o c\u00e1o % ti\u1ebfn \u0111\u1ed9 th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c b\u1eb1ng PivotTable tr\u00ean Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong c\u00f4ng vi\u1ec7c qu\u1ea3n l\u00fd KPI, theo d\u00f5i ti\u1ebfn \u0111\u1ed9 c\u00f4ng vi\u1ec7c, ch\u00fang ta th\u01b0\u1eddng hay ph\u1ea3i s\u1eed d\u1ee5ng bi\u1ec3u \u0111\u1ed3 \u0111\u1ec3 theo d\u00f5i, \u0111\u00e1nh gi\u00e1. Vi\u1ec7c n\u00e0y gi\u00fap theo d\u00f5i m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng v\u00e0 tr\u1ef1c quan h\u01a1n. Nh\u01b0ng c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 cho vi\u1ec7c n\u00e0y nh\u01b0 th\u1ebf n\u00e0o? \u0110\u1ec3 c\u00f3 th\u1ec3 \u0111i \u0111\u1ebfn \u0111\u00edch cu\u1ed1i c\u00f9ng l\u00e0 ho\u00e0n th\u00e0nh \u0111\u01b0\u1ee3c bi\u1ec3u \u0111\u1ed3, ch\u00fang ta c\u1ea7n th\u1ef1c hi\u1ec7n theo 2 b\u01b0\u1edbc:<\/p>\n<ul>\n<li>B\u01b0\u1edbc 1 :\u00a0L\u1eadp b\u1ea3ng b\u00e1o c\u00e1o\u00a0% ti\u1ebfn \u0111\u1ed9 th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c b\u1eb1ng PivotTable<\/li>\n<li>B\u01b0\u1edbc\u00a02: V\u1ebd bi\u1ec3u \u0111\u1ed3 th\u1ec3 hi\u1ec7n % ti\u1ebfn \u0111\u1ed9 th\u1ef1c hi\u1ec7n<\/li>\n<\/ul>\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch l\u1eadp b\u1ea3ng b\u00e1o c\u00e1o\u00a0% ti\u1ebfn \u0111\u1ed9 th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c b\u1eb1ng PivotTable nh\u00e9.<\/p>\n<p>M\u1ee5c \u0111\u00edch c\u1ee7a ch\u00fang ta l\u00e0 t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21156\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/data-ve-bieu-do-tron-tien-do.png\" width=\"783\" height=\"235\" title=\"data-ve-bieu-do-tron-tien-do\"><\/p>\n<p>K\u00e8m theo \u0111\u00f3 l\u00e0 1 b\u1ea3ng v\u1ec1 ch\u1ec9 ti\u00eau k\u1ebf ho\u1ea1ch theo t\u1eebng nh\u00e2n vi\u00ean, cho t\u1eebng khu v\u1ef1c:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21160\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/data-chi-tieu-ke-hoach.png\" width=\"758\" height=\"225\" title=\"data-chi-tieu-ke-hoach\"><\/p>\n<p>D\u1ef1a v\u00e0o 2 b\u1ea3ng tr\u00ean, x\u00e1c \u0111\u1ecbnh % th\u1ef1c hi\u1ec7n k\u1ebf ho\u1ea1ch c\u1ee7a t\u1eebng nh\u00e2n vi\u00ean, trong \u0111\u00f3 m\u1ed7i nh\u00e2n vi\u00ean \u0111\u1ec1u th\u1ec3 hi\u1ec7n \u0111\u01b0\u1ee3c 3 khu v\u1ef1c.<\/p>\n<p>Tr\u01b0\u1edbc khi b\u1eaft \u0111\u1ea7u, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i v\u1ec1 file m\u1eabu \u0111\u1ec3 th\u1ef1c hi\u1ec7n theo h\u01b0\u1edbng d\u1eabn trong b\u00e0i gi\u1ea3ng n\u00e0y t\u1ea1i \u0111\u1ecba ch\u1ec9:\u00a0<a href=\"http:\/\/bit.ly\/2KLL4B0\">http:\/\/bit.ly\/2KLL4B0<\/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\/2025\/01\/ex101_92019-nho-141.gif\" title=\"ex101_92019-nho-141\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-6780b70e9ea25\" 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-lap-bao-cao-tien-do-thuc-hien-cong-viec-bang-pivot-table-tren-excel.html#Lap_bao_cao_doanh_thu_nhan_vien_theo_khu_vuc_bang_PivotTable\" title=\"L\u1eadp b\u00e1o c\u00e1o doanh thu nh\u00e2n vi\u00ean theo khu v\u1ef1c b\u1eb1ng PivotTable\">L\u1eadp b\u00e1o c\u00e1o doanh thu nh\u00e2n vi\u00ean theo khu v\u1ef1c b\u1eb1ng PivotTable<\/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-lap-bao-cao-tien-do-thuc-hien-cong-viec-bang-pivot-table-tren-excel.html#Lap_cong_thuc_xac_dinh_doanh_thu_KE_HOACH\" title=\"L\u1eadp c\u00f4ng th\u1ee9c x\u00e1c \u0111\u1ecbnh doanh thu K\u1ebe HO\u1ea0CH\">L\u1eadp c\u00f4ng th\u1ee9c x\u00e1c \u0111\u1ecbnh doanh thu K\u1ebe HO\u1ea0CH<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-lap-bao-cao-tien-do-thuc-hien-cong-viec-bang-pivot-table-tren-excel.html#Chuyen_doi_ket_qua_tinh_hinh_thuc_hien_ke_hoach_ve_dang\" title=\"Chuy\u1ec3n \u0111\u1ed5i k\u1ebft qu\u1ea3 t\u00ecnh h\u00ecnh th\u1ef1c hi\u1ec7n \/ k\u1ebf ho\u1ea1ch v\u1ec1 d\u1ea1ng %\">Chuy\u1ec3n \u0111\u1ed5i k\u1ebft qu\u1ea3 t\u00ecnh h\u00ecnh th\u1ef1c hi\u1ec7n \/ k\u1ebf ho\u1ea1ch v\u1ec1 d\u1ea1ng %<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Lap_bao_cao_doanh_thu_nhan_vien_theo_khu_vuc_bang_PivotTable\"><\/span>L\u1eadp b\u00e1o c\u00e1o doanh thu nh\u00e2n vi\u00ean theo khu v\u1ef1c b\u1eb1ng PivotTable<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 x\u00e1c \u0111\u1ecbnh s\u1ed1 th\u1ef1c hi\u1ec7n c\u1ee7a nh\u00e2n vi\u00ean theo khu v\u1ef1c, ch\u00fang ta c\u1ea7n ph\u1ea3i l\u1eadp 1 b\u1ea3ng b\u00e1o c\u00e1o\u00a0t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u g\u1ed1c.<\/p>\n<p>C\u00e1ch l\u00e0m kh\u00e1 \u0111\u01a1n gi\u1ea3n: S\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/khoi-dau-voi-pivot-table-trong-excel.html\">PivotTable<\/a> \u0111\u1ec3 t\u1ea1o b\u00e1o c\u00e1o.<\/p>\n<p>N\u1ebfu b\u1ea1n ch\u01b0a bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng PivotTable th\u00ec c\u00f3 th\u1ec3 xem t\u1ea1i b\u00e0i vi\u1ebft:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/khoi-dau-voi-pivot-table-trong-excel.html\">https:\/\/blog.hocexcel.online\/khoi-dau-voi-pivot-table-trong-excel.html<\/a><\/p>\n<p>B\u01b0\u1edbc 1: Ch\u1ecdn b\u1ea3ng d\u1eef li\u1ec7u, sau \u0111\u00f3 ch\u1ecdn th\u1ebb Insert \/ PivotTable. C\u00f3 th\u1ec3 \u0111\u1eb7t b\u1ea3ng Pivot Table t\u1ea1i 1 sheet m\u1edbi.<\/p>\n<p>B\u01b0\u1edbc 2: \u0110\u1eb7t c\u00e1c tr\u01b0\u1eddng d\u1eef li\u1ec7u v\u00e0o c\u00e1c v\u1ecb tr\u00ed:<\/p>\n<ul>\n<li><strong>Chi nh\u00e1nh<\/strong> \u0111\u1eb7t v\u00e0o v\u00f9ng <strong>Rows<\/strong><\/li>\n<li><strong>Nh\u00e2n vi\u00ean<\/strong> \u0111\u1eb7t v\u00e0o v\u00f9ng\u00a0<strong>Filter<\/strong><\/li>\n<li><strong>Doanh thu<\/strong> \u0111\u1eb7t v\u00e0o v\u00f9ng <strong>Values<\/strong><\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21161\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/pivottable-doanh-thu-nv-theo-khu-vuc.png\" width=\"687\" height=\"392\" title=\"pivottable-doanh-thu-nv-theo-khu-vuc\"><\/p>\n<p>Khi l\u1ecdc nh\u00e2n vi\u00ean t\u1ea1i B1 th\u00ec ch\u00fang ta s\u1ebd thu \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u00e0 t\u1ed5ng doanh thu theo t\u1eebng chi nh\u00e1nh c\u1ee7a nh\u00e2n vi\u00ean \u0111\u00f3. \u0110\u00e2y l\u00e0 doanh thu <strong>TH\u1ef0C HI\u1ec6N<\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Lap_cong_thuc_xac_dinh_doanh_thu_KE_HOACH\"><\/span>L\u1eadp c\u00f4ng th\u1ee9c x\u00e1c \u0111\u1ecbnh doanh thu K\u1ebe HO\u1ea0CH<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 so s\u00e1nh gi\u1eefa k\u1ebf ho\u1ea1ch v\u00e0 th\u1ef1c hi\u1ec7n, ch\u00fang ta c\u1ea7n l\u1ea5y ra \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u v\u1ec1 s\u1ed1 k\u1ebf ho\u1ea1ch v\u00e0o v\u1ecb tr\u00ed c\u1ed9t b\u00ean c\u1ea1nh c\u1ed9t T\u1ed5ng doanh thu (c\u1ed9t C). C\u0103n c\u1ee9 \u0111\u1ec3 l\u1ea5y l\u00e0 b\u1ea3ng d\u1eef li\u1ec7u trong sheet <strong>Ch\u1ec9 ti\u00eau.<\/strong><\/p>\n<p>\u1ede \u0111\u00e2y c\u00f3 2 \u0111i\u1ec1u ki\u1ec7n: Nh\u00e2n vi\u00ean l\u00e0 t\u00ean nh\u00e2n vi\u00ean \u0111\u01b0\u1ee3c ch\u1ecdn t\u1ea1i \u00f4 B1, chi nh\u00e1nh l\u00e0 theo t\u00ean chi nh\u00e1nh \u1edf c\u1ed9t A.<\/p>\n<p>Do \u0111\u00f3 khi d\u00f9ng h\u00e0m \u0111\u1ec3 tham chi\u1ebfu s\u1ed1 doanh thu\u00a0k\u1ebf ho\u1ea1ch, ch\u00fang ta c\u00f3 th\u1ec3 c\u00f3 2 c\u00e1ch l\u00e0m:<\/p>\n<ul>\n<li>C\u00e1ch 1: D\u00f9ng c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n (v\u00ed d\u1ee5 SUMPRODUCT). B\u1edfi t\u00ean c\u00e1c nh\u00e2n vi\u00ean kh\u00f4ng tr\u00f9ng nhau, do \u0111\u00f3 m\u1ed7i nh\u00e2n vi\u00ean t\u1ea1i 1 chi nh\u00e1nh ch\u1ec9 c\u00f3 1 k\u1ebft qu\u1ea3 n\u00ean\u00a0k\u1ebft qu\u1ea3 t\u00ednh t\u1ed5ng s\u1ebd t\u01b0\u01a1ng \u1ee9ng v\u1edbi k\u1ebft qu\u1ea3 t\u1ea1o b\u1edfi c\u00f4ng th\u1ee9c tham chi\u1ebfu.<\/li>\n<li>C\u00e1ch 2: D\u00f9ng c\u00f4ng th\u1ee9c tham chi\u1ebfu (v\u00ed d\u1ee5 VLOOKUP). Trong \u0111\u00f3 ch\u00fang ta c\u1ea7n ph\u1ea3i t\u00f9y bi\u1ebfn v\u1ecb tr\u00ed c\u1ed9t k\u1ebft qu\u1ea3 theo t\u00ean c\u1ee7a Khu v\u1ef1c.<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5 t\u1ea1i c\u1ed9t C d\u00f9ng theo c\u00f4ng th\u1ee9c SUMPRODUCT, c\u1ed9t D d\u00f9ng theo c\u00f4ng th\u1ee9c VLOOKUP k\u1ebft h\u1ee3p MATCH, ch\u00fang ta c\u00f3:<\/p>\n<ul>\n<li>C4=SUMPRODUCT(($B$1=\u2019Ch\u1ec9 ti\u00eau\u2019!$A$2:$A$5)*($A4=\u2019Ch\u1ec9 ti\u00eau\u2019!$B$1:$D$1)*(\u2018Ch\u1ec9 ti\u00eau\u2019!$B$2:$D$5))<\/li>\n<li>D4=VLOOKUP($B$1,\u2019Ch\u1ec9 ti\u00eau\u2019!$A$1:$D$5,MATCH($A4,\u2019Ch\u1ec9 ti\u00eau\u2019!$A$1:$D$1,0),0)<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21162\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cong-thuc-xac-dinh-doanh-thu-ke-hoach.png\" width=\"537\" height=\"188\" title=\"cong-thuc-xac-dinh-doanh-thu-ke-hoach\"><\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta th\u1ea5y d\u00f9 d\u00f9ng c\u00f4ng th\u1ee9c n\u00e0o th\u00ec v\u1eabn ra \u0111\u00fang k\u1ebft qu\u1ea3.<\/p>\n<p><strong>Ch\u00fa \u00fd:<\/strong><\/p>\n<p>Trong b\u1ea3ng k\u1ebf ho\u1ea1ch \u0111\u01b0\u1ee3c t\u1ed5 ch\u1ee9c d\u1ea1ng b\u1ea3ng 2 chi\u1ec1u, v\u00ec v\u1eady \u0111\u1ec3 c\u00f3 th\u1ec3 x\u00e1c \u0111\u1ecbnh k\u1ebft qu\u1ea3 c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT \u0111\u1ec3 t\u00ednh d\u1ea1ng m\u1ea3ng 2 chi\u1ec1u.<\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u l\u1ea1i ki\u1ebfn th\u1ee9c v\u1ec1 c\u00e1c h\u00e0m n\u00e0y t\u1ea1i b\u00e0i vi\u1ebft:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html\">Ha\u0300m SUMPRODUCT trong Excel va\u0300 m\u00f4\u0323t s\u00f4\u0301 vi\u0301 vu\u0323 c\u00f4ng th\u01b0\u0301c<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-ham-vlookup-match.html\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup Match<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Chuyen_doi_ket_qua_tinh_hinh_thuc_hien_ke_hoach_ve_dang\"><\/span>Chuy\u1ec3n \u0111\u1ed5i k\u1ebft qu\u1ea3 t\u00ecnh h\u00ecnh th\u1ef1c hi\u1ec7n \/ k\u1ebf ho\u1ea1ch v\u1ec1 d\u1ea1ng %<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 v\u1ebd \u0111\u01b0\u1ee3c \u0111\u00fang d\u1ea1ng bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n, ch\u00fang ta c\u00f3 th\u1ec3 chuy\u1ec3n d\u1eef li\u1ec7u v\u1ec1 d\u1ea1ng % \u0111\u1ec3 c\u00f3 th\u1ec3 bi\u1ec3u di\u1ec5n 1 c\u00e1ch ch\u00ednh x\u00e1c.<\/p>\n<p>C\u00e1ch t\u00ednh nh\u01b0 sau:<\/p>\n<p>% th\u1ef1c hi\u1ec7n = s\u1ed1 th\u1ef1c hi\u1ec7n \/ S\u1ed1 k\u1ebf ho\u1ea1ch<\/p>\n<p>% ch\u01b0a th\u1ef1c hi\u1ec7n = 1 \u2013 % th\u1ef1c hi\u1ec7n<\/p>\n<p>Ch\u00fang ta c\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 sau (s\u1eed d\u1ee5ng 1 trong 2 k\u1ebft qu\u1ea3 \u1edf c\u1ed9t C ho\u1eb7c D)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21163\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tinh-phan-tram-thuc-hien-ke-hoach-1.png\" width=\"748\" height=\"187\" title=\"tinh-phan-tram-thuc-hien-ke-hoach-1\"><\/p>\n<p>Ch\u00fa \u00fd: \u1ede \u0111\u00e2y ch\u00fang ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c t\u1ea1i \u00f4 E4 l\u00e0<\/p>\n<p style=\"padding-left: 30px\">E4=B4\/C4<\/p>\n<p>C\u00e1c b\u1ea1n vi\u1ebft tr\u1ef1c ti\u1ebfp ch\u1eef B4 thay v\u00ec b\u1ea5m ch\u1ecdn \u0111\u1ecba ch\u1ec9 \u00f4 B4, b\u1edfi vi\u1ec7c b\u1ea5m ch\u1ecdn \u0111\u00f3 s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 GetPivotTable_Value, n\u00ean sinh ra 1 d\u00f2ng l\u1ec7nh kh\u00e1 d\u00e0i. Thay v\u00ec v\u1eady c\u00f3 th\u1ec3 vi\u1ebft 1 d\u00f2ng l\u1ec7nh ng\u1eafn, \u0111\u01a1n gi\u1ea3n h\u01a1n l\u00e0 B4\/c4<\/p>\n<p>Nh\u01b0 v\u1eady l\u00e0 ch\u00fang ta \u0111\u00e3 ho\u00e0n th\u00e0nh ph\u1ea7n x\u1eed l\u00fd d\u1eef li\u1ec7u r\u1ed3i.<\/p>\n<p>Trong b\u00e0i ti\u1ebfp theo ch\u00fang ta s\u1ebd c\u00f9ng t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 th\u1ec3 hi\u1ec7n t\u00ecnh h\u00ecnh th\u1ef1c hi\u1ec7n k\u1ebf ho\u1ea1ch theo KPI h\u00ecnh tr\u00f2n nh\u00e9.<\/p>\n<p>M\u1eddi c\u00e1c b\u1ea1n xem ti\u1ebfp b\u00e0i vi\u1ebft t\u1ea1i \u0111\u1ecba ch\u1ec9:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-ve-bieu-hinh-tron-thuc-hien-ke-hoach-tren-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n % th\u1ef1c hi\u1ec7n k\u1ebf ho\u1ea1ch tr\u00ean Excel<\/a><\/p>\n<p>B\u1ea1n c\u00f3 g\u1eb7p kh\u00f3 kh\u0103n trong vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c h\u00e0m c\u1ee7a Excel kh\u00f4ng?\u00a0Mu\u1ed1n hi\u1ec3u r\u00f5 v\u1ec1 c\u00e1c h\u00e0m trong Excel, s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel, b\u1ea1n c\u00f3 th\u1ec3 tham gia kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2P4mlva\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia d\u00e0nh cho ng\u01b0\u1eddi \u0111i l\u00e0m<\/a>\u00a0c\u1ee7a h\u1ec7 th\u1ed1ng H\u1ecdc Excel Online. Trong kh\u00f3a h\u1ecdc n\u00e0y b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c h\u1ecdc c\u00e1c ki\u1ebfn th\u1ee9c v\u1ec1 c\u00e1ch\u00a0vi\u1ebft\u00a0c\u00e1c h\u00e0m t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao, c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5 trong Excel, s\u1eed d\u1ee5ng PivotTable, v\u1ebd bi\u1ec3u \u0111\u1ed3\u2026 r\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c h\u1eefu \u00edch v\u00e0 c\u1ea7n thi\u1ebft trong c\u00f4ng vi\u1ec7c h\u00e0ng n\u00e0y.<\/p>\n<p>M\u1ed9t \u0111i\u1ec1u h\u1ea5p d\u1eabn n\u1eefa l\u00e0 hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i cho b\u1ea1n khi \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. Chi ti\u1ebft xem t\u1ea1i:<\/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\/2025\/01\/ex101_92019-nho-141.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10197,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10196","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\/10196","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=10196"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10196\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10197"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10196"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10196"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}