{"id":1312,"date":"2026-07-24T04:42:37","date_gmt":"2026-07-24T04:42:37","guid":{"rendered":"https:\/\/1phantram.com\/blog\/cach-tinh-phan-tram-trong-excel-google-sheets\/"},"modified":"2026-07-25T06:11:01","modified_gmt":"2026-07-25T06:11:01","slug":"cach-tinh-phan-tram-trong-excel-google-sheets","status":"publish","type":"post","link":"https:\/\/1phantram.com\/blog\/cach-tinh-phan-tram-trong-excel-google-sheets\/","title":{"rendered":"C\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m trong Excel v\u00e0 Google Sheets: c\u00f4ng th\u1ee9c d\u1ec5 d\u00f9ng"},"content":{"rendered":"\nTL;DR:<\/strong> \u0110\u1ec3 t\u00ednh ph\u1ea7n tr\u0103m trong Excel<\/strong> v\u00e0 Google Sheets, h\u00e3y s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n: `=Ph\u1ea7n\/T\u1ed5ng` \u0111\u1ec3 t\u00ednh t\u1ef7 l\u1ec7, `=(Gi\u00e1 tr\u1ecb m\u1edbi\/Gi\u00e1 tr\u1ecb c\u0169) – 1` \u0111\u1ec3 t\u00ednh t\u0103ng tr\u01b0\u1edfng, v\u00e0 `=T\u1ed5ng * T\u1ef7 l\u1ec7 %` \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t ph\u1ea7n. Quan tr\u1ecdng nh\u1ea5t l\u00e0 \u0111\u1ecbnh d\u1ea1ng \u00f4 k\u1ebft qu\u1ea3 sang ki\u1ec3u “Percentage” (D\u1ea5u %) \u0111\u1ec3 hi\u1ec3n th\u1ecb \u0111\u00fang. C\u00e1c h\u00e0m n\u00e0y ho\u1ea1t \u0111\u1ed9ng gi\u1ed1ng h\u1ec7t nhau tr\u00ean c\u1ea3 hai n\u1ec1n t\u1ea3ng.\n\n\n\nTrong th\u1ebf gi\u1edbi s\u1ed1 hi\u1ec7n nay, t\u1eeb qu\u1ea3n l\u00fd t\u00e0i ch\u00ednh c\u00e1 nh\u00e2n, theo d\u00f5i hi\u1ec7u su\u1ea5t kinh doanh cho \u0111\u1ebfn ph\u00e2n t\u00edch d\u1eef li\u1ec7u h\u1ecdc thu\u1eadt, k\u1ef9 n\u0103ng l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh l\u00e0 kh\u00f4ng th\u1ec3 thi\u1ebfu. Excel v\u00e0 Google Sheets \u0111\u00e3 tr\u1edf th\u00e0nh nh\u1eefng c\u00f4ng c\u1ee5 quy\u1ec1n l\u1ef1c, v\u00e0 m\u1ed9t trong nh\u1eefng ph\u00e9p t\u00ednh c\u01a1 b\u1ea3n nh\u01b0ng quan tr\u1ecdng nh\u1ea5t ch\u00ednh l\u00e0 t\u00ednh ph\u1ea7n tr\u0103m. Vi\u1ec7c n\u1eafm v\u1eefng c\u00e1c c\u00f4ng th\u1ee9c ph\u1ea7n tr\u0103m Google Sheets<\/strong> v\u00e0 Excel kh\u00f4ng ch\u1ec9 gi\u00fap b\u1ea1n x\u1eed l\u00fd s\u1ed1 li\u1ec7u nhanh ch\u00f3ng m\u00e0 c\u00f2n mang l\u1ea1i c\u00e1i nh\u00ecn s\u00e2u s\u1eafc h\u01a1n v\u1ec1 \u00fd ngh\u0129a \u0111\u1eb1ng sau ch\u00fang. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd l\u00e0 c\u1ea9m nang to\u00e0n di\u1ec7n, h\u01b0\u1edbng d\u1eabn b\u1ea1n t\u1eeb nh\u1eefng c\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n nh\u1ea5t \u0111\u1ebfn c\u00e1c m\u1eb9o n\u00e2ng cao \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 tin l\u00e0m ch\u1ee7 m\u1ecdi b\u00e0i to\u00e1n li\u00ean quan \u0111\u1ebfn ph\u1ea7n tr\u0103m tr\u00ean hai n\u1ec1n t\u1ea3ng ph\u1ed5 bi\u1ebfn n\u00e0y.\n\n\n\n\nKh\u00e1m Ph\u00e1 C\u00f4ng C\u1ee5 T\u00ednh Ph\u1ea7n Tr\u0103m \u2192<\/a>\n\n\n\n\n

Nguy\u00ean T\u1eafc C\u01a1 B\u1ea3n v\u00e0 Thi\u1ebft L\u1eadp \u0110\u1ecbnh D\u1ea1ng Ph\u1ea7n Tr\u0103m trong Excel & Google Sheets<\/h2>\n\n\n\nTr\u01b0\u1edbc khi \u0111i s\u00e2u v\u00e0o c\u00e1c c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p, vi\u1ec7c n\u1eafm v\u1eefng nguy\u00ean t\u1eafc c\u01a1 b\u1ea3n v\u00e0 c\u00e1ch thi\u1ebft l\u1eadp \u0111\u1ecbnh d\u1ea1ng \u0111\u00fang l\u00e0 b\u01b0\u1edbc \u0111\u1ea7u ti\u00ean v\u00e0 quan tr\u1ecdng nh\u1ea5t \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o m\u1ecdi ph\u00e9p t\u00ednh ph\u1ea7n tr\u0103m trong Excel<\/strong> v\u00e0 Google Sheets \u0111\u1ec1u ch\u00ednh x\u00e1c. V\u1ec1 b\u1ea3n ch\u1ea5t, ph\u1ea7n tr\u0103m l\u00e0 m\u1ed9t c\u00e1ch bi\u1ec3u di\u1ec5n m\u1ed9t s\u1ed1 d\u01b0\u1edbi d\u1ea1ng m\u1ed9t ph\u00e2n s\u1ed1 c\u00f3 m\u1eabu s\u1ed1 l\u00e0 100. V\u00ed d\u1ee5, 50% th\u1ef1c ch\u1ea5t l\u00e0 50\/100, hay 0.5. C\u1ea3 Excel v\u00e0 Google Sheets \u0111\u1ec1u hi\u1ec3u v\u00e0 l\u00e0m vi\u1ec7c v\u1edbi con s\u1ed1 th\u1eadp ph\u00e2n n\u00e0y. Khi b\u1ea1n nh\u1eadp “50%” v\u00e0o m\u1ed9t \u00f4, ph\u1ea7n m\u1ec1m s\u1ebd t\u1ef1 \u0111\u1ed9ng l\u01b0u tr\u1eef gi\u00e1 tr\u1ecb l\u00e0 0.5 v\u00e0 ch\u1ec9 hi\u1ec3n th\u1ecb “50%” \u0111\u1ec3 ng\u01b0\u1eddi d\u00f9ng d\u1ec5 \u0111\u1ecdc. Hi\u1ec3u \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y l\u00e0 ch\u00eca kh\u00f3a \u0111\u1ec3 tr\u00e1nh nh\u1eefng l\u1ed7i sai ph\u1ed5 bi\u1ebfn. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n t\u00ednh ra k\u1ebft qu\u1ea3 l\u00e0 0.25 v\u00e0 mu\u1ed1n n\u00f3 hi\u1ec3n th\u1ecb l\u00e0 25%, b\u1ea1n kh\u00f4ng c\u1ea7n nh\u00e2n n\u00f3 v\u1edbi 100. Thay v\u00e0o \u0111\u00f3, b\u1ea1n ch\u1ec9 c\u1ea7n ch\u1ecdn \u00f4 \u0111\u00f3 v\u00e0 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng “Percentage”.\n\n\n\n\u0110\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m, quy tr\u00ecnh tr\u00ean c\u1ea3 hai n\u1ec1n t\u1ea3ng \u0111\u1ec1u r\u1ea5t tr\u1ef1c quan. Trong Excel, b\u1ea1n ch\u1ecdn \u00f4 ho\u1eb7c m\u1ed9t d\u1ea3i \u00f4 c\u1ea7n \u0111\u1ecbnh d\u1ea1ng, sau \u0111\u00f3 tr\u00ean tab “Home”, t\u00ecm \u0111\u1ebfn nh\u00f3m “Number” v\u00e0 nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u ph\u1ea7n tr\u0103m (%). M\u1ed9t c\u00e1ch nhanh h\u01a1n l\u00e0 s\u1eed d\u1ee5ng ph\u00edm t\u1eaft `Ctrl + Shift + %`. T\u01b0\u01a1ng t\u1ef1, trong Google Sheets, b\u1ea1n c\u0169ng ch\u1ecdn c\u00e1c \u00f4 mong mu\u1ed1n, sau \u0111\u00f3 tr\u00ean thanh c\u00f4ng c\u1ee5, nh\u1ea5p v\u00e0o n\u00fat “%” (Format as percent). S\u1ef1 kh\u00e1c bi\u1ec7t c\u1ed1t l\u00f5i khi b\u1ea1n \u0111\u1ecbnh d\u1ea1ng v\u00e0 khi b\u1ea1n t\u1ef1 nh\u00e2n v\u1edbi 100 l\u00e0 kh\u1ea3 n\u0103ng t\u00ednh to\u00e1n sau \u0111\u00f3. Khi m\u1ed9t \u00f4 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng l\u00e0 “Percentage”, gi\u00e1 tr\u1ecb g\u1ed1c (v\u00ed d\u1ee5: 0.25) v\u1eabn \u0111\u01b0\u1ee3c gi\u1eef l\u1ea1i \u0111\u1ec3 s\u1eed d\u1ee5ng trong c\u00e1c c\u00f4ng th\u1ee9c kh\u00e1c. N\u1ebfu b\u1ea1n nh\u00e2n th\u1ee7 c\u00f4ng v\u1edbi 100 \u0111\u1ec3 c\u00f3 s\u1ed1 25, r\u1ed3i th\u00eam k\u00fd t\u1ef1 “%” v\u00e0o sau, \u00f4 \u0111\u00f3 s\u1ebd b\u1ecb coi l\u00e0 v\u0103n b\u1ea3n (text) v\u00e0 kh\u00f4ng th\u1ec3 d\u00f9ng \u0111\u1ec3 t\u00ednh to\u00e1n, g\u00e2y ra l\u1ed7i `#VALUE!`. Do \u0111\u00f3, lu\u00f4n lu\u00f4n s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng \u0111\u1ecbnh d\u1ea1ng c\u1ee7a b\u1ea3ng t\u00ednh.\n\n\n\nM\u1ed9t t\u00ecnh hu\u1ed1ng th\u1ef1c t\u1ebf th\u01b0\u1eddng g\u1eb7p l\u00e0 khi b\u1ea1n c\u00f3 m\u1ed9t c\u1ed9t s\u1ed1 th\u1eadp ph\u00e2n (v\u00ed d\u1ee5: k\u1ebft qu\u1ea3 c\u1ee7a ph\u00e9p chia) v\u00e0 mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i to\u00e0n b\u1ed9 sang d\u1ea1ng ph\u1ea7n tr\u0103m. Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch t\u1ef7 l\u1ec7 ho\u00e0n th\u00e0nh c\u00f4ng vi\u1ec7c \u1edf c\u1ed9t C, v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb nh\u01b0 0.85, 0.92, 0.75. Thay v\u00ec \u0111i t\u1eebng \u00f4 v\u00e0 nh\u00e2n v\u1edbi 100, b\u1ea1n ch\u1ec9 c\u1ea7n b\u00f4i \u0111en to\u00e0n b\u1ed9 c\u1ed9t C, sau \u0111\u00f3 nh\u1ea5p v\u00e0o n\u00fat “%”. Ngay l\u1eadp t\u1ee9c, c\u00e1c gi\u00e1 tr\u1ecb s\u1ebd \u0111\u01b0\u1ee3c chuy\u1ec3n th\u00e0nh 85%, 92%, v\u00e0 75%. \u0110i\u1ec1u n\u00e0y kh\u00f4ng ch\u1ec9 ti\u1ebft ki\u1ec7m th\u1eddi gian m\u00e0 c\u00f2n \u0111\u1ea3m b\u1ea3o t\u00ednh nh\u1ea5t qu\u00e1n v\u00e0 ch\u00ednh x\u00e1c c\u1ee7a d\u1eef li\u1ec7u. N\u1ebfu b\u1ea1n c\u1ea7n t\u00ednh to\u00e1n nhanh m\u00e0 kh\u00f4ng mu\u1ed1n m\u1edf b\u1ea3ng t\u00ednh, c\u00e1c c\u00f4ng c\u1ee5 t\u00ednh ph\u1ea7n tr\u0103m online<\/a> c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t gi\u1ea3i ph\u00e1p thay th\u1ebf ti\u1ec7n l\u1ee3i, nh\u01b0ng \u0111\u1ec3 qu\u1ea3n l\u00fd v\u00e0 ph\u00e2n t\u00edch m\u1ed9t t\u1eadp d\u1eef li\u1ec7u l\u1edbn, vi\u1ec7c th\u00e0nh th\u1ea1o \u0111\u1ecbnh d\u1ea1ng trong Excel v\u00e0 Sheets l\u00e0 k\u1ef9 n\u0103ng b\u1eaft bu\u1ed9c.\n\n\n\n

C\u00f4ng Th\u1ee9c T\u00ednh T\u1ef7 L\u1ec7 Ph\u1ea7n Tr\u0103m Ho\u00e0n Th\u00e0nh (Part of a Total)<\/h2>\n\n\n\nM\u1ed9t trong nh\u1eefng \u1ee9ng d\u1ee5ng ph\u1ed5 bi\u1ebfn nh\u1ea5t c\u1ee7a vi\u1ec7c t\u00ednh ph\u1ea7n tr\u0103m trong Excel<\/strong> l\u00e0 x\u00e1c \u0111\u1ecbnh t\u1ef7 l\u1ec7 ho\u00e0n th\u00e0nh c\u1ee7a m\u1ed9t c\u00f4ng vi\u1ec7c, m\u1ed9t ch\u1ec9 ti\u00eau doanh s\u1ed1, ho\u1eb7c m\u1ed9t ph\u1ea7n so v\u1edbi t\u1ed5ng th\u1ec3. C\u00f4ng th\u1ee9c to\u00e1n h\u1ecdc cho vi\u1ec7c n\u00e0y r\u1ea5t \u0111\u01a1n gi\u1ea3n: `T\u1ef7 l\u1ec7 % = M\u1ed9t ph\u1ea7n \/ T\u1ed5ng s\u1ed1`. Trong m\u00f4i tr\u01b0\u1eddng b\u1ea3ng t\u00ednh, c\u00f4ng th\u1ee9c n\u00e0y \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng m\u1ed9t c\u00e1ch tr\u1ef1c ti\u1ebfp v\u00e0 m\u1ea1nh m\u1ebd, \u0111\u1eb7c bi\u1ec7t khi b\u1ea1n c\u1ea7n t\u00ednh to\u00e1n cho h\u00e0ng lo\u1ea1t d\u1eef li\u1ec7u. Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb “T\u1ed5ng s\u1ed1” (v\u00ed d\u1ee5: \u00f4 A10 ch\u1ee9a t\u1ed5ng doanh thu m\u1ee5c ti\u00eau) v\u00e0 m\u1ed9t c\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb “M\u1ed9t ph\u1ea7n” (v\u00ed d\u1ee5: c\u1ed9t B ch\u1ee9a doanh thu th\u1ef1c t\u1ebf c\u1ee7a t\u1eebng nh\u00e2n vi\u00ean). \u0110\u1ec3 t\u00ednh ph\u1ea7n tr\u0103m ho\u00e0n th\u00e0nh cho nh\u00e2n vi\u00ean \u0111\u1ea7u ti\u00ean (d\u1eef li\u1ec7u \u1edf \u00f4 B2), b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c `=B2\/A10` v\u00e0o \u00f4 C2. K\u1ebft qu\u1ea3 ban \u0111\u1ea7u c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb d\u01b0\u1edbi d\u1ea1ng s\u1ed1 th\u1eadp ph\u00e2n, v\u00ed d\u1ee5 nh\u01b0 0.854. B\u01b0\u1edbc ti\u1ebfp theo, nh\u01b0 \u0111\u00e3 \u0111\u1ec1 c\u1eadp, l\u00e0 \u0111\u1ecbnh d\u1ea1ng \u00f4 C2 th\u00e0nh ki\u1ec3u “Percentage”, v\u00e0 n\u00f3 s\u1ebd t\u1ef1 \u0111\u1ed9ng hi\u1ec3n th\u1ecb l\u00e0 85.4%.\n\n\n\nH\u00e3y xem x\u00e9t m\u1ed9t t\u00ecnh hu\u1ed1ng th\u1ef1c t\u1ebf. Anh Tu\u1ea5n l\u00e0 tr\u01b0\u1edfng ph\u00f2ng kinh doanh c\u1ee7a m\u1ed9t c\u00f4ng ty ph\u00e2n ph\u1ed1i h\u00e0ng ti\u00eau d\u00f9ng. Anh c\u1ea7n theo d\u00f5i ti\u1ebfn \u0111\u1ed9 ho\u00e0n th\u00e0nh ch\u1ec9 ti\u00eau doanh s\u1ed1 th\u00e1ng c\u1ee7a \u0111\u1ed9i ng\u0169 5 ng\u01b0\u1eddi. Ch\u1ec9 ti\u00eau t\u1ed5ng c\u1ee7a c\u1ea3 ph\u00f2ng l\u00e0 1,500,000,000 VN\u0110. Anh Tu\u1ea5n t\u1ea1o m\u1ed9t b\u1ea3ng t\u00ednh v\u1edbi c\u1ed9t A l\u00e0 t\u00ean nh\u00e2n vi\u00ean, c\u1ed9t B l\u00e0 doanh s\u1ed1 th\u1ef1c \u0111\u1ea1t, v\u00e0 anh mu\u1ed1n c\u1ed9t C hi\u1ec3n th\u1ecb t\u1ef7 l\u1ec7 % ho\u00e0n th\u00e0nh. Doanh s\u1ed1 c\u1ee7a t\u1eebng ng\u01b0\u1eddi l\u1ea7n l\u01b0\u1ee3t l\u00e0: 320 tri\u1ec7u, 410 tri\u1ec7u, 280 tri\u1ec7u, 350 tri\u1ec7u, v\u00e0 300 tri\u1ec7u. \u0110\u1ec3 t\u00ednh cho ng\u01b0\u1eddi \u0111\u1ea7u ti\u00ean, anh Tu\u1ea5n nh\u1eadp c\u00f4ng th\u1ee9c `=B2\/1500000000` v\u00e0o \u00f4 C2. Tuy nhi\u00ean, c\u00e1ch l\u00e0m n\u00e0y kh\u00f4ng linh ho\u1ea1t. M\u1ed9t c\u00e1ch t\u1ed1t h\u01a1n l\u00e0 anh \u0111\u1eb7t t\u1ed5ng ch\u1ec9 ti\u00eau 1,500,000,000 v\u00e0o m\u1ed9t \u00f4 ri\u00eang, v\u00ed d\u1ee5 F1. Sau \u0111\u00f3, c\u00f4ng th\u1ee9c cho ng\u01b0\u1eddi \u0111\u1ea7u ti\u00ean s\u1ebd l\u00e0 `=B2\/F1`. \u0110i\u1ec3m m\u1ea5u ch\u1ed1t \u1edf \u0111\u00e2y l\u00e0 khi anh Tu\u1ea5n k\u00e9o c\u00f4ng th\u1ee9c n\u00e0y xu\u1ed1ng cho c\u00e1c nh\u00e2n vi\u00ean kh\u00e1c, tham chi\u1ebfu `B2` s\u1ebd t\u1ef1 \u0111\u1ed9ng th\u00e0nh `B3`, `B4`… nh\u01b0ng tham chi\u1ebfu `F1` c\u0169ng s\u1ebd b\u1ecb thay \u0111\u1ed5i, g\u00e2y ra l\u1ed7i. \u0110\u00e2y l\u00e0 l\u00fac tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i ph\u00e1t huy t\u00e1c d\u1ee5ng.\n\n\n\n

\u0110\u1ec3 c\u1ed1 \u0111\u1ecbnh \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb t\u1ed5ng khi sao ch\u00e9p c\u00f4ng th\u1ee9c, h\u00e3y s\u1eed d\u1ee5ng k\u00fd hi\u1ec7u \u0111\u00f4 la ($). C\u00f4ng th\u1ee9c \u0111\u00fang ph\u1ea3i l\u00e0 =B2\/$F$1<\/strong>. K\u00fd hi\u1ec7u `$` tr\u01b0\u1edbc c\u1ed9t (F) v\u00e0 h\u00e0ng (1) s\u1ebd “kh\u00f3a” \u00f4 F1 l\u1ea1i, \u0111\u1ea3m b\u1ea3o m\u1ecdi ph\u00e9p chia \u0111\u1ec1u tham chi\u1ebfu \u0111\u1ebfn \u0111\u00fang \u00f4 t\u1ed5ng ch\u1ec9 ti\u00eau. \u0110\u00e2y l\u00e0 m\u1ed9t k\u1ef9 thu\u1eadt b\u1eaft bu\u1ed9c ph\u1ea3i bi\u1ebft khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c ph\u1ea7n tr\u0103m Google Sheets<\/strong> v\u00e0 Excel.<\/p>\n\n\n\nSau khi nh\u1eadp c\u00f4ng th\u1ee9c `=B2\/$F$1` v\u00e0o \u00f4 C2 v\u00e0 \u0111\u1ecbnh d\u1ea1ng n\u00f3 th\u00e0nh ph\u1ea7n tr\u0103m, anh Tu\u1ea5n ch\u1ec9 c\u1ea7n nh\u1ea5p v\u00e0o g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i c\u1ee7a \u00f4 C2 (con tr\u1ecf chu\u1ed9t bi\u1ebfn th\u00e0nh d\u1ea5u c\u1ed9ng m\u00e0u \u0111en) v\u00e0 k\u00e9o xu\u1ed1ng h\u1ebft danh s\u00e1ch nh\u00e2n vi\u00ean. B\u1ea3ng t\u00ednh s\u1ebd t\u1ef1 \u0111\u1ed9ng t\u00ednh to\u00e1n t\u1ef7 l\u1ec7 ho\u00e0n th\u00e0nh cho t\u1ea5t c\u1ea3 m\u1ecdi ng\u01b0\u1eddi m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c: 21.3%, 27.3%, 18.7%, 23.3%, v\u00e0 20.0%. V\u1edbi b\u1ea3ng d\u1eef li\u1ec7u n\u00e0y, anh Tu\u1ea5n c\u00f3 th\u1ec3 nhanh ch\u00f3ng x\u00e1c \u0111\u1ecbnh ai \u0111ang l\u00e0m t\u1ed1t, ai c\u1ea7n h\u1ed7 tr\u1ee3, v\u00e0 t\u00ecnh h\u00ecnh chung c\u1ee7a c\u1ea3 \u0111\u1ed9i. Vi\u1ec7c s\u1eed d\u1ee5ng tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i kh\u00f4ng ch\u1ec9 gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian nh\u1eadp li\u1ec7u m\u00e0 c\u00f2n gi\u1ea3m thi\u1ec3u \u0111\u00e1ng k\u1ec3 nguy c\u01a1 sai s\u00f3t, l\u00e0m cho b\u00e1o c\u00e1o c\u1ee7a b\u1ea1n tr\u1edf n\u00ean chuy\u00ean nghi\u1ec7p v\u00e0 \u0111\u00e1ng tin c\u1eady h\u01a1n r\u1ea5t nhi\u1ec1u.\n\n\n\n

C\u00e1ch T\u00ednh Ph\u1ea7n Tr\u0103m T\u0103ng Tr\u01b0\u1edfng\/S\u1ee5t Gi\u1ea3m Gi\u1eefa Hai K\u1ef3<\/h2>\n\n\n\nPh\u00e2n t\u00edch s\u1ef1 thay \u0111\u1ed5i theo th\u1eddi gian l\u00e0 m\u1ed9t y\u00eau c\u1ea7u c\u1ed1t l\u00f5i trong kinh doanh v\u00e0 t\u00e0i ch\u00ednh. Vi\u1ec7c t\u00ednh to\u00e1n ph\u1ea7n tr\u0103m t\u0103ng tr\u01b0\u1edfng ho\u1eb7c s\u1ee5t gi\u1ea3m gi\u1eefa hai k\u1ef3 (v\u00ed d\u1ee5: th\u00e1ng n\u00e0y so v\u1edbi th\u00e1ng tr\u01b0\u1edbc, qu\u00fd n\u00e0y so v\u1edbi qu\u00fd tr\u01b0\u1edbc) gi\u00fap c\u00e1c nh\u00e0 qu\u1ea3n l\u00fd \u0111\u01b0a ra quy\u1ebft \u0111\u1ecbnh d\u1ef1a tr\u00ean d\u1eef li\u1ec7u. C\u00f4ng th\u1ee9c chung \u0111\u1ec3 t\u00ednh to\u00e1n s\u1ef1 thay \u0111\u1ed5i ph\u1ea7n tr\u0103m l\u00e0: `Thay \u0111\u1ed5i % = (Gi\u00e1 tr\u1ecb m\u1edbi – Gi\u00e1 tr\u1ecb c\u0169) \/ Gi\u00e1 tr\u1ecb c\u0169`. M\u1ed9t bi\u1ebfn th\u1ec3 kh\u00e1c c\u1ee7a c\u00f4ng th\u1ee9c n\u00e0y, th\u01b0\u1eddng d\u1ec5 nh\u1eadp v\u00e0o b\u1ea3ng t\u00ednh h\u01a1n, l\u00e0 `Thay \u0111\u1ed5i % = (Gi\u00e1 tr\u1ecb m\u1edbi \/ Gi\u00e1 tr\u1ecb c\u0169) – 1`. C\u1ea3 hai c\u00f4ng th\u1ee9c \u0111\u1ec1u cho ra c\u00f9ng m\u1ed9t k\u1ebft qu\u1ea3. K\u1ebft qu\u1ea3 d\u01b0\u01a1ng cho th\u1ea5y s\u1ef1 t\u0103ng tr\u01b0\u1edfng, trong khi k\u1ebft qu\u1ea3 \u00e2m bi\u1ec3u th\u1ecb s\u1ef1 s\u1ee5t gi\u1ea3m. \u0110\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng th\u1ee9c ph\u1ea7n tr\u0103m Google Sheets<\/strong> v\u00e0 Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng th\u01b0\u1eddng xuy\u00ean nh\u1ea5t trong c\u00e1c b\u00e1o c\u00e1o t\u00e0i ch\u00ednh v\u00e0 kinh doanh.\n\n\n\nH\u00e3y c\u00f9ng xem x\u00e9t v\u00ed d\u1ee5 c\u1ee7a ch\u1ecb Lan, ch\u1ee7 m\u1ed9t c\u1eeda h\u00e0ng th\u1eddi trang online. Ch\u1ecb mu\u1ed1n ph\u00e2n t\u00edch hi\u1ec7u qu\u1ea3 kinh doanh c\u1ee7a m\u00ecnh b\u1eb1ng c\u00e1ch so s\u00e1nh doanh thu c\u1ee7a 6 th\u00e1ng \u0111\u1ea7u n\u0103m. Ch\u1ecb c\u00f3 m\u1ed9t b\u1ea3ng t\u00ednh v\u1edbi c\u1ed9t A l\u00e0 c\u00e1c th\u00e1ng (Th\u00e1ng 1 \u0111\u1ebfn Th\u00e1ng 6) v\u00e0 c\u1ed9t B l\u00e0 doanh thu t\u01b0\u01a1ng \u1ee9ng. Doanh thu t\u1eeb th\u00e1ng 1 \u0111\u1ebfn th\u00e1ng 6 l\u1ea7n l\u01b0\u1ee3t l\u00e0: 85 tri\u1ec7u, 92 tri\u1ec7u, 88 tri\u1ec7u, 105 tri\u1ec7u, 112 tri\u1ec7u, v\u00e0 120 tri\u1ec7u. \u0110\u1ec3 t\u00ednh ph\u1ea7n tr\u0103m t\u0103ng tr\u01b0\u1edfng c\u1ee7a Th\u00e1ng 2 so v\u1edbi Th\u00e1ng 1, ch\u1ecb Lan s\u1ebd ch\u1ecdn \u00f4 C3 (ngang h\u00e0ng v\u1edbi Th\u00e1ng 2) v\u00e0 nh\u1eadp c\u00f4ng th\u1ee9c `=(B3-B2)\/B2` ho\u1eb7c `=B3\/B2-1`. Gi\u1ea3 s\u1eed \u00f4 B2 ch\u1ee9a doanh thu th\u00e1ng 1 (85 tri\u1ec7u) v\u00e0 B3 ch\u1ee9a doanh thu th\u00e1ng 2 (92 tri\u1ec7u). C\u00f4ng th\u1ee9c s\u1ebd l\u00e0 `=(92-85)\/85`, cho k\u1ebft qu\u1ea3 kho\u1ea3ng 0.0823. Sau khi \u0111\u1ecbnh d\u1ea1ng \u00f4 C3 th\u00e0nh “Percentage”, n\u00f3 s\u1ebd hi\u1ec3n th\u1ecb l\u00e0 8.24%. Ch\u1ecb Lan sau \u0111\u00f3 c\u00f3 th\u1ec3 k\u00e9o c\u00f4ng th\u1ee9c n\u00e0y xu\u1ed1ng c\u00e1c \u00f4 C4, C5, C6, C7 \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng t\u00ednh to\u00e1n t\u1ef7 l\u1ec7 t\u0103ng tr\u01b0\u1edfng cho c\u00e1c th\u00e1ng c\u00f2n l\u1ea1i.\n\n\n\nKhi ch\u1ecb Lan k\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng \u00f4 C4 \u0111\u1ec3 t\u00ednh cho Th\u00e1ng 3 so v\u1edbi Th\u00e1ng 2, c\u00f4ng th\u1ee9c s\u1ebd l\u00e0 `=(B4-B3)\/B3`. V\u1edbi doanh thu th\u00e1ng 3 l\u00e0 88 tri\u1ec7u, k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 `(88-92)\/92 = -0.0435`, hay -4.35%. D\u1ea5u \u00e2m \u1edf \u0111\u00e2y r\u1ea5t quan tr\u1ecdng, n\u00f3 cho th\u1ea5y doanh thu \u0111\u00e3 gi\u1ea3m so v\u1edbi th\u00e1ng tr\u01b0\u1edbc. B\u1eb1ng c\u00e1ch n\u00e0y, ch\u1ecb Lan c\u00f3 m\u1ed9t c\u00e1i nh\u00ecn tr\u1ef1c quan v\u1ec1 bi\u1ebfn \u0111\u1ed9ng doanh thu h\u00e0ng th\u00e1ng: t\u0103ng 8.24% trong th\u00e1ng 2, gi\u1ea3m 4.35% trong th\u00e1ng 3, sau \u0111\u00f3 t\u0103ng m\u1ea1nh 19.32% trong th\u00e1ng 4. Vi\u1ec7c ph\u00e2n t\u00edch s\u00e2u h\u01a1n v\u1ec1 c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m t\u0103ng gi\u1ea3m gi\u1eefa hai m\u1ed1c<\/a> c\u00f3 th\u1ec3 gi\u00fap ch\u1ecb t\u00ecm ra nguy\u00ean nh\u00e2n c\u1ee7a nh\u1eefng bi\u1ebfn \u0111\u1ed9ng n\u00e0y, v\u00ed d\u1ee5 nh\u01b0 c\u00e1c chi\u1ebfn d\u1ecbch marketing trong th\u00e1ng 4 \u0111\u00e3 ho\u1ea1t \u0111\u1ed9ng hi\u1ec7u qu\u1ea3. \u0110\u00e2y l\u00e0 s\u1ee9c m\u1ea1nh c\u1ee7a vi\u1ec7c bi\u1ebfn nh\u1eefng con s\u1ed1 kh\u00f4 khan th\u00e0nh th\u00f4ng tin chi ti\u1ebft h\u1eefu \u00edch cho vi\u1ec7c ra quy\u1ebft \u0111\u1ecbnh kinh doanh. N\u1ebfu kh\u00f4ng c\u00f3 b\u1ea3ng t\u00ednh, vi\u1ec7c n\u00e0y s\u1ebd t\u1ed1n r\u1ea5t nhi\u1ec1u th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c.\n\n\n\n

T\u00ednh Gi\u00e1 Tr\u1ecb Khi Bi\u1ebft T\u1ed5ng v\u00e0 T\u1ef7 L\u1ec7 Ph\u1ea7n Tr\u0103m<\/h2>\n\n\n\nM\u1ed9t b\u00e0i to\u00e1n ng\u01b0\u1ee3c l\u1ea1i nh\u01b0ng c\u0169ng kh\u00f4ng k\u00e9m ph\u1ea7n quan tr\u1ecdng l\u00e0 t\u00ednh gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t ph\u1ea7n khi b\u1ea1n \u0111\u00e3 bi\u1ebft t\u1ed5ng s\u1ed1 v\u00e0 t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m c\u1ee7a ph\u1ea7n \u0111\u00f3. C\u00f4ng th\u1ee9c cho tr\u01b0\u1eddng h\u1ee3p n\u00e0y c\u1ef1c k\u1ef3 \u0111\u01a1n gi\u1ea3n: `Gi\u00e1 tr\u1ecb m\u1ed9t ph\u1ea7n = T\u1ed5ng s\u1ed1 * T\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m`. \u1ee8ng d\u1ee5ng c\u1ee7a c\u00f4ng th\u1ee9c n\u00e0y v\u00f4 c\u00f9ng \u0111a d\u1ea1ng trong cu\u1ed9c s\u1ed1ng h\u00e0ng ng\u00e0y v\u00e0 c\u00f4ng vi\u1ec7c, t\u1eeb vi\u1ec7c t\u00ednh ti\u1ec1n boa, ti\u1ec1n hoa h\u1ed3ng, s\u1ed1 ti\u1ec1n \u0111\u01b0\u1ee3c gi\u1ea3m gi\u00e1 khi mua s\u1eafm, cho \u0111\u1ebfn vi\u1ec7c t\u00ednh to\u00e1n c\u00e1c kho\u1ea3n thu\u1ebf nh\u01b0 thu\u1ebf gi\u00e1 tr\u1ecb gia t\u0103ng (VAT). Vi\u1ec7c s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c ph\u1ea7n tr\u0103m Google Sheets<\/strong> hay Excel cho b\u00e0i to\u00e1n n\u00e0y gi\u00fap t\u1ef1 \u0111\u1ed9ng h\u00f3a v\u00e0 \u0111\u1ea3m b\u1ea3o \u0111\u1ed9 ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i, \u0111\u1eb7c bi\u1ec7t khi ph\u1ea3i x\u1eed l\u00fd m\u1ed9t danh s\u00e1ch d\u00e0i c\u00e1c m\u1eb7t h\u00e0ng ho\u1eb7c giao d\u1ecbch. B\u1ea1n ch\u1ec9 c\u1ea7n \u0111\u1ea3m b\u1ea3o r\u1eb1ng t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m \u0111\u01b0\u1ee3c nh\u1eadp \u0111\u00fang c\u00e1ch v\u00e0o \u00f4 t\u00ednh, ho\u1eb7c l\u00e0 d\u01b0\u1edbi d\u1ea1ng s\u1ed1 th\u1eadp ph\u00e2n (v\u00ed d\u1ee5: 0.15 cho 15%) ho\u1eb7c l\u00e0 nh\u1eadp tr\u1ef1c ti\u1ebfp “15%” v\u00e0 \u0111\u1ec3 ph\u1ea7n m\u1ec1m t\u1ef1 hi\u1ec3u.\n\n\n\nH\u00e3y t\u01b0\u1edfng t\u01b0\u1ee3ng b\u1ea1n l\u00e0 nh\u00e2n vi\u00ean k\u1ebf to\u00e1n v\u00e0 c\u1ea7n t\u00ednh ti\u1ec1n thu\u1ebf VAT 8% cho m\u1ed9t lo\u1ea1t h\u00f3a \u0111\u01a1n. B\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch gi\u00e1 tr\u1ecb c\u00e1c h\u00f3a \u0111\u01a1n tr\u01b0\u1edbc thu\u1ebf \u1edf c\u1ed9t A. \u0110\u1ec3 t\u00ednh s\u1ed1 ti\u1ec1n thu\u1ebf VAT cho h\u00f3a \u0111\u01a1n \u0111\u1ea7u ti\u00ean \u1edf \u00f4 A2, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c `=A2*8%` ho\u1eb7c `=A2*0.08` v\u00e0o \u00f4 B2. V\u00ed d\u1ee5, n\u1ebfu gi\u00e1 tr\u1ecb h\u00f3a \u0111\u01a1n \u1edf A2 l\u00e0 5,500,000 VN\u0110, c\u00f4ng th\u1ee9c `=5500000*8%` s\u1ebd cho ra k\u1ebft qu\u1ea3 l\u00e0 440,000 VN\u0110. Sau \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 k\u00e9o c\u00f4ng th\u1ee9c n\u00e0y xu\u1ed1ng cho to\u00e0n b\u1ed9 c\u1ed9t h\u00f3a \u0111\u01a1n \u0111\u1ec3 t\u00ednh ti\u1ec1n thu\u1ebf cho t\u1ea5t c\u1ea3 ch\u1ec9 trong v\u00e0i gi\u00e2y. \u0110\u1ec3 t\u00ednh t\u1ed5ng s\u1ed1 ti\u1ec1n kh\u00e1ch h\u00e0ng ph\u1ea3i tr\u1ea3 (gi\u00e1 sau thu\u1ebf), b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng c\u00f4ng th\u1ee9c \u1edf c\u1ed9t C: `=A2+B2` ho\u1eb7c m\u1ed9t c\u00f4ng th\u1ee9c g\u1ed9p ti\u1ec7n l\u1ee3i h\u01a1n l\u00e0 `=A2*(1+8%)` ho\u1eb7c `=A2*1.08`. Vi\u1ec7c hi\u1ec3u r\u00f5 c\u00e1ch t\u00ednh VAT v\u00e0 gi\u00e1 sau thu\u1ebf<\/a> l\u00e0 m\u1ed9t k\u1ef9 n\u0103ng thi\u1ebft y\u1ebfu cho b\u1ea5t k\u1ef3 ai l\u00e0m vi\u1ec7c trong l\u0129nh v\u1ef1c k\u1ebf to\u00e1n, b\u00e1n h\u00e0ng.\n\n\n\n

L\u01b0u \u00fd quan tr\u1ecdng: Khi nh\u1eadp ph\u1ea7n tr\u0103m v\u00e0o c\u00f4ng th\u1ee9c, h\u00e3y lu\u00f4n bao g\u1ed3m k\u00fd hi\u1ec7u `%`. N\u1ebfu b\u1ea1n ch\u1ec9 nh\u1eadp `=A2*8`, Excel\/Sheets s\u1ebd hi\u1ec3u l\u00e0 nh\u00e2n v\u1edbi 8, kh\u00f4ng ph\u1ea3i 8% (0.08). \u0110i\u1ec1u n\u00e0y s\u1ebd d\u1eabn \u0111\u1ebfn k\u1ebft qu\u1ea3 sai l\u1ec7ch c\u1ef1c l\u1edbn. Vi\u1ec7c nh\u1eadp \u0111\u00fang `8%` \u0111\u1ea3m b\u1ea3o ph\u1ea7n m\u1ec1m di\u1ec5n gi\u1ea3i ch\u00ednh x\u00e1c \u00fd \u0111\u1ecbnh c\u1ee7a b\u1ea1n.<\/p>\n\n\n\nM\u1ed9t v\u00ed d\u1ee5 kh\u00e1c l\u00e0 t\u00ednh ti\u1ec1n hoa h\u1ed3ng cho nh\u00e2n vi\u00ean b\u00e1n h\u00e0ng. C\u00f4 H\u01b0\u01a1ng, qu\u1ea3n l\u00fd m\u1ed9t \u0111\u1ea1i l\u00fd b\u1ea5t \u0111\u1ed9ng s\u1ea3n, quy \u0111\u1ecbnh m\u1ee9c hoa h\u1ed3ng l\u00e0 1.5% tr\u00ean gi\u00e1 tr\u1ecb m\u1ed7i h\u1ee3p \u0111\u1ed3ng th\u00e0nh c\u00f4ng. C\u00f4 c\u00f3 m\u1ed9t danh s\u00e1ch c\u00e1c giao d\u1ecbch trong th\u00e1ng \u1edf c\u1ed9t A. \u0110\u1ec3 t\u00ednh hoa h\u1ed3ng cho giao d\u1ecbch \u0111\u1ea7u ti\u00ean \u1edf A2 tr\u1ecb gi\u00e1 3,200,000,000 VN\u0110, c\u00f4 nh\u1eadp c\u00f4ng th\u1ee9c `=A2*1.5%` v\u00e0o \u00f4 B2. K\u1ebft qu\u1ea3 s\u1ebd l\u00e0 48,000,000 VN\u0110. T\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u00ed d\u1ee5 tr\u00ean, c\u00f4 c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y cho to\u00e0n b\u1ed9 danh s\u00e1ch giao d\u1ecbch \u0111\u1ec3 t\u00ednh t\u1ed5ng hoa h\u1ed3ng ph\u1ea3i tr\u1ea3 cho nh\u00e2n vi\u00ean trong th\u00e1ng. S\u1ef1 t\u1ef1 \u0111\u1ed9ng h\u00f3a n\u00e0y kh\u00f4ng ch\u1ec9 gi\u00fap c\u00f4 H\u01b0\u01a1ng ti\u1ebft ki\u1ec7m h\u00e0ng gi\u1edd l\u00e0m vi\u1ec7c th\u1ee7 c\u00f4ng m\u00e0 c\u00f2n t\u1ea1o ra m\u1ed9t b\u1ea3ng t\u00ednh minh b\u1ea1ch, d\u1ec5 d\u00e0ng ki\u1ec3m tra v\u00e0 \u0111\u1ed1i so\u00e1t khi c\u1ea7n thi\u1ebft. N\u1ebfu c\u00f3 nhu c\u1ea7u t\u00ednh to\u00e1n nhanh c\u00e1c kho\u1ea3n nh\u1ecf l\u1ebb, m\u1ed9t chi\u1ebfc m\u00e1y t\u00ednh ph\u1ea7n tr\u0103m mi\u1ec5n ph\u00ed<\/a> tr\u00ean web c\u0169ng r\u1ea5t h\u1eefu \u00edch, nh\u01b0ng v\u1edbi c\u00e1c t\u00e1c v\u1ee5 l\u1eb7p \u0111i l\u1eb7p l\u1ea1i v\u00e0 c\u1ea7n l\u01b0u tr\u1eef, Excel v\u00e0 Google Sheets v\u1eabn l\u00e0 l\u1ef1a ch\u1ecdn t\u1ed1i \u01b0u.\n\n\n\n

So S\u00e1nh S\u1ef1 Kh\u00e1c Bi\u1ec7t v\u00e0 T\u01b0\u01a1ng \u0110\u1ed3ng Gi\u1eefa Excel v\u00e0 Google Sheets<\/h2>\n\n\n\nKhi n\u00f3i \u0111\u1ebfn vi\u1ec7c t\u00ednh ph\u1ea7n tr\u0103m trong Excel<\/strong> v\u00e0 Google Sheets, ng\u01b0\u1eddi d\u00f9ng th\u01b0\u1eddng th\u1eafc m\u1eafc li\u1ec7u c\u00f3 s\u1ef1 kh\u00e1c bi\u1ec7t l\u1edbn n\u00e0o gi\u1eefa hai n\u1ec1n t\u1ea3ng n\u00e0y kh\u00f4ng. Tin vui l\u00e0 \u0111\u1ed1i v\u1edbi c\u00e1c ph\u00e9p t\u00ednh ph\u1ea7n tr\u0103m c\u01a1 b\u1ea3n v\u00e0 h\u1ea7u h\u1ebft c\u00e1c h\u00e0m th\u00f4ng d\u1ee5ng, c\u1ea3 hai ho\u1ea1t \u0111\u1ed9ng g\u1ea7n nh\u01b0 gi\u1ed1ng h\u1ec7t nhau. C\u00e1c c\u00f4ng th\u1ee9c nh\u01b0 `=A1\/B1`, `=(B1\/A1)-1`, v\u00e0 `=A1*10%` \u0111\u1ec1u c\u00f3 c\u00fa ph\u00e1p v\u00e0 cho ra k\u1ebft qu\u1ea3 y h\u1ec7t tr\u00ean c\u1ea3 hai ph\u1ea7n m\u1ec1m. Giao di\u1ec7n \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng m\u1ed9t \u00f4 th\u00e0nh ki\u1ec3u “Percentage” c\u0169ng r\u1ea5t t\u01b0\u01a1ng \u0111\u1ed3ng, th\u01b0\u1eddng l\u00e0 m\u1ed9t n\u00fat c\u00f3 bi\u1ec3u t\u01b0\u1ee3ng “%” tr\u00ean thanh c\u00f4ng c\u1ee5 ch\u00ednh. \u0110i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a l\u00e0 n\u1ebfu b\u1ea1n \u0111\u00e3 th\u00e0nh th\u1ea1o vi\u1ec7c t\u00ednh ph\u1ea7n tr\u0103m tr\u00ean Excel, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng chuy\u1ec3n sang s\u1eed d\u1ee5ng Google Sheets v\u00e0 ng\u01b0\u1ee3c l\u1ea1i m\u00e0 kh\u00f4ng g\u1eb7p nhi\u1ec1u kh\u00f3 kh\u0103n. S\u1ef1 t\u01b0\u01a1ng \u0111\u1ed3ng n\u00e0y gi\u00fap vi\u1ec7c chia s\u1ebb file v\u00e0 l\u00e0m vi\u1ec7c c\u1ed9ng t\u00e1c gi\u1eefa nh\u1eefng ng\u01b0\u1eddi d\u00f9ng c\u00e1c h\u1ec7 th\u1ed1ng kh\u00e1c nhau tr\u1edf n\u00ean li\u1ec1n m\u1ea1ch h\u01a1n.\n\n\n\nTuy nhi\u00ean, s\u1ef1 kh\u00e1c bi\u1ec7t ch\u00ednh gi\u1eefa Excel v\u00e0 Google Sheets kh\u00f4ng n\u1eb1m \u1edf c\u00e1c c\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n m\u00e0 \u1edf tri\u1ebft l\u00fd ho\u1ea1t \u0111\u1ed9ng v\u00e0 c\u00e1c t\u00ednh n\u0103ng n\u00e2ng cao. Google Sheets l\u00e0 m\u1ed9t \u1ee9ng d\u1ee5ng d\u1ef1a tr\u00ean n\u1ec1n t\u1ea3ng \u0111\u00e1m m\u00e2y, v\u1edbi th\u1ebf m\u1ea1nh v\u01b0\u1ee3t tr\u1ed9i v\u1ec1 kh\u1ea3 n\u0103ng c\u1ed9ng t\u00e1c theo th\u1eddi gian th\u1ef1c. Nhi\u1ec1u ng\u01b0\u1eddi c\u00f3 th\u1ec3 c\u00f9ng l\u00fac ch\u1ec9nh s\u1eeda m\u1ed9t trang t\u00ednh, v\u00e0 m\u1ecdi thay \u0111\u1ed5i \u0111\u1ec1u \u0111\u01b0\u1ee3c l\u01b0u t\u1ef1 \u0111\u1ed9ng. \u0110i\u1ec1u n\u00e0y l\u00fd t\u01b0\u1edfng cho c\u00e1c nh\u00f3m l\u00e0m vi\u1ec7c c\u1ea7n c\u1eadp nh\u1eadt d\u1eef li\u1ec7u chung li\u00ean t\u1ee5c, ch\u1eb3ng h\u1ea1n nh\u01b0 b\u1ea3ng theo d\u00f5i ti\u1ebfn \u0111\u1ed9 d\u1ef1 \u00e1n ho\u1eb7c b\u00e1o c\u00e1o doanh s\u1ed1 h\u00e0ng ng\u00e0y. Ng\u01b0\u1ee3c l\u1ea1i, Excel, m\u1ed9t ph\u1ea7n c\u1ee7a b\u1ed9 Microsoft Office, c\u00f3 truy\u1ec1n th\u1ed1ng l\u00e0 m\u1ed9t \u1ee9ng d\u1ee5ng m\u00e1y t\u00ednh \u0111\u1ec3 b\u00e0n m\u1ea1nh m\u1ebd. M\u1eb7c d\u00f9 c\u00e1c phi\u00ean b\u1ea3n m\u1edbi c\u1ee7a Excel (qua Microsoft 365) \u0111\u00e3 c\u1ea3i thi\u1ec7n \u0111\u00e1ng k\u1ec3 kh\u1ea3 n\u0103ng c\u1ed9ng t\u00e1c, th\u1ebf m\u1ea1nh c\u1ed1t l\u00f5i c\u1ee7a n\u00f3 v\u1eabn n\u1eb1m \u1edf kh\u1ea3 n\u0103ng x\u1eed l\u00fd c\u00e1c t\u1eadp d\u1eef li\u1ec7u c\u1ef1c l\u1edbn, c\u00e1c m\u00f4 h\u00ecnh t\u00e0i ch\u00ednh ph\u1ee9c t\u1ea1p v\u00e0 c\u00e1c c\u00f4ng c\u1ee5 ph\u00e2n t\u00edch d\u1eef li\u1ec7u chuy\u00ean s\u00e2u nh\u01b0 Power Query v\u00e0 Power Pivot, v\u1ed1n m\u1ea1nh h\u01a1n c\u00e1c c\u00f4ng c\u1ee5 t\u01b0\u01a1ng \u0111\u01b0\u01a1ng tr\u00ean Google Sheets.\n\n\n\n\u0110\u1ec3 cung c\u1ea5p m\u1ed9t c\u00e1i nh\u00ecn t\u1ed5ng quan, b\u1ea3ng so s\u00e1nh d\u01b0\u1edbi \u0111\u00e2y s\u1ebd l\u00e0m r\u00f5 nh\u1eefng \u0111i\u1ec3m t\u01b0\u01a1ng \u0111\u1ed3ng v\u00e0 kh\u00e1c bi\u1ec7t ch\u00ednh gi\u1eefa hai c\u00f4ng c\u1ee5 n\u00e0y khi x\u00e9t \u0111\u1ebfn vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u n\u00f3i chung v\u00e0 c\u00e1c c\u00f4ng th\u1ee9c ph\u1ea7n tr\u0103m Google Sheets<\/strong> n\u00f3i ri\u00eang. S\u1ef1 l\u1ef1a ch\u1ecdn gi\u1eefa Excel v\u00e0 Google Sheets th\u01b0\u1eddng ph\u1ee5 thu\u1ed9c v\u00e0o nhu c\u1ea7u c\u1ee5 th\u1ec3 c\u1ee7a b\u1ea1n: n\u1ebfu \u01b0u ti\u00ean h\u00e0ng \u0111\u1ea7u l\u00e0 c\u1ed9ng t\u00e1c v\u00e0 truy c\u1eadp m\u1ecdi l\u00fac m\u1ecdi n\u01a1i, Google Sheets l\u00e0 l\u1ef1a ch\u1ecdn tuy\u1ec7t v\u1eddi. N\u1ebfu c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n \u0111\u00f2i h\u1ecfi ph\u1ea3i ph\u00e2n t\u00edch c\u00e1c b\u1ed9 d\u1eef li\u1ec7u kh\u1ed5ng l\u1ed3 v\u00e0 s\u1eed d\u1ee5ng c\u00e1c t\u00ednh n\u0103ng ph\u00e2n t\u00edch n\u00e2ng cao, Excel c\u00f3 th\u1ec3 l\u00e0 c\u00f4ng c\u1ee5 ph\u00f9 h\u1ee3p h\u01a1n. D\u00f9 sao \u0111i n\u1eefa, v\u1edbi c\u00e1c t\u00e1c v\u1ee5 h\u00e0ng ng\u00e0y, c\u1ea3 hai \u0111\u1ec1u l\u00e0 nh\u1eefng tr\u1ee3 th\u1ee7 \u0111\u1eafc l\u1ef1c. N\u1ebfu b\u1ea1n ch\u1ec9 c\u1ea7n t\u00ednh to\u00e1n \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng, \u0111\u1eebng qu\u00ean r\u1eb1ng c\u00e1c trang web nh\u01b0 website 1phantram<\/a> c\u0169ng cung c\u1ea5p c\u00e1c c\u00f4ng c\u1ee5 r\u1ea5t ti\u1ec7n d\u1ee5ng.\n\n\n\n
Ti\u00eau ch\u00ed<\/th>Microsoft Excel<\/th>Google Sheets<\/th><\/tr><\/thead>
C\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n<\/strong><\/td>Ho\u00e0n to\u00e0n t\u01b0\u01a1ng th\u00edch (v\u00ed d\u1ee5: =, +, -, *, \/)<\/td>Ho\u00e0n to\u00e0n t\u01b0\u01a1ng th\u00edch<\/td><\/tr>
\u0110\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m<\/strong><\/td>N\u00fat “%” tr\u00ean tab Home, ph\u00edm t\u1eaft Ctrl+Shift+%<\/td>N\u00fat “%” tr\u00ean thanh c\u00f4ng c\u1ee5<\/td><\/tr>
C\u1ed9ng t\u00e1c th\u1eddi gian th\u1ef1c<\/strong><\/td>C\u00f3 tr\u00ean phi\u00ean b\u1ea3n Microsoft 365, nh\u01b0ng Google Sheets th\u01b0\u1eddng \u0111\u01b0\u1ee3c \u0111\u00e1nh gi\u00e1 l\u00e0 m\u01b0\u1ee3t m\u00e0 h\u01a1n<\/td>Th\u1ebf m\u1ea1nh c\u1ed1t l\u00f5i, nhi\u1ec1u ng\u01b0\u1eddi c\u00f9ng ch\u1ec9nh s\u1eeda m\u1ed9t l\u00fac r\u1ea5t m\u01b0\u1ee3t m\u00e0<\/td><\/tr>
L\u00e0m vi\u1ec7c ngo\u1ea1i tuy\u1ebfn<\/strong><\/td>Th\u1ebf m\u1ea1nh truy\u1ec1n th\u1ed1ng, ho\u1ea1t \u0111\u1ed9ng \u0111\u1ea7y \u0111\u1ee7 t\u00ednh n\u0103ng khi kh\u00f4ng c\u00f3 m\u1ea1ng<\/td>Y\u00eau c\u1ea7u thi\u1ebft l\u1eadp tr\u01b0\u1edbc \u0111\u1ec3 truy c\u1eadp v\u00e0 ch\u1ec9nh s\u1eeda ngo\u1ea1i tuy\u1ebfn, m\u1ed9t s\u1ed1 t\u00ednh n\u0103ng b\u1ecb h\u1ea1n ch\u1ebf<\/td><\/tr>
Chi ph\u00ed<\/strong><\/td>Th\u01b0\u1eddng y\u00eau c\u1ea7u mua gi\u1ea5y ph\u00e9p Microsoft Office ho\u1eb7c \u0111\u0103ng k\u00fd Microsoft 365<\/td>Mi\u1ec5n ph\u00ed v\u1edbi t\u00e0i kho\u1ea3n Google c\u00e1 nh\u00e2n<\/td><\/tr>
X\u1eed l\u00fd d\u1eef li\u1ec7u l\u1edbn<\/strong><\/td>R\u1ea5t m\u1ea1nh m\u1ebd, c\u00f3 th\u1ec3 x\u1eed l\u00fd h\u00e0ng tri\u1ec7u d\u00f2ng d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3<\/td>C\u00f3 th\u1ec3 tr\u1edf n\u00ean ch\u1eadm khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c t\u1ec7p r\u1ea5t l\u1edbn (h\u00e0ng tr\u0103m ngh\u00ecn d\u00f2ng)<\/td><\/tr>
H\u00e0m n\u00e2ng cao \u0111\u1ed9c quy\u1ec1n<\/strong><\/td>Power Query, Power Pivot, c\u00e1c h\u00e0m nh\u01b0 XLOOKUP (m\u1edbi h\u01a1n VLOOKUP)<\/td>QUERY, GOOGLEFINANCE, IMPORTRANGE, r\u1ea5t m\u1ea1nh cho vi\u1ec7c l\u1ea5y d\u1eef li\u1ec7u t\u1eeb c\u00e1c ngu\u1ed3n kh\u00e1c<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

C\u00e1c H\u00e0m N\u00e2ng Cao v\u00e0 M\u1eb9o H\u1eefu \u00cdch Khi L\u00e0m Vi\u1ec7c v\u1edbi Ph\u1ea7n Tr\u0103m<\/h2>\n\n\n\nNgo\u00e0i c\u00e1c c\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n, vi\u1ec7c k\u1ebft h\u1ee3p t\u00ednh to\u00e1n ph\u1ea7n tr\u0103m v\u1edbi c\u00e1c h\u00e0m logic v\u00e0 \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n s\u1ebd n\u00e2ng t\u1ea7m kh\u1ea3 n\u0103ng ph\u00e2n t\u00edch d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n trong Excel v\u00e0 Google Sheets. M\u1ed9t trong nh\u1eefng h\u00e0m h\u1eefu \u00edch nh\u1ea5t l\u00e0 h\u00e0m `IF`. H\u00e0m `IF` cho ph\u00e9p b\u1ea1n th\u1ef1c hi\u1ec7n m\u1ed9t h\u00e0nh \u0111\u1ed9ng n\u1ebfu m\u1ed9t \u0111i\u1ec1u ki\u1ec7n l\u00e0 \u0111\u00fang, v\u00e0 m\u1ed9t h\u00e0nh \u0111\u1ed9ng kh\u00e1c n\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u00f3 l\u00e0 sai. Khi \u00e1p d\u1ee5ng v\u1edbi ph\u1ea7n tr\u0103m, n\u00f3 tr\u1edf n\u00ean c\u1ef1c k\u1ef3 m\u1ea1nh m\u1ebd. V\u00ed d\u1ee5, b\u1ea1n c\u00f3 m\u1ed9t c\u1ed9t t\u1ef7 l\u1ec7 ho\u00e0n th\u00e0nh ch\u1ec9 ti\u00eau (\u0111\u00e3 \u0111\u01b0\u1ee3c t\u00ednh b\u1eb1ng c\u00f4ng th\u1ee9c `=Ph\u1ea7n\/T\u1ed5ng`). B\u00e2y gi\u1edd, b\u1ea1n mu\u1ed1n c\u00f3 m\u1ed9t c\u1ed9t tr\u1ea1ng th\u00e1i t\u1ef1 \u0111\u1ed9ng ghi “\u0110\u1ea1t” n\u1ebfu t\u1ef7 l\u1ec7 ho\u00e0n th\u00e0nh t\u1eeb 80% tr\u1edf l\u00ean, v\u00e0 “C\u1ea7n c\u1ed1 g\u1eafng” n\u1ebfu d\u01b0\u1edbi 80%. Gi\u1ea3 s\u1eed t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m n\u1eb1m \u1edf \u00f4 C2, c\u00f4ng th\u1ee9c \u1edf \u00f4 D2 s\u1ebd l\u00e0: `=IF(C2>=80%, “\u0110\u1ea1t”, “C\u1ea7n c\u1ed1 g\u1eafng”)`. L\u01b0u \u00fd r\u1eb1ng b\u1ea1n ph\u1ea3i nh\u1eadp `80%` (ho\u1eb7c `0.8`) trong c\u00f4ng th\u1ee9c \u0111\u1ec3 so s\u00e1nh ch\u00ednh x\u00e1c.\n\n\n\nM\u1ed9t c\u00f4ng c\u1ee5 tr\u1ef1c quan h\u00f3a m\u1ea1nh m\u1ebd kh\u00e1c l\u00e0 “Conditional Formatting” (\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n). T\u00ednh n\u0103ng n\u00e0y cho ph\u00e9p b\u1ea1n t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng c\u1ee7a m\u1ed9t \u00f4 (nh\u01b0 m\u00e0u n\u1ec1n, m\u00e0u ch\u1eef) d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb c\u1ee7a n\u00f3. \u0110\u00e2y l\u00e0 c\u00e1ch tuy\u1ec7t v\u1eddi \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt d\u1eef li\u1ec7u quan tr\u1ecdng m\u00e0 kh\u00f4ng c\u1ea7n d\u00f9ng th\u00eam c\u1ed9t ph\u1ee5 v\u1edbi h\u00e0m `IF`. V\u00ed d\u1ee5, trong b\u1ea3ng theo d\u00f5i t\u1ef7 l\u1ec7 ho\u00e0n th\u00e0nh doanh s\u1ed1 c\u1ee7a anh Tu\u1ea5n, anh c\u00f3 th\u1ec3 b\u00f4i \u0111en c\u1ed9t t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m, sau \u0111\u00f3 v\u00e0o Conditional Formatting v\u00e0 t\u1ea1o m\u1ed9t quy t\u1eafc: “N\u1ebfu gi\u00e1 tr\u1ecb \u00f4 nh\u1ecf h\u01a1n 75%, t\u00f4 n\u1ec1n m\u00e0u \u0111\u1ecf nh\u1ea1t v\u00e0 ch\u1eef m\u00e0u \u0111\u1ecf \u0111\u1eadm”. Anh c\u0169ng c\u00f3 th\u1ec3 t\u1ea1o m\u1ed9t quy t\u1eafc kh\u00e1c: “N\u1ebfu gi\u00e1 tr\u1ecb \u00f4 l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 100%, t\u00f4 n\u1ec1n m\u00e0u xanh l\u00e1 c\u00e2y nh\u1ea1t v\u00e0 ch\u1eef m\u00e0u xanh \u0111\u1eadm”. Ngay l\u1eadp t\u1ee9c, b\u1ea3ng d\u1eef li\u1ec7u c\u1ee7a anh tr\u1edf n\u00ean s\u1ed1ng \u0111\u1ed9ng v\u00e0 d\u1ec5 \u0111\u1ecdc h\u01a1n r\u1ea5t nhi\u1ec1u. Ch\u1ec9 c\u1ea7n li\u1ebfc qua, anh c\u00f3 th\u1ec3 th\u1ea5y ngay ai \u0111ang g\u1eb7p kh\u00f3 kh\u0103n v\u00e0 ai \u0111\u00e3 v\u01b0\u1ee3t ch\u1ec9 ti\u00eau.\n\n\n\n\u0110\u1ed1i v\u1edbi c\u00e1c b\u1ed9 d\u1eef li\u1ec7u l\u1edbn h\u01a1n, PivotTable (B\u1ea3ng t\u1ed5ng h\u1ee3p) l\u00e0 c\u00f4ng c\u1ee5 t\u1ed1i \u01b0u \u0111\u1ec3 t\u00f3m t\u1eaft v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u ph\u1ea7n tr\u0103m. Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u doanh s\u1ed1 chi ti\u1ebft v\u1edbi h\u00e0ng ngh\u00ecn d\u00f2ng, bao g\u1ed3m c\u00e1c c\u1ed9t: Nh\u00e2n vi\u00ean, Khu v\u1ef1c, Ng\u00e0nh h\u00e0ng, v\u00e0 Doanh s\u1ed1. B\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o m\u1ed9t PivotTable \u0111\u1ec3 xem t\u1ed5ng doanh s\u1ed1 theo t\u1eebng khu v\u1ef1c. Sau \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam m\u1ed9t b\u01b0\u1edbc n\u1eefa l\u00e0 y\u00eau c\u1ea7u PivotTable hi\u1ec3n th\u1ecb doanh s\u1ed1 c\u1ee7a m\u1ed7i khu v\u1ef1c d\u01b0\u1edbi d\u1ea1ng “% of Grand Total” (% tr\u00ean T\u1ed5ng). Thao t\u00e1c n\u00e0y s\u1ebd t\u1ef1 \u0111\u1ed9ng t\u00ednh to\u00e1n t\u1ef7 tr\u1ecdng doanh thu c\u1ee7a t\u1eebng khu v\u1ef1c so v\u1edbi t\u1ed5ng doanh thu c\u1ee7a c\u00f4ng ty. V\u00ed d\u1ee5, b\u1ea1n s\u1ebd th\u1ea5y ngay Khu v\u1ef1c A chi\u1ebfm 35%, Khu v\u1ef1c B chi\u1ebfm 45%, v\u00e0 Khu v\u1ef1c C chi\u1ebfm 20% t\u1ed5ng doanh thu. \u0110\u00e2y l\u00e0 m\u1ed9t c\u00e1ch ph\u00e2n t\u00edch c\u1ef1c k\u1ef3 nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3 m\u00e0 kh\u00f4ng c\u1ea7n vi\u1ebft b\u1ea5t k\u1ef3 c\u00f4ng th\u1ee9c th\u1ee7 c\u00f4ng n\u00e0o, gi\u00fap b\u1ea1n c\u00f3 c\u00e1i nh\u00ecn t\u1ed5ng th\u1ec3 v\u1ec1 c\u01a1 c\u1ea5u kinh doanh c\u1ee7a m\u00ecnh.\n\n\n\n

C\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p (FAQ)<\/h2>\n\n\n\n

L\u00e0m sao \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh m\u1ed9t \u00f4 (v\u00ed d\u1ee5 \u00f4 t\u1ed5ng) khi k\u00e9o c\u00f4ng th\u1ee9c ph\u1ea7n tr\u0103m xu\u1ed1ng?<\/h3>\n\n\n\n\u0110\u1ec3 c\u1ed1 \u0111\u1ecbnh m\u1ed9t \u00f4 tham chi\u1ebfu trong c\u00f4ng th\u1ee9c khi b\u1ea1n k\u00e9o ho\u1eb7c sao ch\u00e9p n\u00f3, h\u00e3y s\u1eed d\u1ee5ng k\u00fd hi\u1ec7u \u0111\u00f4 la ($) \u0111\u1ec3 t\u1ea1o m\u1ed9t tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i. V\u00ed d\u1ee5, n\u1ebfu c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n l\u00e0 `=B2\/F1` v\u00e0 b\u1ea1n mu\u1ed1n \u00f4 `F1` lu\u00f4n \u0111\u01b0\u1ee3c gi\u1eef nguy\u00ean, h\u00e3y s\u1eeda c\u00f4ng th\u1ee9c th\u00e0nh `=B2\/$F$1`. K\u00fd hi\u1ec7u `$` \u0111\u1ee9ng tr\u01b0\u1edbc ch\u1eef c\u00e1i c\u1ee7a c\u1ed9t v\u00e0 s\u1ed1 c\u1ee7a h\u00e0ng s\u1ebd “kh\u00f3a” \u00f4 \u0111\u00f3 l\u1ea1i, \u0111\u1ea3m b\u1ea3o m\u1ecdi t\u00ednh to\u00e1n \u0111\u1ec1u tham chi\u1ebfu \u0111\u00fang \u0111\u1ebfn n\u00f3.\n\n\n\n

T\u1ea1i sao c\u00f4ng th\u1ee9c t\u00ednh ph\u1ea7n tr\u0103m c\u1ee7a t\u00f4i l\u1ea1i b\u00e1o l\u1ed7i #DIV\/0!?<\/h3>\n\n\n\nL\u1ed7i `#DIV\/0!` xu\u1ea5t hi\u1ec7n khi b\u1ea1n c\u1ed1 g\u1eafng th\u1ef1c hi\u1ec7n m\u1ed9t ph\u00e9p chia cho s\u1ed1 0. Trong c\u00f4ng th\u1ee9c t\u00ednh ph\u1ea7n tr\u0103m nh\u01b0 `=Ph\u1ea7n\/T\u1ed5ng`, l\u1ed7i n\u00e0y x\u1ea3y ra khi \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb “T\u1ed5ng” b\u1eb1ng 0 ho\u1eb7c l\u00e0 m\u1ed9t \u00f4 tr\u1ed1ng. H\u00e3y ki\u1ec3m tra l\u1ea1i d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o \u00f4 m\u1eabu s\u1ed1 (\u00f4 b\u1ea1n d\u00f9ng \u0111\u1ec3 chia) ch\u1ee9a m\u1ed9t gi\u00e1 tr\u1ecb s\u1ed1 kh\u00e1c kh\u00f4ng. \u0110\u00e2y l\u00e0 m\u1ed9t l\u1ed7i ph\u1ed5 bi\u1ebfn khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c t\u1eadp d\u1eef li\u1ec7u ch\u01b0a ho\u00e0n ch\u1ec9nh.\n\n\n\n

Excel\/Sheets hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 l\u00e0 0.75 thay v\u00ec 75%, t\u00f4i ph\u1ea3i l\u00e0m sao?<\/h3>\n\n\n\n\u0110\u00e2y l\u00e0 v\u1ea5n \u0111\u1ec1 v\u1ec1 \u0111\u1ecbnh d\u1ea1ng \u00f4, kh\u00f4ng ph\u1ea3i l\u1ed7i c\u00f4ng th\u1ee9c. B\u1ea3ng t\u00ednh \u0111ang hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb s\u1ed1 th\u1eadp ph\u00e2n g\u1ed1c. \u0110\u1ec3 chuy\u1ec3n n\u00f3 th\u00e0nh d\u1ea1ng ph\u1ea7n tr\u0103m, h\u00e3y ch\u1ecdn \u00f4 ho\u1eb7c c\u00e1c \u00f4 ch\u1ee9a k\u1ebft qu\u1ea3, sau \u0111\u00f3 tr\u00ean thanh c\u00f4ng c\u1ee5 (tab Home trong Excel), nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u ph\u1ea7n tr\u0103m (%). Thao t\u00e1c n\u00e0y s\u1ebd nh\u00e2n gi\u00e1 tr\u1ecb v\u1edbi 100 v\u00e0 th\u00eam k\u00fd hi\u1ec7u “%” v\u00e0o sau \u0111\u1ec3 hi\u1ec3n th\u1ecb, trong khi v\u1eabn gi\u1eef gi\u00e1 tr\u1ecb g\u1ed1c cho c\u00e1c t\u00ednh to\u00e1n sau n\u00e0y.\n\n\n\n

C\u00f3 c\u00f4ng c\u1ee5 n\u00e0o t\u00ednh ph\u1ea7n tr\u0103m nhanh m\u00e0 kh\u00f4ng c\u1ea7n m\u1edf Excel\/Sheets kh\u00f4ng?<\/h3>\n\n\n\nCh\u1eafc ch\u1eafn r\u1ed3i. \u0110\u1ed1i v\u1edbi nh\u1eefng ph\u00e9p t\u00ednh nhanh, \u0111\u01a1n l\u1ebb, b\u1ea1n kh\u00f4ng c\u1ea7n ph\u1ea3i m\u1edf m\u1ed9t ch\u01b0\u01a1ng tr\u00ecnh b\u1ea3ng t\u00ednh ph\u1ee9c t\u1ea1p. C\u00f3 r\u1ea5t nhi\u1ec1u trang web cung c\u1ea5p c\u00f4ng c\u1ee5 t\u00ednh to\u00e1n ti\u1ec7n l\u1ee3i. B\u1ea1n c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm v\u00e0 s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5 t\u00ednh ph\u1ea7n tr\u0103m online t\u1ea1i 1phantram.com<\/a> \u0111\u1ec3 gi\u1ea3i quy\u1ebft nhanh c\u00e1c b\u00e0i to\u00e1n nh\u01b0 t\u00ednh gi\u1ea3m gi\u00e1, t\u00ednh l\u00e3i su\u1ea5t, ho\u1eb7c t\u00ecm t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng v\u00e0 nhanh ch\u00f3ng ngay tr\u00ean tr\u00ecnh duy\u1ec7t c\u1ee7a m\u00ecnh.\n\n\n\n\nKh\u00e1m Ph\u00e1 C\u00f4ng C\u1ee5 T\u00ednh Ph\u1ea7n Tr\u0103m \u2192<\/a>\n\n","protected":false},"excerpt":{"rendered":"

TL;DR: \u0110\u1ec3 t\u00ednh ph\u1ea7n tr\u0103m trong Excel v\u00e0 Google Sheets, h\u00e3y s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n: `=Ph\u1ea7n\/T\u1ed5ng` \u0111\u1ec3 t\u00ednh t\u1ef7 l\u1ec7, `=(Gi\u00e1 tr\u1ecb…<\/p>\n","protected":false},"author":1,"featured_media":1427,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_title":"C\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m trong Excel v\u00e0 Google Sheets: c\u00f4ng th\u1ee9c d\u1ec5 d\u00f9ng","rank_math_description":"H\u01b0\u1edbng d\u1eabn C\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m trong Excel v\u00e0 Google Sheets: c\u00f4ng th\u1ee9c d\u1ec5 d\u00f9ng: c\u00f4ng th\u1ee9c, v\u00ed d\u1ee5, l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 c\u00f4ng c\u1ee5 t\u00ednh nhanh tr\u00ean 1phantram.com.","rank_math_focus_keyword":"trong excel v\u00e0 google sheets c\u00f4ng th\u1ee9c d\u1ec5 d\u00f9ng","footnotes":""},"categories":[39],"tags":[],"class_list":["post-1312","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cum-cach-tinh-phan-tram-trong-excel-google-sheets"],"_links":{"self":[{"href":"https:\/\/1phantram.com\/blog\/wp-json\/wp\/v2\/posts\/1312","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/1phantram.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/1phantram.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/1phantram.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/1phantram.com\/blog\/wp-json\/wp\/v2\/comments?post=1312"}],"version-history":[{"count":5,"href":"https:\/\/1phantram.com\/blog\/wp-json\/wp\/v2\/posts\/1312\/revisions"}],"predecessor-version":[{"id":1431,"href":"https:\/\/1phantram.com\/blog\/wp-json\/wp\/v2\/posts\/1312\/revisions\/1431"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/1phantram.com\/blog\/wp-json\/wp\/v2\/media\/1427"}],"wp:attachment":[{"href":"https:\/\/1phantram.com\/blog\/wp-json\/wp\/v2\/media?parent=1312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/1phantram.com\/blog\/wp-json\/wp\/v2\/categories?post=1312"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/1phantram.com\/blog\/wp-json\/wp\/v2\/tags?post=1312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}