{"id":19695,"date":"2026-05-05T10:10:52","date_gmt":"2026-05-05T03:10:52","guid":{"rendered":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/?post_type=ht_kb&#038;p=19695"},"modified":"2026-07-09T16:15:25","modified_gmt":"2026-07-09T09:15:25","slug":"huong-dan-sap-xep-du-lieu-cot-tren-cac-bang-bao-cao","status":"publish","type":"ht_kb","link":"https:\/\/helpamis.misa.vn\/amis-tien-luong\/kb\/huong-dan-sap-xep-du-lieu-cot-tren-cac-bang-bao-cao\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eafp x\u1ebfp d\u1eef li\u1ec7u c\u1ed9t tr\u00ean c\u00e1c B\u1ea3ng, B\u00e1o c\u00e1o"},"content":{"rendered":"<h3><b>1. T\u1ed5ng quan<\/b><\/h3>\n<p><b>M\u1ee5c \u0111\u00edch:<\/b> T\u00ednh n\u0103ng s\u1eafp x\u1ebfp cho ph\u00e9p\u00a0 linh ho\u1ea1t \u0111i\u1ec1u ch\u1ec9nh th\u1ee9 t\u1ef1 hi\u1ec3n th\u1ecb nh\u00e2n vi\u00ean trong c\u00e1c b\u1ea3ng v\u00e0 b\u00e1o c\u00e1o theo nhi\u1ec1u ti\u00eau ch\u00ed kh\u00e1c nhau gi\u00fap ki\u1ec3m so\u00e1t, theo d\u00f5i v\u00e0 \u0111\u1ed1i chi\u1ebfu d\u1eef li\u1ec7u d\u1ec5 d\u00e0ng h\u01a1n \u0111\u1ed3ng th\u1eddi gi\u1ea3m b\u1edbt thao t\u00e1c ch\u1ec9nh s\u1eeda khi xu\u1ea5t ra file excel<br \/>\n<b>N\u1ed9i dung:<\/b><\/p>\n<ul>\n<li>H\u01b0\u1edbng d\u1eabn thao t\u00e1c s\u1eafp x\u1ebfp d\u1eef li\u1ec7u tr\u00ean t\u1eebng c\u1ed9t tr\u00ean B\u1ea3ng l\u01b0\u01a1ng\/B\u1ea3ng ph\u00e2n b\u1ed5 l\u01b0\u01a1ng\/B\u1ea3ng d\u1eef li\u1ec7u t\u00ednh l\u01b0\u01a1ng\/B\u00e1o c\u00e1o&#8230;&#8230;<\/li>\n<\/ul>\n<p><b>Ph\u1ea1m vi \u00e1p d\u1ee5ng:<\/b> Nh\u00e2n s\u1ef1, k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, qu\u1ea3n tr\u1ecb h\u1ec7 th\u1ed1ng..<\/p>\n<h3><b>2. H\u01b0\u1edbng d\u1eabn chi ti\u1ebft\u00a0<\/b><\/h3>\n<p>T\u1ea1i giao di\u1ec7n chi ti\u1ebft B\u1ea3ng l\u01b0\u01a1ng\/B\u1ea3ng d\u1eef li\u1ec7u t\u00ednh l\u01b0\u01a1ng\/B\u00e1o c\u00e1o&#8230;.B\u1ea5m v\u00e0o ti\u00eau \u0111\u1ec1 c\u1ed9t \u0111\u1ec3 l\u1ef1a ch\u1ecdn ch\u1ee9c n\u0103ng <strong>Kh\u00f4ng s\u1eafp x\u1ebfp\/T\u0103ng d\u1ea7n\/Gi\u1ea3m d\u1ea7n\/Ghim c\u1ed9t\/Th\u00eam c\u1ed9t b\u00ean tr\u00e1i\/Th\u00eam c\u1ed9t b\u00ean ph\u1ea3i\/X\u00f3a c\u1ed9t.\u00a0<\/strong><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-20419\" src=\"\/amis-tien-luong\/wp-content\/uploads\/2026\/05\/Screenshot_123.png\" alt=\"\" width=\"1918\" height=\"948\" \/><\/p>\n<p>Ngo\u00e0i ra ph\u1ea7n m\u1ec1m c\u00f3 ch\u1ee9c n\u0103ng gom nh\u00f3m c\u00e1c b\u1ea3n ghi l\u1ea1i v\u1edbi nhau theo \u0111\u01a1n v\u1ecb, v\u1ecb tr\u00ed c\u00f4ng vi\u1ec7c ho\u1eb7c ng\u00e0y ch\u00ednh th\u1ee9c. T\u1ea1i giao di\u1ec7n chi ti\u1ebft B\u1ea3ng l\u01b0\u01a1ng\/ B\u00e1o c\u00e1o\\ Ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng <strong><em>Ba\u0301nh r\u0103ng<\/em><\/strong><strong>\u00a0<em>\u2699\\ <\/em><\/strong>Cho\u0323n<strong> Gom nho\u0301m ba\u0309n ghi<\/strong>: <em><strong>Kh\u00f4ng, M\u00f4\u0323t c\u00e2\u0301p ho\u0103\u0323c Hai c\u00e2\u0301p<\/strong>\\ <\/em>\u00a0Ch\u1ecdn tr\u01b0\u1eddng theo nhu c\u1ea7u (<strong>\u0110\u01a1n v\u1ecb, V\u1ecb tr\u00ed c\u00f4ng vi\u1ec7c ho\u1eb7c ng\u00e0y ch\u00ednh th\u1ee9c<\/strong>)\\ Nh\u1ea5n <strong>L\u01b0u<\/strong><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-22507\" src=\"\/amis-tien-luong\/wp-content\/uploads\/2026\/07\/Screenshot-2026-07-09-141515.png\" alt=\"\" width=\"1906\" height=\"926\" \/><\/p>\n<p>Sau khi ho\u00e0n t\u1ea5t s\u1eafp x\u1ebfp, d\u1eef li\u1ec7u s\u1ebd hi\u1ec3n th\u1ecb \u0111\u1ee9ng th\u1ee9 t\u1ef1 mong mu\u1ed1n v\u00e0 khi anh\/ch\u1ecb xu\u1ea5t d\u1eef li\u1ec7u ra Excel, th\u1ee9 t\u1ef1 s\u1eafp x\u1ebfp n\u00e0y \u0111\u01b0\u1ee3c gi\u1eef nguy\u00ean.<\/p>\n<h3><b>3. L\u01b0u \u00fd<\/b><\/h3>\n<ul>\n<li><em><em>C\u1ed9t d\u1eef li\u1ec7u v\u1ec1 STT s\u1ebd kh\u00f4ng h\u1ed7 tr\u1ee3 s\u1eafp x\u1ebfp.<\/em><\/em><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>1. T\u1ed5ng quan M\u1ee5c \u0111\u00edch: T\u00ednh n\u0103ng s\u1eafp x\u1ebfp cho ph\u00e9p\u00a0 linh ho\u1ea1t \u0111i\u1ec1u ch\u1ec9nh th\u1ee9 t\u1ef1 hi\u1ec3n th\u1ecb nh\u00e2n vi\u00ean trong c\u00e1c b\u1ea3ng v\u00e0 b\u00e1o c\u00e1o theo nhi\u1ec1u ti\u00eau ch\u00ed kh\u00e1c nhau gi\u00fap ki\u1ec3m so\u00e1t, theo d\u00f5i v\u00e0 \u0111\u1ed1i chi\u1ebfu d\u1eef li\u1ec7u d\u1ec5 d\u00e0ng h\u01a1n \u0111\u1ed3ng th\u1eddi gi\u1ea3m b\u1edbt&#8230;<\/p>\n","protected":false},"author":141,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[291],"ht-kb-tag":[],"class_list":["post-19695","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-r62-phat-hanh-ngay-27-03-2026"],"_links":{"self":[{"href":"https:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb\/19695","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/users\/141"}],"replies":[{"embeddable":true,"href":"https:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/comments?post=19695"}],"version-history":[{"count":5,"href":"https:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb\/19695\/revisions"}],"predecessor-version":[{"id":22511,"href":"https:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb\/19695\/revisions\/22511"}],"wp:attachment":[{"href":"https:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/media?parent=19695"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb-category?post=19695"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb-tag?post=19695"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}