{"id":4656,"date":"2024-12-08T05:41:30","date_gmt":"2024-12-08T05:41:30","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/tim-hieu-ve-slicer-cong-cu-giup-loc-dong-thoi-nhieu-bao-cao-pivot-table\/"},"modified":"2024-12-08T05:41:30","modified_gmt":"2024-12-08T05:41:30","slug":"tim-hieu-ve-slicer-cong-cu-giup-loc-dong-thoi-nhieu-bao-cao-pivot-table","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/tim-hieu-ve-slicer-cong-cu-giup-loc-dong-thoi-nhieu-bao-cao-pivot-table\/","title":{"rendered":"T\u00ecm hi\u1ec3u v\u1ec1 Slicer \u2013 C\u00f4ng c\u1ee5 gi\u00fap l\u1ecdc \u0111\u1ed3ng th\u1eddi nhi\u1ec1u b\u00e1o c\u00e1o Pivot table"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Nh\u01b0 ch\u00fang ta \u0111\u00e3 bi\u1ebft Pivot Table th\u01b0\u1eddng d\u00f9ng cho m\u1ee5c \u0111\u00edch t\u1ea1o c\u00e1c b\u00e1o c\u00e1o nhanh, t\u00ednh t\u00f9y bi\u1ebfn cao. V\u00e0 \u0111\u1ec3 c\u00f3 th\u1ec3 gi\u00fap ph\u00e2n t\u00edch d\u1eef li\u1ec7u t\u1eeb c\u00e1c b\u00e1o c\u00e1o m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3, ch\u00fang ta kh\u00f4ng th\u1ec3 kh\u00f4ng nh\u1eafc t\u1edbi Slicer \u2013 M\u1ed9t c\u00f4ng c\u1ee5 r\u1ea5t h\u1eefu \u00edch trong Pivot, gi\u00fap l\u1ecdc \u0111\u1ed3ng th\u1eddi nhi\u1ec1u b\u00e1o c\u00e1o Pivot Table. H\u00e3y c\u00f9ng H\u1ecdc Excel Online t\u00ecm hi\u1ec3u v\u1ec1 c\u00f4ng c\u1ee5 n\u00e0y nh\u00e9.<\/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-675531891a8d9\" 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\/tim-hieu-ve-slicer-cong-cu-giup-loc-dong-thoi-nhieu-bao-cao-pivot-table.html#Chuan_bi\" title=\"Chu\u1ea9n b\u1ecb\">Chu\u1ea9n b\u1ecb<\/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\/tim-hieu-ve-slicer-cong-cu-giup-loc-dong-thoi-nhieu-bao-cao-pivot-table.html#Cach_tao_ra_1_slicer\" title=\"C\u00e1ch t\u1ea1o ra 1 slicer\">C\u00e1ch t\u1ea1o ra 1 slicer<\/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\/tim-hieu-ve-slicer-cong-cu-giup-loc-dong-thoi-nhieu-bao-cao-pivot-table.html#Cach_ket_noi_slicer_toi_nhieu_bao_cao_Pivot_Table\" title=\"C\u00e1ch k\u1ebft n\u1ed1i slicer t\u1edbi nhi\u1ec1u b\u00e1o c\u00e1o Pivot Table\">C\u00e1ch k\u1ebft n\u1ed1i slicer t\u1edbi nhi\u1ec1u b\u00e1o c\u00e1o Pivot Table<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Chuan_bi\"><\/span>Chu\u1ea9n b\u1ecb<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 t\u1ea1o ra 1 slicer, tr\u01b0\u1edbc ti\u00ean ch\u00fang ta c\u1ea7n c\u00f3 \u00edt nh\u1ea5t 1 b\u1ea3ng b\u00e1o c\u00e1o b\u1eb1ng Pivot Table. H\u00e3y c\u00f9ng t\u1ea1o 1 v\u00e0i Pivot Table t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u sau. C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i v\u1ec1 b\u1ea3ng d\u1eef li\u1ec7u n\u00e0y t\u1ea1i \u0111\u1ecba ch\u1ec9:\u00a0<a href=\"http:\/\/bit.ly\/2LAdJKq\">http:\/\/bit.ly\/2LAdJKq<\/a><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20237\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data-pivot-table-ngan-hang.png\" width=\"812\" height=\"326\" title=\"data-pivot-table-ngan-hang\"><\/p>\n<p>Trong b\u1ea3ng d\u1eef li\u1ec7u n\u00e0y, ch\u00fang ta t\u1ea1o ra\u00a02 b\u00e1o c\u00e1o theo c\u00e1c y\u00eau c\u1ea7u nh\u01b0 sau:<\/p>\n<ul>\n<li>B\u00e1o c\u00e1o 01: B\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p s\u1ed1 ti\u1ec1n cho t\u1eebng nh\u00f3m kh\u00e1ch h\u00e0ng theo c\u00e1c ch\u01b0\u01a1ng tr\u00ecnh<\/li>\n<li>B\u00e1o c\u00e1o 02: B\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p cho t\u1eebng m\u00e3 hi\u1ec7u theo ch\u01b0\u01a1ng tr\u00ecnh Vay v\u1ed1n theo\u00a0t\u1ed5ng s\u1ed1 l\u1ea7n v\u00e0 t\u1ed5ng s\u1ed1 ti\u1ec1n ph\u00e1t sinh.<\/li>\n<\/ul>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 l\u00e0m \u0111\u01b0\u1ee3c 2 m\u1eabu b\u00e1o c\u00e1o n\u00e0y kh\u00f4ng? H\u00e3y th\u1eed l\u00e0m v\u00e0 so s\u00e1nh k\u1ebft qu\u1ea3 c\u00f9ng H\u1ecdc Excel Online nh\u00e9:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20733\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bao-cao-pivot-table-2-mau-bao-cao.png\" width=\"637\" height=\"670\" title=\"bao-cao-pivot-table-2-mau-bao-cao\"><\/p>\n<p>N\u1ebfu b\u1ea1n ch\u01b0a bi\u1ebft c\u00e1ch \u0111\u1ec3 l\u1eadp ra c\u00e1c b\u00e1o c\u00e1o n\u00e0y b\u1eb1ng Pivot Table, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 xem l\u1ea1i b\u00e0i vi\u1ebft:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-lap-bao-cao-theo-nhieu-dieu-kien-bang-pivot-table.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp b\u00e1o c\u00e1o theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng Pivot Table<\/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-377.gif\" title=\"ex101_92019-nho-377\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_tao_ra_1_slicer\"><\/span>C\u00e1ch t\u1ea1o ra 1 slicer<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 t\u1ea1o \u0111\u01b0\u1ee3c 1 Slicer, ch\u00fang ta s\u1ebd th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: Ch\u1ecdn 1 b\u1ea3ng Pivot Table b\u1ea5t k\u1ef3, trong th\u1ebb <strong>PivotTable Tools<\/strong> ch\u1ecdn m\u1ee5c<strong> Insert Slicer<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20734\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/insert-slicer-from-analyze.png\" width=\"1101\" height=\"445\" title=\"insert-slicer-from-analyze\"><\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: Ch\u1ecdn nh\u1eefng \u0111\u1ed1i t\u01b0\u1ee3ng c\u1ea7n s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m ti\u00eau ch\u00ed l\u1ecdc b\u00e1o c\u00e1o trong c\u1eeda s\u1ed5 Insert Slicer<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20735\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/select-slicer-from-insert-slicer-tab.png\" width=\"961\" height=\"671\" title=\"select-slicer-from-insert-slicer-tab\"><\/p>\n<p><strong>B\u01b0\u1edbc 3<\/strong>: S\u1eed d\u1ee5ng \u0111\u1ed1i t\u01b0\u1ee3ng trong Slicer \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u c\u1ee7a b\u00e1o c\u00e1o<\/p>\n<p>Sau khi \u0111\u00e3 t\u1ea1o ra \u0111\u01b0\u1ee3c Slicer, ch\u00fang ta ch\u1ec9 c\u1ea7n b\u1ea5m ch\u1ecdn v\u00e0o m\u1ed9t trong s\u1ed1 nh\u1eefng n\u1ed9i dung trong \u0111\u00f3 \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u c\u1ee7a b\u00e1o c\u00e1o. M\u1ed7i khi ch\u1ecdn 1 n\u1ed9i dung, b\u00e1o c\u00e1o Pivot Table s\u1ebd t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i k\u1ebft qu\u1ea3 theo n\u1ed9i dung \u0111\u01b0\u1ee3c ch\u1ecdn.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20736\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pivot-table-thay-doi-theo-slicer-01.png\" width=\"895\" height=\"249\" title=\"pivot-table-thay-doi-theo-slicer-01\"><\/p>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean, khi ch\u1ecdn cho Chi nh\u00e1nh 1, k\u1ebft qu\u1ea3 c\u1ee7a B\u00e1o c\u00e1o 01 t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i cho chi nh\u00e1nh 1. R\u1ea5t nhanh v\u00e0 hi\u1ec7u qu\u1ea3 ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_ket_noi_slicer_toi_nhieu_bao_cao_Pivot_Table\"><\/span>C\u00e1ch k\u1ebft n\u1ed1i slicer t\u1edbi nhi\u1ec1u b\u00e1o c\u00e1o Pivot Table<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u00ec trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta c\u00f3 t\u1edbi 2 Pivot Table \u0111\u01b0\u1ee3c t\u1ea1o ra t\u1eeb c\u00f9ng 1 b\u1ea3ng d\u1eef li\u1ec7u. Do \u0111\u00f3 khi ch\u1ecdn n\u1ed9i dung trong Slicer, ch\u00fang ta mu\u1ed1n c\u1ea3 2 b\u00e1o c\u00e1o \u0111\u1ec1u thay \u0111\u1ed5i theo n\u1ed9i dung n\u00e0y. \u0110\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u \u0111\u00f3, ch\u00fang ta c\u1ea7n k\u1ebft n\u1ed1i Slicer t\u1edbi b\u1ea3ng b\u00e1o c\u00e1o th\u1ee9 2.<\/p>\n<p>C\u00e1ch th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<ul>\n<li>B\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o v\u1ecb tr\u00ed b\u1ea5t k\u1ef3 trong Slicer, ch\u1ecdn <strong>Report Connections\u2026<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20737\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/report-connection-from-slicer.png\" width=\"371\" height=\"600\" title=\"report-connection-from-slicer\"><\/p>\n<ul>\n<li>Trong c\u1eeda s\u1ed5 Report Connections, \u0111\u00e1nh d\u1ea5u ch\u1ecdn cho m\u1ee5c <strong>PivotTable2<\/strong> r\u1ed3i b\u1ea5m <strong>OK<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20738\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-noi-pivot-table-02-trong-slicer.png\" width=\"1033\" height=\"672\" title=\"ket-noi-pivot-table-02-trong-slicer\"><\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta \u0111\u00e3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng Slicer \u0111\u1ec3 ph\u00e2n t\u00edch d\u1eef li\u1ec7u \u0111\u1ed3ng th\u1eddi cho c\u1ea3 2 b\u00e1o c\u00e1o \u0111\u01b0\u1ee3c r\u1ed3i. H\u00e3y c\u00f9ng th\u01b0\u1edfng th\u1ee9c th\u00e0nh qu\u1ea3 n\u00e0o:<\/p>\n<p>V\u00ed d\u1ee5: Ch\u1ec9 b\u00e1o c\u00e1o theo chi nh\u00e1nh 02 cho c\u1ea3 2 b\u1ea3ng b\u00e1o c\u00e1o, k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20739\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pivot-table-bao-cao-theo-cn02.png\" width=\"886\" height=\"674\" title=\"pivot-table-bao-cao-theo-cn02\"><\/p>\n<p>Xem th\u00eam:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-lap-bao-cao-theo-thang-bang-pivot-table-khi-du-lieu-khong-co-san-cot-thang.html\">C\u00e1ch l\u1eadp b\u00e1o c\u00e1o theo th\u00e1ng b\u1eb1ng pivot table khi d\u1eef li\u1ec7u kh\u00f4ng c\u00f3 s\u1eb5n c\u1ed9t th\u00e1ng<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-lap-bao-cao-ty-le-phan-tram-trong-excel-bang-pivot-table-don-gian-nhat.html\">C\u00e1ch l\u1eadp b\u00e1o c\u00e1o t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m trong excel b\u1eb1ng Pivot table \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/a><\/p>\n<p>\u0110\u1ec3 t\u00ecm hi\u1ec3u th\u00eam nh\u1eefng ki\u1ebfn th\u1ee9c v\u1ec1 Excel v\u00e0 Pivot table, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham gia kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2Ox1H6G\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc cung c\u1ea5p cho b\u1ea1n ki\u1ebfn th\u1ee9c \u0111\u1ea7y \u0111\u1ee7 v\u00e0 c\u00f3 h\u1ec7 th\u1ed1ng v\u1ec1 c\u00e1c h\u00e0m trong Excel, c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5 trong Excel, \u1ee9ng d\u1ee5ng Excel v\u00e0o c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3. Hi\u1ec7n nay \u0111ang c\u00f3 r\u1ea5t nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n \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\/2024\/12\/ex101_92019-nho-377.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4657,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4656","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\/4656","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=4656"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4656\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4657"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4656"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4656"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4656"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}