¿¢¼¿ ÇÔ¼ö ÃÑÁ¤¸® 2007


¿¢¼¿ ÇÔ¼ö ¸ðÀ½ À¸·Î ¸ðµç ÇÔ¼ö¸¦ ¸ð¾Æ³õÀº °ÀÇ´Â ¾ËÁö¿À R&D [¿ÀÇǽº]ÆÀ¿¡¼ Á÷Á¢ °³¹ßµÈ ¿¢¼¿ ÇÔ¼ö ÃÑÁ¤¸® ÇÑ Àü¹®°ÀÇ·Î ¿¢¼¿¿¡¼ »ç¿ëµÇ´Â ¸ðµç ÇÔ¼öµé¿¡ ´ëÇØ¼ ÃÑÁ¤¸® ¸¦ ÇÑ °ÁÂÀÔ´Ï´Ù. ÇØ´ç °ÀǸ¦ ¼ö°ÇÏ½Ã¸é ¿¢¼¿ ÇÔ¼ö ¸ðÀ½ ÀÇ ½Ç½À¿¹Á¦¸¦ ÅëÇØ ¿¢¼¿ ÇÔ¼ö¸¦ ½Ç¹«¿¡¼ Ȱ¿ëÇÒ ¼ö ÀÖ´Â ¼öÁرîÁö ¸¶½ºÅÍÇÏ½Ç ¼ö ÀÖ½À´Ï´Ù.
-
01.15ºÐ ¼öÇÐÇÔ¼ö 1
POWER,EXP,SUM
Ã¥°¥ÇÇ[00:00] ÇÔ¼ö°ÀÇ ¼Ò°³/[02:02] POWER/[03:53] ¿¬»êÀÚ ^/[04:57] EXPÇÔ¼ö/[07:12] SUMÇÔ¼ö(ÀÚµ¿ÇÕ°è ÀÔ·Â)/[08:00] µµ¿ò¸» »ç¿ë¹ý/[08:42] ¿¹Á¦ º¹»çÇØ¼ »ç¿ëÇÏ´Â ¹æ¹ý/[11:08] ÇÔ¼ö¸¶¹ý»ç »ç¿ë¹æ¹ý -
02.15ºÐ ¼öÇÐÇÔ¼ö 2
SUMIF,SUMIFS,SUMPRODUCT
Ã¥°¥ÇÇ[00:02] SUMIFÇÔ¼ö/[05:08] SUMIFSÇÔ¼ö/[07:30] SUMPRODUCT -
03.16ºÐ ¼öÇÐÇÔ¼ö 3
SUMSQ,QUOTIENT,RAND,MOD,SUBTOTAL
Ã¥°¥ÇÇ[00:10] SUMSQÇÔ¼ö/[02:17] QUOTIENT, MODÇÔ¼ö/[05:26] RAND, RANDBETWEENÇÔ¼ö/[08:07] SUBTOTALÇÔ¼ö -
04.21ºÐ ¼öÇÐÇÔ¼ö 4
TRUNC,ROUNDDOWN,INT,ROUNTUP,ROUND,MROUND
Ã¥°¥ÇÇ[00:47] TRUNCÇÔ¼ö/[05:23] ROUNDDOWNÇÔ¼ö/[06:14] INT,TRUNCÇÔ¼ö ºñ±³/[09:53] ROUNDUPÇÔ¼ö/[13:34] ROUNDÇÔ¼ö/[16:24] MROUNDÇÔ¼ö -
05.20ºÐ ¼öÇÐÇÔ¼ö 5
FLOOR,CEILING,EVEN,ODD,FACT,SQRT,PI,GCD,LCM
Ã¥°¥ÇÇ[00:01] FLOOKR,CEILINGÇÔ¼ö/[05:31] EVEN,ODDÇÔ¼ö/[07:33] FACTÇÔ¼ö/[09:38] SQRTÇÔ¼ö/[12:06] PIÇÔ¼ö/[12:30] COMBINÇÔ¼ö/[16:01] GCDÇÔ¼ö/[17:57] LCMÇÔ¼ö -
06.15ºÐ Åë°èÇÔ¼ö1
COUNT,RANK,QUARTILE
Ã¥°¥ÇÇ[00:46] COUNTÇÔ¼ö/[02:15] COUNTAÇÔ¼ö/[02:47] COUNTBLANKÇÔ¼ö/[03:23] COUNTIFÇÔ¼ö/[06:10] RANKÇÔ¼ö/[09:31] PERCENTRANKÇÔ¼ö/[12:04] QUARTILEÇÔ¼ö/[13:10] PERCENTILE -
07.23ºÐ Åë°èÇÔ¼ö2
LARGE,SMALL,MAX,MIN,AVERAGE
Ã¥°¥ÇÇ[00:18] LARGEÇÔ¼ö/[02:38] SMALLÇÔ¼ö/[03:31] MEDIANÇÔ¼ö/[07:01] MAXÇÔ¼ö/[09:22] MINÇÔ¼ö/[10:34] MAXAÇÔ¼ö/[11:19] MINAÇÔ¼ö/[12:45] AVERAGEÇÔ¼ö/[15:53] AVERAGEAÇÔ¼ö/[19:42] TRIMMEANÇÔ¼ö/[22:24] GEOMEANÇÔ¼ö -
08.25ºÐ ³¯Â¥ ½Ã°£ ÇÔ¼ö
YEAR,MONTH,DAY,EDATE,WORKDAY,TIME,DATEDIF
Ã¥°¥ÇÇ[01:28] YEARÇÔ¼ö/[02:28] MONTHÇÔ¼ö/[02:49] DAYÇÔ¼ö/[03:22] EDATEÇÔ¼ö/[06:29] EOMONTHÇÔ¼ö/[07:46] WORKDAYÇÔ¼ö/[10:07] DATEÇÔ¼ö/[14:30] TIME/[16:20] DATEDIFÇÔ¼ö -
09.19ºÐ ³¯Â¥ ½Ã°£ ÇÔ¼ö
DAYS360,NETWORKDAYS,YEARFRAC,WEEKNUM,TODAY,NOW
Ã¥°¥ÇÇ[00:11] DAYS360ÇÔ¼ö/[05:42] NETWORKDAYSÇÔ¼ö/[07:45] YEARFRACÇÔ¼ö/[11:52] WEEKNUMÇÔ¼ö/[17:09] TODAYÇÔ¼ö/[17:20] NOWÇÔ¼ö -
10.13ºÐ ³í¸®ÇÔ¼ö
IF,AND,OR
Ã¥°¥ÇÇ[00:09] IFÇÔ¼ö/[05:22] ANDÇÔ¼ö/[08:02] ORÇÔ¼ö -
11.26ºÐ ã±â ÂüÁ¶ ÇÔ¼ö
INDEX.MATCH,VLOOKUP,HLOOKUP
Ã¥°¥ÇÇ[00:47] INDEXÇÔ¼ö/[03:46] MATCHÇÔ¼ö/[10:00] VLOOKUPÇÔ¼ö/[16:38] HLOOKUPÇÔ¼ö -
12.14ºÐ ã±â ÂüÁ¶ ÇÔ¼ö
CHOOSE,WEEKDAY,TRANSPOSE
Ã¥°¥ÇÇ[00:27] CHOOSEÇÔ¼ö/[08:05] WEEKDAYÇÔ¼ö/[10:04] TRANSPOSEÇÔ¼ö -
13.20ºÐ µ¥ÀÌÅͺ£À̽º ÇÔ¼ö
µ¥ÀÌÅͺ£À̽º ÇÔ¼ö »ç¿ëÇϱâ,AND,ORÁ¶°Ç ÁöÁ¤
Ã¥°¥ÇÇ[02:10] µ¥ÀÌÅͺ£À̽º ºÎºÐ ÁöÁ¤/[02:54] Çʵå ÁöÁ¤Çϱâ/[04:01] Á¶°ÇÁöÁ¤Çϱâ/[09:30] Á¶°Ç ÀÛ¼ºÇϱâ/[11:36] ANDÁ¶°Ç, ORÁ¶°Ç/[14:13] ³í¸®½ÄÀ¸·Î Á¶°ÇÀÛ¼ºÇϱâ -
14.19ºÐ µ¥ÀÌÅͺ£À̽º ÇÔ¼ö2
DGET,DCOUNT,DPRODUCT,DAVERAGE,DSUM,DMAX,DMIN
Ã¥°¥ÇÇ[00:40] DGETÇÔ¼ö/[04:27] DCOUNTÇÔ¼ö/[08:08] DCOUNTAÇÔ¼ö/[10:08] DPRODUCTÇÔ¼ö/[11:06] DAVERAGEÇÔ¼ö/[13:31] DSUMÇÔ¼ö/[16:16] DMAXÇÔ¼ö/[17:10] DMINÇÔ¼ö -
15.13ºÐ Á¤º¸ÇÔ¼ö
ISTEXT,ISNUMBER,ISLOGICAL,ISREF,ISBLANK,ISERROR,ISNA
Ã¥°¥ÇÇ[00:14] ISTEXTÇÔ¼ö/[01:32] ISNONTEXTÇÔ¼ö/[01:58] ISNUMBERÇÔ¼ö/[04:47] ISLOGICALÇÔ¼ö/[06:10] ISREFÇÔ¼ö/[07:12] ISBLANKÇÔ¼ö/[07:33] ISERROR, ISERR ºñ±³/[08:52] ISNA/[10:00] Á¤º¸ÇÔ¼ö ÀÀ¿ëÇϱâ -
16.15ºÐ Á¤º¸ÇÔ¼ö2
ISODD,ISEVEN,TYPE,ERROR.TYPE,CELL,INFO
Ã¥°¥ÇÇ[00:23] ISODDÇÔ¼ö/[00:42] ISEVENÇÔ¼ö/[02:17] TYPEÇÔ¼ö/[06:10] ERROR.TYPEÇÔ¼ö/[07:17] CELLÇÔ¼ö/[10:58] INFOÇÔ¼ö -
17.19ºÐ À繫ÇÔ¼ö
SLN,DB,FV,FVSCHEDULE
Ã¥°¥ÇÇ[00:24] SLNÇÔ¼ö/[04:10] DBÇÔ¼ö/[09:53] FVÇÔ¼ö/[17:39] FVSCHEDULEÇÔ¼ö -
18.22ºÐ À繫ÇÔ¼ö2
PMT,PPMT,IPMT,ISPMT,NPER,PV,NPV,XNPV
Ã¥°¥ÇÇ[01:33] PMTÇÔ¼ö/[06:08] PPMTÇÔ¼ö/[07:33] IPMTÇÔ¼ö/[09:07] ISPMTÇÔ¼ö/[12:35] CUMPRINCÇÔ¼ö/[14:14] CUMIPMTÇÔ¼ö/[15:40] NPERÇÔ¼ö/[17:25] PVÇÔ¼ö/[19:12] NPVÇÔ¼ö/[20:53] XNPVÇÔ¼ö -
19.27ºÐ ÅØ½ºÆ® ÇÔ¼ö
LEFT,RIGHT,MID,FIND,SEARCH,EXACT,FIXED
Ã¥°¥ÇÇ[00:35] LEFTÇÔ¼ö/[01:25] RIGHTÇÔ¼ö/[01:54] MIDÇÔ¼ö/[06:14] FINDÇÔ¼ö/[11:05] SEARCHÇÔ¼ö/[15:47] SEARCHÇÔ¼ö ÀÀ¿ëÇϱâ/[19:25] EXACTÇÔ¼ö/[23:26] FIXEDÇÔ¼ö -
20.- ÅØ½ºÆ® ÇÔ¼ö2
TEXT,DOLLAR,WON,JUNJA,ASC,REPLACE,SUBSTITUTE,REPT
Ã¥°¥ÇÇ[00:28] TEXTÇÔ¼ö/[04:40] DOLLARÇÔ¼ö/[04:59] WONÇÔ¼ö/[05:43] JUNJAÇÔ¼ö/[07:14] ASCÇÔ¼ö/[08:59] REPLACEÇÔ¼ö/[13:44] SUBSTITUTE/[16:03] REPTÇÔ¼ö
-
¿¢¼¿2007¿¢¼¿2007 Àΰ Æò»ý±³À°¿ø ±³À° ¾È³» ¾ËÁö¿À R&D [¿ÀÇǽº]ÆÀ¿¡ ÀÇÇØ ¿¬±¸°³¹ßµÈ ÀڷḦ Åä´ë·Î ¸¸µé¾îÁø °ÀÇÀÔ´Ï´Ù.ÇнÀ±â°£ : 2°³¿ù/°ÀǼö : 20°/ÁøÇà½Ã°£ : 8½Ã°£ 56ºÐ/¼ö°·á :
140,000¿ø85,000¿ø -
¿¢¼¿ÇÔ¼ö ±âÃÊ+½Ç¹« v2016¿¢¼¿ÇÔ¼ö ±âÃÊ+½Ç¹« v2016 Àΰ Æò»ý±³À°¿ø ±³À° ¾È³» ¿¢¼¿ÇÔ¼ö ±âÃÊ+½Ç¹« v2016 °ÀÇ´Â ¾ËÁö¿À R&D [¿ÀÇǽº]ÆÀ¿¡¼ Á÷Á¢ °³¹ßµÈ °ÀÇ·Î ¿¢¼¿¿¡¼ »ç¿ëµÇ´Â ¸ðµç ÇÔ¼öµé¿¡ ´ëÇØ¼ ÃÑÁ¤¸® ¸¦ ÇÑ °ÁÂÀÔ´Ï´Ù. ÇØ´ç °ÀǸ¦ ¼ö°ÇÏ½Ã¸é ½Ç½À¿¹Á¦¸¦ ÅëÇØ ¿¢¼¿ ÇÔ¼ö ¸¦ ½Ç¹«¿¡¼ Ȱ¿ëÇÒ ¼ö ÀÖ´Â ¼öÁرîÁö ¸¶½ºÅÍÇÏ½Ç ¼ö ÀÖ½À´Ï´Ù.ÇнÀ±â°£ : 2°³¿ù/°ÀǼö : 24°/ÁøÇà½Ã°£ : 22½Ã°£ 4ºÐ/¼ö°·á :
420,000¿ø255,000¿ø -
¿¢¼¿ VBA 2013 [½Ç¹«]¿¢¼¿ VBA 2013 Àΰ Æò»ý±³À°¿ø ±³À° ¾È³» ¿¢¼¿ VBA °ÀÇ´Â ¾ËÁö¿À R&D [¿ÀÇǽº]ÆÀ¿¡¼ Á÷Á¢ °³¹ßµÈ °ÀÇ·Î ¿¢¼¿ VBA 2013 ¿¡ ´ëÇØ¼ ±âº»ÄÚµåÀÇ ÀÌÇØºÎÅÍ ½Ç¹« ÇÁ·Î±×·¡¹Ö±îÁö ÃÑÁ¤¸®µÇ¾úÀ¸¸ç, VBE ½Ç¹«¿¡¼ ¹Ù·Î Ȱ¿ëÇÒ ¼ö ÀÖ´Â ¿¢¼¿ VBA½Ç½À ¿¹Á¦¸¦ ÅëÇØ º¸´Ù ¿Ïº®ÇÏ°Ô ¸¶½ºÅÍÇÏ½Ç ¼ö ÀÖ½À´Ï´Ù.ÇнÀ±â°£ : 2°³¿ù/°ÀǼö : 20°/ÁøÇà½Ã°£ : 12½Ã°£ 13ºÐ/¼ö°·á :
270,000¿ø165,000¿ø