﻿{"id":38759,"date":"2026-07-01T12:22:42","date_gmt":"2026-07-01T05:22:42","guid":{"rendered":"http:\/\/helpbumas.misa.vn\/v4\/?post_type=ht_kb&#038;p=38759"},"modified":"2026-08-17T09:13:13","modified_gmt":"2026-08-17T02:13:13","slug":"cau-hoi-thuong-gap-ve-lap-du-toan","status":"publish","type":"ht_kb","link":"\/v4\/knowledge-base\/cau-hoi-thuong-gap-ve-lap-du-toan\/","title":{"rendered":"C\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p v\u1ec1 L\u1eadp d\u1ef1 to\u00e1n"},"content":{"rendered":"<div class=\"su-accordion su-u-trim\">\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3>1. T\u1ed5ng quan<\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p>B\u00e0i vi\u1ebft t\u1ed5ng h\u1ee3p c\u00e1c c\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng <strong data-start=\"178\" data-end=\"193\">L\u1eadp d\u1ef1 to\u00e1n<\/strong>, gi\u00fap anh\/ch\u1ecb nhanh ch\u00f3ng x\u1eed l\u00fd nh\u1eefng t\u00ecnh hu\u1ed1ng ph\u1ed5 bi\u1ebfn nh\u01b0 kh\u00f4ng t\u00ecm th\u1ea5y d\u1eef li\u1ec7u d\u1ef1 to\u00e1n ho\u1eb7c b\u1ea3ng l\u01b0\u01a1ng \u0111\u00e3 nh\u1eadp, xu\u1ea5t kh\u1ea9u b\u1ea3ng l\u01b0\u01a1ng ra Excel v\u00e0 c\u00e1c thao t\u00e1c th\u01b0\u1eddng g\u1eb7p kh\u00e1c tr\u00ean b\u1ea3ng thuy\u1ebft minh. N\u1ebfu g\u1eb7p kh\u00f3 kh\u0103n trong qu\u00e1 tr\u00ecnh l\u1eadp d\u1ef1 to\u00e1n, anh\/ch\u1ecb c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1c h\u01b0\u1edbng d\u1eabn d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 ki\u1ec3m tra nguy\u00ean nh\u00e2n v\u00e0 th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc kh\u1eafc ph\u1ee5c.<\/p>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3>2. C\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p<\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<table>\n<tbody>\n<tr>\n<td>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h4>2.1. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 xu\u1ea5t kh\u1ea9u b\u1ea3ng l\u01b0\u01a1ng (thuy\u1ebft minh ti\u1ec1n l\u01b0\u01a1ng, ph\u1ee5 c\u1ea5p v\u00e0 c\u00e1c kho\u1ea3n \u0111\u00f3ng g\u00f3p) ra Excel?<\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p>\u0110\u1ec3 ph\u1ee5c v\u1ee5 vi\u1ec7c ki\u1ec3m tra, \u0111\u1ed1i chi\u1ebfu ho\u1eb7c l\u01b0u tr\u1eef d\u1eef li\u1ec7u ti\u1ec1n l\u01b0\u01a1ng, ph\u1ea7n m\u1ec1m h\u1ed7 tr\u1ee3 xu\u1ea5t kh\u1ea9u b\u1ea3ng thuy\u1ebft minh b\u1ea3ng l\u01b0\u01a1ng ra t\u1ec7p Excel. Ch\u1ee9c n\u0103ng n\u00e0y \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n ngay t\u1ea1i m\u00e0n h\u00ecnh l\u1eadp d\u1ef1 to\u00e1n chi th\u01b0\u1eddng xuy\u00ean.<\/p>\n<p><strong><span role=\"text\">Gi\u1ea3i ph\u00e1p:\u00a0<\/span><\/strong>Anh\/ch\u1ecb th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> V\u00e0o <strong>L\u1eadp d\u1ef1 to\u00e1n<\/strong> \u2192 <strong>L\u1eadp d\u1ef1 to\u00e1n nhu c\u1ea7u<\/strong>. T\u1ea1i d\u00f2ng <strong data-start=\"599\" data-end=\"619\">Chi th\u01b0\u1eddng xuy\u00ean<\/strong>, nh\u1ea5n <strong data-start=\"626\" data-end=\"641\">L\u1eadp d\u1ef1 to\u00e1n<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-38765 size-full\" src=\"\/v4\/wp-content\/uploads\/2026\/07\/lap-du-toan.png\" alt=\"\" width=\"1100\" height=\"734\" srcset=\"\/v4\/wp-content\/uploads\/2026\/07\/lap-du-toan.png 1100w, \/v4\/wp-content\/uploads\/2026\/07\/lap-du-toan-300x200.png 300w, \/v4\/wp-content\/uploads\/2026\/07\/lap-du-toan-1024x683.png 1024w, \/v4\/wp-content\/uploads\/2026\/07\/lap-du-toan-768x512.png 768w, \/v4\/wp-content\/uploads\/2026\/07\/lap-du-toan-50x33.png 50w, \/v4\/wp-content\/uploads\/2026\/07\/lap-du-toan-60x40.png 60w, \/v4\/wp-content\/uploads\/2026\/07\/lap-du-toan-100x67.png 100w\" sizes=\"auto, (max-width: 1100px) 100vw, 1100px\" \/><\/p>\n<p><strong data-start=\"644\" data-end=\"655\">B\u01b0\u1edbc 2:<\/strong> Trong danh s\u00e1ch n\u1ed9i dung d\u1ef1 to\u00e1n, t\u00ecm \u0111\u1ebfn d\u00f2ng <strong data-start=\"703\" data-end=\"748\">Ti\u1ec1n l\u01b0\u01a1ng, ph\u1ee5 c\u1ea5p v\u00e0 c\u00e1c kho\u1ea3n \u0111\u00f3ng g\u00f3p<\/strong>. Nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng <strong data-start=\"783\" data-end=\"798\">Thuy\u1ebft minh<\/strong> \u1edf cu\u1ed1i d\u00f2ng \u0111\u1ec3 m\u1edf b\u1ea3ng thuy\u1ebft minh ti\u1ec1n l\u01b0\u01a1ng. T\u1ea1i m\u00e0n h\u00ecnh <strong data-start=\"872\" data-end=\"887\">Thuy\u1ebft minh<\/strong>, nh\u1ea5n <strong data-start=\"894\" data-end=\"908\">Xu\u1ea5t Excel<\/strong> \u1edf g\u00f3c tr\u00ean b\u00ean ph\u1ea3i \u0111\u1ec3 xu\u1ea5t kh\u1ea9u b\u1ea3ng l\u01b0\u01a1ng ra t\u1ec7p Excel.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-38767 size-full\" src=\"\/v4\/wp-content\/uploads\/2026\/07\/xuat-khau-excel.png\" alt=\"\" width=\"1518\" height=\"829\" srcset=\"\/v4\/wp-content\/uploads\/2026\/07\/xuat-khau-excel.png 1518w, \/v4\/wp-content\/uploads\/2026\/07\/xuat-khau-excel-300x164.png 300w, \/v4\/wp-content\/uploads\/2026\/07\/xuat-khau-excel-1024x559.png 1024w, \/v4\/wp-content\/uploads\/2026\/07\/xuat-khau-excel-768x419.png 768w, \/v4\/wp-content\/uploads\/2026\/07\/xuat-khau-excel-50x27.png 50w, \/v4\/wp-content\/uploads\/2026\/07\/xuat-khau-excel-60x33.png 60w, \/v4\/wp-content\/uploads\/2026\/07\/xuat-khau-excel-100x55.png 100w\" sizes=\"auto, (max-width: 1518px) 100vw, 1518px\" \/><\/p>\n<p><strong data-start=\"970\" data-end=\"980\">L\u01b0u \u00fd:<\/strong> N\u00fat <strong data-start=\"985\" data-end=\"999\">Xu\u1ea5t Excel<\/strong> ch\u1ec9 hi\u1ec3n th\u1ecb sau khi anh\/ch\u1ecb m\u1edf m\u00e0n h\u00ecnh <strong data-start=\"1041\" data-end=\"1056\">Thuy\u1ebft minh<\/strong> c\u1ee7a n\u1ed9i dung <strong data-start=\"1070\" data-end=\"1115\">Ti\u1ec1n l\u01b0\u01a1ng, ph\u1ee5 c\u1ea5p v\u00e0 c\u00e1c kho\u1ea3n \u0111\u00f3ng g\u00f3p<\/strong>.<\/p>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h4>2.2. M\u1edf ph\u1ea7n m\u1ec1m nh\u01b0ng kh\u00f4ng th\u1ea5y d\u1eef li\u1ec7u d\u1ef1 to\u00e1n ho\u1eb7c kh\u00f4ng th\u1ea5y b\u1ea3ng l\u01b0\u01a1ng \u0111\u00e3 nh\u1eadp tr\u01b0\u1edbc \u0111\u00f3, ph\u1ea3i l\u00e0m th\u1ebf n\u00e0o?<\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p class=\"PDq2pG_selectionAnchorContainer\" data-start=\"187\" data-end=\"479\"><strong>Nguy\u00ean nh\u00e2n:<\/strong> N\u1ebfu anh\/ch\u1ecb \u0111\u00e3 nh\u1eadp d\u1eef li\u1ec7u d\u1ef1 to\u00e1n ho\u1eb7c b\u1ea3ng l\u01b0\u01a1ng nh\u01b0ng khi m\u1edf ph\u1ea7n m\u1ec1m l\u1ea1i kh\u00f4ng th\u1ea5y, nguy\u00ean nh\u00e2n ph\u1ed5 bi\u1ebfn l\u00e0 \u0111ang l\u00e0m vi\u1ec7c tr\u00ean <strong data-start=\"320\" data-end=\"342\">nh\u1ea7m n\u0103m ng\u00e2n s\u00e1ch<\/strong>. Khi ch\u1ecdn sai n\u0103m ng\u00e2n s\u00e1ch, ph\u1ea7n m\u1ec1m s\u1ebd ch\u1ec9 hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u c\u1ee7a n\u0103m \u0111ang \u0111\u01b0\u1ee3c ch\u1ecdn n\u00ean c\u00f3 th\u1ec3 khi\u1ebfn anh\/ch\u1ecb t\u01b0\u1edfng r\u1eb1ng d\u1eef li\u1ec7u b\u1ecb m\u1ea5t.<\/p>\n<p data-section-id=\"fe7krv\" data-start=\"481\" data-end=\"498\"><strong><span role=\"text\">Gi\u1ea3i ph\u00e1p:\u00a0<\/span><\/strong>Anh\/ch\u1ecb ki\u1ec3m tra l\u1ea1i n\u0103m ng\u00e2n s\u00e1ch \u0111ang l\u00e0m vi\u1ec7c theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p data-start=\"568\" data-end=\"643\"><strong data-start=\"568\" data-end=\"579\">B\u01b0\u1edbc 1:<\/strong> Nh\u1ea5n v\u00e0o <strong data-start=\"589\" data-end=\"613\">bi\u1ec3u t\u01b0\u1ee3ng h\u00ecnh ng\u01b0\u1eddi <\/strong>\u1edf g\u00f3c tr\u00ean b\u00ean ph\u1ea3i m\u00e0n h\u00ecnh.\u00a0Ch\u1ecdn <strong data-start=\"662\" data-end=\"679\">N\u0103m ng\u00e2n s\u00e1ch<\/strong>.<\/p>\n<p data-start=\"568\" data-end=\"643\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-38769 size-full\" src=\"\/v4\/wp-content\/uploads\/2026\/07\/nam-ngan-sach.png\" alt=\"\" width=\"1519\" height=\"824\" srcset=\"\/v4\/wp-content\/uploads\/2026\/07\/nam-ngan-sach.png 1519w, \/v4\/wp-content\/uploads\/2026\/07\/nam-ngan-sach-300x163.png 300w, \/v4\/wp-content\/uploads\/2026\/07\/nam-ngan-sach-1024x555.png 1024w, \/v4\/wp-content\/uploads\/2026\/07\/nam-ngan-sach-768x417.png 768w, \/v4\/wp-content\/uploads\/2026\/07\/nam-ngan-sach-50x27.png 50w, \/v4\/wp-content\/uploads\/2026\/07\/nam-ngan-sach-60x33.png 60w, \/v4\/wp-content\/uploads\/2026\/07\/nam-ngan-sach-100x54.png 100w\" sizes=\"auto, (max-width: 1519px) 100vw, 1519px\" \/><\/p>\n<p data-start=\"682\" data-end=\"851\"><strong data-start=\"682\" data-end=\"693\">B\u01b0\u1edbc 2:<\/strong> Ki\u1ec3m tra n\u0103m ng\u00e2n s\u00e1ch \u0111ang s\u1eed d\u1ee5ng. N\u1ebfu \u0111ang ch\u1ecdn sai n\u0103m, anh\/ch\u1ecb chuy\u1ec3n sang \u0111\u00fang <strong data-start=\"779\" data-end=\"796\">n\u0103m ng\u00e2n s\u00e1ch<\/strong> \u0111\u00e3 nh\u1eadp d\u1eef li\u1ec7u tr\u01b0\u1edbc \u0111\u00f3 (v\u00ed d\u1ee5: 2025, 2026, 2027&#8230;).<\/p>\n<p data-start=\"853\" data-end=\"986\"><strong data-start=\"853\" data-end=\"864\">B\u01b0\u1edbc 3:<\/strong> Sau khi chuy\u1ec3n \u0111\u00fang n\u0103m ng\u00e2n s\u00e1ch, truy c\u1eadp l\u1ea1i ch\u1ee9c n\u0103ng c\u1ea7n th\u1ef1c hi\u1ec7n (L\u1eadp d\u1ef1 to\u00e1n, B\u1ea3ng l\u01b0\u01a1ng&#8230;) \u0111\u1ec3 ki\u1ec3m tra d\u1eef li\u1ec7u.<\/p>\n<p data-start=\"990\" data-end=\"1186\" data-is-last-node=\"\"><strong data-start=\"990\" data-end=\"1000\">L\u01b0u \u00fd:<\/strong> D\u1eef li\u1ec7u \u0111\u01b0\u1ee3c qu\u1ea3n l\u00fd ri\u00eang theo t\u1eebng n\u0103m ng\u00e2n s\u00e1ch. V\u00ec v\u1eady, n\u1ebfu kh\u00f4ng th\u1ea5y d\u1eef li\u1ec7u ho\u1eb7c b\u1ea3ng l\u01b0\u01a1ng \u0111\u00e3 nh\u1eadp, anh\/ch\u1ecb n\u00ean ki\u1ec3m tra <strong data-start=\"1130\" data-end=\"1147\">n\u0103m ng\u00e2n s\u00e1ch<\/strong> tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c kh\u00e1c.<\/p>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h4>2.3. Khi l\u1eadp d\u1ef1 to\u00e1n, \u0111\u01a1n v\u1ecb c\u00f3 b\u1eaft bu\u1ed9c l\u1eadp b\u1ea3ng l\u01b0\u01a1ng ho\u1eb7c thuy\u1ebft minh ti\u1ec1n l\u01b0\u01a1ng kh\u00f4ng?<\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p class=\"PDq2pG_selectionAnchorContainer\" data-start=\"761\" data-end=\"933\">Vi\u1ec7c c\u00f3 b\u1eaft bu\u1ed9c l\u1eadp <strong data-start=\"782\" data-end=\"824\">b\u1ea3ng l\u01b0\u01a1ng ho\u1eb7c thuy\u1ebft minh ti\u1ec1n l\u01b0\u01a1ng<\/strong> khi l\u1eadp d\u1ef1 to\u00e1n <strong data-start=\"841\" data-end=\"881\">kh\u00f4ng ph\u1ee5 thu\u1ed9c v\u00e0o lo\u1ea1i h\u00ecnh \u0111\u01a1n v\u1ecb<\/strong>, m\u00e0 ph\u1ee5 thu\u1ed9c v\u00e0o <strong data-start=\"900\" data-end=\"932\">y\u00eau c\u1ea7u c\u1ee7a c\u01a1 quan c\u1ea5p tr\u00ean<\/strong>.<\/p>\n<p data-start=\"935\" data-end=\"983\">Th\u00f4ng th\u01b0\u1eddng s\u1ebd c\u00f3 m\u1ed9t trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p sau:<\/p>\n<ul data-start=\"985\" data-end=\"1193\">\n<li data-section-id=\"1np6m7k\" data-start=\"985\" data-end=\"1084\">C\u1ea5p tr\u00ean y\u00eau c\u1ea7u \u0111\u01a1n v\u1ecb \u0111\u00ednh k\u00e8m <strong data-start=\"1020\" data-end=\"1042\">file Excel t\u1ef1 t\u00ednh<\/strong> \u0111\u1ec3 ch\u1ee9ng minh s\u1ed1 li\u1ec7u d\u1ef1 to\u00e1n ti\u1ec1n l\u01b0\u01a1ng.<\/li>\n<li data-section-id=\"1er6wlk\" data-start=\"1085\" data-end=\"1193\">C\u1ea5p tr\u00ean ban h\u00e0nh <strong data-start=\"1105\" data-end=\"1145\">bi\u1ec3u m\u1eabu thuy\u1ebft minh<\/strong>\u00a0\u0111\u1ec3 c\u00e1c \u0111\u01a1n v\u1ecb c\u1ea5p d\u01b0\u1edbi th\u1ef1c hi\u1ec7n theo \u0111\u00fang m\u1eabu.<\/li>\n<\/ul>\n<p data-start=\"1195\" data-end=\"1221\">\u0110\u1ec3 ki\u1ec3m tra tr\u00ean ph\u1ea7n m\u1ec1m:<\/p>\n<ol data-start=\"1223\" data-end=\"1432\">\n<li data-section-id=\"1d2mkc5\" data-start=\"1223\" data-end=\"1294\">Khi l\u1eadp <strong data-start=\"1234\" data-end=\"1258\">D\u1ef1 to\u00e1n theo nhu c\u1ea7u<\/strong>, ch\u1ecdn <strong data-start=\"1265\" data-end=\"1293\">D\u1ef1 to\u00e1n chi th\u01b0\u1eddng xuy\u00ean<\/strong>.<\/li>\n<li data-section-id=\"m9spmp\" data-start=\"1295\" data-end=\"1337\">Ch\u1ecdn <strong data-start=\"1303\" data-end=\"1319\">N\u1ed9i dung chi<\/strong> l\u00e0 <strong data-start=\"1323\" data-end=\"1336\">Chi l\u01b0\u01a1ng (Ti\u1ec1n l\u01b0\u01a1ng,&#8230;)<\/strong><\/li>\n<li data-section-id=\"kq69vz\" data-start=\"1338\" data-end=\"1432\">Ch\u1ecdn tab <strong data-start=\"1350\" data-end=\"1365\">Thuy\u1ebft minh<\/strong> \u1edf b\u00ean ph\u1ea3i \u0111\u1ec3 ki\u1ec3m tra xem c\u1ea5p tr\u00ean \u0111\u00e3 ban h\u00e0nh bi\u1ec3u m\u1eabu hay ch\u01b0a.<\/li>\n<\/ol>\n<p data-start=\"1434\" data-end=\"1590\">N\u1ebfu kh\u00f4ng c\u00f3 bi\u1ec3u m\u1eabu ho\u1eb7c ch\u01b0a r\u00f5 \u0111\u01a1n v\u1ecb m\u00ecnh c\u00f3 ph\u1ea3i l\u1eadp b\u1ea3ng l\u01b0\u01a1ng hay kh\u00f4ng, anh\/ch\u1ecb vui l\u00f2ng li\u00ean h\u1ec7 c\u01a1 quan c\u1ea5p tr\u00ean \u0111\u1ec3 \u0111\u01b0\u1ee3c h\u01b0\u1edbng d\u1eabn theo quy \u0111\u1ecbnh.<\/p>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h4>2.4. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 th\u00eam ho\u1eb7c x\u00f3a d\u00f2ng, c\u1ed9t tr\u00ean b\u1ea3ng Thuy\u1ebft minh \u0111\u00e3 l\u01b0u?<\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p class=\"isSelectedEnd\"><strong>Bi\u1ec3u hi\u1ec7n:<\/strong> Anh\/ch\u1ecb \u0111\u00e3 l\u1eadp v\u00e0 l\u01b0u b\u1ea3ng <strong>Thuy\u1ebft minh<\/strong>, tuy nhi\u00ean khi c\u1ea7n b\u1ed5 sung th\u00eam c\u00e1n b\u1ed9, nh\u00e2n vi\u00ean, th\u00eam c\u1ed9t ho\u1eb7c x\u00f3a c\u00e1c d\u00f2ng kh\u00f4ng c\u00f2n s\u1eed d\u1ee5ng th\u00ec kh\u00f4ng bi\u1ebft c\u00e1ch th\u1ef1c hi\u1ec7n.<\/p>\n<p class=\"isSelectedEnd\"><strong>C\u00e1ch th\u1ef1c hi\u1ec7n:<\/strong> Tr\u00ean tab <strong>Thuy\u1ebft minh<\/strong>, anh\/ch\u1ecb th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p class=\"isSelectedEnd\"><strong>B\u01b0\u1edbc 1:<\/strong> Nh\u1ea5n <strong>S\u1eeda<\/strong> \u1edf g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i m\u00e0n h\u00ecnh \u0111\u1ec3 chuy\u1ec3n b\u1ea3ng Thuy\u1ebft minh sang ch\u1ebf \u0111\u1ed9 ch\u1ec9nh s\u1eeda.<\/p>\n<p class=\"isSelectedEnd\"><strong>B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn d\u00f2ng ho\u1eb7c c\u1ed9t c\u1ea7n thao t\u00e1c, sau \u0111\u00f3 nh\u1ea5n <strong>chu\u1ed9t ph\u1ea3i<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-38865 size-full\" src=\"\/v4\/wp-content\/uploads\/2026\/07\/DILF4STNFE.png\" alt=\"\" width=\"1369\" height=\"845\" srcset=\"\/v4\/wp-content\/uploads\/2026\/07\/DILF4STNFE.png 1369w, \/v4\/wp-content\/uploads\/2026\/07\/DILF4STNFE-300x185.png 300w, \/v4\/wp-content\/uploads\/2026\/07\/DILF4STNFE-1024x632.png 1024w, \/v4\/wp-content\/uploads\/2026\/07\/DILF4STNFE-768x474.png 768w, \/v4\/wp-content\/uploads\/2026\/07\/DILF4STNFE-50x31.png 50w, \/v4\/wp-content\/uploads\/2026\/07\/DILF4STNFE-60x37.png 60w, \/v4\/wp-content\/uploads\/2026\/07\/DILF4STNFE-100x62.png 100w\" sizes=\"auto, (max-width: 1369px) 100vw, 1369px\" \/><\/p>\n<p class=\"isSelectedEnd\"><strong>B\u01b0\u1edbc 3:<\/strong> Ch\u1ecdn ch\u1ee9c n\u0103ng ph\u00f9 h\u1ee3p:<\/p>\n<ul data-spread=\"false\">\n<li><strong>Th\u00eam d\u00f2ng l\u00ean tr\u00ean<\/strong>: Ch\u00e8n m\u1ed9t d\u00f2ng m\u1edbi ph\u00eda tr\u00ean d\u00f2ng \u0111ang ch\u1ecdn.<\/li>\n<li><strong>Th\u00eam d\u00f2ng xu\u1ed1ng d\u01b0\u1edbi<\/strong>: Ch\u00e8n m\u1ed9t d\u00f2ng m\u1edbi ph\u00eda d\u01b0\u1edbi d\u00f2ng \u0111ang ch\u1ecdn.<\/li>\n<li><strong>X\u00f3a d\u00f2ng<\/strong>: X\u00f3a d\u00f2ng \u0111ang ch\u1ecdn kh\u1ecfi b\u1ea3ng Thuy\u1ebft minh.<\/li>\n<li><strong>Th\u00eam c\u1ed9t<\/strong>: Ch\u00e8n th\u00eam c\u1ed9t \u0111\u1ec3 b\u1ed5 sung th\u00f4ng tin theo nhu c\u1ea7u (n\u1ebfu \u0111\u01b0\u1ee3c ph\u00e9p ch\u1ec9nh s\u1eeda).<\/li>\n<\/ul>\n<p class=\"isSelectedEnd\"><strong>B\u01b0\u1edbc 4:<\/strong> Th\u1ef1c hi\u1ec7n nh\u1eadp ho\u1eb7c \u0111i\u1ec1u ch\u1ec9nh th\u00f4ng tin (n\u1ebfu c\u00f3), sau \u0111\u00f3 nh\u1ea5n <strong>L\u01b0u<\/strong> \u0111\u1ec3 ho\u00e0n t\u1ea5t.<\/p>\n<p class=\"isSelectedEnd\"><strong>L\u01b0u \u00fd:<\/strong><\/p>\n<ul data-spread=\"true\">\n<li>N\u1ebfu khi nh\u1ea5n chu\u1ed9t ph\u1ea3i ch\u1ec9 hi\u1ec3n th\u1ecb c\u00e1c t\u00f9y ch\u1ecdn <strong>\u1ea8n d\u00f2ng<\/strong> v\u00e0 <strong>Hi\u1ec7n d\u00f2ng<\/strong> m\u00e0 kh\u00f4ng c\u00f3 c\u00e1c ch\u1ee9c n\u0103ng <strong>Th\u00eam d\u00f2ng l\u00ean tr\u00ean<\/strong>, <strong>Th\u00eam d\u00f2ng xu\u1ed1ng d\u01b0\u1edbi<\/strong> ho\u1eb7c <strong>X\u00f3a d\u00f2ng<\/strong>, anh\/ch\u1ecb vui l\u00f2ng ki\u1ec3m tra l\u1ea1i v\u00e0 \u0111\u1ea3m b\u1ea3o \u0111\u00e3 nh\u1ea5n <strong>S\u1eeda<\/strong> \u1edf g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i m\u00e0n h\u00ecnh tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n.<\/li>\n<li><strong>\u0110\u1ed1i v\u1edbi b\u1ea3ng Thuy\u1ebft minh do \u0111\u01a1n v\u1ecb c\u1ea5p tr\u00ean ban h\u00e0nh:<\/strong> Anh\/ch\u1ecb c\u00f3 th\u1ec3 th\u00eam ho\u1eb7c x\u00f3a c\u00e1c <strong>d\u00f2ng chi ti\u1ebft<\/strong>. Tuy nhi\u00ean, vi\u1ec7c <strong>th\u00eam c\u1ed9t<\/strong> c\u00f3 th\u1ec3 l\u00e0m c\u1ea5u tr\u00fac b\u1ea3ng Thuy\u1ebft minh c\u1ee7a \u0111\u01a1n v\u1ecb c\u1ea5p d\u01b0\u1edbi kh\u00e1c v\u1edbi m\u1eabu do c\u1ea5p tr\u00ean ban h\u00e0nh. \u0110\u1ec3 \u0111\u1ea3m b\u1ea3o th\u1ed1ng nh\u1ea5t d\u1eef li\u1ec7u, anh\/ch\u1ecb n\u00ean trao \u0111\u1ed5i v\u00e0 \u0111\u1ec1 ngh\u1ecb <strong>\u0111\u01a1n v\u1ecb c\u1ea5p tr\u00ean<\/strong> b\u1ed5 sung c\u1ed9t tr\u00ean m\u1eabu tr\u01b0\u1edbc khi c\u00e1c \u0111\u01a1n v\u1ecb c\u1ea5p d\u01b0\u1edbi th\u1ef1c hi\u1ec7n l\u1eadp Thuy\u1ebft minh. Tr\u01b0\u1eddng h\u1ee3p \u0111\u01a1n v\u1ecb c\u1ea5p tr\u00ean cho ph\u00e9p, \u0111\u01a1n v\u1ecb c\u1ea5p d\u01b0\u1edbi m\u1edbi n\u00ean t\u1ef1 b\u1ed5 sung c\u1ed9t.<\/li>\n<li><strong>\u0110\u1ed1i v\u1edbi b\u1ea3ng Thuy\u1ebft minh do \u0111\u01a1n v\u1ecb t\u1ef1 t\u1ea1o ho\u1eb7c kh\u00f4ng c\u00f3 c\u1ea5u tr\u00fac chi ti\u1ebft theo t\u1eebng ch\u1ec9 ti\u00eau chi:<\/strong> Anh\/ch\u1ecb c\u00f3 th\u1ec3 ch\u1ee7 \u0111\u1ed9ng <strong>th\u00eam, s\u1eeda, x\u00f3a d\u00f2ng v\u00e0 c\u1ed9t<\/strong> theo nhu c\u1ea7u \u0111\u1ec3 ph\u00f9 h\u1ee3p v\u1edbi n\u1ed9i dung c\u1ea7n thuy\u1ebft minh.<\/li>\n<\/ul>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h4>2.5. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 bi\u1ebft \u0111\u01b0\u1ee3c n\u1ed9i dung chi n\u00e0o c\u00f3 b\u1ea3ng Thuy\u1ebft minh l\u00e0 c\u1ee7a c\u1ea5p tr\u00ean ban h\u00e0nh xu\u1ed1ng?<\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p class=\"PDq2pG_selectionAnchorContainer\" data-start=\"157\" data-end=\"319\"><strong data-start=\"157\" data-end=\"171\">Bi\u1ec3u hi\u1ec7n: <\/strong>Anh\/ch\u1ecb mu\u1ed1n bi\u1ebft n\u1ed9i dung chi n\u00e0o s\u1eed d\u1ee5ng b\u1ea3ng <strong data-start=\"222\" data-end=\"265\">Thuy\u1ebft minh do \u0111\u01a1n v\u1ecb c\u1ea5p tr\u00ean ban h\u00e0nh<\/strong> v\u00e0 n\u1ed9i dung chi n\u00e0o \u0111\u01a1n v\u1ecb c\u00f3 th\u1ec3 t\u1ef1 l\u1eadp Thuy\u1ebft minh.<\/p>\n<p data-start=\"321\" data-end=\"340\"><strong data-start=\"321\" data-end=\"340\">C\u00e1ch nh\u1eadn bi\u1ebft: <\/strong>Tr\u00ean m\u00e0n h\u00ecnh <strong data-start=\"356\" data-end=\"388\">L\u1eadp d\u1ef1 to\u00e1n chi th\u01b0\u1eddng xuy\u00ean<\/strong>, t\u1ea1i danh s\u00e1ch c\u00e1c n\u1ed9i dung chi:<\/p>\n<ul data-start=\"423\" data-end=\"891\">\n<li data-section-id=\"fc723a\" data-start=\"423\" data-end=\"619\">C\u00e1c n\u1ed9i dung chi c\u00f3 <strong data-start=\"445\" data-end=\"471\">bi\u1ec3u t\u01b0\u1ee3ng Thuy\u1ebft minh<\/strong>\u00a0\u1edf cu\u1ed1i d\u00f2ng l\u00e0 <strong data-start=\"495\" data-end=\"543\">b\u1ea3ng Thuy\u1ebft minh do \u0111\u01a1n v\u1ecb c\u1ea5p tr\u00ean ban h\u00e0nh<\/strong>. Anh\/ch\u1ecb c\u1ea7n th\u1ef1c hi\u1ec7n l\u1eadp Thuy\u1ebft minh theo m\u1eabu \u0111\u00e3 \u0111\u01b0\u1ee3c c\u1ea5p tr\u00ean thi\u1ebft l\u1eadp.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-38877 size-full\" src=\"\/v4\/wp-content\/uploads\/2026\/07\/uJZ8rKICU5-1.png\" alt=\"\" width=\"964\" height=\"600\" srcset=\"\/v4\/wp-content\/uploads\/2026\/07\/uJZ8rKICU5-1.png 964w, \/v4\/wp-content\/uploads\/2026\/07\/uJZ8rKICU5-1-300x187.png 300w, \/v4\/wp-content\/uploads\/2026\/07\/uJZ8rKICU5-1-768x478.png 768w, \/v4\/wp-content\/uploads\/2026\/07\/uJZ8rKICU5-1-50x31.png 50w, \/v4\/wp-content\/uploads\/2026\/07\/uJZ8rKICU5-1-60x37.png 60w, \/v4\/wp-content\/uploads\/2026\/07\/uJZ8rKICU5-1-100x62.png 100w\" sizes=\"auto, (max-width: 964px) 100vw, 964px\" \/><\/p>\n<ul data-start=\"423\" data-end=\"891\">\n<li data-section-id=\"1y6vjqe\" data-start=\"621\" data-end=\"891\">C\u00e1c n\u1ed9i dung chi <strong data-start=\"640\" data-end=\"675\">kh\u00f4ng c\u00f3 bi\u1ec3u t\u01b0\u1ee3ng Thuy\u1ebft minh<\/strong> c\u1ee7a c\u1ea5p tr\u00ean th\u00ec \u0111\u01a1n v\u1ecb <strong data-start=\"700\" data-end=\"722\">t\u1ef1 l\u1eadp Thuy\u1ebft minh<\/strong>. Khi m\u1edf tab <strong data-start=\"735\" data-end=\"750\">Thuy\u1ebft minh<\/strong>, anh\/ch\u1ecb c\u00f3 th\u1ec3:\n<ul data-start=\"770\" data-end=\"891\">\n<li data-section-id=\"1ajqbpy\" data-start=\"770\" data-end=\"822\">Nh\u1eadp tay tr\u1ef1c ti\u1ebfp n\u1ed9i dung Thuy\u1ebft minh tr\u00ean ph\u1ea7n m\u1ec1m ho\u1eb7c <b data-path-to-node=\"4,1,1,0,0\" data-index-in-node=\"43\">sao ch\u00e9p (copy) s\u1ed1 li\u1ec7u t\u1eeb t\u1ec7p Excel b\u00ean ngo\u00e0i d\u00e1n (paste) tr\u1ef1c ti\u1ebfp v\u00e0o b\u1ea3ng Thuy\u1ebft minh<\/b> (<i data-path-to-node=\"4,1,1,0,0\" data-index-in-node=\"126\">L\u01b0u \u00fd: Ph\u1ea7n m\u1ec1m ch\u01b0a h\u1ed7 tr\u1ee3 t\u1ea3i\/import tr\u1ef1c ti\u1ebfp t\u1ec7p Excel v\u00e0o b\u1ea3ng Thuy\u1ebft minh<\/i>).<\/li>\n<li data-section-id=\"12mgq1r\" data-start=\"825\" data-end=\"891\">T\u1ea3i t\u1ec7p Excel l\u00ean m\u1ee5c <b data-path-to-node=\"4,1,1,1,0\" data-index-in-node=\"22\">\u0110\u00ednh k\u00e8m<\/b> n\u1ebfu c\u1ea7n l\u01b0u tr\u1eef ho\u1eb7c theo d\u00f5i ri\u00eang.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p data-start=\"893\" data-end=\"903\"><strong data-start=\"893\" data-end=\"903\">L\u01b0u \u00fd:<\/strong><\/p>\n<ul data-start=\"905\" data-end=\"1277\">\n<li data-section-id=\"6ytdfv\" data-start=\"905\" data-end=\"1162\">\u0110\u1ed1i v\u1edbi c\u00e1c b\u1ea3ng Thuy\u1ebft minh do c\u1ea5p tr\u00ean ban h\u00e0nh, \u0111\u01a1n v\u1ecb n\u00ean th\u1ef1c hi\u1ec7n theo \u0111\u00fang m\u1eabu \u0111\u00e3 \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp. N\u1ebfu c\u1ea7n b\u1ed5 sung th\u00eam c\u1ed9t ho\u1eb7c thay \u0111\u1ed5i c\u1ea5u tr\u00fac c\u1ee7a b\u1ea3ng Thuy\u1ebft minh, anh\/ch\u1ecb n\u00ean trao \u0111\u1ed5i v\u1edbi \u0111\u01a1n v\u1ecb c\u1ea5p tr\u00ean \u0111\u1ec3 \u0111\u01b0\u1ee3c th\u1ed1ng nh\u1ea5t tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n.<\/li>\n<li data-section-id=\"vtoyxp\" data-start=\"1163\" data-end=\"1277\">\u0110\u1ed1i v\u1edbi c\u00e1c b\u1ea3ng Thuy\u1ebft minh do \u0111\u01a1n v\u1ecb t\u1ef1 l\u1eadp, anh\/ch\u1ecb c\u00f3 th\u1ec3 ch\u1ee7 \u0111\u1ed9ng b\u1ed5 sung, ch\u1ec9nh s\u1eeda n\u1ed9i dung theo nhu c\u1ea7u.<\/li>\n<\/ul>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h4>2.6. T\u1ea1i sao tr\u00ean thuy\u1ebft minh l\u01b0\u01a1ng kh\u00f4ng hi\u1ec3n th\u1ecb c\u1ed9t 2% kinh ph\u00ed c\u00f4ng \u0111o\u00e0n (KPC\u0110)?<\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p class=\"PDq2pG_selectionAnchorContainer\" data-section-id=\"1iuozlf\" data-start=\"248\" data-end=\"261\"><strong>Bi\u1ec3u hi\u1ec7n:\u00a0<\/strong>Khi l\u1eadp d\u1ef1 to\u00e1n nhu c\u1ea7u n\u0103m 2027, anh\/ch\u1ecb g\u1eb7p m\u1ed9t trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p sau:<\/p>\n<ul data-start=\"340\" data-end=\"507\">\n<li data-section-id=\"1vj137j\" data-start=\"340\" data-end=\"433\">Mu\u1ed1n thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c t\u00ednh <strong data-start=\"372\" data-end=\"404\">2% kinh ph\u00ed c\u00f4ng \u0111o\u00e0n (KPC\u0110)<\/strong> tr\u00ean b\u1ea3ng thuy\u1ebft minh l\u01b0\u01a1ng.<\/li>\n<li data-section-id=\"3tljjs\" data-start=\"434\" data-end=\"507\">Kh\u00f4ng th\u1ea5y c\u1ed9t <strong data-start=\"451\" data-end=\"478\">Kinh ph\u00ed c\u00f4ng \u0111o\u00e0n (2%)<\/strong> tr\u00ean b\u1ea3ng thuy\u1ebft minh l\u01b0\u01a1ng.<\/li>\n<\/ul>\n<p data-section-id=\"1ha9u4r\" data-start=\"509\" data-end=\"523\"><strong>C\u00e1ch x\u1eed l\u00fd:\u00a0<\/strong><\/p>\n<p data-start=\"525\" data-end=\"580\"><strong><span style=\"font-size: 12pt;\">Tr\u01b0\u1eddng h\u1ee3p 1: \u0110\u00e3 c\u00f3 c\u1ed9t KPC\u0110 tr\u00ean b\u1ea3ng thuy\u1ebft minh<\/span><\/strong><\/p>\n<p data-start=\"582\" data-end=\"738\">N\u1ebfu tr\u00ean b\u1ea3ng <strong data-start=\"596\" data-end=\"617\">Thuy\u1ebft minh l\u01b0\u01a1ng<\/strong> \u0111\u00e3 c\u00f3 c\u1ed9t <strong data-start=\"628\" data-end=\"655\">Kinh ph\u00ed c\u00f4ng \u0111o\u00e0n (2%)<\/strong>, anh\/ch\u1ecb c\u00f3 th\u1ec3 m\u1edf m\u1eabu Excel \u0111\u1ec3 thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c t\u00ednh theo quy \u0111\u1ecbnh c\u1ee7a \u0111\u01a1n v\u1ecb.<\/p>\n<p data-start=\"740\" data-end=\"798\">Th\u00f4ng th\u01b0\u1eddng, kinh ph\u00ed c\u00f4ng \u0111o\u00e0n \u0111\u01b0\u1ee3c t\u00ednh theo c\u00f4ng th\u1ee9c:<\/p>\n<p data-start=\"802\" data-end=\"867\"><strong data-start=\"802\" data-end=\"867\">Kinh ph\u00ed c\u00f4ng \u0111o\u00e0n = Qu\u1ef9 ti\u1ec1n l\u01b0\u01a1ng l\u00e0m c\u0103n c\u1ee9 \u0111\u00f3ng BHXH \u00d7 2%<\/strong><\/p>\n<p data-start=\"869\" data-end=\"886\">V\u00ed d\u1ee5 tr\u00ean Excel: c\u1ed9t <strong data-start=\"802\" data-end=\"867\">Kinh ph\u00ed c\u00f4ng \u0111o\u00e0n <\/strong>= &lt;\u00d4 ch\u1ee9a t\u1ed5ng ti\u1ec1n l\u01b0\u01a1ng l\u00e0m c\u0103n c\u1ee9 \u0111\u00f3ng BHXH&gt;*2%.<\/p>\n<p data-start=\"951\" data-end=\"1024\">Sau khi thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c, l\u01b0u m\u1eabu \u0111\u1ec3 ph\u1ea7n m\u1ec1m s\u1eed d\u1ee5ng khi l\u1eadp d\u1ef1 to\u00e1n.<\/p>\n<p data-start=\"1028\" data-end=\"1194\"><strong data-start=\"1028\" data-end=\"1038\">L\u01b0u \u00fd:<\/strong> C\u1ed9t d\u00f9ng l\u00e0m c\u0103n c\u1ee9 t\u00ednh KPC\u0110 c\u00f3 th\u1ec3 kh\u00e1c nhau t\u00f9y theo m\u1eabu bi\u1ec3u v\u00e0 y\u00eau c\u1ea7u c\u1ee7a \u0111\u01a1n v\u1ecb. Anh\/ch\u1ecb c\u1ea7n thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c theo \u0111\u00fang quy \u0111\u1ecbnh c\u1ee7a \u0111\u01a1n v\u1ecb m\u00ecnh.<\/p>\n<p data-start=\"1201\" data-end=\"1259\"><strong><span style=\"font-size: 12pt;\">Tr\u01b0\u1eddng h\u1ee3p 2: Kh\u00f4ng c\u00f3 c\u1ed9t KPC\u0110 tr\u00ean b\u1ea3ng thuy\u1ebft minh<\/span><\/strong><\/p>\n<p data-start=\"1261\" data-end=\"1418\">N\u1ebfu m\u1edf <strong data-start=\"1268\" data-end=\"1289\">Thuy\u1ebft minh l\u01b0\u01a1ng<\/strong> nh\u01b0ng kh\u00f4ng th\u1ea5y c\u1ed9t <strong data-start=\"1311\" data-end=\"1338\">Kinh ph\u00ed c\u00f4ng \u0111o\u00e0n (2%)<\/strong>, nguy\u00ean nh\u00e2n l\u00e0 m\u1eabu thuy\u1ebft minh do c\u1ea5p tr\u00ean ban h\u00e0nh ch\u01b0a b\u1ed5 sung ch\u1ec9 ti\u00eau n\u00e0y.<\/p>\n<p data-start=\"1420\" data-end=\"1691\">Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, anh\/ch\u1ecb vui l\u00f2ng <strong data-start=\"1459\" data-end=\"1486\">li\u00ean h\u1ec7 \u0111\u01a1n v\u1ecb c\u1ea5p tr\u00ean<\/strong> \u0111\u1ec3 ki\u1ec3m tra v\u00e0 c\u1eadp nh\u1eadt m\u1eabu thuy\u1ebft minh. Sau khi c\u1ea5p tr\u00ean b\u1ed5 sung v\u00e0 ban h\u00e0nh l\u1ea1i m\u1eabu, \u0111\u01a1n v\u1ecb c\u1ea5p d\u01b0\u1edbi s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1ed3ng b\u1ed9 v\u00e0 hi\u1ec3n th\u1ecb c\u1ed9t <strong data-start=\"1622\" data-end=\"1649\">Kinh ph\u00ed c\u00f4ng \u0111o\u00e0n (2%)<\/strong> \u0111\u1ec3 nh\u1eadp s\u1ed1 li\u1ec7u ho\u1eb7c thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c.<\/p>\n<p data-start=\"1420\" data-end=\"1691\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-38883 size-full\" src=\"\/v4\/wp-content\/uploads\/2026\/07\/thuyet-minh-bang-luong-1.png\" alt=\"\" width=\"1262\" height=\"620\" srcset=\"\/v4\/wp-content\/uploads\/2026\/07\/thuyet-minh-bang-luong-1.png 1262w, \/v4\/wp-content\/uploads\/2026\/07\/thuyet-minh-bang-luong-1-300x147.png 300w, \/v4\/wp-content\/uploads\/2026\/07\/thuyet-minh-bang-luong-1-1024x503.png 1024w, \/v4\/wp-content\/uploads\/2026\/07\/thuyet-minh-bang-luong-1-768x377.png 768w, \/v4\/wp-content\/uploads\/2026\/07\/thuyet-minh-bang-luong-1-50x25.png 50w, \/v4\/wp-content\/uploads\/2026\/07\/thuyet-minh-bang-luong-1-60x29.png 60w, \/v4\/wp-content\/uploads\/2026\/07\/thuyet-minh-bang-luong-1-100x49.png 100w\" sizes=\"auto, (max-width: 1262px) 100vw, 1262px\" \/><\/p>\n<p data-start=\"1695\" data-end=\"1829\"><strong>L\u01b0u \u00fd:<\/strong> \u0110\u01a1n v\u1ecb c\u1ea5p d\u01b0\u1edbi kh\u00f4ng th\u1ec3 t\u1ef1 b\u1ed5 sung c\u1ed9t Kinh ph\u00ed c\u00f4ng \u0111o\u00e0n (2%) n\u1ebfu \u0111ang s\u1eed d\u1ee5ng m\u1eabu thuy\u1ebft minh do c\u1ea5p tr\u00ean ban h\u00e0nh.<\/p>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h4>2.7. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 xem t\u1ed5ng ti\u1ec1n, t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng tr\u00ean b\u1ea3ng thuy\u1ebft minh? <\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p data-start=\"590\" data-end=\"601\"><strong>V\u1ea5n \u0111\u1ec1:<\/strong> Anh\/ch\u1ecb mu\u1ed1n xem <strong data-start=\"573\" data-end=\"608\">t\u1ed5ng s\u1ed1 ti\u1ec1n, t\u1ed3ng s\u1ed1 l\u01b0\u1ee3ng tr\u00ean b\u1ea3ng thuy\u1ebft minh<\/strong>\u00a0nh\u01b0ng ch\u01b0a bi\u1ebft c\u00e1ch t\u00ednh tr\u00ean ph\u1ea7n m\u1ec1m.<\/p>\n<ul>\n<li data-start=\"590\" data-end=\"601\">Xem t\u1ed5ng s\u1ed1 ti\u1ec1n l\u01b0\u01a1ng c\u1ee7a c\u00e1n b\u1ed9, c\u00f4ng ch\u1ee9c, vi\u00ean ch\u1ee9c, h\u1ee3p \u0111\u1ed3ng<\/li>\n<li data-start=\"590\" data-end=\"601\">Xem t\u1ed5ng s\u1ed1 ti\u1ec1n ph\u1ee5 c\u1ea5p kh\u00e1c nh\u01b0: h\u1ed7 tr\u1ee3 t\u1ebft, ngh\u1ec9 l\u1ec5&#8230;.<\/li>\n<\/ul>\n<p class=\"PDq2pG_selectionAnchorContainer\" data-start=\"590\" data-end=\"601\"><strong data-start=\"590\" data-end=\"601\">Tr\u1ea3 l\u1eddi:\u00a0<\/strong>Hi\u1ec7n t\u1ea1i, <strong data-start=\"613\" data-end=\"708\">tab Thuy\u1ebft minh ch\u01b0a h\u1ed7 tr\u1ee3 xem nhanh t\u1ed5ng gi\u00e1 tr\u1ecb b\u1eb1ng c\u00e1ch k\u00e9o chu\u1ed9t b\u00f4i \u0111en v\u00f9ng d\u1eef li\u1ec7u<\/strong> nh\u01b0 Microsoft Excel.<\/p>\n<p data-start=\"731\" data-end=\"794\">Tuy nhi\u00ean, anh\/ch\u1ecb v\u1eabn c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n m\u1ed9t trong hai c\u00e1ch sau:<\/p>\n<ul data-start=\"796\" data-end=\"1037\">\n<li data-section-id=\"6yg2iv\" data-start=\"796\" data-end=\"913\"><strong data-start=\"798\" data-end=\"809\">C\u00e1ch 1:<\/strong> Nh\u1eadp c\u00f4ng th\u1ee9c <strong>=SUM(&#8230;)<\/strong> v\u00e0o m\u1ed9t \u00f4 tr\u00ean b\u1ea3ng Thuy\u1ebft minh \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u1ee7a c\u1ed9t ho\u1eb7c d\u00f2ng c\u1ea7n t\u00ednh.<\/li>\n<li data-section-id=\"1k4loya\" data-start=\"914\" data-end=\"1037\"><strong data-start=\"916\" data-end=\"927\">C\u00e1ch 2:<\/strong> Nh\u1ea5n <strong data-start=\"933\" data-end=\"947\">Xu\u1ea5t Excel<\/strong>, sau \u0111\u00f3 s\u1eed d\u1ee5ng c\u00e1c ch\u1ee9c n\u0103ng t\u00ednh t\u1ed5ng c\u1ee7a Microsoft Excel \u0111\u1ec3 th\u1ed1ng k\u00ea v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u.<\/li>\n<\/ul>\n<p data-start=\"1041\" data-end=\"1270\"><strong data-start=\"1041\" data-end=\"1051\">L\u01b0u \u00fd:<\/strong><\/p>\n<ul>\n<li data-start=\"1041\" data-end=\"1270\">Ph\u1ea7n m\u1ec1m h\u1ed7 tr\u1ee3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c cho t\u1eebng \u00f4 <strong>=SUM(&#8230;), = Count(&#8230;),&#8230;<\/strong>\u00a0nh\u01b0ng <strong data-start=\"1105\" data-end=\"1249\">kh\u00f4ng h\u1ed7 tr\u1ee3 t\u00ednh n\u0103ng b\u00f4i \u0111en nhi\u1ec1u \u00f4 \u0111\u1ec3 hi\u1ec3n th\u1ecb nhanh gi\u00e1 tr\u1ecb T\u1ed5ng (Sum), Trung b\u00ecnh (Average), S\u1ed1 l\u01b0\u1ee3ng (Count)&#8230; tr\u00ean thanh tr\u1ea1ng th\u00e1i<\/strong> nh\u01b0 Microsoft Excel.<\/li>\n<li>\u0110\u1ed1i v\u1edbi c\u00e1c b\u1ea3ng Thuy\u1ebft minh do c\u1ea5p tr\u00ean ban h\u00e0nh, \u0111\u00e3 thi\u1ebft l\u1eadp s\u1eb5n c\u00f4ng th\u1ee9c t\u1ed5ng, n\u1ebfu c\u00f3 thay \u0111\u1ed5i c\u1ea5u tr\u00fac c\u1ee7a b\u1ea3ng Thuy\u1ebft minh, anh\/ch\u1ecb n\u00ean trao \u0111\u1ed5i v\u1edbi \u0111\u01a1n v\u1ecb c\u1ea5p tr\u00ean \u0111\u1ec3 \u0111\u01b0\u1ee3c th\u1ed1ng nh\u1ea5t tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n.<\/li>\n<\/ul>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h4>2.8. T\u1ea1i sao kh\u00f4ng s\u1eeda \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c c\u1ed9t t\u1ed5ng ( t\u1ed5ng s\u1ed1 ti\u1ec1n, th\u00e0nh ti\u1ec1n...) tr\u00ean b\u00e1o c\u00e1o c\u1ea5p tr\u00ean ban h\u00e0nh?<\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><strong>Bi\u1ec3u hi\u1ec7n:<\/strong><\/p>\n<ul>\n<li>S\u1eeda c\u00f4ng th\u1ee9c t\u1ed5ng tr\u00ean b\u00e1o c\u00e1o c\u1ea5p tr\u00ean ban h\u00e0nh (b\u1ea3ng thuy\u1ebft minh ban h\u00e0nh) nh\u01b0ng kh\u00f4ng s\u1eeda \u0111\u01b0\u1ee3c.\u00a0<\/li>\n<li>L\u1eadp\/N\u1ed9p b\u00e1o c\u00e1o c\u1ea5p tr\u00ean b\u00e1o l\u1ed7i &#8220;Ch\u1ec9 ti\u00eau t\u1ed5ng kh\u00f4ng \u0111\u01b0\u1ee3c b\u1ecf tr\u1ed1ng&#8221;.\u00a0<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5: B\u00e1o c\u00e1o lao \u0111\u1ed9ng, ti\u1ec1n l\u01b0\u01a1ng, ngu\u1ed3n kinh ph\u00ed \u0111\u1ea3m b\u1ea3o c\u1ee7a c\u00e1c \u0111\u01a1n v\u1ecb s\u1ef1 nghi\u1ec7p&#8230;<\/p>\n<p><strong>Nguy\u00ean nh\u00e2n: <\/strong>L\u1ed7i n\u00e0y th\u01b0\u1eddng x\u1ea3y ra do m\u00e1y t\u00ednh c\u1ee7a Anh\/ch\u1ecb \u0111ang s\u1eed d\u1ee5ng ch\u1ebf \u0111\u1ed9 ng\u00f4n ng\u1eef b\u00e0n ph\u00edm c\u1ee7a Windows l\u00e0 Ti\u1ebfng Vi\u1ec7t (VIE), d\u1eabn \u0111\u1ebfn vi\u1ec7c sai l\u1ec7ch k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t khi nh\u1eadp c\u00f4ng th\u1ee9c.<\/p>\n<p><strong>C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong><br \/>\n<strong>B\u01b0\u1edbc 1:<\/strong> Anh\/ch\u1ecb thao t\u00e1c chuy\u1ec3n \u0111\u1ed5i ng\u00f4n ng\u1eef b\u00e0n ph\u00edm theo 2 c\u00e1ch sau:<\/p>\n<ul>\n<li><strong>C\u00e1ch 1:\u00a0<\/strong>Ki\u1ec3m tra thanh Taskbar \u1edf g\u00f3c d\u01b0\u1edbi c\u00f9ng b\u00ean ph\u1ea3i m\u00e0n h\u00ecnh m\u00e1y t\u00ednh \u0111\u1ec3 xem ng\u00f4n ng\u1eef b\u00e0n ph\u00edm \u0111ang hi\u1ec3n th\u1ecb , n\u1ebfu \u0111ang l\u00e0 VIE c\u1ea7n t\u00edch chu\u1ed9t ph\u1ea3i chuy\u1ec3n sang ENG.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-38929 size-full\" src=\"\/v4\/wp-content\/uploads\/2026\/08\/9.png\" alt=\"\" width=\"329\" height=\"232\" srcset=\"\/v4\/wp-content\/uploads\/2026\/08\/9.png 329w, \/v4\/wp-content\/uploads\/2026\/08\/9-300x212.png 300w, \/v4\/wp-content\/uploads\/2026\/08\/9-50x35.png 50w, \/v4\/wp-content\/uploads\/2026\/08\/9-60x42.png 60w, \/v4\/wp-content\/uploads\/2026\/08\/9-100x71.png 100w\" sizes=\"auto, (max-width: 329px) 100vw, 329px\" \/><\/p>\n<ul>\n<li><strong>C\u00e1ch 2:<\/strong> Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm\u00a0<strong>Windows + Space<\/strong> (ph\u00edm c\u00e1ch) tr\u00ean b\u00e0n ph\u00edm \u0111\u1ec3 chuy\u1ec3n ng\u00f4n ng\u1eef t\u1eeb VIE c\u1ea7n t\u00edch chu\u1ed9t ph\u1ea3i chuy\u1ec3n sang ENG<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 2: <\/strong>Quay l\u1ea1i giao di\u1ec7n ch\u1ec9nh s\u1eeda b\u00e1o c\u00e1o (b\u1ea3ng thuy\u1ebft minh) tr\u00ean ph\u1ea7n m\u1ec1m, ti\u1ebfn h\u00e0nh nh\u1eadp l\u1ea1i c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng.<\/p>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h4>2.9. Trong ph\u1ea7n <strong>Chi ti\u1ebft d\u1ef1 to\u00e1n<\/strong>, s\u1ed1 ti\u1ec1n \u1edf ph\u1ea7n <strong>S\u1ed1 li\u1ec7u tham kh\u1ea3o<\/strong> \u0111ang b\u1ecb sai. T\u00f4i mu\u1ed1n s\u1eeda l\u1ea1i s\u1ed1 li\u1ec7u n\u00e0y th\u00ec th\u1ef1c hi\u1ec7n \u1edf \u0111\u00e2u?<\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p class=\"isSelectedEnd\">Nguy\u00ean nh\u00e2n: S\u1ed1 li\u1ec7u t\u1ea1i ph\u1ea7n <strong>S\u1ed1 li\u1ec7u tham kh\u1ea3o<\/strong> khi l\u1eadp d\u1ef1 to\u00e1n \u0111\u01b0\u1ee3c ph\u1ea7n m\u1ec1m l\u1ea5y t\u1eeb <strong>th\u00f4ng tin d\u1ef1 to\u00e1n n\u0103m tr\u01b0\u1edbc<\/strong> m\u00e0 anh\/ch\u1ecb \u0111\u00e3 nh\u1eadp.<\/p>\n<p class=\"isSelectedEnd\">Gi\u1ea3i ph\u00e1p: N\u1ebfu s\u1ed1 li\u1ec7u tham kh\u1ea3o c\u00e1c n\u0103m tr\u01b0\u1edbc ch\u01b0a \u0111\u00fang, anh\/ch\u1ecb th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<ol start=\"1\" data-spread=\"false\">\n<li>Nh\u1ea5n <strong>F5<\/strong> \u0111\u1ec3 t\u1ea3i l\u1ea1i tr\u00ecnh duy\u1ec7t.<\/li>\n<li>T\u1ea1i thanh menu, ch\u1ecdn <strong>D\u1eef li\u1ec7u n\u0103m tr\u01b0\u1edbc<\/strong>.<\/li>\n<li>Ch\u1ecdn \u0111\u00fang <strong>danh m\u1ee5c d\u1ef1 to\u00e1n<\/strong> \u0111ang l\u1eadp, v\u00ed d\u1ee5: <strong>Chi th\u01b0\u1eddng xuy\u00ean, Chi H\u0110SN, D\u1ecbch v\u1ee5,&#8230;<\/strong><\/li>\n<li>Ki\u1ec3m tra v\u00e0 \u0111\u1ed1i chi\u1ebfu s\u1ed1 li\u1ec7u theo \u0111\u00fang <strong>Ch\u01b0\u01a1ng, Lo\u1ea1i, Kho\u1ea3n, M\u1ee5c, N\u1ed9i dung chi<\/strong>.<\/li>\n<li>N\u1ebfu ph\u00e1t hi\u1ec7n s\u1ed1 ti\u1ec1n ch\u01b0a \u0111\u00fang, anh\/ch\u1ecb s\u1eeda l\u1ea1i s\u1ed1 li\u1ec7u theo nhu c\u1ea7u.<\/li>\n<li>Sau khi s\u1eeda xong, quay l\u1ea1i giao di\u1ec7n <strong>L\u1eadp d\u1ef1 to\u00e1n<\/strong>. Ph\u1ea7n <strong>S\u1ed1 li\u1ec7u tham kh\u1ea3o<\/strong> s\u1ebd \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt theo s\u1ed1 li\u1ec7u \u0111\u00e3 ch\u1ec9nh s\u1eeda.<\/li>\n<\/ol>\n<p><strong>L\u01b0u \u00fd:<\/strong> Kh\u00f4ng s\u1eeda tr\u1ef1c ti\u1ebfp s\u1ed1 li\u1ec7u t\u1ea1i ph\u1ea7n <strong>S\u1ed1 li\u1ec7u tham kh\u1ea3o<\/strong> trong giao di\u1ec7n l\u1eadp d\u1ef1 to\u00e1n. Tr\u01b0\u1eddng h\u1ee3p s\u1ed1 li\u1ec7u tham kh\u1ea3o ch\u01b0a \u0111\u00fang, c\u1ea7n ki\u1ec3m tra v\u00e0 \u0111i\u1ec1u ch\u1ec9nh t\u1ea1i <strong>D\u1eef li\u1ec7u n\u0103m tr\u01b0\u1edbc<\/strong>.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":149,"template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[201],"ht-kb-tag":[],"class_list":["post-38759","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-chung"],"_links":{"self":[{"href":"\/v4\/wp-json\/wp\/v2\/ht-kb\/38759","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/v4\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"\/v4\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"\/v4\/wp-json\/wp\/v2\/users\/149"}],"version-history":[{"count":3,"href":"\/v4\/wp-json\/wp\/v2\/ht-kb\/38759\/revisions"}],"predecessor-version":[{"id":39019,"href":"\/v4\/wp-json\/wp\/v2\/ht-kb\/38759\/revisions\/39019"}],"wp:attachment":[{"href":"\/v4\/wp-json\/wp\/v2\/media?parent=38759"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/v4\/wp-json\/wp\/v2\/ht-kb-category?post=38759"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/v4\/wp-json\/wp\/v2\/ht-kb-tag?post=38759"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}