{"id":3451,"date":"2024-12-03T02:32:13","date_gmt":"2024-12-03T02:32:13","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-cach-phan-tich-tra-no-goc-va-lai-cung-chuoi-ham-pmt-trong-excel\/"},"modified":"2024-12-03T02:32:13","modified_gmt":"2024-12-03T02:32:13","slug":"huong-dan-cach-phan-tich-tra-no-goc-va-lai-cung-chuoi-ham-pmt-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-cach-phan-tich-tra-no-goc-va-lai-cung-chuoi-ham-pmt-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch ph\u00e2n t\u00edch tr\u1ea3 n\u1ee3 g\u1ed1c v\u00e0 l\u00e3i c\u00f9ng chu\u1ed7i h\u00e0m PMT trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i h\u1ecdc v\u1ec1 <a href=\"http:\/\/blog.ezworkapp.com\/excel-voi-tai-chinh-ham-pmt-tinh-tien-thanh-toan-hang-ky-cho-khoan-vay.html\">h\u00e0m PMT t\u00ednh s\u1ed1 ti\u1ec1n ph\u1ea3i tr\u1ea3 h\u00e0ng k\u1ef3 cho kho\u1ea3n vay c\u00f3 l\u00e3i su\u1ea5t x\u00e1c\u00a0\u0111\u1ecbnh<\/a>, ch\u00fang ta\u00a0\u0111\u00e3 x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m PMT. Nh\u01b0ng n\u1ebfu mu\u1ed1n ph\u00e2n bi\u1ec7t r\u00f5 s\u1ed1 tr\u1ea3 g\u1ed1c v\u00e0 tr\u1ea3 l\u00e3i h\u00e0ng k\u1ef3 th\u00ec l\u00e0m th\u1ebf n\u00e0o? Trong b\u00e0i n\u00e0y ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch ph\u00e2n t\u00edch tr\u1ea3 n\u1ee3 g\u1ed1c v\u00e0 l\u00e3i c\u00f9ng chu\u1ed7i h\u00e0m PMT trong\u00a0excel nh\u00e9.<\/p>\n<p><em><strong>V\u1eabn s\u1eed d\u1ee5ng v\u00ed d\u1ee5 c\u1ee7a b\u00e0i h\u1ecdc tr\u01b0\u1edbc\u00a0\u0111\u1ec3\u00a0\u00e1p d\u1ee5ng v\u00e0o b\u00e0i h\u1ecdc n\u00e0y:<\/strong><\/em><\/p>\n<p>B\u1ea1n c\u1ea7n vay m\u1ed9t kho\u1ea3n ti\u1ec1n l\u00e0 100 tri\u1ec7u t\u1ea1i th\u1eddi \u0111i\u1ec3m hi\u1ec7n t\u1ea1i, tr\u1ea3 \u0111\u1ec1u \u0111\u1eb7n h\u00e0ng th\u00e1ng trong v\u00f2ng 3 n\u0103m v\u1edbi l\u00e3i su\u1ea5t 6% m\u1ed7i th\u00e1ng. V\u1eady m\u1ed7i th\u00e1ng ph\u1ea3i tr\u1ea3 bao nhi\u00eau ti\u1ec1n? T\u1ed5ng c\u1ed9ng sau 3 n\u0103m ph\u1ea3i tr\u1ea3 c\u1ea3 g\u1ed1c v\u00e0 l\u00e3i l\u00e0 bao nhi\u00eau ti\u1ec1n? Ph\u00e2n t\u00edch s\u1ed1 ti\u1ec1n g\u1ed1c, ti\u1ec1n l\u00e3i, c\u00f2n n\u1ee3 c\u1ee7a t\u1eebng k\u1ef3?<\/p>\n<p><strong><em>C\u00e1ch l\u00e0m<\/em><\/strong>:<\/p>\n<p>\u0110\u1ec3 ph\u00e2n t\u00edch tr\u1ea3 n\u1ee3, ch\u00fang ta l\u1eadp 1 b\u1ea3ng x\u00e1c\u00a0\u0111\u1ecbnh r\u00f5 t\u1eebng k\u1ef3 thanh to\u00e1n nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12950\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic03-8.png\" width=\"1190\" height=\"475\" title=\"pic03-8\"><\/p>\n<ul>\n<li>X\u00e1c\u00a0\u0111\u1ecbnh r\u00f5 t\u1eebng k\u1ef3 thanh to\u00e1n<\/li>\n<li>T\u1ea1i m\u1ed7i k\u1ef3 s\u1ebd x\u00e1c\u00a0\u0111\u1ecbnh c\u00e1c ch\u1ec9 ti\u00eau: S\u1ed1 ph\u1ea3i tr\u1ea3, S\u1ed1 tr\u1ea3 g\u1ed1c, S\u1ed1 tr\u1ea3 l\u00e3i, s\u1ed1 c\u00f2n n\u1ee3<\/li>\n<\/ul>\n<p>M\u1ed7i ch\u1ec9 ti\u00eau s\u1ebd\u00a0\u0111\u01b0\u1ee3c t\u00ednh c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/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<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-114.gif\" title=\"vba101_92019-nho-114\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-266.gif\" title=\"ex101_92019-nho-266\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><label for=\"ez-toc-cssicon-toggle-item-674e6daca53b9\" 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\/excel-tai-chinh-phan-tich-tra-no-goc-va-lai-cung-chuoi-ham-pmt.html#1_So_phai_tra_ham_PMT\" title=\"1. S\u1ed1 ph\u1ea3i tr\u1ea3 = h\u00e0m PMT\">1. S\u1ed1 ph\u1ea3i tr\u1ea3 = h\u00e0m PMT<\/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\/excel-tai-chinh-phan-tich-tra-no-goc-va-lai-cung-chuoi-ham-pmt.html#2_Tra_goc_ham_PPMT_Principal_Part_of_the_Payment\" title=\"2. Tr\u1ea3 g\u1ed1c = h\u00e0m PPMT (Principal Part\u00a0of the Payment)\">2. Tr\u1ea3 g\u1ed1c = h\u00e0m PPMT (Principal Part\u00a0of the Payment)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/excel-tai-chinh-phan-tich-tra-no-goc-va-lai-cung-chuoi-ham-pmt.html#3_Tra_lai_ham_IPMT_Interest_Part_of_the_Payment\" title=\"3. Tr\u1ea3 l\u00e3i = h\u00e0m IPMT\u00a0(Interest\u00a0Part\u00a0of the Payment)\">3. Tr\u1ea3 l\u00e3i = h\u00e0m IPMT\u00a0(Interest\u00a0Part\u00a0of the Payment)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/excel-tai-chinh-phan-tich-tra-no-goc-va-lai-cung-chuoi-ham-pmt.html#4_So_con_no_Khoan_vay_Tra_goc_vi_tra_goc_la_so_am\" title=\"4. S\u1ed1 c\u00f2n n\u1ee3 = Kho\u1ea3n vay + Tr\u1ea3 g\u1ed1c (v\u00ec tr\u1ea3 g\u1ed1c l\u00e0 s\u1ed1\u00a0\u00e2m)\">4. S\u1ed1 c\u00f2n n\u1ee3 = Kho\u1ea3n vay + Tr\u1ea3 g\u1ed1c (v\u00ec tr\u1ea3 g\u1ed1c l\u00e0 s\u1ed1\u00a0\u00e2m)<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"1_So_phai_tra_ham_PMT\"><\/span>1. S\u1ed1 ph\u1ea3i tr\u1ea3 = h\u00e0m PMT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<blockquote>\n<p>F2 =PMT($C$4,$C$3,$C$2)<\/p>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12951 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic04-8.png\" width=\"1202\" height=\"236\" title=\"pic04-8\"><\/p>\n<p>C\u00e1c v\u1ecb tr\u00ed c\u1ee7a tham chi\u1ebfu trong h\u00e0m PMT s\u1ebd c\u1ea7n\u00a0\u0111\u01b0\u1ee3c c\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u0111\u1ec3 ch\u00fang ta c\u00f3 th\u1ec3 t\u00ednh ti\u1ebfp cho c\u00e1c k\u1ef3 sau.<\/p>\n<blockquote>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">T\u00e0i li\u1ec7u Excel c\u01a1 b\u1ea3n<\/a> hay nh\u1ea5t<\/p>\n<\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"2_Tra_goc_ham_PPMT_Principal_Part_of_the_Payment\"><\/span>2. Tr\u1ea3 g\u1ed1c = h\u00e0m PPMT (Principal Part\u00a0of the Payment)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u1ea5u tr\u00fac h\u00e0m <strong>PPMT(Rate, Per, Nper, PV,\u00a0[FV],\u00a0[Type])<\/strong><\/p>\n<p>\u1ede\u00a0\u0111\u00e2y xu\u1ea5t hi\u1ec7n th\u00eam 1 tham chi\u1ebfu l\u00e0 Per = T\u1ea1i k\u1ef3 n\u00e0o =&gt; X\u00e1c\u00a0\u0111\u1ecbnh c\u1ee5 th\u1ec3 tr\u1ea3 g\u1ed1c v\u00e0o k\u1ef3 n\u00e0o. Kho\u1ea3n ti\u1ec1n n\u00e0y s\u1ebd\u00a0\u0111\u01b0\u1ee3c quy\u00a0\u0111\u1ed5i v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai c\u1ee7a kho\u1ea3n ti\u1ec1n t\u1ea1i th\u1eddi\u00a0\u0111i\u1ec3m k\u1ebft th\u00fac k\u1ef3 h\u1ea1n tr\u1ea3 n\u1ee3.<\/p>\n<blockquote>\n<p>G2\u00a0=PPMT($C$4,$E2,$C$3,$C$2)<\/p>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12952 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic05-7.png\" width=\"1188\" height=\"226\" title=\"pic05-7\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_Tra_lai_ham_IPMT_Interest_Part_of_the_Payment\"><\/span>3. Tr\u1ea3 l\u00e3i = h\u00e0m IPMT\u00a0(Interest\u00a0Part\u00a0of the Payment)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u1ea5u tr\u00fac h\u00e0m\u00a0<strong>IPMT(Rate, Per, Nper, PV,\u00a0[FV],\u00a0[Type])<\/strong><\/p>\n<p>C\u1ea5u tr\u00fac n\u00e0y t\u01b0\u01a1ng t\u1ef1 v\u1edbi c\u1ea5u tr\u00fac h\u00e0m PPMT, ch\u1ec9 kh\u00e1c l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m cho ch\u00fang ta s\u1ed1 ti\u1ec1n l\u00e0 s\u1ed1 l\u00e3i ph\u1ea3i tr\u1ea3, quy\u00a0\u0111\u1ed5i v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai c\u1ee7a kho\u1ea3n ti\u1ec1n t\u1ea1i th\u1eddi\u00a0\u0111i\u1ec3m k\u1ebft th\u00fac k\u1ef3 h\u1ea1n tr\u1ea3 n\u1ee3.<\/p>\n<blockquote>\n<p>H2 =IPMT($C$4,E2,$C$3,$C$2)<\/p>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12953 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic06-6.png\" width=\"1192\" height=\"227\" title=\"pic06-6\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_So_con_no_Khoan_vay_Tra_goc_vi_tra_goc_la_so_am\"><\/span>4. S\u1ed1 c\u00f2n n\u1ee3 = Kho\u1ea3n vay + Tr\u1ea3 g\u1ed1c (v\u00ec tr\u1ea3 g\u1ed1c l\u00e0 s\u1ed1\u00a0\u00e2m)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>S\u1ed1 c\u00f2n n\u1ee3 = Kho\u1ea3n vay c\u00f2n l\u1ea1i sau m\u1ed7i k\u1ef3\u00a0\u2013 Tr\u1ea3 g\u1ed1c m\u1ed7i k\u1ef3<\/p>\n<p>I2 = C2+G2<\/p>\n<p>I3 = I2+G3<\/p>\n<p>I4=I3+G4<\/p>\n<p>\u2026<\/p>\n<p>=&gt; Sau\u00a0\u0111\u00f3 Filldown to\u00e0n b\u1ed9 c\u00f4ng th\u1ee9c cho c\u00e1c k\u1ef3 c\u00f2n l\u1ea1i\u00a0\u0111\u1ec3 xem k\u1ebft qu\u1ea3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12954 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic07-6.png\" width=\"1196\" height=\"709\" title=\"pic07-6\"><\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta c\u00f3 th\u1ec3 ph\u00e2n bi\u1ec7t\u00a0\u0111\u01b0\u1ee3c r\u00f5 s\u1ed1 g\u1ed1c v\u00e0 s\u1ed1 l\u00e3i trong m\u1ed7i k\u1ef3 thanh to\u00e1n.<\/p>\n<p>C\u00e0ng tr\u1ea3 nhi\u1ec1u k\u1ef3 th\u00ec s\u1ed1 l\u00e3i ph\u1ea3i tr\u1ea3 c\u00e0ng t\u0103ng<\/p>\n<p>Ch\u00fang ta th\u1eed x\u00e9t v\u00ed d\u1ee5 tr\u00ean v\u1edbi s\u1ed1 k\u1ef3 tr\u1ea3 n\u1ee3 l\u00e0 12 th\u00e1ng xem sao:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12955 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic08-1.png\" width=\"1188\" height=\"398\" title=\"pic08-1\"><\/p>\n<p>Nh\u01b0 v\u1eady ch\u1ec9 c\u1ea7n gi\u1ea3m s\u1ed1 k\u1ef3 tr\u1ea3 l\u00e3i t\u1eeb 36 xu\u1ed1ng 12 th\u00ec\u00a0\u0111\u00e3 gi\u1ea3m\u00a0\u0111\u01b0\u1ee3c h\u01a1n 100 tri\u1ec7u ti\u1ec1n l\u00e3i r\u1ed3i.<\/p>\n<p>Qua b\u00e0i h\u1ecdc n\u00e0y, ch\u00fang ta h\u1ecdc th\u00eam\u00a0\u0111\u01b0\u1ee3c k\u1ef9 n\u0103ng ph\u00e2n t\u00edch kho\u1ea3n vay v\u00e0 vi\u1ec7c thanh to\u00e1n kho\u1ea3n vay nh\u1edd v\u00e0o c\u00e1c h\u00e0m PMT trong\u00a0Excel.\u00a0\u0110\u00e2y l\u00e0 k\u1ef9 n\u0103ng c\u01a1 b\u1ea3n nh\u01b0ng r\u1ea5t quan tr\u1ecdng m\u00e0 khi l\u00e0m vi\u1ec7c\u00a0\u1edf m\u1ea3ng t\u00e0i ch\u00ednh ch\u00fang ta\u00a0\u0111\u1ec1u c\u1ea7n ph\u1ea3i n\u1eafm\u00a0\u0111\u01b0\u1ee3c.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng H\u1ecdc\u00a0Excel Online!<\/p>\n<p>T\u1ea3i v\u1ec1: <a href=\"https:\/\/drive.google.com\/open?id=17ceLngYwLa58Rs32a9bhTUbeEAN92V3Y\">File k\u00e8m theo b\u00e0i h\u1ecdc<\/a><\/p>\n<p>\u00c1p d\u1ee5ng Excel v\u00e0o t\u00e0i ch\u00ednh v\u00e0 k\u1ebf to\u00e1n gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u c\u00f4ng vi\u1ec7c trong th\u1eddi gian ng\u1eafn v\u00e0 v\u1edbi s\u1ed1 li\u1ec7u ch\u00ednh x\u00e1c h\u01a1n. \u0110\u1ec3 \u00e1p d\u1ee5ng th\u00e0nh th\u1ea1o Excel v\u00e0o l\u0129nh v\u1ef1c t\u00e0i ch\u00ednh, k\u1ebf to\u00e1n, c\u00e1c b\u1ea1n c\u1ea7n hi\u1ec3u v\u00e0 n\u1eafm r\u1ea5t r\u00f5 t\u00ednh n\u0103ng c\u1ee7a c\u00e1c h\u00e0m, c\u00f4ng c\u1ee5 trong Excel.<\/p>\n<p>B\u1ea1n tham kh\u1ea3o kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2w6YAe8\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\" target=\"_blank\" rel=\"noopener\">HocExcel.Online<\/a><\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-114.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3452,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-3451","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\/3451","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=3451"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3451\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3452"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3451"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3451"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3451"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}