{"id":3925,"date":"2024-12-04T08:18:33","date_gmt":"2024-12-04T08:18:33","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/ung-dung-power-query-xay-dung-mo-hinh-du-lieu-phan-tich-nang-suat-lao-dong-phan-2\/"},"modified":"2024-12-04T08:18:33","modified_gmt":"2024-12-04T08:18:33","slug":"ung-dung-power-query-xay-dung-mo-hinh-du-lieu-phan-tich-nang-suat-lao-dong-phan-2","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/ung-dung-power-query-xay-dung-mo-hinh-du-lieu-phan-tich-nang-suat-lao-dong-phan-2\/","title":{"rendered":"\u1ee8ng d\u1ee5ng Power Query x\u00e2y d\u1ef1ng m\u00f4 h\u00ecnh d\u1eef li\u1ec7u ph\u00e2n t\u00edch n\u0103ng su\u1ea5t lao \u0111\u1ed9ng \u2013 Ph\u1ea7n 2"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u m\u1ed9t\u00a0\u1ee9ng d\u1ee5ng c\u1ee7a Power Query trong vi\u1ec7c x\u00e2y d\u1ef1ng m\u00f4 h\u00ecnh d\u1eef li\u1ec7u v\u1ec1 ph\u00e2n t\u00edch n\u0103ng su\u1ea5t lao\u00a0\u0111\u1ed9ng. M\u00f4 h\u00ecnh n\u00e0y c\u0169ng th\u01b0\u1eddng g\u1eb7p trong th\u1ef1c t\u1ebf khi l\u00e0m vi\u1ec7c v\u1edbi\u00a0Excel. H\u00e3y xem v\u1edbi Power Query ch\u00fang ta c\u00f3 th\u1ec3 l\u00e0m\u00a0\u0111\u01b0\u1ee3c g\u00ec nh\u00e9.<\/p>\n<p>Trong ph\u1ea7n 1, ch\u00fang ta\u00a0\u0111\u00e3 t\u00ecm hi\u1ec3u c\u00e1ch t\u00e1i c\u1ea5u tr\u00fac l\u1ea1i c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u\u00a0\u0111\u1ec3 c\u00f3 c\u1ea5u tr\u00fac\u00a0\u0111\u00fang ti\u00eau chu\u1ea9n. M\u1ee5c\u00a0\u0111\u00edch c\u1ee7a vi\u1ec7c n\u00e0y l\u00e0 t\u1ea1o ra b\u1ea3ng k\u1ebft qu\u1ea3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng\u00a0\u0111\u01b0\u1ee3c Pivot Table \u2013 n\u1ed9i dung quan tr\u1ecdng nh\u1ea5t trong vi\u1ec7c gi\u00fap ph\u00e2n t\u00edch d\u1eef li\u1ec7u.<\/p>\n<p>Xem l\u1ea1i:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ung-dung-power-query-xay-dung-mo-hinh-du-lieu-phan-tich-nang-suat-lao-dong-phan-1.html\">\u1ee8ng d\u1ee5ng Power Query x\u00e2y d\u1ef1ng m\u00f4 h\u00ecnh d\u1eef li\u1ec7u ph\u00e2n t\u00edch n\u0103ng su\u1ea5t lao \u0111\u1ed9ng \u2013 Ph\u1ea7n 1<\/a><\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i file\u00a0k\u1ebft qu\u1ea3 ph\u1ea7n 1\u00a0t\u1ea1i\u00a0\u0111\u1ecba ch\u1ec9:\u00a0<a href=\"http:\/\/bit.ly\/31XTYVj\">http:\/\/bit.ly\/31XTYVj<\/a><\/p>\n<h2>Ph\u1ea7n 2: G\u1ed9p c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u v\u00e0o 1 b\u1ea3ng duy nh\u1ea5t<\/h2>\n<p>Ngo\u00e0i vi\u1ec7c c\u1ea5u tr\u00fac b\u1ea3ng d\u1eef li\u1ec7u\u00a0\u0111\u00fang chu\u1ea9n, ch\u00fang ta c\u00f2n ph\u1ea3i\u00a0\u0111\u1ea3m b\u1ea3o t\u1ea5t c\u1ea3 c\u00e1c d\u1eef li\u1ec7u\u00a0\u0111\u01b0\u1ee3c t\u1eadp trung, th\u1ed1ng nh\u1ea5t tr\u00ean 1 b\u1ea3ng d\u1eef li\u1ec7u. C\u00f3 nh\u01b0 v\u1eady th\u00ec ch\u00fang ta m\u1edbi c\u00f3\u00a0\u0111\u1ee7 th\u00f4ng tin\u00a0\u0111\u1ec3 ph\u00e2n t\u00edch.<\/p>\n<p>\u0110\u1eb7c\u00a0\u0111i\u1ec3m c\u1ee7a m\u00f4 h\u00ecnh d\u1eef li\u1ec7u trong b\u00e0i t\u1eadp l\u00e0 d\u1eef li\u1ec7u chia ra 3 b\u1ea3ng t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi 3 n\u0103m, theo c\u00e1c Sheet ri\u00eang. Do\u00a0\u0111\u00f3 y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c l\u00e0 ch\u00fang ta ph\u1ea3i g\u1ed9p c\u00e1c b\u1ea3ng v\u00e0o th\u00e0nh 1 b\u1ea3ng duy nh\u1ea5t.<\/p>\n<p>Trong file k\u1ebft qu\u1ea3 c\u1ee7a Ph\u1ea7n 1, ch\u00fang ta c\u00f3\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u00e0 3 b\u1ea3ng: Data_2017,\u00a0Data_2018,\u00a0Data_2019 t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi 3 Sheet.<\/p>\n<p>C\u00e1c b\u01b0\u1edbc\u00a0\u0111\u1ec3 g\u1ed9p file trong Power Query nh\u01b0 sau:<\/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-312.gif\" title=\"ex101_92019-nho-312\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><strong>B\u01b0\u1edbc 1: T\u1ea1o 1 Query m\u1edbi<\/strong> b\u1eb1ng c\u00e1ch: Ch\u1ecdn Th\u1ebb Data &gt; Get Data &gt; From Other Source &gt; Blank Query<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-30509\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-1-tao-moi-blank-query.png\" width=\"424\" height=\"634\" title=\"2-1-tao-moi-blank-query\"><\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: Trong Query m\u1edbi\u00a0\u0111\u01b0\u1ee3c t\u1ea1o, nh\u1eadp c\u00e2u l\u1ec7nh sau\u00a0\u0111\u00e2y tr\u00ean thanh c\u00f4ng th\u1ee9c:<\/p>\n<blockquote>\n<p>=Excel.CurrentWorkbook()<\/p>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-30510\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-2-nhap-lenh-excel-currentworkbook-vao-thanh-cong-thuc.png\" width=\"620\" height=\"273\" title=\"2-2-nhap-lenh-excel-currentworkbook-vao-thanh-cong-thuc\"><\/p>\n<p>Ch\u00fa\u00a0\u00fd: Ph\u1ea3i vi\u1ebft hoa\u00a0\u0111\u00fang v\u1ecb tr\u00ed c\u00e1c ch\u1eef c\u00e1i. Khi nh\u1eadp l\u1ec7nh n\u00e0y, b\u1ea1n s\u1ebd\u00a0\u0111\u01b0\u1ee3c g\u1ee3i\u00a0\u00fd. C\u00f3 th\u1ec3 ch\u1ecdn theo n\u1ed9i dung\u00a0\u0111\u01b0\u1ee3c g\u1ee3i\u00a0\u00fd\u00a0\u0111\u1ec3 vi\u1ebft\u00a0\u0111\u00fang c\u00fa ph\u00e1p.<\/p>\n<p>M\u1ee5c\u00a0\u0111\u00edch:\u00a0\u0110\u1ec3 c\u00f3 th\u1ec3 l\u1ea5y to\u00e0n b\u1ed9 n\u1ed9i dung c\u00e1c b\u1ea3ng c\u00f3 trong\u00a0Workbook\u00a0\u0111\u01b0a v\u00e0o trong Power Query.<\/p>\n<p>K\u1ebft qu\u1ea3 c\u1ee7a c\u00e2u l\u1ec7nh:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-30511\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-3-noi-dung-table-trong-currentworkbook.png\" width=\"442\" height=\"234\" title=\"2-3-noi-dung-table-trong-currentworkbook\"><\/p>\n<p>Trong\u00a0\u0111\u00f3 ch\u00fang ta t\u1eadp trung v\u00e0o c\u00e1c b\u1ea3ng c\u00f3 t\u00ean l\u00e0 Data_2017, Data_2018, Data_2019 v\u00ec\u00a0\u0111\u00e2y l\u00e0 c\u00e1c b\u1ea3ng\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c x\u1eed l\u00fd qua ph\u1ea7n 1.<\/p>\n<p><strong>B\u01b0\u1edbc 3: L\u1ecdc c\u00e1c b\u1ea3ng c\u1ea7n s\u1eed d\u1ee5ng<\/strong><\/p>\n<p>T\u1ea1i v\u1ecb tr\u00ed n\u00fat l\u1ecdc trong c\u1ed9t Name, ch\u00fang ta ch\u1ec9 gi\u1eef l\u1ea1i t\u00ean c\u00e1c b\u1ea3ng\u00a0\u0111\u00e3 qua x\u1eed l\u00fd. C\u00e1c b\u1ea3ng kh\u00f4ng d\u00f9ng\u00a0\u0111\u1ebfn s\u1ebd b\u1ecf ch\u1ecdn.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-30512\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-4-loc-cac-table-can-su-dung.png\" width=\"434\" height=\"492\" title=\"2-4-loc-cac-table-can-su-dung\"><\/p>\n<p>\u0110\u00e2y l\u00e0 c\u00e1c b\u1ea3ng s\u1ebd\u00a0\u0111\u01b0\u1ee3c d\u00f9ng\u00a0\u0111\u1ec3 g\u1ed9p l\u1ea1i v\u00e0o 1 b\u1ea3ng chung. C\u00e1c b\u1ea3ng n\u00e0y\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c x\u1eed l\u00fd v\u1ec1 c\u1ea5u tr\u00fac, c\u00e1ch t\u1ed5 ch\u1ee9c gi\u1ed1ng nhau.<\/p>\n<p><strong>B\u01b0\u1edbc 4: M\u1edf r\u1ed9ng n\u1ed9i dung chi ti\u1ebft trong b\u1ea3ng<\/strong><\/p>\n<p>\u0110\u1ec3 xem chi ti\u1ebft n\u1ed9i dung trong b\u1ea3ng theo c\u00e1c c\u1ed9t, ch\u00fang ta s\u1ebd b\u1ecf d\u1ea5u t\u00edch trong m\u1ee5c\u00a0<strong>Use\u00a0original column name\u00a0as prefix<\/strong> r\u1ed3i ch\u1ecdn OK<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-30513\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-5-bo-gop-noi-dung-trong-cac-bang.png\" width=\"650\" height=\"387\" title=\"2-5-bo-gop-noi-dung-trong-cac-bang\"><\/p>\n<p>K\u1ebft qu\u1ea3 nh\u1eadn\u00a0\u0111\u01b0\u1ee3c ch\u00ednh l\u00e0 b\u1ea3ng d\u1eef li\u1ec7u g\u1ed9p t\u1eeb 3 b\u1ea3ng:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30514\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-6-bang-du-lieu-da-duoc-gop-1024x226-1.png\" width=\"1024\" height=\"226\" title=\"2-6-bang-du-lieu-da-duoc-gop-1024x226-1\"><\/p>\n<p>Trong\u00a0\u0111\u00f3 xu\u1ea5t hi\u1ec7n th\u00eam c\u1ed9t Name:\u00a0\u0111\u00e2y ch\u00ednh l\u00e0 c\u1ed9t th\u1ec3 hi\u1ec7n n\u1ed9i dung trong t\u1eebng d\u00f2ng\u00a0thu\u1ed9c b\u1ea3ng n\u00e0o.<\/p>\n<p><strong>B\u01b0\u1edbc 5: T\u00e1ch s\u1ed1 n\u0103m ra th\u00e0nh 1 c\u1ed9t ri\u00eang<\/strong><\/p>\n<p>V\u1edbi c\u00e1c t\u00ean Data_2017, Data_2018, Data_2019 s\u1ebd l\u00e0 c\u00e1c k\u00fd t\u1ef1 Text. N\u1ebfu mu\u1ed1n t\u00e1ch ri\u00eang s\u1ed1 n\u0103m ra kh\u1ecfi c\u00e1c c\u1ed9t n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 l\u00e0m c\u00e1ch sau:<\/p>\n<p>Ch\u1ecdn Split Column &gt; By Delemiter &gt;\u00a0D\u1ef1a tr\u00ean k\u00fd t\u1ef1 nh\u1eadn bi\u1ebft v\u1ecb tr\u00ed c\u1ea7n t\u00e1ch\u00a0l\u00e0 d\u1ea5u g\u1ea1ch d\u01b0\u1edbi<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-30515\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-7-tach-noi-dung-trong-cot-theo-ky-tu-dac-biet.png\" width=\"875\" height=\"452\" title=\"2-7-tach-noi-dung-trong-cot-theo-ky-tu-dac-biet\"><\/p>\n<p>Nh\u01b0 v\u1eady k\u1ebft qu\u1ea3 s\u1ebd g\u1ed3m 2 c\u1ed9t:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-30516\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-8-cot-ket-qua-sau-khi-tach.png\" width=\"400\" height=\"164\" title=\"2-8-cot-ket-qua-sau-khi-tach\"><\/p>\n<ul>\n<li>Name.2 :\u00a0\u0110\u1ed5i t\u00ean th\u00e0nh \u2018<strong>N\u0103m<\/strong>\u2018<\/li>\n<li>Name.1 : C\u00f3 th\u1ec3 x\u00f3a c\u1ed9t n\u00e0y\u00a0\u0111i (ch\u1ecdn c\u1ed9t Name.1 r\u1ed3i b\u1ea5m chu\u1ed9t ph\u1ea3i, ch\u1ecdn <strong>Remove<\/strong>)<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 6: Ho\u00e0n th\u00e0nh<\/strong>, b\u1ea5m ch\u1ecdn th\u1ebb Home r\u1ed3i b\u1ea5m Close &amp; Load\u00a0\u0111\u1ec3\u00a0\u0111\u00f3ng Power Query v\u00e0 xu\u1ea5t b\u1ea3ng k\u1ebft qu\u1ea3 ra file\u00a0Excel<\/p>\n<p><strong>B\u01b0\u1edbc 7<\/strong>: Do t\u1ea1i b\u01b0\u1edbc 2, ch\u00fang ta l\u1ea5y to\u00e0n b\u1ed9 c\u00e1c b\u1ea3ng trong\u00a0Excel.CurrentWorkbook. Do\u00a0\u0111\u00f3 khi Refresh l\u1ea1i d\u1eef li\u1ec7u, b\u1ea3ng k\u1ebft qu\u1ea3 s\u1ebd b\u1ecb Duplicate (tr\u00f9ng l\u1eb7p d\u1eef li\u1ec7u).\u00a0\u0110\u1ec3 ng\u0103n vi\u1ec7c n\u00e0y, ch\u00fang ta s\u1ebd l\u00e0m nh\u01b0 sau:<\/p>\n<ul>\n<li>B\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o v\u1ecb tr\u00ed b\u1ea5t k\u1ef3 trong b\u1ea3ng k\u1ebft qu\u1ea3, ch\u1ecdn Table &gt; Edit Query (ho\u1eb7c nh\u00e1y\u00a0\u0111\u00fap chu\u1ed9t v\u00e0o t\u00ean Query trong b\u1ea3ng Queries &amp; Connections)\u00a0\u0111\u1ec3 quay tr\u1edf l\u1ea1i c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c c\u1ee7a Power Query<\/li>\n<li>Trong c\u1eeda s\u1ed5 Power Query v\u1edbi Query1 (l\u00e0 Query v\u1eeba l\u00e0m vi\u1ec7c\u00a0\u1edf tr\u00ean), ch\u1ecdn m\u1ee5c Source tr\u00ean c\u1eeda s\u1ed5 Applied Step. Sau\u00a0\u0111\u00f3 ch\u1ecdn m\u1ee5c Refresh Preview &gt; B\u1ea5m ch\u1ecdn\u00a0<strong>Refresh Preview<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-30517\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-9-giao-dien-refresh-preview.png\" width=\"750\" height=\"389\" title=\"2-9-giao-dien-refresh-preview\"><\/p>\n<p>K\u1ebft qu\u1ea3 s\u1ebd c\u00f3 th\u00eam b\u1ea3ng Query1 (b\u1ea3ng k\u1ebft qu\u1ea3\u00a0\u1edf b\u01b0\u1edbc 6)<\/p>\n<p>Th\u1ef1c hi\u1ec7n l\u1ea1i thao t\u00e1c l\u1ecdc b\u1ea3ng (trong b\u01b0\u1edbc 3): Ch\u1ec9 ch\u1ecdn\u00a0\u0111\u00fang 3 b\u1ea3ng c\u1ea7n l\u00e0m vi\u1ec7c: Data_2017, Data_2018, Data_2019. C\u00e1c b\u1ea3ng kh\u00e1c s\u1ebd b\u1ecf ch\u1ecdn.<\/p>\n<p>Sau\u00a0\u0111\u00f3 b\u1ea5m <strong>Close &amp; Load<\/strong>\u00a0\u0111\u1ec3 ho\u00e0n th\u00e0nh c\u00f4ng vi\u1ec7c.<\/p>\n<p>File k\u1ebft qu\u1ea3 c\u00f3 th\u1ec3 t\u1ea3i v\u1ec1 t\u1ea1i\u00a0\u0111\u00e2y:<\/p>\n<p>Nh\u01b0 v\u1eady l\u00e0 ch\u00fang ta\u00a0\u0111\u00e3 ho\u00e0n th\u00e0nh\u00a0\u0111\u01b0\u1ee3c c\u00f4ng vi\u1ec7c t\u00e1i c\u1ea5u tr\u00fac l\u1ea1i to\u00e0n b\u1ed9 c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u\u00a0\u0111\u1ec3 cho ra 1 b\u1ea3ng d\u1eef li\u1ec7u duy nh\u1ea5t.\u00a0B\u1ea3ng d\u1eef li\u1ec7u n\u00e0y s\u1ebd\u00a0\u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt t\u1ef1\u00a0\u0111\u1ed9ng m\u1ed7i khi file g\u1ed1c c\u00f3 s\u1ef1 thay\u00a0\u0111\u1ed5i n\u1ed9i dung. Vi\u1ec7c n\u00e0y gi\u00fap qu\u00e1 tr\u00ecnh nh\u1eadp d\u1eef li\u1ec7u v\u1eabn tr\u00ean File g\u1ed1c, b\u1ea3ng g\u1ed1c, kh\u00f4ng c\u1ea7n ph\u1ea3i l\u00e0m l\u1ea1i thao t\u00e1c\u00a0t\u00e1i c\u1ea5u tr\u00fac d\u1eef li\u1ec7u n\u1eefa. R\u1ea5t ti\u1ec7n l\u1ee3i ph\u1ea3i kh\u00f4ng n\u00e0o.<\/p>\n<p>Trong ph\u1ea7n sau, ch\u00fang ta s\u1ebd c\u00f9ng t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c t\u00ednh trong Power Query\u00a0\u0111\u1ec3 t\u1ea1o ra c\u00e1c d\u1eef li\u1ec7u\u00a0c\u1ea7n thi\u1ebft cho b\u00e1o c\u00e1o.<\/p>\n<p>\u00a0<\/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-312.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3926,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3925","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3925","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=3925"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3925\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3926"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3925"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3925"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3925"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}