¿¢¼¿ÇÔ¼ö ±âÃÊ+½Ç¹« v2016





¿¢¼¿ÇÔ¼ö ±âÃÊ+½Ç¹« v2016 °ÀÇ´Â ¾ËÁö¿À R&D [¿ÀÇǽº]ÆÀ¿¡¼ Á÷Á¢ °³¹ßµÈ °ÀÇ·Î ¿¢¼¿¿¡¼ »ç¿ëµÇ´Â ¸ðµç ÇÔ¼öµé¿¡ ´ëÇØ¼ ÃÑÁ¤¸® ¸¦ ÇÑ °ÁÂÀÔ´Ï´Ù. ÇØ´ç °ÀǸ¦ ¼ö°ÇÏ½Ã¸é ½Ç½À¿¹Á¦¸¦ ÅëÇØ ¿¢¼¿ ÇÔ¼ö ¸¦ ½Ç¹«¿¡¼ Ȱ¿ëÇÒ ¼ö ÀÖ´Â ¼öÁرîÁö ¸¶½ºÅÍÇÏ½Ç ¼ö ÀÖ½À´Ï´Ù.
-
01.35ºÐ [¿Ïº® ¸¶½ºÅÍ] ¿¢¼¿ ÇÔ¼öÀÇ Vocabulary! - Chapter 1
À̸§Á¤ÀÇ, ¼ö½Ä¿¡¼ÀÇ È°¿ë, indirect, subtotal ÇÔ¼ö¿¡ ´ëÇØ ½Ç½ÀÇÕ´Ï´Ù.
Ã¥°¥ÇÇ[00:13] F3Ű /[05:54] ¼±Åÿµ¿ª¿¡¼ ¸¸µé±â/[10:17] ÇÊÅÍ/[15:04] count/countaÇÔ¼ö/[19:35] indirect/[24:54] µ¥ÀÌÅÍÀ¯È¿¼º°Ë»ç/[30:11] ÀÚµ¿Ã¤¿ì±âÇÚµé -
02.32ºÐ [¿Ïº® ¸¶½ºÅÍ] ¿¢¼¿ ÇÔ¼öÀÇ Vocabulary! - Chapter 2
¿¬°á¿¬»êÀÚ, F9, ³¯Â¥°ü·Ã ¿¬»êÀÚ, ³¯Â¥¿¡ °ü·ÃµÈ ÀÛ¾÷¿¡¼ÀÇ ÇÔ¼ö¸¦ ½Ç½ÀÇÕ´Ï´Ù.
Ã¥°¥ÇÇ[00:00] TODAY, NOW ÇÔ¼ö/[05:13] DATEDIF ÇÔ¼ö/[10:17] weekday/[18:23] EOMONTH ÇÔ¼ö/[28:13] networkdays -
03.43ºÐ [¿Ïº® ¸¶½ºÅÍ] ¿¢¼¿ ÇÔ¼öÀÇ Vocabulary! - Chapter 3
³í¸®ÇÔ¼ö¸¦ ÀÌ¿ëÇÏ¿© Ãâ±ÙºÎÀÛ¼º¿¡ ´ëÇØ ½Ç½ÀÇÕ´Ï´Ù.
Ã¥°¥ÇÇ[00:06] ifÇÔ¼ö/[04:49] ANDÇÔ¼ö/[10:49] °³¹ßµµ±¸ÅÇ/[17:03] ¼¿¼½Ä/[24:53] ISERROR/[28:15] ½ºÇÉ´ÜÃß/[30:27] datevalueÇÔ¼ö/[36:14] ¼±½ºÅ¸ÀÏ -
04.40ºÐ [¿Ïº® ¸¶½ºÅÍ] ¿¢¼¿ ÇÔ¼öÀÇ Vocabulary! - Chapter 4
ÅØ½ºÆ®ÇÔ¼öÀÇ Á¾·ù¸¦ ÆÄ¾ÇÇϰí, ½Ç¹«¿¹Á¦¸¦ Ȱ¿ëÇÏ¿© ½Ç½ÀÇÕ´Ï´Ù.
Ã¥°¥ÇÇ[00:00] TEXTÇÔ¼ö/[05:38] CLEANÇÔ¼ö/[10:11] ´õºí¹ÙÀÌÆ®·Î ÃàÃâ/[16:13] VALUEÇÔ¼ö/[22:06] JUNJAÇÔ¼ö/[29:13] MIDÇÔ¼ö/[36:13] REPLACEÇÔ¼ö/[39:33] REPTÇÔ¼ö -
05.39ºÐ [¿Ïº® ¸¶½ºÅÍ] ¿¢¼¿ ÇÔ¼öÀÇ Vocabulary! - Chapter 5
°øÇÐÇÔ¼ö¿Í ¼öÇÐ ÇÔ¼ö¿¡ ´ëÇØ ¹è¿ì°í ¿¹Á¦¸¦ ÅëÇØ ½ÉµµÀÖ°Ô ¹è¿öº¾´Ï´Ù.
Ã¥°¥ÇÇ[00:05] EXACTÇÔ¼ö/[04:19] FINDÇÔ¼ö/[10:08] LENÇÔ¼ö/[15:08] DOLLARÇÔ¼ö/[22:33] LEFTÇÔ¼ö/[30:40] µ¥ÀÌÅÍÀ¯È¿¼º°Ë»ç/[34:43] CODE -
06.47ºÐ [¿Ïº® ¸¶½ºÅÍ] ¿¢¼¿ ÇÔ¼öÀÇ Vocabulary! - Chapter 6
vlookup,hlookup ÇÔ¼ö¿¡ ´ëÇØ °øºÎÇϰí, ½Ç¹«¿¡¼ Ȱ¿ë °¡´ÉÇÑ ´Ù¾çÇÑ ¿¹Á¦¸¦ Ȱ¿ëÇÏ¿© °øºÎÇÕ´Ï´Ù.
Ã¥°¥ÇÇ[00:00] LOOKUP, VLOOKUP, HLOOKUP ÇÔ¼ö/[08:31] CHOOSE ÇÔ¼ö/[13:28] if+iserror/[16:47] ÂüÁ¶ ÇÔ¼ö, ³í¸® ÇÔ¼ö ½Ç½À1(°Å·¡¸í¼¼Ç¥)/[21:00] Á¦Ç° Äڵ忡 µû¸¥ Á¦Ç°¸í °¡Á®¿À±â/[29:19] Á¦Ç° Äڵ忡 µû¸¥ ´Ü°¡ ±¸Çϱâ/[33:42] Á¦Ç° ÇÒÀÎÀ² °¡Á®¿À±â/[39:10] ±Ý¾× ±¸Çϱâ/[43:52] À̸§ Á¤ÀÇ -
07.33ºÐ [¿Ïº® ¸¶½ºÅÍ] ¿¢¼¿ ÇÔ¼öÀÇ Vocabulary! - Chapter 7
match, index, OFFSET ÇÔ¼ö¿¡ ´ëÇØ °øºÎÇϰí, ½Ç¹«¿¡¼ Ȱ¿ë °¡´ÉÇÑ ´Ù¾çÇÑ ¿¹Á¦¸¦ Ȱ¿ëÇÏ¿© °øºÎÇÕ´Ï´Ù.
Ã¥°¥ÇÇ[00:57] MATCH ÇÔ¼ö/[05:19] INDEX ÇÔ¼ö/[09:32] OFFSET ÇÔ¼ö/[12:50] ¿Àüü¿Í ÇàÀüü ¹üÀ§/[14:46] ÂüÁ¶ ÇÔ¼ö ½Ç½À1(ÆÇ¸ÅÇöȲºÐ¼®)/[20:16] ÂüÁ¶ ÇÔ¼ö ½Ç½À2(°áÁ¦ÇöȲºÐ¼®)/[28:11] ÂüÁ¶ ÇÔ¼ö ½Ç½À3(±Þ¿©´ëÀå) -
08.37ºÐ [¿Ïº® ¸¶½ºÅÍ] ¿¢¼¿ ÇÔ¼öÀÇ Vocabulary! - Chapter 8
address, areas, rows, columns, getpivotdata, hyperlink, transpose ÇÔ¼ö¿¡ ´ëÇØ °øºÎÇϰí, ½Ç¹«¿¡¼ Ȱ¿ë °¡´ÉÇÑ ´Ù¾çÇÑ ¿¹Á¦¸¦ Ȱ¿ëÇÏ¿© °øºÎÇÕ´Ï´Ù.
Ã¥°¥ÇÇ[00:01] ADDRESS ÇÔ¼ö/[02:50] AREAS ÇÔ¼ö/[03:48] rows, columns ÇÔ¼ö/[04:43] GETPIVOTDATA ÇÔ¼ö/[06:48] HYPERLINK ÇÔ¼ö/[08:35] TRANSPOSE ÇÔ¼ö/[09:21] ÂüÁ¶ ÇÔ¼ö ½Ç½À1(PartList)/[15:27] ÂüÁ¶ ÇÔ¼ö ½Ç½À2(ÇǹþÅ×ÀÌºí ºÐ¼®)/[20:15] ÂüÁ¶ ÇÔ¼ö ½Ç½À3(°Å·¡¸í¼¼Ç¥)/[22:56] ÂüÁ¶ ÇÔ¼ö ½Ç½À4(ÄÞº¸»óÀÚÀ̹ÌÁöº¯È¯)/[26:58] µ¥ÀÌÅÍ À¯È¿¼º °Ë»ç -
09.36ºÐ [¿Ïº® ¸¶½ºÅÍ] ¿¢¼¿ ÇÔ¼öÀÇ Vocabulary! - Chapter 9
¼öÇÐÇÔ¼öÀÇ Á¾·ù¸¦ ¾Ë¾Æº¸°í, ½Ç¹«¿¡¼ Ȱ¿ë °¡´ÉÇÑ ´Ù¾çÇÑ ¿¹Á¦¸¦ Ȱ¿ëÇÏ¿© ½Ç½ÀÇÕ´Ï´Ù.
Ã¥°¥ÇÇ[00:00] ABS ÇÔ¼ö/[00:55] AGGREGATE ÇÔ¼ö/[04:06] CEILING ÇÔ¼ö/[05:16] ROUNDUP, ROUNDDOWN, ROUND ÇÔ¼ö/[08:24] TRUNC ÇÔ¼ö/[09:24] INT ÇÔ¼ö/[10:48] ÃÖ´ë°ø¾à¼ö(GCD)¿Í ÃÖ¼Ò°ø¹è¼ö(LCM)/[11:51] SUMIFS ÇÔ¼ö/[13:57] MOD, QUOTIENT ÇÔ¼ö/[14:50] LARGE, SMALL ÇÔ¼ö/[16:16] ¼öÇÐ ÇÔ¼ö ½Ç½À1(ÆÇ¸ÅÇöȲ)/[20:14] ¼öÇÐ ÇÔ¼ö ½Ç½À2(±âº»±Þ¿©´ëÀå)/[32:00] ¼öÇÐ ÇÔ¼ö ½Ç½À3(ÆÇ¸ÅÀ²ºÐ¼®) -
10.29ºÐ [¿Ïº® ¸¶½ºÅÍ] ¿¢¼¿ ÇÔ¼öÀÇ Vocabulary! - Chapter 10
Åë°èÇÔ¼öÀÇ Á¾·ù¸¦ ¾Ë¾Æº¸°í, ½Ç¹«¿¡¼ Ȱ¿ë °¡´ÉÇÑ ´Ù¾çÇÑ ¿¹Á¦¸¦ Ȱ¿ëÇÏ¿© ½Ç½ÀÇÕ´Ï´Ù.
Ã¥°¥ÇÇ[00:00] AVERAGE, GEOMEAN, HARMEAN ÇÔ¼ö/[02:36] VAR, VARP ÇÔ¼ö/[04:27] STDEV, STDEVP ÇÔ¼ö/[05:18] AVERAGEIFS ÇÔ¼ö/[06:45] MODE ÇÔ¼ö/[07:11] FREQUENCY ÇÔ¼ö/[08:56] MEDIAN ÇÔ¼ö/[09:19] MIN, MINA, MAX, MAXA ÇÔ¼ö/[11:58] VARA ÇÔ¼ö/[12:25] Åë°è ÇÔ¼ö ½Ç½À1(Àç°í·®ºÐ¼®)/[21:27] Åë°è ÇÔ¼ö ½Ç½À2(°áÁ¦³»¿ª)/[24:07] Åë°è ÇÔ¼ö ½Ç½À3(¹°Ç°¹ß¼Û¿¹Á¤Ç¥)/[25:27] Åë°è ÇÔ¼ö ½Ç½À4(Á¦Ç°°Ë»ç)/[27:58] Åë°è ÇÔ¼ö ½Ç½À5(¹ÝǰºÐ¼®) -
11.44ºÐ [¿Ïº® ¸¶½ºÅÍ] ¿¢¼¿ ÇÔ¼öÀÇ Vocabulary! - Chapter 11
Åë°èÇÔ¼öÀÇ Á¾·ù¸¦ ¾Ë¾Æº¸°í, ½Ç¹«¿¡¼ Ȱ¿ë °¡´ÉÇÑ ´Ù¾çÇÑ ¿¹Á¦¸¦ Ȱ¿ëÇÏ¿© ½Ç½ÀÇÕ´Ï´Ù
Ã¥°¥ÇÇ[01:20] TRIMMEAN ÇÔ¼ö/[02:32] PERCENTILE, PERCENTILE.EXC ÇÔ¼ö/[05:42] RANK, RANK.AVG ÇÔ¼ö/[10:01] PERCENTRANK ÇÔ¼ö/[14:06] SLOPE, INTERCEPT ÇÔ¼ö/[16:14] LINESST ÇÔ¼ö/[17:50] COMBIN ÇÔ¼ö/[19:13] Åë°è ÇÔ¼ö ½Ç½À1(ÆÇ¸ÅÇöȲºÐ¼®)/[34:55] Åë°è ÇÔ¼ö ½Ç½À2(Á¦Ç°°Ë»ç)/[39:13] Åë°è ÇÔ¼ö ½Ç½À3(¹ÝǰºÐ¼®) -
12.1½Ã°£ 11ºÐ [¿Ïº® ¸¶½ºÅÍ] ¿¢¼¿ ÇÔ¼öÀÇ Vocabulary! - Chapter 12
DBÇÔ¼ö¿¡ ´ëÇØ ¾Ë¾Æº¸°í, ½Ç¹«¿¡¼ Ȱ¿ë °¡´ÉÇÑ ´Ù¾çÇÑ ¿¹Á¦¸¦ Ȱ¿ëÇÏ¿© ½Ç½ÀÇÕ´Ï´Ù.
Ã¥°¥ÇÇ[00:06] DBÇÔ¼ö¶õ/[03:13] SUM, SUMIF, SUMIFS, DSUM ÇÔ¼ö/[10:40] Á¶°Ç¹üÀ§ ³í¸®/[14:24] EXACT ÇÔ¼ö/[18:44] DGET ÇÔ¼ö/[21:41] DAVERAGE ÇÔ¼ö/[25:45] DMAX, DMIN ÇÔ¼ö/[27:25] ¿ÍÀϵåÄ«µå/[27:56] DCOUNTA ÇÔ¼ö/[32:33] DPRODUCT ÇÔ¼ö/[33:51] DVAR, DVARP ÇÔ¼ö/[36:06] DSTDEV, DSTDEVP ÇÔ¼ö/[38:08] DB ÇÔ¼ö ½Ç½À1(°áÁ¦³»¿ª)/[44:46] DB ÇÔ¼ö ½Ç½À2(¹°Ç°¹ß¼Û¿¹Á¤Ç¥)/[53:00] DB ÇÔ¼ö ½Ç½À3(¹°Ç°¹ß¼Û¿¹Á¤Ç¥ ÇÊÅÍ)/[55:28] DB ÇÔ¼ö ½Ç½À4(Á¦Ç°°Ë»ç)/[01:03:04] DB ÇÔ¼ö ½Ç½À5(¹ÝǰºÐ¼®)/[01:08:09] DB ÇÔ¼ö ½Ç½À6 -
13.42ºÐ [¿Ïº® ¸¶½ºÅÍ] ¿¢¼¿ ÇÔ¼öÀÇ Vocabulary! - Chapter 13
À繫ÇÔ¼ö¿¡ ´ëÇØ ¾Ë¾Æº¸°í, ½Ç¹«¿¡¼ Ȱ¿ë °¡´ÉÇÑ ´Ù¾çÇÑ ¿¹Á¦¸¦ Ȱ¿ëÇÏ¿© ½Ç½ÀÇÕ´Ï´Ù.
Ã¥°¥ÇÇ[00:00] À繫ÇÔ¼ö¿ë¾î/[01:18] ´Ü¸®°è»ê½Ä, º¹¸®°è»ê½Ä/[03:25] FV ÇÔ¼ö/[05:52] PV ÇÔ¼ö/[07:39] RATE ÇÔ¼ö/[09:47] PMT ÇÔ¼ö/[14:13] PPMT ÇÔ¼ö/[17:36] À繫 ÇÔ¼ö ½Ç½À1(¹Ì·¡°¡Ä¡)/[20:37] À繫 ÇÔ¼ö ½Ç½À2(ÇöÀç°¡Ä¡)/[22:41] À繫 ÇÔ¼ö ½Ç½À3(¿ùÀÌÀ²)/[24:46] À繫 ÇÔ¼ö ½Ç½À4(¿ùÁöºÒ±Ý¾×)/[26:08] À繫 ÇÔ¼ö ½Ç½À5(¿ùÁöºÒÀÌÀÚ)/[27:18] À繫 ÇÔ¼ö ½Ç½À6(¿ùÁöºÒ¿ø±Ý)/[28:38] À繫 ÇÔ¼ö ½Ç½À7(Àû±Ý¸¸±â±Ý¾×)/[33:12] À繫 ÇÔ¼ö ½Ç½À8(Á¤±âÀû±ÝÀÌÀÚÀ²)/[36:33] À繫 ÇÔ¼ö ½Ç½À9(¿ù»óȯ¾×ºÐ¼®) -
14.33ºÐ [¿Ïº® ¸¶½ºÅÍ] ¿¢¼¿ ÇÔ¼öÀÇ Vocabulary! - Chapter 14
À繫ÇÔ¼ö¿¡ ´ëÇØ ¾Ë¾Æº¸°í, ½Ç¹«¿¡¼ Ȱ¿ë °¡´ÉÇÑ ´Ù¾çÇÑ ¿¹Á¦¸¦ Ȱ¿ëÇÏ¿© ½Ç½ÀÇÕ´Ï´Ù.
Ã¥°¥ÇÇ[00:07] À繫ÇÔ¼ö ¿ë¾î/[01:21] NPV ÇÔ¼ö/[03:06] IRR ÇÔ¼ö/[06:09] XNPV ÇÔ¼ö/[10:47] XIRR ÇÔ¼ö/[12:20] MIRR ÇÔ¼ö/[18:58] À繫 ÇÔ¼ö ½Ç½À1(NPV)/[26:19] À繫 ÇÔ¼ö ½Ç½À2(XNPV, XIRR)/[31:08] À繫 ÇÔ¼ö ½Ç½À3(¿¬°£´©Àû¼ºÀå·ü) -
15.38ºÐ [¿Ïº® ¸¶½ºÅÍ] ¿¢¼¿ ÇÔ¼öÀÇ Vocabulary! - Chapter 15
À繫ÇÔ¼ö¿¡ ´ëÇØ ¾Ë¾Æº¸°í, ½Ç¹«¿¡¼ Ȱ¿ë °¡´ÉÇÑ ´Ù¾çÇÑ ¿¹Á¦¸¦ Ȱ¿ëÇÏ¿© ½Ç½ÀÇÕ´Ï´Ù.
Ã¥°¥ÇÇ[00:06] À繫ÇÔ¼ö ¿ë¾î/[00:21] CUMPRINC ÇÔ¼ö/[04:11] CUMIPMT ÇÔ¼ö/[06:13] EFFECT ÇÔ¼ö/[08:00] NOMINAL ÇÔ¼ö/[10:27] SLN ÇÔ¼ö/[13:21] DB ÇÔ¼ö/[16:47] DISC ÇÔ¼ö/[20:02] À繫 ÇÔ¼ö ½Ç½À1(¿ù»óȯ¾×ºÐ¼®)/[25:32] À繫 ÇÔ¼ö ½Ç½À2(°¨°¡»ó°¢)/[36:07] °¨°¡»ó°¢Ç¥ »ý¼º -
16.1½Ã°£ 50ºÐ ¿¢¼¿ ÇÔ¼öÀÇ ¸¶½ºÅ͸µ Bible - Chapter 1
¹è¿¼ö½Ä¿¡ ´ëÇØ ¾Ë¾Æº¸°í, ½Ç¹«¿¡¼ Ȱ¿ë °¡´ÉÇÑ ´Ù¾çÇÑ ¿¹Á¦¸¦ Ȱ¿ëÇÏ¿© ½Ç½ÀÇÕ´Ï´Ù.
Ã¥°¥ÇÇ[00:00] ¹è¿ ¼ö½Ä/[03:04] ¹è¿ÀÇ ÀԷ¿¬½À/[05:37] ¹è¿ ¼ö½Ä ÀÔ·ÂÇϱâ/[11:23] ¹è¿ ÇÔ¼öÀÇ Æ÷ÇÔ°ü°è/[12:52] SUM, SUMIF, SUMIFS, DSUM ÇÔ¼ö/[24:11] ¹è¿ ¼ö½Ä Ç¥Çö/[28:05] °øÅë¹è¿¼ö½Ä/[34:47] ¹è¿ÀÇ ÇÕ°è½Ä/[45:26] ¹è¿ ¼ö½Ä ½Ç½À1(°áÁ¦³»¿ª)/[49:06] ¹è¿ ¼ö½Ä ½Ç½À2(Á¦Ç°°Ë»ç)/[59:10] ¹è¿½Ä ¼ö·® ±¸Çϱâ(SUM, COUNT¿Í IF)/[01:05:08] ¹è¿½Ä Æò±Õ ±¸Çϱâ(AVERAGE¿Í IF)/[01:08:30] ¹è¿½Ä ÃÖ´ë, ÃÖ¼Ò°ª ±¸Çϱâ(MAX, MIN)/[01:14:08] ¹è¿½Ä ÇÕ°è ±¸Çϱâ (SUM°ú MONTH)/[01:18:27] ¹è¿ ¼ö½Ä ½Ç½À3 (¸ÅÃâ¹è¿ºÐ¼®)/[01:30:56] ¹è¿ ¼ö½Ä ½Ç½À4(¸ÅÃâÁý°è) -
17.1½Ã°£ 37ºÐ ¿¢¼¿ ÇÔ¼öÀÇ ¸¶½ºÅ͸µ Bible - Chapter 2
¹è¿¼ö½Ä¿¡ ´ëÇØ ¾Ë¾Æº¸°í, ½Ç¹«¿¡¼ Ȱ¿ë °¡´ÉÇÑ ´Ù¾çÇÑ ¿¹Á¦¸¦ Ȱ¿ëÇÏ¿© ½Ç½ÀÇÕ´Ï´Ù.
Ã¥°¥ÇÇ[00:20] Çà¹øÈ£, ¿¹øÈ£ ¹è¿¼ö½Ä/[02:32] INDEX ÇàÀÔ·Â, ¿ÀÔ·Â/[07:33] RANK ÇÔ¼ö/[15:54] ¹Ýº°¼øÀ§ ±¸Çϱâ/[20:35] Çà¹øÈ£ ¹è¿¼ö½Ä, ¿¹øÈ£ ¹è¿¼ö½Ä(SUM MONTH)/[23:13] Ȧ¼öÇà ÇÕ, ¦¼öÇà ÇÕ°è ±¸Çϱâ(SUM MOD)/[28:00] SUM INDEX ÇÔ¼öÀÇ ÇÕ°è ±¸Çϱâ(SUM INDEX)/[31:20] ¹è¿ ¼ö½Ä ½Ç½À1(¼øÀ§ÇöȲºÐ¼®)/[40:45] ¹è¿ ¼ö½Ä ½Ç½À2(¸ÅÃâ³»¿ª)/[50:16] TRANSPOSE ÇÔ¼ö/[51:26] MODE, MODE.MULT ÇÔ¼ö/[55:25] MIN°ú IF ÇÔ¼ö/[58:02] SUM°ú COUNTIF ÇÔ¼ö/[01:02:07] MAX¿Í COUNTIF ÇÔ¼ö/[01:06:14] INDEX¿Í MATCH ÇÔ¼ö, MAX¿Í COUNTIF ÇÔ¼ö/[01:08:37] MAX, LARGE, MIN ÇÔ¼ö/[01:14:11] ¹è¿ ¼ö½Ä ½Ç½À3(¸ÅÃâ³»¿ª)/[01:29:38] ¹è¿ ¼ö½Ä ½Ç½À4(µ¿Àû Â÷Æ® ºÐ¼®) -
18.1½Ã°£ 30ºÐ ¿¢¼¿ ÇÔ¼öÀÇ ¸¶½ºÅ͸µ Bible - Chapter 3
À̸§Á¤ÀÇ¿¡ ´ëÇØ ¾Ë¾Æº¸°í, ½Ç¹«¿¡¼ Ȱ¿ë °¡´ÉÇÑ ´Ù¾çÇÑ ¿¹Á¦¸¦ Ȱ¿ëÇÏ¿© ½Ç½ÀÇÕ´Ï´Ù.
Ã¥°¥ÇÇ[00:00] À̸§Á¤ÀÇ/[05:07] Ç¥¸¸µé±â¿Í Ç¥ÀÇ À̸§/[07:41] ³»ÀåµÈ ÇÔ¼öÀ̸§ Ȱ¿ë/[09:09] GET.CELL ÇÔ¼ö/[14:41] EVALUATE ÇÔ¼ö/[22:35] PRINT_AREA (Àμ⿵¿ªÀ̸§¸¸µé±â)/[24:34] À̸§Á¤ÀÇ ½Ç½À1(¸ÅÃâ³»¿ª)/[31:46] À̸§Á¤ÀÇ ½Ç½À2(Àç°íºÐ¼®)/[35:34] À̸§Á¤ÀÇ ½Ç½À3(ÆÇ¸ÅÇöȲ)/[43:13] Àμ⿵¿ª ¼³Á¤/[45:55] Ç¥À̸§ Á¤ÀÇ/[53:49] Á¶°ÇºÎ ¼½Ä-µ¥ÀÌÅÍ ¸·´ë/[54:53] ¼¼·Î ¸·´ëÇü Â÷Æ®/[57:35] À̸§Á¤ÀÇ ½Ç½À4(¼ºÀûÇ¥)/[01:02:57] µ¥ÀÌÅÍ ¸·´ë/[01:08:28] Æò±ÕÁ¡¼ö ±¸Çϱâ/[01:25:10] µ¿ÀûÂ÷Æ® »ý¼º -
19.60ºÐ ¿¢¼¿ ÇÔ¼öÀÇ ¸¶½ºÅ͸µ Bible - Chapter 4
¾ç½ÄÄÁÆ®·Ñ¿¡ ´ëÇØ ¾Ë¾Æº¸°í, ½Ç¹«¿¡¼ Ȱ¿ë °¡´ÉÇÑ ´Ù¾çÇÑ ¿¹Á¦¸¦ Ȱ¿ëÇÏ¿© ½Ç½ÀÇÕ´Ï´Ù.
Ã¥°¥ÇÇ[00:03] »ç¿ëÀÚ Á¤ÀÇÇÔ¼ö/[19:02] ¾ç½ÄÄÁÆ®·Ñ(½ºÇÉ´ÜÃß, ½ºÅ©·Ñ¸·´ë, ÄÞº¸»óÀÚ, È®Àζõ°ú ¿É¼Ç)/[35:57] ¾ç½ÄÄÁÆ®·Ñ ½Ç½À1(»ý»ê·®, ÆÇ¸Å·®, °á»êÇ¥)/[45:08] ¾ç½ÄÄÁÆ®·Ñ ½Ç½À2(Á÷¿øº°±âº»Á¤º¸ °Ë»ö)/[57:23] ¾ç½ÄÄÁÆ®·Ñ ½Ç½À3(¿ù»óȯ¾×ºÐ¼®) - [Final]
-
20.2½Ã°£ 10ºÐ ¿¢¼¿ ÇÔ¼ö ÃÑÁ¤¸® ¸¶Áö¸· FINAL Ư°!
¼öÇÐÇÔ¼ö, »ï°¢ÇÔ¼ö, Åë°èÇÔ¼ö, ÅØ½ºÆ®ÇÔ¼ö¿¡ ´ëÇØ ¾Ë¾Æº¸°í, ½Ç¹«¿¡¼ Ȱ¿ë °¡´ÉÇÑ ´Ù¾çÇÑ ¿¹Á¦¸¦ Ȱ¿ëÇÏ¿© ½Ç½ÀÇÕ´Ï´Ù.
Ã¥°¥ÇÇ[00:00] ¼öÇÐÇÔ¼ö¿Í »ï°¢ÇÔ¼ö/[01:28] ARABIC, ROMAN ÇÔ¼ö/[05:41] SIGN ÇÔ¼ö/[07:01] BASE, DECIMAL ÇÔ¼ö/[13:36] DEGREES, RADIANS ÇÔ¼ö/[17:58] SIN, COS, TAN ÇÔ¼ö/[23:54] MDETERM ÇÔ¼ö/[27:47] ºÎÈ£¿Í Áø¹ý/[37:13] »ï°¢ÇÔ¼ö °î¼±±×¸®±â/[40:07] Á¤¹æÇà·Ä º¯¼ö±¸Çϱâ/[45:16] Åë°èÇÔ¼ö/[46:51] Æò±Õ(AVERAGE)°ú Ç¥ÁØÆíÂ÷(STDEVP)/[48:23] Àý´ëÄ¡(ABS), Áö¼ö½Â(POWER)/[50:40] ÆíÂ÷Á¦°öÇÕ(DEVSQ)/[52:35] Àý´ëÆíÂ÷ÀÇ Æò±Õ(AVEDEV)/[54:40] »ó°ü°è¼ö(CORREL, PEARSON)/[59:12] µ¥ÀÌÅÍ ºÐ¼® µµ±¸/[01:05:51] °³Ã¼·Î ¸¸µå´Â ¼ø¿(PERMUT, PERMUTATIONA)/[01:08:34] ¾ç³¡°ª Á¦¿Ü Æò±Õ(TRIMMEAN)/[01:11:13] ½Ç¹«Åë°è/[01:21:16] ÅØ½ºÆ® ÇÔ¼ö Á¾·ù/[01:21:46] ÅØ½ºÆ®¿Í °ª(TEXT, VALUE)/[01:25:03] ÅØ½ºÆ® ÆÇº°(T ÇÔ¼ö)/[01:27:36] ´Þ·¯¿Í ¿ø ÇÔ¼ö(DOLLAR, WON)/[01:30:58] ¿©·¯ ÅØ½ºÆ®¸¦ Á¶ÀÎ(CONCATENATE, &)/[01:35:04] µÎ ÅØ½ºÆ®°¡ °°ÀºÁö ºñ±³(EXACT)/[01:36:14] ÁöÁ¤ÇÑ ÅØ½ºÆ® ã±â(FIND, SEARCH)/[01:39:20] ÅØ½ºÆ® °ø¹éÁ¦°Å(TRIM, CLEAN, SUBSTITUTE)/[01:53:17] ÅØ½ºÆ® ÆÇº°(PHONETIC)/[01:56:33] ÅØ½ºÆ® ÇÔ¼ö ½Ç½À - ¿¢¼¿ÇÔ¼öÃÑÁ¤¸® ½ºÆä¼È ¿ä¾àÁ¤¸® Ư°
-
21.60ºÐ
1~5° ¿¢¼¿ÇÔ¼öÃÑÁ¤¸® ¿ä¾àÁ¤¸® Ư°
1°ºÎÅÍ 5°±îÁöÀÇ ³»¿ëÀ» ¿ä¾àÇÏ¿© Á¤¸®ÇÕ´Ï´Ù.
Ã¥°¥ÇÇ[00:00] 1° ¿ä¾à/[13:34] 2° ¿ä¾à/[24:38] 3° ¿ä¾à/[34:57] 4° ¿ä¾à/[46:16] 5° ¿ä¾à -
22.59ºÐ
6~10° ¿¢¼¿ÇÔ¼öÃÑÁ¤¸® ¿ä¾àÁ¤¸® Ư°
6°ºÎÅÍ 10°±îÁöÀÇ ³»¿ëÀ» ¿ä¾àÇÏ¿© Á¤¸®ÇÕ´Ï´Ù.
Ã¥°¥ÇÇ[00:00] 6° ¿ä¾à/[13:34] 7° ¿ä¾à/[20:49] 8° ¿ä¾à/[32:45] 9° ¿ä¾à/[45:30] 10° ¿ä¾à -
23.49ºÐ
11~15° ¿¢¼¿ÇÔ¼öÃÑÁ¤¸® ¿ä¾àÁ¤¸® Ư°
11°ºÎÅÍ 15°±îÁöÀÇ ³»¿ëÀ» ¿ä¾àÇÏ¿© Á¤¸®ÇÕ´Ï´Ù.
Ã¥°¥ÇÇ[00:00] 11° ¿ä¾à/[11:09] 12° ¿ä¾à/[25:57] 13° ¿ä¾à/[34:52] 14° ¿ä¾à/[40:29] 15° ¿ä¾à -
24.1½Ã°£ 10ºÐ
16~Á¾° ¿¢¼¿ÇÔ¼öÃÑÁ¤¸® ¿ä¾àÁ¤¸® Ư°
16°ºÎÅÍ Á¾° ±îÁöÀÇ ³»¿ëÀ» ¿ä¾àÇÏ¿© Á¤¸®ÇÕ´Ï´Ù.
Ã¥°¥ÇÇ[00:00] 16° ¿ä¾à/[15:14] 17° ¿ä¾à/[29:46] 18° ¿ä¾à/[44:30] 19° ¿ä¾à/[54:44] Á¾° ¿ä¾à
-
¿¢¼¿ 2013¿¢¼¿ 2013 Àΰ Æò»ý±³À°¿ø ±³À° ¾È³» ¿¢¼¿ 2013 ±âÃʰÀÇ ºÎÅÍ ¾ËÁö¿À R&D [¿ÀÇǽº]ÆÀ¿¡ ÀÇÇØ ¿¬±¸°³¹ßµÈ ÀڷḦ ¿¢¼¿ 2013 ¹öÀüÀÇ Åä´ë·Î ¸¸µé¾îÁø °ÀÇÀÔ´Ï´Ù.ÇнÀ±â°£ : 2°³¿ù/°ÀǼö : 20°/ÁøÇà½Ã°£ : 18½Ã°£ 9ºÐ/¼ö°·á :
170,000¿ø105,000¿ø -
¿¢¼¿ VBA 2013 [½Ç¹«]¿¢¼¿ VBA 2013 Àΰ Æò»ý±³À°¿ø ±³À° ¾È³» ¿¢¼¿ VBA °ÀÇ´Â ¾ËÁö¿À R&D [¿ÀÇǽº]ÆÀ¿¡¼ Á÷Á¢ °³¹ßµÈ °ÀÇ·Î ¿¢¼¿ VBA 2013 ¿¡ ´ëÇØ¼ ±âº»ÄÚµåÀÇ ÀÌÇØºÎÅÍ ½Ç¹« ÇÁ·Î±×·¡¹Ö±îÁö ÃÑÁ¤¸®µÇ¾úÀ¸¸ç, VBE ½Ç¹«¿¡¼ ¹Ù·Î Ȱ¿ëÇÒ ¼ö ÀÖ´Â ¿¢¼¿ VBA½Ç½À ¿¹Á¦¸¦ ÅëÇØ º¸´Ù ¿Ïº®ÇÏ°Ô ¸¶½ºÅÍÇÏ½Ç ¼ö ÀÖ½À´Ï´Ù.ÇнÀ±â°£ : 2°³¿ù/°ÀǼö : 20°/ÁøÇà½Ã°£ : 12½Ã°£ 13ºÐ/¼ö°·á :
270,000¿ø165,000¿ø