{"id":29,"date":"2023-11-20T01:49:26","date_gmt":"2023-11-20T01:49:26","guid":{"rendered":"https:\/\/exceladvisor.org\/ko\/%eb%b0%a9%ec%8b%9d\/"},"modified":"2023-12-11T06:59:32","modified_gmt":"2023-12-11T06:59:32","slug":"%eb%b0%a9%ec%8b%9d","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/ko\/%eb%b0%a9%ec%8b%9d\/","title":{"rendered":"200\uac1c\uac00 \ub118\ub294 excel \uc218\uc2dd \ubaa9\ub85d"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3513816692\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <h2 id=\"t-1687347410907\">1.\ud569\uacc4<\/h2><ul><li> Excel\uc5d0\uc11c OR \ub17c\ub9ac\ub97c \uc0ac\uc6a9\ud558\ub294 SUMIF\/SUMIFS<\/li><li> SUMIFS \ub0a0\uc9dc \ubc94\uc704(\ub450 \ub0a0\uc9dc \uc0ac\uc774\uc758 \uac12\uc758 \ud569)<\/li><li> Excel\uc5d0\uc11c \uc640\uc77c\ub4dc\uce74\ub4dc\uac00 \ud3ec\ud568\ub41c SUMIF<\/li><li> Excel\uc5d0\uc11c \uc804\uccb4 \uc5f4\uc774\ub098 \ud589 \ucd94\uac00<\/li><li> SUMIF\ub97c \uc0ac\uc6a9\ud558\uc5ec \uac12\ubcf4\ub2e4 \ud070 \ud569\uacc4<\/li><li> Excel\uc758 \uac19\uc9c0 \uc54a\uc740 \uac12\uc758 \ud569\uacc4(SUMIFS)<\/li><li> Excel\uc758 \uc784\uc758 \uc140 \ud569\uacc4<\/li><li> Excel\uc5d0\uc11c \ubcf4\uc774\ub294 \uc140\ub9cc \ud569\uc0b0<\/li><li> SUMIF\ub97c \uc0ac\uc6a9\ud558\uc5ec \ube48 \uac12 \ub610\ub294 \ube48 \uc140\uc758 \ud569\uc744 \uad6c\ud569\ub2c8\ub2e4.<\/li><li> \uc140\uc5d0 \ud2b9\uc815 \ud14d\uc2a4\ud2b8\uac00 \ud3ec\ud568\ub41c \uacbd\uc6b0 \ud569\uacc4(SUMIF \ubd80\ubd84 \ud14d\uc2a4\ud2b8)<\/li><li> \ub0a0\uc9dc\ubcc4 SUMIF(\ub0a0\uc9dc \uae30\uc900 \uac12\uc758 \ud569\uacc4)<\/li><li> \ube44\uc5b4 \uc788\uc9c0 \uc54a\uc740 SUMIF(\ube44\uc5b4 \uc788\uc9c0 \uc54a\uc740 \uc140\uc758 \ud569\uacc4 \uac12)<\/li><\/ul><ul><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/ko\/sumif-vlookup\/\">VLOOKUP\uacfc SUMIF \uacb0\ud569<\/a><\/li><li> \uc5f0\ub3c4\ubcc4 \uac12\uc758 \ud569\uacc4(SUMIF \uc5f0\ub3c4)<\/li><li> Excel\uc5d0\uc11c \uc694\uc57d \ud589 \ucd94\uac00<\/li><li> Excel\uc5d0\uc11c \uc790\ub3d9 \ud569\uacc4\ub97c \ube60\ub974\uac8c \uc0ac\uc6a9<\/li><li> 0\ubcf4\ub2e4 \ud070 \uac12\uc758 \ud569(SUMIF)<\/li><li> \ud2b9\uc815 \uac12\ubcf4\ub2e4 \uc791\uc740 \uac12\uc758 \ud569(SUMIF less than)<\/li><li> SUM\uacfc \ud568\uaed8 INDIRECT \uc0ac\uc6a9<\/li><li> \uc6d4 \uae30\uc900 \uac12\uc758 \ud569\uacc4(SUMIF)<\/li><li> \ub204\uc801 \ud569\uacc4<\/li><li> \uadf8\ub8f9\ub2f9 \uac12\uc758 \ud569<\/li><li> \uc81c\uacf1\uc758 \ud569<\/li><\/ul><h2 id=\"t-1687347410908\"> 2. \uac1c\uc218<\/h2><ul><li> Excel\uc758 COUNTIF\/COUNIFS\uc758 OR \ub17c\ub9ac<\/li><li> Excel\uc5d0\uc11c \ub2e8\uc5b4 \uacc4\uc0b0<\/li><li> Excel\uc5d0\uc11c 0\ubcf4\ub2e4 \ud070 \uc218(COUNTIF)<\/li><li> Excel\uc5d0\uc11c \ub450 \uc22b\uc790 \uc0ac\uc774\uc758 \uac1c\uc218(COUNTIFS)<\/li><li> Excel\uc5d0\uc11c\uc640 \uac19\uc9c0 \uc54a\uc740 \uc140 \uac1c\uc218 \uacc4\uc0b0(COUNTIF)<\/li><li> Excel\uc5d0\uc11c \ubc94\uc704\uc758 \ucd1d \uc140 \uc218 \uacc4\uc0b0<\/li><li> Excel\uc5d0\uc11c COUNTIF\ub97c \uc0ac\uc6a9\ud558\uc5ec \ube48(\ube48) \uc140 \uac1c\uc218 \uacc4\uc0b0<\/li><li> Excel\uc5d0\uc11c \ud2b9\uc815 \uac12(COUNTIF)\ubcf4\ub2e4 \uc791\uc740 \uc140 \uac1c\uc218 \uacc4\uc0b0<\/li><li> Excel\uc5d0\uc11c \ube44\uc5b4 \uc788\uc9c0 \uc54a\uc740 \uc140 \uc218 \uacc4\uc0b0<\/li><\/ul><ul><li> Excel\uc5d0\uc11c \ud2b9\uc815 \ubb38\uc790 \uc218 \uacc4\uc0b0<\/li><li> Excel\uc5d0\uc11c \ud14d\uc2a4\ud2b8\uac00 \ud3ec\ud568\ub41c \uc140 \uac1c\uc218 \uacc4\uc0b0<\/li><li> Excel\uc5d0\uc11c \uace0\uc720 \uac12 \uacc4\uc0b0<\/li><li> COUNT \ub300 COUNTA<\/li><li> Excel\uc5d0\uc11c \ud544\ud130\ub9c1\ub41c \ud589 \uac1c\uc218 \uacc4\uc0b0<\/li><li> \ub77c\uc778 \uc218 \uacc4\uc0b0(\ubaa8\ub450, \ube44\uc5b4 \uc788\uc74c, \ube44\uc5b4 \uc788\uc9c0 \uc54a\uc74c \ubc0f \uc22b\uc790 \ud3ec\ud568)<\/li><\/ul><h2 id=\"t-1687347410909\"> 3. \ub0a0\uc9dc<\/h2><ul><li> Excel\uc5d0\uc11c \ud14d\uc2a4\ud2b8\ub97c \ub0a0\uc9dc\ub85c \ubcc0\ud658<\/li><li> Excel\uc758 DATEDIF \ud568\uc218<\/li><li> Excel\uc758 \uc0ac\uc6a9\uc790 \uc815\uc758 \ub0a0\uc9dc \ud615\uc2dd<\/li><li> Excel\uc5d0\uc11c \ub0a0\uc9dc\ub85c\ubd80\ud130 \uc6d4 \uac00\uc838\uc624\uae30(\uc6d4 \ucd94\ucd9c)<\/li><li> Excel\uc5d0\uc11c \uc6d4\uc758 \uc885\ub8cc \ub0a0\uc9dc\ub97c \uac00\uc838\uc635\ub2c8\ub2e4.<\/li><li> Excel\uc5d0\uc11c \ucd1d \uac1c\uc6d4 \uc218\ub97c \uc5bb\uc73c\uc2ed\uc2dc\uc624.<\/li><li> Excel\uc758 \ub0a0\uc9dc\uc5d0\uc11c \uc694\uc77c \uc774\ub984 \uac00\uc838\uc624\uae30<\/li><li> Excel\uc5d0\uc11c \ub450 \ub0a0\uc9dc \uc0ac\uc774\uc758 \ub0a0\uc9dc \uac15\uc870 \ud45c\uc2dc<\/li><li> Excel\uc758 [\ud68c\uacc4 + \ub2ec\ub825] \ub0a0\uc9dc\uc5d0\uc11c \ubd84\uae30 \uac00\uc838\uc624\uae30<\/li><li> Excel\uc5d0\uc11c \ud604\uc7ac\uae4c\uc9c0 \uc5f0\ub3c4 \ucd94\uac00<\/li><li> Excel\uc758 \ub0a0\uc9dc\uc5d0\uc11c \uc8fc \ub354\ud558\uae30 \ube7c\uae30<\/li><li> Excel\uc5d0\uc11c \uc5f0\uac04 \uc77c\uc218 \uc5bb\uae30<\/li><li> Excel\uc5d0\uc11c \ub0a0\uc9dc \ubc94\uc704 \ub9cc\ub4e4\uae30<\/li><li> Excel\uc5d0\uc11c \ub450 \ub0a0\uc9dc \ube44\uad50<\/li><li> Excel\uc5d0\uc11c \ub0a0\uc9dc\ub97c \uc22b\uc790\ub85c \ubcc0\ud658<\/li><li> Excel\uc5d0\uc11c \ub450 \ub0a0\uc9dc \uc0ac\uc774\uc758 \uc5f0\ub3c4 \uacc4\uc0b0<\/li><li> Excel\uc5d0\uc11c \uc218\ub144\uac04\uc758 \uc11c\ube44\uc2a4 \ubc1b\uae30<\/li><\/ul><ul><li> Excel\uc5d0\uc11c \uc6d4\uc758 \uccab\ub0a0 \uac00\uc838\uc624\uae30(\uc6d4 \uc2dc\uc791)<\/li><li> Excel\uc5d0\uc11c \ub450 \ub0a0\uc9dc \uc0ac\uc774\uc758 \uac1c\uc6d4 \uc218<\/li><li> Excel\uc758 \ub0a0\uc9dc \uc0ac\uc774\uc758 \uc5f0\ub3c4<\/li><li> Excel\uc5d0\uc11c \ub0a0\uc9dc\uc640 \uc2dc\uac04 \uacb0\ud569<\/li><li> Excel\uc758 \ub0a0\uc9dc\uc5d0\uc11c \uc5f0\ub3c4 \ub610\ub294 \uc6d4 \ucd94\ucd9c(\uac00\uc838\uc624\uae30)<\/li><li> \ub450 \ub0a0\uc9dc \uc0ac\uc774\uc758 \uc77c\uc218 \uacc4\uc0b0(COUNTIF \ub0a0\uc9dc \ubc94\uc704)<\/li><li> \uc6d4 \uc774\ub984\uc744 \uc22b\uc790\ub85c \ubcc0\ud658<\/li><li> \ud55c \ub2ec\uc758 \uadfc\ubb34\uc77c<\/li><li> \ub0a0\uc9dc\ub97c \ud14d\uc2a4\ud2b8\ub85c \ubcc0\ud658<\/li><li> \uce74\uc6b4\ud2b8\ub2e4\uc6b4 \uc77c\uc218<\/li><li> \uc728\ub9ac\uc6b0\uc2a4\ub825 \ub0a0\uc9dc\ub85c \ubcc0\ud658<\/li><li> \ub0a0\uc9dc\ub97c \uc6d4\uacfc \uc5f0\ub3c4\ub85c \ubcc0\ud658<\/li><li> \uc774\uc804 \uc77c\uc694\uc77c \uac00\uc838\uc624\uae30<\/li><li> Excel\uc5d0\uc11c \ub0a0\uc9dc\uc5d0 \ud55c \ub2ec \ucd94\uac00<\/li><li> Excel\uc5d0\uc11c \ub450 \ub0a0\uc9dc\ub97c \ube60\ub974\uac8c \uc5f0\uacb0<\/li><li> Excel\uc758 \uc784\uc758 \ub0a0\uc9dc \uc0dd\uc131\uae30(Excel \uc218\uc2dd)<\/li><\/ul><h2 id=\"t-1687347410910\"> 4 \ubc88<\/h2><ul><li> \ub450 \uc2dc\uac04 \uc0ac\uc774\uc758 \uc2dc\uac04 \ucc28\uc774\ub97c \uacc4\uc0b0\ud558\uc138\uc694.<\/li><li> Excel\uc5d0\uc11c \ub0a0\uc9dc\uc640 \uc2dc\uac04\uc744 \ubd84\ub9ac\ud558\uc138\uc694.<\/li><li> Excel\uc758 \uad70\uc0ac \uc2dc\uac04(\uac00\uc838\uc624\uae30 \ubc0f \ube7c\uae30)<\/li><li> Excel\uc5d0\uc11c \uc2dc\uac04\uc5d0 \ubd84 \ucd94\uac00<\/li><li> Excel\uc5d0\uc11c \uc2dc\uac04 \ud615\uc2dd \ubcc0\uacbd<\/li><li> Excel\uc5d0\uc11c \uc2dc\uac04\uc5d0 \uc2dc\uac04 \ucd94\uac00<\/li><li> \uc2dc\uac04\uc5d0 \ucd08 \ucd94\uac00<\/li><li> \ud604\uc7ac \uc2dc\uac04 \uac00\uc838\uc624\uae30<\/li><\/ul><ul><li> Excel\uc758 \ud569\uacc4 \uc2dc\uac04(Excel \uc218\uc2dd)<\/li><li> \uc2dc\uac04 \uac12\uc744 \uc2ed\uc9c4\uc218(\uc2dc\uac04)\ub85c \ubcc0\ud658<\/li><li> \uc2dc\uac04 \uac12\uc744 \ubd84\uc73c\ub85c \ubcc0\ud658(Excel \uacf5\uc2dd)<\/li><li> \uc2dc\uac04 \uac12\uc744 \ucd08\ub85c \ubcc0\ud658<\/li><li> \ubd84\uc744 \uc2dc, \ubd84\uc73c\ub85c \ubcc0\ud658(HH:MM)<\/li><li> \ucd08\ub97c \uc2dc\uac04\uacfc \ubd84\uc73c\ub85c \ubcc0\ud658<\/li><li> \uc2dc\uac04\uc744 \uc18c\uc218\ub85c \ubcc0\ud658<\/li><\/ul><h2 id=\"t-1687347410911\"> 5. \uc5f0\uad6c<\/h2><ul><li> Excel\uc5d0\uc11c VLOOKUP MATCH \uacb0\ud569<\/li><li> Excel\uc5d0\uc11c \uc591\ubc29\ud5a5 \uac80\uc0c9 \uc218\ud589<\/li><li> Excel\uc5d0\uc11c VLOOKUP\uc744 \uc0ac\uc6a9\ud55c \uc640\uc77c\ub4dc\uce74\ub4dc<\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/ko\/iferror-vlookup\/\">Excel\uc5d0\uc11c #N\/A\ub97c \ub300\uccb4\ud558\uae30 \uc704\ud574 Excel\uc5d0\uc11c VLOOKUP\uc744 \uc0ac\uc6a9\ud55c IFERROR<\/a><\/li><li> Excel\uc5d0\uc11c \uc5ec\ub7ec \uae30\uc900\uc744 \uc0ac\uc6a9\ud558\ub294 VLOOKUP<\/li><li> Excel\uc5d0\uc11c VLOOKUP \uc5ed\ubc29\ud5a5(\ub4a4\ub85c: \uc624\ub978\ucabd\uc5d0\uc11c \uc67c\ucabd\uc73c\ub85c)<\/li><li> VLOOKUP \ub0a0\uc9dc(\ub370\uc774\ud130\uc758 \ub0a0\uc9dc\uc5d0 \ub300\ud55c VLOOKUP)<\/li><\/ul><ul><li> \uc5f4\uc774\ub098 \ud589\uc758 \ub9c8\uc9c0\ub9c9 \uac12 \ucc3e\uae30<\/li><li> \ub2e4\ub978 \uc2dc\ud2b8\uc758 VLOOKUP(\uc2dc\ud2b8 \uac04)<\/li><li> VLOOKUP\uc744 \uc0ac\uc6a9\ud55c \uac04\uc811<\/li><li>VLOOKUP\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub450 \uc5f4 \uc77c\uce58\/\ube44\uad50<\/li><li>XLOOKUP\uc740 \ubaa8\ub4e0 \uc77c\uce58 \ud56d\ubaa9\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4. \uac00\ub2a5\ud55c?<\/li><li> \uc5ec\ub7ec \uae30\uc900\uc774 \uc788\ub294 XLOOKUP<\/li><li> \uac12 \ub300\uc2e0 \uc140 \uc8fc\uc18c \ucc3e\uae30<\/li><\/ul><h2 id=\"t-1687347410912\"> 6. \uc218\ud559<\/h2><ul><li> Excel\uc5d0\uc11c \uac00\uc911 \ud3c9\uade0 \uacc4\uc0b0<\/li><li> Excel\uc5d0\uc11c \ube44\uc728\uc744 \ube60\ub974\uac8c \uacc4\uc0b0<\/li><li> Excel\uc758 MAX IF<\/li><li> Excel\uc5d0\uc11c \uac00\uc7a5 \ub192\uc740 5\uac1c \uac12\uc758 \ud3c9\uade0<\/li><li> Excel\uc5d0\uc11c \uc81c\uacf1\uadfc \uacc4\uc0b0 + \uae30\ud638 \uc0bd\uc785<\/li><li> Excel\uc5d0\uc11c \uac00\uc7a5 \uac00\uae4c\uc6b4 .5, 5.50(Down-Up)\uc73c\ub85c \ubc18\uc62c\ub9bc<\/li><li> Excel\uc5d0\uc11c \ud050\ube0c \ub8e8\ud2b8 \uacc4\uc0b0<\/li><li> Excel\uc5d0\uc11c \uc22b\uc790\ub97c \uac00\uc7a5 \uac00\uae4c\uc6b4 1000\uc73c\ub85c \ubc18\uc62c\ub9bc<\/li><li> Excel\uc5d0\uc11c \ubc31\ubd84\uc728 \ubd84\uc0b0(\ucc28\uc774) \uacc4\uc0b0<\/li><li> Excel\uc5d0\uc11c \uc22b\uc790 \uc81c\uacf1\ud558\uae30<\/li><li> Excel\uc5d0\uc11c \ubcc0\ub3d9\uacc4\uc218(CV) \uacc4\uc0b0<\/li><li> Excel\uc758 \uc5f0\uc0b0\uc790\uc640 \uac19\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/li><\/ul><ul><li> \ube44\uc5b4 \uc788\uc9c0 \uc54a\uc740 \uc140\ub9cc \ud3c9\uade0\ud654<\/li><li> \ubc31\ubd84\uc728 \uac12\uc758 \ud3c9\uade0 \uacc4\uc0b0<\/li><li> \uc2dc\uac04 \uac12\uc758 \ud3c9\uade0 \uacc4\uc0b0<\/li><li> \uac12\uc758 \ub204\uc801\ud569\uc744 \uacc4\uc0b0\ud569\ub2c8\ub2e4(Excel \uc218\uc2dd).<\/li><li> \uc140 \ubc94\uc704\uc5d0\uc11c \uac00\uc7a5 \uc791\uc740 \uac12 \ucc3e\uae30(\ucd5c\uc18c)<\/li><li> \uc22b\uc790 \ubaa9\ub85d\uc5d0\uc11c \uac00\uc7a5 \ub0ae\uc740 \uac12 \ucc3e\uae30(N)<\/li><li> \ubc30\uc5f4\uc758 \uac00\uc7a5 \ube48\ubc88\ud55c \uc22b\uc790\ub97c \uac00\uc838\uc635\ub2c8\ub2e4.<\/li><li> n\ubc88\uc9f8 \ub8e8\ud2b8\ub97c \uacc4\uc0b0\ud569\ub2c8\ub2e4.<\/li><li> \ubc18\uc62c\ub9bc \uac12 \ubc31\ubd84\uc728<\/li><li> \uc22b\uc790\uc758 \ubc31\ubd84\uc728\uc744 \ub354\ud558\uace0 \ube7c\uae30<\/li><li> \ud3c9\uade0\uc774\uc9c0\ub9cc \uc624\ub958\ub97c \ubb34\uc2dc\ud569\ub2c8\ub2e4(#N\/A \ubc0f \uae30\ud0c0 \uc624\ub958).<\/li><li> \ud3c9\uade0 \uc22b\uc790\uc774\uc9c0\ub9cc 0\uc740 \uc81c\uc678<\/li><\/ul><h2 id=\"t-1687347410913\"> 7. \uc870\uac74<\/h2><ul><li> IF\uac00 0(\uc601)\uc778\uc9c0 \ud655\uc778\ud558\uace0 Excel\uc5d0\uc11c \ube44\uc5b4 \uc788\uc74c<\/li><li> Excel\uc758 \ubc94\uc704\uc5d0 \uac12\uc774 \uc788\ub294\uc9c0 \ud655\uc778<\/li><li> Excel\uc5d0\uc11c IF\uc640 AND \ud568\uc218 \uacb0\ud569<\/li><li> Excel\uc5d0\uc11c IF \ubc0f OR \ud568\uc218 \uacb0\ud569<\/li><li> Excel\uc5d0\uc11c \ub450 \uc140 \ube44\uad50<\/li><li> \uc870\uac74\ubd80 \uc21c\uc704 [RANKIF]<\/li><li> IF + ISBLANK\ub97c \uc0ac\uc6a9\ud558\uc5ec IF \uc140\uc774 \ube44\uc5b4 \uc788\uc74c(\ube44\uc5b4 \uc788\uc74c)<\/li><li> IF\uac00 \ud3ec\ud568\ub41c \uc18c\uacc4(\uc870\uac74\ubd80 \uc18c\uacc4)<\/li><li>\ubcf4\ub2e4 \ud07c(&gt;) \ubc0f \uac19\uc74c(=) \uc5f0\uc0b0\uc790<\/li><\/ul><ul><li> \uc74c\uc218\uc774\uba74 Excel\uc5d0\uc11c 0\uc785\ub2c8\ub2e4.<\/li><li> SUMPRODUCT IF \u2013 \uc870\uac74\uc2dd<\/li><li> \uc140\uc5d0 \ubd80\ubd84 \ud14d\uc2a4\ud2b8\uac00 \ud3ec\ud568\ub418\uc5b4 \uc788\ub294\uc9c0 \ud655\uc778<\/li><li> \uc140 \uac12\uc774 \uc22b\uc790\uc778\uc9c0 \ud655\uc778<\/li><li> \uc140 \uac12\uc774 \ud14d\uc2a4\ud2b8\ub098 \uc22b\uc790\ub85c \uc2dc\uc791\ud558\ub294 \uacbd\uc6b0<\/li><li> IF\uac00 \uc788\ub294 \uc911\uc559\uac12(\uc870\uac74\ubd80 \uae30\uc900)<\/li><li> CONCATENATE IF(\uc870\uac74\uacfc \uacb0\ud569)<\/li><li>Excel\uc758 TRUE \ubc0f FALSE(\ubd80\uc6b8 \uac12)<\/li><li> Excel\uc758 \uc0b0\uc220 \uc5f0\uc0b0\uc790<\/li><\/ul><h2 id=\"t-1687347410914\"> 8. \ud14d\uc2a4\ud2b8<\/h2><ul><li> Excel\uc5d0\uc11c \uc140\uc5d0 \uc0c8 \uc904 \ucd94\uac00(\uc904 \ubc14\uafc8)<\/li><li> Excel\uc5d0\uc11c \uc120\ud589 0 \ucd94\uac00<\/li><li> Excel\uc5d0\uc11c \uccab \uae00\uc790\ub97c \ub300\ubb38\uc790\ub85c \ud45c\uc2dc<\/li><li> Excel\uc5d0\uc11c \uc5f4\uc744 \ud589\uc73c\ub85c \ubcc0\uacbd(\ubc18\ub300\ub85c)<\/li><li>Excel\uc5d0\uc11c \ubb38\uc7a5 \ucf00\uc774\uc2a4\ub85c \uc804\ud658<\/li><li> \uc140\uc744 \uc27c\ud45c\ub85c \uc5f0\uacb0(\uacb0\ud569)<\/li><li> \uc140 \ubc94\uc704 \uc5f0\uacb0(\uacb0\ud569)<\/li><li> Excel\uc5d0\uc11c \uc904 \ubc14\uafc8\uc73c\ub85c \uc5f0\uacb0<\/li><li> Excel\uc5d0\uc11c \uac00\ub85c \ud544\ud130 \ub9cc\ub4e4\uae30<\/li><li>Excel\uc5d0\uc11c \ubcc4\ud45c \ud3c9\uac00 \ud15c\ud50c\ub9bf \ub9cc\ub4e4\uae30<\/li><li> Excel\uc5d0\uc11c \ud30c\uc77c \uc774\ub984 \uac00\uc838\uc624\uae30<\/li><li> Excel\uc5d0\uc11c \uc2dc\ud2b8 \uc774\ub984 \uac00\uc838\uc624\uae30<\/li><li> Excel\uc758 \uc140\uc5d0\uc11c \uccab \ubc88\uc9f8 \ubb38\uc790 \uc81c\uac70<\/li><li> Excel\uc5d0\uc11c \uc784\uc758\uc758 \ubb38\uc790\ub97c \ube60\ub974\uac8c \uc0dd\uc131<\/li><li> Excel\uc5d0\uc11c \ubaa9\ub85d \ubb34\uc791\uc704\ud654(\uc784\uc758 \uc815\ub82c)<\/li><li>\uc774\uba54\uc77c ID\uc5d0\uc11c \ub3c4\uba54\uc778 \uac00\uc838\uc624\uae30<\/li><li> \ubb38\uc790\uc5f4\uc5d0\uc11c \ub9c8\uc9c0\ub9c9 \ubb38\uc790 \uc81c\uac70<\/li><li> \uc6d0\ud558\uc9c0 \uc54a\ub294 \ubb38\uc790 \uc81c\uac70<\/li><li> \ubb38\uc790 \uc55e\ub4a4\uc758 \ud14d\uc2a4\ud2b8 \ucd94\ucd9c<\/li><\/ul><ul><li> Excel\uc5d0\uc11c \ucd94\uac00 \uacf5\ubc31 \uc81c\uac70<\/li><li> Excel\uc5d0\uc11c \ubcc4\ub3c4\uc758 \uc774\ub984 \u2013 (\uc774\ub984\uacfc \uc131)<\/li><li> Excel\uc5d0\uc11c \ubb38\uc790 \uac1c\uc218 \uacc4\uc0b0(\uc140 \ubc0f \ubc94\uc704)<\/li><li> \ub3d9\uc801 \ud558\uc774\ud37c\ub9c1\ud06c \ub9cc\ub4e4\uae30<\/li><li> \uc774\ub984\uacfc \uc131\uc744 \ubc18\ud658\ud558\uace0 \uba85\ub839\uc744 \ucd94\uac00\ud569\ub2c8\ub2e4.<\/li><li> \ud30c\uc77c \uacbd\ub85c \uac00\uc838\uc624\uae30(Excel \uc218\uc2dd)<\/li><li> \uc140 \uac12 \uac00\uc838\uc624\uae30<\/li><li> \uc140\uc5d0\uc11c \ub9c8\uc9c0\ub9c9 \ub2e8\uc5b4 \ucd94\ucd9c<\/li><li> \uc140\uc5d0\uc11c \uc904 \ubc14\uafc8 \uc81c\uac70<\/li><li> Excel\uc5d0\uc11c \uad04\ud638 \uc81c\uac70(\uad04\ud638)<\/li><li> \uc5ec\ub7ec(\uc911\ucca9) \uac12 \ubc14\uafb8\uae30<\/li><li> \ubb34\uc791\uc704 \uadf8\ub8f9 \uc0dd\uc131<\/li><li> \uacf5\uac04 \ucd94\uac00(\ub2e8\uc77c \ubc0f \ub2e4\uc911)<\/li><li> \uc27c\ud45c \ucd94\uac00(\uc140 \ud14d\uc2a4\ud2b8)<\/li><li> \ub450 \ubb38\uc790\uc5f4(\ud14d\uc2a4\ud2b8) \ube44\uad50<\/li><li> \uacf5\ubc31\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud14d\uc2a4\ud2b8 \ubd84\ud560<\/li><li> \ud14d\uc2a4\ud2b8 \ub300\uc18c\ubb38\uc790 \ubcc0\uacbd(\ub300\ubb38\uc790, \uc18c\ubb38\uc790, \uace0\uc720)<\/li><li> \ud14d\uc2a4\ud2b8(\ubb38\uc790\uc5f4)\uc5d0\uc11c \uc22b\uc790\ub9cc \ucd94\ucd9c<\/li><li> \uc27c\ud45c \uc81c\uac70<\/li><\/ul><h2 id=\"t-1687347410915\"> 9. \uc624\ub958<\/h2><ul><li>#DIV\/0<\/li><li> #\ud655\uc0b0!<\/li><li> #REF!<\/li><\/ul><ul><li> #\uac12<\/li><li> \ubaa8\ub4e0 \uc624\ub958\ub97c \ubb34\uc2dc<\/li><li> #N \/ A<\/li><\/ul><h2 id=\"t-1687347410916\"> 10. \uc7ac\uc815<\/h2><ul><li> Excel\uc5d0\uc11c \ubcf5\ub9ac \uacc4\uc0b0<\/li><li> Excel\uc5d0\uc11c \ub2e8\ub9ac \uacc4\uc0b0\ud558\uae30<\/li><\/ul><ul><li> \ub9e4\ucd9c\ucd1d\uc774\uc775(\ub9c8\uc9c4 \ubc0f \ube44\uc728)<\/li><li> \ubd80\uac00\uac00\uce58\uc138 \uacc4\uc0b0<\/li><\/ul><h2> 11. \uae30\ud0c0<\/h2><ul><li> Excel\uc758 3D \ucc38\uc870<\/li><li> Excel\uc758 \uc640\uc77c\ub4dc\uce74\ub4dc<\/li><li>Excel\uc5d0\uc11c \uc218\uc2dd \uc228\uae30\uae30<\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/ko\/r1c1\/\">Excel\uc758 R1C1 \ucc38\uc870 \uc2a4\ud0c0\uc77c<\/a><\/li><\/ul>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-29","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>200\uac1c \uc774\uc0c1\uc758 Excel \uc218\uc2dd \ubaa9\ub85d(\uae30\ubcf8 + \uace0\uae09 2023)<\/title>\n<meta name=\"description\" content=\"\uc774\uac83\uc740 \uac00\uc7a5 \uc911\uc694\ud558\uace0 \uc720\uc6a9\ud55c Excel \uc218\uc2dd\uc744 \ubc30\uc6b0\uae30 \uc704\ud55c \uc644\ubcbd\ud55c \uac00\uc774\ub4dc\uc785\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \ubb34\ub8cc\uac15\uc758\ub3c4 \uc788\uc5b4\uc694\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/ko\/\ubc29\uc2dd\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"200\uac1c \uc774\uc0c1\uc758 Excel \uc218\uc2dd \ubaa9\ub85d(\uae30\ubcf8 + \uace0\uae09 2023)\" \/>\n<meta property=\"og:description\" content=\"\uc774\uac83\uc740 \uac00\uc7a5 \uc911\uc694\ud558\uace0 \uc720\uc6a9\ud55c Excel \uc218\uc2dd\uc744 \ubc30\uc6b0\uae30 \uc704\ud55c \uc644\ubcbd\ud55c \uac00\uc774\ub4dc\uc785\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \ubb34\ub8cc\uac15\uc758\ub3c4 \uc788\uc5b4\uc694\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/ko\/\ubc29\uc2dd\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-11T06:59:32+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04\" \/>\n\t<meta name=\"twitter:data1\" content=\"1\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/%eb%b0%a9%ec%8b%9d\/\",\"url\":\"https:\/\/exceladvisor.org\/ko\/%eb%b0%a9%ec%8b%9d\/\",\"name\":\"200\uac1c \uc774\uc0c1\uc758 Excel \uc218\uc2dd \ubaa9\ub85d(\uae30\ubcf8 + \uace0\uae09 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/#website\"},\"datePublished\":\"2023-11-20T01:49:26+00:00\",\"dateModified\":\"2023-12-11T06:59:32+00:00\",\"description\":\"\uc774\uac83\uc740 \uac00\uc7a5 \uc911\uc694\ud558\uace0 \uc720\uc6a9\ud55c Excel \uc218\uc2dd\uc744 \ubc30\uc6b0\uae30 \uc704\ud55c \uc644\ubcbd\ud55c \uac00\uc774\ub4dc\uc785\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \ubb34\ub8cc\uac15\uc758\ub3c4 \uc788\uc5b4\uc694\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/%eb%b0%a9%ec%8b%9d\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/ko\/%eb%b0%a9%ec%8b%9d\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/%eb%b0%a9%ec%8b%9d\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\uc9d1\",\"item\":\"https:\/\/exceladvisor.org\/ko\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"200\uac1c\uac00 \ub118\ub294 excel \uc218\uc2dd \ubaa9\ub85d\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/#website\",\"url\":\"https:\/\/exceladvisor.org\/ko\/\",\"name\":\"Excel Advisor\",\"description\":\"\ub370\uc774\ud130 \uc9c0\ubc30\ub825\uc744 \uc704\ud55c \uac00\uc774\ub4dc!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/ko\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/ko\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/ko\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/ko\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"200\uac1c \uc774\uc0c1\uc758 Excel \uc218\uc2dd \ubaa9\ub85d(\uae30\ubcf8 + \uace0\uae09 2023)","description":"\uc774\uac83\uc740 \uac00\uc7a5 \uc911\uc694\ud558\uace0 \uc720\uc6a9\ud55c Excel \uc218\uc2dd\uc744 \ubc30\uc6b0\uae30 \uc704\ud55c \uc644\ubcbd\ud55c \uac00\uc774\ub4dc\uc785\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \ubb34\ub8cc\uac15\uc758\ub3c4 \uc788\uc5b4\uc694","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/ko\/\ubc29\uc2dd\/","og_locale":"ko_KR","og_type":"article","og_title":"200\uac1c \uc774\uc0c1\uc758 Excel \uc218\uc2dd \ubaa9\ub85d(\uae30\ubcf8 + \uace0\uae09 2023)","og_description":"\uc774\uac83\uc740 \uac00\uc7a5 \uc911\uc694\ud558\uace0 \uc720\uc6a9\ud55c Excel \uc218\uc2dd\uc744 \ubc30\uc6b0\uae30 \uc704\ud55c \uc644\ubcbd\ud55c \uac00\uc774\ub4dc\uc785\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \ubb34\ub8cc\uac15\uc758\ub3c4 \uc788\uc5b4\uc694","og_url":"https:\/\/exceladvisor.org\/ko\/\ubc29\uc2dd\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-11T06:59:32+00:00","twitter_card":"summary_large_image","twitter_misc":{"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"1\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/ko\/%eb%b0%a9%ec%8b%9d\/","url":"https:\/\/exceladvisor.org\/ko\/%eb%b0%a9%ec%8b%9d\/","name":"200\uac1c \uc774\uc0c1\uc758 Excel \uc218\uc2dd \ubaa9\ub85d(\uae30\ubcf8 + \uace0\uae09 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/ko\/#website"},"datePublished":"2023-11-20T01:49:26+00:00","dateModified":"2023-12-11T06:59:32+00:00","description":"\uc774\uac83\uc740 \uac00\uc7a5 \uc911\uc694\ud558\uace0 \uc720\uc6a9\ud55c Excel \uc218\uc2dd\uc744 \ubc30\uc6b0\uae30 \uc704\ud55c \uc644\ubcbd\ud55c \uac00\uc774\ub4dc\uc785\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \ubb34\ub8cc\uac15\uc758\ub3c4 \uc788\uc5b4\uc694","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/ko\/%eb%b0%a9%ec%8b%9d\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/ko\/%eb%b0%a9%ec%8b%9d\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/ko\/%eb%b0%a9%ec%8b%9d\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\uc9d1","item":"https:\/\/exceladvisor.org\/ko\/"},{"@type":"ListItem","position":2,"name":"200\uac1c\uac00 \ub118\ub294 excel \uc218\uc2dd \ubaa9\ub85d"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/ko\/#website","url":"https:\/\/exceladvisor.org\/ko\/","name":"Excel Advisor","description":"\ub370\uc774\ud130 \uc9c0\ubc30\ub825\uc744 \uc704\ud55c \uac00\uc774\ub4dc!","publisher":{"@id":"https:\/\/exceladvisor.org\/ko\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/ko\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/ko\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/ko\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/exceladvisor.org\/ko\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/ko\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/ko\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/ko\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/pages\/29","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/comments?post=29"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/pages\/29\/revisions"}],"predecessor-version":[{"id":763,"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/pages\/29\/revisions\/763"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/media?parent=29"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}