¿¢¼¿±³½Ç
ÇÔ¼ö°ÁÂ
³¯Â¥ µ¥ÀÌÅ͸¦ º¸°í ÈÞÀÏ¿©ºÎ È®ÀÎÇϱâ(IF, WEEKD ...
19,328 VIEW
³¯Â¥ µ¥ÀÌÅ͸¦ º¸°í ¿øÇÏ´Â ´Þ¸¸ ÇÕ°è³»±â(SUMPROD ...
5,425 VIEW
¼ýÀÚ ¾Õ¿¡ ÀÚ¸®¼ö¸¦ ¸ÂÃß¾î 0ºÙÀ̱â(LEN, REPT ...
40,300 VIEW
¹®ÀÚ¿¿¡¼ ´ë¼Ò¹®ÀÚ ÇѲ¨¹ø¿¡ º¯°æÇϱâ(UPPER, LO ...
7,631 VIEW
µÎ¼ö»çÀÌ¿¡ ³¼ö¸¦ ¹ß»ý½ÃÄÑ ¹«ÀÛÀ§ Ãß÷Çϱâ(RANDBE ...
EXCEL 2007
10,641 VIEW
ÇÊÅ͸µµÈ µ¥ÀÌÅÍ¿¡ ´ëÇÑ ÇÕ°è ±¸Çϱâ(SUBTOTAL) ...
18,932 VIEW
¹®ÀÚ¿¿¡¼ ƯÁ¤¹®ÀÚ¸¦ Æ÷ÇÔÇÑ ¼¿ °³¼ö ¼¼±â(COUNTI ...
95,430 VIEW
°ýÈ£¾ÈÀÇ ¼ýÀÚ °è»êÇϱâ(FIND, MID) ...
8,194 VIEW
¹®ÀÚ¿ µ¥ÀÌÅÍ¿¡¼ ¼ýÀÚ »Ì¾Æ¼ °è»êÇϱâ(VALUE, S ...
38,624 VIEW
´ëÃâ»óȯÀÏ °è»ê(EDATE)
1,411 VIEW
CHOOSE, RANK ÁßøÇÔ¼ö
3,636 VIEW
°øÈÞÀÏ Á¦¿Ü ÀÛ¾÷Àϼö °è»ê(NETWORKDAYS) ...
18,391 VIEW
ÆǸž×ÀÇ Æò±Õ±Ý¾× °è»ê(AVERAGEIFS) ...
1,817 VIEW
ÆǸž×ÀÇ ÇÕ°è °è»ê(SUMIFS)
1,417 VIEW
¸ÅÃâ¹üÀ§¿¡ ¸Â´Â »óÇ°°³¼ö °è»ê(COUNTIFS) ...
3,761 VIEW
ÀüȹøÈ£ °¡¿îµ¥ ÀÚ¸® *º°Ç¥½ÃÇϱâ(REPT) ...
4,942 VIEW
Áö¿ªº° »óÇ°ÆÇ¸Å¾× °è»ê(DPRODUCT) ...
1,334 VIEW
ÃâÀåÀοø °è»ê(DCOUNT, DCOUNTA)
1,793 VIEW
½ÃÇèÁ¡¼ö Æò±Õ°è»ê(DAVERAGE)
2,479 VIEW
¼ºÀûÇ¥ ÃÖ°í, ÃÖÀúÁ¡ °è»ê(DMAX, DMIN) ...
2,656 VIEW