{"id":8745,"date":"2024-12-29T05:27:07","date_gmt":"2024-12-29T05:27:07","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/29\/huong-dan-cach-lap-bao-cao-theo-khoang-dieu-kien-bang-pivot-table\/"},"modified":"2024-12-29T05:27:07","modified_gmt":"2024-12-29T05:27:07","slug":"huong-dan-cach-lap-bao-cao-theo-khoang-dieu-kien-bang-pivot-table","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/29\/huong-dan-cach-lap-bao-cao-theo-khoang-dieu-kien-bang-pivot-table\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp b\u00e1o c\u00e1o theo kho\u1ea3ng \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng Pivot Table"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Ch\u00fang ta t\u1eebng bi\u1ebft t\u1edbi r\u1ea5t nhi\u1ec1u t\u00e1c d\u1ee5ng c\u1ee7a Pivot Table nh\u01b0: L\u1eadp b\u00e1o c\u00e1o kh\u00f4ng c\u1ea7n vi\u1ebft c\u00f4ng th\u1ee9c, b\u00e1o c\u00e1o t\u1ef1\u00a0\u0111\u1ed9ng, b\u00e1o c\u00e1o theo nhi\u1ec1u lo\u1ea1i d\u1eef li\u1ec7u\u2026 Nh\u01b0ng v\u1edbi\u00a0\u0111i\u1ec1u ki\u1ec7n n\u1eb1m trong 1 kho\u1ea3ng th\u00ec l\u00e0m th\u1ebf n\u00e0o? Trong b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u\u00a0c\u00e1ch l\u1eadp b\u00e1o c\u00e1o theo kho\u1ea3ng \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng Pivot Table nh\u00e9.<\/p>\n<p>Ch\u00fang ta c\u00f9ng x\u00e9t v\u00ed d\u1ee5 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26946\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/yeu-cau-bao-cao-theo-khoang.png\" width=\"934\" height=\"350\" title=\"yeu-cau-bao-cao-theo-khoang\"><\/p>\n<p>Trong h\u00ecnh tr\u00ean ch\u00fang ta c\u00f3 1 b\u1ea3ng d\u1eef li\u1ec7u g\u1ed3m 65 ng\u01b0\u1eddi k\u00e8m theo th\u00f4ng tin ng\u00e0y sinh.<\/p>\n<p>Y\u00eau c\u1ea7u l\u1eadp b\u00e1o c\u00e1o th\u1ed1ng k\u00ea theo\u00a0\u0111\u1ed9 tu\u1ed5i, gi\u1ea3 s\u1eed th\u1ed1ng k\u00ea theo 3 kho\u1ea3ng: D\u01b0\u1edbi 30, t\u1eeb 30 t\u1edbi 40, tr\u00ean 40<\/p>\n<p>V\u00e0 b\u00e1o c\u00e1o tr\u00ean th\u1ef1c hi\u1ec7n b\u1eb1ng Pivot Table th\u00ec l\u00e0m nh\u01b0 th\u1ebf n\u00e0o?<\/p>\n<p>Tr\u01b0\u1edbc h\u1ebft b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i file m\u1eabu tr\u00ean\u00a0\u0111\u1ec3 l\u00e0m theo h\u01b0\u1edbng d\u1eabn trong b\u00e0i vi\u1ebft t\u1ea1i\u00a0\u0111\u1ecba ch\u1ec9:\u00a0<a href=\"http:\/\/bit.ly\/2UXwRqr\">http:\/\/bit.ly\/2UXwRqr<\/a><\/p>\n<h2>C\u00e1ch l\u1eadp b\u00e1o c\u00e1o theo kho\u1ea3ng \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng Pivot Table<\/h2>\n<p><strong>B\u01b0\u1edbc 1:<\/strong><\/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-816.gif\" title=\"ex101_92019-nho-816\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u0110\u1ea7u ti\u00ean ch\u00fang ta x\u00e1c\u00a0\u0111\u1ecbnh tu\u1ed5i c\u1ee7a nh\u1eefng ng\u01b0\u1eddi trong b\u1ea3ng b\u1eb1ng c\u00f4ng th\u1ee9c:<\/p>\n<p style=\"padding-left: 30px\">L\u1ea5y s\u1ed1 n\u0103m hi\u1ec7n t\u1ea1i \u2013 N\u0103m sinh c\u1ee7a t\u1eebng ng\u01b0\u1eddi<\/p>\n<p>H\u00e0m x\u00e1c\u00a0\u0111\u1ecbnh s\u1ed1 n\u0103m l\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dung-ham-year-trong-excel-de-lap-bao-cao-theo-nam.html\">h\u00e0m YEAR<\/a><\/p>\n<p>H\u00e0m x\u00e1c\u00a0\u0111\u1ecbnh ng\u00e0y hi\u1ec7n t\u1ea1i l\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dung-ham-now-today-time-trong-vba-excel.html\">h\u00e0m TODAY<\/a><\/p>\n<p>K\u1ebft qu\u1ea3 l\u00e0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-26947\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cong-thuc-tinh-tuoi-1024x280-1.png\" width=\"1024\" height=\"280\" title=\"cong-thuc-tinh-tuoi-1024x280-1\"><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong><\/p>\n<p>Ti\u1ebfp theo l\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/khoi-dau-voi-pivot-table-trong-excel.html\">t\u1ea1o b\u00e1o c\u00e1o b\u1eb1ng Pivot Table<\/a>:<\/p>\n<ul>\n<li>Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n s\u1eed d\u1ee5ng\u00a0\u0111\u1ec3 l\u1eadp b\u00e1o c\u00e1o (B2:D67), v\u00f9ng n\u00e0y ph\u1ea3i bao g\u1ed3m c\u1ea3 d\u00f2ng ti\u00eau\u00a0\u0111\u1ec1 (d\u00f2ng 2)<\/li>\n<li>T\u1ea1o Pivot Table b\u1eb1ng c\u00e1ch ch\u1ecdn th\u1ebb\u00a0Insert &gt; Pivot Table &gt; Trong c\u1eeda s\u1ed5 Create PivotTable ch\u1ecdn\u00a0Exitsting\u00a0Worksheet l\u00e0 1 v\u1ecb tr\u00ed x\u00e1c\u00a0\u0111\u1ecbnh (v\u00ed d\u1ee5\u00a0\u00f4 F3) nh\u01b0 trong h\u00ecnh<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-26948\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/create-pivot-table-1024x410-1.png\" width=\"1024\" height=\"410\" title=\"create-pivot-table-1024x410-1\"><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong><\/p>\n<p>Ch\u1ecdn\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng\u00a0\u0111\u1ec3 tr\u00ecnh b\u00e0y b\u00e1o c\u00e1o.<\/p>\n<p>V\u00ec m\u1ee5c\u00a0\u0111\u00edch c\u1ee7a b\u00e1o c\u00e1o l\u00e0 Th\u1ed1ng k\u00ea theo\u00a0\u0111\u1ed9 tu\u1ed5i n\u00ean ch\u00fang ta c\u00f3 c\u00e1c ti\u00eau ch\u00ed:<\/p>\n<ul>\n<li><strong>\u0110\u1ed1i t\u01b0\u1ee3ng Row<\/strong>: l\u00e0 c\u00e1c m\u1ed1c tu\u1ed5i<\/li>\n<li><strong>\u0110\u1ed1i t\u01b0\u1ee3ng Value (k\u1ebft qu\u1ea3)<\/strong>:\u00a0\u0110\u1ebfm (Count) theo tu\u1ed5i<\/li>\n<\/ul>\n<p>Trong PivotTable Field ch\u00fang ta tr\u00ecnh b\u00e0y nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26949\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pivottable-dem-theo-tuoi.png\" width=\"730\" height=\"702\" title=\"pivottable-dem-theo-tuoi\"><\/p>\n<p>C\u00f3 th\u1ec3 th\u1ea5y b\u00e1o c\u00e1o PivotTable\u00a0\u0111\u00e3 th\u1ed1ng k\u00ea chi ti\u1ebft theo t\u1eebng\u00a0\u0111\u1ed9 tu\u1ed5i c\u1ee5 th\u1ec3. Tuy nhi\u00ean ch\u00fang ta mu\u1ed1n l\u1eadp b\u00e1o c\u00e1o theo kho\u1ea3ng\u00a0\u0111\u1ed9 tu\u1ed5i, thay v\u00ec\u00a0c\u1ee5 th\u1ec3 t\u1eebng tu\u1ed5i.<\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong><\/p>\n<p>Ph\u00e2n nh\u00f3m kho\u1ea3ng trong b\u00e1o c\u00e1o.<\/p>\n<p>B\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng Rows trong b\u00e1o c\u00e1o, ch\u1ecdn Group (nh\u00f3m)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26950\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/select-group-pivot-table.png\" width=\"366\" height=\"609\" title=\"select-group-pivot-table\"><\/p>\n<p>Trong m\u1ee5c nh\u00f3m n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 ch\u1ecdn c\u00e1c ti\u00eau ch\u00ed ph\u00e2n nh\u00f3m nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26951\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tieu-chi-phan-nhom-pivot-table.png\" width=\"290\" height=\"220\" title=\"tieu-chi-phan-nhom-pivot-table\"><\/p>\n<ul>\n<li>Starting at: Gi\u00e1 tr\u1ecb b\u1eaft\u00a0\u0111\u1ea7u (nh\u1ecf nh\u1ea5t)<\/li>\n<li>Ending at: Gi\u00e1 tr\u1ecb k\u1ebft th\u00fac (l\u1edbn nh\u1ea5t)<\/li>\n<li>By: Kho\u1ea3ng c\u00e1ch, ph\u1ea1m vi,\u00a0\u0111\u1ed9 l\u1edbn trong t\u1eebng nh\u00f3m<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5 ch\u00fang ta c\u00f3 3 m\u1ed1c l\u00e0 D\u01b0\u1edbi 30, t\u1eeb 30-40 v\u00e0 tr\u00ean 40, ta c\u00f3 th\u1ec3 ph\u00e2n chia nh\u01b0 sau:<\/p>\n<ul>\n<li>B\u1eaft\u00a0\u0111\u1ea7u t\u1eeb 20<\/li>\n<li>K\u1ebft th\u00fac l\u00e0 50<\/li>\n<li>Kho\u1ea3ng c\u00e1ch m\u1ed7i nh\u00f3m tu\u1ed5i l\u00e0 10<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26952\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/phan-nhom-theo-3-moc-tuoi.png\" width=\"574\" height=\"220\" title=\"phan-nhom-theo-3-moc-tuoi\"><\/p>\n<p>Nh\u01b0 v\u1eady k\u1ebft qu\u1ea3 c\u1ee7a PivotTable\u00a0\u0111\u00e3 ch\u00ednh x\u00e1c theo\u00a0\u00fd mu\u1ed1n r\u1ed3i ph\u1ea3i kh\u00f4ng n\u00e0o.<\/p>\n<p>T\u00ednh n\u0103ng Group l\u00e0 1 t\u00ednh n\u0103ng r\u1ea5t h\u1eefu\u00a0\u00edch c\u1ee7a PivotTable trong vi\u1ec7c gi\u00fap ch\u00fang ta c\u00f3 th\u1ec3 b\u00e1o c\u00e1o theo c\u00e1c kho\u1ea3ng c\u00e1ch nh\u1ea5t\u00a0\u0111\u1ecbnh, tr\u00e1nh vi\u1ec7c b\u00e1o c\u00e1o th\u1ec3 hi\u1ec7n qu\u00e1 nhi\u1ec1u n\u1ed9i dung chi ti\u1ebft kh\u00f4ng c\u1ea7n thi\u1ebft,\u00a0\u0111\u1eb7c bi\u1ec7t trong nh\u1eefng m\u1ee5c\u00a0\u0111\u00edch th\u1ed1ng k\u00ea v\u1edbi d\u1eef li\u1ec7u c\u00f3 bi\u00ean\u00a0\u0111\u1ed9 l\u1edbn.<\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam c\u00e1c\u00a0\u1ee9ng d\u1ee5ng th\u00fa v\u1ecb kh\u00e1c c\u1ee7a Pivot Table t\u1ea1i c\u00e1c b\u00e0i vi\u1ebft sau:<\/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 style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-xep-hang-trong-bao-cao-bang-pivot-table.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch x\u1ebfp h\u1ea1ng trong b\u00e1o c\u00e1o b\u1eb1ng Pivot Table<\/a><\/p>\n<p style=\"padding-left: 30px\"><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<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<\/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-816.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8746,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8745","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\/8745","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=8745"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8745\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8746"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8745"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8745"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8745"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}