{"id":1735,"date":"2024-04-11T16:44:21","date_gmt":"2024-04-11T09:44:21","guid":{"rendered":"http:\/\/kthtx.vn\/?p=1735"},"modified":"2026-01-16T16:01:30","modified_gmt":"2026-01-16T09:01:30","slug":"but-toan-khoa-so","status":"publish","type":"post","link":"https:\/\/kthtx.vn\/index.php\/2024\/04\/11\/but-toan-khoa-so\/","title":{"rendered":"B\u00fat to\u00e1n kh\u00f3a s\u1ed5 – L\u1eadp b\u00e1o c\u00e1o t\u00e0i ch\u00ednh"},"content":{"rendered":"\n

C\u00e1ch \u0111\u0103ng nh\u1eadp: Cu\u1ed1i k\u1ef3 \\ B\u00fat to\u00e1n kh\u00f3a s\u1ed5<\/em><\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Gi\u1ea3i th\u00edch m\u1ed9t s\u1ed1  th\u00f4ng tin c\u1eadp nh\u1eadt:<\/em><\/strong><\/p>\n\n\n\n

S\u1ed1\u00a0th\u1ee9\u00a0t\u1ef1<\/em><\/strong><\/td>S\u1ed1 th\u1ee9 t\u1ef1 s\u1eafp x\u1ebfp tr\u00ean m\u00e0n h\u00ecnh.<\/td><\/tr>
Di\u1ec5n gi\u1ea3i<\/em><\/strong><\/td>N\u1ed9i dung c\u1ee7a b\u00fat to\u00e1n.<\/td><\/tr>
T\u00e0i kho\u1ea3n\u00a0\u0111i<\/em><\/strong><\/td>T\u00e0i kho\u1ea3n m\u00e0 s\u1ebd k\u1ebft chuy\u1ec3n \u0111i<\/td><\/tr>
T\u00e0i kho\u1ea3n\u00a0\u0111\u1ebfn<\/em><\/strong><\/td>T\u00e0i kho\u1ea3n \u0111\u1ed1i \u1ee9ng c\u1ee7a t\u00e0i kho\u1ea3n \u0111i. (Ch\u00fa \u00fd ph\u1ea3i l\u00e0 t\u00e0i kho\u1ea3n chi ti\u1ebft.)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

M\u1ed9t s\u1ed1 ch\u1ee9c n\u0103ng trong b\u00fat to\u00e1n kh\u00f3a s\u1ed5:<\/strong><\/p>\n\n\n\n

Th\u00eam(F2): <\/strong>Ch\u1ee9c n\u0103ng n\u00e0y c\u00f3 th\u1ec3 gi\u00fap cho ng\u01b0\u1eddi s\u1eed d\u1ee5ng c\u00f3 th\u1ec3 th\u00eam nh\u1eefng b\u00fat to\u00e1n kh\u00f3a s\u1ed1 cu\u1ed1i k\u1ef3. \u0110\u1ec3 th\u00eam ta k\u00edch chu\u1ed9t v\u00e0o Th\u00eam(F2) tr\u00ean thanh c\u00f4ng c\u1ee5, khi \u0111\u00f3 ch\u01b0\u01a1ng tr\u00ecnh hi\u1ec7n l\u00ean m\u1ed9t giao di\u1ec7n c\u1ea7n th\u00eam<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

V\u00ed d\u1ee5:<\/strong> Th\u00eam b\u00fat to\u00e1n k\u1ebft chuy\u1ec3n chi ph\u00ed kh\u00e1c<\/strong><\/p>\n\n\n\n

S\u1ed1 th\u1ee9 t\u1ef1: 04- Th\u1ee9 t\u1ef1 c\u1ee7a c\u00e1c b\u00fat to\u00e1n k\u1ebft chuy\u1ec3n<\/p>\n\n\n\n

Di\u1ec5n gi\u1ea3i: K\u1ebft chuy\u1ec3n chi ph\u00ed kh\u00e1c- L\u00fd do k\u1ebft chuy\u1ec3n<\/p>\n\n\n\n

K\u1ebft chuy\u1ec3n t\u1eeb Tk 911 \u0111\u1ebfn Tk 421: Tr\u00ecnh t\u1ef1 c\u1ee7a b\u00fat to\u00e1n k\u1ebft chuy\u1ec3n<\/p>\n\n\n\n

Lo\u1ea1i k\u1ebft chuy\u1ec3n: 1- K\u1ebft chuy\u1ec3n s\u1ed1 ph\u00e1t sinh nh\u1ee9ng n\u1ebfu b\u00fat to\u00e1n ta k\u1ebft mu\u1ed1n k\u1ebft chuy\u1ec3n s\u1ed1 ph\u00e1t sinh hay s\u1ed1 d\u01b0 cu\u1ed1i th\u00ec ta nh\u1eadp gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng l\u00e0 1 hay 2 v\u00e0o<\/p>\n\n\n\n

Ki\u1ec3u k\u1ebft chuy\u1ec3n: Mu\u1ed1n k\u1ebft chuy\u1ec3n theo ki\u1ec3u n\u00f2a th\u00ec ta nh\u1eadp t\u01b0\u01a1ng \u1ee9ng<\/p>\n\n\n\n

Sau \u0111\u00f3 k\u00edch chu\u1ed9t v\u00e0o th\u1ef1c hi\u1ec7n.<\/strong><\/p>\n\n\n\n

Ch\u00fa \u00fd: Ta c\u00f3 th\u1ec3 nh\u1ea5n ph\u00edm F2 tr\u00ean b\u00e0n ph\u00edm \u0111\u1ec3 th\u00eam,  <\/p>\n\n\n\n

C\u00e1c b\u01b0\u1edbc k\u1ebft chuy\u1ec3n:<\/strong><\/p>\n\n\n\n

B1:<\/strong> Ch\u1ecdn c\u00e1c b\u00fat to\u00e1n k\u1ebft chuy\u1ec3n b\u1eb1ng c\u00e1ch Click chu\u1ed9t tr\u00e1i v\u00e0o \u00f4 ch\u1ecdn hi\u1ec7n l\u00ean d\u1ea5u: \u201cx\u201d nh\u01b0 d\u01b0\u1edbi:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

B2: <\/strong>K\u00edch chu\u1ed9t v\u00e0o k\u1ebft chuy\u1ec3n tr\u00ean thanh c\u00f4ng c\u1ee5 ho\u1eb7c l\u00e0 ta c\u00f3 th\u1ec3 nh\u1ea5n ph\u00edm F10 tr\u00ean b\u00e0nph\u00edm \u0111\u1ec3 k\u1ebft chuy\u1ec3n.<\/p>\n\n\n\n

B3:<\/strong> Ch\u1ecdn kho\u1ea3n th\u1eddi gian k\u1ebft chuy\u1ec3n v\u00e0 k\u00edch chu\u1ed9t v\u00e0o Ch\u1ea5p nh\u1eadn<\/strong> \u0111\u1ec3 th\u1ef1c hi\u1ec7n.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

L\u01b0u \u00fd<\/em><\/strong>:<\/em><\/strong> Sau khi t\u1ea1o c\u00e1c b\u00fat to\u00e1n k\u1ebft chuy\u1ec3n th\u00ec ta c\u00f3 th\u1ec3 xem, s\u1eeda, xo\u00e1 ch\u00fang b\u1eb1ng c\u00e1ch v\u00e0o m\u00e0n h\u00ecnh \u201cCh\u1ee9ng t\u1eeb t\u1ef1 \u0111\u1ed9ng\u201d l\u1ecdc ra v\u1edbi \u0111i\u1ec1u ki\u1ec7n l\u1ecdc l\u00e0 m\u00e3 ch\u1ee9ng t\u1eeb = [TD] v\u00e0 ng\u00e0y ch\u1ee9ng t\u1eeb l\u00e0 ng\u00e0y \u0111\u00e3 k\u1ebft chuy\u1ec3n.<\/p>\n\n\n\n

Ph\u00edm t\u1eaft:<\/em><\/strong>         ^A        Ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c b\u00fat to\u00e1n<\/p>\n\n\n\n

^U        B\u1ecf l\u1ef1a ch\u1ecdn <\/p>\n\n\n\n

S\u1eeda(F3): <\/strong>Ch\u1ee9c n\u0103ng n\u00e0y c\u00f3 th\u1ec3 gi\u00fap cho ng\u01b0\u1eddi s\u1eed d\u1ee5ng s\u1eeda \u0111\u01b0\u1ee3c c\u00e1c b\u00fat to\u00e1n k\u1ebft chuy\u1ec3n. \u0110\u1ec3 s\u1eeda ta Click chu\u1ed9t \u0111\u1ebfn b\u00fat to\u00e1n c\u1ea7n s\u1eeda v\u00e0 k\u00edch chu\u1ed9t v\u00e0o s\u1eeda tr\u00ean thanh c\u00f4ng c\u1ee5, khi \u0111\u00f3 ch\u01b0\u01a1ng trinh s\u1ebd hi\u1ec7n l\u00ean n\u1ed9i dung ta c\u1ea7n s\u1eeda<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

S\u1eeda \u0111\u00fang n\u1ed9i dung c\u1ea7n s\u1eeda v\u00e0 k\u00edch chu\u1ed9t v\u00e0o th\u1ef1c hi\u1ec7n.<\/strong><\/p>\n\n\n\n

Ch\u00fa \u00fd: Ta c\u00f3 th\u1ec3 nh\u1ea5n ph\u00edm F3 tr\u00ean b\u00e0n ph\u00edm \u0111\u1ec3 th\u00eam<\/p>\n\n\n\n

X\u00f3a(F8)<\/strong>: Ch\u1ee9c n\u0103ng n\u00e0y c\u00f3 th\u1ec3 gi\u00fap cho ng\u01b0\u1eddi s\u1eed d\u1ee5ng x\u00f3a nh\u1eefng b\u00fat to\u00e1n k\u1ebft chuy\u1ec3n. \u0110\u1ec3 x\u00f3a ta Click chu\u1ed9t \u0111\u1ebfn b\u00fat to\u00e1n c\u1ea7n x\u00f3a v\u00e0 k\u00edch chu\u1ed9t v\u00e0o tr\u00ean thanh c\u00f4ng c\u1ee5, khi \u0111\u00f3 ch\u01b0\u01a1ng tr\u00ecnh \u0111\u01b0a ra c\u00e2u h\u1ecfi: \u201cC\u00f3 ch\u1eafc ch\u1eafn x\u00f3a kh\u00f4ng\u201d. N\u1ebfu mu\u1ed1n x\u00f3a th\u00ec ta k\u00edch chu\u1ed9t v\u00e0o \u201cYes\u201d, kh\u00f4ng mu\u1ed1n x\u00f3a th\u00ec k\u00edch chu\u1ed9t v\u00e0o \u201cNo\u201d.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

K\u1ebft xu\u1ea5t d\u1eef li\u1ec7u: <\/strong>Ch\u1ee9c n\u0103ng n\u00e0y c\u00f3 th\u1ec3 gi\u00fap cho ng\u01b0\u1eddi s\u1eed d\u1ee5ng k\u1ebft xu\u1ea5t d\u1eef li\u1ec7u \u1edf trong danh m\u1ee5c c\u1ea7n chuy\u1ec3n sang file Excel. \u0110\u1ec3 k\u1ebft xu\u1ea5t ta k\u00edch chu\u1ed9t v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng ch\u1eef X m\u00e0u xanh tr\u00ean thanh c\u00f4ng c\u1ee5, khi \u0111\u00f3 ch\u01b0\u01a1ng tr\u00ecnh hi\u1ec7n l\u00ean file ta c\u1ea7n k\u1ebft xu\u1ea5t nh\u01b0 d\u01b0\u1edbi<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

C\u00e1ch \u0111\u0103ng nh\u1eadp: Cu\u1ed1i k\u1ef3 \\ B\u00fat to\u00e1n kh\u00f3a s\u1ed5 Gi\u1ea3i th\u00edch m\u1ed9t s\u1ed1  th\u00f4ng tin c\u1eadp nh\u1eadt: S\u1ed1\u00a0th\u1ee9\u00a0t\u1ef1 S\u1ed1 th\u1ee9 t\u1ef1 s\u1eafp x\u1ebfp tr\u00ean m\u00e0n h\u00ecnh. Di\u1ec5n gi\u1ea3i N\u1ed9i dung c\u1ee7a b\u00fat to\u00e1n. T\u00e0i kho\u1ea3n\u00a0\u0111i T\u00e0i kho\u1ea3n m\u00e0 s\u1ebd k\u1ebft chuy\u1ec3n \u0111i T\u00e0i kho\u1ea3n\u00a0\u0111\u1ebfn T\u00e0i kho\u1ea3n \u0111\u1ed1i \u1ee9ng c\u1ee7a t\u00e0i kho\u1ea3n \u0111i. (Ch\u00fa \u00fd ph\u1ea3i l\u00e0 t\u00e0i kho\u1ea3n chi ti\u1ebft.) M\u1ed9t s\u1ed1 … <\/p>\n","protected":false},"author":156,"featured_media":2550,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[169,7,177],"tags":[236],"class_list":["post-1735","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-huong-dan-su-dung-phan-mem-lotus","category-ke-toan-hop-tac-xa","category-thong-tu-71-2024-tt-btc","tag-lap-bao-cao-tai-chinh-htx-theo-tt-7124-tt-btc","grid-sizer"],"_links":{"self":[{"href":"https:\/\/kthtx.vn\/index.php\/wp-json\/wp\/v2\/posts\/1735","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kthtx.vn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kthtx.vn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kthtx.vn\/index.php\/wp-json\/wp\/v2\/users\/156"}],"replies":[{"embeddable":true,"href":"https:\/\/kthtx.vn\/index.php\/wp-json\/wp\/v2\/comments?post=1735"}],"version-history":[{"count":8,"href":"https:\/\/kthtx.vn\/index.php\/wp-json\/wp\/v2\/posts\/1735\/revisions"}],"predecessor-version":[{"id":2552,"href":"https:\/\/kthtx.vn\/index.php\/wp-json\/wp\/v2\/posts\/1735\/revisions\/2552"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kthtx.vn\/index.php\/wp-json\/wp\/v2\/media\/2550"}],"wp:attachment":[{"href":"https:\/\/kthtx.vn\/index.php\/wp-json\/wp\/v2\/media?parent=1735"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kthtx.vn\/index.php\/wp-json\/wp\/v2\/categories?post=1735"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kthtx.vn\/index.php\/wp-json\/wp\/v2\/tags?post=1735"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}