{"id":7391,"date":"2021-08-10T10:06:09","date_gmt":"2021-08-10T03:06:09","guid":{"rendered":"https:\/\/tct.vn\/blog\/?p=7391"},"modified":"2021-08-18T11:08:38","modified_gmt":"2021-08-18T04:08:38","slug":"cac-thu-thuat-tinh-toan-hay-trong-excel","status":"publish","type":"post","link":"https:\/\/tct.vn\/blog\/cac-thu-thuat-tinh-toan-hay-trong-excel\/","title":{"rendered":"C\u00e1c th\u1ee7 thu\u1eadt t\u00ednh to\u00e1n hay trong Excel"},"content":{"rendered":"<p>T\u00ednh to\u00e1n c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u l\u00e0 c\u00f4ng n\u0103ng ch\u00ednh c\u1ee7a Excel v\u00e0 ch\u00fang ta th\u01b0\u1eddng ph\u1ea3i l\u00e0m \u0111i\u1ec1u n\u00e0y d\u1ef1a v\u00e0o c\u00e1c c\u00f4ng th\u1ee9c. C\u00f4ng th\u1ee9c l\u00e0 c\u00e1c ph\u01b0\u01a1ng tr\u00ecnh th\u1ef1c hi\u1ec7n c\u00e1c t\u00ednh to\u00e1n kh\u00e1c nhau trong c\u00e1c b\u1ea3ng t\u00ednh. M\u1eb7c d\u00f9 Microsoft gi\u1edbi thi\u1ec7u th\u00eam nhi\u1ec1u h\u00e0m m\u1edbi qua c\u00e1c n\u0103m nh\u01b0ng kh\u00e1i ni\u1ec7m c\u00f4ng th\u1ee9c b\u1ea3ng t\u00ednh Excel v\u1eabn gi\u1ed1ng nhau trong t\u1ea5t c\u1ea3 c\u00e1c phi\u00ean b\u1ea3n Excel 2016, Excel 2013, Excel 2010, Excel 2007 v\u00e0 th\u1ea5p h\u01a1n.<\/p>\n<ul>\n<li>T\u1ea5t c\u1ea3 c\u00e1c c\u00f4ng th\u1ee9c Excel b\u1eaft \u0111\u1ea7u v\u1edbi m\u1ed9t d\u1ea5u b\u1eb1ng (=).<\/li>\n<li>Sau d\u1ea5u b\u1eb1ng, b\u1ea1n nh\u1eadp ho\u1eb7c l\u00e0 ph\u00e9p t\u00ednh ho\u1eb7c h\u00e0m. V\u00ed d\u1ee5: \u0111\u1ec3 c\u1ed9ng c\u00e1c gi\u00e1 tr\u1ecb trong c\u00e1c \u00f4 t\u1eeb B1 t\u1edbi B5, b\u1ea1n c\u00f3 th\u1ec3:\n<ul>\n<li>G\u00f5 to\u00e0n b\u1ed9 ph\u01b0\u01a1ng tr\u00ecnh: = B1 + B2 + B3 + B4 + B5<\/li>\n<li>S\u1eed d\u1ee5ng h\u00e0m SUM: = SUM (B1: B5)<\/li>\n<\/ul>\n<\/li>\n<li>Nh\u1ea5n ph\u00edm Enter \u0111\u1ec3 ho\u00e0n th\u00e0nh c\u00f4ng th\u1ee9c.<\/li>\n<\/ul>\n<p>Trong m\u1ed9t c\u00f4ng th\u1ee9c Excel th\u00ec h\u00e0m l\u00e0 y\u1ebfu t\u1ed1 quan tr\u1ecdng nh\u1ea5t gi\u00fap b\u1ea1n t\u00ednh to\u00e1n ch\u00ednh x\u00e1c. Ch\u00ednh v\u00ec v\u1eady, vi\u1ec7c n\u1eafm r\u00f5 nh\u1eefng h\u00e0m c\u01a1 b\u1ea3n, th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng l\u00e0 m\u1ed9t trong c\u00e1c th\u1ee7 thu\u1eadt Excel quan tr\u1ecdng cho d\u00e2n v\u0103n ph\u00f2ng. Sau \u0111\u00e2y, ch\u00fang ta h\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u m\u1ed9t s\u1ed1 h\u00e0m t\u00ednh to\u00e1n c\u01a1 b\u1ea3n trong Excel nh\u00e9!<\/p>\n<p><a id=\"toc-7\" name=\"toc-7\"><\/a><\/p>\n<h3>H\u00e0m \u0111\u1ebfm<\/h3>\n<p class=\"_ilcss2_\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7400\" src=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-3.jpg\" alt=\"\" width=\"400\" height=\"356\" \/><\/p>\n<p>B\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng t\u00ednh v\u1edbi c\u01a1 s\u1edf d\u1eef li\u1ec7u kh\u1ed5ng l\u1ed3 v\u00e0 c\u1ea7n bi\u1ebft c\u00f3 bao nhi\u00eau \u00f4 trong m\u1ed9t v\u00f9ng n\u00e0o \u0111\u00f3 hay trong to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh ch\u1ec9 ch\u1ee9a ch\u1eef s\u1ed1, kh\u00f4ng ch\u1ee9a ch\u1eef c\u00e1i. Thay v\u00ec ph\u1ea3i ng\u1ed3i \u0111\u1ebfm m\u1ed9t c\u00e1ch th\u1ee7 c\u00f4ng th\u00ec b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m\u00a0<strong>=COUNT<\/strong>. V\u00ed d\u1ee5, b\u1ea1n c\u1ea7n \u0111\u1ebfm t\u1eeb \u00f4 C6 \u0111\u1ebfn C14, h\u00e3y g\u00f5\u00a0<strong>=COUNT(C6:C14)<\/strong>. Ngo\u00e0i ra c\u00f2n c\u00f3 hai h\u00e0m kh\u00e1c l\u00e0:<\/p>\n<p><em><strong>H\u00e0m COUNTA<\/strong><\/em><\/p>\n<ul>\n<li><strong>C\u00fa ph\u00e1p:<\/strong>\u00a0COUNTA(Value1, Value2\u2026).<\/li>\n<li><strong>C\u00e1c tham s\u1ed1:\u00a0<\/strong>Value1, Value2\u2026 l\u00e0 m\u1ea3ng hay d\u00e3y d\u1eef li\u1ec7u.<\/li>\n<li><strong>Ch\u1ee9c n\u0103ng:\u00a0<\/strong>H\u00e0m \u0111\u1ebfm t\u1ea5t c\u1ea3 c\u00e1c \u00f4 ch\u1ee9a d\u1eef li\u1ec7u.<\/li>\n<li><strong>V\u00ed d\u1ee5:<\/strong>\u00a0=COUNTA(A4:D9) \u0111\u1ebfm c\u00e1c \u00f4 ch\u1ee9a d\u1eef li\u1ec7u trong d\u00e3y t\u1eeb \u00f4 A4 \u0111\u1ebfn \u00f4 D9.<\/li>\n<\/ul>\n<p class=\"_ilcss2_\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7394\" src=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-5-1.jpg\" alt=\"\" width=\"400\" height=\"281\" \/><\/p>\n<p><em><strong>H\u00e0m COUNTIF<\/strong><\/em><\/p>\n<ul>\n<li><strong>C\u00fa ph\u00e1p:\u00a0<\/strong>COUNTIF(Range, Criteria).<\/li>\n<li><strong>C\u00e1c tham s\u1ed1:<\/strong>\n<ul>\n<li><em><strong>Range:\u00a0<\/strong><\/em>d\u00e3y d\u1eef li\u1ec7u c\u00e1c b\u1ea1n mu\u1ed1n \u0111\u1ebfm.<\/li>\n<li><em><strong>Criteria:\u00a0<\/strong><\/em>\u0111i\u1ec1u ki\u1ec7n, ti\u00eau chu\u1ea9n cho c\u00e1c \u00f4 \u0111\u1ebfm.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Ch\u1ee9c n\u0103ng:\u00a0<\/strong>H\u00e0m \u0111\u1ebfm c\u00e1c \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb theo \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc.<\/li>\n<li><strong>V\u00ed d\u1ee5:\u00a0<\/strong>=COUNTIF(A1:A5,&#8221;&gt;9&#8243;) \u0111\u1ebfm t\u1ea5t c\u1ea3 c\u00e1c \u00f4 t\u1eeb A1 \u0111\u1ebfn A5 c\u00f3 ch\u1ee9a s\u1ed1 l\u1edbn h\u01a1n 9.<\/li>\n<\/ul>\n<p class=\"_ilcss2_\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7401\" src=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-4.png\" alt=\"\" width=\"604\" height=\"227\" srcset=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-4.png 604w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-4-400x150.png 400w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-4-510x192.png 510w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<p><a id=\"toc-8\" name=\"toc-8\"><\/a><\/p>\n<h3>H\u00e0m t\u00ednh t\u1ed5ng<\/h3>\n<p><em><strong>H\u00e0m SUM<\/strong><\/em><\/p>\n<p>H\u00e0m SUM trong Excel th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c \u0111\u1ed1i s\u1ed1 tr\u00ean b\u1ea3ng t\u00ednh. S\u1eed d\u1ee5ng h\u00e0m Sum trong Excel gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m kh\u00e1 nhi\u1ec1u th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c so v\u1edbi c\u00e1ch t\u00ednh th\u1ee7 c\u00f4ng th\u00f4ng th\u01b0\u1eddng.<\/p>\n<ul>\n<li><strong>C\u00fa ph\u00e1p:<\/strong>\u00a0SUM(Number1, Number2..).<\/li>\n<li><strong>C\u00e1c tham s\u1ed1:\u00a0<\/strong>Number1, Number2\u2026 l\u00e0 c\u00e1c s\u1ed1 c\u1ea7n t\u00ednh t\u1ed5ng.<\/li>\n<li><strong>V\u00ed d\u1ee5:\u00a0<\/strong>=SUM(A2:B2) t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb t\u1eeb \u00f4 A2 \u0111\u1ebfn \u00f4 B2.<\/li>\n<\/ul>\n<p class=\"_ilcss2_\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7403\" src=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-6.png\" alt=\"\" width=\"352\" height=\"133\" \/><\/p>\n<p><em><strong>H\u00e0m SUMIF<\/strong><\/em><\/p>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ednh\u00a0t\u1ed5ng c\u00e1c \u00f4 \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh b\u1edfi nh\u1eefng ti\u00eau chu\u1ea9n \u0111\u01b0a v\u00e0o th\u00ec b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m SUMIF.<\/p>\n<ul>\n<li><strong>C\u00fa ph\u00e1p:\u00a0<\/strong>SUMIF(Range, Criteria, Sum_range).<\/li>\n<li><strong>C\u00e1c tham s\u1ed1:<\/strong>\n<ul>\n<li><strong>Range:<\/strong>\u00a0L\u00e0 d\u00e3y s\u1ed1 m\u00e0 c\u00e1c b\u1ea1n mu\u1ed1n x\u00e1c \u0111\u1ecbnh.<\/li>\n<li><strong>Criteria:\u00a0<\/strong>\u0110i\u1ec1u ki\u1ec7n, ti\u00eau chu\u1ea9n c\u00e1c b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng (c\u00f3 th\u1ec3 l\u00e0 s\u1ed1, bi\u1ec3u th\u1ef1c ho\u1eb7c chu\u1ed7i).<\/li>\n<li><strong>Sum_range:<\/strong>\u00a0L\u00e0 c\u00e1c \u00f4 th\u1ef1c s\u1ef1 c\u1ea7n t\u00ednh t\u1ed5ng.<\/li>\n<\/ul>\n<\/li>\n<li><strong>V\u00ed d\u1ee5:\u00a0<\/strong>=SUMIF(A1:A5,&#8221;green&#8221;,B1:B5) t\u00ednh t\u1ed5ng c\u00e1c \u00f4 t\u1eeb B1 \u0111\u1ebfn B5 v\u1edbi \u0111i\u1ec1u ki\u1ec7n gi\u00e1 tr\u1ecb trong c\u1ed9t t\u1eeb A1 \u0111\u1ebfn A5 l\u00e0 green.<\/li>\n<\/ul>\n<p class=\"_ilcss2_\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7404\" src=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-7.png\" alt=\"\" width=\"604\" height=\"227\" srcset=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-7.png 604w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-7-400x150.png 400w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-7-510x192.png 510w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<p><strong><em>H\u00e0m SUMPRODUCT<\/em><\/strong><\/p>\n<ul>\n<li><strong>C\u00fa ph\u00e1p:\u00a0<\/strong>SUMPRODUCT(Array1,Array2,Array3\u2026).<\/li>\n<li><strong>C\u00e1c tham s\u1ed1:<\/strong>\u00a0Array1: b\u1eaft bu\u1ed9c, \u0111\u1ed1i s\u1ed1 m\u1ea3ng \u0111\u1ea7u ti\u00ean m\u00e0 b\u1ea1n mu\u1ed1n nh\u00e2n c\u00e1c th\u00e0nh ph\u1ea7n c\u1ee7a n\u00f3 r\u1ed3i c\u1ed9ng t\u1ed5ng. Array2, Array3&#8230; t\u00f9y ch\u1ecdn, c\u00e1c \u0111\u1ed1i s\u1ed1 m\u1ea3ng t\u1eeb 2 \u0111\u1ebfn 255 m\u00e0 b\u1ea1n mu\u1ed1n nh\u00e2n c\u00e1c th\u00e0nh ph\u1ea7n c\u1ee7a n\u00f3 r\u1ed3i c\u1ed9ng t\u1ed5ng.<\/li>\n<li><strong>Ch\u1ee9c n\u0103ng:\u00a0<\/strong>L\u1ea5y t\u00edch c\u1ee7a c\u00e1c d\u00e3y \u0111\u01b0a v\u00e0o, sau \u0111\u00f3 t\u00ednh t\u1ed5ng c\u00e1c t\u00edch \u0111\u00f3.<\/li>\n<\/ul>\n<p><strong>L\u01b0u \u00fd:<\/strong>\u00a0C\u00e1c \u0111\u1ed1i s\u1ed1 trong c\u00e1c d\u00e3y ph\u1ea3i c\u00f9ng chi\u1ec1u, n\u1ebfu kh\u00f4ng h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1ed7i #VALUE.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7405\" src=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-9.png\" alt=\"\" width=\"604\" height=\"227\" srcset=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-9.png 604w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-9-400x150.png 400w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-9-510x192.png 510w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<h3>H\u00e0m t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh<\/h3>\n<p><em><strong>H\u00e0m AVERAGE<\/strong><\/em><\/p>\n<ul>\n<li><strong>C\u00fa ph\u00e1p:\u00a0<\/strong>AVERAGE(Number1, Number2\u2026).<\/li>\n<li><strong>C\u00e1c tham s\u1ed1:\u00a0<\/strong>Number1, Number2\u2026 l\u00e0 c\u00e1c s\u1ed1 c\u1ea7n t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh.<\/li>\n<li><strong>Ch\u1ee9c n\u0103ng:\u00a0<\/strong>Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ee7a c\u00e1c \u0111\u1ed1i s\u1ed1.<\/li>\n<\/ul>\n<p class=\"_ilcss2_\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7413\" src=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-24.jpg\" alt=\"\" width=\"649\" height=\"436\" srcset=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-24.jpg 649w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-24-400x269.jpg 400w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-24-510x343.jpg 510w\" sizes=\"auto, (max-width: 649px) 100vw, 649px\" \/><\/p>\n<p><a id=\"toc-10\" name=\"toc-10\"><\/a><\/p>\n<h3>H\u00e0m MIN\/MAX<\/h3>\n<p>H\u00e0m MAX v\u00e0 h\u00e0m MIN th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t, nh\u1ecf nh\u1ea5t c\u1ee7a c\u00e1c \u0111\u1ed1i s\u1ed1 hay v\u00f9ng d\u1eef li\u1ec7u.<\/p>\n<p><em><strong>H\u00e0m MAX<\/strong><\/em><\/p>\n<ul>\n<li><strong>C\u00fa ph\u00e1p:\u00a0<\/strong>MAX(Number1, Number2\u2026).<\/li>\n<li><strong>C\u00e1c tham s\u1ed1:<\/strong>\u00a0Number1, Number2\u2026 l\u00e0 d\u00e3y m\u00e0 c\u00e1c b\u1ea1n mu\u1ed1n t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t \u1edf trong \u0111\u00f3.<\/li>\n<li><strong>Ch\u1ee9c n\u0103ng:\u00a0<\/strong>H\u00e0m tr\u1ea3 v\u1ec1 s\u1ed1 l\u1edbn nh\u1ea5t trong d\u00e3y \u0111\u01b0\u1ee3c nh\u1eadp.<\/li>\n<li><strong>V\u00ed d\u1ee5:\u00a0<\/strong>=MAX(E4:E9) \u0111\u01b0a ra gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t trong c\u00e1c \u00f4 t\u1eeb E4 \u0111\u1ebfn E9.<\/li>\n<\/ul>\n<p class=\"_ilcss2_\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7406\" src=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-10.png\" alt=\"\" width=\"484\" height=\"380\" srcset=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-10.png 484w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-10-400x314.png 400w\" sizes=\"auto, (max-width: 484px) 100vw, 484px\" \/><\/p>\n<p><em><strong>H\u00e0m MIN<\/strong><\/em><\/p>\n<ul>\n<li><strong>C\u00fa ph\u00e1p:\u00a0<\/strong>MIN(Number1, Number2\u2026).<\/li>\n<li><strong>C\u00e1c tham s\u1ed1:\u00a0<\/strong>Number1, Number2\u2026 l\u00e0 d\u00e3y m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t \u1edf trong \u0111\u00f3.<\/li>\n<li><strong>Ch\u1ee9c n\u0103ng:\u00a0<\/strong>H\u00e0m tr\u1ea3 v\u1ec1 s\u1ed1 nh\u1ecf nh\u1ea5t trong d\u00e3y \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o.<\/li>\n<\/ul>\n<p class=\"_ilcss2_\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7417\" src=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-11-1.jpg\" alt=\"\" width=\"535\" height=\"409\" srcset=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-11-1.jpg 535w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-11-1-400x306.jpg 400w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-11-1-510x390.jpg 510w\" sizes=\"auto, (max-width: 535px) 100vw, 535px\" \/><\/p>\n<p><a id=\"toc-11\" name=\"toc-11\"><\/a><\/p>\n<h3>H\u00e0m ng\u00e0y th\u00e1ng<\/h3>\n<p><em><strong>H\u00e0m DAYS<\/strong><\/em><\/p>\n<p>H\u00e0m DAYS l\u00e0 h\u00e0m\u00a0t\u00ednh s\u1ed1 ng\u00e0y gi\u1eefa 2 ng\u00e0y trong Excel, th\u01b0\u1eddng d\u00f9ng \u0111\u1ec3 t\u00ednh s\u1ed1 n\u0103m l\u00e0m vi\u1ec7c, ho\u1ea1t \u0111\u1ed9ng&#8230;<\/p>\n<ul>\n<li><strong>C\u00fa ph\u00e1p:\u00a0<\/strong>DAYS(end_date, start_date).<\/li>\n<li><strong>C\u00e1c tham s\u1ed1:<\/strong>\n<ul>\n<li><strong>end_date:<\/strong>\u00a0L\u00e0 ng\u00e0y k\u1ebft th\u00fac mu\u1ed1n x\u00e1c \u0111\u1ecbnh s\u1ed1 ng\u00e0y, l\u00e0 tham s\u1ed1 b\u1eaft bu\u1ed9c.<\/li>\n<li><strong>start_date:<\/strong>\u00a0L\u00e0 ng\u00e0y \u0111\u1ea7u ti\u00ean mu\u1ed1n x\u00e1c \u0111\u1ecbnh s\u1ed1 ng\u00e0y, l\u00e0 tham s\u1ed1 b\u1eaft bu\u1ed9c.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p class=\"_ilcss2_\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7418\" src=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-12-1.jpg\" alt=\"\" width=\"800\" height=\"380\" srcset=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-12-1.jpg 800w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-12-1-400x190.jpg 400w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-12-1-768x365.jpg 768w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-12-1-510x242.jpg 510w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/p>\n<p class=\"_ilcss7_\"><strong>Ch\u00fa \u00fd<\/strong><\/p>\n<ul>\n<li>N\u1ebfu\u00a0<strong>end_date<\/strong>\u00a0v\u00e0\u00a0<strong>start_date<\/strong>\u00a0\u0111\u1ec1u c\u00f3 d\u1ea1ng s\u1ed1 -&gt; h\u00e0m d\u00f9ng\u00a0<strong>EndDate<\/strong>\u00a0&#8211;\u00a0<strong>StartDate<\/strong>\u00a0\u0111\u1ec3 t\u00ednh s\u1ed1 ng\u00e0y gi\u1eefa 2 ng\u00e0y n\u00e0y.<\/li>\n<li>N\u1ebfu\u00a0<strong>end_date<\/strong>\u00a0v\u00e0\u00a0<strong>start_date<\/strong>\u00a0\u1edf d\u1ea1ng v\u0103n b\u1ea3n h\u00e0m t\u1ef1 \u0111\u1ed9ng chuy\u1ec3n sang \u0111\u1ecbnh d\u1ea1ng ng\u00e0y b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m\u00a0<strong>DATEVALUE(date_text)<\/strong>\u00a0r\u1ed3i t\u00ednh to\u00e1n.<\/li>\n<li>N\u1ebfu \u0111\u1ed1i s\u1ed1 v\u01b0\u1ee3t ngo\u00e0i ph\u1ea1m vi c\u1ee7a ng\u00e0y th\u00e1ng n\u0103m -&gt; h\u00e0m tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1ed7i #NUM!<\/li>\n<li>N\u1ebfu \u0111\u1ed1i s\u1ed1 d\u1ea1ng v\u0103n b\u1ea3n m\u00e0 kh\u00f4ng th\u1ec3 chuy\u1ec3n sang \u0111\u1ecbnh d\u1ea1ng ng\u00e0y h\u1ee3p l\u1ec7 -&gt; h\u00e0m tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1ed7i #VALUE!<\/li>\n<\/ul>\n<p><em><strong>H\u00e0m NETWORKDAYS<\/strong><\/em><\/p>\n<p>Thay v\u00ec d\u00f9ng c\u00e1ch th\u1ee7 c\u00f4ng nh\u01b0 \u0111\u1ebfm tay \u0111\u1ec3 t\u00ednh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c. Excel h\u1ed7 tr\u1ee3 cho b\u1ea1n m\u1ed9t\u00a0h\u00e0m NETWORKDAYS\u00a0t\u00ednh s\u1ed1 l\u01b0\u1ee3ng ng\u00e0y l\u00e0m vi\u1ec7c to\u00e0n th\u1eddi gian gi\u1eefa hai ng\u00e0y m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c, nhanh g\u1ecdn.<\/p>\n<p><strong>C\u00fa Ph\u00e1p:<\/strong>\u00a0NETWORKDAYS(start_date,end_date,[HOLIDAYS])<\/p>\n<div class=\"google-auto-placed ap_container\"><ins class=\"adsbygoogle adsbygoogle-noablate\" data-ad-format=\"auto\" data-ad-client=\"ca-pub-9275417305531302\" data-adsbygoogle-status=\"done\" data-ad-status=\"unfilled\"><ins id=\"aswift_3_expand\" tabindex=\"0\" title=\"Advertisement\" aria-label=\"Advertisement\"><ins id=\"aswift_3_anchor\"><iframe loading=\"lazy\" id=\"aswift_3\" src=\"https:\/\/googleads.g.doubleclick.net\/pagead\/ads?client=ca-pub-9275417305531302&amp;output=html&amp;h=280&amp;adk=3701038348&amp;adf=4265817773&amp;pi=t.aa~a.1601029810~i.159~rp.4&amp;w=893&amp;fwrn=4&amp;fwrnh=100&amp;lmt=1628560337&amp;num_ads=1&amp;rafmt=1&amp;armr=3&amp;sem=mc&amp;pwprc=4852867487&amp;psa=1&amp;ad_type=text_image&amp;format=893x280&amp;url=https%3A%2F%2Fmeta.vn%2Fhotro%2Fthu-thuat-excel-hay-cho-dan-van-phong-6948&amp;flash=0&amp;fwr=0&amp;pra=3&amp;rh=200&amp;rw=893&amp;rpe=1&amp;resp_fmts=3&amp;wgl=1&amp;fa=27&amp;adsid=ChAI8KTDiAYQtb6W7en7xrYtEkwAgfdKmL0lpnan-bck4G2_rCLzEFCugn5oxSi6dM4ZEFJqK6K_un7pFFWLfEWpJGf28H6Uv1H0yBpQzJyz83ggHgsMtCMS7rU1-tsk&amp;uach=WyJXaW5kb3dzIiwiMTAuMCIsIng4NiIsIiIsIjkyLjAuNDUxNS4xMzEiLFtdLG51bGwsbnVsbCxudWxsXQ..&amp;tt_state=W3siaXNzdWVyT3JpZ2luIjoiaHR0cHM6Ly9hdHRlc3RhdGlvbi5hbmRyb2lkLmNvbSIsInN0YXRlIjo3fV0.&amp;dt=1628560301910&amp;bpp=4&amp;bdt=3094&amp;idt=5&amp;shv=r20210805&amp;mjsv=m202108090101&amp;ptt=9&amp;saldr=aa&amp;abxe=1&amp;cookie=ID%3D8f94e33ad3000ea3-22470319beca0019%3AT%3D1628511061%3ART%3D1628511061%3AS%3DALNI_MY4WAqkhSrVTBJWMVOu52xnQS_HdA&amp;prev_fmts=0x0%2C903x840&amp;nras=3&amp;correlator=5415669427104&amp;frm=20&amp;pv=1&amp;ga_vid=1745760427.1628511008&amp;ga_sid=1628560301&amp;ga_hid=105941572&amp;ga_fc=0&amp;ga_cid=626893082.1628511009&amp;u_tz=420&amp;u_his=5&amp;u_java=0&amp;u_h=1080&amp;u_w=1920&amp;u_ah=1040&amp;u_aw=1920&amp;u_cd=24&amp;u_nplug=3&amp;u_nmime=4&amp;adx=5&amp;ady=12110&amp;biw=903&amp;bih=840&amp;scr_x=0&amp;scr_y=9100&amp;eid=42530671%2C44747621%2C20211866%2C21067496&amp;oid=3&amp;pvsid=4097639289973852&amp;pem=965&amp;ref=https%3A%2F%2Fwww.google.com%2F&amp;eae=0&amp;fc=1408&amp;brdim=958%2C26%2C958%2C26%2C1920%2C0%2C936%2C960%2C920%2C840&amp;vis=1&amp;rsz=%7C%7Cs%7C&amp;abl=NS&amp;fu=128&amp;bc=31&amp;jar=2021-08-09-12&amp;ifi=4&amp;uci=a!4&amp;btvi=1&amp;fsb=1&amp;xpc=HhMuuFpy5c&amp;p=https%3A\/\/meta.vn&amp;dtd=35346\" name=\"aswift_3\" width=\"893\" height=\"0\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" sandbox=\"allow-forms allow-popups allow-popups-to-escape-sandbox allow-same-origin allow-scripts allow-top-navigation-by-user-activation\" allowfullscreen=\"allowfullscreen\" data-google-container-id=\"a!4\" data-google-query-id=\"COiKhp2spfICFQxraAodqVwBOg\" data-load-complete=\"true\" data-mce-fragment=\"1\"><\/iframe><\/ins><\/ins><\/ins><\/div>\n<p><strong>V\u00ed d\u1ee5:<\/strong>\u00a0Trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y, ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m\u00a0NETWORKDAYS t\u00ednh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c v\u1edbi ng\u00e0y b\u1eaft \u0111\u1ea7u l\u00e0 23\/01\/2013, ng\u00e0y k\u1ebft th\u00fac l\u00e0 18\/02\/2013, trong \u0111\u00f3 bao g\u1ed3m c\u1ea3 ng\u00e0y ngh\u1ec9. C\u00f4ng th\u1ee9c l\u00e0 =NETWORKDAYS(B4,C4).<\/p>\n<p class=\"_ilcss2_\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7419\" src=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-13-1.jpg\" alt=\"\" width=\"500\" height=\"136\" srcset=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-13-1.jpg 500w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-13-1-400x109.jpg 400w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/p>\n<p><em><strong>H\u00e0m NOW<\/strong><\/em><\/p>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb ng\u00e0y v\u00e0 th\u1eddi gian hi\u1ec7n t\u1ea1i tr\u00ean trang t\u00ednh ho\u1eb7c mu\u1ed1n t\u00ednh to\u00e1n d\u1ef1a tr\u00ean th\u1eddi gian hi\u1ec7n t\u1ea1i th\u00ec h\u00e0m NOW l\u00e0 gi\u1ea3i ph\u00e1p d\u00e0nh cho b\u1ea1n.<\/p>\n<p><strong>C\u00fa Ph\u00e1p:<\/strong>\u00a0NOW ()<\/p>\n<p class=\"_ilcss2_\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7420\" src=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-14-1.jpg\" alt=\"\" width=\"460\" height=\"285\" srcset=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-14-1.jpg 460w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-14-1-400x248.jpg 400w\" sizes=\"auto, (max-width: 460px) 100vw, 460px\" \/><\/p>\n<p><strong>Ch\u00fa \u00fd<\/strong><\/p>\n<ul>\n<li>C\u00fa ph\u00e1p h\u00e0m NOW kh\u00f4ng s\u1eed d\u1ee5ng \u0111\u1ed1i s\u1ed1.<\/li>\n<li>K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m NOW \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt khi b\u1ea1n th\u1ef1c hi\u1ec7n m\u1ed9t c\u00f4ng th\u1ee9c ho\u1eb7c edit m\u1ed9t \u00f4 gi\u00e1 tr\u1ecb ch\u1ee9 kh\u00f4ng c\u1eadp nh\u1eadt li\u00ean t\u1ee5c.<\/li>\n<\/ul>\n<p><a id=\"toc-12\" name=\"toc-12\"><\/a><\/p>\n<h3>H\u00e0m tra c\u1ee9u v\u00e0 tham chi\u1ebfu<\/h3>\n<p><em><strong>H\u00e0m VLookup<\/strong><\/em><\/p>\n<p>H\u00e0m VLookup d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb trong c\u1ed9t ngo\u00e0i c\u00f9ng b\u00ean tr\u00e1i c\u1ee7a b\u1ea3ng v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb trong c\u00f9ng m\u1ed9t h\u00e0ng t\u1eeb c\u1ed9t kh\u00e1c m\u00e0 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh. C\u00fa ph\u00e1p: VLOOKUP(\u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm, v\u00f9ng b\u1ea3ng ch\u1ee9a gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm v\u00e0 tr\u1ea3 v\u1ec1,c\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1), c\u00f3 th\u1ec3 th\u00eam \u0111\u1ed1i s\u1ed1 th\u1ee9 4 nh\u01b0 v\u00ed d\u1ee5 d\u01b0\u1edbi.<\/p>\n<p class=\"_ilcss2_\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7421\" src=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-15-1.png\" alt=\"\" width=\"604\" height=\"307\" srcset=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-15-1.png 604w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-15-1-400x203.png 400w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-15-1-510x259.png 510w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<p>H\u00e0m VLookup t\u00ecm ID (104) trong c\u1ed9t ngo\u00e0i c\u00f9ng b\u00ean tr\u00e1i c\u1ee7a d\u1ea3i $E$4:$G$7 v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb trong c\u00f9ng m\u1ed9t h\u00e0ng t\u1eeb c\u1ed9t th\u1ee9 3 (\u0111\u1ed1i s\u1ed1 th\u1ee9 3 \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh l\u00e0 3). \u0110\u1ed1i s\u1ed1 th\u1ee9 4 \u0111\u1eb7t l\u00e0 FALSE \u0111\u1ec3 tr\u1ea3 l\u1ea1i k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c ho\u1eb7c l\u1ed7i #N\/A n\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y.<\/p>\n<p>B\u1ea1n ch\u1ec9 c\u1ea7n th\u1ef1c hi\u1ec7n tr\u00ean 1 \u00f4, sau \u0111\u00f3 k\u00e9o h\u00e0m VLookup xu\u1ed1ng d\u01b0\u1edbi \u0111\u1ec3 \u00e1p d\u1ee5ng cho c\u00e1c h\u00e0ng b\u00ean d\u01b0\u1edbi. V\u00ec v\u00f9ng tham chi\u1ebfu gi\u1eef nguy\u00ean n\u00ean ph\u1ea3i d\u00f9ng $ tr\u01b0\u1edbc c\u00e1c k\u00fd hi\u1ec7u \u0111\u1ec3 t\u1ea1o tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i.<\/p>\n<p><em><strong>H\u00e0m\u00a0HLookup<\/strong><\/em><\/p>\n<p>H\u00e0m HLookup l\u00e0 h\u00e0m excel n\u00e2ng cao d\u00f9ng d\u00f2 t\u00ecm m\u1ed9t gi\u00e1 tr\u1ecb \u1edf d\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u. N\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u1edf c\u00f9ng tr\u00ean c\u1ed9t v\u1edbi gi\u00e1 tr\u1ecb t\u00ecm th\u1ea5y tr\u00ean h\u00e0ng m\u00e0 ch\u00fang ta ch\u1ec9 \u0111\u1ecbnh. H\u00e0m HLookup th\u01b0\u1eddng d\u00f9ng \u0111\u1ec3 \u0111i\u1ec1n th\u00f4ng tin v\u00e0o b\u1ea3ng d\u1eef li\u1ec7u l\u1ea5y t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u ph\u1ee5.\u00a0C\u00fa ph\u00e1p HLOOKUP(gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm, b\u1ea3ng gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm, s\u1ed1 th\u1ee9 t\u1ef1 h\u00e0ng c\u1ea7n l\u1ea5y, ph\u1ea1m vi t\u00ecm ki\u1ebfm).<\/p>\n<p>V\u00ed d\u1ee5:<\/p>\n<p>\u0110\u1ec3 t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb\u00a0M\u00e3\u00a0\u0111\u01a1n v\u1ecb\u00a0c\u1ee7a b\u1ea3ng tham chi\u1ebfu v\u00e0 cho ra k\u1ebft qu\u1ea3\u00a0\u0110\u01a1n v\u1ecb\u00a0t\u01b0\u01a1ng \u1ee9ng v\u1edbi m\u1ee9c th\u01b0\u1edfng \u0111\u00f3 ch\u00fang ta l\u00e0m nh\u01b0 sau:<\/p>\n<p>Ta c\u00f3: HLOOKUP(A2:A4;$A$6:$D$7;2;1)<\/p>\n<p class=\"_ilcss2_\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7422\" src=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-16-1.png\" alt=\"\" width=\"634\" height=\"190\" srcset=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-16-1.png 634w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-16-1-400x120.png 400w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-16-1-510x153.png 510w\" sizes=\"auto, (max-width: 634px) 100vw, 634px\" \/><\/p>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li>A2:A4:\u00a0l\u00e0 \u0111\u1ecba ch\u1ec9\u00a0M\u00e3\u00a0\u0111\u01a1n\u00a0v\u1ecb\u00a0\u0111\u1ed1i chi\u1ebfu v\u1edbi d\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng tham chi\u1ebfu<\/li>\n<li>$A$6:$D$7:\u00a0l\u00e0 \u0111\u1ecba ch\u1ec9 tuy\u1ec7t \u0111\u1ed1i c\u1ee7a b\u1ea3ng tham chi\u1ebfu (c\u00e1c b\u1ea1n ch\u00fa \u00fd kh\u00f4ng l\u1ea5y ti\u00eau \u0111\u1ec1 nh\u00e9)<\/li>\n<li>2:\u00a0d\u00f2ng \u0111\u01a1n v\u1ecb l\u00e0 d\u00f2ng th\u1ee9 2 c\u1ee7a b\u1ea3ng tham chi\u1ebfu<\/li>\n<li>1:\u00a0d\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng tham chi\u1ebfu \u0111\u00e3 s\u1eafp x\u1ebfp theo chi\u1ec1u t\u0103ng d\u1ea7n (ng\u1ea7m \u0111\u1ecbnh)<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c nh\u01b0 sau:<\/p>\n<p class=\"_ilcss2_\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7423\" src=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-17.png\" alt=\"\" width=\"408\" height=\"155\" srcset=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-17.png 408w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/thu-thuat-excel-hay-cho-dan-van-phong-17-400x152.png 400w\" sizes=\"auto, (max-width: 408px) 100vw, 408px\" \/><\/p>\n<p>Tr\u00ean \u0111\u00e2y ch\u1ec9 l\u00e0 nh\u1eefng h\u00e0m Excel c\u01a1 b\u1ea3n nh\u1ea5t th\u01b0\u1eddng \u0111\u01b0\u1ee3c d\u00f9ng trong v\u0103n ph\u00f2ng. \u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel, ch\u00ednh v\u00ec v\u1eady, b\u1ea1n c\u1ea7n ph\u1ea3i th\u01b0\u1eddng xuy\u00ean luy\u1ec7n t\u1eadp \u0111\u1ec3 ghi nh\u1edb v\u00e0 thu\u1ea7n th\u1ee5c c\u00e1ch s\u1eed d\u1ee5ng c\u1ee7a c\u00e1c h\u00e0m n\u00e0y.<\/p>\n<p>Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>T\u00ednh to\u00e1n c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u l\u00e0 c\u00f4ng n\u0103ng ch\u00ednh c\u1ee7a Excel v\u00e0 ch\u00fang ta th\u01b0\u1eddng ph\u1ea3i l\u00e0m \u0111i\u1ec1u n\u00e0y d\u1ef1a v\u00e0o c\u00e1c c\u00f4ng th\u1ee9c. C\u00f4ng th\u1ee9c l\u00e0 c\u00e1c ph\u01b0\u01a1ng tr\u00ecnh th\u1ef1c hi\u1ec7n c\u00e1c t\u00ednh to\u00e1n kh\u00e1c nhau trong c\u00e1c b\u1ea3ng t\u00ednh. M\u1eb7c d\u00f9 Microsoft gi\u1edbi thi\u1ec7u th\u00eam nhi\u1ec1u h\u00e0m m\u1edbi qua c\u00e1c n\u0103m nh\u01b0ng [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":7393,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,508],"tags":[],"class_list":["post-7391","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tin-tuc","category-office"],"_links":{"self":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/7391","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/comments?post=7391"}],"version-history":[{"count":0,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/7391\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media\/7393"}],"wp:attachment":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media?parent=7391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/categories?post=7391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/tags?post=7391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}