{"id":10807,"date":"2025-01-14T23:51:02","date_gmt":"2025-01-14T23:51:02","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/cach-tao-phieu-luong-dung-cong-cu-asap-utilities\/"},"modified":"2025-01-14T23:51:02","modified_gmt":"2025-01-14T23:51:02","slug":"cach-tao-phieu-luong-dung-cong-cu-asap-utilities","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/cach-tao-phieu-luong-dung-cong-cu-asap-utilities\/","title":{"rendered":"C\u00e1ch t\u1ea1o phi\u1ebfu l\u01b0\u01a1ng d\u00f9ng c\u00f4ng c\u1ee5 ASAP Utilities"},"content":{"rendered":"
\n

Nh\u01b0 \u0111\u00e3 h\u1ee9a v\u1edbi c\u00e1c b\u1ea1n \u1edf b\u00e0i tr\u01b0\u1edbc, h\u00f4m nay m\u00ecnh xin \u0111\u01b0\u1ee3c\u00a0chia s\u1ebb m\u1ed9t ki\u1ebfn th\u1ee9c m\u00e0 m\u00ecnh h\u1ecdc \u0111\u01b0\u1ee3c t\u1eeb c\u00e1c ch\u1ecb m\u00e0 m\u00ecnh c\u00f3 c\u01a1 h\u1ed9i \u0111\u01b0\u1ee3c l\u00e0m c\u00f9ng. \u0110\u00f3 l\u00e0 t\u1ea1o payslip cho nh\u00e2n vi\u00ean t\u1eeb b\u1ea3ng l\u01b0\u01a1ng l\u00e0m tr\u00ean excel b\u1eb1ng c\u00f4ng c\u1ee5 ASAP Utilities, m\u1ed9t c\u00f4ng c\u1ee5 ph\u1ee5 tr\u1ee3 r\u1ea5t nhi\u1ec1u cho excel. \u0110\u1ea7u ti\u00ean c\u00e1c b\u1ea1n h\u00e3y download v\u00e0 c\u00e0i \u0111\u1eb7t c\u00f4ng c\u1ee5 n\u00e0y v\u1ec1 m\u00e1y t\u00ednh c\u1ee7a c\u00e1c b\u1ea1n nh\u00e9. Khi c\u00e1c b\u1ea1n ho\u00e0n t\u1ea5t b\u01b0\u1edbc n\u00e0y th\u00ec excel c\u1ee7a c\u00e1c b\u1ea1n s\u1ebd xu\u1ea5t hi\u1ec7n th\u00eam m\u1ed9t th\u1ebb m\u1edbi \u0111\u00f3 l\u00e0\u00a0ASAP Utilities.<\/p>\n

B\u01b0\u1edbc \u0111\u1ea7u ti\u00ean c\u00e1c b\u1ea1n t\u1ea1o m\u1ed9t sheet m\u1edbi nh\u01b0 h\u00ecnh n\u00e0y, t\u00f9y thu\u1ed9c v\u00e0o m\u1ee5c \u0111\u00edch v\u00e0 c\u00e1c ti\u00eau ch\u00ed m\u00e0 c\u00e1c b\u1ea1n mu\u1ed1n th\u1ec3 hi\u1ec7n tr\u00ean phi\u1ebfu l\u01b0\u01a1ng n\u00e0y m\u00e0 c\u00e1c b\u1ea1n t\u1ea1o phi\u1ebfu cho ph\u00f9 h\u1ee3p b\u1eb1ng c\u00e1ch d\u00f9ng h\u00e0m vlookup \u0111\u1ec3 tham chi\u1ebfu \u0111\u1ebfn c\u00e1c v\u00f9ng d\u1eef li\u1ec7u\u00a0nh\u00e9. L\u01b0u \u00fd l\u00e0 c\u00e1c b\u1ea1n ch\u1ecdn d\u1eef li\u1ec7u t\u1eeb v\u00f9ng\u00a0tham chi\u1ebfu n\u00e0o th\u00ec ph\u1ea3i ch\u1ecdn v\u00f9ng\u00a0\u0111\u00f3 v\u00e0o v\u00f9ng tham chi\u1ebfu nh\u00e9.\u00a0\u0110\u1ec3 ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u n\u00e0y, c\u00e1c b\u1ea1n nh\u1ea5n \u0111\u1ed3ng lo\u1ea1t 2 ph\u00edm Ctrl+F3<\/strong> \u00a0ho\u1eb7c v\u00e0o th\u1ebb Formulas=> Name Manager<\/strong> \u00a0n\u00f3 s\u1ebd m\u1edf cho c\u00e1c b\u1ea1n m\u1ed9t b\u1ea3ng nh\u01b0 sau:<\/p>\n

\"chon-vung-tim-kiem\"<\/p>\n

C\u00f4ng vi\u1ec7c ti\u1ebfp theo c\u1ee7a b\u1ea1n l\u00e0 ch\u1ecdn New\u00a0<\/strong>v\u00e0 qu\u00e9t ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm, khi \u0111\u00f3 excel s\u1ebd \u0111\u1ed5 xu\u1ed1ng cho ch\u00fang ta m\u1ed9t danh s\u00e1ch t\u00ean v\u00e0 v\u00f9ng t\u00ecm ki\u1ebfm nh\u01b0 h\u00ecnh tr\u00ean.<\/p>\n

V\u00e0 \u0111\u00e2y l\u00e0 h\u00ecnh \u1ea3nh c\u1ee7a sheet m\u00ecnh t\u1ea1o ra:<\/p>\n

\"Sheet-mau\"<\/p>\n

V\u00ed d\u1ee5 m\u00ecnh c\u00f3 b\u1ea3ng l\u01b0\u01a1ng v\u1edbi m\u1ed9t s\u1ed1\u00a0ti\u00eau ch\u00ed nh\u01b0 sau:<\/p>\n

\"bang-luong-mau\"<\/p>\n

\n
\n

D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n


\n
\n<\/a>\n<\/div>\n<\/div>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

\u00a0<\/p>\n

B<\/u><\/strong>\u01b0\u1edb<\/u><\/strong>c 1<\/u><\/strong>:\u00a0T<\/strong>\u1ea1<\/strong>o c<\/strong>\u00e1<\/strong>c phi<\/strong>\u1ebf<\/strong>u l<\/strong>\u01b0\u01a1<\/strong>ng m<\/strong>\u1eab<\/strong>u:<\/strong><\/p>\n

C\u00e1c b\u1ea1n ch\u1ecdn c\u1ed9t t\u00ean nh\u01b0 h\u00ecnh tr\u00ean nh\u00e9, sau \u0111\u00f3 \u0111i v\u00e0o th\u1ebb\u00a0\u00a0ASAP Utilities v\u00e0 l\u00e0m nh\u01b0 h\u00ecnh nh\u00e9:<\/p>\n

\"tao-phieu-luong-cho-tung-NV\"<\/p>\n

Sau \u0111\u00f3 l\u00e0m ti\u1ebfp nh\u01b0 sau:<\/p>\n

\"tao-phieu-luong-2\"<\/p>\n

Sau khi c\u00e1c b\u1ea1n l\u00e0m xong thao t\u00e1c tr\u00ean ASAP \u00a0s\u1ebd t\u1ea1o cho ch\u00fang ta c\u00e1c sheet v\u1edbi t\u00ean sheet l\u00e0 t\u00ean c\u1ee7a c\u00e1c nh\u00e2n vi\u00ean \u0111\u01b0\u1ee3c ch\u1ecdn.<\/p>\n

B<\/u><\/strong>\u01b0\u1edb<\/u><\/strong>c 2:<\/u><\/strong>\u00a0\u0110i<\/strong>\u1ec1<\/strong>n th<\/strong>\u00f4<\/strong>ng tin cho c\u00e1c ti\u00eau ch\u00ed c<\/strong>\u1ea7<\/strong>n t<\/strong>\u00ec<\/strong>m ki<\/strong>\u1ebf<\/strong>m tr<\/strong>\u00ea<\/strong>n phi<\/strong>\u1ebf<\/strong>u l<\/strong>\u01b0\u01a1<\/strong>ng:<\/strong>\u00a0<\/strong><\/p>\n

V\u00ec m\u00ecnh \u0111\u00e3 ch\u1ecdn c\u1ed9t t\u00ean \u0111\u1ec3 t\u1ea1o c\u00e1c phi\u1ebfu l\u01b0\u01a1ng n\u00ean b\u00e2y gi\u1edd \u1edf sheet m\u00ecnh s\u1ebd \u0111\u1eb7t con tr\u1ecf chu\u1ed9t \u1edf \u00f4 t\u00ean v\u00e0 sau \u0111\u00f3 gi\u1eef ph\u00edm Shift r\u1ed3i ch\u1ecdn c\u00e1c sheet t\u00ean nh\u00e2n vi\u00ean t\u1eeb t\u00ean c\u1ee7a ng\u01b0\u1eddi \u0111\u1ea7u ti\u00ean \u0111\u1ebfn t\u00ean c\u1ee7a ng\u01b0\u1eddi cu\u1ed1i c\u00f9ng:<\/p>\n

\"buoc-2-1\"<\/p>\n

R\u1ed3i sau \u0111\u00f3 v\u00e0o ti\u1ebfp th\u1ebb ASAP v\u00e0 l\u00e0m nh\u01b0 sau:<\/p>\n

\"tao-phieu-luong\"<\/p>\n

B\u00e2y gi\u1edd c\u00f4ng vi\u1ec7c ti\u1ebfp theo c\u1ee7a c\u00e1c b\u1ea1n l\u00e0 \u1ea5n OK v\u00e0 t\u1eadn h\u01b0\u1edfng th\u00e0nh qu\u1ea3 nh\u00e9!<\/p>\n

C\u1ea3m \u01a1n c\u00e1c b\u1ea1n \u0111\u00e3 theo d\u00f5i b\u00e0i vi\u1ebft c\u1ee7a m\u00ecnh. H\u1eb9n g\u1eb7p l\u1ea1i c\u00e1c b\u1ea1n \u1edf c\u00e1c b\u00e0i ti\u1ebfp theo.<\/p>\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n

D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n


\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10808,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10807","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\/10807","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=10807"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10807\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10808"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10807"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10807"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10807"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}