{"id":35995,"date":"2022-04-12T18:41:43","date_gmt":"2022-04-12T11:41:43","guid":{"rendered":"https:\/\/divineshop.vn\/tin-tuc\/?p=35995"},"modified":"2022-04-12T18:41:43","modified_gmt":"2022-04-12T11:41:43","slug":"bo-tui-ngay-cach-tinh-phan-tram-trong-excel-don-gian-tien-loi-trong-bai-viet-nay-nhe","status":"publish","type":"post","link":"https:\/\/divineshop.vn\/tin-tuc\/bo-tui-ngay-cach-tinh-phan-tram-trong-excel-don-gian-tien-loi-trong-bai-viet-nay-nhe\/","title":{"rendered":"B\u1ecf t\u00fai ngay c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m trong Excel \u0111\u01a1n gi\u1ea3n, ti\u1ec7n l\u1ee3i trong b\u00e0i vi\u1ebft n\u00e0y nh\u00e9"},"content":{"rendered":"
\n

B\u1ea1n c\u1ea7n ph\u1ea3i l\u00e0m nh\u1eefng b\u1ea3n b\u00e1o c\u00e1o v\u1edbi nhi\u1ec1u s\u1ed1 li\u1ec7u ph\u1ee9c t\u1ea1p v\u00e0 \u0111ang th\u1eafc m\u1eafc li\u1ec7u r\u1eb1ng c\u00f3 m\u1ed9t h\u00e0m c\u1ee5 th\u1ec3 n\u00e0o trong Excel c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n t\u00ednh ra \u0111\u01b0\u1ee3c t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m c\u00e1c d\u1eef li\u1ec7u c\u0169ng nh\u01b0 so s\u00e1nh ch\u00fang.<\/strong><\/p>\n

C\u00e2u tr\u1ea3 l\u1eddi \u1edf \u0111\u00e2y l\u00e0 hi\u1ec7n t\u1ea1i v\u1eabn ch\u01b0a c\u00f3 h\u00e0m t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m c\u1ee5 th\u1ec3 nh\u01b0ng v\u1edbi b\u00e0i vi\u1ebft d\u01b0\u1edbi d\u00e2y, Divine Shop s\u1ebd m\u00e1ch b\u1ea1n t\u1ea5t t\u1ea7n t\u1eadt c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m trong Excel \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng ch\u1ec9 v\u1edbi 1 v\u00e0i b\u01b0\u1edbc. H\u00e3y ti\u1ebfp t\u1ee5c theo d\u00f5i nh\u00e9! \"B\u1ecf<\/span><\/p>\n

\n

<\/span><\/span>H\u01b0\u1edbng d\u1eabn c\u00f4ng th\u1ee9c t\u00ednh ph\u1ea7n tr\u0103m trong Excel<\/b><\/span><\/span><\/h2>\n

\u1ede c\u00f4ng th\u1ee9c t\u00ednh ph\u1ea7n tr\u0103m \u0111\u1ea7u ti\u00ean, \u0111\u00f3 l\u00e0 t\u00ednh ph\u1ea7n tr\u0103m cho t\u1eebng \u0111\u01a1n v\u1ecb ri\u00eang l\u1ebb. V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y s\u1ebd y\u00eau c\u1ea7u b\u1ea1n t\u00ednh ph\u1ea7n tr\u0103m cho t\u1eebng s\u1ea3n ph\u1ea9m \u0111\u00e3 b\u00e1n so v\u1edbi t\u1ed5ng s\u1ed1 s\u1ea3n ph\u1ea9m.\u00a0<\/span><\/p>\n

B\u01b0\u1edbc 1: <\/b>B\u1ea1n h\u00e3y kh\u1edfi \u0111\u1ed9ng v\u00e0 m\u1edf file c\u1ea7n t\u00ednh to\u00e1n. \"H\u01b0\u1edbng<\/span><\/p>\n

B\u01b0\u1edbc 2: <\/b>T\u1ea1i \u00f4 t\u00ednh ph\u1ea7n tr\u0103m \u0111\u00e3 b\u00e1n, b\u1ea1n h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c \u0111\u00f3 l\u00e0 l\u1ea5y s\u1ed1 \u0111\u00e3 b\u00e1n chia cho t\u1ed5ng s\u1ed1 v\u1edbi c\u00fa ph\u00e1p <\/span>=D2\/C2 <\/b>sau \u0111\u00f3 nh\u1ea5n Enter<\/strong>. \"H\u01b0\u1edbng<\/span><\/p>\n

B\u01b0\u1edbc 3: <\/b>Sau \u0111\u00f3, b\u1ea1n h\u00e3y s\u1ebd hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 v\u00e0 b\u1ea1n s\u1ebd k\u00e9o th\u1ef1c hi\u1ec7n k\u00e9o k\u1ebft qu\u1ea3 \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c \u0111\u1ebfn c\u00e1c \u00f4 c\u00f2n l\u1ea1i trong b\u1ea3ng. \"H\u01b0\u1edbng<\/span><\/p>\n

B\u01b0\u1edbc 4: <\/b>Ti\u1ebfp \u0111\u1ebfn, b\u1ea1n h\u00e3y th\u1ef1c hi\u1ec7n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng th\u00e0nh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m b\u1eb1ng c\u00e1ch b\u00f4i \u0111en t\u1ea5t c\u1ea3 \u00f4 k\u1ebft qu\u1ea3. Sau \u0111\u00f3 <\/span>Click chu\u1ed9t ph\u1ea3i > Format Cells<\/b>. \"H\u01b0\u1edbng<\/span><\/p>\n

B\u01b0\u1edbc 5: <\/b>Ti\u1ebfp theo, t\u1ea1i h\u1ed9p tho\u1ea1i Format Cells b\u1ea1n h\u00e3y ch\u1ecdn m\u1ee5c <\/span>Percentage <\/b>v\u00e0 \u0111i\u1ec1u ch\u1ec9nh ph\u00e2n c\u00e1ch \u0111\u1ebfn 2 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n.\"H\u01b0\u1edbng<\/span><\/p>\n

B\u01b0\u1edbc 6: <\/b>Cu\u1ed1i c\u00f9ng, k\u1ebft qu\u1ea3 s\u1ebd hi\u1ec3n th\u1ecb nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi \u0111\u00e2y. \"H\u01b0\u1edbng<\/span><\/p>\n

<\/span><\/span>C\u00e1ch t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m trong Excel d\u1ef1a tr\u00ean nhi\u1ec1u h\u00e0ng\u00a0<\/b><\/span><\/span><\/h2>\n

T\u01b0\u01a1ng t\u1ef1 v\u1edbi ph\u00e9p t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m cho t\u1eebng \u0111\u01a1n v\u1ecb h\u00e0ng ri\u00eang l\u1ebb, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n t\u00ednh ph\u1ea7n tr\u0103m c\u1ee7a c\u00e1c s\u1ea3n ph\u1ea9m d\u1ef1a tr\u00ean t\u1ea5t c\u1ea3 c\u00e1c s\u1ea3n ph\u1ea9m \u0111\u00e3 b\u00e1n v\u1edbi c\u00f4ng th\u1ee9c nh\u01b0 sau:\u00a0<\/span><\/p>\n

B\u01b0\u1edbc 1<\/b>: T\u1ea1i b\u1ea3ng t\u00ednh \u0111\u00e3 \u0111\u01b0\u1ee3c kh\u1edfi \u0111\u1ed9ng. Sau \u0111\u00f3, b\u1ea1n h\u00e3y th\u1ef1c hi\u1ec7n h\u00e0m SUMIF \u0111\u1ec3 t\u00ednh t\u1ed5ng s\u1ea3n ph\u1ea9m v\u1edbi \u0111i\u1ec1u ki\u1ec7n v\u00e0 chia cho t\u1ed5ng s\u1ed1 \u0111\u1ec3 t\u00ecm ra k\u1ebft qu\u1ea3.\u00a0<\/span>V\u1edbi c\u00fa ph\u00e1p nh\u01b0 sau: <\/span>=SUMIF($B$2:$B$7;\u201d\u0110i\u1ec7n tho\u1ea1i\u201d;$C$2:$C$7)\/$C$8 \"C\u00e1ch<\/b><\/p>\n

B\u01b0\u1edbc 2: <\/b>Sau \u0111\u00f3, b\u1ea1n h\u00e3y th\u1ef1c hi\u1ec7n t\u01b0\u01a1ng t\u1ef1 v\u1edbi c\u00e1c s\u1ea3n ph\u1ea9m c\u00f2n l\u1ea1i. \"C\u00e1ch<\/span><\/p>\n

B\u01b0\u1edbc 3: <\/b>Ti\u1ebfp \u0111\u1ebfn, b\u1ea1n h\u00e3y \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng sang t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m b\u1eb1ng c\u00e1ch b\u00f4i \u0111en c\u00e1c \u00f4 \u0111\u00e3 t\u00ednh, <\/span>Click chu\u1ed9t ph\u1ea3i > Format Cells<\/b>.\"C\u00e1ch<\/span><\/p>\n

B\u01b0\u1edbc 4: <\/b>T\u1ea1i h\u1ed9p tho\u1ea1i Format Cells, ch\u1ecdn v\u00e0o m\u1ee5c <\/span>Percentage > Ok<\/b>.\"C\u00e1ch<\/span><\/p>\n

B\u01b0\u1edbc 5: <\/b>Cu\u1ed1i c\u00f9ng, b\u1ea1n s\u1ebd xem \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y. \"C\u00e1ch<\/span><\/p>\n

<\/span><\/span>H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m chi\u1ebft kh\u1ea5u trong Excel ch\u1ec9 trong t\u00edch t\u1eafc<\/b><\/span><\/span><\/h2>\n

Ti\u1ebfp theo, Divine Shop s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m chi\u1ebft kh\u1ea5u trong Excel v\u00e0 d\u1ea1ng th\u01b0\u1eddng g\u1eb7p \u0111\u00f3 l\u00e0 t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m chi\u1ebft kh\u1ea5u so v\u1edbi th\u00e0nh ti\u1ec1n. \u1ede v\u00ed d\u1ee5, ti\u1ebfp theo sau \u0111\u00e2y l\u00e0 c\u00e1c s\u1ea3n ph\u1ea9m v\u1edbi gi\u00e1 g\u1ed1c v\u00e0 c\u00f3 s\u1eed d\u1ee5ng chi\u1ebft kh\u1ea5u gi\u1ea3m gi\u00e1.\u00a0<\/span><\/p>\n

B\u01b0\u1edbc 1: <\/b>T\u1ea1i b\u1ea3ng t\u00ednh Excel, b\u1ea1n h\u00e3y ch\u1ecdn v\u00e0o \u00f4 c\u1ea7n t\u00ednh v\u00e0 s\u1eed d\u1ee5ng c\u00fa ph\u00e1p sau: <\/span>=C2-(C2*D2) \"H\u01b0\u1edbng<\/b><\/p>\n

B\u01b0\u1edbc 2: <\/b>Sau \u0111\u00f3 th\u1ef1c hi\u1ec7n k\u00e9o \u0111\u1ebfn c\u00e1c \u00f4 c\u00f2n l\u1ea1i \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c. V\u00e0 cu\u1ed1i c\u00f9ng b\u1ea1n s\u1ebd c\u00f3 b\u1ea3ng t\u00ednh v\u1edbi gi\u00e1 b\u00e1n \u0111\u00e3 \u0111\u01b0\u1ee3c chi\u1ebft kh\u1ea5u nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y. \"H\u01b0\u1edbng<\/span><\/p>\n

<\/span><\/span>C\u00e1ch t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m trong Excel khi c\u00f3 s\u1ef1 thay \u0111\u1ed5i, ch\u00eanh l\u1ec7ch<\/b><\/span><\/span><\/h2>\n

Th\u00eam m\u1ed9t tr\u01b0\u1eddng h\u1ee3p c\u0169ng th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong Excel, \u0111\u00f3 l\u00e0 t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m c\u1ee7a m\u1ed9t thay \u0111\u1ed5i qua c\u00e1c n\u0103m, th\u00e1ng khi b\u1ea1n mu\u1ed1n th\u1ea5y s\u1ef1 t\u0103ng tr\u01b0\u1edfng c\u1ee7a doanh thu, s\u1ea3n ph\u1ea9m.\u00a0<\/span>\u1ede v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, \u0111\u00f3 l\u00e0 so s\u00e1nh s\u1ef1 t\u0103ng tr\u01b0\u1edfng doanh thu gi\u1eefa 3 th\u00e1ng \u0111\u1ea7u n\u0103m.\u00a0<\/span><\/p>\n

B\u01b0\u1edbc 1: <\/b>Sau khi \u0111\u00e3 kh\u1edfi \u0111\u1ed9ng file c\u1ea7n t\u00ednh, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c nh\u01b0 sau: <\/span>=(C3\/$C$2)-1 <\/b>\u0111\u1ec3 \u0111\u00e1nh gi\u00e1 s\u1ef1 t\u0103ng tr\u01b0\u1edfng doanh thu so v\u1edbi Th\u00e1ng 1. \"C\u00e1ch<\/span><\/p>\n

B\u01b0\u1edbc 2: <\/b>Ti\u1ebfp \u0111\u1ebfn, b\u1ea1n h\u00e3y l\u00e0m t\u01b0\u01a1ng t\u1ef1 v\u1edbi th\u00e1ng c\u00f2n l\u1ea1i v\u00e0 nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 t\u0103ng tr\u01b0\u1edfng theo t\u1eebng th\u00e1ng. \"C\u00e1ch<\/span><\/p>\n

<\/span><\/span>T\u1ea1m k\u1ebft<\/b><\/span><\/span><\/h2>\n

B\u00e0i vi\u1ebft tr\u00ean \u0111\u00e2y, Divine Shop \u0111\u00e3 h\u01b0\u1edbng d\u1eabn b\u1ea1n m\u1ed9t v\u00e0i c\u00f4ng th\u1ee9c t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m trong Excel th\u00f4ng d\u1ee5ng nh\u1ea5t hi\u1ec7n nay, v\u1edbi c\u00e1c v\u00ed d\u1ee5 tr\u00ean hy v\u1ecdng s\u1ebd ph\u00f9 h\u1ee3p v\u1edbi nh\u1eefng s\u1ed1 li\u1ec7u b\u1ea1n c\u1ea7n x\u1eed l\u00fd. Ch\u00fac c\u00e1c b\u1ea1n th\u1ef1c hi\u1ec7n th\u00e0nh c\u00f4ng!<\/span><\/p>\n

\u00a0<\/strong><\/em><\/p>\n

\u00a0<\/p>\n<\/div>\n<\/div>\n\n\n

\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n\n\n\n\n
<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

B\u1ea1n c\u1ea7n ph\u1ea3i l\u00e0m nh\u1eefng b\u1ea3n b\u00e1o c\u00e1o v\u1edbi nhi\u1ec1u s\u1ed1 li\u1ec7u ph\u1ee9c t\u1ea1p v\u00e0 \u0111ang th\u1eafc m\u1eafc li\u1ec7u r\u1eb1ng c\u00f3 m\u1ed9t h\u00e0m c\u1ee5 th\u1ec3 n\u00e0o trong Excel c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n t\u00ednh ra \u0111\u01b0\u1ee3c t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m c\u00e1c d\u1eef li\u1ec7u c\u0169ng nh\u01b0 so s\u00e1nh ch\u00fang. C\u00e2u tr\u1ea3 l\u1eddi \u1edf \u0111\u00e2y l\u00e0 hi\u1ec7n t\u1ea1i […]<\/p>\n","protected":false},"author":12,"featured_media":35996,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[148],"tags":[190],"yoast_head":"\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n\n\n\t\n\t\n\t\n