{"id":6515,"date":"2024-12-21T15:28:30","date_gmt":"2024-12-21T15:28:30","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-lap-bao-cao-theo-thang-bang-pivot-table-khi-du-lieu-khong-co-san-cot-thang\/"},"modified":"2024-12-21T15:28:30","modified_gmt":"2024-12-21T15:28:30","slug":"cach-lap-bao-cao-theo-thang-bang-pivot-table-khi-du-lieu-khong-co-san-cot-thang","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-lap-bao-cao-theo-thang-bang-pivot-table-khi-du-lieu-khong-co-san-cot-thang\/","title":{"rendered":"C\u00e1ch l\u1eadp b\u00e1o c\u00e1o theo th\u00e1ng b\u1eb1ng pivot table khi d\u1eef li\u1ec7u kh\u00f4ng c\u00f3 s\u1eb5n c\u1ed9t th\u00e1ng"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Pivot table l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 r\u1ea5t h\u1eefu \u00edch trong vi\u1ec7c l\u1eadp b\u00e1o c\u00e1o. N\u00f3 gi\u00fap ch\u00fang ta c\u00f3 th\u1ec3 t\u1ea1o ra b\u00e1o c\u00e1o m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng, nhanh ch\u00f3ng\u00a0v\u00e0 kh\u00f4ng c\u1ea7n d\u00f9ng t\u1edbi c\u00f4ng th\u1ee9c. Nh\u01b0ng trong tr\u01b0\u1eddng\u00a0c\u1ea7n l\u1eadp b\u00e1o c\u00e1o theo th\u1eddi gian th\u00ec c\u00f3 m\u1ed9t v\u00e0i h\u1ea1n ch\u1ebf, \u0111\u00f3 l\u00e0 c\u01a1 ch\u1ebf l\u1ecdc d\u1eef li\u1ec7u theo th\u1eddi gian c\u1ee7a pivot table. Trong b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1ch l\u1eadp b\u00e1o c\u00e1o theo th\u00e1ng b\u1eb1ng pivot table khi d\u1eef li\u1ec7u kh\u00f4ng c\u00f3 s\u1eb5n c\u1ed9t th\u00e1ng.<\/p>\n<p>V\u00ed d\u1ee5 ch\u00fang ta c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20237\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data-pivot-table-ngan-hang-2.png\" width=\"812\" height=\"326\" title=\"data-pivot-table-ngan-hang-2\"><\/p>\n<p>Trong b\u1ea3ng d\u1eef li\u1ec7u n\u00e0y ch\u00fang ta ch\u1ec9 c\u00f3 1 d\u1eef li\u1ec7u li\u00ean quan t\u1edbi th\u1eddi gian l\u00e0 c\u1ed9t Ng\u00e0y (C\u1ed9t A)<\/p>\n<p>Nh\u01b0ng b\u1ea1n s\u1ebd l\u00e0m th\u1ebf n\u00e0o v\u1edbi y\u00eau c\u1ea7u l\u1eadp b\u00e1o c\u00e1o b\u1eb1ng pivot table cho s\u1ed1 ti\u1ec1n c\u1ee7a t\u1eebng chi nh\u00e1nh theo c\u00e1c ch\u01b0\u01a1ng tr\u00ecnh ti\u1ebft ki\u1ec7m v\u00e0 vay v\u1ed1n trong th\u00e1ng 7?<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6766de9dafaa4\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-lap-bao-cao-theo-thang-bang-pivot-table-khi-du-lieu-khong-co-san-cot-thang.html#Lap_bao_cao_bang_Pivot_table\" title=\"L\u1eadp b\u00e1o c\u00e1o b\u1eb1ng Pivot table\">L\u1eadp b\u00e1o c\u00e1o b\u1eb1ng Pivot table<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-lap-bao-cao-theo-thang-bang-pivot-table-khi-du-lieu-khong-co-san-cot-thang.html#Phan_tich_yeu_cau_lap_bao_cao\" title=\"Ph\u00e2n t\u00edch y\u00eau c\u1ea7u l\u1eadp b\u00e1o c\u00e1o\">Ph\u00e2n t\u00edch y\u00eau c\u1ea7u l\u1eadp b\u00e1o c\u00e1o<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-lap-bao-cao-theo-thang-bang-pivot-table-khi-du-lieu-khong-co-san-cot-thang.html#Cach_tao_truong_du_lieu_Thang_tu_truong_du_lieu_Ngay\" title=\"C\u00e1ch t\u1ea1o tr\u01b0\u1eddng d\u1eef li\u1ec7u Th\u00e1ng t\u1eeb tr\u01b0\u1eddng d\u1eef li\u1ec7u Ng\u00e0y\">C\u00e1ch t\u1ea1o tr\u01b0\u1eddng d\u1eef li\u1ec7u Th\u00e1ng t\u1eeb tr\u01b0\u1eddng d\u1eef li\u1ec7u Ng\u00e0y<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Lap_bao_cao_bang_Pivot_table\"><\/span>L\u1eadp b\u00e1o c\u00e1o b\u1eb1ng Pivot table<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tr\u01b0\u1edbc h\u1ebft ch\u00fang ta h\u00e3y c\u00f9ng l\u1eadp b\u00e1o c\u00e1o t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u tr\u00ean b\u1eb1ng c\u00f4ng c\u1ee5 Pivot table. C\u00e1ch th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<ul>\n<li>Ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng d\u1eef li\u1ec7u. V\u00ed d\u1ee5 b\u1ea3ng d\u1eef li\u1ec7u n\u1eb1m \u1edf Sheet1, v\u00f9ng A1:F198<\/li>\n<li>Trong th\u1ebb Insert ch\u1ecdn Pivot table. Khi m\u1edf ra c\u1eeda s\u1ed5 PivotTable th\u00ec v\u00f9ng b\u1ea3ng d\u1eef li\u1ec7u n\u1eb1m \u1edf m\u1ee5c Table\/Range<\/li>\n<li>L\u1ef1a ch\u1ecdn \u0111\u1eb7t v\u1ecb tr\u00ed pivot table. Trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y ch\u00fang ta s\u1ebd \u0111\u1eb7t Pivot table t\u1ea1i 1 sheet m\u1edbi (m\u1ee5c Choose where you want\u2026 placed ch\u1ecdn <strong>New Worksheet<\/strong>)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20238\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/create-pivot-table-01.png\" width=\"1379\" height=\"575\" title=\"create-pivot-table-01\"><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-584.gif\" title=\"ex101_92019-nho-584\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Sau khi l\u00e0m xong c\u00e1c b\u01b0\u1edbc tr\u00ean v\u00e0 b\u1ea5m OK th\u00ec ch\u00fang ta s\u1ebd c\u00f3 1 sheet m\u1edbi k\u00e8m theo giao di\u1ec7n kh\u1edfi t\u1ea1o Pivot table nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20240\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pivot-table-layout-01.png\" width=\"698\" height=\"481\" title=\"pivot-table-layout-01\"><\/p>\n<p><strong>Ph\u1ea7n b\u00ean tr\u00e1i<\/strong>: V\u00f9ng s\u1ebd hi\u1ec3n th\u1ecb c\u00e1c n\u1ed9i dung k\u1ebft qu\u1ea3 c\u1ee7a b\u00e1o c\u00e1o Pivot table<\/p>\n<p><strong>Ph\u1ea7n b\u00ean ph\u1ea3i<\/strong>: C\u00e1c tr\u01b0\u1eddng d\u1eef li\u1ec7u v\u00e0 v\u1ecb tr\u00ed c\u00e1c v\u00f9ng \u0111\u1eb7t c\u00e1c tr\u01b0\u1eddng d\u1eef li\u1ec7u theo b\u1ed1 c\u1ee5c.<\/p>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoi-dau-voi-pivot-table-trong-excel.html\">Kh\u1edfi \u0111\u1ea7u v\u1edbi Pivot Table trong Excel<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Phan_tich_yeu_cau_lap_bao_cao\"><\/span>Ph\u00e2n t\u00edch y\u00eau c\u1ea7u l\u1eadp b\u00e1o c\u00e1o<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 bi\u1ebft c\u00e1c tr\u01b0\u1eddng d\u1eef li\u1ec7u s\u1ebd \u0111\u1eb7t t\u1ea1i c\u00e1c v\u1ecb tr\u00ed n\u00e0o trong b\u00e1o c\u00e1o Pivot table th\u00ec ch\u00fang ta c\u1ea7n ph\u1ea3i ph\u00e2n t\u00edch y\u00eau c\u1ea7u l\u1eadp b\u00e1o c\u00e1o. \u0110\u00e2y l\u00e0 vi\u1ec7c r\u1ea5t quan tr\u1ecdng gi\u00fap ch\u00fang ta c\u00f3 th\u1ec3 h\u00ecnh th\u00e0nh \u0111\u01b0\u1ee3c 1 b\u00e1o c\u00e1o \u0111\u00fang, \u0111\u1eb9p v\u00e0 khoa h\u1ecdc.<\/p>\n<p>Y\u00eau c\u1ea7u l\u1eadp b\u00e1o c\u00e1o: cho <strong>s\u1ed1 ti\u1ec1n<\/strong> c\u1ee7a <strong>t\u1eebng chi nh\u00e1nh<\/strong> theo<strong> c\u00e1c ch\u01b0\u01a1ng tr\u00ecnh<\/strong> ti\u1ebft ki\u1ec7m v\u00e0 vay v\u1ed1n trong <strong>th\u00e1ng 7<\/strong><\/p>\n<p>Nh\u01b0 v\u1eady trong y\u00eau c\u1ea7u n\u00e0y c\u00f3 li\u00ean quan t\u1edbi c\u00e1c tr\u01b0\u1eddng d\u1eef li\u1ec7u (ph\u1ea7n t\u00f4 \u0111\u1eadm):<\/p>\n<ul>\n<li><strong>C\u1ed9t s\u1ed1 ti\u1ec1n<\/strong>: \u0111\u00e2y s\u1ebd l\u00e0 k\u1ebft qu\u1ea3 c\u1ea7n t\u00ednh \u0111\u01b0\u1ee3c c\u1ee7a b\u00e1o c\u00e1o. C\u1ed9t n\u00e0y s\u1ebd n\u1eb1m trong m\u1ee5c <strong>Values<\/strong> c\u1ee7a Pivot table<\/li>\n<li><strong>C\u1ed9t chi nh\u00e1nh<\/strong>: \u0111\u1ec3 b\u00e1o c\u00e1o cho t\u1eebng chi nh\u00e1nh th\u00ec ch\u00fang ta ph\u1ea3i s\u1eed d\u1ee5ng t\u1edbi tr\u01b0\u1eddng (c\u1ed9t) chi nh\u00e1nh. \u0110\u00e2y l\u00e0 \u0111\u1ed1i t\u01b0\u1ee3ng ch\u00ednh c\u1ee7a b\u00e1o c\u00e1o n\u00ean s\u1ebd \u0111\u1eb7t t\u1ea1i m\u1ee5c <strong>Rows<\/strong> c\u1ee7a Pivot table<\/li>\n<li><strong>C\u1ed9t Ch\u01b0\u01a1ng tr\u00ecnh<\/strong>: c\u1ee5 th\u1ec3 \u1edf \u0111\u00e2y l\u00e0 2 ch\u01b0\u01a1ng tr\u00ecnh ti\u1ebft ki\u1ec7m v\u00e0 vay v\u1ed1n. Do \u0111\u00f3 \u0111\u00e2y c\u0169ng l\u00e0 \u0111\u1ed1i t\u01b0\u1ee3ng ch\u00ednh c\u1ee7a b\u00e1o c\u00e1o. \u0110\u1ed1i t\u01b0\u1ee3ng n\u00e0y \u0111\u1ed9c l\u1eadp v\u1edbi \u0111\u1ed1i t\u01b0\u1ee3ng Chi nh\u00e1nh, do \u0111\u00f3 s\u1ebd \u0111\u1eb7t trong m\u1ee5c <strong>Columns<\/strong> c\u1ee7a Pivot table<\/li>\n<li><strong>Th\u00e1ng 7<\/strong>: n\u1ed9i dung n\u00e0y li\u00ean quan t\u1edbi ng\u00e0y. C\u1ee5 th\u1ec3 l\u00e0 ch\u1ec9 l\u1ecdc theo nh\u1eefng ng\u00e0y trong th\u00e1ng 7. Do \u0111\u00f3 \u1edf \u0111\u00e2y m\u1ee5c ng\u00e0y s\u1ebd l\u00e0 \u0111\u1ed1i t\u01b0\u1ee3ng trong m\u1ee5c<strong> Filter<\/strong>, gi\u00fap l\u1ecdc d\u1eef li\u1ec7u. Nh\u01b0ng do tr\u01b0\u1eddng <strong>Th\u00e1ng<\/strong> kh\u00f4ng c\u00f3 s\u1eb5n trong b\u1ea3ng d\u1eef li\u1ec7u, ch\u1ec9 c\u00f3 tr\u01b0\u1eddng <strong>Ng\u00e0y<\/strong><\/li>\n<\/ul>\n<p>Th\u00f4ng th\u01b0\u1eddng ch\u00fang ta s\u1ebd l\u00e0m nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20243\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pivot-table-drag-fields.png\" width=\"866\" height=\"410\" title=\"pivot-table-drag-fields\"><\/p>\n<p>Khi \u0111\u00f3 \u0111\u1ec3 c\u00f3 th\u1ec3 l\u1ecdc d\u1eef li\u1ec7u Ng\u00e0y trong th\u00e1ng 7, ch\u00fang ta s\u1ebd b\u1ea5m l\u1ecdc \u1edf\u00a0v\u00f9ng Ng\u00e0y nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20244\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pivot-table-filter-fields-select.png\" width=\"317\" height=\"398\" title=\"pivot-table-filter-fields-select\"><\/p>\n<p>Nh\u01b0ng l\u00e0m nh\u01b0 v\u1eady th\u00ec r\u1ea5t m\u1ea5t c\u00f4ng, b\u1edfi nh\u01b0 v\u1eady ch\u00fang ta ph\u1ea3i ch\u1ecdn t\u1edbi 31 \u0111\u1ed1i t\u01b0\u1ee3ng ng\u00e0y trong th\u00e1ng 7. V\u00e0 n\u1ebfu y\u00eau c\u1ea7u b\u00e1o c\u00e1o thay \u0111\u1ed5i sang th\u00e1ng kh\u00e1c th\u00ec ph\u1ea3i l\u00e0m l\u1ea1i thao t\u00e1c ch\u1ecdn nhi\u1ec1u \u0111\u1ed1i t\u01b0\u1ee3ng n\u00e0y. Vi\u1ec7c n\u00e0y kh\u00f4ng \u0111\u1ea3m b\u1ea3o y\u00eau c\u1ea7u b\u00e1o c\u00e1o nhanh c\u1ee7a Pivot table. V\u1eady c\u00f3 c\u00e1ch n\u00e0o kh\u1eafc ph\u1ee5c v\u1ea5n \u0111\u1ec1 n\u00e0y?<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_tao_truong_du_lieu_Thang_tu_truong_du_lieu_Ngay\"><\/span>C\u00e1ch t\u1ea1o tr\u01b0\u1eddng d\u1eef li\u1ec7u Th\u00e1ng t\u1eeb tr\u01b0\u1eddng d\u1eef li\u1ec7u Ng\u00e0y<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00f3 m\u1ed9t th\u1ee7 thu\u1eadt nh\u1ecf gi\u00fap ch\u00fang ta c\u00f3 th\u1ec3 t\u1ef1 t\u1ea1o th\u00eam tr\u01b0\u1eddng d\u1eef li\u1ec7u Th\u00e1ng t\u1eeb tr\u01b0\u1eddng d\u1eef li\u1ec7u Ng\u00e0y, \u0111\u00f3 l\u00e0 vi\u1ec7c trong Pivot table c\u00f3 th\u1ec3 t\u1ef1 g\u1ed9p nh\u00f3m d\u1eef li\u1ec7u khi \u0111\u01b0a v\u00e0o m\u1ee5c Rows. D\u1ef1a v\u00e0o \u0111i\u1ec1u \u0111\u00f3 ch\u00fang ta s\u1ebd l\u00e0m nh\u01b0 sau:\u00a0K\u00e9o tr\u01b0\u1eddng d\u1eef li\u1ec7u Ng\u00e0y r\u1ed3i th\u1ea3 v\u00e0o m\u1ee5c Rows. Khi \u0111\u00f3 s\u1ebd t\u1ef1 \u0111\u1ed9ng sinh ra 2 tr\u01b0\u1eddng Ng\u00e0y v\u00e0 Months<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20245\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pivot-table-create-months-fields.png\" width=\"866\" height=\"581\" title=\"pivot-table-create-months-fields\"><\/p>\n<p>B\u00e2y gi\u1edd ch\u1ec9 vi\u1ec7c lo\u1ea1i b\u1ecf tr\u01b0\u1eddng d\u1eef li\u1ec7u Ng\u00e0y kh\u1ecfi Rows, v\u00e0 k\u00e9o tr\u01b0\u1eddng Months l\u00ean m\u1ee5c Filters. Trong Months ch\u00fang ta s\u1ebd b\u1ea5m n\u00fat l\u1ecdc v\u00e0 ch\u1ecdn th\u00e1ng 7<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20246\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pivot-table-select-months-fields.png\" width=\"916\" height=\"513\" title=\"pivot-table-select-months-fields\"><\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta \u0111\u00e3 thu \u0111\u01b0\u1ee3c b\u00e1o c\u00e1o ho\u00e0n ch\u1ec9nh theo y\u00eau c\u1ea7u \u0111\u1ec1 b\u00e0i r\u1ed3i:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20247\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pivot-table-ket-qua.png\" width=\"495\" height=\"242\" title=\"pivot-table-ket-qua\"><\/p>\n<p>N\u1ebfu y\u00eau c\u1ea7u b\u00e1o c\u00e1o cho th\u00e1ng kh\u00e1c, ch\u00fang ta ch\u1ec9 c\u1ea7n thay \u0111\u1ed5i vi\u1ec7c l\u1ecdc th\u00e1ng l\u00e0 \u0111\u01b0\u1ee3c.<\/p>\n<p>Qua b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta \u0111\u00e3 bi\u1ebft th\u00eam m\u1ed9t c\u00e1ch x\u1eed l\u00fd d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng trong Pivot table khi n\u00f3 c\u00f3 kh\u1ea3 n\u0103ng t\u1ef1 sinh ra c\u00e1c tr\u01b0\u1eddng d\u1eef li\u1ec7u nh\u01b0 Th\u00e1ng, Qu\u00fd, N\u0103m. D\u1ef1a v\u00e0o t\u00ednh n\u0103ng n\u00e0y vi\u1ec7c l\u1ecdc d\u1eef li\u1ec7u theo th\u1eddi gian trong Pivot Table kh\u00f4ng c\u00f2n kh\u00f3 kh\u0103n n\u1eefa.<\/p>\n<p>T\u1ea3i v\u1ec1 file m\u1eabu t\u1ea1i \u0111\u1ecba ch\u1ec9:\u00a0<a href=\"http:\/\/bit.ly\/2meQDOt\">http:\/\/bit.ly\/2meQDOt<\/a><\/p>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/cach-lap-bao-cao-ty-le-phan-tram-trong-excel-bang-pivot-table-don-gian-nhat.html\">C\u00e1ch l\u1eadp b\u00e1o c\u00e1o t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m trong excel b\u1eb1ng Pivot table \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/a><\/p>\n<p>Nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2usEfz9\">Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a> c\u1ee7a H\u1ecdc Excel Online. Trong kh\u00f3a h\u1ecdc c\u00e1c b\u1ea1n c\u00f2n h\u1ecdc th\u00eam \u0111\u01b0\u1ee3c nhi\u1ec1u ki\u1ebfn th\u1ee9c kh\u00e1c li\u00ean quan t\u1edbi c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 trong Excel \u0111\u1ec3 \u1ee9ng d\u1ee5ng v\u00e0o c\u00f4ng vi\u1ec7c \u0111\u01b0\u1ee3c t\u1ed1t h\u01a1n. Th\u00f4ng tin chi ti\u1ebft m\u1eddi b\u1ea1n b\u1ea5m v\u00e0o h\u00ecnh b\u00ean d\u01b0\u1edbi:<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-584.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6516,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-6515","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6515","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=6515"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6515\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6516"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6515"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6515"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6515"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}