{"id":1290,"date":"2017-04-15T16:59:23","date_gmt":"2017-04-15T09:59:23","guid":{"rendered":"https:\/\/engisv.info\/?p=1290"},"modified":"2017-04-15T16:59:23","modified_gmt":"2017-04-15T09:59:23","slug":"microsoft-excel-tong-quan-ve-cach-giai-cac-bai-toan","status":"publish","type":"post","link":"https:\/\/www.engisv.info\/?p=1290","title":{"rendered":"Microsoft Excel &#8211; T\u1ed5ng quan v\u1ec1 c\u00e1ch gi\u1ea3i c\u00e1c b\u00e0i to\u00e1n"},"content":{"rendered":"<p>Hai b\u00e0i tr\u01b0\u1edbc ch\u00fang ta \u0111\u00e3 c\u00f3 <a href=\"https:\/\/www.engisv.info\/?p=1106\" target=\"_blank\">kh\u00e1i ni\u1ec7m c\u01a1 b\u1ea3n v\u1ec1 Excel<\/a>, <a href=\"https:\/\/www.engisv.info\/?p=1191\" target=\"_blank\">c\u00e1c ki\u1ec3u d\u1eef li\u1ec7u v\u00e0 \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng l\u00e0m vi\u1ec7c trong Excel<\/a>. Trong b\u00e0i n\u00e0y, ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u c\u00e1c b\u01b0\u1edbc c\u01a1 b\u1ea3n \u0111\u1ec3 gi\u1ea3i quy\u1ebft c\u00e1c b\u00e0i to\u00e1n trong Excel. \u1ede b\u00e0i vi\u1ebft n\u00e0y, t\u00f4i s\u1ebd kh\u00f4ng n\u00f3i c\u1ee5 th\u1ec3 v\u1ec1 h\u00e0m trong Excel, trong b\u00e0i n\u00e0y ch\u1ec9 h\u01b0\u1edbng d\u1ea9n kh\u00e1i qu\u00e1t l\u00e0m sao \u0111\u00f3 cho b\u1ea1n c\u00f3 c\u00e1ch t\u01b0 duy nhanh c\u00e1c b\u00e0i to\u00e1n m\u00e0 b\u1ea1n mu\u1ed1n gi\u1ea3i quy\u1ebft. Gi\u1ea3i quy\u1ebft m\u1ed9t y\u00eau c\u1ea7u trong Excel l\u00e0 s\u1ef1 k\u1ebft h\u1ee3p c\u00e1c h\u00e0m, ph\u00e9p to\u00e1n v\u00e0 d\u1eef li\u1ec7u \u0111\u00e3 c\u00f3 \u0111\u1ec3.<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 gi\u1ea3i quy\u1ebft m\u1ed9t b\u00e0i to\u00e1n tr\u00ean Excel, \u0111\u1ea7u ti\u00ean b\u1ea1n ph\u1ea3i bi\u1ebft \u0111\u00f3 l\u00e0 ph\u00e2n t\u00edch:<\/p>\n<ul>\n<li>K\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng b\u1ea1n mu\u1ed1n \u0111\u1ea1t \u0111\u01b0\u1ee3c l\u00e0 g\u00ec?<\/li>\n<li>C\u00e1c y\u00eau c\u1ea7u \u0111\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u00e0 g\u00ec?<\/li>\n<li>C\u00e1c d\u1eef li\u1ec7u b\u1ea1n \u0111\u00e3 c\u00f3, d\u1eef li\u1ec7u c\u1ea7n tham chi\u1ebfu, so s\u00e1nh , t\u00ednh to\u00e1n.<\/li>\n<\/ul>\n<p>T\u1eeb c\u00e1c ph\u00e2n t\u00edch tr\u00ean b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm c\u00e1c h\u00e0m ph\u00f9 h\u1ee3p, x\u1eed l\u00fd c\u00e1c ph\u00e9p to\u00e1n \u0111\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3. V\u1ec1 h\u00e0m, c\u00f3 th\u1ec3 b\u1ea1n \u0111\u00e3 bi\u1ebft ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 tra h\u00e0m s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 c\u00f3 s\u1eb5n trong Excel:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1812 zoooom\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/04\/giai_excel-1.png\" alt=\"\" width=\"343\" height=\"378\" \/><\/p>\n<p>Ch\u00fang ta s\u1ebd \u0111i v\u00e0o v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 \u0111\u1ec3 d\u1ec5 h\u00ecnh dung h\u01a1n, ta c\u00f3 d\u1eef li\u1ec7u nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1813 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/04\/giai_excel-2.png\" alt=\"\" width=\"681\" height=\"345\" \/><\/p>\n<p>B\u1ea1n s\u1ebd \u0111i gi\u1ea3i quy\u1ebft c\u00e1c y\u00eau c\u1ea7u \u0111\u01b0a ra k\u1ebft qu\u1ea3 cho nh\u1eefng \u00f4 trong v\u00f9ng t\u00f4 m\u00e0u nh\u01b0 sau:<\/p>\n<ol>\n<li>T\u00ean h\u00e0ng: d\u1ef1a v\u00e0o 4 k\u00fd t\u1ef1 \u0111\u1ea7u c\u1ee7a M\u00e3 h\u00e0ng, tra trong B\u1ea2NG 1.<\/li>\n<li>M\u00e3 QG: d\u1ef1a v\u00e0o 4 k\u00fd t\u1ef1 \u0111\u1ea7u c\u1ee7a M\u00e3 h\u00e0ng, tra trong B\u1ea2NG 1.<\/li>\n<li>Xu\u1ea5t x\u1ee9: d\u1ef1a v\u00e0o M\u00e3 QG\u00a0v\u1eeba t\u00ecm ra tra v\u1edbi B\u1ea2NG 2<\/li>\n<li>Tr\u1ecb gi\u00e1: S\u1ed1 l\u01b0\u1ee3ng * \u0110\u01a1n gi\u00e1. Bi\u1ebft r\u1eb1ng \u0111\u01a1n gi\u00e1 d\u1ef1a v\u00e0o 4 k\u00fd t\u1ef1 \u0111\u1ea7u c\u1ee7a M\u00e3 h\u00e0ng, tra trong B\u1ea2NG 1, k\u1ebft h\u1ee3p v\u1edbi Lo\u1ea1i h\u00e0ng \u0111\u1ec3 l\u1ea5y gi\u00e1 tr\u1ecb h\u1ee3p l\u00fd.<\/li>\n<li>Ph\u00ed v\u1eadn chuy\u1ec3n: S\u1ed1 l\u01b0\u1ee3ng * Gi\u00e1 VC. Bi\u1ebft r\u1eb1ng, gi\u00e1 v\u1eadn chuy\u1ec3n d\u1ef1a v\u00e0o M\u00e3 QG, tra trong B\u1ea2NG 2.<\/li>\n<li>Th\u00e0nh ti\u1ec1n: Tr\u1ecb gi\u00e1 + Ph\u00ed v\u1eadn chuy\u1ec3n. N\u1ebfu b\u00e1n ra trong th\u00e1ng 5 th\u00ec gi\u1ea3m 5% Th\u00e0nh ti\u1ec1n.<\/li>\n<\/ol>\n<p>Ch\u00fang ta l\u1ea7n l\u01b0\u1ee3t \u0111i ph\u00e2n t\u00edch v\u00e0 gi\u1ea3i quy\u1ebft t\u1eebng y\u00eau c\u1ea7u:<\/p>\n<p><strong>Y\u00eau c\u1ea7u 1<\/strong>:\u00a0T\u00ean h\u00e0ng: <strong>d\u1ef1a v\u00e0o 4 k\u00fd t\u1ef1 \u0111\u1ea7u<\/strong> c\u1ee7a <strong>M\u00e3 h\u00e0ng<\/strong>, tra trong <strong>B\u1ea2NG 1<\/strong>. V\u1eady:<\/p>\n<p>Tra trong B\u1ea2NG 1 \u0111\u1ec3 l\u1ea5y ra <strong>T\u00ean h\u00e0ng<\/strong>, nh\u01b0 v\u1eady l\u00e0 s\u1ebd c\u00f3 h\u00e0m tham chi\u1ebfu d\u1eef li\u1ec7u, \u1edf \u0111\u00e2y b\u1ea3ng ph\u1ee5 tr\u00ecnh b\u00e0y theo chi\u1ec1u d\u1ecdc, v\u1eady ch\u00fang ta s\u1ebd d\u00f9ng h\u00e0m VLOOKUP, VLOOKUP(tham s\u1ed1 tham chi\u1ebfu, v\u00f9ng d\u1eef li\u1ec7u, c\u1ed9t tr\u1ea3 v\u1ec1,FALSE).<\/p>\n<ul>\n<li>V\u00f9ng d\u1eef li\u1ec7u s\u1ebd l\u00e0\u00a0<strong>$A$14:$E$16<\/strong>, \u1edf \u0111\u00e2y ta d\u00f9ng d\u1ea5u $\u00a0do v\u00f9ng d\u1eef li\u1ec7u n\u00e0y l\u00e0 c\u1ed1 \u0111\u1ecbnh.<\/li>\n<li>Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 ch\u00ednh l\u00e0 c\u1ed9t tr\u1ea3 v\u1ec1 l\u00e0 c\u1ed9t 2 c\u1ee7a B\u1ea2NG 1<\/li>\n<li>V\u1eady \u00a0ta s\u1ebd c\u00f3 c\u00f4ng th\u1ee9c VLOOKUP(<strong><em>gi\u00e1 tr\u1ecb tham chi\u1ebfu<\/em><\/strong>,$A$14:$E$16,2,FALSE)<\/li>\n<\/ul>\n<p>\u1ede \u0111\u00e2y, ta th\u1ea5y l\u00e0 ch\u01b0a c\u00f3 <strong><em>gi\u00e1 tr\u1ecb tham chi\u1ebfu<\/em><\/strong>. Theo y\u00eau c\u1ea7u gi\u00e1 tr\u1ecb tham chi\u1ebfu ch\u00ednh l\u00e0 <strong>d\u1ef1a v\u00e0o 4 k\u00fd t\u1ef1 \u0111\u1ea7u<\/strong> \u00a0trong m\u00e3 h\u00e0ng c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u ch\u00ednh, m\u00e0 m\u00e3 n\u00e0y l\u1ea1i ch\u1ee9a 5 k\u00fd t\u1ef1 nh\u01b0ng ta ch\u1ec9 c\u1ea7n c\u00f3 4 k\u00fd t\u1ef1 \u0111\u1ea7u, v\u1eady ta s\u1ebd l\u1ea5y t\u1eeb tr\u00e1i qua 4 k\u00fd t\u1ef1, nh\u01b0 v\u1eady ta s\u1ebd d\u00f9ng h\u00e0m Left, <strong>LEFT (A3,4)<\/strong>, \u0111\u1ec3 tr\u00edch c\u00e1c k\u00fd t\u1ef1 c\u1ea7n so s\u00e1nh.<\/p>\n<p>Sau khi c\u00f3 gi\u00e1 tr\u1ecb tham chi\u1ebfu, ta s\u1ebd c\u00f3 c\u00f4ng th\u1ee9c:<\/p>\n<p>=VLOOKUP(LEFT(A3,4),$A$14:$E$16,2,FALSE)<\/p>\n<p><strong>Y\u00eau c\u1ea7u 2<\/strong>: M\u00e3 QG: <strong>d\u1ef1a v\u00e0o 4 k\u00fd t\u1ef1 \u0111\u1ea7u<\/strong> c\u1ee7a <strong>M\u00e3 h\u00e0ng<\/strong>, tra trong <strong>B\u1ea2NG 1<\/strong>. \u1ede y\u00eau c\u1ea7u n\u00e0y t\u01b0\u01a1ng t\u1ef1 nh\u01b0 Y\u00eau c\u1ea7u 1, nh\u01b0ng gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 l\u00e0 c\u1ed9t th\u1ee9 3 c\u1ee7a B\u1ea2NG 1.<\/p>\n<p>K\u1ebft qu\u1ea3 ta c\u00f3:<\/p>\n<p>=VLOOKUP(LEFT(A3,4),$A$14:$E$16,3,FALSE)<\/p>\n<p><strong>Y\u00eau c\u1ea7u 3<\/strong>: Xu\u1ea5t x\u1ee9: d\u1ef1a v\u00e0o <strong>M\u00e3 QG<\/strong>\u00a0v\u1eeba t\u00ecm tra v\u1edbi <strong>B\u1ea2NG 2<\/strong>. T\u01b0\u01a1ng t\u1ef1 nh\u01b0 Y\u00eau c\u1ea7u 1 v\u00e0 Y\u00eau c\u1ea7u 2, nh\u01b0ng \u1edf \u0111\u00e2y, ch\u00fang ta tra c\u1ee9u d\u1eef li\u1ec7u trong B\u1ea2NG 2, b\u1ea3ng n\u00e0y \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng ngang n\u00ean ch\u00fang ta d\u00f9ng h\u00e0m HLOOKUP.<\/p>\n<p>K\u1ebft qu\u1ea3 ta c\u00f3:<\/p>\n<p>=HLOOKUP(C3,$H$12:$J$14,2,FALSE)<\/p>\n<p><strong>Y\u00eau c\u1ea7u 4<\/strong>: Tr\u1ecb gi\u00e1: <strong>S\u1ed1 l\u01b0\u1ee3ng * \u0110\u01a1n gi\u00e1<\/strong>. Bi\u1ebft r\u1eb1ng <strong>\u0111\u01a1n gi\u00e1 d\u1ef1a v\u00e0o 4 k\u00fd t\u1ef1 \u0111\u1ea7u<\/strong> c\u1ee7a <strong>M\u00e3 h\u00e0ng<\/strong>, tra trong <strong>B\u1ea2NG 1<\/strong>, k\u1ebft h\u1ee3p v\u1edbi <strong>Lo\u1ea1i h\u00e0ng<\/strong> \u0111\u1ec3 l\u1ea5y gi\u00e1 tr\u1ecb h\u1ee3p l\u00fd. \u1ede \u0111\u00e2y:<\/p>\n<p>S\u1ed1 l\u01b0\u1ee3ng l\u00e0 d\u1eef li\u1ec7u \u0111\u00e3 c\u00f3 s\u1eb5n.<\/p>\n<p>\u0110\u01a1n gi\u00e1\u00a0s\u1ebd d\u1ef1a v\u00e0o 2 gi\u00e1 tr\u1ecb tham chi\u1ebfu l\u00e0 4 k\u00fd t\u1ef1 \u0111\u1ea7u c\u1ee7a M\u00e3 h\u00e0ng, <strong>LEFT(A3,4)<\/strong>, cho bi\u1ebft \u0111\u00f3 l\u00e0 m\u1eb7t h\u00e0ng n\u00e0o. K\u00fd t\u1ef1 cu\u1ed1i ,\u00a0<strong>RIGHT(A3,1)<\/strong>, cho bi\u1ebft ch\u1ea5t l\u01b0\u1ee3ng c\u1ee7a m\u1eb7t h\u00e0ng \u0111\u00f3. M\u1ed9t m\u1eb7t h\u00e0ng c\u00f3 hai gi\u00e1 tri:<\/p>\n<ul>\n<li>Cao c\u1ea5p t\u01b0\u01a1ng \u1ee9ng v\u1edbi <strong>C<\/strong> trong <strong>M\u00e3 h\u00e0ng<\/strong>,<\/li>\n<li>Th\u01b0\u1eddng\u00a0t\u01b0\u01a1ng \u1ee9ng v\u1edbi <strong>T<\/strong>\u00a0trong <strong>M\u00e3 h\u00e0ng<\/strong><\/li>\n<\/ul>\n<p>D\u1ef1a v\u00e0o b\u1ea3ng s\u1ed1 li\u1ec7u v\u00e0 s\u1ef1 ph\u00e2n t\u00edch ta th\u1ea5y <strong>\u0110\u01a1n gi\u00e1<\/strong> c\u1ee7a <strong>M\u1eb7t h\u00e0ng<\/strong> s\u1ebd thay \u0111\u1ed5i d\u1ef1a v\u00e0o C v\u00e0 T.<\/p>\n<ul>\n<li>N\u1ebfu k\u00fd t\u1ef1 cu\u1ed1i l\u00e0 <strong>C<\/strong> th\u00ec l\u1ea5y s\u1ed1 l\u01b0\u1ee3ng nh\u00e2n cho \u0110\u01a1n gi\u00e1<strong> Cao C\u1ea5p<\/strong><\/li>\n<li>N\u1ebfu k\u00fd t\u1ef1 cu\u1ed1i l\u00e0 <strong>T<\/strong> th\u00ec l\u1ea5y s\u1ed1 l\u01b0\u1ee3ng nh\u00e2n cho \u0110\u01a1n gi\u00e1 <strong>Th\u01b0\u1eddng<\/strong>.<\/li>\n<li>\u0110\u1ec3 l\u1ea5y \u0111\u01b0\u1ee3c \u0110\u01a1n Gi\u00e1 <strong>Cao c\u1ea5p<\/strong> trong B\u1ea2NG 1 <strong>d\u1ef1a v\u00e0o 4 k\u00fd t\u1ef1 \u0111\u1ea7u<\/strong> c\u1ee7a<strong> M\u00e3 h\u00e0ng<\/strong>:\u00a0VLOOKUP(LEFT(A3,4),$A$14:$E$16,4,FALSE)<\/li>\n<li>\u0110\u1ec3 l\u1ea5y \u0111\u01b0\u1ee3c \u0110\u01a1n Gi\u00e1 <strong>Th\u01b0\u1eddng<\/strong>\u00a0trong B\u1ea2NG 1 <strong>d\u1ef1a v\u00e0o 4 k\u00fd t\u1ef1 \u0111\u1ea7u<\/strong> c\u1ee7a <strong>M\u00e3 h\u00e0ng<\/strong>: VLOOKUP(LEFT(A3,4),$A$14:$E$16,5,FALSE)<\/li>\n<\/ul>\n<p>\u1ede \u0111\u00e2y ch\u00fang ta th\u1ea5y, ch\u1ec9 c\u00f3 2 \u0111i\u1ec1u ki\u1ec7n l\u00e0 C v\u00e0 T, v\u1eady ta s\u1ebd \u0111\u1eb7t \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 t\u00ednh t\u00ednh:<\/p>\n<ul>\n<li>N\u1ebfu k\u00fd t\u1ef1 cu\u1ed1i m\u00e3 h\u00e0ng l\u00e0 C,\u00a0<strong>RIGHT(A3,1)=&#8221;C&#8221;<\/strong>,\u00a0th\u00ec l\u1ea5y E3 nh\u00e2n v\u1edbi \u00a0VLOOKUP(LEFT(A3,4),$A$14:$E$16,4,FALSE)<\/li>\n<li>Ng\u01b0\u1ee3c l\u1ea1i th\u00ec l\u1ea5y E3 nh\u00e2n v\u1edbi\u00a0VLOOKUP(LEFT(A3,4),$A$14:$E$16,5,FALSE)<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 ta c\u00f3:<\/p>\n<p>=IF(RIGHT(A3,1)=&#8221;C&#8221;,E3*VLOOKUP(LEFT(A3,4),$A$14:$E$16,4,FALSE),E3*VLOOKUP(LEFT(A3,4),$A$14:$E$16,5,FALSE))<\/p>\n<p><strong>Y\u00eau c\u1ea7u 5<\/strong>:\u00a0Ph\u00ed v\u1eadn chuy\u1ec3n: S\u1ed1 l\u01b0\u1ee3ng * Gi\u00e1 VC. Bi\u1ebft r\u1eb1ng, gi\u00e1 v\u1eadn chuy\u1ec3n d\u1ef1a v\u00e0o M\u00e3 QG, tra trong B\u1ea2NG 2.<\/p>\n<p>S\u1ed1 l\u01b0\u1ee3ng \u0111\u00e3 c\u00f3 trong b\u1ea3ng d\u1eef li\u1ec7u.<\/p>\n<p>V\u1eady ta c\u1ea7n tham chi\u1ebfu M\u00e3 QG trong b\u1ea3ng d\u1eef li\u1ec7u ch\u00ednh v\u00e0 B\u1ea2NG 2 \u0111\u1ec3 l\u1ea5y ra gi\u00e1 tr\u1ecb Gi\u00e1 VC. Do B\u1ea2NG 2 l\u00e0 b\u1ea3ng d\u1eef li\u1ec7u ngang n\u00ean ch\u00fang ta s\u1ebd d\u00f9ng h\u00e0m HLOOKUP:\u00a0HLOOKUP(C3,$H$12:$J$14,3,FALSE)<\/p>\n<p>=E3*HLOOKUP(C3,$H$12:$J$14,3,FALSE)<\/p>\n<p><strong>Y\u00eau c\u1ea7u 6<\/strong>: Th\u00e0nh ti\u1ec1n: Tr\u1ecb gi\u00e1 + Ph\u00ed v\u1eadn chuy\u1ec3n. N\u1ebfu b\u00e1n ra trong th\u00e1ng 5 th\u00ec gi\u1ea3m 5% Th\u00e0nh ti\u1ec1n.<\/p>\n<ul>\n<li>Th\u00e0nh ti\u1ec1n = G3+H3<\/li>\n<li>5% c\u1ee7a Th\u00e0nh ti\u1ec1n =(G3+H3)*5%<\/li>\n<li>Th\u00e1ng 5= MONTH(F3)=5<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady, N\u1ebfu l\u00e0 <strong>Th\u00e1ng 5<\/strong> th\u00ec <strong>Th\u00e0nh ti\u1ec1n<\/strong> l\u00e0<strong>\u00a0Th\u00e0nh ti\u1ec1n<\/strong>\u00a0tr\u1eeb <strong>5% Th\u00e0nh ti\u1ec1n<\/strong> v\u00e0 ng\u01b0\u1ee3c l\u1ea1i <strong>Th\u00e0nh ti\u1ec1n <\/strong>b\u1eb1ng\u00a0<strong>Th\u00e0nh ti\u1ec1n<\/strong>.<\/p>\n<p>K\u1ebft qu\u1ea3 ta c\u00f3:<\/p>\n<p>=IF(MONTH(F3)=5,(G3+H3)-((G3+H3)*5%),G3+H3)<\/p>\n<p>Sau khi ho\u00e0n th\u00e0nh, ta \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"zoooom aligncenter wp-image-1828 \" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/04\/giai_excel-3.png\" alt=\"\" width=\"819\" height=\"324\" \/><\/p>\n<p>Trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd c\u00e1c y\u00eau c\u1ea7u, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c v\u00f9ng tr\u1ed1ng b\u00ean ngo\u00e0i \u0111\u1ec3 ki\u1ec3m tra c\u00e1c c\u00f4ng th\u1ee9c nh\u1ecf, tr\u01b0\u1edbc khi gh\u00e9p n\u1ed1i n\u00f3 th\u00e0nh m\u1ed9t c\u00f4ng th\u1ee9c ho\u00e0n ch\u1ec9nh. Vi\u1ec7c x\u1eed l\u00fd t\u1eebng y\u00eau c\u1ea7u nh\u1ecf c\u00f3 th\u1ec3 s\u1ebd gi\u00fap b\u1ea1n x\u1eed l\u00fd y\u00eau c\u1ea7u l\u1edbn ch\u00ednh x\u00e1c v\u00e0 hi\u1ec7u qu\u1ea3 h\u01a1n.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hai b\u00e0i tr\u01b0\u1edbc ch\u00fang ta \u0111\u00e3 c\u00f3 kh\u00e1i ni\u1ec7m c\u01a1 b\u1ea3n v\u1ec1 Excel, c\u00e1c ki\u1ec3u d\u1eef li\u1ec7u v\u00e0 \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng l\u00e0m vi\u1ec7c trong Excel. Trong b\u00e0i n\u00e0y, ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u c\u00e1c b\u01b0\u1edbc c\u01a1 b\u1ea3n \u0111\u1ec3 gi\u1ea3i quy\u1ebft c\u00e1c b\u00e0i to\u00e1n trong Excel. \u1ede b\u00e0i vi\u1ebft n\u00e0y, t\u00f4i s\u1ebd kh\u00f4ng n\u00f3i c\u1ee5 th\u1ec3 v\u1ec1 h\u00e0m trong Excel, trong b\u00e0i n\u00e0y ch\u1ec9 h\u01b0\u1edbng d\u1ea9n kh\u00e1i qu\u00e1t l\u00e0m sao \u0111\u00f3 cho b\u1ea1n c\u00f3 c\u00e1ch t\u01b0 duy nhanh c\u00e1c b\u00e0i to\u00e1n m\u00e0 b\u1ea1n mu\u1ed1n gi\u1ea3i quy\u1ebft. Gi\u1ea3i quy\u1ebft m\u1ed9t y\u00eau c\u1ea7u&hellip;<\/p>\n","protected":false},"author":2,"featured_media":1108,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"footnotes":""},"categories":[14,15],"tags":[37,42],"class_list":["post-1290","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat","category-van-phong","tag-excel","tag-ham-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Microsoft Excel - T\u1ed5ng quan v\u1ec1 c\u00e1ch gi\u1ea3i c\u00e1c b\u00e0i to\u00e1n - EngISV<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.engisv.info\/?p=1290\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Excel - T\u1ed5ng quan v\u1ec1 c\u00e1ch gi\u1ea3i c\u00e1c b\u00e0i to\u00e1n - EngISV\" \/>\n<meta property=\"og:description\" content=\"Hai b\u00e0i tr\u01b0\u1edbc ch\u00fang ta \u0111\u00e3 c\u00f3 kh\u00e1i ni\u1ec7m c\u01a1 b\u1ea3n v\u1ec1 Excel, c\u00e1c ki\u1ec3u d\u1eef li\u1ec7u v\u00e0 \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng l\u00e0m vi\u1ec7c trong Excel. Trong b\u00e0i n\u00e0y, ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u c\u00e1c b\u01b0\u1edbc c\u01a1 b\u1ea3n \u0111\u1ec3 gi\u1ea3i quy\u1ebft c\u00e1c b\u00e0i to\u00e1n trong Excel. \u1ede b\u00e0i vi\u1ebft n\u00e0y, t\u00f4i s\u1ebd kh\u00f4ng n\u00f3i c\u1ee5 th\u1ec3 v\u1ec1 h\u00e0m trong Excel, trong b\u00e0i n\u00e0y ch\u1ec9 h\u01b0\u1edbng d\u1ea9n kh\u00e1i qu\u00e1t l\u00e0m sao \u0111\u00f3 cho b\u1ea1n c\u00f3 c\u00e1ch t\u01b0 duy nhanh c\u00e1c b\u00e0i to\u00e1n m\u00e0 b\u1ea1n mu\u1ed1n gi\u1ea3i quy\u1ebft. Gi\u1ea3i quy\u1ebft m\u1ed9t y\u00eau c\u1ea7u&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.engisv.info\/?p=1290\" \/>\n<meta property=\"og:site_name\" content=\"EngISV\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/engisv\" \/>\n<meta property=\"article:published_time\" content=\"2017-04-15T09:59:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/excel-cover-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"hoanghiepktv\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"hoanghiepktv\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1290#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1290\"},\"author\":{\"name\":\"hoanghiepktv\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#\\\/schema\\\/person\\\/dcbab2ddc35f4c71f45c7e13f36367bf\"},\"headline\":\"Microsoft Excel &#8211; T\u1ed5ng quan v\u1ec1 c\u00e1ch gi\u1ea3i c\u00e1c b\u00e0i to\u00e1n\",\"datePublished\":\"2017-04-15T09:59:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1290\"},\"wordCount\":1668,\"publisher\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1290#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/excel-cover-1.png\",\"keywords\":[\"Excel\",\"H\u00e0m Excel\"],\"articleSection\":[\"Th\u1ee7 thu\u1eadt\",\"V\u0103n ph\u00f2ng\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1290\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/?p=1290\",\"name\":\"Microsoft Excel - T\u1ed5ng quan v\u1ec1 c\u00e1ch gi\u1ea3i c\u00e1c b\u00e0i to\u00e1n - EngISV\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1290#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1290#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/excel-cover-1.png\",\"datePublished\":\"2017-04-15T09:59:23+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1290#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.engisv.info\\\/?p=1290\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1290#primaryimage\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/excel-cover-1.png\",\"contentUrl\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/excel-cover-1.png\",\"width\":300,\"height\":300},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1290#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.engisv.info\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft Excel &#8211; T\u1ed5ng quan v\u1ec1 c\u00e1ch gi\u1ea3i c\u00e1c b\u00e0i to\u00e1n\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#website\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/\",\"name\":\"EngISV\",\"description\":\"H\u00e3y b\u1eaft \u0111\u1ea7u t\u1eeb nh\u1eefng vi\u1ec7c nh\u1ecf!\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.engisv.info\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#organization\",\"name\":\"EngISV\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/logo2-3-1-1.png\",\"contentUrl\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/logo2-3-1-1.png\",\"width\":200,\"height\":76,\"caption\":\"EngISV\"},\"image\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/engisv\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#\\\/schema\\\/person\\\/dcbab2ddc35f4c71f45c7e13f36367bf\",\"name\":\"hoanghiepktv\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g\",\"caption\":\"hoanghiepktv\"},\"url\":\"https:\\\/\\\/www.engisv.info\\\/?author=2\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Microsoft Excel - T\u1ed5ng quan v\u1ec1 c\u00e1ch gi\u1ea3i c\u00e1c b\u00e0i to\u00e1n - EngISV","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.engisv.info\/?p=1290","og_locale":"en_US","og_type":"article","og_title":"Microsoft Excel - T\u1ed5ng quan v\u1ec1 c\u00e1ch gi\u1ea3i c\u00e1c b\u00e0i to\u00e1n - EngISV","og_description":"Hai b\u00e0i tr\u01b0\u1edbc ch\u00fang ta \u0111\u00e3 c\u00f3 kh\u00e1i ni\u1ec7m c\u01a1 b\u1ea3n v\u1ec1 Excel, c\u00e1c ki\u1ec3u d\u1eef li\u1ec7u v\u00e0 \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng l\u00e0m vi\u1ec7c trong Excel. Trong b\u00e0i n\u00e0y, ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u c\u00e1c b\u01b0\u1edbc c\u01a1 b\u1ea3n \u0111\u1ec3 gi\u1ea3i quy\u1ebft c\u00e1c b\u00e0i to\u00e1n trong Excel. \u1ede b\u00e0i vi\u1ebft n\u00e0y, t\u00f4i s\u1ebd kh\u00f4ng n\u00f3i c\u1ee5 th\u1ec3 v\u1ec1 h\u00e0m trong Excel, trong b\u00e0i n\u00e0y ch\u1ec9 h\u01b0\u1edbng d\u1ea9n kh\u00e1i qu\u00e1t l\u00e0m sao \u0111\u00f3 cho b\u1ea1n c\u00f3 c\u00e1ch t\u01b0 duy nhanh c\u00e1c b\u00e0i to\u00e1n m\u00e0 b\u1ea1n mu\u1ed1n gi\u1ea3i quy\u1ebft. Gi\u1ea3i quy\u1ebft m\u1ed9t y\u00eau c\u1ea7u&hellip;","og_url":"https:\/\/www.engisv.info\/?p=1290","og_site_name":"EngISV","article_publisher":"https:\/\/www.facebook.com\/engisv","article_published_time":"2017-04-15T09:59:23+00:00","og_image":[{"width":300,"height":300,"url":"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/excel-cover-1.png","type":"image\/png"}],"author":"hoanghiepktv","twitter_card":"summary_large_image","twitter_misc":{"Written by":"hoanghiepktv","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.engisv.info\/?p=1290#article","isPartOf":{"@id":"https:\/\/www.engisv.info\/?p=1290"},"author":{"name":"hoanghiepktv","@id":"https:\/\/www.engisv.info\/#\/schema\/person\/dcbab2ddc35f4c71f45c7e13f36367bf"},"headline":"Microsoft Excel &#8211; T\u1ed5ng quan v\u1ec1 c\u00e1ch gi\u1ea3i c\u00e1c b\u00e0i to\u00e1n","datePublished":"2017-04-15T09:59:23+00:00","mainEntityOfPage":{"@id":"https:\/\/www.engisv.info\/?p=1290"},"wordCount":1668,"publisher":{"@id":"https:\/\/www.engisv.info\/#organization"},"image":{"@id":"https:\/\/www.engisv.info\/?p=1290#primaryimage"},"thumbnailUrl":"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/excel-cover-1.png","keywords":["Excel","H\u00e0m Excel"],"articleSection":["Th\u1ee7 thu\u1eadt","V\u0103n ph\u00f2ng"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.engisv.info\/?p=1290","url":"https:\/\/www.engisv.info\/?p=1290","name":"Microsoft Excel - T\u1ed5ng quan v\u1ec1 c\u00e1ch gi\u1ea3i c\u00e1c b\u00e0i to\u00e1n - EngISV","isPartOf":{"@id":"https:\/\/www.engisv.info\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.engisv.info\/?p=1290#primaryimage"},"image":{"@id":"https:\/\/www.engisv.info\/?p=1290#primaryimage"},"thumbnailUrl":"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/excel-cover-1.png","datePublished":"2017-04-15T09:59:23+00:00","breadcrumb":{"@id":"https:\/\/www.engisv.info\/?p=1290#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.engisv.info\/?p=1290"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.engisv.info\/?p=1290#primaryimage","url":"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/excel-cover-1.png","contentUrl":"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/excel-cover-1.png","width":300,"height":300},{"@type":"BreadcrumbList","@id":"https:\/\/www.engisv.info\/?p=1290#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.engisv.info\/"},{"@type":"ListItem","position":2,"name":"Microsoft Excel &#8211; T\u1ed5ng quan v\u1ec1 c\u00e1ch gi\u1ea3i c\u00e1c b\u00e0i to\u00e1n"}]},{"@type":"WebSite","@id":"https:\/\/www.engisv.info\/#website","url":"https:\/\/www.engisv.info\/","name":"EngISV","description":"H\u00e3y b\u1eaft \u0111\u1ea7u t\u1eeb nh\u1eefng vi\u1ec7c nh\u1ecf!","publisher":{"@id":"https:\/\/www.engisv.info\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.engisv.info\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.engisv.info\/#organization","name":"EngISV","url":"https:\/\/www.engisv.info\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.engisv.info\/#\/schema\/logo\/image\/","url":"https:\/\/www.engisv.info\/wp-content\/uploads\/2018\/06\/logo2-3-1-1.png","contentUrl":"https:\/\/www.engisv.info\/wp-content\/uploads\/2018\/06\/logo2-3-1-1.png","width":200,"height":76,"caption":"EngISV"},"image":{"@id":"https:\/\/www.engisv.info\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/engisv"]},{"@type":"Person","@id":"https:\/\/www.engisv.info\/#\/schema\/person\/dcbab2ddc35f4c71f45c7e13f36367bf","name":"hoanghiepktv","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g","caption":"hoanghiepktv"},"url":"https:\/\/www.engisv.info\/?author=2"}]}},"_links":{"self":[{"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/posts\/1290","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1290"}],"version-history":[{"count":0,"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/posts\/1290\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/media\/1108"}],"wp:attachment":[{"href":"https:\/\/www.engisv.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1290"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1290"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1290"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}