{"id":3890,"date":"2024-12-03T20:33:35","date_gmt":"2024-12-03T20:33:35","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/ung-dung-power-query-xay-dung-mo-hinh-du-lieu-phan-tich-nang-suat-lao-dong-phan-4\/"},"modified":"2024-12-03T20:33:35","modified_gmt":"2024-12-03T20:33:35","slug":"ung-dung-power-query-xay-dung-mo-hinh-du-lieu-phan-tich-nang-suat-lao-dong-phan-4","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/ung-dung-power-query-xay-dung-mo-hinh-du-lieu-phan-tich-nang-suat-lao-dong-phan-4\/","title":{"rendered":"\u1ee8ng d\u1ee5ng Power Query x\u00e2y d\u1ef1ng m\u00f4 h\u00ecnh d\u1eef li\u1ec7u ph\u00e2n t\u00edch n\u0103ng su\u1ea5t lao \u0111\u1ed9ng \u2013 Ph\u1ea7n 4"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Qua 2 ph\u1ea7n tr\u01b0\u1edbc, ch\u00fang ta\u00a0\u0111\u00e3\u00a0\u1ee9ng d\u1ee5ng Power Query\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 t\u00e1i c\u1ea5u tr\u00fac b\u1ea3ng d\u1eef li\u1ec7u, gi\u00fap x\u00e2y d\u1ef1ng b\u1ea3ng d\u1eef li\u1ec7u\u00a0\u0111\u00fang chu\u1ea9n,\u00a0\u0111\u1ed3ng th\u1eddi g\u1ed9p d\u1eef li\u1ec7u t\u1eeb 3 b\u1ea3ng v\u00e0o chung 1 b\u1ea3ng. B\u1ea1n c\u00f3 th\u1ec3 xem l\u1ea1i c\u00e1c ph\u1ea7n t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ung-dung-power-query-xay-dung-mo-hinh-du-lieu-phan-tich-nang-suat-lao-dong-phan-1.html\">Ph\u1ea7n 1:\u00a0T\u00e1i c\u1ea5u tr\u00fac b\u1ea3ng d\u1eef li\u1ec7u\u00a0\u0111\u00fang ti\u00eau chu\u1ea9n<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ung-dung-power-query-xay-dung-mo-hinh-du-lieu-phan-tich-nang-suat-lao-dong-phan-2.html\">Ph\u1ea7n 2:\u00a0G\u1ed9p c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u v\u00e0o 1 b\u1ea3ng duy nh\u1ea5t<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ung-dung-power-query-xay-dung-mo-hinh-du-lieu-phan-tich-nang-suat-lao-dong-phan-3.html\">Ph\u1ea7n 3:\u00a0T\u1ea1o th\u00eam c\u00e1c gi\u00e1 tr\u1ecb b\u1eb1ng\u00a0c\u00f4ng th\u1ee9c t\u00ednh trong Power Query<\/a><\/p>\n<p>File k\u1ebft qu\u1ea3 sau\u00a03 ph\u1ea7n \u2013\u00a0 Link t\u1ea3i file:\u00a0<a href=\"http:\/\/bit.ly\/33hR3XW\">http:\/\/bit.ly\/33hR3XW<\/a><\/p>\n<p>Trong ph\u1ea7n n\u00e0y, ch\u00fang ta s\u1ebd c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng Pivot Table v\u00e0 Pivot Chart\u00a0\u0111\u1ec3 l\u1eadp b\u00e1o c\u00e1o ph\u00e2n t\u00edch k\u1ebft qu\u1ea3 n\u0103ng su\u1ea5t lao\u00a0\u0111\u1ed9ng. L\u01b0u\u00a0\u00fd r\u1eb1ng vi\u1ec7c n\u00e0y ch\u1ec9 th\u1ef1c hi\u1ec7n\u00a0\u0111\u01b0\u1ee3c sau khi ch\u00fang ta\u00a0\u0111\u00e3 ho\u00e0n th\u00e0nh 3 ph\u1ea7n tr\u00ean.<\/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-674f6b1de515e\" 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\/ung-dung-power-query-xay-dung-mo-hinh-du-lieu-phan-tich-nang-suat-lao-dong-phan-4.html#Phan_4_Xay_dung_bao_cao_phan_tich_du_lieu\" title=\"Ph\u1ea7n 4: X\u00e2y d\u1ef1ng b\u00e1o c\u00e1o ph\u00e2n t\u00edch d\u1eef li\u1ec7u\">Ph\u1ea7n 4: X\u00e2y d\u1ef1ng b\u00e1o c\u00e1o ph\u00e2n t\u00edch d\u1eef li\u1ec7u<\/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-2\" href=\"https:\/\/blog.hocexcel.online\/ung-dung-power-query-xay-dung-mo-hinh-du-lieu-phan-tich-nang-suat-lao-dong-phan-4.html#Dac_diem_cua_bao_cao_phan_tich_du_lieu\" title=\"\u0110\u1eb7c\u00a0\u0111i\u1ec3m c\u1ee7a b\u00e1o c\u00e1o ph\u00e2n t\u00edch d\u1eef li\u1ec7u\">\u0110\u1eb7c\u00a0\u0111i\u1ec3m c\u1ee7a b\u00e1o c\u00e1o ph\u00e2n t\u00edch d\u1eef li\u1ec7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ung-dung-power-query-xay-dung-mo-hinh-du-lieu-phan-tich-nang-suat-lao-dong-phan-4.html#Cach_lap_bao_cao_phan_tich_du_lieu_tren_Excel\" title=\"C\u00e1ch l\u1eadp b\u00e1o c\u00e1o ph\u00e2n t\u00edch d\u1eef li\u1ec7u tr\u00ean\u00a0Excel\">C\u00e1ch l\u1eadp b\u00e1o c\u00e1o ph\u00e2n t\u00edch d\u1eef li\u1ec7u tr\u00ean\u00a0Excel<\/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\/ung-dung-power-query-xay-dung-mo-hinh-du-lieu-phan-tich-nang-suat-lao-dong-phan-4.html#Huong_dan_chi_tiet_cach_lap_bao_cao_phan_tich_nang_suat_lao_dong_tren_Excel\" title=\"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch l\u1eadp b\u00e1o c\u00e1o ph\u00e2n t\u00edch n\u0103ng su\u1ea5t lao\u00a0\u0111\u1ed9ng tr\u00ean\u00a0Excel\">H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch l\u1eadp b\u00e1o c\u00e1o ph\u00e2n t\u00edch n\u0103ng su\u1ea5t lao\u00a0\u0111\u1ed9ng tr\u00ean\u00a0Excel<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/ung-dung-power-query-xay-dung-mo-hinh-du-lieu-phan-tich-nang-suat-lao-dong-phan-4.html#Buoc_1_Xac_dinh_cau_truc_bao_cao\" title=\"B\u01b0\u1edbc 1: X\u00e1c\u00a0\u0111\u1ecbnh c\u1ea5u tr\u00fac b\u00e1o c\u00e1o\">B\u01b0\u1edbc 1: X\u00e1c\u00a0\u0111\u1ecbnh c\u1ea5u tr\u00fac b\u00e1o c\u00e1o<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/ung-dung-power-query-xay-dung-mo-hinh-du-lieu-phan-tich-nang-suat-lao-dong-phan-4.html#Buoc_2_Xac_dinh_cac_noi_dung_can_phan_tich_bieu_dien_tren_bao_cao\" title=\"B\u01b0\u1edbc 2: X\u00e1c\u00a0\u0111\u1ecbnh c\u00e1c n\u1ed9i dung c\u1ea7n ph\u00e2n t\u00edch, bi\u1ec3u di\u1ec5n tr\u00ean b\u00e1o c\u00e1o\">B\u01b0\u1edbc 2: X\u00e1c\u00a0\u0111\u1ecbnh c\u00e1c n\u1ed9i dung c\u1ea7n ph\u00e2n t\u00edch, bi\u1ec3u di\u1ec5n tr\u00ean b\u00e1o c\u00e1o<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/ung-dung-power-query-xay-dung-mo-hinh-du-lieu-phan-tich-nang-suat-lao-dong-phan-4.html#Buoc_3_Tao_Pivot_Table_tu_bang_du_lieu\" title=\"B\u01b0\u1edbc 3: T\u1ea1o Pivot Table t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u\">B\u01b0\u1edbc 3: T\u1ea1o Pivot Table t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/ung-dung-power-query-xay-dung-mo-hinh-du-lieu-phan-tich-nang-suat-lao-dong-phan-4.html#Buoc_4_Tao_cac_Slicer_de_phan_tich_du_lieu\" title=\"B\u01b0\u1edbc 4: T\u1ea1o c\u00e1c Slicer\u00a0\u0111\u1ec3 ph\u00e2n t\u00edch d\u1eef li\u1ec7u\">B\u01b0\u1edbc 4: T\u1ea1o c\u00e1c Slicer\u00a0\u0111\u1ec3 ph\u00e2n t\u00edch d\u1eef li\u1ec7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/ung-dung-power-query-xay-dung-mo-hinh-du-lieu-phan-tich-nang-suat-lao-dong-phan-4.html#Buoc_5_Tao_noi_dung_cho_cac_the\" title=\"B\u01b0\u1edbc 5: T\u1ea1o n\u1ed9i dung cho c\u00e1c th\u1ebb\">B\u01b0\u1edbc 5: T\u1ea1o n\u1ed9i dung cho c\u00e1c th\u1ebb<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/ung-dung-power-query-xay-dung-mo-hinh-du-lieu-phan-tich-nang-suat-lao-dong-phan-4.html#Buoc_6_Ve_bieu_do_bang_Pivot_Chart_tu_Pivot_Table\" title=\"B\u01b0\u1edbc 6: V\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3 b\u1eb1ng Pivot Chart t\u1eeb Pivot Table\">B\u01b0\u1edbc 6: V\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3 b\u1eb1ng Pivot Chart t\u1eeb Pivot Table<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/ung-dung-power-query-xay-dung-mo-hinh-du-lieu-phan-tich-nang-suat-lao-dong-phan-4.html#Buoc_7_Ket_noi_cac_PivotTable_vao_cung_Slicer\" title=\"B\u01b0\u1edbc 7: K\u1ebft n\u1ed1i c\u00e1c PivotTable v\u00e0o c\u00f9ng Slicer\">B\u01b0\u1edbc 7: K\u1ebft n\u1ed1i c\u00e1c PivotTable v\u00e0o c\u00f9ng Slicer<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Phan_4_Xay_dung_bao_cao_phan_tich_du_lieu\"><\/span>Ph\u1ea7n 4: X\u00e2y d\u1ef1ng b\u00e1o c\u00e1o ph\u00e2n t\u00edch d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Th\u1ebf n\u00e0o l\u00e0 1 b\u00e1o c\u00e1o ph\u00e2n t\u00edch d\u1eef li\u1ec7u? B\u1ea1n\u00a0\u0111\u00e3 t\u1eebng nghe t\u1edbi kh\u00e1i ni\u1ec7m n\u00e0y ch\u01b0a?\u00a0Khi hi\u1ec3u r\u00f5 v\u1ec1 m\u1ee5c\u00a0\u0111\u00edch,\u00a0\u0111\u1eb7c\u00a0\u0111i\u1ec3m c\u1ee7a b\u00e1o c\u00e1o n\u00e0y th\u00ec ch\u00fang ta m\u1edbi c\u00f3 th\u1ec3 x\u00e2y d\u1ef1ng\u00a0\u0111\u01b0\u1ee3c.<\/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-309.gif\" title=\"ex101_92019-nho-309\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Dac_diem_cua_bao_cao_phan_tich_du_lieu\"><\/span>\u0110\u1eb7c\u00a0\u0111i\u1ec3m c\u1ee7a b\u00e1o c\u00e1o ph\u00e2n t\u00edch d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u00e1o c\u00e1o ph\u00e2n t\u00edch\u00a0l\u00e0 d\u1ea1ng b\u00e1o c\u00e1o d\u00f9ng cho m\u1ee5c\u00a0\u0111\u00edch ph\u00e2n t\u00edch d\u1eef li\u1ec7u. D\u1ef1a tr\u00ean k\u1ebft qu\u1ea3 ph\u00e2n t\u00edch\u00a0\u0111\u1ec3 t\u00ecm ra ph\u01b0\u01a1ng ph\u00e1p, m\u1ee5c ti\u00eau h\u00e0nh\u00a0\u0111\u1ed9ng.<\/p>\n<p>\u0110\u1ed1i t\u01b0\u1ee3ng c\u1ee7a lo\u1ea1i b\u00e1o c\u00e1o n\u00e0y d\u00e0nh cho nh\u1eefng ng\u01b0\u1eddi l\u00e0m c\u00f4ng vi\u1ec7c li\u00ean quan t\u1edbi qu\u1ea3n l\u00fd, gi\u00e1m\u00a0\u0111\u1ed1c.\u00a0\u0110\u1eb7c\u00a0\u0111i\u1ec3m c\u1ee7a c\u00f4ng vi\u1ec7c n\u00e0y th\u01b0\u1eddng bao g\u1ed3m c\u00e1c n\u1ed9i dung sau:<\/p>\n<ul>\n<li><strong>T\u01b0 duy bao qu\u00e1t<\/strong>: N\u1eafm \u0111\u01b0\u1ee3c s\u1ed1 li\u1ec7u t\u1ed5ng c\u1ee7a c\u00e1c ch\u1ec9 ti\u00eau, nh\u00f3m ch\u1ec9 ti\u00eau. V\u00ed d\u1ee5: t\u1ed5ng c\u1ee7a to\u00e0n b\u1ed9, t\u1ed5ng c\u1ee7a 1 nh\u00f3m, t\u1ef7 l\u1ec7 c\u1ee7a 1\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng trong t\u1ed5ng s\u1ed1, ho\u1eb7c t\u00ecnh h\u00ecnh t\u0103ng\/gi\u1ea3m c\u1ee7a 1 ch\u1ec9 ti\u00eau so v\u1edbi k\u1ef3 tr\u01b0\u1edbc\u2026<\/li>\n<li><strong>T\u01b0 duy ph\u00e2n t\u00edch<\/strong>: v\u1ebd bi\u1ec3u \u0111\u1ed3, ph\u00e2n t\u00edch c\u00e1c ch\u1ec9 ti\u00eau tr\u00ean bi\u1ec3u \u0111\u1ed3. B\u1edfi bi\u1ec3u\u00a0\u0111\u1ed3 s\u1ebd cung c\u1ea5p c\u00e1i nh\u00ecn tr\u1ef1c quan nh\u1ea5t v\u1ec1 c\u00e1c n\u1ed9i dung. Thay v\u00ec nh\u00ecn v\u00e0o 1 b\u1ea3ng g\u1ed3m qu\u00e1 nhi\u1ec1u c\u00e1c ch\u1ec9 ti\u00eau v\u00e0 con s\u1ed1, vi\u1ec7c bi\u1ec3u di\u1ec5n tr\u00ean bi\u1ec3u\u00a0\u0111\u1ed3 s\u1ebd d\u1ec5 nh\u00ecn h\u01a1n r\u1ea5t nhi\u1ec1u. Th\u00eam v\u00e0o\u00a0\u0111\u00f3 bi\u1ec3u\u00a0\u0111\u1ed3 c\u00f2n gi\u00fap d\u1ec5 d\u00e0ng nh\u1eadn ra s\u1ef1 ch\u00eanh l\u1ec7ch, xu h\u01b0\u1edbng bi\u1ebfn\u00a0\u0111\u1ed9ng c\u1ee7a c\u00e1c n\u1ed9i dung\u00a0\u0111\u01b0\u1ee3c bi\u1ec3u di\u1ec5n.<\/li>\n<li><strong>Ra quy\u1ebft \u0111\u1ecbnh<\/strong>: d\u1ef1a tr\u00ean nh\u1eefng \u0111i\u1ec1u ph\u00e2n t\u00edch \u0111\u01b0\u1ee3c c\u00f3 th\u1ec3 \u0111\u01b0a ra quy\u1ebft \u0111\u1ecbnh. B\u1edfi m\u1ee5c\u00a0\u0111\u00edch cu\u1ed1i c\u00f9ng c\u1ee7a vi\u1ec7c ph\u00e2n t\u00edch ch\u00ednh l\u00e0 ch\u1ec9 ra\u00a0\u0111\u01b0\u1ee3c m\u1ee5c ti\u00eau\u00a0\u0111\u1ec3 h\u00e0nh\u00a0\u0111\u1ed9ng.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Cach_lap_bao_cao_phan_tich_du_lieu_tren_Excel\"><\/span>C\u00e1ch l\u1eadp b\u00e1o c\u00e1o ph\u00e2n t\u00edch d\u1eef li\u1ec7u tr\u00ean\u00a0Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3\u00a0\u0111\u1ea3m b\u1ea3o b\u00e1o c\u00e1o\u00a0\u0111\u1ea1t\u00a0\u0111\u01b0\u1ee3c c\u00e1c m\u1ee5c ti\u00eau tr\u00ean, y\u00eau c\u1ea7u c\u1ee7a d\u1ea1ng b\u00e1o c\u00e1o n\u00e0y th\u01b0\u1eddng l\u00e0:<\/p>\n<ul>\n<li>B\u1ea3ng b\u00e1o c\u00e1o g\u1ed3m nhi\u1ec1u b\u1ea3ng \/ bi\u1ec3u\u00a0\u0111\u1ed3 tr\u00ean c\u00f9ng 1 m\u00e0n h\u00ecnh\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 c\u00f3 nhi\u1ec1u g\u00f3c nh\u00ecn, nhi\u1ec1u chi\u1ec1u ph\u00e2n t\u00edch<\/li>\n<li>C\u00e1c b\u1ea3ng \/ bi\u1ec3u\u00a0\u0111\u1ed3 c\u1ea7n li\u00ean k\u1ebft v\u1edbi nhau th\u1ed1ng nh\u1ea5t theo c\u00f9ng 1 h\u01b0\u1edbng c\u1ea7n ph\u00e2n t\u00edch (n\u1ebfu c\u00e1c b\u1ea3ng \/ bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u1ed9c l\u1eadp v\u1edbi nhau th\u00ec c\u00f3 th\u1ec3 kh\u00f4ng c\u1ea7n li\u00ean k\u1ebft n\u00e0y)<\/li>\n<\/ul>\n<p>Do\u00a0\u0111\u00f3 c\u00f4ng c\u1ee5 ch\u1ee7 y\u1ebfu trong\u00a0Excel\u00a0\u0111\u1ec3 l\u00e0m vi\u1ec7c n\u00e0y ch\u00ednh l\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/khoi-dau-voi-pivot-table-trong-excel.html\">Pivot Table<\/a> v\u00e0 Pivot Chart. B\u1edfi Pivot Table t\u1ea1o ra c\u00e1c b\u00e1o c\u00e1o\u00a0\u0111\u1ed9ng, gi\u00fap linh ho\u1ea1t trong vi\u1ec7c th\u1ec3 hi\u1ec7n n\u1ed9i dung b\u00e1o c\u00e1o. Pivot Chart l\u00e0 d\u1ea1ng bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1ee3c v\u1ebd n\u00ean t\u1eeb Pivot Table.\u00a0\u0110\u1ed3ng th\u1eddi t\u1eeb Pivot Table ch\u00fang ta c\u00f3 th\u1ec3 t\u1ea1o ra c\u00e1c <a href=\"http:\/\/blog.ezworkapp.com\/tim-hieu-ve-slicer-cong-cu-giup-loc-dong-thoi-nhieu-bao-cao-pivot-table.html\">Slicer<\/a>, Timeline\u00a0\u0111\u1ec3 l\u00e0m b\u1ed9 l\u1ecdc gi\u00fap ph\u00e2n t\u00edch theo 1 s\u1ed1 ch\u1ec9 ti\u00eau c\u1ee5 th\u1ec3.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Huong_dan_chi_tiet_cach_lap_bao_cao_phan_tich_nang_suat_lao_dong_tren_Excel\"><\/span>H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch l\u1eadp b\u00e1o c\u00e1o ph\u00e2n t\u00edch n\u0103ng su\u1ea5t lao\u00a0\u0111\u1ed9ng tr\u00ean\u00a0Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Buoc_1_Xac_dinh_cau_truc_bao_cao\"><\/span>B\u01b0\u1edbc 1: X\u00e1c\u00a0\u0111\u1ecbnh c\u1ea5u tr\u00fac b\u00e1o c\u00e1o<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Tr\u01b0\u1edbc khi x\u00e2y d\u1ef1ng b\u00e1o c\u00e1o, ch\u00fang ta n\u00ean c\u00f3 1 s\u1ed1 h\u00ecnh dung v\u1ec1 c\u1ea5u tr\u00fac, b\u1ed1 c\u1ee5c b\u00e1o c\u00e1o. B\u1edfi c\u00f3 r\u1ea5t nhi\u1ec1u n\u1ed9i dung s\u1ebd c\u1ea7n\u00a0\u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y tr\u00ean b\u00e1o c\u00e1o n\u00e0y. Do\u00a0\u0111\u00f3 vi\u1ec7c s\u1eafp x\u1ebfp, tr\u00ecnh b\u00e0y c\u0169ng r\u1ea5t quan tr\u1ecdng.<\/p>\n<p>M\u1ed9t s\u1ed1\u00a0ti\u00eau ch\u00ed c\u1ea7n c\u00f3 trong b\u1ed1 c\u1ee5c b\u00e1o c\u00e1o:<\/p>\n<ul>\n<li>Trong ph\u1ea1m vi\u00a0\u0111\u01b0\u1ee3c x\u00e1c\u00a0\u0111\u1ecbnh, t\u1ed1t nh\u1ea5t l\u00e0 trong\u00a0\u0111\u00fang 1 khung m\u00e0n h\u00ecnh. B\u1edfi vi\u1ec7c v\u01b0\u1ee3t qu\u00e1 khung h\u00ecnh s\u1ebd d\u1eabn t\u1edbi vi\u1ec7c ph\u1ea3i di chuy\u1ec3n qua l\u1ea1i\u00a0\u0111\u1ec3 xem b\u00e1o c\u00e1o. Khi\u00a0\u0111\u00f3 s\u1ebd l\u00e0m gi\u1ea3m s\u1ef1 t\u1eadp trung ho\u1eb7c kh\u00f3 theo d\u00f5i to\u00e0n b\u1ed9 b\u00e1o c\u00e1o.<\/li>\n<li>C\u00f3 s\u1ef1 ph\u00e2n c\u1ea5p theo m\u1ee9c\u00a0\u0111\u1ed9 chi ti\u1ebft\u00a0\u0111\u1ec3 ph\u00f9 h\u1ee3p v\u1edbi qu\u00e1 tr\u00ecnh ph\u00e2n t\u00edch b\u00e1o c\u00e1o. N\u00ean ph\u00e2n c\u1ea5p theo chi\u1ec1u t\u1eeb tr\u00ean &gt; d\u01b0\u1edbi, tr\u00e1i &gt; ph\u1ea3i.<\/li>\n<li>Trong c\u00f9ng 1 nh\u00f3m n\u1ed9i dung th\u00ec c\u00e1c n\u1ed9i dung c\u1ea7n\u00a0\u0111\u01b0\u1ee3c th\u1ed1ng nh\u1ea5t v\u1ec1 c\u00e1ch tr\u00ecnh b\u00e0y, k\u00edch c\u1ee1, m\u00e0u s\u1eafc, lo\u1ea1i bi\u1ec3u\u00a0\u0111\u1ed3\u2026\u00a0\u0111\u1ec3\u00a0\u0111\u1ea3m b\u1ea3o t\u00ednh th\u1ed1ng nh\u1ea5t cho n\u1ed9i dung c\u1ea7n th\u1ec3 hi\u1ec7n.<\/li>\n<\/ul>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o 1 s\u1ed1 m\u1eabu b\u1ed1 c\u1ee5c b\u00e1o c\u00e1o trong file sau: <a href=\"http:\/\/bit.ly\/2p76jZ1\">http:\/\/bit.ly\/2p76jZ1<\/a><\/p>\n<p>V\u00ed d\u1ee5 ch\u00fang ta s\u1eed d\u1ee5ng\u00a0m\u1eabu b\u00e1o c\u00e1o nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi \u0111\u1ec3 bi\u1ec3u di\u1ec5n cho b\u00e1o c\u00e1o ph\u00e2n t\u00edch n\u0103ng su\u1ea5t lao \u0111\u1ed9ng:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30536\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-1-mau-template_dashboard-1024x644-1.png\" width=\"1024\" height=\"644\" title=\"4-1-mau-template_dashboard-1024x644-1\"><\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 copy m\u1eabu b\u00e1o c\u00e1o trong file Template, sau\u00a0\u0111\u00f3 d\u00e1n v\u00e0o file B\u00e0i t\u1eadp\u00a0\u0111ang l\u00e0m\u00a0\u0111\u1ec3 c\u00f3 m\u1eabu b\u00e1o c\u00e1o m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i t\u1ef1 v\u1ebd l\u1ea1i.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Buoc_2_Xac_dinh_cac_noi_dung_can_phan_tich_bieu_dien_tren_bao_cao\"><\/span>B\u01b0\u1edbc 2: X\u00e1c\u00a0\u0111\u1ecbnh c\u00e1c n\u1ed9i dung c\u1ea7n ph\u00e2n t\u00edch, bi\u1ec3u di\u1ec5n tr\u00ean b\u00e1o c\u00e1o<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1eb7c\u00a0\u0111i\u1ec3m d\u1eef li\u1ec7u trong c\u00e1c c\u1ed9t s\u1ebd li\u00ean quan t\u1edbi vi\u1ec7c b\u1ea1n c\u00f3 th\u1ec3 bi\u1ec3u di\u1ec5n\u00a0\u0111\u01b0\u1ee3c nh\u1eefng g\u00ec tr\u00ean b\u00e1o c\u00e1o:<\/p>\n<ul>\n<li>Nh\u1eefng c\u1ed9t ch\u1ee9a n\u1ed9i dung theo d\u1ea1ng danh s\u00e1ch (c\u00e1c gi\u00e1 tr\u1ecb l\u1eb7p l\u1ea1i trong ph\u1ea1m vi 1 danh s\u00e1ch nh\u1ea5t\u00a0\u0111\u1ecbnh, th\u01b0\u1eddng l\u00e0 ng\u1eafn, d\u01b0\u1edbi 8 d\u00f2ng) th\u00ec c\u00f3 th\u1ec3 d\u00f9ng l\u00e0m b\u1ed9 l\u1ecdc (Slicer) cho b\u00e1o c\u00e1o ho\u1eb7c d\u00f9ng cho bi\u1ec3u\u00a0\u0111\u1ed3 d\u1ea1ng nh\u00f3m, t\u1ef7 l\u1ec7 nh\u00f3m. V\u00ed d\u1ee5 nh\u01b0 c\u1ed9t D\u1ef1\u00a0\u00e1n, Khu v\u1ef1c<\/li>\n<li>Nh\u1eefng c\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb s\u1ed1 (s\u1ed1\u00a0lao\u00a0\u0111\u1ed9ng, gi\u00e1 tr\u1ecb, n\u0103ng su\u1ea5t lao\u00a0\u0111\u1ed9ng) th\u00ec c\u00f3 th\u1ec3 d\u00f9ng\u00a0\u0111\u1ec3 bi\u1ec3u di\u1ec5n c\u00e1c ch\u1ec9 ti\u00eau d\u1ea1ng s\u1ed1 v\u00e0 l\u00e0 gi\u00e1 tr\u1ecb\u00a0\u0111\u1ec3 bi\u1ec3u di\u1ec5n tr\u00ean bi\u1ec3u\u00a0\u0111\u1ed3.<\/li>\n<li>Nh\u1eefng c\u1ed9t ch\u1ee9a n\u1ed9i dung kh\u00f4ng tr\u00f9ng l\u1eb7p ho\u1eb7c theo danh s\u00e1ch d\u00e0i (chi nh\u00e1nh) th\u00ec th\u01b0\u1eddng d\u00f9ng\u00a0\u0111\u1ec3 bi\u1ec3u di\u1ec5n c\u00e1c\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng tr\u00ean bi\u1ec3u\u00a0\u0111\u1ed3 d\u1ea1ng c\u1ed9t, bar, line<\/li>\n<\/ul>\n<p>Ti\u1ebfp\u00a0\u0111\u1ebfn ch\u00fang ta h\u00ecnh dung 1 s\u1ed1 d\u1ea1ng b\u00e1o c\u00e1o c\u00f3 th\u1ec3 d\u00f9ng\u00a0\u0111\u1ec3 ph\u00e2n t\u00edch, ph\u1ea3n\u00a0\u00e1nh n\u0103ng su\u1ea5t lao\u00a0\u0111\u1ed9ng:<\/p>\n<ul>\n<li>N\u0103ng su\u1ea5t l\u00e0 1 gi\u00e1 tr\u1ecb s\u1ed1, c\u00f3 th\u1ec3\u00a0\u0111\u1ecbnh l\u01b0\u1ee3ng\u00a0\u0111\u01b0\u1ee3c. Do\u00a0\u0111\u00f3 c\u00f3 th\u1ec3 t\u00ecm\u00a0\u0111\u01b0\u1ee3c s\u1ed1\u00a0l\u1edbn nh\u1ea5t, s\u1ed1 nh\u1ecf nh\u1ea5t, s\u1ed1 trung b\u00ecnh. Ngo\u00e0i ra n\u0103ng su\u1ea5t li\u00ean quan t\u1edbi t\u1eebng chi nh\u00e1nh, t\u1eebng d\u1ef1\u00a0\u00e1n, t\u1eebng khu v\u1ef1c =&gt; x\u00e1c\u00a0\u0111\u1ecbnh n\u0103ng su\u1ea5t theo c\u00e1c\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng n\u00e0y.<\/li>\n<li>Li\u00ean quan t\u1edbi th\u1eddi gian: Th\u00e1ng, N\u0103m: ch\u00fang ta c\u00f3 th\u1ec3 d\u00f9ng\u00a0\u0111\u1ec3 t\u00ednh l\u0169y ti\u1ebfn theo th\u1eddi gian\u00a0\u0111\u1ec3 so s\u00e1nh n\u0103ng su\u1ea5t\u00a0gi\u1eefa c\u00e1c n\u0103m.<\/li>\n<li>N\u0103ng su\u1ea5t c\u00f3\u00a0\u0111\u01b0\u1ee3c l\u00e0 do Gi\u00e1 tr\u1ecb \/ S\u1ed1 lao\u00a0\u0111\u1ed9ng. Do\u00a0\u0111\u00f3 ch\u00fang ta c\u00f3 th\u1ec3 bi\u1ec3u di\u1ec5n th\u00eam c\u00e1c bi\u1ec3u\u00a0\u0111\u1ed3 v\u1ec1 gi\u00e1 tr\u1ecb, s\u1ed1 lao\u00a0\u0111\u1ed9ng\u00a0\u0111\u1ec3 so s\u00e1nh,\u00a0\u0111\u1ed1i chi\u1ebfu th\u00eam v\u1edbi n\u0103ng su\u1ea5t.<\/li>\n<\/ul>\n<p>B\u01b0\u1edbc n\u00e0y r\u1ea5t quan tr\u1ecdng, b\u1edfi d\u1ef1a tr\u00ean c\u00e1c y\u1ebfu t\u1ed1\u00a0\u0111\u00e3 c\u00f3 v\u00e0 m\u1ed1i quan h\u1ec7 gi\u1eefa c\u00e1c y\u1ebfu t\u1ed1\u00a0\u0111\u00f3, ch\u00fang ta c\u00f3 th\u1ec3\u00a0\u0111\u1ecbnh h\u00ecnh\u00a0\u0111\u01b0\u1ee3c s\u1ebd bi\u1ec3u di\u1ec5n n\u1ed9i dung g\u00ec tr\u00ean b\u00e1o c\u00e1o\u00a0v\u00e0 c\u00e1ch ph\u00e2n t\u00edch b\u00e1o c\u00e1o.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Buoc_3_Tao_Pivot_Table_tu_bang_du_lieu\"><\/span>B\u01b0\u1edbc 3: T\u1ea1o Pivot Table t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>B\u1eb1ng c\u00e1ch ch\u1ecdn b\u1ea3ng Query1, ch\u00fang ta ch\u1ecdn ti\u1ebfp th\u1ebb\u00a0Insert &gt; Pivot Table.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-30537\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-2-tao-pivot-table-tu-bang-query1.png\" width=\"673\" height=\"578\" title=\"4-2-tao-pivot-table-tu-bang-query1\"><\/p>\n<p>M\u1ee5c\u00a0\u0111\u00edch c\u1ee7a vi\u1ec7c n\u00e0y:<\/p>\n<ul>\n<li>Pivot Table l\u00e0 d\u1ea1ng b\u00e1o c\u00e1o\u00a0\u0111\u1ed9ng, d\u1eef li\u1ec7u c\u1ee7a b\u00e1o c\u00e1o n\u00e0y\u00a0\u0111\u01b0\u1ee3c l\u1ea5y t\u1eeb b\u1ea3ng Query1. M\u1ed7i Pivot Table s\u1ebd th\u1ec3 hi\u1ec7n 1 n\u1ed9i dung, do \u0111\u00f3 c\u1ea7n nhi\u1ec1u Pivot Table. T\u1ea5t c\u1ea3 c\u00e1c Pivot Table\u00a0\u0111\u1ec1u l\u1ea5y chung t\u1eeb 1 ngu\u1ed3n\u00a0\u0111\u1ec3\u00a0\u0111\u1ea3m b\u1ea3o t\u00ednh th\u1ed1ng nh\u1ea5t v\u00e0 k\u1ebft n\u1ed1i\u00a0\u0111\u01b0\u1ee3c c\u00e1c Pivot Table v\u1edbi nhau.<\/li>\n<li>Khi b\u1ea3ng Query1\u00a0\u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt (b\u1eb1ng refresh) th\u00ec to\u00e0n b\u1ed9 c\u00e1c b\u00e1o c\u00e1o Pivot Table c\u0169ng s\u1ebd\u00a0\u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt theo v\u00ec c\u00f9ng chung 1 ngu\u1ed3n.<\/li>\n<\/ul>\n<p>N\u1ebfu\u00a0\u0111\u00e3 c\u00f3 Sheet b\u00e1o c\u00e1o s\u1eb5n r\u1ed3i th\u00ec ch\u00fang ta ch\u1ecdn\u00a0Existing\u00a0Worksheet v\u00e0 ch\u1ecdn v\u1ecb tr\u00ed n\u01a1i\u00a0\u0111\u1eb7t Pivot Table trong Sheet\u00a0\u0111\u00f3 (n\u1ebfu b\u1ea1n \u0111\u00e3 th\u1ef1c hi\u1ec7n B\u01b0\u1edbc 2 th\u00ec c\u00f3 th\u1ec3 \u0111\u1eb7t Pivot table v\u00e0o c\u00f9ng Sheet c\u00f3 ch\u1ee9a m\u1eabu b\u00e1o c\u00e1o). C\u00f2n kh\u00f4ng th\u00ec s\u1ebd\u00a0\u0111\u1eb7t Pivot Table t\u1ea1i 1 Sheet m\u1edbi th\u00ec ch\u1ecdn New\u00a0Worksheet.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Buoc_4_Tao_cac_Slicer_de_phan_tich_du_lieu\"><\/span>B\u01b0\u1edbc 4: T\u1ea1o c\u00e1c Slicer\u00a0\u0111\u1ec3 ph\u00e2n t\u00edch d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Trong Pivot Table v\u1eeba t\u1ea1o\u00a0\u1edf b\u01b0\u1edbc 3, b\u1ea1n b\u1ea5m v\u00e0o th\u1ebb PivotTable\u00a0Analyze (ho\u1eb7c PivotTable Option), ch\u1ecdn m\u1ee5c\u00a0Insert Slicer<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-30538\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-3-tao-slicer-de-phan-tich-du-lieu.png\" width=\"853\" height=\"585\" title=\"4-3-tao-slicer-de-phan-tich-du-lieu\"><\/p>\n<p>C\u1ee5 th\u1ec3\u00a0\u1edf\u00a0\u0111\u00e2y ch\u00fang ta l\u1ea5y theo 2 ti\u00eau ch\u00ed\u00a0l\u00e0 D\u1ef1\u00a0\u00e1n v\u00e0 Khu v\u1ef1c<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Buoc_5_Tao_noi_dung_cho_cac_the\"><\/span>B\u01b0\u1edbc 5: T\u1ea1o n\u1ed9i dung cho c\u00e1c th\u1ebb<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>C\u00e1c th\u1ebb\u00a0\u1edf\u00a0\u0111\u00e2y ch\u00ednh l\u00e0 ph\u1ea7n x\u00e1c\u00a0\u0111\u1ecbnh c\u00e1c ch\u1ec9 ti\u00eau ch\u1ee9a S\u1ed1 v\u00e0 bi\u1ebfn\u00a0\u0111\u1ed9ng (ph\u1ea7n b\u00ean tr\u00e1i c\u1ee7a m\u1eabu b\u00e1o c\u00e1o).<\/p>\n<p>V\u00ed d\u1ee5: X\u00e1c\u00a0\u0111\u1ecbnh t\u1ed5ng gi\u00e1 tr\u1ecb c\u1ee7a c\u00e1c n\u1ed9i dung\u00a0\u0111\u01b0\u1ee3c bi\u1ec3u th\u1ecb v\u00e0 t\u1ef7 l\u1ec7 % c\u1ee7a s\u1ed1 n\u00e0y so v\u1edbi to\u00e0n b\u1ed9 c\u00e1c gi\u00e1 tr\u1ecb.<\/p>\n<ul>\n<li>T\u1ea1o PivotTable 1<\/li>\n<li>Trong PivotTable 1 b\u1ea1n\u00a0\u0111\u01b0a\u00a0ch\u1ec9 ti\u00eau Gi\u00e1 tr\u1ecb v\u00e0o v\u1ecb tr\u00ed Value, k\u1ebft qu\u1ea3 l\u00e0:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-30539\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-4-tao-chi-tieu-tong-gia-tri.png\" width=\"640\" height=\"533\" title=\"4-4-tao-chi-tieu-tong-gia-tri\"><\/p>\n<ul>\n<li>Gi\u00e1 tr\u1ecb n\u00e0y s\u1ebd thay\u00a0\u0111\u1ed5i khi b\u1ea1n b\u1ea5m ch\u1ecdn c\u00e1c n\u1ed9i dung trong Slicer<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-30540\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-5-thay-doi-ket-qua-pivot-table-theo-slicer.png\" width=\"400\" height=\"392\" title=\"4-5-thay-doi-ket-qua-pivot-table-theo-slicer\"><\/p>\n<ul>\n<li>\u0110\u1ec3 t\u1ea1o ra 1 gi\u00e1 tr\u1ecb kh\u00f4ng\u00a0\u0111\u1ed5i, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3\u00a0\u0111\u1eb7t c\u00f4ng th\u1ee9c t\u00ednh gi\u00e1 tr\u1ecb\u00a0\u0111\u00f3 (v\u00ed d\u1ee5 \u0111\u1eb7t t\u1ea1i \u00f4 A7):<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\">=SUM(Query1[Gi\u00e1 tr\u1ecb])<\/p>\n<p style=\"padding-left: 60px\">T\u00ednh t\u1ed5ng trong to\u00e0n b\u1ed9 c\u1ed9t Gi\u00e1 tr\u1ecb c\u1ee7a b\u1ea3ng Query1 (khi vi\u1ebft h\u00e0m SUM r\u1ed3i tham chi\u1ebfu t\u1edbi c\u1ed9t Gi\u00e1 tr\u1ecb th\u00ec s\u1ebd t\u1ef1\u00a0\u0111\u1ed9ng nh\u1eadn\u00a0\u0111\u01b0\u1ee3c c\u00e1ch vi\u1ebft h\u00e0m SUM nh\u01b0 tr\u00ean)<\/p>\n<ul>\n<li>T\u00ednh t\u1ef7 l\u1ec7 % gi\u1eefa gi\u00e1 tr\u1ecb c\u1ee7a PivotTable1 v\u1edbi t\u1ed5ng to\u00e0n b\u1ed9 Gi\u00e1 tr\u1ecb:<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\">=GETPIVOTDATA(\u201cGi\u00e1 tr\u1ecb\u201d,$A$3)\/A7<\/p>\n<p style=\"padding-left: 60px\">\u0110\u1ecbnh d\u1ea1ng k\u1ebft qu\u1ea3 d\u01b0\u1edbi d\u1ea1ng %, ch\u00fang ta c\u00f3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-30541\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-6-ket-qua-ve-tong-gia-tri.png\" width=\"617\" height=\"440\" title=\"4-6-ket-qua-ve-tong-gia-tri\"><\/p>\n<ul>\n<li>Cu\u1ed1i c\u00f9ng,\u00a0\u0111\u01b0a c\u00e1c k\u1ebft qu\u1ea3\u00a0\u0111\u00e3 t\u00ednh\u00a0\u0111\u01b0\u1ee3c v\u00e0o trong th\u1ebb t\u1ea1i b\u00e1o c\u00e1o:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-30542\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-7-dua-ket-qua-vao-the-trong-bieu-do.png\" width=\"623\" height=\"430\" title=\"4-7-dua-ket-qua-vao-the-trong-bieu-do\"><\/p>\n<p>\u0110\u1ec3\u00a0\u0111\u01b0a\u00a0\u0111\u01b0\u1ee3c n\u1ed9i dung v\u00e0o trong c\u00e1c th\u1ebb (l\u00e0 c\u00e1c h\u00ecnh kh\u1ed1i): B\u1ea1n ch\u1ecdn h\u00ecnh kh\u1ed1i, b\u1ea5m ph\u00edm F2 \u0111\u1ec3 c\u00f3 th\u1ec3 vi\u1ebft c\u00f4ng th\u1ee9c g\u1eafn gi\u00e1 tr\u1ecb, sau\u00a0\u0111\u00f3 nh\u1eadp t\u1ecda\u00a0\u0111\u1ed9 mu\u1ed1n tham chi\u1ebfu (=A4 v\u1edbi s\u1ed1 t\u1ed5ng gi\u00e1 tr\u1ecb, =A10 v\u1edbi s\u1ed1 t\u1ef7 l\u1ec7)<\/p>\n<p>Ngo\u00e0i ra\u00a0\u0111\u1ec3 r\u00fat g\u1ecdn gi\u00e1 tr\u1ecb trong ph\u1ea7n t\u1ed5ng gi\u00e1 tr\u1ecb, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o c\u00f4ng th\u1ee9c chuy\u1ec3n\u00a0\u0111\u1ed5i gi\u00e1 tr\u1ecb t\u1ea1i\u00a0\u00f4 A4 sang 1\u00a0\u00f4 kh\u00e1c, sau\u00a0\u0111\u00f3 tham chi\u1ebfu t\u1edbi\u00a0\u00f4\u00a0\u0111\u00f3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-30543\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-8-thay-doi-cach-bieu-dien-ket-qua-trong-the.png\" width=\"825\" height=\"337\" title=\"4-8-thay-doi-cach-bieu-dien-ket-qua-trong-the\"><\/p>\n<p>V\u00ed d\u1ee5: D\u00f9ng h\u00e0m ROUND\u00a0\u0111\u1ec3 l\u00e0m tr\u00f2n cho ph\u00e9p chia gi\u00e1 tr\u1ecb t\u1ea1i\u00a0\u00f4 A4 cho 1 tri\u1ec7u, sau\u00a0\u0111\u00f3 n\u1ed1i th\u00eam ch\u1eef \u201ctri\u1ec7u\u201d\u00a0\u0111\u1ec3 bi\u1ec3u th\u1ecb gi\u00e1 tr\u1ecb k\u1ebft qu\u1ea3\u00a0\u0111\u00e3 r\u00fat g\u1ecdn l\u00ean h\u00e0ng tri\u1ec7u.<\/p>\n<p>Sau \u0111\u00f3 g\u00e1n gi\u00e1 tr\u1ecb trong th\u1ebb v\u1edbi\u00a0\u00f4 A2.<\/p>\n<p>B\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 t\u1ea1o th\u00eam c\u00e1c th\u1ebb kh\u00e1c: N\u0103ng su\u1ea5t l\u1edbn nh\u1ea5t, n\u0103ng su\u1ea5t trung b\u00ecnh, n\u0103ng su\u1ea5t nh\u1ecf nh\u1ea5t, t\u1ed5ng s\u1ed1 lao\u00a0\u0111\u1ed9ng\u2026\u00a0\u0111\u1ec3 bi\u1ec3u di\u1ec5n l\u00ean c\u00e1c th\u1ebb t\u00f9y theo nhu c\u1ea7u b\u00e1o c\u00e1o.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Buoc_6_Ve_bieu_do_bang_Pivot_Chart_tu_Pivot_Table\"><\/span>B\u01b0\u1edbc 6: V\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3 b\u1eb1ng Pivot Chart t\u1eeb Pivot Table<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ec3 th\u1ec3 hi\u1ec7n n\u1ed9i dung tr\u00ean bi\u1ec3u\u00a0\u0111\u1ed3, c\u00e1c b\u01b0\u1edbc c\u1ea7n th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<ul>\n<li>T\u1ea1o PivotTable m\u1edbi. M\u1ed7i PivotTable\u00a0\u1ee9ng v\u1edbi 1 bi\u1ec3u\u00a0\u0111\u1ed3. C\u00e1c PivotTable n\u00e0y\u00a0\u0111\u1ec1u t\u1ea1o t\u1eeb b\u1ea3ng Query1.<\/li>\n<li>X\u00e1c\u00a0\u0111\u1ecbnh n\u1ed9i dung c\u1ea7n bi\u1ec3u di\u1ec5n. V\u00ed d\u1ee5:\u00a0Top 10 chi nh\u00e1nh c\u00f3 n\u0103ng su\u1ea5t cao nh\u1ea5t. Khi\u00a0\u0111\u00f3 gi\u00e1 tr\u1ecb c\u1ea7n bi\u1ec3u di\u1ec5n trong PivotTable s\u1ebd l\u00e0:<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\">Row: Chi nh\u00e1nh<\/p>\n<p style=\"padding-left: 60px\">Value: N\u0103ng su\u1ea5t<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-30544\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-9-pivottable-bieu-dien-nang-suat-theo-chi-nhanh.png\" width=\"826\" height=\"623\" title=\"4-9-pivottable-bieu-dien-nang-suat-theo-chi-nhanh\"><\/p>\n<p>V\u00ec c\u00f3 r\u1ea5t nhi\u1ec1u chi nh\u00e1nh n\u00ean ch\u00fang ta c\u00f3 th\u1ec3 l\u1ecdc theo Top10 chi nh\u00e1nh c\u00f3 n\u0103ng su\u1ea5t l\u1edbn nh\u1ea5t: B\u1ea5m n\u00fat l\u1ecdc trong c\u1ed9t Chi nh\u00e1nh &gt; Ch\u1ecdn Value Filters &gt; Ch\u1ecdn Top 10\u2026 &gt; xu\u1ea5t hi\u1ec7n c\u1eeda s\u1ed5 l\u1ecdc theo Top10, b\u1ea5m OK<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-30545\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-10-loc-top-10-chi-nhanh-co-nang-suat-lon-nhat.png\" width=\"594\" height=\"593\" title=\"4-10-loc-top-10-chi-nhanh-co-nang-suat-lon-nhat\"><\/p>\n<p>Ti\u1ebfp theo ch\u00fang ta t\u1ea1o Pivot Chart t\u1eeb PivotTable n\u00e0y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30546\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-11-pivotchart-tu-pivot-table-1024x459-1.png\" width=\"1024\" height=\"459\" title=\"4-11-pivotchart-tu-pivot-table-1024x459-1\"><\/p>\n<ul>\n<li>B\u1ea5m v\u00e0o PivotTable &gt; Tr\u00ean thanh c\u00f4ng c\u1ee5 xu\u1ea5t hi\u1ec7n th\u1ebb d\u00e0nh ri\u00eang cho PivotTable<\/li>\n<li>B\u1ea5m ch\u1ecdn PivotTable\u00a0Analyze (hay PivotTable Options), ch\u1ecdn Pivot Chart<\/li>\n<li>Ch\u1ecdn lo\u1ea1i bi\u1ec3u\u00a0\u0111\u1ed3 ph\u00f9 h\u1ee3p (v\u00ed d\u1ee5 bi\u1ec3u\u00a0\u0111\u1ed3 c\u1ed9t\u00a0\u0111\u1ee9ng)<\/li>\n<li>Co d\u00e3n k\u00edch th\u01b0\u1edbc bi\u1ec3u\u00a0\u0111\u1ed3 cho ph\u00f9 h\u1ee3p v\u1edbi khung\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf s\u1eb5n<\/li>\n<li>Khi v\u1ebd ra bi\u1ec3u\u00a0\u0111\u1ed3, b\u1ea1n c\u00f3 th\u1ec3 b\u1ecf b\u1edbt c\u00e1c n\u1ed9i dung kh\u00f4ng c\u1ea7n thi\u1ebft\u00a0\u0111\u1ec3 ch\u1ec9 t\u1eadp trung v\u00e0o n\u1ed9i dung bi\u1ec3u\u00a0\u0111\u1ed3:<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\">+ B\u1ecf b\u1edbt t\u00ean ti\u00eau\u00a0\u0111\u1ec1, ghi ch\u00fa<\/p>\n<p style=\"padding-left: 60px\">+ \u1ea8n c\u00e1c n\u00fat kh\u00f4ng c\u1ea7n thi\u1ebft (b\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o v\u1ecb tr\u00ed c\u00e1c n\u00fat, ch\u1ecdn <em><strong>Hide All Field Buttons on Chart<\/strong><\/em> nh\u01b0 h\u00ecnh d\u01b0\u1edbi)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-30547\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-12-thiet-lap-co-ban-cho-bieu-do.png\" width=\"609\" height=\"390\" title=\"4-12-thiet-lap-co-ban-cho-bieu-do\"><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Buoc_7_Ket_noi_cac_PivotTable_vao_cung_Slicer\"><\/span>B\u01b0\u1edbc 7: K\u1ebft n\u1ed1i c\u00e1c PivotTable v\u00e0o c\u00f9ng Slicer<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>T\u1ea1i B\u01b0\u1edbc 6, ch\u00fang ta t\u1ea1o ra th\u00eam PivotTable kh\u00e1c.\u00a0\u0110\u1ec3 Slicer c\u00f3 th\u1ec3\u00a0\u0111\u1ed3ng th\u1eddi t\u00e1c d\u1ee5ng l\u00ean PivotTable m\u1edbi t\u1ea1o, ch\u00fang ta c\u1ea7n k\u1ebft n\u1ed1i c\u00e1c PivotTable v\u00e0o c\u00f9ng Slicer. C\u00e1ch l\u00e0m nh\u01b0 sau:<\/p>\n<ul>\n<li>B\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o Slicer, ch\u1ecdn Report Connections\u2026<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-30548\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-13-report-connections-slicer.png\" width=\"350\" height=\"439\" title=\"4-13-report-connections-slicer\"><\/p>\n<ul>\n<li>Ch\u1ecdn c\u00e1c PivotTable s\u1ebd\u00a0\u0111\u01b0\u1ee3c k\u1ebft n\u1ed1i:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-30549\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-14-chon-pivot-table-de-ket-noi-trong-slicer.png\" width=\"658\" height=\"248\" title=\"4-14-chon-pivot-table-de-ket-noi-trong-slicer\"><\/p>\n<p><strong>L\u01b0u\u00a0\u00fd<\/strong>:<\/p>\n<ul>\n<li>N\u1ebfu c\u00f3 nhi\u1ec1u Slicer th\u00ec\u00a0m\u1ed7i Slicer\u00a0\u0111\u1ec1u ph\u1ea3i t\u1ea1o k\u1ebft n\u1ed1i v\u1edbi c\u00e1c PivotTable.<\/li>\n<li>C\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn PivotTable n\u00e0o s\u1ebd b\u1ecb\u00a0\u1ea3nh h\u01b0\u1edfng t\u1eeb vi\u1ec7c l\u1ecdc c\u1ee7a Slicer hay kh\u00f4ng b\u1eb1ng vi\u1ec7c k\u1ebft n\u1ed1i n\u00e0y.<\/li>\n<\/ul>\n<p>Sau khi ho\u00e0n t\u1ea5t c\u00e1c b\u01b0\u1edbc, b\u1ea1n ch\u1ec9 c\u1ea7n l\u1eb7p l\u1ea1i n\u1ebfu mu\u1ed1n c\u00f3 th\u00eam bi\u1ec3u\u00a0\u0111\u1ed3, th\u00eam c\u00e1c th\u1ebb\u2026\u00a0\u0111\u1ec3 l\u00e0m phong ph\u00fa th\u00eam cho b\u00e1o c\u00e1o.<\/p>\n<p>V\u00ed d\u1ee5 v\u1ec1 1 k\u1ebft qu\u1ea3 ho\u00e0n thi\u1ec7n:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30473\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dashboard-phan-tich-nang-suat-lao-dong-1024x736-1.gif\" width=\"1024\" height=\"736\" title=\"dashboard-phan-tich-nang-suat-lao-dong-1024x736-1\"><\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i file m\u1eabu t\u1ea1i\u00a0\u0111\u1ecba ch\u1ec9:\u00a0<a href=\"http:\/\/bit.ly\/2VyQfeD\">http:\/\/bit.ly\/2VyQfeD<\/a><\/p>\n<p>Nh\u01b0 v\u1eady qua Seri b\u00e0i vi\u1ebft g\u1ed3m 4 ph\u1ea7n, ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3\u00a0n\u1eafm\u00a0\u0111\u01b0\u1ee3c to\u00e0n b\u1ed9 ki\u1ebfn th\u1ee9c gi\u00fap x\u00e2y d\u1ef1ng b\u00e1o c\u00e1o qu\u1ea3n tr\u1ecb, b\u00e1o c\u00e1o ph\u00e2n t\u00edch d\u1eef li\u1ec7u. B\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5 trong\u00a0Excel nh\u01b0 Power Query, Pivot Table, Pivot Chart, Slicer\u2026 ch\u00fang ta\u00a0\u0111\u00e3\u00a0chuy\u1ec3n t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u r\u1eddi r\u1ea1c, kh\u00f4 c\u1ee9ng v\u1edbi d\u1eef li\u1ec7u s\u1ed1 th\u00e0nh d\u1ea1ng b\u00e1o c\u00e1o linh ho\u1ea1t tr\u00ean bi\u1ec3u\u00a0\u0111\u1ed3, c\u00f3 th\u1ec3 t\u1ef1\u00a0\u0111\u1ed9ng thay\u00a0\u0111\u1ed5i theo n\u1ed9i dung c\u1ea7n ph\u00e2n t\u00edch v\u00e0 t\u1ef1\u00a0\u0111\u1ed9ng c\u1eadp nh\u1eadt d\u1eef li\u1ec7u m\u00e0 kh\u00f4ng c\u1ea7n thay\u00a0\u0111\u1ed5i ph\u01b0\u01a1ng ph\u00e1p thu th\u1eadp d\u1eef li\u1ec7u ban\u00a0\u0111\u1ea7u.<\/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-309.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3891,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3890","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3890","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=3890"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3890\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3891"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}