{"id":3514,"date":"2024-12-03T02:45:11","date_gmt":"2024-12-03T02:45:11","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-cach-lap-bang-tinh-lai-suat-vay-tieu-dung-theo-du-no-giam-dan-tren-excel\/"},"modified":"2024-12-03T02:45:11","modified_gmt":"2024-12-03T02:45:11","slug":"huong-dan-cach-lap-bang-tinh-lai-suat-vay-tieu-dung-theo-du-no-giam-dan-tren-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-cach-lap-bang-tinh-lai-suat-vay-tieu-dung-theo-du-no-giam-dan-tren-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp b\u1ea3ng t\u00ednh l\u00e3i su\u1ea5t vay ti\u00eau d\u00f9ng theo d\u01b0 n\u1ee3 gi\u1ea3m d\u1ea7n tr\u00ean Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Ch\u1eafc h\u1eb3n b\u1ea1n kh\u00f4ng l\u1ea1 g\u00ec v\u1edbi nh\u1eefng l\u1eddi m\u1eddi vay ti\u00eau d\u00f9ng c\u1ee7a ng\u00e2n h\u00e0ng. Nh\u01b0ng b\u1ea1n l\u1ea1i\u00a0kh\u00f4ng c\u00f3\u00a0\u0111\u1ee7 ki\u1ebfn th\u1ee9c t\u00e0i ch\u00ednh\u00a0\u0111\u1ec3 t\u1ef1 tay t\u00ednh to\u00e1n\u00a0\u0111\u01b0\u1ee3c s\u1ed1 l\u00e3i ph\u1ea3i tr\u1ea3 tr\u00ean 1 h\u1ee3p\u00a0\u0111\u1ed3ng vay l\u00e0 bao nhi\u00eau, li\u1ec7u l\u1eddi m\u1eddi c\u1ee7a ng\u00e2n h\u00e0ng c\u00f3 th\u1ef1c s\u1ef1 h\u1ea5p d\u1eabn? H\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc\u00a0Excel Online<\/strong> <\/a>l\u1eadp <strong>b\u1ea3ng\u00a0t\u00ednh l\u00e3i su\u1ea5t vay ti\u00eau d\u00f9ng<\/strong> theo d\u01b0 n\u1ee3 gi\u1ea3m d\u1ea7n tr\u00ean Excel\u00a0\u0111\u1ec3 hi\u1ec3u r\u00f5 v\u1ea5n\u00a0\u0111\u1ec1 n\u00e0y nh\u00e9.<\/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-674e70b67bb68\" 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\/huong-dan-cach-lap-bang-tinh-lai-suat-vay-tieu-dung-theo-du-no-giam-dan-tren-excel.html#Xac_dinh_cac_thong_so_trong_hop_dong_vay\" title=\"X\u00e1c\u00a0\u0111\u1ecbnh c\u00e1c th\u00f4ng s\u1ed1 trong h\u1ee3p\u00a0\u0111\u1ed3ng vay\">X\u00e1c\u00a0\u0111\u1ecbnh c\u00e1c th\u00f4ng s\u1ed1 trong h\u1ee3p\u00a0\u0111\u1ed3ng vay<\/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\/huong-dan-cach-lap-bang-tinh-lai-suat-vay-tieu-dung-theo-du-no-giam-dan-tren-excel.html#Quy_doi_de_thong_nhat_don_vi_tinh_cho_cac_thong_so\" title=\"Quy\u00a0\u0111\u1ed5i\u00a0\u0111\u1ec3 th\u1ed1ng nh\u1ea5t\u00a0\u0111\u01a1n v\u1ecb t\u00ednh cho c\u00e1c th\u00f4ng s\u1ed1\">Quy\u00a0\u0111\u1ed5i\u00a0\u0111\u1ec3 th\u1ed1ng nh\u1ea5t\u00a0\u0111\u01a1n v\u1ecb t\u00ednh cho c\u00e1c th\u00f4ng s\u1ed1<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-lap-bang-tinh-lai-suat-vay-tieu-dung-theo-du-no-giam-dan-tren-excel.html#He_so_quy_doi\" title=\"H\u1ec7 s\u1ed1 quy\u00a0\u0111\u1ed5i:\">H\u1ec7 s\u1ed1 quy\u00a0\u0111\u1ed5i:<\/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\/huong-dan-cach-lap-bang-tinh-lai-suat-vay-tieu-dung-theo-du-no-giam-dan-tren-excel.html#Phuong_phap_quy_doi\" title=\"Ph\u01b0\u01a1ng ph\u00e1p quy\u00a0\u0111\u1ed5i\">Ph\u01b0\u01a1ng ph\u00e1p quy\u00a0\u0111\u1ed5i<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-lap-bang-tinh-lai-suat-vay-tieu-dung-theo-du-no-giam-dan-tren-excel.html#Bang_chi_tiet_ke_hoach_tra_vay\" title=\"B\u1ea3ng chi ti\u1ebft k\u1ebf ho\u1ea1ch tr\u1ea3 vay\">B\u1ea3ng chi ti\u1ebft k\u1ebf ho\u1ea1ch tr\u1ea3 vay<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-lap-bang-tinh-lai-suat-vay-tieu-dung-theo-du-no-giam-dan-tren-excel.html#Ky\" title=\"K\u1ef3\">K\u1ef3<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-lap-bang-tinh-lai-suat-vay-tieu-dung-theo-du-no-giam-dan-tren-excel.html#No_dau_ky\" title=\"N\u1ee3\u00a0\u0111\u1ea7u k\u1ef3\">N\u1ee3\u00a0\u0111\u1ea7u k\u1ef3<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-lap-bang-tinh-lai-suat-vay-tieu-dung-theo-du-no-giam-dan-tren-excel.html#Goc\" title=\"G\u1ed1c\">G\u1ed1c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-lap-bang-tinh-lai-suat-vay-tieu-dung-theo-du-no-giam-dan-tren-excel.html#Lai\" title=\"L\u00e3i\">L\u00e3i<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-lap-bang-tinh-lai-suat-vay-tieu-dung-theo-du-no-giam-dan-tren-excel.html#Tong_phai_tra\" title=\"T\u1ed5ng ph\u1ea3i tr\u1ea3\">T\u1ed5ng ph\u1ea3i tr\u1ea3<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-lap-bang-tinh-lai-suat-vay-tieu-dung-theo-du-no-giam-dan-tren-excel.html#No_cuoi_ky\" title=\"N\u1ee3 cu\u1ed1i k\u1ef3\">N\u1ee3 cu\u1ed1i k\u1ef3<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Xac_dinh_cac_thong_so_trong_hop_dong_vay\"><\/span>X\u00e1c\u00a0\u0111\u1ecbnh c\u00e1c th\u00f4ng s\u1ed1 trong h\u1ee3p\u00a0\u0111\u1ed3ng vay<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>M\u1ed7i m\u1ed9t h\u1ee3p\u00a0\u0111\u1ed3ng vay\u00a0\u0111\u1ec1u c\u00f3 s\u1eb5n m\u1ed9t v\u00e0i th\u00f4ng s\u1ed1 c\u01a1 b\u1ea3n\u00a0\u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n r\u00f5 r\u00e0ng, c\u1ee5 th\u1ec3. Vi\u1ec7c\u00a0\u0111\u1ea7u ti\u00ean l\u00e0 ch\u00fang ta c\u1ea7n ghi l\u1ea1i c\u00e1c th\u00f4ng s\u1ed1\u00a0\u0111\u00f3\u00a0\u0111\u1ec3 l\u00e0m c\u0103n c\u1ee9 t\u00ednh to\u00e1n. C\u00e1c th\u00f4ng s\u1ed1 n\u00e0y c\u00f3 th\u1ec3 thay\u00a0\u0111\u1ed5i theo t\u1eebng lo\u1ea1i h\u1ee3p\u00a0\u0111\u1ed3ng, n\u00ean ch\u00fang ta c\u1ea7n tr\u00ecnh b\u00e0y sao cho c\u00e1c con s\u1ed1 n\u00e0y c\u0169ng c\u00f3 th\u1ec3 thay\u00a0\u0111\u1ed5i\u00a0\u0111\u01b0\u1ee3c.<\/p>\n<p>Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/lam-the-nao-de-tinh-lai-kep-trong-excel-cong-thuc-cho-tinh-lai-kep-ngay-thang-nam.html\"><strong>C\u00f4ng th\u1ee9c t\u00ednh l\u00e3i k\u00e9p<\/strong><\/a> trong excel v\u00f4 c\u00f9ng d\u1ec5 d\u00e0ng v\u00e0 \u0111\u01a1n gi\u1ea3n<\/p>\n<p>V\u00ed d\u1ee5 b\u1ea1n x\u00e9t 1 h\u1ee3p\u00a0\u0111\u1ed3ng bao g\u1ed3m c\u00e1c y\u1ebfu t\u1ed1 sau:<\/p>\n<ul>\n<li>S\u1ed1 ti\u1ec1n d\u1ef1\u00a0\u0111\u1ecbnh vay l\u00e0 100 tri\u1ec7u\u00a0\u0111\u1ed3ng<\/li>\n<li>Th\u1eddi gian vay trong 4 n\u0103m<\/li>\n<li>G\u1ed1c v\u00e0 l\u00e3i tr\u1ea3 d\u1ea7n theo th\u00e1ng<\/li>\n<li>L\u00e3i su\u1ea5t ph\u1ea3i tr\u1ea3 l\u00e0 16%\/n\u0103m<\/li>\n<li>Ph\u01b0\u01a1ng ph\u00e1p t\u00ednh l\u00e3i theo\u00a0d\u01b0 n\u1ee3 gi\u1ea3m d\u1ea7n<\/li>\n<\/ul>\n<p>H\u00e3y m\u1edf 1 file\u00a0Excel l\u00ean v\u00e0 tr\u00ecnh b\u00e0y nh\u1eefng n\u1ed9i dung n\u00e0y n\u00e0o:<\/p>\n<figure id=\"attachment_22419\" aria-describedby=\"caption-attachment-22419\" style=\"width: 560px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-22419 size-full\" title=\"C\u00e1ch t\u00ednh l\u00e3i su\u1ea5t vay ti\u00eau d\u00f9ng tr\u00ean excel 4\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/khai-bao-thong-so-chua-format-cells.png\" alt=\"C\u00e1ch t\u00ednh l\u00e3i su\u1ea5t vay ti\u00eau d\u00f9ng tr\u00ean excel 4\" width=\"560\" height=\"209\"><figcaption id=\"caption-attachment-22419\" class=\"wp-caption-text\">C\u00e1ch t\u00ednh l\u00e3i su\u1ea5t vay ti\u00eau d\u00f9ng tr\u00ean excel 4<\/figcaption><\/figure>\n<p>C\u00e1c th\u00f4ng s\u1ed1 b\u1ea1n c\u1ea7n nh\u1eadp ri\u00eang v\u00e0o t\u1eebng\u00a0\u00f4,\u00a0\u0111\u1ec3 khi c\u1ea7n thay\u00a0\u0111\u1ed5i th\u00f4ng s\u1ed1 n\u00e0o ch\u00fang ta s\u1ebd thay\u00a0\u0111\u1ed5i t\u1ea1i ri\u00eang\u00a0\u00f4\u00a0\u0111\u00f3.<\/p>\n<p>\u0110\u1ecbnh d\u1ea1ng c\u00e1c d\u1eef li\u1ec7u 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-271.gif\" title=\"ex101_92019-nho-271\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>A1:C1 ch\u1ecdn <strong>Styles<\/strong> l\u00e0 <strong>Heading1<\/strong><\/li>\n<li>D\u00f2ng 1 c\u00f3 <strong>Row height<\/strong>= 24 (40 pixels)<\/li>\n<li>D\u00f2ng 2\u00a0\u0111\u1ebfn d\u00f2ng 6 \u00a0c\u00f3 <strong>Row height<\/strong>=\u00a015.6 (26 pixels)<\/li>\n<li>C\u1ed9t A c\u00f3\u00a0 Column\u00a0Width = 22 (205 pixels)<\/li>\n<li>C\u1ed9t B c\u00f3 Column\u00a0Width = 14 (133 pixels)<\/li>\n<li>C\u1ed9t C c\u00f3 Column\u00a0Width = 8 (79 pixels)<\/li>\n<\/ul>\n<p>Thi\u1ebft l\u1eadp <strong>Data Validation<\/strong> t\u1ea1i c\u00e1c\u00a0\u00f4 <strong>C3, B4, C5<\/strong> l\u00e0:<\/p>\n<ul>\n<li>Allow=List<\/li>\n<li>Source=Th\u00e1ng, Qu\u00fd, N\u0103m<\/li>\n<\/ul>\n<figure id=\"attachment_22420\" aria-describedby=\"caption-attachment-22420\" style=\"width: 1053px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-22420 size-full\" title=\"C\u00e1ch t\u00ednh l\u00e3i su\u1ea5t vay ti\u00eau d\u00f9ng tr\u00ean excel 5\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data-validation-thang-quy-nam.png\" alt=\"C\u00e1ch t\u00ednh l\u00e3i su\u1ea5t vay ti\u00eau d\u00f9ng tr\u00ean excel 5\" width=\"1053\" height=\"418\"><figcaption id=\"caption-attachment-22420\" class=\"wp-caption-text\">C\u00e1ch t\u00ednh l\u00e3i su\u1ea5t vay ti\u00eau d\u00f9ng tr\u00ean excel 5<\/figcaption><\/figure>\n<p>C\u00e1c\u00a0\u00f4 <strong>B2:B6, C3, C5<\/strong> ch\u1ecdn <strong>Cell Styles<\/strong> l\u00e0<strong> Input<\/strong>\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u00e2y s\u1ebd l\u00e0 n\u01a1i\u00a0\u0111\u1ec3 nh\u1eadp d\u1eef li\u1ec7u<\/p>\n<figure id=\"attachment_22421\" aria-describedby=\"caption-attachment-22421\" style=\"width: 1172px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-22421 size-full\" title=\"C\u00e1ch t\u00ednh l\u00e3i su\u1ea5t vay ti\u00eau d\u00f9ng tr\u00ean excel 6\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cells-styles-input.png\" alt=\"C\u00e1ch t\u00ednh l\u00e3i su\u1ea5t vay ti\u00eau d\u00f9ng tr\u00ean excel 6\" width=\"1172\" height=\"373\"><figcaption id=\"caption-attachment-22421\" class=\"wp-caption-text\">C\u00e1ch t\u00ednh l\u00e3i su\u1ea5t vay ti\u00eau d\u00f9ng tr\u00ean excel 6<\/figcaption><\/figure>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta\u00a0\u0111\u00e3 thi\u1ebft l\u1eadp xong ph\u1ea7n Khai b\u00e1o th\u00f4ng s\u1ed1. V\u1edbi m\u1ed7i 1 ph\u01b0\u01a1ng\u00a0\u00e1n vay kh\u00e1c nhau, ho\u1eb7c c\u00f3 s\u1ef1 thay\u00a0\u0111\u1ed5i c\u1ee7a b\u1ea5t k\u1ef3 1 th\u00f4ng s\u1ed1 n\u00e0o th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 thay\u00a0\u0111\u1ed5i tr\u1ef1c ti\u1ebfp v\u00e0o c\u00e1c v\u00f9ng\u00a0\u00f4 t\u1eeb B2:C6.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Quy_doi_de_thong_nhat_don_vi_tinh_cho_cac_thong_so\"><\/span>Quy\u00a0\u0111\u1ed5i\u00a0\u0111\u1ec3 th\u1ed1ng nh\u1ea5t\u00a0\u0111\u01a1n v\u1ecb t\u00ednh cho c\u00e1c th\u00f4ng s\u1ed1<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ch\u00fang ta th\u1ea5y :<\/p>\n<ul>\n<li><strong>Th\u1eddi gian vay<\/strong> (C3) v\u00e0<strong> l\u00e3i su\u1ea5t<\/strong> (C5) t\u00ednh theo\u00a0\u0111\u01a1n v\u1ecb l\u00e0 <strong>N\u0103m<\/strong><\/li>\n<li><strong>K\u1ef3 tr\u1ea3 l\u00e3i<\/strong> (\u00f4 B4) l\u1ea1i t\u00ednh theo\u00a0\u0111\u01a1n v\u1ecb l\u00e0 <strong>Th\u00e1ng<\/strong><\/li>\n<\/ul>\n<p>Do\u00a0\u0111\u00f3 vi\u1ec7c c\u1ea7n l\u00e0m ti\u1ebfp theo l\u00e0 quy\u00a0\u0111\u1ed5i v\u1ec1\u00a0\u0111\u1ed3ng nh\u1ea5t\u00a0\u0111\u01a1n v\u1ecb. Khi\u00a0\u0111\u00f3 ch\u00fang ta m\u1edbi c\u00f3 th\u1ec3 t\u00ednh\u00a0\u0111\u00fang\u00a0\u0111\u01b0\u1ee3c.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"He_so_quy_doi\"><\/span>H\u1ec7 s\u1ed1 quy\u00a0\u0111\u1ed5i:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>1 N\u0103m = 12 Th\u00e1ng<\/li>\n<li>1 Qu\u00fd =\u00a03 th\u00e1ng<\/li>\n<li>1 N\u0103m = 4 Qu\u00fd<\/li>\n<\/ul>\n<p>Ta c\u00f3 b\u1ea3ng quy\u00a0\u0111\u1ed5i nh\u01b0 sau:<\/p>\n<figure id=\"attachment_22422\" aria-describedby=\"caption-attachment-22422\" style=\"width: 544px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-22422 size-full\" title=\"C\u00e1ch t\u00ednh l\u00e3i su\u1ea5t vay ti\u00eau d\u00f9ng tr\u00ean excel 3\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bang-quy-doi-he-so-thang-quy-nam.png\" alt=\"C\u00e1ch t\u00ednh l\u00e3i su\u1ea5t vay ti\u00eau d\u00f9ng tr\u00ean excel 3\" width=\"544\" height=\"264\"><figcaption id=\"caption-attachment-22422\" class=\"wp-caption-text\">C\u00e1ch t\u00ednh l\u00e3i su\u1ea5t vay ti\u00eau d\u00f9ng tr\u00ean excel 3<\/figcaption><\/figure>\n<p>B\u1ea3ng quy\u00a0\u0111\u1ed5i n\u00e0y c\u00f3 th\u1ec3\u00a0\u0111\u1eb7t t\u1ea1i\u00a0\u00f4<strong> I1:L10<\/strong> t\u1eeb c\u1ed9t <strong>\u0110\u01a1n v\u1ecb 1<\/strong> \u0111\u1ebfn c\u1ed9t <strong>H\u1ec7 s\u1ed1<\/strong>\u00a0(ri\u00eang c\u1ed9t <strong>C\u00e1ch nh\u1eadp<\/strong> l\u00e0 di\u1ec5n gi\u1ea3i c\u00e1ch nh\u1eadp ra h\u1ec7 s\u1ed1, kh\u00f4ng c\u1ea7n nh\u1eadp l\u1ea1i n\u1ed9i dung c\u1ed9t n\u00e0y)<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Phuong_phap_quy_doi\"><\/span>Ph\u01b0\u01a1ng ph\u00e1p quy\u00a0\u0111\u1ed5i<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Quy v\u1ec1\u00a0\u0111\u01a1n v\u1ecb t\u1ea1i <strong>B4<\/strong> (l\u00e0m c\u0103n c\u1ee9 quy\u00a0\u0111\u1ed5i)<\/p>\n<p>\u00a0<\/p>\n<figure id=\"attachment_22424\" aria-describedby=\"caption-attachment-22424\" style=\"width: 775px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-22424 size-full\" title=\"C\u00e1ch t\u00ednh l\u00e3i su\u1ea5t vay ti\u00eau d\u00f9ng tr\u00ean excel 2\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bang-tinh-quy-doi-he-so-01.png\" alt=\"C\u00e1ch t\u00ednh l\u00e3i su\u1ea5t vay ti\u00eau d\u00f9ng tr\u00ean excel 2\" width=\"775\" height=\"212\"><figcaption id=\"caption-attachment-22424\" class=\"wp-caption-text\">C\u00e1ch t\u00ednh l\u00e3i su\u1ea5t vay ti\u00eau d\u00f9ng tr\u00ean excel 2<\/figcaption><\/figure>\n<p>C\u00e1c\u00a0\u00f4<strong> E3:G3<\/strong> v\u00e0 <strong>E5:G5<\/strong>\u00a0\u0111\u1ecbnh d\u1ea1ng <strong>Cells Styles<\/strong> l\u00e0 <strong>Calculation<\/strong><\/p>\n<p>Ta c\u00f3:<\/p>\n<ul>\n<li>E3=B4 (h\u1ec7 s\u1ed1 quy\u00a0\u0111\u1ed5i th\u1ee9 1)<\/li>\n<li>E5=B4 (h\u1ec7 s\u1ed1 quy\u00a0\u0111\u1ed5i th\u1ee9 1)<\/li>\n<li>F3=VLOOKUP(E3&amp;C3,$K$2:$L$10,2,0)\u00a0\u0110\u1ed1i t\u01b0\u1ee3ng t\u00ecm ki\u1ebfm c\u1ee7a h\u00e0m Vlookup l\u00e0 gh\u00e9p h\u1ec7 s\u1ed1 quy\u00a0\u0111\u1ed5i t\u1ea1i 2\u00a0\u00f4 E3 v\u1edbi C3, trong\u00a0\u0111\u00f3 E3 l\u00e0 h\u1ec7 s\u1ed1 1, C3 l\u00e0 h\u1ec7 s\u1ed1 2; v\u00f9ng b\u1ea3ng tham chi\u1ebfu l\u00e0 b\u1ea3ng quy\u00a0\u0111\u1ed5i, trong 2 c\u1ed9t <strong>Gh\u00e9p<\/strong> v\u00e0 <strong>H\u1ec7 s\u1ed1<\/strong><\/li>\n<li>G3=B3*F3 l\u00e0 t\u1ed5ng s\u1ed1 k\u1ef3\u00a0\u0111\u01b0\u1ee3c quy\u00a0\u0111\u1ed5i<\/li>\n<li>F5=VLOOKUP(E5&amp;C5,$K$2:$L$10,2,0) t\u01b0\u01a1ng t\u1ef1 nh\u01b0 F3<\/li>\n<li>G5=B5\/F5 l\u00e0 l\u00e3i su\u1ea5t\u00a0\u0111\u01b0\u1ee3c quy\u00a0\u0111\u1ed5i<\/li>\n<\/ul>\n<p>(\u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n t\u1ea1i sao l\u00e0 ph\u00e9p chia th\u00ec vui l\u00f2ng xem l\u1ea1i b\u1ea3ng h\u1ec7 s\u1ed1 quy\u00a0\u0111\u1ed5i)<\/p>\n<p>Sau khi\u00a0\u0111\u00e3 th\u1ed1ng nh\u1ea5t v\u1ec1 1\u00a0\u0111\u01a1n v\u1ecb, ch\u00fang ta c\u00f3 th\u1ec3 b\u1eaft\u00a0\u0111\u1ea7u ti\u1ebfn h\u00e0nh x\u00e2y d\u1ef1ng b\u1ea3ng t\u00ednh l\u00e3i cho kho\u1ea3n vay nh\u01b0 sau:<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Bang_chi_tiet_ke_hoach_tra_vay\"><\/span>B\u1ea3ng chi ti\u1ebft k\u1ebf ho\u1ea1ch tr\u1ea3 vay<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Khi x\u00e9t k\u1ebf ho\u1ea1ch tr\u1ea3 vay, ch\u00fang ta c\u1ea7n\u00a0\u0111\u00e1nh gi\u00e1 tr\u00ean 1 s\u1ed1 y\u1ebfu t\u1ed1 sau:<\/p>\n<ul>\n<li>K\u1ef3: l\u00e0 m\u1ed7i l\u1ea7n th\u1ef1c hi\u1ec7n tr\u1ea3 g\u1ed1c + l\u00e3i.\u00a0 S\u1ed1 k\u1ef3 x\u00e1c\u00a0\u0111\u1ecbnh d\u1ef1a theo T\u1ed5ng th\u1eddi gian vay (G3) v\u00e0\u00a0K\u1ef3 tr\u1ea3 l\u00e3i (B4)<\/li>\n<li>N\u1ee3\u00a0\u0111\u1ea7u k\u1ef3: S\u1ed1 ti\u1ec1n vay g\u1ed1c c\u00f2n l\u1ea1i\u00a0\u1edf\u00a0\u0111\u1ea7u m\u1ed7i k\u1ef3 = N\u1ee3 cu\u1ed1i k\u1ef3 tr\u01b0\u1edbc\u00a0\u0111\u00f3<\/li>\n<li>G\u1ed1c: S\u1ed1 ti\u1ec1n tr\u1ea3 t\u00ednh v\u00e0o g\u1ed1c t\u1ea1i k\u1ef3\u00a0\u0111\u00f3 = T\u1ed5ng s\u1ed1 ti\u1ec1n vay \/ T\u1ed5ng s\u1ed1 k\u1ef3 tr\u1ea3 vay\u00a0\u0111\u00e3 quy\u00a0\u0111\u1ed5i<\/li>\n<li>L\u00e3i: S\u1ed1 ti\u1ec1n l\u00e3i ph\u1ea3i tr\u1ea3 t\u1ea1i k\u1ef3\u00a0\u0111\u00f3 = N\u1ee3\u00a0\u0111\u1ea7u k\u1ef3 * L\u00e3i su\u1ea5t vay \u0111\u00e3 quy\u00a0\u0111\u1ed5i<\/li>\n<li>T\u1ed5ng ph\u1ea3i tr\u1ea3: =G\u1ed1c + L\u00e3i<\/li>\n<li>N\u1ee3 cu\u1ed1i k\u1ef3: S\u1ed1 ti\u1ec1n c\u00f2n l\u1ea1i t\u1ea1i cu\u1ed1i k\u1ef3<\/li>\n<\/ul>\n<figure id=\"attachment_22430\" aria-describedby=\"caption-attachment-22430\" style=\"width: 1216px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-22430 size-full\" title=\"C\u00e1ch t\u00ednh l\u00e3i su\u1ea5t vay ti\u00eau d\u00f9ng tr\u00ean excel 1\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bo-cuc-bang-tinh-lai-vay.png\" alt=\"C\u00e1ch t\u00ednh l\u00e3i su\u1ea5t vay ti\u00eau d\u00f9ng tr\u00ean excel 1\" width=\"1216\" height=\"352\"><figcaption id=\"caption-attachment-22430\" class=\"wp-caption-text\">C\u00e1ch t\u00ednh l\u00e3i su\u1ea5t vay ti\u00eau d\u00f9ng tr\u00ean excel 1<\/figcaption><\/figure>\n<p>C\u00e1ch\u00a0\u0111\u1ecbnh d\u1ea1ng:<\/p>\n<ul>\n<li>A11:F11 \u2013 Cell Styles \u2013 Heading 1 (ho\u1eb7c Heading 2 t\u00f9y b\u1ea1n ch\u1ecdn)<\/li>\n<li>A12:F12 \u2013 Cell Styles \u2013 Heading\u00a03<\/li>\n<li>A12:F12: C\u0103n l\u1ec1 ph\u1ea3i<\/li>\n<\/ul>\n<p>C\u00e1ch t\u00ednh c\u00e1c ch\u1ec9 ti\u00eau nh\u01b0 sau:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ky\"><\/span>K\u1ef3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>T\u1ea1i A13 nh\u1eadp s\u1ed1 1, b\u1edfi k\u1ef3 lu\u00f4n b\u1eaft\u00a0\u0111\u1ea7u t\u1eeb 1<\/li>\n<li>A14\u00a0\u0111\u1eb7t c\u00f4ng th\u1ee9c: N\u1ebfu A13+1 l\u1edbn h\u01a1n t\u1ed5ng s\u1ed1 k\u1ef3 t\u1ea1i\u00a0\u00f4 G3 th\u00ec cho gi\u00e1 tr\u1ecb r\u1ed7ng, n\u1ebfu kh\u00f4ng l\u1edbn h\u01a1n G3 th\u00ec t\u00ednh theo A13+1. Ch\u00fa\u00a0\u00fd c\u1ed1\u00a0\u0111\u1ecbnh v\u1ecb tr\u00ed\u00a0\u00f4 G3<\/li>\n<li>A15 tr\u1edf\u00a0\u0111i: Filldown c\u00f4ng th\u1ee9c t\u1eeb A14 xu\u1ed1ng<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\">A14=IF(A13+1&gt;$G$3,\u201d\u201d,A13+1)<\/p>\n<p>Ch\u00fa\u00a0\u00fd: N\u1ebfu k\u1ef3 tr\u01b0\u1edbc\u00a0\u0111\u00f3\u00a0\u0111\u00e3 r\u1ed7ng th\u00ec kh\u00f4ng x\u00e9t c\u00e1c k\u1ef3 sau\u00a0\u0111\u00f3 n\u1eefa. Do\u00a0\u0111\u00f3 c\u00f4ng th\u1ee9c ho\u00e0n ch\u1ec9nh l\u00e0:<\/p>\n<p style=\"padding-left: 60px\">A14=IF(A13=\u201d\u201d,\u201d\u201d,IF(A13+1&gt;$G$3,\u201d\u201d,A13+1))<\/p>\n<h3><span class=\"ez-toc-section\" id=\"No_dau_ky\"><\/span>N\u1ee3\u00a0\u0111\u1ea7u k\u1ef3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u1ea1i k\u1ef3 1:\u00a0\u00f4 B13<\/p>\n<p style=\"padding-left: 30px\">Kho\u1ea3n vay g\u1ed1c ban\u00a0\u0111\u1ea7u<\/p>\n<p style=\"padding-left: 30px\">B13=$B$2<\/p>\n<p>T\u1ea1i k\u1ef3 2:\u00a0\u00f4 B14<\/p>\n<p style=\"padding-left: 30px\">N\u1ee3\u00a0\u0111\u1ea7u k\u1ef3 2 = N\u1ee3 cu\u1ed1i k\u1ef3 1<\/p>\n<p style=\"padding-left: 30px\">B14=F13<\/p>\n<p>L\u01b0u\u00a0\u00fd: N\u1ebfu tr\u01b0\u1eddng h\u1ee3p kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng\u00a0\u1ee9ng\u00a0\u1edf c\u1ed9t A (K\u1ef3) th\u00ec s\u1ebd kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb\u00a0\u1edf c\u00e1c c\u1ed9t c\u00f2n l\u1ea1i. Do\u00a0\u0111\u00f3 ph\u1ea3i x\u00e9t th\u00eam tr\u01b0\u1eddng h\u1ee3p n\u00e0y tr\u01b0\u1edbc khi t\u00ednh. Do\u00a0\u0111\u00f3:<\/p>\n<p style=\"padding-left: 30px\">B13=IF(A13=\u201d\u201d,\u201d\u201d,$B$2)<\/p>\n<p style=\"padding-left: 30px\">B14=IF(A14=\u201d\u201d,\u201d\u201d,F13)<\/p>\n<p>T\u1eeb B15 tr\u1edf\u00a0\u0111i: Filldown c\u00f4ng th\u1ee9c t\u1eeb B14 xu\u1ed1ng<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Goc\"><\/span>G\u1ed1c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u1ea1i k\u1ef3 1:\u00a0\u00f4 C13<\/p>\n<p style=\"padding-left: 30px\">T\u1ed5ng kho\u1ea3n vay (B2) chia cho T\u1ed5ng s\u1ed1 k\u1ef3 vay (G3)<\/p>\n<p style=\"padding-left: 30px\">C13=$B$2\/$G$3<\/p>\n<p>L\u01b0u\u00a0\u00fd: N\u1ebfu tr\u01b0\u1eddng h\u1ee3p kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng\u00a0\u1ee9ng\u00a0\u1edf c\u1ed9t A (K\u1ef3) th\u00ec s\u1ebd kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb\u00a0\u1edf c\u00e1c c\u1ed9t c\u00f2n l\u1ea1i. Do\u00a0\u0111\u00f3 ph\u1ea3i x\u00e9t th\u00eam tr\u01b0\u1eddng h\u1ee3p n\u00e0y tr\u01b0\u1edbc khi t\u00ednh. Do\u00a0\u0111\u00f3:<\/p>\n<p style=\"padding-left: 30px\">C13=IF(A13=\u201d\u201d,\u201d\u201d,$B$2\/$G$3)<\/p>\n<p>T\u1eeb C14 tr\u1edf\u00a0\u0111i: Filldown c\u00f4ng th\u1ee9c t\u1eeb\u00a0C13 xu\u1ed1ng<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Lai\"><\/span>L\u00e3i<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>L\u00e3i = N\u1ee3\u00a0\u0111\u1ea7u k\u1ef3 * L\u00e3i su\u1ea5t vay \u0111\u00e3 quy\u00a0\u0111\u1ed5i, ch\u00fa\u00a0\u00fd c\u1ed1\u00a0\u0111\u1ecbnh v\u1ecb tr\u00ed tham chi\u1ebfu\u00a0\u00f4 G5<\/p>\n<p style=\"padding-left: 30px\">D13=B13*$G$5<\/p>\n<p>L\u01b0u\u00a0\u00fd: N\u1ebfu tr\u01b0\u1eddng h\u1ee3p kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng\u00a0\u1ee9ng\u00a0\u1edf c\u1ed9t A (K\u1ef3) th\u00ec s\u1ebd kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb\u00a0\u1edf c\u00e1c c\u1ed9t c\u00f2n l\u1ea1i. Do\u00a0\u0111\u00f3 ph\u1ea3i x\u00e9t th\u00eam tr\u01b0\u1eddng h\u1ee3p n\u00e0y tr\u01b0\u1edbc khi t\u00ednh. Do\u00a0\u0111\u00f3:<\/p>\n<p style=\"padding-left: 30px\">D13=IF(A13=\u201d\u201d,\u201d\u201d,B13*$G$5)<\/p>\n<p>T\u1eeb D14 tr\u1edf\u00a0\u0111i: Filldown c\u00f4ng th\u1ee9c t\u1eeb D13 xu\u1ed1ng<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tong_phai_tra\"><\/span>T\u1ed5ng ph\u1ea3i tr\u1ea3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>=G\u1ed1c + L\u00e3i<\/p>\n<p style=\"padding-left: 30px\">E13=IF(A13=\u201d\u201d,\u201d\u201d,C13+D13)<\/p>\n<p>T\u1eeb E14 tr\u1edf\u00a0\u0111i: Filldown c\u00f4ng th\u1ee9c t\u1eeb E13 xu\u1ed1ng<\/p>\n<h3><span class=\"ez-toc-section\" id=\"No_cuoi_ky\"><\/span>N\u1ee3 cu\u1ed1i k\u1ef3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>=N\u1ee3\u00a0\u0111\u1ea7u k\u1ef3 \u2013\u00a0N\u1ee3 g\u1ed1c<\/p>\n<p style=\"padding-left: 30px\">F13=IF(A13=\u201d\u201d,\u201d\u201d,B13-C13)<\/p>\n<p>T\u1eeb F14 tr\u1edf\u00a0\u0111i: Filldown c\u00f4ng th\u1ee9c t\u1eeb F13 xu\u1ed1ng<\/p>\n<p>K\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng ta c\u00f3 nh\u01b0 sau:<\/p>\n<figure id=\"attachment_22431\" aria-describedby=\"caption-attachment-22431\" style=\"width: 625px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-22431 size-full\" title=\"C\u00e1ch t\u00ednh l\u00e3i su\u1ea5t vay ti\u00eau d\u00f9ng tr\u00ean excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ke-hoach-tra-vay.png\" alt=\"C\u00e1ch t\u00ednh l\u00e3i su\u1ea5t vay ti\u00eau d\u00f9ng tr\u00ean excel\" width=\"625\" height=\"687\"><figcaption id=\"caption-attachment-22431\" class=\"wp-caption-text\">C\u00e1ch t\u00ednh l\u00e3i su\u1ea5t vay ti\u00eau d\u00f9ng tr\u00ean excel<\/figcaption><\/figure>\n<p>Ch\u00fa\u00a0\u00fd: Filldown t\u1edbi s\u1ed1 k\u1ef3 l\u1edbn h\u01a1n gi\u00e1 tr\u1ecb\u00a0\u1edf\u00a0\u00f4 G3<\/p>\n<p>\u0110\u1ec3 t\u00ednh t\u1ed5ng s\u1ed1 ti\u1ec1n g\u1ed1c, l\u00e3i, ch\u00fang ta c\u00f3 th\u1ec3\u00a0\u0111\u1eb7t c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng tr\u00ean d\u00f2ng 11, t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi c\u00e1c c\u1ed9t<\/p>\n<p>Nh\u01b0 v\u1eady l\u00e0 ch\u00fang ta\u00a0\u0111\u00e3 ho\u00e0n th\u00e0nh <strong>b\u1ea3ng\u00a0t\u00ednh l\u00e3i su\u1ea5t vay ti\u00eau d\u00f9ng<\/strong> theo d\u01b0 n\u1ee3 gi\u1ea3m d\u1ea7n tr\u00ean Excel r\u1ed3i. H\u00e3y th\u1eed thay\u00a0\u0111\u1ed5i c\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n th\u00f4ng s\u1ed1\u00a0\u0111\u1ec3 xem b\u1ea3ng t\u00ednh c\u1ee7a ch\u00fang ta thay\u00a0\u0111\u1ed5i th\u1ebf n\u00e0o nh\u00e9.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng!<\/p>\n<p>T\u1ea3i file m\u1eabu k\u00e8m theo b\u00e0i vi\u1ebft t\u1ea1i\u00a0\u0111\u1ecba ch\u1ec9:\u00a0<a href=\"http:\/\/bit.ly\/2N4p19Q\">http:\/\/bit.ly\/2N4p19Q<\/a><\/p>\n<p>Xem th\u00eam:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-tai-chinh-va-cach-su-dung-cac-ham-tai-chinh-trong-excel-full.html\">H\u00e0m t\u00e0i ch\u00ednh v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m t\u00e0i ch\u00ednh trong Excel, Full<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/excel-voi-tai-chinh-ham-pmt-tinh-tien-thanh-toan-hang-ky-cho-khoan-vay.html\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m PMT t\u00ednh s\u1ed1 ti\u1ec1n thanh to\u00e1n h\u00e0ng k\u1ef3 cho kho\u1ea3n vay trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/excel-tai-chinh-phan-tich-tra-no-goc-va-lai-cung-chuoi-ham-pmt.html\">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<\/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\/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-271.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3515,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-3514","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\/3514","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=3514"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3514\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3515"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3514"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3514"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3514"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}