{"id":7936,"date":"2024-12-21T18:59:02","date_gmt":"2024-12-21T18:59:02","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/3-cach-dem-so-o-trong-trong-excel\/"},"modified":"2024-12-21T18:59:02","modified_gmt":"2024-12-21T18:59:02","slug":"3-cach-dem-so-o-trong-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/3-cach-dem-so-o-trong-trong-excel\/","title":{"rendered":"3 c\u00e1ch \u0111\u1ebfm s\u1ed1 \u00f4 tr\u1ed1ng trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">N\u1ebfu c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n l\u00e0 \u0111\u1ec3 Excel t\u00ednh c\u00e1c \u00f4 tr\u1ed1ng trong b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh, h\u00e3y \u0111\u1ecdc b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec3 t\u00ecm 3 c\u00e1ch \u0111\u1ec3 th\u1ef1c hi\u1ec7n n\u00f3. T\u00ecm hi\u1ec3u c\u00e1ch t\u00ecm ki\u1ebfm v\u00e0 ch\u1ecdn \u00f4 tr\u1ed1ng b\u1eb1ng <strong><em>Go to Special<\/em><\/strong>, s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/find-va-replace-nang-cao-trong-excel-cach-su-dung-hieu-qua-nhat.html\" target=\"_blank\" rel=\"noopener noreferrer\"><em>Find and Replace <\/em><\/a>\u0111\u1ec3 t\u00ednh kho\u1ea3ng tr\u1ed1ng ho\u1eb7c nh\u1eadp c\u00f4ng th\u1ee9c trong Excel 2010-2016.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n l\u00e0 nh\u00e0 cung \u1ee9ng cho r\u1ea5t nhi\u1ec1u c\u1eeda h\u00e0ng. B\u1ea1n c\u00f3 m\u1ed9t trang t\u00ednh Excel v\u1edbi t\u00ean c\u1eeda h\u00e0ng, s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng h\u1ecd b\u00e1n. M\u1ed9t v\u00e0i \u00f4 t\u00ednh trong c\u1ed9t H\u00e0ng b\u00e1n b\u1ecf tr\u1ed1ng.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-count-blanks-sample.png\" alt=\"Count blank cells in excel 2010-2013\" title=\"excel-count-blanks-sample\"><\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u1ea7n \u0111\u1ebfm s\u1ed1 \u00f4 tr\u1ed1ng, t\u00ecm v\u00e0 ch\u1ecdn ch\u00fang \u0111\u1ec3 xem x\u00e9t c\u00f3 bao nhi\u00eau c\u1eeda h\u00e0ng kh\u00f4ng cung c\u1ea5p th\u00f4ng tin c\u1ea7n thi\u1ebft cho c\u00f4ng ty b\u1ea1n. Ti\u1ebfn h\u00e0nh thao t\u00e1c n\u00e0y theo c\u00e1ch th\u1ee7 c\u00f4ng kh\u00e1 t\u1ed1n th\u1eddi gian, v\u00ec v\u1eady h\u00e3y l\u1ef1a ch\u1ecdn m\u1ed9t trong nh\u1eefng c\u00e1ch \u0111\u1ec1 ra trong b\u00e0i vi\u1ebft n\u00e0y.<\/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-67670ff5c603b\" 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-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/3-cach-dem-o-trong-trong-excel.html#1_Tim_o_trong_voi_Go_to_Special\" title=\"1. T\u00ecm \u00f4 tr\u1ed1ng v\u1edbi Go to Special\">1. T\u00ecm \u00f4 tr\u1ed1ng v\u1edbi Go to Special<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/3-cach-dem-o-trong-trong-excel.html#2Tim_o_trong_voi_Find_and_Replace\" title=\"2.T\u00ecm \u00f4 tr\u1ed1ng v\u1edbi Find and Replace\">2.T\u00ecm \u00f4 tr\u1ed1ng v\u1edbi Find and Replace<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/3-cach-dem-o-trong-trong-excel.html#3_Tim_o_trong_voi_cong_thuc_dac_biet\" title=\"3. T\u00ecm \u00f4 tr\u1ed1ng v\u1edbi c\u00f4ng th\u1ee9c \u0111\u1eb7c bi\u1ec7t\">3. T\u00ecm \u00f4 tr\u1ed1ng v\u1edbi c\u00f4ng th\u1ee9c \u0111\u1eb7c bi\u1ec7t<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"1_Tim_o_trong_voi_Go_to_Special\"><\/span><strong>1. T\u00ecm \u00f4 tr\u1ed1ng v\u1edbi Go to Special<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>1.1. Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u tr\u1ed1ng trong b\u1ea3ng v\u00e0 nh\u1ea5n ph\u00edm <strong>F5<\/strong> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <em><strong>Go to<\/strong><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-goto-dialog.png\" alt=\"Press F5 on your keyboard to get the Go To dialog box\" title=\"excel-goto-dialog\"><\/em><\/p>\n<p>1.2. Nh\u1ea5n <strong>Alt + S<\/strong> \u0111\u1ec3 m\u1edf c\u1eeda s\u1ed5 <em><strong>Go To Special &gt; Blanks &gt; OK<\/strong><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-goto-special-blanks.png\" alt=\"Select the Blanks radio button on the Go To Special window\" title=\"excel-goto-special-blanks\"><\/em><\/p>\n<p>1.3. C\u00e1c \u00f4 tr\u1ed1ng t\u00ecm th\u1ea5y \u0111\u01b0\u1ee3c highlight trong b\u1ea3ng bi\u1ec3u.<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-goto-special-results.png\" alt=\"See the empty cells highlighted in your table\" title=\"excel-goto-special-results\"><\/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-327.gif\" title=\"vba101_92019-nho-327\"><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-713.gif\" title=\"ex101_92019-nho-713\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><strong>L\u01b0u \u00fd. <\/strong>B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <strong><em>Fill Color <\/em><\/strong>\u1edf tab <strong><em>Home<\/em><\/strong> \u0111\u1ec3 thay \u0111\u1ed5i m\u00e0u cho nh\u1eefng \u00f4 tr\u1ed1ng n\u00e0y.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/goto-special-blanks-background.png\" alt=\"Change the background of empty cells to keep the selection\" title=\"goto-special-blanks-background\"><\/p>\n<p style=\"text-align: justify\">H\u00e3y nh\u1edb r\u1eb1ng <strong><em>Go to Special <\/em><\/strong>\u00a0s\u1ebd kh\u00f4ng nh\u1eadn bi\u1ebft c\u00e1c \u00f4 tr\u1ed1ng c\u00f3 s\u1eed d\u1ee5ng ph\u00edm c\u00e1ch ho\u1eb7c nh\u1eefng \u00f4 c\u00f3 c\u00f4ng th\u1ee9c l\u00e0m tr\u1ed1ng (pseudo-blank cells).<\/p>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"2Tim_o_trong_voi_Find_and_Replace\"><\/span><strong>2.T\u00ecm \u00f4 tr\u1ed1ng v\u1edbi Find and Replace<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>2.1. Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n \u0111\u1ebfm s\u1ed1 \u00f4 tr\u1ed1ng v\u00e0 nh\u1ea5n <strong>Ctrl + F<\/strong>. L\u01b0u \u00fd: N\u1ebfu b\u1ea1n ch\u1ecdn m\u1ed9t \u00f4 t\u00ednh, <a href=\"http:\/\/blog.ezworkapp.com\/find-va-replace-nang-cao-trong-excel-cach-su-dung-hieu-qua-nhat.html\" target=\"_blank\" rel=\"noopener noreferrer\"><strong><em>Find &amp; Replace <\/em><\/strong><\/a>s\u1ebd t\u00ecm ki\u1ebfm tr\u00ean to\u00e0n b\u1ed9 b\u1ea3ng.<\/p>\n<p>2.2. \u0110\u1ec3 tr\u1ed1ng \u00f4 <em><strong>Find what<\/strong>.<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/find-replace-entire-cell.png\" alt=\"Select the Match entire cell contents checkbox\" title=\"find-replace-entire-cell\"><\/em><\/p>\n<p>2.4. Ch\u1ecdn <strong><em>Formulas <\/em><\/strong>ho\u1eb7c <strong><em>Values <\/em><\/strong>t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn <em><strong>Look in<\/strong>.<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/find-replace-lookin.png\" alt=\"Pick the Values or Formulas item from the Look in: drop-down list\" title=\"find-replace-lookin\"> <\/em><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n ch\u1ecdn t\u00ecm <strong><em>Values<\/em><\/strong>, c\u00f4ng c\u1ee5 s\u1ebd \u0111\u1ebfm t\u1ea5t c\u1ea3 c\u00e1c \u00f4 tr\u1ed1ng bao g\u1ed3m c\u1ea3 <em><strong>pseudo-blank cells<\/strong><\/em>.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n ch\u1ecdn t\u00ecm <em><strong>Formulas<\/strong>, <\/em>c\u00f4ng c\u1ee5 ch\u1ec9 \u0111\u1ebfm nh\u1eefng \u00f4 tr\u1ed1ng kh\u00f4ng ph\u1ea3i <em><strong>pseudo-blank cells<\/strong><\/em>.<\/p>\n<p style=\"text-align: justify\">3.5. Nh\u1ea5n <strong><em>Find All <\/em><\/strong>\u0111\u1ec3 xem k\u1ebft qu\u1ea3. S\u1ed1 \u00f4 tr\u1ed1ng s\u1ebd hi\u1ec3n th\u1ecb \u1edf g\u00f3c d\u01b0\u1edbi b\u00ean tr\u00e1i.<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/find-replace-results-pane.png\" alt=\"Get the number of blanks on the Find and Replace window\" title=\"find-replace-results-pane\"><\/p>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"3_Tim_o_trong_voi_cong_thuc_dac_biet\"><\/span><strong>3. T\u00ecm \u00f4 tr\u1ed1ng v\u1edbi c\u00f4ng th\u1ee9c \u0111\u1eb7c bi\u1ec7t<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c \u201c<em><strong>=COUNTBLANKS()<\/strong><\/em>\u201d s\u1ebd hi\u1ec3n th\u1ecb s\u1ed1 \u00f4 tr\u1ed1ng bao g\u1ed3m pseudo-blank cells.<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c \u201c=<em><strong>ROWS()*COLUMNS()-COUNTA()<\/strong><\/em>\u201d cho k\u1ebft qu\u1ea3 t\u1ea5t c\u1ea3 nh\u1eefng \u00f4 th\u1eadt s\u1ef1 tr\u1ed1ng, t\u1ee9c l\u00e0 kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb, kh\u00f4ng c\u00f3 c\u00f4ng th\u1ee9c l\u00e0m tr\u1ed1ng \u00f4 t\u00ednh.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y, h\u00e3y th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p style=\"text-align: justify\">3.1. Ch\u1ecdn b\u1ea5t k\u1ef3 \u00f4 tr\u1ed1ng n\u00e0o trong trang t\u00ednh.<\/p>\n<p style=\"text-align: justify\">3.2. Nh\u1eadp \u201c<em><strong>=COUNTBLANKS()<\/strong><\/em>\u201d ho\u1eb7c \u201c<em><strong>=ROWS()*COLUMNS()-COUNTA()<\/strong><\/em>\u201d v\u00e0o thanh c\u00f4ng th\u1ee9c.<\/p>\n<p style=\"text-align: justify\">3.3. Sau \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp \u0111\u1ecba ch\u1ec9 v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n \u0111\u1ebfm \u00f4 tr\u1ed1ng v\u00e0o kho\u1ea3ng gi\u1eefa d\u1ea5u ngo\u1eb7c trong c\u00f4ng th\u1ee9c; ho\u1eb7c \u0111\u1eb7t con tr\u1ecf chu\u1ed9t gi\u1eefa c\u00e1c d\u1ea5u ngo\u1eb7c v\u00e0 ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n thi\u1ebft tr\u00ean trang t\u00ednh. B\u1ea1n s\u1ebd th\u1ea5y \u0111\u1ecba ch\u1ec9 v\u00f9ng t\u1ef1 \u0111\u1ed9ng xu\u1ea5t hi\u1ec7n trong c\u00f4ng th\u1ee9c.<\/p>\n<p style=\"text-align: justify\">3.4. Nh\u1ea5n Enter. B\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 trong \u00f4 \u0111\u00e3 ch\u1ecdn.<\/p>\n<p style=\"text-align: justify\">Trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y, ch\u00fang t\u00f4i xin tr\u00ecnh b\u00e0y t\u00f3m t\u1eaft c\u00e1ch s\u1eed d\u1ee5ng hai c\u00f4ng th\u1ee9c n\u00e0y. T\u00f4i ch\u1ecdn 4 \u00f4 t\u00ednh. A2 c\u00f3 m\u1ed9t gi\u00e1 tr\u1ecb, A3 c\u00f3 m\u1ed9t c\u00f4ng th\u1ee9c l\u00e0m tr\u1ed1ng \u00f4, A4 ho\u00e0n to\u00e0n r\u1ed7ng v\u00e0 A5 ch\u1ee9a hai d\u1ea5u c\u00e1ch. B\u00ean d\u01b0\u1edbi v\u00f9ng d\u1eef li\u1ec7u, s\u1ed1 \u00f4 \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y hi\u1ec3n th\u1ecb k\u1ebf b\u00ean c\u00f4ng th\u1ee9c \u0111\u00e3 thi\u1ebft l\u1eadp.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/count-blanks-formula-summary.png\" alt=\"See how 2 different formulas work with constants and pseudo-blank cells\" title=\"count-blanks-formula-summary\"><\/p>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch t\u00ecm v\u00e0 \u0111\u1ebfm c\u00e1c \u00f4 tr\u1ed1ng trong b\u1ea3ng Excel c\u1ee7a m\u00ecnh. S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00ednh to\u00e1n s\u1ed1 \u00f4 tr\u1ed1ng, <a href=\"http:\/\/blog.ezworkapp.com\/find-va-replace-nang-cao-trong-excel-cach-su-dung-hieu-qua-nhat.html\" target=\"_blank\" rel=\"noopener noreferrer\"><em>Find and Replace<\/em><\/a> \u0111\u1ec3 \u0111\u00e1nh d\u1ea5u kho\u1ea3ng tr\u1ed1ng, \u0111i\u1ec1u h\u01b0\u1edbng \u0111\u1ebfn ch\u00fang v\u00e0 \u0111\u1ebfm s\u1ed1 \u00f4, ho\u1eb7c ch\u1ecdn t\u00ednh n\u0103ng <em>Go To Special<\/em> \u0111\u1ec3 nhanh ch\u00f3ng ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c kho\u1ea3ng tr\u1eafng trong b\u1ea3ng c\u1ee7a b\u1ea1n. Vui l\u00f2ng chia s\u1ebb b\u1ea5t k\u1ef3 g\u1ee3i \u00fd n\u00e0o kh\u00e1c m\u00e0 b\u1ea1n c\u00f3.<\/p>\n<p style=\"text-align: justify\"><em><strong>Ngu\u1ed3n:<\/strong> Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi Hocexcel Online.<\/em><\/p>\n<p style=\"text-align: left\">\u0110\u1ec3 s\u1eed d\u1ee5ng Excel \u1edf m\u1ee9c Th\u00e0nh th\u1ea1o, b\u1ea1n ph\u1ea3i m\u1ea5t h\u00e0ng th\u00e1ng \u0111\u1ec3 nghi\u00ean c\u1ee9u v\u00e0 th\u1ef1c h\u00e0nh, do Excel c\u00f3 r\u1ea5t nhi\u1ec1u h\u00e0m, c\u00f4ng c\u1ee5 v\u00e0 ch\u1ee9c n\u0103ng. Tuy nhi\u00ean, n\u1ebfu h\u1ecdc c\u00f3 h\u1ec7 th\u1ed1ng v\u00e0 luy\u1ec7n t\u1eadp h\u00e0ng ng\u00e0y, ch\u1eafc ch\u1eafn ch\u1ec9 sau m\u1ed9t v\u00e0i tu\u1ea7n, tr\u00ecnh \u0111\u1ed9 s\u1eed d\u1ee5ng Excel c\u1ee7a b\u1ea1n s\u1ebd t\u0103ng l\u00ean nhanh ch\u00f3ng. Hi\u1ec7n t\u1ea1i H\u1ecdc Excel Online c\u00f3 kh\u00f3a h\u1ecdc\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\/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-327.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7937,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7936","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\/7936","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=7936"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7936\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7937"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7936"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7936"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7936"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}