Part 1 º¹ÀâÇÑ ÀÌ·ÐÀº ÀÌÁ¦ ±×¸¸!
ÃʽºÇǵå·Î °£´ÜÈ÷ ³¡³»´Â ÇÔ¼öÀÇ ±âº»
01| Áö±ß Áö±ßÇÑ ¼ö½Ä°ú Ä£ÇØÁö±â
¼ö½Ä ÀÔ·ÂÇϱâ
¼ö½Ä Àç°è»êÇϱâ
¿¬»êÀÚ »ç¿ëÇϱâ
»ó´ëÂüÁ¶, Àý´ëÂüÁ¶ ±×¸®°í È¥ÇÕÂüÁ¶

02| ÇÔ¼ö¿Í Ä£ÇØÁö±â
ÇÔ¼öÀÇ ±¸Á¶
[ÀÚµ¿ÇÕ°è] »ç¿ëÇϱâ
ÇÔ¼ö ¸¶¹ý»ç »ç¿ëÇϱâ
ÁßøÇÔ¼ö »ç¿ëÇϱâ
¼ö½Ä ¿À·ù ¸Þ½ÃÁö

Part 2 ´Ü¼øÇÑ È°¿ëÀº ÀÌÁ¦ ±×¸¸!
ÇÔ¼ö·Î ±¸ÇöÇÏ´Â ½Ç¹«ÀÚµ¿È­ ÇÙ½ÉÅ×Å©´Ð
01| Çö±ÝÃâ³³Àå ÀÛ¼ºÇϱâ - SUM ÇÔ¼ö
|°ü·ÃÇÔ¼ö| SUMIF
02| ¼ö°­ÇöȲ´ëÀå ÀÛ¼ºÇϱâ - INDIRECT ÇÔ¼ö
|°ü·ÃÇÔ¼ö| ADDRESS
03| ¿µ¾÷½ÇÀûÇöȲ Á¶È¸Çϱâ - AND ÇÔ¼ö
04| ȸ¿ø¸íºÎ ÀÛ¼ºÇϱâ - OFFSET ÇÔ¼ö
05| ´çÀÏÃâ°í¸®½ºÆ® ÀÛ¼ºÇϱâ - MATCH ÇÔ¼ö
|°ü·ÃÇÔ¼ö| LOOKUP
06| Àü¹Ý±âÆǸÅÇöȲÀ» Â÷Æ®·Î ³ªÅ¸³»±â - INDEX ÇÔ¼ö
07| °æ·ÂÁõ¸í¼­ ÀÛ¼ºÇϱâ - DATEDIF ÇÔ¼ö
08| Ãâ±ÙºÎ ÀÛ¼ºÇϱâ - INT ÇÔ¼ö
|°ü·ÃÇÔ¼ö| ABS, MOD, TRUNC
09| °ßÀû¼­ ÀÛ¼ºÇϱâ - VLOOKUP ÇÔ¼ö
10| À̺¥Æ® ´ç÷ÀÚ Ãß÷Çϱâ - RAND ÇÔ¼ö
11| ´ç÷ÀÚ ¾È³»¹® ÀÛ¼ºÇϱâ - REPLACE ÇÔ¼ö
|°ü·ÃÇÔ¼ö| REPT
12| ³³Ç°ÇöȲ Á¶È¸Çϱâ - DSUM ÇÔ¼ö
|°ü·ÃÇÔ¼ö| DAVERAGE, DCOUNT, DCOUNTA, DMAX,DMIN, DPRODUCT
13| ±Þ·á´ëÀå ÀÛ¼ºÇϱâ - ISBLANK ÇÔ¼ö
|°ü·ÃÇÔ¼ö| ISERR, ISERROR, ISLOGICAL, ISNA, ISREF, ERROR.TYPE
14| 7ÀÏ°£ÀÇ ÀÏÁ¤Ç¥ ÀÛ¼ºÇϱâ - WEEKDAY ÇÔ¼ö
15| ÈÞ°¡½Åû¼­ ÀÛ¼ºÇϱâ - OR ÇÔ¼ö
16| °Å·¡³»¿ªÀ» Â÷Æ®·Î ³ªÅ¸³»±â - COUNTA ÇÔ¼ö
|°ü·ÃÇÔ¼ö| °ü·ÃÇÔ¼ö - COUNT, MODE
17| ¸ÅÀÔ¸ÅÃâÀå ÀÛ¼ºÇϱâ - IF ÇÔ¼ö
|°ü·ÃÇÔ¼ö| NOT
18| ±Ùűâ·Ï´ëÀå ÀÛ¼ºÇϱâ - COUNTIF ÇÔ¼ö
|°ü·ÃÇÔ¼ö| COUNTBLANK, RANK ,MEDIAN, AVERAGE, AVERAGEA
19| Ç°¹ø´ëÀå ÀÛ¼ºÇϱâ - TEXT ÇÔ¼ö
|°ü·ÃÇÔ¼ö| CONCATENATE, T, TRIM, VALUE
20| Àç°í °ü¸®Çϱâ - SUMPRODUCT ÇÔ¼ö
|°ü·ÃÇÔ¼ö| PRODUCT, ROUND, ROUNDDOWN, ROUNDUP, SUBTOTAL
21| ½ÇÀû ¼øÀ§´ë·Î ³ªÅ¸³»±â - SMALL ÇÔ¼ö
|°ü·ÃÇÔ¼ö| LARGE, MAX, MAXA, MIN, MINA
22| ȸ¿ø¹øÈ£ °Ë»çÇϱâ - ISNUMBER ÇÔ¼ö
|°ü·ÃÇÔ¼ö| ISTEXT, ISNONTEXT, TYPE
23| °£ÀÌ¿µ¼öÁõ ÀÛ¼ºÇϱâ - DAY ÇÔ¼ö
|°ü·ÃÇÔ¼ö| DAYS360, HOUR, MINUTE, SECOND
24| ¼¼±Ý°è»ê¼­ ÀÛ¼ºÇϱâ - CHOOSE ÇÔ¼ö
25| ¿øÄ¢ ¾øÀÌ ÀÔ·ÂÇÑ ÀÚ·á Á¤¸®Çϱâ 0 SUBSTITUTE ÇÔ¼ö
|°ü·ÃÇÔ¼ö| CHAR, CODE, EXACT, FIND, SEARCH, FIXED
26| °£Æ®Â÷Æ®·Î ÁÖ¿äÀÏÁ¤ ÆľÇÇϱâ - MONTH ÇÔ¼ö
|°ü·ÃÇÔ¼ö| YEAR, NOW, TODAY
27| °Å·¡¸í¼¼Ç¥ ÀÛ¼ºÇϱâ - ROW ÇÔ¼ö
|°ü·ÃÇÔ¼ö| ROWS, COLUMN, COLUMNS, TRANSPOSE
28| ÀÚ·á ±¸ºÐÇϱâ - LEFT ÇÔ¼ö
|°ü·ÃÇÔ¼ö| RIGHT, MID, LEN, LOWER, UPPER, PROPER
29| ´çÁ÷±Ù¹« ´Þ·Â ÀÛ¼ºÇϱâ - DATE ÇÔ¼ö
|°ü·ÃÇÔ¼ö| DATEVALUE, TIME, TIMEVALUE
30| ±Þ¿©¸í¼¼¼­ ÀÛ¼ºÇϱâ - HLOOKUP ÇÔ¼ö

Part 3 Á¤ÇØÁø ÇÔ¼ö´Â ÀÌÁ¦ ±×¸¸!
ÇÊ¿ä¿¡ ÀÇÇØ ¸¸µé¾î ¾²´Â »ç¿ëÀÚ Á¤ÀÇ ÇÔ¼ö
01| »ç¿ëÀÚ Á¤ÀÇÇÔ¼ö¿¡ ´ëÇÑ ¸ðµç °Í
Visual Basic Editor
VBE âÀ» º»·¡ÀÇ ¸ð½ÀÀ¸·Î µÇµ¹¸®±â
»ç¿ëÀÚ Á¤ÀÇ ÇÔ¼ö ÀÛ¼ºÇÏ¿© »ç¿ëÇϱâ
¸ðµâ¸¸ ÀúÀåÇÏ°í ºÒ·¯¿À±â
»ç¿ëÀÚ Á¤ÀÇ ÇÔ¼ö µµ¿ò¸» Ç¥½ÃÇϱâ
»ç¿ëÀÚ Á¤ÀÇ ÇÔ¼ö¸¦ ¾ðÁ¦µçÁö »ç¿ëÇÒ¼ö ÀÖµµ·Ï ¸¸µé±â

02| ½ÃÆ® À̸§À» Á¦¸ñÀ¸·Î »ç¿ëÇϱâ
¡®°Å·¡Ã³¡¯ »ç¿ëÀÚ Á¤ÀÇ ÇÔ¼ö ÀÛ¼ºÇϱâ
¡®°Å·¡Ã³¡¯ »ç¿ëÀÚ Á¤ÀÇ ÇÔ¼ö »ç¿ëÇϱâ

03| ³¯Â¥¿¡ ÇØ´çÇÏ´Â ¿äÀÏÀ» ¹Ù·Î ³ªÅ¸³»±â
¡®¿äÀϳªÅ¸³»±â¡¯ »ç¿ëÀÚ Á¤ÀÇ ÇÔ¼ö ÀÛ¼ºÇϱâ
¡®¿äÀϳªÅ¸³»±â¡¯ »ç¿ëÀÚ Á¤ÀÇ ÇÔ¼ö »ç¿ëÇϱâ

04| Áֹεî·Ï¹øÈ£¸¦ Åä´ë·Î ¼ºº°ÀÔ·ÂÇϱâ
¡®¼ºº°³Ö±â¡¯ »ç¿ëÀÚ Á¤ÀÇ ÇÔ¼ö ÀÛ¼ºÇϱâ
¡®¼ºº°³Ö±â¡¯ »ç¿ëÀÚ Á¤ÀÇ ÇÔ¼ö »ç¿ëÇϱâ