{"id":900,"date":"2020-09-08T21:22:17","date_gmt":"2020-09-08T14:22:17","guid":{"rendered":"https:\/\/hoctin.vn\/?p=900"},"modified":"2020-09-09T19:48:43","modified_gmt":"2020-09-09T12:48:43","slug":"pivot-table-trong-excel","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/pivot-table-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng D\u1eabn S\u1eed D\u1ee5ng Pivot Table Trong Excel V\u00e0 V\u00ed D\u1ee5 C\u1ee5 Th\u1ec3"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"900\" class=\"elementor elementor-900\">\n\t\t\t\t\t\t<div class=\"elementor-inner\">\n\t\t\t\t<div class=\"elementor-section-wrap\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8cef5a0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8cef5a0\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ec6681b\" data-id=\"ec6681b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5ea0687 elementor-widget elementor-widget-text-editor\" data-id=\"5ea0687\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Pivot Table l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu \u00edch trong Excel v\u1edbi nhi\u1ec1u t\u00ednh n\u0103ng v\u01b0\u1ee3t tr\u1ed9i v\u1edbi t\u1ed1c \u0111\u1ed9 ra k\u1ebft qu\u1ea3 nhanh v\u00e0 d\u1ec5 d\u00e0ng thao t\u00e1c. Ch\u1ec9 c\u1ea7n n\u1eafm trong tay nh\u1eefng t\u00ednh n\u0103ng c\u01a1 b\u1ea3n c\u1ee7a Pivot Table, b\u1ea1n c\u00f3 th\u1ec3 c\u1ea3i thi\u1ec7n hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh m\u1ed9t c\u00e1ch \u0111\u00e1ng k\u1ec3.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span id=\"docs-internal-guid-22deb6ff-7fff-24b1-063e-bd3815109453\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u00fap c\u00e1c b\u1ea1n hi\u1ec3u \u0111\u01b0\u1ee3c Pivot Table l\u00e0 g\u00ec, ch\u1ee9c n\u0103ng c\u1ee7a Pivot Table, c\u00e1ch t\u1ea1o m\u1ed9t Pivot Table c\u0169ng nh\u01b0 h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng Pivot Table \u0111\u1ec3 t\u1ed5ng h\u1ee3p, ph\u00e2n t\u00edch, tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u, l\u1eadp b\u1ea3ng th\u1ed1ng k\u00ea trong Excel 2007, 2010, 2013, 2016, 2019 v\u00e0 365.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c08f303 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c08f303\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fed24df\" data-id=\"fed24df\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-07942a7 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"07942a7\" data-element_type=\"widget\" data-settings=\"{&quot;exclude_headings_by_selector&quot;:[],&quot;marker_view&quot;:&quot;bullets&quot;,&quot;icon&quot;:{&quot;value&quot;:&quot;&quot;,&quot;library&quot;:&quot;&quot;},&quot;headings_by_tags&quot;:[&quot;h2&quot;,&quot;h3&quot;,&quot;h4&quot;,&quot;h5&quot;,&quot;h6&quot;],&quot;minimize_box&quot;:&quot;yes&quot;,&quot;minimized_on&quot;:&quot;tablet&quot;,&quot;hierarchical_view&quot;:&quot;yes&quot;,&quot;min_height&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"table-of-contents.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-toc__header\">\n\t\t\t<h4 class=\"elementor-toc__header-title\">M\u1ee5c L\u1ee5c B\u00e0i Vi\u1ebft<\/h4>\t\t\t\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--expand\"><i class=\"fas fa-chevron-down\"><\/i><\/div>\n\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--collapse\"><i class=\"fas fa-chevron-up\"><\/i><\/div>\n\t\t\t\t\t<\/div>\n\t\t<div class=\"elementor-toc__body\">\n\t\t\t<div class=\"elementor-toc__spinner-container\">\n\t\t\t\t<i class=\"elementor-toc__spinner eicon-loading eicon-animation-spin\" aria-hidden=\"true\"><\/i>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-31c0e97 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"31c0e97\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-39ad67f\" data-id=\"39ad67f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0cbb920 elementor-widget elementor-widget-heading\" data-id=\"0cbb920\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-9f992ac9-7fff-e1d5-5dd9-001d0e9ecbe8\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">1. Pivot Table L\u00e0 G\u00ec? T\u1ea1i Sao N\u00ean S\u1eed D\u1ee5ng Pivot Table Trong Ph\u00e2n T\u00edch D\u1eef Li\u1ec7u?<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-343e9c0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"343e9c0\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b39dbb1\" data-id=\"b39dbb1\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-764473e elementor-widget elementor-widget-text-editor\" data-id=\"764473e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Ch\u1ec9 b\u1eb1ng v\u00e0o click chu\u1ed9t, ch\u1ee9c n\u0103ng Pivot Table c\u00f3 th\u1ec3 h\u1ed7 tr\u1ee3 ng\u01b0\u1eddi d\u00f9ng t\u00ednh to\u00e1n, t\u00f3m t\u1eaft, ph\u00e2n t\u00edch, khai th\u00e1c \u00fd ngh\u0129a d\u1eef li\u1ec7u.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">H\u00e3y b\u1eaft \u0111\u1ea7u b\u1eb1ng m\u1ed9t v\u00ed d\u1ee5 c\u01a1 b\u1ea3n nh\u1ea5t cho th\u1ea5y s\u1ee9c m\u1ea1nh c\u1ee7a Pivot Table: D\u01b0\u1edbi \u0111\u00e2y l\u00e0 d\u1eef li\u1ec7u t\u1ed5ng h\u1ee3p doanh thu s\u1ea3n ph\u1ea9m h\u00e0ng th\u00e1ng c\u1ee7a m\u1ed9t c\u00f4ng ty trong qu\u00fd I\/2020.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-cc6dc0f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cc6dc0f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1c465a4\" data-id=\"1c465a4\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d7d7540 elementor-widget elementor-widget-image\" data-id=\"d7d7540\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/du-lieu-doanh-thu-ban-hang-can-su-dung-pivot-table-de-phan-tich.png\" title=\"v\u00ed d\u1ee5 c\u01a1 b\u1ea3n nh\u1ea5t cho th\u1ea5y s\u1ee9c m\u1ea1nh c\u1ee7a Pivot Table: d\u1eef li\u1ec7u t\u1ed5ng h\u1ee3p doanh thu s\u1ea3n ph\u1ea9m h\u00e0ng th\u00e1ng c\u1ee7a m\u1ed9t c\u00f4ng ty trong 2020\" alt=\"v\u00ed d\u1ee5 c\u01a1 b\u1ea3n nh\u1ea5t cho th\u1ea5y s\u1ee9c m\u1ea1nh c\u1ee7a Pivot Table: d\u1eef li\u1ec7u t\u1ed5ng h\u1ee3p doanh thu s\u1ea3n ph\u1ea9m h\u00e0ng th\u00e1ng c\u1ee7a m\u1ed9t c\u00f4ng ty trong 2020\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3307b22 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3307b22\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-988fdfc\" data-id=\"988fdfc\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f1c32eb elementor-widget elementor-widget-text-editor\" data-id=\"f1c32eb\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Gi\u1ea3 s\u1eed b\u1ea1n \u0111ang l\u00e0m vi\u1ec7c cho c\u00f4ng ty n\u00e0y, b\u1ea1n l\u00e0 ng\u01b0\u1eddi b\u00e1o c\u00e1o d\u1eef li\u1ec7u v\u00e0 \u0111\u00e3 nh\u1eadn \u0111\u01b0\u1ee3c m\u1ed9t s\u1ed1 c\u00e2u h\u1ecfi t\u1eeb s\u1ebfp c\u1ee7a b\u1ea1n nh\u01b0 sau:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; font-style: italic; font-weight: bold; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; font-style: italic; font-weight: bold; white-space: pre-wrap;\">Q1: Doanh thu t\u1eebng th\u00e1ng c\u1ee7a c\u00f4ng ty?<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; font-style: italic; font-weight: bold; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; font-style: italic; font-weight: bold; white-space: pre-wrap;\">Q2: Khu v\u1ef1c mi\u1ec1n Nam b\u00e1n ch\u1ea1y nh\u1ea5t lo\u1ea1i s\u1ea3n ph\u1ea9m n\u00e0o (s\u1ed1 l\u01b0\u1ee3ng l\u1edbn nh\u1ea5t)?<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; font-style: italic; font-weight: bold; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; font-style: italic; font-weight: bold; white-space: pre-wrap;\">Q3: Khu v\u1ef1c n\u00e0o b\u00e1n \u0111\u01b0\u1ee3c nhi\u1ec1u \u00e1o s\u01a1 mi nh\u1ea5t?<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; font-style: italic; font-weight: bold; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; font-style: italic; font-weight: bold; white-space: pre-wrap;\">Q4: S\u1ed1 l\u01b0\u1ee3ng \u00e1o b\u00e1n \u0111\u01b0\u1ee3c c\u1ee7a c\u00e1c khu v\u1ef1c?<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">N\u1ebfu kh\u00f4ng s\u1eed d\u1ee5ng Pivot Table, c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t m\u00e0 ai c\u0169ng ngh\u0129 \u0111\u1ebfn l\u00e0 d\u00f9ng c\u00e1c h\u00e0m trong Excel.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><b style=\"font-weight: normal;\">\u00a0<\/b><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">B\u1ea1n s\u1ebd x\u1eed l\u00fd nh\u01b0 n\u00e0o n\u1ebfu s\u1ebfp c\u1ee7a b\u1ea1n \u0111\u1ed9t ng\u1ed9t giao th\u00eam cho b\u1ea1n m\u1ed9t danh s\u00e1ch c\u00e1c c\u00e2u h\u1ecfi kh\u00e1c? &#8211; C\u00f3 th\u1ec3 b\u1ea1n s\u1ebd ph\u1ea3i quay l\u1ea1i b\u1ea3ng d\u1eef li\u1ec7u \u0111\u1ec3 t\u1ea1o ra nh\u1eefng c\u00f4ng th\u1ee9c m\u1edbi m\u1ed7i khi c\u00f3 s\u1ef1 thay \u0111\u1ed5i.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><b style=\"font-weight: normal;\">\u00a0<\/b><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: italic; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Pivot Table c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n ch\u1ec9 trong v\u00e0i thao t\u00e1c click chu\u1ed9t \u0111\u01a1n gi\u1ea3n. B\u1ea1n c\u00f3 th\u1ec3 xem \u0111\u00e1p \u00e1n c\u1ee7a nh\u1eefng c\u00e2u h\u1ecfi \u1edf ph\u1ea7n 4 b\u00e0i vi\u1ebft.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\">\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Tr\u01b0\u1edbc khi tr\u1ea3 l\u1eddi nh\u1eefng c\u00e2u h\u1ecfi tr\u00ean, h\u00e3y c\u00f9ng Hoctin.vn t\u00ecm hi\u1ec3u c\u00e1c c\u00e1ch t\u1ea1o m\u1ed9t b\u1ea3ng Pivot Table trong Excel trong ph\u1ea7n ti\u1ebfp theo.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-01b9fad elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"01b9fad\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-61c670e\" data-id=\"61c670e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-199f6cf elementor-widget elementor-widget-heading\" data-id=\"199f6cf\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-973c2fca-7fff-1ab2-66f7-98c207477d49\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2. C\u00e1ch T\u1ea1o Pivot Table Trong Excel<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-50e9c61 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"50e9c61\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fe198b6\" data-id=\"fe198b6\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-cbb5fec elementor-widget elementor-widget-heading\" data-id=\"cbb5fec\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-51d92c24-7fff-43cc-3d34-702f3e236d33\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2.1, C\u00e1ch T\u1ea1o Pivot Table Theo M\u1eabu C\u00f3 S\u1eb5n Trong Excel B\u1eb1ng Ch\u1ee9c N\u0103ng Recommended PivotTables<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-bb3d9b1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bb3d9b1\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e731112\" data-id=\"e731112\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9321bd9 elementor-widget elementor-widget-text-editor\" data-id=\"9321bd9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">\u0110\u1ec3 t\u1ea1o m\u1ed9t b\u1ea3ng Pivot theo m\u1eabu c\u00f3 s\u1eb5n trong Excel:<\/span><\/p><ul style=\"margin-top: 0; margin-bottom: 0;\"><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Ch\u1ecdn m\u1ed9t \u00f4 b\u1ea5t k\u1ef3 trong b\u1ea3ng d\u1eef li\u1ec7u.<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"background-color: transparent; font-size: 12pt; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Tr\u00ean thanh c\u00f4ng c\u1ee5, ch\u1ecdn <\/span><span style=\"background-color: transparent; font-size: 12pt; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Insert &gt;&gt; Recommened PivotTables<\/span><span style=\"background-color: transparent; font-size: 12pt; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\"> \u1edf m\u1ee5c Table.<\/span><\/p><\/li><\/ul>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d686934 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d686934\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e0e40d4\" data-id=\"e0e40d4\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ec3b01b elementor-widget elementor-widget-image\" data-id=\"ec3b01b\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img width=\"321\" height=\"154\" src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/cach-tao-pivot-table-theo-mau-co-san-trong-excel-recommended-pivot-tables.png\" class=\"attachment-large size-large\" alt=\"C\u00e1ch T\u1ea1o Pivot Table Theo M\u1eabu C\u00f3 S\u1eb5n Trong Excel B\u1eb1ng Ch\u1ee9c N\u0103ng Recommended PivotTables\" loading=\"lazy\" srcset=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/cach-tao-pivot-table-theo-mau-co-san-trong-excel-recommended-pivot-tables.png 321w, https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/cach-tao-pivot-table-theo-mau-co-san-trong-excel-recommended-pivot-tables-300x144.png 300w\" sizes=\"(max-width: 321px) 100vw, 321px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4c8193b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4c8193b\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-af63b48\" data-id=\"af63b48\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9181dce elementor-widget elementor-widget-text-editor\" data-id=\"9181dce\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">&nbsp;<\/span><\/p>\n<p><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">C\u1eeda s\u1ed5 g\u1ee3i \u00fd hi\u1ec7n l\u00ean c\u00e1c m\u1eabu Pivot Table, \u0111\u1ebfn \u0111\u00e2y b\u1ea1n ch\u1ec9 c\u1ea7n l\u1ef1a ch\u1ecdn b\u1ea3ng ph\u00f9 h\u1ee3p nh\u1ea5t v\u1edbi nhu c\u1ea7u c\u1ee7a m\u00ecnh:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-cbbd7bc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cbbd7bc\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ffa2940\" data-id=\"ffa2940\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b408230 elementor-widget elementor-widget-image\" data-id=\"b408230\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/cac-loai-pivot-table-theo-mau-co-san-trong-excel-recommended-pivot-tables.png\" title=\"cac-loai-pivot-table-theo-mau-co-san-trong-excel-recommended-pivot-tables\" alt=\"C\u00e1ch T\u1ea1o Pivot Table Theo M\u1eabu C\u00f3 S\u1eb5n Trong Excel B\u1eb1ng Ch\u1ee9c N\u0103ng Recommended PivotTables\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-382f29d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"382f29d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-17527ee\" data-id=\"17527ee\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1dc08a6 elementor-widget elementor-widget-heading\" data-id=\"1dc08a6\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-c5dc94aa-7fff-8167-5570-64dc4af10ab8\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2.2, T\u1ea1o Pivot Table \u0110\u1ec3 T\u00f9y Ch\u1ec9nh Ph\u00e2n T\u00edch D\u1eef Li\u1ec7u<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9f6cef3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9f6cef3\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bb4942e\" data-id=\"bb4942e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-439fb2c elementor-widget elementor-widget-text-editor\" data-id=\"439fb2c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-0a033054-7fff-4783-4f4f-7da30a44873f\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">S\u1eed d\u1ee5ng Pivot Table s\u1eb5n c\u00f3 theo m\u1eabu nhanh nh\u01b0ng kh\u00f4ng cung c\u1ea5p \u0111\u01b0\u1ee3c nhi\u1ec1u ki\u1ec3u th\u00f4ng tin v\u00e0 tr\u01b0\u1eddng d\u1eef li\u1ec7u nh\u01b0 c\u00e1ch t\u1ea1o b\u1ea3ng t\u00f9y ch\u1ec9nh.<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-08ea303 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"08ea303\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-207bd39\" data-id=\"207bd39\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-04e9f45 elementor-widget elementor-widget-heading\" data-id=\"04e9f45\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-3b5db091-7fff-9585-05c3-45df0bc15ed9\"><span style=\"font-size: 14pt; font-family: Arial; color: rgb(67, 67, 67); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2.2.1, C\u00e1ch t\u1ea1o Pivot Table Tr\u1ed1ng<\/span><\/span><\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-fe5e99b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fe5e99b\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c8f64e6\" data-id=\"c8f64e6\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0f6b9a7 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"0f6b9a7\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span id=\"docs-internal-guid-511cb13a-7fff-532f-b2bc-8b4697b5dd23\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Ch\u1ecdn m\u1ed9t \u00f4 b\u1ea5t k\u1ef3 trong b\u1ea3ng d\u1eef li\u1ec7u. <\/span><\/span><span id=\"docs-internal-guid-13e17d94-7fff-697e-588c-b8a61e54b57b\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">L\u01b0u \u00fd b\u1ea3ng d\u1eef li\u1ec7u:<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span id=\"docs-internal-guid-48272262-7fff-2aa6-0ae8-ea1b732a16c2\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">D\u1eef li\u1ec7u t\u1ed5 ch\u1ee9c d\u1ea1ng b\u1ea3ng, kh\u00f4ng c\u00f3 h\u00e0ng\/ c\u1ed9t tr\u1ed1ng<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><font color=\"#000000\" face=\"Arial\"><span style=\"font-size: 16px;\">H<\/span><\/font><span id=\"docs-internal-guid-c2a1db47-7fff-0f56-057a-c1cc2444c6d3\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">\u00e0ng \u0111\u1ea7u ti\u00ean ch\u1ee9a t\u00ean tr\u01b0\u1eddng d\u1eef li\u1ec7u (th\u00e1ng\/ khu v\u1ef1c\/ s\u1ea3n ph\u1ea9m\u2026)<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">M\u1ed7i c\u1ed9t ch\u1ec9 \u0111\u01b0\u1ee3c ch\u1ee9a m\u1ed9t ki\u1ec3u d\u1eef li\u1ec7u (s\u1ed1\/ v\u0103n b\u1ea3n\/ ng\u00e0y th\u00e1ng\u2026)<\/span><\/span><br><br><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span id=\"docs-internal-guid-165f9113-7fff-60b7-a23f-30f33b5d9840\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Tr\u00ean thanh c\u00f4ng c\u1ee5, ch\u1ecdn <\/span><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Insert <\/span><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">&gt;&gt; <\/span><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">PivotTable<\/span><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\"> \u1edf m\u1ee5c Tables.<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-69b2c51 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"69b2c51\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-16eedcc\" data-id=\"16eedcc\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-bcf6d58 elementor-widget elementor-widget-image\" data-id=\"bcf6d58\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/insert-pivot-table-trong-excel.png\" title=\"insert-pivot-table-trong-excel\">&gt; PivotTable \u1edf m\u1ee5c Tables\" \/&gt;\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6a3b850 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6a3b850\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-63218fe\" data-id=\"63218fe\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4f98168 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"4f98168\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">H\u1ed9p tho\u1ea1i <\/span><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Create Pivot Table <\/span><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">hi\u1ec7n l\u00ean: Excel m\u1eb7c \u0111\u1ecbnh \u0111\u1eb7t Pivot Table \u1edf m\u1ed9t trang t\u00ednh m\u1edbi t\u1ea1i m\u1ee5c <\/span><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">New worksheet.<\/span><\/span><br><span id=\"docs-internal-guid-39547659-7fff-36af-6962-c0e7c1bc740c\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n \u0111\u1eb7t Pivot Table t\u1ea1i m\u1ed9t v\u1ecb tr\u00ed c\u1ee5 th\u1ec3: ch\u1ecdn m\u1ee5c <\/span><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Existing Worksheet<\/span><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\"> &gt;&gt; ch\u1ecdn \u00f4 b\u1eaft \u0111\u1ea7u b\u1ea3ng Pivot trong m\u1ee5c <\/span><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Location<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-06c34e0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"06c34e0\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-824e32c\" data-id=\"824e32c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c3ea3a8 elementor-widget elementor-widget-image\" data-id=\"c3ea3a8\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/cua-so-pivot-table-trong-excel.png\" title=\"cua-so-pivot-table-trong-excel\" alt=\"C\u00e1ch t\u1ea1o Pivot Table Tr\u1ed1ng\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-43daef7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"43daef7\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c7337a4\" data-id=\"c7337a4\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2d9a795 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"2d9a795\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span id=\"docs-internal-guid-aef5f33a-7fff-0131-4925-f21a169625ac\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Sau khi \u1ea5n <\/span><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">OK <\/span><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">ho\u1eb7c ph\u00edm <\/span><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Enter,<\/span><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\"> b\u1ea3ng Pivot tr\u1ed1ng \u0111\u01b0\u1ee3c t\u1ea1o.<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ff6df13 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ff6df13\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5aba7d1\" data-id=\"5aba7d1\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8668044 elementor-widget elementor-widget-heading\" data-id=\"8668044\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-0dc48fd5-7fff-3131-e463-9a8d0f663e14\"><span style=\"font-size: 14pt; font-family: Arial; color: rgb(67, 67, 67); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2.2.2, C\u00e1ch T\u00f9y Ch\u1ec9nh Pivot Table Fields \u0110\u1ec3 Ph\u00e2n T\u00edch D\u1eef Li\u1ec7u<\/span><\/span><\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f527805 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f527805\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9ab863d\" data-id=\"9ab863d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c7880b5 elementor-widget elementor-widget-text-editor\" data-id=\"c7880b5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-fe5bfe76-7fff-927f-f1e9-df7a2af9f31a\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Khi b\u1ea1n click v\u00e0o m\u1ed9t \u00f4 b\u1ea5t k\u1ef3 trong b\u1ea3ng Pivot, <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Pivot Table Fields<\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\"> s\u1ebd hi\u1ec7n ra \u1edf ph\u00eda b\u00ean ph\u1ea3i giao di\u1ec7n Excel v\u1edbi hai th\u00e0nh ph\u1ea7n ch\u00ednh l\u00e0 <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Fields <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">v\u00e0 <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Areas:<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0f510ca elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0f510ca\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d7815f1\" data-id=\"d7815f1\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b2b9f48 elementor-widget elementor-widget-image\" data-id=\"b2b9f48\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/pivot-table-fields-trong-excel.png\" title=\"pivot-table-fields-trong-excel\" alt=\"Khi b\u1ea1n click v\u00e0o m\u1ed9t \u00f4 b\u1ea5t k\u1ef3 trong b\u1ea3ng Pivot, Pivot Table Fields s\u1ebd hi\u1ec7n ra \u1edf ph\u00eda b\u00ean ph\u1ea3i giao di\u1ec7n Excel v\u1edbi hai th\u00e0nh ph\u1ea7n ch\u00ednh l\u00e0 Fields v\u00e0 Areas\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a8f5f48 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a8f5f48\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c0a1507\" data-id=\"c0a1507\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-369dfcb elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"369dfcb\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span><p dir=\"ltr\" style=\"line-height:1.38;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Fields<\/span><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\"> g\u1ed3m c\u00e1c tr\u01b0\u1eddng d\u1eef li\u1ec7u \u0111\u1ec3 c\u1ea5u t\u1ea1o n\u00ean Pivot Table. C\u00e1c tr\u01b0\u1eddng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn s\u1ebd \u0111\u01b0\u1ee3c b\u00f4i \u0111\u1eadm v\u00e0 c\u00f3 d\u1ea5u tick \u1edf \u00f4 vu\u00f4ng b\u00ean c\u1ea1nh.<\/span><\/p><p dir=\"ltr\" style=\"line-height:1.38;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">\u0110\u1ec3 t\u00ecm nhanh m\u1ed9t tr\u01b0\u1eddng d\u1eef li\u1ec7u, c\u00f3 th\u1ec3 nh\u1eadp t\u00ean v\u00e0o \u00f4 \u201cSearch Box\u201d.<\/span><\/p><\/span><br><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span id=\"docs-internal-guid-2c470845-7fff-5b23-9098-78886a1eae94\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Areas<\/span><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\"> l\u00e0 n\u01a1i k\u00e9o c\u00e1c tr\u01b0\u1eddng d\u1eef li\u1ec7u v\u00e0o c\u00e1c v\u00f9ng sau:<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span id=\"docs-internal-guid-5d595ce2-7fff-811a-6f55-6b1a85cdad44\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">V\u00f9ng Filters: d\u1eef li\u1ec7u c\u1ee7a tr\u01b0\u1eddng \u0111\u01b0\u1ee3c k\u00e9o v\u00e0o v\u00f9ng n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng l\u00e0m b\u1ed9 l\u1ecdc cho c\u1ea3 b\u1ea3ng Pivot<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span id=\"docs-internal-guid-7afc6dbe-7fff-9792-47ea-f3f4108551dc\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">V\u00f9ng Rows &amp; Columns: hai v\u00f9ng quy\u1ebft \u0111\u1ecbnh c\u00e1c h\u00e0ng v\u00e0 c\u1ed9t c\u1ee7a b\u1ea3ng Pivot ch\u1ee9a c\u00e1c tr\u01b0\u1eddng n\u00e0o cho m\u1ee5c \u0111\u00edch s\u1eafp x\u1ebfp b\u1ea3ng d\u1eef li\u1ec7u<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span id=\"docs-internal-guid-64502caf-7fff-aef7-3971-d7e275859a01\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">V\u00f9ng VALUES: tr\u01b0\u1eddng n\u00e0o \u0111\u01b0\u1ee3c k\u00e9o v\u00e0o v\u00f9ng n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c t\u1ed5ng h\u1ee3p b\u1edbi c\u00e1c ph\u00e9p to\u00e1n sum\/ count\/ average\/ max\/ min\/ product...<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5cc85fa elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5cc85fa\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-42d785e\" data-id=\"42d785e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9550071 elementor-widget elementor-widget-text-editor\" data-id=\"9550071\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">V\u00ed d\u1ee5 1<\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">: \u0110\u1ec3 t\u1ed5ng h\u1ee3p doanh thu t\u1eebng s\u1ea3n ph\u1ea9m theo th\u00e1ng, b\u1ea1n c\u1ea7n k\u00e9o c\u00e1c tr\u01b0\u1eddng ho\u1eb7c thao t\u00e1c tick ch\u1ecdn v\u00e0o c\u00e1c v\u00f9ng Values, Rows v\u00e0 Columns nh\u01b0 sau:<\/span><\/p><ul style=\"margin-top: 0; margin-bottom: 0;\"><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Values: ch\u1ecdn Doanh thu v\u00e0 ch\u1ecdn ph\u00e9p to\u00e1n SUM<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Rows: ch\u1ecdn S\u1ea3n ph\u1ea9m<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Columns: ch\u1ecdn Th\u00e1ng (b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ed5i v\u1ecb tr\u00ed hai tr\u01b0\u1eddng \u1edf v\u00f9ng Rows v\u00e0 Columns, b\u1ea3ng s\u1ebd hi\u1ec3n th\u1ecb \u0111\u1ed5i v\u1ecb tr\u00ed c\u1ee7a h\u00e0ng v\u00e0 c\u1ed9t).<\/span><\/p><\/li><\/ul><p><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap; text-align: justify;\">\u00a0<\/span><\/p><p><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap; text-align: justify;\">K\u1ebft qu\u1ea3 Pivot Tables hi\u1ec3n th\u1ecb nh\u01b0 sau:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8a24396 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8a24396\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5cda393\" data-id=\"5cda393\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-96f8188 elementor-widget elementor-widget-image\" data-id=\"96f8188\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/su-dung-pivot-table-tong-hop-doanh-thu-san-pham-theo-thang.png\" title=\"su-dung-pivot-table-tong-hop-doanh-thu-san-pham-theo-thang\" alt=\"S\u1eed d\u1ee5ng pivot table t\u1ed5ng h\u1ee3p doanh thu t\u1eebng s\u1ea3n ph\u1ea9m theo th\u00e1ng\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-21b9163 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"21b9163\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d795ed7\" data-id=\"d795ed7\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fe334c1 elementor-widget elementor-widget-text-editor\" data-id=\"fe334c1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">L\u01b0u \u00fd quan tr\u1ecdng:<\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> Khi c\u00f3 s\u1ef1 b\u1ed5 sung hay \u0111i\u1ec1u ch\u1ec9nh \u1edf ngu\u1ed3n d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o, \u0111\u1ec3 c\u1eadp nh\u1eadt m\u1edbi d\u1eef li\u1ec7u trong Pivot Table: <\/span><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">T\u1ea1i thanh c\u00f4ng c\u1ee5, ch\u1ecdn tab <\/span><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Analyze <\/span><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">&gt;&gt; trong m\u1ee5c Data ch\u1ecdn <\/span><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Refresh<\/span><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\"> ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p <\/span><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">ph\u00edm t\u1eaft Alt + F5<\/span><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6124d09 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6124d09\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f91ae4c\" data-id=\"f91ae4c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0345693 elementor-widget elementor-widget-image\" data-id=\"0345693\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/refresh-pivot-table-update-cap-nhat-du-lieu-data.png\" title=\"refresh-pivot-table-update-cap-nhat-du-lieu-data\" alt=\"Khi c\u00f3 s\u1ef1 b\u1ed5 sung hay \u0111i\u1ec1u ch\u1ec9nh \u1edf ngu\u1ed3n d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o, \u0111\u1ec3 c\u1eadp nh\u1eadt m\u1edbi d\u1eef li\u1ec7u trong Pivot Table s\u1eed d\u1ee5ng Refresh trong tab Analyze\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-cd009b8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cd009b8\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5e75831\" data-id=\"5e75831\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f5f1f8c elementor-widget elementor-widget-heading\" data-id=\"f5f1f8c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-3c96b249-7fff-e3a7-8f6f-fbcceb7bf746\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">3. C\u00e1c V\u00ed D\u1ee5 H\u01b0\u1edbng D\u1eabn S\u1eed D\u1ee5ng Pivot Tables \u0110\u1ec3 Ph\u00e2n T\u00edch, T\u1ed5ng H\u1ee3p D\u1eef Li\u1ec7u<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8056dd9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8056dd9\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-84a7941\" data-id=\"84a7941\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d97303b elementor-widget elementor-widget-heading\" data-id=\"d97303b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-9099074a-7fff-1eca-463b-5b90015d90bd\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">3.1, Thay \u0110\u1ed5i Rows v\u00e0 Columns Cho M\u1ee5c \u0110\u00edch Ph\u00e2n T\u00edch D\u1eef Li\u1ec7u<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-31eb7cd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"31eb7cd\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-34bfe1b\" data-id=\"34bfe1b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-89a8fd1 elementor-widget elementor-widget-text-editor\" data-id=\"89a8fd1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Tr\u01b0\u1eddng h\u1ee3p b\u1ea1n c\u1ea7n t\u1ed5ng h\u1ee3p<\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> doanh thu khu v\u1ef1c<\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> theo t\u1eebng<\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> lo\u1ea1i s\u1ea3n ph\u1ea9m<\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">, c\u00e1c tr\u01b0\u1eddng d\u1eef li\u1ec7u c\u1ea7n s\u1eed d\u1ee5ng l\u00e0 \u201cDoanh thu\u201d, \u201cKhu v\u1ef1c\u201d, \u201cS\u1ea3n ph\u1ea9m\u201d.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">Ti\u1ebfp theo, h\u00e3y h\u00ecnh dung v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a c\u00e1c tr\u01b0\u1eddng d\u1eef li\u1ec7u. V\u00ed d\u1ee5, b\u1ea1n mu\u1ed1n c\u00e1c Khu V\u1ef1c s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1eb7t \u1edf \u0111\u1ea7u m\u1ed7i h\u00e0ng, c\u00e1c lo\u1ea1i S\u1ea3n ph\u1ea9m s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1eb7t \u1edf \u0111\u1ea7u m\u1ed7i c\u1ed9t.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Cu\u1ed1i c\u00f9ng, b\u1ea1n ch\u1ec9 c\u1ea7n k\u00e9o c\u00e1c tr\u01b0\u1eddng v\u00e0o c\u00e1c v\u00f9ng nh\u01b0 sau:<\/span><\/p><ul style=\"margin-top: 0; margin-bottom: 0;\"><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Values: k\u00e9o c\u1ed9t Doanh thu v\u00e0o v\u00e0 ch\u1ecdn ph\u00e9p to\u00e1n SUM<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Rows: ch\u1ecdn Khu V\u1ef1c<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Columns: ch\u1ecdn S\u1ea3n ph\u1ea9m.<\/span><\/p><\/li><\/ul><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span id=\"docs-internal-guid-59df513a-7fff-69d1-28e6-e5198ff6646c\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">B\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ed5i v\u1ecb tr\u1ecb Rows v\u00e0 Columns, khi \u0111\u00f3 b\u1ea3ng Pivot ch\u1ec9 \u0111\u01a1n gi\u1ea3n l\u00e0 chuy\u1ec3n \u0111\u1ed5i h\u00e0ng sang c\u1ed9t v\u00e0 ng\u01b0\u1ee3c l\u1ea1i.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-45c217f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"45c217f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ca6cca0\" data-id=\"ca6cca0\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b18a167 elementor-widget elementor-widget-image\" data-id=\"b18a167\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/su-dung-pivot-table-tong-hop-doanh-thu-khu-vuc-theo-san-pham.png\" title=\"su-dung-pivot-table-tong-hop-doanh-thu-khu-vuc-theo-san-pham\" alt=\"S\u1eed d\u1ee5ng pivot table \u0111\u1ec3 t\u1ed5ng h\u1ee3p doanh thu khu v\u1ef1c theo t\u1eebng lo\u1ea1i s\u1ea3n ph\u1ea9m\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-dc32531 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dc32531\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1dfc37e\" data-id=\"1dfc37e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3e9bc3f elementor-widget elementor-widget-heading\" data-id=\"3e9bc3f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-6cc84d79-7fff-3373-ecc5-7fe322e52145\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">3.2, S\u1eed D\u1ee5ng Filters Trong Pivot Table<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-538e16e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"538e16e\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b999f5a\" data-id=\"b999f5a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9a2e96e elementor-widget elementor-widget-text-editor\" data-id=\"9a2e96e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u00e1c v\u00ed d\u1ee5 tr\u00ean \u0111\u1ec1u x\u1eed l\u00fd c\u00e1c b\u00e0i to\u00e1n t\u1ed5ng h\u1ee3p, ph\u00e2n t\u00edch to\u00e0n b\u1ed9 1 c\u1ed9t. Tr\u01b0\u1eddng h\u1ee3p c\u1ea7n ph\u00e2n t\u00edch m\u1ed9t gi\u00e1 tr\u1ecb trong m\u1ed9t c\u1ed9t th\u00ec sao?<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">&nbsp;<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">V\u00f9ng <\/span><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Filter <\/span><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">s\u1ebd gi\u1ea3i quy\u1ebft gi\u00fap b\u1ea1n c\u00e2u h\u1ecfi n\u00e0y.<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">&nbsp;<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">\u0110\u1ec3 t\u1ed5ng h\u1ee3p<\/span><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\"> doanh thu khu v\u1ef1c h\u00e0ng th\u00e1ng theo m\u1ed9t lo\u1ea1i s\u1ea3n ph\u1ea9m c\u1ee5 th\u1ec3<\/span><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">, b\u1ea1n \u0111\u1eb7t tr\u01b0\u1eddng S\u1ea3n ph\u1ea9m v\u00e0o Filter \u0111\u1ec3 l\u1ecdc khi c\u1ea7n ph\u00e2n t\u00edch m\u1ed9t s\u1ea3n ph\u1ea9m trong tr\u01b0\u1eddng n\u00e0y:<\/span><\/p><ul style=\"margin-top: 0; margin-bottom: 0;\"><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Filters: ch\u1ecdn S\u1ea3n ph\u1ea9m<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Values: ch\u1ecdn Doanh thu v\u00e0 ch\u1ecdn ph\u00e9p to\u00e1n SUM<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Rows: ch\u1ecdn Khu V\u1ef1c<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Columns: ch\u1ecdn Th\u00e1ng.<\/span><\/p>\n<\/li>\n<\/ul>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-75e0181 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"75e0181\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-66cd85b\" data-id=\"66cd85b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2bcd9a7 elementor-widget elementor-widget-image\" data-id=\"2bcd9a7\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/ket-qua-su-dung-filter-trong-pivot-table-san-pham.png\" title=\"ket-qua-su-dung-filter-trong-pivot-table-san-pham\" alt=\"S\u1eed D\u1ee5ng Filters Trong PivotTable\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a90c9bd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a90c9bd\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b085113\" data-id=\"b085113\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-cc1ce5a elementor-widget elementor-widget-text-editor\" data-id=\"cc1ce5a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">T\u01b0\u01a1ng t\u1ef1, \u0111\u1ec3 gi\u1ea3i quy\u1ebft c\u00e2u h\u1ecfi \u1edf \u0111\u1ea7u m\u1ee5c 3, b\u1ea1n mu\u1ed1n bi\u1ebft <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">doanh thu b\u00e1n h\u00e0ng khu v\u1ef1c mi\u1ec1n B\u1eafc theo s\u1ea3n ph\u1ea9m t\u1eebng th\u00e1ng<\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">:<\/span> <span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Sau khi x\u00e1c \u0111\u1ecbnh tr\u01b0\u1eddng d\u1eef li\u1ec7u l\u00e0 \u201cKhu v\u1ef1c\u201d, \u201cS\u1ea3n ph\u1ea9m\u201d, \u201cTh\u00e1ng\u201d v\u00e0 \u201cDoanh thu\u201d, k\u00e9o\/ ch\u1ecdn v\u00f9ng nh\u01b0 sau:<\/span><\/p><ul style=\"margin-top: 0; margin-bottom: 0;\"><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Filters: ch\u1ecdn Khu v\u1ef1c<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Values: ch\u1ecdn Doanh thu v\u00e0 ch\u1ecdn ph\u00e9p to\u00e1n SUM<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Rows: ch\u1ecdn S\u1ea3n ph\u1ea9m<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Columns: ch\u1ecdn Th\u00e1ng.<\/span><\/p><\/li><\/ul>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-aab938d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"aab938d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6d03efc\" data-id=\"6d03efc\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-76b75d6 elementor-widget elementor-widget-image\" data-id=\"76b75d6\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/ket-qua-su-dung-pivot-table.png\" title=\"ket-qua-su-dung-pivot-table\" alt=\"S\u1eed D\u1ee5ng Filters Trong Pivot Table\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-07590a5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"07590a5\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c0d5ec3\" data-id=\"c0d5ec3\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b2dbc0e elementor-widget elementor-widget-text-editor\" data-id=\"b2dbc0e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-67333ff8-7fff-0eba-c522-6dbc188af1b8\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Filter Khu v\u1ef1c hi\u1ec7n ra \u1edf \u0111\u1ea7u b\u1ea3ng Pivot, ch\u1ecdn m\u0169i t\u00ean th\u1ea3 xu\u1ed1ng, danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb trong c\u1ed9t Khu v\u1ef1c hi\u1ec7n ra: Mi\u1ec1n B\u1eafc, Mi\u1ec1n Nam, Mi\u1ec1n Trung.<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4c8a9eb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4c8a9eb\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-cca6e23\" data-id=\"cca6e23\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-932c222 elementor-widget elementor-widget-image\" data-id=\"932c222\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/su-dung-filter-trong-pivot-table.png\" title=\"su-dung-filter-trong-pivot-table\" alt=\"Filter Khu v\u1ef1c hi\u1ec7n ra \u1edf \u0111\u1ea7u b\u1ea3ng Pivot Table, ch\u1ecdn m\u0169i t\u00ean th\u1ea3 xu\u1ed1ng\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9831b26 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9831b26\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2c6f64e\" data-id=\"2c6f64e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b66b3c0 elementor-widget elementor-widget-text-editor\" data-id=\"b66b3c0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Excel m\u1eb7c \u0111\u1ecbnh ch\u1ec9 ch\u1ecdn 1 gi\u00e1 tr\u1ecb. \u0110\u1ec3 ch\u1ecdn t\u1eeb 2 gi\u00e1 tr\u1ecb tr\u1edf l\u00ean \u1edf Filter, tick <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Select Multiple Items.<\/span><\/p><p><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap; text-align: justify;\">Ch\u1ecdn Mi\u1ec1n B\u1eafc, \u1ea5n OK, d\u1eef li\u1ec7u c\u1ea7n t\u1ed5ng h\u1ee3p v\u00e0 ph\u00e2n t\u00edch \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n nh\u01b0 sau:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b37dd83 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b37dd83\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-51e6dde\" data-id=\"51e6dde\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d930407 elementor-widget elementor-widget-image\" data-id=\"d930407\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/ket-qua-su-dung-pivot-table-filter-khu-vuc.png\" title=\"ket-qua-su-dung-pivot-table-filter-khu-vuc\" alt=\"S\u1eed D\u1ee5ng Filters Trong Pivot Table \u0110\u1ec3 t\u1ed5ng h\u1ee3p doanh thu 1 khu v\u1ef1c c\u1ee5 th\u1ec3 h\u00e0ng th\u00e1ng theo c\u00e1c lo\u1ea1i s\u1ea3n ph\u1ea9m\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1c30eee elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1c30eee\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-29c8a03\" data-id=\"29c8a03\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-605bd0a elementor-widget elementor-widget-heading\" data-id=\"605bd0a\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-3a71d277-7fff-4da1-1806-af030d5d6482\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">3.3, V\u00ed D\u1ee5 Pivot Tables S\u1eed D\u1ee5ng T\u1eeb 2 Tr\u01b0\u1eddng D\u1eef Li\u1ec7u Trong 1 V\u00f9ng (Area)<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8f65618 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8f65618\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5ccc7d6\" data-id=\"5ccc7d6\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-bf653ed elementor-widget elementor-widget-text-editor\" data-id=\"bf653ed\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u00e1c v\u00ed d\u1ee5 \u1edf tr\u00ean \u0111\u1ec1u ch\u1ec9 k\u00e9o 1 tr\u01b0\u1eddng d\u1eef li\u1ec7u cho Filter, H\u00e0ng v\u00e0 C\u1ed9t.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">B\u1ea1n c\u00f3 th\u1eafc m\u1eafc Pivot table tr\u00f4ng s\u1ebd nh\u01b0 th\u1ebf n\u00e0o n\u1ebfu 1 v\u00f9ng ch\u1ee9a nhi\u1ec1u h\u01a1n 1 tr\u01b0\u1eddng d\u1eef li\u1ec7u?<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">Thay v\u00ec s\u1eed d\u1ee5ng Filter, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng d\u1eef li\u1ec7u l\u1ed3ng nhau b\u1eb1ng c\u00e1ch th\u00eam tr\u01b0\u1eddng v\u00e0o c\u00e1c v\u00f9ng Rows v\u00e0 Columns. V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y t\u1ed5ng h\u1ee3p Doanh thu t\u1eebng lo\u1ea1i S\u1ea3n ph\u1ea9m theo Khu v\u1ef1c v\u00e0 Th\u00e1ng (S\u1ea3n ph\u1ea9m &gt;&gt; Khu v\u1ef1c):<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8de9f4d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8de9f4d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7ac9789\" data-id=\"7ac9789\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-73bb850 elementor-widget elementor-widget-image\" data-id=\"73bb850\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/sap-xep-du-lieu-trong-pivot-table-de-phan-tich-vung-theo-san-pham.png\" title=\"sap-xep-du-lieu-trong-pivot-table-de-phan-tich-vung-theo-san-pham\" alt=\"V\u00ed D\u1ee5 Pivot Tables S\u1eed D\u1ee5ng T\u1eeb 2 Tr\u01b0\u1eddng D\u1eef Li\u1ec7u Trong 1 V\u00f9ng\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7fd238c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7fd238c\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fa57ab7\" data-id=\"fa57ab7\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d0d672a elementor-widget elementor-widget-text-editor\" data-id=\"d0d672a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">N\u1ebfu th\u1ee9 t\u1ef1 th\u00eam tr\u01b0\u1eddng v\u00e0o Area thay \u0111\u1ed5i, d\u1eef li\u1ec7u c\u0169ng thay \u0111\u1ed5i t\u01b0\u01a1ng \u1ee9ng.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">N\u1ebfu \u0111\u1ea3o th\u1ee9 t\u1ef1 c\u1ee7a tr\u01b0\u1eddng S\u1ea3n ph\u1ea9m l\u00ean ph\u00eda tr\u00ean tr\u01b0\u1eddng Khu V\u1ef1c trong Rows th\u00ec Pivot Table hi\u1ec3n th\u1ecb t\u1ed5ng h\u1ee3p Doanh thu t\u1eebng Khu v\u1ef1c theo S\u1ea3n ph\u1ea9m v\u00e0 Th\u00e1ng (Khu v\u1ef1c &gt;&gt; S\u1ea3n ph\u1ea9m):<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5a3534e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5a3534e\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1d75f52\" data-id=\"1d75f52\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2c4288d elementor-widget elementor-widget-image\" data-id=\"2c4288d\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/sap-xep-du-lieu-trong-pivot-table-de-phan-tich-san-pham-theo-vung.png\" title=\"sap-xep-du-lieu-trong-pivot-table-de-phan-tich-san-pham-theo-vung\" alt=\"N\u1ebfu th\u1ee9 t\u1ef1 th\u00eam tr\u01b0\u1eddng v\u00e0o Area thay \u0111\u1ed5i, d\u1eef li\u1ec7u Pivot table c\u0169ng thay \u0111\u1ed5i t\u01b0\u01a1ng \u1ee9ng\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6b908a1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6b908a1\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d935213\" data-id=\"d935213\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7685b78 elementor-widget elementor-widget-heading\" data-id=\"7685b78\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-dd972ebb-7fff-7e95-6515-05d68b0d180b\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">4. C\u00e1ch S\u1eed D\u1ee5ng Pivot Table N\u00e2ng Cao \u1ee8ng D\u1ee5ng Gi\u1ea3i B\u00e0i T\u1eadp Excel \u1ede M\u1ee5c 1<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-99be5a6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"99be5a6\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f1dcd83\" data-id=\"f1dcd83\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e0dc631 elementor-widget elementor-widget-text-editor\" data-id=\"e0dc631\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Sau khi \u0111\u00e3 t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng Pivot Table c\u01a1 b\u1ea3n, c\u00e1c b\u1ea1n h\u00e3y c\u00f9ng Hoctin.vn tr\u1ea3 l\u1eddi nh\u1eefng c\u00e2u h\u1ecfi \u0111\u1ec1 ra \u1edf \u0111\u1ea7u b\u00e0i vi\u1ebft nh\u00e9!<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">\u0110\u1ec3 ti\u1ec7n theo d\u00f5i, hoctin.vn s\u1ebd \u0111\u1eb7t Pivot Table \u1edf c\u1ea1nh d\u1eef li\u1ec7u g\u1ed1c b\u1eb1ng c\u00e1ch ch\u1ecdn m\u1ee5c <\/span><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Existing Worksheet <\/span><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">trong h\u1ed9p tho\u1ea1i <\/span><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Create Pivot Table<\/span><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e61fcde elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e61fcde\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-725716e\" data-id=\"725716e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0609792 elementor-widget elementor-widget-heading\" data-id=\"0609792\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-d04dfaed-7fff-faa1-60fe-df5da36135b8\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Q1: Doanh thu t\u1eebng th\u00e1ng c\u1ee7a c\u00f4ng ty?<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-dd6f515 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dd6f515\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-31063fd\" data-id=\"31063fd\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c86b0e4 elementor-widget elementor-widget-text-editor\" data-id=\"c86b0e4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">N\u1ebfu \u0111\u00e3 t\u00ecm hi\u1ec3u c\u00e1c v\u00ed d\u1ee5 tr\u00ean c\u1ee7a hoctin.vn th\u00ec tr\u1ea3 l\u1eddi c\u00e2u h\u1ecfi n\u00e0y qu\u00e1 d\u1ec5 \u0111\u00fang kh\u00f4ng?<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f6da061 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f6da061\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7426c69\" data-id=\"7426c69\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6e1379d elementor-widget elementor-widget-image\" data-id=\"6e1379d\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/Doanh-thu-tung-thang-cua-cong-ty-ap-dung-pivot-table.png\" title=\"Doanh-thu-tung-thang-cua-cong-ty-ap-dung-pivot-table\" alt=\"C\u00e1ch S\u1eed D\u1ee5ng Pivot Table N\u00e2ng Cao \u1ee8ng D\u1ee5ng Gi\u1ea3i B\u00e0i T\u1eadp Excel Doanh thu t\u1eebng th\u00e1ng c\u1ee7a c\u00f4ng ty\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a812fd6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a812fd6\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9d0c7a3\" data-id=\"9d0c7a3\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5f3c2ad elementor-widget elementor-widget-heading\" data-id=\"5f3c2ad\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-f4cdf231-7fff-442d-67bb-c4f6571f402b\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Q2: Khu v\u1ef1c mi\u1ec1n Nam b\u00e1n ch\u1ea1y nh\u1ea5t lo\u1ea1i s\u1ea3n ph\u1ea9m n\u00e0o (s\u1ed1 l\u01b0\u1ee3ng l\u1edbn nh\u1ea5t)?<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0535878 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0535878\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5651a61\" data-id=\"5651a61\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1d20a09 elementor-widget elementor-widget-text-editor\" data-id=\"1d20a09\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">S\u1eed d\u1ee5ng Filter l\u1ecdc khu v\u1ef1c Mi\u1ec1n Nam, r\u1ed3i ch\u1ecdn ra s\u1ea3n ph\u1ea9m b\u00e1n ch\u1ea1y nh\u1ea5t l\u00e0 \u00c1o S\u01a1 Mi (860 chi\u1ebfc) so v\u1edbi s\u1ea3n ph\u1ea9m c\u00f2n l\u1ea1i l\u00e0 Qu\u1ea7n Short (b\u00e1n \u0111\u01b0\u1ee3c 550 chi\u1ebfc).<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b9ababe elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b9ababe\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1f7cdbb\" data-id=\"1f7cdbb\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-878b2e4 elementor-widget elementor-widget-image\" data-id=\"878b2e4\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/San-pham-ban-chay-nhat-su-dung-pivot-table.png\" title=\"San-pham-ban-chay-nhat-su-dung-pivot-table\" alt=\"C\u00e1ch S\u1eed D\u1ee5ng Pivot Table N\u00e2ng Cao \u1ee8ng D\u1ee5ng Gi\u1ea3i B\u00e0i T\u1eadp Excel T\u00ecm s\u1ea3n ph\u1ea9m b\u00e1n ch\u1ea1y nh\u1ea5t\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7588fc5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7588fc5\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-31bb629\" data-id=\"31bb629\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3039a6e elementor-widget elementor-widget-heading\" data-id=\"3039a6e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-c3eb128c-7fff-4560-bcd0-1403610e3ccd\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Q3: Khu v\u1ef1c n\u00e0o b\u00e1n \u0111\u01b0\u1ee3c nhi\u1ec1u \u00e1o s\u01a1 mi nh\u1ea5t?<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-28c5aa5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"28c5aa5\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6091b2f\" data-id=\"6091b2f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4fef320 elementor-widget elementor-widget-text-editor\" data-id=\"4fef320\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">T\u01b0\u01a1ng t\u1ef1 c\u00e2u h\u1ecfi 2, \u0111\u1ec3 gi\u1ea3i b\u00e0i t\u1eadp Excel n\u00e0y, b\u1ea1n ch\u1ec9 c\u1ea7n Filter S\u1ea3n ph\u1ea9m \u00c1o S\u01a1 Mi v\u00e0 ch\u1ecdn Values l\u00e0 h\u00e0m SUM cho S\u1ed1 L\u01b0\u1ee3ng: b\u1ea3ng Pivot Table s\u1ebd tr\u1ea3 v\u1ec1 t\u1ed5ng s\u1ed1 \u00e1o s\u01a1 mi \u0111\u00e3 b\u00e1n c\u1ee7a t\u1eebng v\u00f9ng.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">K\u1ebft qu\u1ea3: Mi\u1ec1n Nam l\u00e0 v\u00f9ng b\u00e1n \u0111\u01b0\u1ee3c nhi\u1ec1u \u00e1o s\u01a1 mi nh\u1ea5t.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d634773 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d634773\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d8cec62\" data-id=\"d8cec62\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-92f55b3 elementor-widget elementor-widget-image\" data-id=\"92f55b3\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/khu-vuc-ban-chay-san-pham-nhat-su-dung-pivot-table.png\" title=\"khu-vuc-ban-chay-san-pham-nhat-su-dung-pivot-table\" alt=\"C\u00e1ch S\u1eed D\u1ee5ng Pivot Table N\u00e2ng Cao \u1ee8ng D\u1ee5ng Gi\u1ea3i B\u00e0i T\u1eadp Excel\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2ec7edc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2ec7edc\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3c1fb33\" data-id=\"3c1fb33\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2de4907 elementor-widget elementor-widget-heading\" data-id=\"2de4907\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-4e7e5b7c-7fff-ecae-284d-509acee2f1d5\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Q4: S\u1ed1 l\u01b0\u1ee3ng \u00e1o b\u00e1n \u0111\u01b0\u1ee3c c\u1ee7a c\u00e1c khu v\u1ef1c?<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9731c50 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9731c50\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-cffa56e\" data-id=\"cffa56e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e74de97 elementor-widget elementor-widget-text-editor\" data-id=\"e74de97\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">\u0110\u1ec3 tr\u1ea3 l\u1eddi c\u00e2u h\u1ecfi n\u00e0y, hoctin.vn v\u1eabn s\u1eed d\u1ee5ng v\u00f9ng Filter c\u1ee7a Pivot Table, ch\u1ec9 c\u00f3 \u0111i\u1ec3m kh\u00e1c v\u1edbi c\u00e1c v\u00ed d\u1ee5 tr\u00ean \u1edf ch\u1ed7, c\u00f3 nhi\u1ec1u h\u01a1n 1 s\u1ea3n ph\u1ea9m l\u00e0 \u00e1o n\u00ean b\u1ea1n s\u1ebd c\u1ea7n ch\u1ecdn Select Multiple Items \u0111\u1ec3 l\u1ecdc b\u1ea3ng Pivot cho t\u1eeb 2 s\u1ea3n ph\u1ea9m tr\u1edf l\u00ean.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a271231 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a271231\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-817c258\" data-id=\"817c258\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-467218c elementor-widget elementor-widget-image\" data-id=\"467218c\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/so-luong-ao-ban-duoc-su-dung-pivot-table-va-filter-de-chon-nhieu-san-pham-cung-luc.png\" title=\"so-luong-ao-ban-duoc-su-dung-pivot-table-va-filter-de-chon-nhieu-san-pham-cung-luc\" alt=\"C\u00e1ch S\u1eed D\u1ee5ng Pivot Table N\u00e2ng Cao \u1ee8ng D\u1ee5ng Gi\u1ea3i B\u00e0i T\u1eadp Excel Filters Nhi\u1ec1u gi\u00e1 tr\u1ecb\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b87357e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b87357e\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-12478bd\" data-id=\"12478bd\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2548231 elementor-widget elementor-widget-text-editor\" data-id=\"2548231\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">S\u1ed1 l\u01b0\u1ee3ng \u00e1o b\u00e1n \u0111\u01b0\u1ee3c c\u1ee7a c\u00e1c khu v\u1ef1c (\u00e1o thun v\u00e0 \u00e1o s\u01a1 mi) l\u00e0:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c86421f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c86421f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-152c19f\" data-id=\"152c19f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-619ac17 elementor-widget elementor-widget-image\" data-id=\"619ac17\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/su-dung-pivot-table-va-filter-de-chon-nhieu-san-pham-cung-luc.png\" title=\"su-dung-pivot-table-va-filter-de-chon-nhieu-san-pham-cung-luc\" alt=\"C\u00e1ch S\u1eed D\u1ee5ng Pivot Table N\u00e2ng Cao \u1ee8ng D\u1ee5ng Gi\u1ea3i B\u00e0i T\u1eadp Excel Filters 2 S\u1ea3n ph\u1ea9m\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-220bc09 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"220bc09\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fdd1d62\" data-id=\"fdd1d62\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0beb4da elementor-widget elementor-widget-text-editor\" data-id=\"0beb4da\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height:1.38;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:12pt;font-family:Arial;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">Tr\u00ean \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 \u1ee9ng d\u1ee5ng Pivot Table t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao. Hi v\u1ecdng b\u00e0i vi\u1ebft c\u1ee7a Hoctin.vn \u0111\u00e3 mang l\u1ea1i cho c\u00e1c b\u1ea1n c\u00e1c th\u00f4ng tin h\u1eefu \u00edch.<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height:1.38;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><span style=\"background-color: transparent; color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; white-space: pre-wrap;\"><br><\/span><\/p>\n<p dir=\"ltr\" style=\"line-height:1.38;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><span style=\"background-color: transparent; color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">M\u1eddi c\u00e1c b\u1ea1n \u0111\u00f3n \u0111\u1ecdc b\u00e0i vi\u1ebft v\u1ec1 c\u00e1ch d\u00f9ng <\/span><a href=\"https:\/\/hoctin.vn\/pivot-table-nang-cao\/\" target=\"_blank\">Pivot Table n\u00e2ng cao<\/a><span style=\"background-color: transparent; color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">: s\u1eed d\u1ee5ng Slicer <\/span><span style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 16px; white-space: pre-wrap;\">trong PivotTable <\/span><span style=\"background-color: transparent; color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u, Calculated Field \u0111\u1ec3 th\u00eam tr\u01b0\u1eddng t\u00ednh to\u00e1n, tr\u00e1nh b\u1eaby Average v\u00e0 tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb sheet n\u00e0y sang sheet kh\u00e1c.<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height:1.38;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><span style=\"background-color: transparent; color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; white-space: pre-wrap;\"><br><\/span><\/p>\n<p dir=\"ltr\" style=\"line-height:1.38;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><span style=\"background-color: transparent; color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">Ngo\u00e0i ra, \u0111\u1ec3 \u1ee9ng d\u1ee5ng hi\u1ec7u qu\u1ea3 Excel, b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c c\u1ee7a Excel, h\u00e3y c\u00f9ng \u0111\u00f3n \u0111\u1ecdc series b\u00e0i vi\u1ebft \u1ee9ng d\u1ee5ng c\u00e1c h\u00e0m Excel:<\/span><\/p>\n<p><span style=\"background-color: transparent; color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; white-space: pre-wrap; text-align: justify;\"><br><\/span><\/p>\n<p><a href=\"https:\/\/hoctin.vn\/cach-su-dung-ham-vlookup-trong-excel\/\" target=\"_blank\">H\u00e0m VLOOKUP<\/a><br><\/p>\n<p><a href=\"https:\/\/hoctin.vn\/ham-countif-co-ban\/\" target=\"_blank\">H\u00e0m COUNTIF<\/a><br><\/p>\n<p><a href=\"https:\/\/hoctin.vn\/ham-if-trong-excel\/\" target=\"_blank\">H\u00e0m IF<\/a><br><\/p>\n<div><span style=\"font-size:12pt;font-family:Arial;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\"><br><\/span><\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Pivot Table l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu \u00edch trong Excel v\u1edbi nhi\u1ec1u t\u00ednh n\u0103ng v\u01b0\u1ee3t tr\u1ed9i v\u1edbi t\u1ed1c \u0111\u1ed9 ra k\u1ebft qu\u1ea3 nhanh v\u00e0 d\u1ec5 d\u00e0ng thao t\u00e1c. Ch\u1ec9 c\u1ea7n n\u1eafm trong tay nh\u1eefng t\u00ednh n\u0103ng c\u01a1 b\u1ea3n c\u1ee7a Pivot Table, b\u1ea1n c\u00f3 th\u1ec3 c\u1ea3i thi\u1ec7n hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh m\u1ed9t c\u00e1ch \u0111\u00e1ng k\u1ec3. &#8230; <a title=\"H\u01b0\u1edbng D\u1eabn S\u1eed D\u1ee5ng Pivot Table Trong Excel V\u00e0 V\u00ed D\u1ee5 C\u1ee5 Th\u1ec3\" class=\"read-more\" href=\"https:\/\/hoctin.vn\/pivot-table-trong-excel\/\">Read more <span class=\"screen-reader-text\">H\u01b0\u1edbng D\u1eabn S\u1eed D\u1ee5ng Pivot Table Trong Excel V\u00e0 V\u00ed D\u1ee5 C\u1ee5 Th\u1ec3<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":944,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25],"tags":[14],"_links":{"self":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/900"}],"collection":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/comments?post=900"}],"version-history":[{"count":0,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/900\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media\/944"}],"wp:attachment":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media?parent=900"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/categories?post=900"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/tags?post=900"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}