{"id":256132,"date":"2023-09-13T19:20:16","date_gmt":"2023-09-13T12:20:16","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=256132"},"modified":"2023-09-13T19:20:16","modified_gmt":"2023-09-13T12:20:16","slug":"pivot-table","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/pivot-table\/","title":{"rendered":"Pivot Table l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng Pivot Table trong Excel"},"content":{"rendered":"<p>Pivot Table kh\u00f4ng ch\u1ec9 l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 ph\u00e2n t\u00edch m\u1ea1nh m\u1ebd trong Excel m\u00e0 c\u00f2n l\u00e0 m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n v\u00e0 hi\u1ec7u qu\u1ea3 \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p. V\u1edbi kh\u1ea3 n\u0103ng t\u1ed5ng h\u1ee3p, s\u1eafp x\u1ebfp, v\u00e0 t\u00ednh to\u00e1n d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch nhanh ch\u00f3ng, c\u00f4ng c\u1ee5 n\u00e0y \u0111\u00e3 tr\u1edf th\u00e0nh m\u1ed9t tr\u1ee3 th\u1ee7 \u0111\u1eafc l\u1ef1c cho nh\u1eefng ng\u01b0\u1eddi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u.<\/p>\n<h2>Pivot table l\u00e0 g\u00ec?<\/h2>\n<p>\u0110\u00e2y l\u00e0 m\u1ed9t t\u00ednh n\u0103ng xu\u1ea5t hi\u1ec7n trong c\u00e1c \u1ee9ng d\u1ee5ng b\u1ea3ng t\u00ednh nh\u01b0 Microsoft Excel, Google Sheets v\u00e0 Apple Numbers, cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng d\u1ec5 d\u00e0ng t\u1ed5ng h\u1ee3p v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u. T\u00ednh n\u0103ng n\u00e0y cho ph\u00e9p thay \u0111\u1ed5i c\u00e1ch hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u, s\u1eafp x\u1ebfp l\u1ea1i c\u00e1c gi\u00e1 tr\u1ecb, th\u00eam\/x\u00f3a th\u00f4ng tin chi ti\u1ebft v\u00e0 th\u1ef1c hi\u1ec7n c\u00e1c t\u00ednh to\u00e1n t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u.<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-256229\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table.jpg\" alt=\"Pivot-table-18 \" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>Pivot Table th\u01b0\u1eddng \u0111\u01b0\u1ee3c \u01b0a chu\u1ed9ng khi ph\u1ea3i x\u1eed l\u00fd v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u trong c\u00e1c b\u1ea3ng t\u00ednh l\u1edbn, gi\u00fap ng\u01b0\u1eddi d\u00f9ng nhanh ch\u00f3ng t\u00ecm ki\u1ebfm th\u00f4ng tin quan tr\u1ecdng v\u00e0 c\u00f3 c\u00e1i nh\u00ecn s\u00e2u h\u01a1n v\u1ec1 d\u1eef li\u1ec7u \u0111ang l\u00e0m vi\u1ec7c. \u1ee8ng d\u1ee5ng c\u1ee7a c\u00f4ng c\u1ee5 n\u00e0y r\u1ea5t \u0111a d\u1ea1ng, t\u1eeb ph\u00e2n t\u00edch t\u00e0i ch\u00ednh, \u0111\u00e1nh gi\u00e1 doanh s\u1ed1 kinh doanh, \u0111\u1ebfn ph\u00e2n t\u00edch d\u1eef li\u1ec7u li\u00ean quan \u0111\u1ebfn kh\u00e1ch h\u00e0ng, s\u1ea3n ph\u1ea9m ho\u1eb7c d\u1ecbch v\u1ee5.<\/p>\n<p>Tuy nhi\u00ean, \u0111\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 n\u00e0y m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n n\u1eafm v\u1eefng c\u00e1ch t\u1ea1o v\u00e0 t\u00f9y ch\u1ec9nh, c\u00f9ng v\u1edbi vi\u1ec7c tu\u00e2n th\u1ee7 c\u00e1c l\u01b0u \u00fd v\u00e0 kinh nghi\u1ec7m khi l\u00e0m vi\u1ec7c v\u1edbi t\u00ednh n\u0103ng n\u00e0y.<\/p>\n<h2>C\u00e1c t\u00ednh n\u0103ng c\u1ee7a c\u00f4ng c\u1ee5 Pivot table l\u00e0 g\u00ec?<\/h2>\n<p>C\u00f4ng c\u1ee5 n\u00e0y kh\u00f4ng ch\u1ec9 \u0111\u01a1n gi\u1ea3n l\u00e0 m\u1ed9t c\u00e1ch \u0111\u1ec3 t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u, n\u00f3 c\u00f2n cung c\u1ea5p m\u1ed9t lo\u1ea1t c\u00e1c t\u00ednh n\u0103ng v\u00e0 kh\u1ea3 n\u0103ng t\u00f9y ch\u1ec9nh m\u00e0 gi\u00fap b\u1ea1n khai th\u00e1c s\u00e2u v\u00e0o th\u00f4ng tin v\u00e0 t\u1ea1o ra b\u00e1o c\u00e1o th\u1ed1ng k\u00ea \u0111a d\u1ea1ng. M\u1ed9t s\u1ed1 t\u00ednh n\u0103ng n\u1ed5i b\u1eadt c\u1ee7a c\u1ee7a b\u1ea3ng t\u1ed5ng h\u1ee3p n\u00e0y nh\u01b0:<\/p>\n<p><strong>T\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u:<\/strong> Cho ph\u00e9p t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u ngu\u1ed3n theo c\u00e1c c\u1ed9t ho\u1eb7c thu\u1ed9c t\u00ednh c\u1ee5 th\u1ec3. B\u1ea1n c\u00f3 th\u1ec3 t\u00ednh t\u1ed5ng, \u0111\u1ebfm, t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t, gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t, t\u00ednh trung b\u00ecnh,&#8230;<\/p>\n<p><strong>Nh\u00f3m d\u1eef li\u1ec7u:<\/strong> B\u1ea1n c\u00f3 kh\u1ea3 n\u0103ng nh\u00f3m d\u1eef li\u1ec7u d\u1ef1a tr\u00ean c\u00e1c gi\u00e1 tr\u1ecb trong c\u00e1c c\u1ed9t, cho ph\u00e9p b\u1ea1n t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u theo nh\u00f3m m\u1ed9t c\u00e1ch t\u1ef1 \u0111\u1ed9ng. V\u00ed d\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 nh\u00f3m c\u00e1c m\u1ee5c theo danh m\u1ee5c s\u1ea3n ph\u1ea9m, khu v\u1ef1c \u0111\u1ecba l\u00fd ho\u1eb7c th\u1eddi gian.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-256214\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-3.jpg\" alt=\"Pivot-table-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p><strong>Xoay (pivot) d\u1eef li\u1ec7u:<\/strong> Cho ph\u00e9p thay \u0111\u1ed5i c\u1ea5u tr\u00fac c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u b\u1eb1ng c\u00e1ch xoay c\u1ed9t th\u00e0nh h\u00e0ng v\u00e0 ng\u01b0\u1ee3c l\u1ea1i.<\/p>\n<p><strong>T\u00edch h\u1ee3p c\u00e1c h\u00e0m t\u00ednh to\u00e1n:<\/strong> Pivot Table cho ph\u00e9p b\u1ea1n s\u1eed d\u1ee5ng c\u00e1c h\u00e0m t\u00ednh to\u00e1n \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh ph\u1ee9c t\u1ea1p tr\u00ean d\u1eef li\u1ec7u, nh\u01b0 t\u00edch h\u1ee3p gi\u1eefa c\u00e1c gi\u00e1 tr\u1ecb ho\u1eb7c t\u00ednh to\u00e1n t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m.<\/p>\n<p><strong>T\u1ea1o b\u00e1o c\u00e1o v\u00e0 bi\u1ec3u \u0111\u1ed3:<\/strong> B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 n\u00e0y \u0111\u1ec3 t\u1ea1o c\u00e1c b\u00e1o c\u00e1o v\u00e0 bi\u1ec3u \u0111\u1ed3 d\u1ef1a tr\u00ean d\u1eef li\u1ec7u t\u1ed5ng h\u1ee3p m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng.<\/p>\n<p><strong>L\u1ecdc d\u1eef li\u1ec7u:<\/strong> Cho ph\u00e9p b\u1ea1n l\u1ecdc d\u1eef li\u1ec7u d\u1ef1a tr\u00ean c\u00e1c ti\u00eau ch\u00ed c\u1ee5 th\u1ec3, cho ph\u00e9p b\u1ea1n t\u1eadp trung v\u00e0o c\u00e1c ph\u1ea7n quan tr\u1ecdng c\u1ee7a d\u1eef li\u1ec7u ho\u1eb7c t\u1ea1o c\u00e1c b\u00e1o c\u00e1o ph\u1ee5 theo c\u00e1c \u0111i\u1ec1u ki\u1ec7n t\u00f9y ch\u1ecdn.<\/p>\n<h2>\u01afu \u0111i\u1ec3m c\u1ee7a Pivot table<\/h2>\n<p>C\u00f4ng c\u1ee5 n\u00e0y c\u00f3 nhi\u1ec1u \u01b0u \u0111i\u1ec3m quan tr\u1ecdng khi s\u1eed d\u1ee5ng trong vi\u1ec7c x\u1eed l\u00fd v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u, bao g\u1ed3m:<\/p>\n<p>T\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u d\u1ec5 d\u00e0ng: Cho ph\u00e9p b\u1ea1n t\u1ed5ng h\u1ee3p v\u00e0 t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u l\u1edbn m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng. B\u1ea1n c\u00f3 th\u1ec3 t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u theo nhi\u1ec1u c\u00e1ch kh\u00e1c nhau, t\u1eeb t\u00ednh t\u1ed5ng, \u0111\u1ebfm, \u0111\u1ebfn t\u00ednh trung b\u00ecnh v\u00e0 nhi\u1ec1u ph\u00e9p t\u00ednh kh\u00e1c.<\/p>\n<p>T\u1ea1o b\u00e1o c\u00e1o linh ho\u1ea1t: Pivot Table cho ph\u00e9p b\u1ea1n xoay c\u1ed9t th\u00e0nh h\u00e0ng v\u00e0 ng\u01b0\u1ee3c l\u1ea1i, t\u1ea1o ra c\u00e1c b\u00e1o c\u00e1o c\u00f3 c\u1ea5u tr\u00fac kh\u00e1c nhau \u0111\u1ec3 th\u1ec3 hi\u1ec7n d\u1eef li\u1ec7u theo nhi\u1ec1u g\u00f3c \u0111\u1ed9. \u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea1n nhanh ch\u00f3ng thay \u0111\u1ed5i c\u00e1ch hi\u1ec3n th\u1ecb th\u00f4ng tin v\u00e0 t\u1ea1o b\u00e1o c\u00e1o t\u00f9y ch\u1ec9nh.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-256228\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-17.jpg\" alt=\"Pivot-table-17\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-17.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-17-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-17-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>T\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt d\u1eef li\u1ec7u: Khi d\u1eef li\u1ec7u ngu\u1ed3n thay \u0111\u1ed5i, c\u00f3 th\u1ec3 t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt \u0111\u1ec3 hi\u1ec3n th\u1ecb th\u00f4ng tin m\u1edbi nh\u1ea5t. \u0110i\u1ec1u n\u00e0y ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c so v\u1edbi vi\u1ec7c c\u1eadp nh\u1eadt b\u00e1o c\u00e1o th\u1ee7 c\u00f4ng.<\/p>\n<p>Ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c: S\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 n\u00e0y gi\u00fap b\u1ea1n nhanh ch\u00f3ng t\u1ea1o b\u00e1o c\u00e1o v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u00e0 kh\u00f4ng c\u1ea7n vi\u1ebft c\u00e1c c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p ho\u1eb7c th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c tay.<\/p>\n<p>Nh\u1eefng \u01b0u \u0111i\u1ec3m n\u00e0y l\u00e0m c\u00f4ng c\u1ee5 n\u00e0y tr\u1edf th\u00e0nh m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd trong vi\u1ec7c qu\u1ea3n l\u00fd v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u, \u0111\u1eb7c bi\u1ec7t l\u00e0 trong c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u l\u1edbn v\u00e0 ph\u1ee9c t\u1ea1p.<\/p>\n<h2>Nh\u01b0\u1ee3c \u0111i\u1ec3m c\u1ee7a Pivot table<\/h2>\n<p>M\u1eb7c d\u00f9 c\u00f4ng v\u1ee5 n\u00e0y c\u00f3 nhi\u1ec1u \u01b0u \u0111i\u1ec3m, nh\u01b0ng c\u0169ng c\u00f3 m\u1ed9t s\u1ed1 nh\u01b0\u1ee3c \u0111i\u1ec3m:<\/p>\n<p>Kh\u1ea3 n\u0103ng x\u1eed l\u00fd d\u1eef li\u1ec7u l\u1edbn: C\u00f4ng c\u1ee5 n\u00e0y c\u00f3 th\u1ec3 g\u1eb7p kh\u00f3 kh\u0103n khi ph\u1ea3i x\u1eed l\u00fd c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u r\u1ea5t l\u1edbn. N\u1ebfu b\u1ea1n c\u00f3 m\u1ed9t t\u1eadp d\u1eef li\u1ec7u qu\u00e1 l\u1edbn, vi\u1ec7c t\u1ea1o v\u00e0 c\u1eadp nh\u1eadt Pivot Table c\u00f3 th\u1ec3 tr\u1edf n\u00ean ch\u1eadm ch\u1ea1p ho\u1eb7c g\u00e2y c\u1ea3n tr\u1edf cho hi\u1ec7u su\u1ea5t.<\/p>\n<p>Y\u00eau c\u1ea7u ki\u1ebfn th\u1ee9c: \u0110\u1ec3 s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n c\u00f3 ki\u1ebfn th\u1ee9c v\u1ec1 c\u00e1ch t\u1ea1o v\u00e0 t\u00f9y ch\u1ec9nh. Vi\u1ec7c thi\u1ebfu ki\u1ebfn th\u1ee9c c\u00f3 th\u1ec3 d\u1eabn \u0111\u1ebfn vi\u1ec7c s\u1eed d\u1ee5ng kh\u00f4ng hi\u1ec7u qu\u1ea3 ho\u1eb7c t\u1ea1o ra k\u1ebft qu\u1ea3 sai l\u1ec7ch.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-256215 size-full\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-4.jpg\" alt=\"Pivot-table-trong-excel-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>Kh\u00f3 trong vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u kh\u00f4ng \u0111\u1ed3ng \u0111\u1ec1u: N\u1ebfu d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n kh\u00f4ng \u0111\u1ed3ng \u0111\u1ec1u ho\u1eb7c ch\u1ee9a nhi\u1ec1u gi\u00e1 tr\u1ecb b\u1ecb thi\u1ebfu, vi\u1ec7c x\u1eed l\u00fd ch\u00fang c\u00f3 th\u1ec3 tr\u1edf n\u00ean ph\u1ee9c t\u1ea1p v\u00e0 \u0111\u00f2i h\u1ecfi nhi\u1ec1u c\u00f4ng vi\u1ec7c ti\u1ec1n x\u1eed l\u00fd tr\u01b0\u1edbc.<\/p>\n<p>Kh\u00f3 kh\u0103n trong vi\u1ec7c th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh ph\u1ee9c t\u1ea1p: H\u1ed7 tr\u1ee3 nhi\u1ec1u ph\u00e9p t\u00ednh c\u01a1 b\u1ea3n, nh\u01b0ng vi\u1ec7c th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh ph\u1ee9c t\u1ea1p h\u01a1n s\u1ebd g\u1eb7p kh\u00f3 kh\u0103n.<\/p>\n<p>M\u1eb7c d\u00f9 c\u00f3 nh\u01b0\u1ee3c \u0111i\u1ec3m nh\u01b0 tr\u00ean nh\u01b0ng \u0111\u00e2y v\u1eabn l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd v\u00e0 h\u1eefu \u00edch trong vi\u1ec7c t\u1ed5ng h\u1ee3p v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p.<\/p>\n<h2>C\u00e1ch s\u1eed d\u1ee5ng b\u1ea3ng Pivot table trong Excel chi ti\u1ebft<\/h2>\n<p>C\u00f4ng c\u1ee5 n\u00e0y kh\u00f4ng ch\u1ec9 gi\u00fap b\u1ea1n t\u1ed5 ch\u1ee9c v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 m\u00e0 c\u00f2n bi\u1ebfn d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p th\u00e0nh th\u00f4ng tin c\u00f3 \u00fd ngh\u0129a v\u00e0 d\u1ec5 \u0111\u1ecdc. C\u00f9ng t\u00ecm hi\u1ec3u ngay c\u00e1ch s\u1eed d\u1ee5ng b\u1ea3ng t\u1ed5ng h\u1ee3p n\u00e0y nh\u00e9!<\/p>\n<h3>C\u00e1ch s\u1eed d\u1ee5ng b\u1ea3ng Pivot table trong Excel \u0111\u1ec3 th\u1ed1ng k\u00ea d\u1eef li\u1ec7u<\/h3>\n<p>T\u1ea1o v\u00e0 t\u00f9y ch\u1ec9nh b\u1ea3ng t\u1ed5ng h\u1ee3p \u0111\u00f2i h\u1ecfi b\u1ea1n ph\u1ea3i c\u00f3 d\u1eef li\u1ec7u ban \u0111\u1ea7u. B\u1ea1n c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda, th\u00eam ho\u1eb7c x\u00f3a d\u1eef li\u1ec7u trong v\u00f9ng d\u1eef li\u1ec7u g\u1ed1c, tuy nhi\u00ean, c\u00f4ng c\u1ee5 n\u00e0y kh\u00f4ng t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt, v\u00e0 b\u1ea1n ph\u1ea3i th\u1ee7 c\u00f4ng c\u1eadp nh\u1eadt b\u1eb1ng l\u1ec7nh Refresh.<\/p>\n<p>B\u01b0\u1edbc 1: Trong tab Insert tr\u00ean thanh c\u00f4ng c\u1ee5, b\u1ea1n ch\u1ecdn Pivot Table.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-256216 size-full\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-5.jpg\" alt=\"Pivot-table-trong-excel-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>B\u01b0\u1edbc 2: M\u1ed9t h\u1ed9p tho\u1ea1i Pivot Table xu\u1ea5t hi\u1ec7n:<\/p>\n<ul>\n<li>T\u1ea1i v\u00f9ng Select a table or range: \u0110\u00e2y l\u00e0 v\u00f9ng m\u00e0 b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng Pivot.<\/li>\n<li>T\u1ea1i Choose where you want the PivotTable to be placed ch\u1ecdn:\n<ul>\n<li>New Worksheet: \u0110\u1ec3 \u1ee9ng d\u1ee5ng b\u1ea3ng trong m\u1ed9t sheet m\u1edbi.<\/li>\n<li>Existing Worksheet: T\u00f9y ch\u1ecdn n\u00e0y gi\u00fap b\u1ea1n \u0111\u1eb7t v\u1ecb tr\u00ed b\u1ea3ng t\u1ed5ng h\u1ee3p theo nhu c\u1ea7u. Cu\u1ed1i c\u00f9ng, b\u1ea1n nh\u1ea5n OK.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-256217\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-6.jpg\" alt=\"Pivot-table-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>B\u01b0\u1edbc 3: L\u00fac n\u00e0y b\u1ea3ng t\u1ed5ng h\u1ee3p s\u1ebd xu\u1ea5t hi\u1ec7n t\u1ea1i v\u1ecb tr\u00ed b\u1ea1n \u0111\u00e3 ch\u1ecdn ho\u1eb7c tr\u00ean m\u1ed9t sheet m\u1edbi.<\/p>\n<p>\u1ede ph\u00eda d\u01b0\u1edbi, b\u1ea1n c\u00f3 th\u1ec3 k\u00e9o c\u00e1c tr\u01b0\u1eddng d\u1eef li\u1ec7u v\u00e0o c\u00e1c \u00f4 \u0111\u1ec3 t\u1ea1o c\u1ea5u tr\u00fac:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-256218\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-7.jpg\" alt=\"Pivot-table-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<ul>\n<li>Filters: L\u00e0 b\u1ed9 l\u1ecdc \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u.<\/li>\n<li>Columns: Hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u d\u1ea1ng c\u1ed9t.<\/li>\n<li>Rows: hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u theo h\u00e0ng.<\/li>\n<li>Values: \u0111\u1ec3 hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb t\u00ednh to\u00e1n t\u1eeb tr\u01b0\u1eddng d\u1eef li\u1ec7u.<\/li>\n<\/ul>\n<p>B\u01b0\u1edbc 4: T\u00f9y ch\u1ec9nh b\u1ea3ng theo c\u00e1ch b\u1ea1n mu\u1ed1n \u0111\u1ec3 t\u1ed5ng h\u1ee3p v\u00e0 th\u1ed1ng k\u00ea d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-256219\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-8.jpg\" alt=\"Pivot-table-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>B\u01b0\u1edbc 5: \u0110\u1ec3 \u0111i\u1ec1u ch\u1ec9nh hi\u1ec3n th\u1ecb, b\u1ea1n c\u00f3 th\u1ec3 v\u00e0o th\u1ebb PivotTable Analyze v\u00e0 ch\u1ecdn Options. M\u1ed9t h\u1ed9p tho\u1ea1i PivotTable Options s\u1ebd xu\u1ea5t hi\u1ec7n, cho ph\u00e9p b\u1ea1n t\u00f9y ch\u1ec9nh c\u00e1c thi\u1ebft l\u1eadp nh\u01b0: Layout &amp; Format, Totals &amp; Filters, Display, Printing, Data, v\u00e0 Alt Text.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-256220\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-9.jpg\" alt=\"Pivot-table-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>B\u01b0\u1edbc 6: B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 thay \u0111\u1ed5i c\u00e1ch t\u00ednh to\u00e1n gi\u00e1 tr\u1ecb b\u1eb1ng c\u00e1ch trong \u00f4 Values, nh\u1ea5n v\u00e0o tr\u01b0\u1eddng d\u1eef li\u1ec7u v\u00e0 ch\u1ecdn Value Field Setting.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-256222\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-11.jpg\" alt=\"Pivot-table-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-256223\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-12.jpg\" alt=\"Pivot-table-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<h3>H\u01b0\u1edbng d\u1eabn x\u00f3a b\u1ea3ng Pivot table trong Excel<\/h3>\n<p>C\u00f3 hai c\u00e1ch \u0111\u1ec3 x\u00f3a m\u1ed9t b\u1ea3ng b\u1ea3ng t\u1ed5ng h\u1ee3p n\u00e0y trong Excel:<\/p>\n<p>C\u00e1ch 1: X\u00f3a to\u00e0n b\u1ed9 d\u00f2ng, c\u1ed9t.<\/p>\n<ul>\n<li>Ch\u1ecdn t\u1ea5t c\u1ea3 h\u00e0ng v\u00e0 c\u1ed9t b\u1eb1ng c\u00e1ch b\u00f4i \u0111en to\u00e0n b\u1ed9 b\u1ea3ng.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-256225\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-14.jpg\" alt=\"Pivot-table-14\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-14.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-14-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-14-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<ul>\n<li>Click chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn &#8220;Delete&#8221; \u0111\u1ec3 x\u00f3a to\u00e0n b\u1ed9 b\u1ea3ng n\u00e0y.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-256224\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-13.jpg\" alt=\"Pivot-table-13\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-13-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-13-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>L\u01b0u \u00fd r\u1eb1ng c\u00e1ch n\u00e0y s\u1ebd x\u00f3a t\u1ea5t c\u1ea3 c\u00e1c d\u1eef li\u1ec7u b\u00ean ngo\u00e0i b\u1ea3ng c\u00f9ng v\u1edbi n\u00f3. V\u00ec v\u1eady, tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n thao t\u00e1c n\u00e0y, b\u1ea1n n\u00ean \u0111\u1ea3m b\u1ea3o r\u1eb1ng kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u quan tr\u1ecdng n\u00e0o kh\u00e1c tr\u00ean c\u00f9ng m\u1ed9t d\u00f2ng ho\u1eb7c c\u1ed9t v\u1edbi b\u1ea3ng.<\/p>\n<p>C\u00e1ch 2: X\u00f3a b\u1eb1ng c\u00e1ch ch\u1ecdn b\u1ea3ng.<\/p>\n<p>\u0110\u00e2y l\u00e0 c\u00e1ch an to\u00e0n h\u01a1n \u0111\u1ec3 x\u00f3a b\u1ea3ng t\u1ed5ng h\u1ee3p n\u00e0y m\u00e0 kh\u00f4ng l\u00e0m m\u1ea5t c\u00e1c d\u1eef li\u1ec7u b\u00ean ngo\u00e0i.<\/p>\n<ul>\n<li>Click v\u00e0o m\u1ed9t v\u1ecb tr\u00ed b\u1ea5t k\u1ef3 trong b\u1ea3ng.<\/li>\n<li>Tr\u00ean tab &#8220;PivotTable Tools&#8221; ho\u1eb7c &#8220;Analyze,&#8221; b\u1ea1n ch\u1ecdn &#8220;Select&#8221;\u00a0 v\u00e0 sau \u0111\u00f3 nh\u1ea5p v\u00e0o &#8220;Entire PivotTable.&#8221;<\/li>\n<li>Cu\u1ed1i c\u00f9ng, b\u1ea1n nh\u1ea5n n\u00fat &#8220;Delete&#8221; tr\u00ean b\u00e0n ph\u00edm \u0111\u1ec3 x\u00f3a to\u00e0n b\u1ed9 b\u1ea3ng n\u00e0y.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-256226\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-15.jpg\" alt=\"Pivot-table-15\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-15.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-15-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-15-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>C\u00e1ch th\u1ee9 2 \u0111\u1ea3m b\u1ea3o r\u1eb1ng ch\u1ec9 c\u00f3 Pivot Table b\u1ecb x\u00f3a, kh\u00f4ng \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn d\u1eef li\u1ec7u kh\u00e1c trong b\u1ea3ng Excel c\u1ee7a b\u1ea1n.<\/p>\n<h2>L\u01b0u \u00fd khi s\u1eed d\u1ee5ng<\/h2>\n<p>Pivot Table kh\u00f4ng ch\u1ec9 \u0111\u01a1n gi\u1ea3n l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u m\u00e0 c\u00f2n \u0111\u00f2i h\u1ecfi s\u1ef1 hi\u1ec3u bi\u1ebft v\u00e0 tu\u00e2n th\u1ee7 c\u00e1c quy t\u1eafc v\u00e0 l\u01b0u \u00fd c\u1ee5 th\u1ec3 \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o b\u1ea1n s\u1eed d\u1ee5ng n\u00f3 m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 v\u00e0 ch\u00ednh x\u00e1c. Khi s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 n\u00e0y, c\u00f3 m\u1ed9t s\u1ed1 l\u01b0u \u00fd quan tr\u1ecdng b\u1ea1n n\u00ean c\u00e2n nh\u1eafc nh\u01b0:<\/p>\n<ul>\n<li>Ch\u1ecdn d\u1eef li\u1ec7u ngu\u1ed3n ch\u00ednh x\u00e1c: \u0110\u1ea3m b\u1ea3o b\u1ea1n \u0111\u00e3 ch\u1ecdn b\u1ea3ng d\u1eef li\u1ec7u ngu\u1ed3n ch\u00ednh x\u00e1c \u0111\u1ec3 t\u1ea1o. N\u1ebfu d\u1eef li\u1ec7u ngu\u1ed3n kh\u00f4ng \u0111\u00fang, k\u1ebft qu\u1ea3 s\u1ebd b\u1ecb sai l\u1ec7ch.<\/li>\n<li>S\u1eafp x\u1ebfp v\u00e0 l\u1ecdc d\u1eef li\u1ec7u tr\u01b0\u1edbc: Tr\u01b0\u1edbc khi t\u1ea1o b\u1ea3ng n\u00e0y, b\u1ea1n n\u00ean s\u1eafp x\u1ebfp v\u00e0 l\u1ecdc d\u1eef li\u1ec7u ngu\u1ed3n \u0111\u1ec3 lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u kh\u00f4ng c\u1ea7n thi\u1ebft v\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp \u0111\u00fang th\u1ee9 t\u1ef1.<\/li>\n<li>X\u00e1c \u0111\u1ecbnh m\u1ee5c ti\u00eau tr\u01b0\u1edbc: Tr\u01b0\u1edbc khi b\u1eaft \u0111\u1ea7u, x\u00e1c \u0111\u1ecbnh m\u1ee5c ti\u00eau c\u1ee7a b\u1ea1n cho Pivot Table. \u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea1n x\u00e1c \u0111\u1ecbnh nh\u1eefng tr\u01b0\u1eddng d\u1eef li\u1ec7u c\u1ea7n t\u1ed5ng h\u1ee3p v\u00e0 ph\u00e2n t\u00edch.<\/li>\n<li>Ch\u1ecdn \u0111\u00fang h\u00e0m: Ch\u1ecdn c\u00e1c h\u00e0m t\u00ednh to\u00e1n ph\u00f9 h\u1ee3p v\u1edbi m\u1ee5c ti\u00eau c\u1ee7a b\u1ea1n. S\u1eed d\u1ee5ng SUM cho t\u1ed5ng h\u1ee3p, AVERAGE cho gi\u00e1 tr\u1ecb trung b\u00ecnh, v\u00e0 MAX\/MIN cho gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t\/nh\u1ecf nh\u1ea5t.<\/li>\n<li>S\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u ph\u00f9 h\u1ee3p: B\u1ea1n c\u1ea7n x\u00e1c \u0111\u1ecbnh xem d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n l\u00e0 d\u1ea1ng s\u1ed1 h\u1ecdc, v\u0103n b\u1ea3n, ng\u00e0y th\u00e1ng, ho\u1eb7c c\u00e1c lo\u1ea1i d\u1eef li\u1ec7u kh\u00e1c \u0111\u1ec3 \u00e1p d\u1ee5ng c\u00e1c h\u00e0m t\u00ednh to\u00e1n v\u00e0 hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u \u0111\u00fang c\u00e1ch.<\/li>\n<li>S\u1eed d\u1ee5ng l\u1ecdc v\u00e0 s\u1eafp x\u1ebfp: S\u1eed d\u1ee5ng c\u00e1c t\u00ednh n\u0103ng l\u1ecdc v\u00e0 s\u1eafp x\u1ebfp trong \u0111\u1ec3 xem d\u1eef li\u1ec7u theo nhi\u1ec1u g\u00f3c \u0111\u1ed9 kh\u00e1c nhau v\u00e0 nhanh ch\u00f3ng t\u00ecm th\u1ea5y th\u00f4ng tin quan tr\u1ecdng.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-256227\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-16.jpg\" alt=\"Pivot-table-16\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-16.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-16-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-16-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<h2>K\u1ebft lu\u1eadn<\/h2>\n<p>Pivot Table l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd v\u00e0 linh ho\u1ea1t trong Excel, gi\u00fap b\u1ea1n th\u1ec3 hi\u1ec7n s\u1ef1 s\u1eafp x\u1ebfp v\u00e0 t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng v\u00e0 nhanh ch\u00f3ng. Hy v\u1ecdng th\u00f4ng qua b\u00e0i chia s\u1ebb b\u00ean tr\u00ean b\u1ea1n c\u00f3 th\u1ec3 c\u00f3 th\u1ec3 hi\u1ec3u v\u00e0 s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 n\u00e0y m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng.<\/p>\n<p>Tham kh\u1ea3o th\u00eam:<\/p>\n<ul>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-ve-bieu-do-tron-trong-excel-don-gian-de-hieu\/\">C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 tr\u00f2n trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 hi\u1ec3u<\/a><\/strong><\/li>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-5-cach-loc-trong-excel-de-dang-dan-van-phong-khong-the-bo-qua\/\">H\u01b0\u1edbng d\u1eabn 5 c\u00e1ch l\u1ecdc trong excel d\u1ec5 d\u00e0ng d\u00e2n v\u0103n ph\u00f2ng kh\u00f4ng th\u1ec3 b\u1ecf qua<\/a><\/strong><\/li>\n<\/ul>\n<p>Ho\u1eb7c theo d\u00f5i <strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/\">Ho\u00e0ng H\u00e0<\/a><\/strong> \u0111\u1ec3 c\u1eadp nh\u1eadt nh\u1eefng tin t\u1ee9c n\u00f3ng n\u1ed5i nh\u1ea5t!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pivot Table kh\u00f4ng ch\u1ec9 l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 ph\u00e2n t\u00edch m\u1ea1nh m\u1ebd trong Excel m\u00e0 c\u00f2n l\u00e0 m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n v\u00e0 hi\u1ec7u qu\u1ea3 \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p. V\u1edbi kh\u1ea3 n\u0103ng t\u1ed5ng h\u1ee3p, s\u1eafp x\u1ebfp, v\u00e0 t\u00ednh to\u00e1n d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch nhanh ch\u00f3ng, c\u00f4ng c\u1ee5 n\u00e0y \u0111\u00e3 tr\u1edf th\u00e0nh m\u1ed9t tr\u1ee3 [&hellip;]<\/p>\n","protected":false},"author":85,"featured_media":256233,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16],"tags":[],"class_list":["post-256132","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.3 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Pivot table l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng Pivot Table trong Excel<\/title>\n<meta name=\"description\" content=\"Pivot Table l\u00e0 m\u1ed9t t\u00ednh n\u0103ng trong c\u00e1c ph\u1ea7n m\u1ec1m b\u1ea3ng t\u00ednh nh\u01b0 Excel cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng t\u1ed5ng h\u1ee3p v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/pivot-table\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pivot Table l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng Pivot Table trong Excel\" \/>\n<meta property=\"og:description\" content=\"Pivot Table l\u00e0 m\u1ed9t t\u00ednh n\u0103ng trong c\u00e1c ph\u1ea7n m\u1ec1m b\u1ea3ng t\u00ednh nh\u01b0 Excel cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng t\u1ed5ng h\u1ee3p v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/pivot-table\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2023-09-13T12:20:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-trong-excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Nguy\u1ec5n Th\u1ecb Trang\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nguy\u1ec5n Th\u1ecb Trang\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/pivot-table\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/pivot-table\\\/\"},\"author\":{\"name\":\"Nguy\u1ec5n Th\u1ecb Trang\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#\\\/schema\\\/person\\\/21d5b8137dd43e6020b64eafef83fca5\"},\"headline\":\"Pivot Table l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng Pivot Table trong Excel\",\"datePublished\":\"2023-09-13T12:20:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/pivot-table\\\/\"},\"wordCount\":3141,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/pivot-table\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2023\\\/09\\\/Pivot-table-trong-excel.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/pivot-table\\\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/pivot-table\\\/\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/pivot-table\\\/\",\"name\":\"Pivot table l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng Pivot Table trong Excel\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/pivot-table\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/pivot-table\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2023\\\/09\\\/Pivot-table-trong-excel.jpg\",\"datePublished\":\"2023-09-13T12:20:16+00:00\",\"description\":\"Pivot Table l\u00e0 m\u1ed9t t\u00ednh n\u0103ng trong c\u00e1c ph\u1ea7n m\u1ec1m b\u1ea3ng t\u00ednh nh\u01b0 Excel cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng t\u1ed5ng h\u1ee3p v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/pivot-table\\\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/pivot-table\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/pivot-table\\\/#primaryimage\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2023\\\/09\\\/Pivot-table-trong-excel.jpg\",\"contentUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2023\\\/09\\\/Pivot-table-trong-excel.jpg\",\"width\":1200,\"height\":628,\"caption\":\"Pivot-table-trong-excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/pivot-table\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Th\u1ee7 thu\u1eadt\",\"item\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/category\\\/thu-thuat\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Pivot Table l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng Pivot Table trong Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#website\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2021\\\/12\\\/logo-text.png\",\"contentUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2021\\\/12\\\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#\\\/schema\\\/person\\\/21d5b8137dd43e6020b64eafef83fca5\",\"name\":\"Nguy\u1ec5n Th\u1ecb Trang\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b40eea6081e2720646b447d80a7f82e82251c1a6c83dd3533653175a123e6f53?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b40eea6081e2720646b447d80a7f82e82251c1a6c83dd3533653175a123e6f53?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b40eea6081e2720646b447d80a7f82e82251c1a6c83dd3533653175a123e6f53?s=96&d=mm&r=g\",\"caption\":\"Nguy\u1ec5n Th\u1ecb Trang\"},\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/author\\\/nguyen-trang\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Pivot table l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng Pivot Table trong Excel","description":"Pivot Table l\u00e0 m\u1ed9t t\u00ednh n\u0103ng trong c\u00e1c ph\u1ea7n m\u1ec1m b\u1ea3ng t\u00ednh nh\u01b0 Excel cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng t\u1ed5ng h\u1ee3p v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/pivot-table\/","og_locale":"vi_VN","og_type":"article","og_title":"Pivot Table l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng Pivot Table trong Excel","og_description":"Pivot Table l\u00e0 m\u1ed9t t\u00ednh n\u0103ng trong c\u00e1c ph\u1ea7n m\u1ec1m b\u1ea3ng t\u00ednh nh\u01b0 Excel cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng t\u1ed5ng h\u1ee3p v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/pivot-table\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-09-13T12:20:16+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-trong-excel.jpg","type":"image\/jpeg"}],"author":"Nguy\u1ec5n Th\u1ecb Trang","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Nguy\u1ec5n Th\u1ecb Trang","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"14 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/pivot-table\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/pivot-table\/"},"author":{"name":"Nguy\u1ec5n Th\u1ecb Trang","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/21d5b8137dd43e6020b64eafef83fca5"},"headline":"Pivot Table l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng Pivot Table trong Excel","datePublished":"2023-09-13T12:20:16+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/pivot-table\/"},"wordCount":3141,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/pivot-table\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-trong-excel.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/pivot-table\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/pivot-table\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/pivot-table\/","name":"Pivot table l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng Pivot Table trong Excel","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/pivot-table\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/pivot-table\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-trong-excel.jpg","datePublished":"2023-09-13T12:20:16+00:00","description":"Pivot Table l\u00e0 m\u1ed9t t\u00ednh n\u0103ng trong c\u00e1c ph\u1ea7n m\u1ec1m b\u1ea3ng t\u00ednh nh\u01b0 Excel cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng t\u1ed5ng h\u1ee3p v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/pivot-table\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/pivot-table\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/pivot-table\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-trong-excel.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/Pivot-table-trong-excel.jpg","width":1200,"height":628,"caption":"Pivot-table-trong-excel"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/pivot-table\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Th\u1ee7 thu\u1eadt","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/"},{"@type":"ListItem","position":3,"name":"Pivot Table l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng Pivot Table trong Excel"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/21d5b8137dd43e6020b64eafef83fca5","name":"Nguy\u1ec5n Th\u1ecb Trang","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/secure.gravatar.com\/avatar\/b40eea6081e2720646b447d80a7f82e82251c1a6c83dd3533653175a123e6f53?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b40eea6081e2720646b447d80a7f82e82251c1a6c83dd3533653175a123e6f53?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b40eea6081e2720646b447d80a7f82e82251c1a6c83dd3533653175a123e6f53?s=96&d=mm&r=g","caption":"Nguy\u1ec5n Th\u1ecb Trang"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-trang\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/256132","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/85"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=256132"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/256132\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/256233"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=256132"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=256132"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=256132"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}