{"id":806,"date":"2023-08-25T23:29:32","date_gmt":"2023-08-25T16:29:32","guid":{"rendered":"https:\/\/trannghiait.com\/?p=806"},"modified":"2023-08-25T23:29:32","modified_gmt":"2023-08-25T16:29:32","slug":"tom-tat-nhanh-de-hieu-hon-50-cu-phap-dung-excel-cho-anh-em-van-phong","status":"publish","type":"post","link":"https:\/\/trannghiait.com\/index.php\/2023\/08\/25\/tom-tat-nhanh-de-hieu-hon-50-cu-phap-dung-excel-cho-anh-em-van-phong\/","title":{"rendered":"T\u00f3m t\u1eaft nhanh d\u1ec5 hi\u1ec3u h\u01a1n 50 c\u00fa ph\u00e1p d\u00f9ng excel cho anh em v\u0103n ph\u00f2ng"},"content":{"rendered":"\n

D\u01b0\u1edbi \u0111\u00e2y l\u00e0 50 c\u00fa ph\u00e1p th\u01b0\u1eddng d\u00f9ng trong Excel:<\/em><\/p>\n\n\n\n

    \n
  1. SUM:<\/strong> T\u00ednh t\u1ed5ng c\u1ee7a m\u1ed9t d\u00e3y c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t b\u1ea3ng t\u00ednh. V\u00ed d\u1ee5: =SUM(A1:A10)<\/li>\n\n\n\n
  2. AVERAGE: <\/strong>T\u00ednh trung b\u00ecnh c\u1ed9ng c\u1ee7a m\u1ed9t d\u00e3y c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t b\u1ea3ng t\u00ednh. V\u00ed d\u1ee5: =AVERAGE(A1:A10)<\/li>\n\n\n\n
  3. MAX:<\/strong> T\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t trong m\u1ed9t d\u00e3y c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t b\u1ea3ng t\u00ednh. V\u00ed d\u1ee5: =MAX(A1:A10)<\/li>\n\n\n\n
  4. MIN:<\/strong> T\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong m\u1ed9t d\u00e3y c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t b\u1ea3ng t\u00ednh. V\u00ed d\u1ee5: =MIN(A1:A10)<\/li>\n\n\n\n
  5. IF:<\/strong> Ki\u1ec3m tra m\u1ed9t \u0111i\u1ec1u ki\u1ec7n v\u00e0 tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb n\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang v\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb kh\u00e1c n\u1ebfu \u0111i\u1ec1u ki\u1ec7n sai. V\u00ed d\u1ee5: =IF(A1>10,”L\u1edbn h\u01a1n 10″,”Nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng 10″)<\/li>\n\n\n\n
  6. COUNT: <\/strong>\u0110\u1ebfm s\u1ed1 l\u01b0\u1ee3ng gi\u00e1 tr\u1ecb trong m\u1ed9t d\u00e3y c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t b\u1ea3ng t\u00ednh. V\u00ed d\u1ee5: =COUNT(A1:A10)<\/li>\n\n\n\n
  7. CONCATENATE: K\u1ebft h\u1ee3p hai ho\u1eb7c nhi\u1ec1u chu\u1ed7i v\u0103n b\u1ea3n th\u00e0nh m\u1ed9t chu\u1ed7i duy nh\u1ea5t. V\u00ed d\u1ee5: =CONCATENATE(“Hello “,”world”)<\/li>\n\n\n\n
  8. VLOOKUP:<\/strong> T\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb trong m\u1ed9t b\u1ea3ng t\u00ednh v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng t\u1eeb c\u1ed9t kh\u00e1c trong b\u1ea3ng t\u00ednh \u0111\u00f3. V\u00ed d\u1ee5: =VLOOKUP(A1,B1:C10,2,FALSE)<\/li>\n\n\n\n
  9. HLOOKUP: <\/strong>T\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb trong m\u1ed9t b\u1ea3ng t\u00ednh v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng t\u1eeb h\u00e0ng kh\u00e1c trong b\u1ea3ng t\u00ednh \u0111\u00f3. V\u00ed d\u1ee5: =HLOOKUP(A1,A1:B10,2,FALSE)<\/li>\n\n\n\n
  10. INDEX: <\/strong>Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t \u00f4 trong m\u1ed9t b\u1ea3ng t\u00ednh, s\u1eed d\u1ee5ng ch\u1ec9 s\u1ed1 h\u00e0ng v\u00e0 c\u1ed9t. V\u00ed d\u1ee5: =INDEX(A1:C10,2,3)<\/li>\n\n\n\n
  11. MATCH: <\/strong>T\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb trong m\u1ed9t d\u00e3y c\u00e1c gi\u00e1 tr\u1ecb v\u00e0 tr\u1ea3 v\u1ec1 ch\u1ec9 s\u1ed1 c\u1ee7a gi\u00e1 tr\u1ecb \u0111\u00f3 trong d\u00e3y. V\u00ed d\u1ee5: =MATCH(A1,A1:A10,0)<\/li>\n\n\n\n
  12. ROUND:<\/strong> L\u00e0m tr\u00f2n m\u1ed9t s\u1ed1 \u0111\u1ebfn m\u1ed9t s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n c\u1ee5 th\u1ec3. V\u00ed d\u1ee5: =ROUND(A1,2)<\/li>\n\n\n\n
  13. TODAY:<\/strong> Tr\u1ea3 v\u1ec1 ng\u00e0y hi\u1ec7n t\u1ea1i theo \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng n\u0103m. V\u00ed d\u1ee5: =TODAY()<\/li>\n\n\n\n
  14. NOW:<\/strong> Tr\u1ea3 v\u1ec1 ng\u00e0y v\u00e0 gi\u1edd hi\u1ec7n t\u1ea1i theo \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng n\u0103m v\u00e0 gi\u1edd ph\u00fat gi\u00e2y. V\u00ed d\u1ee5: =NOW()<\/li>\n\n\n\n
  15. LEFT: <\/strong>Tr\u00edch xu\u1ea5t m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 t\u1eeb b\u00ean tr\u00e1i c\u1ee7a m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n. V\u00ed d\u1ee5: =LEFT(A1,5)<\/li>\n\n\n\n
  16. RIGHT: <\/strong>Tr\u00edch xu\u1ea5t m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 t\u1eeb b\u00ean ph\u1ea3i c\u1ee7a m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n. V\u00ed d\u1ee5: =RIGHT(A1,5)<\/li>\n\n\n\n
  17. MID:<\/strong> Tr\u00edch xu\u1ea5t m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 t\u1eeb v\u1ecb tr\u00ed b\u1ea5t k\u1ef3 c\u1ee7a m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n. V\u00ed d\u1ee5: =MID(A1,3,5)<\/li>\n\n\n\n
  18. LEN: <\/strong>Tr\u1ea3 v\u1ec1 s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 trong m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n. V\u00ed d\u1ee5: =LEN(A1)<\/li>\n\n\n\n
  19. TRIM:<\/strong> Lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng kh\u00f4ng c\u1ea7n thi\u1ebft t\u1eeb m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n. V\u00ed d\u1ee5: =TRIM(A1)<\/li>\n\n\n\n
  20. SUBSTITUTE:<\/strong> Thay th\u1ebf t\u1ea5t c\u1ea3 c\u00e1c xu\u1ea5t hi\u1ec7n c\u1ee7a m\u1ed9t chu\u1ed7i con trong m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n kh\u00e1c b\u1eb1ng m\u1ed9t chu\u1ed7i con kh\u00e1c. V\u00ed d\u1ee5: =SUBSTITUTE(A1,”apple”,”orange”)<\/li>\n\n\n\n
  21. PROPER:<\/strong> Chuy\u1ec3n \u0111\u1ed5i t\u1ea5t c\u1ea3 c\u00e1c ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean c\u1ee7a c\u00e1c t\u1eeb trong m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n th\u00e0nh ch\u1eef c\u00e1i in hoa v\u00e0 c\u00e1c ch\u1eef c\u00e1i kh\u00e1c th\u00e0nh ch\u1eef c\u00e1i th\u01b0\u1eddng. V\u00ed d\u1ee5: =PROPER(A1)<\/li>\n\n\n\n
  22. UPPER:<\/strong> Chuy\u1ec3n \u0111\u1ed5i t\u1ea5t c\u1ea3 c\u00e1c ch\u1eef c\u00e1i c\u1ee7a m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n th\u00e0nh ch\u1eef c\u00e1i in hoa. V\u00ed d\u1ee5: =UPPER(A1)<\/li>\n\n\n\n
  23. LOWER: <\/strong>Chuy\u1ec3n \u0111\u1ed5i t\u1ea5t c\u1ea3 c\u00e1c ch\u1eef c\u00e1i c\u1ee7a m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n th\u00e0nh ch\u1eef c\u00e1i th\u01b0\u1eddng. V\u00ed d\u1ee5: =LOWER(A1)<\/li>\n\n\n\n
  24. CONCAT:<\/strong> K\u1ebft h\u1ee3p hai ho\u1eb7c nhi\u1ec1u chu\u1ed7i v\u0103n b\u1ea3n th\u00e0nh m\u1ed9t chu\u1ed7i duy nh\u1ea5t, t\u01b0\u01a1ng t\u1ef1 nh\u01b0 CONCATENATE nh\u01b0ng c\u00f3 th\u1ec3 c\u00f3 nhi\u1ec1u h\u01a1n hai \u0111\u1ed1i s\u1ed1. V\u00ed d\u1ee5: =CONCAT(A1,” “,B1,” “,C1)<\/li>\n\n\n\n
  25. TEXTJOIN: <\/strong>K\u1ebft h\u1ee3p hai ho\u1eb7c nhi\u1ec1u chu\u1ed7i v\u0103n b\u1ea3n th\u00e0nh m\u1ed9t chu\u1ed7i duy nh\u1ea5t, t\u01b0\u01a1ng t\u1ef1 nh\u01b0 CONCAT nh\u01b0ng c\u00f3 th\u1ec3 c\u00f3 nhi\u1ec1u h\u01a1n hai \u0111\u1ed1i s\u1ed1 v\u00e0 c\u00f3 th\u1ec3 ch\u1ec9 \u0111\u1ecbnh k\u00fd t\u1ef1 ng\u0103n c\u00e1ch gi\u1eefa c\u00e1c chu\u1ed7i \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p. V\u00ed d\u1ee5: =TEXTJOIN(“, “,TRUE,A1:C1)<\/li>\n\n\n\n
  26. RAND: <\/strong>Tr\u1ea3 v\u1ec1 m\u1ed9t s\u1ed1 ng\u1eabu nhi\u00ean trong kho\u1ea3ng t\u1eeb 0 \u0111\u1ebfn 1. V\u00ed d\u1ee5: =RAND()<\/li>\n\n\n\n
  27. RANDBETWEEN:<\/strong> Tr\u1ea3 v\u1ec1 m\u1ed9t s\u1ed1 ng\u1eabu nhi\u00ean trong kho\u1ea3ng t\u1eeb hai s\u1ed1 \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh. V\u00ed d\u1ee5: =RANDBETWEEN(1,100)<\/li>\n\n\n\n
  28. COUNTIF:<\/strong> \u0110\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 trong m\u1ed9t d\u00e3y c\u00e1c \u00f4 th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh. V\u00ed d\u1ee5: =COUNTIF(A1:A10,”>10″)<\/li>\n\n\n\n
  29. SUMIF:<\/strong> T\u00ednh t\u1ed5ng c\u00e1c \u00f4 trong m\u1ed9t d\u00e3y c\u00e1c \u00f4 th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh. V\u00ed d\u1ee5: =SUMIF(A1:A10,”>10″)<\/li>\n\n\n\n
  30. AVERAGEIF:<\/strong> T\u00ednh trung b\u00ecnh c\u1ed9ng c\u00e1c \u00f4 trong m\u1ed9t d\u00e3y c\u00e1c \u00f4 th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh. V\u00ed d\u1ee5: =AVERAGEIF(A1:A10,”>10″)<\/li>\n\n\n\n
  31. COUNTIFS:<\/strong> \u0110\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 trong m\u1ed9t d\u00e3y c\u00e1c \u00f4 th\u1ecfa m\u00e3n nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh. V\u00ed d\u1ee5: =COUNTIFS(A1:A10,”>10″,B1:B10,”<20″)<\/li>\n\n\n\n
  32. SUMIFS:<\/strong> T\u00ednh t\u1ed5ng c\u00e1c \u00f4 trong m\u1ed9t d\u00e3y c\u00e1c \u00f4 th\u1ecfa m\u00e3n nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh. V\u00ed d\u1ee5: =SUMIFS(A1:A10,”>10″,B1:B10,”<20″)<\/li>\n\n\n\n
  33. AVERAGEIFS: <\/strong>T\u00ednh trung b\u00ecnh c\u1ed9ng c\u00e1c \u00f4 trong m\u1ed9t d\u00e3y c\u00e1c \u00f4 th\u1ecfa m\u00e3n nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh. V\u00ed d\u1ee5: =AVERAGEIFS(A1:A10,”>10″,B1:B10,”<20″)<\/li>\n\n\n\n
  34. IFERROR: <\/strong>Ki\u1ec3m tra xem c\u00f4ng th\u1ee9c c\u00f3 l\u1ed7i hay kh\u00f4ng v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 kh\u00e1c n\u1ebfu c\u00f3 l\u1ed7i. V\u00ed d\u1ee5: =IFERROR(1\/0,”Kh\u00f4ng th\u1ec3 chia cho 0″)<\/li>\n\n\n\n
  35. ROUNDUP:<\/strong> L\u00e0m tr\u00f2n m\u1ed9t s\u1ed1 l\u00ean \u0111\u1ebfn s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t ho\u1eb7c l\u1edbn h\u01a1n nh\u01b0 \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh. V\u00ed d\u1ee5: =ROUNDUP(A1,0)<\/li>\n\n\n\n
  36. ROUNDDOWN:<\/strong> L\u00e0m tr\u00f2n m\u1ed9t s\u1ed1 xu\u1ed1ng \u0111\u1ebfn s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t ho\u1eb7c nh\u1ecf h\u01a1n nh\u01b0 \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh. V\u00ed d\u1ee5: =ROUNDDOWN(A1,0)<\/li>\n\n\n\n
  37. CEILING.MATH:<\/strong> L\u00e0m tr\u00f2n m\u1ed9t s\u1ed1 l\u00ean \u0111\u1ebfn s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t ho\u1eb7c l\u1edbn h\u01a1n nh\u01b0 \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh, theo c\u00e1ch t\u00ednh to\u00e1n \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh (v\u1edbi Excel 2016 tr\u1edf l\u00ean). V\u00ed d\u1ee5: =CEILING.MATH(A1,5)<\/li>\n\n\n\n
  38. FLOOR.MATH: <\/strong>L\u00e0m tr\u00f2n m\u1ed9t s\u1ed1 xu\u1ed1ng \u0111\u1ebfn s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t ho\u1eb7c nh\u1ecf h\u01a1n nh\u01b0 \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh, theo c\u00e1ch t\u00ednh to\u00e1n \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh (v\u1edbi Excel 2016 tr\u1edf l\u00ean). V\u00ed d\u1ee5: =FLOOR.MATH(A1,5)<\/li>\n\n\n\n
  39. DATEVALUE:<\/strong> Chuy\u1ec3n \u0111\u1ed5i m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n th\u00e0nh ng\u00e0y (v\u1edbi \u0111\u1ecbnh d\u1ea1ng ng\u00e0y\/th\u00e1ng\/n\u0103m). V\u00ed d\u1ee5: =DATEVALUE(“25\/08\/2023”)<\/li>\n\n\n\n
  40. EOMONTH:<\/strong> Tr\u1ea3 v\u1ec1 ng\u00e0y cu\u1ed1i c\u00f9ng c\u1ee7a th\u00e1ng cho ng\u00e0y \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh (v\u1edbi Excel 2010 tr\u1edf l\u00ean). V\u00ed d\u1ee5: =EOMONTH(A1,0)<\/li>\n\n\n\n
  41. NETWORKDAYS.INTL: <\/strong>Tr\u1ea3 v\u1ec1 s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c gi\u1eefa hai ng\u00e0y \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh (v\u1edbi Excel 2010 tr\u1edf l\u00ean). C\u00f3 th\u1ec3 ch\u1ec9 \u0111\u1ecbnh lo\u1ea1i l\u1ecbch l\u00e0m vi\u1ec7c (v\u00ed d\u1ee5 nh\u01b0 lo\u1ea1i l\u1ecbch l\u00e0m vi\u1ec7c M\u1ef9 ho\u1eb7c lo\u1ea1i l\u1ecbch l\u00e0m vi\u1ec7c ch\u00e2u \u00c2u). V\u00ed d\u1ee5: =NETWORKDAYS.INTL(A1,B1,”0000000″)<\/li>\n\n\n\n
  42. WORKDAY.INTL:<\/strong> Tr\u1ea3 v\u1ec1 ng\u00e0y l\u00e0m vi\u1ec7c ti\u1ebfp theo sau m\u1ed9t s\u1ed1 ng\u00e0y \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh (v\u1edbi Excel 2010 tr\u1edf l\u00ean). C\u00f3 th\u1ec3 ch\u1ec9 \u0111\u1ecbnh lo\u1ea1i l\u1ecbch l\u00e0m vi\u1ec7c (v\u00ed d\u1ee5 nh\u01b0 lo\u1ea1i l\u1ecbch l\u00e0m vi\u1ec7c M\u1ef9 ho\u1eb7c lo\u1ea1i l\u1ecbch l\u00e0m vi\u1ec7c ch\u00e2u \u00c2u). V\u00ed d\u1ee5: =WORKDAY.INTL(A1,5,”0000000″)<\/li>\n\n\n\n
  43. PMT: <\/strong>T\u00ednh to\u00e1n kho\u1ea3n thanh to\u00e1n h\u00e0ng th\u00e1ng cho m\u1ed9t kho\u1ea3n vay c\u00f3 l\u00e3i su\u1ea5t c\u1ed1 \u0111\u1ecbnh v\u00e0 s\u1ed1 ti\u1ec1n \u0111\u01b0\u1ee3c vay (v\u1edbi Excel 2007 tr\u1edf l\u00ean). V\u00ed d\u1ee5: =PMT(0.05\/12,60,10000)<\/li>\n\n\n\n
  44. FV:<\/strong> T\u00ednh to\u00e1n gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai c\u1ee7a kho\u1ea3n ti\u1ec1n g\u1eedi ban \u0111\u1ea7u khi bi\u1ebft l\u00e3i su\u1ea5t h\u00e0ng n\u0103m v\u00e0 s\u1ed1 n\u0103m g\u1eedi ti\u1ec1n (v\u1edbi Excel 2007 tr\u1edf l\u00ean). V\u00ed d\u1ee5: =FV(0.05\/12,60,-100,-10000)<\/li>\n\n\n\n
  45. PV: <\/strong>T\u00ednh to\u00e1n gi\u00e1 tr\u1ecb hi\u1ec7n t\u1ea1i c\u1ee7a kho\u1ea3n ti\u1ec1n t\u01b0\u01a1ng lai khi bi\u1ebft l\u00e3i su\u1ea5t h\u00e0ng n\u0103m v\u00e0 s\u1ed1 n\u0103m \u0111\u1ec3 t\u1edbi h\u1ea1n thanh to\u00e1n (v\u1edbi Excel 2007 tr\u1edf l\u00ean). V\u00ed d\u1ee5: =PV(0.05\/12,60,-100,-10000)<\/li>\n\n\n\n
  46. NPV:<\/strong> T\u00ednh to\u00e1n gi\u00e1 tr\u1ecb hi\u1ec7n t\u1ea1i net c\u1ee7a c\u00e1c lu\u1ed3ng ti\u1ec1n khi bi\u1ebft t\u1ef7 su\u1ea5t chi\u1ebft kh\u1ea5u (v\u1edbi Excel 2007 tr\u1edf l\u00ean). V\u00ed d\u1ee5: =NPV(0.05,A1:A10)<\/li>\n\n\n\n
  47. IRR:<\/strong> T\u00ecm t\u1ef7 su\u1ea5t sinh l\u1eddi n\u1ed9i b\u1ed9 c\u1ee7a c\u00e1c lu\u1ed3ng ti\u1ec1n khi bi\u1ebft c\u00e1c gi\u00e1 tr\u1ecb c\u1ee7a ch\u00fang (v\u1edbi Excel 2007 tr\u1edf l\u00ean). V\u00ed d\u1ee5: =IRR(A1:A10)<\/li>\n\n\n\n
  48. XNPV:<\/strong> T\u00ednh to\u00e1n gi\u00e1 tr\u1ecb hi\u1ec7n t\u1ea1i net c\u1ee7a c\u00e1c lu\u1ed3ng ti\u1ec1n khi bi\u1ebft t\u1ef7 su\u1ea5t chi\u1ebft kh\u1ea5u kh\u00f4ng \u0111\u1ed3ng nh\u1ea5t (v\u1edbi Excel 2010 tr\u1edf l\u00ean). V\u00ed d\u1ee5:=XNPV(0.05,A1:A10,B1:B10)<\/li>\n\n\n\n
  49. XIRR: <\/strong>T\u00ecm t\u1ef7 su\u1ea5t sinh l\u1eddi n\u1ed9i b\u1ed9 c\u1ee7a c\u00e1c lu\u1ed3ng ti\u1ec1n khi bi\u1ebft t\u1ef7 su\u1ea5t chi\u1ebft kh\u1ea5u kh\u00f4ng \u0111\u1ed3ng nh\u1ea5t (v\u1edbi Excel 2010 tr\u1edf l\u00ean). V\u00ed d\u1ee5:=XIRR(A1:A10,B1:B10)<\/li>\n<\/ol>\n\n\n\n

    50. LARGE:<\/strong> T\u00ecm ra gi\u00e1 tr\u1ecb l\u1edbn th\u1ee9 k trong danh s\u00e1ch \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh (v\u1edbi k l\u00e0 m\u1ed9t con s\u1ed1).Vd:=LARGE(A1:A10,3) s\u1ebd t\u00ecm ra gi\u00e1 tr\u1ecb l\u1edbn th\u1ee9 3 trong danh s\u00e1ch A1:A10<\/p>\n","protected":false},"excerpt":{"rendered":"

    D\u01b0\u1edbi \u0111\u00e2y l\u00e0 50 c\u00fa ph\u00e1p th\u01b0\u1eddng d\u00f9ng trong Excel: 50. LARGE: T\u00ecm ra gi\u00e1 tr\u1ecb l\u1edbn th\u1ee9 k trong danh s\u00e1ch \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh […]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":776,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-806","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kien-thuc-excel"],"_links":{"self":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/806","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/comments?post=806"}],"version-history":[{"count":1,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/806\/revisions"}],"predecessor-version":[{"id":807,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/806\/revisions\/807"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/media\/776"}],"wp:attachment":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/media?parent=806"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/categories?post=806"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/tags?post=806"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}