ȸ
|
μ | ǻȰɷ | óɻ
| Ȱ | | Ʈ | ũ/VBA | ǹ
OA α׷ | | ڰ | Ÿ
α
йȣ
 ȸ 湮     8,351,583   
  ο     12   
  Ȩ > >     

ȸ ǹ ִ 2013
: ε帲ȹ()
ǻ : ȭ
: 2015 5

   01 åҰ

ǹ ۼϱ ɸ ٽ !

 

ε ϰ ִ α׷ ܿ ֽϴ. ʿ α׷ӿ ұϰ ȿ Ȱϰ ִٰ ڽϴ ڴ ׸ ʽϴ. å ϴ ǥ μ ִ ְ Ȱ뵵 ɰ Լ ٷϴ. å Ǹ ǹ ۼϸ Ȱ ڿ ͵ ֽϴ. ذ ٸ ϴ Դϴ. å ɵ ڿ Ȱ ô.
 

ǻ

1. ǽ
ҰǴ 150 2013 Ͽϴ. ݺ ϱ ʽڵ н ֽϴ.

2. ϸ 2013
ϸ ô. Point ϱ ĥ ִ ߰ Ͽ Ȯϰ ֵ ݴϴ.

3. ȭ н ʿ
Special Tip Level up ġϿϴ. , ȭ Ͽ ȭ н ϴµ ݴϴ.

4. ϴ Լ
۾ ϴ Լ 50 Ͽϴ. Լ Ͽ ۼϸ ȿ Դϴ.

5. ǹ Project
ǹ ̴ پϰ Ͽ Project ҽϴ. ǹڰ Ȱ뵵 ϴ ȿ ۾ ֽϴ.

 


   02

-Part 1- ⺻ 50

01. 2013 ۰
02. 2013 ȭ
03. 2013 ϱ
04.
05. ޴ ϱ
06. ϱ
07. Էϱ
08. ȣ Էϱ
09. () Էϱ
10. ä ڵ ϱ
11. ä
12. ޸ ߰ϱ
13.
14. Ʈ ̸ ٲٱ
15. Ʈ ԰
16. Ʈ ̵
17. ̵
18. ã ٲٱ
19. ҿ ٽ
20. , , ϱ
21. , , ϱ
22. ũ
23. ۲ ϱ
24. ϱ
25. ǥ ϱ
26. ׵θ ϱ
27. ä ϱ
28. ׸ ϱ
29. ũƮ μϱ
30. μ μ ϱ
[Special tip] μ ϴ
31. ϱ
32. ũƮ Ȯ
33. â ϱ
34. â
35. Ʋ ϱ
36. Էϱ
37. ϱ
38. Լ Էϱ
39. ڵ հ ϱ
40. Ʈ
41. Ʈ ٲٱ
42. Ʈ ٲٱ
43. Ʈ ϱ
44. Ʈ ϱ
45. ͸ ǥ ϱ
46. ϱ
47. ϱ
48. κ
49. ø κ
50. ڵ ͷ ˻ϱ

 

-Part 2- Ȯϰ Ƿ , Ȱ 50
01. ȿ ˻ ϱ
02. ϱ
03. Ͽ ٿֱ
04. ׸ ٿֱ
05. Ʈ ϱ
06. ũƮ ȣϱ
07. չ ȣϱ
08. ȣϱ
09. ǥ
[Special tip] ڵ
10. ¥ ǥ
11. Ǻ
12. Ǻ
13. , , Ǻ
14. Ӹ۰ ٴڱ
15. ϱ
16. ̸
17. Ʈ μϱ
18. ̸ ϱ
19. Ʈ ϱ
20. Ʈ
21. Ʈ
22. ũ
23. ׸
24. ä ȿ ϱ
25. WordArt
26. ¶ ׸ ϱ
27. ׷ ϱ
28. ڵ
29. ڵ
30. ͷ ˻ϱ
31. ؽƮ
32. ߺ ׸ ϱ
[Special tip] ߺ Է ϱ
33. 3 ̿
34.
35. ϱ
36. ǹ ̺
37. ǹ ̺ ̾ƿ ٲٱ
38. ǹ ̺ ʵ ϱ
39. ǹ ̺ ׸ ׷ȭ
[Special tip] ǹ ̺ κ
40. ǹ Ʈ
41. ̼ ð ǥ
42. ǥ ã
43. ó
44. ǥ
45. ǥ
46. ũ ϱ
47. ũ ϱ
48. Ȯζ ɼ Ʈ ϱ
49. ޺ ڿ Ʈ ϱ
50. ϱ

 

-Part 3- 𸣸 Լ 50
01. հ ϱ - SUM
02. ϱ - AVERAGE
03. - COUNT / COUNTA / COUNTBLANK
04. 밪 ȣ Ǵ - ABS / SIGN
05. ϱ - MOD / QUOTIENT
06. ݿø//ø - ROUND / ROUNDDOWN / ROUNDUP
07. ִ밪 ּҰ - MAX / MIN
08. k° ū , ϱ - LARGE / SMALL
09. ϱ - RANK / RANK.EQ / RANK.AVG
10. ǿ óϱ - IF
11. IF Լ ġ - ø IF
12. ˻ϱ - AND / OR
13. ϱ - LEFT / RIGHT / MID
14. ڸ ڷ ȯϱ ? VALUE / NUMBERVALUE
15. ؽƮ ȯϱ - TEXT
16. ʿ ϱ - TRIM
17. ؽƮ ٲٱ ? REPLACE / SUBSTITUTE
18. ؽƮ ã ? FIND / SEARCH
19. ¥ ð ϱ - TODAY / NOW / DAYS
20. ¥ ϱ - DATEDIF
21. , , ϱ - YEAR / MONTH / DAY
22. , , ϱ - HOUR / MINUTE / SECOND
23. ¥ - DATE
24. ð - TIME
25. ȣ ˾Ƴ - WEEKDAY
26. ۾ ϼ ϱ - NETWORKDAYS
27. ۾ ϼ / ¥ ϱ - WORKDAY
[Special tip] NETWORKDAYS.INTL, WORKDAY.INTL
28. ǿ ´ - COUNTIF
29. ǿ ´ հ - SUMIF
30. ǿ - COUNTIFS
31. ǿ հ - SUMIFS
32. ǿ ´ ϱ - AVERAGEIF
33. ǿ ϱ - AVERAGEIFS
34. óϱ - IFERROR
35. ǿ ´ հ ϱ - SUMPRODUCT
36. κ ϱ - SUBTOTAL
37. ϱ - AGGREGATE
38. FREQUENCY
39. ȣ ȣ Ȱ - ROW / COLUMN
40. ؿ ϱ - CHOOSE
41. ù ã - VLOOKUP
42. ù ࿡ ã - HLOOKUP
43. ã - LOOKUP
44. ġ ȣ ã - MATCH / INDEX
45. ͺ̽ Լ ϱ - DSUM / DAVERAGE
46. ǿ ´ ڵ ʵ ϱ - DGET
47. ȸ ȯݾ ϱ - PMT
48. ݰ ϱ - PPMT / IPMT
49. ̷ ġ ϱ - FV
50. ڱݾ ġ ϱ - PV

 

-Project- ǹ 20
PROJECT 01. ȼ
PROJECT 02.
PROJECT 03.
PROJECT 04. ѽ ۹
PROJECT 05. ڱ Ұ
PROJECT 06.
PROJECT 07. ٷ ༭
PROJECT 08.
PROJECT 09.
PROJECT 10.
PROJECT 11. ޿
PROJECT 12.
PROJECT 13. ּ
PROJECT 14.
PROJECT 15. ̷¼
PROJECT 16. ݰ꼭
PROJECT 17. ǰǼ
PROJECT 18.
PROJECT 19. Ʈ
PROJECT 20. Ʈ

 

--


   03 + 뺸  
? - ڿ 2016-09-18 50

ڵ
 2007
μ ⹮
ǻȰ ⹮
2013 ޿ ڵ
ܿ ⹮ ˻
ڵȭ
ڵȭ
ǹ
ε帲  ˻
ڵȭۿû
ȣ : ε帲ȹ | ڵϹȣ : 105-20-55088 | ǸžŰȣ : 5343ȣ | ǥ : |
å : ̼ҿ | ּ : Ư ŷ16 47 201ȣ() | ȭ: 02)323-7705 |
Fax: 0504)446-5419 | Աݰ : (543001-01-213514) | E-Mail :
Copyright 2006 ε帲ȹ(www.edodream.com) All Rights Reseved.