{"id":2143,"date":"2024-12-02T07:05:05","date_gmt":"2024-12-02T07:05:05","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet\/"},"modified":"2024-12-02T07:05:05","modified_gmt":"2024-12-02T07:05:05","slug":"6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet\/","title":{"rendered":"6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p><em><span style=\"font-weight: 400\">\u1ede nh\u1eefng b\u00e0i tr\u01b0\u1edbc ch\u00fang ta \u0111\u00e3 bi\u1ebft \u0111\u1ebfn nh\u1eefng ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n c\u1ee7a PivotTables. Trong b\u00e0i vi\u1ebft h\u00f4m nay <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd gi\u1edbi thi\u1ec7u b\u1ea1n nh\u1eefng<a href=\"http:\/\/blog.ezworkapp.com\/6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet.html\"> <strong>k\u1ef9 thu\u1eadt n\u00e2ng cao cho Pivottable<\/strong>.<\/a>\u00a0<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">PivotTable c\u00f3 r\u1ea5t nhi\u1ec1u t\u00ednh n\u0103ng h\u1eefu \u00edch tuy nhi\u00ean r\u1ea5t kh\u00f3 \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c to\u00e0n di\u1ec7n v\u1ec1 c\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a n\u00f3. V\u00ec v\u1eady \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c nh\u1eefng ki\u1ebfn th\u1ee9c n\u1ec1n t\u1ea3ng ch\u00fang ta s\u1ebd chia nh\u1ecf nh\u1eefng t\u00ednh n\u0103ng \u0111\u1ec3 t\u00ecm hi\u1ec3u k\u1ef9 t\u1eeb \u0111\u00f3 khai th\u00e1c s\u1ee9c m\u1ea1nh t\u1ed1i \u0111a c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\/khoi-dau-voi-pivot-table-trong-excel.html\"><strong>PivotTables<\/strong>.<\/a><\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 c\u00f3 th\u1ec3 h\u00ecnh dung \u0111\u01b0\u1ee3c ch\u00fang ta s\u1ebd theo d\u00f5i v\u00ed d\u1ee5 s\u1eed d\u1ee5ng trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y: Jason s\u1ea3n xu\u1ea5t v\u00e0 b\u00e1n bia t\u1ea1i nh\u00e0 m\u00e1y bia \u1edf ch\u00ednh qu\u00ea h\u01b0\u01a1ng \u00f4ng \u1ea5y. \u0110\u1ec3 theo d\u00f5i doanh s\u1ed1 b\u00e1n h\u00e0ng th\u00ec Jason \u0111\u00e3 s\u1eed d\u1ee5ng c\u00e1c PivotTable. V\u00e0 b\u00e2y gi\u1edd ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u m\u1ed9t s\u1ed1 k\u1ef9 thu\u1eadt n\u00e2ng cao cho PivotTable d\u01b0\u1edbi \u0111\u00e2y nh\u00e9.<\/span><\/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-674d5c20a9228\" 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\/6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet.html#1_Su_dung_Slicer\" title=\"1. S\u1eed d\u1ee5ng Slicer\">1. S\u1eed d\u1ee5ng Slicer<\/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\/6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet.html#2_Tao_Calculated_Field\" title=\"2. T\u1ea1o Calculated Field\">2. T\u1ea1o Calculated Field<\/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\/6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet.html#3_Tao_nhieu_PivotTable_tu_mot_PivotTable_goc\" title=\"3. T\u1ea1o nhi\u1ec1u PivotTable t\u1eeb m\u1ed9t PivotTable g\u1ed1c\">3. T\u1ea1o nhi\u1ec1u PivotTable t\u1eeb m\u1ed9t PivotTable g\u1ed1c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet.html#4_An_hoac_hien_tong_phu\" title=\"4. \u1ea8n ho\u1eb7c hi\u1ec7n t\u1ed5ng ph\u1ee5\">4. \u1ea8n ho\u1eb7c hi\u1ec7n t\u1ed5ng ph\u1ee5<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet.html#5_Cach_xem_chi_tiet_tung_du_lieu_trong_bang_tong_hop\" title=\"5. C\u00e1ch xem chi ti\u1ebft t\u1eebng d\u1eef li\u1ec7u trong b\u1ea3ng t\u1ed5ng h\u1ee3p\">5. C\u00e1ch xem chi ti\u1ebft t\u1eebng d\u1eef li\u1ec7u trong b\u1ea3ng t\u1ed5ng h\u1ee3p<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet.html#6_Lam_moi_du_lieu\" title=\"6. L\u00e0m m\u1edbi d\u1eef li\u1ec7u\">6. L\u00e0m m\u1edbi d\u1eef li\u1ec7u<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"1_Su_dung_Slicer\"><\/span><b>1. S\u1eed d\u1ee5ng Slicer<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Slicer l\u00e0 c\u00f4ng c\u1ee5 c\u1ef1c k\u1ef3 h\u1eefu \u00edch\u00a0 trong vi\u1ec7c ph\u00e2n t\u00edch nhi\u1ec1u d\u1eef li\u1ec7u. Slicer ch\u00ednh x\u00e1c l\u00e0 g\u00ec? N\u00f3i m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n Slicer d\u00f9ng \u0111\u1ec3 li\u00ean k\u1ebft nhi\u1ec1u Pivottables v\u1edbi nhau t\u1eeb \u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3 l\u1ecdc d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh t\u1eeb nh\u1eefng b\u1ea3ng \u0111\u00f3 c\u00f9ng m\u1ed9t l\u00fac, thay v\u00ec b\u1ea1n ph\u1ea3i l\u1ecdc d\u1eef li\u1ec7u tr\u00ean t\u1eebng b\u1ea3ng t\u1ed5ng h\u1ee3p ri\u00eang l\u1ebb.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed tr\u01b0\u1eddng h\u1ee3p sau \u0111\u00e2y l\u00e0 Jason \u0111ang xem x\u00e9t hai b\u1ea3ng t\u1ed5ng h\u1ee3p kh\u00e1c nhau: M\u1ed9t b\u1ea3ng hi\u1ec3n th\u1ecb doanh s\u1ed1 bia b\u00e1n \u0111\u01b0\u1ee3c theo qu\u00fd v\u00e0 m\u1ed9t b\u1ea3ng hi\u1ec3n th\u1ecb doanh s\u1ed1 b\u00e1n bia theo quy m\u00f4. Hi\u1ec7n t\u1ea1i anh \u1ea5y \u0111ang c\u00e2n nh\u1eafc d\u1eef li\u1ec7u cho c\u1ea3 2 n\u0103m l\u00e0 2016, 2017:<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110i\u1ec1u m\u00e0 Jason mu\u1ed1n l\u00e0 \u0111i s\u00e2u xem doanh s\u1ed1 b\u00e1n bia theo qu\u00fd v\u00e0 theo quy m\u00f4 ch\u1ec9 ri\u00eang n\u0103m 2016. Thay v\u00ec l\u1ecdc tr\u00ean c\u1ea3 2 n\u0103m \u0111\u00f3 th\u00ec anh ta c\u00f3 th\u1ec3 t\u1ea1o ra m\u1ed9t b\u1ed9 l\u1ecdc ri\u00eang cho n\u0103m 2016. C\u00e1ch th\u1ef1c hi\u1ec7n \u0111i\u1ec1u \u0111\u00f3 nh\u01b0 sau:<\/span><\/p>\n<figure id=\"attachment_33564\" aria-describedby=\"caption-attachment-33564\" style=\"width: 523px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33564\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet.png\" alt=\"1 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT\" width=\"523\" height=\"393\" title=\"1-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet\"><figcaption id=\"caption-attachment-33564\" class=\"wp-caption-text\">1 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT<\/figcaption><\/figure>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o b\u1ea3ng t\u1ed5ng h\u1ee3p.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Ch\u1ecdn \u201cInsert\u201d sau \u0111\u00f3 nh\u1ea5p n\u00fat \u201cSlicer\u201d. Ch\u1ecdn bi\u1ebfn s\u1ed1 b\u1ea1n mu\u1ed1n s\u1eafp x\u1ebfp d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh (trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 \u201cYear\u201d) sau \u0111\u00f3 nh\u1ea5p n\u00fat \u201cok\u201d.<\/span><\/li>\n<\/ol>\n<figure id=\"attachment_33565\" aria-describedby=\"caption-attachment-33565\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33565\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet.gif\" alt=\"2 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT\" width=\"600\" height=\"380\" title=\"2-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet\"><figcaption id=\"caption-attachment-33565\" class=\"wp-caption-text\">2 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">3. Thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc v\u00e0 di chuy\u1ec3n slicer c\u1ee7a b\u1ea1n \u0111\u1ebfn n\u01a1i b\u1ea1n mu\u1ed1n n\u00f3 xu\u1ea5t hi\u1ec7n. L\u1eddi khuy\u00ean b\u1ea1n n\u00ean \u0111\u1eb7t \u0111\u00f3 tr\u00ean \u0111\u1ea7u b\u1ea3ng t\u1ed5ng h\u1ee3p c\u1ee7a b\u1ea1n \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng xem m\u1ecdi th\u1ee9.<\/span><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-67.gif\" title=\"vba101_92019-nho-67\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-164.gif\" title=\"ex101_92019-nho-164\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<figure id=\"attachment_33566\" aria-describedby=\"caption-attachment-33566\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33566\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet.gif\" alt=\"3 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT\" width=\"600\" height=\"363\" title=\"3-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet\"><figcaption id=\"caption-attachment-33566\" class=\"wp-caption-text\">3 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">4. B\u00e2y gi\u1edd Jason c\u1ea7n li\u00ean k\u1ebft c\u00e1c PivotTables hi\u1ec7n c\u00f3 v\u1edbi Slicer \u0111\u1ec3 t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c li\u00ean k\u1ebft v\u1edbi nh\u1eefng Slicer c\u1ee5 th\u1ec3. \u0110\u1ec3 th\u1ef1c hi\u1ec7n th\u00ec nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o Slicer, ch\u1ecdn \u201cReport Connections,\u201d, sau \u0111\u00f3 c\u1eeda s\u1ed5 hi\u1ec7n l\u00ean b\u1ea1n ch\u1ecdn c\u00e1c pivottables k\u1ebft n\u1ed1i v\u1edbi Slicer \u0111\u00f3.<\/span><\/p>\n<figure id=\"attachment_33567\" aria-describedby=\"caption-attachment-33567\" style=\"width: 1274px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33567\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet.gif\" alt=\"4 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT\" width=\"1274\" height=\"540\" title=\"4-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet\"><figcaption id=\"caption-attachment-33567\" class=\"wp-caption-text\">4 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">V\u1edbi thi\u1ebft l\u1eadp Slicer \u0111\u00f3, Jason ch\u1ec9 c\u1ea7n nh\u1ea5n n\u00fat tr\u00ean slicer \u0111\u00f3 l\u00e0 c\u00f3 th\u1ec3 nh\u00ecn th\u1ea5y d\u1eef li\u1ec7u n\u0103m 2016 nh\u01b0 trong b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y. M\u1eb7c d\u00f9 vi\u1ec7c thi\u1ebft l\u1eadp Slicer l\u00e0 m\u1ed9t c\u00f4ng vi\u1ec7c nh\u1ecf nh\u01b0ng n\u00f3 c\u1ef1c k\u1ef3 quan tr\u1ecdng gi\u00fap gi\u1ea3i quy\u1ebft c\u00f4ng vi\u1ec7c t\u1ed1t h\u01a1n, \u0111\u1eb7c bi\u1ec7t n\u1ebfu b\u1ea1n \u0111ang s\u1eed d\u1ee5ng nhi\u1ec1u Pivottable kh\u00e1c nhau.<\/span><\/p>\n<figure id=\"attachment_33568\" aria-describedby=\"caption-attachment-33568\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33568\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/5-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet.gif\" alt=\"5 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT\" width=\"600\" height=\"436\" title=\"5-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet\"><figcaption id=\"caption-attachment-33568\" class=\"wp-caption-text\">5 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"2_Tao_Calculated_Field\"><\/span><b>2. T\u1ea1o Calculated Field<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd trong vi\u1ec7c gi\u1ea3i quy\u1ebft nh\u1eefng t\u00ednh to\u00e1n v\u00e0 khi l\u00e0m vi\u1ec7c v\u1edbi nhi\u1ec1u Pivottable th\u00ec \u0111i\u1ec1u ch\u1eafc ch\u1eafn b\u1ea1n c\u1ea7n bi\u1ebft \u0111\u1ebfn \u0111\u00f3 l\u00e0 s\u1eed d\u1ee5ng Calculated Field.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Calculated Field cho ph\u00e9p b\u1ea1n duy tr\u00ec m\u1ed9t ph\u00e9p t\u00ednh xuy\u00ean su\u1ed1t c\u00e1c Pivottable \u2013 t\u01b0\u01a1ng t\u1ef1 nh\u01b0 c\u00e1ch b\u1ea1n s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c c\u1eafm v\u00e0o b\u1ea3ng t\u00ednh chu\u1ea9n th\u00f4ng th\u01b0\u1eddng.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Jason mu\u1ed1n t\u00ednh to\u00e1n l\u1ee3i nhu\u1eadn t\u1eebng lo\u1ea1i bia m\u00e0 anh ta kinh doanh: Pilsner, Stout, Amber v\u00e0 IPA. N\u1ebfu nh\u01b0 t\u1ef1 m\u00ecnh t\u00ednh to\u00e1n l\u1ee3i nhu\u1eadn b\u00ean ngo\u00e0i PivotTable th\u00ec kh\u00e1 ph\u1ee9c t\u1ea1p v\u00ec ph\u1ea3i tr\u1eeb chi ph\u00ed Q1 kh\u1ecfi doanh thu Q1, tr\u1eeb chi ph\u00ed Q2 kh\u1ecfi doanh thu Q2 v\u00e0 t\u01b0\u01a1ng t\u1ef1\u2026<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u00e2y gi\u1edd Jason c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp m\u1ed9t tr\u01b0\u1eddng t\u00ednh to\u00e1n t\u1ef1 \u0111\u1ed9ng thu th\u1eadp c\u00e1c con s\u1ed1 v\u00e0 sau \u0111\u00f3 tr\u1ea3 k\u1ebft qu\u1ea3 l\u1ee3i nhu\u1eadn \u0111\u1ed1i v\u1edbi t\u1eebng lo\u1ea1i bia. \u0110\u1ec3 th\u1ef1c hi\u1ec7n l\u00e0m c\u00e1c b\u01b0\u1edbc sau:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o \u00f4 b\u1ea5t k\u1ef3 tr\u00ean b\u1ea3ng t\u1ed5ng h\u1ee3p, ch\u1ecdn \u201c<\/span><i><span style=\"font-weight: 400\">PivotTable Analyze<\/span><\/i><span style=\"font-weight: 400\">\u201d tr\u00ean thanh c\u00f4ng c\u1ee5,\u00a0 sau \u0111\u00f3 nh\u1eadp v\u00e0o <\/span><i><span style=\"font-weight: 400\">\u201cCalculated Field\u201d.<\/span><\/i><\/li>\n<\/ol>\n<figure id=\"attachment_33569\" aria-describedby=\"caption-attachment-33569\" style=\"width: 1234px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33569\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/6-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet.gif\" alt=\"6 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT\" width=\"1234\" height=\"619\" title=\"6-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet\"><figcaption id=\"caption-attachment-33569\" class=\"wp-caption-text\">6 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">2. Trong c\u1eeda s\u1ed5 b\u1eadt l\u00ean, nh\u1eadp t\u00ean c\u1ee7a tr\u01b0\u1eddng m\u1edbi \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n (Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y th\u00ec Jason s\u1ebd t\u00ean l\u00e0 \u201cProfit\u201d ho\u1eb7c c\u00e1i g\u00ec \u0111\u00f3 t\u01b0\u01a1ng t\u1ef1).<\/span><\/p>\n<figure id=\"attachment_33570\" aria-describedby=\"caption-attachment-33570\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33570\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet.gif\" alt=\"7 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT\" width=\"600\" height=\"414\" title=\"7-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet\"><figcaption id=\"caption-attachment-33570\" class=\"wp-caption-text\">7 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">3. B\u00e2y gi\u1edd Jason nh\u1eadp c\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00ednh to\u00e1n. \u0110\u1ec3 t\u00ednh ra l\u1ee3i nhu\u1eadn th\u00ec l\u1ea5y doanh thu tr\u1eeb chi ph\u00ed. Trong \u00f4 c\u00f4ng th\u1ee9 Jason s\u1ebd nh\u1eadp c\u00f4ng th\u1ee9c \u201c=Sale-Cost\u201d. \u201cSale v\u00e0 Cost th\u00ec Jason s\u1ebd l\u1ea7n l\u01b0\u1ee3t ch\u1ecdn trong b\u1ea3ng Field b\u00ean d\u01b0\u1edbi v\u00e0 nh\u1ea5n \u201c\u201dInsert Field\u201d. Sau \u0111\u00f3 nh\u1ea5p Ok.<\/span><\/p>\n<figure id=\"attachment_33571\" aria-describedby=\"caption-attachment-33571\" style=\"width: 768px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33571\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/8-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet.gif\" alt=\"8 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT\" width=\"768\" height=\"683\" title=\"8-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet\"><figcaption id=\"caption-attachment-33571\" class=\"wp-caption-text\">8 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">V\u1edbi tr\u01b0\u1eddng \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n \u0111\u00f3, Jason c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng xem l\u1ee3i nhu\u1eadn c\u1ee7a m\u00ecnh cho t\u1eebng lo\u1ea1i bia, c\u0169ng nh\u01b0 t\u1ed5ng l\u1ee3i nhu\u1eadn l\u1edbn \u2013 \u1edf h\u00e0ng d\u01b0\u1edbi c\u00f9ng c\u1ee7a b\u1ea3ng t\u1ed5ng h\u1ee3p.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"3_Tao_nhieu_PivotTable_tu_mot_PivotTable_goc\"><\/span><b>3. T\u1ea1o nhi\u1ec1u PivotTable t\u1eeb m\u1ed9t PivotTable g\u1ed1c<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Khi b\u1ea1n mu\u1ed1n chia nh\u1ecf d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh t\u1eeb m\u1ed9t PivotTable th\u00e0nh nhi\u1ec1u PivotTable nh\u1ecf th\u00ec b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng th\u1ee7 thu\u1eadt h\u1eefu \u00edch d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5: Jason c\u00f3 m\u1ed9t b\u1ea3ng t\u1ed5ng h\u1ee3p hi\u1ec3n th\u1ecb doanh s\u1ed1 b\u00e1n bia theo qu\u00fd. Anh \u1ea5y mu\u1ed1n \u0111i s\u00e2u v\u00e0o doanh s\u1ed1 bia trong m\u1ed7i qu\u00fd v\u1edbi t\u1eebng lo\u1ea1i bia\u00a0 (Amber, Pilsner, IPA ho\u1eb7c Stout).<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 l\u00e0m nh\u01b0 v\u1eady, Jason s\u1ebd t\u1ea1o m\u1ed9t PivotTable cho t\u1eebng lo\u1ea1i bia: m\u1ed9t cho Amber, m\u1ed9t cho Pilsner \u2026 \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u \u0111\u00f3 ch\u1ec9 c\u1ea7n v\u00e0i c\u00fa nh\u1ea5p chu\u1ed9t b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng b\u1ea3ng Pivottable g\u1ed1c v\u00e0 th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">D\u00f9 b\u1ea1n mu\u1ed1n l\u1ecdc b\u1ea3ng t\u1ed5ng h\u1ee3p c\u1ee7a m\u00ecnh theo c\u00e1ch n\u00e0o (trong t\u00ecnh hu\u1ed1ng n\u00e0y l\u00e0 l\u1ecdc theo lo\u1ea1i bia) th\u00ec b\u1ea1n c\u0169ng c\u00e0n \u00e1p c\u00e1i b\u1ea3ng \u0111\u00f3 v\u00e0o b\u1ed9 l\u1ecdc. Nh\u1ea5p v\u00e0o b\u1ea3ng Pivottable, tr\u00ean thanh c\u00f4ng c\u1ee5 ch\u1ecdn \u201c<\/span><i><span style=\"font-weight: 400\">PivotTable Analyze<\/span><\/i><span style=\"font-weight: 400\">\u201d , nh\u1ea5p v\u00e0o \u201c<\/span><i><span style=\"font-weight: 400\">Fields List<\/span><\/i><span style=\"font-weight: 400\">\u201d sau \u0111\u00f3 b\u1ea1n k\u00e9o <\/span><i><span style=\"font-weight: 400\">Type<\/span><\/i><span style=\"font-weight: 400\"> v\u00e0o <\/span><i><span style=\"font-weight: 400\">Filters.<\/span><\/i><\/li>\n<\/ol>\n<figure id=\"attachment_33572\" aria-describedby=\"caption-attachment-33572\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33572\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/9-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet.gif\" alt=\"9 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT\" width=\"600\" height=\"364\" title=\"9-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet\"><figcaption id=\"caption-attachment-33572\" class=\"wp-caption-text\">9 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">2. B\u1ed9 l\u1ecdc \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng, Jason nh\u1ea5p v\u00e0o b\u00ean trong b\u1ea3ng t\u1ed5ng h\u1ee3p, quay l\u1ea1i tab \u201c<\/span><i><span style=\"font-weight: 400\">PivotTable Analyze<\/span><\/i><span style=\"font-weight: 400\">\u201d tr\u00ean thanh c\u00f4ng c\u1ee5 r\u1ed3i nh\u1ea5p v\u00e0o <\/span><i><span style=\"font-weight: 400\">Options<\/span><\/i><span style=\"font-weight: 400\"> r\u1ed3i ch\u1ecdn \u201c <\/span><i><span style=\"font-weight: 400\">Show report Filters Page\u201d<\/span><\/i><span style=\"font-weight: 400\"> . Sau \u0111\u00f3 \u0111\u00e1nh d\u1ea5u v\u00e0o \u201c<\/span><i><span style=\"font-weight: 400\">Type<\/span><\/i><span style=\"font-weight: 400\">\u201d\u00a0 v\u00e0 ch\u1ecdn Ok. Excel s\u1ebd t\u1ea1o m\u1ed9t trang t\u00ednh m\u1edbi v\u1edbi m\u1ed9t b\u1ea3ng t\u1ed5ng h\u1ee3p t\u1eebng lo\u1ea1i bia.<\/span><\/p>\n<figure id=\"attachment_33573\" aria-describedby=\"caption-attachment-33573\" style=\"width: 1038px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33573\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/10-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet.gif\" alt=\"10 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT\" width=\"1038\" height=\"832\" title=\"10-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet\"><figcaption id=\"caption-attachment-33573\" class=\"wp-caption-text\">10 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"4_An_hoac_hien_tong_phu\"><\/span><b>4. \u1ea8n ho\u1eb7c hi\u1ec7n t\u1ed5ng ph\u1ee5<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Nh\u01b0 \u0111\u00e3 \u0111\u1ec1 c\u1ea5p th\u00ec Excel c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n h\u1ea1n ch\u1ebf nh\u1eefng sai s\u1ed1 c\u00f3 th\u1ec3 x\u1ea3 ra. \u0110i\u1ec1u n\u00e0y kh\u00f4ng ch\u1ec9 \u00e1p d\u1ee5ng cho c\u00e1c t\u1ed5ng s\u1ed1 m\u00e0 c\u00f2n c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb t\u1ed5ng ph\u1ee5 trong b\u1ea3ng t\u1ed5ng h\u1ee3p n\u1ebfu b\u1ea1n mu\u1ed1n.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed Jason \u0111ang xem x\u00e9t d\u1eef li\u1ec7u v\u1ec1 doanh s\u1ed1 b\u00e1n bia c\u1ee7a m\u00ecnh theo Size (quy m\u00f4) v\u00e0 theo lo\u1ea1i (Type). N\u1ebfu \u0111\u1eb7t gi\u00e1 tr\u1ecb m\u1eb7c \u0111\u1ecbnh theo c\u00e1ch c\u1ee7a anh \u1ea5y th\u00ec Excel s\u1ebd kh\u00f4ng hi\u1ec3n th\u1ecb t\u1ed5ng ph\u1ee5 cho m\u1ed7i ti\u00eau ch\u00ed m\u00e0 ch\u1ec9 hi\u1ec3n th\u1ecb doanh thu b\u00e1n bia c\u1ee7a anh \u1ea5y.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Jason s\u1ebd xem x\u00e9t d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c chia nh\u1ecf:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o b\u00ean trong b\u1ea3ng v\u00e0 nh\u1ea5p v\u00e0o tab \u201cDesign\u201d tr\u00ean thanh c\u00f4ng c\u1ee5.<\/span><\/li>\n<\/ol>\n<figure id=\"attachment_33558\" aria-describedby=\"caption-attachment-33558\" style=\"width: 1172px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33558\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/11-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet.gif\" alt=\"11 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT\" width=\"1172\" height=\"755\" title=\"11-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet\"><figcaption id=\"caption-attachment-33558\" class=\"wp-caption-text\">11 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">2. Nh\u1ea5p v\u00e0o \u201c Subtotal\u201d v\u00e0 sau \u0111\u00f3 ch\u1ecdn hi\u1ec3n th\u1ecb t\u1ed5ng ph\u1ee5 \u1edf cu\u1ed1i ho\u1eb7c \u0111\u1ea7u nh\u00f3m c\u1ee7a b\u1ea1n (c\u00e1ch n\u00e0o c\u0169ng \u0111\u01b0\u1ee3c t\u00f9y v\u00e0o l\u1ef1a ch\u1ecdn c\u1ee7a b\u1ea1n).4<\/span><\/p>\n<figure id=\"attachment_33559\" aria-describedby=\"caption-attachment-33559\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33559\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/12-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet.gif\" alt=\"12 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT\" width=\"600\" height=\"521\" title=\"12-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet\"><figcaption id=\"caption-attachment-33559\" class=\"wp-caption-text\">12 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Sau khi l\u00e0m theo nh\u1eefng b\u01b0\u1edbc tr\u00ean th\u00ec c\u00e1c t\u1ed5ng ph\u1ee5 cho t\u1eebng Size c\u1ee7a s\u1ea3n ph\u1ea9m bia s\u1ebd hi\u1ec3n th\u1ecb. N\u1ebfu mu\u1ed1n x\u00f3a t\u1ed5ng ph\u1ee5 th\u00ec c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc t\u01b0\u01a1ng t\u1ef1 v\u00e0 ch\u1ecdn \u201cHide subtotal\u201d.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"5_Cach_xem_chi_tiet_tung_du_lieu_trong_bang_tong_hop\"><\/span><b>5. C\u00e1ch xem chi ti\u1ebft t\u1eebng d\u1eef li\u1ec7u trong b\u1ea3ng t\u1ed5ng h\u1ee3p<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u00e2y l\u00e0 m\u1ed9t k\u1ef9 thu\u1eadt gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 t\u00ecm hi\u1ec3u d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh. B\u1ea1n c\u00f3 th\u1ec3 xem chi ti\u1ebft b\u1ea5t k\u1ef3 d\u1eef li\u1ec7u trong b\u1ea3ng t\u1ed5ng h\u1ee3p ch\u1ec9 b\u1eb1ng c\u00e1ch nh\u1ea5p \u0111\u00fap v\u00e0o \u0111\u00f3.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5: Jason \u0111ang xem b\u1ea3ng t\u1ed5ng h\u1ee3p doanh s\u1ed1 b\u00e1n bia theo quarter (qu\u00fd) v\u00e0 theo size (quy m\u00f4) trong 2017. Anh \u1ea5y mu\u1ed1n xem th\u00f4ng tin chi ti\u1ebft v\u1ec1 doanh s\u1ed1 bia c\u1ee7a m\u00ecnh trong Q1. Ch\u00fang ta ch\u1ec9 c\u1ea7n nh\u1ea5p \u0111\u00fap v\u00e0o s\u1ed1 \u0111\u00f3 trong excel s\u1ebd m\u1edf ra th\u00f4ng tin chi ti\u1ebft trong m\u1ed9t trang t\u00ednh m\u1edbi.<\/span><\/p>\n<figure id=\"attachment_33560\" aria-describedby=\"caption-attachment-33560\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33560\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/13-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet.gif\" alt=\"13 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT\" width=\"600\" height=\"350\" title=\"13-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet\"><figcaption id=\"caption-attachment-33560\" class=\"wp-caption-text\">13 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"6_Lam_moi_du_lieu\"><\/span><b>6. L\u00e0m m\u1edbi d\u1eef li\u1ec7u<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">N\u1ebfu nh\u01b0 b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh h\u00e0ng gi\u1edd \u0111\u1ed3ng h\u1ed3, x\u00e2y d\u1ef1ng h\u00e0ng ch\u1ee5c b\u1ea3ng t\u1ed5ng h\u1ee3p kh\u00e1c nhau t\u1eeb d\u1eef li\u1ec7u g\u1ed1c nh\u01b0 v\u00ed d\u1ee5 Jason \u1edf tr\u00ean. Nh\u1eefng t\u00ecnh hu\u1ed1ng x\u1ea5u nh\u1ea5t \u0111\u00f3 l\u00e0 b\u1ea1n nh\u1eadn ra b\u1ea1n m\u1eafc l\u1ed7i nh\u01b0 l\u1ed7i \u0111\u00e1nh m\u00e1y trong t\u1eadp d\u1eef li\u1ec7u. gi\u1ea3 d\u1ee5 \u0111\u00e1nh nh\u1ea7m \u201cGrowler\u201d l\u00e0 \u201cgrowler\u201d v\u00e0 b\u00e2y gi\u1edd n\u00f3 hi\u1ec3n th\u1ecb \u1edf t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng.<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu s\u1eeda m\u1ed9t c\u00e1ch th\u1ee7 c\u00f4ng th\u00ec Jason ph\u1ea3i xem qua c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c c\u1ee7a m\u00ecnh m\u1ed9t c\u00e1ch t\u1ec9 m\u1ec9, chi ti\u1ebft \u0111\u1ec3 s\u1eeda t\u1ea5t c\u1ea3 c\u00e1c l\u1ed7i \u0111\u00f3 trong d\u1eef li\u1ec7u v\u00e0 c\u00e1c Pivottable. Tuy nhi\u00ean \u0111i\u1ec1u n\u00e0y r\u1ea5t m\u1ea5t th\u1eddi gian v\u00e0 ch\u00fang ta ch\u1ec9 c\u1ea7n l\u00e0m nh\u1eefng b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n nh\u01b0 sau:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Quay l\u1ea1i t\u1eadp d\u1eef li\u1ec7u g\u1ed1c m\u00e0 b\u1ea1n d\u00f9ng \u0111\u1ec3 t\u1ea1o c\u00e1c b\u1ea3ng Pivottable nh\u1ecf v\u00e0 th\u1ef1c hi\u1ec7n \u201cFind and Place\u201d. Nh\u1ea5n Ctrl+F\u00a0 v\u00e0 sau \u0111\u00f3 nh\u1eadp nh\u1eefng g\u00ec b\u1ea1n mu\u1ed1n v\u00e0 t\u1ea5t c\u1ea3 s\u1ebd \u0111\u01b0\u1ee3c thay \u0111\u1ed5i cho nh\u1eefng v\u1ecb tr\u00ed m\u00e0 b\u1ea1n nh\u1ea7m l\u1eabn.<\/span><\/li>\n<\/ol>\n<figure id=\"attachment_33561\" aria-describedby=\"caption-attachment-33561\" style=\"width: 1010px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33561\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/14-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet.gif\" alt=\"14 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT\" width=\"1010\" height=\"829\" title=\"14-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet\"><figcaption id=\"caption-attachment-33561\" class=\"wp-caption-text\">14 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">2. Khi l\u00e0m nh\u01b0 v\u1eady s\u1ebd s\u1eeda t\u1ea5t c\u00e1c l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a \u201cGrolwer\u201d trong t\u1eadp d\u1eef li\u1ec7u nh\u01b0ng s\u1ebd kh\u00f4ng s\u1eeda \u0111\u01b0\u1ee3c b\u1ea5t k\u1ef3 pivottables m\u00e0 \u0111\u01b0\u1ee3c li\u00ean k\u1ebft v\u1edbi n\u00f3.<\/span><\/p>\n<figure id=\"attachment_33562\" aria-describedby=\"caption-attachment-33562\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33562\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/15-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet.gif\" alt=\"15 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT\" width=\"600\" height=\"592\" title=\"15-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet\"><figcaption id=\"caption-attachment-33562\" class=\"wp-caption-text\">15 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">3. \u0110\u1ec3 th\u1ef1c hi\u1ec7n c\u1eadp nh\u1eadt \u0111\u00f3 c\u00e1c v\u1ecb tr\u00ed m\u1eafc l\u1ed7i, h\u00e3y chuy\u1ec3n \u0111\u1ebfn tab \u201cData\u201d trong thanh c\u00f4ng c\u00f4ng c\u1ee5 v\u00e0 sau \u0111\u00f3 nh\u1ea5p v\u00e0o n\u00fat \u201cRefresh all\u201d. \u0110i\u1ec1u \u0111\u00f3 s\u1ebd th\u1ef1c hi\u1ec7n ch\u1ec9nh s\u1eeda t\u01b0\u01a1ng t\u1ef1 tr\u00ean to\u00e0n b\u1ed9 s\u1ed5 l\u00e0m vi\u1ec7c.<\/span><\/p>\n<figure id=\"attachment_33563\" aria-describedby=\"caption-attachment-33563\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33563\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/16-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet.gif\" alt=\"16 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT\" width=\"600\" height=\"334\" title=\"16-6-ky-thuat-nang-cao-cho-pivottable-ban-nen-biet\"><figcaption id=\"caption-attachment-33563\" class=\"wp-caption-text\">16 6 K\u1ef8 THU\u1eacT N\u00c2NG CAO CHO PIVOTTABLE B\u1ea0N N\u00caN BI\u1ebeT<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\"><strong>H\u1ecdc Excel Online<\/strong> \u0111\u00e3 gi\u1edbi thi\u1ec7u b\u1ea1n <strong>6 k\u1ef9 thu\u1eadt PivotTable n\u00e2ng cao<\/strong> m\u00e0 b\u1ea1n n\u00ean bi\u1ebft. Vi\u1ec7c t\u00f3m t\u1eaft d\u1eef li\u1ec7u v\u00e0 ph\u00e2n t\u00edch s\u1ebd d\u1ec5 d\u00e0ng h\u01a1n khi b\u1ea1n trang b\u1ecb nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e2ng cao v\u1ec1 Pivottable.<\/span><\/p>\n<p>H\u00e3y theo d\u00f5i v\u00e0 c\u00f9ng tham gia c\u00e1c <a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-tu-co-ban-toi-nang-cao-danh-cho-dan-van-phong-2010-20132016\"><strong>kh\u00f3a h\u1ecdc Excel<\/strong><\/a> v\u1ec1 Pivot Table c\u00f9ng H\u1ecdc Excel Online \u0111\u1ec3 vi\u1ec7c h\u1ecdc t\u1eadp, c\u00f4ng vi\u1ec7c thu\u1eadn ti\u1ec7n v\u00e0 nhanh h\u01a1n nh\u00e9!<\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-67.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2144,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2143","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\/2143","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=2143"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2143\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2144"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2143"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2143"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}