{"id":28882,"date":"2021-08-14T09:10:28","date_gmt":"2021-08-14T02:10:28","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=28882"},"modified":"2021-08-14T09:11:00","modified_gmt":"2021-08-14T02:11:00","slug":"pivot-table-la-gi","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/pivot-table-la-gi\/","title":{"rendered":"Pivot Table l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng Pivot Table \u0111\u1ec3 th\u1ed1ng k\u00ea"},"content":{"rendered":"

Pivot Table l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 r\u1ea5t h\u1eefu \u00edch trong Excel nh\u01b0ng l\u1ea1i ch\u01b0a \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi bi\u1ebft \u0111\u1ebfn. C\u00f4ng c\u1ee5 n\u00e0y th\u01b0\u1eddng d\u00f9ng trong vi\u1ec7c th\u1ed1ng k\u00ea d\u1eef li\u1ec7u. V\u1eady Pivot Table l\u00e0 g\u00ec<\/strong> v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng Ben Computer t\u00ecm c\u00e2u tr\u1ea3 l\u1eddi \u1edf b\u00e0i vi\u1ebft n\u00e0y nh\u00e9!<\/p>\n

1\/ Pivot Table l\u00e0 g\u00ec?<\/strong><\/span><\/h2>\n

Nh\u01b0 \u0111\u00e3 gi\u1edbi thi\u1ec7u \u1edf tr\u00ean, Pivot Table l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 trong Excel. C\u1ee5 th\u1ec3, \u0111\u00e2y l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 gi\u00fap ph\u00e2n t\u00edch, l\u1ecdc v\u00e0 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u t\u1eeb m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u l\u1edbn m\u1ed9t c\u00e1ch khoa h\u1ecdc v\u00e0 nhanh ch\u00f3ng. D\u00f9 b\u1ea1n c\u00f3 m\u1ed9t kh\u1ed1i d\u1eef li\u1ec7u l\u1edbn th\u00ec Pivot table c\u0169ng c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n t\u1ed5ng h\u1ee3p v\u00e0 thu g\u1ecdn theo nh\u01b0 y\u00eau c\u1ea7u. Nh\u1edd c\u00f3 Pivot Table, b\u1ea1n s\u1ebd d\u1ec5 d\u00e0ng n\u1eafm b\u1eaft d\u1eef li\u1ec7u v\u00e0 h\u1ea1ch to\u00e1n \u0111\u01a1n gi\u1ea3n h\u01a1n.<\/p>\n

\"Pivot<\/p>\n

2\/ C\u00e1ch s\u1eed d\u1ee5ng Pivot Table \u0111\u1ec3 th\u1ed1ng k\u00ea trong Excel<\/strong><\/span><\/h2>\n

V\u1edbi c\u00e1ch gi\u1ea3i th\u00edch \u1edf tr\u00ean, ch\u1eafc h\u1eb3n b\u1ea1n \u0111\u00e3 hi\u1ec3u Pivot Table l\u00e0 g\u00ec<\/strong> r\u1ed3i \u0111\u00fang kh\u00f4ng n\u00e0o? V\u1eady c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 n\u00e0y nh\u01b0 th\u1ebf n\u00e0o? \u0110\u1ec3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Pivot Table m\u1ed9t c\u00e1ch th\u00e0nh th\u1ea1o, tr\u01b0\u1edbc ti\u00ean, c\u00e1c b\u1ea1n c\u1ea7n n\u1eafm \u0111\u01b0\u1ee3c c\u00e1ch s\u1eed d\u1ee5ng c\u01a1 b\u1ea3n c\u1ee7a Pivot Table, hi\u1ec3u v\u00e0 \u00e1p d\u1ee5ng \u0111\u01b0\u1ee3c nh\u1eefng l\u1ec7nh trong Pivot Table.<\/p>\n

\u0110\u1ec3 hi\u1ec3u r\u00f5 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng Pivot Table, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o v\u00ed d\u1ee5 sau \u0111\u00e2y.<\/p>\n

V\u00ed d\u1ee5:<\/strong> Gi\u1ea3 s\u1eed, b\u1ea1n c\u00f3 m\u1ed9t h\u1ec7 th\u1ed1ng si\u00eau th\u1ecb \u1edf c\u00e1c chi nh\u00e1nh kh\u00e1c nhau. N\u1ebfu b\u1ea1n mu\u1ed1n th\u1ed1ng k\u00ea t\u1ed5ng doanh thu t\u1eeb m\u1ed9t m\u1eb7t h\u00e0ng c\u1ee5 th\u1ec3 trong t\u1ea5t c\u1ea3 c\u00e1c chi nh\u00e1nh c\u1ee7a h\u1ec7 th\u1ed1ng si\u00eau th\u1ecb, c\u00e1c b\u1ea1n s\u1ebd d\u00f9ng Pivot Table \u0111\u1ec3 th\u1ed1ng k\u00ea nh\u01b0 sau:<\/em><\/p>\n

B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u trong b\u1ea3ng d\u1eef li\u1ec7u t\u1ed5ng m\u00e0 b\u1ea1n mu\u1ed1n truy v\u1ea5n =><\/strong> ch\u1ecdn l\u1ec7nh Insert<\/strong> tr\u00ean thanh menu =><\/strong> Ch\u1ecdn Pivot Table<\/strong><\/p>\n

\"s\u1eed<\/p>\n

B\u01b0\u1edbc 2:\u00a0<\/strong>Sau \u0111\u00f3, giao di\u1ec7n s\u1ebd hi\u1ec3n th\u1ecb h\u1ed9p tho\u1ea1i Create PivotTable.<\/strong> Trong ph\u1ea7n Table\/Range <\/strong>s\u1ebd hi\u1ec3n th\u1ecb v\u00f9ng d\u1eef li\u1ec7u m\u00e0 c\u00e1c b\u1ea1n v\u1eeba l\u1ef1a ch\u1ecdn truy v\u1ea5n. Ngay ph\u00eda b\u00ean d\u01b0\u1edbi, c\u00e1c b\u1ea1n s\u1ebd th\u1ea5y l\u1ec7nh “Choose where you want the PivotTable report to be replaced”, <\/strong>\u1edf ph\u00eda d\u01b0\u1edbi c\u00f3 hai l\u1ef1a ch\u1ecdn New worksheet <\/strong>v\u00e0 Exsisting Worksheet.<\/strong> L\u1ec7nh \u0111\u00f3 c\u00f3 ngh\u0129a l\u00e0 c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn v\u1ecb tr\u00ed \u0111\u1ec3 \u0111\u1eb7t PivotTable, <\/strong>c\u00f3 th\u1ec3 n\u1eb1m trong sheet m\u1edbi ho\u1eb7c trong sheet hi\u1ec7n t\u1ea1i c\u00f3 ph\u1ea7n Location<\/strong> nh\u01b0 m\u00f4 t\u1ea3 ngay b\u00ean d\u01b0\u1edbi.<\/p>\n

\"Pivot<\/p>\n

Sau khi \u0111\u00e3 nh\u1eadp xong h\u1ebft nh\u1eefng th\u00f4ng tin v\u1ec1 v\u1ecb tr\u00ed, c\u00e1c b\u1ea1n nh\u1ea5n ch\u1ecdn Ok<\/strong><\/p>\n

B\u01b0\u1edbc 3: <\/strong>Sau \u0111\u00f3, c\u00e1c b\u1ea1n s\u1ebd th\u1ea5y tr\u00ean giao di\u1ec7n ph\u1ea7n m\u1ec1m hi\u1ec7n l\u00ean m\u1ed9t b\u1ea3ng PivotTable Fields. <\/strong>\u1ede m\u1ee5c Choose fields to add report,\u00a0<\/strong>c\u00e1c b\u1ea1n s\u1ebd th\u1ea5y h\u1ec7 th\u1ed1ng \u0111\u00e3 ph\u00e2n t\u00edch v\u00e0 chia ra nh\u1eefng v\u00f9ng th\u00f4ng tin \u1edf b\u00ean d\u01b0\u1edbi, c\u00e1c b\u1ea1n ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u mu\u1ed1n th\u00eam v\u00e0o PivotTable. <\/strong>C\u00e1c b\u1ea1n t\u00edch ch\u1ecdn m\u1eb7t h\u00e0ng v\u00e0 chi nh\u00e1nh m\u00e0 m\u00ecnh mu\u1ed1n t\u1ed5ng k\u1ebft doanh thu.<\/p>\n

\"Pivot<\/p>\n

B\u01b0\u1edbc 4:<\/strong> B\u00ean d\u01b0\u1edbi c\u1ee7a b\u1ea3ng PivotTable Fields, <\/strong>c\u00e1c b\u1ea1n th\u1ea5y l\u1ec7nh Drag Fields between areas below <\/strong>bao g\u1ed3m 4 th\u00f4ng tin: Filters, columns, rows, values. <\/strong>Sau khi b\u1ea1n t\u00edch v\u00e0o c\u00e1c v\u00f9ng d\u1eef li\u1ec7u b\u00ean tr\u00ean th\u00ec \u1edf \u00f4 Rows <\/strong>s\u1ebd hi\u1ec7n l\u00ean t\u00ean v\u00f9ng d\u1eef li\u1ec7u. C\u00e1c b\u1ea1n gi\u1eef chu\u1ed9t v\u00e0 k\u00e9o sang \u00f4 b\u00ean c\u1ea1nh Values.<\/strong> Trong \u00f4 Values,<\/strong> c\u00e1c b\u1ea1n ch\u1ecdn h\u00e0m t\u00ednh to\u00e1n ph\u00f9 h\u1ee3p v\u1edbi nhu c\u1ea7u. Trong v\u00ed d\u1ee5 n\u00e0y, c\u00e1c b\u1ea1n ch\u1ecdn h\u00e0m Sum <\/strong>\u0111\u1ec3 t\u00ednh t\u1ed5ng doanh thu.<\/p>\n

\"Pivot<\/p>\n

Sau khi th\u1ea5y Values hi\u1ec3n th\u1ecb tr\u00ean m\u00e0n h\u00ecnh b\u00ean tr\u00e1i, b\u1ea1n \u0111\u00e3 th\u1ed1ng k\u00ea xong doanh thu c\u1ee7a m\u1eb7t h\u00e0ng \u0111\u00f3.<\/p>\n

Tr\u00ean \u0111\u00e2y l\u00e0 m\u1ed9t v\u00ed d\u1ee5 c\u01a1 b\u1ea3n v\u1ec1 vi\u1ec7c s\u1eed d\u1ee5ng PivotTable \u0111\u1ec3 th\u1ed1ng k\u00ea. Ngo\u00e0i ra PivotTable c\u00f3 th\u1ec3 d\u00f9ng v\u00e0o nhi\u1ec1u ho\u1ea1t \u0111\u1ed9ng kh\u00e1c n\u1eefa c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u th\u00eam.<\/p>\n

K\u1ebft lu\u1eadn: <\/strong>Tr\u00ean \u0111\u00e2y, Ben Computer \u0111\u00e3 cung c\u1ea5p cho c\u00e1c b\u1ea1n th\u00f4ng tin v\u1ec1 PivotTable l\u00e0 g\u00ec<\/strong> v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng Pivot Table \u0111\u1ec3 th\u1ed1ng k\u00ea. N\u1ebfu c\u00e1c b\u1ea1n c\u00f3 th\u1eafc m\u1eafc g\u00ec h\u00e3y comment xu\u1ed1ng ph\u00eda d\u01b0\u1edbi \u0111\u1ec3 th\u1ea3o lu\u1eadn c\u00f9ng Ben Computer<\/a> nh\u00e9!<\/p>\n","protected":false},"excerpt":{"rendered":"

Pivot Table l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 r\u1ea5t h\u1eefu \u00edch trong Excel nh\u01b0ng l\u1ea1i ch\u01b0a \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi bi\u1ebft \u0111\u1ebfn. C\u00f4ng c\u1ee5 n\u00e0y th\u01b0\u1eddng d\u00f9ng trong vi\u1ec7c th\u1ed1ng k\u00ea d\u1eef li\u1ec7u. V\u1eady Pivot Table l\u00e0 g\u00ec v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng Ben Computer t\u00ecm c\u00e2u tr\u1ea3 l\u1eddi \u1edf b\u00e0i vi\u1ebft […]<\/p>\n","protected":false},"author":25,"featured_media":28883,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[11],"tags":[],"class_list":["post-28882","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat-van-phong"],"_links":{"self":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/28882","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=28882"}],"version-history":[{"count":0,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/28882\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/28883"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=28882"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=28882"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=28882"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}