{"id":11155,"date":"2025-01-15T01:53:26","date_gmt":"2025-01-15T01:53:26","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/10-tips-de-tao-mot-report-xuat-sac-tren-excel\/"},"modified":"2025-01-15T01:53:26","modified_gmt":"2025-01-15T01:53:26","slug":"10-tips-de-tao-mot-report-xuat-sac-tren-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/10-tips-de-tao-mot-report-xuat-sac-tren-excel\/","title":{"rendered":"10 Tips \u0110\u1ec3 T\u1ea1o M\u1ed9t Report Xu\u1ea5t S\u1eafc Tr\u00ean Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>\u0110i\u1ec1u g\u00ec th\u1ef1c s\u1ef1 t\u1ea1o n\u00ean m\u1ed9t b\u1ea3ng b\u00e1o c\u00e1o xu\u1ea5t s\u1eafc? L\u00e0 do ki\u1ebfn th\u1ee9c chuy\u00ean m\u00f4n hay k\u0129 n\u0103ng c\u1ee7a b\u1ea1n?<\/p>\n<p>N\u1ebfu b\u1ea1n \u0111ang l\u00e0m vi\u1ec7c trong ngh\u00e0nh t\u00e0i ch\u00ednh, b\u1ea1n s\u1ebd ph\u1ea3i l\u1eadp b\u00e1o c\u00e1o r\u1ea5t th\u01b0\u1eddng xuy\u00ean. V\u00e0 c\u00f3 l\u1ebd kh\u00f4ng sai khi n\u00f3i r\u1eb1ng m\u1ed9t ng\u00e0y c\u1ee7a b\u1ea1n b\u1eaft \u0111\u1ea7u v\u00e0 k\u1ebft th\u00fac ch\u1ec9 xoay quanh c\u00e1c b\u1ea3n b\u00e1o c\u00e1o, bi\u1ec3u \u0111\u1ed3, dashboards tr\u00ean Excel.<\/p>\n<p>C\u00f3 m\u1ed9t nghi\u00ean c\u1ee9u \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n b\u1edfi APQC v\u1ec1 \u201ck\u1ef9 thu\u1eadt n\u00e0o m\u00e0 h\u1ea7u h\u1ebft c\u00e1c b\u1ed9 ph\u1eadn FP&amp;A s\u1eed d\u1ee5ng khi l\u00e0m vi\u1ec7c ?\u201d.<\/p>\n<p>Theo nh\u01b0 k\u1ebft qu\u1ea3 nghi\u00ean c\u1ee9u th\u00ec kho\u1ea3ng 39% l\u00e0 l\u00e0m vi\u1ec7c v\u1edbi trang t\u00ednh v\u00e0 56% l\u00e0 k\u1ebft h\u1ee3p trang t\u00ednh v\u1edbi c\u00e1c ph\u1ea7n m\u1ec1m chuy\u00ean m\u00f4n kh\u00e1c.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9779 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/21-09-01.jpeg\" width=\"600\" height=\"277\" title=\"21-09-01\"><\/p>\n<p><strong>V\u1eady r\u00fat ra \u0111i\u1ec1u g\u00ec t\u1eeb nghi\u00ean c\u1ee9u n\u00e0y?<\/strong><\/p>\n<p>\u0110\u00f3 l\u00e0 d\u00f9 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0o th\u00ec c\u00e1c b\u1ea3ng b\u00e1o c\u00e1o trong Excl c\u0169ng r\u1ea5t quan tr\u1ecdng cho vi\u1ec7c ph\u00e2n t\u00edch v\u00e0 tr\u00ecnh b\u00e0y d\u1eef li\u1ec7u.<\/p>\n<p>Tips \u0111\u1ec3 t\u1ea1o ra nh\u1eefng b\u1ea3ng b\u00e1o c\u00e1o trong Excel<\/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\/2025\/01\/ex101_92019-nho-264.gif\" title=\"ex101_92019-nho-264\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9780 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/21-09-02.jpeg\" width=\"618\" height=\"1024\" title=\"21-09-02\"><\/p>\n<p>T\u1ea1o b\u00e1o c\u00e1o tr\u00ean Excel\u00a0 l\u00e0 k\u1ef9 n\u0103ng m\u1edbi m\u00e0 h\u1ea7u h\u1ebft c\u00e1c nh\u00e0 tuy\u1ec3n d\u1ee5ng \u0111ang t\u00ecm ki\u1ebfm; v\u00ec v\u1eady h\u00e3y \u0111\u1ea7u t\u01b0 m\u1ed9t \u00edt th\u1eddi gian \u0111\u1ec3 l\u00e0m quen v\u1edbi n\u00f3.<\/p>\n<ol>\n<li><strong>Ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng file cho workbook \u2013 gi\u00fap t\u0103ng t\u1ed1c \u0111\u1ed9 t\u00ednh to\u00e1n v\u00e0 ti\u1ebft ki\u1ec7m \u0111\u1ebfn 73,65% b\u1ed9 nh\u1edb.<\/strong><\/li>\n<\/ol>\n<p>B\u1ea1n c\u00f3 bi\u1ebft r\u1eb1ng ch\u1ecdn \u0111\u00fang lo\u1ea1i file workbook c\u00f3 th\u1ec3 b\u1ea3o v\u1ec7 d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n kh\u1ecfi nh\u1eefng l\u1ed7i h\u01b0 h\u1ecfng trong t\u01b0\u01a1ng lai. \u0110i\u1ec1u n\u00e0y th\u1ef1c s\u1ef1 \u0111\u00fang v\u00e0 n\u00f3 \u0111\u00e3 \u0111\u01b0\u1ee3c ki\u1ec3m ch\u1ee9ng b\u1edfi c\u00e1c chuy\u00ean gia.<\/p>\n<p>Theo kinh nghi\u1ec7m\u00a0 c\u1ee7a r\u1ea5t nhi\u1ec1u online reviews th\u00ec vi\u1ec7c l\u01b0u excel report v\u1edbi \u0111\u1ecbnh d\u1ea1ng file \u201c.xlsb\u201d (excel binary workbook)\u00a0s\u1ebd l\u00e0m gi\u1ea3m k\u00edch c\u1ee1 workbook v\u00e0 quan tr\u1ecdng h\u01a1n n\u1eefa l\u00e0 n\u00f3 h\u1ed7 tr\u1ee3 cho t\u1ea5t c\u1ea3.<\/p>\n<p>V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n c\u00f3 m\u1ed9t l\u01b0\u1ee3ng d\u1eef li\u1ec7u kh\u1ed5ng l\u1ed3 trong report c\u1ee7a m\u00ecnh v\u00e0 b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng macros \u0111\u1ec3 khi\u1ebfn n\u00f3 linh ho\u1ea1t h\u01a1n th\u00ec l\u1ef1a ch\u1ecdn l\u00fd t\u01b0\u1edfng c\u1ee7a b\u1ea1n n\u00ean l\u00e0 \u0111\u1ecbnh d\u1ea1ng binary workbook (d\u1ea1ng nh\u1ecb ph\u00e2n).<\/p>\n<p><strong>V\u1eady t\u1ec7p nh\u1ecb ph\u00e2n l\u00e0 g\u00ec?<\/strong><\/p>\n<p>Trong m\u00e1y t\u00ednh th\u00ec c\u1ee5m t\u1eeb nh\u1ecb ph\u00e2n c\u00f3 ngh\u0129a l\u00e0 ch\u1ec9 \u0111\u1ea1o cho m\u00e1y ch\u1ea1y d\u1ef1a tr\u00ean d\u00e3y s\u1ed1 \u20180\u2019 v\u00e0 \u20181\u2019.<\/p>\n<p>Nh\u01b0 v\u1eady, n\u1ebfu l\u01b0u v\u1edbi d\u1ea1ng file n\u00e0y c\u00f3 nh\u0129a l\u00e0 b\u1ea1n \u0111ang l\u01b0u d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh d\u01b0\u1edbi d\u1ea1ng \u20180\u2019 v\u00e0 \u20181\u2019 thay v\u00ec to\u00e0n b\u1ed9 v\u0103n b\u1ea3n trong b\u1ed9 nh\u1edb. N\u00f3 gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian loading v\u00e0 b\u1ed9 nh\u1edb.<\/p>\n<blockquote>\n<p>\u0110\u1eebng b\u1ecf l\u1ee1: <a href=\"http:\/\/blog.ezworkapp.com\">Kh\u00f3a h\u1ecdc word excel<\/a><\/p>\n<\/blockquote>\n<p><strong>T\u1ea1i sao b\u1ea1n n\u00ean s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng binary cho workbook?<\/strong><\/p>\n<p>C\u00e2u tr\u1ea3 l\u1eddi n\u1eb1m \u1edf b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9781 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/21-09-03.jpeg\" width=\"697\" height=\"334\" title=\"21-09-03\"><\/p>\n<p><strong>\u0110i\u1ec3m h\u1ea1n ch\u1ebf<\/strong><\/p>\n<p>Binary workbook kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng trong Excel 2003 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n tr\u01b0\u1edbc<\/p>\n<p>C\u00f3 th\u1ec3 sinh ra m\u1ed9t v\u00e0i l\u1ed7i khi tra c\u1ee9u t\u1eeb c\u00e1c file c\u00f3 \u0111\u1ecbnh d\u1ea1ng kh\u00e1c b\u1edfi s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng v\u00e0 c\u1ed9t<\/p>\n<p><strong>2.Version control \u2013 H\u1ecdc c\u00e1ch sao l\u01b0u d\u1eef li\u1ec7u<\/strong><\/p>\n<p>T\u01b0\u1edfng t\u01b0\u1ee3ng r\u1eb1ng n\u1ebfu nh\u01b0 b\u1ea1n c\u00f3 deadline d\u00e0y \u0111\u1eb7c v\u00e0 b\u1ea1n l\u00e0m vi\u1ec7c r\u1ea5t ch\u0103m ch\u1ec9 \u0111\u1ec3 ho\u00e0n th\u00e0nh n\u00f3, nh\u01b0ng \u0111\u1ed9t nhi\u00ean excel x\u1ea3y ra l\u1ed7i v\u00e0 \u0111\u00f3ng tr\u01b0\u1edbc khi b\u1ea1n k\u1ecbp l\u01b0u. V\u1eady \u0111i\u1ec1u g\u00ec s\u1ebd x\u1ea3y ra?<\/p>\n<p>Ch\u1eafc ch\u1eafn b\u1ea1n s\u1ebd ph\u1ea3i l\u00e0m l\u1ea1i.<\/p>\n<p><strong>V\u1eady version control l\u00e0 g\u00ec?<\/strong><\/p>\n<p>VC l\u00e0 ph\u01b0\u01a1ng ph\u00e1p l\u01b0u tr\u1eef d\u1eef li\u1ec7u thay \u0111\u1ed5i g\u1ea7n \u0111\u00e2y trong m\u1ed9t file v\u00e0 c\u00f3 th\u1ec3 l\u1ea5y l\u1ea1i b\u1ea5t c\u1ee9 khi n\u00e0o b\u1ea1n mu\u1ed1n. VC th\u01b0\u1eddng xuy\u00ean \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong ng\u00e0nh IT, tuy nhi\u00ean, ch\u00fang ta c\u0169ng c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng n\u00f3 n\u1ebfu bi\u1ebft s\u1eed d\u1ee5ng \u0111\u00fang c\u00e1ch.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9782 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/21-09-04.jpeg\" width=\"557\" height=\"306\" title=\"21-09-04\"><\/p>\n<p>B\u1ea1n ch\u1ec9 c\u1ea7n \u0111\u01a1n gi\u1ea3n t\u1ea1o m\u1ed9t folder n\u01a1i ch\u1ee9a t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3n \u0111\u00e3 l\u01b0u v\u00e0 \u0111\u1eb7t t\u00ean cho n\u00f3 \u0111\u1ec3 hi\u1ec3u l\u00e0 \u201cb\u1ea3n sao l\u01b0u\u201d. R\u1ed3i h\u00e3y l\u01b0u b\u1ea3n copy m\u1edbi nh\u1ea5t v\u00e0o folder \u0111\u00f3. T\u01b0\u01a1ng t\u1ef1, b\u1ea5t c\u1ee9 khi n\u00e0o b\u1ea1n thay \u0111\u1ed5i hay updates, b\u1ea1n ph\u1ea3i \u201cSave as\u201d v\u00e0 l\u01b0u theo th\u1ee9 t\u1ef1 v1 hay v2 hay v3\u2026<\/p>\n<p>B\u1eb1ng c\u00e1ch l\u00e0m n\u00e0y, b\u1ea1n s\u1ebd l\u01b0u \u0111\u01b0\u1ee3c h\u1ea7u h\u1ebft c\u00e1c b\u1ea3n theo th\u1ee9 t\u1ef1, v\u00ec v\u1eady b\u1ea1n c\u00f3 th\u1ec3 xem l\u1ea1i v\u00e0 ch\u1ecdn b\u1ea3n m\u00ecnh mu\u1ed1n.<\/p>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 c\u00e1ch luy\u1ec7n t\u1eadp<\/p>\n<ul>\n<li>Khi l\u00e0m vi\u1ec7c v\u1edbi report m\u1edbi, h\u00e3y l\u01b0u tr\u01b0\u1edbc khi l\u00e0m<\/li>\n<li>Lu\u00f4n c\u00f3 th\u00f3i quen Ctl+S , b\u1ea1n c\u1ea7n ph\u1ea3i luy\u1ec7n t\u1eadp \u0111\u1ec3 ng\u00f3n tay s\u1ebd t\u1ef1 \u0111\u1ed9ng l\u00e0m vi\u1ec7c<\/li>\n<li>Quan tr\u1ecdng l\u00e0 ph\u1ea3i c\u00f3 backup folder v\u00e0 th\u1ef1c hi\u1ec7n l\u01b0u c\u00e1c phi\u00ean b\u1ea3n<\/li>\n<li>C\u00f3 th\u00f3i quen s\u1eed d\u1ee5ng ph\u01b0\u01a1ng ph\u00e1p version control \u0111\u1ec3 ng\u0103n vi\u1ec7c m\u1ea5t d\u1eef li\u1ec7u<\/li>\n<\/ul>\n<ol start=\"3\">\n<li><strong>D\u00f9ng m\u00e0u \u0111\u1ec3 ph\u00e2n bi\u1ec7t \u00f4 d\u1eef li\u1ec7u v\u00e0 \u00f4 c\u00f4ng th\u1ee9c<\/strong><\/li>\n<\/ol>\n<p>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ph\u00e2n bi\u1ec7t \u00f4 c\u00f4ng th\u1ee9c v\u00e0 \u00f4 d\u1eef li\u1ec7u \u0111\u1ec3 tr\u00e1nh l\u00e0m lo\u1ea1n c\u00e1c c\u00f4ng th\u1ee9c t\u00ednh. S\u1ebd th\u1ebf n\u00e0o n\u1ebfu ng\u01b0\u1eddi kh\u00e1c v\u00f4 t\u00ecnh x\u00f3a c\u00e1c c\u00f4ng th\u1ee9c trong b\u00e1o c\u00e1o c\u1ee7a b\u1ea1n?<\/p>\n<p><strong>Gi\u1ea3i ph\u00e1p<\/strong><\/p>\n<p>H\u1ea7u h\u1ebft c\u00e1c chuy\u00ean gia s\u1eed d\u1ee5ng m\u00e0u v\u00e0ng \u201clight yellow\u201d \u0111\u1ec3 ch\u1ec9 \u00f4 ch\u1ee9a d\u1eef li\u1ec7u, n\u01a1i ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 nh\u1eadp d\u1eef li\u1ec7u.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9783 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/21-09-05.png\" width=\"769\" height=\"249\" title=\"21-09-05\"><\/p>\n<p>V\u00e0 s\u1eed d\u1ee5ng m\u00e0u b\u1ea1c \u201clight gray\u2019 \u0111\u1ec3 b\u00f4i v\u00e0o c\u00e1c \u00f4 c\u00f4ng th\u1ee9c, kh\u00f4ng \u0111\u01b0\u1ee3c s\u1eeda.<\/p>\n<p><strong>M\u1ed9t v\u00e0i tips<\/strong><\/p>\n<ul>\n<li>H\u00e3y t\u00e2n d\u1ee5ng \u00a0ch\u1ee9c n\u0103ng conditional formatting<\/li>\n<li>D\u00f9ng m\u00e0u xanh l\u00e1 \u201cgreen\u201d cho s\u1ef1 t\u0103ng v\u00e0 m\u00e0u \u0111\u1ecf \u201cred\u201d cho s\u1ef1 gi\u1ea3m<\/li>\n<li>H\u00e3y t\u1ea1o ra c\u00e1c bi\u1ec3u \u0111\u1ed3 \u0111\u1ea7y m\u00e0u s\u1eafc<\/li>\n<li>B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng color patterns (b\u1ea3ng m\u00e0u) \u0111\u1ec3 l\u00e0m \u0111\u1eb9p cho report c\u1ee7a m\u00ecnh, nh\u01b0ng \u0111\u1eebng l\u1ea1m d\u1ee5ng qu\u00e1.<\/li>\n<\/ul>\n<ol start=\"4\">\n<li><strong>X\u00f3a b\u1ecf nh\u1eefng fomulas kh\u00f4ng mong mu\u1ed1n<\/strong><\/li>\n<\/ol>\n<p>S\u1eed d\u1ee5ng qu\u00e1 nhi\u1ec1u c\u00f4ng th\u1ee9c c\u00f3 th\u1ec3 g\u00e2y ra l\u1ed7i tr\u00ecnh b\u00e0y trong b\u1ea3n b\u00e1o c\u00e1o c\u1ee7a b\u1ea1n. V\u00ed d\u1ee5, b\u1ea1n d\u00f9ng h\u00e0m vlookup \u0111\u1ec3 k\u00e9o d\u1eef li\u1ec7u t\u1eeb workbook kh\u00e1c nh\u01b0ng l\u1ea1i qu\u00ean x\u00f3a n\u00f3 \u0111i.<\/p>\n<p>Nh\u1eefng fomulas kh\u00f4ng c\u1ea7n thi\u1ebft s\u1ebd l\u00e0m report ch\u1ea1y ch\u1eadm h\u01a1n v\u00e0 m\u1ea5t th\u1eddi gian t\u00ednh to\u00e1n. T\u1ec7 nh\u1ea5t l\u00e0 crash report khi n\u00f3 \u0111ang l\u00e0m vi\u1ec7c.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9784 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/21-09-06.jpeg\" width=\"598\" height=\"277\" title=\"21-09-06\"><\/p>\n<p><strong>Gi\u1ea3i ph\u00e1p<\/strong><\/p>\n<ul>\n<li>\u0110\u1eebng gi\u1eef nh\u1eefng fomulas kh\u00f4ng c\u1ea7n thi\u1ebft- d\u00f9ng paste special ho\u1eb7c ch\u1ec9 convert gi\u00e1 tr\u1ecb.<\/li>\n<li>Kh\u00f4ng copy c\u00f4ng th\u1ee9c t\u1eeb workbook n\u00e0y sang workbook kh\u00e1c- n\u1ebfu l\u00e0m v\u1eady c\u00e1c fomulas s\u1ebd ch\u1ee9a nhi\u1ec1u \u00f4 th\u1eeba<\/li>\n<li>C\u1ea9n th\u1eadn v\u1edbi c\u00e1c h\u00e0m nh\u01b0 RAND &amp; RANDBETWEEN v\u00ec n\u00f3 s\u1ebd random s\u1ed1 m\u1ed7i khi b\u1ea1n \u1ea5n refresh hay l\u01b0u report<\/li>\n<\/ul>\n<ol start=\"5\">\n<li><strong>Excel Array formulas- ch\u1ec9 s\u1eed d\u1ee5ng khi kh\u00f4ng c\u00f2n l\u1ef1a ch\u1ecdn n\u00e0o kh\u00e1c<\/strong><\/li>\n<\/ol>\n<p>C\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng (array fomulas) l\u00e0 nh\u1eefng c\u00f4ng th\u1ee9c tinh vi nh\u1ea5t trong excel, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 bi\u1ec3u di\u1ec5n c\u00e1c ph\u00e9p t\u00ednh ph\u1ee9c t\u1ea1p v\u1edbi m\u1ed9t ho\u1eb7c hai \u0111i\u1ec1u ki\u1ec7n.<\/p>\n<p>Kho\u1ea3ng 95% ng\u01b0\u1eddi d\u00f9ng kh\u00f4ng bi\u1ebft \u0111\u1ebfn CSE (Ctrl+Shift+Enter) or Array formulas, V\u00ec v\u1eady h\u00e3y d\u00e0nh th\u1eddi gian h\u1ecdc v\u1ec1 n\u00f3<\/p>\n<p>C\u00f3 r\u1ea5t nhi\u1ec1u l\u1ee3i \u00edch khi s\u1eed d\u1ee5ng array formulas, nh\u01b0ng kh\u00f4ng gi\u1ed1ng nh\u01b0 c\u00e1c h\u00e0m kh\u00e1c, ch\u00fang c\u00f3 th\u1ec3 m\u1ea5t ki\u1ec3m so\u00e1t n\u1ebfu b\u1ea1n kh\u00f4ng c\u1ea9n th\u1eadn.<\/p>\n<p>Khi d\u00f9ng h\u00e0m n\u00e0y trong report, n\u00f3 c\u00f3 th\u1ec3 khi\u1ebfn m\u00e1y b\u1ea1n m\u1ea5t 3-4 ph\u00fat update hay refresh<\/p>\n<p>V\u00ec v\u1eady, s\u1ebd t\u1ed1t h\u01a1n n\u1ebfu b\u1ea1n bi\u1ebft khi n\u00e0o v\u00e0 \u1edf \u0111\u00e2u n\u00ean s\u1eed d\u1ee5ng h\u00e0m n\u00e0y \u0111\u1ec3 kh\u00f4ng ph\u1ea3i t\u1ed1n th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c.<\/p>\n<blockquote>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/tag\/hoc-excel-2007\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng excel 2007 to\u00e0n t\u1eadp<\/a><\/p>\n<\/blockquote>\n<ol start=\"6\">\n<li><strong>Name ranges<\/strong><\/li>\n<\/ol>\n<p>R\u1ea5t nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng th\u1ea5y vi\u1ec7c s\u1eed d\u1ee5ng t\u00ean cho d\u00e3y th\u00ec hi\u1ec7u qu\u1ea3 h\u01a1n l\u00e0 vi\u1ec7c \u0111\u1ec3 c\u00e1c \u00f4 m\u1eb7c \u0111\u1ecbnh. B\u1edfi v\u00ec con ng\u01b0\u1eddi th\u01b0\u1eddng kh\u00f3 nh\u1edb c\u00e1c d\u00e3y s\u1ed1 v\u00e0 ch\u1eef kh\u00f4ng li\u00ean quan \u0111\u1ebfn nhau. Nh\u01b0ng v\u1edbi Excel th\u00ec ch\u00fang th\u1eadm ch\u00ed kh\u00f3 nh\u1edb h\u01a1n b\u1edfi v\u00ec c\u00e1c \u00f4 s\u1ebd ch\u1ee9a c\u1ea3 ch\u1eef c\u00e1i, s\u1ed1 v\u00e0 k\u00fd hi\u1ec7u<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9785 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/21-09-07.png\" width=\"801\" height=\"198\" title=\"21-09-07\"><\/p>\n<p>V\u00ed d\u1ee5: \u201cRevenue \u2013 Cost = Margin\u201d (Doanh thu \u2013 Chi ph\u00ed= L\u1ee3i nhu\u1eadn) lu\u00f4n d\u1ec5 nh\u1edb h\u01a1n l\u00e0 \u201cA1-B1=C1\u201d.<\/p>\n<p>Nh\u1eefng b\u1ea3n b\u00e1o c\u00e1o s\u1eed d\u1ee5ng named ranges trong fomulas s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh gi\u00e1 cao h\u01a1n. \u0110\u1eb7c bi\u1ec7t n\u00f3 gi\u00fap \u0111\u01a1n gi\u1ea3n h\u00f3a c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n.<\/p>\n<p><strong>C\u00e1c v\u1ea5n \u0111\u1ec1 v\u1edbi named ranges<\/strong><\/p>\n<p>M\u1ed9t \u0111i\u1ec3m tr\u1eeb \u0111\u00f3 l\u00e0: t\u00ean c\u1ee7a d\u00e3y \u0111\u01b0\u1ee3c m\u1eb7c \u0111\u1ecbnh n\u00ean n\u00f3 kh\u00f4ng linh ho\u1ea1t, b\u1ea5t c\u1ee9 khi n\u00e0o c\u00f3 s\u1ef1 thay \u0111\u1ed5i, range name s\u1ebd kh\u00f4ng t\u1ef1 \u0111\u1ed9ng update.<\/p>\n<p>\u0110\u1ec3 x\u1eed l\u00fd v\u1ea5n \u0111\u1ec1 n\u00e0y, ng\u01b0\u1eddi d\u00f9ng b\u1eaft \u0111\u1ea7u b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng dynamic named ranges (link) \u2013d\u00f9ng OFFSET &amp; COUNTA formulas.<\/p>\n<ol start=\"7\">\n<li><strong>D\u00f9ng \u201cSort\u201d \u0111\u1ec3 t\u0103ng t\u1ed1c \u0111\u1ed9 t\u00ednh to\u00e1n<\/strong><\/li>\n<\/ol>\n<p>B\u1ea1n c\u00f3 bi\u1ebft r\u1eb1ng vi\u1ec7c s\u1eafp x\u1ebfp d\u1eef li\u1ec7u gi\u00fap workbook l\u00e0m vi\u1ec7c nhanh h\u01a1n g\u1ea5p 4 l\u1ea7n?<\/p>\n<p>Excel sort s\u1ebd s\u1eafp x\u1ebfp d\u1eef li\u1ec7u theo h\u1ec7 th\u1ed1ng d\u1ef1a tr\u00ean \u0111i\u1ec1u ki\u1ec7n m\u00e0 b\u1ea1n ch\u1ecdn<\/p>\n<p>V\u00ec khi ch\u00fang c\u1ea7n ph\u1ea3i x\u00f3a d\u1eef li\u1ec7u theo m\u1ed9t th\u1ee9 t\u1ef1 n\u00e0o \u0111\u00f3, Excel s\u1ebd kh\u00f4ng c\u1ea7n m\u1ea5t c\u00f4ng t\u00ecm ki\u1ebfm m\u00e0 thay v\u00e0o \u0111\u00f3 ch\u1ec9 c\u1ea7n x\u00f3a d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp m\u1ed9t c\u00e1ch nhanh ch\u00f3ng.<\/p>\n<ol start=\"8\">\n<li><strong>Calculation options ( l\u1ef1a ch\u1ecdn t\u00ednh to\u00e1n)<\/strong><\/li>\n<\/ol>\n<p><em>Excels formulas kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng \u0111\u01b0\u1ee3c b\u1edfi v\u00ec calculation options<\/em>. V\u1eady calculation options l\u00e0 g\u00ec?<\/p>\n<p>Hi\u1ec3u \u0111\u01a1n gi\u1ea3n, n\u00f3 l\u00e0 l\u1ef1a ch\u1ecdn \u0111\u01b0\u1ee3c \u0111\u01b0a ra cho ng\u01b0\u1eddi d\u00f9ng \u0111\u1ec3 quy\u1ebft \u0111\u1ecbnh xem ms excel s\u1ebd th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n khi c\u00f3 update hay n\u00f3 s\u1ebd th\u1ef1c hi\u1ec7n th\u01b0\u1eddng xuy\u00ean.<\/p>\n<p>B\u1ea1n c\u00f3 th\u1ec3 t\u00ecm th\u1ea5y calculations options d\u01b0\u1edbi tab Fomulas. N\u1ebfu \u1edf ph\u1ea7n c\u00e0i \u0111\u1eb7t m\u1eb7c \u0111\u1ecbnh \u0111\u1ec3 \u201cautomatic\u201d, c\u00f3 ngh\u0129a l\u00e0 m\u1ed7i khi b\u1ea1n t\u1ea1o s\u1ef1 thay \u0111\u1ed5i v\u1edbi file execl th\u00ec n\u00f3 s\u1ebd \u0111\u01b0\u1ee3c ph\u1ea3n \u00e1nh m\u1ed9t c\u00e1ch t\u1ef1 \u0111\u1ed9ng.<\/p>\n<p>C\u00f2n n\u1ebfu l\u00e0 \u201cmanual\u201d, c\u00f3 ngh\u0129a l\u00e0 s\u1ef1 thay \u0111\u1ed5i s\u1ebd kh\u00f4ng ph\u1ea3n \u00e1nh t\u1ef1 \u0111\u1ed9ng m\u00e0 thay v\u00e0o \u0111\u00f3 ng\u01b0\u1eddi d\u00f9ng ph\u1ea3i resfresh m\u1ecdi l\u00fac \u0111\u1ec3 update k\u1ebft qu\u1ea3.<\/p>\n<p><strong>V\u1eady calculations options t\u1ed1t hay x\u1ea5u?<\/strong><\/p>\n<p>N\u00f3 c\u00f3 c\u1ea3 t\u1ed1t l\u1eabn x\u1ea5u.\u00a0 N\u1ebfu ng\u01b0\u1eddi d\u00f9ng kh\u00f4ng bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng th\u00ec s\u1ebd \u0111\u01b0a ra sai k\u1ebft qu\u1ea3. Nh\u01b0ng c\u0169ng v\u1edbi \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 c\u00f3 nhi\u1ec1u l\u1ee3i \u00edch n\u1ebfu bi\u1ebft n\u00f3 ho\u1ea1t \u0111\u1ed9ng th\u1ebf n\u00e0o.<\/p>\n<p>L\u1eddi khuy\u00ean: N\u1ebfu b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi l\u01b0\u1ee3ng d\u1eef li\u1ec7u l\u1edbn m\u00e0 ch\u1ec9 ch\u1ecdn option \u201cmanual\u201d th\u00ec khi ho\u00e0n th\u00e0nh xong h\u00e3y nh\u1edb c\u00e0i \u0111\u1eb7t v\u1ec1 d\u1ea1ng \u201cautomatic\u201d.<\/p>\n<p>\u0110i\u1ec1u c\u1ea7n bi\u1ebft:<\/p>\n<p>Khi b\u1ea1n th\u1ef1c hi\u1ec7n thay \u0111\u1ed5i trong report, n\u00f3 s\u1ebd l\u01b0u l\u1ea1i cho \u0111\u1ebfn khi b\u1ea1n quay l\u1ea1i v\u00e0 ch\u1ec9nh s\u1eeda. V\u1eady n\u00ean c\u00f3 m\u1ed9t s\u1ef1 nh\u1ea7m l\u1eabn l\u00e0 n\u1ebfu b\u1ea1n m\u1edf c\u00f9ng m\u1ed9t report trong c\u00e1c m\u00e1y t\u00ednh kh\u00e1c nhau, th\u00ec n\u00f3 s\u1ebd t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i theo c\u00e0i \u0111\u1eb7t c\u1ee7a m\u00e1y t\u00ednh \u0111\u00f3. Tuy nhi\u00ean \u0111i\u1ec1u \u0111\u00f3 l\u00e0 kh\u00f4ng \u0111\u00fang.<\/p>\n<ol start=\"9\">\n<li><strong>X\u1eed l\u00fd l\u1ed7i<\/strong><\/li>\n<\/ol>\n<p>M\u1ed9t trong nh\u1eefng th\u00e1ch th\u1ee9c l\u1edbn nh\u1ea5t l\u00e0 \u0111\u1ea3m b\u1ea3o report c\u1ee7a b\u1ea1n kh\u00f4ng b\u1ecb c\u00e1c l\u1ed7i th\u00f4ng th\u01b0\u1eddng.<\/p>\n<p><strong>C\u00e1c lo\u1ea1i l\u1ed7i<\/strong><\/p>\n<p><strong>+) Excel defined errors<\/strong>: H\u1ea7u h\u1ebft ng\u01b0\u1eddi d\u00f9ng excel \u0111\u1ec1u nh\u1eadn ra \u0111\u01b0\u1ee3c c\u00e1c l\u1ed7i n\u00e0y b\u1edfi ch\u00fang \u0111\u01b0\u1ee3c \u0111\u1ecbnh ngh\u0129a s\u1eb5n. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n th\u1ea5y #DIV0! Trong report,n\u00f3 c\u00f3 ngh\u0129a l\u00e0 c\u00f4ng th\u1ee9c b\u1ecb chia cho gi\u00e1 tr\u1ecb 0. M\u00e0 chia cho 0 th\u00ec kh\u00f4ng t\u00ednh \u0111\u01b0\u1ee3c.<\/p>\n<p><strong>Tip:<\/strong> d\u00f9ng IFERROR or ISERROR formulas \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh l\u1ed7i<\/p>\n<p><strong>+) User specific errors:<\/strong> Nh\u1eefng l\u1ed7i n\u00e0y xu\u1ea5t hi\u1ec7n l\u00e0 do sai l\u1ea7m c\u1ee7a ng\u01b0\u1eddi d\u00f9ng. T\u00e1c \u0111\u1ed9ng c\u1ee7a nh\u1eefng l\u1ed7i n\u00e0y th\u01b0\u1eddng cao h\u01a1n so v\u1edbi l\u1ed7i \u0111\u01b0\u1ee3c \u0111\u1ecbnh trong Excel. V\u1ea5n \u0111\u1ec1 l\u1edbn nh\u1ea5t l\u00e0 kh\u00f4ng c\u00f3 h\u1ec7 th\u1ed1ng n\u00e0o ph\u00e1t hi\u1ec7n v\u00e0 thay \u0111\u1ed5i ng\u01b0\u1eddi d\u00f9ng.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9786 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/21-09-08.jpeg\" width=\"594\" height=\"336\" title=\"21-09-08\"><\/p>\n<p><strong>M\u1ed9t v\u00e0i l\u1ed7i do ng\u01b0\u1eddi d\u00f9ng :<\/strong><\/p>\n<p><strong>+) Kh\u00f4ng bi\u1ebft quy t\u1eafc BODMAS<\/strong>: 50% ng\u01b0\u1eddi s\u1eed d\u1ee5ng Excel ng\u00e0y nay kh\u00f4ng bi\u1ebft excel s\u1ebd th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n nh\u01b0 th\u1ebf n\u00e0o. C\u00f3 m\u1ed9t kho\u1ea3ng c\u00e1ch l\u1edbn gi\u1eefa vi\u1ec7c hi\u1ec3u v\u00e0 kh\u00f4ng hi\u1ec3u c\u00e1ch t\u00ednh c\u1ee7a Excel.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9787 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/21-09-09.jpeg\" width=\"600\" height=\"288\" title=\"21-09-09\"><\/p>\n<p>Excel t\u00ednh to\u00e1n d\u1ef1a theo nguy\u00ean t\u1eafc to\u00e1n h\u1ecdc l\u00e0 BODMAS \u00a0(Brackets first, Orders (IE Powers and Square Roots, etc.), Division and Multiplication (left-to-right), Addition and Subtraction (left-to-right)).<\/p>\n<p>V\u00ed d\u1ee5, 2+5*3=?, ch\u00fang ta s\u1ebd ra ngay k\u1ebft qu\u1ea3 l\u00e0 21, nh\u01b0ng c\u00e2u tr\u1ea3 l\u1eddi \u0111\u00fang theo BODMAS l\u00e0 17.<\/p>\n<p>Gi\u1ea3i ph\u00e1p: H\u00e3y \u00e1p d\u1ee5ng quy t\u1eafc BODMAS khi l\u1eadp c\u00f4ng th\u1ee9c<\/p>\n<p><strong>+) Improper testing mechanism<\/strong>: Kh\u00f4ng gi\u1ed1ng nh\u01b0 c\u00e1c ph\u1ea7n m\u1ec1m ki\u1ec3m tra kh\u00e1c, ch\u00fang ta kh\u00f4ng c\u00f3 c\u00f4ng c\u1ee5 ph\u00e1t hi\u1ec7n l\u1ed7i m\u1ed9t c\u00e1ch tinh vi. C\u00e1ch t\u1ed1t nh\u1ea5t l\u00e0 ki\u1ec3m tra fomulas m\u1ed7i khi b\u1ea1n t\u1ea1o ra n\u00f3 v\u1edbi 2-3 l\u1ea7n th\u1eed d\u1eef li\u1ec7u.<\/p>\n<ol start=\"10\">\n<li><strong>Home page, user guide &amp; presentation<\/strong><\/li>\n<\/ol>\n<p>C\u00e1ch b\u1ea1n tr\u00ecnh b\u00e0y nh\u01b0 th\u1ebf n\u00e0o c\u0169ng quan tr\u1ecdng kh\u00f4ng k\u00e9m formulas, VBA code &amp; logic\u2019s trong report. N\u00f3 kh\u00f4ng ch\u1ec9 l\u00e0 m\u00e0u s\u1eafc v\u00e0 h\u00ecnh \u1ea3nh, m\u00e0 c\u00f2n l\u00e0 c\u00e1ch b\u1ea1n t\u1ea1o b\u1ea3ng, c\u00e1ch s\u1eafp x\u1ebfp, t\u1eadn d\u1ee5ng t\u1ea5t c\u1ea3 c\u00e1c t\u00ednh n\u0103ng \u0111\u1ec3 \u0111\u01b0a ra k\u1ebft qu\u1ea3 t\u1ed1t nh\u1ea5t.<\/p>\n<p><strong>Tips \u0111\u1ec3 l\u00e0m \u0111\u1eb9p report<\/strong><\/p>\n<ul>\n<li>N\u1ebfu b\u1ea1n c\u00f3 nhi\u1ec1u worksheet trong report th\u00ec n\u00ean s\u1eed d\u1ee5ng <strong>Home page<\/strong> v\u00e0 d\u00f9ng hyperlink \u0111\u1ec3 link ch\u00fang l\u1ea1i v\u1edbi nhau.<\/li>\n<li>H\u00e3y th\u00eam h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng report (b\u1ea1n kh\u00f4ng c\u1ea7n vi\u1ebft t\u1eebng \u0111i\u1ec3m m\u1ed9t, ch\u1ec9 c\u1ea7n b\u1ea3n t\u00f3m t\u1eaft)<\/li>\n<li>Tr\u00ecnh b\u00e0y d\u1eef li\u1ec7u v\u1edbi \u0111\u1ed3 th\u1ecb, bi\u1ec3u \u0111\u1ed3<\/li>\n<li>S\u1eed d\u1ee5ng conditional formatting khi bi\u1ec3u di\u1ec5n trend.<\/li>\n<\/ul>\n<p>L\u01b0u \u00fd: S\u1eed d\u1ee5ng qu\u00e1 nhi\u1ec1u \u0111\u1ecbnh d\u1ea1ng c\u0169ng l\u00e0m t\u0103ng k\u00edch th\u01b0\u1edbc file workbook v\u00e0 d\u1eabn \u0111\u1ebfn crash, v\u00ec v\u1eady h\u00e3y \u00a0xem x\u00e9t \u00a0s\u1eed d\u1ee5ng t\u1ed1i thi\u1ec3u format v\u1edbi t\u1ed1i \u0111a l\u1ee3i \u00edch.<\/p>\n<p><strong>K\u1ebft lu\u1eadn<\/strong><\/p>\n<p>M\u1ee5c \u0111\u00edch ch\u00ednh c\u1ee7a b\u1ea5t k\u00ec report n\u00e0o c\u0169ng l\u00e0 cung c\u1ea5p th\u00f4ng tin c\u00f3 gi\u00e1 tr\u1ecb m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c. To\u00e0n b\u1ed9 n\u1ed9i dung b\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn c\u00e1ch b\u1ea1n luy\u1ec7n t\u1eadp v\u00e0 t\u1ea1o \u0111\u00f2n b\u1ea9y gi\u00fap b\u1ea1n t\u1ea1o \u0111\u01b0\u1ee3c nh\u1eefng report \u0111\u1eb9p nh\u1ea5t.<\/p>\n<p style=\"text-align: left\">Blog Ho\u0323c Excel online \u0111a\u0303 m\u01a1\u0309 r\u00e2\u0301t nhi\u00ea\u0300u ca\u0301c kho\u0301a ho\u0323c \u0111a\u0300o ta\u0323o v\u00ea\u0300\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-co-ban\">H\u1ecdc Excel c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao<\/a>\u00a0v\u01a1\u0301i ca\u0301c chuy\u00ean gia ha\u0300ng \u0111\u00e2\u0300u ta\u0323i Vi\u00ea\u0323t Nam. Ch\u00fang t\u00f4i se\u0303 mang \u0111\u00ea\u0301n cho ba\u0323n nh\u01b0\u0303ng bu\u00f4\u0309i ho\u0323c b\u00f4\u0309 i\u0301ch, hi\u00ea\u0309u qua\u0309 co\u0301 th\u00ea\u0309 s\u01b0\u0309 du\u0323ng tha\u0300nh tha\u0323o Excel \u0111\u00ea\u0309 a\u0301p du\u0323ng trong c\u00f4ng vi\u00ea\u0323c. Ngoa\u0300i ra, chu\u0301ng t\u00f4i \u0111ang co\u0301 nhi\u00ea\u0300u ch\u01b0\u01a1ng tri\u0300nh khuy\u00ea\u0301n ma\u0323i l\u01a1\u0301n cho ca\u0301c ho\u0323c vi\u00ean \u0111\u0103ng ki\u0301 trong tha\u0301ng na\u0300y, v\u00e2\u0323y co\u0300n tr\u1ea7n tr\u01b0\u0300 gi\u0300 n\u01b0\u0303a ma\u0300 kh\u00f4ng \u0111\u0103ng ki\u0301 ngay th\u00f4i. Th\u00f4ng tin chi ti\u1ebft xem t\u1ea1i:<\/p>\n<p style=\"text-align: justify\">\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\/2025\/01\/ex101_92019-nho-264.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11156,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11155","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\/11155","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=11155"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11155\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11156"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11155"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11155"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}