¿¢¼¿±³½Ç
ÇÔ¼ö°ÁÂ
³¯Â¥ µ¥ÀÌÅ͸¦ º¸°í ÈÞÀÏ¿©ºÎ È®ÀÎÇϱâ(IF, WEEKD ...
19,128 VIEW
³¯Â¥ µ¥ÀÌÅ͸¦ º¸°í ¿øÇÏ´Â ´Þ¸¸ ÇÕ°è³»±â(SUMPROD ...
5,332 VIEW
¼ýÀÚ ¾Õ¿¡ ÀÚ¸®¼ö¸¦ ¸ÂÃß¾î 0ºÙÀ̱â(LEN, REPT ...
39,716 VIEW
¹®ÀÚ¿¿¡¼ ´ë¼Ò¹®ÀÚ ÇѲ¨¹ø¿¡ º¯°æÇϱâ(UPPER, LO ...
7,444 VIEW
µÎ¼ö»çÀÌ¿¡ ³¼ö¸¦ ¹ß»ý½ÃÄÑ ¹«ÀÛÀ§ Ãß÷Çϱâ(RANDBE ...
EXCEL 2007
10,517 VIEW
¸Þ´º°ÁÂ
¹®¼ ¼Ó¼º È®ÀÎÇÏ´Â ¹æ¹ý
1,695 VIEW
ÇÊÅ͸µµÈ µ¥ÀÌÅÍ¿¡ ´ëÇÑ ÇÕ°è ±¸Çϱâ(SUBTOTAL) ...
18,354 VIEW
¹®ÀÚ¿¿¡¼ ƯÁ¤¹®ÀÚ¸¦ Æ÷ÇÔÇÑ ¼¿ °³¼ö ¼¼±â(COUNTI ...
93,641 VIEW
°ýÈ£¾ÈÀÇ ¼ýÀÚ °è»êÇϱâ(FIND, MID) ...
8,117 VIEW
¿¢¼¿ 2007¿¡¼ Á¦°øÇÏÁö ¾Ê´Â ¿¢¼¿ 97 ~ 2003 ...
EXCEL 2003EXCEL 2007
1,100 VIEW
¹®ÀÚ¿ µ¥ÀÌÅÍ¿¡¼ ¼ýÀÚ »Ì¾Æ¼ °è»êÇϱâ(VALUE, S ...
38,320 VIEW
´ëÃâ»óȯÀÏ °è»ê(EDATE)
1,403 VIEW
µ¥ÀÌÅ͸¦ ÀÔ·ÂÇϸé ÀÚµ¿À¸·Î Å׵θ®°¡ Ç¥½ÃµÇ°Ô ÇÏ´Â ¹æ¹ý ...
3,936 VIEW
CHOOSE, RANK ÁßøÇÔ¼ö
3,623 VIEW
¹è¿ »ó¼ö ÀÌÇØÇϱâ
4,490 VIEW
°øÈÞÀÏ Á¦¿Ü ÀÛ¾÷Àϼö °è»ê(NETWORKDAYS) ...
18,265 VIEW
ÆǸž×ÀÇ Æò±Õ±Ý¾× °è»ê(AVERAGEIFS) ...
1,793 VIEW
ÆǸž×ÀÇ ÇÕ°è °è»ê(SUMIFS)
1,416 VIEW
¸ÅÃâ¹üÀ§¿¡ ¸Â´Â »óÇ°°³¼ö °è»ê(COUNTIFS) ...
3,717 VIEW
ÀüȹøÈ£ °¡¿îµ¥ ÀÚ¸® *º°Ç¥½ÃÇϱâ(REPT) ...
4,884 VIEW