V\u00ed d\u1ee5:<\/strong> Chi ph\u00ed v\u1eadn h\u00e0nh gi\u1ea3m t\u1eeb 80 tri\u1ec7u xu\u1ed1ng 68 tri\u1ec7u.<\/p>\nPh\u1ea7n tr\u0103m gi\u1ea3m = [(80 \u2013 68) \/ 80] x 100 = 15%<\/p>\n
L\u01b0u \u00fd khi t\u00ednh<\/h3>\n
\u2013 Gi\u00e1 tr\u1ecb c\u0169 lu\u00f4n l\u00e0 m\u1ed1c so s\u00e1nh, \u0111\u1eb7t \u1edf m\u1eabu s\u1ed1.<\/p>\n
\u2013 K\u1ebft qu\u1ea3 d\u01b0\u01a1ng ngh\u0129a l\u00e0 t\u0103ng, k\u1ebft qu\u1ea3 \u00e2m ngh\u0129a l\u00e0 gi\u1ea3m.<\/p>\n
\u2013 Kh\u00f4ng nh\u1ea7m l\u1eabn gi\u1eefa ph\u1ea7n tr\u0103m t\u0103ng v\u00e0 \u0111i\u1ec3m ph\u1ea7n tr\u0103m t\u0103ng (v\u00ed d\u1ee5: t\u1eeb 20% l\u00ean 25% l\u00e0 t\u0103ng 5 \u0111i\u1ec3m ph\u1ea7n tr\u0103m, nh\u01b0ng t\u0103ng 25% v\u1ec1 t\u1ef7 l\u1ec7).<\/p>\n
5. C\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m ch\u00eanh l\u1ec7ch gi\u1eefa hai gi\u00e1 tr\u1ecb<\/h2>\n
Khi c\u1ea7n so s\u00e1nh hai gi\u00e1 tr\u1ecb m\u00e0 kh\u00f4ng x\u00e1c \u0111\u1ecbnh r\u00f5 \u0111\u00e2u l\u00e0 g\u1ed1c, b\u1ea1n d\u00f9ng c\u00f4ng th\u1ee9c ch\u00eanh l\u1ec7ch:<\/p>\n
Ph\u1ea7n tr\u0103m ch\u00eanh l\u1ec7ch = [|Gi\u00e1 tr\u1ecb A \u2013 Gi\u00e1 tr\u1ecb B| \/ ((Gi\u00e1 tr\u1ecb A + Gi\u00e1 tr\u1ecb B) \/ 2)] x 100<\/strong><\/p>\nV\u00ed d\u1ee5:<\/strong> So s\u00e1nh chi ph\u00ed nguy\u00ean li\u1ec7u hai nh\u00e0 cung c\u1ea5p: A b\u00e1o gi\u00e1 45 tri\u1ec7u, B b\u00e1o gi\u00e1 52 tri\u1ec7u.<\/p>\nPh\u1ea7n tr\u0103m ch\u00eanh l\u1ec7ch = [|45 \u2013 52| \/ ((45 + 52) \/ 2)] x 100 = [7 \/ 48,5] x 100 \u2248 14,43%<\/p>\n
C\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m ch\u00eanh l\u1ec7ch th\u01b0\u1eddng d\u00f9ng trong nghi\u00ean c\u1ee9u ho\u1eb7c \u0111\u00e1nh gi\u00e1 b\u00e1o gi\u00e1 t\u1eeb nhi\u1ec1u ngu\u1ed3n.<\/p>\n
6. C\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m trong Excel<\/h2>\n
Excel h\u1ed7 tr\u1ee3 nhi\u1ec1u c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m nhanh ch\u00f3ng, ph\u00f9 h\u1ee3p v\u1edbi c\u00f4ng vi\u1ec7c v\u0103n ph\u00f2ng v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u.<\/p>\n
T\u00ednh ph\u1ea7n tr\u0103m c\u01a1 b\u1ea3n<\/h3>\n
Nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o \u00f4 c\u1ea7n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3:<\/p>\n
=A1\/B1<\/code><\/p>\nSau \u0111\u00f3 ch\u1ecdn \u00f4 k\u1ebft qu\u1ea3, v\u00e0o tab Home > Number > ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng Percentage (%).<\/p>\n
T\u00ednh ph\u1ea7n tr\u0103m t\u0103ng gi\u1ea3m<\/h3>\n
=(B2-A2)\/A2<\/code><\/p>\nTrong \u0111\u00f3 A2 l\u00e0 gi\u00e1 tr\u1ecb c\u0169, B2 l\u00e0 gi\u00e1 tr\u1ecb m\u1edbi. \u0110\u1ecbnh d\u1ea1ng \u00f4 k\u1ebft qu\u1ea3 th\u00e0nh Percentage.<\/p>\n
T\u00ednh gi\u00e1 tr\u1ecb sau khi c\u1ed9ng ph\u1ea7n tr\u0103m<\/h3>\n
=A1*(1+B1)<\/code><\/p>\nTrong \u0111\u00f3 A1 l\u00e0 gi\u00e1 tr\u1ecb g\u1ed1c, B1 l\u00e0 t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m (\u0111\u00e3 \u0111\u1ecbnh d\u1ea1ng %).<\/p>\n
M\u1ed9t s\u1ed1 m\u1eb9o h\u1eefu \u00edch<\/h3>\n
\u2013 D\u00f9ng ph\u00edm t\u1eaft Ctrl + Shift + % \u0111\u1ec3 chuy\u1ec3n nhanh \u0111\u1ecbnh d\u1ea1ng \u00f4 sang ph\u1ea7n tr\u0103m.<\/p>\n
\u2013 Khi nh\u1eadp s\u1ed1 25 r\u1ed3i chuy\u1ec3n sang \u0111\u1ecbnh d\u1ea1ng %, Excel s\u1ebd hi\u1ec3n th\u1ecb 2500%. N\u00ean nh\u1eadp 0,25 ho\u1eb7c nh\u1eadp 25% ngay t\u1eeb \u0111\u1ea7u.<\/p>\n
\u2013 D\u00f9ng h\u00e0m =ROUND(A1\/B1*100, 2)<\/code> \u0111\u1ec3 l\u00e0m tr\u00f2n k\u1ebft qu\u1ea3 2 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n.<\/p>\n7. Sai l\u1ea7m th\u01b0\u1eddng g\u1eb7p khi t\u00ednh ph\u1ea7n tr\u0103m<\/h2>\n
Khi \u00e1p d\u1ee5ng c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m, nhi\u1ec1u ng\u01b0\u1eddi th\u01b0\u1eddng m\u1eafc c\u00e1c l\u1ed7i sau:<\/p>\n
\u2013 Nh\u1ea7m l\u1eabn c\u01a1 s\u1edf so s\u00e1nh:<\/strong> Lu\u00f4n l\u1ea5y gi\u00e1 tr\u1ecb g\u1ed1c l\u00e0m m\u1eabu s\u1ed1. \u0110\u1eb7t sai m\u1eabu s\u1ed1 s\u1ebd cho k\u1ebft qu\u1ea3 l\u1ec7ch \u0111\u00e1ng k\u1ec3.<\/p>\n\u2013 C\u1ed9ng tr\u1eeb ph\u1ea7n tr\u0103m tr\u1ef1c ti\u1ebfp:<\/strong> T\u0103ng 20% r\u1ed3i gi\u1ea3m 20% kh\u00f4ng tr\u1edf v\u1ec1 gi\u00e1 tr\u1ecb ban \u0111\u1ea7u. V\u00ed d\u1ee5: 100 t\u0103ng 20% th\u00e0nh 120, gi\u1ea3m 20% c\u00f2n 96.<\/p>\n\u2013 Nh\u1ea7m ph\u1ea7n tr\u0103m v\u00e0 \u0111i\u1ec3m ph\u1ea7n tr\u0103m:<\/strong> L\u00e3i su\u1ea5t t\u1eeb 5% l\u00ean 7% l\u00e0 t\u0103ng 2 \u0111i\u1ec3m ph\u1ea7n tr\u0103m, nh\u01b0ng t\u0103ng 40% v\u1ec1 t\u1ef7 l\u1ec7.<\/p>\n\u2013 Kh\u00f4ng quy \u0111\u1ed5i \u0111\u01a1n v\u1ecb:<\/strong> Qu\u00ean chuy\u1ec3n \u0111\u1ed5i gi\u1eefa d\u1ea1ng s\u1ed1 th\u1eadp ph\u00e2n (0,25) v\u00e0 d\u1ea1ng ph\u1ea7n tr\u0103m (25%) d\u1eabn \u0111\u1ebfn k\u1ebft qu\u1ea3 sai g\u1ea5p 100 l\u1ea7n.<\/p>\n8. \u1ee8ng d\u1ee5ng c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m trong c\u00f4ng vi\u1ec7c v\u00e0 \u0111\u1eddi s\u1ed1ng<\/h2>\n
C\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m<\/strong> kh\u00f4ng ch\u1ec9 l\u00e0 ki\u1ebfn th\u1ee9c to\u00e1n h\u1ecdc m\u00e0 c\u00f2n l\u00e0 k\u1ef9 n\u0103ng thi\u1ebft y\u1ebfu trong nhi\u1ec1u t\u00ecnh hu\u1ed1ng th\u1ef1c t\u1ebf:<\/p>\n\u2013 Qu\u1ea3n l\u00fd t\u00e0i ch\u00ednh c\u00e1 nh\u00e2n:<\/strong> T\u00ednh t\u1ef7 l\u1ec7 ti\u1ebft ki\u1ec7m so v\u1edbi thu nh\u1eadp, theo d\u00f5i m\u1ee9c t\u0103ng gi\u1ea3m chi ti\u00eau h\u00e0ng th\u00e1ng.<\/p>\n\u2013 Mua s\u1eafm:<\/strong> X\u00e1c \u0111\u1ecbnh nhanh gi\u00e1 sau khi \u00e1p m\u00e3 gi\u1ea3m gi\u00e1. V\u00ed d\u1ee5: s\u1ea3n ph\u1ea9m 1.200.000 \u0111\u1ed3ng gi\u1ea3m 35% c\u00f2n 780.000 \u0111\u1ed3ng.<\/p>\n\u2013 C\u00f4ng vi\u1ec7c v\u0103n ph\u00f2ng:<\/strong> L\u1eadp b\u00e1o c\u00e1o t\u1ef7 l\u1ec7 ho\u00e0n th\u00e0nh KPI, ph\u00e2n t\u00edch bi\u1ebfn \u0111\u1ed9ng doanh thu, t\u00ednh l\u00e3i su\u1ea5t vay.<\/p>\n\u2013 \u0110\u1ea7u t\u01b0:<\/strong> T\u00ednh l\u1ee3i nhu\u1eadn ho\u1eb7c l\u1ed7 theo ph\u1ea7n tr\u0103m \u0111\u1ec3 so s\u00e1nh hi\u1ec7u qu\u1ea3 gi\u1eefa c\u00e1c k\u00eanh \u0111\u1ea7u t\u01b0.<\/p>\n9. C\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p<\/h2>\n
T\u00ednh ph\u1ea7n tr\u0103m c\u1ee7a m\u1ed9t s\u1ed1 ngh\u0129a l\u00e0 g\u00ec?<\/em><\/strong><\/p>\nT\u00ednh ph\u1ea7n tr\u0103m c\u1ee7a m\u1ed9t s\u1ed1 l\u00e0 x\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng v\u1edbi t\u1ef7 l\u1ec7 cho tr\u01b0\u1edbc. V\u00ed d\u1ee5: 30% c\u1ee7a 500 = 500 x 30\/100 = 150.<\/p>\n
L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh ng\u01b0\u1ee3c gi\u00e1 g\u1ed1c khi bi\u1ebft gi\u00e1 \u0111\u00e3 gi\u1ea3m?<\/em><\/strong><\/p>\nD\u00f9ng c\u00f4ng th\u1ee9c: Gi\u00e1 g\u1ed1c = Gi\u00e1 sau gi\u1ea3m \/ (1 \u2013 T\u1ef7 l\u1ec7 gi\u1ea3m). V\u00ed d\u1ee5: s\u1ea3n ph\u1ea9m gi\u1ea3m 25% c\u00f2n 750.000 \u0111\u1ed3ng th\u00ec gi\u00e1 g\u1ed1c = 750.000 \/ 0,75 = 1.000.000 \u0111\u1ed3ng.<\/p>\n
V\u00ec sao t\u0103ng 50% r\u1ed3i gi\u1ea3m 50% kh\u00f4ng ra gi\u00e1 tr\u1ecb ban \u0111\u1ea7u?<\/em><\/strong><\/p>\nV\u00ec hai ph\u00e9p t\u00ednh c\u00f3 c\u01a1 s\u1edf kh\u00e1c nhau. T\u0103ng 50% t\u1eeb 100 \u0111\u01b0\u1ee3c 150; gi\u1ea3m 50% t\u1eeb 150 ch\u1ec9 c\u00f2n 75. M\u1eabu s\u1ed1 thay \u0111\u1ed5i sau m\u1ed7i l\u1ea7n t\u00ednh n\u00ean k\u1ebft qu\u1ea3 kh\u00f4ng \u0111\u1ed1i x\u1ee9ng.<\/p>\n
T\u00f3m l\u1ea1i, c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m<\/strong> l\u00e0 k\u1ef9 n\u0103ng n\u1ec1n t\u1ea3ng m\u00e0 b\u1ea5t k\u1ef3 ai c\u0169ng c\u1ea7n n\u1eafm v\u1eefng \u0111\u1ec3 x\u1eed l\u00fd c\u00f4ng vi\u1ec7c v\u00e0 qu\u1ea3n l\u00fd t\u00e0i ch\u00ednh hi\u1ec7u qu\u1ea3 h\u01a1n. T\u1eeb c\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n, ph\u1ea7n tr\u0103m ng\u01b0\u1ee3c, ph\u1ea7n tr\u0103m t\u0103ng gi\u1ea3m \u0111\u1ebfn \u1ee9ng d\u1ee5ng tr\u00ean Excel, m\u1ed7i ph\u00e9p t\u00ednh \u0111\u1ec1u c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng ngay v\u00e0o c\u00e1c t\u00ecnh hu\u1ed1ng h\u00e0ng ng\u00e0y. H\u00e3y th\u1ef1c h\u00e0nh th\u01b0\u1eddng xuy\u00ean \u0111\u1ec3 thao t\u00e1c nhanh v\u00e0 ch\u00ednh x\u00e1c h\u01a1n.<\/p>\nMinh An<\/em><\/p>\nN\u1ed9i dung trong b\u00e0i mang t\u00ednh tham kh\u1ea3o v\u00e0 \u0111\u1ecbnh h\u01b0\u1edbng t\u1ed5ng quan; c\u01a1 h\u1ed9i ngh\u1ec1 nghi\u1ec7p v\u00e0 thu nh\u1eadp th\u1ef1c t\u1ebf c\u00f3 th\u1ec3 kh\u00e1c nhau t\u00f9y thu\u1ed9c v\u00e0o n\u0103ng l\u1ef1c, kinh nghi\u1ec7m, v\u1ecb tr\u00ed, doanh nghi\u1ec7p v\u00e0 th\u1eddi \u0111i\u1ec3m th\u1ecb tr\u01b0\u1eddng.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"Ph\u1ea7n tr\u0103m l\u00e0 \u0111\u01a1n v\u1ecb quen thu\u1ed9c xu\u1ea5t hi\u1ec7n trong h\u1ea7u h\u1ebft l\u0129nh v\u1ef1c t\u1eeb t\u00e0i ch\u00ednh, kinh doanh \u0111\u1ebfn h\u1ecdc t\u1eadp h\u00e0ng ng\u00e0y. N\u1eafm …<\/p>\n","protected":false},"author":59,"featured_media":14599,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-10682","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-goc-ky-nang"],"_links":{"self":[{"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts\/10682","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/users\/59"}],"replies":[{"embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/comments?post=10682"}],"version-history":[{"count":2,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts\/10682\/revisions"}],"predecessor-version":[{"id":13158,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts\/10682\/revisions\/13158"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/media\/14599"}],"wp:attachment":[{"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/media?parent=10682"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/categories?post=10682"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/tags?post=10682"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}