HOME>¿ÀÇǽº / ÀÚ°ÝÁõ>¿¢¼¿ÇÔ¼ö | ¿¢¼¿VBA>¿¢¼¿ ÇÔ¼ö ÃÑÁ¤¸® 2007
¾ËÁö¿À ÆÐŰÁö

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

¿¢¼¿ ÇÔ¼ö ÃÑÁ¤¸® 2007
20ȸÂ÷ ¼Ó¼º°úÁ¤
Àüü : 5½Ã°£ 57ºÐ|ȸÂ÷´ç Æò±Õ : 17ºÐ51ÃÊ

ÀÌ¿ë±â°£ 2°³¿ù

Àü¹®°­»ç : ¾ËÁö¿À R&D [¿ÀÇǽº]

140,000¿ø85,000¿ø
¿¢¼¿ ÇÔ¼ö ÃÑÁ¤¸® 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ÇÔ¼ö


¾ËÁö¿À ÆÐŰÁö