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



¿¢¼¿ ÇÔ¼ö ÃÑÁ¤¸® 2003 Àΰ Æò»ý±³À°¿ø ±³À° ¾È³»
¿¢¼¿ ÇÔ¼ö ¸ðÀ½ À¸·Î ¸ðµç ÇÔ¼ö¸¦ ¸ð¾Æ³õÀº °ÀÇ´Â ¾ËÁö¿À R&D [¿ÀÇǽº]ÆÀ¿¡¼ Á÷Á¢ °³¹ßµÈ ¿¢¼¿ ÇÔ¼ö ÃÑÁ¤¸® ÇÑ Àü¹®°ÀÇ·Î ¿¢¼¿¿¡¼ »ç¿ëµÇ´Â ¸ðµç ÇÔ¼öµé¿¡ ´ëÇØ¼ ÃÑÁ¤¸® ¸¦ ÇÑ °ÁÂÀÔ´Ï´Ù. ÇØ´ç °ÀǸ¦ ¼ö°ÇÏ½Ã¸é ¿¢¼¿ ÇÔ¼ö ¸ðÀ½ ÀÇ ½Ç½À¿¹Á¦¸¦ ÅëÇØ ¿¢¼¿ ÇÔ¼ö¸¦ ½Ç¹«¿¡¼ Ȱ¿ëÇÒ ¼ö ÀÖ´Â ¼öÁرîÁö ¸¶½ºÅÍÇÏ½Ç ¼ö ÀÖ½À´Ï´Ù.
¿¢¼¿ ÇÔ¼ö ¸ðÀ½ À¸·Î ¸ðµç ÇÔ¼ö¸¦ ¸ð¾Æ³õÀº °ÀÇ´Â ¾ËÁö¿À R&D [¿ÀÇǽº]ÆÀ¿¡¼ Á÷Á¢ °³¹ßµÈ ¿¢¼¿ ÇÔ¼ö ÃÑÁ¤¸® ÇÑ Àü¹®°ÀÇ·Î ¿¢¼¿¿¡¼ »ç¿ëµÇ´Â ¸ðµç ÇÔ¼öµé¿¡ ´ëÇØ¼ ÃÑÁ¤¸® ¸¦ ÇÑ °ÁÂÀÔ´Ï´Ù. ÇØ´ç °ÀǸ¦ ¼ö°ÇÏ½Ã¸é ¿¢¼¿ ÇÔ¼ö ¸ðÀ½ ÀÇ ½Ç½À¿¹Á¦¸¦ ÅëÇØ ¿¢¼¿ ÇÔ¼ö¸¦ ½Ç¹«¿¡¼ Ȱ¿ëÇÒ ¼ö ÀÖ´Â ¼öÁرîÁö ¸¶½ºÅÍÇÏ½Ç ¼ö ÀÖ½À´Ï´Ù.
- ¼öÇÐ/»ï°¢
-
01.16ºÐ power, exp, sum, sumif, product, sumproduct ÇÔ¼ö
-
02.11ºÐ sumsq, quotient, mod, subtotal, rand, randbetween ÇÔ¼ö
-
03.12ºÐ trunc, rounddown, int, floor, ceiling ÇÔ¼ö
-
04.20ºÐ roundup, mround, even, odd, sqrt, fact, combin, gcd, lcm ÇÔ¼ö
- Åë°è
-
05.12ºÐ count, counta, countif, counfblank , rank, percentrank ÇÔ¼ö
-
06.13ºÐ quartile, percentile, large, small, median ÇÔ¼ö
-
07.14ºÐ max, maxa, min, mina, mode, average, averagea, trimmean, geomean ÇÔ¼ö
- ³¯Â¥/½Ã°£
-
08.12ºÐ year, month, day, edate, eomonth, workday ÇÔ¼ö
-
09.19ºÐ date, time, datedif, days, networkdays, yearfrac, neeknum, today, now ÇÔ¼ö
- ³í¸®/ã±â/ÂüÁ¶¿µ¿ª
-
10.11ºÐ if, and, or, index ÇÔ¼ö
-
11.14ºÐ vlookup, hlookup, choose, match, transposeÇÔ¼ö
- µ¥ÀÌÅͺ£À̽º
-
12.15ºÐ dget, dcount, dcounta, dproduct, daverage, dsum, dmax, dmin ÇÔ¼ö
-
13.13ºÐ istext, isnotext, isnumber, iserror, iseven, isodd, type ÇÔ¼ö
- À繫
-
14.21ºÐ sln, db, fv, fvschedule, pmt, ppmt, ipmt ÇÔ¼ö
-
15.19ºÐ ispmt, cumipmt, cumprinc, nper, pv, npv, xnpv ÇÔ¼ö
- ÅØ½ºÆ®
-
16.13ºÐ find, search, left, mid, right ÇÔ¼ö
-
17.16ºÐ exact, concatenate, fixed, text, dollar, junja, asc, replace, replaceb, substitute, rept ÇÔ¼ö
-
¿¢¼¿2003¿¢¼¿2003 Àΰ Æò»ý±³À°¿ø ±³À° ¾È³» ¾ËÁö¿À R&D [¿ÀÇǽº]ÆÀ¿¡ ÀÇÇØ ¿¬±¸°³¹ßµÈ ÀڷḦ Åä´ë·Î ¸¸µé¾îÁø °ÀÇÀÔ´Ï´Ù.ÇнÀ±â°£ : 2°³¿ù/°ÀǼö : 33°/ÁøÇà½Ã°£ : 9½Ã°£ 0ºÐ/¼ö°·á :
100,000¿ø65,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¿ø