{"id":7275,"date":"2024-12-21T17:13:46","date_gmt":"2024-12-21T17:13:46","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-tao-pivot-table-tu-nhieu-sheet-trong-excel\/"},"modified":"2024-12-21T17:13:46","modified_gmt":"2024-12-21T17:13:46","slug":"cach-tao-pivot-table-tu-nhieu-sheet-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-tao-pivot-table-tu-nhieu-sheet-trong-excel\/","title":{"rendered":"C\u00e1ch t\u1ea1o Pivot Table t\u1eeb nhi\u1ec1u sheet trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-h4k0Fa0I#1\">\n<p><em>Trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p th\u1ef1c t\u1ebf, ch\u00fang ta c\u00f3 th\u1ec3 l\u01b0u d\u1eef li\u1ec7u trong c\u00f9ng 1 file Excel nh\u01b0ng trong nhi\u1ec1u b\u1ea3ng t\u00ednh (sheet) kh\u00e1c nhau. Ch\u00fang ta c\u00f3 th\u1ec3 l\u01b0u d\u1eef li\u1ec7u m\u1ed7i th\u00e1ng \u1edf 1 sheet, ho\u1eb7c d\u1eef li\u1ec7u k\u1ebft qu\u1ea3 l\u00e0m vi\u1ec7c c\u1ee7a m\u1ed7i nh\u00e2n vi\u00ean hay chi nh\u00e1nh c\u00f4ng ty \u1edf m\u1ed9t b\u1ea3ng t\u00ednh. \u0110\u1eb7c tr\u01b0ng c\u1ee7a ki\u1ec3u l\u01b0u tr\u1eef d\u1eef li\u1ec7u n\u00e0y l\u00e0 c\u1ea5u tr\u00fac c\u1ed9t c\u1ee7a c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u gi\u1ed1ng nhau, ch\u1ec9 c\u00f3 \u0111\u1ed9 d\u00e0i c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u l\u00e0 c\u00f3 th\u1ec3 kh\u00e1c nhau. L\u00e0m sao ch\u00fang ta c\u00f3 th\u1ec3 t\u1ea1o <a href=\"http:\/\/blog.ezworkapp.com\/cach-tao-pivot-table-tu-nhieu-sheet-trong-excel.html\"><strong>Pivot Table<\/strong><\/a> t\u1eeb nhi\u1ec1u sheet trong Excel?<\/em><\/p>\n<p>Ch\u00fang ta, \u1edf v\u1ecb tr\u00ed qu\u1ea3n l\u00fd, c\u1ea7n c\u00f3 c\u00e1i nh\u00ecn t\u1ed5ng th\u1ec3 h\u01a1n d\u1ef1a tr\u00ean c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u, trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Pivot Table trong Excel. Tuy nhi\u00ean v\u1ea5n \u0111\u1ec1 \u0111\u1eb7t ra l\u00e0, d\u1eef li\u1ec7u l\u1ea1i \u0111ang n\u1eb1m \u1edf c\u00e1c sheet kh\u00e1c nhau trong m\u1ed9t File Excel. B\u00e0i n\u00e0y<a href=\"http:\/\/blog.ezworkapp.com\"><strong> H\u1ecdc Excel Online<\/strong> <\/a>s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n m\u1ed9t k\u1ef9 thu\u1eadt \u0111\u1ec3 c\u00f3 th\u1ec3 t\u1ea1o Pivot Table t\u1eeb nhi\u1ec1u sheet trong Excel.<\/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-6766f74935b18\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-pivot-table-tu-nhieu-sheet-trong-excel.html#Sua_ten_sheet\" title=\"S\u1eeda t\u00ean sheet\">S\u1eeda t\u00ean sheet<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-pivot-table-tu-nhieu-sheet-trong-excel.html#Su_dung_Microsoft_Query_de_tao_vung_du_lieu_cho_bang_Pivot\" title=\"S\u1eed d\u1ee5ng Microsoft Query \u0111\u1ec3 t\u1ea1o v\u00f9ng d\u1eef li\u1ec7u cho b\u1ea3ng Pivot\">S\u1eed d\u1ee5ng Microsoft Query \u0111\u1ec3 t\u1ea1o v\u00f9ng d\u1eef li\u1ec7u cho b\u1ea3ng Pivot<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Sua_ten_sheet\"><\/span>S\u1eeda t\u00ean sheet<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ea7u ti\u00ean, ch\u00fang ta h\u00e3y \u0111i s\u1eeda l\u1ea1i t\u00ean b\u1ea3ng t\u00ednh \u0111\u1ec3 thu\u1eadn ti\u1ec7n cho c\u00e1c b\u01b0\u1edbc sau. Cho ph\u1ea7n n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1eb7t t\u00ean sheet ng\u1eafn g\u1ecdn, kh\u00f4ng c\u00f3 d\u1ea5u c\u00e1ch v\u00e0 kh\u00f4ng c\u00f3 k\u00ed t\u1ef1 \u0111\u1eb7c bi\u1ec7t. V\u00ec d\u1eef li\u1ec7u m\u1eabu trong b\u00e0i n\u00e0y \u0111ang \u0111\u01b0\u1ee3c l\u01b0u theo n\u0103m, n\u00ean m\u00ecnh \u0111\u1eb7t t\u00ean c\u00e1c sheet l\u1ea7n l\u01b0\u1ee3t l\u00e0 Y2017, Y2018, Y2019, Y2020. \u0110\u1ec3 \u0111\u1ed5i t\u00ean sheet, b\u1ea1n click \u0111\u00fap chu\u1ed9t tr\u00e1i v\u00e0o t\u00ean sheet v\u00e0 g\u00f5 t\u00ean m\u1edbi.<\/p>\n<figure id=\"attachment_31447\" aria-describedby=\"caption-attachment-31447\" style=\"width: 694px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/cach-tao-pivot-table-tu-nhieu-sheet-excel-01.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31447\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-tao-pivot-table-tu-nhieu-sheet-excel-01.png\" alt=\"C\u00e1ch t\u1ea1o pivot table t\u1eeb nhi\u1ec1u sheet excel\" width=\"694\" height=\"399\" title=\"cach-tao-pivot-table-tu-nhieu-sheet-excel-01\"><\/a><figcaption id=\"caption-attachment-31447\" class=\"wp-caption-text\">S\u1eeda l\u1ea1i t\u00ean sheet cho thu\u1eadn ti\u1ec7n<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_Microsoft_Query_de_tao_vung_du_lieu_cho_bang_Pivot\"><\/span>S\u1eed d\u1ee5ng Microsoft Query \u0111\u1ec3 t\u1ea1o v\u00f9ng d\u1eef li\u1ec7u cho b\u1ea3ng Pivot<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Tr\u01b0\u1edbc khi c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng Microsoft Query, c\u00e1c v\u00f9ng d\u1eef li\u1ec7u tr\u00ean c\u00e1c sheets c\u1ea7n \u0111\u01b0\u1ee3c <a href=\"http:\/\/blog.ezworkapp.com\/23-%e2%97%8f-cach-tao-bang-trong-excel.html\">\u0111\u1ecbnh d\u1ea1ng \u1edf d\u1ea1ng b\u1ea3ng<\/a>. Sau \u0111\u00f3, tu\u1ef3 v\u00e0o phi\u00ean b\u1ea3n Excel c\u1ee7a b\u1ea1n m\u00e0 c\u00e1ch truy c\u1eadp t\u00ednh n\u0103ng Microsoft Query s\u1ebd h\u01a1i kh\u00e1c nhau 1 ch\u00fat.<\/p>\n<p>\u0110\u1ed1i v\u1edbi Excel 2010, b\u1ea1n ch\u1ecdn th\u1ebb <strong>Data &gt; From Other Sources &gt; From Microsoft Query<\/strong><\/p>\n<figure id=\"attachment_31450\" aria-describedby=\"caption-attachment-31450\" style=\"width: 1512px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/cach-tao-pivot-table-tu-nhieu-sheet-excel-02-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31450 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-tao-pivot-table-tu-nhieu-sheet-excel-02-1.png\" alt=\"C\u00e1ch truy c\u1eadp v\u00e0o Microsoft Query trong Excel\" width=\"1512\" height=\"1167\" title=\"cach-tao-pivot-table-tu-nhieu-sheet-excel-02-1\"><\/a><figcaption id=\"caption-attachment-31450\" class=\"wp-caption-text\">C\u00e1ch truy c\u1eadp v\u00e0o Microsoft Query trong Excel<\/figcaption><\/figure>\n<p>\u0110\u1ed1i v\u1edbi c\u00e1c phi\u00ean b\u1ea3n Excel m\u1edbi h\u01a1n, b\u1ea1n v\u00e0o th\u1ebb\u00a0<strong>Data &gt; Get Data &gt; From Other Sources &gt; From Microsoft Query<\/strong><\/p>\n<figure id=\"attachment_31449\" aria-describedby=\"caption-attachment-31449\" style=\"width: 1254px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/cach-tao-pivot-table-tu-nhieu-sheet-excel-03.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31449\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-tao-pivot-table-tu-nhieu-sheet-excel-03.png\" alt=\"C\u00e1ch m\u1edf Microsoft Query trong Excel\" width=\"1254\" height=\"1154\" title=\"cach-tao-pivot-table-tu-nhieu-sheet-excel-03\"><\/a><figcaption id=\"caption-attachment-31449\" class=\"wp-caption-text\">C\u00e1ch m\u1edf Microsoft Query trong Excel<\/figcaption><\/figure>\n<p>Trong c\u1eeda s\u1ed5 ch\u1ecdn ngu\u1ed3n d\u1eef li\u1ec7u, ch\u1ecdn d\u1eef li\u1ec7u t\u1eeb file excel nh\u01b0 h\u00ecnh r\u1ed3i b\u1ea5m OK<\/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-656.gif\" title=\"ex101_92019-nho-656\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/chon-data-source-microsoft-query.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-31451\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/chon-data-source-microsoft-query.png\" width=\"912\" height=\"480\" title=\"chon-data-source-microsoft-query\"><\/a><\/p>\n<p>\u1ede c\u1eeda s\u1ed5 ti\u1ebfp theo, b\u1ea1n c\u1ea7n ch\u1ecdn \u0111\u00fang \u0111\u01b0\u1eddng d\u1eabn t\u1edbi file Excel hi\u1ec7n t\u1ea1i<\/p>\n<figure id=\"attachment_31452\" aria-describedby=\"caption-attachment-31452\" style=\"width: 1466px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/cach-su-dung-microsoft-query-pivot-table.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31452\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-su-dung-microsoft-query-pivot-table.png\" alt=\"Ch\u1ecdn \u0111\u01b0\u1eddng d\u1eabn t\u1edbi file Excel \u0111\u1ec3 s\u1eed d\u1ee5ng Power Query\" width=\"1466\" height=\"564\" title=\"cach-su-dung-microsoft-query-pivot-table\"><\/a><figcaption id=\"caption-attachment-31452\" class=\"wp-caption-text\">Ch\u1ecdn \u0111\u01b0\u1eddng d\u1eabn t\u1edbi file Excel \u0111\u1ec3 s\u1eed d\u1ee5ng Power Query<\/figcaption><\/figure>\n<p>Sau khi ch\u1ecdn \u0111\u01b0\u1eddng d\u1eabn v\u00e0 b\u1ea5m OK, b\u1ea1n c\u00f3 th\u1ec3 nh\u00ecn th\u1ea5y m\u00e0n h\u00ecnh sau \u0111\u00e2y<\/p>\n<figure id=\"attachment_31453\" aria-describedby=\"caption-attachment-31453\" style=\"width: 982px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/cach-su-dung-microsoft-query-trong-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31453\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-su-dung-microsoft-query-trong-excel.png\" alt=\"C\u00e1ch truy c\u1eadp v\u00e0o Microsoft Query trong Excel\" width=\"982\" height=\"608\" title=\"cach-su-dung-microsoft-query-trong-excel\"><\/a><figcaption id=\"caption-attachment-31453\" class=\"wp-caption-text\">Microsoft Query Wizard<\/figcaption><\/figure>\n<p>N\u1ebfu l\u00e0m t\u1edbi b\u01b0\u1edbc n\u00e0y m\u00e0 b\u1ea1n kh\u00f4ng nh\u00ecn th\u1ea5y d\u1eef li\u1ec7u trong ph\u1ea7n \u201cAvailable tables and columns\u201d, th\u00ec b\u1ea1n c\u1ea7n b\u1ea5m v\u00e0o n\u00fat <strong>Options\u2026\u00a0<\/strong>sau \u0111\u00f3 \u1edf c\u1eeda s\u1ed5 Table Options, ch\u1ecdn tick v\u00e0o <strong>System Tables\u00a0<\/strong>nh\u01b0 h\u00ecnh r\u1ed3i b\u1ea5m OK<\/p>\n<figure id=\"attachment_31454\" aria-describedby=\"caption-attachment-31454\" style=\"width: 456px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/system-tables.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-31454\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/system-tables.png\" alt=\"C\u00e1ch truy c\u1eadp v\u00e0o Microsoft Query trong Excel\" width=\"456\" height=\"346\" title=\"system-tables\"><\/a><figcaption id=\"caption-attachment-31454\" class=\"wp-caption-text\">Click ch\u1ecdn system tables<\/figcaption><\/figure>\n<p>Sau \u0111\u00f3 b\u1ea1n ch\u1ecdn b\u1ea3ng \u0111\u1ea7u ti\u00ean v\u00e0 b\u1ea5m n\u00fat m\u0169i t\u00ean sang ph\u1ea3i \u0111\u1ec3 th\u00eam c\u00e1c c\u1ed9t v\u00e0o trong Query<\/p>\n<figure id=\"attachment_31456\" aria-describedby=\"caption-attachment-31456\" style=\"width: 737px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/microsoft-query-trong-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31456\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/microsoft-query-trong-excel.png\" alt=\"Th\u00eam c\u1ed9t v\u00e0o microsoft query\" width=\"737\" height=\"456\" title=\"microsoft-query-trong-excel\"><\/a><figcaption id=\"caption-attachment-31456\" class=\"wp-caption-text\">Th\u00eam c\u1ed9t v\u00e0o microsoft query<\/figcaption><\/figure>\n<p>Sau \u0111\u00f3, b\u1ea1n b\u1ea5m Next cho t\u1edbi khi g\u1eb7p m\u00e0n h\u00ecnh sau th\u00ec d\u1eebng l\u1ea1i v\u00e0 ch\u1ecdn m\u1ee5c<\/p>\n<p><strong>View data or edit query in Microsoft Query<\/strong><\/p>\n<figure id=\"attachment_31457\" aria-describedby=\"caption-attachment-31457\" style=\"width: 982px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/cach-su-dung-microsoft-query.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31457\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-su-dung-microsoft-query.png\" alt=\"C\u00e1ch truy c\u1eadp v\u00e0o Microsoft Query trong Excel\" width=\"982\" height=\"578\" title=\"cach-su-dung-microsoft-query\"><\/a><figcaption id=\"caption-attachment-31457\" class=\"wp-caption-text\">Ch\u1ecdn view data or edit query in Microsoft Query<\/figcaption><\/figure>\n<p>Sau \u0111\u00f3 ch\u00fang ta c\u1ea7n b\u1ea5m n\u00fat SQL<\/p>\n<figure id=\"attachment_31460\" aria-describedby=\"caption-attachment-31460\" style=\"width: 982px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/microsoft-query-sql-view.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31460\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/microsoft-query-sql-view.png\" alt=\"C\u00e1ch truy c\u1eadp v\u00e0o Microsoft Query trong Excel\" width=\"982\" height=\"578\" title=\"microsoft-query-sql-view\"><\/a><figcaption id=\"caption-attachment-31460\" class=\"wp-caption-text\">B\u1ea5m n\u00fat SQL<\/figcaption><\/figure>\n<p>Trong h\u1ed9p tho\u1ea1i SQL Statement, d\u00e1n \u0111o\u1ea1n SQL sau \u0111\u00e2y:<\/p>\n<p><code>SELECT * FROM `Y2017$`<br \/>\nUNION ALL<br \/>\nSELECT * FROM `Y2018$`<br \/>\nUNION ALL<br \/>\nSELECT * FROM `Y2019$`<br \/>\nUNION ALL<br \/>\nSELECT * FROM `Y2020$`<\/code><\/p>\n<p>Sau \u0111\u00f3 b\u1ea5m OK<\/p>\n<figure id=\"attachment_31461\" aria-describedby=\"caption-attachment-31461\" style=\"width: 2308px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/sua-sql-trong-microsoft-query.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31461\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sua-sql-trong-microsoft-query.png\" alt=\"S\u1eeda SQL trong Microsoft Query\" width=\"2308\" height=\"1604\" title=\"sua-sql-trong-microsoft-query\"><\/a><figcaption id=\"caption-attachment-31461\" class=\"wp-caption-text\">S\u1eeda SQL trong Microsoft Query<\/figcaption><\/figure>\n<p>Sau \u0111\u00f3, trong c\u1eeda s\u1ed5 Microsoft Query, b\u1ea1n ch\u1ecdn <strong>File &gt; Return Data to Excel<\/strong><\/p>\n<figure id=\"attachment_31462\" aria-describedby=\"caption-attachment-31462\" style=\"width: 342px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/return-data-to-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-31462\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/return-data-to-excel.png\" alt=\"\u0110\u1ed5 d\u1eef li\u1ec7u t\u1eeb Microsoft Query v\u1ec1 Excel\" width=\"342\" height=\"326\" title=\"return-data-to-excel\"><\/a><figcaption id=\"caption-attachment-31462\" class=\"wp-caption-text\">\u0110\u1ed5 d\u1eef li\u1ec7u t\u1eeb Microsoft Query v\u1ec1 Excel<\/figcaption><\/figure>\n<p>Ti\u1ebfp theo, ch\u00fang ta s\u1ebd l\u1ef1a ch\u1ecdn n\u01a1i s\u1ebd l\u01b0u d\u1eef li\u1ec7u \u1edf file Excel l\u00e0 1 worksheet m\u1edbi<\/p>\n<figure id=\"attachment_31464\" aria-describedby=\"caption-attachment-31464\" style=\"width: 334px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/return-data-to-excel-microsoft-query.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-31464\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/return-data-to-excel-microsoft-query.png\" alt=\"L\u01b0u l\u1ea1i d\u1eef li\u1ec7u v\u00e0o b\u1ea3ng tr\u00ean Excel\" width=\"334\" height=\"380\" title=\"return-data-to-excel-microsoft-query\"><\/a><figcaption id=\"caption-attachment-31464\" class=\"wp-caption-text\">L\u01b0u l\u1ea1i d\u1eef li\u1ec7u v\u00e0o b\u1ea3ng tr\u00ean Excel<\/figcaption><\/figure>\n<p>Nh\u01b0 v\u1eady l\u00e0 t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 <a href=\"http:\/\/blog.ezworkapp.com\/khoi-dau-voi-pivot-table-trong-excel.html\">t\u1ea1o ra Pivot Table<\/a> v\u00e0 nh\u1eefng b\u00e1o c\u00e1o c\u1ea7n thi\u1ebft. Khi d\u1eef li\u1ec7u \u1edf c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u ban \u0111\u1ea7u thay \u0111\u1ed5i, b\u1ea1n ch\u1ec9 c\u1ea7n b\u1ea5m Refresh d\u1eef li\u1ec7u trong th\u1ebb Table Design l\u00e0 d\u1eef li\u1ec7u s\u1ebd \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt<\/p>\n<figure id=\"attachment_31465\" aria-describedby=\"caption-attachment-31465\" style=\"width: 1004px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/refresh-du-lieu-pivot-table.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31465\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/refresh-du-lieu-pivot-table.png\" alt=\"L\u00e0m m\u1edbi d\u1eef li\u1ec7u trong b\u1ea3ng Pivot Table\" width=\"1004\" height=\"486\" title=\"refresh-du-lieu-pivot-table\"><\/a><figcaption id=\"caption-attachment-31465\" class=\"wp-caption-text\">L\u00e0m m\u1edbi d\u1eef li\u1ec7u trong b\u1ea3ng ngu\u1ed3n c\u1ee7a Pivot Table<\/figcaption><\/figure>\n<p>N\u1ebfu c\u00e1c b\u01b0\u1edbc ph\u00eda tr\u00ean c\u00f2n ch\u01b0a r\u00f5 v\u1edbi c\u00e1c b\u1ea1n, m\u1eddi c\u00e1c b\u1ea1n xem video sau \u0111\u00e2y:<\/p>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/PTx16zNcKyU\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe>\n<p><em>Ch\u00fac th\u00e0nh c\u00f4ng c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng v\u1edbi b\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y c\u1ee7a ch\u00fang t\u00f4i. C\u1eadp nh\u1eadt th\u00eam nh\u1eefng ki\u1ebfn th\u1ee9c v\u1ec1 <a href=\"http:\/\/blog.ezworkapp.com\/power-query-la-gi-tai-sao-can-hoc-power-query.html\"><strong>Power Query<\/strong><\/a> \u1edf nh\u1eefng b\u00e0i vi\u1ebft sau nh\u00e9!<\/em><\/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-656.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7276,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-7275","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\/7275","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=7275"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7275\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7276"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7275"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7275"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7275"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}