½Ç¹«¿¡¼ ÅëÇÏ´Â Excel 2013
ÃÖÀÇ¹Ì °»ç
¼ö°·á 25,000¿ø
(¼ö°ÇýÅà : ¼ö°·á 10% ÇÒÀÎÄíÆù Àû¸³!!)
ÇнÀ±â°£ : 2°³¿ù (¿À´Ã ½Åû ½Ã: 2024.03.19 ~ 2024.05.18)
ÇнÀ±â°£ µ¿¾È ¹«Á¦ÇÑ ¹Ýº¹ ¼ö°
°Á¼Ұ³
-¿¢¼¿ÀÇ ±âº» ±â´ÉÀ» ³Ñ¾î ½Ç¹«¿¡¼ ¸¹ÀÌ »ç¿ëµÇ´Â ´Ù¾çÇÑ ÇÔ¼öµéÀ» Áß½ÉÀ¸·Î ÇнÀÇÏ¿© ¾÷¹«È¿À²À» ³ô¿©º¸¼¼¿ä~
• ¾Ë¾ÆµÎ¸é ÁÁÀº ¿¢¼¿ ±â´É ²ÜTip
• ½Ç¹«¿¡¼ ¸¹¾Æ È°¿ëµÇ´Â ÇÔ¼ö±â´É
• ´Ù¾çÇÑ ¿¹Á¦¸¦ È°¿ëÇÑ ¹®¼ÀÛ¼º ½Ç½À
¼ö°´ë»ó
- ½Ç¹«¿¡¼ ¸¹ÀÌ »ç¿ëµÇ´Â ¿¢¼¿ÀÇ ÇÔ¼ö±â´ÉÀ» ÇнÀÇÏ°íÀÚ ÇÏ´Â ¿¢¼¿ »ç¿ëÀÚ
- ¾÷¹«È¿À²À» ³ôÀÌ°íÀÚ ÇÏ´Â Á÷ÀåÀÎ
Microsoft OFFICE ´Ù¿î·Îµå(½ÃÇèÆÇ) °ü·Ã
- OFFICE 2013 üÇèÆÇ ¹öÀü ÇÁ·Î±×·¥ ´Ù¿î·Îµå´Â ÇöÀç »õ ¹öÀü ¹ß¸Å·Î ÀÎÇØ Microsoft ȨÆäÀÌÁö¿¡¼ Á¦°øµÇÁö ¾Ê°í ÀÖ½À´Ï´Ù.(ÀúÀÛ±Ç ¹®Á¦·Î µû·Î Á¦°øÇص帮Áö ¾Ê½À´Ï´Ù.)
- ÇÁ·Î±×·¥À» ÀÌ¿ëÇÏ°íÀÚ ÇϽøé Microsoft¿¡¼ Á¦°øÇÏ°í ÀÖ´Â ÃֽŹöÀüÀ» ´Ù¿î¹Þ¾Æ »ç¿ëÇÏ½Ã¸é µË´Ï´Ù.(2013°ú´Â ȸ鱸¼º»ó¿¡¼ ¾à°£ÀÇ Â÷ÀÌ°¡ ÀÖÀ»»Ó ÇнÀÇϽôµ¥ ºÒÆíÇÔÀº ¾ø½À´Ï´Ù.)
OFFICE ÃֽŹöÀü ÇÁ·Î±×·¥ ´Ù¿î
- ´Ù¿î·Îµå ¸µÅ© : Microsoft OFFICE ´Ù¿î·Îµå ¼¾ÅÍ ¢Ð Click!
- À§ ÇÁ·Î±×·¥Àº trial¹öÀüÀ¸·Î½á ¼³Ä¡ ÈÄ 30ÀÏ°£ ÀÌ¿ëÇÏ½Ç ¼ö ÀÖÀ¸¸ç °è¼ÓÇؼ ÀÌ¿ëÇÏ½Ç °æ¿ì Á¤Ç°À» º°µµ·Î ±¸¸ÅÇÏ¼Å¾ß ÇÕ´Ï´Ù.
- 2013 ¹öÀü ÇÁ·Î±×·¥ ±¸ÀÔ ¹®ÀÇ´Â Microsoft Korea. 1577-9700À¸·Î ¹®ÀÇÇϽñ⠹ٶø´Ï´Ù.
ÇнÀ¸ñÂ÷
Â÷¼ö |
´Ü¿ø |
ÇнÀ½Ã°£ |
1ȸ |
ÁÖÁ¦ |
¾Ë¾ÆµÎ¸é ÁÁÀº ¿¢¼¿ Tip!!
°ÀÇ ¸Àº¸±â
|
³»¿ë |
- À̸§ »óÀÚ¿Í ´ÜÃàÅ°¸¦ ÀÌ¿ëÇÏ¿© ¼¿ À̵¿Çϱâ
- ¼¿ º´ÇÕÇÑ °Í ó·³ º¸À̱â
- ½±°í ºü¸£°Ô µ¥ÀÌÅÍ ÀÔ·ÂÇϱâ
- ¼û°ÜÁø ¿µ¿ª Á¦¿ÜÇÑ ¿µ¿ª º¹»ç ºÙ¿©³Ö±â |
|
21ºÐ |
2ȸ |
ÁÖÁ¦ |
´ÜÀÏÁ¶°ÇÇÔ¼ö, ´ÙÁßÁ¶°ÇÇÔ¼ö È°¿ëÇϱâ
|
³»¿ë |
- COUNTIF¿Í COUNTIFS
- SUMIF¿Í SUMIFS
- AVERAGEIF¿Í AVERAGEIFS |
|
27ºÐ |
3ȸ |
ÁÖÁ¦ |
ºÐ±âº°¸ÅÃâÇöȲµ¥ÀÌÅÍ·Î ºÐ±âº°ÇöȲ±¸Çϱâ
|
³»¿ë |
- ½ÇÀûÇհ豸Çϱâ
(SUBTOTAL)
- ¸ÅÃâ¼ö·®°ú ÆÇ¸Å±Ý¾× ±¸Çϱâ
(SUBTOTAL, VLOOKUP)
- À̸§Á¤ÀÇ·Î Àüü¿Í ºÎºÐ°Ë»ö ±¸Çϱâ
(OFFSET, COUNTA, SUBTOTAL) |
|
22ºÐ |
4ȸ |
ÁÖÁ¦ |
¸ÅÃâ ´Þ¼º·ü°ú ½ÇÀû·üÀÇ ¼øÀ§¿¡ µû¸¥ ºÎ¼ ã±â
|
³»¿ë |
- ¸ÅÃâ ¼øÀ§¿¡ µû¸¥ ÁöÁ¡ ã±â
(SMALL, LARGE, MATCH, INDEX)
- »ó, ÇϹݱ⠽ÇÀû¼øÀ§¿¡ µû¸¥ Áö¿ª±¸Çϱâ
(LARGE, MATCH, INDEX)
- ºÐ±âº° ½ÇÀûÇ¥
(MAX, MIN, MATCH, INDEX)
- Á÷À§¿Í ºÎ¼ ¼±Åÿ¡ µû¸¥ ÃÖ°í ÃÑ ÆǸŷ®
(SUBTOTAL, MAX, MATCH, INDEX) |
|
18ºÐ |
5ȸ |
ÁÖÁ¦ |
½Ã±ÞÁ¦ »ç¿øÀÇ Ãâ±ÙÇöȲǥ ¸¸µé±â
|
³»¿ë |
- ½Ã±ÞÁ¦ »ç¿ø¸ñ·Ï À̸§Á¤ÀÇÇϱâ
(COUNTA, OFFSET)
- Ãâ±ÙÇöȲǥ ÀÛ¼ºÇϱâ
(DATE, IFERROR, INDEX, WEEKDAY) |
|
26ºÐ |
6ȸ |
ÁÖÁ¦ |
»ç¿øÀÇ ±Þ¿©°è»êÇϱâ
|
³»¿ë |
- »ç¿ø¸ñ·Ï È°¿ëÇÏ¿© ±Þ¿©Á¤»êÇ¥ ÀÛ¼ºÇϱâ
(MATCH, INDEX)
- Ãâ±ÙÇöȲǥ È°¿ëÇÏ¿© ±Þ¿©Á¤»êÇϱâ
(MATCH, INDEX, ROW, ROUND, SUM, MOD, TEXT) |
|
24ºÐ |
7ȸ |
ÁÖÁ¦ |
°Å·¡¸í¼¼Ç¥ ÀÚµ¿ÈÇϱâ À§ÇÑ ÀÛ¾÷
|
³»¿ë |
- µ¥ÀÌÅÍ ÀÔ·Â ¹× À̸§Á¤ÀÇÇϱâ
(À¯È¿¼º°Ë»ç, COUNTA, OFFSET)
- »óÇ°Á¤º¸ µ¥ÀÌÅÍ È°¿ëÇÏ¿© ÀÔ·ÂÇϱâ
(IFERROR, IF, OFFSET, VLOOKUP, SUM, COUNTA) |
|
20ºÐ |
8ȸ |
ÁÖÁ¦ |
°Å·¡¸í¼¼Ç¥¿Í ¼¼±Ý°è»ê¼ ÀÛ¼ºÇϱâ
|
³»¿ë |
- °Å·¡¸í¼¼Ç¥ ÀÛ¼ºÇϱâ
(INDEX, ROW, Á¶°ÇºÎ¼½Ä)
- ¼¼±Ý°è»ê¼ ÀÛ¼ºÇϱâ
(COLUMN, MID, VLOOKUP, COUNTIF, SUM) |
|
26ºÐ |
9ȸ |
ÁÖÁ¦ |
»ç¿ø°ü¸®¸íºÎ·Î Áõ¸í¼ ÀÔ·ÂÇϱâ
|
³»¿ë |
- »ç¿ø°ü¸®¸íºÎ À̸§Á¤ÀÇÇϱâ
(À¯È¿¼º°Ë»ç, COUNTA, OFFSET)
- Áõ¸í¼ ÀÔ·ÂÇϱâ
(COUNTA, MATCH, IF, OR, AND INDEX, DATEDIF) |
|
28ºÐ |
10ȸ |
ÁÖÁ¦ |
¾ç½ÄÄÁÆ®·Ñ¿Í ¸ÅÅ©·Î±â´ÉÀ» È°¿ëÇÏ¿© ¸ÅÃâ³»¿ª µ¥ÀÌÅÍ·Î ¸ÅÃâ°Ë»ö Çϱâ
|
³»¿ë |
- ¾ç½ÄÄÁÆ®·Ñ ÀÔ·ÂÇÏ¿© µ¥ÀÌÅ͸¦ Æí¸®ÇÏ°Ô °ü¸®Çϱâ
- °í±ÞÇÊÅÍ°úÁ¤ ¸ÅÅ©·Î·Î ±â·ÏÇϱâ |
|
23ºÐ |