{"id":1532,"date":"2024-12-02T05:22:05","date_gmt":"2024-12-02T05:22:05","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/khoi-dau-voi-pivot-table-trong-excel\/"},"modified":"2024-12-02T05:22:05","modified_gmt":"2024-12-02T05:22:05","slug":"khoi-dau-voi-pivot-table-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/khoi-dau-voi-pivot-table-trong-excel\/","title":{"rendered":"Kh\u1edfi \u0111\u1ea7u v\u1edbi Pivot Table trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>B\u00e0i vi\u1ebft\u00a0 n\u00e0y, ch\u00fang t\u00f4i s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n chi ti\u1ebft t\u1eebng b\u01b0\u1edbc m\u1ed9t \u0111\u1ec3 t\u1ea1o ra m\u1ed9t pivot table c\u1ea5p cao trong Excel. L\u01b0u \u00fd r\u1eb1ng nh\u1eefng ch\u1ec9 d\u1eabn trong b\u00e0i vi\u1ebft ch\u1ec9 \u00e1p d\u1ee5ng \u0111\u01b0\u1ee3c v\u1edbi phi\u00ean b\u1ea3n Excel hi\u1ec7n h\u00e0nh (2007 v\u00e0 l\u1edbn h\u01a1n).<\/p>\n<p>\u1ede v\u00ed d\u1ee5 b\u00ean d\u01b0\u1edbi c\u00f3 s\u1eed d\u1ee5ng b\u1ea3ng t\u00ednh, trong \u0111\u00f3 bao g\u1ed3m doanh s\u1ed1 b\u00e1n h\u00e0ng c\u1ee7a m\u1ed9t c\u00f4ng ty trong qu\u00fd I n\u0103m 2016. B\u1ea3ng t\u00ednh ghi l\u1ea1i ng\u00e0y b\u00e1n h\u00e0ng (date), h\u00f3a \u0111\u01a1n t\u01b0\u01a1ng \u1ee9ng (invoice ref), t\u1ed5ng h\u00f3a \u0111\u01a1n, t\u00ean ng\u01b0\u1eddi b\u00e1n h\u00e0ng (sales rep.), v\u00e0 khu v\u1ef1c b\u00e1n h\u00e0ng (region).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-8616 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-2.png\" width=\"453\" height=\"336\" title=\"1-2\"><\/p>\n<p><strong>Tham kh\u1ea3o th\u00eam:<\/strong>\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/hoc-excel-2007\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Excel 2007 to\u00e0n t\u1eadp<\/a><\/p>\n<p>Trong v\u00ed d\u1ee5 l\u00e0 m\u1ed9t pivot table bi\u1ec3u di\u1ec5n t\u1ed5ng doanh thu t\u1eebng th\u00e1ng trong n\u0103m, \u0111\u01b0\u1ee3c chia nh\u1ecf theo khu v\u1ef1c v\u00e0 ng\u01b0\u1eddi b\u00e1n h\u00e0ng. Qu\u00e1 tr\u00ecnh t\u1ea1o ra pivot table n\u00e0y \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc nh\u01b0 sau:<\/p>\n<ol>\n<li>Ch\u1ecdn m\u1ed9t \u00f4 b\u1ea5t k\u00ec ho\u1eb7c ch\u1ecdn to\u00e0n b\u1ed9 d\u1ea3i d\u1eef li\u1ec7u trong pivot table. L\u01b0u \u00fd: N\u1ebfu b\u1ea1n ch\u1ec9 ch\u1ecdn m\u1ed9t \u00f4 duy nh\u1ea5t, Excek s\u1ebd t\u1ef1 \u0111\u1ed9ng x\u00e1c \u0111\u1ecbnh v\u00e0 ch\u1ecdn c\u1ea3 d\u1ea3i d\u1eef li\u1ec7u cho pivot table c\u1ee7a b\u1ea1n.<\/li>\n<li>Nh\u1ea5n chu\u1ed9t v\u00e0o n\u00fat Pivot Table trong nh\u00e3n \u2018<strong>Insert<\/strong>\u2018 tr\u00ean thanh c\u00f4ng c\u1ee5.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8617 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-3.png\" width=\"287\" height=\"138\" title=\"2-3\"><\/p>\n<p>3. H\u1ed9p tho\u1ea1i\u00a0\u2018<strong>Create PivotTable<\/strong>\u2018 xu\u1ea5t hi\u1ec7n. H\u00e3y ch\u1eafc ch\u1eafn r\u1eb1ng d\u1ea3i d\u1eef li\u1ec7u b\u1ea1n \u0111\u00e3 ch\u1ecdn s\u1ebd t\u01b0\u01a1ng \u1ee9ng v\u1edbi d\u1ea3i \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng cho pivot table c\u1ee7a b\u1ea1n. C\u0169ng s\u1ebd c\u00f3 m\u1ed9t t\u00f9y ch\u1ecdn y\u00eau c\u1ea7u n\u01a1i b\u1ea1n mu\u1ed1n \u0111\u1eb7t pivot table, \u0111i\u1ec1u n\u00e0y cho ph\u00e9p b\u1ea1n pivot table trong m\u1ed9t b\u1ea3ng t\u00ednh c\u1ee5 th\u1ec3. N\u1ebfu kh\u00f4ng ch\u1eafc ch\u1eafn h\u00e3y ch\u1ecdn \u2018<strong>N<\/strong><b>ew<\/b> <strong>worksheet<\/strong>\u2018<b>\u00a0<\/b>(b\u1ea3ng t\u00ednh m\u1edbi). Cu\u1ed1i c\u00f9ng ch\u1ecdn \u2018<strong>Ok<\/strong>\u2018.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-8618 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-2.png\" width=\"399\" height=\"289\" title=\"3-2\"><\/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-111.gif\" title=\"ex101_92019-nho-111\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>4. M\u1ed9t Pivot Table tr\u1ed1ng s\u1ebd xu\u1ea5t hi\u1ec7n c\u00f9ng v\u1edbi b\u1ea3ng t\u00e1c v\u1ee5 \u2018<strong>Pivot Table Field List<\/strong>\u2018 ch\u1ee9a c\u00e1c tr\u01b0\u1eddng d\u1eef li\u1ec7u, l\u01b0u \u00fd \u0111\u00e2y l\u00e0 nh\u1eefng ti\u00eau \u0111\u1ec1 t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u ban \u0111\u1ea7u c\u1ee7a b\u1ea1n. T\u1eeb b\u1ea3ng t\u00e1c v\u1ee5 \u2018<strong>Pivot Table Field List<\/strong>\u2018, th\u1ef1c hi\u1ec7n:<\/p>\n<ul>\n<li>K\u00e9o \u2018<strong>Date<\/strong>\u2018 (ng\u00e0y) v\u00e0o v\u00f9ng \u2018<strong>Row Labels<\/strong>\u2018 (ho\u1eb7c \u2018Rows\u2019) (D\u00e3y\u00a0nh\u00e3n\u00a0ho\u1eb7c d\u00e3y)<\/li>\n<li>K\u00e9o \u2018<strong>Amount<\/strong>\u2018 (s\u1ed1 l\u01b0\u1ee3ng) v\u00e0o v\u00f9ng\u00a0\u2018<strong>\u03a3 Values<\/strong>\u2018 (gi\u00e1 tr\u1ecb)<\/li>\n<li>K\u00e9o \u2018<strong>Region<\/strong>\u2018 v\u00e0o v\u00f9ng\u00a0\u2018<strong>Column Labels<\/strong>\u2018 (or \u2018Columns\u2019) (C\u1ed9t nh\u00e3n ho\u1eb7c c\u1ed9t)<\/li>\n<li>K\u00e9o \u2018<strong>Sales Rep.<\/strong>\u2018 v\u00e0o v\u00f9ng\u00a0\u2018<strong>Column Labels<\/strong>\u2018 (or \u2018Columns\u2019)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-8619 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-2-197x300-1.png\" width=\"197\" height=\"300\" title=\"4-2-197x300-1\"><\/p>\n<p>5. K\u1ebft qu\u1ea3 s\u1ebd \u0111\u01b0\u1ee3c t\u00ednh b\u1eb1ng t\u1ed5ng doanh thu h\u00e0ng ng\u00e0y t\u1ea1i m\u1ed7i khu v\u1ef1c b\u00e1n h\u00e0ng v\u00e0 m\u1ed7i ng\u01b0\u1eddi b\u00e1n h\u00e0ng nh\u01b0 h\u00ecnh d\u01b0\u1edbi:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-8620 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/5-2-300x168-1.png\" width=\"300\" height=\"168\" title=\"5-2-300x168-1\"><\/p>\n<p>Tuy nhi\u00ean, \u0111\u1ec3 nh\u00f3m ng\u00e0y l\u1ea1i th\u00e0nh th\u00e1ng c\u1ea7n th\u1ef1c hi\u1ec7n:<\/p>\n<ul>\n<li>Nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0o b\u1ea5t k\u00ec ng\u00e0y n\u00e0o trong c\u1ed9t b\u00ean tr\u00e1i trong pivot table.<\/li>\n<li>Ch\u1ecdn \u2018<strong>Group\u2026<\/strong>\u2018 (Nh\u00f3m\u2026) cho ng\u00e0y s\u1ebd xu\u1ea5t hi\u1ec7n.<\/li>\n<li>H\u1ed9p tho\u1ea1i \u2018<strong>Grouping<\/strong>\u2018 cho c\u00e1c ng\u00e0y s\u1ebd xu\u1ea5t hi\u1ec7n.\u00a0Ch\u1ecdn \u2018<strong>Months<\/strong>\u2018 (Th\u00e1ng) (l\u01b0u \u00fd r\u1eb1ng b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 nh\u00f3m c\u00e1c ng\u00e0y v\u00e0 gi\u1edd theo c\u00e1c kho\u1ea3ng th\u1eddi gian kh\u00e1c nh\u01b0 qu\u00fd,\u2026<\/li>\n<li>Ch\u1ecdn \u2018<strong>Ok<\/strong>\u2018.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8621 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/6-2.png\" width=\"197\" height=\"250\" title=\"6-2\"><\/p>\n<p>Nh\u01b0 y\u00eau c\u1ea7u, pivot table cu\u1ed1i c\u00f9ng s\u1ebd bi\u1ec3u di\u1ec5n t\u1ed5ng doanh thu theo th\u00e1ng, chia nh\u1ecf theo khu v\u1ef1c v\u00e0 ng\u01b0\u1eddi b\u00e1n h\u00e0ng:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-8622 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-2-300x78-1.png\" width=\"300\" height=\"78\" title=\"7-2-300x78-1\"><\/p>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n ho\u00e0n thi\u1ec7n pivot table, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ecbnh d\u1ea1ng c\u1ed9t B-G theo \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7. C\u00e1ch d\u1ec5 nh\u1ea5t \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng m\u1ed9t d\u1ea3i \u00f4 v\u1ec1 \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7 l\u00e0 ch\u1ecdn d\u1ea3i \u00f4 mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng, sau \u0111\u00f3 nh\u1ea5n chu\u1ed9t v\u00e0o n\u00fat \u0111\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec7 n\u1eb1m \u1edf nh\u00f3m \u2018<strong>Number<\/strong>\u2018 (s\u1ed1) trong nh\u00e3n \u2018<strong>Home<\/strong>\u2018 tr\u00ean thanh c\u00f4ng c\u1ee5.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8623 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/8-1.png\" width=\"144\" height=\"87\" title=\"8-1\"><\/p>\n<p><strong>B\u1ed9 l\u1ecdc b\u00e1o c\u00e1o Pivot Table<\/strong><\/p>\n<p>B\u1ed9 l\u1ecdc b\u00e1o c\u00e1o Pivot Table cho ph\u00e9p b\u1ea1n quan s\u00e1t d\u1eef li\u1ec7u c\u1ee7a t\u1eebng gi\u00e1 tr\u1ecb, t\u1eebng v\u00f9ng ch\u1ecdn c\u1ee7a nh\u1eefng gi\u00e1 tr\u1ecb x\u00e1c \u0111\u1ecbnh trong v\u00f9ng d\u1eef li\u1ec7u.<\/p>\n<p>V\u00ed d\u1ee5, trong pivot table ph\u00eda tr\u00ean, b\u1ea1n ch\u1ec9 c\u00f3 th\u1ec3 quan s\u00e1t d\u1eef li\u1ec7u doanh thu c\u1ee7a khu v\u1ef1c ph\u00eda B\u1eafc ho\u1eb7c ph\u00eda Nam. \u0110\u1ec3 quan s\u00e1t \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u doanh thu v\u00f9ng ph\u00eda B\u1eafc (North), quay tr\u1edf l\u1ea1i b\u1ea3ng t\u00e1c v\u1ee5\u00a0\u2018<strong>Pivot Table Field List<\/strong>\u2018 v\u00e0 k\u00e9o m\u1ee5c \u2018<strong>Region<\/strong>\u2018 v\u00e0o v\u00f9ng\u00a0\u2018<strong>Report Filter<\/strong>\u2018 (ho\u1eb7c \u2018Filters\u2019) (B\u1ed9 l\u1ecdc b\u00e1o c\u00e1o ho\u1eb7c b\u1ed9 l\u1ecdc).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-8614 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/9-1-204x300-1.png\" width=\"204\" height=\"300\" title=\"9-1-204x300-1\"><\/p>\n<p>B\u1ea1n s\u1ebd th\u1ea5y \u2018<strong>Region<\/strong>\u2018 xu\u1ea5t hi\u1ec7n \u1edf \u0111\u1ea7u pivot table. S\u1eed d\u1ee5ng\u00a0drop-down list (danh s\u00e1ch x\u1ed5 xu\u1ed1ng) c\u1ee7a v\u00f9ng n\u00e0y \u0111\u1ec3 ch\u1ecdn \u2018<strong>North<\/strong>\u2018. K\u1ebft qu\u1ea3 pivot table s\u1ebd ch\u1ec9 bi\u1ec3u di\u1ec5n doanh thu c\u1ee7a v\u00f9ng ph\u00eda B\u1eafc:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-8615 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/10-1-300x162-1.png\" width=\"300\" height=\"162\" title=\"10-1-300x162-1\"><\/p>\n<blockquote>\n<p>T\u00ecm hi\u1ec3u ngay:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-ke-toan.html\">l\u01a1\u0301p h\u1ecdc Excel k\u1ebf to\u00e1n<\/a> t\u1ea1i H\u00e0 N\u1ed9i<\/p>\n<\/blockquote>\n<p>\u00a0<\/p>\n<p>\u00a0<\/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-111.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1533,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1532","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\/1532","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=1532"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1532\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1533"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1532"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1532"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1532"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}